array formula-f

M

Mark

frank,

Im using your recommendation and it is working but it
seems to return every other match not all of them

=INDEX('sheet1'!$B1:$B$100,SMALL(IF('sheet1'!
$A$1:$A$100=$A$1,ROW('shee t1'!$A$1:$A$100)),ROW
(1:1)))(1:1)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted % Complete calculation 1
HELP: IF Statement between Dates for Reverse Index failing 0
Match Array returning #NA, Works individually 4
return multiple values when within range (greater than and less than) 11
Index Match to ignore blank cells 0
Need help with INDEX lookup 14
Select minimum with duplicate values to return column headings 3
Hyperlinks with lookups 0

Top