# Archive by category Excel 2003 Help

Excel 2003 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

## Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

## Excel work Lottery prediction

To whom this may concern,   I have a question in regards to my project which involves working out a secret formula in the determining the odds section to …

## Formula Help

Hi   I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews. I would like the …

## looking age of last non-matching value

I have data that looks like this (three columns: Date, IGN and AP):   Date IGN AP 8/8/2019 Emxmari0 3560 8/11/2019 Emxmari0 3580 8/12/2019 Emxmari0 3580 …

## solution

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? By:

## Divide numbers

Hi, Hope you’re fine and healthy. I have a time sheet for my employees and the working days of each employees calculates based on projects that employee …

## Automatic match

Hi, Would very much appreciate your assistance tackling the following conundrum:  I have two separate sheets.  In sheet 1: I have a column A for …

Hi!   I’m hoping someone can help me with this formula. I am looking for a formula to use that take the words that are in separate cells …

## Change into decimal

I unable to convert the amount i in Ms Excel to lakh in decimal. e.g. 234567  convert to 2.34 By:

## Tracking value changes to a number

I am trying to figure out what formula I would use to track value changes to my Blank Permits. For example, I have an Export Permit # 05064578 with several …

## INDEX / INDIRECT

I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data …

## mulit formulas within a cell

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor  with in that cell I want to track …

## mulit formulas within a cell

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor  with in that cell I want to track …

## Help !

I am having trouble with a project I am doing with Excel. For my statistics class I have to show the maximum temperature of the 50 states in a 30 day period. I …

## Multiple LOOKUP criteria

Is it possible to have multiple criteria in a LOOKUP formula?  By: hands in

## excel

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

## Excel help

Hello, I need to formulate the following row A 0 0 0 1 2 3 4 5 Row B Period end              Period end Period end Row c …

## Data in consecutive cells

I want to room students for specific exams. I would like to input a formula or something to allow 24 cells to be populated with the same room number. Is this …

## Cell References in Excel Macro

Hi, I want to write a Macro in excel then it can find whatever in C2 and replace it with C1 in the whole worksheet. Please could you advice what to write it …

## dalmia

Using Sumifs, pls calculate total Item received by each warehouse and the amount of item received by each ware house             …

## Round up the cell contains symbol with number

Round up the cell contains symbol with number   Eg ↓9.849639   output should be ↓9.85 …

## Large data set

<!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; …

## excel question

if cell B1 have any text then cell e1 should get 1000 automatically and if b1 have any text and d1 also have any text in such case e1 should have 4000 …

## Complex sorting

I have 2 excel files that I want to merge. Each has 2 columns, one of which is dates and one of which is dollar amounts. Within each sheet, the dates are in …

## Mrs

I have a workbook with dates that calculate to percetages. When I enter a new date the percentages does not change. Do I need to enter a digit before date …

## Mrs

I have a workbook with dates that calculate to percetages. When I enter a new date the percentages does not change. Do I need to enter a digit before date …

## Distribution in excel

Hi  I want to allocate Stock available (Column K) qty as per Sales order – Line item combination (basis first come first serve basis).   Sales …

## adding dates with key words

I need a formula that will search a specific cell (E2) or all of column E for a “key” word and then if found, take the date in A2 and add 30 days …

I have an event spreadsheet created with several colums. One of the coumns is “Class” recorded as A or B or C thru W. Is there an automated  …

## Splitting up an excel file by rows

Help!! I’m trying to split up an excel file that has 13865 lines into separate tabs. I want to break this into groups of 1387 lines and retain the …

## Mr

Help with excel formula nested IF statement in simpe spreadsheet using Excel 2016 with Windows 10.   Hi, I am trying to include a nested formula in a …

## Mr

Hi, I am trying to include a nested formula in a spread sheet. the formula is =IF(\$G22=”S”,\$E22-205,””,IF(\$G22=2,E22)) G22 is either S …

## Move remaining text

Is there a shortcut to move all remaining text right of the cursor into next cell to the right? By:

## IF function

Dear sir, I have Quarry   I Have Stock Item in Column A1 Cell Phone A2 Key Borad Key Borad  Column B1 Amount Rs 10,000  Columns B2 Amount …

## Conditional formatting for entire column

Hi I want to apply conditional formatting to entire column. Here is my requirement:   I want to highlight a cell if it has a value (date to be specific) …

## Alphabetical sort with maiden name in parenthesis

I am using Excel 2007 on a PC. I’m using the following formats to enter names in the same column: 1. Last name, First name  – for males and …