Jun 23, 2014
I am attempting to count up the sum of names that will be submitted, through a web form, in a single cell.
View 14 Replies
Cell B1 will have a bunch of names submitted to it. let's say 10: Marino, Elway, Namath, Montana, Manning, Brady, Romo, Bradshaw, Favre, Aikman. (these text strings will be all in one single cell)
I will have a list of names that are correct to compare to: Montana, Brady, Bradshaw, Manning. I can put those in its own cell to compare to. (C1)
How do i get the sum of 4 from B1 cell? If B1 only has 3 of the 10, how would it return the sum of 3?
A1 B1 (Submitted cell) C1 (List to compare to "right answers") D1 (sum from B1 compared to C1)
user 1 Marino, Elway, Namath, Montana, Manning, Brady, Romo, Bradshaw, Favre, Aikman Montana, Brady, Bradshaw, Manning 4
user 2 Marino, Elway, Namath, Montana, Manning, Brady, Favre, Aikman 3
This is I am sure a very newbie question, but I couldn't find anything on multiple text strings within one cell, and counting a sum of those.