Note: In the formula, A2:A6 is the first column data of your original data, and B8 is the cell linked to the combo box.ħ. Enter the following formula into A12 and copy it across to I12, and it returns the value in the row which number corresponds to the currently selected item in the drop-down list, see screenshot: And then, copy the header of the original data, and leave an empty row for displaying the filtered sales data, see screenshot:Ħ. Then, click OK button, now, the product names have been added into the drop-down, and the linked cell value (B8) characterizes the currently selected item from the menu as option 1, 2, 3, 4 or 5, see screenshot:ĥ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |