Excel Forum



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.