Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default i need help with formula

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default i need help with formula

see:

http://www.contextures.com/xlDataVal02.html


--
Gary''s Student - gsnu200742


"Mandy" wrote:

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default i need help with formula

Take a look he

http://www.contextures.com/xlDataVal02.html

"Mandy" wrote:

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default i need help with formula

Thank you very much! It helped out and answered my question!

"Toppers" wrote:

Take a look he

http://www.contextures.com/xlDataVal02.html

"Mandy" wrote:

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default i need help with formula

See Debra Dalgleish's site for how to create dependent Data Validation lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Tue, 4 Sep 2007 12:10:15 -0700, Mandy
wrote:

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"