Hi all - this is a bit of weird one, and I'm not sure it's possible. I have an employee leave tracking calendar, with employee names/vacation balances by row, and year-long dates by column displayed along the top. When somebody takes a day off, I would enter "8" in the corresponding cell that matches their name and the correct date. I have a formula that sums their vacation time taken (by row), and subtracts it from their vacation balance for example.
What I'd like to be able to do, is to write a formula by row that would detect every cell that has data in it (e.g. John Smith x March. 3rd, "8") and spit out the list of dates that person has taken time off. This is really for ease so that I don't have to scroll through my entire worksheet when a manager asks which dates their employees have taken off so far this year. So really, I'd like the formula to "sense" that there's some data in a range of cells, and spit out the cell column headings. Is this possible?
Bookmarks