Filter Data To Only Show Values That Appear Once

[AptGardener24]

Hi, I have data where “order numbers” can be repeated for multiple rows. I am trying to filter so that only rows with non-repeated “order numbers” will be included in the data set for tables, pivot tables, graphs, etc. I was thinking that an approach would be to create a calculated field that shows “TRUE” or “FALSE”, and then use that as a filter, but I can’t figure out how to do this.

Thank you!

I accomplished this in google sheets with (I know this may not be the best way to do this either). 

=FILTER('Raw Data'!B:B, COUNTIF('Raw Data'!B:B, 'Raw Data'!B:B)=1)

Thank you!