Identify multiple rows?

[welshgasman]

Hi all,

My boss wants me to try and work out a way of highlighting all rows except the first for a certain criteria.

I have a column that holds a unique key, and this can be repeated for as many rows as necessary. I can easily add a COUNTIF to get the number of rows for that key, that is one item we do need.
What he also wants is to leave the first row alone, but highlight in some way the other rows.?

Does anyone have some tips on how I might achieve this please?

TIA

 

[sheetspread]

Use the filter and F5 (Go To)-visible cells, then highlight.

 

[welshgasman]

Hi sheetspread,
Sorry, I do not understand. All the rows will be visible, each row will have the same number in a column due to the CountIf function.
I am looking for some way to determine that for 3 rows each will have 3 in the column, but the last two rows, need to ne highlighted in some way. That i can probably do, it is the function/process to identify all but the first row for a common set of rows (as identified by the unique key).

 

[sheetspread]

Are you trying to just highlight the duplicates? Then change the end cell of the countif reference to relative (cumulative), filter <2, and use the Go To method:

Excel 2010
	A	B
1	Unique Key	Count
2	1	1
3	1	2
4	1	3
5	1	4
6	2	1
7	2	2
8	3	1
9	4	1
10	4	2
11	4	3
12	4	4
13	4	5
14	5	1
15	5	2
16	6	1
17	6	2
18	6	3
19	6	4
20	7	1
21	7	2
22	7	3
23	7	4
Sheet9

Cell Formulas
Range	Formula
B2	=COUNTIF($A$2:A2,A2)

(can be done with conditional formatting also)

If this still isn't what you want, show me a small data sample with before/after results

 

[welshgasman]

Nope, you've cracked it, that is what he is looking for, or so I believe

Thank you.
I was thinking a running count might do it and was going to try that tomorrow when in work, but you have confirmed it, and I would have still had to work out how to do a running count, and you have shown me how.

Thanks again.