|
|
Adding character to text string by
Adam
Hello All,
I have a spreadsheet that has customer information. I
need to add a few characters to an existing text string in
hundreds of fields.
For example,...
|
September 25th, 2003 08:58 AM
by JMay
|
2 |
347 |
|
|
Script Editor Grayed Out by
Adam
I have a file that has three External Database Queries. I am trying to
change the Database Path, but the Script Editor is Grayed out. Any idea why
it is...
|
March 12th, 2007 04:55 PM
by Adam
|
1 |
79 |
|
|
D count Criteria by
Adam
I've made a spreadsheet to report on a sheet of raw data. Is there a maximum
number of column heading that can be used when defining the criteria?
I've got up...
|
|
4 |
84 |
|
|
|
|
1 |
292 |
|
|
|
June 15th, 2004 02:43 PM
by Adam
|
1 |
453 |
|
|
|
|
1 |
260 |
|
|
Shortcut to select column? by
Adam
Is there a shortcut in excel to select the entire active
column? also to select the active row?
Thanks
Adam
|
|
1 |
176 |
|
|
Extracting data from alpa numeric string by
Adam
I have about 5,000 alpha numeric records. I need to
derive three separate fields from these individual records.
For example:
ABC5DE -- ABC 5 DE
XYZ77EF ...
|
|
2 |
129 |
|
|
How many records with xl 03 hold? by
Adam
The current record limit is 256 columns and 65kish rows,
will this be extended in the 2003 version?
I've heard that quattro pro looks at 1 million...
|
|
1 |
86 |
|
|
Date re-formatting by
Adam
I have data in mm/dd/yyyy format and was wondering how (or
if) I could convert that to just day of the year (1-365)?
thanks
adam
|
|
1 |
131 |
|
|
What function to use? by
Adam
What function should I use to find the probability of 2 girls being absent
out of 5 total students being absent in a class of 25 total students?
|
|
1 |
40 |
|
|
|
February 20th, 2005 06:15 AM
by Ola
|
4 |
87 |
|
|
SUM Condition by
Adam Bradley
I have collumn A as referece numbers such as 0535 which relate to several
values in collumn D eg.
0535 £235
0535 £82
0535 ...
|
|
4 |
112 |
|
|
SumProduct making things work slow by
Adam Graham
I was using DSUM to sum financial transactions based on a variety of
criteria, many of which involved dates. The problem for this is that I would
have to...
|
|
7 |
146 |
|
|
|
|
1 |
117 |
|
|
Returning Multiple Matches by
Adam Hodge
I have an worksheet that has data that is sorted like the following
Bar NumberProperty Node...
|
November 13th, 2008 04:09 PM
by Max
|
4 |
151 |
|
|
Check Boxes by
Adam H[_3_]
Hiya,
I need to set up two check boxes in excel.
The first box needs to be there, on show, all the time, but the second only
needs to appear once the first...
|
|
5 |
63 |
|
|
Is there a worksheet function that will... by
Adam Kroger
Is there a worksheet function that will copy (or return) the value of
another cell (not its formula), with the result being stable, even though
the orriginal...
|
|
1 |
67 |
|
|
Lookup Problem by
Adam L
I have an array of data. I want to use a lookup function to find a
particular value, then produce the value directly below this reference. For
example if...
|
|
3 |
73 |
|
|
Excluding formulas in hidden cells? by
Adam L. Kehl
If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3 thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide several
of...
|
|
3 |
85 |