Functions

FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
I have a table of data that is used to input a product metric every month. Product names are in column [A], and number headings are in Row [1] (i.e. 1,2,3,4.....). We do not use month names. Metrics are then entered into each row horizontally, for the list of products. Because of certain minimum rules, not all... 5 Jul 2008 23:45

Help with a bsic formula
I am trying to write a formula, but, have got stuck as I haven't used Excel for a very long time. Hope someone can help me with this one - it is for my son's school and is based on the game of Cluedo:- Sheet 1 - column 1 will be a list of names (suspects) column 2 will be an item (clock, chair et... 6 Jul 2008 07:52

Help with blank cells when concatenating
I have a list of 2000 rows by 25 columns. I want to concatenate a cells e to y in each row. Not all cells have data in them but the cells that do have data in them have a seven digit number. I need to concatenate all cells with data in them and have them end up in one column, with each seven digit number div... 7 Jul 2008 12:30

How to get result by using CountIF, if there are 3 conditions to b
How to get result by using CountIF, if there are 3 conditions to be met? I want to get the number of occurances with 3 or more conditions to be checked! Please help Thanking you ... 6 Jul 2008 00:46

the value should not be more than 0.8
i have a date in colum a like this 1.8 3.8 0.0 3.5 1.1 0.8 5.6 4.8 4.5 0.0 0.0 i want to write a formual in column B, if the value is greater than 0.8 then the value should be less than 0.8, in this manner. at any point it should not go above 0.8 0.8 0.6 0 0.7 0.6 0.8 0.8 0.5 0.4 0 0 can any... 5 Jul 2008 13:32

Searching from a table
I have posted a question on mrexcel forum seeking help. I have got any help yet and would request few experts out here to help me. I have also posted there that I am seeking help from you guys too. http://www.mrexcel.com/forum/showthread.php?t=328448 ... 6 Jul 2008 06:51

How can i use lookup for data in reverse column ?
How can Vlook work to provide the data in revers for example: in one excel sheet my data is, A B 12 Raj 55 Abhay 96 Vinod 75 Ganesh in another Excel sheet my data is, A B Abhay Vinod Raj Ganesh I want the... 7 Jul 2008 09:24

Counting incidences of surname and date of birth and rearrangi
Thanks Mike, I'll give it ago. -- painless2 "Mike H" wrote: Hi, You probably need a 'Helper Column'. Assuming you names are in column A1:A1000 put this in row 1 of an empty column and drag down = COUNTIF($A$1:$A$1000,A1) Select all you columns including the 'Helper' and sort... 5 Jul 2008 06:24

Counting incidences of surname and date of birth and rearranging s
Hope somone can help, this should be easy but I'm new to excel. I have a sheet of 1000+ names with columns of surname, initial, date of birth. I need to count the incidence of unique records and then rearrange the sheet with the name with the most occurrences at the top, and following names in decreasing inciden... 7 Jul 2008 09:24

iam not able to find CONTACT PERSON collum in my exel work sheet
i need my CONTACT PERSON collum, iam not able to see in my work sheet so plzzzz help me out its urgend n becos of it my work got stoped,........ ... 5 Jul 2008 06:24