P
Paul H
Hi all
A colleague of mine has to sort out library numbers of children at our
school. This involves allocating up to 500 numbers individually for each
child. The system has been working for a number of years and each year he
has to delete children who have left and re allocate their numbers to a new
intake. What has happened over time is that numbers are either unused or
worse allocated to two or more children. What I would like to do is quickly
identify what numbers are a) unused and b) have multiple user names. I have
successfully played around with conditional formatting and spinners to
generate a sequence numbers to identify unused and multiple numbers, but
what I would really like to do is run a macro and have a table of unused and
multiple used numbers appear.
The data is very simple stored as:
pupil first name, pupil surname, library number.
A colleague of mine has to sort out library numbers of children at our
school. This involves allocating up to 500 numbers individually for each
child. The system has been working for a number of years and each year he
has to delete children who have left and re allocate their numbers to a new
intake. What has happened over time is that numbers are either unused or
worse allocated to two or more children. What I would like to do is quickly
identify what numbers are a) unused and b) have multiple user names. I have
successfully played around with conditional formatting and spinners to
generate a sequence numbers to identify unused and multiple numbers, but
what I would really like to do is run a macro and have a table of unused and
multiple used numbers appear.
The data is very simple stored as:
pupil first name, pupil surname, library number.