Create name abbreviation using Excel TEXTSPLIT, LEFT and CONCAT
Here, we will learn how to create name abbreviation using the Excel TEXTSPLIT, LEFT and CONCAT functions in one formula.
Find last column number and convert to letter in Excel
In Excel, to find the last column number in the range and then convert the number to column letter, you can use the MIN, COLUMN and COLUMNS functions and nest the formula in the SUBSTITUTE and ADDRESS functions.
Excel dropdown INDIRECT INDIRECT formula
In Excel, to extract score of the student in the subject based on the selection of the dropdowns, you can use data validation and the INDIRECT INDIRECT formula.
Excel dropdown IF AND formula
In Excel, to build an IF AND statement based on the selection of the dropdown list, combine the IF and AND functions in one formula and use the Data Validation feature.
Excel dropdown VLOOKUP with AVERAGE, MAX, MIN
In Excel, to find the maximum, minimum and average value in the range and return the corresponding value from another range, use the VLOOKUP formula with the AVERAGE, MAX and MIN functions.