See
http://www.cpearson.com/Excel/EveryNth.aspx for a variety of
formulas related to this very topic.
Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
On Fri, 29 Jan 2010 09:12:01 -0800, Ken
wrote:
Excel2003 ...
Range N3:N5002 ... contains 4 char Text (0200, 0340, 1050, etc) each value
repeats 50 times.
In Col D ... I wish a formula to return 1st occs only of each Value found in
Col N
== I can get results using "Advanced Filter Unique Records", but I need to
do this by formula (if I can?)
Thanks ... Kha