Forum Discussion
Need help to build excel formulas
Hello everyone, I need help with to process some data. Problem 1: As per mentioned below, Can you please show me formula used so that i can have result for example, "3" in I7 column (An...
Hi, thank you for your reply.
I'm sorry if my question came out wrongly. English is not my first language :)
What I would like to ask is what formula can be used in order to show result as per requirement in I4-I11. For example, on 3/12/18, only 3 unique names appear. So I need 3 to be shown on I6.
And for the file I attached earlier, I didn't encounter same error as yours. I was able to download the file even from different device.
I'm sorry if my question came out wrongly. English is not my first language :)
What I would like to ask is what formula can be used in order to show result as per requirement in I4-I11. For example, on 3/12/18, only 3 unique names appear. So I need 3 to be shown on I6.
And for the file I attached earlier, I didn't encounter same error as yours. I was able to download the file even from different device.
Hello again :) OK, now I understand - hopefully. Your formula in I4-I11 has to be something with countif and I attached you another example, because my Excel is kind of preppy today... never mind.
Hope that screenshot helps :)
