Forum Discussion

Alasdair Gray's avatar
Alasdair Gray
Copper Contributor
Oct 11, 2017

PROBLEM FILTERING LARGE DATA SHEET

I've got a large data sheet where i need to filter all values of readings great than 0.3 taken on a monthly basis. SO in teh row column I have the units being tested and the columns are the months that testing takes place noting each reading for each unit. I wanted to only display those reading greater than 0.3 but the basic filter fucntion obvisouly limits it to each column. How can i filter a great number of columns?

 

Thanks

Al.

1 Reply