|
|
|
|
4 |
134 |
|
|
Find and Replace wildcards by
Colin Hayes
Hi All
I need a little help.
What would be the codes to enter in the Find and Replace boxes so that
the second decimal place in any number would be replaced...
|
|
2 |
95 |
|
|
Format problem by
dinesh
Hi,
I am using Excel 2007. One of my worksheet has a number formating problem.
This worskheet has many (appros 15) tabs. Every time I open the worksheet,...
|
February 16th, 2010 11:54 PM
by dinesh
|
0 |
89 |
|
|
Reorder String by
msnyc07
I tried to re-process strings in a VBA script that parsed some cells to no
avail.
So I am looking for a function that will do so.
Essentially the VBA...
|
February 16th, 2010 11:49 PM
by msnyc07
|
0 |
72 |
|
|
Excel Worksheets by
Deb
I want to set up 2 different worksheets in one document (workbook), and I
want to bring a formula based cell from the first worksheet to be included in
a...
|
February 16th, 2010 10:43 PM
by Deb
|
3 |
80 |
|
|
Whats wrong with this array formula by
Carl_B[_2_]
I have a worksheet with 5 city names in column A and dollar amounts in
column I.
I need to calculate the average amount for each city.
I use the array formula...
|
February 16th, 2010 10:39 PM
by T. Valko
|
7 |
162 |
|
|
What's wrong with this formula? by
Ray
=IF(B270,+B27:B32-B28,"")
Want to add B27-B32 and subtract B28 if B27 is 0.
If not I want the cell to stay blank.
As soon as I enter a number in B27 the cell...
|
|
3 |
97 |
|
|
Greater than a month by
PAL
I have these two formulas below working great. I have been asked to modify
it by doing the calculation for a period greater than one month. I currently...
|
February 16th, 2010 08:49 PM
by Mike H
|
2 |
70 |
|
|
|
|
3 |
113 |
|
|
input time by keybrd in locked worksheet by
Darrell
What I want to do is have a user input time start and end in a time sheet to
account for worked hours by using a short cut key stroke but I don't want him
to...
|
February 16th, 2010 08:04 PM
by John
|
2 |
84 |
|
|
|
|
2 |
99 |
|
|
|
February 16th, 2010 06:49 PM
by Marty
|
8 |
112 |
|
|
Follow up on date function question by
Jim Peterson
Hey sorry to bother you guys again, but I've got a slightly different problem
now.
I used T. Valko's formula =TEXT(EDATE(B5,6),"mmmm") which works great....
|
|
3 |
154 |
|
|
iserror, index & if by
Sueellen1312
I'm trying to design a workbook that has a front sheet where you input all
the information, then a function that will copy it to relevant worksheet
within...
|
|
4 |
72 |
|
|
|
February 16th, 2010 04:51 PM
by candifv
|
0 |
66 |
|
|
|
February 16th, 2010 04:20 PM
by Max
|
2 |
93 |
|
|
|
February 16th, 2010 03:18 PM
by Luke M
|
2 |
90 |
|
|
|
February 16th, 2010 02:01 PM
by Pete_UK
|
2 |
96 |
|
|
|
|
4 |
88 |
|
|
|
February 16th, 2010 01:47 PM
by Mike H
|
2 |
79 |