• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by niting

  1. N

    SORT

    Dear forum, Thanks a lot for the help. Nitin
  2. N

    SORT

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

    SORT

    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...
  4. N

    Data lookup and aggregation

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

    Data lookup and aggregation

    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...
  6. N

    Data lookup and aggregation

    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
  7. N

    Data lookup and aggregation

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

    Data lookup and aggregation

    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...
  9. N

    Data lookup and aggregation

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

    Sum previous non blank cell in a column

    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
  11. N

    Data lookup and aggregation

    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...
  12. N

    Min of number above zero using name a range

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

    Ctrl+f not yielding result

    Thanks guys for the help!
See more
Back
Top