danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
How to extract multiple values (exc duplicates) with two criteria
ABL1VendorInvoiceReference2100001003422167058190052331L2L2=(INDEX(Sheet2!$L$3:$L$21835, SMALL(IF(FREQUENCY(IF(Sheet2!$K$3:$K$21835=$B2, Sheet2!$L$3:$L$21835), Sheet2!$L$3:$L$21835), ROW(Sheet2!$L$3:$L$21835)-ROW(Sheet2!$L$3)+1), COLUMNS($L2:L2)))) Above is what I am using currently. Searching...
www.mrexcel.com
This is an old thread of mine which I wanted to re-read as I have upgraded to Office 365
However, the formatting in my OP is showing text and I cannot see what the original table looked like. I tried copying and pasting it into a new post and previewing it but it just showed the text.
Is there are a way to see what the OP would have looked like when I posted it?