Registration date
April 12, 2009
Last seen
June 29, 2010
December 8, 1980
Lahore / Lodhran, PAKISTAN
Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

How to calculate positions(1st,2nd,3rd...) in Excel [Solved/Closed]

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

Partial Cell Match of Company Names in Excel [Solved/Closed]

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

Find word within cell & put value in adjacent [Solved/Closed]

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

Run macro automatically [Solved]

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

Excel cell flash when date is near

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

Excel: Convert Oz. to milliliters inside Text

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

remove blank cell from conditional formatting

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!

How to create a count down formula [Solved]

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

Counting number of times a value appears if.. [Solved]

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

moving data from rows into columns for every [Solved]

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

index and matching 2 different spreadsheets

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

Excel If Function over a range of dates [Solved]

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

naming range in a macro

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

Comparing two excel worksheets [Solved/Closed]

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

go to next page in word doc using VBA code [Solved/Closed]

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

Look at column and match and add this text te [Solved/Closed]

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

Excel "IF" formula problem [Solved]

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