Search results for query: *

Is there a way to select all the remaining Makes in this example? The Formula in D4 is =SUMPRODUCT((MAKE=$C4)*(YEARSOLD=$B$2)*(STORE="RED")*(SALETYPE="RETAIL")*1 In E4 =SUMPRODUCT((MAKE=$C4)*(YEARSOLD=$B$2)*(STORE="RED")*(SALETYPE="RETAIL")*COST/$D4)) Occasionally we sell an odd MAKE that...

Hello All, I hope I can explain this correctly. I need a sheet to create a Log of License plates when we fill in just one cell. The plates are always 7 characters with the first three being ALPHA (ABC) and the last four characters being numbers. (1234). My problem is when the plates are...

Good morning all. I am hoping NOT to have to redo all my formulas to fix this. It would would be so very much easier if my name range would look at data in two columns as one. I have a DATA sheet called 'ALL DATA'. I update the data sheet monthly. I export data from my mainframe and never had...

Good morning all. I am hoping NOT to have to redo all my formulas to fix this. It would would be so very much easier if my name range would look at data in two columns as one. I have a DATA sheet called 'ALL DATA'. I update the data sheet monthly. I export data from my mainframe and never...

I hesitate to ask this question, because I am almost embarassed that I am having trouble with this array formula. I searched through the previous postings, but cannot find a parallel situation for mine. Most all of my array formulas seek results of all the true conditions and are rather easy...

I hope I can explain this well enough for everyone to get an answer. I think I want a conditional format, but not certain. What I have is a Vacation-Absentee spreadsheet. I use Office Excel 2000. In column A2:A20, I have names. Across the top, I have dates. I mark a "V" for Vacation...

One of the most powerful and best tricks I have ever learned from this forum was how to properly use the Array Formula. But I running into a problem recently that I thought could be solved easily using a Wild Card (*,?,~). To be simple, here's my formula that results in "0"...

I have Excel 2000. (9.0.04402sr-1). I would like to have every NEW worksheet automatically open with margins open as wide as possible and with the Footer to note the file name and sheet name and date. I know how to do these when working on a sheet, but I would love to be able to set these up...

Can anyone help? I am using a Dell Optiplex 260 (have had it since day one new) and windows 2000 pro. The day I got it, I ran Magical Jelly Bean and copied down the product key. I have upgraded all security patches for years from Microsoft with no problems but now I come up with an Invalic...

Hello, I work with a lot with a system where I can use copy/paste even though it is not a windows based computer. I use an emulation program called REFLECTIONS. Anyway, I do a lot of copying from the Reflections screens and paste them into Excel. Then I use the "TEXT TO COLUMNS" function...

I have a sheet that allows me to enter almost all of my data then all of a sudden i get an error box that says "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. " This is in a Program Error Box with the...

Hello and Happy Holidays, I change the margins on almost every Excel sheet I produce. The default is for a 1" header, 1" footer and .75" right and left margins. I am constantly previewing and changing these to maximize my display of data on a single sheet. Is there a way to have Excel...

Here's what I have in a cell. The cell is right justified so that it will print since the adjacent cells to the left are empty. I need just the value to print in bold. The cell formula is ="Total number of units > 45 days old is " & SUM(D6:D19) . The value of D6:D19 happens to be 20...

Hi, I have an Excel 2000 worksheet (on windows2000) that I have been using for two years. I have a macro that I recorded that prints the worksheet and clears the data to make it ready for another set of calculations. When i open the worksheet, it still prompts me to enable macros, which I...

I use Excel 2000 on windows2000. I created a sheet (actually not really that large, A1:AC82) and during my creating it, I colored several cells to make my data easier to read and assemble. Now that I am done, I wanted to get rid of the cell colors by clicking on "no fill", and an error box...

Is there a way (other than AUTO FILTER) to have Excel print a packing slip? I have a very large excel sheet. O.H. PART-NO DESC BIN 2 12455 pump SHELF20 3 16490 gasket SHELF20 I would like to have Excel print each BIN separately without having to...

I am having trouble using nested functions. I know there is a way to do this simply, but maybe I am too simple. Here's my data: DAYS TYPE DATE AMOUNT 107 CAR 10/16/03 10,621.68 107 CAR 10/16/03 12,055.39 100 CAR 10/23/03 10,586.03 99 CAR 10/24/03 5,118.00 95 CAR 10/28/03 17,488.69 32 CAR...

First - this is the greatest site on the Internet! I need help with buttons (added them via VIEW - TOOLBAR - FORMS). I have 5 buttons across from each other. I f i click one it highlights and the other goes out. This is the effect I want. But, I want another five underneath of these five...