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,...

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...

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...

I need to figure out how to copy text information from a cell on one sheet to a nother cell on another sheet and/or file. I don't want to use cut and paste. I...

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

Jan: I've faced the same issue with an excel file that contains hyperlinks to sheets within the same document and no macros. The earlier suggestion (MS Kbase...

Hello, I need some help. I am trying to extract values only from cells that are a specific color (in my instance, yellow) is there a function that will allow...

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...

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 ...

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...

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...

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...

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...

This is silly but I have not been able to locate the Help item online: Recently I used the Reviewing toolbar. I deselected it when I opened Excel this...

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...

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...

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...

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"...

Hi all Is it possible to have a formula which recognises whether to select or delete data. Eg; A1 = xxx A2 = yyy A3 = zzz

I am running Execl 2002 SP2. It has suddenly started opening new sheets in mirror arrangement (Column A on the right and all scrolling controls reversed). ...