Search results

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

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

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

THank you very much Nebu

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

thank you Hui

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

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

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)

THank you very much Chihiro

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

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

Thank you HUI

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

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

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

Thank you Ramesh, it worked well

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.

Thank you very much Chandoo

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.

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

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

Thank you very much NEBU. Did the trick

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

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