Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Look at Cell B2,
  2. Filter out all that matches it
  3. Paste it into second worksheet
  4.  
  5. When the button is clicked again:
  6.  
  7. Check cell B3, see if it matches B2 - If yes then go to B4
  8. if not then then do this filtering process again for this row
  9.  
  10. =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