I need to define a name for 31 cells in a worksheet. They are all in the same column, but they are about every 11th line. Excel will only let me use 23 of...

I have a large spreadsheet consisting of about 16,000 rows and 8 columns. The first columns are longitude and latitude coordinates. Is there a way to sort and...

Hi Guys & Gals: John provided me with the enclosed macro, (I have made modifications, so the problem isn't his fault) Problem: I can only get the enclosed to...

Hi Gals & Guys: I would like to do a function that would count the number of times an amount of the same / or greater value occurs in succession. I tried a...

Hello Guys & Gals: Can anyone help me with a formula that converts current Barometric pressure to Sea Level pressure? Thanks a lot. -- Wayne Friendship...

How do multiple users adjust a common worksheet over a network? I wish to create a worksheet so that several users can update where a project is up to at any...

Hi Everybody, Is it possible to do multy thread Programming with Excel. i.e. Assiging each worksheet to a thread and run all threads simultaneously to reduce...

Hi all, we are currently using MSExcel 2003 version. We are facing a problem of deleting perticular data by selecting the range. We are first selecting the...

Hi, We have developed a customizd macro where we are sorting more than 5000 rows. For a particular selection, the current region range is not getting...

Hi all, I am Radha krishna, I am having a doubt in Excel VBA programming. In our work we are doing formats such as Merging, row banding, Button creation,...

Hi, Can any one help me how to shade the alternate rows even when some rows are hidden using conditional formats. forexample. suppose i am using gray colur...

Hi , I am using the sheet reference in a formula. the sheets are named on the basis of dates of a month... So i have to change the formula in every month...

hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...

hi, i have the below data and i need to make pivot from multiple sheets.i have tried to make by selecting multiple consolidation ranges, bbut it is not...

i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns. i need to use the vlookup function in Sheet1 taking the range from column E to...

Hi, I need to make a pivot from multiple sheets. I have tried to make by consolidating the sheets, hoeverthere are some limitations to that. It does not...

Hi, I have below data with me, i have 4 columns where the "no of days" for Employee ID (under a particular manager ID) is coming with -ve value as well as...

Hi, can anybody help in the below query i have the below data with...

Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...