Want data table cell with the maximum and minimum values of another page to
show as a/b in a cell. Is this possible?

Don't have a clue what you're talking about. Perhaps you could show an
example.

Tyro

"drb" wrote in message
...
Want data table cell with the maximum and minimum values of another page
to show as a/b in a cell. Is this possible?

A/B

A = max
B = min

=MAX(Sheet2!A1:A10)&"/"&MIN(Sheet2!A1:A10)

--
Biff
Microsoft Excel MVP


"drb" wrote in message
...
Want data table cell with the maximum and minimum values of another page
to show as a/b in a cell. Is this possible?

Excellent, excellent. Exactly what I needed. THANK YOU.

"T. Valko" wrote in message
...
A/B

A = max
B = min

=MAX(Sheet2!A1:A10)&"/"&MIN(Sheet2!A1:A10)

--
Biff
Microsoft Excel MVP


"drb" wrote in message
...
Want data table cell with the maximum and minimum values of another page
to show as a/b in a cell. Is this possible?

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"drb" wrote in message
...
Excellent, excellent. Exactly what I needed. THANK YOU.

"T. Valko" wrote in message
...
A/B

A = max
B = min

=MAX(Sheet2!A1:A10)&"/"&MIN(Sheet2!A1:A10)

--
Biff
Microsoft Excel MVP


"drb" wrote in message
...
Want data table cell with the maximum and minimum values of another page
to show as a/b in a cell. Is this possible?