|
|
|
|
4 |
151 |
|
|
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 |
112 |
|
|
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 10:54 PM
by dinesh
|
0 |
106 |
|
|
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 10:49 PM
by msnyc07
|
0 |
89 |
|
|
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 09:43 PM
by Deb
|
3 |
97 |
|
|
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 09:39 PM
by T. Valko
|
7 |
179 |
|
|
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 |
114 |
|
|
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 07:49 PM
by Mike H
|
2 |
87 |
|
|
|
|
3 |
129 |
|
|
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 07:04 PM
by John
|
2 |
101 |
|
|
|
|
2 |
116 |
|
|
|
February 16th, 2010 05:49 PM
by Marty
|
8 |
129 |
|
|
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 |
171 |
|
|
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 |
89 |
|
|
|
February 16th, 2010 03:51 PM
by candifv
|
0 |
83 |
|
|
|
February 16th, 2010 03:20 PM
by Max
|
2 |
109 |
|
|
|
February 16th, 2010 02:18 PM
by Luke M
|
2 |
107 |
|
|
|
February 16th, 2010 01:01 PM
by Pete_UK
|
2 |
113 |
|
|
|
|
4 |
105 |
|
|
|
February 16th, 2010 12:47 PM
by Mike H
|
2 |
96 |