split cells with each having a formula possible?
 

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

split cells with each having a formula 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?

split cells with each having a formula 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?

split cells with each having a formula 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?

split cells with each having a formula 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?