Copy any text into another cell

I am attempting to analyze a range of 5 cells. If they are blank, then I want the answer cell to remain blank, but if it contains a word, then I want that word to be copied to the answer cell. In addition, if the word is duplicated, I want the duplicates ignored.

Ideally, I would then have a total of the duplicates post into another adjacent cell.

Application:
In a calendar format, an employees name would be entered if they were off, and that name copied to a cell outside the calendar with the number of times in that week they were off, added and placed in the adjacent cell.
Then I can automatically calculate the number of vacation/personal days that employee has remaining for the calendar year.

System is Windows 7
Excel is version 2010
By: Ric Holloway

Leave a Reply

Your email address will not be published. Required fields are marked *