Forum Discussion

Copper Contributor

Apr 13, 2022

Solved

Find the first, second, third, and so values in an array.

I have an array that is 70 rows and 30 columns wide. Looking up the first value larger than zero in a certain column in the array is simple. How do I find the second, the third, the fourth, and so on...

excel

Detlef_Lewin
Apr 13, 2022
FifthSteve

=SORT(FILTER(column_range,column_range>0))

Detlef_Lewin

Silver Contributor

Apr 13, 2022

FifthSteve

=SORT(FILTER(column_range,column_range>0))

FifthSteve

Copper Contributor

Apr 14, 2022

Detlef_Lewin Thank you. I doubt if I would have found this simple elegant solution. I was working so hard on this solution I didn't think of the next step. I am very poor at chess.

The spreadsheet I am making has the user input three numbers in three columns separated by 6 columns left blank. Every 7 columns a formula uses the input and continues to the end of the columns. So, out of each series of 7 columns, I only need to display one. Is there a way to eliminate those 6 and keep the one I want?

I appreciate any help you can give me.

Detlef_Lewin
Silver Contributor
Apr 15, 2022
FifthSteve
*
FifthSteve wrote:
The spreadsheet I am making has the user input three numbers in three columns separated by 6 columns left blank. Every 7 columns a formula uses the input and continues to the end of the columns. So, out of each series of 7 columns, I only need to display one. Is there a way to eliminate those 6 and keep the one I want?
I appreciate any help you can give me.
So, that is a new question?
Please upload a sample worksheet with the desired output.