The first drop down list contains unique distinct values from column A. ![]() We are going to create two drop-down lists. Here is a list of order numbers and products. This article explains how to build dependent drop down lists. Most used functions COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP functionĪuthor: Oscar Cronquist Article last updated on May 06, 2022 VLOOKUP in a filtered Excel Table and return multiple valuesÄiscount percentages Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course List permutations with repetition and how many to choose from ![]() ![]() Tracking a stock portfolio in excel (auto update) Automate net asset value (NAV) calculation on your stock portfolio
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |