DESPERATE: Skipping questions / blacking out boxes (#2)

Status
Not open for further replies.

floridaboy2004

New Member
Joined
Nov 17, 2004
Messages
44
Hello all,

I have a question that I absolutely CANNOT solve...I believe that Cbrine touched on some of it before (thanks!), but I still cannot figure out how to do this:

If a customer has one of the following hobby preferences assigned #'s of 2, 7, 15, 22, 35, or 50 selected for arbitrary question # 2 (as an open box), then how could I 'black out' question #'s 31 through 33 (e.g. NOT allow an answer to be entered for #'s 31-33) on the form?

Also, if I fill in a customer data form and put "N" (for No) for question #5, then how could I 'black out' the REST of the form (e.g. question #'s 6-35)?

Also, if I fill in a customer data form and put "N" (for No) or "NA" (for No Answer) for question #8, then how could I 'black out' question # 21?

Could someone explain how I could select from my customer population BY AGE (at date of purchase) when the only 2 fields that I have on my form are DATE OF BIRTH (DOB) and DATE OF PURCHASE (DOP)? For example, if the customer was <40 years old on the date of purchase, I would like to skip question # 24.

The more specific (e.g. menus, fields, etc. to use) you can be, the better off I will be.

Thank-you again for your help, kind souls...I REALLY appreciate everyone's help as I learn how to do this!

Many thanks! -FB2004
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Status
Not open for further replies.

Forum statistics

Threads
1,221,831
Messages
6,162,242
Members
451,756
Latest member
tommyw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top