|
|
|
Drop Down lists
Thu, 2 Oct 2008 11:27:03 -0700
Is there a way to count different values in a column with drop down boxes.
For example, if I have a column with drop down lists, 2009 Q1, 2009 Q2, 2009
Q3, 2009 Q4 how do I count each time one of these is selected to get totals
for 2009 Q1, 2009 Q2, 2009 Q3, 2009 Q4?
Thanks.
--
Debbie ...
|
Two vlookup questions
Thu, 2 Oct 2008 11:19:03 -0700
Greetings everyone,
First question, is there anyway to "optimize" this formula:
=IF(J3="","",IF(J3="F",0,IF(J3="P",60,IF(J3<AU$6,100,IF(E3="M",IF(ISERROR(VLOOKUP(J3,'Male
Tables'!$AJ$4:AT$140,AR3)),"",VLOOKUP(J3,'Male
Tables'!$AJ$4:AT$140,AR3)),IF(ISERROR(VLOOKUP(J3,'Female
Tables'!$AH$4:AR$140,AR3)),"",VL ...
|
counting ranges with multiple variables
Thu, 2 Oct 2008 10:49:02 -0700
I'M TRYING TO COUNT A CERTAIN RANGE OF NAMES.
LEWIS MARQUITA 68
HAGANS LESLIE L 68
TYLER BRET J 67
NIMMONS SORENZO 67
GADSON GWENDOLY 65
RICKS KENNETH B 65
PONDER DENISE 65
CALLAWAY HENRY 65
LEE APRIL 64
BETTAC NATHAN D 64
CAMPBELL TAMMYE 64
PIPER SABRINA ...
|
HELP
Thu, 2 Oct 2008 10:29:09 -0700
I have a tracking chart with various drop down menus to select various info
(ie. attendee name, location, date, etc.) I have a seperate worksheet for
each month of the year. I then want to design a confirmation/ sign-off sheet
in which I want to pull the relevant information for each attendee to the
sign ...
|
Conditional formatting on Date
Thu, 2 Oct 2008 09:34:12 -0700
I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year. ...
|
Find a word in a table, then use a function
Thu, 2 Oct 2008 09:14:06 -0700
Hi everybody
I have a table with the days of the week, and the shifts for each one
eg
S1 Sun
S2 Sun
S3 Sun
S1 Mon
S2 Mon
etc
on column A
and in column B, the number of items manufactured
On another table, (column D) i have ONLY the days
Sun
Mon
Tue
etc
What I want to do is to sum in column E th ...
|
Excel formula needed
Thu, 2 Oct 2008 08:58:15 -0700
I have 2 worksheets in my workbook. The 1st worksheet is a datase of part
numbers and classification codes. It has about 30,000 part numbers and 100 or
more classification codes. The 2nd worksheet is where I enter part numbers to
get the classification code. I'm using a vlookup on sheet 2 to reference part
n ...
|
|
|
tilda in VLOOKUP and MATCH
Thu, 2 Oct 2008 08:46:09 -0700
What exactly do VLOOKUP and MATCH do with tildas (~) in text strings?
=VLOOKUP("Hello~ World",array,2,0)
will match "Hello World" but not "Hello~ World"
=MATCH("Hello~ World",array,0)
will not match either string.
I am using Excel 2003, and Help does not say anything about this for either
function.
...
|
perform a regression analysis
Thu, 2 Oct 2008 08:38:11 -0700
I need to know how to perform this analysis using Excel 2007. ...
|
Estimate number of emails to be send
Thu, 2 Oct 2008 08:19:53 -0700 (PDT)
I?m trying to estimate the number of people I need to pull from a
database based off certain criteria:
1. 5,000 people pulled initially from database and sent emails
2. Of those 5,000 people 4% open email
3. Of that 4% or 200 people only 27% or 54 people actually click and
complete questions in email
4. 300 ...
|
|
|
