bound

Hi, Is this possible to detect this kind of sequence in 250k-750k row data. 1) Count start at least the sequence of up-down 2) Stop the count if next value is not in squence of, increasing(up)-decreasing(down)-increasing(up)-decreasing(down),.... , example: i- up-down->down ii-...

I am using Bound Column 1 - which works fine, but if I want the Combo Box to use Column 3 to filter the form, it doesn't do anything?

On my userform I have a List box and in the properties I see it asks for Bound Column, Column Count... So I assume you can show more than one column in the list. RowSource: Drop_Down_Lists!$J$3:$K$100 I set the column count to 2 the bound column I set to 2 and I made the widths so that it...

I have a bound Parent form with a Bound Listbox that navigates the form to a certain record. I would like to be able to filter the Listbox with a "search" text box to make it easier to find the records I need to update with the child subforms. I thought it would look something like this...

This should be easy but for some reason I am just stumped. I am trying to get this done without adding too many additional cells I have tried nesting an IF statement and adding clauses to the SUMPRODUCT but cannot quite get it. I am most likely OVERthinking this The below is what I am trying...