|
|
Advanced Filtering by
Kirk P.
Is it possible to set up advanced filtering showing records where an amount
is, say = 2 AND = 4?
|
|
2 |
76 |
|
|
Create a flat file in Excel by
GF08
I need to create a flat file in Excel using the pipe delimiter | as element,
and carriage return line feed as line delimiter.
How do I do this?
|
|
4 |
103 |
|
|
=today() less one month by
Jim
Hello,
In a cell I would like to return last month, October. What is the formula
for this?
Thanks
Jim
|
|
4 |
132 |
|
|
|
November 19th, 2009 05:41 PM
by GailH
|
2 |
106 |
|
|
Yes no drop down list and macros by
Larry Fitch
I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.
When I run the macro I get an info...
|
|
4 |
125 |
|
|
|
|
3 |
108 |
|
|
formula to make currency formatting useful by
Nipsey Russell
situation: a woman i work with pays thousands of invoices a year and records
them in a spreadsheet. When they are in different currencies, she doesn't...
|
|
4 |
121 |
|
|
|
November 19th, 2009 05:35 PM
by GKelly
|
0 |
88 |
|
|
Length of an Excel document by
suroora
Is there a maximum length for an Excel spreadsheet before it crashes? My
colleague has one that goes into several sheets, and she was worried it would
crash...
|
November 19th, 2009 05:33 PM
by suroora
|
3 |
112 |
|
|
Pivot table missing column by
Pivot Table missing column
Hi, I need help here on Pivot table. I run the pivot table on a big report
with 12 months display, I always missing one month data and don't know why's
that....
|
|
0 |
91 |
|
|
Hyperlinks were lost by
Etz99
Hi All,
I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds
of links to forms to each individual row created. I last saved my file...
|
|
3 |
143 |
|
|
vba code by
CandiC
does anyone know if it is possible to write a macro to clear all unlocked
cells by the click of a button on a user form?
|
November 19th, 2009 04:04 PM
by CandiC
|
4 |
124 |
|
|
Macro with line graph by
Sasikiran
Dear,
I have huge data with different headers. I want to plot a single line graph
linked with a validation with the list of all the headers. The data in the...
|
|
2 |
129 |
|
|
|
November 19th, 2009 03:02 PM
by John
|
2 |
100 |
|
|
Formula For Multiple Rows by
satrntgr
In Excel 2009 I need to multiply rows 1 through 55 by $0.35. I don't need
any amounts of the rows multiplied by that, just the number of rows (55 x
$.035). ...
|
November 19th, 2009 02:47 PM
by Bob I
|
2 |
101 |
|
|
"Centre Across Selection" and character limit by
upsidedown_pw[_2_]
The problem I have been having is when I type text into a cell it limits me
to displaying over 255 characters and instead displays ####
Following advise, I...
|
|
1 |
99 |
|
|
Date format getting muddled by
Jez
Hi,
I work for a computer software company. We export data to Excel. We have a
client in South Africa where the date is getting muddled when it is exported...
|
|
3 |
146 |
|
|
Access or Macro by
dab
Good day
Thanks for reading.
I need to create a user interface that will allow the user to input some
values and then the program/macro will use this...
|
November 19th, 2009 02:15 PM
by dab
|
2 |
107 |
|
|
Pivot table help? by
Scott
Hi
I've got a list of job numbers in column a, with a list of hours worked in
column b. There are a number of repeating jobs in column a as some jobs
have...
|
November 19th, 2009 01:58 PM
by Eduardo
|
1 |
109 |
|
|
-sign by
bbc1
I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of
cell d is greater than the total of cell a, if cell d is...
|
|
2 |
89 |