Hi, I have a problem with a table i am working with.
Its ranks people based on percetnages and inserts them into a table on the table. First worked no problem but when you insert it into other sheets whcih needs to be done every week its is displayed like
Call Logging - Rankings
1 Craig Faulkner 100%
2 Fiona Watson 100%
3 Gavin Baird 99%
4 Otto 98%
5 Ruairi Taylor 98%
6 #N/A #N/A
7 #N/A #N/A
8 Malachy Kelly 95%
9 #N/A #N/A
It is because the tavle it is referncing is sometime blank or because the percentages are the same. Is theres a way of doing it so that it includes a side table for hang ups or possibly by inserting in alphabetical order?
Bookmarks