Raw Data below:
I need to create a report that shows:
Till ID, Sales Person and Time of first sale.
I have used MID to extract the till number and then used IF(AND ..... If till number = 1629 and Column C = sales then return time in column B but this has failed miserably.
I want to show that 1629 - James Best, made his first sale at 12:00:54, whereas 1642 - Sally James, made her first sale at 13:13:56.
I have around 200 sales people to show data for and it's too time consuming to do it manually.
Would really appreciate some help ....
<colgroup><col width="70" style="width: 53pt;">
<col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;">
<col width="70" style="width: 53pt;" span="3">
<tbody>
</tbody>
I need to create a report that shows:
Till ID, Sales Person and Time of first sale.
I have used MID to extract the till number and then used IF(AND ..... If till number = 1629 and Column C = sales then return time in column B but this has failed miserably.
I want to show that 1629 - James Best, made his first sale at 12:00:54, whereas 1642 - Sally James, made her first sale at 13:13:56.
I have around 200 sales people to show data for and it's too time consuming to do it manually.
Would really appreciate some help ....
A | B | C | D | E |
Sales Person & Till Number: 1629 - James Best | ||||
Run Report Interval: 19/09/2017 18:00:54 | ||||
12:00:54 | Sale | |||
12:00:54 | Sale | |||
12:01:11 | Refund | |||
12:33:56 | Sale | |||
12:34:23 | Exchange | |||
12:46:59 | Sale | |||
12:48:26 | Sale | |||
13:02:25 | Refund | |||
13:02:25 | Refund | |||
13:05:05 | Sale | |||
13:05:05 | Exchange | |||
13:05:06 | Sale | |||
Sales Person & Till Number: 1642 - Sally James | ||||
Run Report Interval: 19/09/2017 18:00:54 | ||||
12:00:31 | Refund | |||
12:00:49 | Refund | |||
13:01:11 | Exchange | |||
13:13:56 | Sale | |||
13:34:23 | Sale | |||
12:46:59 | Sale | |||