List Table Data Unique Part Numbers Matching Technician to Tab Name

Hello,

I have a sheet named "All Part Numbers" that contains the source information. What I would like to do is to list the table data (all 5 columns) on the other sheet tabs that apply to the specific Technician.

But is it also possible to have only unique Part Numbers for these sheets?

I appreciate any help on how to accomplish this.

Thank you very much for your help in advance,

BS

Hello,

I think with this formula you can filter, just change the name of the technician.
=(FILTER(Table134,Table134[Technician]="Xenobia Harvey"))

But for the only unique part numbers, there are several part numbers that appear for different AFR Number.
This unique list is not going to include the AFR Number?

I thank you very much for help.

What the objective is to list unique parts that each technician has worked on.

Excellent suggestions as always on here. What a gem this forum is.

First define a name, the name is shtname, and placement the formula is =REPLACE(GET.DOCUMENT(1),1,FIND("]",GET.DOCUMENT(1)),)&T(NOW())

cell B4 formula , then copy to next TAB Cell B4 and so on

Formula:

Please Login or Register  to view this content.

Once again a wonderful source of help. Keep up the fantastic support!

@BillySpivy You're Welcome. Glad to help . Thank You for the feedback