View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?