INDEX consecutive row indexing

Mike TV
Mike TV ✭✭✭✭✭✭

I've had this issue come up a bunch for me when trying to write formulas. Say I've got a column of Order Numbers that have a lot of repeated numbers in it. I can write a formula to pull out distinct numbers into another sheet such as this formula:

=INDEX(DISTINCT({Order Number}), 1)

However, that's only going to pull out the first one into my new sheet. What if I have over 100 distinct order numbers I want to pull into a new sheet? Currently I only know of one way to do it. By changing the row index number at the end to 2, then 3, then 4, and it can take an hour or more to put that formula into over 100 rows.

Is there a faster way to pull out the distinct numbers aside from manually telling SmartSheet to give me the first result, then the second, then the third, all manually?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!