Designing automated grid in Excel

I have a grid that is used to determine the size of a company expressed as a letter of the alphabet. At the top of the grid I have “Number of Staff” expressed in groups of “Up to 100”, “100 -200”, “300 – 400” etc. (14 groups in total). On the left of the grid I have “Market Cap” expressed in groups of “Up to 70m”, “70 to 140”, “140 – 440” etc. (14 groups in total).

At the moment, when determining the size, you would identify the number of employees and the size of the market cap and where the column and row overlap, that would be the letter to use.

I would like to remove the manual “tracing column and row until they match” part and rather have a section where you would type in the number of employees and the market cap and when you hit enter, Excel would then highlight (in some form) the block where the 2 overlap. or would even highlight the entire row and column (so as to create a cross-like visualisation).

Is this possible..?

By: Chanel

Leave a Reply

Your email address will not be published. Required fields are marked *