Hi Holly,

Do you already have the Lows, middles and highs, or are you dependent on
Excel to determine these based on the range of values for each column or row?
Also, is this for reporting/charting purposes, or are you looking for a
cell/cells to return the low/mid/high analysis based on the data entered?

Jamie

"Holly" wrote:

I need to set up three different scenarios with same columns and rows for
Low, Middle, High analysis. What's the smartest way for data input? Three
different files, or in same tab with three different line to indicate L, M, H?