Can you put the formula in 1 cell and have it display 20 cells of data

In that one cell: not unless you want to concatenate all the values into a
single string - basically =formula1 & formula2 & char(10) & formula3 &
formula4 & char(10) & . . . & formula20

In a range 10 rows by 2 columns: No, you need one formula per cell - just
like I showed you.

You can enter something similar to it as an array formula, but I don't see
what the issue with doing as i said.

--
Regards,
Tom Ogilvy




"sam" wrote:

HI,Tom

Thank you for your help!

I tried this method. It works.
However, it needs to drag the F4 manually to display the whole range
info. Is there any other method can display the whole range
automatively. I tried the clause F4
=if($F$1="","",if($F$1=1,Detail!$A$1:$B$10,if(row( )11,"",Detail!$C$1:$D$8))).
It doesn't work. Do you have some ideas on this issue? Thank you in
advances!!!

Best Regards

Sam

Best Regards