Date shown as just month and year
Tue, 30 Sep 2008 09:48:26 -0700 (PDT)
In column D I have a date in the standard format of 22/02/2008, in
column K i would like that date to be displayed as the month and
year. So in this case "Feb 2008"
I believe i can just add a simple formula that will lookup the date in
column D and display it as requested.
Could anybody assist please.
W ...
|
add times
Tue, 30 Sep 2008 09:40:11 -0700
I am trying to add this times in my time sheet but I don't know what I'm
doing wrong
8:00 =TEXT(E7+H7,"h:mm) This is the formula I used to get the total for the
day and is ok but know I can't get the total for the week
I used this =SUM(I7:I10) but it won't work. ...
|
I can't figure how to Sorting
Tue, 30 Sep 2008 08:51:02 -0700
Iâ??ve run into a problem when trying to sort information. Here is my problem.
I get many blue prints each day that have numbered with areas that need to be
measured. Each blue print is different. On one blue print I may only have
three (3) areas that need to be measured when a different blue print may have
...
|
how do i find out a turnover %
Tue, 30 Sep 2008 07:54:01 -0700
Can someone please help me ...
|
how can i set excel 2007 to do a "calculate on open"?
Tue, 30 Sep 2008 01:43:02 -0700
When I open Excel itself - it opens fine.
When I open an excel file - it will not open until I right click and select
'calculate'.
Can anyone tell me why? Or How do I set a default "calculate on open"?
Thanks
SER ...
|
EXCEL 2007 no longer add properly
Mon, 29 Sep 2008 19:23:00 -0700
In cell k17 I have the number 1
in cell l17 I have the number 2
in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be)
Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the
answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20
and l20
What ...
|
Lookup based on criteria in 2 columns
Mon, 29 Sep 2008 13:31:00 -0700
Hi,
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16 ...
|
|
|
Input Dialog box
Mon, 29 Sep 2008 09:41:01 -0700
I am trying to create a dialog box in one cell which checks value in anoth
cell (e.g. yes or no) and if it is yes, then asks for a value number (1-100)
and if it is no then enters a zero. Can anybody help with this box, I am
novice use of excel so a step by step instructiion will be greatly
appreciated. Or ...
|
Excel (Need a formula)
Mon, 29 Sep 2008 07:10:02 -0700
I need a formula that will enable me to count how many of each product there
is. For example in one column there could be five different products appear
several times and in the column next to it I have the amount of product. I
want the formula to look up the two columns and give me the total of each
produ ...
|
Beep on greater than zero
Mon, 29 Sep 2008 06:45:02 -0700
I have an excel spreadsheet with several columns. To verify that data has
been entered correctly I have a column that adds all the columns and should
equal zero if they are entered correctly. Since the "proofing column" is not
always visable unless I tab to the end of the worksheet, I would like to hear
a ...
|
