http://www.contextures.com/30excelfunctionsin30days30xl30d.html
The INDEX function returns a value or reference, based on a row and column number.
The INDEX function can:
-- Find sales amount for selected month
-- Get reference to specified row, column, area
-- Create a dynamic range based on count
-- Sort text in alphabetical order
Watch this video to see how to use the Excel INDEX function, and combine it with other functions.
Link to this comment:
All Comments (0)