How do I fill in a table by getting excel to look at the values in another table?1yr ⋅ The1DonCorleone ⋅ r/excel
How do I get the sum of my helper column Z without actually needing the column Z since it is just multiplying each row x * y and then adding all the rows up1yr ⋅ NaxeyOffman ⋅ r/excel
Just lost my VBA Virginity. Ok, baby steps and very first bit of writing VBA, but things can only get worse from here. Right? Btw. Tiger Spreadsheet Solutions has a baby steps set of videos.5yr ⋅ 60svintage ⋅ r/excel
Hi folks 👋🏼 My Dad hit an unknown button on his spreadsheet and now we have those weird level and filter tools on the sides. They are only on this document. How do we disable them?5yr ⋅ MessyMessenger ⋅ r/excel
I have typed multiple lists, is there any automatic way to have excel place every line into a different cell?5yr ⋅ 3STUDIOS ⋅ r/excel
Does anyone know how to get the text in the center of the doughnut chart like this one?5yr ⋅ mycatsnameisrosie ⋅ r/excel
How to replace asterisks with dots or bullets on the fly, rather than using Find & Replace afterwards. More detailed explanation in pic.5yr ⋅ lithium91w ⋅ r/excel
Inconsistent formula error is appearing, claiming it is not consistent with the column to the left5yr ⋅ WhenRedditFlies ⋅ r/excel
Can Excel Scan website and let you know if a word was found without you clicking on hyperlink. So I want to create an excel function that will scan a website without me having to click on the website and let me know if a key word is on the web page.5yr ⋅ JerryThompson2018 ⋅ r/excel
For the life of me I cannot understand why excel just stalls periodically with it launching from cold or from a file explorer.5yr ⋅ borse2008 ⋅ r/excel
Full on idiot question - sorry! (Used Excel for years, but I’ve never learned properly) I want to show projected costs (black line) and actual costs (blue line). Ideally with some formula behind it, to enter day rates and hours worked for several people. Is there an idiot’s guise on how to?5yr ⋅ _catchmeifyoucan_ ⋅ r/excel
Frames to timecode help! I have converted time code to frames, but am struggling with converting frames back into time code HOUR:MINUTE:SECOND:FRAMES. would anyone be able to figure out the formula for frames to time considering there's 24 frames per second?5yr ⋅ aymsmithers ⋅ r/excel
Hello all! Request: I want to obtain the minimum value on a row, excluding values that are less than 15yr ⋅ SantiagoCeb ⋅ r/excel
How do I apply a simple formula to a column that wont put a value in Column C when Column B is empty?5yr ⋅ Daisyahoy ⋅ r/excel
Hyperlink Email to Access PreMade Outlook Email Template. Basically I work in an industry where clients like updates to their email on a monthly basis (no kidding). So I thought this might save a lot of time instead of doing mail merge and all that fun stuff or using bcc.No mail merge solutions pls5yr ⋅ JerryThompson2018 ⋅ r/excel
Hey Reddit fam, need help with formula that isn’t behaving... formula used to reflect the appropriate addition of time to current system time. Just recently it is 1-2 hours off. File is locked so I know no one messed with it but I can’t figure it out.. any ideas?5yr ⋅ SenyorHefe ⋅ r/excel
Help *splitting* numbers into separate columns without typing them all out from what you see in column E to what you see in column G:I5yr ⋅ SuperHare96 ⋅ r/excel
Can I make a heatmap in excel using the coordinate system in this image as a reference to individual measurements tied to various points on the image?5yr ⋅ PotatoCasserole ⋅ r/excel
I'm Excel Certified and I completely blanked out today. Can someone point me in the right direction? How do I set up a function to create a time estimate to complete a certain task based on percent already complete?5yr ⋅ SEK494 ⋅ r/excel
Confused on what to use between VLOOKUP, INDEX and MATCH to return values from another section of a sheet5yr ⋅ MartyVanB ⋅ r/excel
Why two sheets with exact same margins/print settings etc are printing like this?5yr ⋅ recuiter ⋅ r/excel
Would like to automate this Excel Spreedsheet so I don't drive myself crazy by manually entering everything.5yr ⋅ Rherna8872 ⋅ r/excel
Does anyone know how to alter Gantt chart templates so they don’t use the top scroll bar?1yr ⋅ Shmusher3 ⋅ r/excel
For my cakeday, I, too, would like to share something that wouldn't have been possible without you guys. I got a lot of praise from my boss for this and I owe it to this community.11yr ⋅ ntotheewb ⋅ r/excel
How to hard input a date, such as 12/31/2018, and then link other cells to be 1,2,3, etc years older than that date?5yr ⋅ FondleMeh ⋅ r/excel
Help, how does one make it so one worksheet is used to assign values to certain codes and another worksheet is used to type only the codes and having a cell next to those autofilled with the assigned values from the other worksheet? I made a drawing to explain what I mean.5yr ⋅ BlackNair ⋅ r/excel
Check out this awesome 3D Maze in Excel! (Workbook and Tutorials in the comments)11yr ⋅ CaryWalkin ⋅ r/excel
Every time someone asks me for help with something really complicated at work...12yr ⋅ werfnort ⋅ r/excel
I just saw this guide to how to make tables on Reddit, and instantly thought of the usefulness it would have in this sub.12yr ⋅ Flm ⋅ r/excel
Thank you /r/excel! finally able to complete this little graph thanks to your help.11yr ⋅ SOLUNAR ⋅ r/excel
VLOOKUP Help. It keeps giving me an error and when it doesn't it gives me a whole different answer from what I want.5yr ⋅ Itz_Wally_ ⋅ r/excel
What would your plan be to separate these into columns? Text to columns isn't sophisticated enough it seems.11yr ⋅ porourke27 ⋅ r/excel
(request) How do I make it do text to columns with return as a delimiter?11yr ⋅ Authenticait ⋅ r/excel
Fun LOOKUP exercise I put together to teach some coworkers about flexible dataset searching: OFFSET(A1,MATCH,MATCH)12yr ⋅ CG_Ops ⋅ r/excel
How would I copy and paste formatted text so that the formatting becomes additional text?11yr ⋅ [deleted] ⋅ r/excel
How do you arrange your data and what kind of graph do you pick to end up with something like this?12yr ⋅ OkieNotRedneck ⋅ r/excel
I've spent a few weeks trying to figure out why this code does what it does. Is there anyone who'd be interested in breaking down this array formula so that I could ask some questions about it?11yr ⋅ [deleted] ⋅ r/excel
Anyone know why a chart would display differently on xp and windows 7 both running Office 2007 32 bit. And if there is a fix11yr ⋅ b3hr ⋅ r/excel
What formula will generate student Age from the Day/Month/Year columns in my spreadsheet? (Photo attached)12yr ⋅ RedditCraig ⋅ r/excel
Any idea why this isn't working? I've never been stumped by such a seemingly easy equation.11yr ⋅ capnShocker ⋅ r/excel
How do I do this using an excel formula/named range? (without using VBA)13yr ⋅ GeorgeVandalay ⋅ r/excel
Excel 2013 feature. How to disable this 'tool tip' looking feature?11yr ⋅ havanagilamonster ⋅ r/excel
How do you get the error checking notification box to not pop up over the top of the data you're trying to work on?12yr ⋅ elvendude ⋅ r/excel
What's this odd coloured part of the margin in my spreadsheet? I should be able to print in that area but I can't.11yr ⋅ NerdMachine ⋅ r/excel
Help with confusing IF statement...details in comment. ASAP if possible?11yr ⋅ showmeurOface ⋅ r/excel
Is there any way to have the # of cells in amount due equal the amount of payments due?11yr ⋅ makingmyownfun ⋅ r/excel
Need to tally a few columns with blanks into a single column. Probably very simple11yr ⋅ mambouli ⋅ r/excel
How can I make cells shade like this? I don't know how to program... Just need to use the toolbar!11yr ⋅ cyu12 ⋅ r/excel
Possible or not? Trying to create a pivot table with the following data.11yr ⋅ AcousticArmor ⋅ r/excel
I need help filling a repetitive formula into a chart like format. More in comments.11yr ⋅ DrPepperHelp ⋅ r/excel
Frustrating Excel problem - column chart putting two columns in front/on top of each other, not side-by-side. How to fix?12yr ⋅ DarkSideOfTheNuum ⋅ r/excel
Is there a 2003 VBA plugin that would enable expanding/collapsing sections like in VB 2010 Express?12yr ⋅ matt-ice ⋅ r/excel
when my company wants to roll out horrific spreadsheets to be maintained by the managers12yr ⋅ frescani ⋅ r/excel
I had NO idea Excel automatically did this by just selecting some cells. This is handy!14yr ⋅ mannyotr ⋅ r/excel
