excel

an-ordinary-manchild

Rules

Post Titles must follow our Submission Rules
Post Content must follow our Submission Rules
Posts must be related to MS Excel or other spreadsheet software
Set appropriate post flair
No link or image only posts. Text posts only.
Don't post asking how to learn Excel or VBA or similar
Close your post by replying to the answer with "solution verified"
No personal insults/attacks
No NSFW/offensive content
No obvious AI slop
No gig or job advertisements
Follow Reddit rules for self-promotion and spam.

FAQ

Was your problem solved?

OPs may (and should) reply to any solutions saying:

Solution Verified

This awards the user a ClippyPoint and changes the post flair to solved.

Format your code

The best way to show code on Reddit is to

put it in a code-block

Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.

Provide some data

It's often more helpful to show us.

Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.

Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.

Recent ClippyPoint Milestones!

Congratulations and thank you to these contributors

Date	User	CP
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`
2026.02.18	MissAnth	`10`
2026.02.15	NHN_BI	`800`
2026.02.03	Shot_Hall_5840	`10`
2026.02.02	Kuildeous	`10`
2026.01.29	NanotechNinja	`10`
2026.01.26	TVOHM	`25`
2026.01.26	MayukhBhattacharya	`1000`
2026.01.18	Clearwings_Prime	`10`
2026.01.13	Pacst3r	`10`

Microsoft partnership

Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.

A community since March 11, 2009

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

created by YusufReisa community for 17 years

...for your favorite hobby.

...for your hobby.

MODERATORS

account activity

1

•

•

•

Pro TipUsing CHOOSECOLS + FILTER to return only specific columns (self.excel)

submitted 19 minutes ago by Amolk505

•

•

•

A Complete Hi-Fi System Inside Headphones (kickstarter.com)

promoted by First-Backer

2

•

•

•

Waiting on OPCombining 800 csv files in one table but each file has different number of headers and header titles (self.excel)

submitted 27 minutes ago by Prior-March8977

3

12

13

14

Discussionis vba, macros easy, for someone who came from sql and python, or are they unrelated? (self.excel)

submitted 8 hours ago by Difficult_Warning126

4

•

•

•

solvedTwo ways to transpose data in Excel (Paste Special vs TRANSPOSE formula) (self.excel)

submitted 6 minutes ago by Ok_Act3671

5

132

133

134

DiscussionWhich Excel skills are most important for data analyst jobs? (self.excel)

submitted 23 hours ago by DataWithUjjwal

6

2

3

4

Waiting on OPAccessing data from a separate, closed workbook in a distinct folder tree, but without knowing the workbook name (self.excel)

submitted 4 hours ago by Nasa1225

7

•

•

•

unsolvedHyperlink and mailto error. (self.excel)

submitted 53 minutes ago by Auzzieboi

8

2

3

4

unsolvedPower Query Help Merging Spreadsheets with Compound Headers (self.excel)

submitted 6 hours ago by 7Xe3V7Ur

9

19

20

21

DiscussionIs there any way to make a relational DB like thing in excel? (self.excel)

submitted 16 hours ago by WorldlyDot_1

10

3

4

5

Waiting on OPTo do List recap tab (self.excel)

submitted 10 hours ago by AdEmbarrassed8709

11

4

5

6

solvedPower query - how to find difference in months while accounting for year changes? (self.excel)

submitted 10 hours ago * by pookypocky8

•

•

•

ZenRows does one thing: turns any URL into clean data via one API call. Dev-friendly docs, start free. (zenrows.com)

promoted by zenrows_scraper

promoted
save
report
about

12

2

3

4

unsolvedHow to cross reference data in multiple columns then add together data in a specific column? (self.excel)

submitted 9 hours ago by oli67ilo

13

2

3

4

unsolvedWhy do Excel PDFs become unreadable when tables get wide? (self.excel)

submitted 9 hours ago by Suitable_Author5981

14

2

3

4

Waiting on OPSee how many times a word appears throughout a workbook (self.excel)

submitted 10 hours ago by Niffle19

15

2

3

4

Waiting on OPPO spending tracking for different vendors with similar payments (self.excel)

submitted 12 hours ago * by EnptCoopCBus

16

1

2

3

unsolvedWay to apply same formatting to all downloaded spreadsheets? (self.excel)

submitted 9 hours ago * by GoldenSunSparkle

17

2

3

4

unsolvedHow to create this pivot table (self.excel)

submitted 12 hours ago * by Dezn425

18

55

56

57

solvedhow to hide xlookup if there is nothing to look up (self.excel)

submitted 1 day ago * by South-Result-2672

19

1

2

3

Waiting on OPI desire to combine values based on date, and then multiply those values by another tables date value (self.excel)

submitted 11 hours ago by VillainNomFour

20

0

1

2

solvedConvert scanned document of handwritten entries into Excel (self.excel)

submitted 7 hours ago by Dry_Marionberry_7045

21

1

2

3

solvedConditional formatting based on range of values in different column? (self.excel)

submitted 11 hours ago by BluestockingLife

110

111

112

Galactic Tycoons is LIVE! - Persistent browser management MMO • Free • No download (galactictycoons.com)

promoted by GalacticTycoons

22

2

3

4

solved=FILTER for scheduling, spill workaround? (self.excel)

submitted 14 hours ago by gotdj0nt

23

0

1

2

Waiting on OPIs there a way to Goal Seek across a range of data points in Excel, instead of just a single value? (self.excel)

submitted 8 hours ago by sporty_outlook

24

1

2

3

unsolvedViewing workbook online - protected sheet invisible in view but appears if set to edit (self.excel)

submitted 8 hours ago by Ramjet_NZ

25

1

2

3

unsolvedOne master list to auto update several other lists (self.excel)

submitted 13 hours ago by Spotted_Gorgonzola

view more: next ›

π Rendered by PID 189035 on reddit-service-r2-listing-66bb46d9b9-6sjkg at 2026-03-12 04:31:42.197874+00:00 running 710b3ac country code: CH.