Discussion Re: Generating a table when at least one of the elements of a row changes in Excel
https://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590583#M72088
<P>Hi! Each row has seven actually <LI-USER uid="746148"></LI-USER> </P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicomateos_0-1597496827258.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/212601iE6A450451ABF9FCB/image-size/medium?v=v2&px=400" role="button" title="nicomateos_0-1597496827258.png" alt="nicomateos_0-1597496827258.png" /></span></P><P> </P>Sat, 15 Aug 2020 13:07:20 GMTnicomateos2020-08-15T13:07:20ZGenerating a table when at least one of the elements of a row changes
https://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590230#M72075
<P> </P><P>Dear all,</P><P> </P><P>I have this issue i need to solve and i cant just figure this out. Can you help me?</P><P> </P><P>I have a range of cells with different values and I need that when at least one the values of the range change a table is generated with this very same range. Then, when at least one of the values change again I need that range to be appended to the previous data in the table. The goal is to build a time series until there are not more changes. (Clearly the table must have as many rows as changes happened in the range plus the initial range) </P><P> </P><P>Thank you very much! <LI-EMOJI id="lia_slightly-smiling-face" title=":cara_con_una_leve_sonrisa:"></LI-EMOJI></P>Sat, 15 Aug 2020 03:03:01 GMThttps://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590230#M72075nicomateos2020-08-15T03:03:01ZRe: Generating a table when at least one of the elements of a row changes
https://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590303#M72079
So each row has two values?Sat, 15 Aug 2020 05:39:49 GMThttps://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590303#M72079Ramiz_Assaf2020-08-15T05:39:49ZRe: Generating a table when at least one of the elements of a row changes
https://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590583#M72088
<P>Hi! Each row has seven actually <LI-USER uid="746148"></LI-USER> </P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicomateos_0-1597496827258.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/212601iE6A450451ABF9FCB/image-size/medium?v=v2&px=400" role="button" title="nicomateos_0-1597496827258.png" alt="nicomateos_0-1597496827258.png" /></span></P><P> </P>Sat, 15 Aug 2020 13:07:20 GMThttps://techcommunity.microsoft.com/t5/excel/generating-a-table-when-at-least-one-of-the-elements-of-a-row/m-p/1590583#M72088nicomateos2020-08-15T13:07:20Z