Dear All, May I kindly request that you help me with this formula? |
my request to amend my formula to be used as horizontal |
result |
=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF(K$8:K8,$A$2:$A$15),0),1),"") |
as in our office, we use Excel 2016 |
Many thanks in advance |