Concatenate with Countif

[gmazza76]

Good morning

I am using a basic formula outside a linked table to identify how many times my name appears in a table in excel so I can pull information from each line.

=CONCATENATE(U3,COUNTIF($U$2:U3,U3))

the outcome would be "Gavin1, Gavin2" etc...

Is there anyway to do this within my table so it auto updates on a refresh? The table column is in "U", which is called "Owner", but I am having no luck updating this?

thanks in advance
Gavin

 

[RoryA]

Is it a Power Query table?

 

[gmazza76]

yes it is, I have just realised I only need to do this if "Active" is in column "Status" in my main table

 

[RoryA]

It would make more sense to do it in PQ then rather than adding a formula column to the output table.

I'll move this thread to the correct forum.

Can you post some sample data that matches your columns?

 

[RoryA]

Does a particular name only have one status, or could the same person have some items active and some not?