Firstly thank you for the help I have received in the past, much appreciated. My issue concerns a "league table"
for my companies departmental shifts, I have already been helped in returning zero's in the top two tables but as you see in
the last table, where it is using an offset formula to place the departments in "order" it is placing the top
department in all the positions and not a blank as I would like. I am still very much a beginner and I have tried all sorts
of IF statements but I am just so wide of the mark.
This is what the table looks like showing weeks 1 to 4 set at zero's. Normally once the year has gone under way it will be
populated with positive values.
NPE 0 0 0 0
NPM 0 0 0 0
NPN 0 0 0 0
PE 0 0 0 0
PM 0 0 0 0
PN 0 0 0 0
PRODM 0 0 0 0
PRODN 0 0 0 0
Immediatelly below it is a table that will show the departments in their respective positions for each week of the period.
1 NPE NPE NPE NPE
2 NPE NPE NPE NPE
3 NPE NPE NPE NPE
4 NPE NPE NPE NPE
5 NPE NPE NPE NPE
6 NPE NPE NPE NPE
7 NPE NPE NPE NPE
8 NPE NPE NPE NPE
This is the code that lies in each cell within the second column and reads from the table above;
But as you see it places the top department in all of the cells but ideally I would like it blank. I do have an annual table
at the end of the book which reads from 13 periodical sheets but as you can imagine it is full of NPE! Is there a way out of
I have attached an example sheet.