Check if a value's position is before the position of another value in a range

Hi,

I'm looking for some guidance on determining if the position of value "A" in a range is before the position of value "B" in the same range. Basically, I have two columns. Column A is a list of numbers from 1 to 50 in order. Column B contains various positive and negative dollar amounts. I want to be able to run a macro that will return the position of value "A" only if it is before the position of value "B".

Here's a fuller explanation of what I am trying to do. I have 40 worksheets, each having two columns. Each worksheet represents 1 Blackjack session. Column A has numbers 1 to 50 in order. These represent Blackjack hands. Column B has a corresponding total dollar amount (positive or negative) for each hand in column A. This is the amount up or down at each hand. The macro will contain two variables that are dollar amounts: "up" and "down". Let's say "up" = $100 and "down' = -$150. As an example, when the macro is run, it will look through Column B to find where $100 occurs before -$150 occurs on each of the 40 worksheets. It will then return the total count of the number of worksheets where this is true.

For right now, I just need to figure out how to find if one value occurs before another value in a range.

Let me know if more information or clarification is needed.

Thanks in advance

Here's one way (on the proviso I've understood the question!)

Please Login or Register  to view this content.

BSB