With the use of MS Excel (Not VBA), a formula that returns the values found within a range containing the most words (by Word Count). Please Note: I’m looking for the cell within a range that contains the most total words separated by Spaces, not based on the most/longest character length in a cell range.
The provided example and illustration, search across the range (A2:D2) and find the cell containing the most by word count and return results. In the event, of duplicate (tie) max word count, only return the result of the first (single) cell containing the most words.
A2: John Doe (2 Words)
B2: J. X. D. Jr. (4 Words)
C2: John X. Doe (3 Words)
D2: John Xavier Doe (3 Words)
The correct result to be returned: B2 J. X. D. Jr, equals 4 separated Words/Letters by spaces.
3