Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


View this topic in a long page with up to 500 replies per page Create new topic
1 | 2 
6434 posts

Uber Geek
+1 received by user: 1571


  Reply # 622910 10-May-2012 15:16
Send private message

Bhugz:


It will work as you want. try it out.
The only time it will show a 0 is if the player hasn't played at all in any game (or if their best score actually was 0!)

(and if you want to ignore that, then just setup conditional formatting so a 0 shows as white text or something)


ETA: I just realised it is possible to have a negative score. That screws up the ISERROR part of the calc. sorry.  Pivots are your best bet


Yeah I was getting a #Name error with your formula. Is there any other way to do it without using pivot tables, like if i have a helper column or something?


whats wrong with a pivot table?  It will make it much easier to add new data.



47 posts

Geek


  Reply # 622915 10-May-2012 15:24
Send private message

Wouldn't I have to do a separate pivot table for each game?

 
 
 
 


6434 posts

Uber Geek
+1 received by user: 1571


  Reply # 622936 10-May-2012 15:46
Send private message

Bhugz: Wouldn't I have to do a separate pivot table for each game?

you have one data input sheet,  then create separate pivots for whatever views you want, all taking data from the one table.



1 | 2 
View this topic in a long page with up to 500 replies per page Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Geekzone Live »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.