Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 25 Apr 2024 13:38:24 +0000
[Programming Help] - Return unique value in column range
View Count: 897
| [2020-01-14 08:08:06] |
| User345071 - Posts: 11 |
|
im looking to extract unique values from a column using this formula. =INDEX($AA$3:$AA$15, MATCH(0,IF(ISBLANK($AA$3:$AA$15),1,COUNTIF($H$2:H2, $AA$3:$AA$15)), 0)) Source: https://www.listendata.com/2013/05/excel-3-ways-to-extract-unique-values.html This doesn't work on Sierra Chart. Does support or any other users know how this can be achieved? Thanks Date Time Of Last Edit: 2020-01-14 08:08:28
|
To post a message in this thread, you need to log in with your Sierra Chart account: