On 2 Oct, 14:41, Teethless mama
wrote:
"Name" is a defined name range (no quotes) in column AI

In AM:
=IF(ISERR(SMALL(IF(Name=$AL1,ROW(INDIRECT("1:"&ROW S(Name)))),COLUMNS($A:A))*),"",SMALL(IF(Name=$AL1, ROW(INDIRECT("1:"&ROWS(Name)))),COLUMNS($A:A)))

ctrl+shift+enter, not just enter
copy across and down as far as needed



" wrote:
Hi

I have a list of names in Column AI that can recur up to 7 times per
name (each name)
EG
Scott
Billy
Leigh
Seb
Billy
Scott

In Column AL I list these people once
EG
Scott
Billy
Leigh
Seb
etc
etc
etc

In Columns AM to AS I wish to return the row numbers that these names
occur in (each name will occur a maximim of 7 times, but I don't mind
the formula returning #N/A if they don't occur 7 times) and the data
will go from row 1 through to 60
So, Scott is in AL1 and the value 1 would be in AM1 and 6 in AN1 etc
etc
Billy in AL2 with value 2 in AM2, and 5 in AN2 etc etc

How would I achieve this?
I can use MATCH in colum AM to get first occurences, but this doesn't
work on subsequent columns.

Any help with this would be most appreciated. (I hope I explained this
clearly)
Thanks
Neil- Hide quoted text -

- Show quoted text -

Thanks to everyone for their repsonses. I now have just what I need to
proceed.
Pivot table wasn't right for what I need to do

Neil