I need help with a listbox. I have figured out how to add a listbox to a worksheet from the Forms toolbar and how to specify the input range. I want to be...

I have used this newsgroup several times and always get my answer. Im just wondering who you people are that answer these questions? And thank you to you all...

Can an excel file be put on a public drive than copied onto individual computers from that drive, where any changes to the file on the public drive will change...

Hi, I am using a "Subtotal" Function in a worksheet that I have to sum certain columns that I filter on. However, I need to combine a "Subtotal" function...

How do I set up a lookup formula that uses two lookup values? I am trying to do a formula that has one absolute value (it will always equal "A"), but each row...

Very simple example of Data I'm working...

Hi, Is there a function opposite to concatenate that splits text in a cell? Thanks

On of my criteria is ....*(StoreArray=Store)*...... But somtimes the range Store = "All" which is not a value in StoreArray. So I tried...

When using Sumproduct as a multiple criteria sumif function, I've seen it used two ways: sumproduct(()*()*()) sumproduct(--(),--(),()) My question is are...

I have used this newsgroup several times and always get my answer. Im just wondering who you people are that answer these questions? And thank you to you all...

Hello all This is extremely annoying!!!! I am using the count function for to count #of days work was completed. than another to count errors. so one...

I have a combox box for a long list of names. I'd like to be able to type the first letter of a name and automatically go to that part of the list. I don't...

I have a whole row which has comments on them. How do i transfer them to a whole row?

Is there a way to have excel populate the current date such as =today() or =now() but make it so the next time you open the workbook the original date is still...

Thanks in advance for your help. I am querying a website for some tabular data. This website contains several pages of tabular data in the following...

Hello I have a question I’m creating a weekly schedule in excel. I was wondering if there is a way to create a Rule that if there is more than 40 hours...

Quick question about office 2K and windows XP- If and when I open 2 or more files in excel i get 2 instances of excel.. I want them both to open in 1...

Thanks Bernie, This is working great with numbers. However, I'm trying to sort a list of names (TEXT). I have tried to use the "code" function to determine...

Can excel support ratio's. ie: 20/1 but I want to show it as 20:1 where one cell has 20 and another has the 1. when divided I get 5% but I want 20:1 Any...

I can make a drop down menu just fine,. My problem is that I want the choice for the drop down menu to then fill in something other than what the choice is...