Is it possible to have more than thirty arguments in a single average function? The arguments are not contiguous, so i can't just make them into data...

Can I split a cell in MS-Excell as we do in table in MS-word?

I have a timetable where with the date show at row 1 (from B1 to CC1) and time at column A (from A2 to A30). The rest of the data are the subjectID (about...

I need to create a unique list of the staff name which key in multiple columns (A2:Z26) where it also contains of empty data within the range. I know we can...

I need to create a unique data from a spreadsheet with the design as below: 1/1/07 2/1/07 3/1/07 ...... (date at row 1) 9am abc xyz ...

I have create a spreadsheet D and using Paste link from other 3 other spreadsheets (A, B, C) in the same workbook. The text shown corrently on spreadsheet D...

Hi, I am using excel to consolidate monthly room booking data. I have a date column and time column. May I know how to to delete those rows which contains...

Hi everyone! I'm looking for hints on the following: I have a list with a large number of values and I would like to sort these into four groups by...

That sort of says it. I need to create a list, probably on the same sheet, with the names & birthdays of everybody whose birthday, e.g., falls in October....

Each month we need the identities of employees who joined the company 3 months and one year ago. It is nonsense to go through the list manually, but I can't...

I am trying to create a function that will allow a user to select from a drop down menu. Upon selecting an option, I want the other cells in this row to...

I am trying to make a menu in exel... and I want buttons to click on to perform the macros I have made. So how do I make a costumize button? Click and drag...

i want know information about this man pleas

I am trying to come up with a template for expenses. We have 3 sources of shared expenses with 6 people. 1 person pays for 2 people , Another pays for 3,...

How can 2 cells have the same values, such that when I edit either cell the change is reflected on both?

I have a workbook that contains 14 sheets. I have a sheet for each month followed by 2 sheets for information. Each Month sheet has the following column...

I have developed a concantenation, but in the new cell it does not maintain the font of the data from the originals (ie, it is a concantanation of names, and...

I have one excel page and need to print 50 copies. I want them to be numbered 1 to 50. But all I get is page 1 of 1 on all 50. Is there any way to get the 1...

Excel 2007 with password. When you put in the password it comes up: "The file is corrupt and can not open". Works with every other computer. If we copy the...

My requirement is to be able to create a column whose elements consist of difference between adjacent elements in a column, say column A. If I can choose...