baseball

Hi all - thanks in advance. I think this is fairly straightforward with an array formula but can't get it to function. If I have a column that has multiple occurences of a word, and the second column contains either a "n" or a "y", if any of the the occurences contain a "Y" I want the formuala...

I want to highlight the days on my calendar that match my Event list, but I want the different events to have different colors. example: Event List 1. 1/3/2020 - Baseball 2. 1/4/2020 - Football 3. 1/5/2020 - Golf 4. 1/6/2020 - Baseball 5. 1/7/2020 - Baseball 6. 1/8/2020 - Golf I want the...

I have the Lahman Baseball Data which is an ExcelSpreadsheet of every player to pay professional baseball which is massive spreadsheetof data. What I want to do is set up a spreadsheet that I can compare 2 playersstats for there full career. For example take the data from this spreadsheet andon...

Below is a snapshot of my spreadsheet. All numbers (hits) are populated (linked) from other sheets in workbook depicting each specific games. The GREEN background seen is currently being formatted manually. I am now trying to figure out how to CONDITIONALLY FORMAT the cells to show a players...

Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...

Hi, I'm trying to create a combo graph. I have a list of terms (baseball bat, baseball, glove, baseball jersey etc) and I want to be able to compare their monthly sales to the month search volume. How would be the best way to organize the data so that I could create a combo graph that would...

I'm trying to, what I think is, 3-D Cell References across worksheets to calculate a baseball league's statistics. My document can be downloaded here: http://twitterbaseballny.com/wp-content/uploads/2017/04/2016-Twitter-Baseball-League-Wide-Stats.xlsx I've set up my excel file with the first...

Hi all, I'm wondering if anyone knows an excel formula to search for the first letter in a column, and return that letter. Also, bonus points for adding a comma after the first letter. heres example column: <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>...

Hi Everyone, I'm trying to automate some statistics for my softball league, and one of the things I want to look at is opponent's Win-Loss record. I want to solve the problem using array formulas, but I can't seem to crack it. We have a table of home team/away team and another table of...

I want to calculate innings pitched across multiple sheets, 162 to be exact. I need it to calculate it into the proper baseball format. Example- 2.1 + 1.2 = 4. Anyone able to help?

I am trying to import baseball webpages via VBA http://sports.yahoo.com/mlb/scoreboard?d=2012-03-16 The problem I am getting is that all the code from the site is too big for the variable and does not even get to the point where the scores are imported. Ultimatley I want to build a...