Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Look at Cell B2,
- Filter out all that matches it
- Paste it into second worksheet
- When the button is clicked again:
- Check cell B3, see if it matches B2 - If yes then go to B4
- if not then then do this filtering process again for this row
- =IFERROR(INDEX($A$1:$C$7,SMALL(IF(COUNTIF(searchbox,colA),MATCH(ROW(colA),ROW(colA)),""),ROWS(L3:$L$3)),COLUMNS($A$1:A1)),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement