|
Tricky Question
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... |
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... |
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... . |
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... . |
Hi
as said: more details are required :-) -- Regards Frank Kabel Frankfurt, Germany "The Boondock Saint" schrieb im Newsbeitrag ... 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... . |
"Frank Kabel" wrote: Hi as said: more details are required :-) -- Regards Frank Kabel Frankfurt, Germany "The Boondock Saint" schrieb im Newsbeitrag ... 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... . |
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... |
What about Auto filter for Non-blank??
HTH Gilles "The Boondock Saint" wrote in message ... 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... |
| All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com