Thanks for the suggestion it did work really well, but I think I'm dealing with a little too much data for it. This is an example of what I'm trying to...

(I am not sure if this is possible) I am trying to configure a formula to tell me how many times certain number appears in a column of numbers. Is this...

Someone here once gave me the formula for converting a Date to the number of the week. In other words 1/16 would be 3 as it falls on the 3 week of the year....

When I paste (regular or special) a 10 digit number beginning with 989, I get 9.89E+09 displayed in the actual cell, even though the actual 10 digit number...

=?Utf-8?B?VG9tIEtlcmVzenRlcw==?= wrote: I am building a spread sheet that needs goal-seeker to find changes that satisfy a condition. This needs to be...

I understand there are "ifs,if's?" in this program... What are "ifs, if's"?

Hi, how can I find out which day in week it is for certain date? Thanx alekm

I need a macro that will insert an extra blank line that includes a *total* formula in the last column. Simple if u know how, im sure :) Can anyone help me out...

Is there a way to delete more than one graphic at a time from a worksheet? Picking one at a time is a pain if you have lots to delete.

I have created a Pivot Table but, unfortunately, I did not name my source-data range. Now I want to add more rows to my source data but I cannot find a help...

I would like to easily/quickly toggle series in an Excel chart on and off. What I would really like to have is some way to click on a series in the legend next...

All of a sudden I am having trouble printing excel spreadsheets. The text shows up with horizontal streaks of missing ink through it. Test pages and...

When opening a text file in Excel, the Text Import Wizard doesn't show and the file opens as blank with nothing in it. Any ideas? Thanks, - Andrew.

when i try to apply the below mentioned procedures; when i type list2 in the Input Range of Combo Box2, i get the msg "Reference is not Valid" Can any body...

I have data per/year, but i want it extended for a monthly sheet. I have: 2005 10 2006 12 I want: Jan 2005 10 Feb 2005 10

I'm using a simple dsum to collapse and summarize records. My criteria is a text field. My target or search database column is a text field. DSUM returns...

Hitting F2 followed by Enter changes the results of a formula in my worksheet. Hitting these 2 keys repeatedly, toggles between 2 results. It's like this: F2...

I have a list in C4 that contains the following items: Airfare, Car Rental, Mileage. I want to be able to insert text into C5, depending on what the user...

Hi, Every time I click on a shortcut link to a spead sheet, whether on the desktop or from e-mail I get a message that says "A document with the same...

I have a workbook with a link to a workbook that no longer exists. I can't figue out how to remove move it. There is nothing listed in any of my books or the...