wykikitoon 9385 Posted February 21 Author Share Posted February 21 The first two are two separate tabs. One is the league, the others is where I have been imputing my events. So I put in a name of who has done the event and that's picked up on the league. Link to comment Share on other sites More sharing options...
The Fish 4895 Posted February 21 Share Posted February 21 Ok, make a data table with the names of the rider id, rank, rider number, people, gender, score, medal (unless this is a calculated field), then the events, etc. than create a pivot table off this for the men Gender in Filters Name as rows Events as columns Do the same for women. 1 Link to comment Share on other sites More sharing options...
wykikitoon 9385 Posted February 21 Author Share Posted February 21 1 hour ago, The Fish said: Ok, make a data table with the names of the rider id, rank, rider number, people, gender, score, medal (unless this is a calculated field), then the events, etc. than create a pivot table off this for the men Gender in Filters Name as rows Events as columns Do the same for women. Top man, will give it a go this eve and let thee know. Link to comment Share on other sites More sharing options...
The Fish 4895 Posted February 21 Share Posted February 21 6 minutes ago, wykikitoon said: Top man, will give it a go this eve and let thee know. Remember, when you're creating your data table; a) include as many columns as you can imagine needing. e.g. all of the events you'll schedule for the year, b) format the information as a table. a) it's easier to ignore empty fields than it is to add more and b) formatting as a table means the pivot table will include all the changes you make to the table easier than if it's a range. I was thinking it'd also be useful to have a separate table for the dates of the events. Purely as an index (or vlookup) reference. 1 Link to comment Share on other sites More sharing options...
wykikitoon 9385 Posted February 22 Author Share Posted February 22 @The Fish Just thinking. Is it worth having a table for each league member? There's 50 Riders. Then in that table have what each event they have done. Then that can be put into the overall table Link to comment Share on other sites More sharing options...
The Fish 4895 Posted February 22 Share Posted February 22 24 minutes ago, wykikitoon said: @The Fish Just thinking. Is it worth having a table for each league member? There's 50 Riders. Then in that table have what each event they have done. Then that can be put into the overall table You want as few steps as possible. Better to have one monster table that the pivot table summarises, than a multitude of smaller tables that you're referencing from. Say you wanted only the men. You'd need to instruct excel to look in each table, individually, for the gender of the rider. Instead have one table with all the riders, their genders, the events they've taken part in, etc. 1 Link to comment Share on other sites More sharing options...
Gemmill 21627 Posted February 22 Share Posted February 22 No one should be using vlookup now that xlookup exists. Re what the fish is saying. Make it a proper table (ctrl+t). There are loads of benefits of using proper excel tables. 1 Link to comment Share on other sites More sharing options...
wykikitoon 9385 Posted February 22 Author Share Posted February 22 I've actually simplfied it somewhat. Instead if using an XLOOPUP for some events I have just manually inputted the points awarded. At the end of the day its not going to have shit loads of Data in so why complicate it? Or am I just being a wimp The table thing is great to work with, then the pivot table off it is so simple. 1 Link to comment Share on other sites More sharing options...
Craig 5990 Posted March 10 Share Posted March 10 2 1 Link to comment Share on other sites More sharing options...
The Fish 4895 Posted March 10 Share Posted March 10 This touches me 2 Link to comment Share on other sites More sharing options...
Monkeys Fist 25105 Posted March 10 Share Posted March 10 Link to comment Share on other sites More sharing options...
Gemmill 21627 Posted March 10 Share Posted March 10 I'm finally getting to grips with DAX and have just built my first data model for power BI, complete with a bunch of DAX measures I wrote ALL BY MYSELF. Nothing you say can hurt me today. I'm going into the weekend on a MASSIVE high. 2 Link to comment Share on other sites More sharing options...
wykikitoon 9385 Posted March 10 Author Share Posted March 10 9 hours ago, The Fish said: This touches me Honestly I've used excel for a couple of decades but very very basic. Ive got loads of spreadsheets for my calcs. When you mentioned making some of my stuff a table I've gone back and redone a lot of my stuff and it's soooooo good. What's your. PayPal 😂 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now