Archive for ADDRESS function
How to use the ADDRESS function
The ADDRESS function returns the address of a specific cell, you need to provide a row and column number. Formula […]
Quickly select a data set or an excel defined table [HYPERLINK]
If you often copy data sets or tables, the following technique might be interesting! The animated gif shows two hyperlinks, […]
Locate lookup values in a table [HYPERLINK]
Today I´ll show you how to search a table column and jump to that table cell using the hyperlink function. When […]
How to quickly find the maximum or minimum value [Formula]
Question: I have three columns and how do I identify the largest and smallest number? Where is the value? I […]
Get cell addresses from several cells
Question: How do i get the cell adresses from the cells that contain TRUE? See picture below. Array formula in cell […]
