|
|
visible rowindex by
Chris
Is there any possible way to change this formula to only use the
visible rows so I can filter my list?
=INDIRECT("PrintData!B" &RowIndex)
|
September 2nd, 2008 02:40 PM
by Spiky
|
3 |
57 |
|
|
Sumif function? by
Esradekan
I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a...
( 1 2)
|
September 2nd, 2008 02:30 PM
by Spiky
|
11 |
143 |
|
|
Evaluate boolean values as 1 or 0 by
hmm
How do I use boolean values so that a formula would evaluate TRUE as 1 and
FALSE as 0? For example, if column A contains boolean values, I want to
avoid...
|
|
3 |
90 |
|
|
|
|
7 |
86 |
|
|
Compare two columns by
Jeanne T[_2_]
How can I compare two columns to find only those that are different?
Ex: Col A Col B Difference
EA EA None
...
|
|
2 |
96 |
|
|
Command Button by
Freshman
Dear experts,
I want to create a command button and when I click it, rows under row 30
will be collapsed. When I click the button again, it toggles to expand...
|
September 2nd, 2008 01:16 PM
by Freshman
|
3 |
92 |
|
|
Auto Filter - Add visible cells by
Doobrifurkin
Hi,
I have a list containing numerical and text values. I have applied an auto
filter and would like to place a formula that adds up these values of the...
|
|
3 |
129 |
|
|
sumproduct text by
A.Mourice[_2_]
Hello,
A1 A,B,X,C,X
A2 X,D,G,X
A3 F,G,K,L,X
I need to count how many X repeated at many cells using sumproduct function.
|
|
5 |
103 |
|
|
|
September 2nd, 2008 10:16 AM
by Dave
|
5 |
92 |
|
|
|
September 2nd, 2008 07:14 AM
by Gav123
|
1 |
115 |
|
|
Lists by
Varney
Hi, I have a problem I need help with. I will attempt to explain what I am
trying to do. I have created a drop down box with several customer's names
to...
|
September 2nd, 2008 03:55 AM
by T. Valko
|
4 |
86 |
|
|
2007 Conditional Formatting by
BigDDDD
In older versions of Excel, I used to set 3-4 conditions in cells A1 to A4.
Then, I would copy these 4 cells across to Column BZ and all would be well.
Now,...
|
September 2nd, 2008 02:46 AM
by T. Valko
|
1 |
114 |
|
|
Paste Link between Worksheets by
JC
Hi, I have been using 2003 and 2007 versions of Excel and trying to link
graphs from one master sheet to another file so that it automatically updates
when i...
|
September 2nd, 2008 02:32 AM
by JC
|
0 |
100 |
|
|
indirect formula question by
Chris
Hello - I have been trying to wrap my head around getting an indirect
formula that indexes rows to be printed to only recognize visible rows
so I can run a...
|
September 2nd, 2008 12:03 AM
by Chris
|
6 |
88 |
|
|
Excel Cell Reference by
Jer
I am trying Office 2007 and in Excel I have at one attempt tried to reference
a cell in another sheet in the same workbook and another time have attempted
to...
|
September 1st, 2008 11:51 PM
by smartin
|
1 |
106 |
|
|
Monday Following by
robzrob
Hello
I'm sure I've done this before, but I can't remember how. I need a
cell to return the date of the first Monday after today.
|
September 1st, 2008 11:47 PM
by Bernd P
|
8 |
120 |
|
|
Finding the solution to an Exel problem. by
MJohn
My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP'
functions and they return a value when certain criteria are met. There are
only 4...
|
|
3 |
93 |
|
|
|
|
1 |
78 |
|
|
|
September 1st, 2008 08:59 PM
by T. Valko
|
11 |
260 |
|
|
Calculating Information by
Andrew
I have created a workflow to determine work hours from when a request was
received until it is completed. The date / time is captured as yyyy/mm/dd
hh:mm
In...
|
September 1st, 2008 08:28 PM
by JMB
|
3 |
77 |