Filter data, do i need all cells filed?

Hi,

Yes, all the cells have to be filled.

Here is a link on how to quickly fill them in:

https://www.extendoffice.com/documen...lue-above.html

Cheers

Select columns A to D by clicking on the column identifying letters, then click on Data | Filter. You will find all your names listed in the filter drop-down for column D, and for the other columns you will have the values followed by (Blanks) in the drop-down list.

For future reference, here's how to attach a file to one of your posts:

Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Note that the Paperclip icon does not work.

Hope this helps.

Pete

Thank you for fast reply. Since there is no filtering without filling all data, is there, maybe, a macro which searches names and then shows rest of data.
Let me explain a bit closer. In column "job description" jobs arent explained in 1 word. Sometimes i have a lot of text there, around 20 rows in some, thats why i cant fill all cells with data like that, cause table would be, in that case, very nontransparent and bad. My boss needs to find the laziest/ the most hardworking employee and their current jobs/sectors/subsector.

You can do it like in the attached file. I've set up a data validation drop-down in cell J2 (coloured yellow) so that you can choose the employee you are interested in from the drop-down. This formula in G2:

=IF($J2="","",LOOKUP("zzzz",A2:INDEX(A:A,MATCH($J2,$D:$D,0))))

can be copied into H2 and I2, and these bring the appropriate fields across (i.e. the last-entered item in those columns for that person). Just change the name in J2 to see it in operation.

Hope this helps.

Pete