Excel spreadsheet comparisons
Closed
stb_0532
venkat1926
- Posts
- 2
- Registration date
- Friday July 20, 2012
- Status
- Member
- Last seen
- July 23, 2012
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel spreadsheet comparisons
- How to screenshot excel spreadsheet - Guide
- Send email when excel spreadsheet is updated ✓ - Forum - Excel
- Change author on excel spreadsheet - Guide
- Golf skins excel spreadsheet ✓ - Forum - Excel
- Update dates in Excel spreadsheet: each year, formula - Guide
3 replies
venkat1926
Jul 20, 2012 at 10:35 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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
Jul 23, 2012 at 08:33 AM
- 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?
venkat1926
Jul 23, 2012 at 10:40 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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