How extracted from above, the following requirements of data


Requirements:
1, the extraction of a client, recently four salesman and date, from right to left, which in turn is the most recent time
2, the salesman extraction of first selection is not service in recent one month before the customer, for example: chun-yan zhao this customer has not been served one month salesman: xu, Fang Fei, soho, peach peach, a total of four, choose the farthest distance time as the preferred salesman, the remaining three according to the time as far as the recent time, in turn, fill in the candidate salesman


Table data uploaded to the network location, which master can help have a look, thank you
Link: https://pan.baidu.com/s/1KiCNvoNBvYSKY25KO9-gvQ extraction code: cd4e

CodePudding user response: