Frustrating Excel Formula! I do not know where to begin

[alecp]

Hello Excel Gurus,


I have a problem where I need to match certain defined groups of parameters to where they would be popping up in a historical sheet. For instance: Identity 1 could be defined as 101-105 and Identity 2 could be 109-112...but these will not pop up in order! I need a way to match these parameters to these different identities! The sheet attached helps, sorry for the vagueness!


Thank you for your help!

Patterson

[TMS]

Maybe:

=IF(COUNTIF(A2:A6,101)+COUNTIF(A2:A6,102)+COUNTIF(A2:A6,103)+COUNTIF(A2:A6,104)+COUNTIF(A2:A6,105)=5,"Identity 1","")


Regards, TMS

[Tartarus]

Hello Trevor,
Allow me to improve upon your idea:-

Please Login or Register  to view this content.

Regards, Tartarus

[alecp]

I appreciate the replies, and those would work. But I am looking ahead at what I need to do and I realize that I did not ask this question properly. I am going to have a type of database sheet that is going to have what parameters all of the different identities are, and I need the formula to somehow use that. I was thinking about using names or something, I am still unsure. I attached an updated form to maybe help clarify.


Thanks once again!

[alecp]

Also - tartarus:

Is there a character limit on the formula field? Because I could go through and type them in like that if need be instead of using the database thing, but there are going to but dozens and dozens of these "identities"...any ideas?

[Cutter]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Tartarus]

Looks like you want to work your way from the middle toward both ends, enlisting help without disclosing what the ends are or which end you want to reach first. An endless formula will not give you what you want.
You seem to have realised that the construction of your list of identities is key to the problem. So, why not work on that list? Where do the numbers in your list come from? Is it something like if you are free (100), white (101) and 21 (102) your identity is #1?
In such a scenario you would have a number of check boxes and by the time you clicked "married" it's already clear that you aren't free and therefore not of #1 identity. Hence, the solution would have to be found in the evaluation of the check boxes and certainly not in a formula like we have been looking at.

[arlu1201]

Tartarus,

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc