Previous Topic Next Topic

Excel spreadsheet comparisons

Closed
stb_0532
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
 - Jul 20, 2012 at 03:42 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 - Jul 23, 2012 at 10:40 PM
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
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Jul 20, 2012 at 10:35 PM
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
0
Answer 2 / 3
stb_0532
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
Jul 23, 2012 at 08:33 AM
This worked pretty well...any way of combining the value of U2 and V2-W2 where V and W are dates?
0
Answer 3 / 3
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Jul 23, 2012 at 10:40 PM
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
0