If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare cells
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
|
|||
|
|||
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 | |
Display Modes | |
|
|
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 |