I was hoping to find the formula necessary for taking a table of values, and then creating new tables based on the paramters. Here is an example of the original table
X Y Z
1 2 4
2 4 5
1 1 6
2 3 2
I was hoping to then create a unique table for each X-Value somewhere else on the sheet eg:
x = 1
X Y Z
1 2 4
1 1 6
and
x =2
X Y Z
2 4 5
2 3 2
Is there a way to automate the creation of these secondary tables?
Thanks alot
Bookmarks