Excel dependent dropdown list using INDIRECT
In Excel, to create dependent dropdown list, I will convert the dropdown list data to an Excel table and use the INDIRECT function in the data validation feature.
Excel highlight & SUM top & bottom values using LARGE & SMALL
In Excel, to highlight top & bottom values and return their sum separately, I will use conditional formatting and use the SUM, LARGE and SMALL functions.
Excel dropdown INDEX MATCH MATCH formula
In Excel, to extract data from the database based on the selection of dropdown list, I will use data validation, INDEX function and MATCH function.
Conditionally calculate SUM in Excel
In Excel, to conditionally calculate total, I will use the SUM function that sums up the numbers.
Excel dropdown SUM with All option using SUMIF with IF
In Excel, to sum values based on the selection of drop-down list with the All option, I use data validation, the SUMIF and the IF function.