|
|
|
|
4 |
371 |
|
|
Date Formula Help by
SMonczka
Someone here once gave me the formula for converting a Date to the
number of the week. In other words 1/16 would be 3 as it falls on the
3 week of the year....
|
|
4 |
185 |
|
|
|
|
4 |
320 |
|
|
What function would I use? by
Capn_Chord
Thanks for the suggestion it did work really well, but I
think I'm dealing with a little too much data for it.
This is an example of what I'm trying to...
|
July 3rd, 2004 09:45 AM
by AlfD
|
5 |
239 |
|
|
|
|
1 |
163 |
|
|
date and sending message by
rpahl
I am trying to create a macro that sends a specific number to a
specific cell on a certain day.
"If the first day of the month, then send 75 to cell A2
If the...
|
|
2 |
150 |
|
|
|
|
7 |
942 |
|
|
filter out all the #n/a... by
sokevin
I have done a vlookup in col(b), col(c) and col(d)
i want to summarise column b,c,d in column E
e.g
if col b2 = #na, c2=#na, d2=300 then i want e2=300
if...
|
|
2 |
167 |
|
|
AutoFilter not an Option by
Jeremy
I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the...
|
July 3rd, 2004 04:41 PM
by Jeremy
|
3 |
146 |
|
|
Auto refresh of Pivot Table by
K. Georgiadis
I found the following code on C. Pearson's website:
Sub Auto_Open()
Application.OnSheetActivate = "UpdateIt"
End Sub
Sub UpdateIt()
Dim iP As...
|
|
2 |
118 |
|
|
Matching by
gary
a1..e711 contains data in this format:
Part-nbr Date Amount
008101815-8 03/12/2001 751.72
008101816-9 03/12/2001 514.50
008101817-0 03/12/2001 ...
|
|
2 |
165 |
|
|
Work menu in Excel? by
billlake
~× wrote:
*Very handy feature in Word. It's a menu where you can add the
documents you work most frequently with. Much better than the Recent
Files...
( 1 2)
|
July 3rd, 2004 10:15 PM
by Andy
|
13 |
695 |
|
|
Using formulae to display pictures.... by
matt_123
Hopefully there is somebody that can help me with this predicament. I
regularly compile quizzes on excel which get sent out & are now viewed
as far afield as...
|
July 3rd, 2004 10:32 PM
by AlfD
|
2 |
361 |
|
|
|
|
2 |
2,143 |
|
|
count if by
gregork
I need a formula to return text based on that text being in all the cells in
a range. I want the formula to ignore blank cells in the range. I have...
|
|
6 |
254 |
|
|
Reduce chart white space by
Vinod
When I create a pie chart, a terrible amount of white space exists
around the pie. When I insert it into PowerPoint, it takes up way too
much room.
I can...
|
|
2 |
431 |
|
|
Data validation input message by
DT
Can anyone please offer any advice? ..... I am using data validation on a
worksheet and would like to resize the message box that appears when the
cell is...
|
|
8 |
226 |
|
|
pop-up/comment of text in chart by
acl
Hi
I am basically brand new to VBA and excel macros...so please keep that
in mind. If the solution lies in either of those, if you would be kind
enough to...
|
|
2 |
209 |
|
|
Athos by
Athos
is there a way to write this as a formula?
I want each cell (B1:B10) to refer to a fixed cell(A1) in
the following way:
Cell B1 = $A$1 * n. Where n is a...
( 1 2)
|
|
13 |
242 |
|
|
Excel to Lotus by
xippy
Is there a way to convert an MS Excel spreadsheet to Lotus? I have saved an
Excel file, but it's Read Only for some reason, and doesn't...
|
|
1 |
176 |