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 1863 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}


Related:

3 responses

Answer 1 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
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?
Answer 3 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses