G
Garf
Hi
I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104
and one with values
How do I count the number of values that pertain to a specific rep and week
number and also how do i return the value that relates to the rep code and
week number
Week Number Value Rep Code
1 £3,200 103
1 £1,000 106
1 £450 104
1 £1,000 106
1 £1,000 102
1 £800 106
1 £500 106
2 £2,000 102
2 £2,200 104
2 £1,230 104
2 £1,000 102
I am trying to insert these values in to a sales tracker by week by number
and value automatically and am having trouble
I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104
and one with values
How do I count the number of values that pertain to a specific rep and week
number and also how do i return the value that relates to the rep code and
week number
Week Number Value Rep Code
1 £3,200 103
1 £1,000 106
1 £450 104
1 £1,000 106
1 £1,000 102
1 £800 106
1 £500 106
2 £2,000 102
2 £2,200 104
2 £1,230 104
2 £1,000 102
I am trying to insert these values in to a sales tracker by week by number
and value automatically and am having trouble