Seeking a formula to return

[eolivier]

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​

 

[Fluff]

How about

+Fluff.xlsm
	A	B	C
1	Position ID	Board Name	Is Current Row?
2	69962	Kelly Services_MI
3	69962	Manpower
4	69962	RobertHalf
5	69962	Accretive Solutions - Scott Mayotte, Specialty Finance
6	69962	*Cybertech_Jon Melnick	1
Main

Cell Formulas
Range	Formula
C2:C6	C2	=IF(COUNTIF($B$2:$B$6,"<"&$B2)=0,1,"")

 

[eolivier]

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]

You're welcome & thanks for the feedback