I HAVE A 38 PAGE PRICE LIST WHERE COLUMN "A" IS A DESCRIPTION OF THE ITEM, COLUMN "B" IS THE PRICE, COLUMN "C" IS THE QUANTITY AND COLUMN "D" IS THE TOTAL...

When scrolling down through many rows I often find that I way overshoot the end of my data. Is there a way to identify a row as the last row of data so that...

I need to randomly order numbers from a list or range of consecutive whole numbers, such that each number is listed only once. Can this be done in excel using...

If I put a dash and put zeros in after it, how can I make it stay in that format? Or even, how can I make a cell display multiple zeros instead of one? I...

Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc Hi, What is the best way to enter a maturity date to calculate PRICE function? If I am not looking...

I'm a beginner with excel macro. I tried to write a macro and soon I found I couldn't finish it so I just determined to delete it to get out. Then when I open...

I have been using OmniPage 12 to scan columnar data and then export it to Excel. So far I have had reasonable success with the OCR formatting but...

My data are in 19 columns and 600 rows. I need to find the minimum value in each row. At the top of the columns are descriptions (e.g. Pen A, Pen B...). I...

Hallo, i have a problem with Excel. What can I do with URLs in Excel if a part of the URL is no more actual? That means in my case... I have about 400 URLs...

After I set the print area to include the chart I want to print, the printer sends back a kernel error and will not print. What I want to print show up fine on...

I subtotal my current balance on address and then I want to count how many distinct addresses there are

In J5 I have the following formula which tells me what commission to...

I want to find all the dates from a list that are earlier than a specific date and replace them with another date. How do I do that without having to do one by...

I have an excel file to determine parts needed and costs for the many projects we have going on. I have an Access Database table load into a sheet of the...

I am working with Excel 2000. I have a worksheet that has several pictures on it. Each picture has an associated macro. The macros are in an extenal...

I have a field asking for a county name. There are 77 possible counties to enter. I want to ensure that the user enters a valid county and has it...

I have copied a web page into EXCEL that contains numerous hyperlinks labeled "e-mail". When I click on the hyperlink Outlook opens and the e-mail address is...

I'm creating a form which I will save as a protected template. How do I allow users to insert their own logo in a designated area? Is this possible? I tried...

I am using data groups and outline in excel 2003. When I want to minimize a grouping, I am receiving the error message "cant shift object off sheet" How do I...

I've just created a fairly complex work sheet with some grouped columns. I wish to protect some cells with formulas but have other people enter data to the...