I have created a work book to log faults on CCTV cameras from multiple sites. The problem i have got is what formula to use to show the location of the camera. Please see example below.
A B C
Cam Site Cam No Cam Location
1 Store A 2 Right Corner
2 Store B 1 Manin Entrance
3 Store A 8 Back YArd
4 Store C 3 Corridor A
Each store has 200 cameras and the are 10 stores. The Camera log needs to be able to log 200 faults. At the moment i have all the cameras logged on a sheet in the following format,
Store Name Camera Number Camera Location
so i have 2000 entries in total.
any help would be greatly recieved.
many thanks in advance!
Ben