Hi Experts and/or users,
In the attached workbook I was trying to extract unique values of a column using the formulae. I must confess that I have copied it from a google search and pasted it! For some reason the unique list if returning 0. Please look at column "H" and column "L" in the "Bank transactions" Tab.
Same formula in the other tab with a different set of data works!
COuld someone help please?
Thanks a bunch!
worksheet or tab name : Bank Transactions
Cell L3 formula , Drag down
Formula:
Please Login or Register to view this content.
Please try
=IFERROR(INDEX($H$3:$H$21, MATCH(0,COUNTIF($L$2:L2, $H$3:$H$21), 0)),"")
or faster than Countif with Match
=IFERROR(INDEX($H$3:$H$21,MATCH(TRUE,ISNA(MATCH($H$3:$H$21,M$2:M2,)),0)),"")
Hi wk9128 and Bo-Ry,
Thanks a lot for your help. Much appreciated. I have actually downloaded the file from Bo-Ry and I'm using it! Have a great day guys!
@kollur You're Welcome. Glad to help . Thank You for the feedback
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks