I have a table which shows sales and staff:
50 - 2
100 - 2
200 - 3
300 - 5
etc
if i enter my actual sales in A coloum eg.
50
78
220
157
100
35
it will match staff to the figures:
50 - 2
78 - 2
220 - 3
157 - 3
100 - 2
35 -2
the sales alos have to round up or down so 157 would select 200 from the table.
thanks
50 - 2
100 - 2
200 - 3
300 - 5
etc
if i enter my actual sales in A coloum eg.
50
78
220
157
100
35
it will match staff to the figures:
50 - 2
78 - 2
220 - 3
157 - 3
100 - 2
35 -2
the sales alos have to round up or down so 157 would select 200 from the table.
thanks