|
|
Countif to count more than one item? by
Adam
All,
Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column.
Column has MD, LK,...
|
|
6 |
192 |
|
|
Custom Buttons linked to Macros by
surveyorinva
This is fustrating...
I have made a custom menu based upon macros that I have in a worksheet. This worksheet is a file which will be saved using a different...
|
|
1 |
548 |
|
|
Copying GridLines with AutoFill by
Elusive
I have a fill macro assigned to a worksheet that is designed to only copy over items that show a quanity of one or more items. If the macro detects a quanity...
|
|
1 |
164 |
|
|
|
|
3 |
219 |
|
|
Setting up hot key by
George A. Yorks
Setting up excel spread sheet want to be able to hot key
from any cell back to a given cell. ie: from g15 back to
a3.
Any help appreciated
|
June 16th, 2004 06:27 PM
by AlfD
|
1 |
182 |
|
|
|
|
0 |
579 |
|
|
|
|
5 |
694 |
|
|
not enough quota by
Mike P.
I am running Excel 2000 on Windows 2000. I have created a
small spreadsheet (25.5 kb)with several hyperlinks. When
I try to save it to the network share I...
|
June 16th, 2004 05:37 PM
by jeff
|
1 |
328 |
|
|
Calculate Due Dates in slabs by
Shanks
I have 3 dates within a month to make cheques,as per
Bills received. Below is the matrix for the same.
Received Paid on
23rd to 5th ...
|
June 16th, 2004 05:33 PM
by jeff
|
1 |
319 |
|
|
Number of pages in a document by
saybut
Hi,
Could anyone tell me if it is possible for excel to return information
about a document in a folder?
I have several pdf's in a folder on my c: drive. Is...
|
June 16th, 2004 05:19 PM
by saybut
|
0 |
470 |
|
|
Check Box Sizing by
beantownbrad
Hi,
When using check boxes, no matter how much I resize the area, the actual check box itself never gets larger (only the area for a description does). Is...
|
|
1 |
366 |
|
|
Not sure what type of formula is needed by
shternm
I am looking for a formula that's going to look at column where there
are multiple text entries and return a list of all distict entries.
For example,
Column...
|
|
2 |
424 |
|
|
Read Only Folder by
cwt
I would like to create a 'Read Only Folder' or
a 'Password Protected Folder' in which I can add
spreadsheets to without having to individually protect
each...
|
|
1 |
163 |
|
|
|
|
3 |
417 |
|
|
Row and column Headers formating by
Salim
When I open a particular workbook i always find the
headers are strikethrough, I need a help on how to remove
this strikethrough, note this is not on the cells...
|
|
2 |
198 |
|
|
Automatic Cell Re-sizing by
Tappie
I have created a spreadsheet that is to be completed by
several people.
Some of the cells in the spreadsheet are protected appart
rom the ones to be completed...
|
|
1 |
149 |
|
|
running a macro only if criteria are met by
The Grinch
hello all,
I have a macro that runs fine, the problem is it relies on user input,
and will run even if the data received is invalid. I can calculate
simple...
|
|
2 |
325 |
|
|
File Not Found by
Salvatore Iannazzo
I have Excel 2000, and I use Paste Links often. Sometimes
one of my files seems to get "infected" in such a way that
when I open it, I get a "File Not Found"...
|
|
1 |
309 |
|
|
Selecting or deleting data by
Joey
Hi all
Is it possible to have a formula which recognises whether to select or
delete data.
Eg;
A1 = xxx
A2 = yyy
A3 = zzz
|
|
5 |
217 |
|
|
|
|
1 |
170 |