Forum Discussion
Last Invoice Timing
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"))
mathetes Thank you, So I need to use this formula in any sheet to get the values am I correct
?
I didn't catch what is the logic of selection name/date in second sheet, but if the purpose is to show max time for each name and each date when PivotTable could work
Layout and design could be adjusted as needed.
