Hi guys - please see attached. This is a small cut (100 records) of a dataset of 8,000 records.
I am looking for a formula to be entered in M2 which does the following:
Looks at L2
if L2 contains a numeric value on the end then say "SNN"
if L2 contains a string which is all text values then say "CC"
if L2 says WEBCONNECT then say "WEB"
The third criteria "Webconnect" is a text value so I am unusure how to distinguish this from the second criteria which is someones first initial and surname.
Background.
Col L is a "booking Cancelled by field" - Webconnect mean a booking was canx via web, three letters and a numeric value means canx on site and the rest are contact centre agents inital and surname.
I have been using =SUM(SUMIF(C2:C11,"???"&{1,2,3},D2:D11)) and countif blah blah webconnect previously to get figures but I now need col m to say SNN, CC or WEB.
Thanks for looking.
Bookmarks