question

MohdAnsari-7872 avatar image
0 Votes"
MohdAnsari-7872 asked erinding-msft edited

How to show employee name and place by current date in excel

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.

office-excel-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MohdAnsari-7872

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

1 Vote 1 ·

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.

0 Votes 0 ·
MohdAnsari-7872 avatar image
0 Votes"
MohdAnsari-7872 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft edited

Hi @MohdAnsari-7872

To my understanding, you may use PivotTable in Insert tab.
I create a sample.
103825-test.gif
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.


test.gif (825.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

tandat-7389 avatar image
0 Votes"
tandat-7389 answered tandat-7389 edited

@ erinding-msft

Thanks for your understanding.


103825-test.gif (825.6 KiB)
suimaoga.pdf (316.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.