*There may be a thread that exists but I do not understand them. I am trying to create a formula so every time I type the letter b the following data ...

In excel 2003, I need to calculate per centages of a number, and add the sums of each together. The results may be off a penny or two each time. Can...

I work with Boy Scouts. They have lots of requirements to earn badges. I have a spreadsheet which lists a summary of requirements in the first column and...

I am looking for a vlookup that will look up different tabs based on dates. I have been looking through the INDIRECT questions but I cannot get my formula...

I have a strength report that generates counts based on multiple criteria. The workbook has 2 sheets (Roster contains the personnel names and position...

My current formula is: =IF(G4F4,F4-G4,"0") and it calculates correctly or displays a "0" if G4 is less than F4. But I need help finding out what to add to...

I am trying to automate a price list, and get the sheet to return a selling price on the variable cost price and markup amount. I have the...

I have a database that consists of the following: Col A: case number (e.g. 1993-01-115, 2002-11-078, etc.) Col B: username (e.g. John Henry, Jane Doe,...

I have looked at Debra Dalgleish's site but can't find the answer for this one. I have a named list with only four option but each of the four entries is...

Hi, I believe there is a bug in excel 2007 for sorting function. I have a worksheet with the first column being a building code. Some of the codes consist...

i have update to 2007 office from 2003. Now the macros that were saved in 2003 are not functioning or can't find them. Can anyone help?

I am trying to add values in one column, if the second column matches the criteria. This is what I have written and I know this is wrong. Can anyone please...

I am using the =today function in one of my spreadsheets. Is there anyway to make it show the date that it was saved when you reopen it? For instance, it...

I'm trying to find and replace * symbol.. Some boby help me

Hi How do i make a tick appear in a check box when it is clicked? what macro code do i use? -- Lois

Hi All, Please help me on consolidating 580 file's data in one file without oppening each and every file.If there is any options for importing these files...

I have a data extract listing several different vendors and the items they have sold. I can create a Pivot table that totals up the items per vendor. What...

I have a spreadsheet which I need to have conditional formatting. It is excel 2003 but is only allows me to have a 3 conditions / colour. 1st conditions I...

Hi, Is there a function or formula to automatically insert a new line in Excel. In this instance, I have a spreadsheet with three sections (top to bottom). ...

I have two sheet , I want to know if the value in a colomn of a sheet is exist in other sheet also. say the value is loan number if the same loan number is...