|
|
Time interval worksheet function by
Zb Kornecki
I would appriciate some help writing a function, to measure several interval
along a timeline. however not every interval applies to every record. what
I...
|
|
3 |
54 |
|
|
please help w/ a time formula by
Zb Kornecki
I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always
C,...
|
March 8th, 2007 01:18 AM
by Pete_UK
|
2 |
78 |
|
|
Number formatting by
ZB
Hi,
I am need to convert numbers from my excel file to a text file where the
number needs to show up as follows:
###############.##
So for $401.11 the amount...
|
April 24th, 2005 03:50 PM
by JulieD
|
5 |
76 |
|
|
|
May 15th, 2006 07:01 PM
by CLR
|
2 |
169 |
|
|
Pastable function using VLOOKUP? by
zatomics
This is my problem:
I have a spreadsheet with three separate cells, call them A, B, and C,
that I am using for inputs. These three input values create a table...
|
May 23rd, 2006 06:17 AM
by Max
|
1 |
79 |
|
|
|
|
1 |
94 |
|
|
Selected cells shadding Invisible. by
Zarrar Janjua
When I select rows and columns in Excel, the selected cells are too feint to
see clearly (much darker in previous releases). Is there a way of darkening
the...
|
June 6th, 2007 08:58 PM
by KCook
|
6 |
59 |
|
|
loan/lease repayment using IPMT/CUMIPMT by
zardozoz
I have been trying to create a monthly loan/lease calculation where there is
a residual at the end of a 5 year term. I am happy with each month (using
IPMT),...
|
|
2 |
104 |
|
|
Extracting Data for a Formula from a List by
Zaraf
I have a large list which I want to use two different criteria to find
one unique row. I was able to achieve this using the Autofilter
command (perfect with...
|
July 12th, 2006 09:16 PM
by Zaraf
|
2 |
72 |
|
|
changing the year of a date by
zapszipszops
Hi Everyone,
Is there a way I can easily change the year in a list of randon dates??
I have a table in excel, with date in the first column. I need to...
|
|
2 |
78 |
|
|
Macro causing large file size. by
ZAPPER
I created some Macros to do some simple functions (sort/filter/text to columns/create a new worksheet) on some fairly small data samples (max 200 rows and 8...
|
|
1 |
544 |
|
|
Lookup by
Zaphod117
I'm looking for a function that will lookup a value and return the value of
the cell directly below the cell in which the looked up value is found. In
this...
|
August 28th, 2007 03:26 AM
by Max
|
2 |
82 |
|
|
Ranking by multiple Criteria by
Zaphod117
I would like to rank a group based on two Criteria, and i can't figure it
out. I've got a list of 10 teams and I want to rank them based first on
winning %...
|
September 14th, 2007 07:05 AM
by T. Valko
|
2 |
80 |
|
|
bullet in excell with indent by
zap
I want use bullet in the excel cell with indent text. Could you please help
me, thatnks.
Waiting positive response.
|
|
1 |
67 |
|
|
Calculate 'exact' age in EXCEL by
Zanny Garbett
Try this with:
= date of birth;
= Date of death;
=DATEDIF(A1,B1,"y")&"y,"&DATEDIF(A1,B1,"ym")&"m,"&DATEDIF(A1,B1,"md")&"d"
Should work OK
Regards
|
|
4 |
83 |
|
|
Return value of the cell to the right... by
zangief
I have been using the function
=IF(COUNTIF(H:H,"Rory")0,I21,"")
It will return the value of cell of I21 if the name "Rory" is in column
H. I need to know if...
|
September 27th, 2005 04:35 AM
by Rowan
|
3 |
101 |
|
|
|
|
4 |
79 |
|
|
custom cell number by
zander
how do you format a cell so that when you enter 1254 the number is displayed
as 1,254,000
|
August 23rd, 2005 02:58 PM
by zander
|
4 |
139 |
|
|
|
|
1 |
109 |
|
|
|
|
1 |
81 |