Search results

Dear delvillardennis Type the formula in D9 =VLOOKUP(B9,$H$3:$J$9,3,TRUE) You may copy the formula and paste in D9 in your sheet Regards Muneer

Dear jigar_mehta You can apply the logic. >Data validation >Select Text length from Allow >Select Greater than from Data >Type 0 in Minimum>OK Regards, Muneer

Pofski Think your data is from A1:B9 Type D2=FEB and E2=CLN Type/Copy the formula in F2 =COUNTIFS(A:A,D2)-COUNTIFS(A:A,D2,B:B,E2) Regards Muneer

Dear ankit bidawatka, Without any visible formula you can represent output in any cell using conditional formatting. I am giving you just an idea. You can customize as you want. Select a cell (D4) >Conditional formatting >New reules >Format all cells based on their values...

Dear Ecel Dumbo In the sheet Sheet1, B1=1, C1=2, D1=3 In B2, type/copy the formula =GETPIVOTDATA("Amount",'Pivot table Look UP Data'!$A$7,"Territory Manager",$A$1,"Period",B$1,"Mapping",$A2) Now copy the cell and paste B2:D4 Regards Muneer

I would request you to provide a simple example

Dear ankit bidawatka, What kind of answer you want? Please specify clearly. Regards Muneer

Dear San_jayd, Think your data is in Col-A and Col-B Go to B2 Home>Conditional Formatting>New Rule >Select-Use a formula to determine which cells to format >Type =B2>A2 in - Formula values where this formula is true >Click on format button >Fill >Select...

Dear vipulhumein Please upload a sample file and quote your required output. Regards Muneer

barnesdacb Welcome to Chandoo's forum. You should provide some sample data and your asking so that forum members can understand easily your requirement. Regards, Muneer

sachinbizboy, I think any value is existed in the last column XFD (Excel-2007). You can check it according to Hui's statement. Press Ctrl+End. If it highlight in any cell of XFD, delete any column. You can insert a column. Regards, Muneer

Dear Mehta, Please upload a sample file and make the readers clear. I think you can try aamirsq's logic. Regards, Muneer

Hui Thanks a lot! Best Regards, Muneer

Dear Smisar, According to your example, think your data A1:D17 Part Qty Qty Rate Per Number From To Unit 111 1 1 10 111 2 2 9.5 111 3 3 9 111 4 4 8.5 111 5 5 8 111 6 10 7.5 111 11 15 7 111 16 Above 6.5 222 1 1 11 222 2 2 10.5 222 3 3 10 222 4 4 9.5 222 5 5 9 222 6 10 8.5 222 11...

Dear vrunda, find the link and customize as you want. I have given just idea. http://www.2shared.com/file/nxX4VOEl/Random_Question_and_Score-MNM.html Regards, Muneer

Dear rahuladlakha You can try to do this using SUMIF() or SUMIFS() function from your raw data Regards, Muneer

Dear Pirduh, Your data structure is not clear. Please upload a sample excel file Regards, Nazmul Muneer

Dear Khushboo, Welcome to Chandoo's forum. You should make a dynamic chart. Use OFFSET() function and control your chart by two variable, i.e Start date and End date. Regards, Muneer

Dear Suresh, In outlook 2010, you can preview the excel file if you click (single click) on excel attachment. You can also highlight the cell just like excel file. Regards, Nazmul Muneer

Dear a_avins, Try this........ =TRIM(CLEAN(A1)) Regards, Nazmul Muneer

@oldchippy: SirJB7 wants to make you older @bobhc: Do you know the intention of SirJB7? Regards, Muneer

Dear Indzara Well Done!!! Thak you. I have got a new idea Regards! Nazmul Muneer

Dear Daleepsingh Type A1=18/05/1998 B1=15/02/2013 C1=DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months " & DATEDIF(A1,B1,"MD")&" Days" Regards, Nazmul Muneer

drewszone32 Please see the details below for learning IF condition. I think it will help you. The Excel IF function checks to see if a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else...

Dear Amir, Debraj Roy has provided the correct solution. Try the formula INDEX(dps!$C$8:$C$567,MATCH(A2,$AHR$8:$AHR$567,0)) Regards, Muneer