How is the data laid out in your workbook?, are dates in their seperate
cells?
Pleasehelp via OfficeKB.com;324122 Wrote:
I have a spreadsheet with 24 months across the columns. The rows
contain
customer names. The cells contain data beginning with the date that
amounts
were transferred into the department. Is there a function that will
allow me
to look across the columns and return the first date that is populated?
I
tried to use a conditional if statement, but the number of periods are
greater than the number of conditions allowed?
--
Message posted via 'MS Office forums. More than 400,000 of Word, Excel,
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)
--
The Code Cage Team
Regards,
The Code Cage Team
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile:
http://www.thecodecage.com/forumz/member.php?userid=2
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=90571