Member

Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one... regards hardy

Hello, I was wondering if anyone knows how to match similar but not identical cells in excel without specifying the exact match string. For example what formula would match the first word in one cell with the first word in another cell, or say the first 5 characters. For example, matching the cell "ABC Learning Centres" with "ABC Le... Read more

Hello, I'd like to scan a column for a certain word (e.g. "apple") and put a code (e.g. "A") on the cell next to it each time it finds it. In this case, "apple" might be by itself or in the middle of a sentence. Read more

Hello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in other cell and user must not change any cell, therefore result of formula change in cell but macro not run?! Thanks

Hi, I am trying to find out how to get an excel spread sheet to hightlight a date when that date gets near. There must be a way for the sheet to recongize the date on the computer and perhaps hightlight the cell. I know I can put =DATE() in a cell at the top. But how do I then tell the column w/ all the dates, that "when it get... Read more

Hello, I've been looking for a solution for the following issue: I have a very long excel list of product description that contain product with OZ value. For example: Bottle A is 4 Oz I would like to convert the OZ to milliliters so that I could have Bottle A is x milliliters How can I do a mass find and replace f... Read more

Hello, Please let me know how can I remove conditional formatting from blank cells? I set a formula (ex: smaller than other row) to determine which cell will be formated, of course blank cell will be formated also, and I want to avoid that. Thanks!

Hello all I'd be grateful if anyone could advise on a formula to highlight a cell which would change colour 30 days before the expiry date. I believe this would be a conditional formatting. Say I have a date in Cell A1, which is the expiry date of a training certificate eg 07/3/2010, I would like the cell to change colour to red 30 da... Read more

Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a certain value appears in a column even if there are multiple values in the same cell. For example: A respondant may have selected answer a, b, d for question 5 (all 3 of these would be in th... Read more

Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions but didn't work. Can anyone help me? Thanks. David

Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The column of data varies in the amount of data each time. A B C D E F G H I J etc into A B C D E F G H I J etc Thank you in advance for any advise or solution that will help... Read more

Hello, i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying to add that data over on the other spreadhseet becaue not all the names are on the spreadsheet i'm trying to get a result on. please help. example: i'm trying to place the job location to the... Read more

Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "Scb", years 1994-1995, "J" 1996-1997, "Y" 1998-1999 and "E" over 1999. Is there anyway I can do this? Any help would be appreciated. thank you. Read more

Hello, I am tyring to name a range say a14:d14 (working_cap_formula) and then copy of past into range a15:d15 (working_cap_paste). I have set up a macro to do the sopy and paste process but would like to name the range in the macro to ensure if rows are deleted or inserted above row 14 then the macro will still find the ranges to co... Read more

Hello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet with a list of employee names and their relevant information. I have another excel worksheet with a list of employee names that have accounts in a system. I would like to know what employee ... Read more

Hello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code

Hello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code

Hello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the add Tom in column next to it ( this is who she reports to) , if first column second row is Mary and automatically add Julie on the same row she is but this specific column. Example: Name o... Read more

Hello, I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells is: =IF('2009'!E2>0,'2009'!E2,""). My problem is trying to find the total of these cells. I'm adding 3 and subtracting 1. The formula I'm using is: =IF(SUM(C2,E2:F2)>0,SUM(C2-D2+E2+F2),"... Read more

Hello, I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it. Thanks for your time, Manohar