Exceladd1ct
Board Regular
- Joined
- Feb 10, 2019
- Messages
- 76
Hello, I have a huge list of items in column A. Many of this items are duplicates(for a good reason).
Is there a way to return all cells that match a certain item?
I use this formula but it only returns the first occurrence:
Thank you.
Is there a way to return all cells that match a certain item?
I use this formula but it only returns the first occurrence:
Code:
=ADDRESS(MATCH("MyLookup";A1:A10;0);1;4)
Thank you.