User Profile
Young_Grasshopper_EIT
Copper Contributor
Joined Jul 14, 2023
User Widgets
Recent Discussions
Re: Help Counting Cells with Numbers and Text without counting duplicates.
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!1.2KViews1like0CommentsRe: Help Counting Cells with Numbers and Text without counting duplicates.
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!1.3KViews0likes2CommentsRe: Help Counting Cells with Numbers and Text without counting duplicates.
Thank you for your quick reply! Here is the sample file! The large set of data at the top of the file will be different every time. I am trying to create a template file. Every time I need to use this file I will copy and paste that first table from another program. I then want to figure out how to pull the information needed to generate the tables seen on the "Protected Tree Total" sheet . I want to make the file as dynamic as possible so anybody can open it, copy and paste the first large table, and it will give them all the subsequent tables on sheet 2.1.3KViews0likes4CommentsHelp 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 "8"MAPLE","9"MAPLE","10"MAPLE" into the second table. Is there a way for excel to read through the first table (the first picture) find all the different size trees and then generate the second table (picture 2) without having to manually read through the first table and manually insert all different sizes for the trees?Solved1.4KViews0likes6Comments
Recent Blog Articles
No content to show