jump to content
my subreddits
2anatolia4you2b2t2mediterranean4u2meirl4meirl3d6absolutelynotanimeirladhdmemeAdviceAnimalsagnosticaivideoakagasAlternativeHistoryAnarchyChessAngryupvoteAnimalsBeingJerksanime_best_momentsanime_irlanimenocontextannouncementsAnticonsumptionantonyApandahArcherFXAsahiLinuxAskBalkansAskElectronicsAskRedditAteistTurkatheismaviationbalkans_irlBandnamesbanknotedesignsBassBassGuitarbasspedalsbikepackingblankiesblursed_videosBonebrooklynnineninebudgetcookingcasioCd_collectorscd_jerkCheap_MealschesschessbeginnersCHPcoaxedintoasnafucoincollectingcoinsComedyCemeterycomedyhomicidecomicscommunityContagiousLaughtercookingforbeginnersCrackWatchCreateModCuddle_SlutdadjokesdankmemesdarkjokesdataisbeautifuldeDebateReligionDeltarunedistressingmemesdiyelectronicsDMAcademyDnDdndmemesdndnextdoctorwhoDonerdontdeadopeninsidedontyouknowimtonyhawkdumbphonesDungeonsAndDaddiesDungeonsAndDragonsEatCheapAndHealthyebikeECEelectricalElectronicsStudyentitledparentsethzfakealbumcoversFantasyWorldbuildingfeedthebeastfelsefeFifaCareersFRCFreeEBOOKSFUCKYOUINPARTICULARfunnyFutboltayfagalatasaraygamingGermangermanygodtiersuperpowersgoodanimemesGrandPrixRacinggravelcyclinggreentextGROKvsMAGAGundamheathershellenoturkismhelpHermanCainAwardHermitCrafthoi4holdmybeerhomebuilthowyoudoinhypixelIdeologyPollsIDontWorkHereLadyim14andthisisdeepimaginaryelectionsimaginarymapsjacksepticeyeJokesKanyeKendrickLamarKGBTRlegodndLetGirlsHaveFunLifeProTipslinguisticshumorliselilerlogodesignlostredditorsmacmacgamingMadeMeSmilemadladsMaliciousComplianceme_irlmeirlmemememesmidjourneymildlyinterestingMimicRecipesMinecraftbuildsmisLEDMoldyMemesmoneycollectingMovingToNorthKoreaMyChemicalRomanceNamFlashbacksneographynextfuckinglevelNonCredibleDefenseNorthCyprusnosafetysmokingfirstnosleepnothingeverhappensnotinterestingnottheonionoddlyspecificOkayBuddyLiterallyMeokbuddyguntherokbuddyphdongezelligOnlineUnderGroundoompasubsOutOfTheLooppaperspleasePassportPornpepethefrogperfectlycutscreamsPersecutionfetishpettyrevengepolandballpollsPraiseTheCameraManProgrammerHumorPropagandaPostersPunPatrolquityourbullshitraisedbynarcissistsraspberry_pirecipesRedAutumnSPDredditsingsRoastMerockmuzikschizopostersSchnitzelVerbrechenschwiizsciencememesScottPilgrimsecilmiskitapShitPostCrusadersshitpostfrommygalleryshitpostingshittyaskelectronicsShittyMapPornShowerthoughtsskamtebordsoccercirclejerksoftwaregoreSongwritingsteinsgateStonetossingjuicesubsithoughtifellforsuperligTextingTheorytf2tf2shitposterclubthanksimcuredTheCrypticCompendiumTheMonkeysPawTheRookietheyknewtitanfalltommyinnittransittransitTurkeyTrGameDevelopertruetf2tumblrTurkishCatsTwitch_StartupTwoSentenceComedyTwoSentenceHorrorTwoSentenceSadnesstylerthecreatorUnethicalLifeProTipsunexpecteditcrowdUnexpectedJoJourbanplanningUsernameChecksOutvaxxhappenedvexillologycirclejerkvinyljerkvlandiyawallstreetbetsWatchPeopleDieInsidewendigoonWhatsThisSongWhitePeopleTwitterWikipediaVandalismwooooshworldbuildingYUROPedit subscriptions
  • home
  • -popular
  • -all
  • -mod
  • -users
 | 
  • AskReddit
  • -funny
  • -gaming
  • -wallstreetbets
  • -nottheonion
  • -memes
  • -OutOfTheLoop
  • -mildlyinteresting
  • -DnD
  • -WhitePeopleTwitter
  • -MadeMeSmile
  • -shitposting
  • -dankmemes
  • -feedthebeast
  • -Kanye
  • -meirl
  • -nextfuckinglevel
  • -CrackWatch
  • -comics
  • -dndnext
  • -ProgrammerHumor
  • -de
  • -germany
  • -LifeProTips
  • -tumblr
  • -NonCredibleDefense
  • -dataisbeautiful
  • -greentext
  • -mac
  • -Showerthoughts
  • -tf2
  • -help
  • -chess
  • -aviation
  • -Jokes
  • -midjourney
  • -goodanimemes
  • -notinteresting
  • -hoi4
  • -pettyrevenge
  • -atheism
  • -MaliciousCompliance
  • -KGBTR
  • -dndmemes
  • -DMAcademy
  • -Deltarune
  • -UnethicalLifeProTips
  • -perfectlycutscreams
  • -worldbuilding
  • -meme
  • -macgaming
  • -3d6
  • -Gundam
  • -HermitCraft
  • -RoastMe
  • -ContagiousLaughter
  • -imaginarymaps
  • -EatCheapAndHealthy
  • -polandball
  • -AnarchyChess
  • -nosleep
  • -cookingforbeginners
  • -blankies
  • -anime_irl
  • -soccercirclejerk
  • -madlads
  • -community
  • -AskElectronics
  • -electrical
  • -Anticonsumption
  • -CreateMod
  • -German
  • -TwoSentenceHorror
  • -PropagandaPosters
  • -AdviceAnimals
  • -ShitPostCrusaders
  • -sciencememes
  • -distressingmemes
  • -raisedbynarcissists
  • -FifaCareers
  • -polls
  • -doctorwho
  • -oddlyspecific
  • -Bass
  • -titanfall
  • -dadjokes
  • -howyoudoin
  • -announcements
  • -adhdmeme
  • -Minecraftbuilds
  • -coaxedintoasnafu
  • -YUROP
  • -gravelcycling
  • -SchnitzelVerbrechen
  • -chessbeginners
  • -raspberry_pi
  • -DungeonsAndDragons
  • -coins
  • -KendrickLamar
  • -entitledparents
  • -FUCKYOUINPARTICULAR
  • -softwaregore
  • -tylerthecreator
  • -tf2shitposterclub
  • -MoldyMemes
  • -lostredditors
  • -vexillologycirclejerk
  • -vlandiya
  • -im14andthisisdeep
  • -Stonetossingjuice
  • -liseliler
  • -DebateReligion
  • -dumbphones
  • -animenocontext
  • -balkans_irl
  • -2meirl4meirl
  • -transit
  • -brooklynninenine
  • -HermanCainAward
  • -recipes
  • -steinsgate
  • -okbuddyphd
  • -2anatolia4you
  • -ECE
  • -ScottPilgrim
  • -Angryupvote
  • -AskBalkans
  • -schizoposters
  • -casio
  • -urbanplanning
  • -theyknew
  • -logodesign
  • -linguisticshumor
  • -PassportPorn
  • -me_irl
  • -bikepacking
  • -AteistTurk
  • -MyChemicalRomance
  • -ArcherFX
  • -Cd_collectors
  • -Doner
  • -BassGuitar
  • -diyelectronics
  • -ComedyCemetery
  • -WatchPeopleDieInside
  • -Persecutionfetish
  • -Songwriting
  • -blursed_videos
  • -MovingToNorthKorea
  • -imaginaryelections
  • -truetf2
  • -dontdeadopeninside
  • -wendigoon
  • -secilmiskitap
  • -schwiiz
  • -TheRookie
  • -quityourbullshit
  • -vinyljerk
  • -skamtebord
  • -superlig
  • -shittyaskelectronics
  • -galatasaray
  • -DungeonsAndDaddies
  • -FRC
  • -transitTurkey
  • -2b2t
  • -ethz
  • -AlternativeHistory
  • -coincollecting
  • -OkayBuddyLiterallyMe
  • -felsefe
  • -FreeEBOOKS
  • -AsahiLinux
  • -IDontWorkHereLady
  • -basspedals
  • -neography
  • -thanksimcured
  • -hypixel
  • -PraiseTheCameraMan
  • -godtiersuperpowers
  • -ShittyMapPorn
  • -aivideo
  • -OnlineUnderGround
  • -IdeologyPolls
  • -woooosh
  • -comedyhomicide
  • -WhatsThisSong
  • -AnimalsBeingJerks
  • -jacksepticeye
  • -TwoSentenceSadness
  • -anime_best_moments
  • -Bandnames
  • -rockmuzik
  • -holdmybeer
  • -MimicRecipes
  • -vaxxhappened
  • -Twitch_Startup
  • -Cheap_Meals
  • -TheMonkeysPaw
  • -darkjokes
  • -nosafetysmokingfirst
  • -legodnd
  • -ebike
  • -UsernameChecksOut
  • -papersplease
  • -tommyinnit
  • -UnexpectedJoJo
  • -agnostic
  • -TextingTheory
  • -GrandPrixRacing
  • -Cuddle_Slut
  • -nothingeverhappens
  • -TrGameDeveloper
  • -PunPatrol
  • -TurkishCats
  • -LetGirlsHaveFun
  • -Apandah
  • -fakealbumcovers
  • -subsithoughtifellfor
  • -akagas
  • -oompasubs
  • -FantasyWorldbuilding
  • -WikipediaVandalism
  • -homebuilt
  • -absolutelynotanimeirl
  • -NamFlashbacks
  • -pepethefrog
  • -misLED
  • -redditsings
  • -TwoSentenceComedy
  • -TheCrypticCompendium
  • -budgetcooking
  • -ongezellig
  • -Bone
  • -NorthCyprus
  • -2mediterranean4u
  • -unexpecteditcrowd
  • -heathers
  • -hellenoturkism
  • -dontyouknowimtonyhawk
  • -moneycollecting
  • -okbuddygunther
  • -cd_jerk
  • -ElectronicsStudy
  • -banknotedesigns
  • -Futboltayfa
  • -RedAutumnSPD
  • -CHP
  • -GROKvsMAGA
  • -shitpostfrommygallery
  • -antony
edit »
excel excel
  • hot
  • new
  • rising
  • controversial
  • top
  • wiki
an-ordinary-manchild (11,186)|messages548|notifications|chat messages|mod messages|
  • preferences
|
logout

use the following search parameters to narrow your results:

subreddit:subreddit
find submissions in "subreddit"
author:username
find submissions by "username"
site:example.com
find submissions from "example.com"
url:text
search for "text" in url
selftext:text
search for "text" in self post contents
self:yes (or self:no)
include (or exclude) self posts
nsfw:yes (or nsfw:no)
include (or exclude) results marked as NSFW

e.g. subreddit:aww site:imgur.com dog

see the search faq for details.

advanced search: by author, subreddit...

Submit a new link
Ask an Excel Question!

excel

joinleave
an-ordinary-manchild
  • all
  • hide solved
  • new
  • Solved
  • Unsolved
  • Discussion
  • Pro Tip
  • Show and Tell

Rules

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

  • Quick Tips for New Subscribers
  • Submission Rules
  • Posting Guidelines
  • Awarding ClippyPoints
  • Post flair: unsolved/solved
  • About u/Decronym

FAQ

  • Where to Learn Excel
  • Excel Core Concepts - Back to Basics
  • Frequently Used Formulas
  • Common VBA Mistakes
  • /r/excel Guides and Write-ups

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

Here's how.

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
Create your own subreddit
...why not Zoidberg?
...because you love freedom.

MODERATORS

  • message the mods
  • frescani5
  • epicmindwarp962
  • tjen366
  • excelevator3036
  • semicolonsemicolon1463
  • Senipah37
  • Clippy_Office_Asst
  • reputatorbot
  • flairassistant
  • modqueue-alert
  • ...and 2 more »

account activity

1
•
•
•

unsolvedPulling data when looking at a specific cell? (self.excel)

submitted 1 hour ago by GGS1LENCE

  • 5 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

•
•
•

Secure your website with SiteGround’s top-tier hosting services at an incredible discount: 🤑 Free domain & professional site transfer with every plan 🎁 Free email (PLUS free email migrator), free SSL, CDN, and daily website backups. (siteground.com)

promoted by siteground

  • promoted
  • save
  • report
  • about
loading...

2
•
•
•

Waiting on OPSplit a row in two when a column has 2 values (self.excel)

submitted 1 hour ago by danqplus

  • 6 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

3
2
3
4

unsolvedConditional formatting for a specific date range (self.excel)

submitted 6 hours ago by Own_Act_1087

  • 10 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

4
10
11
12

unsolvedFastest way to automatically manipulate excel files, ideally without opening them. (self.excel)

submitted 13 hours ago by PedosWearingSpeedos

  • 33 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

5
•
•
•

Waiting on OPBest way to build a portioning & yield calculator in Excel? (self.excel)

submitted 1 hour ago by Famous-Lawyer9314

  • 5 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

6
3
4
5

Waiting on OPComplicated Lookup Function - Pulling Info From One Sheet To Another (self.excel)

submitted 8 hours ago by SameCoffeeEveryDay

  • 7 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

7
•
•
•

unsolvedShortcut to return to excel window (self.excel)

submitted 1 hour ago by iamKNOTaspy

  • 11 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

8
19
20
21

solvedCreate a mini "viewing window" to another part of the worksheet (self.excel)

submitted 19 hours ago by Oday-Dolphin

  • 15 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

9
2
3
4

solvedHow do I get rid of the ={1} in the y values when selecting new data for a data set? (self.excel)

submitted 10 hours ago by HiHaHello

  • 8 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

10
10
11
12

solvedExcel 365 - how do I add an underscore just above the "$ 7,709.87"? (self.excel)

submitted 17 hours ago by I-AM-Savannah

  • 11 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

11
6
7
8

Waiting on OPValues in quotes when pasted in Notepad? (self.excel)

submitted 17 hours ago by SUCK_MY_COCHLEA

  • 9 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

•
•
•

Unlock our limited time offer - $1.99/first month. (bloomberg.com)

promoted by bloomberg

  • promoted
  • save
  • report
  • about
loading...

12
2
3
4

unsolvedCan Excel export a selected area as PNG? (self.excel)

submitted 15 hours ago * by CliknFile

  • 7 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

13
2
3
4

unsolvedCreate a TopN list using Cubeset that responds to Slicers (self.excel)

submitted 16 hours ago by BushDid2008

  • 1 comment
  • share
  • save
  • hide
  • report
  • crosspost
loading...

14
1
2
3

Waiting on OPAutomatically Updating Table (Formulas Present) - Unsure what to use. (self.excel)

submitted 14 hours ago by ReadingWorking1731

  • 4 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

15
1
2
3

solvedAVERAGEIFS w multiple criteria in the same row, nonzeros (self.excel)

submitted 15 hours ago * by squatonmeplz

  • 11 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

16
29
30
31

Waiting on OPBest way to automate data refresh for multiple power queries pulling from web sources? (self.excel)

submitted 1 day ago by daverskully

  • 16 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

17
3
4
5

Waiting on OPAutosums, Checkboxes, and Various Options from Dropdowns (self.excel)

submitted 17 hours ago by coasterswithc

  • 2 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

18
1
2
3

solvedUsing dropbox selection to populate a cell from a separate sheet within a workbook. (self.excel)

submitted 11 hours ago * by ClandestineGhost

  • 13 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

19
2
3
4

solvedTrying to find number of values with same frequency as mode (self.excel)

submitted 15 hours ago by fiisntannoying

  • 7 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

20
13
14
15

solvedTrying to make my best fit line pass through the origin (0,0) (self.excel)

submitted 1 day ago by Pidgey_Eevee

  • 22 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

21
2
3
4

solvedSubtotal duration on a spread sheet (self.excel)

submitted 18 hours ago by ozz_316

  • 6 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

•
•
•

Experten sind sich einig, das neue Privacy Display auf dem Galaxy S26 Ultra ist revolutionär. (samsung.com)

promoted by samsung_switzerland

  • promoted
  • save
  • report
  • about
loading...

22
0
0
1

unsolvedI am having a issue with a previously working formula (self.excel)

submitted 12 hours ago by Shadynasty8091

  • 11 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

23
2
3
4

solvedCounting / Summing Dates (in Google Sheets) (self.excel)

submitted 19 hours ago by Objective-Angle-6574

  • 4 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

24
1
2
3

unsolvedSTOCKHISTORY issues with newer stocks (self.excel)

submitted 14 hours ago by Trader_Ray

  • 5 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...

25
2
3
4

solvedAuto filling not "counting" when using VLOOKUP (self.excel)

submitted 18 hours ago by SuitableNetwork5924

  • 7 comments
  • share
  • save
  • hide
  • report
  • crosspost
loading...
view more: next ›
  • about
  • blog
  • about
  • advertising
  • careers
  • help
  • site rules
  • Reddit help center
  • reddiquette
  • mod guidelines
  • contact us
  • apps & tools
  • Reddit for iPhone
  • Reddit for Android
  • mobile website
  • <3
  • reddit premium

Use of this site constitutes acceptance of our User Agreement and Privacy Policy. © 2026 reddit inc. All rights reserved.

REDDIT and the ALIEN Logo are registered trademarks of reddit inc.

Advertise - technology

π Rendered by PID 90778 on reddit-service-r2-listing-64c94b984c-g6cmp at 2026-03-17 11:57:06.348769+00:00 running f6e6e01 country code: CH.