| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mark certain cells
I have a sheet with 3 columns.
On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
In C1 enter:
=IF(COUNTIF(A:A,B1)0,"a","") and set the font to Marlett Then copy down -- Gary''s Student - gsnu200850 "frederico roldao" wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
Hi,
=IF(COUNTIF($A$1:$A$1000,B1)0,"Duplicate","") Drag down to the length of column B Mike "frederico roldao" wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
one way - in C1:
=IF(COUNTIF($A$1:$A$1000,B1)0,"yes","") then drag/copy down On 30 Kwi, 12:06, frederico roldao wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
I'm sorry, I didn't explain myself properly!
I mean to have a mark on column C on the rows where in column A there is a value that is also in column B (anywhere on column B, not necessarily side by side) "frederico roldao" wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
And if you try any of the suggestions provided you'll find that's exactl what
they do!! "frederico roldao" wrote: I'm sorry, I didn't explain myself properly! I mean to have a mark on column C on the rows where in column A there is a value that is also in column B (anywhere on column B, not necessarily side by side) "frederico roldao" wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark certain cells
actually the formula that worked was =IF(COUNTIF(B:B;A1)0;"y";""), which is
a bit different from what was advised, but the advice served as a starting point, so, thanks! "Mike H" wrote: And if you try any of the suggestions provided you'll find that's exactl what they do!! "frederico roldao" wrote: I'm sorry, I didn't explain myself properly! I mean to have a mark on column C on the rows where in column A there is a value that is also in column B (anywhere on column B, not necessarily side by side) "frederico roldao" wrote: I have a sheet with 3 columns. On column "A" I have 1000 email addresses, on column "B" I have 200 email addresses. On column "C" I want to have a formula that will mark the cell if the address on the adjacent cell (in column B) also exists somewhere in column A. How do I go about this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Foot mark aka single quote mark? | Excel Worksheet Functions | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| green mark in the top left corner of cells | Excel Discussion (Misc queries) | |||
| mark unrepeated cells | New Users to Excel | |||
| How do I mark certains cells with gridlines? | Excel Discussion (Misc queries) | |||
Hybrid Mode
