Forum Discussion
Trying to remember a function to add a row below if the row above has data
Thank you mathetes . I believe the formula is a lot more complicated than that. I will be working on it more today, and if I figure it out, I will definitely post it.
More along the lines of =(sheet:B6 = TRUE, (A6), FALSE), IF row2=true, DATA=row3)
I know that is not accurate either, but closer to what I am trying to achieve....
I believe the formula is a lot more complicated than that. I will be working on it more today, and if I figure it out, I will definitely post it.
More along the lines of =(sheet:B6 = TRUE, (A6), FALSE), IF row2=true, DATA=row3)
I know that is not accurate either, but closer to what I am trying to achieve....
Might I suggest that you start with a clear statement in words of what it is you're hoping to accomplish.
So far your words themselves (as well as the attempts at formulas) have been confusing.
- For example, is it actually the fact that sheet(whatever),cell B6 will simply contain TRUE (or 1)?
- It certainly can't be the case that row2 will ever be TRUE. Rows, as such, don't contain values; they contain cells and the cells contain values.
Is it acceptable to ask you what the massive workbook is about, what the context or bigger picture is? I see by your user name that you are administering the galaxy itself, so can't help but wonder if it has something to do with the heavens..... Just curious. It's not common to see workbooks with 75 sheets in them.
- The worksheet is so massive because there are several different departments and parts and stuff divided up.
It is basically trying to distill cost onto a single worksheet that will determine work order costs/estimates/billing. The other worksheets will be locked so the workers will only be able to access 2 sheets in the end - the sheet that provides both cost and end price, and the estimate/billing sheet. The designer knows there is a formula that, if the line above in the estimate is filled, the next item will populate the line below as pulled from the master cost sheet. Unfortunately, it has been a very long time since he has used the formula and has since forgotten it.
Why is he doing it himself in Excel when there are estimating programs already written? Well, proprietary use and all that.
Does that help explain what we are trying to accomplish?
Thanks again for being persistent.Does that help explain what we are trying to accomplish?
Yes. And, sadly, no.
Depending on how recently that memory was created, there's a relatively new function called FILTER that might have been in play. I have used it to populate additional lines in such things as invoices for work done. It uses criteria to determine what lines to pull from another sheet (so in that sense bears a resemblance to IF formulae).
Here's a website with info on FILTER. And here, perhaps even more helpful, is a YouTube video with a couple of demonstrations.
- Thank you very much - I will forward that info (after trying it myself) and see if that works. You have been exceptionally helpful.