Forum

Here is the code I use, when I assign it to a form button, it doesn't clear "all data" sheet and paste the data from "export" sheet. can anyone she...

Thanks for all the solutions! Very helpful!

Thanks for your prompt reply! Does this formula work if the table has a query link behind? I still couldnt get Velouris's formula work on my spreadshe...

Thanks Phil, I downloaded your file, but the formula results show as '#NAME?', I don't know why. I tried inputting the formula as you suggested, a...

Thanks Velouria. I am not using O365, and I keep getting message 'You've entered too many arguments for this function.' - I am frustrated now...

sorry that forgot about it. just attached the file. wanted to count unique ID if filtering different fund. thanks

hi Sunny, I tried your suggestion, but the result was not changed. thanks, T

hello Sunny, thanks so much for the reply! I attached a sample file and pivot table, the grouping is not what I need, 10-60 60-11...

Thanks! but why does it not grouping like, 10-60 61-111 ? many thanks?