All Hokie, All the Time. Period. Presented by

The Lounge Board

CochraneResident

Joined: 01/28/2002 Posts: 4883
Likes: 2215


Go to Data Validation, as you are making a list, then use an IF,THEN


statement to show the different groups. The statement is just if(Cell=1, A-C, D-G)

I just tried it, and it works like a charm.

(In response to this post by Technocrat)

Posted: 06/28/2017 at 09:38AM



+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


Current Thread:
 
  
Excel Grand Wizards - need assistance -- Technocrat 06/28/2017 09:00AM
  Much grass ** -- Technocrat 06/28/2017 10:02AM

Tech Sideline is Presented By:

Our Sponsors

vm307