Get instant live expert help on How do I drop down arrow

To add visible arrow to the drop down list

View the data in the PivotTable to determine the employee with the highest number of units sold. In cell A2, click the drop-down arrow, and then select the name of the employee with the highest number of units sold. In cell A3, click the drop-down arrow, and then select the name of the employee with the second highest number of units sold.

View the PivotTable data to determine the employee with the lowest number of units sold. Click cell A5, click the drop-down arrow, and then select the name of the employee with the lowest number of units sold. Click cell A6, click the drop-down arrow, and then select the name of the employee who sold 30 units to answer question 2.

In Google sheets, I have a drop down list with a list of items criteria. Approved,Pending,Rejected,Met,Over,Under,No Actual Originally the list was . . . No Actual,Over,Under,Approved,Pending,Rejected,Met This validation is in a sequence of several rows in a column. No matter what I do, when I press the drop-down arrow, sometimes the original list displays in the drop down and sometimes the old list displays. I have copied one of the correct cells and removed then recreated the list, and the drop-down won't present the list as shown in the criteria list. The criteria list is correct but the drop-down list is incorrect. Please help.

I am trying to create a dependent drop down list with the following formula, =INDIRECT(SUBSTITUTE(A18," ","_")) I have 10 Columns and only 6 of them seem to be working correctly with no options coming up for the other 4 when I try clicking on the drop down list arrow. Could you please provide me with some assistance for this issue it would be greatly appreciated