Forum Discussion
Help with Excel formula please
Hi all, I have a dataset that looks like the following and I'm trying to eliminate the blanks and consolidate the staff name into Column PM1 and PM2. For PM 1 I use this formula: =IF(A2<>""...
Please consider the solution in the the attached workbook. Rather than using "Y"-characters in different positions, I find it so much easier to work with numbers 1 and 2.
By the way, I introduced a named range "Staff". You may replace it with "A1:D1" if you prefer.