microsoft.public.excel.worksheet.functions

• Thread Index

---

• Re: Need function that will work in Excel 2003 like "Countifs" in
  • From: RD
• Re: This function returns incorrect value sporadically
  • From: T. Valko
• Re: Mann-Whitney U test
  • From: Rocky4460
• Re: V_Lookup question!
  • From: T. Valko
• Re: How can I merge and link workbooks into one summary workbook?
  • From: Ron de Bruin
• Re: Another Cool Macro
  • From: Jarek Kujawa
• Re: Using Autofilter to exclude dates
  • From: David Biddulph
• Re: Excel worksheet
  • From: Spiky
• Re: FORMULA, DAYS WORKED TO VACATION DAYS
  • From: Ron Rosenfeld
• Re: Using Autofilter to exclude dates
  • From: Ian
• Re: Percentage ranges within data range - help needed
  • From: Spiky
• Re: Activate second macro only after the first macro is run
  • From: Ruchir
• RE: if formula
  • From: Mike H
• Re: Activate second macro only after the first macro is run
  • From: Susan
• Re: Activate second macro only after the first macro is run
  • From: Susan
• RE: Pop Up Message
  • From: chickalina
• Re: Using Autofilter to exclude dates
  • From: David Biddulph
• Re: Using Autofilter to exclude dates
  • From: Ian
• Re: Averages
  • From: Paige06
• RE: Min Values minus 18 months
  • From: John C
• Re: Filter on more than one cells (text)
  • From: Spiky
• Re: Activate second macro only after the first macro is run
  • From: Ruchir
• Re: Using Autofilter to exclude dates
  • From: Reitanos
• Re: Using Autofilter to exclude dates
  • From: David Biddulph
• Re: Activate second macro only after the first macro is run
  • From: ytayta555
• Activate second macro only after the first macro is run
  • From: Ruchir
• Re: Conditionally format fill color for entire row
  • From: Spiky
• Re: Using Autofilter to exclude dates
  • From: Ian
• Re: Conditionally format fill color for entire row
  • From: Spiky
• Re: I Need get work this formula
  • From: ytayta555
• Re: Averages
  • From: joeu2004
• RE: Min Values minus 18 months
  • From: Elizabeth
• Re: Mann-Whitney U test
  • From: Pete_UK
• Re: Using Autofilter to exclude dates
  • From: David Biddulph
• Re: Min Values minus 18 months
  • From: David Biddulph
• Re: Averages
  • From: Paige06
• RE: Min Values minus 18 months
  • From: John C
• Re: Using Autofilter to exclude dates
  • From: Reitanos
• RE: Min Values minus 18 months
  • From: Elizabeth
• Re: Averages
  • From: Paige06
• Re: Difference between 2 cells (growing column)
  • From: MyVeryOwnSelf
• RE: Min Values minus 18 months
  • From: Elizabeth
• Re: Additional Columns past IV?
  • From: T. Valko
• Re: Additional Columns past IV?
  • From: Peo Sjoblom
• Re: Returning a value based on a query
  • From: T. Valko
• Re: Lookup formula?
  • From: Glenn
• RE: Min Values minus 18 months
  • From: Mike H
• Re: Networkdays to open previous day's file
  • From: Bob Phillips
• Re: Sum multiple worksheet sales data by month
  • From: Bob Phillips
• Re: Can I use solver for this?
  • From: Dana DeLouis
• Re: Returning a value based on a query
  • From: linda
• RE: Find Function
  • From: Jeff Gross
• Re: iferror
  • From: T. Valko
• RE: skipp blank cell
  • From: Gary''s Student
• Re: count if with multiple criteria
  • From: RagDyeR
• Re: For Mr. RagDyer please
  • From: RagDyeR
• Re: Using LARGE function with criteria
  • From: RagDyeR
• skipp blank cell
  • From: Sanjiv
• For Mr. RagDyer please
  • From: ytayta555
• Re: Averages
  • From: joeu2004
• Re: Sum multiple worksheet sales data by month
  • From: RobS
• Re: Add days to a date, but exclude holidays
  • From: Chickadee
• Re: Conditional format when text contains using cell reference
  • From: Cheryl
• Re: Conditional format when text contains using cell reference
  • From: Glenn
• Pivot Table Calculations
  • From: Neanderthal
• Re: Cell offset issue
  • From: David Biddulph
• Re: Networkdays to open previous day's file
  • From: Dave
• Re: index(match) Wind Uplift Calculations (match four conditions)
  • From: JMeier
• Re: Rounding Time.
  • From: David Biddulph
• Re: Averages
  • From: Paige06
• RE: Excel PERCENTRANK help
  • From: John Bundy
• Re: Add days to a date, but exclude holidays
  • From: Ron Rosenfeld
• RE: Excel PERCENTRANK help
  • From: Erica.DC
• Re: Rounding Time.
  • From: GEM
• Re: Sum Time.
  • From: GEM
• Re: Networkdays to open previous day's file
  • From: Bob Phillips
• Re: Sum multiple worksheet sales data by month
  • From: RobS
• Networkdays to open previous day's file
  • From: Dave
• Re: Can I use solver for this?
  • From: Dana DeLouis
• RE: Complex cost allocation formula
  • From: John C
• I Need get work this formula
  • From: ytayta555
• Re: Conditionnal Formatting
  • From: Glenn
• Re: Conditionnal Formatting
  • From: Glenn
• Re: vlookup
  • From: Pete_UK
• RE: VLOOKUP - MULTIPLE RETURNS
  • From: Stingz
• RE: VBA code to hide blank rows
  • From: Stingz
• Re: VBA code to hide blank rows
  • From: ub
• Re: VBA code to hide blank rows
  • From: Pete_UK
• RE: VLOOKUP - MULTIPLE RETURNS
  • From: Stingz
• VBA code to hide blank rows
  • From: ub
• Re: Sum multiple worksheet sales data by month
  • From: Bob Phillips
• Re: Sumproduct calculation for January 09
  • From: Dave Peterson
• Re: Summing Problem In A Pivot Table
  • From: Fred Smith
• Re: Sumproduct calculation for January 09
  • From: Pete_UK
• Re: Sumproduct calculation for January 09
  • From: Bob Phillips
• Re: Sumproduct calculation for January 09
  • From: Pete_UK
• Re: Filter on more than one cells (text)
  • From: Pete_UK
• Re: need help mutiple worksheets to create monthly report sheet
  • From: Pete_UK
• Re: Formula using worksheet names
  • From: Pete_UK
• need help mutiple worksheets to create monthly report sheet
  • From: tedt
• RE: Formula using worksheet names
  • From: E
• Re: Quick way to change file name
  • From: Pete_UK
• Re: Formula using worksheet names
  • From: Pete_UK
• Re: Filtered Data-Linking
  • From: Pete_UK
• Re: macro help to change row colour automatically
  • From: Bob Phillips
• macro help to change row colour automatically
  • From: angel
• RE: Aouto filter by macro
  • From: Stefi
• Re: Sum Time.
  • From: David Biddulph
• Re: Add days to a date, but exclude holidays
  • From: Bob Phillips
• Re: iferror
  • From: Roy Gudgeon
• Re: [XL07] Conditionally format fill color for entire row
  • From: David Biddulph
• Re: Formula
  • From: David Biddulph
• Re: Counting time
  • From: David Biddulph
• RE: Aouto filter by macro
  • From: nader
• Re: Rounding Time.
  • From: David Biddulph
• Re: Counting time
  • From: vsoler
• Re: Rounding Time.
  • From: David Biddulph
• Complex cost allocation formula
  • From: vsoler
• Re: Need help with an IF formula
  • From: Arvi Laanemets
• RE: find and Summarize data in a table from a different sheet?
  • From: Richard Z SF
• Re: [XL07] Conditionally format fill color for entire row
  • From: Derf
• Re: [XL07] Conditionally format fill color for entire row
  • From: Peo Sjoblom
• Re: Sum Time.
  • From: Peo Sjoblom
• Re: Formula with multiple variables
  • From: Sam
• Re: Cell offset issue
  • From: T. Valko
• Re: Identify missing numbers in list
  • From: Infinitogool
• Re: Identify missing numbers in list
  • From: T. Valko
• Re: Previous visible cell
  • From: Fred
• Re: Data Base Functions
  • From: Infinitogool
• Re: index(match) Wind Uplift Calculations (match four conditions)
  • From: JMeier
• Re: Filtered Data-Linking
  • From: Pete_UK
• Re: Need help with an IF formula
  • From: Dave Peterson
• RE: Need help with an IF formula
  • From: Michael M
• Cell offset issue
  • From: MGarrison
• Re: Count a range of cells using an IF
  • From: Max
• Re: VLOOKUP formula results strange after copying down
  • From: Pete_UK
• Re: Count a range of cells using an IF
  • From: Pete_UK
• Re: Using a function/formula for copying text
  • From: Max
• Re: VLOOKUP formula results strange after copying down
  • From: CaptSpify
• Re: Count a range of cells using an IF
  • From: robzrob
• Re: Count a range of cells using an IF
  • From: Pete_UK
• Re: Count a range of cells using an IF
  • From: Pete_UK
• Re: Sum Time.
  • From: Peo Sjoblom
• Re: Count a range of cells using an IF
  • From: Max
• Re: Formula with multiple variables
  • From: Pete_UK
• Re: Sum Time.
  • From: Peo Sjoblom
• Re: Picking up data from workbooks which may not exist yet
  • From: Pete_UK
• Re: Rounding Time.
  • From: GEM
• Re: Sum Time.
  • From: robzrob
• Re: Add days to a date, but exclude holidays
  • From: Ron Rosenfeld
• Re: Rounding Time.
  • From: David Biddulph
• Re: Add days to a date, but exclude holidays
  • From: Bob Phillips
• Re: List of when functions where added
  • From: Ubentook
• Re: How to check previous entries in column for same contents
  • From: Emily
• Re: Decimal to Time Format.
  • From: GEM
• Re: Picking up data from workbooks which may not exist yet
  • From: robzrob
• Re: Decimal to Time Format.
  • From: Peo Sjoblom
• Re: Decimal to Time Format.
  • From: Dave Peterson
• Re: How to check previous entries in column for same contents
  • From: robzrob
• Re: Picking up data from workbooks which may not exist yet
  • From: Pete_UK
• Re: Decimal to Time Format.
  • From: Lars-Åke Aspelin
• Re: How to check previous entries in column for same contents
  • From: robzrob
• Re: Decimal to Time Format.
  • From: GEM
• Re: Decimal to Time Format.
  • From: David Biddulph
• How to check previous entries in column for same contents
  • From: Emily
• Re: How do I count sets of cells in two columns?
  • From: T. Valko
• Re: Need help with this formula
  • From: Don Guillett
• Re: How do I count sets of cells in two columns?
  • From: robzrob
• RE: Need Function for Year-to-Date spent total
  • From: Barb Reinhardt
• Picking up data from workbooks which may not exist yet
  • From: robzrob
• Re: VLOOKUP question
  • From: T. Valko
• RE: How to Combine Cells using Other Cell
  • From: ryguy7272
• Re: VLOOKUP question
  • From: Niek Otten
• Re: Averages
  • From: joeu2004
• Re: count if with multiple criteria
  • From: RagDyer
• Re: Conditional formula/Please help before I throw my computer!
  • From: Mindy
• Re: Functions for inventory
  • From: J-LL
• Re: Product - Conditions - Edited Results
  • From: Glenn
• Re: Product - Conditions - Edited Results
  • From: Glenn
• Re: Product - Conditions - Edited Results
  • From: Bob Phillips
• Re: left and right functions
  • From: Peo Sjoblom
• Re: left and right functions
  • From: Bob Phillips
• Re: left and right functions
  • From: Glenn
• Re: Averages
  • From: Harry Stevens
• Re: Averages
  • From: Paige06
• Re: formula for unique values
  • From: bridgeb3
• Re: Averages
  • From: Paige06
• RE: Pulling Data from External Worksheets
  • From: Jim Thomlinson
• Re: Add days to a date, but exclude holidays
  • From: Ron Rosenfeld
• Re: Add days to a date, but exclude holidays
  • From: John C
• Re: putting help text in the animated bubble
  • From: Pete Derkowski
• Re: match values in two column and return value in
  • From: T. Valko
• Re: Can be here some changes for a faster speed ?
  • From: ytayta555
• Re: Averages
  • From: joeu2004
• Re: Can be here some changes for a faster speed ?
  • From: ytayta555
• Re: match values in two column and return value in
  • From: PW
• Re: Can be here some changes for a faster speed ?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Averages
  • From: Bob Phillips
• Re: iferror
  • From: T. Valko
• Re: formula for unique values
  • From: Glenn
• Re: Averages
  • From: David Biddulph
• Re: Determining work hours between dates / hours
  • From: David Biddulph
• Re: Conditionnal Formatting
  • From: Glenn
• Re: match values in two column and return value in
  • From: T. Valko
• Re: NETWORKDAYS formula
  • From: David Biddulph
• Re: Determining work hours between dates / hours
  • From: David Biddulph
• Re: iferror
  • From: Lars-Åke Aspelin
• Re: NETWORKDAYS formula
  • From: David Biddulph
• Can be here some changes for a faster speed ?
  • From: ytayta555
• RE: Pulling Data from External Worksheets
  • From: blucajun
• NETWORKDAYS formula
  • From: Susan
• Re: iferror
  • From: Lars-Åke Aspelin
• Re: Determining the text mode from a variety of data types
  • From: Pete_UK
• Re: Averages
  • From: Bob Phillips
• Re: Pulling Data from External Worksheets
  • From: Ron de Bruin
• match values in two column and return value in
  • From: PW
• RE: Pulling Data from External Worksheets
  • From: Jim Thomlinson
• Re: Determining the text mode from a variety of data types
  • From: matt3542
• Re: Determining the text mode from a variety of data types
  • From: matt3542
• Re: iferror
  • From: John C
• Re: iferror
  • From: John C
• RE: Enter a User Name When Changes are Made
  • From: chickalina
• Re: Vlookp-matching names between sheets
  • From: Pierre
• Re: Add days to a date, but exclude holidays
  • From: Chickadee
• Re: iferror
  • From: Roy Gudgeon
• Re: Need function that will work in Excel 2003 like "Countifs" in 2007
  • From: RagDyeR
• RE: Enter a User Name When Changes are Made
  • From: Gary''s Student
• Re: putting help text in the animated bubble
  • From: Peo Sjoblom
• Re: iferror
  • From: Lars-Åke Aspelin
• Need function that will work in Excel 2003 like "Countifs" in 2007
  • From: RD
• RE: Enter a User Name When Changes are Made
  • From: chickalina
• Re: putting help text in the animated bubble
  • From: Pete Derkowski
• Re: iferror
  • From: Lars-Åke Aspelin
• Re: How to check if a date falls within a range(2 cells: Start/End
  • From: MarcusMac
• Re: Determining the text mode from a variety of data types
  • From: Pete_UK
• RE: Enter a User Name When Changes are Made
  • From: Gary''s Student
• Re: Determining the text mode from a variety of data types
  • From: Pete_UK
• putting help text in the animated bubble
  • From: Pete Derkowski
• Re: iferror
  • From: Infinitogool
• Re: Lastrow
  • From: ryguy7272
• formula for unique values
  • From: bridgeb3
• Re: Add days to a date, but exclude holidays
  • From: Bob Phillips
• Re: Better performance Vlookup or Index/Match?
  • From: Infinitogool
• Re: Sumproduct
  • From: David Biddulph
• Re: Add days to a date, but exclude holidays
  • From: Pete_UK
• RE: Add days to a date, but exclude holidays
  • From: John C
• Re: Add days to a date, but exclude holidays
  • From: Bob Phillips
• Re: 1st sheet
  • From: Tia
• Re: Determining the text mode from a variety of data types
  • From: Pete_UK
• RE: HELP linking access table to excel
  • From: ryguy7272
• Re: Functions for inventory
  • From: J-LL
• Re: Min Function
  • From: matt3542
• Re: Round to the nearest minute if more than 6 seconds
  • From: Infinitogool
• RE: Min Function
  • From: matt3542
• RE: Pop Up Message
  • From: Mike H
• RE: Work Sheet Association
  • From: Gary''s Student
• Excel showing files as read only , when they aren't.....
  • From: Colin Hayes
• Re: Min Function
  • From: matt3542
• RE: Pop Up Message
  • From: Mike H
• Re: Sumproduct
  • From: Pete_UK
• Re: Min Function
  • From: Pete_UK
• RE: Min Function
  • From: John C
• RE: Min Function
  • From: Mike H
• Re: count number of instances a number occurs
  • From: Pete_UK
• Re: Min Function
  • From: Don Guillett
• Re: How to check if a date falls within a range(2 cells: Start/End
  • From: Pete_UK
• Re: Find duplicate, but only if an adjacent cell is identical
  • From: stevewy
• Re: Macros in Excel
  • From: Don Guillett
• How to use the IF Function for 3 conditions
  • From: tech1NJ
• Re: Find duplicate, but only if an adjacent cell is identical
  • From: Nayab
• Find duplicate, but only if an adjacent cell is identical
  • From: stevewy
• Re: can assign a picture to a cell ?
  • From: Ken Johnson
• Re: How to check if a date falls within a range(2 cells: Start/End
  • From: MarcusMac
• Re: Rolling Monthly Average
  • From: Damon Longworth
• Re: Fill color with if function
  • From: Pete_UK
• Re: Names and addresses
  • From: Pete_UK
• RE: Fill color with if function
  • From: Mike H
• RE: Names and addresses
  • From: Steve
• Re: SumProduct?
  • From: Bob Phillips
• Re: Simple problem with Dates and Times is driving me nuts
  • From: David Biddulph
• 1st sheet
  • From: Tia
• Re: lookup and display
  • From: Max
• RE: HELP linking access table to excel
  • From: greg
• RE: cell reference formula
  • From: John C
• find and Summarize data in a table from a different sheet?
  • From: Richard Z SF
• RE: sorting problem.
  • From: John C
• Re: Function indicating a row have empty value on several columns
  • From: Fred
• RE: Excel conditional sum
  • From: John C
• Re: Function indicating a row have empty value on several columns
  • From: Joerg Mochikun
• Previous visible cell
  • From: Fred
• Re: SumProduct?
  • From: RagDyer
• Function indicating a row have empty value on several columns
  • From: Aline
• Re: Macros in Excel
  • From: Joerg Mochikun
• Re: two variables to get result
  • From: T. Valko
• Macros in Excel
  • From: Cheryl
• Re: Can I Use a Count Function for Text?
  • From: T. Valko
• Re: displaying the correct value.
  • From: T. Valko
• cheapestsell@hotmail.com sell cheap NHL NFL MITCHELL NFL PRO BOWL&SUPER NBA NBA children MLB NBA jerseys t-shirt shorts
  • From: cheapestsell
• Re: displaying the correct value.
  • From: GAIDEN
• display.. help
  • From: angel
• Re: lookup and display
  • From: GAIDEN
• Re: lookup and display
  • From: GAIDEN
• Re: displaying the correct value.
  • From: GAIDEN
• Re: lookup and display
  • From: smartin
• RE: when I enter a number, only ###### shows?
  • From: Joe Mac
• Re: Rolling Monthly Average
  • From: Colin Hayes
• Simple problem with Dates and Times is driving me nuts
  • From: BingBong
• Re: Make cell contents blank upon opening worksheet
  • From: Max
• Re: Calculating the value of a cell from another cell
  • From: Gord Dibben
• Re: Can I Use a Count Function for Text?
  • From: Steve Scatt
• cell reference formula
  • From: BBB
• Re: Rolling Monthly Average
  • From: Pete_UK
• Re: help with pivot tables
  • From: Infinitogool
• Calculating the value of a cell from another cell
  • From: GPark1018
• Re: index(match) Wind Uplift Calculations (match four conditions)
  • From: JMeier
• Re: MATCH working but not....
  • From: Max
• Re: Display row of the maximum in a list
  • From: T. Valko
• RE: Display row of the maximum in a list
  • From: Marcelo
• Rolling Monthly Average
  • From: Colin Hayes
• Re: average formula
  • From: Harlan Grove
• Re: Filter by Date of Birth
  • From: Naomi
• RE: How to Change Column Header from numbers back to letters
  • From: FSt1
• Re: Filter by Date of Birth
  • From: John C
• Re: Filter by Date of Birth
  • From: Naomi
• RE: How to Combine Cells using Other Cell
  • From: Mike H
• RE: How to Combine Cells using Other Cell
  • From: Mike H
• Re: Sumproduct
  • From: David Biddulph
• average formula
  • From: hserphillips
• Re: Filter by Date of Birth
  • From: David Biddulph
• Re: Filter by Date of Birth
  • From: John C
• Re: Filter by Date of Birth
  • From: Naomi
• Re: Apply a percentage factor to a base number
  • From: Southern Kiwi
• Re: Apply a percentage factor to a base number
  • From: Southern Kiwi
• Re: Filter by Date of Birth
  • From: John C
• How to Combine Cells using Other Cell
  • From: pll
• Re: Filter by Date of Birth
  • From: Naomi
• Re: Filter by Date of Birth
  • From: Reitanos
• RE: Filter by Date of Birth
  • From: Naomi
• Re: HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
  • From: Anna
• RE: Filter by Date of Birth
  • From: M Kan
• Re: IF function
  • From: David Biddulph
• Re: IF function
  • From: David Biddulph
• Re: IF function
  • From: Reitanos
• Re: Adding Rows
  • From: ryguy7272
• Re: Write a formula using two arrays, across two worksheets
  • From: Susan
• RE: How can I calculate total spend on items that have different value
  • From: John C
• Re: INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  • From: Pinto G
• Re: Write a formula using two arrays, across two worksheets
  • From: David Biddulph
• RE: Formula being replaced by =#N/A
  • From: VoxBox-Richard
• Re: HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
  • From: Peo Sjoblom
• How can I calculate total spend on items that have different values
  • From: gorbash . uk
• Re: Write a formula using two arrays, across two worksheets
  • From: Susan
• Re: Lookup Function Not in Ascending Order
  • From: Pete_UK
• Re: Summing between two dates
  • From: Pete_UK
• Re: Counting Records Between Two Dates
  • From: Pete_UK
• Re: Exporting list from Excel to PP, I want a new slide for each cell
  • From: Reitanos
• Re: HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
  • From: Anna
• Re: Still need help with IF and Count Function
  • From: Vicki
• RE: If with multiple or
  • From: TFMR
• Re: Counting Records Between Two Dates
  • From: Infinitogool
• Re: Excel not correctly calculating formula
  • From: Pete_UK
• Re: Counting Records Between Two Dates
  • From: Pete_UK
• Re: MATCH working but not....
  • From: Max
• Counting Records Between Two Dates
  • From: Stevo
• Re: Summing between two dates
  • From: Pete_UK
• Re: Summing between two dates
  • From: Max
• Re: Still need help with IF and Count Function
  • From: Stephen Lloyd
• RE: how to make a cell mandatory in the excel sheet
  • From: Gary Brown
• RE: If with multiple or
  • From: John C
• Re: Is it possible to filter using row height in Excel
  • From: Otto Moehrbach
• Re: Excel not correctly calculating formula
  • From: Darren Ingram
• Re: Excel not correctly calculating formula
  • From: Darren Ingram
• Re: Multiple Data Validation
  • From: Bob Phillips
• Re: Excel not correctly calculating formula
  • From: Pete_UK
• Re: How to check if a date falls within a range(2 cells: Start/End Dat
  • From: Pete_UK
• Re: If with multiple or
  • From: Lars-Åke Aspelin
• Re: If with multiple or
  • From: Pete_UK
• Re: Lookup Function Not in Ascending Order
  • From: Pete_UK
• Re: convert US dates to UK dates
  • From: Dave Peterson
• Re: Lookup Function Not in Ascending Order
  • From: Ron Rosenfeld
• Re: How do I use a variable as a reference to an array in INDEX
  • From: Steve Haack
• Re: Lookup Function Not in Ascending Order
  • From: Pete_UK
• Re: Multiple Data Validation
  • From: Bob Phillips
• Re: convert US dates to UK dates
  • From: Pete_UK
• Is it possible to filter using row height in Excel
  • From: xBRITO
• Re: Multiple Critiera Sum Array - One critiera to be between two numbers
  • From: Forgone
• RE: Apply a percentage factor to a base number
  • From: Mike H
• Re: IF function? to turn around answers in questionaire
  • From: Bob Phillips
• Re: sumproduct help.
  • From: Bob Phillips
• Apply a percentage factor to a base number
  • From: Southern Kiwi
• Re: IF function? to turn around answers in questionaire
  • From: Max
• Re: IF function? to turn around answers in questionaire
  • From: Pete_UK
• Re: sumproduct help.
  • From: Pete_UK
• Re: Alphanumeric
  • From: beejay
• Re: sumproduct help.
  • From: Max
• IF function? to turn around answers in questionaire
  • From: Windav
• Re: Adding sums from different worksheets
  • From: Pete_UK
• Re: Regarding Formula for Date and time
  • From: Bob Phillips
• Re: Lowest two values
  • From: Bob Phillips
• Re: Alphanumeric
  • From: T. Valko
• Re: Creating a data entry form in excel
  • From: David Biddulph
• RE: Copy & paste block of text number of times equal to value in cell
  • From: ryguy7272
• Re: Alphanumeric
  • From: T. Valko
• Re: Can I Use a Count Function for Text?
  • From: T. Valko
• Re: Multiple Critiera Sum Array - One critiera to be between two numbers
  • From: Forgone
• Re: Can I Use a Count Function for Text?
  • From: Steve Scatt
• Re: displaying the correct value.
  • From: Fred Smith
• Re: displaying the correct value.
  • From: T. Valko
• Re: MS Excel 2007
  • From: RagDyer
• Re: Lookup Formula Question
  • From: Max
• Re: INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  • From: Infinitogool
• Re: Lowest two values
  • From: RagDyer
• Re: INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  • From: RagDyer
• Re: Lowest two values
  • From: Infinitogool
• Re: MS Excel 2007
  • From: Pete_UK
• Re: Lowest two values
  • From: Pete_UK
• Lookup Formula Question
  • From: JWNJ
• MS Excel 2007
  • From: sherrysboyfriend
• RE: Ignore blank cells when calculating date for If, Then function
  • From: AndreaS13
• Re: SUMIF
  • From: RagDyer
• Re: lookup or vlookup
  • From: Max
• Re: Vlookup with multiple corresponding values
  • From: Pete_UK
• Re: How do I use a variable as a reference to an array in INDEX
  • From: T. Valko
• Re: How do I use a variable as a reference to an array in INDEX
  • From: Pete_UK
• Re: Still need help with IF and Count Function
  • From: Pete_UK
• Re: How do I use a variable as a reference to an array in INDEX
  • From: Steve Haack
• Re: Still need help with IF and Count Function
  • From: Pete_UK
• Re: Still need help with IF and Count Function
  • From: T. Valko
• RE: Still need help with IF and Count Function
  • From: Vicki
• Re: Write a formula using two arrays, across two worksheets
  • From: Lars-Åke Aspelin
• Re: Write a formula using two arrays, across two worksheets
  • From: Susan
• Re: Write a formula using two arrays, across two worksheets
  • From: Lars-Åke Aspelin
• RE: Vlookup with multiple corresponding values
  • From: Dudeone
• Need to report a count that meets multiple criteria.
  • From: tkm
• Re: Count if problems
  • From: T. Valko
• Re: How do I use a variable as a reference to an array in INDEX
  • From: T. Valko
• Re: Count if problems
  • From: Peo Sjoblom
• Re: Count if problems
  • From: T. Valko
• Re: Deleting/Sorting
  • From: Karen
• RE: Deleting/Sorting
  • From: Karen
• RE: Deleting/Sorting
  • From: Karen
• Re: Count if problems
  • From: Bob Phillips
• RE: Deleting/Sorting
  • From: Karen
• RE: Count if problems
  • From: Stephen Lloyd
• Re: Countif with two conditions
  • From: T. Valko
• Re: Exporting data
  • From: Otto Moehrbach
• Re: Countif with two conditions
  • From: Vicki
• Re: Still need help with IF and Count Function
  • From: Bob Phillips
• Still need help with IF and Count Function
  • From: Vicki
• RE: Excel worksheets
  • From: JLatham
• Re: Count if problems
  • From: T. Valko
• Re: Excel worksheets
  • From: Peo Sjoblom
• Re: Write a formula using two arrays, across two worksheets
  • From: Vicki
• Re: How do I format cells as custom and keep text formatting?
  • From: Peo Sjoblom
• Re: Problem with IF Statement
  • From: PCLIVE
• Re: excel 2007 formulas
  • From: T. Valko
• Creating a data entry form in excel
  • From: Seaside Nutty
• RE: SUMIF
  • From: Brad Bross
• How to use the IF function to resolved more than one creteria
  • From: tech1NJ
• Re: Problem with IF Statement
  • From: M Peddle
• Re: If Statement On Two Conditions
  • From: RoadKill
• CORRECTION! CRe: Problem with IF Statement
  • From: PCLIVE
• Re: How to combine two columns into a new column
  • From: Spiky
• Re: Problem with IF Statement
  • From: PCLIVE
• Re: If Statement On Two Conditions
  • From: Bob Phillips
• Re: Cell Paste using cell link option Half works
  • From: Spiky
• Re: Problem with IF Statement
  • From: Bob Phillips
• Re: If Statement On Two Conditions
  • From: T. Valko
• Re: tracing precedents
  • From: Spiky
• Re: Countif with two conditions
  • From: T. Valko
• Re: Problem with IF Statement
  • From: M Peddle
• Re: SUMIF
  • From: RagDyeR
• Re: Write a formula using two arrays, across two worksheets
  • From: Lars-Åke Aspelin
• Re: Countif with two conditions
  • From: Vicki
• tracing precedents
  • From: Ricardo Monroy
• RE: Deleting/Sorting
  • From: Gary Brown
• Re: Deleting/Sorting
  • From: Susan
• Re: Problem with IF Statement
  • From: Bob Phillips
• RE: Deleting/Sorting
  • From: StumpedAgain
• Re: Conditional Formatting in Excel 2007
  • From: neillstoddart
• SUMIF
  • From: Brad Bross
• Re: Problem with IF Statement
  • From: PCLIVE
• Re: Lookup automatically specified arrays
  • From: Spiky
• Problem with IF Statement
  • From: M Peddle
• Re: Conditional Formatting in Excel 2007
  • From: Bob Phillips
• Re: Help required
  • From: Spiky
• Re: Conditional Formatting in Excel 2007
  • From: neillstoddart
• Re: lookup or vlookup
  • From: Peo Sjoblom
• Conditional Formatting in Excel 2007
  • From: neillstoddart
• Re: lookup or vlookup
  • From: Teethless mama
• Re: lookup or vlookup
  • From: Peo Sjoblom
• Re: Find & Replace - Limit search to a specific column
  • From: Spiky
• Ignore blank cells when calculating date for If, Then function
  • From: AndreaS13
• Re: lookup or vlookup
  • From: Teethless mama
• Re: Exporting data
  • From: Otto Moehrbach
• Re: VLOOKUP()
  • From: Finance Guru
• Re: VLOOKUP()
  • From: Don Guillett
• Re: lookup or vlookup
  • From: Max
• RE: Not allow data to be entered beyond a specified row.
  • From: Mike H
• Re: Not allow data to be entered beyond a specified row.
  • From: Bernard Liengme
• Not allow data to be entered beyond a specified row.
  • From: Cassie
• Re: Search for data and return cell reference
  • From: John
• RE: Search for data and return cell reference
  • From: Gary''s Student
• Re: hlookup
  • From: John
• lookup or vlookup
  • From: jamalhakem
• Re: Calculate the time difference excluding weekends and out of business hours ( i.e. 8AM - 5 PM)
  • From: joshi . sadanand
• RE: Vlookup with multiple corresponding values
  • From: exoticdisease
• Re: Using auto filter after my worksheet is protected
  • From: Dave Peterson
• Re: Calculate the time difference excluding weekends and out of business hours ( i.e. 8AM - 5 PM)
  • From: David Biddulph
• Re: Different password for different worksheet
  • From: macropod
• Using auto filter after my worksheet is protected
  • From: LY
• Re: Calculate the time difference excluding weekends and out of business hours ( i.e. 8AM - 5 PM)
  • From: joshi . sadanand
• Calculate the time difference excluding weekends and out of business hours ( i.e. 8AM - 5 PM)
  • From: joshi . sadanand
• Re: How we convert number in to word
  • From: macropod
• Re: Different password for different worksheet
  • From: macropod
• Re: hlookup
  • From: Ivan
• Re: all dates in a column have gone back four years
  • From: macropod
• RE: Aouto filter by macro
  • From: Stefi
• Re: Password
  • From: Harlan Grove
• Password
  • From: Gitano
• hlookup
  • From: mtitanium
• Vlookup with multiple corresponding values
  • From: Dudeone
• Re: Summing by weeks
  • From: Scopar
• Re: Adding Rows
  • From: Joerg Mochikun
• RE: Find & Replace - Limit search to a specific column
  • From: falena23
• RE: Report Function
  • From: Wigi
• Re: Excel Script to Auto pick next
  • From: Otto Moehrbach
• Re: protecting worksheets
  • From: Otto Moehrbach
• Re: file names
  • From: Esradekan
• Re: Multiple If Statements in the same cell
  • From: Don Guillett
• RE: file names
  • From: Greg Wilson
• Adding Rows
  • From: leimst
• Re: capturing all of the data
  • From: T. Valko
• Re: How to change cell value if cell contain specified word
  • From: Ragdyer
• RE: capturing all of the data
  • From: M Kan
• Re: COUNTIF
  • From: Rick Rothstein \(MVP - VB\)
• Re: COUNTIF
  • From: s2m
• Re: How to change cell value if cell contain specified word
  • From: Gord Dibben
• Re: finding out denominations.!
  • From: via135
• Re: capturing all of the data
  • From: jimbo
• Re: capturing all of the data
  • From: jimbo
• RE: Drop down lists and macros
  • From: lost and confused in excel-land
• Re: alphabetize ignoring hyphen
  • From: Ron Rosenfeld
• Re: file names
  • From: Esradekan
• RE: file names
  • From: FloMM2
• Re: How to change cell value if cell contain specified word
  • From: Hassan
• Re: How to change cell value if cell contain specified word
  • From: Ragdyer
• Re: Formula Not Working
  • From: Ragdyer
• RE: alphabetize ignoring hyphen
  • From: lewisweiss
• RE: How to change cell value if cell contain specified word
  • From: Hassan
• Re: AVERAGEIF
  • From: T. Valko
• Re: capturing all of the data
  • From: NoodNutt
• Re: capturing all of the data
  • From: Gord Dibben
• Re: Freezing Panes
  • From: Gord Dibben
• Re: Alphanumeric
  • From: hardeep via OfficeKB.com
• Re: Formula Not Working
  • From: JBoyer
• Re: Freezing Panes
  • From: Rick Rothstein \(MVP - VB\)
• file names
  • From: Esradekan
• Re: Freezing Panes
  • From: Rick Rothstein \(MVP - VB\)
• Re: Break a forgotten worksheet password
  • From: T. Valko
• Re: capturing all of the data
  • From: T. Valko
• Re: Break a forgotten worksheet password
  • From: Peo Sjoblom
• Re: AVERAGEIF
  • From: T. Valko
• Re: Enter a value in wks1-Find that value on wks2-Auto fill cells
  • From: Pete_UK
• Re: How do I link cells from one excel worksheet to another?
  • From: Gord Dibben
• Re: Freeze a title only
  • From: Gord Dibben
• Re: Freeze a title only
  • From: smartin
• Freeze a title only
  • From: Judy Kay
• Re: Enter a value in wks1-Find that value on wks2-Auto fill cells
  • From: danno-c
• capturing all of the data
  • From: jimbo
• Re: Need help creating formula for given data
  • From: Don Guillett
• Re: TABBING BETWEEN PARTICULAR CELLS
  • From: smartin
• Re: Need help creating formula for given data
  • From: Lars-Åke Aspelin
• Re: Need help creating formula for given data
  • From: Austin
• RE: WORKDAY() results appear to be inconsistent...
  • From: Mike H
• Re: Formula Not Working
  • From: Ragdyer
• Re: Formula Not Working
  • From: Ragdyer
• Re: Need help creating formula for given data
  • From: Need Assistance! Please Help!
• Re: Need help creating formula for given data
  • From: Don Guillett
• Re: Need help creating formula for given data
  • From: Don Guillett
• Re: finding out denominations.!
  • From: Harlan Grove
• Re: Formula
  • From: Don Guillett
• Re: finding out denominations.!
  • From: Lars-Åke Aspelin
• Re: Advanced sorting
  • From: Ragdyer
• finding out denominations.!
  • From: via135
• Need help creating formula for given data
  • From: Need Assistance! Please Help!
• Re: Advanced sorting
  • From: Lars-Åke Aspelin
• Re: Alphanumeric
  • From: Ron Rosenfeld
• Re: Advanced sorting
  • From: Gerben Dirksen
• Re: How do I copy a VLOOKUP into a column and keep a constant array?
  • From: Niek Otten
• RE: How do I copy a VLOOKUP into a column and keep a constant array?
  • From: Mike H
• Re: How do I copy a VLOOKUP into a column and keep a constant array?
  • From: Lars-Åke Aspelin
• Formula Not Working
  • From: JBoyer
• Re: difference between exel 2003 and 2007
  • From: David Biddulph
• Re: Formula for multiple cells
  • From: Rick Rothstein \(MVP - VB\)
• Re: TABBING BETWEEN PARTICULAR CELLS
  • From: Gord Dibben
• Re: Formula for multiple cells
  • From: Gord Dibben
• RE: Aouto filter by macro
  • From: nader
• RE: Alphanumeric
  • From: hardeep via OfficeKB.com
• Re: Trying to get work days out of two dates
  • From: David Biddulph
• Re: Formula for multiple cells
  • From: Rick Rothstein \(MVP - VB\)
• Formula for Adding cells up
  • From: Raich
• Re: TABBING BETWEEN PARTICULAR CELLS
  • From: Ragdyer
• Re: ANOVA with two factors
  • From: Mike Middleton
• Re: ANOVA with two factors
  • From: NoodNutt
• Re: Need Help on formal - output a sum
  • From: T. Valko
• Re: Need Help on formal - output a sum
  • From: Deiow
• Re: Need Help on formal - output a sum
  • From: T. Valko
• Need Help on formal - output a sum
  • From: Deiow
• Re: Variable named range in worksheet function
  • From: T. Valko
• RE: How do I create a table on a new worksheet from other workshee
  • From: Etg-Para
• Re: Variable named range in worksheet function
  • From: Barb Reinhardt
• Re: Caps formular please help
  • From: Pete_UK
• Re: Variable named range in worksheet function
  • From: Peo Sjoblom
• Re: Auto Sum entries in a cell
  • From: Gord Dibben
• Re: vlookup() function
  • From: Gord Dibben
• Re: Conditional formula/Please help before I throw my computer!
  • From: Gord Dibben
• Re: Replacing ISERROR Formula
  • From: T. Valko
• Re: Replacing ISERROR Formula
  • From: RagDyer
• Re: Trying to get work days out of two dates
  • From: T. Valko
• Re: Variable named range in worksheet function
  • From: Peo Sjoblom
• Re: Trying to get work days out of two dates
  • From: erick-flores
• Re: Need help with formulas
  • From: Rick Rothstein \(MVP - VB\)
• Re: Need help with formulas
  • From: Rita
• Re: INDEX using range
  • From: Harlan Grove
• Re: Need help with formulas
  • From: Rick Rothstein \(MVP - VB\)
• Re: INDEX using range
  • From: T. Valko
• Re: Trying to get work days out of two dates
  • From: Peo Sjoblom
• Msnstockquote
  • From: tfjr
• Re: Trying to get work days out of two dates
  • From: erick-flores
• Re: Need help with formulas
  • From: Harlan Grove
• Re: Need help with formulas
  • From: Rita
• Re: Trying to get work days out of two dates
  • From: erick-flores
• Re: Need help with formulas
  • From: Rick Rothstein \(MVP - VB\)
• Re: Trying to get work days out of two dates
  • From: T. Valko
• Re: Formula greater than
  • From: T. Valko
• RE: Trying to get work days out of two dates
  • From: John C
• Re: Need help with formulas
  • From: Rita
• Excel Script to Auto pick next
  • From: Jay Bowers
• Re: Seperate Cell contenets in to different columns on basis of leading spaces
  • From: Harlan Grove
• Trying to get work days out of two dates
  • From: erick-flores
• Re: Lookup MIN Date
  • From: dcr
• Re: Lookup MIN Date
  • From: Peo Sjoblom
• Re: Need help with formulas
  • From: Rick Rothstein \(MVP - VB\)
• Re: Caps formular please help
  • From: Peo Sjoblom
• Re: Caps formular please help
  • From: Pete_UK
• Re: DATA VALIDATION
  • From: Debra Dalgleish
• Re: Need help with formulas
  • From: Rick Rothstein \(MVP - VB\)
• Re: Associating a STATE or TIME with a phone number
  • From: charles770
• Need help with formulas
  • From: Rita
• RE: Excel Spreadsheet
  • From: JLatham
• Re: Lookup MIN Date
  • From: Bob Phillips
• Re: Lookup MIN Date
  • From: Pete_UK
• Re: Lookup MIN Date
  • From: Pete_UK
• Seperate Cell contenets in to different columns on basis of leading spaces
  • From: vgondia
• Re: Associating a STATE or TIME with a phone number
  • From: JE McGimpsey
• Re: Need something other than IF function
  • From: PrinceAli
• Re: Countifs with same reference?
  • From: David Biddulph
• Re: VLOOKUP for multiple colums
  • From: T. Valko
• Re: VLOOKUP for multiple colums
  • From: Lars-Åke Aspelin
• Re: remove #n/a from the columnI've used a function
  • From: Pete_UK
• Total rows allowed on spreadsheet 2007 version
  • From: Babyjsmom
• remove #n/a from the columnI've used a function
  • From: Sue
• Re: VLOOKUP for multiple colums
  • From: Harlan Grove
• Re: VLOOKUP for multiple colums
  • From: Lars-Åke Aspelin
• RE: VLOOKUP for multiple colums
  • From: Stephen Lloyd
• Re: VLOOKUP for multiple colums
  • From: T. Valko
• Linked sheets, blank cells and adding new rows
  • From: CharlieJane
• Re: Countifs with same reference?
  • From: Harlan Grove
• Re: Need a Formula to Calculate the Area -Simpson Rule
  • From: Harlan Grove
• Re: VLOOKUP for multiple colums
  • From: Peo Sjoblom
• Re: VLOOKUP for multiple colums
  • From: Pete_UK
• Re: Countifs with same reference?
  • From: John C
• Re: Using Countif with multiple worksheets
  • From: Peo Sjoblom
• Re: Need something other than IF function
  • From: Bob Phillips
• Multiple Lookups in one Cell
  • From: lehigh46
• Need something other than IF function
  • From: PrinceAli
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: John C
• RE: Logical if more than 7
  • From: vmohan1978
• Re: Countifs with same reference?
  • From: Harlan Grove
• Re: Conditional formula/Please help before I throw my computer!
  • From: Mindy
• Re: Countifs with same reference?
  • From: John C
• Re: Countifs with same reference?
  • From: Harlan Grove
• Re: Counting the ones, twos and threes - Please Help
  • From: Peo Sjoblom
• vlookup() function
  • From: harsh_njoy
• Re: Shared Document & Hyperlinks
  • From: Dave Peterson
• Re: new to excel need help with function
  • From: Pete_UK
• Re: new to excel need help with function
  • From: NoodNutt
• Re: MODE - Second most frequent value
  • From: Sam via OfficeKB.com
• Shared Document & Hyperlinks
  • From: chickalina
• Re: large amount of data moving to excel
  • From: Pete_UK
• Re: Countifs with same reference?
  • From: John C
• Re: Need a Formula to Calculate the Area -Simpson Rule
  • From: Jarek Kujawa
• Re: new to excel need help with function
  • From: Pete_UK
• Re: change formula in a shared worksheet without losing change his
  • From: DCE
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET
  • From: Ron de Bruin
• Re: HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET
  • From: NoodNutt
• Re: Cell references in SUMIF formulas
  • From: Pete_UK
• Re: Simplification of IF Statement
  • From: NoodNutt
• Re: Cell references in SUMIF formulas
  • From: Karl
• Re: Excel 2007 lookup problem continuing ...
  • From: NoodNutt
• Re: Simplification of IF Statement
  • From: NoodNutt
• Re: Excel 2007 lookup problem continuing ...
  • From: Pete_UK
• RE: Simplification of IF Statement
  • From: Mike H
• Re: sumproduct _zafar
  • From: Pete_UK
• Re: Enter a value in wks1-Find that value on wks2-Auto fill cells in w
  • From: Pete_UK
• Simplification of IF Statement
  • From: NoodNutt
• Re: calculating Leave
  • From: Bob Phillips
• Re: getting list of files
  • From: Héctor Miguel
• Re: getting list of files
  • From: Esradekan
• Re: create a summary sheet
  • From: Tia
• RE: create a summary sheet
  • From: FloMM2
• Re: just wondering, do they have smthing called XMIRR
  • From: David Biddulph
• Re: Calculating present age if date of birth is given.
  • From: Joerg Mochikun
• Re: Calculating present age if date of birth is given.
  • From: David Biddulph
• Re: Countifs with same reference?
  • From: David Biddulph
• Re: getting list of files
  • From: Héctor Miguel
• RE: alphabetize ignoring hyphen
  • From: Mike H
• create a summary sheet
  • From: Tia
• Re: Countifs with same reference?
  • From: Harlan Grove
• Re: Calculating present age if date of birth is given.
  • From: NoodNutt
• Calculating present age if date of birth is given.
  • From: harsh_njoy
• Re: calculating Leave
  • From: Tia
• Re: Macro to copy an image (or picture) from one workbook to a new sheet in another workbook
  • From: NoodNutt
• Excel 2007 lookup problem continuing ...
  • From: Trish
• getting list of files
  • From: Esradekan
• Re: How to conditional format columns in a range based on
  • From: T. Valko
• Re: How to conditional format columns in a range based on
  • From: BlyChris
• Re: Scroll Bar Disappears
  • From: Gord Dibben
• Re: Countifs with same reference?
  • From: John C
• Re: change formula in a shared worksheet without losing change his
  • From: NoodNutt
• Re: change formula in a shared worksheet without losing change his
  • From: NoodNutt
• Re: Average if and networkdays
  • From: T. Valko
• Re: Changing worksheet reference in a VLOOKUP
  • From: T. Valko
• Re: Scroll Bar Disappears
  • From: Lucy
• Re: Use Len and Left to make name 3 letters
  • From: T. Valko
• Re: Copy Paste filtered column ok in 2003 not in 2007
  • From: NoodNutt
• Re: How to use LEN & LEFT on last name to show only 3 letters
  • From: Pete_UK
• Re: Filtering
  • From: Susan
• RE: Filtering
  • From: Susan
• Re: Changing worksheet reference in a VLOOKUP
  • From: Mark
• How to ID numbers in Excel sheet that add up to specific sum?
  • From: Kassira
• Re: Convert int ccyymmdd to date(time)
  • From: Ron Rosenfeld
• Re: Scroll Bar Disappears
  • From: Gord Dibben
• Re: How to use LEN & LEFT on last name to show only 3 letters
  • From: Pete_UK
• Re: How to dealing with functions with 30+ variables?
  • From: Gord Dibben
• Re: Filtering
  • From: Pete_UK
• Re: MODE - Second most frequent value
  • From: Harlan Grove
• Re: DATA VALIDATION
  • From: Gord Dibben
• Re: using error type and if statement to return a value.
  • From: Pete_UK
• Re: using error type and if statement to return a value.
  • From: Max
• Re: DATA VALIDATION
  • From: Debra Dalgleish
• Re: using error type and if statement to return a value.
  • From: Bob Phillips
• Re: Using IF and date ranges
  • From: Bob Phillips
• Re: How to dealing with functions with 30+ variables?
  • From: Darius
• MODE - Second most frequent value
  • From: Sam via OfficeKB.com
• Re: COUNTIF
  • From: Rick Rothstein \(MVP - VB\)
• RE: Filtering
  • From: Anne903
• Re: COUNTIF
  • From: Peo Sjoblom
• Re: COUNTIF
  • From: Wigi
• Re: how to make an IF function that has the same result as COUNTIF
  • From: Peo Sjoblom
• Re: Color coding cells
  • From: Otto Moehrbach
• Re: COUNTIF
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to make an IF function that has the same result as COUNTIF
  • From: Alex Khan
• Re: VLOOKUP
  • From: Gord Dibben
• Re: drag across multiple data sets
  • From: Gord Dibben
• Re: Formulae stop working
  • From: RagDyer
• Re: excel won't save the border lines
  • From: Gord Dibben
• Re: How to dealing with functions with 30+ variables?
  • From: Gord Dibben
• RE: DATA VALIDATION
  • From: Wigi
• Re: how to make an IF function that has the same result as COUNTIF?
  • From: Peo Sjoblom
• Re: excel won't save the border lines
  • From: Spiky
• Re: need help with sumif function
  • From: PCLIVE
• RE: can i create formula to make cell PLURAL if other cell is >1?
  • From: me@BBB
• RE: need help with sumif function
  • From: Gary''s Student
• Re: can i create formula to make cell PLURAL if other cell is >1?
  • From: RagDyer
• Re: can i create formula to make cell PLURAL if other cell is >1?
  • From: T. Valko
• Re: drag across multiple data sets
  • From: Spiky
• Re: can i create formula to make cell PLURAL if other cell is >1?
  • From: David Biddulph
• Re: How to Create Macro to Increase Cell Value to one and Print Wo
  • From: mdms515
• ?Advanced? Hyperlinking
  • From: PurchaseGuy
• Re: setting multiple conditions in one cell
  • From: Don Guillett
• Re: have date show in cell when only entering numbers
  • From: Peo Sjoblom
• Re: Inserting data into next blank cell down in next sheet
  • From: Nick Wakeham
• Re: excel won't save the border lines
  • From: Spiky
• Re: formulae corruption in excel
  • From: Spiky
• Re: have date show in cell when only entering numbers
  • From: cjlatta
• Conditional Formatting qn
  • From: Trisna Lim
• Re: excel text formula does not calculate after editing
  • From: T. Valko
• Re: Summary help!
  • From: Sandy Mann
• Re: Summary help!
  • From: ml
• Re: excel text formula does not calculate after editing
  • From: David Biddulph
• Re: How to conditional format columns in a range based on
  • From: T. Valko
• Re: Scroll Bar Disappears
  • From: Gord Dibben
• Re: excel text formula does not calculate after editing
  • From: T. Valko
• Re: calculating Leave
  • From: Bob Phillips
• Re: How to Create Macro to Increase Cell Value to one and Print Wo
  • From: Gary''s Student
• Re: Countifs with same reference?
  • From: Harlan Grove
• Re: calculating Leave
  • From: Bob Phillips
• RE: How to dealing with functions with 30+ variables?
  • From: Mike H
• RE: How do I create a table on a new worksheet from other worksheet da
  • From: M Kan
• Re: SORTING CELLS
  • From: Gord Dibben
• How do I create a table on a new worksheet from other worksheet da
  • From: Etg-Para
• Re: Sales mark up formula
  • From: David Biddulph
• Re: column reference in an Excel spreadsheet
  • From: David Biddulph
• Re: column reference in an Excel spreadsheet
  • From: Don Guillett
• Re: Color coding cells
  • From: Don Guillett
• Re: Sales mark up formula
  • From: Sandy Mann
• Re: have date show in cell when only entering numbers
  • From: Peo Sjoblom
• Re: Summary help!
  • From: Sandy Mann
• Re: Sales mark up formula
  • From: PCLIVE
• Re: Sales mark up formula
  • From: Sandy Mann
• Re: Look up Function
  • From: Pete_UK
• Macro to copy an image (or picture) from one workbook to a new sheet in another workbook
  • From: Ruchir
• Re: Excel 2000
  • From: Pete_UK
• RE: Counting Empty Dates within a Range?
  • From: Gina
• Re: drag across multiple data sets
  • From: Spiky
• Re: Sales mark up formula
  • From: PCLIVE
• Inserting data into next blank cell down in next sheet
  • From: Nick Wakeham
• Re: Index, Large and Match??
  • From: Spiky
• Re: SORTING CELLS
  • From: David Biddulph
• RE: Counting Empty Dates within a Range?
  • From: Allllen
• Query: Automatically transfer complete rows?
  • From: Smurrf
• Re: Convert int ccyymmdd to date(time)
  • From: patf@xxxxxxxx
• Counting Empty Dates within a Range?
  • From: Gina
• How to conditional format columns in a range based on
  • From: BlyChris
• SORTING CELLS
  • From: LAURA
• RE: How to change cell value if cell contain specified word
  • From: Stefi
• Re: Countifs with same reference?
  • From: David Biddulph
• RE: Countif numbers fall between two values
  • From: Teethless mama
• Re: Hiii - Please help
  • From: NPell
• Re: change formula in a shared worksheet without losing change his
  • From: DCE
• RE: how to extract caracters up to comma in excel cell
  • From: Teethless mama
• Re: INDIRECT reference to another worksheet in same workbook
  • From: Max
• Graph and updating
  • From: Nick Wakeham
• Re: how to extract caracters up to comma in excel cell
  • From: Ken Johnson
• Re: How to Create Macro to Increase Cell Value to one and Print Worksh
  • From: mdms515
• Re: Cell references in SUMIF formulas
  • From: Pete_UK
• Re: calculating Leave
  • From: Tia
• Re: calculating Leave
  • From: Bob Phillips
• Re: Cannot insert worksheet in exel - not available in insert menu
  • From: Dave Peterson
• Re: Need help ( Hope i made it clear this time)
  • From: Bob Phillips
• Re: calculating Leave
  • From: Bob Phillips
• Re: Hiii - Please help
  • From: Pete_UK
• Re: calculating Leave
  • From: Bob Phillips
• Re: Hiii - Please help
  • From: Fuzzy
• Need help ( Hope i made it clear this time)
  • From: Tia
• Re: sumproduct _zafar
  • From: Pete_UK
• Re: sumproduct _zafar
  • From: vlook fomula
• VBE Error (Project unviewable)
  • From: Tia
• Re: Hiii - Please help
  • From: Fuzzy
• Re: sumproduct _zafar
  • From: Pete_UK
• Re: Copy Paste filtered column ok in 2003 not in 2007
  • From: Sandra Williams
• Re: Hiii - Please help
  • From: Pete_UK
• Re: Nested Forecast Formula Help
  • From: Bob Phillips
• Re: sumproduct _zafar
  • From: Bob Phillips
• Re: Hiii - Please help
  • From: Bob Phillips
• Re: calculating Leave
  • From: Tia
• Re: calculating Leave
  • From: Bob Phillips
• Re: Hiii - Please help
  • From: Fuzzy
• Re: Hiii - Please help
  • From: Bob Phillips
• Re: calculating Leave
  • From: Tia
• sumproduct_zafar
  • From: vlook fomula
• Re: calculating Leave
  • From: Bob Phillips
• calculating Leave
  • From: Tia
• Re: Index, Large and Match??
  • From: David Biddulph
• Re: Combining data from 2 sheets - advanced help please
  • From: Mark
• Re: return values in the table with multiple conditions
  • From: JE McGimpsey
• Re: Excel 2007 Autofilter vs Excel 2003
  • From: James8309
• Re: match, lookup two column data
  • From: Ragdyer
• Re: Convert int ccyymmdd to date(time)
  • From: Ron Rosenfeld
• Re: Convert int ccyymmdd to date(time)
  • From: Dave Peterson
• RE: Excel 2007 Autofilter vs Excel 2003
  • From: OssieMac
• Re: Date Calculations
  • From: Rick Rothstein \(MVP - VB\)
• Re: Convert int ccyymmdd to date(time)
  • From: Pete_UK
• Re: Convert int ccyymmdd to date(time)
  • From: Ron Rosenfeld
• Re: Pivot Table data
  • From: Herbert Seidenberg
• Re: Date Calculations
  • From: Ron Rosenfeld
• Re: Convert int ccyymmdd to date(time)
  • From: Dave Peterson
• Excel 2007 Autofilter vs Excel 2003
  • From: James8309
• Re: change formula in a shared worksheet without losing change history
  • From: NoodNutt
• Re: MCONCAT
  • From: Ron Rosenfeld
• Re: Convert int ccyymmdd to date(time)
  • From: patf@xxxxxxxx
• return values in the table with multiple conditions
  • From: cprao
• Re: Index, Large and Match??
  • From: Max
• Re: Copy Paste filtered column ok in 2003 not in 2007
  • From: NoodNutt
• Re: Index, Large and Match??
  • From: Pete_UK
• Re: Cell Underline problem underlines across width of cell
  • From: Pete_UK
• Re: Date Calculations
  • From: Pete_UK
• Re: Index, Large and Match??
  • From: Max
• Re: Convert int ccyymmdd to date(time)
  • From: Pete_UK
• Re: How do I delete the refernce a formula when copying and pasting?
  • From: Gord Dibben
• Re: Printing with ""
  • From: Gord Dibben
• Convert int ccyymmdd to date(time)
  • From: patf@xxxxxxxx
• Re: Using SUMIF with RIGHT()
  • From: T. Valko
• Re: Printing with ""
  • From: Spiky
• Re: assigning grades
  • From: T. Valko
• Re: Adding duplicates...
  • From: Spiky
• RE: assigning grades
  • From: John C
• Re: IF
  • From: Gord Dibben
• Re: How do I intergrate lines added so they follow in descending order
  • From: Spiky
• Re: NON SEQUENTIAL DATE RANGES
  • From: Spiky
• Re: Using SUMIF with RIGHT()
  • From: T. Valko
• Re: Printing with ""
  • From: Gord Dibben
• Re: Printing with ""
  • From: Gord Dibben
• Re: Create macro with button in excel spreadsheet
  • From: Gord Dibben
• Re: MCONCAT
  • From: Gary Brown
• Re: Get rid of $ signs in formulas
  • From: Harlan Grove
• RE: Get rid of $ signs in formulas
  • From: Gary Brown
• Re: MCONCAT
  • From: Harlan Grove
• RE: Calculating dates of holidays
  • From: Gary Brown
• Re: MCONCAT
  • From: Dave Peterson
• Re: Entering changing months with a cell
  • From: T. Valko
• Re: Changing worksheet reference in a VLOOKUP
  • From: T. Valko
• Re: Calculating dates of holidays
  • From: Rick Rothstein \(MVP - VB\)
• RE: Calculating dates of holidays
  • From: Mike H
• Re: Excel Function - Date evaluation
  • From: Pete_UK
• Re: Changing worksheet reference in a VLOOKUP
  • From: Mark
• Calculating dates of holidays
  • From: mikelee101
• Create macro with button in excel spreadsheet
  • From: Lori
• RE: if statement syntax help
  • From: Mike H
• Re: use source formatting with protected worksheet
  • From: Gord Dibben
• Re: if statement syntax help
  • From: David Biddulph
• RE: if statement syntax help
  • From: OfficeManager
• Re: MCONCAT
  • From: Gary Brown
• RE: Generate list
  • From: dvya
• Re: if statement syntax help
  • From: T. Valko
• RE: Conditional Sum of cells
  • From: M Kan
• RE: Generate list
  • From: M Kan
• Re: MCONCAT
  • From: Ron Rosenfeld
• Generate list
  • From: dvya
• RE: Separating Strings
  • From: CJ
• Re: Separating Strings
  • From: T. Valko
• Re: Entering changing months with a cell
  • From: Loadmaster
• Pivot Table data
  • From: ahern79
• Re: Entering changing months with a cell
  • From: Loadmaster
• Conditional Sum of cells
  • From: ub
• Re: Printing with ""
  • From: Bernard Liengme
• change formula in a shared worksheet without losing change history
  • From: DCE
• RE: Vlookup on Dates
  • From: Graeme K Moore
• RE: Vlookup on Dates
  • From: Graeme K Moore
• Printing with ""
  • From: Alan12345
• Re: Multiples conditions in an array
  • From: Lea from CA
• Re: Entering changing months with a cell
  • From: Bernard Liengme
• Re: Expansion of COUNT if Question
  • From: PCLIVE
• Expansion of COUNT if Question
  • From: Adam
• Re: format a right justified zero filled field to a prn file
  • From: right justified and zero filled (excel)
• Adding duplicates...
  • From: accountant
• Re: format a right justified zero filled field to a prn file
  • From: right justified and zero filled (excel)
• RE: Vlookup on Dates
  • From: Graeme K Moore
• Re: Vlookup on Dates
  • From: recrit
• Re: month text in calculation
  • From: T. Valko
• Re: Entering changing months with a cell
  • From: T. Valko
• Re: Index, Large and Match??
  • From: Spiky
• Re: Entering changing months with a cell
  • From: Loadmaster
• Re: unhiding formulas
  • From: Spiky
• Insert Graphics File into Worksheet via Formula
  • From: rockfalls3
• Re: correct formula
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to change formula in shared sheet without loss of change histo
  • From: Rick Rothstein \(MVP - VB\)
• Re: calculate percentage of numbers <= zero in a given range
  • From: T. Valko
• Re: The hyperlink reference doesn't changes when I insert Rows and co.
  • From: d . louchbaum
• Re: calculate percentage of numbers <= zero in a given range
  • From: David Biddulph
• Re: certain time
  • From: T. Valko
• Re: calculate percentage of numbers <= zero in a given range
  • From: Pete_UK
• Re: month text in calculation
  • From: KUMPFfrog
• Re: month text in calculation
  • From: KUMPFfrog
• Re: Cell resizing
  • From: Kathleen
• RE: How to Create Macro to Increase Cell Value to one and Print Worksh
  • From: Gary''s Student
• Re: match, lookup two column data
  • From: KUMPFfrog
• calculate percentage of numbers <= zero in a given range
  • From: spowel4
• Re: Annual Leave automatic calculation
  • From: Tia
• Re: help text for user defined formula
  • From: WJvR
• Re: match, lookup two column data
  • From: KUMPFfrog
• Re: certain time
  • From: Karl Davidson
• Re: Vlookup on Dates
  • From: Pete_UK
• RE: MCONCAT
  • From: Gary Brown
• how to change formula in shared sheet without loss of change histo
  • From: DCE
• RE: Annual Leave automatic calculation
  • From: Gary Brown
• Re: IF function, nested with 2 source cells?
  • From: Spiky
• Re: Remove Rows That Are NOT Duplicates
  • From: Mongo the Magnificent
• Re: Entering changing months with a cell
  • From: Loadmaster
• Extracting data from Outlook to Excel using VBA
  • From: HBruno
• RE: Pivot Table Question
  • From: M Kan
• RE: Count items in range
  • From: Stefi
• IF
  • From: Mike H
• IF
  • From: John C
• Annual Leave automatic calculation
  • From: Tia
• IF
  • From: Karen6175
• How to Create Macro to Increase Cell Value to one and Print Worksheet
  • From: mdms515
• how do I set up or adjust my column chart?
  • From: Jerome
• Re: Use tab name in Vlook Up
  • From: AMH
• RE: Entering changing months with a cell
  • From: Mike H
• Re: Entering changing months with a cell
  • From: Bernard Liengme
• RE: Entering changing months with a cell
  • From: Mike H
• Re: Use tab name in Vlook Up
  • From: Don Guillett
• Pivot Table Question
  • From: Liz J
• MCONCAT
  • From: lehigh46
• Re: Use tab name in Vlook Up
  • From: AMH
• Re: Use tab name in Vlook Up
  • From: Bernard Liengme
• Re: Use tab name in Vlook Up
  • From: Don Guillett
• Use tab name in Vlook Up
  • From: AMH
• Re: I have year based data want to convert into weekly basis
  • From: Pete_UK
• Re: Replace mutiply sign *
  • From: Pete_UK
• why do I lose cell format in a pivot table?
  • From: Megglesface
• RE: Replace mutiply sign *
  • From: Mike H
• Re: sumproduct_zafar
  • From: Pete_UK
• Adding a sort to a working query asks for a parameter value
  • From: BRob
• sumproduct_zafar
  • From: vlook fomula
• print range is gray and i cannot change
  • From: peter
• RE: Removing Digit Separator
  • From: Dennis
• Re: Removing Digit Separator
  • From: David Biddulph
• Re: Date Calculation in Conditional Formatting
  • From: David Biddulph
• Re: unhiding formulas
  • From: Jan Bolluyt
• Re: Using IF and MAX functions together
  • From: Max
• Re: Retain font/cell color on lookup/copy
  • From: JE McGimpsey
• RE: Excel 2007 Lookup
  • From: Trish
• Re: Index, Large and Match??
  • From: Max
• Re: Can I Use a Count Function for Text?
  • From: JE McGimpsey
• RE: Excel filtering of split panes
  • From: M Kan
• RE: Exact Precedents
  • From: Shakeel
• Re: format a right justified zero filled field to a prn file
  • From: Rick Rothstein \(MVP - VB\)
• Re: Combine 6 Worksheets to 1 Worksheet with total amounts
  • From: Herbert Seidenberg
• Concatenate a formula
  • From: Steven
• Re: MATCH not working in IF statement
  • From: T. Valko
• Can I Use a Count Function for Text?
  • From: Sedmikraska
• Re: Make a cell not equal less than a certain number
  • From: T. Valko
• Re: certain time
  • From: T. Valko
• Re: Formulae stop working
  • From: T. Valko
• Re: format a right justified zero filled field to a prn file
  • From: Dave Peterson
• Re: Multiples conditions in an array
  • From: RagDyer
• Re: Multiples conditions in an array
  • From: Infinitogool
• Re: COLUMN & ROW EQUAL
  • From: RagDyer
• Re: MATCH not working in IF statement
  • From: yogart
• Re: Formulae stop working
  • From: daddylonglegs
• Re: match, lookup two column data
  • From: Lars-Åke Aspelin
• Re: Formulae stop working
  • From: T. Valko
• Re: match, lookup two column data
  • From: RagDyer
• Re: Comment insert
  • From: Infinitogool
• Re: month text in calculation
  • From: Lars-Åke Aspelin
• Re: month text in calculation
  • From: T. Valko
• Re: match, lookup two column data
  • From: KUMPFfrog
• Re: IF function, nested with 2 source cells?
  • From: Patrick R
• Re: Changing worksheet reference in a VLOOKUP
  • From: T. Valko
• Combine 6 Worksheets to 1 Worksheet with total amounts
  • From: Ms. D
• Re: match, lookup two column data
  • From: Lars-Åke Aspelin
• Re: IF function, nested with 2 source cells?
  • From: Spiky
• RE: Changing worksheet reference in a VLOOKUP
  • From: M Kan
• Changing worksheet reference in a VLOOKUP
  • From: Mark
• Re: I think I know how to ask this sumproduct question now:
  • From: M Kan
• Re: I think I know how to ask this sumproduct question now:
  • From: T. Valko
• Re: I think I know how to ask this sumproduct question now:
  • From: PCLIVE
• RE: Comment insert
  • From: THILL
• Re: Formulae stop working
  • From: Lars-Åke Aspelin
• Re: define name with 2 lists
  • From: Spiky
• Re: IF function, nested with 2 source cells?
  • From: Pete_UK
• Re: Remove Rows That Are NOT Duplicates
  • From: Gord Dibben
• Re: Remove Rows That Are NOT Duplicates
  • From: Lars-Åke Aspelin
• Re: Excel mobile help please
  • From: Peo Sjoblom
• Re: Remove Rows That Are NOT Duplicates
  • From: Pete_UK
• Re: invalid reference for vlookup
  • From: Pete_UK
• Re: counta
  • From: Gord Dibben
• Re: Pivot Table
  • From: Debra Dalgleish
• Re: Case Sensitivity in Lookup Functions
  • From: T. Valko
• Re: Case Sensitivity in Lookup Functions
  • From: Lars-Åke Aspelin
• Re: Really large files, not sure why
  • From: Gord Dibben
• Re: Case Sensitivity in Lookup Functions
  • From: Jan Bolluyt
• Re: Really large files, not sure why
  • From: Jan Bolluyt
• Re: Vertical lookup of pictures
  • From: Gord Dibben
• Re: How to count for 3 columns
  • From: T. Valko
• Re: VLOOKUP Question - Can I Keep the Same Aray with Drag?
  • From: T. Valko
• How to count for 3 columns
  • From: Mysa
• Re: MATCH not working in IF statement
  • From: T. Valko
• RE: How best to use sumproduct instead of conditional sum:
  • From: Gina
• Re: Copies From The Internet
  • From: Spiky
• Re: How to use a range name in a macro
  • From: Bob Phillips
• Re: Copies From The Internet
  • From: lehigh46
• Re: Data Validation Question
  • From: T. Valko
• Re: MATCH not working in IF statement
  • From: yogart
• Re: append column data
  • From: Gord Dibben
• Copies From The Internet
  • From: lehigh46
• Re: Nested if using range names
  • From: Bernard Liengme
• Re: How do I copy cells containing drop downs?
  • From: Gord Dibben
• Re: Dates - Custom - Pos Pay Format
  • From: Rick Rothstein \(MVP - VB\)
• Re: use source formatting with protected worksheet
  • From: Gord Dibben
• Re: Dates - Custom - Pos Pay Format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Pos Pay
  • From: T. Valko
• RE: How do I copy specific information from a master sheet?
  • From: Gary''s Student
• Re: Linking formulas between several woorkbooks
  • From: Spiky
• Re: Using COUNTA for a variable array
  • From: T. Valko
• RE: Purchase Order Form
  • From: Ice Man
• Re: match, lookup two column data
  • From: Lars-Åke Aspelin
• Re: match, lookup two column data
  • From: RagDyeR
• Re: why do I get an error message when i try to merge cells?
  • From: Gord Dibben
• Re: Vertical lookup of pictures
  • From: DJDKAL
• Re: Vertical lookup of pictures
  • From: DJDKAL
• RE: How best to use sumproduct instead of conditional sum:
  • From: Teethless mama
• Re: How do I copy cells containing drop downs?
  • From: Otto Moehrbach
• Conditional Hyperlinking
  • From: PurchaseGuy
• Re: Vertical lookup of pictures
  • From: Gord Dibben
• Re: Conditional formula
  • From: Gord Dibben
• Re: append column data
  • From: Rick Rothstein \(MVP - VB\)
• Re: Autofill reference formula but repeating n times before increm
  • From: RagDyeR
• Re: need help formating a cell
  • From: Gord Dibben
• Re: Vertical lookup of pictures
  • From: Ken Johnson
• Re: Retain font/cell color on lookup/copy
  • From: Pete_UK
• Re: Conditional Format - Hide/Unhide
  • From: robzrob
• Re: Conditional Format - Hide/Unhide
  • From: Pete_UK
• Re: conditional formatting #
  • From: Spiky
• Conditional Format - Hide/Unhide
  • From: robzrob
• Re: Conditional Formatting Question
  • From: mommatee
• Re: Conditional Formatting Question
  • From: Rick Rothstein \(MVP - VB\)
• Re: grouping cells
  • From: Spiky
• RE: =If(A1:D1="Pass","Y","N")
  • From: Teethless mama
• Conditional Formatting Question
  • From: mommatee
• RE: VLOOKUP? SUMPRODUCT? not sure how to do this
  • From: Mike H
• Re: Vertical lookup of pictures
  • From: DJDKAL
• Re: =If(A1:D1="Pass","Y","N")
  • From: Lars-Åke Aspelin
• Re: =If(A1:D1="Pass","Y","N")
  • From: Pete_UK
• =If(A1:D1="Pass","Y","N")
  • From: Gaurav
• RE: VLOOKUP? SUMPRODUCT? not sure how to do this
  • From: Gambit-6
• Re: why do I get an error message when i try to merge cells?
  • From: Megglesface
• Re: formulas
  • From: Susan
• Re: why do I get an error message when i try to merge cells?
  • From: Susan
• Re: Using COUNTA for a variable array
  • From: Schannah
• RE: Using COUNTA for a variable array
  • From: Schannah
• Re: If, Lookup, Match or a combination of all
  • From: Lars-Åke Aspelin
• Re: If, Lookup, Match or a combination of all
  • From: Bob Phillips
• Re: If, Lookup, Match or a combination of all
  • From: Lars-Åke Aspelin
• If, Lookup, Match or a combination of all
  • From: Beverly Darvill
• Re: Make a cell not equal less than a certain number
  • From: Karl Davidson
• Re: EXCEL Formula Microsoft Product ID
  • From: Nayab
• Re: I want help to fill data of sheet 2 in sheet 1
  • From: Lars-Åke Aspelin
• Re: Combining data from 2 sheets - advanced help please
  • From: Lars-Åke Aspelin
• Combining data from 2 sheets - advanced help please
  • From: Mark
• Re: Autofill reference formula but repeating n times before increm
  • From: Anton
• Re: Make a cell not equal less than a certain number
  • From: T. Valko
• Re: EXCEL Formula Microsoft Product ID
  • From: JE McGimpsey
• Re: MATCH not working in IF statement
  • From: T. Valko
• Re: Conditional Formatting
  • From: Joerg Mochikun
• RE: Excel 2007 Lookup
  • From: M Kan
• Re: Autofill reference formula but repeating n times before incrementi
  • From: RagDyeR
• Re: Autofill reference formula but repeating n times before incrementi
  • From: T. Valko
• RE: IF Function Question
  • From: FSt1
• Re: Cell on Cell interaction help
  • From: T. Valko
• Re: Make a cell not equal less than a certain number
  • From: T. Valko
• Re: Incorporating Cell color fill in an "if" logical function?
  • From: T. Valko
• RE: Excel 2007 Lookup
  • From: Trish
• Re: Vertical lookup of pictures
  • From: Ken Johnson
• RE: Excel 2007 Lookup
  • From: M Kan
• Re: Row reference formula not working with a VLookup
  • From: RagDyer
• Re: If and/or Look Up function
  • From: Pete_UK
• Re: TRUE/FALSE function in IF statement
  • From: Bob Phillips
• Re: Incorporating Cell color fill in an "if" logical function?
  • From: Shawn
• Re: Need a Formula to Calculate the Area -Simpson Rule
  • From: Jarek Kujawa
• Re: rounding problems
  • From: joeu2004
• Re: Count items in range
  • From: Bob Phillips
• Multiple if statements based on two columns of information
  • From: Elizabeth
• Re: Max function
  • From: Ryan
• RE: Max function
  • From: Ryan
• Re: Mid Statements
  • From: Rick Rothstein \(MVP - VB\)
• Re: Row reference formula not working with a VLookup
  • From: Spiky
• Re: Convert Indirect row reference
  • From: Dave Peterson
• Re: Incorporating Cell color fill in an "if" logical function?
  • From: T. Valko
• Re: Row reference formula not working with a VLookup
  • From: RagDyer
• RE: Count items in range
  • From: TWhizTom
• Re: Max function
  • From: T. Valko
• RE: Conditional Formatting
  • From: TWhizTom
• Re: Convert Indirect row reference
  • From: Harry Stevens
• Re: Mid Statements
  • From: RagDyer
• Conditional Formatting
  • From: PRS1114
• Re: How do I export report and have info appear on 1 line?
  • From: Otto Moehrbach
• RE: NOTES FOR A CELL
  • From: Wigi
• RE: grouping cells
  • From: M Kan
• RE: [XL07] Conditionally format fill color for entire row
  • From: TWhizTom
• Re: Count items in range
  • From: Steven
• Re: [XL07] Conditionally format fill color for entire row
  • From: Bernard Liengme
• Search/Match/Find ANY part of string to ANY part of Cell Value
  • From: TWhizTom
• grouping cells
  • From: johnrb7865
• Re: This formula can not work in Excel 2007
  • From: Ron Rosenfeld
• Re: Count items in range
  • From: Steven
• Re: If and/or Look Up function
  • From: Pete_UK
• [XL07] Conditionally format fill color for entire row
  • From: Trevor Stone
• How do I export report and have info appear on 1 line?
  • From: Jackson
• Re: Convert Indirect row reference
  • From: Dave Peterson
• Re: Help with Functions (IF)
  • From: Spiky
• Re: Max function
  • From: Ryan
• compare cells in column to criteria, then average next column cell
  • From: Bradwin
• Re: Convert Indirect row reference
  • From: Harry Stevens
• Re: VBA Help
  • From: Marino M
• If and/or Look Up function
  • From: Maureen
• RE: rounding problems
  • From: Gary Brown
• Re: Prevent alpha character from being entered into a numeric field
  • From: Reitanos
• Re: Can I Use a Count Function for Text?
  • From: T. Valko
• Re: Counting rows that meet conditions in multiple columns
  • From: belleinhell
• VBA Help
  • From: Marino M
• Re: rounding problems
  • From: Bernard Liengme
• RE: Help with Functions (IF)
  • From: StumpedAgain
• Re: Max function
  • From: T. Valko
• Help with Functions (IF)
  • From: Melissa
• Re: Time query
  • From: Glenn
• Re: Need a Formula to Calculate the Area -Simpson Rule
  • From: Spiky
• Re: Filling speadsheet with INDIRECT functions?
  • From: Max
• RE: Purchase Order Form
  • From: John C
• Re: Long If Statement
  • From: Harlan Grove
• Purchase Order Form
  • From: Ice Man
• Re: Sorting out negative numbers
  • From: Spiky
• Re: Long If Statement
  • From: Lars-Åke Aspelin
• Vlookup based on 2 criteria
  • From: Alex
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: Long If Statement
  • From: Bernard Liengme
• RE: SumProduct Question
  • From: M Kan
• Re: Lotus 123 has a function called "rvbalance", does excel have?
  • From: Bernard Liengme
• RE: Drop down lists and macros
  • From: Gary Brown
• Re: Conditional formula
  • From: Mindy
• Re: Count items in range
  • From: Bob Phillips
• Re: Drop down lists and macros
  • From: JP
• Re: Count items in range
  • From: Stefi
• Re: copy and paste not functioning, think clipboard problem
  • From: Susan
• Re: Count items in range
  • From: Infinitogool
• Re: help text for user defined formula
  • From: Niek Otten
• Re: Multiply with conditions
  • From: Bob Phillips
• Re: sumproduct
  • From: Bob Phillips
• Re: Count items in range
  • From: Bob Phillips
• copy and paste not functioning, think clipboard problem
  • From: Jane, UK
• Re: Count items in range
  • From: Bob Phillips
• RE: Aouto filter by macro
  • From: Stefi
• Re: Excel Formulae 'Help'
  • From: Pete_UK
• Re: Count items in range
  • From: Bob Phillips
• Re: Count items in range
  • From: Jarek Kujawa
• Re: need help formating a cell
  • From: Jarek Kujawa
• Re: need help formating a cell
  • From: Jarek Kujawa
• RE: Exact Precedents
  • From: Abdul Shakeel
• Re: Convert Indirect row reference
  • From: Dave Peterson
• Convert Indirect row reference
  • From: Harry Stevens
• Re: Any ideas why a reference that works will in 2003 has problems in
  • From: T. Valko
• Re: Lookup Function
  • From: Dave Peterson
• Re: Excel Formulae 'Help'
  • From: FootballvBlues
• Re: Custom functions
  • From: Palpha32
• Lookup Function
  • From: Aequo79
• Re: Conditional Average
  • From: T. Valko
• Re: Excel mobile help please
  • From: Terry
• Drop down lists and macros
  • From: lost and confused in excel-land
• Re: Conditional Average
  • From: Eki75
• Re: Conditional Average
  • From: T. Valko
• Re: Conditional Average
  • From: daddylonglegs
• Re: Formula Returning Records # of Days from Today in Excel
  • From: Ragdyer
• Re: Conditional Average
  • From: Eki75
• Re: Conditional Average
  • From: Bernard Liengme
• Re: Conditional Average
  • From: Bernard Liengme
• Re: Conditional Average
  • From: T. Valko
• Conditional Average
  • From: Eki75
• Re: Sort excel columns as a function
  • From: Gord Dibben
• Re: Returning a value based on a query
  • From: T. Valko
• RE: Columns into 2 way tables
  • From: Billy Liddel
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLAN
  • From: T. Valko
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLAN
  • From: Ron Rosenfeld
• Re: I Need An Argument
  • From: Otto Moehrbach
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLAN
  • From: Morton Detwyler
• RE: Returning a value based on a query
  • From: Gail
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLAN
  • From: Morton Detwyler
• Re: Excel Function
  • From: joeu2004
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLAN
  • From: Morton Detwyler
• RE: Returning a value based on a query
  • From: Gail
• Re: Sorting columns into a table
  • From: Per Jessen
• Sorting columns into a table
  • From: Christian
• Re: how do I copy automatically from one worksheet to another
  • From: Don Guillett
• Re: how do I copy automatically from one worksheet to another
  • From: Bernard Liengme
• RE: I Need An Argument
  • From: newdeas
• Re: sumproduct with wildcard for text?
  • From: Bob Phillips
• Re: Need a Formula to Calculate the Area -Simpson Rule
  • From: Lars-Åke Aspelin
• Sorting
  • From: Eamon
• Re: sumproduct with wildcard for text?
  • From: Jarek Kujawa
• Re: sumproduct with wildcard for text?
  • From: Per Jessen
• Re: Letter Replace Help!!
  • From: James8309
• RE: Letter Replace Help!!
  • From: Mike H
• Re: Letter Replace Help!!
  • From: Jarek Kujawa
• Letter Replace Help!!
  • From: James8309
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
  • From: T. Valko
• Re: Excel Formulae 'Help'
  • From: Pete_UK
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
  • From: Ron Rosenfeld
• Re: Locking cells with formulas
  • From: Gord Dibben
• Re: Locking cells with formulas
  • From: Gord Dibben
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
  • From: Lars-Åke Aspelin
• Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
  • From: Lars-Åke Aspelin
• Re: Stuck in a Sub Loop
  • From: robzrob
• Re: Stuck in a Sub Loop
  • From: Gord Dibben
• Re: Stuck in a Sub Loop
  • From: robzrob
• Re: Stuck in a Sub Loop
  • From: Don Guillett
• Re: Excel Formulae 'Help'
  • From: FootballvBlues
• Stuck in a Sub Loop
  • From: robzrob
• Re: Excel mobile help please
  • From: Terry
• Re: How do I freeze column names to view when scrolling?
  • From: Gord Dibben
• Re: change order of 5 letter word based on another cell containing 5 numbers
  • From: Ron Rosenfeld
• Re: change order of 5 letter word based on another cell containing 5 numbers
  • From: Forum Freak
• Re: change order of 5 letter word based on another cell containing 5 numbers
  • From: Forum Freak
• Re: change order of 5 letter word based on another cell containing 5 numbers
  • From: Lars-Åke Aspelin
• Re: Any ideas why a reference that works will in 2003 has problems in
  • From: Ron Rosenfeld
• Re: change order of 5 letter word based on another cell containing 5 numbers
  • From: Ron Rosenfeld
• Re: Any ideas why a reference that works will in 2003 has problems in
  • From: T. Valko
• change order of 5 letter word based on another cell containing 5 numbers
  • From: Forum Freak
• Re: How do I freeze column names to view when scrolling?
  • From: Mary
• Re: How do I freeze column names to view when scrolling?
  • From: Gord Dibben
• Re: Sum Of Last Three Entries In Rotating Columns
  • From: Peo Sjoblom
• Re: Excel mobile help please
  • From: Terry
• Re: Excel mobile help please
  • From: Peo Sjoblom
• Excel mobile help please
  • From: Terry
• Re: 40 sheets/Formula to advance to next worksheet
  • From: Don Guillett
• Re: separating numbers from text
  • From: Ron Rosenfeld
• can you link an excel workbook to a live word doc
  • From: Dave Gerecke
• Re: Using IF and MAX functions together
  • From: Lars-Åke Aspelin
• Re: How do I freeze column names to view when scrolling?
  • From: Mary
• RE: Exact Precedents
  • From: Billy Liddel
• Re: Excel Formulae
  • From: Pete_UK
• Re: Excel Formulae 'Help'
  • From: Pete_UK
• RE: Aouto filter by macro
  • From: nader
• RE: Columns into 2 way tables
  • From: Christian
• Re: Auto updates with checkbox that affects total
  • From: NoodNutt
• Re: Countifs with same reference?
  • From: Harlan Grove
• Want to add help file for custom function but excel 2007 is flaked
  • From: Sabotuer99
• Excel Formulae
  • From: FootballvBlues
• Excel Formulae 'Help'
  • From: FootballvBlues
• Re: Scoring Formula helop
  • From: MyVeryOwnSelf
• Re: Need help with a multiple criteria formula
  • From: Pete_UK
• Re: Referencing Checkbox Names
  • From: Dave Peterson
• Re: Vlookup problem
  • From: Pete_UK
• RE: Vlookup problem
  • From: Belinda7237
• Re: Keyboard shortcut for Paste Special-Values
  • From: RagDyer
• Re: Sum and If Function Problem with Excel 2007
  • From: T. Valko
• Re: How do I freeze column names to view when scrolling?
  • From: Gord Dibben
• Re: Count instances of text in date entries
  • From: RagDyer
• Re: Countifs with same reference?
  • From: Per Jessen
• Re: Complex Conditional
  • From: PAL
• Re: VLOOKUP Keeps Returning #N/A
  • From: Niek Otten
• RE: VLOOKUP Keeps Returning #N/A
  • From: Ric_M
• Re: Count instances of text in date entries
  • From: MilusC
• Re: Excel - Compare spreadsheets and indicate matched data
  • From: debvan
• Re: VLOOKUP Keeps Returning #N/A
  • From: Niek Otten
• Re: Keyboard shortcut for Paste Special-Values
  • From: Mark
• Re: Sum and If Function Problem with Excel 2007
  • From: David
• Re: Complex Conditional
  • From: PAL
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• Re: Count instances of text in date entries
  • From: RagDyer
• Re: Count instances of text in date entries
  • From: Peo Sjoblom
• Re: How do I SUM multiple results from a VLOOKUP?
  • From: Bernard Liengme
• RE: How do I SUM multiple results from a VLOOKUP?
  • From: M Kan
• Re: Excel 2003 - Copy Down Function to Reference Next Worksheet
  • From: RagDyer
• RE: Columns into 2 way tables
  • From: Christian
• RE: Columns into 2 way tables
  • From: Christian
• Re: Analysis Toolpak
  • From: Spiky
• Re: Cant use indirect() and dynamic ranges together?
  • From: John C
• Re: Add top numbers
  • From: RagDyer
• Re: Excel not converting file
  • From: Otto Moehrbach
• Re: past cell by date
  • From: Pete_UK
• Re: Counting rows that meet conditions in multiple columns
  • From: Peo Sjoblom
• RE: Need help with a multiple criteria formula
  • From: butterfly
• Re: Alpha conditional statements
  • From: Peo Sjoblom
• past cell by date
  • From: Tony
• Re: Cell resizing
  • From: Spiky
• Re: fixed asset life table
  • From: Spiky
• Re: Excel 2003 - Copy Down Function to Reference Next Worksheet
  • From: T. Valko
• Re: Columns into 2 way tables
  • From: T. Valko
• Re: How do I freeze column names to view when scrolling?
  • From: Mary
• RE: Date Function needed
  • From: Gary''s Student
• Re: Sum and If Function Problem with Excel 2007
  • From: T. Valko
• Date Function needed
  • From: smonczka
• Re: Alpha conditional statements
  • From: Peo Sjoblom
• Re: Can I Use a Count Function for Text?
  • From: Spiky
• Re: Analysis Toolpak
  • From: Gord Dibben
• Re: Analysis Toolpak
  • From: Peo Sjoblom
• RE: Sum from a Drop down menu using value in the cell below
  • From: John C
• Re: Sum from a Drop down menu using value in the cell below
  • From: Kat
• Re: Count functions with multiple conditions/ranges
  • From: Peo Sjoblom
• RE: Sum from a Drop down menu using value in the cell below
  • From: Kat
• Analysis Toolpak
  • From: Spiky
• Re: Excel - Compare spreadsheets and indicate matched data
  • From: Peo Sjoblom
• RE: Sum from a Drop down menu using value in the cell below
  • From: John C
• Re: Sum from a Drop down menu using value in the cell below
  • From: Peo Sjoblom
• Re: Time query
  • From: Glenn
• Re: Cant use indirect() and dynamic ranges together?
  • From: RagDyeR
• Re: Connecting multiple IF THEN formulas in one cell
  • From: RagDyeR
• Re: Time query
  • From: Glenn
• Re: help with function/formula
  • From: Max
• Re: Mutually exclusive cells - Excel 2003
  • From: Spiky
• Re: Locking Cell through Validation
  • From: Max
• Re: Hyperlink Function
  • From: Max
• RE: Do nothing if False!
  • From: Jennifer B
• Re: Sum and If Function Problem with Excel 2007
  • From: Bob Phillips
• Re: Sum from a Drop down menu using value in the cell below
  • From: Jarek Kujawa
• Re: Help in formula
  • From: Bob Phillips
• Re: how to format a complex number
  • From: Jan Bolluyt
• Re: No more rows...??
  • From: Fred Smith
• Re: Focus on a cell based on date
  • From: Jarek Kujawa
• Re: Focus on a cell based on date
  • From: Fred Smith
• RE: Focus on a cell based on date
  • From: Dave
• Focus on a cell based on date
  • From: dave . castle
• RE: No more rows...??
  • From: RET615GA
• how to combine Logical if and Vlook up
  • From: vmohan1978
• Re: Excel Documents
  • From: Ivan
• RE: Exact Precedents
  • From: Abdul Shakeel
• RE: worksheet functions
  • From: Stefi
• Re: worksheet functions
  • From: Jarek Kujawa
• RE: Columns into 2 way tables
  • From: Billy Liddel
• Re: =If( statement for 80-90% condition then write "ME"
  • From: Jarek Kujawa
• RE: Exact Precedents
  • From: Abdul Shakeel
• Re: =If( statement for 80-90% condition then write "ME"
  • From: MartinW
• Re: =If( statement for 80-90% condition then write "ME"
  • From: Jarek Kujawa
• =If( statement for 80-90% condition then write "ME"
  • From: Master T
• RE: Do nothing if False!
  • From: Dave
• Re: Need to remove text with strikethrough - Excel 2007
  • From: Jarek Kujawa
• Re: Hyperlink Function
  • From: Dave Peterson
• Re: Blank date column return datel 00-Jan-00
  • From: Frank Situmorang
• Re: This formula can not work in Excel 2007
  • From: Frank Situmorang
• Re: Blank date column return datel 00-Jan-00
  • From: T. Valko
• Re: how to sort addresses in microsoft excel
  • From: recrit
• Re: how to sort addresses in microsoft excel
  • From: recrit
• Re: Negative time numbers
  • From: Fred Smith
• Re: Complex Conditional
  • From: T. Valko
• Re: Formula for Next Sheet and Every Other Cell
  • From: misteremanca
• Re: Hyperlink Function
  • From: Gord Dibben
• Re: Do nothing if False!
  • From: Gord Dibben
• Re: This formula can not work in Excel 2007
  • From: Ron Rosenfeld
• Re: Formula for Next Sheet and Every Other Cell
  • From: Gord Dibben
• Re: Hyperlink Function
  • From: Max
• Re: VLookup is not working correctly
  • From: Dave Peterson
• Re: Do nothing if False!
  • From: Dave Peterson
• Re: Can I copy a field from another spreadsheet based on search?
  • From: Pete_UK
• Re: Formula for Next Sheet and Every Other Cell
  • From: misteremanca
• Re: VLookup is not working correctly
  • From: T. Valko
• Re: VLookup is not working correctly
  • From: Ron Rosenfeld
• Re: semi-interquartile range function?
  • From: Infinitogool
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• Re: whats the formula
  • From: Gord Dibben
• Re: Sliding commission rates in excel
  • From: joeu2004
• Re: Formula for Next Sheet and Every Other Cell
  • From: Gord Dibben
• Re: emailing active sheet with macro
  • From: Ron de Bruin
• Re: How do I insert a work sheet populated with data into another?
  • From: Gord Dibben
• Re: Cell resizing
  • From: Kathleen
• Re: text outside merge cells despite clicking wrap text
  • From: Kathleen
• Re: Formula for Next Sheet and Every Other Cell
  • From: misteremanca
• Re: My formula returns a result but the cell displays a zero?
  • From: Wayne
• Re: VLOOKUP and HLOOKUP
  • From: Jan Bolluyt
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• Re: Cant use indirect() and dynamic ranges together?
  • From: RagDyer
• Re: My formula returns a result but the cell displays a zero?
  • From: Rick Rothstein \(MVP - VB\)
• Re: VLOOKUP and HLOOKUP
  • From: Dave Peterson
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• RE: My formula returns a result but the cell displays a zero?
  • From: Wayne
• Re: Cant use indirect() and dynamic ranges together?
  • From: RagDyer
• RE: My formula returns a result but the cell displays a zero?
  • From: Wayne
• Re: Formula Question
  • From: Bob Phillips
• Re: Conditional Formatting on empty cells
  • From: T. Valko
• RE: update a sheet automatically with changing values from another she
  • From: J Sedoff
• Re: Need to remove text with strikethrough - Excel 2007
  • From: HD
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• Re: Cant use indirect() and dynamic ranges together?
  • From: T. Valko
• Re: Connecting multiple IF THEN formulas in one cell
  • From: Peter P
• Re: SUMIF sum range
  • From: T. Valko
• Re: Macro for Edit/Copy/Paste Special
  • From: icanlearn via OfficeKB.com
• Re: Conditional Formatting on empty cells
  • From: mgccoop
• Re: Conditional Formatting on empty cells
  • From: T. Valko
• Re: Cant use indirect() and dynamic ranges together?
  • From: Bob Phillips
• Re: Conditional Formatting on empty cells
  • From: T. Valko
• Re: Connecting multiple IF THEN formulas in one cell
  • From: RagDyer
• Cant use indirect() and dynamic ranges together?
  • From: nashism
• RE: How to add a prefix to a column of numbers in an excel document?
  • From: J Sedoff
• Pivot Table, Calculated Field, Running Total
  • From: Valeri
• Re: Conditional Formatting on empty cells
  • From: mgccoop
• Re: Complex Conditional
  • From: PAL
• Re: Complex Conditional
  • From: PAL
• Re: past date cell colour change
  • From: flasherr
• RE: Connecting multiple IF THEN formulas in one cell
  • From: Peter P
• Re: Conditional Formatting on empty cells
  • From: T. Valko
• Re: Formula Help
  • From: Peo Sjoblom
• Re: Complex Conditional
  • From: T. Valko
• Re: Formula Help
  • From: Peo Sjoblom
• Re: Can I Use a Count Function for Text?
  • From: T. Valko
• Re: SUMIF sum range
  • From: Rick Rothstein \(MVP - VB\)
• Re: Complex Conditional
  • From: PAL
• Re: count occurences meeting criteria
  • From: T. Valko
• Re: SUMIF sum range
  • From: T. Valko
• Re: Complex Conditional
  • From: T. Valko
• Re: SUMIF sum range
  • From: RagDyeR
• Re: semi-interquartile range function?
  • From: pjkaraffa
• Re: count occurences meeting criteria
  • From: Rick Rothstein \(MVP - VB\)
• Re: Advanced sorting
  • From: RagDyeR
• RE: Vlookup or getpivot? two entries
  • From: LAB
• Re: count occurences meeting criteria
  • From: geebee
• Re: Complex Conditional
  • From: PAL
• Re: count occurences meeting criteria
  • From: Rick Rothstein \(MVP - VB\)
• Re: count occurences meeting criteria
  • From: Fred Smith
• Advanced sorting
  • From: Gerben Dirksen
• Re: count occurences meeting criteria
  • From: Rick Rothstein \(MVP - VB\)
• Re: Need to remove text with strikethrough - Excel 2007
  • From: Rick Rothstein \(MVP - VB\)
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: John C
• Re: count occurences meeting criteria
  • From: Rick Rothstein \(MVP - VB\)
• RE: Need a formula
  • From: Darrell_Sarrasin via OfficeKB.com
• Re: SEPARAT NUMBERS FROM TEXT
  • From: Ron Rosenfeld
• Re: SEPARAT NUMBERS FROM TEXT
  • From: Rick Rothstein \(MVP - VB\)
• Re: Problem with "Currency Convert to Text"
  • From: Rick Rothstein \(MVP - VB\)
• RE: Aouto filter by macro
  • From: Stefi
• Re: Need to remove text with strikethrough - Excel 2007
  • From: Jarek Kujawa
• Re: RANGE addresses. Getting from other cells.
  • From: Bob Phillips
• Re: Custom functions
  • From: Rick Rothstein \(MVP - VB\)
• Need to remove text with strikethrough - Excel 2007
  • From: HD
• Re: RANGE addresses. Getting from other cells.
  • From: Jarek Kujawa
• automatic inserting the values
  • From: stremetzky
• Re: Calculating percentage complete
  • From: David Biddulph
• Re: Sliding commission rates in excel
  • From: David Biddulph
• Re: how to get the answers from 3 conditions
  • From: David Biddulph
• Re: Custom functions
  • From: Palpha32
• Re: Custom functions
  • From: Rick Rothstein \(MVP - VB\)
• Re: Custom functions
  • From: Palpha32
• Re: Formula help
  • From: Jan
• Sliding commission rates in excel
  • From: dene . coleman
• Re: Count cells based on whether another cell is blank or not
  • From: Max
• Re: Count cells based on whether another cell is blank or not
  • From: luvnrocs
• Calculating percentage complete
  • From: Daisy
• Re: Why QUOTIENT function is not being recognized?
  • From: Ron Rosenfeld
• Re: Why QUOTIENT function is not being recognized?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Why QUOTIENT function is not being recognized?
  • From: Ron Rosenfeld
• Re: What is the math divide funtion in Excell?
  • From: Ron Rosenfeld
• Re: Count cells based on whether another cell is blank or not
  • From: Max
• Re: Tabs
  • From: Max
• Re: Count cells based on whether another cell is blank or not
  • From: Rick Rothstein \(MVP - VB\)
• RE: Conditional Formatting: Adding more then 3
  • From: ryguy7272
• RE: Vlookup problem
  • From: ryguy7272
• RE: Vlookup or getpivot? two entries
  • From: ryguy7272
• RE: Using Table Column Data in MATCH
  • From: ryguy7272
• Re: Count cells based on whether another cell is blank or not
  • From: Max
• Re: text outside merge cells despite clicking wrap text
  • From: Gord Dibben
• Re: color change after date
  • From: Bob Phillips
• Re: Question on the countif function and times
  • From: Bob Phillips
• Count cells based on whether another cell is blank or not
  • From: luvnrocs
• Re: Cell resizing
  • From: Gord Dibben
• Re: semi-interquartile range function?
  • From: Niek Otten
• Re: Cell resizing
  • From: Gord Dibben
• color change after date
  • From: flasherr
• past date cell colour change
  • From: flasherr
• Need a formula
  • From: Darrell_Sarrasin via OfficeKB.com
• Re: Conditional Formatting: Adding more then 3
  • From: Gord Dibben
• Re: need formula to apply to entire column not just one line
  • From: Gord Dibben
• Re: Counting a range of cells
  • From: T. Valko
• Re: blank date shows up as s 1/0/00
  • From: T. Valko
• Re: Complex Conditional
  • From: T. Valko
• Re: Define fiscal year
  • From: Herbert Seidenberg
• Re: Sumproduct with If
  • From: Marcelo
• Re: HOW TO CREATE AN ARCHITECTURAL NUMBER FORMAT
  • From: Bernard Liengme
• Re: Selecting the latest date reference
  • From: RagDyer
• Re: Sumproduct with If
  • From: David Biddulph
• Re: Question on the countif function and times
  • From: Bob Phillips
• Re: Macro for Edit/Copy/Paste Special
  • From: Susan
• RE: Min +1
  • From: PAL
• Re: text outside merge cells despite clicking wrap text
  • From: Kathleen
• RE: Min +1
  • From: John C
• RE: Macro for Edit/Copy/Paste Special
  • From: icanlearn
• Re: Sumproduct with If
  • From: Glenn
• RE: Vlookup problem
  • From: Mike H
• RE: Vlookup problem
  • From: Mike H
• Re: SORTING WORKSHEETS?
  • From: Peo Sjoblom
• Vlookup problem
  • From: Belinda7237
• Re: Selecting the latest date reference
  • From: Shams
• Re: Cell resizing
  • From: Kathleen
• Macro for Edit/Copy/Paste Special
  • From: icanlearn
• Re: Cell resizing
  • From: Kathleen
• RE: Date of worksheet comes out numbers on other linked worksheet
  • From: Mike H
• Re: Sumproduct with If
  • From: Harlan Grove
• Re: Selecting the latest date reference
  • From: RagDyer
• Re: Data lookup function
  • From: JL Taylor
• Re: Sumproduct with If
  • From: Marcelo
• Re: Can't view all text in a cell
  • From: Spiky
• Re: Workdays/Networkdays #Name? Error
  • From: Niek Otten
• Re: Workdays/Networkdays #Name? Error
  • From: Niek Otten
• Re: Workdays/Networkdays #Name? Error
  • From: Niek Otten
• Re: Selecting the latest date reference
  • From: Shams
• Re: Sumproduct with If
  • From: Glenn
• Re: PivotTable Grand Total Error using Calculated Field
  • From: Debra Dalgleish
• Re: DATABASE REACHED MAXIMUM SIZE
  • From: Spiky
• Re: Workdays/Networkdays #Name? Error
  • From: K
• Re: how do I Count number of records beteen two dates- Excell 2007
  • From: T. Valko
• Re: Sumproduct with If
  • From: Glenn
• RE: applying formulas for all sheets selected
  • From: Gary Brown
• RE: Sumproduct with If
  • From: Marcelo
• Sumproduct
  • From: googley
• Re: Finding cells with a value ending in '.0'
  • From: Rick Rothstein \(MVP - VB\)
• Re: Workdays/Networkdays #Name? Error
  • From: Niek Otten
• RE: Sumproduct with If
  • From: Angie
• Re: Sumproduct with If
  • From: T. Valko
• RE: Sumproduct with If
  • From: Marcelo
• RE: applying formulas for all sheets selected
  • From: emilr17
• Re: Sumproduct with If
  • From: David Biddulph
• Re: How do I calculate the mode for a column of text?
  • From: T. Valko
• Re: Conditional formatting to a different cell and it contains a formula
  • From: T. Valko
• Re: Workdays/Networkdays #Name? Error
  • From: Dave Peterson
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: Selecting the latest date reference
  • From: RagDyeR
• Re: Sumproduct with If
  • From: Glenn
• Re: How do I create macro to add 8 rows at a time?
  • From: Glenn
• RE: Paste Special
  • From: MichaelRobert
• RE: Sumproduct with If
  • From: StumpedAgain
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: John C
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: Selecting the latest date reference
  • From: Shams
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: John C
• Re: Spreadsheet
  • From: Niek Otten
• RE: Paste Special
  • From: MichaelRobert
• applying formulas for all sheets selected
  • From: emilr17
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: Chronological Numbering
  • From: Peo Sjoblom
• Re: Selecting the latest date reference
  • From: RagDyeR
• Re: Can't view all text in a cell
  • From: Dave Peterson
• Re: Hyperlink Function
  • From: Dave Peterson
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: Selecting the latest date reference
  • From: RagDyeR
• Re: Time query
  • From: Glenn
• Re: Workdays/Networkdays #Name? Error
  • From: Dave Peterson
• Re: Inserting Function blanks adjoioning cell
  • From: Spiky
• Re: Sum the amount of times a number appears in a column in Excel?
  • From: Glenn
• RE: Data Validation - select AcctName and AcctCodes shows
  • From: John C
• Re: Chronological Numbering
  • From: Bernard Liengme
• Re: multi-if then formula i think
  • From: Ann
• RE: Time query
  • From: Ber
• Re: text in mm:ss to time
  • From: David Biddulph
• Re: how do I Count number of records beteen two dates- Excell 2007
  • From: Bob Phillips
• Re: multi-if then formula i think
  • From: Bob Phillips
• Re: Hyperlink Function
  • From: Max
• Non-table look ups
  • From: Rich Mogy
• Re: Hyperlink Function
  • From: Max
• Re: keep track of phone numbers
  • From: Eamon
• Re: Time query
  • From: Ber
• Re: Define fiscal year
  • From: Fred Smith
• Re: Conditional formatting to a different cell and it contains a formula
  • From: Rick
• Re: Workdays/Networkdays #Name? Error
  • From: Fred Smith
• RE: Paste Special
  • From: Gary''s Student
• Re: Macro To Make Workbook Demonstrate Itself
  • From: robzrob
• Data Validation - select AcctName and AcctCodes shows
  • From: SJAdams4444
• Re: how to get the answers from 3 conditions
  • From: robzrob
• Re: Locking Cell through Validation
  • From: Max
• Re: Macro To Make Workbook Demonstrate Itself
  • From: Bob Phillips
• Macro To Make Workbook Demonstrate Itself
  • From: robzrob
• How to set the enter key to move every 2 rows instead of one row
  • From: PhyllisTheCat
• how to get the answers from 3 conditions
  • From: Chiran
• Re: This formula can not work in Excel 2007
  • From: Ron Rosenfeld
• Re: This formula can not work in Excel 2007
  • From: Jarek Kujawa
• RE: Count Function
  • From: Gary''s Student
• Re: counting values ignoring duplicates
  • From: matt3542
• Re: Time query
  • From: Bob Phillips
• Re: Excel still not recognising equal values
  • From: Niek Otten
• Excel still not recognising equal values
  • From: pecan
• Time query
  • From: Ber
• Re: Count Function
  • From: Bob Phillips
• Re: How do I calculate the mode for a column of text?
  • From: matt3542
• Re: How can I recover the previous data after save change
  • From: edp . laveranda
• Re: I have a text cell and I want to inport a value into the cell
  • From: David Biddulph
• Re: Multiple Criteria Lookup Results
  • From: Bob Phillips
• Re: Check if a person exists in a distribution list
  • From: Jarek Kujawa
• Re: Multiple Critiera Sum Array - One critiera to be between two numbers
  • From: Jarek Kujawa
• Multiple Critiera Sum Array - One critiera to be between two numbers
  • From: Forgone
• Re: text in mm:ss to time
  • From: Jarek Kujawa
• Re: Sum up all up changes and down changes
  • From: Max
• Re: Sum up all up changes and down changes
  • From: Tetsuya Oguma
• Hyperlink Function
  • From: Hershey
• Re: text in mm:ss to time
  • From: Rick Rothstein \(MVP - VB\)
• Re: Custom functions
  • From: Rick Rothstein \(MVP - VB\)
• Re: Finding cells with a value ending in '.0'
  • From: Rick Rothstein \(MVP - VB\)
• Custom functions
  • From: Palpha32
• text in mm:ss to time
  • From: P Boric
• Re: Replacing characters with numbers in cells
  • From: Rick Rothstein \(MVP - VB\)
• Re: Replacing characters with numbers in cells
  • From: Ron Rosenfeld
• RE: Function for grouping range of data
  • From: John C
• Re: Sum up all up changes and down changes
  • From: Max
• Sum up all up changes and down changes
  • From: Tetsuya Oguma
• Re: Multiple Criteria Lookup Results
  • From: Forgone
• Re: Replacing characters with numbers in cells
  • From: Harlan Grove
• Combination...SumProduct, Index, Match?
  • From: Monte
• Re: can you link a text box to a cell in excel?
  • From: Max
• Re: can you link a text box to a cell in excel?
  • From: Max
• Re: Replacing characters with numbers in cells
  • From: Ron Rosenfeld
• Re: Finding cells with a value ending in '.0'
  • From: Harlan Grove
• Re: Replacing characters with numbers in cells
  • From: David Biddulph
• Re: Finding cells with a value ending in '.0'
  • From: David Biddulph
• Re: Finding cells with a value ending in '.0'
  • From: Harlan Grove
• Re: Finding cells with a value ending in '.0'
  • From: Harlan Grove
• Replacing characters with numbers in cells
  • From: Juan Valdez
• Re: Random Sampling - Please Help!
  • From: joeu2004
• Re: Finding cells with a value ending in '.0'
  • From: David Biddulph
• Re: Conditional formatting to a different cell and it contains a formula
  • From: RagDyer
• Re: Conditional formatting to a different cell and it contains a formula
  • From: RagDyer
• Re: Conditional formatting to a different cell and it contains a formula
  • From: Rick
• Re: Conditional formula
  • From: Gord Dibben
• RE: Histogram bins driving me crazy-please HELP
  • From: Joel
• Re: Using the Subtotal function
  • From: Spiky
• Re: date flexibility
  • From: Spiky
• Re: help with a formula
  • From: gromit
• Re: Conditional formatting to a different cell and it contains a formula
  • From: T. Valko
• Re: Conditional formatting to a different cell and it contains a formula
  • From: Bob Phillips
• Conditional formatting to a different cell and it contains a formula
  • From: Rick
• RE: Referencing Table Data
  • From: Steve Haack
• Re: Match forst four letters
  • From: Harlan Grove
• Re: Paste, Paste Special
  • From: robzrob
• Re: Cell Background Color
  • From: Rick Rothstein \(MVP - VB\)
• Re: Match forst four letters
  • From: T. Valko
• RE: Random Sampling - Please Help!
  • From: Gary Brown
• Re: Display a Date when a cell is Modified
  • From: Sean
• Re: Cell Background Color
  • From: Gary Brown
• Re: MIN and Year Functions
  • From: T. Valko
• Re: Sorting Worksheet Tabs
  • From: Dave Peterson
• Re: counting values ignoring duplicates
  • From: ryguy7272
• Re: Sorting Worksheet Tabs
  • From: Gord Dibben
• Re: Automatically adjusting chart reference
  • From: Gord Dibben
• Re: SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
  • From: Dave Peterson
• Re: Upper to Lowercase in Excel
  • From: Gord Dibben
• Re: add cells together from different sheets within a workbook
  • From: Dave Peterson
• Re: Conditional formula
  • From: Mindy
• Re: Match forst four letters
  • From: ryguy7272
• Re: how do i copy a worksheet to another work book
  • From: Gord Dibben
• Display a Date when a cell is Modified
  • From: Sean
• Re: Paste, Paste Special
  • From: Bernard Liengme
• Re: Cell resizing
  • From: Gord Dibben
• Re: Pivot Table
  • From: Debra Dalgleish
• Re: Vertical lookup of pictures
  • From: Gord Dibben
• Re: cell color
  • From: Gord Dibben
• Re: IF Formula and multiple formulas
  • From: Per Jessen
• Paste, Paste Special
  • From: robzrob
• Re: Cell Background Color
  • From: Joe Gieder
• Re: Sorting Worksheet Tabs
  • From: janabanana
• Re: Workdays/Networkdays #Name? Error
  • From: K
• Re: subtracting date/time
  • From: Bob Phillips
• Re: subtracting date/time
  • From: Rick Rothstein \(MVP - VB\)
• Re: Workdays/Networkdays #Name? Error
  • From: Fred Smith
• Re: subtracting date/time
  • From: Fred Smith
• Referencing Table Data
  • From: Steve Haack
• Re: Match forst four letters
  • From: Peo Sjoblom
• RE: IF Formula Error
  • From: Mike H
• Re: Using COUNTA for a variable array
  • From: T. Valko
• Re: Using the Subtotal function
  • From: Bob Phillips
• Re: Anchoring Excel Cells
  • From: Bob Phillips
• Re: WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
  • From: Bob Phillips
• Re: SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
  • From: Bob Phillips
• Re: Match forst four letters
  • From: ryguy7272
• Re: SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
  • From: Jarek Kujawa
• Re: SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
  • From: Jarek Kujawa
• RE: Using COUNTA for a variable array
  • From: John C
• Re: How do I calculate the mode for a column of text?
  • From: JuanMarin
• Re: add cells together from different sheets within a workbook
  • From: s6292
• Re: counting two ranges for one criteria
  • From: Bob Phillips
• Re: add cells together from different sheets within a workbook
  • From: T. Valko
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Re: Pivot Table
  • From: susan
• Re: Upper to Lowercase in Excel
  • From: Beth
• Re: How do I calculate the mode for a column of text?
  • From: T. Valko
• Check box in Filters
  • From: AceRoadRunner
• Re: add cells together from different sheets within a workbook
  • From: Dave Peterson
• Re: Upper to Lowercase in Excel
  • From: JuanMarin
• Re: Need formula to return next Monday's date
  • From: T. Valko
• Re: Pivot Table
  • From: Debra Dalgleish
• Re: Match forst four letters
  • From: Peo Sjoblom
• Re: Combining date and time data
  • From: Rick Rothstein \(MVP - VB\)
• Re: Cell Background Color
  • From: Rick Rothstein \(MVP - VB\)
• date flexibility
  • From: Karina
• add cells together from different sheets within a workbook
  • From: s6292
• how do i copy a worksheet to another work book
  • From: multi work book sheet copies
• RE: Formula Error
  • From: cdjudge
• Re: Cell resizing
  • From: Kathleen
• Re: If formula error
  • From: Bob Phillips
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Re: Converting from 12-hour to 24-hour format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Looking to replace "dots"
  • From: Rick
• Re: Mid Function
  • From: RagDyeR
• Re: Looking to replace "dots"
  • From: Glenn
• Re: SUMPRODUCT - Using Month
  • From: Phendrena
• Mid Function
  • From: Mattlynn via OfficeKB.com
• Re: SUMPRODUCT - Using Month
  • From: Phendrena
• Looking to replace "dots"
  • From: Rick
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Re: SUMPRODUCT - Using Month
  • From: Phendrena
• Converting from 12-hour to 24-hour format
  • From: Nathan
• Re: total a column in which there are sum formula
  • From: Glenn
• Random Sampling - Please Help!
  • From: Lee Mathew
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Using COUNTA for a variable array
  • From: Schannah
• Re: Total of a specific name
  • From: Tia
• Re: Total of a specific name
  • From: Bob Phillips
• Re: SUMPRODUCT - Using Month
  • From: Bob Phillips
• Re: SUMPRODUCT - Using Month
  • From: Jarek Kujawa
• Re: SUMPRODUCT - Using Month
  • From: Jarek Kujawa
• Re: SUMPRODUCT - Using Month
  • From: Jarek Kujawa
• Re: Another LINEST bug
  • From: Jerry W. Lewis
• SUMPRODUCT - Using Month
  • From: Phendrena
• Total of a specific name
  • From: Tia
• Re: DP jog macro.
  • From: Aaron
• Re: formula alternate column call value
  • From: Jarek Kujawa
• Re: formula alternate column call value
  • From: Jarek Kujawa
• Re: Countif with two conditions
  • From: Jarek Kujawa
• Countif with two conditions
  • From: Jean-Bernard STROOBANT
• Re: Formula at alternate Cell Values
  • From: Bob Phillips
• Re: Multiple Criteria Lookup Results
  • From: Bob Phillips
• Re: cell color
  • From: Bob Phillips
• Re: cell color
  • From: Jarek Kujawa
• Re: counting values ignoring duplicates
  • From: matt3542
• Multiple Criteria Lookup Results
  • From: Forgone
• Re: DP jog macro.
  • From: Bob Phillips
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re:Function to Produce a Number Pattern?
  • From: Dave Curtis
• Re: how to count if cell "contains" a word
  • From: Ron Rosenfeld
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: total a column in which there are sum formula
  • From: Jarek Kujawa
• Re: total a column in which there are sum formula
  • From: Jarek Kujawa
• Re: total a column in which there are sum formula
  • From: Jarek Kujawa
• DP jog macro.
  • From: Aaron
• Re: countif and sum if if two condition are satisfied
  • From: ryguy7272
• Re: counting values ignoring duplicates
  • From: ryguy7272
• Re: count if unique entries
  • From: ryguy7272
• Re: How do I display the result of a function on seperate worksheet e.
  • From: JuanMarin
• RE: an IF function that can take no action?
  • From: shoy
• Re: Buttons
  • From: Gord Dibben
• Function to Produce a Number Pattern?
  • From: mommy2kh
• Re: Formula question
  • From: Gord Dibben
• Buttons
  • From: Henrique
• Re: Vertical lookup of pictures
  • From: Gord Dibben
• Re: Auto Fill Color Cell
  • From: Gord Dibben
• Re: How Do I put items,(names)inside DV dropdown?
  • From: Gord Dibben
• Re: Cell resizing
  • From: Gord Dibben
• Re: Formulas
  • From: Gord Dibben
• Re: Format changed when the details in cell changed
  • From: Gord Dibben
• Re: how to count if cell "contains" a word
  • From: Harlan Grove
• Re: I need help with an if statement that has more than 7 nested condi
  • From: Bob Phillips
• RE: I need help with an if statement that has more than 7 nested condi
  • From: StumpedAgain
• Re: Dynamic Link to Quickbooks
  • From: Alan Beban
• Re: Creating a formula which would affect multiple cells
  • From: Rob
• Re: I need help with a IF(ISNA with vlookup
  • From: Pete_UK
• Re: Creating a formula which would affect multiple cells
  • From: Rob
• How do I display the result of a function on seperate worksheet e.
  • From: Beth
• Re: SUMPRODUCT: dividing the formula of one cell by another.
  • From: Bernard Liengme
• Re: Compare lists when one column contains multiple entries
  • From: Swilliams
• Re: How Do I put items,(names)inside DV dropdown?
  • From: Otto Moehrbach
• Re: Formula question
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: Filtering failed moving on...HELP
  • From: Otto Moehrbach
• Re: Creating a formula which would affect multiple cells
  • From: Bernard Liengme
• Re: Compare lists when one column contains multiple entries
  • From: T. Valko
• Re: Compare lists when one column contains multiple entries
  • From: Dave Peterson
• Re: Extracting Specific Data from one sheet to another.
  • From: Pete_UK
• Re: Creating a formula which would affect multiple cells
  • From: Bernard Liengme
• Re: Creating a formula which would affect multiple cells
  • From: T. Valko
• Re: Can I copy a field from another spreadsheet based on search?
  • From: Pete_UK
• Re: using OR function with Index/Match?
  • From: Dave Peterson
• Re: different phrasing
  • From: Pete_UK
• Re: how to count if cell "contains" a word
  • From: Harlan Grove
• Re: Vertical lookup of pictures
  • From: Peo Sjoblom
• Re: How to print entire workbook 9 pages to a sheet?
  • From: Glenn
• Can I copy a field from another spreadsheet based on search?
  • From: Faye
• RE: Document Specific Autocorrection
  • From: TheBroon
• Re: using OR function with Index/Match?
  • From: Bob Phillips
• Re: How to print entire workbook 9 pages to a sheet?
  • From: Glenn
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to count if cell "contains" a word
  • From: Harlan Grove
• Re: Need Simple List...Multiple Columns and Multiple Worksheets
  • From: Otto Moehrbach
• Re: Find matching values in two different columns
  • From: T. Valko
• Re: how to count if cell "contains" a word
  • From: Ron Rosenfeld
• Re: Count IF
  • From: Dave Peterson
• Re: If statements looking for nonblank cells
  • From: T. Valko
• Re: How to print entire workbook 9 pages to a sheet?
  • From: Glenn
• Re: Excel 2007 Conditional Formatting only copies absolute
  • From: Spiky
• Re: Find matching values in two different columns
  • From: T. Valko
• Re: Count IF
  • From: Romanli
• Re: Average time
  • From: Lars-Åke Aspelin
• Re: count if unique entries
  • From: T. Valko
• Re: Count IF
  • From: Bernard Liengme
• RE: count if unique entries
  • From: Gary''s Student
• Re: How can I choose more than one item from list in a form in Exc
  • From: Rick Rothstein \(MVP - VB\)
• Re: Gradient and intercept on data with errors
  • From: Bernard Liengme
• count if unique entries
  • From: Tonybagodonuts
• Re: Count IF
  • From: Dave Peterson
• Re: Count IF
  • From: Bernard Liengme
• Re: Counting data in a range
  • From: T. Valko
• Re: How can I choose more than one item from list in a form in Exc
  • From: Jolly
• Re: PERCENTILE exceeding 8191 points
  • From: Bernard Liengme
• Re: Sum of continous cell
  • From: T. Valko
• Re: INDIRECT
  • From: Harlan Grove
• Re: edit data in multiple cells
  • From: Jarek Kujawa
• RE: edit data in multiple cells
  • From: Ask MS
• How Do I put items,(names)inside DV dropdown?
  • From: Sassy
• Re: edit data in multiple cells
  • From: Jarek Kujawa
• Re: Counting data in a range
  • From: David Biddulph
• RE: Sum of continous cell
  • From: Gary Brown
• Re: Counting data in a range
  • From: Peo Sjoblom
• RE: Sum of continous cell
  • From: John C
• Re: Counting data in a range
  • From: RagDyeR
• Re: Counting data in a range
  • From: Jarek Kujawa
• Re: Duplicate ramdom sampling
  • From: Lee Mathew
• Counting data in a range
  • From: Glenn L.
• controlling pivot table
  • From: mrc1986 via OfficeKB.com
• Re: how to count if cell "contains" a word
  • From: cjlatta
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: How can I choose more than one item from list in a form in Exc
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to count if cell "contains" a word
  • From: cjlatta
• Gradient and intercept on data with errors
  • From: Dave Curtis
• Re: How can I choose more than one item from list in a form in Exc
  • From: Rick Rothstein \(MVP - VB\)
• Re: Pivot Chart Formating
  • From: Debra Dalgleish
• Re: How can I choose more than one item from list in a form in Excel?
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to print entire workbook 9 pages to a sheet?
  • From: Glenn
• Re: Average time
  • From: Bob Phillips
• Re: how to count if cell "contains" a word
  • From: cjlatta
• Re: Subtotalling taking long time to complete
  • From: AndyV
• Re: Average time
  • From: Jarek Kujawa
• Re: counting values ignoring duplicates
  • From: matt3542
• Re: Average time
  • From: Jarek Kujawa
• Re: Average time
  • From: Bob Phillips
• Re: Average time
  • From: Bob Phillips
• Re: Average time
  • From: Jarek Kujawa
• Re: an IF function that can take no action?
  • From: Jarek Kujawa
• Re: vlookup not returning a match even when there is one
  • From: karen
• Re: circular reference where sumif and vlookup overlap
  • From: John C
• Re: vlookup not returning a match even when there is one
  • From: Mike H
• Re: vlookup not returning a match even when there is one
  • From: Mike H
• Re: counting values ignoring duplicates
  • From: Lars-Åke Aspelin
• Re: counting values ignoring duplicates
  • From: Bob Phillips
• Re: counting values ignoring duplicates
  • From: Dave Peterson
• Re: counting values ignoring duplicates
  • From: Jarek Kujawa
• Re: vlookup not returning a match even when there is one
  • From: Dave Peterson
• Re: Subtotalling taking long time to complete
  • From: Dave Peterson
• Re: HYPERLINK - Jump to another sheet in the same workbook
  • From: Dave Peterson
• Re: Subtotalling taking long time to complete
  • From: AndyV
• Re: vlookup not returning a match even when there is one
  • From: karen
• Re: HYPERLINK - Jump to another sheet in the same workbook
  • From: Pete_UK
• Re: vlookup not returning a match even when there is one
  • From: Pete_UK
• vlookup not returning a match even when there is one
  • From: karen
• Re: Subtotalling taking long time to complete
  • From: Pete_UK
• Re: Peak call times/hours
  • From: Ber
• Re:How do you alphabetize street addresses within a column?
  • From: Dave Curtis
• Re: countif and sum if if two condition are satisfied
  • From: Bob Phillips
• Re: countif and sum if if two condition are satisfied
  • From: Jarek Kujawa
• Re: Inserting Function blanks adjoioning cell
  • From: Max
• Re: Need Simple List...Multiple Columns and Multiple Worksheets
  • From: Jane Doe
• Re: Need Simple List...Multiple Columns and Multiple Worksheets
  • From: Jane Doe
• Re: clear cell based on text in opposing column
  • From: bubba
• Re: Need Simple List...Multiple Columns and Multiple Worksheets
  • From: Otto Moehrbach
• Re: Flying Hours
  • From: Ron Rosenfeld
• Re: Format changed when the details in cell changed
  • From: angel
• Re: vlookup returns wrong answer (off by one row)
  • From: Peo Sjoblom
• Re: Lock or Unlock Range of Cells on Worksheet_Change Event
  • From: Grahame Coyle
• Re: VLookup in a form
  • From: NoodNutt
• Re: Weekly Totals Based on Dates
  • From: Ed Ferrero
• Re: clear cell based on text in opposing column
  • From: Don Guillett
• Re: Return to a default state???
  • From: NoodNutt
• clear cell based on text in opposing column
  • From: bubba
• Re: INDIRECT
  • From: INDIRECT
• Re: Lock or Unlock Range of Cells on Worksheet_Change Event
  • From: Grahame Coyle
• Re: Flying Hours
  • From: Ragdyer
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: T. Valko
• Re: how to have auto calc cells be blank unless entry made
  • From: Per Jessen
• Re: how to convert number to words
  • From: Nikhil Jain
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: mommy2kh
• Re: INDIRECT
  • From: Harlan Grove
• Re: Flying Hours
  • From: Rick Rothstein \(MVP - VB\)
• RE: Flying Hours
  • From: FSt1
• Re: Auto populate a cell by comparing lists
  • From: Ken
• Re: Auto populate a cell by comparing lists
  • From: recrit
• RE: Lock or Unlock Range of Cells on Worksheet_Change Event
  • From: Mike H
• Re: <>= Formula ?
  • From: Lars-Åke Aspelin
• Re: <>= Formula ?
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to change font in form contollers
  • From: Gord Dibben
• Re: <>= Formula ?
  • From: Henrique
• Re: Extact minutes from text field?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Inserting Function blanks adjoioning cell
  • From: Dave
• Re: INDIRECT
  • From: Ragdyer
• Lock or Unlock Range of Cells on Worksheet_Change Event
  • From: Grahame Coyle
• Re: sum between a range of dates
  • From: H. Nissen
• Re: sum between a range of dates
  • From: Bernard Liengme
• Auto populate a cell by comparing lists
  • From: Ken
• Re: circular reference where sumif and vlookup overlap
  • From: mining north
• Extact minutes from text field?
  • From: Lenchik
• Re: Replacing Part of a Cell's Content
  • From: Ron Rosenfeld
• Re: date problem or is it me?
  • From: zekni
• RE: Populate cell range
  • From: lost and confused in excel-land
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: T. Valko
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: mommy2kh
• Re: insert column header in cell below result of max FUNCTION
  • From: T. Valko
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: T. Valko
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: T. Valko
• Re: how do i calculate cumulative percentages in Pivot table reports
  • From: Herbert Seidenberg
• Re: INDIRECT
  • From: Tim Zych
• RE: Replacing Part of a Cell's Content
  • From: Mike
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: mommy2kh
• Re: circular reference where sumif and vlookup overlap
  • From: John C
• Re: Changing Pivot Table to Formular Table
  • From: Max
• Re: conditional formatting or VB
  • From: Dave Peterson
• Re: Excell Formula
  • From: Max
• Re: conditional formatting or VB
  • From: ryguy7272
• Re: sumif < date
  • From: Rick Rothstein \(MVP - VB\)
• Re: keep track of phone numbers
  • From: recrit
• Re: spreadsheet to keep track of phone numbers
  • From: recrit
• Excel Loan Repayment Schedule template.
  • From: stevegg
• Re: sumif < date
  • From: T. Valko
• Re: sumif < date
  • From: Dave Peterson
• Re: keep old cell value and new cell value
  • From: Otto Moehrbach
• Re: If statements in Data Validation
  • From: T. Valko
• Re: keep old cell value and new cell value
  • From: Gord Dibben
• Re: Calculating values based on selection from a drop-down list in
  • From: Gord Dibben
• Re: keep track of phone numbers
  • From: HappySenior
• Re: how to convert number to words
  • From: Bob Phillips
• Re: Finding quantity that falls within a range or Tier
  • From: Ron Rosenfeld
• Re: keep track of phone numbers
  • From: Don Guillett
• Re: Count Non-Blank Values in a Table but only for a range
  • From: Pete_UK
• keep track of phone numbers
  • From: Eamon
• spreadsheet to keep track of phone numbers
  • From: Eamon
• Re: Finding quantity that falls within a range or Tier
  • From: Mimi
• Re: >> vlookup refering to a cell to get wookbook name
  • From: Bob Phillips
• Re: If statements in Data Validation
  • From: lost and confused in excel-land
• Re: If statements in Data Validation
  • From: Tim Zych
• Re: If statements in Data Validation
  • From: T. Valko
• Re: Can I Use A Count If Function With A Forward Slash?
  • From: T. Valko
• Re: If statements in Data Validation
  • From: Tim Zych
• Re: Need formula to return next Monday's date
  • From: T. Valko
• Re: Need formula to return next Monday's date
  • From: Tim Zych
• Re: If statements in Data Validation
  • From: Tim Zych
• Re: how to count if cell "contains" a word
  • From: Ragdyer
• Re: Inserting Function blanks adjoioning cell
  • From: Max
• Re: how to count if cell "contains" a word
  • From: Ragdyer
• Re: Comparing Addresses from 2 different Worksheets
  • From: Max
• Re: Multiple calculations within cell? Writing in Excel 2000, usin
  • From: John C
• VLookup in a form
  • From: theresaluff
• Inserting Function blanks adjoioning cell
  • From: Dave
• Re: Finding quantity that falls within a range or Tier
  • From: Ron Rosenfeld
• Re: how to count if cell "contains" a word
  • From: Ron Rosenfeld
• Re: how to count if cell "contains" a word
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to count if cell "contains" a word
  • From: Ron Rosenfeld
• Re: Calculating values based on selection from a drop-down list in Exc
  • From: Gord Dibben
• Re: Multiple calculations within cell? Writing in Excel 2000, usin
  • From: robzrob
• Re: Duplicate ramdom sampling
  • From: Bernd P
• Re: circular reference where sumif and vlookup overlap
  • From: Gord Dibben
• Re: Copy Info from 1 sheet to another within same workbook
  • From: Gord Dibben
• Re: Multiple calculations within cell? Writing in Excel 2000, using i
  • From: robzrob
• Re: how to count if cell "contains" a word
  • From: robzrob
• Re: how to count if cell "contains" a word
  • From: RagDyer
• RE: circular reference where sumif and vlookup overlap
  • From: John C
• Re: want to automatically skip certain cells when you hit enter
  • From: Gord Dibben
• Re: Printing
  • From: Gord Dibben
• Re: Data Validation and combination
  • From: Gord Dibben
• Re: copying formulas
  • From: Gord Dibben
• Re: Filtering
  • From: Gord Dibben
• Multiple calculations within cell? Writing in Excel 2000, using in Excel 2003
  • From: robzrob
• Re: Format changed when the details in cell changed
  • From: Gord Dibben
• Re: Average of Day and Time
  • From: Bob Phillips
• Re: Average of Day and Time
  • From: Bob Phillips
• RE: multiple IF formulas
  • From: Gary Brown
• Re: CONCATENATE within SUMPRODUCT
  • From: PCLIVE
• Re: CONCATENATE within SUMPRODUCT
  • From: PCLIVE
• Re: Already exists on the destination workbook
  • From: Dave Peterson
• Re: CONCATENATE within SUMPRODUCT
  • From: RagDyer
• Re: CONCATENATE within SUMPRODUCT
  • From: Harlan Grove
• Re: CONCATENATE within SUMPRODUCT
  • From: Harlan Grove
• Re: Formula, automation turn red if value exceed a number
  • From: Pete_UK
• Re: CONCATENATE within SUMPRODUCT
  • From: RagDyer
• Re: Compare and get the best value
  • From: Pete_UK
• Re: Quday001-Conditional Formatting
  • From: Pete_UK
• Re: Already exists on the destination workbook
  • From: Pete_UK
• Re: conditional formatting or VB
  • From: Don Guillett
• Re: Count Non-Blank Values in a Table but only for a range
  • From: Pete_UK
• Re: Formula, automation turn red if value exceed a number
  • From: Pete_UK
• Re: match or vlookup function formula help
  • From: Pete_UK
• Re: CONCATENATE within SUMPRODUCT
  • From: PCLIVE
• Re: Minutes/seconds not right ( 24 ??? %$@#$%$)
  • From: Pete_UK
• Re: CONCATENATE within SUMPRODUCT
  • From: Bob Phillips
• Re: CONCATENATE within SUMPRODUCT
  • From: Bob Phillips
• Re: Minutes/seconds not right ( 24 ??? %$@#$%$)
  • From: Steve
• Duplicate ramdom sampling
  • From: Lee Mathew
• Re: want to automatically skip certain cells when you hit enter
  • From: IanC
• Re: Peak call times/hours
  • From: Pete_UK
• Re: Push updates from one workbook to others?
  • From: Pete_UK
• Re: match or vlookup function formula help
  • From: Pete_UK
• Re: IF function question
  • From: Pete_UK
• Re: CONCATENATE within SUMPRODUCT
  • From: Peo Sjoblom
• RE: Minutes/seconds not right ( 24 ??? %$@#$%$)
  • From: John C
• Re: Minutes/seconds not right ( 24 ??? %$@#$%$)
  • From: Pete_UK
• Re: IF and dates
  • From: Pete_UK
• Re: IF and dates
  • From: PCLIVE
• Re: CONCATENATE within SUMPRODUCT
  • From: RagDyeR
• Peak call times/hours
  • From: Ber
• Re: IF and dates
  • From: PCLIVE
• Re: CONCATENATE within SUMPRODUCT
  • From: RagDyeR
• Re: CONCATENATE within SUMPRODUCT
  • From: Icarus
• Re: Refer to a sheet using a cell value
  • From: bony_tony
• Re: CONCATENATE within SUMPRODUCT
  • From: Bob Phillips
• Re: date problem or is it me?
  • From: zekni
• Re: ?????????????????????
  • From: bony_tony
• CONCATENATE within SUMPRODUCT
  • From: Icarus
• Refer to a sheet using a cell value
  • From: bony_tony
• Re: Look Up two cells
  • From: RagDyeR
• Re: copying formulas
  • From: ambam
• Re: copying formulas
  • From: Fred Smith
• RE: spreadsheet to keep track of phone numbers
  • From: John C
• RE: copying formulas
  • From: ambam
• spreadsheet to keep track of phone numbers
  • From: Eamon
• Spreadsheet to keep track of phone numbers
  • From: Eamon
• Re: Quday-Conditional Formatting
  • From: Jarek Kujawa
• Re: date problem or is it me?
  • From: Jarek Kujawa
• Re: "in" function???
  • From: PCLIVE
• Re: "in" function???
  • From: Bernard Liengme
• Quday-Conditional Formatting
  • From: Udayan
• date problem or is it me?
  • From: zekni
• Re: HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?
  • From: Meebers
• Re: Excel 2007 Conditional Formatting only copies absolute
  • From: Rob
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Bernd P
• Re: sumif or if or something else????
  • From: Pete_UK
• Re: ideas needed, pls help..
  • From: sajay
• sumif or if or something else????
  • From: durrienz
• Re: Date Correction
  • From: JPS
• Re: Date Correction
  • From: Bob Phillips
• ideas needed, pls help..
  • From: angel
• Re: how to use my Excel 2003 DTF commands
  • From: David Biddulph
• Password in Visual basic editor
  • From: Tia
• Re: Data Validation lists update orginal cell with list update
  • From: roniaelm
• Re: Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
  • From: Harlan Grove
• Re: Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
  • From: Max
• Re: Excel time calculation
  • From: T. Valko
• Re: Test for normality of data
  • From: Harlan Grove
• Re: Two way lookup on a table from user input
  • From: T. Valko
• Re: Payroll lookup
  • From: T. Valko
• Re: Excel time calculation
  • From: Mark K
• Re: Excel time calculation
  • From: Mark K
• Re: Test for normality of data
  • From: Mike Middleton
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• Re: Hide a sheet with a variable name
  • From: Héctor Miguel
• Re: Comparing Addresses from 2 different Worksheets
  • From: Max
• Re: using vlookup
  • From: Mark
• Re: Format changed when the details in cell changed
  • From: angel
• Re: using vlookup
  • From: Gord Dibben
• Re: using vlookup
  • From: Pete_UK
• Re: using vlookup
  • From: Pete_UK
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• Re: Data Validation and combination
  • From: Gord Dibben
• Re: Auto filter sort ascending not working while sheet protected
  • From: Gord Dibben
• Re: How do I remove names from a drop down box?
  • From: Gord Dibben
• Re: Auto filter sort ascending not working while sheet protected
  • From: Pete_UK
• Re: If calculations
  • From: Pete_UK
• RE: I need help with a IF(ISNA with vlookup
  • From: StumpedAgain
• RE: XIRR FUNCTION
  • From: Lynndale
• Re: Complex Array sorting issue
  • From: Héctor Miguel
• Re: Need Help with Lookup Formula that Also Puts in Text Where Mat
  • From: Toria
• Re: password protected workbook
  • From: Reitanos
• RE: Replacing a Range of Numbers
  • From: StumpedAgain
• Re: IF STATEMENT
  • From: Lars-Åke Aspelin
• Re: password protected workbook
  • From: Niek Otten
• Re: IF STATEMENT
  • From: charlie
• Re: adding a round function to an existing formula
  • From: Fred Smith
• Re: IF STATEMENT
  • From: Fred Smith
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Zumble
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• Re: Align data in 2 column in the same row if the user id's match
  • From: Bernard Liengme
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• Re: Conditinal Formation
  • From: Bernard Liengme
• Re: multipying a cell by a percentage
  • From: Zumble
• Re: Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
  • From: Dave Peterson
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: Data lookup function
  • From: Zumble
• Align data in 2 column in the same row if the user id's match
  • From: simon
• Re: Average If - averaging cells based on value of another cell
  • From: Pete_UK
• Re: Another LINEST bug
  • From: Bernard Liengme
• Re: how to copy excel carriage return to notepad w/out the quotati
  • From: BB
• Re: Another LINEST bug
  • From: T. Valko
• Re: Date Formula
  • From: Pete_UK
• Re: move or copy
  • From: Pete_UK
• RE: leave cells blank until formula applied
  • From: tim m
• Re: Critical - Converting Single Column Address Data into Multiple Col
  • From: Zumble
• Re: Counting dates including the beginning date.
  • From: T. Valko
• Re: Easy to do but cannot remember how!
  • From: Gord Dibben
• RE: Easy to do but cannot remember how!
  • From: Chivalrous1
• Re: Formula
  • From: Gord Dibben
• Re: Format changed when the details in cell changed
  • From: Gord Dibben
• Re: How to Compare between cells and choose smallest value
  • From: T. Valko
• How do I force entry in multiple cell ranges in one worksheet
  • From: CindyB
• Re: ACCRINTM() function
  • From: Niek Otten
• Re: Critical - Converting Single Column Address Data into Multiple Col
  • From: Zumble
• ACCRINTM() function
  • From: Zumble
• Re: Format changed when the details in cell changed
  • From: angel
• Re: how to copy excel carriage return to notepad w/out the quotati
  • From: Dave Peterson
• Re: how to copy excel carriage return to notepad w/out the quotati
  • From: BB
• Re: Conditional formatting - source data from another sheet
  • From: Peo Sjoblom
• Re: Conditional formatting - source data from another sheet
  • From: Gord Dibben
• Re: What does the ! notation mean in excel financial formulas?
  • From: Peo Sjoblom
• Re: Format changed when the details in cell changed
  • From: Gord Dibben
• Re: the font colour icon in excell 2007 kicks me out of the programme
  • From: Ron de Bruin
• Re: =SLOPE(OFFSET(INDEX .... Help please
  • From: Bernd P
• Re: Fill down with references to worksheets
  • From: Zumble
• Re: Complex Array sorting issue
  • From: Tubster
• Re: How can I make a drop down box visible within a worksheet?
  • From: Dave Peterson
• Re: FONT COLOUR CHANGE
  • From: Peo Sjoblom
• Re: Fill down with references to worksheets
  • From: Gord Dibben
• Re: lookup by multiple parameters
  • From: Peo Sjoblom
• Re: Fill down with references to worksheets
  • From: Peo Sjoblom
• Re: text outside merge cells despite clicking wrap text
  • From: Gord Dibben
• Re: Average If - averaging cells based on value of another cell
  • From: Pete_UK
• RE: List or colour Cells of results
  • From: Jamie
• Re: Counting on 2 criteria
  • From: PCLIVE
• Re: Counting on 2 criteria
  • From: Pete_UK
• Re: Excel Autoformating cells
  • From: Gord Dibben
• Fill down with references to worksheets
  • From: chris
• Counting on 2 criteria
  • From: Richie
• Re: a little help?
  • From: Pete_UK
• Re: how do i get zeros to show after decimal point?
  • From: David Biddulph
• Re: How can I make a drop down box visible within a worksheet?
  • From: Brainless_in_Boston
• Re: how do i get zeros to show after decimal point?
  • From: Cimjet
• Re: multipying a cell by a percentage
  • From: David Biddulph
• Re: Help with multi sheet workbook
  • From: ryguy7272
• Re: SUMIF function
  • From: David Biddulph
• Re: SUMIF function
  • From: Dave Peterson
• Re: SUMIF function
  • From: Dave Peterson
• Re: Date Entered +7, unless another field is greater than 0
  • From: chickalina
• SUMIF function
  • From: Igor
• RE: Date and time stamping with a (macro) button
  • From: Mike H
• RE: Date and time stamping with a (macro) button
  • From: Mike H
• Re: Another LINEST bug
  • From: Bernard Liengme
• RE: Date and time stamping with a (macro) button
  • From: ArcticWolf
• Re: How to split up text
  • From: Ron Rosenfeld
• RE: How to split up text
  • From: Dennis
• Re: How to split up text
  • From: Mark K
• =SLOPE(OFFSET(INDEX .... Help please
  • From: Mark K
• How to split up text
  • From: Hilton
• text outside merge cells despite clicking wrap text
  • From: chedd via OfficeKB.com
• RE: More Conditional Formatting
  • From: Stefi
• Re: How do I lock the formatting of my worksheet but still add text?
  • From: sajay
• Re: MID and FIND Function for Numbers
  • From: ArcticWolf
• RE: Excel - Min function over 4 separate cells, but ignoring negat
  • From: griff
• Re: EXCEL SHEET
  • From: sajay
• Re: Formula Display
  • From: sajay
• Re: Counting
  • From: Pete_UK
• Re: Date Entered +7, unless another field is greater than 0
  • From: Per Jessen
• RE: XIRR FUNCTION
  • From: pshepard
• Re: Text to columns with date format does not work :(
  • From: Rick Rothstein \(MVP - VB\)
• More Conditional Formatting
  • From: tvh
• Re: Conditional Formatting for Values in 3 cells
  • From: T. Valko
• Re: seeking help
  • From: Rick Rothstein \(MVP - VB\)
• Re: Vlookup combined with Hlookup
  • From: T. Valko
• Re: MID and FIND Function for Numbers
  • From: Rick Rothstein \(MVP - VB\)
• Re: Counting
  • From: Civette
• Re: Counting
  • From: Civette
• Re: Counting
  • From: Civette
• Re: Vlookup combined with Hlookup
  • From: Cornelius
• Re: Find a color value
  • From: Héctor Miguel
• RE: XIRR FUNCTION
  • From: Lynndale
• Re: First Positive on Horizontal Array
  • From: T. Valko
• Re: Counting
  • From: Dave Peterson
• Re: a little help?
  • From: Pete_UK
• Re: Cell resizing
  • From: Gord Dibben
• Re: If calculations
  • From: Pete_UK
• Re: Counting
  • From: Harlan Grove
• Re: Locking documents in Excel after a template has been created.
  • From: Gord Dibben
• Re: Counting
  • From: Pete_UK
• Re: Counting
  • From: Civette
• Re: Counting
  • From: Civette
• Re: Complex Array sorting issue
  • From: Héctor Miguel
• Re: When saving, Excel prompt me for all worksheet passwords
  • From: Gord Dibben
• Re: Excel Autoformating cells
  • From: Gord Dibben
• Re: Filter Data From Master Sheet Into Other Worksheets
  • From: Max
• Re: how do I copy and paste a drop down list in excel?
  • From: Gord Dibben
• Re: Counting
  • From: Pete_UK
• Re: Complex Array sorting issue
  • From: Tubster
• Re: how do i calculate the average of 30+ cells over multiple work
  • From: Harlan Grove
• Re: Dropping decimal places whern transfering to AS400?
  • From: Harlan Grove
• Re: can't lookup a value to the left of my variable
  • From: Sandy Mann
• Re: Excel - Min function over 4 separate cells, but ignoring negatives
  • From: Harlan Grove
• Re: Counting
  • From: Civette
• Re: can't lookup a value to the left of my variable
  • From: Dave Peterson
• Re: can't lookup a value to the left of my variable
  • From: Niek Otten
• Re: If statement error check
  • From: Peo Sjoblom
• Re: Find a color value
  • From: Dave Peterson
• Re: Counting
  • From: Dave Peterson
• Re: Counting
  • From: Civette
• Re: How do retrieve deleted files from excel?
  • From: David Biddulph
• Re: Complex Array sorting issue
  • From: Héctor Miguel
• Re: First Positive on Horizontal Array
  • From: Rick Rothstein \(MVP - VB\)
• Re: Want to unlink calculations
  • From: Otto Moehrbach
• Re: SUM with nested VLOOKUPS - can i make it ignore N/As?
  • From: Peo Sjoblom
• Re: How to extract text from middle of a string
  • From: Ron Rosenfeld
• RE: Its a toughie, not sure if its possible.
  • From: pshepard
• Re: First Positive on Horizontal Array
  • From: Dave Peterson
• Re: SUM with nested VLOOKUPS - can i make it ignore N/As?
  • From: Niek Otten
• Re: name separation
  • From: Rick Rothstein \(MVP - VB\)
• Re: Counting
  • From: Pete_UK
• Re: Counting
  • From: Civette
• Re: SUM with nested VLOOKUPS - can i make it ignore N/As?
  • From: Niek Otten
• Re: Counting
  • From: Pete_UK
• Re: Counting
  • From: T. Valko
• Re: How to show a whole worksheet on one screen?
  • From: Spiky
• Re: Finding and Adding
  • From: Niek Otten
• Re: Counting
  • From: Civette
• Re: Excel Calculation
  • From: T. Valko
• Re: Counting
  • From: T. Valko
• Re: Actual Language for Nesting criteria
  • From: Pete_UK
• Re: Excel Calculation
  • From: Pete_UK
• Re: Counting
  • From: Pete_UK
• Re: Please Help Qtr Mtch
  • From: KristiM
• RE: XIRR FUNCTION
  • From: pshepard
• RE: VLookup function
  • From: Belinda7237
• Re: Excel Calculation
  • From: T. Valko
• Re: First Positive on Horizontal Array
  • From: T. Valko
• Re: VLookup function
  • From: David Biddulph
• Re: First Positive on Horizontal Array
  • From: Dave Peterson
• Re: Vlookup combined with Hlookup
  • From: T. Valko
• Re: Finding selected numbers within a master list
  • From: Dave Peterson
• Re: Nested if's and lookup
  • From: T. Valko
• Re: Finding selected numbers within a master list
  • From: Pete_UK
• Re: Please Help Qtr Mtch
  • From: KristiM
• Re: Main worksheet to automatically update figures on other worksheets
  • From: Pete_UK
• Re: Separating Text
  • From: Pete_UK
• Re: Locking documents in Excel after a template has been created.
  • From: RagDyeR
• Re: Formula Display
  • From: Rick Rothstein \(MVP - VB\)
• Re: Formula Display
  • From: David Biddulph
• Re: Excel - Min function over 4 separate cells, but ignoring negatives
  • From: David Biddulph
• Re: Add numbers in a column, but exclude percentages in the same c
  • From: David Biddulph
• RE: Formula Display
  • From: Kimbanev
• Re: how do i calculate the average of 30+ cells over multiple work
  • From: Fred Smith
• Re: Dropping decimal places whern transfering to AS400?
  • From: David Biddulph
• Re: EXCEL SHEET
  • From: David Biddulph
• Re: how do i calculate the average of 30+ cells over multiple work
  • From: Ariana
• RE: Formula for adding 2 worksheets
  • From: Rich W.
• Excel - Min function over 4 separate cells, but ignoring negatives
  • From: griff
• Re: Is there a showif formula?
  • From: Mike
• Re: how do i replace #n/a in a vlookup?
  • From: Pete_UK
• Re: Adding rows based on no of rows specified from a given position
  • From: Pete_UK
• Re: How to extract text from middle of a string
  • From: bollard
• Re: how do i replace #n/a in a vlookup?
  • From: Pete_UK
• Re: indirect formula syntax
  • From: Dave Peterson
• Re: Continuation to equivalent for formula - to Mr. Harlan Grove (and not only...)
  • From: ytayta555
• Re: Enabling Macros
  • From: David Price
• Re: Help with multi sheet workbook
  • From: David Price
• Re: indirect formula syntax
  • From: Pete_UK
• indirect formula syntax
  • From: Graeme
• Re: Excel 2007 nested function
  • From: David Price
• Re: Its a toughie, not sure if its possible.
  • From: Rick Rothstein \(MVP - VB\)
• Re: Its a toughie, not sure if its possible.
  • From: Per Jessen
• Re: Selecting a diff. worksheet but same cell references using Validat
  • From: Pete_UK
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: What formula should I use?
  • From: Héctor Miguel
• Re: Vlookup combined with Hlookup
  • From: Cornelius
• Re: lookup question
  • From: Harlan Grove
• Re: if then statements with calculations
  • From: Harlan Grove
• Re: Vlookup combined with Hlookup
  • From: T. Valko
• Re: Hide a sheet with a variable name
  • From: Héctor Miguel
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Rick Rothstein \(MVP - VB\)
• Re: Find a color value
  • From: Héctor Miguel
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Rick Rothstein \(MVP - VB\)
• Re: Is there an INDIRECT function for a RANGE?
  • From: T. Valko
• Re: Nested if's and lookup
  • From: T. Valko
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: how do I copy and paste a drop down list in excel?
  • From: T. Valko
• Re: Is there an INDIRECT function for a RANGE?
  • From: T. Valko
• Re: Need Help with Lookup Formula that Also Puts in Text Where Mat
  • From: Pete_UK
• Re: Need Help with Lookup Formula that Also Puts in Text Where Mat
  • From: Toria
• Re: how to copy excel carriage return to notepad w/out the quotations
  • From: Dave Peterson
• Hide a sheet with a variable name
  • From: Scott
• Re: Need Help with Lookup Formula that Also Puts in Text Where Matchin
  • From: Pete_UK
• Re: Help with dates
  • From: Pete_UK
• Re: WHat is wrong with this formula
  • From: Pete_UK
• Re: Summing same cells in multiple worksheets
  • From: Gord Dibben
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: T. Valko
• Re: XIRR Function - large IRRs
  • From: Fred Smith
• Summing same cells in multiple worksheets
  • From: neilcarden
• Re: How can I make a drop down box visible within a worksheet?
  • From: Gord Dibben
• Re: Searching Multiple sheets in excel
  • From: Gord Dibben
• Re: spreadsheet colum combination
  • From: Gord Dibben
• Re: Help with dates
  • From: Rick Rothstein \(MVP - VB\)
• Re: How can I make a drop down box visible within a worksheet?
  • From: Kendra510
• Re: Converting specific text to numbers then sum
  • From: T. Valko
• Re: spreadsheet colum combination
  • From: Old Bob
• Re: spreadsheet colum combination
  • From: Old Bob
• Re: Hyper link between spread sheets
  • From: Dave Peterson
• Re: LOOKUP Help
  • From: T. Valko
• Re: spreadsheet colum combination
  • From: Old Bob
• Re: sumif with multiple conditions
  • From: T. Valko
• Re: Countif with multiple criteria
  • From: girasole
• Re: Converting specific text to numbers then sum
  • From: Mule
• Re: =IF
  • From: Susan
• Re: Hyper link between spread sheets
  • From: MyVeryOwnSelf
• Re: Help Me Please -
  • From: Rick Rothstein \(MVP - VB\)
• Re: how do i replace #n/a in a vlookup?
  • From: Rick Rothstein \(MVP - VB\)
• Re: =IF
  • From: Rick Rothstein \(MVP - VB\)
• RE: Help Me Please -
  • From: Yossy
• Re: =IF
  • From: Pete_UK
• Re: How to show a whole worksheet on one screen?
  • From: Rick Rothstein \(MVP - VB\)
• Re: =IF
  • From: Rick Rothstein \(MVP - VB\)
• Excel 2007 nested function
  • From: David Price
• Re: =IF
  • From: PCLIVE
• Re: How to show a whole worksheet on one screen?
  • From: Pete_UK
• Re: Help Me Please -
  • From: Peo Sjoblom
• RE: Help Me Please -
  • From: John C
• RE: Help Me Please -
  • From: Mike H
• how do i replace #n/a in a vlookup?
  • From: infinite1013
• Re: IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS
  • From: Gord Dibben
• RE: Delete duplicates in a row
  • From: Hardeep_kanwar
• Re: Conditional Formatting - workdays only
  • From: T. Valko
• Re: Converting specific text to numbers then sum
  • From: T. Valko
• Re: SUMPRODUCT AND LEFT
  • From: K
• Re: lookup question
  • From: Pete_UK
• Re: Countif with multiple criteria
  • From: Pete_UK
• Re: simple formula
  • From: Rick Rothstein \(MVP - VB\)
• RE: simple formula
  • From: John C
• Re: How do I use condiftional formatting to indicate a formula?
  • From: Gord Dibben
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: SUMPRODUCT AND LEFT
  • From: Pete_UK
• Re: LOOKUP Help
  • From: Don Guillett
• Re: lookup question
  • From: Jonathan Horvath
• Re: How do I freeze column names to view when scrolling?
  • From: Gord Dibben
• Re: Conditional Formatting, Date
  • From: Gord Dibben
• Re: spreadsheet colum combination
  • From: Gord Dibben
• Re: returning calculation based on number
  • From: Tim Zych
• Re: How do I freeze column names to view when scrolling?
  • From: Pete_UK
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Rick Rothstein \(MVP - VB\)
• Re: How do I freeze column names to view when scrolling?
  • From: Alexis
• Re: Inserting rows automatically.
  • From: Lars-Åke Aspelin
• Re: Inserting rows automatically.
  • From: Don Guillett
• Re: XIRR Function - #NUM error
  • From: Ron Rosenfeld
• Re: Conditional Formatting, Date
  • From: chickalina
• Re: XIRR Function - #NUM error
  • From: Ron Rosenfeld
• Re: Converting specific text to numbers then sum
  • From: Mule
• Re: XIRR Function - #NUM error
  • From: KevinGH
• Re: Converting specific text to numbers then sum
  • From: Mule
• Re: XIRR Function - #NUM error
  • From: Niek Otten
• Re: Add numbers in a column, but exclude percentages in the same colum
  • From: David Biddulph
• Re: OLD PROBLEM without SOLUTION , part ||
  • From: ytayta555
• Re: SUMPRODUCT AND LEFT
  • From: K
• RE: #n/a in table data table output
  • From: Gary Brown
• Re: spreadsheet colum combination
  • From: Spiky
• Re: lookup question
  • From: Pete_UK
• Re: Percent
  • From: Spiky
• Re: lookup question
  • From: Pete_UK
• Re: lookup question
  • From: Jonathan Horvath
• Re: Delete duplicates in a row
  • From: Don Guillett
• Re: lookup question
  • From: Jonathan Horvath
• Re: converting hour values to day mean values
  • From: Max
• Re: lookup question
  • From: Pete_UK
• RE: Referencing Cells in a Summary page
  • From: Katintn
• Re: Converting specific text to numbers then sum
  • From: Mule
• Re: Pivot Tables - Can you just list data and not SUM
  • From: Debra Dalgleish
• Re: match 2 columns and return value of another
  • From: Don Guillett
• Re: SUMPRODUCT question
  • From: Per Jessen
• Re: converting hourly values into daily values
  • From: Bob Phillips
• Re: exact differnce between 2 dates & time networkdays give round off
  • From: Bob Phillips
• converting hourly values into daily values
  • From: Reza
• Code to hide sheets
  • From: Tia
• Re: SUMPRODUCT question
  • From: Per Jessen
• VBE to hide sheets "can i share it as well"
  • From: Tia
• Re: Conditional Formatting - 3 Rules - Excel 2000
  • From: Max
• RE: How to count zeros and not blank in selected range?
  • From: Stefi
• Re: Conditional Formatting - workdays only
  • From: Mike
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: T. Valko
• Re: Random numbers from several ranges
  • From: Jarek Kujawa
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular
  • From: Max
• Re: Can you change normal numbers to ordinal numbers ?
  • From: T. Valko
• Re: Multiple Questions about adding different cells
  • From: Redsphynx
• Re: Multiple Questions about adding different cells
  • From: T. Valko
• Re: Multiple Questions about adding different cells
  • From: T. Valko
• Re: Multiple Questions about adding different cells
  • From: T. Valko
• Re: Multiple Questions about adding different cells
  • From: Redsphynx
• Re: Multiple Questions about adding different cells
  • From: T. Valko
• Re: Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: T. Valko
• Re: Multiple Questions about adding different cells
  • From: Redsphynx
• Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
  • From: Max
• Re: Complicated Lookup
  • From: Max
• Re: Multiple Questions about adding different cells
  • From: T. Valko
• Re: Complicated Lookup
  • From: Trefor
• Re: Complicated Lookup
  • From: Trefor
• Multiple Questions about adding different cells
  • From: Redsphynx
• Re: Conditional Formatting for Values in 3 cells
  • From: T. Valko
• Re: Conditional Formatting for Values in 3 cells
  • From: Peo Sjoblom
• Re: Converting specific text to numbers then sum
  • From: T. Valko
• Re: ActiveX Control text box
  • From: KMorris
• Re: converting question; function, formula, or coding?
  • From: Pete_UK
• Re: Conditional Formatting, Date
  • From: Gord Dibben
• Continuation to equivalent for formula - to Mr. Harlan Grove (and not only...)
  • From: ytayta555
• OLD PROBLEM without SOLUTION , part ||
  • From: ytayta555
• Re: SUMPRODUCT AND LEFT
  • From: Pete_UK
• Re: DSUM Criteria - find exact match only
  • From: Peo Sjoblom
• Re: Perform a calculation on same cell across many worksheets
  • From: Gord Dibben
• Re: SUMPRODUCT AND LEFT
  • From: Don Guillett
• Re: returning calculation based on number
  • From: Tim Zych
• Re: formula ending with a letter
  • From: Gord Dibben
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: Countif w/semicolon separated values AND Filter
  • From: T. Valko
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: Countif w/semicolon separated values
  • From: T. Valko
• Re: Converting specific text to numbers then sum
  • From: T. Valko
• Converting specific text to numbers then sum
  • From: Mule
• RE: Calculating totals of material with feet and inches
  • From: Gary Brown
• RE: Calculating totals of material with feet and inches
  • From: Julleanna
• Re: countif from different worksheets
  • From: Bob Phillips
• Re: Summing across multiple worksheets
  • From: Bob Phillips
• Re: Percent
  • From: Spiky
• Re: Percent
  • From: Spiky
• Re: combine or if
  • From: Dave Peterson
• Re: Excel 2007 Conditional Formatting only copies absolute
  • From: Spiky
• Re: Calculating eligibility dates
  • From: Spiky
• Re: spreadsheet colum combination
  • From: Spiky
• Re: Differences between Dates
  • From: JBoyer
• Re: mutiple if statements that then compute a value
  • From: Pete_UK
• Re: How to count...
  • From: Pete_UK
• Re: HELP!!! Text count?
  • From: Pete_UK
• Re: How to count...
  • From: Rick Rothstein \(MVP - VB\)
• Re: Hide sheets
  • From: Otto Moehrbach
• RE: Percent
  • From: Pauline
• Re: Columns labeled with numbers not letters
  • From: Rick Rothstein \(MVP - VB\)
• mutiple if statements that then compute a value
  • From: cmac
• RE: Still problems with calculation of time
  • From: H. Nissen
• Re: didn't work!
  • From: Pete_UK
• Re: converting question; function, formula, or coding?
  • From: Pete_UK
• Re: In Excel, conditional format (font red) referencing another ce
  • From: KMorris
• Re: Error of slope taking into account error of the data points
  • From: Pete_UK
• Re: converting question; function, formula, or coding?
  • From: Per Erik Midtrød
• Re: combine or if
  • From: Pete_UK
• Re: combine or if
  • From: Peo Sjoblom
• Re: converting hour values to day mean values
  • From: Reza
• Re: Percent Function Help
  • From: David Biddulph
• Re: Differences between Dates
  • From: David Biddulph
• Re: Error of slope taking into account error of the data points
  • From: Pete_UK
• Re: Hide sheets
  • From: Tia
• Re: Differences between Dates
  • From: Reitanos
• Re: Autopopulate text from multiple tabs into list.
  • From: Otto Moehrbach
• Re: Help with blank cells when concatenating
  • From: Spiky
• Re: SUMIF FUNCTION
  • From: Max
• Differences between Dates
  • From: Jack
• Re: spreadsheet colum combination
  • From: Old Bob
• RE: Autopopulate text from multiple tabs into list.
  • From: BobT
• Re: SUMIF FUNCTION
  • From: PCLIVE
• Re: Hide sheets
  • From: Otto Moehrbach
• Re: Drop Down Lists
  • From: Debra Dalgleish
• Re: Latest Result
  • From: RagDyeR
• Re: LOOKUP FUNCTION HELP
  • From: JuanMarin
• Re: Complicated Lookup
  • From: Pete_UK
• Re: Drop Down Lists
  • From: Don Guillett
• Re: Drop Down Lists
  • From: Debra Dalgleish
• Re: Drop Down Lists
  • From: Don Guillett
• RE: Still problems with calculation of time
  • From: H. Nissen
• Re: how do i sort data record on two rows?
  • From: Pete_UK
• RE: Still problems with calculation of time
  • From: H. Nissen
• Re: Search formula referencing range of keywords
  • From: Malvaro
• Re: How do I lock the formatting of my worksheet but still add text?
  • From: Otto Moehrbach
• Re: Tabela Dinamica
  • From: Agarb Carvalho
• RE: Still problems with calculation of time
  • From: Mike H
• How do I lock the formatting of my worksheet but still add text?
  • From: Y2Kate
• RE: Countif w/semicolon separated values
  • From: Stefi
• Hide sheets
  • From: Tia
• RE: Countif w/semicolon separated values
  • From: crazymfr
• Re: how do i sort data record on two rows?
  • From: anyole
• Re: Summing across multiple worksheets
  • From: HL
• Re: Complicated Lookup
  • From: Trefor
• Re: Complicated Lookup
  • From: Trefor
• Re: Months in Excel Chart
  • From: Don Guillett
• Re: Calculating eligibility dates
  • From: Bob Phillips
• Re: Summing across multiple worksheets
  • From: Bob Phillips
• Re: spreadsheet colum combination
  • From: sajay
• Re: Tabela Dinamica
  • From: sajay
• Re: how do i sort data record on two rows?
  • From: Pete_UK
• Re: How can i use lookup for data in reverse column ?
  • From: sajay
• Re: Counting incidences of surname and date of birth and rearranging s
  • From: sajay
• Re: Help with blank cells when concatenating
  • From: sajay
• Summing across multiple worksheets
  • From: HL
• Re: VBE "Help"
  • From: Don Guillett
• Re: VBE "Help"
  • From: Bob Phillips
• Re: Run formula automatically
  • From: Don Guillett
• VBE "Help"
  • From: Tia
• Re: Complicated Lookup
  • From: Bernard Liengme
• Re: Extracting data
  • From: amir2000
• Re: Complicated Lookup
  • From: Pete_UK
• Re: Complicated Lookup
  • From: Pete_UK
• Re: Excel problem - sumif with multiple parameters
  • From: Bernard Liengme
• Re: Excel problem - sumif with multiple parameters
  • From: Bob Phillips
• RE: Complicated Lookup
  • From: Trefor
• Re: excel
  • From: Max
• Re: how do i sort data record on two rows?
  • From: Pete_UK
• Re: how do i sort data record on two rows?
  • From: anyole
• Re: How to calculate an average from various rows???
  • From: Bob Phillips
• Re: how do i sort data record on two rows?
  • From: Pete_UK
• Re: how do i sort data record on two rows?
  • From: anyole
• Re: Text does not carries Over
  • From: Rick Rothstein \(MVP - VB\)
• Re: How do I use the WORKDAY() for a 6days working wk excluding ho
  • From: JP.F
• Text does not carries Over
  • From: Godwin Chan
• Re: How do I use the WORKDAY() for a 6days working wk excluding ho
  • From: JP.F
• Re: Searcing foran Excel event fired.
  • From: Bob Phillips
• Re: excel
  • From: Max
• RE: SUMPRODUCT containing txt string search
  • From: Stefi
• Searcing foran Excel event fired.
  • From: Dwipayan Das
• Re: Simple cell formating question
  • From: Metafreak
• LOOKUP FUNCTION HELP
  • From: JuanMarin
• Re: How to calculate avg from various rows
  • From: T. Valko
• Re: Simple cell formating question
  • From: Fred Smith
• Re: Latest Result
  • From: T. Valko
• RE: Multiple value lookups from a table to select & sum data from
  • From: JLatham
• Re: Counting repeated data in a column
  • From: freeman
• Re: Adding multiple cell totals
  • From: Bernard Liengme
• Re: Counting repeated data in a column
  • From: Bernard Liengme
• RE: Multiple value lookups from a table to select & sum data from
  • From: brettster999
• Adding multiple cell totals
  • From: D
• Re: Simple cell formating question
  • From: Dave Peterson
• Re: How to calculate an average from various rows???
  • From: paulk2002
• Re: How to calculate avg from various rows
  • From: paulk2002
• Re: OLD PROBLEM without SOLUTION
  • From: Harlan Grove
• Re: sorting array formula
  • From: Dave Peterson
• Re: Easy way to stack column data?
  • From: Don Guillett
• Re: sorting array formula
  • From: Héctor Miguel
• Re: How do I change date yyyymmdd to a Excel-supported date format?
  • From: NoodNutt
• Re: How do I change date yyyymmdd to a Excel-supported date format?
  • From: Rick Rothstein \(MVP - VB\)
• Re: How do I change date yyyymmdd to a Excel-supported date format?
  • From: David Biddulph
• Re: Latest Result
  • From: Graham H
• Re: Latest Result
  • From: T. Valko
• Re: Latest Result
  • From: Graham H
• Re: Latest Result
  • From: Graham H
• Re: Latest Result
  • From: Ragdyer
• Re: Latest Result
  • From: Don Guillett
• RE: If formula problem
  • From: mrsmmm1000
• Re: problems with formating and concatonating time [hours]
  • From: Ron Rosenfeld
• Latest Result
  • From: Graham H
• Re: problems with formating and concatonating time [hours]
  • From: Bret Bernever
• Re: If formula problem
  • From: Graham H
• Re: If formula problem
  • From: Jim
• Re: problems with formating and concatonating time [hours]
  • From: Ron Rosenfeld
• It could be due to an error
  • From: Ex Cell
• problems with formating and concatonating time [hours]
  • From: Bret Bernever
• Re: formula ending with a letter
  • From: Rick Rothstein \(MVP - VB\)
• Re: formula ending with a letter
  • From: Don Guillett
• Re: INDIRECT formula
  • From: Don Guillett
• Re: Text detector
  • From: O2 andy
• Re: INDIRECT formula
  • From: Ken
• Re: Help with blank cells when concatenating
  • From: Gord Dibben
• Re: need formula for finding opposite (trigo)
  • From: jimE
• Re: Text detector
  • From: Max
• need formula for finding opposite (trigo)
  • From: jimE
• Re: INDIRECT formula
  • From: Don Guillett
• Re: INDIRECT formula
  • From: Ken
• Re: INDIRECT formula
  • From: Ken
• Re: INDIRECT formula
  • From: Don Guillett
• Re: Run formula automatically
  • From: Don Guillett
• Re: INDIRECT formula
  • From: Don Guillett
• Re: Trying to work out the difference in 2 cells.
  • From: Pete_UK
• Re: INDIRECT formula
  • From: Pete_UK
• INDIRECT formula
  • From: Ken
• Re: Trying to work out the difference in 2 cells.
  • From: Bernard Liengme
• Re: Help with a basic formula
  • From: stevejeffries
• Re: Multiple Criteria to Classify groups
  • From: Pete_UK
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Help with a bsic formula
  • From: Pete_UK
• Re: How to get result by using CountIF, if there are 3 conditions
  • From: Pete_UK
• Re: Searching from a table
  • From: Pete_UK
• Re: Searching from a table
  • From: gojakie
• Re: count uniques anomaly
  • From: Héctor Miguel
• Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  • From: Rick Rothstein \(MVP - VB\)
• Re: count uniques anomaly
  • From: T. Valko
• Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  • From: Pete_UK
• RE: Multiple Criteria to Classify groups
  • From: Mike H
• Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  • From: Bob Phillips
• Re: Multiple Criteria to Classify groups
  • From: Karoline
• RE: Multiple Criteria to Classify groups
  • From: Karoline
• RE: Multiple Criteria to Classify groups
  • From: Mike H
• Re: Multiple Criteria to Classify groups
  • From: Mike Middleton
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: Calculating of time
  • From: H. Nissen
• Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  • From: Rick Rothstein \(MVP - VB\)
• Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA
  • From: Pete_UK
• Re: Help with blank cells when concatenating
  • From: Rick Rothstein \(MVP - VB\)
• Re: Help with a bsic formula
  • From: Pete_UK
• Re: the value should not be more than 0.8
  • From: Pete_UK
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: How I unprotect my workbook if I failed to remember my password
  • From: Gord Dibben
• Re: How can i use lookup for data in reverse column ?
  • From: Gord Dibben
• Re: Help with blank cells when concatenating
  • From: Ron Rosenfeld
• Re: Help with blank cells when concatenating
  • From: Gord Dibben
• Re: How can I activate spell check in a protected sheet
  • From: Gord Dibben
• RE: Help with blank cells when concatenating
  • From: LM
• Re: Help with blank cells when concatenating
  • From: Ron Rosenfeld
• Re: Help with blank cells when concatenating
  • From: Don Guillett
• Re: Searching from a table
  • From: Pete_UK
• Re: How can i use lookup for data in reverse column ?
  • From: Mike H
• Re: Searching from a table
  • From: sajay
• Re: How can i use lookup for data in reverse column ?
  • From: Sandy Mann
• Re: the value should not be more than 0.8
  • From: sajay
• Re: How to get result by using CountIF, if there are 3 conditions to b
  • From: Pete_UK
• Re: How can i use lookup for data in reverse column ?
  • From: Ramesh Jaiswal (9867936636)
• Re: How can i use lookup for data in reverse column ?
  • From: Ramesh Jaiswal (9867936636)
• Re: the value should not be more than 0.8
  • From: Sandy Mann
• Re: the value should not be more than 0.8
  • From: sajay
• Re: How can i use lookup for data in reverse column ?
  • From: Sandy Mann
• Re: How can i use lookup for data in reverse column ?
  • From: Mike H
• Re: How can i use lookup for data in reverse column ?
  • From: Ramesh Jaiswal (9867936636)
• Searching from a table
  • From: gojakie
• Re: If a date range contains a leap year (date)
  • From: Ron Rosenfeld
• Re: count uniques anomaly
  • From: Bob Phillips
• Re: How can i use lookup for data in reverse column ?
  • From: Sandy Mann
• Re: Calculating of time
  • From: Sandy Mann
• Re: Wrong count of time
  • From: H. Nissen
• RE: How I unprotect my workbook if I failed to remember my password
  • From: Mike H
• Re: Wrong count of time
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to convert Number into words in EXCEL same or a new cell ?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Wrong count of time
  • From: H. Nissen
• Re: How to convert Number into words in EXCEL same or a new cell ?
  • From: Nayab
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: count uniques anomaly
  • From: Héctor Miguel
• Re: #value! Error
  • From: T. Valko
• count uniques anomaly
  • From: T. Valko
• Re: Link transposed data from one sheet to another for DB purposes
  • From: Max
• Re: Link transposed data from one sheet to another for DB purposes
  • From: Max
• Re: Link transposed data from one sheet to another for DB purposes
  • From: YMTEO
• Re: Link transposed data from one sheet to another for DB purposes
  • From: YMTEO
• Re: COUNTIF: unique names and values accross several columns.
  • From: ryguy7272
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: If a date range contains a leap year (date)
  • From: Rick Rothstein \(MVP - VB\)
• Re: COUNTIF: unique names and values accross several columns.
  • From: Dave Peterson
• Re: Wrong count of time
  • From: Rick Rothstein \(MVP - VB\)
• Re: yes / no formulas into 1/0
  • From: Dave Peterson
• Re: If a date range contains a leap year (date)
  • From: Ron Rosenfeld
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: yes / no formulas into 1/0
  • From: NoodNutt
• Wrong count of time
  • From: H. Nissen
• Re: Link transposed data from one sheet to another for DB purposes
  • From: Max
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: How to look up a value in a list and return multiple correspon
  • From: ryguy7272
• Re: Collapsing filtered macro
  • From: ryguy7272
• Re: Vlookup Function with multiple worksheets
  • From: T. Valko
• Re: If a date range contains a leap year (date)
  • From: Bob Phillips
• Re: Calculating of time
  • From: Sandy Mann
• Re: If a date range contains a leap year (date)
  • From: Rick Rothstein \(MVP - VB\)
• RE: Compiling to one sheet
  • From: ryguy7272
• Re: Vlookup Function with multiple worksheets
  • From: ryguy7272
• Re: Updating Imported Data (Excell 2003)
  • From: Ragdyer
• Re: Filter latest date from multiple date entries
  • From: Fred Smith
• Re: Mean separation by LSD value
  • From: Mike Middleton
• RE: extract number from alphanumric
  • From: ryguy7272
• Re: Column to row
  • From: Alan Beban
• Re: If a date range contains a leap year (date)
  • From: Ron Rosenfeld
• Re: If a date range contains a leap year (date)
  • From: Ron Rosenfeld
• Re: If a date range contains a leap year (date)
  • From: joeu2004
• Re: If a date range contains a leap year (date)
  • From: joeu2004
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: How to look up a value in a list and return multiple corresponding values
  • From: NoodNutt
• Re: YTD average cust calulation
  • From: NoodNutt
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: YTD average cust calulation
  • From: NoodNutt
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• RE: Possible getpivotdata with offset?
  • From: ryguy7272
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Wrap Text Problem + a little VB :)
  • From: NoodNutt
• Re: Conditional Formatting - workdays only
  • From: T. Valko
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: How do I use the WORKDAY() for a 6days working wk excluding holida
  • From: Bob Phillips
• RE: Calculate and display year and month
  • From: Teethless mama
• Re: how do i sort data record on two rows?
  • From: vezerid
• Re: Column to row
  • From: vezerid
• Re: Associate values in worksheet??
  • From: Pete_UK
• Re: how do i sort data record on two rows?
  • From: anyole
• Associate values in worksheet??
  • From: Jon M
• Re: Data Validation lists update orginal cell with list update
  • From: Debra Dalgleish
• Re: Pivot Tables & Conditional Formatting
  • From: Debra Dalgleish
• Re: Calculating of time
  • From: H. Nissen
• Re: Lookup where column data does not match
  • From: Dave Peterson
• Re: Changing the headers on an excel worksheet from Numbers back to le
  • From: Cimjet
• Re: Changing the headers on an excel worksheet from Numbers back to le
  • From: Dave Peterson
• Re: May be a long-shot, but.....
  • From: Dave Peterson
• Re: Searching specific record using VLOOKUP function.
  • From: Dave Peterson
• Changing the headers on an excel worksheet from Numbers back to le
  • From: Maxine
• Filter latest date from multiple date entries
  • From: padmanaban . mm
• Counting specific letters in multiple cells
  • From: tohlz
• RE: Stop text carries over
  • From: Godwin Chan
• Re: Stop text carries over
  • From: Nayab
• Re: Calendar or date formulas
  • From: Nayab
• Re: Calendar or date formulas
  • From: Pete_UK
• Re: yes / no formulas into 1/0
  • From: Pete_UK
• yes / no formulas into 1/0
  • From: The snow Queen
• Re: How to calculate an average from various rows???
  • From: Bob Phillips
• Re: If a date range contains a leap year (date)
  • From: Bob Phillips
• Re: Conditional Formatting - workdays only
  • From: Mike
• Re: Advice on a couple of things if possible.
  • From: Chiccada
• Re: Searching specific record using VLOOKUP function.
  • From: dev
• Re:How would I attach or assign values to a trendline?
  • From: Dave Curtis
• Re: Copy from another sheet but spreading the data out down the co
  • From: Ragdyer
• Protect columns with password
  • From: Anders
• Re: Restricting cell data amount
  • From: Héctor Miguel
• Re: not working for me
  • From: T. Valko
• Re: Count rows after filter
  • From: Héctor Miguel
• Re: Restricting cell data amount
  • From: NoodNutt
• Re: How to calculate avg from various rows
  • From: T. Valko
• not working for me
  • From: justin something
• How to calculate avg from various rows
  • From: paulk2002
• Re: May be a long-shot, but.....
  • From: T. Valko
• How to calculate an average from various rows???
  • From: paulk2002
• Re: #value! Error
  • From: T. Valko
• May be a long-shot, but.....
  • From: chuckden
• Re: Restricting cell data amount
  • From: Héctor Miguel
• RE: Pivot Tables & Conditional Formatting
  • From: ryguy7272
• Re: Copy from another sheet but spreading the data out down the co
  • From: Peter
• Re: Restricting cell data amount
  • From: NoodNutt
• RE: Data Validation lists update orginal cell with list update
  • From: ryguy7272
• Data Validation lists update orginal cell with list update
  • From: roniaelm
• Re: Restricting cell data amount
  • From: Héctor Miguel
• Restricting cell data amount
  • From: NoodNutt
• Re: Nested IF Function not working
  • From: T. Valko
• Re: Set fixed Decimal places with no rounding
  • From: Fred Smith
• Re: Set fixed Decimal places with no rounding
  • From: recrit
• Re: Updating data in one Worksheet and propagating it to others
  • From: Pete_UK
• Re: Link transposed data from one sheet to another for DB purposes
  • From: YMTEO
• Re: Copy from another sheet but spreading the data out down the col
  • From: RagDyer
• Re: Nested IF Function not working
  • From: Harlan Grove
• Re: I need to count a row with something in it
  • From: Elvira
• Re: OLD PROBLEM without SOLUTION
  • From: Harlan Grove
• Re: I need to count a row with something in it
  • From: T. Valko
• Re: I need to count a row with something in it
  • From: Elvira
• Re: How can I activate spell check in a protected sheet
  • From: jaf
• RE: EQUIVALENT for this FORMULA , please
  • From: TomPl
• Re: rounding decimals to nearest quarter
  • From: Bob Phillips
• Re: rounding decimals to nearest quarter
  • From: T. Valko
• Re: if value is between two numbers
  • From: RagDyer
• Re: if value is between two numbers
  • From: RagDyer
• Re: Insert Copied Rows or Drag/Drop Formulas While Protected
  • From: Gord Dibben
• Re: Insert Copied Rows or Drag/Drop Formulas While Protected
  • From: Per Jessen
• Re: split data into seperate worksheets by criteria
  • From: Ron de Bruin
• Re: if value is between two numbers
  • From: RagDyer
• Re: Isolate text immediately preceding "("
  • From: Tacrier
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: alphabetical on column c
  • From: Per Jessen
• Re: Nested IF Function not working
  • From: RagDyer
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• if value is between two numbers
  • From: samuel
• Re: If a date range contains a leap year (date)
  • From: Rick Rothstein \(MVP - VB\)
• How do u sort many items out a spread sheet in excel
  • From: csuprano
• Re: Nested IF Function not working
  • From: Rick Rothstein \(MVP - VB\)
• Re: OLD PROBLEM without SOLUTION
  • From: Harlan Grove
• Re: =SUMPRODUCT(COUNTIF(O153:S550,{"Unknown"}),{1})
  • From: Bob Phillips
• Re: Nested IF Function not working
  • From: Dave Peterson
• Re: How to find the highest name in an alphabetic list?
  • From: Don Guillett
• Re: OLD PROBLEM without SOLUTION
  • From: Harlan Grove
• Re: Isolate text immediately preceding "("
  • From: Rick Rothstein \(MVP - VB\)
• Re: split data into seperate worksheets by criteria
  • From: Tieske
• Re: Comparing Lists
  • From: Tieske
• EQUIVALENT for this FORMULA , please
  • From: ytayta555
• RE: FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
  • From: Gary Brown
• Re: Sorting text and numbers from multiple tabs
  • From: Gord Dibben
• Re: FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
  • From: T. Valko
• Re: OLD PROBLEM without SOLUTION
  • From: Gord Dibben
• FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
  • From: vikkib
• Re: Isolate text immediately preceding "("
  • From: Sandy Mann
• Re: Isolate text immediately preceding "("
  • From: Ron Rosenfeld
• Re: How Do I DO IF with DATE
  • From: Sandy Mann
• Sorting text and numbers from multiple tabs
  • From: Jessabez
• Re: Nested if/then or array???
  • From: Bob Phillips
• Re: How to find the highest name in an alphabetic list?
  • From: Grd
• RE: Change Workbook Password
  • From: Gary Brown
• RE: Calculate a ratio of two numbers to the total
  • From: rhh29
• RE: Change Workbook Password
  • From: iperlovsky
• Re: Ungroup "+" on a protected sheet
  • From: Dave Peterson
• RE: Change Workbook Password
  • From: Gary Brown
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: copying from pdf into excel ?
  • From: Gord Dibben
• Re: Drop down list help
  • From: Gord Dibben
• Re: Advice on a couple of things if possible.
  • From: Gord Dibben
• RE: Formula
  • From: dazoloko via OfficeKB.com
• Re: I need to count a row with something in it
  • From: T. Valko
• Re: Help with if statement (more than 7)
  • From: T. Valko
• How Do I DO IF with DATE
  • From: Dig
• Re: Summ figures that are not struck-through
  • From: Gord Dibben
• Re: Counting specific letters in a cell
  • From: RagDyeR
• RE: Advice on a couple of things if possible.
  • From: Gary Brown
• Re: Counting specific letters in a cell
  • From: RagDyeR
• Re: Counting specific letters in a cell
  • From: Pete_UK
• Re: Figuring and adding time in Excel
  • From: Bob Phillips
• Re: Figuring and adding time in Excel
  • From: vezerid
• Re: Nested if/then or array???
  • From: Bob Phillips
• Re: If a date range contains a leap year (date)
  • From: Bob Phillips
• Re: convert 80521 to 05/21/08
  • From: vezerid
• Re: If a date range contains a leap year (date)
  • From: vezerid
• Calculate a ratio of two numbers to the total
  • From: rhh29
• Re: Copy Left Word
  • From: Pete_UK
• Re: convert 80521 to 05/21/08
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to find the highest name in an alphabetic list?
  • From: Don Guillett
• Re: convert 80521 to 05/21/08
  • From: vezerid
• Re: Linking cell ranges between rows and columns
  • From: vezerid
• convert 80521 to 05/21/08
  • From: KKay
• Re: How to find the highest name in an alphabetic list?
  • From: vezerid
• Re: Copy Left Word
  • From: Alectrical
• Re: how do i sort data record on two rows?
  • From: vezerid
• Re: Combining information from rows
  • From: vezerid
• =SUMPRODUCT(COUNTIF(O153:S550,{"Unknown"}),{1})
  • From: Jon Car
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: check certain cells for data before saving file
  • From: vezerid
• Re: Help with if statement (more than 7)
  • From: Blessedx3
• Re: Take first word out of cell and put it in a new cell
  • From: LM
• Re: simple timesheet
  • From: Larry
• Formula
  • From: dazoloko via OfficeKB.com
• Re: how do i sort data record on two rows?
  • From: anyole
• Re: I need to count a row with something in it
  • From: Rick
• Re: sumbycolor formula
  • From: Bob Phillips
• Re: finding and replacing
  • From: Pete_UK
• Re: work book open _ event
  • From: Dave Peterson
• Re: Take first word out of cell and put it in a new cell
  • From: Dave Peterson
• Re: taking conditions from one spreadsheet to another
  • From: Pete_UK
• Re: Drop down list help
  • From: SGfla
• Re: Copy Left Word
  • From: Ron Rosenfeld
• Re: Copy Left Word
  • From: Pete_UK
• Re: taking conditions from one spreadsheet to another
  • From: Pete_UK
• Re: Moving The Decimal Point Of Existing Entries
  • From: Pete_UK
• Re: REALLY easy question
  • From: Pete_UK
• RE: REALLY easy question
  • From: JR
• Re: Take first word out of cell and put it in a new cell
  • From: Bob Phillips
• Re: Calculating of time
  • From: Sandy Mann
• Re: Calculating of time
  • From: H. Nissen
• Re: Take first word out of cell and put it in a new cell
  • From: Bob Phillips
• Re: count if using columns not range of cells
  • From: Bob Phillips
• Re: Countif function
  • From: Bob Phillips
• REALLY easy question
  • From: Thatgirl
• Balenciaga Giant Part Time Bag Cream 328B - www.luxury-gift.org
  • From: yxs069
• nike air force shoes AFS071107 - www.luxury-gift.org
  • From: yxs069
• nike air force shoes AFS071020 - www.luxury-gift.org
  • From: yxs069
• Re: Summ figures that are not struck-through
  • From: Héctor Miguel
• Re: Countif function
  • From: Murray
• Re: Calculating of time
  • From: H. Nissen
• Re: Spreadsheet for bowling games?
  • From: T. Valko
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Spreadsheet for bowling games?
  • From: T. Valko
• Using Tabs within the allow users to edit range while sheet protec
  • From: Jess
• Countif function
  • From: Paul10r
• RE: How to convert data from Landscape to vertical
  • From: liem
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• RE: How to convert data from Landscape to vertical
  • From: liem
• RE: Vlookup with Multiple like values in the reference column
  • From: bpeltzer
• Re: Formulas new in excel 2007 not compatible with 97-03
  • From: Fred Smith
• RE: How to convert data from Landscape to vertical
  • From: Teethless mama
• Re: How do I round a number to the nearest .49 in a cell that has
  • From: T. Valko
• RE: If Then forumal
  • From: Teethless mama
• Re: If Then forumal
  • From: NoodNutt
• Re: how do i substitute filename in a formula
  • From: Pete_UK
• Re: Help with Formulas
  • From: Pete_UK
• Complicated comparison and highlighting question
  • From: Aimee
• Re: Help with Formulas
  • From: Nadine
• Re: Help with if statement (more than 7)
  • From: T. Valko
• Re: how do i substitute filename in a formula
  • From: Pete_UK
• Re: Help with Formulas
  • From: Pete_UK
• Re: IF and SUMIF
  • From: Sandy Mann
• Charts not updating
  • From: vitorjose
• Re: Drop down list help
  • From: Gord Dibben
• Re: Help with if statement (more than 7)
  • From: Sandy Mann
• Help with Formulas
  • From: Nadine
• Re: Dragging Down a Formula
  • From: JBoyer
• Re: Calculating of time
  • From: Sandy Mann
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: Sum = to greater than, change it to 1
  • From: Gord Dibben
• Re: How do I round a number to the nearest .49 in a cell that has a fo
  • From: T. Valko
• Re: How do I round a number to the nearest .49 in a cell that has a fo
  • From: T. Valko
• Re: make a single cell always equal zero
  • From: Spiky
• Re: Setting a sale price and rounding up
  • From: Gord Dibben
• Re: Calculating of time
  • From: H. Nissen
• Re: Diference between two hours in Minutes
  • From: Pete_UK
• Re: how do i sort data record on two rows?
  • From: Gord Dibben
• Re: How do I round a number to the nearest .49 in a cell that has a fo
  • From: Pete_UK
• Re: Copy/Past/Transpose Formulas
  • From: Gord Dibben
• Re: Copy/Past/Transpose Formulas
  • From: Gord Dibben
• RE: Help with if statement (more than 7)
  • From: jcheko
• Re: Drop down list help
  • From: Gord Dibben
• Re: Drop down list help
  • From: Gord Dibben
• Help with if statement (more than 7)
  • From: Blessedx3
• Re: Formula to evaluate dates
  • From: Pete_UK
• Re: Diference between two hours in Minutes
  • From: Pete_UK
• RE: Formula to evaluate dates
  • From: Gary Brown
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: Vlookup Function with multiple worksheets
  • From: T. Valko
• Re: I am having some trouble with a long formula and multiple spre
  • From: Pete_UK
• Re: string lookup combined with SUM
  • From: Pete_UK
• Re: I need to count a row with something in it
  • From: T. Valko
• Re: count if using columns not range of cells
  • From: Bob Phillips
• Re: Calculating of time
  • From: Sandy Mann
• Re: Calculating of time
  • From: Sandy Mann
• Re: IF and SUMIF
  • From: GoBow777
• RE: Vlookup with Multiple like values in the reference column
  • From: bpeltzer
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: Vlookup Function with multiple worksheets
  • From: Dahliahlu
• Sum = to greater than, change it to 1
  • From: Kim
• Re: Calculating of time
  • From: H. Nissen
• Re: Drop down list help
  • From: SGfla
• Re: string lookup combined with SUM
  • From: T. Valko
• Re: Drop down list help
  • From: SGfla
• Re: OLD PROBLEM without SOLUTION
  • From: Harlan Grove
• Re: I am having some trouble with a long formula and multiple spre
  • From: LiveUser
• Re: string lookup combined with SUM
  • From: Pete_UK
• Re: check certain cells for data before saving file
  • From: Anthony
• Re: Counta function
  • From: T. Valko
• Re: Calculating of time
  • From: Sandy Mann
• string lookup combined with SUM
  • From: bestrugger
• Re: Cell Formats
  • From: vezerid
• Re: Cell Formats
  • From: Pete_UK
• Re: Worksheet Formula Returning Sum of a Series
  • From: Dana DeLouis
• Re: check certain cells for data before saving file
  • From: vezerid
• Re: check certain cells for data before saving file
  • From: Anthony
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: Calculating of time
  • From: H. Nissen
• Re: Combining information from rows
  • From: vezerid
• Re: OLD PROBLEM without SOLUTION
  • From: ytayta555
• Re: I am having some trouble with a long formula and multiple spre
  • From: Pete_UK
• Re: check certain cells for data before saving file
  • From: vezerid
• Re: I am having some trouble with a long formula and multiple spre
  • From: LiveUser
• Re: how do i sort data record on two rows?
  • From: vezerid
• Re: count if, but not if
  • From: LiveUser
• Re: sumif or vlookup help
  • From: Pete_UK
• Re: sumif or vlookup help
  • From: Bob Phillips
• Re: count if, but not if
  • From: Bob Phillips
• Re: OLD PROBLEM without SOLUTION
  • From: Pete_UK
• Re: excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3
  • From: Pete_UK
• Re: pivot tables
  • From: YP Koh
• Re: Calculating Average
  • From: Pete_UK
• Re: Find a value Using a lookup table multiple columns and rows
  • From: glasspumpkin
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: count if, but not if
  • From: LiveUser
• sumif or vlookup help
  • From: Katie
• OLD PROBLEM without SOLUTION
  • From: ytayta555
• RE: count if using columns not range of cells
  • From: Opal
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: count if, but not if
  • From: Bob Phillips
• Re: count if using columns not range of cells
  • From: Bob Phillips
• Re: Worksheet Formula Returning Sum of a Series
  • From: monir
• Re: Sum when cell's value in Named List
  • From: Bob Phillips
• Re: Advancing lookups and comparisons
  • From: ahern79
• Re: Dates-Conversion
  • From: vezerid
• Re: Searching specific record using VLOOKUP function.
  • From: Dave Peterson
• Re: Find a value Using a lookup table multiple columns and rows
  • From: recrit
• Re: Searching specific record using VLOOKUP function.
  • From: Dave Peterson
• Re: How can I make BINGO boards using EXCEL?
  • From: Glenn
• count if using columns not range of cells
  • From: Opal
• Re: Need to Count the number of times a value occurs within a dt r
  • From: Max
• Re: extract number from alphanumric
  • From: recrit
• Re: I am having some trouble with a long formula and multiple spreadsh
  • From: Pete_UK
• extract number from alphanumric
  • From: Hardeep_kanwar
• Copy/Past/Transpose Formulas
  • From: jackle298
• RE: SUMPRODUCT containing txt string search
  • From: sideshowjack
• Re: SUMPRODUCT containing txt string search
  • From: Bob Phillips
• RE: Find a value Using a lookup table multiple columns and rows
  • From: glasspumpkin
• Re: calculate the the diffrence between 2 Dates and time
  • From: Pete_UK
• Re: calculate the the diffrence between 2 Dates and time
  • From: Bob Phillips
• Re: count if, but not if
  • From: Bob Phillips
• RE: Multiple If(AND
  • From: John C
• RE: SUMPRODUCT containing txt string search
  • From: Stefi
• RE: SUMPRODUCT containing txt string search
  • From: sideshowjack
• RE: Compiling to one sheet
  • From: ahern79
• Re: Searching specific record using VLOOKUP function.
  • From: Dave Peterson
• Re: Searching specific record using VLOOKUP function.
  • From: dev
• SUMPRODUCT containing txt string search
  • From: sideshowjack
• Re: Hyperlinks and spaces
  • From: Pete_UK
• Re: where in excel 2007 is old file properties menu
  • From: Bob Phillips
• Re: Im doing something wrong in Visual basic for sure
  • From: Bob Phillips
• Re: Im doing something wrong in Visual basic for sure
  • From: Tia
• Re: Hyperlinks and spaces
  • From: Graham H
• Re: pull down list and single value allowed
  • From: Pete_UK
• Re: Hyperlinks and spaces
  • From: Pete_UK
• RE: Im doing something wrong in Visual basic for sure
  • From: Stefi
• Im doing something wrong in Visual basic for sure
  • From: Tia
• Re: Dual income calculator help
  • From: Pete_UK
• Re: Worksheet Formula Returning Sum of a Series
  • From: Shane Devenshire
• Re: Worksheet Formula Returning Sum of a Series
  • From: Shane Devenshire
• Re: Searching specific record using VLOOKUP function.
  • From: Roger Govier
• Re: vlookup returns #n/a
  • From: Michael Dieckmann
• Re: Counta function
  • From: Shane Devenshire
• Hyperlinks and spaces
  • From: Graham H
• Re: =COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS(M3:M17,"=LHR",P
  • From: Bob Phillips
• Re: Worksheet Formula Returning Sum of a Series
  • From: Bob Phillips
• Re: Elapsed Time
  • From: Stefi
• Re: Elapsed Time
  • From: KevinT
• Re: How to convert an address file from Word into Excel?
  • From: Mr BT
• Re: Counta function
  • From: T. Valko
• Comments, is there a way to export them?
  • From: Mr BT
• Re: Sum when cell's value in Named List
  • From: YY san.
• Counta function
  • From: Help
• Re: simple timesheet
  • From: Dave Peterson
• Re: Dual income calculator help
  • From: Dave Peterson
• Re: return cell within date range
  • From: T. Valko
• simple timesheet
  • From: Larry
• Re: How to determine the max. value?
  • From: T. Valko
• Re: Search formula referencing range of keywords
  • From: T. Valko
• Re: Dual income calculator help
  • From: Pete_UK
• Re: How to determine the max. value?
  • From: Eric
• Re: SUMPRODUCT/COUNTIF
  • From: IreneW
• Re: Countif versus SumProduct
  • From: Pete_UK
• Compiling to one sheet
  • From: Ahern79
• Re: SUMPRODUCT/COUNTIF
  • From: Bob Phillips
• Compiling to one sheet
  • From: Ahern79
• Re: How to determine the max. value?
  • From: Eric
• Re: Hyperlink function in an If function
  • From: Pete_UK
• Re: Countif using multiple references
  • From: K
• Re: reference every 19 rows
  • From: Gord Dibben
• Re: Excel sort ( exclude letters include hyphens)?
  • From: always confused
• Re: SUMPRODUCT/COUNTIF
  • From: Bob Phillips
• Re: Calculating of time
  • From: Sandy Mann
• Re: Need to Count the number of times a value occurs within a dt r
  • From: Max
• Re: Sum when cell's value in Named List
  • From: Spiky
• Re: Search formula referencing range of keywords
  • From: Malvaro
• Re: Vlookup Function with multiple worksheets
  • From: T. Valko
• Re: Need to Count the number of times a value occurs within a dt r
  • From: Max
• Re: How do I pull data for consecutive months in an Excel spreadsheet
  • From: Spiky
• Re: Template
  • From: Tieske
• Re: How to determine the max. value?
  • From: T. Valko
• Re: Adding a Number and Formula Text and Evaluating
  • From: Gord Dibben
• Re: Drop down list help
  • From: Gord Dibben
• Re: Create user id fm LName, FName
  • From: Rick Rothstein \(MVP - VB\)
• Re: Dates-Conversion
  • From: Lisa12
• RE: Create user id fm LName, FName
  • From: Teethless mama
• Re: Create user id fm LName, FName
  • From: willwonka
• Re: How do I pull data for consecutive months in an Excel spreadsheet
  • From: Glenn
• Re: Countif with multiple criteria
  • From: Pete_UK
• Re: Countif versus SumProduct
  • From: Pete_UK
• Countif with multiple criteria
  • From: Debbie Whitaker
• Re: Dates-Conversion
  • From: Lisa12
• Re: sorting datasets on two rows
  • From: anyole
• Re: SUM Product formula help needed
  • From: T. Valko
• Re: Excel sort ( exclude letters include hyphens)?
  • From: Pete_UK
• Re: Calculating of time
  • From: H. Nissen
• Re: SUM Product formula help needed
  • From: T. Valko
• Re: SUM Product formula help needed
  • From: Pete_UK
• Re: SUM Product formula help needed
  • From: Bob Phillips
• Re: SUM Product formula help needed
  • From: Peo Sjoblom
• Re: Dates-Conversion
  • From: vezerid
• Re: Dates-Conversion
  • From: vezerid
• Re: Filtering in Excel 2007
  • From: Peo Sjoblom
• Re: Calculating of time
  • From: Bob Phillips
• Re: Conditional Formatting - workdays only
  • From: T. Valko
• Re: Sum when cell's value in Named List
  • From: Bob Phillips
• Re: get a range corresponding to a particular col header
  • From: Spiky
• Re: Pivot Table - divide two results
  • From: Carolina
• Re: Spreadsheet for bowling games?
  • From: Spiky
• Re: Dates-Conversion
  • From: Lisa12
• Re: 1st sheet being displayed
  • From: Gord Dibben
• Re: excel 2003 drop-down box color changes how
  • From: Gord Dibben
• Re: Excel - adding a picture that will pop up when I wand over it?
  • From: Gord Dibben
• Re: Need help with a formula
  • From: recrit
• Re: Need help with a formula
  • From: Roger Govier
• Re: Sum when cell's value in Named List
  • From: Per Jessen
• Re: vlookup returns #n/a
  • From: Dave Peterson
• Re: Sum when cell's value in Named List
  • From: Roger Govier
• How to determine the max. value?
  • From: Eric
• How to determine the max. value?
  • From: Eric
• Re: make a single cell always equal zero
  • From: Spiky
• Re: Excel sort ( exclude letters include hyphens)?
  • From: Pete_UK
• Re: Help with Functions & formulas
  • From: Sandy Mann
• MSOffice 2007 - Excel - Subtotal Function
  • From: Cheryl S
• Re: sorting datasets on two rows
  • From: Pete_UK
• Re: Need to Count the number of times a value occurs within a dt r
  • From: Max
• Re: Need to Count the number of times a value occurs within a dt r
  • From: Gina
• Re: how can i determine number of weeks between 2 dates
  • From: Sandy Mann
• Re: Help with Functions & formulas
  • From: Bob Phillips
• RE:oops problem Setting up spreadsheet to calculate time
  • From: Meenie
• Re: Elapsed Time
  • From: Stefi
• Re: On opening a worksheet move focus to a cell based on date
  • From: Nayab
• Re: Comments question
  • From: Nayab
• Re: Adding more than one maximum
  • From: Max
• Re: Can Excel automatically insert current date in a cell?
  • From: Paul D. Simon
• Re: Elapsed Time
  • From: KevinT
• Re: how do I attach a scanned pdf file to a cell so that I can bring
  • From: Dave Peterson
• Re: sorting datasets on two rows
  • From: anyole
• Re: 1st sheet being displayed
  • From: Tia
• Re: return cell within date range
  • From: Bob Phillips
• Re: Elapsed Time
  • From: Roger Govier
• 1st sheet being displayed
  • From: Tia
• Re: Elapsed Time
  • From: Bob Phillips
• Re: Count occurances of a name over previous 12 months
  • From: Bob Phillips
• Re: Conditional Formatting - workdays only
  • From: Mike
• Re: Count a specific month in a column
  • From: Pete_UK
• Re: Sort function
  • From: Pete_UK
• Re: Formulas new in excel 2007 not compatible with 97-03
  • From: Bob Phillips
• Re: Finding text
  • From: Jarek Kujawa
• Re: Auto update worksheets
  • From: Fred Smith
• Re: Formulas new in excel 2007 not compatible with 97-03
  • From: Fred Smith
• Re: Formulas new in excel 2007 not compatible with 97-03
  • From: T. Valko
• Re: Can't find certain date in search
  • From: Fred Smith
• Re: Why is the sum formula is not adding correctly?
  • From: joeu2004
• Re: Search formula referencing range of keywords
  • From: T. Valko
• Re: Collapsing filtered macro
  • From: Debra Dalgleish
• Re: Can't find certain date in search
  • From: Ken
• Re: Compare 400 cells to one
  • From: Max
• Re: Count a specific month in a column
  • From: Elaine
• Re: Count a specific month in a column
  • From: Dave Peterson
• Re: Count a specific month in a column
  • From: Pete_UK
• RE: Count a specific month in a column
  • From: Elaine
• Re: Dates-Conversion
  • From: ward376
• Re: Dates-Conversion
  • From: ShaneDevenshire
• RE: Using v-lookup with multiple identifiers
  • From: ShaneDevenshire
• Re: Complex IF formula
  • From: Ron Rosenfeld
• Re: Using v-lookup with multiple identifiers
  • From: Pete_UK
• Re: Can't find certain date in search
  • From: Fred Smith
• Re: Auto update worksheets
  • From: Pete_UK
• Re: Auto update worksheets
  • From: J James
• Can't find certain date in search
  • From: Ken
• Re: Auto update worksheets
  • From: Pete_UK
• Re: Auto update worksheets
  • From: J James
• Re: Finding text
  • From: Meebers
• Re: Use a cell to name a file to be opened.
  • From: Dave Peterson
• Re: Auto update worksheets
  • From: Pete_UK
• Hyperlink function in an If function
  • From: GoBow777
• Search formula referencing range of keywords
  • From: Malvaro