Hi guys,
I am trying to automatically resort a list of items based on some data result elsewhere in the book and I would like to avoid using VBA or a macro.
For instance:
<tbody>
</tbody>
Well is a string identifier
Data is determined elsewhere in the book, its a boolean type
Result is simply detecting whether or not the Data is true and referencing the well
List is the part Im stuck on, I have 2400 identifiers but only 20 or 40 hits (data with 1 value). I want the list to ignore the results that are "-" and line up the results if they have a value into a compact list in the result column. I am making a template that will be shared by a group of people so I would like to avoid macros and VBA if possible (else this would be a piece of cake).
Thank you for your time and help! All thoughts are greatly appreciated
Kyle
ps I have an attachment in excel but the board wont let me post it?
I am trying to automatically resort a list of items based on some data result elsewhere in the book and I would like to avoid using VBA or a macro.
For instance:
Well | Data | Result | List |
A01 | 0 | - | A02 |
A02 | 1 | A02 | B01 |
A03 | 0 | - | B04 |
A04 | 0 | - | |
B01 | 1 | B01 | |
B02 | 0 | - | |
B03 | 0 | - | |
B04 | 1 | B04 |
<tbody>
</tbody>
Well is a string identifier
Data is determined elsewhere in the book, its a boolean type
Result is simply detecting whether or not the Data is true and referencing the well
List is the part Im stuck on, I have 2400 identifiers but only 20 or 40 hits (data with 1 value). I want the list to ignore the results that are "-" and line up the results if they have a value into a compact list in the result column. I am making a template that will be shared by a group of people so I would like to avoid macros and VBA if possible (else this would be a piece of cake).
Thank you for your time and help! All thoughts are greatly appreciated
Kyle
ps I have an attachment in excel but the board wont let me post it?