Is it possible to Min Info that doesn't exist?

[ExcelNewb09]

I have 2 columns of info for a bunch of facilities we have.

Recorded treatments, and Scheduled treatments.

Was wondering if it'd be possible to find the Min (or Max, stdev, average, etc) of the result of:

Recorded/Scheduled

without physically putting that column somewhere.
Is this possible?

Thx

 

[Andrew Poulsom]

You can use a formula like:

=MIN(B2:B4/C2:C4)

which must be confirmed with Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround this array formula with curly braces {}.

 

[ExcelNewb09]

Exactly what I needed,
Thank you much sir!