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

Search results

  1. M

    Pivot table & Vlookup

    i have billing number in pivot table.i have another sheet which has billnumber and amount i want to lookup the amount to another column beside the pivot. any suggestions
  2. M

    Pivot table & Vlookup

    Can I use Vlookup formula to get date from pivot table
  3. M

    Eaches from Pack describtion

    KIT KAT 4 Finger 18(18x37.3g) N3 IN I want a formula to get 18 which is in red
  4. M

    Eaches from Pack describtion

    eaches end with x
  5. M

    Eaches from Pack describtion

    I want a formula to get eaches from pack description for example 18 for kitkat,for polo 27. Can you help me PACK Eaches KIT KAT 4 Finger 18(18x37.3g) N3 IN 18 NESTLE CEREGROW BIB 24x300g IN 24 CERELAC STAGE 1 Rice BIB 24x300g N3 IN 24 CERELAC STA1 WheApp Poshan BIB24x300g IN 24...
  6. M

    Filling up data

    i want to get data by entering shipment number get the start date and end date customer name location and timings which are all in nov sheet.hyd dc time is in dc column customer timings are there in cd colums. gr number is from gr column. distance from km shheet based on towns
  7. M

    Filling up data

    I need to fill the data with shipment as criteria date and time i am attaching the sample file Can u help me
  8. M

    One sheet into multiple sheets based on criteria

    I want to copy the data into different sheets based on the name as criteria I have pasted the data of one customer i want the data to paste the data of all customers for one customer one sheet
  9. M

    Annexure from Excel dump

    I have to get the details from dump sheet to annex sheet depending on the po number Please help
  10. M

    Checking for the quqntity

    Can you please send the excel file
  11. M

    Checking for the quqntity

    I select the item code from e column in stock intake i dont have issue in f column stock in take but enter in stock out in g column i have to check whether is quantity avaible in H col in investory sheet Can u please give any solution for this Regards Mohandas
  12. M

    Inventory solution

    This file is for tracking the inventory for the manufactuing products I have 3 sheets 1 RM (Raw Material) 2 PM (Packaging Material) 3 FM (Finished Material) I have to select in the FM the raw material which is multiple may be more than 1 and pacaking material which also can be the multiple...
  13. M

    Data validation

    Dear Sir, I want to do validation I have 3 sheets 1 RM 2 PM 3 FM I want to do data validation on F column in FM SHeet where i have enter the quantity which has to check in PM sheets whether it has quantity or not ,If not it has to give the message Please help
  14. M

    Getting the data from different sheets into on sheet

    I Have many sheets which has the brand name and averages. I want data from all sheets into one sheet and sheet name as columns heading can any one help me Regards Mohandas
  15. M

    Getting data with sheet name and columns heading

    I have in this sample file 3 sheets called town1, town2,town3 Which has category of oulets namely supermarkets and so on I have another sheet called summary in which this town data needs to be updated Please help me getting the data from that sheets as sheet name and outlet category as...
  16. M

    Sumif prob with blank cells

    Can u help me in formula in excel file.Please help
  17. M

    Sumif prob with blank cells

    Correct result for blanks should be zero
  18. M

    Sumif prob with blank cells

    Now the file has only blanks but still it shows some number 92.10 for GC Column which is fairly blanks
  19. M

    Sumif prob with blank cells

    I have 2 sheets one is pack and another is brand. I was trying to sum the brand basis brand names in b column and quantity in ge columns from pack sheet to brand sheet. There was issue in blanks cells which is giving wrong numbers. Please help me in this issue Regards Mohan
  20. M

    Need help on this format

    Please help
  21. M

    Need help on this format

    I need to select the block from list in sheet 2 B1 cell then data should be populated based on the selection
  22. M

    Need help on this format

    Need for all blocks i want to data validation list box for it
Back
Top