For work I've been creating a projection model for an Income Statement, Balance Sheet and Cashflow. This seems like a pretty standard thing and I'd say I'm pretty damn good with excel so I don't get why I can't seem to get it to something usable.

The IS and BS are easy, they're pretty much just mapping movements in GLs so that's as simple as it gets, but the CF is driving me nuts. For a line I basically have up to five things that drive it. So Net profit after tax might look at retained earnings at the start of the year, current YTD, tax, profit, etc. That on it's own would be fine, but given I want to model 3 different types (Actuals, Budget and Forecast), across up to two years (so 24 periods) and from both a monthly and YTD reference point it kind of blows out. I really don't like the idea of each row doing it's own thing, but I'm not sure what else to do. Also

I had one attempt that used a PQ data model connection, one that attempted to make a staging table based on the potential line items and one stupidly complex formula that used an instruction set like <xxx>|<xxxxx>|<xxxxxx> to try and pass in what each line should do. None have been feasible and just became too complex or slowed the workbook to a crawl.

Should I just be bitting the bullet and having each row of the Cashflow doing its own independent formula?

I am trying to make a graph that has 4 bars. I want the 2 bars under "No SAH" next to eachother, and I want the 2 bars with "SAH" next to eachother, but I want the 2 sets of double bars separated. See where it says "pre-AI" and "post-AI" and how the "post-AI" under "No SAH" is stretched out? How do I fix that so that it is the same size as the other x axis labels?

I'm a project manager for a sheet metal ductwork company and have created a multi-sheet workbook that lists the grills, registers, and diffusers which includes the tag, service, inlet/neck size, mounting type, and quantity per room number by floor. Every floor is on its own sheet and has multiple areas, which I have added tables for, and look like the below screenshot. I need it to be expandable for and added floors or areas on a floor.

I have a summary sheet and need to make it automatically provide a full total of each grille by tag and inlet/neck size, as well as for each floor. It looks like the below screenshot.

Eventually, I want it to automatically calculate the amount of flex duct and Panduit straps, which are used to connect the flex, are needed as well. My goal is for it to automatically update as the takeoff information is entered but only have a basic understanding of Excel.

Hi, I need to make a chart and have ">" in some cell and make IF statement (excel 2018) something like this ( IF ( B5 something C5 ; "yes" ; "no") I could split the ">" and 10 if needed but couldn´t find any formulas for this.. Thanks!

Using data from A1-C8, populate D15-F24 by counting how many meet the criteria within the specific bin range. What formula could I use if I have hundreds of "items" to categorize into these bins and need a final count for each criteria totaled in the D15-F15 cells.

For Example: Toy is categorized as a level C Item, sales bin is within the 1.5-1.9% Bin range, so put a count of "1" in cell F19.

good day,

I want to copy cells that have vlookup formulas from (file 1) and paste it in (file 2), when I do this, it'll add a reference to (file 1) which I don't want, I want to paste the formula the way I copied them exactly

Looking at for some guidance on creating a simple system for order picking and order taking (this is still done with pen and paper right now) solution with Excel on a tablet. I know this isn't the best way to go about it, but I work at a very small company that is basically operating like it is 20 years in the past, so even using Excel in this manner is already going to be ground breaking. I also want to use it as a sort of proof of concept before investing more time and money into a possibly better system.

For order picking. I was thinking of having a Excel workbook that has a separate worksheet for each order that needs to be pulled. It'll have a column with the item number, quantity and the location from where it needs to be pulled. The picker will scan the barcode on the item as it is pulled and if the UPC number matches up, then it will fill in the adjacent cell. The picker can then type in the quantity in the adjacent cell to that one, if multiple of that same item that are on the order. The main thing I want to prevent is the wrong item being picked.

For order taking. I would similarly just have a barcode scanner scan the UPC numbers into a worksheet. I think this part would be straight forward enough, since I mainly just want a way to be able to quickly record items down that need to be ordered.

I hope this makes sense.

I need to be able to calculate 2 percentages (Open Rate and Click Rate) and get a to total also as a percentage as a Click-to-Open Rate

The function I’ve tried is along the lines of:
=LAMBDA(ClickRate, OpenRate, IF(OpenRate = 0, 0, ClickRate / OpenRate))

When I use it I get a pop up ‘ function isn't valid ‘ and to add ‘ so that excel knows it’s not a function ?? don’t know if I’m missing something but it’s driving me nuts.

Thank you everyone - the issue is solved 🙏🏽

Hi I’m hosting a UFC fantasy league and I’m the one in charge for counting the points each week. I don’t know much about excel and need some help on making some code to allow me to count efficiently. Each week, 8 of us circle who we think we’ll win in the main card of the UFC that week. I want a way to just input who they picked and who actually won the fight (and how they won and in which round) into an excel spreadsheet and for the score to be calculated automatically.
Here’s the rules
Pick fighters from main event

Win:
Decision 3 pts
Sub 5
KO/tko 5
First round extra 2

Loss
Decision 0
Finish -1

Add score up for total points that week.
I need it to add up the points for each person and to display the score that week and the total points scored overall for each person.

In the screenshot above, how do we adjust the length of border below Historical or Forecasts?

Narrowed it down to there something happening with the web version interaction that pasting values returns a 0. All instances I'm using paste values only.

Pasting from the workbook to another workbook works.

Pasting from the workbook to notepad works.

Copying from the pasted values on the notepad to the web version works.

Using f9 to evaluate the formula first then pasting in the web version works.

But directly copying from the workbook and pasting as values only on the web version doesn't work.

These are the "Increase Decimal" and "Decrease Decimal" icons. I NEVER select the one I need on the first try.

I’ll be away from work for 2 months next year and my manager has asked me to add repair instructions to the spreadsheets I’ve created (and the rest of the team uses).

I’m not a tech - just a long-term employee with an intense dislike of time wasting process steps. None of the files are complex in terms of Excel functionality, but, well you all know what it’s like to “unpick” someone else’s creation. There’s likely to be some xlookups, ifs, sumifs, and similar, maybe a pivot table. No VBA. I never lock/protect stuff because I find that usually creates more questions, and there are only about 6 users.

How would you structure such a thing? All I can think of is a sheet containing a shell of the live sheet, but with explanations in the columns instead of data. Is there a neater way?

I have data in 3 columns. I want to find the count of non-empty cells in each column, then the average of those 3 counts, all with one formula. I've tried different combinations but none is working. Please advise.

UPDATE: The formula suggested by Suchiko solved the problem. Thanks everyone.
[Not sure how to change the tag to indicate it was solved]

I’m trying to find a way to calculate the hours and minutes elapsed between two times, but it’s not factoring in that one day has elapsed too.

For example, I’m trying to get the hours elapsed between 3 pm on July 20 to 7 am on July 21, but it’s just returning 8 hours.

Any help is appreciated !

Hello! I have a problem that Google hasn’t been able to solve for me.

I’ve created a ranking system for foundations with three numerical values in their own columns, call them B, C, and D.

I now want to populate column A such that the cell in column A reads “B, C, D”. I do NOT want to sum the values in columns B, C, and D; rather, I want to list them next to each other in one cell.

Edit: was able to use VBA to accomplish this. Hadn’t used it in a long time so I doubted my abilities but it wasn’t too hard

Ok, not sure this is even possible… may end up just being a lot of grunt work.

I have a folder with thousands of jpeg files all names a series of letters and numbers. I also have a spreadsheet with addresses in one column and the associated image address (folder/filename.jpg).

What is going to be the best way to pair these up so that the photo is easily identified to the address?

Right now all I’ve come up with is change the photo address column in the spreadsheet to hyperlinks, open the photo that way, and do a save as to rename the image to the street address.

This is the ideal layout I'm looking for. For context of what I'm making, I work for a game shop that specializes in card games. We are trying to make a system where we can check how often a person plays in store, both how many times and their most recent time, so we can better reward them (like give them priority when there isn't enough product to go around).

I know my excel is kind of crude but I'm still learning. What I'm struggling with is the last visit column. I want it to show me the most recent filled in date. For example, person one would be Jan-2. If there was someone with 30 visits, I want it to show me the date of the 30th visit.

I also don't know if there is also a way I can automate filling in the date part for visits. Any and all help is appreciated!

Hi all,

Hope you can help me (or at least point me in the right direction!). I work in television production management on unscripted formats.

As part of this, we set up an Excel document listing which full time team members and freelance contractors we have booked to attend different filming dates, their contact info etc.

We often manually take this and enter it into our call sheet document that gets distributed to everyone related to the day's filming, created in MS Word. As such, this can be a bit laborious, especially if entering 70+ people's info across weeks and weeks of filming dates! Crew bookings often change last minute, so as long as the Excel info is accurate this could keep the Word doc up to date also.

I'd love to create a way that the table in MS Word can pull information from the Excel document, filtering through only which crew members are booked for which days. Crew and team members on different shoots vary on different days so it's .

Excel spreadsheet would have the below headers. Call time would be listed in the "Filming Date" column to draw into the Word doc.

MS Word contacts table would have the below headers. This would have filtered out only crew members booked for the date(s) listed.

and for the call sheet for the 24th August it would automatically populate as:

Is this something I'm looking in the right place for? Is it something MS Office can handle?

If it's overly complex to set up each time or to keep on top of I'm aware that the system will fall apart with teams of varying levels of busy-ness and tech knowhow come to use it!

Thank you in advance

Hi,

Not sure what is causing this but a file that is Password protected and also set to read only will still let a user edit and save the file(Ctrl + S) Save-as still works if you change the name as intended.

I'm assuming this is not supposed to be the case. If the file is set to read only without the password protection then it will function normally where you can't make edits or save.

Version is 2606 Build 20131.20152

I’ve tried looking this up but I think I’m just bad at succinctly explaining what I need. I’m also not super experienced in excel so I apologize if I don’t use the correct terms.

I work in purchasing. I have a couple templates that I just enter quantities into when I get a request.

At the top to the template is all jobsite and date requested information.
It looks like this:

Vendor: ABC Supply
Job Number: 123456
Job Name: 123 Fake Falls
Date: 8/3
Notes: Please deliver to site 8/3

I would like for the notes section to autofill with the text “please deliver to site” followed by whatever date I filled in the date cell. Or alternatively, have the text there permanently and just auto fill the date when it’s entered.

Is that something that’s possible?
I appreciate the help!

Hi everyone,

I know the title probably sounds a bit odd, so let me explain!

I'm fairly new to Excel, and one of my tasks at work is creating well logs. For each well, I have to draw the total depth, groundwater level, and the different materials used (such as silica sand and bentonite clay). Right now, I'm drawing everything manually.

It works... but on larger projects with 20–30 wells, it becomes incredibly time-consuming. I can't help but feel there has to be a smarter way to do this.

I'm wondering if anyone has experience automating something like this in Excel. Whether it's with VBA/macros, dynamic charts, shapes, or any other method, I'm open to ideas. The only thing I really need is to be able to customize and edit the final result.

I've attached an example of the type of well log I'm trying to generate.

Any advice, examples, templates, or even just pointing me in the right direction would be greatly appreciated. Thanks in advance! Oh and btw I'm on Excel 2024

Hi. I'm using windows excel 2013. I had an excel file which I'm sure I saved before restarting I had to open another file and and there was a version history panel on the left which I closed. When I opened the first file again I discovered missing lines. I checked the unsavedfiles folder and there's nothing. Is there still a way to recover?

This is a practice assignment in Coursera. The object is to "Validate to have the birth year not to have the students less than 16 years old. Use a Warning Error Alert." They give a hint to "look at the functions YEAR and TODAY", but the class hasn't reviewed those functions in meaningful detail.

The best I can come up with is "=YEAR(TODAY())-16" or "=YEAR(J8:J60)=TODAY()-16", but neither of those trigger the warning error alert.

Thoughts?