I have a list of data in two columns. The data ralates to areas and times of cleaning shifts in a hospital environment. The first column is a list of data that indictaes the shifts that are vacant, for example when people are on holidy or are sick. The 2nd column shows the shifts that are subsequently filled by other staff. What I need is for a third column to sort this automatically to leave just the shifts that havent been filled
Workbook attached
Thoughts
Does this do what you require? Array formula entered with Crtl Shift Enter
Dynamic removal of duplicates.xlsx
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Its a great start but it seems to be removing too many!
It checks to see if any of the the values on column B are in Column A and the ones that are not on both, it transfers them to Column C, if this is incorrect can you elaborate more?
Thanks
Ive looked again. You are absolutely right. Brilliant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks