|
|
Worksheet Name by
_Pete_
Hi All,
I am a first timer. So bare with me.
I would like to get the workbook name and place it in a cell in the
worksheet.
This is what I do. I copy a...
|
|
2 |
70 |
|
|
Help needed with priority list by
_SPCA
I need to take this list and pick a color by means of priority. In
this example, I put a priority of 1 for the color of orange in the
cell next to the color,...
|
January 20th, 2005 10:24 PM
by _SPCA
|
0 |
93 |
|
|
macro problem related with all worksheets by
___Zoom
Hi, I have a workbook with a lot of worksheets. I need to write a macro that:
a) takes an input of date in (dd.mm.yyyy) format.
b) takes an input of some...
|
August 4th, 2007 07:58 AM
by ___Zoom
|
7 |
89 |
|
|
excel - query by
| m o []
hi!
I am preparing a basic calculator for myself for some funds and I got into a
trouble...
there is a excel file U can...
|
|
1 |
151 |
|
|
How to Concatenate with a text & number by
|| cypher ||
A1 will have a 4 digit number and letter (ex: 1332s)
B1 will have a number between 1 & 999
I am trying to get C1 to concatenate the two, taking the B1 value...
|
|
1 |
123 |
|
|
|
|
4 |
134 |
|
|
Navigating by
~ One Fine Old Dude
I minimize Excel and size it so it uses 1/2 of my monitor window. I open
another window in the other half so I can copy data from this to Excel.
On...
|
|
0 |
55 |
|
|
Navigating by
~ One Fine Old Dude
I minimize Excel and size it so it uses 1/2 of my monitor window. I open
another window in the other half so I can copy data from this to Excel.
On...
|
|
0 |
61 |
|
|
Ignoring zero cells in IF statements by
~Andy~
Hi all - I'm not sure if it's an IF statement I need - but if it is then
I would like to know how to ignore cells with zero as the number.
Let me explain...
|
November 29th, 2005 02:20 PM
by SteveG
|
5 |
95 |
|
|
Excel Reference or VLookup? by
~Brenda
I am using Excel 2000. I have a spreadsheet that has some
calculations that are simple totaling of columns.
Rather than rekey that total on another...
( 1 2)
|
July 20th, 2004 11:57 PM
by Don
|
10 |
290 |
|
|
|
|
12 |
200 |
|
|
|
May 2nd, 2006 02:09 PM
by ~C
|
2 |
89 |
|
|
Summing lookup values by
~C
I have a spreadsheet and I need to use a VLookup that then sums the returned
values that repeat. Below is an example, where Ashish shows up 3 times in...
|
|
4 |
67 |
|
|
Concatenation question by
~C
I have four feilds, First, Middle, Last and Email. I want to use a
concatenation function in Email to combine First middle and last and
automatically add the...
|
|
1 |
75 |
|
|
Combining Worksheets into one by
~C
A client emails me a worksheet with to indicate which duplicate records need
to be deleted. The client has multiple locations, so each location fills
marks...
|
February 2nd, 2006 03:29 PM
by ~C
|
2 |
93 |
|
|
If cell is not blank, then line out row by
~C
I have a spreadsheet. When I enter in a date in the "Date Reply Sent"
column, the issue is now closed. I would like that row to line out. Is
there a way to...
|
|
1 |
77 |
|
|
Time formula help by
~Jeff~
I have a cell that equals the remaining number of hours of vacation pay. I
would like to have a cell next to that that would indicate how many work
days are...
|
|
2 |
91 |
|
|
Monthly payment cells by
~Jeff~
If I have a starting cell equal to say: 8/1/2004
I would like each cell under that one to show the 1st of the next month. If
I change the starting cell, the...
|
|
2 |
100 |
|
|
Formula help by
~Jeff~
I want to calculate the monthly mortgage payment in my spreadsheet. The
interest rate is fixed
Cell values:
A4 = principle
A5 = interest rate
A6 = years of...
|
|
3 |
190 |
|
|
Text box character limit issue by
~L
I'm working with a spreadsheet that has automatic calculation disabled
because a large number of UDF database lookups refer to one cell and
recalculating the...
|
November 13th, 2008 06:52 PM
by ~L
|
0 |
71 |