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.
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