yogi_Pull Data For Only First Instance Of Entities In Column E Of Sheet 'Upload.OP'

Google Spreadsheet   Post  #2565

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-03-2019

question by: DennBA:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/A3Q2FTvK0vc;context-place=forum/docs
How to who only one data of a kind (with filter)?

Hello,

can I only show one data of a kind and hide the other ones with the filter?

I made some screenshots, to explain it.

I want to hide the rows which are strikethrough in red. (Screenshot 1)

Which formula do I have to use in the filter? (Screenshot 2)

Thank you very much!

Dennis

Screenshot 1.png

270 KB

Screenshot 2.png

295 KB