Have you tried an if statement on sheet 2
For characters =IF(Sheet1!A1" ",Sheet1!A1," ")
for numbers =IF(Sheet1!B20,Sheet1!B2," ")

"The Boondock Saint" wrote:

Hi all,

Just wondering,

I have a results page.... which draws a username.. and total from other
sheets...

the system allows for 100 players... but if there is only 15 i dont want the
results page to have the 100 results... with 85 being blank......

Anyone have any ideas on how it can just display the number of results
depending on the number of players?

look forward to your thoughts...

saint...