|
|
|
|
5 |
233 |
|
|
overlap printing by
riven
my spreadsheet size is too large to print in a single sheet of paper. the
only way to print it is by overlapping sheets. please teach me how... thanks
in...
|
|
1 |
262 |
|
|
Text Split by
DDay
Hi,
I have 4000 line of data which is first and surnames combined e.g DavidHill,
MarkSmith etc etc. I need a formula to divide these by the second capital...
|
|
5 |
210 |
|
|
|
|
0 |
233 |
|
|
Stop and show error by
alvin Kuiper
Hi
If i start my excel file with macros, i just get this micosoft error you all
know
and it shot my file down, isn't there a way to stop my program and see...
|
|
2 |
222 |
|
|
Calculate next year in different cell by
duketter
Excel 2007 - I have a specific date in cell A1 for example. A1 - 3/31/2009.
I then want in cell G1 the exact next year calculated so for example cell G1...
|
|
5 |
562 |
|
|
Filtering by
Paul X
Hello
I'm trying to automate my regular excel journal form. I want to set up a
drop down filter that can look up data from another spreadsheet.
eg sheet...
|
|
1 |
362 |
|
|
Worksheet duplicates by
puiuluipui
Hi, i need to find duplicates in all sheets and result to be, "yes" or "no".
In "C" column i have numbers, and in "D" column i need the code for...
|
|
8 |
337 |
|
|
Reading from set Row/Column location by
Ant
I am not an advanced user of this product and this question I think has a
simple answer, but all my research does not find a solution.
What I would like to...
|
May 14th, 2009 09:54 AM
by Max
|
4 |
252 |
|
|
Pivot Tables & data changes by
Anna
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working...
|
|
3 |
228 |
|
|
conditional formatting by
LNS
How do I apply conditonally formatting to two rows which contain text? For
instance;
A B
1 Australia ...
|
|
7 |
250 |
|
|
Combo Box Control Strange Behavior by
Tom McCray[_2_]
Using the VBA control -
90% of the time all is well, but occassionally some of the combo boxes will
automatically 'resize' when I click on them. It looks...
|
|
1 |
236 |
|
|
Case Sensitive Lookup by
danpt
How do I make Range("A6") to return 97, as given in the sub.
Sub CaseSensitiveLookup()
Range("A1") = "a"
Range("B1") = "A"
Range("A2") = "97"
Range("B2") =...
|
May 14th, 2009 06:20 AM
by danpt
|
3 |
195 |
|
|
|
|
1 |
183 |
|
|
|
|
1 |
186 |
|
|
Conditional COUNTIF by
Sara
What is wrong with this formula
IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F")
|
May 14th, 2009 04:44 AM
by Max
|
4 |
250 |
|
|
|
|
3 |
229 |
|
|
|
|
3 |
181 |
|
|
|
|
4 |
207 |
|
|
sort changes row height by
Christyr
How can I keep row height from changing when I perform a sort? When I sort, I
lose sight of some of my information in my cells and then have to resize my
row...
|
|
1 |
207 |