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...
Hi Barrie,
Excel definitely compares cells with text
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?
Sergei, It is the latter, ie generate the list of unique names , ie First Name Barrie (A) and Surname Kirton B and be able to count the number of times in the list that this unique combination of First and Surname appears also would like to incorporate a location in column C eg St Cuthberts church
Okay, I see. Locations in column C are the same for same persons or one person could have different locations in your records?
