San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
This is part of a project I am working on and I can't figure this part out. I import some data from a web site. It's the schedules from our leagues football games. There are games that have a (R) and games that have (T) and some have neither a R or a T. I'd like to find some simple code to search and count the number of Wins for R and Wins for T and losses for R and Losses for T. Here are 2 picture examples.
The code would be in B1, B2, B4, and B5.
http://www.nflfever2.com/FantasyFootball/excel11.1.jpg
It would get the data from Cell B10 - B200 and it would look for (R) and (T). There will be more than 1 (R) and (T). If it finds an (R) it then looks to the cell to the right in column C and finds out if it's a win or a loss and adds them up.
http://www.nflfever2.com/FantasyFootball/excel11.1.jpg
So the results if done right would look like so
http://www.nflfever2.com/FantasyFootball/excel11.3.jpg
If someone doesn't mind helping, I sure appreciate it and so would a numerous amount of people once the things is completed. It's going to be a huge rankings for 288 teams. Thanks
The code would be in B1, B2, B4, and B5.
http://www.nflfever2.com/FantasyFootball/excel11.1.jpg
It would get the data from Cell B10 - B200 and it would look for (R) and (T). There will be more than 1 (R) and (T). If it finds an (R) it then looks to the cell to the right in column C and finds out if it's a win or a loss and adds them up.
http://www.nflfever2.com/FantasyFootball/excel11.1.jpg
So the results if done right would look like so
http://www.nflfever2.com/FantasyFootball/excel11.3.jpg
If someone doesn't mind helping, I sure appreciate it and so would a numerous amount of people once the things is completed. It's going to be a huge rankings for 288 teams. Thanks