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.
the file wasn't attached. If you can't attach it maybe upload and send link to it in Sharepoint, Onedrive, or similar.
In either case I recommend you make the first table 'Format as a Table' and then either the PivotTable or the formulas can reference that table by name and not worry about exactly how many rows of data there are.
In either case I recommend you make the first table 'Format as a Table' and then either the PivotTable or the formulas can reference that table by name and not worry about exactly how many rows of data there are.
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!