Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Excel spreadsheet comparisons [Closed]

Report
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
 -
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
Hello,
I have a large spreadsheet that I need to compare weekly. I have 5 sets of 4 columns within the same worksheet that need to compare to a single column. Example: Column M is my base I need to match - column X is what I comparing to...if M is less than or equal to X, I need the excel sheet to populate the value in column U and V and W in a single cell...if it doesn't match, then this is a manual item I need to review. Is there a formula or macro I could set up for this process to become more automated? {Using Excel 2010}


3 replies

Answer 1 / 3
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 797
If i understood correctly try this

in any empty cell in row no.2 type this formula

=if(M2<=X2,"U2"&" "&V2&" "&W2,"do manual item")

you can even copy this cell down if necessary
Answer 2 / 3
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
This worked pretty well...any way of combining the value of U2 and V2-W2 where V and W are dates?
Answer 3 / 3
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 797
depends upon how you want the date is to be given in the result
for e.g the date
7/24/12 and is u10

then
=TEXT(U10,"dd-mmm-yy") will give you result
24-Jul-12


use this in the formula
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!