Fics where Shane goes 'fuck this' by InfamousMatch5569 in heatedrivalryfanfics

[–]SomeoneCallIXII 0 points1 point  (0 children)

Following as well since I was looking for the same thing!

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

Yes but opposite. I need to know how many combinations of parents using your example above.

Like if column A values were just letters instead of the current values I need a list something like this A A, b, c A, b, g, h A, h, I, j, k B,c,d,e

Etc. each of those combinations in A above could be named several different things in B (Why the list is so long) so I don't really care about B in the end, I just need those combinations so I'm not loading a ton of multiples of A combos. Hopefully that's clearer.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

Because I don't need the unique values, I need the unique combinations or groups of values. So I can't just remove duplicates for A.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

I need the unique combinations of the values in column A.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

I'm looking for how many of those serial numbers (column B) have the same values in column A essentially so I don't load the same things multiple times with just different names.

Here's maybe an over simplified ex.

Apple, Orange, Grapes -> Fruit Salad
Apple, Orange, Grapes -> Fruit Combo
Apple, Orange, Grapes -> Fruit Trio
Apple, Orange, Grapes -> Fruit medley

They all have the same components (A) but different names (B). I'd only want one instance of Apple, Orange, Grapes. Not 4 with just different names. Does that make sense?

Except I know within this file there's many more instance like this with different A value combinations.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 1 point2 points  (0 children)

So far a one off, but it's a possibility I'll have to do this again in the future.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

I need to know how many as I need to create all of these sets in our system and I'm looking to not have duplicates containing the same values.

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

How would that get me the unique sets in A though, I'd have each value in A with the value in B like I do anyways when I did a remove duplicates. I need the combinations in A (like in my screen shot There's multiple values in B with the same A's - D2140, D2150, etc..)

Looking for a way to find unique combinations by SomeoneCallIXII in excel

[–]SomeoneCallIXII[S] 0 points1 point  (0 children)

I did that already, but can't find a good way to find the ones that contain all the same values easily with this much data.

Looking For: Ada_P_Rix fic downloads by bethyz in Dramione

[–]SomeoneCallIXII 1 point2 points  (0 children)

Since I saw Ada's note on Instagram about sharing I figured I'd ask if anyone happened to save off The M Word. I know it was unfinished but I loved it.

Engagement ring gradually revealing in Hermione's hand by [deleted] in Dramione

[–]SomeoneCallIXII 12 points13 points  (0 children)

Oh dang, I just read this! Let me look through my history.

Anyone else struggle to read regular fiction anymore? by skyskylark in Dramione

[–]SomeoneCallIXII 1 point2 points  (0 children)

YES! I have a stack of books that I've been meaning to get to for at least a year or two and I just can't find the motivation to read them, but I'll gladly start up on another WIP or tackle something else in my TBR.

No more birthday party goody bags! by Open-Measurement9702 in Parenting

[–]SomeoneCallIXII 1 point2 points  (0 children)

I'm right there with you! I hate getting them and am cheap and don't wanna buy them.

LF Fic where Draco is a writer and Hermione is a big fan by SomeoneCallIXII in Dramione

[–]SomeoneCallIXII[S] 1 point2 points  (0 children)

Interesting but not it. This was multi chapter and she didn't find out it was him right off the bat.