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.

Example:

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?

Example:

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.

View 14 Replies
View Related