Search results

Dear forum, Thanks a lot for the help. Nitin

Amritansh, Here is the link of the sample data sheet https://www.dropbox.com/s/cwq7gu5av1y04wz/Sales%20Data.xls Thanks Nitin

Hie forum, I have a list of customer wise product wise sales. The customer is in col A and product is in Col B. for customer A, there can be 4-5 different products and the subtotal of sales made is shown. Now the problem I have is that I want to sort the customer wise grand total sales with...

Absolutely, Thanks Narayan!!! That is what I want the final list to be.

Narayan, The file posted is Bill of Material drill down file and it is the working file not sample file. There is no chance that the inputs will change. However, going forward new Finished goods could be added or new constituent inputs can be added like packing material or chemicals. This...

Faseeh and Narayan, Thanks for your inputs. Faseeh, I am afraid the solution proposed by you does nto answer my queries. The query is aptly captured by Narayan. Hope the Excel Ninzas would be able to help me out. Thanks Nitin Gupta

Hie forum, Any help on the query I have??? Thanks Nitin

Faseeh, Since the sheet is now available, I will talk in reference to the sheet contents. In Tab " Mapping" there are two set of data. One is BOM for FG in range A1: AV100, The BOM is for material codes in Col A and the constituent materials are in Row 3. In Tab " Mapping" only, in range...

Hi Faseeh, Please see the sample work book in the link-: https://www.dropbox.com/s/j5szm0wwwmmx78s/Multilevel%20Bom-QUERY.xls Thanks

J, You can select the range starting at the first blank cell(say D2) and ending at the last cell with number( say D10) Then use CTRL+G, special, blanks, = D3+1, CTRL+enter. This should take care if the numbers and blanks are alternating. Thanks

Hie forum, I tried to upload the sample worksheet, but just could not. Therefore, posting my question in text form. I have a sheet which has the Bill of Material details for around 50 FG. The FG code is in column A whereas relevant components like SFG, Chemicals, Fuel, Packing material, Raw...

Hui, What about formula forensic on the solution posted by Haseeb and Sajan??? Thanks Nitin

Thanks guys for the help!

I applied subtotal for some items in a large range of cells!! When I used the large formula for picking up "n" largest items, I got the correct answer. However, when I tried to use index match for retrieving the corrosponding value, the formula din't work! I tried to manually search for the...

Hui, Lil problem in the above formula. The columns D, E, G,H contains some other data, i.e. the relevant column appears every 3rd column from Column C. Also, to determine the proportionate amount, say for full years is Rs. 15,000. Then till July, the amount payable is Rs. (15,000/12*4). So i...

hie forum, I have a value in column C against employee code in Column B. The column C contains the eligibility amount( for the whole year) for the employee code. The employee is entitled to draw some amount against this eligibility every month and I add columns every month , say Col F for...

Luke, SUMPRODUCT((MAY!$B$5:$BJ$5=E$5)*(MAY!$A$6:$A$79=$A6)*(MAY!$B$6:$BJ$79)) gives error , whereas SUMPRODUCT((MAY!$B$5:$BJ$5=E$5)*(MAY!$A$6:$A$79=$A6),(MAY!$B$6:$BJ$79))does not. it gives the correct value. As I mentioned in the last post, when I am using the "," operator for last...

Luke, that is exactly where I am getting stuck. I had used * operator for multiplication of array 1Rx61C with 74Rx1C giving me 74x61 array. However, when I use * operator for last array which is 74x61 size, then also XL throws #Value error i.e if i use...

Hi forum, I was just about to upload a worksheet where I was facing problem when I came across this post http://chandoo.org/wp/2010/11/09/2way-lookup-formulas/ which gave me solution to my problem. My question for better understanding of the problem is-...

Asa, Thanks a ton!!!! My apologies for replying I'll late, bt it is quite neat nd effective solution Jst 1 issue: when I copy d formula down d sheet, it shows d value against d dependants which ideally it should not considering dat all information is captured in d rows corresponding to...

Asa, Thanks a lot for the prompt reply. I am looking at your suggestions and would try to follow them step by step , so that I could automate the process without resorting to manually doing the process. As for your questions-: 1. the premium is listed against the employee and his/her...

Hi forum, Have a sheet with employee number mentioned in col a, col b mentions the serial number of dependants of employee number mentioned in COl A( if employee no. 1 has 4 dependants, den cell A2 to A5 would be blanks and cell B2 to B5 contains the serial number of dependants). Col C...

Luke, Hie!! Column A contains the Serial No. of employees, column B contains the count of number of dependants, column C is the employee number, column D is the relationship of employee with the dependants( for relationship with himself, self is mentioned) and column E is the age. Now, say...

Hie forum, Stuck up in a problem!!! Have a list like dis-: Col A Col B Col C Col D Col E SrNo. Dependants Emp No Relation Age 1 71 Self 54 1 Wife 48 2 Son 24 2...

On the same topic above, I thought I might identify the 11th serial number and then set print range at that point. so i tried CF in the serial number column with the rule as follows-: =MOD(A4,11)=0 HOwever, it also highlights the rows which are empty. So stuck royally. ANy help??? Thanks