Hello
i have list of results (e.g. 123,12,-23,-24,1....) lets say B1:B12
i need to count max consecutive loss number but only for visible cells(if i hide some cell with table filtration it wouldnt be counted)
so far i found =MAX(FREQUENCY(IF(B1:B12<0;ROW(B1:B12));IF(B1:B12>=0;ROW(B1:B12))))
but this one count value even if cell is hidden
i have list of results (e.g. 123,12,-23,-24,1....) lets say B1:B12
i need to count max consecutive loss number but only for visible cells(if i hide some cell with table filtration it wouldnt be counted)
so far i found =MAX(FREQUENCY(IF(B1:B12<0;ROW(B1:B12));IF(B1:B12>=0;ROW(B1:B12))))
but this one count value even if cell is hidden