Functions

Multiple name appearances
Have a list of 1000 names trying to sort by appearances >5. Not sure if Lookup or Hlookup? ... 17 Feb 2010 12:15

Excel files take long time to open
I just upgraded to office 2007. I have files that were created in older versions of excel. Some of them contain macros and some don't. When I go to my documents folder and double click on an excel file, it takes about 30 to 45 seconds to open. I have Windows XP operating system. Any suggestions. one thing... 17 Feb 2010 12:15

Workday function not working
Hello, Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003? My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is the number of days. Any sugguestion, thank you. ... 19 Mar 2010 06:00

Pulling Data from one worksheet into another
Hi, I have a question regarding pulling text from one worksheet into another. Please can you help me? I need to duplicate the information (text only) on one worksheet to another one as it is typed. Is there a formula I can use that will allow the data typed in one worksheet to appear in the other one immediat... 17 Feb 2010 09:59

Delete some column headings from an autofiltered range.
I've selected a range of cells e.g. A6 to CP83 and autofiltered this range. I wish to retain the list headings for columns A to C but wish to remove the list headings from the remaining columns D to CP without affecting the overall list range. Can this be done? ... 17 Feb 2010 02:18

Counting days from a date
in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12 to today. ... 17 Feb 2010 12:15

MS Word equation
How can I edit MS Word equation after pasting it in excel sheet? ... 17 Feb 2010 09:59

how to automatically update a second worksheet when data inserted
I prepared a worksheet with years and names. This worksheet showed names, dates and other data (total five columns) with the names (column 2) in alphabetical order A to Z. I copied this to a second worksheet which showed all the same data but in year order (column 1) 1999 to 2010. Can I now insert a row of d... 17 Feb 2010 11:06

if statements for multiple entries
I have a spreadsheet that has a ID number in column A and an airport identifier in column B in sheet 1. I want to return a value ("1") if the ID number and airport identifier matches the ID and airport identifier in sheet 2. The problem is that sheet 2 will have multiple matching ID numbers and multiple airpo... 16 Feb 2010 22:54

Formula for unique records
I am trying to make a report a little more user friendly for a novice excel user, and I am trying to use all formula's instead of pivotables on large data sources. Is there a formula that will pull unique records out of a list of customer #'s as an example without having to use auto filter which would then req... 17 Feb 2010 09:59