2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How Else to Best Showcase Reddit Data?

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!

submitted by /u/Sustainable_Twat
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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