Thanks Phil I had tried to do that, couldn't figure how the formula should be. Greatly appreciated. Regards Sue
Thanks Phil. Most helpful in heading me in the right direction
Great - just what I needed. Thanks
Thanks Mynda - that helped. I was looking at it the wrong way around. I was trying to reduce the amount of data the staff have to input - thus using...
Hi Mynda I'm clearly doing something wrong. I added the identifier to my "Risks list" tab This has the list of all the people with their room n...
Thanks Mynda I had not thought of an identifier - but a great idea. Thanks I'm not sure I fully understand "The 'lookup' you want to do can also ...
Thanks Mynda I think my other problem is I don't fully understand the whole concept of dashboards, pivot tables, tabular formats and other Excel ba...
To assist with what initially should be in the dashboard, I've done a heatmap - fairly basic - but all I can think of at present.
Hi Mynda Thanks for the example file. I'll have to research more to get an understanding of it. I've quite a bit more learning to do to get to th...
After thinking about this for sometime, I realised I had to sort the data more and then add the pivot tables and charts to create the Dashboard. Fo...