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?
|