![]() ![]() NOTE: We could provide the user with a drop-down list to ease the selection process for Division, but for simplicity, we will hardcode the Division name. To begin, select cell G4 and enter the Division “Game”. We will also integrate an IF test to visually suppress any errors that may show up when the returned items do not fully populate the results list area. This method will use the INDEX function with the AGGREGATE function to locate the associated Apps for the selected Division and compile the results into a new list.
0 Comments
Leave a Reply. |