Excel spreadsheet comparisons

[Closed]
Report
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
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?
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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