Support Board

Date/Time: Sun, 21 Dec 2025 03:26:01 +0000

Post From: Return unique value in column range

[2020-01-14 08:08:06] Link To Thread - Link To Post [Go To First Post]
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