Excel Forum
Similar Content
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Increment a Value Every X Number of Rows in Excel
Tutorial: How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...



Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function


See an amazing formula to take all records from a data set and place them into one column. See the functions INDEX, INT, ROWS and MOD functions.





Got a Question? Ask it Here in the Forum.