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
Hi there! Currently, I use the percentage functionin excel, I need to change numbers to show percentage with a 0 - 100% range and it will turn 22,000 to 22,000%. I am also trying to compare information regarding one province to the rest of the provinces all in Column A with the years listed in Column C - H and wondering what is the best formula to use. I hope my question makes sense.
Solved by D. H. in 18 mins
I have a column of ascending numbers. When I add a new number to this column I want excel to compare the new number to the old column and say if that number already exists.
Solved by V. U. in 22 mins
trying to compare if amounts in one column E are greater than amounts in column G, using this formula =E1>G1 with conditional formatting, and not working.
Solved by G. S. in 30 mins
is there any way to compare key values from different collections?
Solved by K. H. in 18 mins
I need to compare the stock that I am holding. I have the master sheet extracted from the software and another excel containing the physically scanned stock. I want to know the difference between these two excels
Solved by V. F. in 14 mins
Goal, is to mark Y for duplicate records in last column.
In column J, if there is a 2 or 3 (Then there are 2 or 3 duplicates). Compare these with the following:
Always keep the latest "Date Acquired" date.
Also keep the latest "Date Assigned" and "Date Acquired".
If there is no "Date Acquired", then keep the latest "Date Assigned".
Solved by M. S. in 30 mins
Help with duplicates. Goal, is to mark Y for duplicate records in last column.
In column J, if there is a 2 or 3 (Then there are 2 or 3 duplicates). Compare these with the following:
Always keep the latest "Date Acquired" date.
Also keep the latest "Date Assigned" and "Date Acquired".
If there is no "Date Acquired", then keep the latest "Date Assigned".
Solved by S. H. in 29 mins
I work with a french version, I need a formula to compare the date of today VS the date of a previous date. I need the output to be in DAYS.
Solved by D. D. in 17 mins
I have a few columns of text in columns "A" and "B" I want to compare those columns to columns "L" and "M" in order to determine if these recurring names come up. I am trying to determine if a donor has donate from year to year and can't figure this out.
Solved by O. L. in 20 mins
From a set price list, I would like to calculate my budget value. Once I know my actual quantities, the actual spend needs to be calculated. In my budget row, I need to sum budget (Column D) compare to the actual (Column E) and create the variance (Column F). The data is summarized on teh histogram (x:type of material, y: Budget and actual
Solved by A. C. in 13 mins