Is vlookup the correct formula to use for my task?
This is the formula that I am trying to write: When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that [...]

Answer Question   |  September 16, 2008  3:54 PM
Excel formulas, Microsoft Excel, VLOOKUP

Excel Form Macro
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux’ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work [...]

Answer Question   |  August 30, 2008  11:27 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel, SpinButton, VBA, Visual Basic for Applications

Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input [...]

Answer Question   |  July 17, 2008  6:32 PM
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query

Adding dayys to a date without adding weekends
I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the [...]

Answer Question   |  July 23, 2008  4:38 PM
Calendar, Excel formulas, Microsoft Excel

Ms Excel Question
i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i’ve applied this formula: =if(A2:A66000=”John”,sum(C2:C66000)) to get the total marks of John in all papers,but it doesnt work. plz help…!!!

Answer Question   |  February 25, 2009  8:51 AM
Excel formulas, Microsoft Excel

Excel 2003 linking text format in two workbooks
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly with [...]

Answer Question   |  May 31, 2008  6:58 PM
Excel 2003, Excel formulas, Excel workbooks, Linking workbooks

Search for duplicates in a collumn and delete the row on which it occurs
Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would [...]

Answer Question   |  May 12, 2008  1:47 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel

Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)
I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the brackets and create a column on another worksheet with them [...]

Answer Question   |  May 6, 2008  8:51 AM
Excel formulas, Excel functions, Excel macros, Microsoft Excel