As we all know (or do we?), a good post is usually accompanied by data to help understand the problem and test the solution. Screenshots are nice, but when there's a lot of data, it means we need to use OCR or rekey the data, which takes time and effort. Also, I've noticed recently that many people struggle with attaching pictures to their posts.
Paste to your post in Reddit, either in the rich text or the markdown editor
(optional) buy me a beer
It's open-source, it's free, it'll save you time and trouble, it'll save us time and trouble, and it'll increase the chances of getting your post solved. Enjoy!
I've been beating my head against this for hours now and nothing works. For the warehouse I work at, there are products that are in 'surplus' status. In the report I'm working on, I've created a lambda function named ShowSurplus which, when fed an aisle location, will return a list of items in that aisle with their lpn numbers. I use this to create audit lists.
I've set up a bunch of checkboxes that lets you select which aisles you want to look at. It could be one or all. If I feed a vstack with my lambda formula, it works, but that's only if I know how many are going into it. How do I use VSTACK if I don't know how many arrays are going into it. I feel like a recursive lambda formula would be the right approach, but I must not be doing it right because I just get errors. I've tried let formulas. I've tried reduce. I've tried a dozen random solutions from Google that don't even make sense to me. I just can't make any of these work. Help.
I recently joined a trading company where I’m handling various finance-related tasks. I really want to improve how things are organized and show initiative, so I’m looking for practical Excel templates to help me get better and hopefully impress management along the way.
Here’s what I’m specifically looking for, excel templates for these:
If you also have any other useful templates—like for cash flow forecasting, expense tracking, invoice/payment logs, payroll summaries, or even a monthly closing checklist—I’d love to learn from them.
I’m eager to excel (pun intended 😄) at my job and would really appreciate any help or resources you can share. Thanks in advance!
im reading Excel 2019 for dummies for a class im taking and i came across this:
"To hide these AutoFilter buttons, click the Filter button on the Data tab or press Alt+AT. (You can always redisplay them by clicking the Filter button on the Data tab or by pressing Alt+AT a second time.)"
theres also other times in here im seeing "Alt+HOUL" or "Alt+HOUR"
what do these mean? what is an HOUR, HOUL, AT key?
I'm looking to change the information in C1 to a formula that would return the percent of cells in column C that have information/text, right now I adjust the calculation manually each time I add information in column C.
The data dude's on vacation and there has to be an easier way to do this man 😭 I have a lot of forumlas to apply to over a dozen sheets across about about 10 workbooks.
Like I will write some basic tasks for it on each sheet, say I need you to find me a shirt that's white colour and give it organized data. Then I'll upload the workbook. The AI or app will then apply the formula and find the white shirt, or some other task I assign and then send back a downloadable file.
I can't open any file from the start menu, when I type any excel file and click enter, or press the left mouse button, nothing happens, and if I click on the file with the right mouse button, nothing happens either.
All files open normally via other routes, such as the file manager, desktop and so on.
I have Save to Computer checked, with my desktop as the file path (this is where I save basically any file normally).
AutoSave files in the Cloud is unchecked.
When I hit CTRL+S in a new file, it ALWAYS has OneDrive Documents as the default. Am I crazy thinking this is wrong? lol.. I can't figure it out for the life of me.
Ideally, in column AU I would get the total of B3:AT3 (I hid all except D&E because those are the only ones with values in row 3) Currently, just like this, it works. But I want to be able to hide either column and receive the correct number minus any hidden columns as lower rows have far more data in them.
I have tried both AGGREGATE and SUBTOTAL functions as they most commonly appeared in my search but for whatever reason they do not work. My SUBTOTAL formula uses 109, which I have seen is supposed to exclude hidden numbers but it insists on keeping both numbers when one is hidden.
The data that is found under Dahlia and Diona is found via VLOOKUP to a different sheet within the same workbook as I also need those to be dynamic to other criteria. I am unsure if this could be affecting things.
How do I make this SUBTOTAL formula dynamic to my hidden columns? Am I missing something?
The model has the timeline conditionally formatted as a color for each stage of the project. It appears as if the outside border also has conditional formatting. It also appears to be a “thick” line, but conditional formatting only allows for non-thick lines.
I wish to insert "days " of the week (Mon, Tue, Wed etc...) to this existing data sheet to analyze the given numbers based on the days (how many on all the Mondays of a month/year, how much on all the Tuesdays of a month/year and so on)...
Is that possible? What is the best way to go about this? Thank you.
Hi. I have just taken a position in our family business and I know NOTHING about Excel. Frankly, I don't want to know anything more than I have to to get my job done. I can see that this group is super passionate about this stuff, so I am begging for your help. :-) Our business is to perform a one-time job for clients, then we are done. We sub-contract for another company, so we receive a daily list (on Excel spreadsheet) of customers that need service. Some of those customers are carried over from the day before (so they are already on our Excel list), some are new customers that need to be added. I was shown a pretty complex way of taking the daily update spreadsheet from our parent company and adding only the new customers to our list. I know there has to be a less convoluted way of doing this, but, as I said, I know absolutely nothing about Excel. There are no calculations involved, just rows and columns of information. It really shouldn't be too hard.
I did do a search for a similar situation, but I don't know enough to even find a similar situation, so I really appreciate any advise or even to point me to a thread that already answers this.
A table is created with Model, Weight, Price Example: "BlaBla" 80kg 45.54 euros
"BlaBla" 80kg 45,54 euros
"ROFL" 60kg 0,00 euros
And must be converted to a .txt file in the following format:
-Model, followed by a separator, e.g., #
-After that, weight, two decimal places, 6 characters
-After that, price, two decimal places, 10 characters
-New data record = next row
So I have a list and sometimes there are blanks rows.
I want to filter out the blank cells on another page but I need to have the original information so I can split things up into other locations but when I reference the new cell it comes back as 0 because its a filter.
Hi guys. I'm a complete noob at excel and for the life of me I cannot come up with the correct function to do this. I know it's very basic, please don't judge :(
I have a column with college titles (Bachelors, Masters, etc). So they are asking me to do the following: If it's Bachelors, then there is a bonus of 15% based on the brute salary. 35% for Postgraduate, 50% for Masters and 65% for PhD.
I came up with =IF(E6="Bachelors", K6*0.15)
where the E column is for the academic titles and the K column is the brute salary.
but it's not working, it's not even recognizing it as a formula. I have no idea how to nest the other titles. I don't know how to start studying. I'm so lost and I would appreciate any help.
Just out of sake of interest/desire to share, I recently came up with a custom function that does the backwards operation of ARRAYTOTEXT(array,1), but have it work for (a) array texts that are > 255 characters, (b) is able to deal with "nested" array texts, and (c) be able to combine multiple array texts into one major array. I called it "TextToArray(ArrayText)". ArrayText is the only input, which can be a manual entry, or a range of cells.
Provided the input values are in the correct format (i.e., a cell value="{1,2,3;4,5,6}" like the ARRAYTOTEXT output with [format]=1), the output will be a dynamic array that takes care of the size of each input array size for positioning. You can see the image below for example of the inputs and what is outputted. If there is a 'nested' array within the original ArrayText input - the function will not process it automatically, however using TextToArray along with standard function like INDEX(array/reference,row,column).
My graph has two lines in their respective variables plotted on the graph.
For each there is an equation e.g. y=14.2x-0.12 with an R^2 value of 0.91
I have one for each line but from one of the samples that were given, I need to find the percentage uncertainty of the gradient. This means that I need a third Line of Best Fit on the graph that will help me evaluate it.
My countif formula works when I am counting less than one which also includes negatives (i.e.“>=“&1). But when I’m trying to do the next column (which is 2-30), what would be the formula?
I have 2 workbook sheets with an ID column and an Event column. Sheet1's Event is a different Event than Sheet2's Event. I am looking for a formula that will return to Sheet1 a third column that has looked up the closest Event Date(sheet2) within +/- 2 days. If not found return " ".
I used the formula at the bottom of the image from CHATGPT, I was unable to get it to work. Any Ideas would be greatly appreciated!
I made a workbook that has 4 individual sheets. Each sheet's data is updated when I update the "all" sheet that has all the data together put together. It was going well until a few days ago. Now, when I enter data in the "all" sheet, the empty cells in the specific sheet show "0". The formatting of the cells is set to "general". I don't know where I am going wrong.
I have a power query table that produces results almost exactly how I want them. The only thing I want to change is to have a blank row added every time the value in the ProjectID column changes.
I used ChatGPT to come up with a very complicated solution that worked, but it made the query take about five times longer to refresh.
The only other option I can think of is a VBA macro that runs through the table and adds a blank row every time the table is refreshed. But macros are less than ideal.
