New answers tagged list
0
votes
Look in data cluster in a row and fetch the first cell value of the row
If I understand it correctly:
=TEXTJOIN(",",,REPT(A2:A6,B2:E6=G2))
- 482
1
vote
Look in data cluster in a row and fetch the first cell value of the row
Set Autofilter for the sheet data
Record a macro when you set filtering for a specific date
Edit the recorded macro to use a variable for the date
Edit more; Add a dialog to ask for the date into that ...
- 10.2k
Top 50 recent answers are included