MATCH Formula to Return multiple Row Numbers.

[Roj47]

Hi,

I had successfully been using

=MATCH($C$13,$B:$B,0)

to return the row number of the corresponding item.

It them dawned on me that the data sometimes had the same value multiple times so only returned the first instance.

Having failed to incorporate FILTER into the formula and internet searches advising the insertion of a new column to make data more unique, I hoped I would be able to tailor the formula without changing the sheet.

Ideally I would be able to remove duplicates or amend the data in column B from Crisps to include flavour to make them unique but it seems this option is not available to me (thanks management!).

Thanks in advance,
Roj.

 

[Cubist]

Can you post a mockup sample of your data (10-20 rows) and the expected outcome?

 

[Roj47]

Can you post a mockup sample of your data (10-20 rows) and the expected outcome?

Thank you for the reply and as requested, please find an example of what I would like to happen in the search.

 

[Alex Blakenburg]

Do you just mean something like this:
1) Down the page

=FILTER(ROW(B:B),B:B=$C$13,"")

2) Across the page

=TRANSPOSE(FILTER(ROW(B:B),B:B=$C$13,""))

 

[Roj47]

Do you just mean something like this:
1) Down the page

=FILTER(ROW(B:B),B:B=$C$13,"")

2) Across the page

=TRANSPOSE(FILTER(ROW(B:B),B:B=$C$13,""))

Thank you, exactly what I was looking.

I kept merging MATCH and FILTER and failing

Much appreciated.

 

[Alex Blakenburg]

You're welcome. Glad we could help.