Forum Discussion
Combining IF and AND formula applied to text strings.
Hi, I would like to insert a combined IF and AND logical routine to return a result in another cell of "True" / "False" / or ideally a number when one cell = a text string eg. "TextA" and anothe...
Sergei,
Many Thanks for your help, very much appreciated.
Is it possible in the Formula string to count the number of times "A2" and B2" = barrie (A2) and kirton (B2)and using COUNTIF and AND routines
I would like to count the number of times these two events occur in a spreadsheet with about 60 rows First Names and Surnames..
I know I can do this with the Data filter tool but would like to use COUNTIF and the AND routine
Many Thanks for your help, very much appreciated.
Is it possible in the Formula string to count the number of times "A2" and B2" = barrie (A2) and kirton (B2)and using COUNTIF and AND routines
I would like to count the number of times these two events occur in a spreadsheet with about 60 rows First Names and Surnames..
I know I can do this with the Data filter tool but would like to use COUNTIF and the AND routine
Barrie,
You'd like to count number of such records for the specific name(s) you have in other cells; or generate the list of unique names from your A,B columns adding how many times such names are repeated?