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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.
Last edited by Admin; 06-22-2013 at 02:52 PM.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Give me this value, and nothing
{=#VALUE!}
Posting Permissions
Bookmarks