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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 23, 2012 at 10:40 PM
Related:
- Excel spreadsheet comparisons
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 20, 2012 at 10:35 PM
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
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
stb_0532
Posts
2
Registration date
Friday July 20, 2012
Status
Member
Last seen
July 23, 2012
Jul 23, 2012 at 08:33 AM
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?
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 23, 2012 at 10:40 PM
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
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
