Hi all
I have two lists of partner names - one has just a list of names (and some other related data) - (Partner ID's), the other has a list of names with a corresponding ID number (Partner Data).
So I have this formula in F1 in the sheet Partner ID's: =IF(E1="None",COUNTIFS('Partner...