|
|
Urgent Help - CountIf by
Jeff
Hello,
In Sheet 1 Column B, I urgently need a formula to would execute the following:
Take Column A value = "Red" in sheet 1.
I need to look for value =...
|
April 13th, 2009 03:36 PM
by Mike H
|
2 |
118 |
|
|
|
|
1 |
101 |
|
|
Insert Rows using VBA by
Tony
I am using the following code to try and find a "1" in column "R". Whenever I
find one I want to insert a row. With the code I have here I find the "1" in...
|
April 13th, 2009 03:17 PM
by Tony
|
2 |
80 |
|
|
|
April 13th, 2009 03:05 PM
by Mike H
|
1 |
178 |
|
|
What 'value' is a Dec2Bin output? by
EvilTony
I'm trying to verify that the guess someone makes as to the binary equivalent
of a decimal number is correct.
Example
cell A1 holds, say, 8
User...
( 1 2)
|
April 13th, 2009 01:59 PM
by Bernd P
|
12 |
283 |
|
|
Countif by
Mike
--------------------------------------------------------------------------------
I am trying to make a chart that will tell how many people are working in...
|
April 13th, 2009 01:47 PM
by Mike
|
0 |
126 |
|
|
Pvt Table Turned Into Static Values by
C02C04
I have a worksheet (.xls) that holds data and built some pivot tables out of
it. It worked fine till today. The pivot tables were able to refresh with new...
|
|
1 |
110 |
|
|
|
|
2 |
142 |
|
|
precision in solver by
Randi
Hi.. Does anyone know what the precision means when you run the solver? We
have to change the number from 0,000001 to 0,001 before solver could find an...
|
|
4 |
151 |
|
|
Data from another worksheet by
Tomvernc
I have a summary sheet as part of a workbook. Some of the data contained is
obtained by reference to another sheet. I would like to send the summary
sheet...
|
|
1 |
112 |
|
|
Text file to Excel format by
thalapathy
I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format,...
|
|
4 |
124 |
|
|
Dragging a formula by
Sasikiran
Dear,
I need to drag a simple reference formula =A7 in such a way that it follows
a pattern. Something like...
=a7
=a14
=a21
=a28
=a35
|
|
8 |
106 |
|
|
|
|
2 |
174 |
|
|
|
April 13th, 2009 02:28 AM
by JLatham
|
2 |
139 |
|
|
|
April 13th, 2009 02:10 AM
by dhstein
|
2 |
117 |
|
|
|
April 13th, 2009 02:06 AM
by FSt1
|
1 |
134 |
|
|
[newbie] if statement by
Jon
I'm trying to include a conditional however, I'm getting a sort of a syntax
error:
=if((F5H5) AND (UPPER(C7) = "YES") AND (C9/C10 H9), "Yes", "No")
F5...
|
|
4 |
117 |
|
|
Sorting Values Without Sorting Formulas by
SBX
Is there a way to sort values from several rows that were calculated using
formulas without disturbing the sequence of the formulas?
After the sort I would...
|
April 12th, 2009 11:17 PM
by SBX
|
2 |
153 |
|
|
|
|
5 |
168 |
|
|
|
|
1 |
115 |