|
|
Calculating a percent decrease by
Karen[_10_]
I am working on a spreadsheet which calcualtes a decrease in base wages,
which is working fine: A1*(1-A2)= X or $15.00 *(1-8%) = $13.80. Howeever,
when I...
|
February 18th, 2009 05:20 PM
by joeu2004
|
2 |
57 |
|
|
Count Unique Values by
Joe Gieder
I'm trying to count unique values based on muliple criteria. I tried using
the formula...
|
February 18th, 2009 05:01 PM
by T. Valko
|
4 |
84 |
|
|
Data Validation w/an If Statement by
Steve
Is it possible to use the Data Validation function with an if statement; then
if the if statement is false limit the input value based on a drop down...
|
February 18th, 2009 05:00 PM
by Eduardo
|
1 |
156 |
|
|
Average by
S. Kissing
I have 13 sheets, Jan - Dec and a total sheet. I want to average cells in
the Jan - Dec sheets. If I add my formula to the sheets then my average
counts...
|
February 18th, 2009 04:53 PM
by Eduardo
|
2 |
52 |
|
|
List of workbook tabs by
Donna
I have a workbook with 100 sheets, named by employee. I want to get a
printout of the tab names so that I don't have to go through the entire list
to see if...
|
|
3 |
51 |
|
|
converting text into years by
Craig
Hi,
I have one column of text imported into excel that looks like column A
data...I want to use a function that would give me whats in Column B, that
is,...
|
February 18th, 2009 04:50 PM
by Pete_UK
|
4 |
46 |
|
|
~Time Calculation by
Karen
I have a formula that calculates time.
The following cells contain the following data.
Cell B381 contains 8:00 AM
Cell C381 contains 4:45 PM
Cell E381 contains...
|
February 18th, 2009 04:43 PM
by Pete_UK
|
6 |
83 |
|
|
|
|
16 |
118 |
|
|
Goal Seek by
Sandra P
I think I need to use goal seek but am not sure how to get to where I need to
be. The scenerio is as follows: We currently pay personal car mileage.
Last...
|
|
1 |
50 |
|
|
Need help giving a response a number value by
ConfusedatWork
I am trying to set up a new tracking system for our Patient Satisfacion cards
to be used in evaluation staff. I have a system now where I simply plug in
the...
|
|
2 |
52 |
|
|
Index Match Problem by
MrRJ
Hi,
I created a formula that does not work for me. What did I do wrong?
=INDEX(B4:B15,MATCH(F18,C4:G15,0))
Thanks,
MrRJ
( 1 2)
|
February 18th, 2009 03:48 PM
by MrRJ
|
13 |
115 |
|
|
|
February 18th, 2009 03:44 PM
by Graham
|
4 |
62 |
|
|
Count Numbers by
Hardeep_kanwar[_2_]
HI! Expert
I have data in Two Column Like This:
Zone No.
East 4
East 8
East 6
East 31
East 5
East 9
East 3
|
February 18th, 2009 03:38 PM
by Mike H
|
4 |
83 |
|
|
auto extend formulas by
Ken[_21_]
Hi Group...
I have a spreadsheet that is up to about 8500 rows, and will
continue to grow at about 40 rows per day.....filtering is slow (about
6 - 10...
|
|
2 |
76 |
|
|
|
|
1 |
78 |
|
|
TODAY() function problem by
Iriemon
I have data arranged like this:
No. Payment Date
1 1-Sep-08
2 1-Oct-08
3 1-Nov-08
4 1-Dec-08
5 1-Jan-09
6 1-Feb-09
7 1-Mar-09
|
|
5 |
80 |
|
|
|
February 18th, 2009 02:43 PM
by rk
|
3 |
80 |
|
|
Correct #N/A Value by
winnie123
Hello,
I have created a formula using the threads I have seen and I can not get rid
of the #N/A value. The formula works ok if there is match or if the value...
|
February 18th, 2009 02:17 PM
by Max
|
6 |
58 |
|
|
rearrange the data with a new table by
KS
I would like to transform my existing table A to table B.
Therefore, I can sort table B by customers for the subtotal.
Thanks. KS
Table...
|
February 18th, 2009 02:16 PM
by Max
|
6 |
78 |
|
|
Data gathering and reporting by
Eán[_2_]
I need to gather some analysis from various different colleagues on a daily
basis for a period of two weeks.
I am looking for a simple way/format I can use.
I...
|
February 18th, 2009 02:10 PM
by Luke M
|
1 |
80 |