Hi guys,
ecountered some errors in my excel sheet.
Sample excel.xlsx
As you can see from the sample excel provided, i'm trying to derieve the number of unique clients from a specific country, however therea are some blanks, would this affect the function used?
The function (kindly provided by benishiryo) worked well on my original data sheet and in this example, HOWEVER for the cell with country "Singapore" with over 3000 accounts, i got an "#N/A" error. Not sure whats wrong with it :/
i'm trying to derieve also, the total amount of money from the accounts under this specific country, however i have some that are labeled as "NA" and some that are blanks, would these affect the function used?
IF anyone can be so kind to help me out.
Thanks in advance
Bookmarks