Formula for finding matching numbers
It did work but only if the number was directly across from it. If it was
somewhere else in the column it didn't work. hmmmm...... i appreciate your
help. Do you have anything else that I could try?
thanks
wendy
"Francis" wrote:
Hi Wendy
try this
=IF(A2=$B$2:$B$15,"Appear","")
if the phone numbers in col A appear in col B, the formula wiil
tell you by returning the word "Appear", otherwise it return blank
Is this what you want?
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"wookie" wrote:
Francis,
Thank you for your reply.
I've tried this and I didn't get any results. It gives me a result of 2.
This is an example of what I have. I want to beable to pull the numbers
from A & B that match, 532-2114 shows up in both columns a few times. (this
is just a few lines of what I have and I will be adding more columns once I
get it to work for me). I want it to be able to tell me any numbers that are
the same in both columns. What would it do? Give me a report? Sorry for the
stupid questions this is the first time for me doing this sort of thing.
A B
March Feb
242-2465 245-5051
245-5343 245-5836
253-2025 253-2127
253-2025 253-2127
275-2291 253-2127
365-1700 365-2234
365-2309 365-5295
453-9044 530-2221
453-9044 532-2114
467-3755 532-2114
532-2114 532-2114
532-2114 532-2114
532-2114 532-2114
532-2114 532-2114
Again thank you
Wendy
"Francis" wrote:
Hi
Do you want to count the duplicates across the columns or down the columns
assuming that you have col A, B and C for Jan, Feb and Mar
and you want to count the numbers of repeating phone numbers across in Jan,
Feb and Mar. try this =COUNTIF(A2:C2,"1")
if you want to count down the column for duplicates, create a list of unique
phone numbers in a column, say D2 and down, you may use the Advance Filter
for
this and try this in the last empty cell in the column A
=COUNTIF($A$2:$A$14,D2), where D2 hold the first unique number
Adjust the ranges to yours
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"wookie" wrote:
I have 3 months of phone numbers from phone bills and I need to know if
there is a way I can make a formula to show me the duplicate numbers from
month to month. I have input them in 3 columns and not sure what to do from
here. I've been reading on the forum and some of I'm reading is not making
sense. I know how to use the basics of excel but now getting this in depth
I'm not sure what to do.
|