# Need Flagging Formula to Return "First" or "F

#### otrevino3

##### New Member
Hello. You guys all rock!

My data column has a series of numbers - sorted in ascending order.

I want to create a formula column that:

Returns a "First" for the first appearance of a number;
Any subsequent appearance of the same number will return a "First+"

this should be easy, right?

tia

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Oaktree

##### MrExcel MVP
Welcome to the board!

B1 = "First"
B2 = IF(COUNTIF(\$A\$1:A2,A2)>1,"First+","First")

Copy B2 down.

#### otrevino3

##### New Member
Re: Need Flagging Formula to Return "First" or &qu

Thanks Superman, that worked!

Have a beer.

#### IML

##### MrExcel MVP
Re: Need Flagging Formula to Return "First" or &qu

For simplicity, you may just want to start with the proposed construction in Cell b1, to wit
="First"&IF(COUNTIF(\$A\$1:A1,A1)>1,"+","")

and copy down. This may help avoid sloppy copy and pasting problems down the road

Replies
13
Views
355
Replies
3
Views
266
Replies
12
Views
194
Replies
5
Views
163
Replies
17
Views
512

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,488
Messages
5,770,380
Members
425,613
Latest member
martinijr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back