|
|
|
April 26th, 2010 05:16 PM
by Max
|
4 |
360 |
|
|
|
April 26th, 2010 05:06 PM
by Pete_UK
|
1 |
685 |
|
|
limit comments to only 600 words by
Tim
I have created a text box but I want the text length to be equal to or less
than 600 words.
How do I do that in Excel 2003 please
|
|
2 |
676 |
|
|
|
|
5 |
760 |
|
|
Count first and last characters by
Elton Law[_2_]
Dear Expert,
I have got a file which have a system generated field below. (15 rows)
First character must be either "T", "F", "U".
Last character must be...
|
|
3 |
861 |
|
|
copying a formula down wards by
UKMAN
=INDEX(Proj_code,MATCH(AQ$6,F$7:F$198,0))
the above formula works in that it shows the first match.
As there could be mulitpule records what do I need to do...
( 1 2)
|
|
10 |
1,504 |
|
|
Help Needed with Dynamic CountIF by
Steve
Hello All.
I have a sheet like this on a tab called Summary:
Month: Jan'10 (This is a drop down list showing all months)
Sales Person New Clients Sec Lead...
|
April 26th, 2010 03:01 PM
by Steve
|
4 |
764 |
|
|
Change a cells value with a function by
Ryan H[_2_]
Here is my function contained in O74. C70 has "Water Heater" in it and
I73="2". Why doesn't N74 have FALSE in it? Also, is there a way to control
a Forms...
|
|
4 |
783 |
|
|
Automatically hide/unhide rows by
JStiehl
I'm a VBA newbie and have searched for an answer for how to do this, but must
be doing something wrong when I've tried other codes. I need to have rows...
|
April 26th, 2010 01:29 PM
by JStiehl
|
6 |
774 |
|
|
Referencing relative to a formula reference by
Csaba Gabor
I have an Excel workbook with two worksheets. In one
sheet (Books) I have defined a series of items with
column 1 being my book Id and column 4 being the...
|
|
3 |
679 |
|
|
Date + relative number reference by
Derek M[_2_]
Hi all
I have a spreadsheet with dates in row 3 going from today till the end of
the year i.e 26/apr/2010
In row 16 directly below the date i have a number...
|
|
3 |
816 |
|
|
|
|
5 |
740 |
|
|
Excel Formulas by
Shona
Dear,
I need to calculate the below in excel sheet. please find below the details
and advise me:
Amount - 25000 - 3% * 3%
please advise how to subtract 3%...
|
April 26th, 2010 07:38 AM
by Shona
|
3 |
681 |
|
|
How to Sum infinite formula by
minyeh
I'm doing a transition matrix (hazard rate method) using formula
(trying to avoid using VBA under some company policy), but then, i'm
stuck when it comes to...
|
April 26th, 2010 04:39 AM
by minyeh
|
7 |
892 |
|
|
Finding matches in two columns by
Erik
I have two columns of years. Column A has 27 years from 1911 to 2007
indicating a particular year a house was built. Column B has all years from
1800 to 2009...
|
|
4 |
714 |
|
|
IF function by
Lost Cluster
I’m using the If Function to compare a string of text to a letter. This is
what I have
ColA has names ColB has the days off in this format (string of text)...
|
April 26th, 2010 03:08 AM
by FSt1
|
4 |
715 |
|
|
SUMPRODUCT by
Skinman
Hi all
Please. Needing some assistance. Using excel 2007
This formula starting in the first row of my data ranks each share value for
the first day (entered...
|
|
3 |
714 |
|
|
Referencing formula using Indirect by
Raj[_4_]
Hi,
A workbook has 13 sheets, a sheet each for the months from Apr-10 to
Mar-11 and final summary sheet
In the Summary sheet, I have a validation list in...
|
|
4 |
703 |
|
|
|
|
1 |
827 |
|
|
IFERROR in Excel 2007 by
Dirrk
I need an example on writing an IFERROR in Excel 2007. =IFERROR......I have
to do this for work and can't find anything on it.
|
|
5 |
976 |