Forum Discussion
Covert two lines to two columns
I have some data as follows: Header1: Data A Header2: Data B Header1: Data A Header2: Data B Header1: Data A Header2: Data B I'm sure this is very simple to do, but I can't work out how. H...
Hi AngelaMR
Please find below query can be handle with new dynamic arrays & classic array method
New dynamic arrays Formula
=FILTER($B$4:$B$9,C$3=$A$4:$A$9,"No Data")
Classic Array Method (Ctrl+Shift+Enter)
=IFERROR(INDEX($B$4:$B$9,SMALL(IF((F$3=$A$4:$A$9),ROW($A$4:$A$9)-ROW($A$3),""),ROW()-ROW($A$3))),"")
Attached is the sample file for your ready reference.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert