01-04-2021 12:46 AM
01-04-2021 12:46 AM
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
01-04-2021 05:40 AM - edited 01-04-2021 05:41 AM
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.
01-04-2021 06:44 AM
@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
01-04-2021 09:28 AM
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
01-04-2021 12:59 PM
You wrote: So I need to use this formula in any sheet to get the values am I correct?
To which I can only answer with a qualified "Yes." That formula, or, more to the point, one like it with updated references, will work where the conditions are essentially the same, but you shouldn't expect to just copy and paste from that sample to another sheet.
Here are two links that can help you understand the FILTER function, which is the heart of what I gave you. The first is an excellent YouTube video which features a Microsoft employee (who occasionally makes an appearance on these pages) introducing the function at a meeting: https://www.youtube.com/watch?v=9I9DtFOVPIg
The other is a website that gives helpful explanations with examples that you can study at your leisure: