|
|
Date Ranges by
Bruce D.
I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date,
eff date.
I want to flag the records somehow if the "eff date" is with 90 days of...
|
May 27th, 2010 09:53 PM
by Jeff
|
2 |
162 |
|
|
Missing fill handle by
Speedbump
When I attempt to expand a column the drag handle is clear, I only get a
4-way arrow and a drawing box. How can I get the black drag handle and
eliminate the...
|
|
0 |
181 |
|
|
|
May 27th, 2010 09:53 PM
by KHW
|
8 |
351 |
|
|
Excel tol .dat file by
Mia
Hello,
I have a problem. I need to create a dat-file from a excel-file.
Do anyone know howe to do this I'll be wery grateful!
--
Best regards
Mia
|
May 27th, 2010 09:52 PM
by Mia
|
0 |
184 |
|
|
Run macro only if by
puiuluipui
Hi, i need a macro to run if A1 contains "John" and C1 contains "Mari", and
if D1 is blank. If this criteria is not mached, then the macro to display a...
( 1 2)
|
|
12 |
521 |
|
|
|
May 27th, 2010 09:50 PM
by jay
|
0 |
286 |
|
|
Match pairs of data in cells by
whatzzup
"whatzzup" wrote:
Good day, i would like a solution to this problem. i have a set of data in a
spreadsheet, these could be repeated, what i would like to...
|
|
0 |
272 |
|
|
Extract numbers from a string of text by
Mike H
Hi,
Try this
=MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,":",CHAR(7),2))+1,7)
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that...
|
May 27th, 2010 09:48 PM
by Mike H
|
0 |
274 |
|
|
linking spreadsheet colour to chart by
Colin
I have data that I must produce in a chart. Normally from a pivot table. The
certain parts of the data are colour specific from an index. Is there anyway...
|
May 27th, 2010 09:46 PM
by Colin
|
0 |
269 |
|
|
excel 2003 by
Dennis
Hi I am using excel 2003 and everything was goin g fine until I tried to open
a file (which was working ok) but now won t open and just comes up with the...
|
|
2 |
242 |
|
|
Help writing a formula by
Ms-Exl-Learner
I assume that your Title starts from C1 cell and AK starts from D1 cell.
Copy and paste the below formula in A1...
|
May 27th, 2010 09:45 PM
by WA
|
2 |
225 |
|
|
Bankup of worksheet by
Mike H
Hi,
Try this. Note I used XLSX as the file extension because I'm using e2007 so
change to the apppropriate one for you
Sub...
|
May 27th, 2010 09:42 PM
by Mike H
|
0 |
237 |
|
|
running macro when workbook is openned by
MD
I have the following macro it should run when the workbook is opened. I keep
getting an error message.
Any ideas. Isthere something that is missing
Option...
|
May 27th, 2010 09:42 PM
by FSt1
|
3 |
273 |
|
|
Converting a non recognizable date time by
mlman
Thanks for your help!
"mlman" wrote:
I have high speed monitoring equipment that imports thousands of date time
readings as follows:
05/24/2010...
|
May 27th, 2010 09:40 PM
by mlman
|
0 |
237 |
|
|
|
|
1 |
382 |
|
|
convert nos into words by
Jim Thomlinson
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b213360
--
HTH...
Jim Thomlinson
"Rajeshwar" wrote:
convert nos into words
|
|
0 |
278 |
|
|
|
May 27th, 2010 09:35 PM
by Mike
|
0 |
306 |
|
|
Lost MOUS Certificates by
JudithJubilee
Good evening,
I completed my Microsoft Office 2003 MOUS exams. Unfortunately due to
circumstances I no longer have the certificates.
Is there any way of an...
|
|
0 |
207 |
|
|
|
May 27th, 2010 09:27 PM
by Ken
|
4 |
465 |
|
|
rows truncated when printing by
wizardmalcolm
I export spreadsheets from another programme to excel. The imported font size
is 8 point. When I increase the font size to 10 for better printing the rows...
|
|
0 |
279 |