There is always only going to be two different text strings. Both will never occur the same amount of times. Basically I just want to know which one occurs the least. The text may vary, so a countif or lookup is not an option as the names are not known, just the range of data. In example,
sam sam sam sam bill
least: bill
Thanks for any assistance.
sam sam sam sam bill
least: bill
Thanks for any assistance.