I am a bit of a novice in the workings of excel. I have created database of fungi records from the london area and have uploaded it to my website. It appears...

I have a column of numbers. Looking for an array formula that will identify and highlite the "highest" three values. Does such an animal exist?

Puxa não consigo criar um calendario perpetuo com feriados ! Alguem pode me ajudadar ? Desde de já grato;

Hi, I have an Excel spreadsheet, where I am trying to put multiple results, into a single cell. For example, I have a dropdown selector "Yes" or "No" in a...

I created a lot of user-defined functions in Excel2000 and I access them from an .xla file (add-in). I frequently send my workbooks to colleagues using...

I copy and paste-special values repeatedly. Is there a keyboard shortcut so that I don't have to point and click the mouse to "Edit" "Paste Special" "Values"...

I have read numerous posts detailing this issue and all the replies have been unhelpful. So hopefully, I can get some actual help for this issue. This issue...

Would like to use data from an existing excel data base for use in a PDF form (W4 - witholding or similar). Can this be done, have had no luck reformating the...

Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve...

I have a workbook with more sheets than I can easily navigate through. I would like to create hyperlinks that jump to other pages, but after following the...

I created a process using Excel 2002 and a step is to break links (Edit/Links/select all links and click 'Break Link') - however, the users only have Excel...

I have a workbook where numbers are entered as whole numbers (includes cents but no decimal point) on one worksheet. These numbers are pulled into another...

I am trying to process a large amount of data that has the format dd/mm/yyyy hh:mm:ss and needs to be converted into yyyy/mm/dd hh:mm:ss. I have...

Hello, How can group adjacent columns independently? If I group them one at a time they get grouped as one block. Please advise.

Any Ideas about what code would read the formula in cell c3 of every workbook in a folder and give an array of the workbook names and...

Hello :). I am trying to import a table from a web-page where some of the values are written for example as 7 -35. Using Data/get external data/new query. I...

I'm trying to design a worksheet that will import data from other worksheets.. I'm a relative newbie with Excel formulas. The formula that I'm getting hung up...

I have written an App which runs fine on a Windows PC (Win98 or XP) with 128 Mb or RAM It immediately runs out of memory when run on a Mac of similar spec...

Hi all, Currently I am trying to enable users to specify date range in my report generated by my pivot tables. I was thinking of using an mdx query...

Every Time i want to Enter some Text in to Excel it is automatically formatted as Scientific Text .. IE: I enter in 5E1 amd Excel Automatically formats the...