Forum Discussion
Total is not working
My total calculation is not working in below example: Data: Shee1: ID CHANNEL 1 A 2 A 3 A 5 A 6 A 7 A 1 B 2 B 4 B 6 B 7 B 1 C 2 C 3 C...
Thank you for your reply. I frorgot to tell one thing here. I am trying to calculate here is that one ID is coming in how many distinct channel. As I have Max 3 channels here, I can get 1 or 2 or 3 count. Means How many IDs are coming in only one channel and How many IDs are coming two channel and how many IDs are coming in three channels.
Ritaf1983
Super User
Super UserThat's fine, my formula does exactly that.
Please note that ID 1 in my table has duplicate channels.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.