[Closed] Excel Help Please

Countif() then filter for the 1s

So if I read right you have 2 columns of data, you want to show entries in column A where there's nothing in column B?

- Highlight the whole table
- click the drop down menu 'sort and filter' (on the home tab on the ribbon)
- click filter, you'll then see little drop downs appear at the top of each column
- click the drop down on column be (child column)
- untick select all
- tick blanks

If you just want to get a list of the unique values in Column A, copy it to a new column (C) to preserve the orginal then highlight Column C and use Data/Remove Duplicate (make sure only Column C is ticjked in the dialogue box) and you'll be left with a list of the unique values.

Edit - Just reread your post so scratch that, go with RobHilton's COUNTIF

so set C1 = COUNTIF(A:A,A1)

copy that down the whole data set

do the autofiltering setup then select on Column C = 1

Or you could use a Pivot Table....

I just want to hightlight the rows that in column A dont have only have 1 occerance

The purist

Thanks that worked

if you just want to 'highlight' the number i.e. change the colour or something, then use Conditional formatting

- select all the data in column A, say A1:A100000
- Home > Conditional Formatting > New Rule
- select "Use formula to determine which cells to format"
- type in =countif($A$1:$A$100000,A1)=1
- click the a Format button and select a font colour etc.
- click OK, OK

If it's only a single column, select the column then:
Home > Conditional formatting > Highlight Cells Rules > Duplicate Values

You can then select either Unique or Duplicate, plus the highlight colour.

You can then sort by that column using cell colour to bring all the unique or duplicate values to the top or bottom.