I want to be able to look at a column (column A on attached spreadsheet - page 'Thur 29 July')
on column A there are lots of numbers going down the column - these are scans of tools going in and out of the tool store.
the sequence is as follows;
- someone takes a tool out of the store and the tool is scanned and the person is scanned (row 3 as example on 'Thur 29 July' page
- if they take more than one tool out the tools on lines 4, 5 and 6 are scanned but we don't scan the person again
- When the tools are returned to the store they are scanned again and shown in column A but we don't scan the person
PROBLEM
When a tool is taken out and returned we put conditional formatting on so the cells go pink. Any tool not returned is then left non shaded. That means we can quickly see what tools are outstanding.
When a tool is taken out more than once in the same day we cannot quickly tell what tools are not returned
WHAT WE WANT TO DO
is have some sort of formula that can check column A and highlight any ODD scenarios for a specific number
ie. if tool number 2 has been taken out and returned twice there should be 4 x no 2 in column A. As that is an even scenario it would be fine
if the tool number 2 was taken out twice and returned once it would show 3 x no 2 in column A. As that is an odd scenario we want this highlighted (we aren't bothered about having conditional formatting)
SOME POINTS
- we do a new page for every day
- the tools and the people are pulling information through from the master sheets showing every tool in the store and every person that may take a tool out
- ideally need to work out something that is relatively (?) easy to manage so that we can amend if we need to
not sure what will do this ?
all help appreciated
Belinda
Bookmarks