I have a few excel files in a folder.These files interlink to each other.I am planning to rename all files in folder & ensure the linkage formula also...

Scenario Worksheet 1- Cell A1 to A6 Worksheet 2-Cell B1 to B2 At worksheet 2- Cell B2, i write Vlookup(+B1,Worksheet1 A1:A6,6,false) and a result pop up at...

Hi all Cell Result Formula (672.00) (672) =--SUBSTITUTE(+$Cell,".",",") ...

I have time data stored in text file in mm:ss format. 1.. When I paste it in Excel, it becomes xx:xx:00, mm:ss gets converted in hh:mm:ss. 2.. I want to...

Hi, My problem is that I have a column A B 1 12 0,10 2 24 0,20 3 36 0,40 4 48 0,70 5 60 0,89

Hello, I have a simple question, I think. I would like to calculate the interest that a bank gives me on a deposit. Each month they give me the correspondent...

Hello, I hope I can explain what I'm looking for. Is it possible to link a formula to another sheet?? I'm trying to use a similiar formula to the "If"...

I have two columns: attendees and ticket prices. Certain attendees get certain ticket prices that others don't. I made a validation list for the attendees...

If I have a number of worksheets between a worksheet called FIRST and a worksheet called LAST in a workbook I can sum the contents of cells, say A1, on all...

An example. I have a workbook in which the worksheets are named for each month of the year: Jan through Dec (3 letter names) On each worksheet the same...

Where can I find a COMPLETE list of the functions provided in Excel? I'd prefer not to have to look in several different places each of which gives only a...

Gentlemen, I have been assigned a new task, to make a score card for Key Performance Indicators. I have asked the concerned departments for the data. Now...

In a worksheet I have 30 or 31 days in a month marked ina row For overtime I am using the following rule B for one rate, C for another and then writing the...

I undertake trainings on sundays, wednesdays and Thursdays. Is there a way that I can get the number of sundays, tuesdays and wednesdays from January 2009 to...

I have organized a quiz and decided on rewarding 10 correct entries. I have made a list of the staff ID and the corresponding name of all the correct...

I have dates in a column for eg 30-aug-09 ten times 1-sep-09 5 times 3-sep-09 6 times I want to add or count all dates of 30-aug-09 as 1 all 1-sep-09 as 2...

I have a column of data.Suppose I want the highest figure of this column of data in different format how do I proceed? can any guru tell me the possible...

MAX($B$2:$B$14)/$B$2:$B$14 I understand it as : find out the maximum value of the numbers in column B row 2 to 14 and divided by ??? The whole formula as...

I saw a worksheet for training programs in which this formula is written =IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) can the function C6EDATE(C6,12) can ever...

I need to have a formula check whether or not a particular value occurs within a range of data. For example, given the data set below: A 1 red 2 yellow 3 ...