Support Board
Date/Time: Tue, 26 Nov 2024 10:50:03 +0000
Post From: Compare range of individual values
| [2023-12-12 04:13:40] |
| User273277 - Posts: 58 |
|
Thank you. That helped get the code most of the way there on the first try. For the multiple columns, I have tried to see how to use things like vlookup, search, nmatch, but I don't see how any of these can select the x value in the swing low list. Ie. it looks like I need to do something like =MOSTRECENTNONZEROVALUE(ID1.SG2@4:ID1.SG2@54,2) to select the second value in its own column. Date Time Of Last Edit: 2023-12-12 04:15:42
|