Search results

Hello friends, please refer the file attached. the file is untidy. i need to look up values based on multiple conditions and insert simple calculations within look up formula. Thanks heaps http://speedy.sh/v9H6y/Complicated-look-up-with-formula.xls

thanks small man

Hello Please refer the below spreadsheet http://speedy.sh/Zktvc/Text-to-column-Query.xls The data in the sheet is un organised and i tried to use text to column and it seems it is not working. I have also shown in another tab, how the correct form will appear as. Any one in here could...

HI Hui, Many Thanks . It worked. Yes are correct, I made a mistake in the rank. Thanks heaps

Hello Dear Friends, Please refer attached spreadsheet. This is using count if and rank formula to rank values. If a values repeats, the repeated values should share the rank. Please see attached sheet for better understanding. I use Excel 2003. Thanks in advance...

THanks Narayanan for your help. Thanks to bobc and Hui too.

Hi Bobhc, Like I said I would need to see in a pivot table all the customers who have ordered Products "AB" and "CD" together. THis is a sample table of a massive file and I am not sure how your method will work

Thanks HUi for your time. May be I was not clear in my question I need to pick up only those customers who have ordered products "AB" and CD" together. In this example- Karimbinal Corporate and Kuttan ordered only "CD" and it got selected. I need to ignore this because this cutomer did not...

Hello, Please refer the attached spreadsheet. The title of this post may be confusing. If you could go through the spreadsheet, i guess you will understand better. I would like to show in a pivot table customers who have ordered two different products together only Any help will be...

THanks SirJB . THanks Narayan for your advise.

THanks Narayan and Dave Turton for your valubale time Narayan , I applied your formula but I am getting #NAME error Dave Turton, I am getting correct percentage discount for exact match of units ordered. The concept is if we order 12 or more units of certain product, we get 30% discount...

Hello, Please refer attached work sheet and suggest a formula to look up discount %s matching multiple values. Thanks http://speedy.sh/UbEGV/Rebates-Query.xls

Thanks Nazmul and Indian for your valuable time

Thanks Indian. It works for one cell. When I drag the formula , the correct values are not showing up. Please advise.

Hello, Could you please suggest a formula to look up values from a pivot table without altering the structure of the pivot table ? PLease refer below attachment If u suggest SUMPRODUCT, I would like to mention the pivot table keeps growing month by month, and as it gets bigger, it takes lot...

Hello friends, I have a file with several sheets and these sheets are linked to one another. Within these sheets, there are addition-% calculation and subtraction formulas which do not have any sheet references. I would like to kill the sheet linkages in each sheet but keep the addition-%...

Hi Indian, Thanks for your valuable time I did not get it right For the first formula I was getting a name# error. For the second , it worked, but I would like to keep the rank till 7. Suppose there are 8 items to rank, the 8th smallest item will not get any rank, there will only be ranks...

Hello, Sorry please ignore the first file. Do refer the attached file http://speedy.sh/94ax7/Formula-to-look-up-Ranks-new.xls Sorry for the inconvenience caused

Hello Friends, Please refer the attached worksheet and advise how to rank items (rank 1 to 7 only) in ascending/descending order. http://speedy.sh/Jsr7C/Formula-to-look-up-Ranks.xls Thanks Dumbo

Thannks a lot Fasseh and Koi. Both ways serves the purpose. thanks heaps

Hello, Please see the attachment and please advise on how to build a pivot table from the shown source data without making any changes to the structure of the source data. http://speedy.sh/Dr9JQ/Complicated-Pivot-Table.xls Thanks Dumbo

Thanks a lot Faseeh