For my original formula, you can add &"" to the end of the formula to hide the 0s.
=IF(ROW(A1)>$C$2, "", INDEX('Student Roster'!A:A, MATCH(ROW(A1), 'Student Roster'!$K:$K, 0))) & ""
For my original formula, you can add &"" to the end of the formula to hide the 0s.
=IF(ROW(A1)>$C$2, "", INDEX('Student Roster'!A:A, MATCH(ROW(A1), 'Student Roster'!$K:$K, 0))) & ""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks