Forum Discussion
Counting Distinct values, number and text
It's been seven hours, over 35 views.... your short fuse might just burn down to the nub.
The spreadsheet you have posted is perhaps clear to you in terms of how to navigate its various sections, but isn't all that clear to somebody seeing it for the first time.
I am going to guess that everybody else who has looked at it and not responded has had the same reaction; I'm just doing the courtesy of letting you know....if you want help, you're going to need to make the organization of your sheet a LOT clearer.
It might benefit from having the extensive database on one sheet by itself, anchored in the upper left hand corner. Then take the various areas meant to extract and analyze the database, to produce those desired results, and place them on their own sheet, and there too not separated by all kinds of white space.
You might even benefit from being able to see things more clearly. You certainly would improve your chances of getting a more substantive reply.
I thank you for the guidancemathetes . I've not posted for help before and appreciate the kind words as it has made my 20+ years in the Marines much brighter... 😉 Seriously though, I'll adjust the data but I don't understand what "anchoring in the upper left hand corner" would do to help.... but I'll try.
Gregg
"Anchoring in the upper left corner" was simply my way of saying "place the table there" so that it's immediately apparent when you open up the sheet. As it is, one has to go hunting. For each thing on your sheet. It's kind of a nightmare to anyone who wasn't part of its creation. And my guess is that you find it frustrating to navigate as well. One of the true values of using multiple sheets is the advantage of being able to find your way around each without much trouble. Make each sheet more dedicated to at most a few tasks or functions. You can always link across sheets........ This is especially true if you're going to be asking for help.
mathetes, you're right on the frustration at times. I appreciate the insight and advice. I hope someone can assist me in a formula to count the distinct data vice "hand jamming" and calculating the info for each year. the master workbook is already 400mb with 30+ sheets. Maybe thats small to some, but its BIG to me.
