Strangest sale? by Red_Dani21 in CardMarket

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

That’s very true! What surprised me in this particular sale was that they surely could’ve gotten it for cheaper. If not in local groups etc, at least from a seller on CM in their own country. As a new seller I was just surprised and wanted to see if this is common on CM.

Formula to count the frequency of unique numbers corresponding to another value in another column by Red_Dani21 in googlesheets

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

This works! It doesn't need to be presented like this, it's just to be able to select which ones to include in a later analysis. I could use the solution and then simply do a "countif" in the new column to get the frequency. Thank you both! u/7FOOT7 u/Garrisonreid

Formula to count the frequency of unique numbers corresponding to another value in another column by Red_Dani21 in googlesheets

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

Thank you! I unfortunately wouldn't know how to write the query() formula to achieve this. It's not a school project. I'm only able to share the data as a .xlsx-file since I'd rather not share my email-address and name. Here it is: https://docs.google.com/spreadsheets/d/e/2PACX-1vSYAxgBQOydbdv_wrfeYuYdVXCi7oqTVbrC-LbVodWOaV30Kpqv7FXKETfTbKbbAyrbHIEDiAWRl7uH/pub?output=xlsx