Finding A Value Repetedly and Marking the Cell Next To it with a Progressive number.

[justforthis1]

My question isn't as complicated as the title makes it sound basically...

A
1
2
3
4
5
6
7
8
9
FindValue
1
2
3
4
5
6
7
8
9
FindValue


The find value will always be the same...its just a placeholder that is randomly inserted. (currently i am using the value "Placeholder").

basically in column B i want to insert the iteration of the Place holder.

ie
A B
Find value 0
(...)
Find value 1
(...)
Find value 2
(...)
Find value 3
(...)

Hopefully the attached spreadsheet better illustrates what i am trying to do.

starting the count at zero is kind of important, but not the end of the world if it is impossible.

[shg]

In B1 and copy down, =IF(A1<>"placeholder", "", COUNTIF(A$1:A1, "placeholder") - 1)

[rylo]

Hi

Here goes.

Please Login or Register  to view this content.

rylo

[justforthis1]

excellent, both methods above seem to work just fine.

Thank you very much.