I want to convert grades to marks A* is 58 points A is 52 etc. I have been using lookup tables but they return A* as 52 points because of the wildcard...

I just wanted to know if there is a way that I can check the content of several cells with a function (possibly IF) to return a value in A1 if the cells...

hello group, Excel vlookup works only if its an exact match,data i have is not in the same format.For eg comparing John matthews & Mr. Matthews John.Thus...

I am trying to update a spreadsheet that someone else created and I have never seen this forumula before. There is nothing in the help files or microsoft...

Hello from Steved In Col A2 the number is 5543 In Col E2 the number is 5177 In Col I2 the Colour is Blue As col A2 number is different from Col E2 then...

I have created a data validation list. Now, I want to type the first character of the word, then the whole word will be displayed like when you type a word...

Hello, Here is my problem, I have 2 series on the y axis dan Date time series on the X axis. how come the markers on the 2nd data sereies are not all...

Dear all, I want to know how to set the functions about it: i will set the first row is headling lines, then enter the data start from row 3, when i pull...

my invoices need to show a due date of the 10th of the following month provided the current date is no later than the 27th. an invoice going out on 6/26/2008...

I need to have multiple workbooks for entering data and then have a Summary workbook that gathers all the data and lines it up in a single report placing all...

I need to have my workbook look for today's date but display Friday's date each week. For example: Today is Sunday, June 15, 2008, but I want the date field...

I have first names listed is column "A" and last names listed in column "B". I have a counif statement in column "C" giving me a total count of each name...

Hi Can anyone advise which excel function should I use to return the desired results? i.e. to count the no. of times e.g. computer components appear in the...

I want to apply a theme to a workbook. When I go to page layout and select themes and choose my theme, it doesn't change the workbook. A live preview when...

Hi, The following formula works: =SUM(H1,F1,D1,D3,E3,G3) How do I do the same with Sumif? (with whatever criteria) Regards - Dave.

My Vlookup formula is: =VLOOKUP(D81,'Week 2 Dataset'!G:O,9,0) How would I write this differently so that when a result doesnt match i get the cell to be...

Using Excel 2007. Multiple sheets in one workbook and each containing a list of "Questions" in column B. As each each is answered, a date is placed in Column...

GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!! A FUTURE MOBILE TECHNOLOGY FOR ALL!!!! VISIT: http://critisedets.blogspot.com/

I want to be able to control a user's input to a couple of test words such as "Yes" or "No" or a date. One of those 3 options and of course the dates input...

So present value = future value / (1+discount rate)^n where n is the number of compounding periods. If I have PV, FV, and n, I assume I use the RATE formula...