TEXT(IF(ISTEXT(B41)=FALSE,B41,IF(ISTEXT(C41)=FALSE,C41,IF(ISTEXT(D41)=FALSE,DC41,IF(ISTEXT(E41)=FALSE,E41,IF(ISTEXT(F41)=FALSE,F41,IF(ISTEXT(G41)=FALSE,G41,)),DD-MMM-)
try this see whether it works for you o
On Fri, Dec 18, 2009 at 10:51 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of shyam
Sent: Thursday, December 17, 2009 7:02 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1 Date at sheet2 Date at
Not sure of your meaning..
concatenate means to join two strings end-to-end.
so, your first line becomes:
0-Jan-000-Jan-000-Jan-0029-Nov-080-Jan-000-Jan-00
THAT is the meaning of concatenation.
At first glance, it looks like you're trying to find the maximum
(or latest) date.
However, in your