Forum Discussion
Solved
Help Counting Cells with Numbers and Text without counting duplicates.
Currently I am reading through this table (first picture) and generating this table (second picture) My issue is that I have to manually search through the first table and manually input...
Young_Grasshopper_EIT here is the file back with 2 options. The first uses power pivot and the second a custom formula. Both use an input to decide which tree type to filter for.
I do apologize for that. It said that the xlsx file was not supported when I tried attaching it. I sent you a PM with the sample file attached! Thank you so very much for the help. I greatly appreciate it!
Young_Grasshopper_EIT here is the file back with 2 options. The first uses power pivot and the second a custom formula. Both use an input to decide which tree type to filter for.
- Thank you so much! I have been trying to wrap my head around how to do this for days! That custom formula is crazy. I kept trying to make a formula but I would get stuck trying to nest way too many if statements. I can't wait to dive into that custom code and the power pivot to see exactly how it works!