Hi, appreciate any help you can give:
I have a database with column 'type'- this has various text eg. "hv","group","pr/group", "1:1", etc the text in an many combinations
i would like to find the average of another column IF 'type'=1:1 or group in any combination.
previous formulas have let me search like this "*"&"1:1"&"*" but i cant seem to do this with averages or ifs. so i came up with a plan- if i add another column next to type and code anything with 1:1 or group as '1' and everything else a 2 then i can do what i need BUT i cant even get my new column to accurately show the '1' and '2'.
this is the closest i got =IF(OR(ISNUMBER(SEARCH("*"&"1"&"*",'RCI Data'!K3)),ISNUMBER(SEARCH("*"&"u"&"*",'RCI Data'!K3))),1,2)
nb 1 is unique to the 1:1 and u to group
HELP please??
Bookmarks