CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulascounting
dafie
dafie

Reputation: 1169

Apply formula for rows with first occurence of text

I want to achieve something like the image below:

enter image description here

How can I do it?

Upvotes: 1

Views: 104

Answers (2)

shrivallabha.redij
shrivallabha.redij

Reputation: 5902

Looks like this normal Excel formula works just fine.

Assuming your data starts from cell A1, insert following formula

=IF(COUNTIF($A$1:A1,A1)=1,"First Occurrence","")

Then copy down as much as you need.

Upvotes: 1

player0
player0

Reputation: 1

use this formula:

=ARRAYFORMULA(IF(COUNTIFS(A:A, A:A, ROW(A:A), "<="&ROW(A:A))=1, 
 "first occurance", ))

0

Upvotes: 3

Related Questions