Forum Discussion
Alasdair Gray
Oct 11, 2017Copper Contributor
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
- Detlef_LewinSilver Contributor
Alasdair,
in AC2:
=COUNTIFS(E2:AA2,">0,3",E2:AA2,"<1")