How to add a index number to a helper column

[JeffGrant]

Hi All, I am having a real brain fade today.

My aim is to keep visible the first occurrence of a record, then hide the rest.

Bu I need to create a helper column such as this.

Book1
	A	B
1	Name	Index
2	Jeff	1
3	Jeff
4	Jeff
5	Tom	1
6	Tom
7	Tom
8	Tim	1
9	Tim
10	Noel	1
11	Fred	1
12	Fred
13	Joe	1
14	Joe
15	Joe
Sheet1

Ordinarily I would research until I found a For Next Loop somewhere on the big www, but I have over 10,000 records, so I am hoping there is a better and more efficient way.

I am not familiar enough with PQ.

If a loop is the preferred way, can someone be kind enough to write one. I am sure what you folk can do in a matter of minutes will take me considerable time to find.

Much appreciated.

J.

 

[JeffGrant]

We learn something knew everyday.

I have only every filtered the entire highlighted range, not just one column like this. I didn't realise it would still pick up the rest of the data

J.

 

[Alex Blakenburg]

We learn something knew everyday.

I have only every filtered the entire highlighted range, not just one column like this. I didn't realise it would still pick up the rest of the data

J.

Technically it doesn't "pick up the rest of the data".
What is does is hide the (whole) row, which hides everything that appears on that row.
(It's also one of the reasons we tend to avoid having separate data tables sitting next to each other)