View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dylan dylan is offline
external usenet poster
 
Posts: 26
Default Compare row contents

Jarek, sure thing,

It's an invoicing database for time/expense. The columns are laid out as
listed below and the columns of the rows I want to check are B, F, G, and I
(B - Person, F - Job ID, G - Item and I - Week Commencing); I want find
duplicates of instances where a person (B) has spent time (G) on a project
(F) within a given week (I). Logically, each person should only have one
entry per project, per week.

Columns A-L
A Ref:
B Person
C Title
D Project Title
E Location Ref
F Job ID
G Item
H NEC3 Ref
I Week Commencing
J Quantity
K Rate
L Qty x Rate
"Jarek Kujawa" wrote:

can you provide an example of what you want to count exactly?