Which functions help with ease of tabulation?

  • Thread starter Thread starter ntrain22
  • Start date Start date
N

ntrain22

I would like to create a spreadsheet that easily tabulates alpha-onl
results. I am working on a retention project for my job, and would lik
to track cancellation reasons, offers made, results and such. I woul
like to use drop-down menus so that users can select options with ease
and I would like for the spreadsheet to give numeric results based o
the alpha reasons that will be selected from. I need assistance i
creating the drop down menus and with getting Excel to turn alph
reasons to numeric results, if this is possible. :confused
 
go here to learn
http://www.contextures.com/tiptech.html

--
Don Guillett
SalesAid Software
(e-mail address removed)
ntrain22 said:
I would like to create a spreadsheet that easily tabulates alpha-only
results. I am working on a retention project for my job, and would like
to track cancellation reasons, offers made, results and such. I would
like to use drop-down menus so that users can select options with ease,
and I would like for the spreadsheet to give numeric results based on
the alpha reasons that will be selected from. I need assistance in
creating the drop down menus and with getting Excel to turn alpha
reasons to numeric results, if this is possible. :confused:


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
train

An example only........

In column A enter the Alphas(A1:A20)

In column B enter the numbers(B1:B20)

In D1 enter =VLOOKUP(C1,$A$1:$B$20,2,false)

Type an alpha into C1 and a number will appear in D1.

A further refinement would be to use Data Validation with a drop-down box in
C1(in this example) with your alphas as the "list" to choose from.

For more on Data Validation see Debra Dalgleish's site.....

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

Gord Dibben XL2002
 
Back
Top