Get instant live Excel expert help with MATCH Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to aggregate my data by year and quarter and opportunity so I can compare Q1,Q2,Q3,Q4 per year by sales person.
So I can see each one of there information and by opportunity.
Solved by G. A. in 17 mins
Challenging problem (details upon request): in a pivot table, compare the first two values according to different criteria (equal, less than, or larger than, or equals to zero)
Solved by K. D. in 29 mins
Can you compare call rates and recalulate these based on time then compare the the values to calculate a credit?
Solved by V. S. in 27 mins
I need to do a t-test like this:
I want to compare data in column B to C, B to D
Then data from G to H, G to I
Then data from L to M, L to N
Then data from Q to R, Q to S
And so on.
I don't want to type out the ttest formula everytime and if I use the fill formula drag tool to drag the formula across that is not selecting the columns I want to compare.
Help would be great.
Thanks
Solved by G. B. in 21 mins
hi im looking to visualise my data set using formulas . i use this data for currency trading i want to add up the profits for each month. i would then like to be able to put them all on to 1 spreadsheet so that i can compare them. i have about 30 sheets that i need to open so the same formulas needs to be on each open tab. the data is for about 4 years but i also need to extend this from the year 2000 to the present day
Solved by Z. A. in 17 mins
I want to create a chart, where by i compare the sales for 206 v 2017 and also calculate percentage change in excel. So similar to a picture i have inserted in the excel sheet, sheet 2.
Solved by E. E. in 22 mins
I need help on how to use pivot table in excel to fill in a sheet and also create a graph to compare the company's performance in 2016 vs 2017
Solved by A. S. in 17 mins
I need a formula to compare a number from one cell with a list of numbers, and if they are equal, enter the text adjacent to the matching entry in the list.
Solved by O. B. in 24 mins
I have 2 time fields in my excel sheet with format 37:30:57 ([h]:mm:ss). In third column I am trying to compare the two fields using IF condition, but the result is incorrect. Can you please help me out in this.
Solved by I. S. in 19 mins
I need formula that look column d and compare with Colum e how many day has pass before complete. Colum d will be fill with text complete or a number of priority
Solved by M. J. in 21 mins