Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing cells
I am trying to figure out how I can compare the information in two different
cells. The cells contain both letters and numbers. If a cell in column "A" is equal to a cell in column "B" then I want the information in column "C" that is on the same row as the as the information in coumn "B" to be placed in column "D" that is in the same row as the information that is being compared in column "A". Is this possible? So if A1=column B then the cell next to B (C)would be put in cell "D" in the same row as A. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing cells
You may use this formula in column D:
=IF(A2=B2,C2,"") It will show blank if A and B are not equal, you may change that default value. Hope this helps, Miguel. "Help me" wrote: I am trying to figure out how I can compare the information in two different cells. The cells contain both letters and numbers. If a cell in column "A" is equal to a cell in column "B" then I want the information in column "C" that is on the same row as the as the information in coumn "B" to be placed in column "D" that is in the same row as the information that is being compared in column "A". Is this possible? So if A1=column B then the cell next to B (C)would be put in cell "D" in the same row as A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Cells | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |