Hi I have a dat of around 2500 line in 2 sheets of a workbook(in Excel 2003), I need to match up these data with eachother. the data in column A(sheet 1)...

I have a hyperlink. I wish to change the number 35473 automatically based on the count formula. The current count is 35500. With this formula, I have to still...

I'm trying to get Excel to randomly choose a number from a set of 58 different numbers using this...

I'm trying to get Excel to randomly choose a number from a set of 58 different numbers using this...

I have a summary workbook that pulls information in from other workbooks. Each workbook relates to one specific real estate property. So each of the source...

Hello! I am trying to create a simple formula which would compute a discounted price on a product. If I choose to calculate the discounted unit price based on...

Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date...

I am trying to write a macro that will sum a set numbers that are a part of a column. I have inserted empty rows to use as breaks for the Ctl+down or...

Is there a way to tell from the source workbook, which workbooks use the source as a reference?

I have a fairly large excel file. How can I send this out, so it is readability on the screen, since many won't print it out.

Hello, I am looking for a formula that will help with the following distribution question: Take a quantity of items (for example 1.5 apples) and distribute...

Hello, I am looking for a formula that will help with the following distribution question: Take a quantity of items (for example 1.5 apples) and distribute...

I have a downloaded list of charges on my credit card that I would like to catagorize. The descriptions are like: ILLIANOS Ristorante (Dining and...

I have a worksheet in which i must subtract cells to show a variance. However I would like to created a chart to dispay the values. The problem is when...

I have 4 columns of data. Column 1 is "daily", Column 2 is the daily value, Column 3 is "monthly", column 4 is the monthly factor. Example: 01/01/2009 ...

I need a formula for when a workbook is opened it will default to a specific tab.

I have a doc with numerous worksheets related to retail inventory, traffic, each store's orders and a totals page. I want to total the quantity of a...

I am trying to create a formula that will tell me how many check boxes are marked in a certain column. Does anyone know how to do this?

How can I make a cell flashing when open a spreadsheet?

On 17 Mar., 00:04, Steve wrote: In xl2007, to the bottom right hand side of the "Outline" section (where the group and ungroup...