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 Displaying Multiple Values without using Macros or ROWS function

Oh well! Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ltzhao" wrote in message
...

Hello T. Valko,

Thanks for your help. Unfortunately, the software doesn't support
ROW() function either. I've figured out another way to get around the
problem. I had to split the information into two sheets, using max(),
match() and index() to get around it. It's not pretty, but it works.

Thanks again for your help.




--
ltzhao