-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
spill range
-
M
Compare individually the values from two different size ranges
Hello! Let’s say range1is a spilled range that contains 3 values. We have another range called range2 that is fixed and contains 5 elements. I want to compare first value=20 from range1 with all the values from range2 and get first value that is greater or equal to 20. After this, go to the...- Mds1
- Thread
- compare loop 2 ranges spill range
- Replies: 7
- Forum: Excel Questions
-
R
Allocate between dates to months then summarise by month and year
I am seeking help how to split bookings by date and summarising it by month and year. Thus an example of the data is: Start End Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Jan-2025 Feb-2025 Mar-2025 Apr-2025 15/01/2024...- Robert Davidson
- Thread
- spill range summarise data
- Replies: 7
- Forum: Excel Questions
-
Filter Dynamic Array by Range, Differently Sized Arrays
I have a spill array that is pulling IDs from another sheet. I already have a list of IDs on one side of my visual, and I want to avoid duplicates. The list of my array formula is longer than the existing list I want to compare, and that's tripping me up. My formula with the spill array...- TheMacroNoob
- Thread
- criteria duplicates filter if spill range
- Replies: 3
- Forum: Excel Questions
-
VBA to insert or delete rows in named range based on spill range
Cross posted at VBA to insert or delete rows in named range based on spill range I have a named range "nameList" (B3:E20) that are populated by a spill range from dynamic array formula in cell B3, and there's a table just below cell B24. If the spill range row count are less or more than the...- markkeith
- Thread
- dynamic array formula named range spill range
- Replies: 3
- Forum: Excel Questions
-
A
Display image using Name Manager on a dynamic spilled range
Hi all. I am new here, so apologies if I miss any conventions with making this post. I'm using Office 365, on Windows. Here is a link to a screen-recording of the spreadsheet/dashboard. (Unfortunately the screen-recording does not capture the drop-down list, for some reason, but you can clearly...- adi772
- Thread
- dynamic image image indirect name manager spill range
- Replies: 2
- Forum: Excel Questions
