Forum Discussion
Solved
Formula or Function???
I have an excel spreadsheet that is huge (over 400 names and over 30 courses) and I need an easy way for a person to see their specific course requirements. Not sure if they would click on their name...
=IFERROR(INDEX($AG$16:$BQ$16,SMALL(IF(OFFSET($G$1,MATCH($BU$21,$G$23:$G$435,0)+21,26,1,37)=1,COLUMN($A:$AK)),ROW(1:1))),"")You are welcome. You can try this formula which works in my file. The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.
In Excel, a formula is an expression that you create inside a cell, while a function is a predefined calculation in the spreadsheet application Here are some key differences between formulas and functions
A formula is any expression that begins with an equals sign (=).
A function is a formula with a special name and purpose.
Functions are predefined formulas that are already in Excel.
Functions carry out specific calculations in a specific order based on the values specified as arguments or parameters.
A formula is any expression that begins with an equals sign (=).
A function is a formula with a special name and purpose.
Functions are predefined formulas that are already in Excel.
Functions carry out specific calculations in a specific order based on the values specified as arguments or parameters.