Linear Values Dissolve

[Huskersippi]

I want to dissolve linear measured values so they split based on Begin & End values. I have attached image of data and desired results. Need to determine if values in Column B equal same value in Column C from previous row. If not, this would indicate a break in the value therefore creating a new output. If they are the same, then move to next row and execute the same test between Column B and Column C values.

Linear Values Dissolve.JPG

[CAntosh]

If I'm understanding correctly, then try the following formula in E3. It should be array-entered with Ctrl + Shift + Enter instead of Enter:

=IFERROR(INDEX(A$3:A$19,SMALL(IF($B$3:$B$19<>$C$2:$C$18,ROW($C$3:$C$19)-ROW($C$3)+1),ROW(1:1))),"")

Fill it right into F3. Array-enter the following into G3:

=IFERROR(INDEX(C$3:C$19,SMALL(IF($C$3:$C$19<>$B$4:$B$20,ROW($C$3:$C$19)-ROW($C$3)+1),ROW(1:1))),"")

Fill E3:G3 down beyond what you think you'll need and you should be good to go. It should automatically adjust as figures are changed in columns A:C. If you need it cover a bigger range, just change all of the range sizes to fit or exceed your actual ranges. Just make sure that the one range in each formula that is offset by one is changed to match. Take a look at the attachment to see if it'll do:

[Huskersippi]

Amazing and so grateful for your quick response!! It works perfect!!! Thank you very much CAntosh !!!!

[CAntosh]

Glad to help, good luck!

[Huskersippi]

It works great but when I change value in Column C with the second to last value (C:19), then ALL output becomes blank in Columns E & F. So for instance, I added two additional rows. A:19 = TEST 3, B:19 = 200.5, C:19 = 1500, A:20 = TEST 3, B:20 = 1500, C:20 = 3000. If I change C:19 from 1500 to 1300 then all data in Columns E & F become blank.

[CAntosh]

Can you post a sample of what you're seeing? All blanks suggests that the ranges in the formula are not all the same size (one range in each formula should be offset one cell up or down, but it should still be the same size), but it's hard to be certain without seeing what you've got.

[Huskersippi]

My apologies. Please disregard.... I just extended my Range Wayyyyy down and it is now accepting dynamic values. Thank you again CAntosh.

[CAntosh]

No worries, I'm glad it's working for you!