I have imported a list which only gives the whole name for an individual. In some cases there is a first and last name, other have a middle name, or a middle...

I am trying to convert multi tabs excel file into csv. Can I get all the tabs in csv format in a same file? Tks

Hi all, I have a weird problem here. I have some formulas in a tab looking up data from an external workbook. As usual, if the external workbook is open,...

Hi. I am working on a worksheet witch draws data from another application. All drawn data appears fine on the worksheet but the date columns. They are...

Hi, I am working on a column that has the same entries 2 or more times. Is there a way (copy-paste or other) to get only unique entries from this column (that...

Hi, I am working in a Pivot table. I have data analysed by each month of years 2000-2005. I hide monthes 1-12 for years 2000 - 2003 so that only the total of...

Hello, I am working on a pivot table that displays data from various dates from 1999 to 2005 and i would like to filter it to show only the data...

This is first day I have become member. Greetings to all of you. Can someone tell how I can use or function inside SUMIFS function in excel. Best...

I asked thsi question last week and thanks Luke M for his kind interest. However it did not solve my problem for example I'm writing SUMIFS(long and 4-5...

Hi, I have a excel file with 16 spreadsheets and I would like to limit access of certain users to certain spreadsheets in the file. Is there any solution...

I have to keep track of load ticket numbers for our trucking company. I have it set up so they are all in one column. Is there a way I can set it up to warn...

Below is from a post dated 2004 by Ron Rosenfeld. It is supposed to check the comma seperated numbers in a cell and filter unique ones and show in sorted....

Two day ago, i did my assignment by using microsoft Exel 2003. In between my work i have save the data.But today when i open again the same fail i didnt find...

Please POST response because email used is bogus to prevent spam: In my cells I have a formula and the formatted result in a percentage format. In my...

I am having trouble with the syntax of a VLOOKUP argument. I am using Excel in Office XP My unique column of numbers (the vlookup) value is a variable. I...

Please post response as email is bogus to prevent spam. I am using Excel 2003. I hope I am clear in my description of my need. I get a weekly sales report...

I have created a workbook with several sheets. I have timed the sheets to stay open for a specific period of time and them move to the next. On the final...

I have several spreadsheets containing data that I would like to consolidate into one spreadsheet. Each of the spreadsheets have a common Product Code field...

Please respond to newsgroup as email is bogus to prevent spam. I am using Excel 2003. I am merging cells in one row so lines of text can be entered. (If...

I am using Excel in Office XP. I have a set of values pertaining to a unique identifier. These unique id's would be a range from say 1230000000 to 1230099999...