INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Need help with Boolean logic on a data list

Need help with Boolean logic on a data list

(OP)
I am not normally this troubled, but this has been baffling me for 3 days.

See attached xlsx file.

RE: Need help with Boolean logic on a data list

(OP)
Sorry, I forgot Rule #6:

6) "CONT" is manually input into col C only if suffix of col B is "A". I don't want "CONT" automatically generated in col C, it has to be input in only one instance on the entire worksheet.

RE: Need help with Boolean logic on a data list

On the spreadsheet, I don't understand:
"and green D row shall be inverse of whateved non-zero sequence 1 to 2 or anything up to 1 to 5"

Also you seem to have your rows and columns reversed in some of the rules.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Need help with Boolean logic on a data list

(OP)
ps

The numbers in col D and col E are for indexing, looking up data elsewhere.

RE: Need help with Boolean logic on a data list

(OP)
ps #2 -

Don't spend any more time on this, I started a fresh approach and am making some headway. It may be very inelegant but it seems to be the right direction.

Just don't waste any more time on this - until I notify otherwise.

RE: Need help with Boolean logic on a data list

(OP)
Well, all was for naught. I am getting absolutely nowhere. If no one can find the solution to this, I am giving up on this particular functionality in my workbook.

RE: Need help with Boolean logic on a data list

oh, btw, I assigned col_d to the entire column, so the example that starts in E28 will actually pull the max from the subsequent example. If you plan on having more than one set of stuff in the same column, you'll need to assign unique ranges.

My markup: http://files.engineering.com/getfile.aspx?folder=e...

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers

RE: Need help with Boolean logic on a data list

(OP)
IR, I modified "Book15" before receiving and reading your post 1:53 but I believe it works.

Thanks!!!

RE: Need help with Boolean logic on a data list

(OP)
IR, thanks again.

At first when I tried to use the info you gave me from your first post 1:48, nothing worked, almost like the cell formula was text instead. Then I tweaked a couple of things and it worked, altho a very slightly concept from what you gave me.

I wasn't familiar with that CODE function and the syntaxes of many things in those formulas were new to me.

Then later when you sent that 1:53 update, that worked too, "right out of the box".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close