Forum Widgets
Latest Discussions
FILL lambda: Fill blank cells in Multiple direction (↓↑→←) across 2D arrays
Hey everyone!! Sharing something I've been putting together: a Lambda for filling blank cells across ranges, with full control over direction and proper 2D array support. =FILL(array, [directions]) Clean single-function interface. The [directions] argument takes: "d" -> Down (default when omitted) "u" -> Up "r" -> Right "l" -> Left Want to chain multiple fills? Just pass an array constant, each direction runs in sequence, output of one feeding into the next: =FILL(A1:D20, {"r","d"}) Super handy for tables with both row and column headers that got merged. Five Lambdas under the hood. Only FILL is meant to be called directly, the rest are internal, prefixed with Dep_ to make that clear: Name What it does FILL Call this one, handles all 4 directions Dep_Fill_D_or_U Vertical fill engine Dep_Fill_R_or_L Horizontal fill engine Dep_VMirror Flips row order -> enables fill-up Dep_HMirror Flips column order -> enables fill-left Blank cells and empty strings are treated the same way throughout. Drop any questions or feedback below, and if you find a use case for it, I'd love to hear about it! All functions available on my GitHub https://gist.github.com/Medohh2120/14697b32ff089aa559d26547a5bd82a9
Fill out other cells based on selection
Hello all, brainstorming some ideas. Want to make it easier for my colleagues to fill out. Currently for review section I made it into a dropdown list so user can select from a list than typing it out every time. What i want is based on the selection in 'Review Section', I want it to populate the sample size and total. I could do a switch statement based on what was chosen but i want to see if there is another easier option. Trying something new, any suggestions are welcomed. My Org did restrict VBA so I can't use those. ty
Excel - COUNTIF Function
Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not sure if my brain is fried from reading/watching all kinds of videos for the past 3 hours and trying to follow their instructions, but any time I put in a formula, I get a pop-up saying I've entered too many arguments. Even if I enter individual cells and use only the 3 that it highlights for me (more than 3 does not highlight). I've attached a screen shot of the worksheet (Figure 1) and have highlighted the area I'm trying to figure out. As you can see, it will be for multiple dates, on multiple lines, going through to the end of the month, with the total chlorine (CL2) tallied up on the right hand side. Chlorine tanks are changed out quite often and each tank begins at 150, depleting down to 0. Figure 2 shows a screen shot of what I'm getting when trying to enter the formula. Am I misunderstanding how the formula works or am I using the wrong formula all together? Figure 1 Figure 2
What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!
Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to be Red Link to Excel Sheet. https://1drv.ms/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctc
"Clear Filter From" Option is Never Available
Once a column is filtered, the option to remove that filter just from that column is always greyed out in my Excel (Microsoft 365, v2604, Build 19929.20090). I have seen multiple references advising to remove protection, check for hidden columns, or ungroup workbooks. None of these apply, since I have also tested this with a new worksheet containing a single column, with nothing possibly hidden, and with no shared access. Here is a screen shot of what I see: Thanks to anyone who may have some advice on how to re-enable this feature.
