Comments
-
sorry my last comment was actually for @GrantSmith
-
Hi, this helped me ALOT too, thank you Grant! I have a very similar issue. However, when I use the formula given: MOD(DENSE_RANK() OVER (ORDER BY MAX(`User Pseudo ID`)), 2) my rows reduce to singular entries instead of showing each row entry to do with the Rank. So ie Apple, Apple, Apple, Carrot, Carrot, turns into just…