01-06-2008, 06:28 AM
|
 |
Forum Guru
|
|
Join Date: 25 Apr 2006
Location: London, England
MS Office Version:xl03 & xl 07(Jan 09)
Posts: 12,315
|
|
Say your Name in Col A and AM or PM in Col C try something like
Quote:
|
=SUMPRODUCT(--($A$2:A2=A2)*($C$2:C2=C2))
|
VBA Noob
|