# Seeking a formula to return

#### eolivier

##### New Member
Hello,

See table below. This is a condensed version of my actual table which has tons of columns, but all other columns have exactly the same values in each row so i have hidden them.

I need a formula that can be copied down in the "Is current row" column to return 1 for only one of these rows, but it does not matter which one. Any ideas? Maybe some sort of logic that says "Return 1 if Board Name is first in A-Z sort order"?

 Position ID Board Name Is Current Row? 69962 Kelly Services_MI 1​ 69962 Manpower 1​ 69962 RobertHalf 1​ 69962 Accretive Solutions - Scott Mayotte, Specialty Finance 1​ 69962 *Cybertech_Jon Melnick 1​

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Fluff

##### MrExcel MVP, Moderator

+Fluff.xlsm
ABC
1Position IDBoard NameIs Current Row?
269962Kelly Services_MI
369962Manpower
469962RobertHalf
569962Accretive Solutions - Scott Mayotte, Specialty Finance
669962*Cybertech_Jon Melnick1
Main
Cell Formulas
RangeFormula
C2:C6C2=IF(COUNTIF(\$B\$2:\$B\$6,"<"&\$B2)=0,1,"")

#### eolivier

##### New Member
Yes sir! I found that formula on Google as well. Still need to work it into the full logic behind that column but i will figure it out! Thank you

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

Replies
3
Views
298
Replies
2
Views
56
Replies
6
Views
306
Replies
3
Views
118
Replies
3
Views
112

1,132,672
Messages
5,654,669
Members
418,147
Latest member
dorkas

### 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