Finding data match in range of data

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

Jacqueline

I have a column with data that, I want to find a match.

EX. Column A ColumnB Column C Column D

apples grapes peaches grapes
pears apples pears apples


I want to find the match for apples in column A. Is there
a way that I can identify that there are 2 apples in the
data.

Thanks so much!
 
There are three "apples" in the data; what is it you're really trying to
say? Does "the data" mean only columns B through C? What do you mean
"find a match"--the address of "apples" in B2? The address of "apples"
in D2? Both? Something else?

=COUNTIF(A1:D2,"apples") will return 3; =COUNTIF(B1:D2,"apples") will
return 2.

Alan Beban
 
Try COUNTIF(B1..D2,A1), with B1..D2 being the range in
which you want to search for the value in Al.
 
I would like to know if apples were found in Column
(B,C,D),if so return a (# and/or True /False)
 
The following will return either the number of occurrences greater than
0, or FALSE if there are no occurrences.

Alan Beban

=IF(COUNTIF(B1:D2,A1)>0,COUNTIF(B1:D2,A1))
 
Back
Top