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'. how do i fix this.
on a side note while posting queries how do i remove this ribbon; its a bit annoying
2 Replies
An issue with share buttons was discussed here
Please remove Community Share Buttons at the left | Microsoft Community Hub In any case that's better to ask at Community Lounge | Microsoft Community Hub
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) )
