Forum Discussion
filter and find
hi I am using filter and find function but the function is returning wrong results. cell R27 should return value from column G for No. '5' (B column) but instead its returning value for No. '95'. ho...
FIND() returns number (position of 5 within value) for any number with 5, e.g. for 5, 95, etc. You may simplify to
=MAX( FILTER( G3:G29998, B3:B29998 = 5) )