Scottie, Do you really need to use Vlookup? You can get the number of the month in a cell containing a date with formatting. Format - Cells -...

can anybody help me out with incorporation of the Gini coefficient function in an excel worksheet Thanks in advance!

Hello Group I am resending this..i dont know why this post did not show up. Anyways,i have this rather simple equation , but cant seem to figure out how to...

Does anyone know how I would create a formula that designates and SUM of cells by the color of it's background? For example if A1 - A10 have numbers in them...

when i set up excel to open upon logging into my work domain, my deafult file location field keeps getting reset. if i open excel manually, i don't have this...

You can use: =SUMPRODUCT((Team="TeamA")*(StartDate=20031004)) -----Original Message----- Hi, I am trying to count the number of times a specific...

Is it possible to build a logical statement using both IF and AND. For example, we have an Excel spreadsheet with Client biling information. Different...

I have this unusual problem where, when I go to sort the spreadsheet, the wizard bypasses the header line, and picks up the first line of data to use as the...

Can you create in excel "pop-up" messages as a reminder for specific dates?

I got a new computer that has XP Profession which includes excel 2002. I had a works 2000 data base file saved on a floppy disk, and I need to import the file...

I have worksheets in an excel file. I would like to encapsulize the totals on a single sheet with links from the worksheets on the summary sheets. How can I...

I'm trying to create a list box that has two values that can change often. I tried a list box ActiveX object, but that didn't work, because the source values...

Here is what I need to do. I have one range with text data, and I have one range with numeric data. I need a formula to count the number of times the first...

Microsoft Knowledge Base Article - 124935. This question is somewhat linked to another question I just posted. When I run the macro from the above KB Article...

Say I have the following information: Column A B C (want these results) Part Delivery Longest Delivery 123 14 123 456 ...

I have data in mm/dd/yyyy format and was wondering how (or if) I could convert that to just day of the year (1-365)? thanks adam

I am building a spreadsheet model and attempting to pull data from a new business unit template. Each quarter, our business will start-up 5 or 10 new units...

i have a list of values with a corresponding checkbox to select each one. how do i get only whats checked to total in a cell? thanks

I am hoping someone can help me. I am using Excel 2002. The problem is that when I open one of my Excel files, Excel is creating a "mirror" of the file which I...

Hello, out there! How do I get a check mark to show up in a cell in a worksheet? I tried character map and found a checkmark in the wingdings2. However, when...