Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:48:59 +0000



Post From: Find the Nth instance of a number in a spreadsheet column using spreadsheet functions?

[2017-05-04 18:38:35]
cgarrad - Posts: 27
I used an extra helper column to verify that match was true on the previous row as part of the formula thus verifying that the next true was a second instance.

Works, but only for the 2nd instance.

Anyway, more functionality is always good ;-)

Thanks.