Referencing

Joined
Feb 28, 2018
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
Hi, I’m not sure what this is called so it’s hard to search for it but what I need help with is..

We have a list of point IDs e.g B1050, B1052, etc. which are devices on a fire alarm system, and we have a list of fire zones and we need to create a sheet which has the point IDs along the top and the list of fire zones along the side and we need to mark/tick which zones are triggered when a point is activated, e.g. if point B1050 goes in to alarm then fire zones 15, 16 and 17 are triggered

I have all the points and I know which zone trigger for each point, but how do I get excel to read my data so I end up with a chart with ticks in the right places?

At the moment we are having to manually cross reference the information and manually enter the marks in the right places
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,224,891
Messages
6,181,614
Members
453,057
Latest member
LE102024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top