Recent content by binoyfalcon

Thank you.... It's working

office proffessional Plus 2013

=MAXIFS(Data!H2:H9,Data!A2:A9,Report!B1) this is not working. 1. Select Emp No. 2. Choose the Item 3 cell B6 - Last date of the Item issued to this Employee - 16617.

Thank you, I choose one Emp. (Employee No.) and select one item from dropdown list, which date we issued the selected item for the Employee (Emp No.)

Thank you for your support. In report sheet i choose one Emp. no and select one item from drop down list, last date of the selected issued. in B6:B9

In report sheet I select Employee No. & select one Item drop down list , need last date of the item issued to the Emplyee 16617.

Dear Experts, Thanks for the help in advance. Attached is the document for support. REPORT SHEET - I need last issued selected item for the Employee.

Dear vletm, More than 100 employees and need yearly report,(01/01/2023 to 31/12/2023) (the out put sheet is an example)

Sorry vletm, Thank you for your help, but this is for my senior, he collect all the datas from us

Dear Masters, I have two sheets report, i want final out put collect the text ( SL, A ) from sheet admin 2 to admin 1 Thank you

DEAR VLETM..... THANK YOU VERY MUCH.... :)

I tried to filter the data but its not filter properly , enter the start date and end date, output generate between the start and end date

Dear vletm, Thank you very much for your kind support. Its work perfectly. can i get the output data with monthly wise selection..

Why do You want that names are in rows and 'date's are in columns? im fine with it either way

I CHANGED THE FORMAT TEXT TO DATE, AND THE COLOUR . I need the master In & Out report for each employees in a month