Thread: [Solved] Extract a matrix of another matrix defined by selected rows marked with an x
View Single Post
 
Old 03-18-2019, 05:43 AM
Tommy7571 Tommy7571 is offline Windows 10 Office 2010
Novice
  
Join Date: Mar 2019
Posts: 11
Tommy7571 is on a distinguished road
Default Extract a matrix of another matrix defined by selected rows marked with an x
Hello,

I have the following problem:
I have a table with data, where not always all cells shall be used, however the sequence must stay the same.
example:

Column 1 Column 2 Column 3 Column 4
x TBA 50 99
DTBP 230 99
x Azeton 50 99

In the first column a x decides if the values of the following Cells need to be used or not. Off Course the x can be in all lines or in none.
I need a virtual data matrix, which includes only marked cells and from which I can extract with VLOOKUP() or Similar the data of the activated cells.
The Matrix should only exist virtually in the formula and have the following form in the example given above

Column 1 Column 2 Column 3
TBA 50 99
Azeton 50 99

From this matrix I want to extract all data linewise.
Can anyone help me?

Thanks

Tommy7571
Last edited by Pecoflyer; 03-19-2019 at 12:15 AM. Reason: wrong Language: selected lines from a matrix
Reply With Quote