|
|
Split text to compare by
Manos
Dear all
I have a code extracted A1 from the system and looks like. Bill.Eko1
Bill.Eko37
Bill.Eko123
There is any possible way to keep from the code the...
|
August 26th, 2008 08:55 AM
by Manos
|
3 |
91 |
|
|
Row header by
Wong KM
How to change row header back to left-side of worksheet?
|
|
4 |
78 |
|
|
Workbook open event by
Pawan
Hi
I have written a code in workbook open event. But it works only if I closes
excel and reopens the file. If I close that particular workbook (without...
|
August 26th, 2008 07:32 AM
by Pawan
|
7 |
109 |
|
|
Rows to Columns by
Shazam
I have a spreadsheet that in A2 =NAME, B2 = ADDRESS, C2 = DENTAL, C3 =
MEDICAL, C4 = HCRA. I need to place column C to a horizontal range where C3
will be D2...
|
August 26th, 2008 06:43 AM
by Max
|
3 |
90 |
|
|
|
|
3 |
65 |
|
|
Lookup question by
Aline
I’m having problems this the following formula:
=LOOKUP(2,1/(Format!A2:A200=D3),B2:B200)
What I want is that only D3 becomes D4, D5, D6... and the rest...
|
August 26th, 2008 05:40 AM
by Sheeloo
|
3 |
125 |
|
|
|
|
0 |
88 |
|
|
COUNT IF by
readystate
I am trying to count values based on 3 sets of criteria. In this case, I am
trying to count the number of times the value in column A exceeds 1,000 but
only...
|
August 26th, 2008 05:32 AM
by Sheeloo
|
1 |
67 |
|
|
duration by
Keith_river
Hi there,
I want to use excel to calculate duration, but i don't know how to do it.
Term to maturity =30 years.
Coupon rate=3%
Yield to maturity=5%
coupon is...
|
|
1 |
86 |
|
|
NETWORKDAY + Excel 2007 + Excel 2003 by
Joe[_22_]
Hi
I have the following problem...
A workbook created in 2003 Excel version has several cells with formulas.
Some cells has the NETWORKDAY function.
This...
|
|
1 |
59 |
|
|
add multiple returns using vlookup by
RZ
Hi
I am using Vlookup function to find matching datat in another worksheet, i
want to add values if there is more than one matching values.
--
RZ
|
August 26th, 2008 03:18 AM
by smartin
|
7 |
240 |
|
|
Incrementing numbers in cells by
Andrew Morine
Hi,
I need to perform the following increments within a cell and need to copy to
a large amount of cells:
=SUM($G7+1)
=SUM($G7+2)
=SUM($G7+3)
etc...
etc...
|
|
1 |
69 |
|
|
Dividing a list into thirds by
Dave
I have a list of handicaps from large to small in B3:B26. In column C I would
like to put these numbers into equal thirds. I.E.:
B C
9 ...
|
|
1 |
67 |
|
|
Sorting a Pivot Table by
cware
I have a pivot table that I need to sort the contents of, by the last data
column. I've tried help, but am just not able to get there. Does anyone
have a...
|
|
2 |
70 |
|
|
Averaging Time by
BostonBoy
We’re trying to figure our how early an employee typically punches in for
work, as we want to give her a bonus. I have the punch clock data in an
excel...
( 1 2)
|
|
14 |
124 |
|
|
predetermined answer in next cell by
geenie
I have a list of short codes that are equal to a certain Commission Rate
Now when this code is entered in a spread sheet the number must
automatically apear...
|
August 25th, 2008 11:40 PM
by Max
|
3 |
89 |
|
|
Subtract 30 minutes from Formula by
Karen
I have a cell that calculates my time with the following formula:
=TEXT(C205-B205," \h\r\s: m \m\i\n\s")
I want to subtract 30 minutes for lunch. How would I...
|
|
9 |
89 |
|
|
|
|
1 |
99 |
|
|
|
|
2 |
82 |
|
|
|
|
3 |
94 |