32.6k views
3 votes
Sheets how to filer that if the data in a certain row is the same it will become a drop down?

User Flexd
by
7.7k points

1 Answer

1 vote

Final Answer:

To create a dropdown list in Go-ogle Sheets based on the data in a specific row, you can use Data Validation. Choose the cell where you want the dropdown, go to Data > Data Validation, select 'List of items,' and enter the range of cells from the desired row. This creates a dropdown with unique values from that row.

Step-by-step explanation:

In Go-ogle Sheets, enabling dropdowns based on data in a particular row involves utilizing Data Validation. First, identify the target cell for the dropdown. Navigate to the "Data" menu, select "Data Validation," and opt for "List of items." Specify the range of cells containing the data in the desired row. Subsequently, a dropdown menu is generated in the chosen cell, offering the unique values from the specified row as selectable options.

User Rosael
by
8.1k points