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

    Index match issues when referencing to dates

    Thank you Grah THanks heaps Peter for explaining the root cause of my formula problem
  2. E

    Index match issues when referencing to dates

    Hi, I tried your formula. But still giving me incorrect answer. I checked the formatting on date cells, they look ok. See file attached
  3. E

    Index match issues when referencing to dates

    Hi Please see attached file I am having trouble getting index match formula correct when i'm trying to reference dates and also when looking up values not found in source table please advise correct formula and what ent wrong in my approach
  4. E

    Help with lookup

    THank you very much Nebu
  5. E

    Help with lookup

    Hi, I have attached file. I'm trying to look up values from "Sourcr tab" referencing to columns A and B ad the result to be produced in "result tab" What makes it complicated is there are lot of duplication in column A Kindly assist with formula
  6. E

    return sum of values from a cluster of columns

    Hi Friends, I need help with formula to sum up values from a specified range of columns in “Data” sheet and then drag the formula side ways and down Please see attached
  7. E

    Custom formatting numbers

    Thank you Narayan. Very clear explanation Thank you Alan for your solution
  8. E

    Custom formatting numbers

    Hi, Could you please provide custom formatting for 910,664 to appear as 911 -541,190 to appear as (541) 1,230,456 to appear as 1,230 -2,534,610 to appear as (2,534)
  9. E

    Sorting dates in Pivot table

    THank you very much Chihiro
  10. E

    Sorting dates in Pivot table

    Dear friends, Please find attached sheet I would need to create two pivot table with the below column headings Pivot table 1 Column heading- Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Pivot table 2 Column heading 2015 2015 TOTAL 2016 Jul-15...
  11. E

    formula to calculate value based on threshold

    Friends, Please see attached file and if you could please suggest a single formula that will provide the value and two separate formula that will shows the thresholds separately thank you
  12. E

    Help with charting

    Dear Friends, I am basic learner in charting. I have a file which involves multiple (more than 2) variables I would like to compare using charts Could you kindly suggest the best possible way to do this ? Thanks Jos
  13. E

    Lookup unique cell with date and time combined

    Thank you Bosco-YIP.....working well now
  14. E

    Lookup unique cell with date and time combined

    HI Ramesh, Sorry after going through the file in detail, There seems to be some issue with the formula. COuld you please check, as I marked the error in red and given desired answers next to it. Could you please check
  15. E

    Lookup unique cell with date and time combined

    Thank you Ramesh, it worked well
  16. E

    Lookup unique cell with date and time combined

    Hi Friends, I have attached a spread sheet. I would need to lookup a cell with unique value of date and time combined and then labelling them accordingly. Any help will be appreciated.
  17. E

    Friends Expense Split Model

    Thank you very much Chandoo
  18. E

    Friends Expense Split Model

    Hi, Using the public forums in here , I managed to partly build up a file that helps to split costs among friends. But I will need further help completing this. Please refer attached.
  19. E

    Look UP formula

    Thanks Hui and Khalid. Both formula worked. By helper columns I meant, we modify existing data to separate what we are exactly looking for , example in T1-L1-0115, we are looking for 0115, so we create another column which shows 0115 and then do a vlookup sort of search. But both formulas worked...
  20. E

    Look UP formula

    Hi Dear Friends I have the below items on which i need to do a lookup to get corresponsing values from the lookup data 0115 Storage 011544 Retail 0B1310 Fruits Look UP data is T1-B-0L1050 43.90 T1-L1-0115 24.20 T1-L1-011544 362.40 T1-L1-0B122944 2.00 T1-L1-0B1310 647.60 T1-L2-021058 26.80...
  21. E

    Index Match and Summing Query

    Thank you very much NEBU. Did the trick
  22. E

    Index Match and Summing Query

    Thanks Nebu. Can you also please suggest me a formula for columns AL and AM in "Result" tab. This is a column totaling up months based on conditions
  23. E

    Index Match and Summing Query

    Thanks Nebu. Pivot table would do the trick and would serve the purpose. I was looking in to more of a formula. Should do the job for now. Thanks heaps. Can you also please suggest a summing formula based on what i have mentioned in the "sheet 1" tab
Top