Index Results Help

xor · #1 01-04-2019, 09:53 AM

Please upload your Excel workbook.
Pictures aren't of much help and no one would like to enter all your data.

radicalrom · #2 01-04-2019, 10:00 AM

Quote:

Originally Posted by xor

Please upload your Excel workbook.
Pictures aren't of much help and no one would like to enter all your data.

OOOps. That sure would have been helpful if I did that. Sorry. I just uploaded the excel file.

xor · #3 01-04-2019, 10:08 AM

It is in column 3, not 2 in your INDEX-range, so:

=IF(ISERROR(INDEX($A$1:$H$16,SMALL(IF($A$1:$A$16=$ J$1,ROW($A$1:$A$16)),ROW(1:1)),3)),"",INDEX($A$1:$ H$16,SMALL(IF($A$1:$A$16=$J$1,ROW($A$1:$A$16)),ROW (1:1)),3))

You can shorten the formula by about 50% by using IFERROR instead of IF(ISERROR(...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a I create an index in a word document where index entries control sections of the document?	pfriorda	Word	3	12-28-2017 08:02 PM
Updating font in index without updating style of index	Nick B	Word	4	11-28-2016 02:00 AM
Relational results	tel703	Excel	2	05-19-2016 09:54 AM
Get Paragraph index from bookmark starting index	vince692	Word VBA	6	05-13-2016 04:51 AM
2013 search results take a long time - they fill in as results in reverse date order	themookman	Outlook	0	10-11-2013 12:01 PM