Reversing large-if array formula

Hi,

Not entirely sure what you're getting at. Could you add the results that you expect to see?

In case it helps if I know I need to get back to an original data order when I've played around with various sorts and moves I find it useful to add a 1,2,3....series of numbers before I start anything, then just use that column to reverse everything

Maybe in C1 then drag down:

Please Login or Register  to view this content.

Bebo, the formula works as intended, thank you.

I should have posted a more complete example of my question, but the column C solution should be able to accommodate for a changing column B criteria - please see the attached workbook for what I mean. The solution should be able to "account" for rows 1-7 being different from rows 8-15, and rows 16-24, and so on, where each new row range may be a random number of rows.

So the new problem I have is that the range F1:O4 is defined using absolute references.

I believe the only way to fix this is using VBA where I add x-number of rows (to your F1:O4 ranges) every time we have a new column B criteria.

So for example cell C8 will be equal to the dragged down cell C7 PLUS an additional 7 rows, to the appropriate ranges. Now, cell C9 will be equal to the dragged down cell C8 value, but no additional rows will be added because cell B8 and cell B9 are the same.

My answer is confusing me so I can't imaging how you guys feel. I will post a solution if I reach one.