Compare cells

#1 August 16th, 2004, 03:56 PM

Hello,

If I have:

A B C
======= ======= =======
01) 1 25
02) 2 124
03) 3 23
04) 4 122
05) 5 21
06) 6 120
07) 7 19
08) 8 118
09) 9 17
10) 10 116
11) 11 15
12) 12 114
13) 13 13
14) 14 112
15) 15 11
16) 16 110
17) 17 9
18) 18 108
19) 19 7
20) 20 106
21) 21 5
22) 22 104
23) 23 3
24) 24 102
25) 25 1

What formula must I use to let me know, in column "C",
that the number in column "B" is somewhere in
column "A"???

Thanks!!!

#2 August 16th, 2004, 04:07 PM

Hi
in C1:
=IF(COUNTIF($A$1:$A$20,B1),"in column A","not in column A")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
Hello,

If I have:

A B C
======= ======= =======
01) 1 25
02) 2 124
03) 3 23
04) 4 122
05) 5 21
06) 6 120
07) 7 19
08) 8 118
09) 9 17
10) 10 116
11) 11 15
12) 12 114
13) 13 13
14) 14 112
15) 15 11
16) 16 110
17) 17 9
18) 18 108
19) 19 7
20) 20 106
21) 21 5
22) 22 104
23) 23 3
24) 24 102
25) 25 1

What formula must I use to let me know, in column "C",
that the number in column "B" is somewhere in
column "A"???

Thanks!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking cells to MS Project cells	Bob	General Discussion	0	July 26th, 2004 05:51 PM
Cannot lock/protect Merge and Center Cells	Tammy	General Discussion	7	July 9th, 2004 05:51 PM
Counting Number of Cells Including Merged Cells	Daniel D.	Worksheet Functions	12	February 24th, 2004 01:27 AM
Locking individual cells	Ken Wright	Worksheet Functions	1	February 15th, 2004 02:27 PM
FILL CELLS = VARIABLE # OF OTHER CELLS (WITH MACRO)		Charts and Charting	7	January 7th, 2004 08:47 PM