I want to get Employee name and his error type like fatel or non current by a previous date. It should show in tabular form dynamically.
I want to get Employee name and his error type like fatel or non current by a previous date. It should show in tabular form dynamically.
LOL. Who's going to figure out what your setup is + what you exactly mean with "error type"...
And, re. It should show in tabular form dynamically. Do you run Excel 365/Online?
Suggestion is you post:
1) A picture showing your actual spreasheet/Table setup
or even better upload & share a workbook with representative (w/o confidential) data
2) A picture showing a few expected results
And confirm the version of Excel in use + Windows or Mac
Hi @MohdAnsari-7872
Please check Lz-3068's reply. To better troubleshoot your issue, it would be better to provide more information.
Thanks for your understanding.
Any updates, please let us know.
I want to display Employee Name and residence city by year.
Like We want names of employee leaving in cities of Florida State current year.
I tried to get result using Filter Function but it displayed all columns of the table instead of showing only names and City
To my understanding, you may use PivotTable in Insert tab.
I create a sample.
Any updates, please let me know.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@ erinding-msft
Thanks for your understanding.
5 people are following this question.