This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have 30 employees, each with 20 expense report numbers, each report number 5 types of expenses attached to them, all with different amount spent. Hence a total of 3000 line items. Of the 3000 line items I want to samples, ensuring that each employee with at least each expense type that has the highest amount spent, without overlapping reports, to be selected as my samples.
I think an iterative macro will be your solution, but can you elaborate further? For your sample, do you want the highest amount spent for each of the 5 expense types for all 30 employees (150 records)?