•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How Else to Best Showcase Reddit Data?
Our take
Showcasing your Reddit data effectively can enhance your understanding of engagement and trends in your comments. By logging your comments and tracking their upvotes, you’ve already created a solid foundation for analysis. Beyond pivot tables and sorting, consider visualizing your data with charts to illustrate trends over time or comparisons between subreddits. Additionally, implementing VBA could help automate data updates or create interactive dashboards. Explore these options to further transform your insights into compelling narratives that highlight your Reddit journey and engagement.
Since the inception of my Reddit account, I’ve been logging my comments as a way of tracking my Karma.
Don’t ask why - I have nothing else going in my life! I don’t particularly do posts and 95% of my karma is derived from silly, witty comments. I’ve just been rather fortunate for some of them to just blow up in terms of upvote count.
I only count comments with upvotes of 2 or more and naturally, there is a disparity between my Reddit upvotes and my Excel sheet as Reddit also takes into account downvotes - I’m not really concerned about this.
I capture the following information on a weekly basis: (Year, Month, Sub, Upvote & Comment).
I’m currently using a Pivot Table to summarise this information by month & sub. and another table which mirrors the raw data except it’s SORTed by upvote count so I can see the comments by upvotes. This sheet also has conditional formatting based on the year so I can see which year I was most “productive”!
With the above information, how else can I best use Excel to showcase this data?
I was thinking of implementing VBA, but I wouldn’t know where to apply this!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Fill out a ranking using data from other pagesHi everyone, I'm not a particularly frequent excel user, and I'm making a silly spreadsheet documenting the reviews my Australian friend is giving to British crisps. Each crisp has a picture on the home page, which when clicked takes you to the individual review of the crisp. She has ranked each crisp with different categories and given it an overall rating. I would love for each "overall rating" to go to a final page on the spreadsheet which shows all the crisps in ranking order. Now, of course I could just go through and type them in, changing them each time she reviews a new crisp, but is there a way excel can take this information with a formula? For example, on each individual crisps page the overall rating is cell D8. If a quaver was rated 8.5, a pombear was rated 6 and a mini cheddar was rated 7, could excel automatically put them in order of quaver, mini cheddar, pombear on my final ranking page? I appreciate this is a very long winded way of getting it across but it's a bit niche and so I wanted to try and make it clear! (It's much easier to just show someone a video of the spreadsheet but I don't think I can do that here!) Thanks!! submitted by /u/puzzled_puzzler12 [link] [comments]
- This Week's /r/Excel Recap for the week of March 21 - March 27, 2026Saturday, March 21 - Friday, March 27, 2026 Top 5 Posts score comments title & link 52 21 comments [unsolved] I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it? 19 2 comments [Discussion] Excel supports nested arrays in cards / rich data field (A1.myArray) 15 19 comments [solved] Is there a better alternative to grouped rows? 12 18 comments [unsolved] Filter only select duplicates 7 8 comments [unsolved] I want to have the ability to track my workouts by recording results in a spreadsheet. Unsolved Posts score comments title & link 2 8 comments [unsolved] I am averaging multiple rows and not all rows have data. I want to apply that result to all rows. Picture attached. 2 8 comments [unsolved] Is there a formula to reverse-scored 2 9 comments [unsolved] Excel vba double checker 2 0 comments [unsolved] How to reset overlapping chart label positioning on each refresh / with slicer use? Top 5 Comments score comment 503 /u/basejester said =FILTER(jobs[job name],jobs[allowsModernExcel]) 410 /u/randomcharacters3 said https://preview.redd.it/jzo7selzx6rg1.jpeg?width=553&format=pjpg&auto=webp&s=7c46b7f1d16a33d0a8ea967c1cf724c890857746 374 /u/rakshala said honestly, giving up and asking the internet for help has been the solution for me a few times. Not that the internet had the answer, but that the second I hit submit to publicize my stupidity, the ans... 365 /u/smcutterco said Power Query 235 /u/DarekKa said That XLOOKUP can return another XLOOKUP if #N/A is the result. i.e. XLOOKUP(Value, ARRAY1, ARRAY2, XLOOKUP(VALUE,ARRAY1, ARRAY3)). No need for IFERROR or other IFs submitted by /u/subredditsummarybot [link] [comments]
- Proper maintenance of game activity tableI'm part of a team of a rather small hobby game that we've been running for many years now. We've been running simple activity summaries in hours spent like this monthly, ever since beginning in April 2017. They simply go like this: GM Matt - 65.7h M Aiden - 54.3h K Hawk - 32.1h K Tell - 30.0h M Poe - 27.6h T Tribux - 25.4h M Vair - 24.5h K Rodian - 23.3h K Eventide - 20.1h T Crab - 14.4h M Voss- 14.3h M Teir - 9.1h M Vallin - 4.4h T Forrte - 0.5h They're posted monthly so there are similar tables for May 2017, June 2017 and so forth up to April 2026. I want to start storing them all in Excel, this is what I did so far: https://preview.redd.it/n9oem7xh2zug1.png?width=1529&format=png&auto=webp&s=95855988839af802d4d6830df3996943eecdc85f The sum part for each year is simply: =SUM(D3:L3) and so on. Then there's a final column "ALLTIME" where I sum everything to the left except the columns with yearly sums. This works so far, but I'm wondering if there's a better approach that's gonna be more comfortable in the future if I want to extract more data. I have zero experience with data management and Excel, this is what came intuitively to me, but I want to know if there isn't something that will bite me in the ass in the future. submitted by /u/Informal-Ordinary387 [link] [comments]
- This Week's /r/Excel Recap for the week of April 11 - April 17, 2026Saturday, April 11 - Friday, April 17, 2026 Top 5 Posts score comments title & link 82 22 comments [Pro Tip] Get more from Power Query in Excel with these little-known capabilities 33 48 comments [solved] How to anonymize user names in a data set 16 17 comments [solved] Populate Cells From a Random Range of Cells, Based on the Contents of Different Cells. 12 8 comments [solved] Formula for vlookup + text or text + vlookup 9 11 comments [unsolved] Search Bar thats acts like a Slicer Unsolved Posts score comments title & link 3 7 comments [unsolved] Weird Excel double-decimal places Top 5 Comments score comment 81 /u/Normalitie said Try SUM(C.:.C) Note the periods before and after the colon, this causes Excel to omit blank rows above and below the data. 55 /u/bradland said This is good stuff for PQ in general, but I find it a bit odd that it is titled "Get more from Power Query in Excel" and then kicks off the conversation with Parameters. Parameters I almost ne... 53 /u/downtownjerm said Are the exports the same every time? It’s not pretty but you could set up a template with lookups to pull the data into a cleaner view. Then when you export the files just paste over the previous data... 32 /u/reggydavis said While the formats may vary bank to bank, each bank should be the same output every month. You’re going to need to build an individual power query for each bank in the format you want. 27 /u/AlgoDip said Guess you won’t be using it for much longer then submitted by /u/subredditsummarybot [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#Excel compatibility#Excel alternatives#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#financial modeling with spreadsheets#rows.com#natural language processing for spreadsheets#cloud-based spreadsheet applications#Reddit#Excel#Karma