I have a list of information (A1 through A10):
Jim:5 Rachael:2 Dan:5 Brock:5
Rachael:2 Jim:5 Brock:2 Dan:2
Jim:1 Rachael:5
Rachael:5 Dan:1 Brock:2
Rachael:3 Brock:1 Lord:1
Rachael:2 Kim:1
Rachael:2 Dan:4 Brock:4
Rachael:2
Rachael:4 Dan:2
Rachael:3
To the right of each cell, I would like to see the number that appears after "Dan:". If Dan does not appear in the cell, I would like the cell to display a 0.
So in this example, my results would be (B1 through B10):
5
2
0
1
0
0
4
0
2
0
After that is working, the idea would be to be able to take this formula and modify it by replacing the word "Dan" with any other word (always ending in a colon) (like Rachael or Brock) to similarly create a column of the appropriate numbers.
I've read almost all of the "extract info from cells and place into other cell" threads. None of them quite hit on my issue or I could not understand them. The one that came the closest was this: http://www.excelforum.com/excel-form...g-numbers.html -- but I could not get it to work for my situation quite right.
Any assistance would be greatly appreciated. Thank you for reading.
Bookmarks