You are here:
Excel/Questions Answered by Expert Tushar Sakhalkar
| Subject | Date Asked |
| EXCEL | 12/24/2011 |
| Q: SIr, If I put data in one sheet like name mark ================= bob 35 mike 65 jean ... A: I do not think, you need macro unless you want it to be done automatically every time entry is made ... | |
| query in excel | 12/22/2011 |
| Q: I have a query, i have a master sheet containing data in 17 columns A to Q and 10 secondary sheets ... A: You should be able to manage it easily by writing appropriate IF statement. Let me try to ... | |
| create macro to populate cells | 11/25/2011 |
| Q: I have 3 worksheets, one (DATA) that has my data stored in it, one (ACTIVE) which has all the cells ... A: I have really not understood the requirement. 1. Someone enters value in Active!A2. 2. Macro ... | |
| insert space | 11/18/2011 |
| Q: My name is John and i want your help. I have hundreds cells with 13 numbers each one. For example: ... A: There is certainly a formula (Assuming original data in A1) -- "=Left(A1,4) & " " & MID(A1,5,2) & " ... | |
| auto populate data tables based on a drop down selection | 11/11/2011 |
| Q: I am desperate for a way to automatically list a table of data based on the option selected in 1 ... A: Solution I think could be -- (1) Create a complete database on another worksheet (say "Data')in same ... | |
| Check Box Protection | 11/5/2011 |
| Q: I have been working on a worksheet that I would like to Protect. I have several check boxes that ... A: You need to do 3 things for this thing to work. You are already doing the two. 1. Removing TICK mark ... | |
| formulas | 4/25/2011 |
| Q: I have a spreadsheet that I need to fill in some columns with an * or some other symbol to designate ... A: YES it is possible. But here are cases- CASE 1 If you have $10000.00, Excel considers it as 5 ... | |
| copying formulas | 4/13/2011 |
| Q: I have one spreadsheet that has the list of items going ACROSS. Row A has the list of names going ... A: Presumptions -- Sheet Names are "Sheet1" and "Sheet2". Now if you want to say "Sheet1!C8" in Sheet2 ... | |
| excel problem | 3/23/2011 |
| Q: in excel sheet when i entered any amt (i.e.1000) it is automatically convert in to lesser two digit ... A: Click on Office Button (Round Button with Office Icon - On your left Top Corner) Click on "Excel ... | |
| compound return calculation | 3/15/2011 |
| Q: If I have the following annual returns: 23.13 10.58 2.02 -1.56 19.21 18.77 34.79 31.93 Is there a ... A: I do not understand EXACT need. There are various formulae in Excel for financial calculations of ... | |
| Excel Formula | 3/7/2011 |
| Q: I have an excel sheet (simplified a sfollows) Name Group Pak 1 one Sri one Pak 2 one Ind one Pak two ... A: 1. It does not look like a array formula. Array formula starts with {. May be you did not put it ... | |
| CF | 2/23/2011 |
| Q: I am using excel 2003I have a few conditional formats in a spreadsheet that highlight when certain ... A: Unfortunately there is no standard functionality in Excel 2003 to count number of cells based on ... | |
| Excel Colour Change Question | 2/21/2011 |
| Q: Here's my situation. I have a column of numbers. I need all numbers between 16 and 24 to remain ... A: You need to use "Conditional Formatting". Unfortunately, detailed steps vary greatly in Excel 2003 ... | |
| Formula | 2/17/2011 |
| Q: Greetings to You! I need an Urgent help that i have two columns, Amount & Narration in Excel. One ... A: There is no direct function to handle this. But I can suggest to use an additional column. Let us ... | |
| Macro to copy filtered data from one sheet to another. | 12/15/2010 |
| Q: I have an excel file which contains a "Base Data" sheet consisting of columns "A" to "BH" and a ... A: Prashant, Only recording a macro will not always be enough. Some parameters will need not be ... | |
| Macro Issue | 11/11/2010 |
| Q: I am using Excel 2003 and as I am limited to 3 conditional formats I am writing a macro to do this ... A: Yes.. you are right in saying that you will need to use IF consitions along with CELL PROPERTIES ... | |
| Conditional Formatting a Date | 10/22/2010 |
| Q: I would like to flag my Corrective Action Due Dates by the following in Excel 2003, how do I do it? ... A: I do not have Excel2003 on my desk now. Hence, I will only give you the logic to be used and cannot ... | |
| excel macro | 10/20/2010 |
| Q: Please help me in creating a macro in excel such that any columns including un labellled columns ... A: I can do it pretty quickly once you answer following questions -- (1) What are names of sheets - ... | |
| SUMPRODUCT Formula Problem... | 10/12/2010 |
| Q: =SUMPRODUCT((WORKSPACE!D5:D22=A17)*(WORKSPACE!N5:N22=LISTS!C17)*(WORKSPACE!P5:P22)) Hi, I have the ... A: It is very nice that you have already analyzed part of the problem. The solution (probably) lies in ... | |
| Import delimited Textfile | 7/26/2010 |
| Q: I need a macro to import the Delimter text file data into excel sheet Assume my Delimiter Textfile ... A: Sub Macro1() ' ' ChDir "C:\" Workbooks.OpenText Filename:= _ "C:\YourFile.txt", ... | |
| Excel | 7/21/2010 |
| Q: Tushar - The use of a formula in conditional formatting is a fantastic idea! I'm just getting an ... A: Use following formula for E12-- = OR($B12="Lincomycin-2-Phosphate", $B12="Clindamycin-B-Phosphate", ... | |
| Excel | 7/19/2010 |
| Q: My question is about automatically Bolding a cell. I have 4 different names that I would like to ... A: If you are looking for 4 values but using same BOLD condition, why don't you use OR statement in 1 ... | |
| Excel | 7/16/2010 |
| Q: My question is about automatically Bolding a cell. I have 4 different names that I would like to ... A: Your solution is probably in in Conditional Formatting. Are you sure you want your result in E ... | |
| Numbers Letters | 7/15/2010 |
| Q: I use a 10 letter code to represent Numbers PRUDENTIAL-1234567890 I would like to type into a cell ... A: It can be done by Find. For example in A1=PRUDENTIAL and B1 = T then C1 formula =FIND(B1,A1,1) will ... | |
| Formulae | 7/8/2010 |
| Q: hey, i previously asked theHey, just wondering is there any way to use a letter in a specific cell ... A: Let me explain the logic so that you can use it repeatedly of your own. The function INDIRECT works ... | |
| EXTRACTING INFORMATION FROM SEPARATE EXCEL SPREADSHEETS | 7/8/2010 |
| Q: I have monthly Excel Spreadsheets that track work assigned to different individuals in my company so ... A: Firstly I am confused by your terminology. We have workbooks and number of Worksheets in them. What ... | |
| trouble recording a macros for a "submit" button | 7/6/2010 |
| Q: I am trying to program a button on an excel worksheet (in excel 2003) that is designed to work as a ... A: The trouble is recording a macro alone is not always enough. Here as I can see, you have recorded ... | |
| Formula | 6/29/2010 |
| Q: I have a database that includes a person's city of residence and date they had an appointment. I ... A: Just try taking sumproduct of three entities.... in D2 you enter desired month (say 1) in E2 you ... | |
| Show Automatic additional info | 6/10/2010 |
| Q: "Hi, I am making a database in MS excel of people that are members of my club that are contributing ... A: Let us assume you maintain ALL information in a sheet called "MASTER" Make sure that you have ... | |
| Drop Down List | 6/8/2010 |
| Q: I am trying to create an excel spreadsheet for my office. One of the things we are trying to do is ... A: For such a requirement, you need to use Conditional Sum. Please read following to understand-- ... | |
| Drop Down List | 6/3/2010 |
| Q: I am trying to create an excel spreadsheet for my office. One of the things we are trying to do is ... A: I will need to make some assumptions... Suppose your Column A contains Categories such as Home, ... | |
| Excel2003-VBA | 5/25/2010 |
| Q: "i want a VBA code that will select the .txt file from given location,currently i am able importing ... A: Sub openfile() response = MsgBox("Please open the file (containing User Data) you want to use.", ... | |
| vba macro [filter] | 5/24/2010 |
| Q: i have a list of customers in workbook1-sheet1-column A.i have another list of customers in ... A: Preparation: I have entered various names in Column A of Sheet1 (e.g. JOHN, SAM, TOM....) I have ... | |
| input function for dates | 5/11/2010 |
| Q: I want a input box to enter a date and then save this date. I will then in the later half of the ... A: To get the date..... myDateString = InputBox("Please date in the format dd/mm/yyyy " , "Get Date as ... | |
| Copying data based on matching all the values in a column | 5/10/2010 |
| Q: I have 2 worksheets, 'Data' which is the master data sheet & other being 'Final' where user can get ... A: Assumptions-- Data is in Sheet1 from first row itself. You will enter your choice in D1 of Sheet2 ... | |
| VBA Code | 5/9/2010 |
| Q: I have statement of Account for different company in one excel Sheet, i inserted filter , auto ... A: VB Macro would work fine. But I would rather prefer a way to use Formulae. How may companies are you ... | |
| distribution list to be copied to spreadsheet | 5/6/2010 |
| Q: "Whenever I open the excel spreadsheet, all the contacts from specified ms office distribution list ... A: The requirement is not clear. Do you have multiple sheets? This is possible.... The way will be -- ... | |
| conditional formatting | 4/30/2010 |
| Q: I want to conditionally format a cell based on a certain cell for example in cell A3, there may be ... A: I am answering the question based on Excel 2007. If you are using Excel 2003 and are unable to do ... | |
| Hiding Rows depending upon a value in a Cell | 4/28/2010 |
| Q: I have a 2000 rows spreadsheet. However my users may only want to display a smaller amount of this ... A: Please try following Macro Sub asknhide() 'Count total no. of rows TotalRows = ... | |
| Macro to generate multiple sheets in one workbook | 4/25/2010 |
| Q: I was looking for a solution to the above problem and realised that the question had been raised ... A: Let us say- In Sheet1, ColumnA you have list of names for new sheets. Sheet2 (named as "Template")is ... | |
| macro-Delete Row | 4/19/2010 |
| Q: Is there a macro that deletes rows if the third cell (C Column) in the row is non blank? A: There is no ready macro. You will need to write something like -- Sub delrow() i = 1 myRows = 17 Do ... | |
| Excel formula | 4/14/2010 |
| Q: I have got a list on database with 100 items with specification From column A to T, each item has ... A: As can think, this will not be possible though Excel Formulae. You will need a Macro for this. ... | |
| Excel Formula | 4/6/2010 |
| Q: i have question about excel formula.i have months and amount column.I want to add total of amount ... A: Prem, You can use SUMIF but you will need to add the formula at appropriate cell. If this is OK, you ... | |
| DSUM - Criteria trouble | 1/22/2010 |
| Q: I know and can use DSUM, but I need to do a DSUM calculation on a matrix using several rows which ... A: Most times, referring a cell in formula dynamically is possible by using INDIRECT, ROW, COLUMN ... | |
| Excel Problem | 1/22/2010 |
| Q: Respected Sir, I was working with an Excel Spreadsheet in my office. Suddenly my computer shut down ... A: Try this (Success not guaranteed) - -- Start Excel -- Open (This should open navigation box) -- ... | |
| Protecting formulae in Excell | 1/13/2010 |
| Q: I need help to protect formulae in Excell Vista. When i try to protect it seems i can only protect ... A: Harsh, You are right. You can only protect entire sheet. However, there is a way how to skip some ... | |
| using ranges with 'if then statements' | 12/31/2009 |
| Q: I have two separate spreadsheets. I need to look in a range of cells for numbers 1-100. If these ... A: Assumptions: 1) "Sheet1" has data to be looked up in Column A. 2) "Sheet2" has similar data in ... | |
| Reading values & looping | 10/5/2009 |
| Q: I have been trying to find help to create a simple(at least I think it is simple!) macro for sorting ... A: I am sure MACRO can be written but my first effort would be to avoid MACRO and achieve it by ... | |
| Macro Help | 10/4/2009 |
| Q: I am just learning the use of a macro. I need certain cells from sheet 1 to be posted on sheet ... A: You will need to -- Worksheets("Sheet1").Select Cells (i,j).select -- Replace i / j with your cell ... | |
| Excel macros | 6/5/2009 |
| Q: How to run a macro which is in a sheet from another sheet in the same work book? A: 1. Create a button and assign Macro. Click the button to run. 2. If you are using Excel 2003 or ... | |
| Can control toolbox check box data be manipulated into a pie chart? | 6/3/2009 |
| Q: I have already created a worksheet that has several checkboxes created from the control toolbox. ... A: Answer is yes. Check box results are linked to a cell. If you have not done it do it by maintaining ... | |
| regarding grid lines in excel Sheet | 6/1/2009 |
| Q: Sir, 1. How to insert gridline in one cell in Excel, nowadays we are applying gridlines to various ... A: Vinod, (1) Firstly, there is no cell A in excel. A is a column. The cells are specified as A1, B5 ... | |
| identifying duplicate data in Excel 2003 | 1/25/2009 |
| Q: I'm virtually a complete novice on excel, and need help. I have two columns of data A and B, and i ... A: There is no direct function to achieve this. However, it can be done through a procedure. In C1 ... | |
| excell vba macro to count consecutive blank cell | 1/25/2009 |
| Q: PLEASE FIRST TRY TO UNDERSTAND WHAT I AM LOOKING FOR. YOU HELP WILL BE GREATLY APPRECIATED. I need ... A: It is difficult to correct someone else's Macro. But if you do not mind, try using this one that I ... | |
| COMBINATIONS | 1/24/2009 |
| Q: VERY IMPRESSED WITH YOUR WORK CAN YOU PLEASE HELP ME WITH THE FOLLOWING CAN NOT FIND ANY ANSWER IN ... A: With my limited abilities of Excel, I think that this is not possible with excel functions and you ... | |
| Importing an existing Spreadsheet Macro to a new spreadsheet | 1/22/2009 |
| Q: I have two different Excel files that I have created and I want to merge the two. How can I import ... A: I have never really come across this... But my trials show one way. If it suits your requirement you ... | |
| Finding next avaliable row | 1/21/2009 |
| Q: I am very new to VBA and hardly worked on it... With the knowledge i have i have recorded a macrtp ... A: If you are sure that all your cells in Column A are non-Blank, then you can use something like- ... | |
| Formula | 1/20/2009 |
| Q: I really hope that you can help me with this: i am trying to keep up with the current volume. the ... A: A, I do not know the compulsions of maintaining the data in this manner. Is it not possible to ... | |
| Breking down lengths into stock lengths. | 1/20/2009 |
| Q: I have a spreadsheet that takes data from an AutoCad drawing and converts them into feet and inches ... A: As you would appreciate, Computer is a HIGH SPEED IDIOT. It can do exactly as you tell it to do. So ... | |
| Formula | 1/19/2009 |
| Q: How to split principal porting and interest portion from an EMI instalment? For example, by using ... A: Follow these steps- B2 = Original Loan Amount (In Rs.) B3 - Loan Rate (As 13%) B4 = Tenor in Months ... | |
| Excel Formula | 1/17/2009 |
| Q: I have an array of words say {cms, pda, visit, clinical, intake}. Now I have an excel sheet which ... A: STEP 1: Store your reference array in L1:L12 STEP 2: Have all your values (for checking in Column ... | |
| NEED HELP ASAP!!!! | 1/12/2009 |
| Q: i have a list of names and numbers all in a notepad document all the names and numbers gone one ... A: STEP 1 - Get the Note pad data in Excel Method 1 Start Excel File-Open (Ctrl-O) Browse for note pad ... | |
| selecting almost duplicate records | 1/12/2009 |
| Q: I have duplicate names and perhaps ages within a record set (e.g. name, age, score) but the scores ... A: Actually, I need more details of your worksheet. But I will try to visualize and answer- Column A - ... | |
| auto average in macro | 1/9/2009 |
| Q: I am wrting a macro and am wondering if it is possible to write an auto-average into the script ... A: Presuming you do not have any blank cells within the first cell and last cell, you may use i = ... | |
| restrictions in excel sheet for different user | 1/8/2009 |
| Q: Would it be possible to put a restriction to each sheet of 1 Excel file? I will be making a phone ... A: The way I think this can be done is by protecting Sheet1 ans Sheet2 with different passwords. FOR ... | |
| Calculate Elapsed Days | 1/8/2009 |
| Q: I am trying to calculate elapsed day between two dates only when there is a closed date in Column C. ... A: I presume you know the formula you want to use to get answer in C3. If I call it a formula, then in ... | |
| Comparing lists. | 11/19/2008 |
| Q: I've got two fairly long lists, one containing client information, one containing transaction ... A: (1) There is function called MATCH in excel but I think it will not serve your purpose. You can ... | |
| Excel Formula | 11/18/2008 |
| Q: Have been trying to come up with a formala that will return a list of contracts that are not renewed ... A: Sarah, I cannot think of a formula that can achieve this. I can attempt to write a MACRO if it is ok ... | |
| MS Excel help | 11/15/2008 |
| Q: How do I sort successive 30 numbers in a column and put them in separate new column. Like I have a ... A: Part Second: If you enter formula =AVERAGE(INDIRECT("A"&(ROW()-1)*30+1):INDIRECT("A"&(ROW()*30))) in ... | |
| Exccel | 11/15/2008 |
| Q: How to protect a column in Excell; Appreciate your help. BR A: Some background- (1) Protection of any range (including a column) comes in to play only when a ... | |
| forumlas of ecels | 11/13/2008 |
| Q: can u give me or learn me formulas of excels in business and have acounts in excels tell me regards A: for learning various topics of MS Excel please visit- http://www.functionx.com/ - Site for self ... | |
| Excel - Conditional Formatting - Dates | 11/13/2008 |
| Q: Can you help me with dates in conditional formatting? I have a column of dates (G) in a ... A: Select Cell G1 Format - Conditional Formatting First Window - Formula Is Second Window - ... | |
| excel Help | 11/12/2008 |
| Q: I would like to know how you make excel show a picture / image if a condition has been met. E.g if ... A: For Excel 2007.... Instead of - Insert -> Name -> Define Do - Formulas - Name Manager - New You will ... | |
| excel Help | 11/11/2008 |
| Q: I would like to know how you make excel show a picture / image if a condition has been met. E.g if ... A: First, you'll need to have one cell that will use an If-statement to display the word related to ... | |
| preventing a cell from changing | 11/10/2008 |
| Q: I have one sheet in a workbook that is linked to another, the first sheet contains raw data and the ... A: This is a standard feature of Excel and I doubt whether you can prevent this happening. But I can ... | |
| merge from excel to excel | 11/8/2008 |
| Q: Can I merge from an excel document to another excel doc? I need instruction as to how this works as ... A: Daniel, If you want to use a DRAFT of letter with some fields with values for fields coming from ... | |
| merge from excel to excel | 11/7/2008 |
| Q: Can I merge from an excel document to another excel doc? I need instruction as to how this works as ... A: Can you please elaborate on what you mean by merging? Are columns in two excel files identical and ... | |
| Calculate age | 11/5/2008 |
| Q: Please help me to calculate age of ppl in years, months and days using their Date of birth. A: We can use the formula below to return the age of any person in years, months and days. It makes use ... | |
| VBA Code Replace Command | 11/1/2008 |
| Q: I am looking how to write VBA code for a macro in excel that would look to cell "I4" and take the ... A: I have not fully understood your requirement.. Check if I am right.. In Cell I4, you will have some ... | |
| autopopulate cells to the left if cell has value | 10/30/2008 |
| Q: I have an excel spread sheet. If I enter a value of 1 into cell H12 I want all the cells to the ... A: Bonni, I do understand why you need more than 7 IF functions. May be your question is not clear to ... | |
| adding percentage to a figure | 10/29/2008 |
| Q: i have got a quite big excel data base that needs updating. i know it is possible to add or subtract ... A: The simple answer is YES. How, please build your logic carefully and use IF statements along with ... | |
| Excel Macro for selecting a range of text | 10/26/2008 |
| Q: I'm creating an Excel macro which graphs the attributes of a collection of projects. All the ... A: METHOD 1: Emulating - (1) Select cell A2 (2) Ctrl-Alt-Right Arrow Range("A2").Select ... | |
| counting cells | 10/21/2008 |
| Q: I have a spreadsheet in Excel, with actual / forecasted spends for every month in columns (from ... A: Mohsin, 1. I have understood the requirements correctly and hence, the formula applies. 2. YES, you ... | |
| counting cells | 10/20/2008 |
| Q: I have a spreadsheet in Excel, with actual / forecasted spends for every month in columns (from ... A: Assumptions: Row 1 has Months in A2 to A14. Months have been entered in Date Format. Column A has ... | |
| How to loop Rows in Macro? | 10/20/2008 |
| Q: I need to write Macro for AutoFilter. But I do not know how do write macro for this type of ... A: Unfortunately, I am not a trained programmer and I have learnt all my Excel VB Macro through Trail & ... | |
| Data entering with Table | 10/17/2008 |
| Q: i made a table for entering data to excel sheet.in this i want add one code for adding number ... A: I am still not sure what you are looking for but I spell out my understanding and solution below. ... | |
| excel- cross sheet validation | 10/17/2008 |
| Q: can you tell me if we can put a list validation between 2 sheets. meaning if the list is in one ... A: Direct answer is NO. But you can have a workaround for this. Please Follow these steps- -- In ... | |
| conditional formats | 10/16/2008 |
| Q: I have a formula in a cell as follows =IF(L31>0,REPT("g",(L31/10)),"") This simply counts and ... A: 1. It is not clear to me which cell you are trying to apply conditional formatting. 2. I presume, ... | |
| copy a formula using multiple worksheets | 10/15/2008 |
| Q: How do I copy a formula and paste into numerous rows on my summary sheet using the following ... A: I have not completely understood your requirement. But try the following- 1. Click on the sheet tab ... | |
| proper function in excel | 10/15/2008 |
| Q: I have a data column which has uppercase data in few of the rows. I want to use the 'proper' ... A: I do not think any function will convert whole of column. I suggest- (Assumption- text data in in ... | |
| VBA copying multiple worksheet and naming them from a list | 10/15/2008 |
| Q: I am trying to create a macro that will copy worksheets, as many times as there are names on a list, ... A: Assumptions: You have entered the names in Sheet1 Column A Sub Macro1() m = ... | |
| Selecting Non contiguous Range | 10/14/2008 |
| Q: I run a macro that selects a range of data. my dataset has changed and currently i am trying to run ... A: Le me explain your code as if you are doing these steps in Excel manually- (1) Range("A11").Select - ... | |
| Excel Macro for inserting a row | 10/14/2008 |
| Q: Ok here is my issue. I know that when creating macros every detail is very important. I am trying to ... A: I have modified your MACRO as- Sub Macro2() ' ' Macro2 Macro ' With ActiveWorkbook.ActiveSheet ... | |
| excel macro | 10/13/2008 |
| Q: how do i make this macro work through the entire worksheet? Sub cylinder() ' ' cylinder Macro ' ... A: David, why it is not working is because my assumption No.1 (There are no BLANK cells in ColumnA) is ... | |
| excel macro | 10/13/2008 |
| Q: how do i make this macro work through the entire worksheet? Sub cylinder() ' ' cylinder Macro ' ... A: Presumptions: 1. There are no BLANK cells in ColumnA 2. You are looking for Cell=Cylinder and cells ... | |
| excel macro | 10/13/2008 |
| Q: how do i make this macro work through the entire worksheet? Sub cylinder() ' ' cylinder Macro ' ... A: Often recording a MACRO is not enough as the recording will be for specific range. You need to ... | |
| Import data from notepad | 10/12/2008 |
| Q: I have data that is more than 65k in notepad.Now i want to Export this data in excel, But when i ... A: (1) Best solution would be to use Excel 2007 which does not pose limitation of 65536 rows. (2) I had ... | |
| Ask About Excel | 10/10/2008 |
| Q: I want to know if can help me, how placing the option of spelling of the cells, that is to say, ... A: Please visit following URL. ... | |
| transpose | 10/9/2008 |
| Q: Is there any way to transpose vertical to horizontal data without pasting? Thanks a million ANSWER: ... A: I think the question is not clear to me.... If Sheet name is Order Details (Original Data) Replace ... | |
| transpose | 10/8/2008 |
| Q: Is there any way to transpose vertical to horizontal data without pasting? Thanks a million A: The simple answer is it is possible. How? It depends on range you need to transpose. I am giving ... | |
| excel help | 10/8/2008 |
| Q: i have Cell A1,A2, AND Cell D1,E2, VALUE OF THE A1 CELL IS 0 AND VALUE OF THE A2 CELL IS 1 IN D1 I ... A: Irfan, Firstly, I do not understand how your getting 5 when A1 is 0 and D1 is =A1+4. Anyway, If ... | |
| Split one cell content into 3 cells in excel using Macros | 6/30/2008 |
| Q: Hope you are doing good. I need your help regarding macros. Here my scenario is: I have a cell ... A: Usually text in one cell is aplit into three (or less or more) cells by TEXT TO COLUMNS for which ... | |
| EXCEL VB | 6/30/2008 |
| Q: We are sorry, but Edward H. Mori wasn't able to answer yourhello sir ... how r u ,,,,, glad that i ... A: I am not sure if I have understodd your requirement properly. This is what I understand... You have ... | |
| Excel reference | 6/24/2008 |
| Q: How do I take the last cell updated in a column and plot it in a single cell For example: Column B ... A: Dave, BLANKS at the end of column should not matter. I did not understand "A1 Returns 21". Do you ... | |
| Cells | 6/22/2008 |
| Q: Sir How r u Thanks For the previous solution Sir, my another question is I have E-mails ID in A1 ... A: I can definitely give you a QUICK solution but please give these clarifications- 1. Is there a ... | |
| text | 6/20/2008 |
| Q: sir Sir,is it possible if A1= 20/6/2008 then B1=Friday, C1= June Any formuls Thanks in Advance ... A: QUESTION-1 If you use =WEEKDAY(A1,2)in B1 you can get 5 i.e. 5th day of the week starting Monday. ... | |
| Formula not working | 6/19/2008 |
| Q: I am using =IF(Z80=$A$1,$B$3,AA80) formula and day by day I collect data in these cells but some ... A: I think the problem is that in H3 you are entering a formula that uses H3 (Circular reference). When ... | |
| applying formula default to all worksheets | 6/18/2008 |
| Q: I WANT TO APPLY THE FORMULA, HEADING AND LOGO OF ONE WORKSHEET TO ALL OTHER WORKSHEETS.I WANT TO ... A: QUESTION 1 I am not fully aware of Excel 2007 but I am answering from my experience of Excel 2003. ... | |
| Excel Macro copy/paste | 6/17/2008 |
| Q: I'm trying to write a small macro. I want it to copy from two cells within my worksheet, which will ... A: I am sure this MACROP was recorded and it was recorded with RELATIVE addresses ACTIVE. Any way, let ... | |
| help with excell data | 6/17/2008 |
| Q: I have a rather lengthy spreadsheet (37k+ rows) with name & address data in one column that I need ... A: First the good news. You can achive this by a Macro and I can write one for you. Now, the reality. ... | |
| Excel - Allowing | 6/16/2008 |
| Q: I want to have one of the cells only accept "0" or multiples of "13" -- Basically, 0 or 13 or 26 or ... A: Yes... We are using alidation only. But a CUSTOM validation rather than STANDARD validations ... | |
| Excel - Allowing "0" or multiples of a certain number in a cell only | 6/15/2008 |
| Q: I want to have one of the cells only accept "0" or multiples of "13" -- Basically, 0 or 13 or 26 or ... A: You reached a right place but probably could not utilize it properly. Please go to ... | |
| Auto populate date in a calendar for a given start date | 6/13/2008 |
| Q: I'd like to enter a start date in C2, then have three rows of 7-day weeks auto populate with the ... A: I do not know, if I understand you fully. But if B2 = "Sunday", B3 = "Monday and C2 = 6/15/2008"then ... | |
| conditional formatting | 6/12/2008 |
| Q: I have conditionally formatted a cell and have managed to copy this down the column. I am using 2 ... A: Amanda, The references & formulae in excel are by default relative. Meaning, if a formula (or a ... | |
| Transposing a list with a blank line dividing contacts | 6/11/2008 |
| Q: I have a list of addresses with a blank line dividing one contact from the next. I have included ... A: try out the following macro- (Two consecutive blank lnes will terminate the macro) Sub transpos() i ... | |
| Transposing a list with a blank line dividing contacts | 6/10/2008 |
| Q: I have a list of addresses with a blank line dividing one contact from the next. I have included ... A: If - A1 - AAG - Club Empleados A2 - Av. Corrientes 538 piso 11 A3- (1043) Capital Federal A4 - ... | |
| Forumula, I think | 6/9/2008 |
| Q: I have little experience with Excel (using 2000) and I need to perform what I think should be a ... A: Please follow folowing steps- -- Enter 1 in Cell A1 -- Select Cell A1 -- You will find a small ... | |
| Conditional Formula | 6/9/2008 |
| Q: I would like to know if there is a formula that can disregard negative numbers when summing up the ... A: I do not think there is a way to add (SUM) the numbers with such criteria. However, I can suggest ... | |
| calculating time worked in excell | 6/6/2008 |
| Q: what is the formulea for calculating time worked in excel using military time? column 1 time in, ... A: Salam Aalekum. Unfortunately, I do not understand Military Time. If you can give some example and ... | |
| Row\Column width | 6/4/2008 |
| Q: 1 .Can u plz provide me a code for fixing column width in a macro ? ANSWER: I can always ... A: If you have 3 sheets, you can use following code. Replace 3 with suitable number. Sub try() For n = ... | |
| Calculating Hours: Minutes | 6/3/2008 |
| Q: How does one calculate the actual time where it will where it will continue to calculate the number ... A: Karen, In cell A1 enter - 6/2/2008 10:15:00 In Cell A2 enetr - 6/3/2008 12:00:00 In cell A3 enter - ... | |
| Row\Column width | 6/3/2008 |
| Q: 1 .Can u plz provide me a code for fixing column width in a macro ? A: I can always provide you with the code lilnes but then why don't you try and record a macro. The ... | |
| make cell address a value | 6/3/2008 |
| Q: I would like to make cell locations (A1, A2, etc.) show up as values ("A1", "A2") in the adjacent ... A: I will reply your answer in steps- STEP 1 - TO SHOW A COLUMN NUMBER =COLUMN(D5) will show column ... | |
| Calculating Hours: Minutes | 6/2/2008 |
| Q: How does one calculate the actual time where it will where it will continue to calculate the number ... A: Since you know how to calculate it, I will stick to the method to SHOW your answer in HH:mm:ss ... | |
| Macro help | 4/22/2008 |
| Q: i am having a problem in excel. I made a macro that tell to hide some rows like: Sub ATI8() If ... A: Yes.... Macro can run when a cell is changed. Follow following procedure... -- RIGHT click the Sheet ... | |
| dates | 4/22/2008 |
| Q: i am looking to find the last date of service for a client. the data dump has a cloumn of clients ... A: Joe, Based on presumption that we have Sheet1 with running data - ColumnA has Client Names and ... | |
| dates | 4/22/2008 |
| Q: i am looking to find the last date of service for a client. the data dump has a cloumn of clients ... A: Joe, Unfortunately, as per my knowledge, VLOOKUP and MAX will not work together. I will trying to ... | |
| Macro help needed | 4/22/2008 |
| Q: I have a lot of data to be formatted in Excel and I'm new to excel macros. What I want to do is: 1> ... A: Recording a Macro is not a complete solution for approaching Macros. One should be able to modify ... | |
| dates | 4/21/2008 |
| Q: i am looking to find the last date of service for a client. the data dump has a cloumn of clients ... A: Joe, I cannot understand your requirement. But from what I understand, =MAX(A1:A29) - Where A1:A29 ... | |
| Excel project | 4/19/2008 |
| Q: 1. We are working on a new Hewlett Packard xw4400 Workstation with 4 Gigs of RAM, 300 Gigs of hard ... A: Sorry to disppoint you but this is not quite my area of expertise. However, I have experienced ... | |
| Excel | 4/17/2008 |
| Q: What formula would you use if you had a first and last name in a single cell and you wanted to ... A: Let us say you have a First Name & Last Name (seperated by Space) in A1. Then Formula in B1 will ... | |
| Excel IF function (multiple IF functions) | 4/15/2008 |
| Q: I'm not quite sure how to create a multiple IF function ! What I have is basically a chart with ... A: Adriana, Here are some rules before you start- (1) You can use maximum of 5 IF fucntion inside each ... | |
| calculating more work time more pay "IF" | 4/14/2008 |
| Q: I would like to produce a spreadsheet that calculates the more you will work the more you will get ... A: I think your logic is perfect but there is a small problem in understanding of the way Excel works. ... | |
| How to count number of blank spaces between numbers | 4/11/2008 |
| Q: . I have data in 3 rows (They so happen to be all the same number). I'm trying to come up with a ... A: I am not able to corealte your query with data and count you indicate below your query. Do you mean ... | |
| lookup 2 conditions | 4/11/2008 |
| Q: Please help me with this condition where i have to lookup 2 conditions to get the result. ... A: I cannot say that it is 100% clear but I will answer the question with few assumptions- (1) Users' ... | |
| Excel Query | 4/7/2008 |
| Q: How can i use the following formula: =Sumif($A$1:$A$70,"Mar'08",AD$1:AD$70) using data from a ... A: Firstly let me let you know that the question is too brief to understand the full requirement. You ... | |
| covert number to text | 4/5/2008 |
| Q: I was looking for a way to convert a number to a text in the same cell. example, if I enter 1 in a1 ... A: There is no EASY WAY. this will need to be addressed by a Macro. Also, the Macro itself will be a ... | |
| compare cells in one row | 4/4/2008 |
| Q: I have 2 sheets in one worksheet that i need to compare their rows. Each column has one ID column in ... A: I presume, there are MANY rows and they are not in same order as far as ID column is concerned. ... | |
| reference from lists | 4/3/2008 |
| Q: Simple question, I have 2 worksheets A and B. A has a list, I want this list to copy in B. BUT I ... A: Imagine you have a list in Sheet1 at A1:A10. Now you want to have this list in Sheet2 at A1:A10. But ... | |
| HELP! | 4/3/2008 |
| Q: I am trying to create a Holiday Planner with excel, and have to split the info onto 2 worksheets, ... A: I will need to presume a few things here. Name of the first sheet (for Apr-Sept) is SHEET1. Name of ... | |
| Writing a script for a command button | 11/8/2007 |
| Q: I know that there is a way to set up a command button that will delete or clear specific contents of ... A: Insert the command button. Right Click -- Assign Macro You will see something like ... | |
| Target setting | 11/7/2007 |
| Q: I have been given a task of setting the targets basing on the historical data.How can set the ... A: You need to provide me sample data / format to work on. Percent increase can be simple - ... | |
| #VALUE! & #N/A | 11/5/2007 |
| Q: Regarding the cell outputs of #VALUE! & #N/A, I am trying to create a statement to say, for example ... A: Excel does not treat "#VALUE" as such though it displays so. What you need to do is tackle the root ... | |
| vlookup commission plans | 11/2/2007 |
| Q: I am trying to develop an Excel sales commission plan program for a real estate sales purpose. I ... A: Firstly my feel is VLOOKUP will not be correct one to be used. We may need to use nested IF ... | |
| Excel Formula | 11/2/2007 |
| Q: My Spreadsheet is as follows Column A - Date = eg 1/1/1900 Column B = Public or Private Column F = ... A: You need to explain the required logic in detail. My Logic- (1) If Private then Private else (2.1) ... | |
| vlookups | 10/31/2007 |
| Q: I'll try to explain what i want to do. I want to compare two tables using vlookup that when a value ... A: To begin with, let me understand the exact requirement. "comparing tables" will not make much sense ... | |
| Excel Formula | 10/31/2007 |
| Q: My Spreadsheet is as follows Column A - Date = eg 1/1/1900 Column B = Public or Private Column F = ... A: You are already doing much of the task. All you need to know is current date is stated as Today(. ... | |
| Excel Formulaes | 10/26/2007 |
| Q: There are the following data on each row(Name, Bill Number, PO#, QTY, Rate, Amount) in sheet1. I ... A: I had answered very similar question on 22-07-2007 for Srivastava. Please go through the interaction ... | |
| number should get convert to alphabets | 10/26/2007 |
| Q: The input i key in the excel is number(ex:1,2,3) and this should change into words(for ex: one,two, ... A: Excel does not have any functionality for this. However, on net you will find number of programs ... | |
| VLOOKUP with 2 conditions | 10/24/2007 |
| Q: I am not sure how to perform a vlookup with 2 conditions. Sheet 1: A B C ... A: Unfortunately, EXCEL does not permit VLOOKUP on 2 columns directely. You have 3 options- (1) Wrting ... | |
| Emergency MS Excel VBA Programming | 10/23/2007 |
| Q: I have a spreadsheet that is used to track documents and I want to create a call sheet. For ... A: Jeanna, It is difficult to correct a code but I can give you a new one that will perform following- ... | |
| Since Hit | 10/22/2007 |
| Q: I have a set of lotto draws: 14 16 21 31 42 46 36 5 10 18 30 32 47 40 1 4 7 29 31 49 30 ... A: I do not know whether any function can do the job. However, I tried a small MACRO with following ... | |
| EXCEL | 10/18/2007 |
| Q: in a cell string value (10pcs) and numeric value (0.69) in another cell and multiply together is it ... A: Yes I understand Anuj. But what you can do if it always pcs is that use formula- ... | |
| create a formula | 10/17/2007 |
| Q: i need to find a formul that will find cells with a certian value in them ,but only part of the ... A: I am sure you can have a better answer.... But my trials with combination of COUNT or COUNTIF with ... | |
| Excel formula / vb script needed | 10/16/2007 |
| Q: Ok, i have two columns in one workbook. A column for Completed/Uncompleted and a Date Sent column. ... A: I have not understood the question.... (1) You have two columns (2) Column 1 has entries as either ... | |
| Sumif & Array Sumif | 10/15/2007 |
| Q: I would like to ask you 2 questions: 1) Which is the function used for sumif funtion with multiple ... A: (1) There is no SUMIF for multiple criteria. If you really need one you have two options - (a) Use ... | |
| vLookup Vba problem | 10/14/2007 |
| Q: I have this formula in cell W2 "=Q2-VLOOKUP(M2;C:H;5;FALSE)" in cell W3 ... A: It is very clear that you know VBA programming. So I will be brief in my answer.. Probably you can ... | |
| Excel: link cell data to sheet name | 10/10/2007 |
| Q: I have workbook with 8 sheets. Sheet 1 i called "Week summary", sheet 2 is "Monday", ... Sheet 8 is ... A: Tina, You need to provide me with a complete picture. Are you intereseted in doing this only in one ... | |
| Find a row with Macros | 10/8/2007 |
| Q: I have an Excel spreadsheet with a small database of clients. The idea of the application is to ... A: Not everytning can be done my RECORDING of a macro. You may need to modify the recorded macro ... | |
| Vlookup Function | 10/8/2007 |
| Q: I'm new to the Vlookup function so I'm not sure if I can use it for my current task. I have two ... A: Firstly, the assurance.. VLOOKUP will work. Secondly, the caution... It will not work directly. :-) ... | |
| Need vba code | 10/7/2007 |
| Q: I would like code that will delete all extra rows below that last populated cell in row B. For ... A: Writing a code for this is very easy and it will be a 4 line code. But I personally feel, it is too ... | |
| deleting empty cells in btw data | 10/7/2007 |
| Q: i'm working on some stock market data and wish to delete the empty cells in btwn data so i could ... A: Ibrahim, you could do one of the following things- (1) Sort the data so that blank rows come at the ... | |
| Excel Count formula | 10/6/2007 |
| Q: I have the following number sets. I want to count the number of occurrences between every 1 number ... A: Unfortunately, AND function will not work (as per my trials) with COUNTIF. My suggstion is- In ... | |
| making two different cells keep adding up to 100 | 10/4/2007 |
| Q: I have two colomns of 9 numbers. The Left hand colomn is set to 100 and the right hand one set to ... A: What you are trying to achieve is ability to have formula & value in same cell. This will not be ... | |
| Fill cells Colour on basis of cell figure | 10/4/2007 |
| Q: I am currently producing a spreadsheet which pulls in a figures which is the difference between two ... A: Irrespective of amount of numbers on the spreadsheet, Conditional formatting should work. I am ... | |
| macros | 10/3/2007 |
| Q: ActiveSheet.Shapes.AddTextbox ... A: (1) The correct sysntax is - myDocument.Shapes.AddTextbox(msoTextOrientationHorizontal, 100, 100, ... | |
| vb code for input in Excel | 9/30/2007 |
| Q: I am trying to get a very simple data entry macro to work without a great deal of success. I want ... A: I think you have gone by the route of recording MACRO. Generally, I go by the way of writing it. ... | |
| Verifying Names in multiple worksheets | 9/26/2007 |
| Q: Ok here is what I am trying to do. I have two worksheets of over 4000 names. column A is the last ... A: I will take up your second problem first. Since you have many smiths, what you can probably do is ... | |
| sorting data | 9/20/2007 |
| Q: I am looking for a way to sort data in a order other than ascending, alphabetical or numerical. ... A: Yes this would be possible by a MACRO. However, I need to know the criteria for sorting. In the ... | |
| XCEL : can I replace text w/ a new column? | 9/20/2007 |
| Q: Greetings, I have an XCEL spreadsheet with a list of names and titles, formatted like this: Ronald ... A: Let me reframe your question.... You have data like "Ronald Anderson - vice president" in Column A ... | |
| SPREADSHEET PROTECTION | 9/19/2007 |
| Q: Does anyone know if you can protect an Excel Spreadsheet so that you cannot copy a cell from that ... A: I presume you need to protect only certain cells. (1) Select entire sheet. (2) ... | |
| EXCEL | 9/18/2007 |
| Q: in a cell string value (10pcs) and numeric value (0.69) in another cell and multiply together is it ... A: I will show you how to extract the numeric values. However, for me to guide you, I need to know the ... | |
| VLOOKUP in Multiple Rows | 9/17/2007 |
| Q: I have an Excel worksheet with roughly 39,000 rows and 20 columns. Here is a quick (and truncated) ... A: Unfortunately that is how VLOOKUP will work. As I understand, you want ALL possible actions to be ... | |
| EXCEL | 9/15/2007 |
| Q: in a cell string value (10pcs) and numeric value (0.69) in another cell and multiply together is it ... A: It is possble under some circumstances. Will it always be "pcs" or will keep changing? If keeps ... | |
| Duplcation of data | 9/12/2007 |
| Q: I have workbook that contain few work sheets, one of these work sheets called TOTAL. I set up a ... A: Mohamad, You need to look at it like this- * What if data is changed after it copied to TOTAL? * So ... | |
| deleting unwanted rows/entries | 9/11/2007 |
| Q: I will like to create a macro that will delete an entire row if a key word is not matched to on a ... A: Please provide following information to proceed- Will you be maintaining list of 18 WS's you are ... | |
| creating dyanamic column | 9/11/2007 |
| Q: Drug Initial Dosage Format CONC Consumption NVP 200 tabs NVP200tabs NVP 200 caps NVP200caps ... A: My trials so far indicate this may not be possible through formulae. I have presumed that you will ... | |
| Excel Formulas | 9/11/2007 |
| Q: I have a general question for you. I wanted to know if there is a way to actually MEMORIZE how to ... A: There is no general method available for these things. However, by practice, you will master the ... | |
| Assign Macro To a Button | 9/5/2007 |
| Q: I added a button to my spreadsheet. Now, I would like to add a macro to it that (when button is ... A: Can you lpease tell me what is the final purpose of this MACRO? Is it to open some file? Try this ... | |
| Macro to setup multiple tabs within single workbook | 9/4/2007 |
| Q: I would like to see VBA code (Excel 2003) that would create mutliple tabs based on this criteria: ... A: Chris, I need to have some more details. (1) Do you mean data on Sheet 2 will keep changing? (2) I ... | |
| Looping | 9/3/2007 |
| Q: I am not able to write script on VB to create VB function. I want excel add one to two cells till ... A: I am going to make certain assumptions here- (1)You canmodify the VB code as required. (2) Cell A2 = ... | |
| Looping | 8/31/2007 |
| Q: I am not able to write script on VB to create VB function. I want excel add one to two cells till ... A: This should be fairly simple... But I see one difficulty. Obviously, some combinations will bring ... | |
| Compare two text values and add a value in third column | 8/29/2007 |
| Q: I really need your help in this mind twister! I have three columns A,B & C. Both A & B can have ... A: I suggest following method (to avoid MACRO) 1. Add a column C 2. Add a formula =A2&B2 in C2 and copy ... | |
| Macro | 8/21/2007 |
| Q: I have a data of a instrument exported in form of Notepad txt file. So exported data files in the ... A: Recording alone will not help. You will need to write a macro. For instance, you may write for i = ... | |
| Excel : Macro code to change column insertion point each week | 8/20/2007 |
| Q: I have a simple worksheet that has a list of product skus in column A. From Column B on, there is ... A: Logic would be - 1. Identify current week by system date. (For example you store first Sunday of the ... | |
| COMPLICATED FORMULA FOR EXCEL | 8/19/2007 |
| Q: EXCEL: I’ve searched everywhere to figure this out and would greatly appreciate it if this could be ... A: Charles, I may not have understood the problem. But if you are referring to formula - ='MONTH TO ... | |
| Rotate data in cells by row follow on | 8/18/2007 |
| Q: Sorry but need to ask a few more. How can I specify specific cell range. I tried to alter to ... A: Mark, you may use modified code- Private Sub tgs() myLast = Cells(56, 2) For i = 0 To 54 Cells(56 ... | |
| Rotate data in cells by row | 8/17/2007 |
| Q: I am trying to create either VBA code via a command button that when pressed will rotate data in a ... A: I am giving the code that can be used below- Sub TGS() 'count the number of rows to be rotated ... | |
| Cell Names as Cell Contents | 8/17/2007 |
| Q: I have a workbook with hundreds of Cells that already have defined Cell Names. I want to know if ... A: I am giving you two solutions, 1. Quick way of getting all Names alongwith cells is a single line ... | |
| excel cell content comparison | 8/16/2007 |
| Q: The coding is to be done in VBSCRIPT OR VB . I have an excel work book and the work book contains 3 ... A: Part I Addition of sheets in the required order- POssible through MACRO. Sheets("Sheet1").Select ... | |
| application of excel in work | 8/16/2007 |
| Q: Sir, Good day. iwant to ask how this macros and VBA is applicable in excel worksheet. i can notice ... A: WHEN TO USE MACROS- My experience show that MACROs may be used for one or more of the following ... | |
| figurs in words | 7/31/2007 |
| Q: i am preparing the salary slip in excel i want the net amount payable to be written in the form of ... A: Mandar, There is no easy way for this. Option 1 Right a complex function yourself. Option 2 You ... | |
| Excel Formula | 7/30/2007 |
| Q: I want to find out the differences in 2 spreadsheets that need to match 2 keys ..both spreadsheets ... A: My suggestion was, in D2 have formula = A2 & " " & B2 & " " & C2 Now, D2 will read - 123456 1234 50 ... | |
| Excel Formula | 7/28/2007 |
| Q: I want to find out the differences in 2 spreadsheets that need to match 2 keys ..both spreadsheets ... A: I do not fully understand what you mean by DIFFERENCE? If it is just which entries are present in ... | |
| Excel | 7/27/2007 |
| Q: Hmm.. I got 2 workbook called book1 and book2 Book1 is design to be form in the spreadsheet for ... A: Steve, What you need to do through your macro, is remove protection of Book 2, update data and again ... | |
| Excel | 7/26/2007 |
| Q: Hmm.. I got 2 workbook called book1 and book2 Book1 is design to be form in the spreadsheet for ... A: YES. This is very much possible. However, what will happen is Book2 will open in background (not ... | |
| assigning a value to a memory variable | 7/20/2007 |
| Q: I am try to assign the cell location to a variable. Dim myx myx = ActiveCell.FormulaR1C1 = ... A: If you want to pass Row Number to a variable you may use a Simple line- myX=Activecell.Row may be ... | |
| EXCEL DATE-FORMAT HELL | 7/19/2007 |
| Q: I work in a Healthcare industry company where I receive spreadsheets in the email from the carriers, ... A: OK... Here are ways to tackle rest of the problems. (1) This is not exactly EXCEL setting. Go to ... | |
| EXCEL DATE-FORMAT HELL | 7/19/2007 |
| Q: I work in a Healthcare industry company where I receive spreadsheets in the email from the carriers, ... A: Presuming you need to extract April 24, 2007 (in D1) from 06070424 (in C1) - (1)Select the column ... | |
| Copy Relative Reference | 7/19/2007 |
| Q: I wonder if you can help me on this... I need to reference some data from a spreadsheet1 which is ... A: I am going to use your data to illustate. In Sheet1 A1 - Mary A2 - Peter A3 - James A4 - Tom Let us ... | |
| entering data using a command button | 7/17/2007 |
| Q: I'm trying to write some code in a control command button that when clicked brings up a box that ... A: Use the following line in your command code with suitable replacements for TITLE (Enter Value for ... | |
| isolating values | 7/15/2007 |
| Q: I am trying to find a formula for Excel that will isolate the final 20 values entered in a ... A: By using additional columns, you may be able to resolve part of the problem. (1) Column A holds your ... | |
| Rounding value | 7/14/2007 |
| Q: i want to round the value. the cell in which my custom formula how can insert round function in ... A: =ROUND(B11*16/100,n) for rounding =ROUNDUP(B11*16/100,n)for rounding always up ... | |
| Excel | 7/13/2007 |
| Q: Here goes: I have a complete list of names and associated IDs in one database (Database A) and a ... A: Imagine you have data in Columns A & B of Sheet1. NAME VALUE Joe aa Ted bb ... | |
| Formula Question | 7/12/2007 |
| Q: I have a formula that counts visible cells when filtered. The formulas is =SUBTOTAL(2,EA8:EA493). ... A: To my knowledge, SUBTOTAL function will not support IF as additional argument. One suggestion could ... | |
| i want to restrict to some value in cell of the excel. | 7/12/2007 |
| Q: i want to restrict to some value in cell of the excel. I need to check that in lost focus of the ... A: (1) Select the cells you want to add restriction to. (2) DATA -- VALIDATION (3) For your example, ... | |
| command button to sort | 7/11/2007 |
| Q: How do I create a command button to sort a database by a particular column? A: You will need to create a MACRO and assign it to a command button. MACRO can be written or recorded. ... | |
| using counif and if together | 7/11/2007 |
| Q: there is a column where i have entered experience of 30 employees..some have no experience and some ... A: My advise would be to introduce one column with a formula- ... | |
| Excel: random question generator | 7/10/2007 |
| Q: Sakhalkar, I have a .doc file with roughly 500 questions. I would like an excel spreadsheet that ... A: Thomas, I have a Excel file with following specs. (1) It holds about 2000 questions (This number can ... | |
| Change font colour in output of the IF command | 7/7/2007 |
| Q: I have a table of marks and using the IF command I transform them into grades. For example ... A: I think I may not have understood the question properly. I presume you need to blankout data ... | |
| VLOOKUP with multiple lists | 7/6/2007 |
| Q: I am building a database for a non-profit education center. I am attempting to use the VLOOKUP ... A: I still feel - based on the information given by you, that VLOOKUP with IF should work. Please ... | |
| copy a excel sheet | 6/29/2007 |
| Q: I want a button on a excel sheet(book1)that asks for a source excel workbook(book2).After giving ... A: Use following macro instead of earlier one- Sub NewMacro() myWorkbook = ActiveWorkbook.Name On ... | |
| copy a excel sheet | 6/28/2007 |
| Q: I want a button on a excel sheet(book1)that asks for a source excel workbook(book2).After giving ... A: Shiv, Which means, you need to copy ALL data from a sheet to active sheet. Copying a sheet conveys ... | |
| Function Range | 6/28/2007 |
| Q: Is there a way to enter an if statement where the logical_test looks for a range of numbers to ... A: Ben, I hope my understanding is correct. (1) Let us say A1 has a value between 1 to 40. (2) In A2 ... | |
| copy a excel sheet | 6/28/2007 |
| Q: I want a button on a excel sheet(book1)that asks for a source excel workbook(book2).After giving ... A: Tools--Macro--Macros "NewMacro"--Create Paste following macro in the place. Create a button in ... | |
| too many arguments | 6/27/2007 |
| Q: i have a spreadsheet with two types of data for each day of the month, data is in 2 columns each. I ... A: Bonnie, Your problem is not clear to me. I am answering with presumption that you are adding 31 ... | |
| Change font colour in output of the IF command | 6/26/2007 |
| Q: I have a table of marks and using the IF command I transform them into grades. For example ... A: For Macro to appear in Pull Down menu, it needs to be created as Excel Add In. Else you can add a ... | |
| excel vb | 6/26/2007 |
| Q: trying to write a macro to combine the content of cells c1:c30 and put result in b1 seperated by ... A: Try this code- Sub Try() Dim myString As String myString = Cells(1, 3).Text For i = 2 To 30 If ... | |
| About Excel Formate | 6/26/2007 |
| Q: I AM WORKING IN U.A.E. I PREPARE A EXCEL SHEET LIKE H.R DEPARTMENT (VISA EXPIRY)I WANT TO DO THAT IF ... A: Salam Aalekum Muhammad... This is possible by conditional formatting. I am sending a seperate ... | |
| Auto update of cell data with date | 6/25/2007 |
| Q: I am trying to do an automated update of the cell in comparison with last year record with the same ... A: I think the question is nlot clear to me. My presumption-- You want to see D1 = B1/C1 and you have ... | |
| Compare cells and fill color | 6/20/2007 |
| Q: I'm a beginner in writing macro. I have a spreadsheet where in each row shows the production date ... A: I still feel you can do without a MACRO. Date = 15th Sep If it falls in week 39, it will ... | |
| Compare cells and fill color | 6/20/2007 |
| Q: I'm a beginner in writing macro. I have a spreadsheet where in each row shows the production date ... A: With little change in the way you are making this sheet, you can do it without a MACRO. I presume ... | |
| Drop-down Menu for Navigation | 6/19/2007 |
| Q: I would like to create a drop-down menu(not via Cell but an object which I can move arrount) which ... A: It can ceratinly be done by using MACROs. But then MACRO needs a trigger (e.g. clicking an object). ... | |
| Auto update/averaging of cell with date | 6/19/2007 |
| Q: I would like to create a sheet that can auto update the cell and do auto calculation with the date I ... A: Prima facie, It is possible. Please send me a proposed layout, I will fill in the formulae and send ... | |
| Macro to search a column and, upon a positive result, will cut corresponding row to new w/s | 6/15/2007 |
| Q: I trying to generate a macro which will search Column M of several worksheets and, if finding a "Y", ... A: Try the one below. You may need to modify as per the needs... Sub Remove() ... | |
| Change font colour in output of the IF command | 6/14/2007 |
| Q: I have a table of marks and using the IF command I transform them into grades. For example ... A: You can do this by recording a macro and then assigning the macro to a command button or a text box. ... | |
| Conditional formatting | 6/11/2007 |
| Q: I would like the background (pattern) color change according to the value in one cell. It is for ... A: Assumptions: Column A is for entering * Columns B,C,D are the ones to be colored if corresponding A ... | |
| excel | 6/8/2007 |
| Q: i have a question regarding excel I have a spreadsheet that displays the project names is it ... A: My apologies for this disappointing answer. The task is a bit complex, mainly from understanding the ... | |
| excel | 6/7/2007 |
| Q: i have a question regarding excel I have a spreadsheet that displays the project names is it ... A: If the list of projects is maintained in the same sheet, you may use Data-->Validation-->List. ... | |
| Cell Merging | 6/6/2007 |
| Q: I was wondering if you could help me on this question in Excel I need to merge two columns data in ... A: Assumption: Cell A1 --- 1009999; Cell B1 --- 1395.5 Formula in Cell C1 "=CONCATENATE(A1,B1)" OR ... | |
| pivot table | 6/5/2007 |
| Q: I have a question regarding pivot tables I have a pivot table however i understand that i cannot ... A: I think (if I have understood correctly) what you need to do is create a copy of original worksheet ... | |
| macro help (expiration dates) | 6/4/2007 |
| Q: I was wondering if you would be able to answer a few excel questions I have concerning macros and ... A: To answer in short...YES. This is very much possible with a simple MACRO. The macro can be triggered ... | |
| Combinations | 5/31/2007 |
| Q: "Hie Tushar i have data in two colums say A and B. where A are debits and c are credits. at the end ... A: Is there a way to know that two entries in Column A correspond to a entry in column B? ... | |
| Conditional formatting question | 5/30/2007 |
| Q: I wanted to ask you a quick question related to conditional formatting. If I have the following row ... A: 1. Select cell A2 2. From the Format menu, select Conditional Formatting. 3. In Condition 1, select ... | |
| Grafs | 5/30/2007 |
| Q: Ok so I have a question on grafs. How come when I plot my studies I get hundreds of dates on the ... A: If the dates in question are far apart, Excel will fill in uniformly the scale data on the axes. To ... | |
| Excel Formula Question - Probably Simple | 5/29/2007 |
| Q: This may be an easily answered question and I apologize ahead of time for that. I have a worksheet ... A: Assumption: Sheet1 Columns- A(Code), B(Deptt), C(Description), D(Quantity), E(Rate), F(Total Amount ... | |
| pivot table | 5/25/2007 |
| Q: I have a question regarding pivot tables I have a pivot table however i understand that i cannot ... A: I am not sure if I have understood the question properly. You cannot make changes to Pivot Table as ... | |
| Combinations | 5/24/2007 |
| Q: "Hie Tushar i have data in two colums say A and B. where A are debits and c are credits. at the end ... A: Though the question is not fully clear, I am answering on the basis of a statement "a macro that can ... | |
| Insert row | 3/19/2007 |
| Q: pls could you tell me how I insert a row so that a formula in that row is automatically copied into ... A: Try this- 1. Slect the row you need to copy 2. Right Click --> Copy 3. Select the row above which ... | |
| Excel | 3/13/2007 |
| Q: I am trying to find out how to make calculations under certain conditions. For example, lets say ... A: Try to add an extra column with a formula- =WEEKDAY(A2,2)<6 You will notice that all weekdays are ... | |
| Automated range selection in lookup table | 2/26/2007 |
| Q: I have a table of cash forecasts for various product lines. The left most column is the date. ... A: Though it requires a additional column, I suggest following. ASSUMPTION: Range A2:A29 contains dates ... | |
| Macro for inserting spaces in a telephone number string | 1/10/2007 |
| Q: The telephone and fax number fields have numbers with no spaces. I have tried to record a macro ... A: .. I can help you with the macro but my question is why not do it by a formula. Assuming a number ... | |
| How to sum | 1/9/2007 |
| Q: In that sheet I want the sum of the columns (column A, Column B, Column C, Column D) respective sum ... A: Fear Jothi, Why are you using MACRO? This can be done simply by formulae. Does the need arise ... | |
| Lookup and Match two lots of data | 9/11/2006 |
| Q: I have extracted from a database a list of Software Items in Column A and what Hardware Item they ... A: 1. I suggest you create a new column at both places by concatenating two columns to get ... | |
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Tushar Sakhalkar
Top Expert on this page
Expertise
Formulae in Excel. VB Macros.. Though not really expert in this.
Experience
Experience in Excel for about 10 years
Education/Credentials
B.Tech. (Chemical Engg)
©2012 About.com, a part of The New York Times Company. All rights reserved.