How to delete a row in 2 dimensional Matrix

Solved4.74K viewsFormulas and Functions2D matrix formula modeler

If I have a 2 dimensional matrix :
Qtr1   Product
Row1   Q1       Tesla
Row2   Q2        Ford
What command should I write to delete all the rows that have product “Ford” ?


S A U Answered question February 13, 2019

Are you kidding?…
If you have to delete Rows based on Criteria in separate (selectable) Fields you may write an A-script using this Algorithm:
1. Prompt the User to select a Category Item from the List as a pointer to a Range of Criteria Values.
2. Prompt the User to select one unique Criterion Value from the List.
3. Delete Rows from M1 matrix according to User-selected Criteria.
That’s exactly what I did. See Version of the A-script for such Case.

S A U Answered question February 13, 2019
You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes