|
|
|
Help!! urgent
Mon, 8 Mar 2010 19:21:01 -0800
I was using Excel 2007 quite happily, and must have hit something on the
keyboard, because now every time I touch keys windows spring open and I am
powerless to do anything on my spreadsheet. I have tried restarting the
computer. How do i turn off this feature? ...
|
putting a set of values into a group of bins
Mon, 08 Mar 2010 20:01:25 -0500
I have a column of numbers and I want to count how many are between 1 and 10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go, or
is there another alternative.
Thanks
Elliott ...
|
show with messaje box when it's time and date
Mon, 8 Mar 2010 18:12:07 -0430
HELLO FRIENDS NEED HELP
I HAVE THE COLUMN (A) The time to write date and hour Next notice /Alarm, I
need
Warn me when it's time and date of notice/alarm start up show with messaje
box
Message with the message that I write in the same row of column ( B) in the
same row
EXAMPLE:
A ...
|
External Data wont refresh on a prtected and shared workbook...
Mon, 8 Mar 2010 12:28:01 -0800
I have a workbook that is used by multiple people over a network. In this
workbook I added some data from a site that i wanted refreshed everytime the
workbook is opened. I found out i can't protect the worksheet or protect and
share the workbook and still have it refresh the data. Is there a way to
prote ...
|
Replace massively formulas with new formulas
Mon, 8 Mar 2010 06:33:57 -0800 (PST)
Hi there,
would like to get your input/hints on how to solve the following:
In a series of cells in a row, I already have a formula calculating a
division among two other columns.
The rows are many (more than 500).
But now I need to apply a ROUND formula, on top of the existing ones.
ex. cell C5 = A1/B1
and I ...
|
How to replace ~ with other value ?
Sun, 7 Mar 2010 23:34:34 -0800 (PST)
Hi Reader
I have some cell have ~ in order number column, How to replace ~ to
two -- ?
Due vlookup can not handle ~.
Moonhkt ...
|
Print Dialogue Box
Sun, 7 Mar 2010 21:20:48 -0800 (PST)
What is the macro command (code) to just open the Print dialogue box
without printing?
I tried this macro ExecuteExcel4Macro
"PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet.
Than kyou. ...
|
|
|
calculating the number of pay-dates before a bill is due?
Sun, 7 Mar 2010 03:50:03 -0800 (PST)
I'm trying to make up a budget for my family, and I'd like to have
Excel tell me how much $ from each paydate I need to set aside, in
order to meet my upcoming bills. So:
1. I'd like to be able to enter in the amount of an upcoming bill
(a1),
2. the due-date of an upcoming bill (b1),
3. then somehow have ...
|
vlookup
Sun, 7 Mar 2010 19:25:02 +0800
How do I use vlookup if ret =abcd, dept = 999 and return value of no = 4 ?
ret dept no
abdf 123 1
abcd 234 2
defg 999 3
abcd 999 4
rgrg 456 5
wdff 547 6
abcd 888 7
...
|
Conditional formatting (Excel 2007)
Sat, 06 Mar 2010 07:59:03 -0800
I am using Excel 2007.
I am trying to format time values that can range from seconds to
years. If the time is below some threshold, say 1 day, I want to use
the hh:mm:ss format. If it's larger that 1 day, I want to use the 0.00
format. After a little study, I selected this conditional format
string:
[<1 ...
|
|
|
