LinkBack URL
About LinkBacks
I use the following formula in Google Sheets to find unique values from a column. How could I do the same for a range like A:D?
=ARRAYFORMULA(IFERROR(INDEX($C$2:$C, MATCH(0,IF(ISBLANK($C$2:$C),1,COUNTIF($B$1:B1, $C$2:$C)), 0)),""))
I use the following formula in Google Sheets to find unique values from a column. How could I do the same for a range like A:D?
=ARRAYFORMULA(IFERROR(INDEX($C$2:$C, MATCH(0,IF(ISBLANK($C$2:$C),1,COUNTIF($B$1:B1, $C$2:$C)), 0)),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks