|
Sort Dates by Month and Day, Not Year
Is there a trick to sort a date column by Month and Day, and not have it
sort the list by year as first sort. Without breaking up the data into
multiple columns.
...
|
5 |
12/29/2008 8:48:56 PM |
|
|
Show hours worked or Text "Day Off"
I have a spreadsheet that keeps track of hours worked during the week. The
formula is =IF(OR(B23="",C23="",D23="",E23=""),"Day Off",(TEXT(B23,"h:mm
AM/PM")&" - "&TEXT(C23,"h:mm AM/PM")
&"
"&TEXT(D23,"h:mm AM/PM")&" - "&TEXT(E23,"h:mm AM/PM")))
The columns track the In and Out times, Column B is In, Column C is Out,
Column D is In, Column E is Out.
This works great when there are n...
|
9 |
12/29/2008 8:19:01 PM |
|
|
Can Excel simulate a simple 2-dimensional database?
I need something that is half way between Word and Access. I'm
wondering if Excel can fill the bill.
For tome to time, I have a need to keep track of "events" and
calculate subtotals along more than 1 dimension. One example is gifts
where I could get subtotals by year and person.
My current application is annual giving. I'd like to create a
"database" with these fields:
DATE AMO...
|
5 |
12/29/2008 7:46:08 PM |
|
|
runtime error
I recently got a new computer and purchased Office 2007 with it.
Every time
i open Excel i get the following error message:
Run-time error '-2147467259 (80004005)':
Method 'Add' of object 'CommandBarControals' failed
I click on End and the file opens fine. Any ideas on how to get rid of
this
error message?
Thanks,
Jenn...
|
2 |
12/29/2008 5:48:48 PM |
|
|
Excel Negative Time Format
When I input these keys:
Spacebar
:
Enter
Excel cell displays ######### (-0.0416666666666667)
-1/24 also displays -0.0416666666666667
Anyone knows why these four keys caused such result?
Elaborate more:
when input
Spacebar + : + 1 shows 00:59
Spacebar + : + 2 shows 01:59
....
Spacebar + : + 24 shows 23:59
Spacebar + : + 25 shows 01/01/1900 12:59:00 AM
....
Spacebar...
|
9 |
12/29/2008 4:03:37 PM |
|
|
problem in opening excel 2003
hi, myself Debashis
whenever I am opening excel 2003, it is opening having rows in right side
and column number starting from right side of all sheets.
but if I create the file first, as like new> New Microsoft Excel Worksheet,
it is opening normally
pls advice
thanks in advance
...
|
5 |
12/29/2008 6:35:21 AM |
|
|
Question about IF function
I would like to have every cell in column A that has value of "0.00"
be changed to "NO" and every cell that is > 0.00 to have number values
changed to "YES". What would the formula be?
Thanks in advance.
...
|
3 |
12/29/2008 5:55:06 AM |
|
|
how to paste email address string into each cell in the spread sheet
How to copy / paste email addresses into each cell in the spread sheet?
We are using Outlook for email. For intra-office memo, we have long list of
email addresses in different project groups and different discussion /
meeting groups of distribution list.
Typical Outlook email address in the cc: list string we can copy / paste
from is like this
'adam@aol.com'; 'john@yahoo.com'; 'mary@gmail...
|
8 |
12/29/2008 3:12:47 AM |
|
|
Hyperlinks and buttons in Excel 2007
Hi...
How do I, in the long and dark hours of a declining year, create a button
with a link to a web page in a workbook?
VB, I guess, but I don't know the code....
I have tried HYPERLINK() but the link do not work as it so flawlessly does
in Outlook.
It's a link with password and username in it....
--
Vennlig hilsen
Øyvind Granberg
tresfjording@live.no
www.tresfjording.co...
|
3 |
12/29/2008 12:32:20 AM |
|
|
open option for comma separated var file when commas missing?
Excel fails to open a speedfan log file (ends in ".csv") correctly as the
file contains tabs instead of commas. The developer is aware of this and
suggests using ooo instead of ms office. I don't think this will get fixed
anytime soon and I was looking at 2007 excel and seeing if I could change
the open option to where it recognizes tabs as a delimiter. If I rename the
file to end in ...
|
4 |
12/28/2008 11:24:44 PM |
|
|
Can't Insert Comments
Excel 2007
I tried to insert comments by right clicking on the cell, but the
option has disappeared.
I then clicked ont the "Review" tab, but everything but "show all
comments" is grayed out.
I opened another spreadsheet and the options are all there.
What the heck did I do?...
|
4 |
12/28/2008 7:56:15 PM |
|
|
if you suffer of viruses every day
if you suffer of viruses every day go this url. download the best
viruses software at all AVG anti-virus free edition 8.0.176
http://magnficant-google-adsense.blogspot.com
...
|
2 |
12/28/2008 7:48:32 PM |
|
|
Requesting virus scan
Requesting virus scan......Is this an excel thing or is it part of something
else?
I would like to turn it off if possible, but how?
thanks
...
|
2 |
12/28/2008 3:54:05 PM |
|
|
SUPRISE...!
http://onlinemovies-music.blogspot.com/...
|
1 |
12/28/2008 3:33:50 PM |
|
|
is there a way to add chart to a protected sheet?
I need a macro. if not is it possible to add it to a hidden sheet
Sub Graph()
ActiveSheet.Shapes.AddChart.Select
With ActiveChart
With .Parent
.Top = Range("d3").Top
.Left = Range("d3").Left
.Width = Range("d3:d16").Width
.Height = Range("d3:d16").Height
.Name = "Chart"
End With
.Axes(xlCatego...
|
3 |
12/28/2008 9:27:37 AM |
|
|
Spacing around text
I have a column of cells containing text. The amount of text varies. I
enter it with word wrap, so the height of each cell adjusts to fit the
text. Therein lies the problem. The text fills the cell from top to
bottom. When I print the column, it looks like a single column of
text.
How can I add some spacing around each block of text so that each is
visually distinct in the printed result?
...
|
2 |
12/28/2008 9:07:47 AM |
|
|
Pivot Table - monthy dates
I'm using Excel 2000. I have financial data with expenditures by date. I've
added a column to calculate the month and year of the expense. A pivot table
has been built over the data to show the expenditures by year (rows) and
month (columns).
I need to have all months (Jan...Dec) listed to be able to link from another
spreadsheet. However not all months has expenditure.
Is there a ...
|
5 |
12/28/2008 8:53:01 AM |
|
|
excel 2002 pagenumbering when workbook is along y-axis instaed
I hope I did not confuse you with x and y. x is starting from left sheet 1,
sheet 2, etc. Y means i use sheet 1, and then copy and paste below, it
successivley 2, 3, etc. Then I select the whole vertical area as the print
area. I do page break and get say 7 pages
How do i number these automatically as 1 of 7, 2 of 7, 3 of 7---
How do i number these as 2 of 8, 3 of 8, etc. if I have th...
|
2 |
12/27/2008 7:55:38 PM |
|
|
copy and paste
Hi all
I am looking for a vba solution to join 3 sheets with variable records to
one sheet sequentially like this sample:
sheet1:
___A___B__
1 Q1 12
2 Q3 32
sheet2:
___A___B__
1 Q2 22
2 Q1 11
sheet3:
___A___B__
1 Q4 19
2 Q2 15
Target sheet:
___A___B___C___D___
1 Q1 12
2 Q3 32
3 Q2 ...
|
3 |
12/27/2008 1:40:50 PM |
|
|
The arrow keys stopped working properly
Dear All,
Suddenly, the arrow keys stopped working properly, i.e., when I hit
them, I get the start menu of Windows2000 instead of having the cursor
moving to a different cell in the Excel spreadsheet. Any ideas?
Thanks in advance,
Paul...
|
4 |
12/26/2008 7:33:27 PM |
|
|
SUM by color type
Hi,
I want to sum cells of certain color. Googled the function
and came up with =colorfunction
=colorfunction($B$1,$B$3:$B$52,TRUE)
Per the example, aside from adding cells from B3 to B52 , I also want to
include range from E3 to E52. How do I include this in the formula?
Thanks a bunch!
...
|
6 |
12/25/2008 11:00:31 PM |
|
|
Getting cell value of composed address
I have a grid of data where I am trying to apply conditional
formatting. The logic is that, for every cell in a column, if it's
value matches what is in row 3 of that column then I want to apply the
conditional formatting. So I have the following formula:
=EXACT(OFFSET($E$3,ROW()-3,0),$E$3)
and it works. The problem is that I have to apply this to every row,
and each time the only mod...
|
3 |
12/25/2008 5:24:46 AM |
|
|
Separating First Name(s) and Last Name into Separate Columns
I have a spreadsheet with one column ("name") that contains names in the
following formats occuring randomly down the list:
Firstname Lastname
Firstname & Firstname Lastname
Firstname Lastname & Firstname Lastname
I need to get them all into two new columns "firstname" and "lastname" and
I'm having difficulties writing a formula to account for all 3 scenarios in
one cell. (If I have...
|
5 |
12/25/2008 3:41:38 AM |
|
|
New to Excel Macros
I'm converting some Quatro Pro spreadsheets to Excel and am having problems
figuring out some of the requirements for Excel macros.
Here is an example. It converts several cells across columns from calculated
figures to numbers. As you can see it really is simple and repetitive, but
I'm stuck.
Thanks in advance, Terry
Macro to change formulas to values
after making allotment inpu...
|
2 |
12/24/2008 5:10:47 PM |
|
|
Macro for autonumbering
Hi guys,
I'm designing a macro -even not being a macro expert- to process some
different files. In these files, I've some data in column B.
I want to make an autonumbering in column A (from cell A2 and below)
which reaches the same row that the data in column B. Both in column A
and B I have headers, that's the reason why I want to start from cell
A2. The number incrementation must be in...
|
4 |
12/24/2008 2:09:12 PM |