|
|
IF function by
freebee
Hi, I'd like to know how to set a formula in "value if true". I want to get
sum of L5+e6-J56 when the value is true
Thanks.
( 1 2)
|
July 15th, 2008 12:08 PM
by mona
|
10 |
212 |
|
|
Printing Excel using Acrobat Adobe by
JeffH
I would like to print all the active worksheets in one PDF file. When I try
to print all the active worksheets, it will print a number of them in one PDF...
|
July 15th, 2008 12:05 PM
by Chris
|
3 |
195 |
|
|
|
July 15th, 2008 11:57 AM
by dmfw
|
4 |
130 |
|
|
Creating macros with if stmts by
Lisa12
I am new to macros and I need to create a macro with an if statement. What
is the correct format, including spacing to make this work? I know the
wordin is...
|
July 15th, 2008 11:38 AM
by Normek
|
3 |
116 |
|
|
how to find duplicate numbers? by
Melt
I have a sets of data that goes:
000 820 2184
123 421 8952
and so on.. am i able to set a command/function that can prevent duplicate
sets at columns and...
|
July 15th, 2008 10:15 AM
by Max
|
1 |
107 |
|
|
paste link by
wildauk
Hi, Is there any reason that a paste link would stop working, I have have
cells from one sheet paste linked to another,and for some reason they have
stoped...
|
July 15th, 2008 09:46 AM
by wildauk
|
2 |
98 |
|
|
|
July 15th, 2008 09:31 AM
by Mike H
|
5 |
126 |
|
|
Private Sub - Called from Userform by
pallaver
I am trying to make all my subs private to minimize confusion for
others using my excel spreadsheet.
All of my subs/macro are on Module1, including a public...
|
|
3 |
144 |
|
|
|
|
5 |
185 |
|
|
If or Lookup or Something else by
KimC
I am trying to work out the formula to populate.
On Sheet 1 I have this
Model Black Toner Yeild
TEST
TEST 2
On Sheet 2 I have this
|
|
8 |
154 |
|
|
Handling Large Files by
RJB
I have a file with a data dump.
It has seven worksheets, each about 30 columns by 21,000 rows. Most of the
info is text, although I have about three columns...
|
July 15th, 2008 04:30 AM
by RJB
|
3 |
155 |
|
|
where is this in 2007? by
Debbiejj
In excel '03 there is a white box with a drop down menu similiar to the one
that tells you the font type. I cant find that box in '07. Does anyone know
where...
|
|
6 |
96 |
|
|
How do I reformat data into ranges by
Jerry
I have an Exel file with 2 columns. The 1st column has over 40,000 different
values, the 2nd has only 5. I need to create ranges showing the Column A
values...
|
|
1 |
92 |
|
|
|
July 15th, 2008 02:45 AM
by JLatham
|
4 |
104 |
|
|
Reset Ctrl+ Macro Shortcuts by
QNiehausen
I wrote a macro and assigned it Ctrl+b (lowercase b). After realizing that
it was also the command for Bolding text, I removed the shortcut, and even
the...
|
|
0 |
91 |
|
|
Getting correct results for lookup? by
tgcali
I have this formula:
=LOOKUP("YES",D9:D32,A9:A32)
that returns the number in the appropriate row in column A. This is not
working on every sheet in the...
|
|
4 |
108 |
|
|
|
|
3 |
121 |
|
|
|
July 15th, 2008 02:11 AM
by JLatham
|
1 |
103 |
|
|
|
July 15th, 2008 12:36 AM
by Pete_UK
|
3 |
127 |
|
|
Help on: IF no "," found in cell then... by
David P.
I need help on an IF function. Basically I want to do this:
IF "," is not found in A1, then...
I've left out the part of the IF function I know how to do so...
|
|
1 |
104 |