thanks Bony.....
Ive looked at that but it doesnt sound right...

basically ive got a page... its got 3 cols.... rank... name.. and $$$
its set up for 100.. but sometimes only 15 people might play.... so i just
want it to have 15 rows of results.....

but i need it to be automatic... depending on how many are playing....





"Bony Pony" wrote in message
...
How about using a Pivot Table?

-----Original Message-----
Hi
you may provide some more details about the exact data
structure of your
file and your expected results

"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...



.