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 th...
Detlef_Lewin
Oct 11, 2017Silver Contributor
Alasdair,
in AC2:
=COUNTIFS(E2:AA2,">0,3",E2:AA2,"<1")