|
|
IF statement by
Liz J[_3_]
I'm looking at a spreadsheet that has 3 columns:
A: Name
B: Expense 1
C: Expense 2
I have a maximum amount, $1,000, that I can spend on both expenses, but,...
|
October 13th, 2009 10:58 PM
by smartin
|
1 |
125 |
|
|
Can't find Column A in my worksheet by
Ayo
The first column, Column A in my worksheet is not visible and I have tried
everything I know to make it visible and it's still not showing.
Any ideas?
|
|
3 |
117 |
|
|
Naming sheets after a range by
kefee85
I have a list of dates in A1:A15 I would automatically like to name sheets
3-18 after the values in that range.
|
|
3 |
124 |
|
|
Vlookup to return the next true value by
Donna
I am working to find a solution to a vlookup that I need to have return the
value for the first 11 characters of the vlookup for the last characters not...
|
October 13th, 2009 09:14 PM
by Donna
|
2 |
119 |
|
|
|
|
1 |
118 |
|
|
|
|
8 |
113 |
|
|
inserting an autoshape into a chart by
NG
Hello everyone,
I have a smiley that changes color (yellow, green, red) based on a
percentage, I made that work with some help.
What i need is to insert...
|
October 13th, 2009 07:40 PM
by NG
|
9 |
159 |
|
|
|
|
3 |
113 |
|
|
|
|
2 |
110 |
|
|
auto renumbering rows with blank spaces by
edithprado
I am so stumped on this one simple function! I am compiling an inventory list
of key rings we loaned to employees. Since there are different departments
with...
|
|
5 |
115 |
|
|
Cell formulas by
Vickie T.
I have two cells that I am using an IF function so that if there is no data
in cells used in the formulas, the cell is blank instead of showing 0.00. I
want...
|
|
2 |
114 |
|
|
paste web without date format by
tombugg55
When i paste from a web page, Excel 2007 automatically changes any text that
might be considered a date into date format. In the Excel help, it indicates...
|
October 13th, 2009 07:01 PM
by Joel
|
1 |
124 |
|
|
I am stumped. Help with Formula... by
Rob
I want A1 to equal the contents of a cell in the "last row with contents".
If not, then I want the cell in the row above it, and if not I want the cell
in...
|
October 13th, 2009 07:01 PM
by Rob
|
5 |
96 |
|
|
Basic Graph help by
Confusicous
I need an opinion for a simple line graph in which the data in b17, c17, d17
are on the Y axis and the data in b9, c9, d9 on the x axis. I only need one
line...
|
|
2 |
99 |
|
|
|
|
9 |
89 |
|
|
|
|
4 |
121 |
|
|
|
|
2 |
125 |
|
|
macro to add numbers based on set criteria by
David
Hi Everyone,
i am trying to create a macro that will add numbers based on set criteria
here is an example
I have a file over 20K lines and about 200 columns...
|
October 13th, 2009 06:01 PM
by Joel
|
6 |
92 |
|
|
How to fill up blanks by
deeds
I am trying to fill a range of blanks with the data at the bottom of the
selections. Example: I want to fill the "x" cells above the 200 with 200, I
want...
|
October 13th, 2009 05:52 PM
by deeds
|
4 |
130 |
|
|
Get information from one sheet to another by
holly2327
I have two data sources and I'm dumping one source onto sheet1 and the other
onto sheet2. I have a common id that is unique in each sheet in column B in
each...
|
|
2 |
97 |