Excel Incrementation

  • Thread starter Thread starter shethuraman
  • Start date Start date
S

shethuraman

all Hi I am working on excel to get an ouput like this


Cloumn A Column B

Green 1
Green 2
Blue 1
Blue 2
Green 3
Red 1

Like this whenever i enter a new name in column A it has to tell the
whether the nameis appearing for the first time / 2nd / 3rd etc.,

can u pl solve this problem
 
Hi

Into B1 enter the formula
=COUNTIF(A$1:A1,A1)
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 Problem 1
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Need Help of How to do a Filter 1
COUNTIFS with OR 5
Lookup for Most Recent Value of a category 9
Row highlight based on the 1-31 day of the month 8
Writing Rows To A Spreadsheet 4
count different instances in two columns 10

Back
Top