Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel help

0 views
Skip to first unread message

Paul

unread,
May 15, 2002, 9:57:56 AM5/15/02
to
Hi,

Only ever having used Excel at the most basic level i have a
requirement where i need to increment a value base on the number of
times a particular cell value occurs to end up with a sequence number.

i.e. if i have a range of cells

sprocket
sprocket
widget
widget
widget
thingy

I need to generate a sequence number as follows

sprocket 001
sprocket 002
widget 001
widget 002
widget 003
thingy 001

any clues would be much appreciated

cheers

Paul

Peo Sjoblom

unread,
May 15, 2002, 10:27:17 AM5/15/02
to
Paul,

assume your example starts in A1,
in b1 put this and copy down, format cells accordingly to get leading zeros..

=COUNTIF($A$1:A1,A1)


--

Regards,


Peo Sjoblom


"Paul" <paul...@nsb.co.uk> wrote in message news:df7ae5ab.02051...@posting.google.com...

Vasant Nanavati

unread,
May 15, 2002, 10:26:32 AM5/15/02
to
Hi Paul:

If your sequence starts in cell A2, enter the following formula in cell
B2:

=TEXT(IF(A3=A2,B2+1,1),"000")

and copy down. This will not work if you start in row 1.
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**

"Paul" <paul...@nsb.co.uk> wrote in message
news:df7ae5ab.02051...@posting.google.com...

Jason Morin

unread,
May 15, 2002, 10:30:30 AM5/15/02
to
If your range starts in A1, then type a 1 in B1, and then
in B2, insert this formula and copy it down:

=IF(A2<>A1,1,B1+1)

Then select B column, right click, Format Cells..., click
on Number tab, select Custom, and key in 000 on your
right. Hit OK.

HTH
Jason
Atlanta, GA

>.
>

0 new messages