I'm currently logging my Reddit comments (The votes specifically) onto a spreadsheet. As it stands, these are the columns, Count (This is mostly so there is some degree of order in which the comments appear as I don't log specific dates), Year, Month, Sub-Reddit, Votes & Comments. I want my default view for my raw data to be the order in which data is inputted as the count is there as a unique ID of sorts. It allows me to sort A-Z and the order there.
Whilst I'm not tracking specific dates (I don't deem it necessary), I'm nevertheless tracking Month & Year. This information is summarized onto a Pivot table with the Sub-Reddits being the rows, Columns being Month (I only made the account this year) and values being Sum of Votes. Personally, I find this to be quite insightful, but I want to take this further.
What I'd like is to be able to track the 10 highest (votes on comments) comments per Sub. Ideally, I'd like the subs being on the left (I've used UNIQUE in the attached), and the next columns consist of the comments as well the corresponding rating. However, I want this to be dynamic so as I'm updating the raw data, this is reflected in this table. I assume I can use XLOOKUP in some capacity to obtain the votes of the comment on the right, but how do I go about outputting the ranking of the comments by Sub-Reddit?
I hope this makes sense (!), but as per attached, there are 3 sheets. Raw Data, Pivot, & Top 10. Raw Data is missing the initial 3 columns as per above. Pivot is there as a BASIC illustration whereas Top 10 is the focus. The idea is that in column A, the unique Sub-Reddits are listed, in Columns C, E, G, etc ... would be comments which are top 3 (We'll expand to top 10) while columns B, D & F would be the respective votes for these comments. How do go I about acquiring the Top 3?
Regarding the attached, I've had to make a new document as I wasn't comfortable with sharing my account which is why it's stripped down. As mentioned, I've removed the first 3 columns from my Raw Data as I don't think they're relevant so the 3 columns in Raw Data in my attached are actually Columns D - F in my file. The pivot in the attached is nothing compared to how I have it my variant contains considerably more data which is categorized by Month. I didn't think it was necessary to go above and beyond for the Pivot. The comments in the attached were all made up for the sake of the this document. What you see in the Top 10 sheet is purely for illustration and I can always work on the design later.
I hope the above makes sense and I am more than happy to elaborate further!
Bookmarks