Darrell,

You can probably use a Pivot Table. Have it summarize the data in
column A and the column in which the date is entered. Then you can
format it so that it hides the blanks and subtotals so all you see is
tank # (1-1-2-f. etc..) the date opened and the grand total. Use the
Pivot Table wizard and it takes about just a few seconds.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=482308