Printable View
Thank you Mr. Fox
But I want to convert this formula also
This is the most important
=IFERROR(IFERROR(IFERROR(INDEX(List1;MATCH(0;COUNT IF(D1:$D$1;List1)+IF(COUNTIF(List1;List1)>1; 0;1);0)); INDEX(List2; MATCH(0;COUNTIF(D1:$D$1;List2)+IF((COUNTIF(List2; List2)+COUNTIF(List1;List2))>1;0;1); 0))); INDEX(List3; MATCH(0;COUNTIF(D$1:$D1;List3)+IF((COUNTIF(List3;L ist3)+COUNTIF(List1;List3)+COUNTIF(List2;List3))>1 ; 0;1);0))); "")
I am very sorry
Formulas do not work
Look at this
Here's the workbook, and the formulas are working absolutely fine.
Cross posted here
Hi mahmoud-lee,
You have been warned for several times for not providing the link while posting the same questions on different forums. I'm locking this thread for now. Please acknowledge what Peter posted at mrexcel and PM either me or Excel Fox.
Give me this value, and nothing
{=#VALUE!}