Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-30-2016, 03:00 PM
mlovell mlovell is offline Cricket Stats Help Windows 10 Cricket Stats Help Office 2010 64bit
Novice
Cricket Stats Help
 
Join Date: May 2016
Posts: 8
mlovell is on a distinguished road
Default Cricket Stats Help

Ive made a stats sheet for my cricket team and im having a few issues with some of the figures i want to show...


On the first sheet named "Season 2016" i have the top 5 stats in different categories using the Index formula based on the stats of the two pages, "Batting stats" and "Bowling Stats". The two problems i am having are.
1. If two people have the same figures e.g two players have taken the same amount of wickets, then it shows the same name twice instead of the two names that have the same number of wickets.
2. I cant find a way to return the best bowling figures as i cant get the Index function to return this. Again these numbers are on the "Bowling Stats" page under the Best Figures Column and are ranked on......highest number - lowest number
Attached Files
File Type: xlsx 2016.xlsx (176.7 KB, 21 views)
Reply With Quote
 

Tags
cricket, excel 2010



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cricket Stats Help Print Stats Office 2010 bolstad2006 Word 5 04-26-2011 09:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft