Excel Functions - Recursive
Hi all,
I have a list in Excel, where I already put a Formula to get the following results: Block Category Row SeatNo Range ChangeSearch A.1 2 29 1 No Change A.1 2 29 2 No Change A.1 2 29 3 No Change A.1 2 29 4 No Change A.1 2 29 5 No Change A.1 2 29 6 No Change A.1 2 29 7 No Change A.1 2 29 8 No Change A.1 2 29 9 Change A.1 2 29 15 No Change A.1 2 29 16 No Change .... Now I want to calculate the range from the first seat to the "Change" to get something like: Block Category Row SeatNo Range A.1 2 29 1 1-9 A.1 2 29 1 15-XXX How can this be done recursively in Excel, no macro?! If only possible with macro, does anyone has a hint? Thanks in advance and kisses, Mel |
Excel Functions - Recursive
Look at DataSubtotals
-- Kind regards, Niek Otten "Mel_la_Bel" wrote in message ... Hi all, I have a list in Excel, where I already put a Formula to get the following results: Block Category Row SeatNo Range ChangeSearch A.1 2 29 1 No Change A.1 2 29 2 No Change A.1 2 29 3 No Change A.1 2 29 4 No Change A.1 2 29 5 No Change A.1 2 29 6 No Change A.1 2 29 7 No Change A.1 2 29 8 No Change A.1 2 29 9 Change A.1 2 29 15 No Change A.1 2 29 16 No Change ... Now I want to calculate the range from the first seat to the "Change" to get something like: Block Category Row SeatNo Range A.1 2 29 1 1-9 A.1 2 29 1 15-XXX How can this be done recursively in Excel, no macro?! If only possible with macro, does anyone has a hint? Thanks in advance and kisses, Mel |
Excel Functions - Recursive
Hello Niek,
what should that do? Kind of Data-consolidate? Thank you, Mel "Niek Otten" wrote: Look at DataSubtotals -- Kind regards, Niek Otten "Mel_la_Bel" wrote in message ... Hi all, I have a list in Excel, where I already put a Formula to get the following results: Block Category Row SeatNo Range ChangeSearch A.1 2 29 1 No Change A.1 2 29 2 No Change A.1 2 29 3 No Change A.1 2 29 4 No Change A.1 2 29 5 No Change A.1 2 29 6 No Change A.1 2 29 7 No Change A.1 2 29 8 No Change A.1 2 29 9 Change A.1 2 29 15 No Change A.1 2 29 16 No Change ... Now I want to calculate the range from the first seat to the "Change" to get something like: Block Category Row SeatNo Range A.1 2 29 1 1-9 A.1 2 29 1 15-XXX How can this be done recursively in Excel, no macro?! If only possible with macro, does anyone has a hint? Thanks in advance and kisses, Mel |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com