Excel 2007 : How to tell if the number in a column are the same

[Lynn1]

I am trying to figure out are the numbers in a column same. In MS Excel 2007.

The column that I need to look at has a five digit number in each cell and there are several hundred rows.

So I am trying to figure out if the five digit numbers in each cell within this particular column the same. Instead of using the scroll bar to move the page and look at each five digit number in each cell in that column.

Is there a formula that will tell if all of the five digit numbers in each cell within that particular column the same instead of visually trying to look at it??

Sincerely,

Lynn

[teylyn]

Hello,

so all cells in the same column should be the same? If your cells are in column C starting with C1, then use something like

=COUNTIF(C:C,C1)=COUNT(C:C)

cheers,

[abousetta]

Hi,

I use a helper column to achieve this in combination with a filter. The example shows how I have numbers in column A and column B. Now there are two scenarios: 1) I expect the numbers to be the same at the corresponding rows (e.g. A2 = B2). In this case, I use:

Please Login or Register  to view this content.

2) the numbers are not expected to be the same:

Please Login or Register  to view this content.

With the latter example, you will get a #NA in the cells where numbers are present in column A but not in column B.

Hope this helps.

abousetta

[teylyn]

You can highlight cells that are not the same. Click the column, then click Conditional Formatting on the Home ribbon > new rule > use a formula to determine ... and enter this formula:

=$C$1<>C1

Select a fill color.

Adjust cell addresses to suit, but mind the placement of the $ signs!!