|
sorting array formula Good day, Please help me prepare a sorted column of infos based on below (e.g) table In sheet 1 col A col B col C col D col E row 1 NAME 100 105 215 280 row 2 ABC A1 A2 row 3 CDE C1 C2 row 4 DEF X1 X3 row 5 FGH F1 F2 Result desired thru formulation In Sheet 2 (e.g) col A col B col C row 1 ... 6 Jul 2008 02:47
Run formula automatically I have an inventory list of air filters for different locations. When I" enter a date indicating the filter has been changed, I would like it to automatically take that out of inventory so I know what to order. Can anyone help me on this topic? ... 6 Jul 2008 01:47
Protecting worksheet Hi, I have a sheet with some protected cell, which allows others to enters some date on the unlocked cells. I would like to see those unlocked cells to be locked as soon as some one enters the date and saves the file. ... 5 Jul 2008 20:41
Multiple Criteria to Classify groups HI! I am a dummy beginner but very interested in improve my skills. I have been 4 hours trying to understand the logic on multiple criteria formulas and I am afraid I am almost going to give up... Someone around could PLEASE help me? Suppose I have 10 different type of groups to classify a loooong list of s... 6 Jul 2008 02:47
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... 5 Jul 2008 13:32
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... 5 Jul 2008 14:34
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 ... 5 Jul 2008 09:27
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... 5 Jul 2008 11:30
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... 5 Jul 2008 06:24 |