Nick
Do you mean "" in my formula? If yes, this is when in Excel we want to say "Nothing"--"Empty cell"...Also, what are the quotation marks for?
OK with this but you can create a small SAMPLE workbook with same data(Not Names, Not sensitive informations), so to see and understand what is the real situation......I would post the file but it is confidential so I cannot.
In any case if you don't find your solution and if you upload a sample, i promise to see it tomorrow morning because for Today, i have no more time.
Thank you for the reb*
Bookmarks