|
|
Formula Tracking by
Dianeg
A client has workbooks with multiple links within each book and to external
books. using the auditing toolbar we can trace the links but it gets very
messy...
|
June 17th, 2009 11:15 AM
by Dianeg
|
0 |
155 |
|
|
Look Up by
Youngy5
Hi
I want to know if i can combine the following two formulas into one. I have
two spreadsheets in the same work book. I want column B of spreadsheet 2 to...
|
June 17th, 2009 09:31 AM
by Pete_UK
|
2 |
156 |
|
|
shared excel workbook by
fi.or.jp.de
Hi All,
Is there any vba code to know whether the active workbook is shared or
not ?
like this .....
if activeworkbook is shared then
...
|
|
0 |
174 |
|
|
ISBLANK and OR Function by
Jacob Skaria
Try the below array formula
=IF(COUNTIF($S$5:$BY$5,"0")=COLUMNS($S$5:$BY$5),"None",INDEX($S$4:$BY$4,MATCH(0,VALUE($S$5:$BY$5),0)))
If this post helps click...
|
|
0 |
173 |
|
|
captcure close application event by
suru
Hi,
I am new to VBA.
Can anyone tell me how to capture Close Application (i.e. close all
workbooks)
event in Microsoft Excel using VBA?
I know that, when i...
|
June 17th, 2009 07:10 AM
by suru
|
2 |
200 |
|
|
sumproduct help by
kristap
First I want to say thank you for all the help everyone is here. Now for my
question. Still helping my husband do his spreadsheet for work with all his...
( 1 2)
|
|
12 |
337 |
|
|
|
|
3 |
210 |
|
|
Cypher by
Bullocks
Good day,
No, I'm not James Bond nor am I a criminal trying to hack into the
CIA... Just wanted a hand with a simple cypher if anyone can help. I
want to be...
|
|
3 |
189 |
|
|
|
|
1 |
199 |
|
|
|
|
1 |
145 |
|
|
Range Names by
Té
How can I create a range name that can only be used for a particular
worksheet, instead of the entire workbook?
|
|
2 |
202 |
|
|
ISBLANK and OR Function by
Shane Devenshire[_3_]
Hi,
Something the following array formula:
=IF(COUNTA(S5:BY5),INDEX($S$4:$BY$4,1,MATCH(TRUE,(S5:BY5=0)+(S5:BY5="")0,)),"None!")
Array - you need to enter...
|
|
0 |
153 |
|
|
Data validation by
VLOOKUP fORMULA
Any one pls help me....?
I am having a data validation rule in sheet1, data taking from sheet2 using
a drop down menu.
My problem is that I am entering the...
|
|
2 |
201 |
|
|
yes/ No on multiple sheet by
Muskrat24
I am trying to make a spread sheet so if for example on sheet 1 I have
A B C D
1 Big $5 ...
|
|
3 |
140 |
|
|
Range Name by
Té
How can I create a range name that is only used for a particular worksheet,
rather than the whole workbook?
|
|
1 |
152 |
|
|
del certain rows based on word search by
Robert
Hello,
I import about 50 pages of data from another program that leaves page
headers which consist of 10 rows of junk. In between these rows of headers,...
|
June 17th, 2009 01:46 AM
by Robert
|
2 |
136 |
|
|
Countif function question by
stevestr
I have a list of birth dates in column A. I want to provide a list of age
ranges in a summary next to the column. For example I would like to create a...
|
June 17th, 2009 01:45 AM
by smartin
|
2 |
173 |
|
|
how to calculate x months from today by
Gene
Excel 2003: I have a "date" in a cell (eg: 6/16/09), and want to calculate
the date which is 6 months from now?
The issue I'm having is that some months are...
|
|
6 |
381 |
|
|
IF Dates by
Talladega
Hi,
I have a column filled with dates. I need to write a formula to show if the
date in column a is after 12/31/06. If it is, then is shows the date of...
|
|
1 |
165 |
|
|
Grouping Data by
Humble09
I have excel 2007 and want to group the list in the 'KEYS' column so that it
reference the name of the person who has the keys.
LAST NAME FIRST...
|
June 17th, 2009 12:25 AM
by smartin
|
1 |
171 |