Search results for query: *

Skip, Thanks for the quick reply. 1) your example is only a pic. Not acceptable! Either provide a table/text example or upload your workbook. I have uploaded my workbook. 2) Where do you use Valid_Makes in your formula? I have yet to use VALID_MAKES in my formula as I cannot figure...

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

zelgar, that will, indeed, work! dhookom, I couldn't get yours to work (but that could be me!). I thank both of you for your quick responses. Have a great day! Creeker69

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

Brad, Thank you so very much for all the help. Yea, despite what skip implied, I tried many combinations and got the #value. It was as you said, the proper placement of the parentheses. Also, you saved me so much work by showing me how to use two non-contiguous columns in a name range. I...

Brad, Thank you so very much! INDEX works perfectly! While I didn't want to change any of my formulas, your solution made the change to the many formulas on the different output sheets pretty simple. I just did a REPLACE (ctrl+H) and then I only had to type your formula the one time. As...

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 totally agree with your logic! And, Thank you for the definitely easier to read and understand formula. I am changing this worksheet to use your formula. Just one typo in yours and that is *(GROSS) should be ,(GROSS) . But, I knew it was a typo. Thank you for being so kind and...

Skip, Thanks for the speedy reply. As usual, the minute after I posted, I got it. I need to not only count the occurences but also add up the total gross profit and that is why I am using an array formula. But, I am always trying to learn from you guys and, frankly, though I love the power of...

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

Thanks to both of you! John explained why it does not work but placing that solution in the very long array formula I already have confused me a little, though it works perfectly by itself. Geoff, I can't believe i didn't think of that simple little extra of "LEFT". That is a very very...

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

Thank you - Thank you - Thank you! The hardest part was finding the correct XLSTART directory. I followed the help in the help file for the correct location of the XLSTART file and the part I missed on my previous attempts was to save the file as "book.xlt". Without that name, it does not...

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

Thank you for the reply. The second response containing the link is not what I am looking for. I WANT to put the legitimate Product Code for my Win2000 Pro into the system. I could just wring Dell's neck for the hassle! They did this to me (sort of) once before too. I bought a PC with...

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

Skip, Thanks for the speedy reply but.... I don't get the chance to answer ANY of the normal TEXT TO COLUMNS delimeters. As soon as I paste, the data is spread out amongst the columns without the chance for me to tell EXCEL fixed width, delimeted by commas, spaces, etc... It just pastes...

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