Filter function ignore blank rows [SOLVED] - Excel Help Forum
Jan 14, 2025 · Filter function ignore blank rows Hello. I'm trying to use the FILTER function to transfer data from B5:E15 to another range of cells using the FILTER formula =FILTER (B5:E15, {1,1,1,1}," ") …
[SOLVED] Power Query; help with left function - Excel Help Forum
Mar 28, 2020 · Re: Power Query; help with left function Possible Solution #1 Why not use the split function and split based upon length. Then merge columns as needed in new column and delete …
IF Function - Begins With - Excel Help Forum
Dec 1, 2016 · Re: IF Function - Begins With Administrative Note: Welcome to the forum. We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that …
The UNIQUE function is not working as expected [SOLVED]
Dec 20, 2024 · Excel Formulas & Functions [SOLVED] The UNIQUE function is not working as expected The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a …
Alternative to sequence function - Excel Help Forum
Jul 4, 2025 · Re: Alternative to sequence function Thanks, but this just returned a value of 1 into B6 only and trying to populate down to the number of days. this example would be down to 29 Register To …
countif () with filter () function [SOLVED] - Excel Help Forum
Aug 10, 2023 · Re: countif () with filter () function If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Filter with indirect function [SOLVED] - Excel Help Forum
Apr 3, 2024 · Filter with indirect function Hi all, can someone please assist with the dashboard page of the attached? It's a dashboard built off the other sheets. I've been using indirect function to make it …
Mimicking SQL COALESCE function in Excel using XLOOKUP?
Jun 7, 2025 · Re: Mimicking SQL COALESCE function in Excel using XLOOKUP? Because I only want to return the row I am interested in. For example back to the meal reimburse program example, …
SEARCH and FIND function - VALUE ERROR ! [SOLVED]
Aug 8, 2014 · [SOLVED] SEARCH and FIND function - VALUE ERROR ! The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have …
Checking two cells for zero with =IF function - Excel Help Forum
May 29, 2007 · Can anyone tell me if you can check two cells for zeros within the same =IF function? I have been able to check once cell for zero with the =IF function, but in order for my calculation to …