Hi Jarek,

This doesn't solve it, I'm trying to check for duplicate rows checking
whether the contents of cells B, F, G & I match these same cells in other
rows, i.e. A row cannot be entered twice and the cells B, F, G & I contains
the data I want to test.

Please find enclosed copy of the sheet I'm trying to check, it may make it a
bit clearer.

Regards
Dylan


"Jarek Kujawa" wrote:

would:

=SUM(IF(($B$1:$B$1000="Bob Dylan")*($F$1:$F$1000="Job ID")*($G$1:$G
$10000)*($I$1:$I$1000="Week number"),1,0))

help?

copy down the formula then apply filter
otherwise send me a file