'CHOOSE function' category

You are here: Excel » Functions » Lookup and reference » CHOOSE function »

CHOOSE function from list
The picture above shows the CHOOSE function in cell F3, one disadvantage is that you need to press with left […]
How to use the CHOOSE function
The CHOOSE function lets you get a value based on a number, the number determines which value to get. The […]
Two-dimensional lookup using two tables
The following formula performs a two-way lookup in two different tables.
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
How to group items by quarter using formulas
This article demonstrates two formulas, the first formula counts items by quarter and the second formula extracts the corresponding items […]
Highlight a group of chart bars
This article demonstrates how to highlight a group of bars in a chart bar, the techniques shown here works fine […]

Excel categories

FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive