Forum Discussion
Last Invoice Timing
I have N number of employee each employee work 13 days for 15days I need each employee's last invoice timing for each day also each employee will be having at least 40 to 150 invoices each day, let me know if you need any files
6 Replies
Maybe some of the true Excel MVPs are able to read minds; my own attempts at telepathy--to read your mind and better understand your need--have failed miserably.
So, yes, a file or two would help. Seriously, your description gives an idea of what you want to do, but not what your raw material looks like, how you've arranged or arrayed your data. And the "how to" of extracting what you want to extract depends very much on being able to work with the actual file. If it contains confidential information, please create a reasonable facsimile that does not reveal proprietary or private info.
mathetes thank you for the response please find the below attachment for the required file, in sheet 1 there are invoice details for each employee and on sheet 2 there is the list of employees where I need the last invoice time.
Hope this sheet will help to resolve me question
I converted your raw data to a Table and shortened the names of the sheets, just because it makes the formula easier to read and create. Having the data as a Table also enables you to enlarge the database and the formula adapts to the new rows automatically.
This formula does use the newly released function FILTER, so you will need to have the most up-to-date version of Excel in order for it to work. Here's the formula
=MAX(FILTER(Table1[Time],(Table1[adduser]=Report!A2)*(Table1[Date]=Report!B2),"NotFound"))
