|
|
Excel lookup by
Maximus
I need to find the formula where there are two dependencies considered to get
the result.In V look up from reference of one column the results in the
second...
|
October 8th, 2009 03:02 PM
by Amey
|
2 |
131 |
|
|
macro function--very nice by
driller
Hello genuine guys,
Is the macro function see below here still possible for adjustment so I
can use this very good macro, productively, as often as needed...
|
October 8th, 2009 02:54 PM
by driller
|
7 |
178 |
|
|
VB Data Validation check by
Bony Pony[_3_]
Hi all,
I am trying to find a way to check if a data validated cell contains invalid
data.
I know I can conditionally format it and that I can set Excel to...
|
October 8th, 2009 02:46 PM
by AB
|
1 |
160 |
|
|
|
|
7 |
465 |
|
|
|
|
6 |
206 |
|
|
Workbook size by
Sri Harsha[_2_]
Hi,
I've created a workbook that captures the daily work done by my team. I had
a similar one before and the new one is more than 11 MB in size. The old one...
|
|
2 |
173 |
|
|
|
October 8th, 2009 02:34 PM
by elance
|
0 |
169 |
|
|
my post by
Help with cell function[_2_]
I posted a message for help yesterday...how do I find it?
|
|
3 |
205 |
|
|
Password Protection by
Kiley
I have password protected an Excel Workbook. However, users of this Workbook
need to unprotect the Workbook to make changes and then re-protect the...
|
October 8th, 2009 02:25 PM
by Brad
|
7 |
268 |
|
|
|
|
3 |
149 |
|
|
|
|
1 |
158 |
|
|
XIRR question by
ORLANDO VAZQUEZ[_2_]
Hi,
In the following data, the negative values are capital calls (outflows) and
the positive values are inflows (distributions, income, etc.) The final...
|
|
5 |
144 |
|
|
Breakout groups from one column of data by
Maarkr
I thought I posted this hours earlier today but it never showed up???
Anyway, I have one column of data with Depts and Names listed below the
dept. I need...
|
October 8th, 2009 01:34 PM
by Maarkr
|
2 |
139 |
|
|
locking cells by
denhar
I have set up an extensive spreadsheet for my "non-Excel" co-workers. I
do not want them inadvertently typing in the cells that have formulas.
Other than...
|
|
7 |
137 |
|
|
Count merged cells by
jlclyde
I have a form and when it loads I want it to calculate how many merged
cells are in selection.
RnSz = Selection.Cells.MergeArea.Count - is what I thought it...
|
October 8th, 2009 01:08 PM
by jlclyde
|
1 |
141 |
|
|
vba line for clearing data from a cell by
cvgairport
Hi all -
Is there a line of vba code that I could put into a startup macro to empty a
cell of data. I want to keep the formatting and any cell comments....
|
|
5 |
170 |
|
|
x means Y by
MitzDriver
How can I change a cell to either "Y" or "N" if the user enters "x".
i.e. If the user enters "x" in G12 and presses enter or moves to another
cell, that cell,...
|
|
3 |
152 |
|
|
VLOOKUP by
Lynn
Have this function
Look up value : A3
Table Array: '01'!Q:S
Column Index Number:2
Range Look Up: False
Want to copy formula into other column
Not change...
|
|
3 |
180 |
|
|
Excel by
RickComputer
When I have alot of data. I filter down to the data I want to see. How can I
create a sum total of only the data I have filtered down to?
|
October 8th, 2009 11:27 AM
by Stefi
|
1 |
148 |
|
|
Days in a specific month by
DubboPete
Hi all,
I hve noted there are documented ways to calculate the number of
weekdays in any month, but my enquiry is somewhat different.
I have 5000 rows, with...
|
October 8th, 2009 11:22 AM
by Stefi
|
2 |
129 |