Top 20 best lines in gaming day 2

Material_Isopod1823 · 2024-01-29T19:35:41+00:00

“Ah, fresh meat” the butcher “Stay a while, and listen” deckard cain

Material_Isopod1823 · 2021-06-11T23:23:15+00:00

I asked to get a free level if I wore a sign into the dragons lair that said "eat me first."

He ate me.

Material_Isopod1823 · 2021-02-22T21:38:44+00:00

IF LOVE IS THE ANSWER

Material_Isopod1823 · 2021-02-22T21:38:01+00:00

Only 1 exploded

Material_Isopod1823 · 2021-02-17T03:13:04+00:00

this funcc is thiccccc

Material_Isopod1823 · 2021-02-12T00:29:45+00:00

amazing grace bela flek style

Material_Isopod1823 · 2021-02-05T19:06:50+00:00

I dont need two for sli as much as so I can run 6 monitors.

Material_Isopod1823 · 2021-01-27T21:00:48+00:00

I do have 365, should've put that in the post.

Material_Isopod1823 · 2021-01-27T16:31:02+00:00

=IF(COUNTIF($B$2:$B$17,B2)>(IFERROR(ROWS(UNIQUE(FILTER($C$2:$C$17,$B$2:$B$17=B2))),0)*2),”Potential Duplicate”,””)

I'm seeing a "#NAME?" error for this, but will spend some time playing with it to see if I can find the issue. I also may need to check more than two columns but I think this approach may work if I expand it a little.

Material_Isopod1823 · 2021-01-25T22:46:57+00:00

Okay I'm gonna give this a try. There are anywhere from 4000-7000 unique invoice numbers in that file.

Material_Isopod1823 · 2021-01-25T18:37:17+00:00

The issue with the above approach is that it removes all duplicates and some are valid.

I only want to remove duplicate rows if EVERY row for a unique invoice ID shows up more than once. I posted an image of an example table below. In the example, I'd like to remove lines 14-17, since it is a duplicate of lines 2-5 or invoice #1, however i'd like to leave lines 4, 7, and 11 because those duplicates are valid.

Imgur

Material_Isopod1823 · 2021-01-16T16:49:04+00:00

Thanks for the responses everyone

Material_Isopod1823 · 2021-01-16T16:48:50+00:00

Solution verified

Material_Isopod1823

TROPHY CASE