B
Brandon
I am looking for a formula that will allow me to copy data from one
spreadsheet into another based on values within my initial worksheet.
For example, if I have 5 colums of data listed below and their corresponding
data;
A B C D E F
3 4 3 5 3 3
I only want to display data that is equal to 3 on another worksheet, so this
would appear as;
A B C
3 3 3
I am trying to find a formula that will allow me to pull across only these
values and exclude the other colums as they do not equal 5.
Thanks,
Brandon
spreadsheet into another based on values within my initial worksheet.
For example, if I have 5 colums of data listed below and their corresponding
data;
A B C D E F
3 4 3 5 3 3
I only want to display data that is equal to 3 on another worksheet, so this
would appear as;
A B C
3 3 3
I am trying to find a formula that will allow me to pull across only these
values and exclude the other colums as they do not equal 5.
Thanks,
Brandon