Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 21:37:30 +0000
Post From: Return unique value in column range
| [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
|