Hello, I was wondering why my text formula of proper is not working. I have placed the formula =proper(f2) in column e2 All I get is the formula =proper(f2)...

Hello, I am trying to do a subtotal on a very large worksheet. My problem is that I only need to Subtotal on Changes in categories like Peoples Names and...

fleet maintenance for vehicles

Can you create Macros in Excel student/teacher edition 2003

I need a date formula that returns the date of the friday from the week before. For example i need it to return March 07 2008 up untill March 14 2008 the it...

I need to write an if function that says when text is enterd in a cell it needs to return "please enter a value!!!" I cant remember how to define text in the...

Hello everyone, I am trying to sort part numbers from column1 but I want the descriptions which are in other columns 3-10 to follow the numbers. I want to use...

Does anyone know what formula I enter to perform the following function? If a cell in a row contains an entry such as "R1 Live" and a second cell in a row...

i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty...

Hi everybody, I want to write a function for a friend of mines Embaulming business to have Excel automatically change a two letter code that he types in for a...

HI Guys Can somebody show me how to do this simple if statement. say i have two rows A and B row A has a set of names in like peter, dan, simon etc etc and

Hi Guys I know this is simple but can somebody tell me how the below formula should be written =IF(C2="PARENT" AND B2="B",90) I know the "AND" part in the...

Hi Guys I need a function or a formula which can do the following...... I have two worksheets. One worksheet has a list of names in a set order that can't...

I have a client that wishes to create a rolling spreadsheet. He would like information from one or more fields on a spread sheet to roll over to the next sheet...

I want to have the current date show up in the first row say A whenever someone enters information in a row - in other words if there is data in cell C4...

Endtime is a column(named Range) with time entries, StartTime(another named Range) column with time entries and i need to be able to subtract the end time...

Is there a way to get the current date to populate in a cell whenever there is information typed in a row for example row 1 contains several colums of...

Dear All, Great forum - hope someone can help with this. I have data in same workbook, different sheet arranged in cols with assigned NAMES to ranges. For...

excel is having auto recover instead of autosave feature, and we have to reset this feature to all the files we make. how can this feature can be used to...

I would like to reference cells in different worksheets (up to 9) based on a number entered in cell G6. Below, I am using nested IF statements for a reference...