Forum Discussion
RobDevens
Jan 26, 2023Copper Contributor
Formula Help Needed to find Distinct Client Interactions
Hi! I'm using Microsoft Excel 2016 on a PC. I am creating a report that lists the number of specific types of interactions with clients by Team during a chosen time frame. I have been able to a...
RobDevens
Jan 27, 2023Copper Contributor
Thanks for the suggestion! When I use this, though, I don't end up with the correct result. The formula produces 0.058823529 as the value.
Martin_Weiss
Jan 30, 2023Bronze Contributor
It's very difficult to find out the reason for this without the file. So if possible, could you upload a sample file (without any sensitive data, of course), so it's easier for us to find a solution.
- RobDevensJan 31, 2023Copper ContributorThanks, Martin, I wasn't sure how to do that, but thought that attaching a link in my post to the file in Google docs would work. Sorry if that doesn't work. Here is the link again:
https://docs.google.com/spreadsheets/d/1VwOR_Y5qQTYDgK2Px3tdm0jKjARb-5Cj/edit#gid=2111119363
Now that I try the link I realize it opens in Google docs instead of just being able to download the excel file.
Some advice on how to upload the sample file would be appreciated :^)