|
|
|
September 16th, 2008 07:11 AM
by Max
|
5 |
107 |
|
|
Text entry into excel by
tobypitblado
Is it possible for me to set-up a spreadsheet for others to use but will
limit the options of the data that they can enter (text only), so that they
may only...
|
|
1 |
98 |
|
|
|
|
1 |
82 |
|
|
cross referencing by
JockW
Hi guys,
what would be the best way to cross reference a list of names in workbook1
with a huge list of names in workbook2. Ideally, if a name from w/b1 isn't...
|
September 16th, 2008 02:38 AM
by T. Valko
|
4 |
77 |
|
|
Blocking/Disabling selected worksheet by
DJ Ghale
I created an excel file for payroll purpose with each employee's pay info
broke down in separate worksheets. Is there a way i can disable or hide other...
|
|
1 |
94 |
|
|
if questions by
Mauro
Hello, i want to compare a cell between two number and return the sample
quantity. I tried to do this using the IF and & functions, but it dosent
works...
|
|
4 |
171 |
|
|
Need an Excel formula by
Paul G
I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years. My...
|
|
2 |
87 |
|
|
sum of info in a range based on dates by
Real esate guru
I'm creating a spreadsheet that shows expiration dates of property as well as
the square footage of each property. What I want to do is to find out the...
|
|
4 |
83 |
|
|
|
September 15th, 2008 10:12 PM
by Mike
|
2 |
76 |
|
|
IF Statement by
KC_Cheer_Coach[_2_]
I am creating a spreadsheet with several conditional formulas. They all work
except for one. I need the following:
IF S4 = YES and T4 = YES then W4 = YES...
|
September 15th, 2008 10:08 PM
by T. Valko
|
4 |
105 |
|
|
Adding up a column of percents by
Trish
I need to know the formula for adding up a row of percents....
I am trying to find the total of 5 percetages - this is a sales increase on
5 different...
|
|
3 |
83 |
|
|
some type of IF function by
WHERE IS THE ANY KEY????
Could someone please help with the formula for having a seperate column
return a value based on a drop down?? Column "B" is linked to column "K"
with all...
|
September 15th, 2008 08:57 PM
by Spiky
|
2 |
57 |
|
|
|
|
2 |
69 |
|
|
ASSIGN NUMBER SCORES TO LETTER GRADES by
DOUG ECKERT[_2_]
I want to code scores "E" and "S" as passing and "U" as not passing. Scores
are in a table of months arranged horizontally. Suggestions are welcome.
DOUG
|
|
4 |
90 |
|
|
Combining MATCH & LOOKUP formulas by
Txlonghorn76
I am trying to find a formula that matches the "Names" from my summary sheet
to a separate worksheet and if the names match, bring back the most recent
date...
|
|
7 |
88 |
|
|
Adding Cell to the left by
cmatera
R57 may or may not contain a #
If R57 contains a number I want to add the value of the cell to the
left of R57 so Q57 to the value of anothercell..lets say...
|
September 15th, 2008 08:01 PM
by Andri
|
3 |
69 |
|
|
Lookups??? by
KevinUPS
I have two sheets of data that both have multiple columns and multiple rows.
I am trying to populate the 1st sheet (one column / multiple rows) with data...
|
September 15th, 2008 07:50 PM
by Spiky
|
2 |
74 |
|
|
Format Time as Text by
bpc
I have a column of time values, (formatted for example as 14:50 or 6:15). I
am flexible on the format of this column. In an adjacent column I need the
time...
|
September 15th, 2008 07:50 PM
by Mike H
|
9 |
65 |
|
|
Using SUMPRODUCT with a VLOOKUP by
mae_bear22
Hi
I have a spreadsheet that goes as follows. Column A is Salesperson's name
and Column B is Achevied Sales Target (Yes or No). Column A gets it data...
|
September 15th, 2008 06:59 PM
by Mike H
|
4 |
71 |
|
|
time tracking formula (trying again) by
DebC
I am sorry to repost this question, but I have not received a response, and I
cannot figure this one out. This forum has helped me previously and I know
if...
|
September 15th, 2008 06:57 PM
by DebC
|
9 |
94 |