Thanks Paul
Dave.
Date: Wed, 15 Sep 2010 05:02:08 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Need most recent date
To: excel-macros@googlegroups.com
alternately, you could sort your data by invoice#,date (descending)
then do a vlookup.
It would pick the first date
Bonallack
>To: "excel-macros@googlegroups.com"
>Sent: Wed, September 15, 2010 12:39:40 AM
>Subject: RE: $$Excel-Macros$$ Need most recent date
>
>Hi,
>I am assuming that your first unique invoice numberis in A2.
>Format B2 of the same sheet as Date, then ente
ith a sample workbook.
Regards - Dave.
Date: Tue, 14 Sep 2010 17:33:44 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Need most recent date
To: excel-macros@googlegroups.com
I have a list of dates in one sheet.
Col A = Invoice Number
Col B = Payment Date
There will be multiple
I have a list of dates in one sheet.
Col A = Invoice Number
Col B = Payment Date
There will be multiple rows for the same invoice number as payments are made
against it until it is paid in full.
Some of these rows will contain dates and some won't.
The next sheet has the unique list of invoice n
