microsoft.public.excel.worksheet.functions

• Thread Index

---

• Re: Referring to Sheet locations in a formula
  • From: PCLIVE
• Re: Showing Top 30 with array-formula?
  • From: RagDyeR
• Re: Referring to Sheet locations in a formula
  • From: T. Valko
• Re: combination of AutoFilter and array formula?
  • From: Don Guillett
• Referring to Sheet locations in a formula
  • From: PCLIVE
• Re: Returning a column name or number
  • From: Harlan Grove
• Re: Excel Formula add if someone types PTO have it =0
  • From: RagDyeR
• Re: Showing Top 30 with array-formula?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Showing Top 30 with array-formula?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Returning a column name or number
  • From: Sandy Mann
• Re: Showing Top 30 with array-formula?
  • From: Ron Rosenfeld
• Re: Showing Top 30 with array-formula?
  • From: Bernd P
• Re: change background color of a cell with an "IF" command?
  • From: Sandy Mann
• Re: combination of AutoFilter and array formula?
  • From: mark
• Challenging Formula. Need help with writing a formula
  • From: tom
• Re: Showing Top 30 with array-formula?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Excel Function
  • From: Rick Rothstein \(MVP - VB\)
• Re: Excel Function
  • From: T. Valko
• Re: Excel Function
  • From: fuller . susieq
• Re: Monter IF statement??? sorry long question
  • From: David Biddulph
• Re: Excel Function
  • From: T. Valko
• Excel Function
  • From: fuller . susieq
• Re: Monter IF statement??? sorry long question
  • From: Steve
• Re: How do I calculate a persn's age in years & months in Excel?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Showing Top 30 with array-formula?
  • From: Ron Rosenfeld
• Re: Monter IF statement??? sorry long question
  • From: David Biddulph
• RE: Does loop function cause this problem?
  • From: JLatham
• RE: Code simplification
  • From: JLatham
• Re: Monter IF statement??? sorry long question
  • From: Steve
• Re: Monter IF statement??? sorry long question
  • From: David Biddulph
• Re: Showing Top 30 with array-formula?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Code simplification
  • From: Don Guillett
• RE: Dollar / Euro sign
  • From: FloMM2
• RE: Dollar / Euro sign
  • From: FloMM2
• Code simplification
  • From: Sandy
• Re: Showing Top 30 with array-formula?
  • From: Jen . Carllson
• Re: Showing Top 30 with array-formula?
  • From: Jen . Carllson
• Re: Showing Top 30 with array-formula?
  • From: Bernd P
• Re: Excel Formula add if someone types PTO have it =0
  • From: Roger Govier
• Re: Showing Top 30 with array-formula?
  • From: Jen
• Re: Showing Top 30 with array-formula?
  • From: Rick Rothstein \(MVP - VB\)
• Showing Top 30 with array-formula?
  • From: Jen . Carllson
• Re: IF
  • From: joeu2004
• Re: ISBLANK()
  • From: Harlan Grove
• Re: ISBLANK()
  • From: Peo Sjoblom
• Re: USE IF CONDITION FOR 2DATA
  • From: deen
• Re: Is conditional formatting or formula possible by cell color?
  • From: MartinW
• Re: Is conditional formatting or formula possible by cell color?
  • From: Rick Rothstein \(MVP - VB\)
• Re: combination of AutoFilter and array formula?
  • From: Don Guillett
• Show Top 10 with array formula
  • From: Jen
• Re: Bizarre Excel 03 Problem - autosum not updating when cells are cha
  • From: Peo Sjoblom
• Re: any ideas appreciated
  • From: driller
• Re: Excel Formula add if someone types PTO have it =0
  • From: Ragdyer
• Re: Excel Formula add if someone types PTO have it =0
  • From: Ragdyer
• Re: any ideas appreciated
  • From: driller
• Re: combination of AutoFilter and array formula?
  • From: Don Guillett
• Re: convert columns to rows
  • From: Peo Sjoblom
• Re: any ideas appreciated
  • From: T. Valko
• Re: formula to count easily
  • From: T. Valko
• Re: convert columns to rows
  • From: Piscator
• RE: calculating sample sizes for independent groups
  • From: Ariel
• Re: HELP--- adding duration of times
  • From: Peo Sjoblom
• Re: Is there a way to sort a list of multi-line items?
  • From: Harlan Grove
• RE: calculating sample sizes for independent groups
  • From: Billy Liddel
• Re: HELP--- adding duration of times
  • From: Piscator
• Re: Form drop down list
  • From: Debra Dalgleish
• RE: any ideas appreciated
  • From: driller
• Re: Excel Formula add if someone types PTO have it =0
  • From: PCLIVE
• Re: Advanced Sumif formula
  • From: Rick Rothstein \(MVP - VB\)
• Re: Advanced Sumif formula
  • From: Rick Rothstein \(MVP - VB\)
• Re: Excel Formula add if someone types PTO have it =0
  • From: Ragdyer
• Re: Excel Formula add if someone types PTO have it =0
  • From: PCLIVE
• Re: why do i get #value! using this formula
  • From: Naraine Ramkirath
• Re: Rounding a sum to the quarter hour.
  • From: Peo Sjoblom
• Re: Rounding a sum to the quarter hour.
  • From: T. Valko
• Re: Sequential VLookups
  • From: Naraine Ramkirath
• RE: any ideas appreciated
  • From: driller
• Re: ISBLANK()
  • From: PCLIVE
• RE: any ideas appreciated
  • From: driller
• Re: why do i get #value! using this formula
  • From: Harlan Grove
• RE: any ideas appreciated
  • From: driller
• Re: How to ignore #DIV/0! in Sumproduct formula
  • From: Harlan Grove
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Rick Rothstein \(MVP - VB\)
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Harlan Grove
• Re: How do I use an If= statement with an apostrophe (IF(s4="jack's",.
  • From: Vasant Nanavati
• RE: Dollar / Euro sign
  • From: Yendorian
• Re: why do i get #value! using this formula
  • From: Naraine Ramkirath
• Re: formula to count easily
  • From: driller
• Re: How to ignore #DIV/0! in Sumproduct formula
  • From: deeds
• Re: Forming a trend line
  • From: Jerry W. Lewis
• why do i get #value! using this formula
  • From: Naraine Ramkirath
• Re: Forming a trend line
  • From: Bernard Liengme
• Re: Searching within an excel document
  • From: Roger Govier
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Rick Rothstein \(MVP - VB\)
• Please help me win my fantasy football league by answering this excel ?
  • From: nicholas.deselle@xxxxxxxxx
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Harlan Grove
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Harlan Grove
• Re: calculating sample sizes for independent groups
  • From: Vasant Nanavati
• Re: Another SUMPRODUCT Query
  • From: Harlan Grove
• Re: Round Function Philosophy
  • From: Harlan Grove
• Re: Forming a trend line
  • From: Aaron
• Re: Another SUMPRODUCT Query
  • From: T. Valko
• Re: formula to count easily
  • From: T. Valko
• Re: formula to count easily
  • From: driller
• Re: How to use Check Box input in a cell's fomula?
  • From: Dave Peterson
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Gord Dibben
• Re: how do i clean out all non-letter characters from an excel sheet
  • From: Pete_UK
• Re: formula to count easily
  • From: driller
• Re: formula to count easily
  • From: T. Valko
• Re: Returning multiple indices for a lookup
  • From: T. Valko
• Re: Can IF do this?
  • From: Pete_UK
• Re: List of Excel 2003 Functions
  • From: David Biddulph
• how do i clean out all non-letter characters from an excel sheet
  • From: jgarbis
• Re: Time formatting
  • From: Gord Dibben
• Can IF do this?
  • From: D.P. Roberts
• Re: Format
  • From: Peo Sjoblom
• RE: formula to count easily
  • From: driller
• Re: Format
  • From: Pete_UK
• Re: formula to count easily
  • From: T. Valko
• Re: Format
  • From: Peo Sjoblom
• Re: Time formatting
  • From: Sandy Mann
• Re: Check if Conditional Format is True or False / Check cell Color
  • From: Peo Sjoblom
• RE: Allocation
  • From: Dinesh
• Re: List of Excel 2003 Functions
  • From: Ron de Bruin
• Re: List of Excel 2003 Functions
  • From: Rick Rothstein \(MVP - VB\)
• Re: Check if Conditional Format is True or False / Check cell Color
  • From: Trevor Shuttleworth
• Re: Check if Conditional Format is True or False / Check cell Color
  • From: Peo Sjoblom
• List of Excel 2003 Functions
  • From: JoJo
• Re: counting values in rows
  • From: T. Valko
• Re: Highlight if ...
  • From: Pete_UK
• Re: Highlight if ...
  • From: David Biddulph
• Re: Choice of Formula
  • From: Naraine Ramkirath
• Highlight if ...
  • From: calibansfolly
• Re: Choice of Formula
  • From: Peo Sjoblom
• Re: Eliminating invalid information
  • From: Peo Sjoblom
• Re: Choice of Formula
  • From: Naraine Ramkirath
• Re: sumif or countif not sure
  • From: Peo Sjoblom
• Re: sumif or countif not sure
  • From: Sandy Mann
• Re: On Excel, the auto filter feature is not filtering all the data
  • From: Peo Sjoblom
• Re: sumif or countif not sure
  • From: Ann
• Re: Excel 2007
  • From: Gary
• Re: sumif or countif not sure
  • From: Sandy Mann
• Re: sumif or countif not sure
  • From: Peo Sjoblom
• Re: Searching within an excel document
  • From: Gord Dibben
• Choice of Formula
  • From: Naraine Ramkirath
• Re: how do I set up a formula showing the day based on date?
  • From: Peo Sjoblom
• RE: sumif or countif not sure
  • From: Ann
• Re: Formula conundrum calculating a percentage average...help!
  • From: Gary
• Re: Formula conundrum calculating a percentage average...help!
  • From: Gary
• Excel 2007
  • From: Gary
• RE: sumif or countif not sure
  • From: Mike H
• Re: Returning multiple indices for a lookup
  • From: Thomas Toth
• Re: Conditional Formatting
  • From: David Biddulph
• Re: Formatting Dates
  • From: Rick Rothstein \(MVP - VB\)
• Re: Insert value from another cell AND text
  • From: Rick Rothstein \(MVP - VB\)
• Re: Mulitple Formulas/Same Cell
  • From: Rick Rothstein \(MVP - VB\)
• Re: VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND
  • From: PCLIVE
• To return the column number of a string
  • From: prasanna.janardhana@xxxxxxxxx
• To return the column number of a string
  • From: prasanna.janardhana@xxxxxxxxx
• To return the column number of a string
  • From: prasanna.janardhana@xxxxxxxxx
• Re: Bad result
  • From: PCLIVE
• Re: Bad result
  • From: Peo Sjoblom
• Re: Bad result
  • From: PCLIVE
• Convert rows to columns
  • From: lucrezia
• Re: Conditional Formatting part 2
  • From: Vasant Nanavati
• Re: Insert value from another cell AND text
  • From: Gord Dibben
• Re: How to ignore #DIV/0! in Sumproduct formula
  • From: Peo Sjoblom
• Re: Insert value from another cell AND text
  • From: PCLIVE
• Insert value from another cell AND text
  • From: calibansfolly
• RE: Formatting Dates
  • From: Ron Coderre
• Re: Linefeed Character
  • From: bj
• Re: Hiding formula to calculate % visits met
  • From: Michele
• Re: Formatting Dates
  • From: Gord Dibben
• Re: Formatting Dates
  • From: David Biddulph
• Re: How to ignore #DIV/0! in Sumproduct formula
  • From: Peo Sjoblom
• Re: How do I create a Form with check boxes in Excel
  • From: Roger Govier
• Re: I need you Mike H!
  • From: Don Guillett
• Re: Excel Conditional Formatting -- more than 4 conditions by row
  • From: Gord Dibben
• Re: SUMPRODUCT problem
  • From: driller
• Re: Linefeed Character
  • From: Jen
• Excel Conditional Formatting -- more than 4 conditions by row
  • From: heathermcpher822
• Re: Need Help Using Calculated Field or Item in Pivot Table
  • From: Jen
• Re: Forming a trend line
  • From: Jerry W. Lewis
• Re: Linefeed Character
  • From: Bernard Liengme
• Re: Hiding formula to calculate % visits met
  • From: Bernard Liengme
• Re: Forming a trend line
  • From: Bernard Liengme
• Re: is anyone familiar with the pull formula in excel?
  • From: Bernard Liengme
• Re: Forming a trend line
  • From: Aaron
• Forming a trend line
  • From: Aaron
• Linefeed Character
  • From: Jen
• Re: Cancel calculation
  • From: Dave Peterson
• Re: Microsoft Excel Sheet
  • From: Avinash Shukla
• Re: SUMPRODUCT problem
  • From: Pete_UK
• Re: Indirect function
  • From: Toppers
• Re: getting the next date based on another date
  • From: Fay
• Re: Excel Convert Multiple Rows into Multiple Columns
  • From: Peo Sjoblom
• Excel Convert Multiple Rows into Multiple Columns
  • From: james . y . so
• Re: Multiple a column of costs by a single factor
  • From: T. Valko
• Re: Round Function Philosophy
  • From: joeu2004
• Re: Generate list from column
  • From: T. Valko
• Re: show 0.00 if referenced cell is empty
  • From: Mark Lincoln
• Re: Round Function Philosophy
  • From: Harlan Grove
• Re: Find Duplicates and Move to New Worksheet
  • From: Max
• RE: Returning multiple indices for a lookup
  • From: JMB
• Re: Sorting into Groups equal size
  • From: Gord Dibben
• Re: Excel 2003 Time Calculation
  • From: Pete_UK
• Re: mirroring worksheets
  • From: Max
• Re: Round Function Philosophy
  • From: joeu2004
• Returning multiple indices for a lookup
  • From: thomas . toth
• Re: Round Function Philosophy
  • From: Pete_UK
• Re: how to display mainframe negative numbers on excel
  • From: Pete_UK
• Re: Round Function Philosophy
  • From: Chip Pearson
• Re: How can I open an Excel Doc from the AutoSave option?
  • From: Gord Dibben
• Re: how to display mainframe negative numbers on excel
  • From: Rick Rothstein \(MVP - VB\)
• Re: Round Function Philosophy
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: Round Function Philosophy
  • From: driller
• Re: Round Function Philosophy
  • From: Peo Sjoblom
• Re: Round Function Philosophy
  • From: Peo Sjoblom
• Re: Round Function Philosophy
  • From: Meebers
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: Socratis
• Re: Round Function Philosophy
  • From: herrdue
• Re: Round Function Philosophy
  • From: Peo Sjoblom
• Re: Round Function Philosophy
  • From: Rick Rothstein \(MVP - VB\)
• Re: Round Function Philosophy
  • From: Vasant Nanavati
• Re: Indirect function
  • From: Peo Sjoblom
• Round Function Philosophy
  • From: herrdue
• Re: Solver Help
  • From: joeu2004
• Re: how to display mainframe negative numbers on excel
  • From: Rick Rothstein \(MVP - VB\)
• Re: how to display mainframe negative numbers on excel
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• RE: Indirect function
  • From: Toppers
• Re: Scroll bar (control) doesn't scroll!! ???
  • From: Bob Umlas
• Re: Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use
  • From: Pete_UK
• Re: Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use
  • From: Pete_UK
• Re: how to display mainframe negative numbers on excel
  • From: Peo Sjoblom
• Re: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• Re: VBE Help, when linked value change, color will not
  • From: Rick Rothstein \(MVP - VB\)
• Re: Advanced filter I think
  • From: Debra Dalgleish
• Re: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• Re: Batch Printing - filtered by Picklist
  • From: Pete_UK
• Need Help Using Calculated Field or Item in Pivot Table
  • From: sg
• Re: Getting a cell reference when a value is less than 0
  • From: T. Valko
• Re: calculate various cells to acheive a specific value
  • From: David Biddulph
• Re: calculate various cells to acheive a specific value
  • From: Peo Sjoblom
• calculate various cells to acheive a specific value
  • From: Jennifer_C
• Re: IF - AND Function
  • From: Peo Sjoblom
• Re: IF - AND Function
  • From: Michael
• Re: IF - AND Function
  • From: Peo Sjoblom
• IF - AND Function
  • From: Michael
• Re: Two Separate Conditions for Cond. formatting
  • From: RagDyeR
• Re: Inserting Additional Text in Spreadsheet
  • From: naz
• Batch Printing - filtered by Picklist
  • From: naz
• Re: Advanced filter I think
  • From: Peo Sjoblom
• Re: How do you create roll-up rows in EXCEL?
  • From: Bob Umlas
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: Advanced filter I think
  • From: Don Guillett
• Re:Getting a cell reference when a value is less than 0 in Excel Works
  • From: Bob
• Re: Find where else in a spreadsheet a cell is referenced with formula
  • From: Niek Otten
• Indirect function
  • From: andy
• Re: Solver Help
  • From: brownti via OfficeKB.com
• Re: Repeat Sort in Excel 2007
  • From: Kevin K
• Re: Getting a cell reference when a value is less than 0
  • From: Bob
• Re: Name Embedded Chart
  • From: Jen
• Name Embedded Chart
  • From: Jen
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: Compare 2 data set
  • From: David Biddulph
• RE: WorkSheet reference
  • From: lena_form
• Re: WorkSheet reference
  • From: lena_form
• Re: How to count the occurences in my range with 2 characters only?
  • From: Pete_UK
• RE: Compare 2 data set
  • From: TouchTone
• Re: Run Time Error 1004
  • From: Roger Govier
• Re: Combo box displays positions not date
  • From: Richhall
• Re: getting the next date based on another date
  • From: T. Valko
• Re: How to count the occurences in my range with 2 characters only?
  • From: Jen
• Re: Calculating Conditional Standard Deviation?
  • From: T. Valko
• Re: Microsoft Excel Sheet
  • From: Peo Sjoblom
• Re: getting the next date based on another date
  • From: Peo Sjoblom
• Re: getting the next date based on another date
  • From: Fay
• Re: Calculating Conditional Standard Deviation?
  • From: Harimau
• Re: Calculating Conditional Standard Deviation?
  • From: T. Valko
• RE: Calculating Conditional Standard Deviation?
  • From: Harimau
• Calculating Conditional Standard Deviation?
  • From: Harimau
• Re: getting the next date based on another date
  • From: T. Valko
• Re: getting the next date based on another date
  • From: Peo Sjoblom
• RE: How to find the first non-blank number in a row?
  • From: Teethless mama
• Re: How to find the first non-blank number in a row?
  • From: T. Valko
• Re: How to find the first non-blank number in a row?
  • From: RLind
• RE: How to find the first non-blank number in a row?
  • From: RLind
• Re: How to change amount in figure to amount in words?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Two Separate Conditions for Cond. formatting
  • From: VegasSageV
• Re: show 0.00 if referenced cell is empty
  • From: Teethless mama
• Re: Error message - PivotTable will not fit on sheet. Show as much as
  • From: ilia
• Re: How to find the first non-blank number in a row?
  • From: Peo Sjoblom
• Re: How to find the first non-blank number in a row?
  • From: T. Valko
• RE: How to find the first non-blank number in a row?
  • From: Teethless mama
• How to find the first non-blank number in a row?
  • From: RLind
• Re: Counting instances of text???
  • From: Ragdyer
• Re: If statement to replace #VALUE! code
  • From: Peo Sjoblom
• Re: Two Separate Conditions for Cond. formatting
  • From: Ragdyer
• Re: If statement to replace #VALUE! code
  • From: Peo Sjoblom
• RE: Counting instances of text???
  • From: Teethless mama
• Re: Two Separate Conditions for Cond. formatting
  • From: VegasSageV
• Re: Two Separate Conditions for Cond. formatting
  • From: Ragdyer
• Re: Counting instances of text???
  • From: Ragdyer
• Re: Counting instances of text???
  • From: Ragdyer
• Re: Multiple a column of costs by a single factor
  • From: RLR
• Re: Multiple a column of costs by a single factor
  • From: RLR
• Re: Dragging a formula containing external links
  • From: Dave Peterson
• Re: Dragging a formula containing external links
  • From: Dave Peterson
• Re: Dragging a formula containing external links
  • From: Dave Peterson
• RE: Counting instances of text???
  • From: tpmax
• Re: Mouse click automatically enters character into cell.
  • From: EP
• Re: Counting instances of text???
  • From: Ragdyer
• RE: Counting instances of text???
  • From: Teethless mama
• Re: Two Separate Conditions for Cond. formatting
  • From: VegasSageV
• Counting instances of text???
  • From: tpmax
• Re: How to change amount in figure to amount in words?
  • From: rony4icab
• Microsoft Excel Sheet
  • From: raju7763
• Check Box & Counter
  • From: RANI
• Re: summation
  • From: Ragdyer
• RE: Run Time Error 1004
  • From: jeannie v
• RE: Run Time Error 1004
  • From: Barb Reinhardt
• Re: Two Separate Conditions for Cond. formatting
  • From: Ragdyer
• Run Time Error 1004
  • From: jeannie v
• Re: How to count the occurences in my range with 2 characters only?
  • From: Pete_UK
• Re: Dragging a formula containing external links
  • From: Keith W.
• Re: Repeat Sort in Excel 2007
  • From: Roger Govier
• Two Separate Conditions for Cond. formatting
  • From: singletary . phx
• Re: Dragging a formula containing external links
  • From: Roger Govier
• Re: Dragging a formula containing external links
  • From: Keith W.
• Re: Dragging a formula containing external links
  • From: driller
• Re: If statement to replace #VALUE! code
  • From: driller
• Re: formula help - maybe vlookup, not sure
  • From: Max
• Re: how to create macro to use cell references for data filter cri
  • From: scshop
• Re: Custom Section Numbering
  • From: Max
• Re: If statement to replace #VALUE! code
  • From: jeannie v
• Re: If statement to replace #VALUE! code
  • From: driller
• Re: Dragging a formula containing external links
  • From: Dave Peterson
• Re: If statement to replace #VALUE! code
  • From: jeannie v
• Dragging a formula containing external links
  • From: Keith W.
• Re: If statement to replace #VALUE! code
  • From: jeannie v
• Repeat Sort in Excel 2007
  • From: Kevin K
• Re: Two conditions in a SUMIF function
  • From: Sandy Mann
• RE: Excel Fromula showing as text but not value
  • From: Elkar
• Re: If statement to replace #VALUE! code
  • From: Peo Sjoblom
• If statement to replace #VALUE! code
  • From: jeannie v
• RE: would like to substitute and return value of 0 for vlookup #N/A er
  • From: egols
• RE: Excel Fromula showing as text but not value
  • From: Paul
• RE: Checking and IF ?
  • From: Teethless mama
• Re: Function to Identify the Modification of a Worksheet
  • From: Vasant Nanavati
• Re: Checking and IF ?
  • From: Peo Sjoblom
• Re: Checking and IF ?
  • From: Vasant Nanavati
• Re: Can the worksheets in a work book be sorted ascending?
  • From: Vasant Nanavati
• Re: Can the worksheets in a work book be sorted ascending?
  • From: Meebers
• Re: Multiple a column of costs by a single factor
  • From: T. Valko
• Re: Multiple a column of costs by a single factor
  • From: Peo Sjoblom
• Re: Average across cells with formulas
  • From: Peo Sjoblom
• Re: Getting a cell reference when a value is less than 0
  • From: T. Valko
• Re: Insert text in a formula
  • From: T. Valko
• Re: show 0.00 if referenced cell is empty
  • From: David D
• Insert text in a formula
  • From: petbi
• Re: Getting a cell reference when a value is less than 0
  • From: T. Valko
• Automatic sorting
  • From: shafer2717
• Re: show 0.00 if referenced cell is empty
  • From: Mark Lincoln
• Re: Two conditions in a SUMIF function
  • From: Sandy Mann
• Re: show 0.00 if referenced cell is empty
  • From: David D
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: Socratis
• Re: VBE Help, when linked value change, color will not
  • From: Rick Rothstein \(MVP - VB\)
• Re: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• Re: COUNTIF cell reference won't work
  • From: Kenny Newbry
• Re: vlookup for the second value of a list
  • From: T. Valko
• Re: show 0.00 if referenced cell is empty
  • From: Vasant Nanavati
• Re: COUNTIF cell reference won't work
  • From: Vasant Nanavati
• Re: show 0.00 if referenced cell is empty
  • From: Mark Lincoln
• Re: COUNTIF cell reference won't work
  • From: T. Valko
• Re: summation
  • From: T. Valko
• Re: vlookup for the second value of a list
  • From: alext49
• COUNTIF cell reference won't work
  • From: Kenny Newbry
• show 0.00 if referenced cell is empty
  • From: David D
• Re: summation
  • From: David Biddulph
• Re: summation
  • From: Rick Rothstein \(MVP - VB\)
• Re: summation
  • From: Rick Rothstein \(MVP - VB\)
• Re: summation
  • From: T. Valko
• Re: vlookup for the second value of a list
  • From: driller
• Re: vlookup for the second value of a list
  • From: T. Valko
• Re: Custom Section Numbering
  • From: Gord Dibben
• Re: VBE Help, when linked value change, color will not
  • From: Toppers
• Re: Excel- option button
  • From: T. Valko
• Re: vlookup for the second value of a list
  • From: T. Valko
• Re: vlookup for the second value of a list
  • From: PCLIVE
• Re: WorkSheet reference
  • From: PCLIVE
• Re: Custom Section Numbering
  • From: Rick Rothstein \(MVP - VB\)
• Re: What Excel formula caluclates number of months between two dat
  • From: Rick Rothstein \(MVP - VB\)
• Re: Auto Sum not working
  • From: Rick Rothstein \(MVP - VB\)
• Re: Auto Sum not working
  • From: Peo Sjoblom
• Re: Auto Sum not working
  • From: Rick Rothstein \(MVP - VB\)
• Re: formula help - maybe vlookup, not sure
  • From: PCLIVE
• Re: Auto Sum not working
  • From: Bernard Liengme
• Re: Auto Sum not working
  • From: Dave Peterson
• Re: HOW TO USE BAHTTEXT FUNCTION?
  • From: Peo Sjoblom
• Re: Multiple passwords
  • From: Dave Peterson
• Re: What Excel formula caluclates number of months between two dates?
  • From: Dave Peterson
• Re: What Excel formula caluclates number of months between two dates?
  • From: Bernard Liengme
• Re: Auto Sum not working
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to count the occurences in my range with 2 characters only?
  • From: Jen
• Re: alternating colors
  • From: Bernard Liengme
• RE: Conditional formatting of a text box ?
  • From: Steve
• Re: Index or Match or what?
  • From: Bernard Liengme
• Re: Find and Add a number in a text field
  • From: Bob Umlas
• Re: Auto Sum not working
  • From: Chip Pearson
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: Auto Sum not working
  • From: Bernard Liengme
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: How to count the occurences in my range with 2 characters only?
  • From: Pete_UK
• Re: How to combine a symbol and a formula
  • From: Heine
• Re: How to combine a symbol and a formula
  • From: Dave Peterson
• Re: Find & Replace (DOH of the week)
  • From: Dave Peterson
• How to count the occurences in my range with 2 characters only?
  • From: Jen
• Re: Excel- option button
  • From: Excel Master Wannabe
• How to combine a symbol and a formula
  • From: Heine
• Re: Formula - IF...then?
  • From: Sandy Mann
• Combo box displays positions not date
  • From: Richhall
• Re: Complex timesheets
  • From: Niek Otten
• Re: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• Re: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• RE: VBE Help, when linked value change, color will not
  • From: JVANWORTH
• Re: Looking for a function
  • From: Roger Govier
• Re: Looking for a function
  • From: T. Valko
• Re: Looking for a function
  • From: T. Valko
• RE: Conditional formatting of a text box ?
  • From: ShaneDevenshire
• Re: how to change number to text with specific format in function
  • From: Vasant Nanavati
• Re: how to change number to text with specific format in function
  • From: Vasant Nanavati
• Re: Automating a line item for several worksheets?
  • From: Vasant Nanavati
• Re: Find Duplicates and Move to New Worksheet
  • From: Vasant Nanavati
• RE: password protecting a column for data entry in a sheet, how?
  • From: JLatham
• Re: if then formula
  • From: T. Valko
• Re: if then forumla
  • From: joeu2004
• Re: if then forumla
  • From: joeu2004
• Re: I want to select a row and insert a copy later in the workshee
  • From: Gord Dibben
• Re: file.xls is locked for editing by "user"
  • From: Pete_UK
• Re: if >200 and <300 formula
  • From: Rick Rothstein \(MVP - VB\)
• Re: if >200 and <300 formula
  • From: Roger Govier
• Re: if then formula
  • From: Gord Dibben
• Re: if >200 and <300 formula
  • From: Rick Rothstein \(MVP - VB\)
• 2 woorksheets 1 workbook, help with lookup
  • From: David D
• Re: if then formula
  • From: T. Valko
• Re: if then formula
  • From: Dave Peterson
• Re: Error message - PivotTable will not fit on sheet. Show as much as
  • From: Roger Govier
• Re: if >200 and <300 formula
  • From: Roger Govier
• Re: Excel- option button
  • From: T. Valko
• Re: How do I put "COPY" on a worksheet when printing
  • From: Gord Dibben
• Re: multiple ranges & criteria for SUM-IF challenge
  • From: T. Valko
• Re: Unknown Sheets
  • From: Gord Dibben
• multiple ranges & criteria for SUM-IF challenge
  • From: akumudzi
• Re: How do I put "COPY" on a worksheet when printing
  • From: Piscator
• Re: if >200 and <300 formula
  • From: Rick Rothstein \(MVP - VB\)
• Re: if >200 and <300 formula
  • From: Piscator
• Re: if >200 and <300 formula
  • From: krcowen
• Re: Function to incorporate worksheets that have yet to be created?
  • From: Gord Dibben
• Re: Links not updated when primary worksheet is sorted
  • From: Susi Farmer
• Re: if >200 and <300 formula
  • From: Trevor Shuttleworth
• RE: Conditional formatting of a text box ?
  • From: Steve
• RE: Conditional formatting of a text box ?
  • From: Steve
• Re: Excel formulas
  • From: Peo Sjoblom
• Re: sum if formula help requested
  • From: Peo Sjoblom
• Re: sum if formula help requested
  • From: PCLIVE
• Re: I want to select a row and insert a copy later in the worksheet
  • From: Peo Sjoblom
• Re: Unknown Sheets
  • From: Harlan Grove
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: lock cell based on a condition
  • From: Gary''s Student
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: Unknown Sheets
  • From: Harlan Grove
• Re: Unknown Sheets
  • From: Peo Sjoblom
• Re: ifcount to compare two columns?
  • From: T. Valko
• Re: difference between logical AND and multiplication?
  • From: Harlan Grove
• Re: sumifs in excel 2003
  • From: Harlan Grove
• Re: Changing worksheet direction
  • From: berber
• Re: "Paste" overwrites Verification Controls
  • From: Harlan Grove
• Re: ifcount to compare two columns?
  • From: T. Valko
• Re: linked info
  • From: Bob Umlas
• Re: Need to know what formula to use
  • From: Roger Govier
• Re: Excel 2007 backwards compatibility - nesting functions
  • From: Roger Govier
• Re: difference between logical AND and multiplication?
  • From: Bob Umlas
• Re: lock cell based on a condition
  • From: Amanda
• Re: Macro Request: Fill in empty cells with previous Filled cell in column
  • From: Bob Umlas
• Re: lock cell based on a condition
  • From: Gary''s Student
• Re: Excel 2007 backwards compatibility - nesting functions
  • From: ilia
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: IF function not working in conditional formatting
  • From: David Biddulph
• Re: Excel 2007 backwards compatibility - nesting functions
  • From: ilia
• Macro Request: Fill in empty cells with previous Filled cell in column
  • From: Artis
• Re: lock cell based on a condition
  • From: Amanda
• Re: Formula Help Please
  • From: Ron Rosenfeld
• Re: Formula Help Please
  • From: Ron Rosenfeld
• Re: Copy formulas not working
  • From: David Biddulph
• Re: lock cell based on a condition
  • From: Gary''s Student
• Re: Need to know what formula to use
  • From: cindy
• Copy formulas not working
  • From: Dave Stitz
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: tennisash
• Re: lock cell based on a condition
  • From: Amanda
• Re: lock cell based on a condition
  • From: Amanda
• Re: Formula Help Please
  • From: Rick Rothstein \(MVP - VB\)
• Re: lock cell based on a condition
  • From: Gary''s Student
• Re: difference between logical AND and multiplication?
  • From: krcowen
• Re: difference between logical AND and multiplication?
  • From: Sandy Mann
• Re: difference between logical AND and multiplication?
  • From: Bernard Liengme
• difference between logical AND and multiplication?
  • From: ergo
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive val
  • From: Ron Rosenfeld
• Re: sumifs in excel 2003
  • From: ergo
• Re: lock cell based on a condition
  • From: Amanda
• Re: Formula Help Please
  • From: Ron Rosenfeld
• Re: Links not updated when primary worksheet is sorted
  • From: Arvi Laanemets
• Re: Pasting across worksheets
  • From: Sandy Mann
• Re: sumifs in excel 2003
  • From: Lok Tak Cheong
• Re: How do I include part of a cell in text (string?) in another cell?
  • From: Chris Mitchell
• Re: Excel date format, NOT JUST DISPLAY !!
  • From: Rick Rothstein \(MVP - VB\)
• Re: "Paste" overwrites Verification Controls
  • From: Harlan Grove
• Re: sumifs in excel 2003
  • From: Lok Tak Cheong
• Re: Excel date format, NOT JUST DISPLAY !!
  • From: Rick Rothstein \(MVP - VB\)
• sumifs in excel 2003
  • From: Lok Tak Cheong
• Re: How do I include part of a cell in text (string?) in another cell?
  • From: Rick Rothstein \(MVP - VB\)
• How do I include part of a cell in text (string?) in another cell?
  • From: Chris Mitchell
• Re: Windows Explorer
  • From: Launchnet via OfficeKB.com
• Re: macro sheet name conflicts
  • From: Rick Rothstein \(MVP - VB\)
• Re: Excel- option button
  • From: Excel Master Wannabe
• Re: Excel- option button
  • From: T. Valko
• RE: Splitting into Groups
  • From: Socratis
• Re: Changing worksheet direction
  • From: Jim Cone
• Re: top3 selection
  • From: Ragdyer
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: COUNTIF
  • From: Dave Peterson
• RE: Splitting into Groups
  • From: tay4432
• Re: Top 3
  • From: Trevor Shuttleworth
• Re: Changing worksheet direction
  • From: Gord Dibben
• RE: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Excel 2003 function for counting rows with two conditions.
  • From: Stan Brown
• Re: Need to fix macro to list data underneath each other
  • From: Roger Govier
• Re: Excel 2003 function for counting rows with two conditions.
  • From: T. Valko
• Re: Creating a formula that references the last value of a column
  • From: T. Valko
• RE: Splitting into Groups
  • From: Socratis
• Re: Changing worksheet direction
  • From: Gord Dibben
• Re: Returning the cell reference when you find a value in an array
  • From: T. Valko
• Re: MS Excel
  • From: Harlan Grove
• Re: VBE Help, when linked value change, color will not
  • From: Rick Rothstein \(MVP - VB\)
• Re: VBE Help, when linked value change, color will not
  • From: Rick Rothstein \(MVP - VB\)
• Re: formula help
  • From: Don Guillett
• Re: formula help
  • From: Mike
• Re: VBE Help, when linked value change, color will not
  • From: Gord Dibben
• Re: formula help
  • From: Don Guillett
• Re: Moving many named cells at once to the next column
  • From: Gord Dibben
• Re: VBE Help, when linked value change, color will not
  • From: Rick Rothstein \(MVP - VB\)
• Re: Need to fix macro to list data underneath each other
  • From: Roger Govier
• Re: zero out
  • From: Sandy Mann
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: upload data from excel to notepad
  • From: shah shailesh
• Re: zero out
  • From: MartinW
• Re: Windows Explorer
  • From: shah shailesh
• Re: Need to fix macro to list data underneath each other
  • From: Roger Govier
• Re: Excel- option button
  • From: T. Valko
• RE: zero out
  • From: JLatham
• zero out
  • From: Pieter
• Re: Trying to convert hh.mm.ss in General format to minutes
  • From: Alan
• Re: Omitting zeroes when looking for minimum values
  • From: Harlan Grove
• Re: frequency
  • From: Bernard Liengme
• Re: frequency
  • From: Harlan Grove
• Re: calculating # of days
  • From: Ron Rosenfeld
• Re: Trying to convert hh.mm.ss in General format to minutes
  • From: Alan
• Windows Explorer
  • From: Launchnet
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Moving many named cells at once to the next column
  • From: Gord Dibben
• RE: How do you display IF statement results in a different cell
  • From: Socratis
• Re: Omitting zeroes when looking for minimum values
  • From: T. Valko
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Harlan Grove
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Ron Rosenfeld
• RE: Need to fix macro to list data underneath each other
  • From: Mike
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Harlan Grove
• Re: Need to fix macro to list data underneath each other
  • From: Roger Govier
• Re: Excel 2007 backwards compatibility - nesting functions
  • From: Harlan Grove
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Ron Rosenfeld
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Harlan Grove
• Re: Need to fix macro to list data underneath each other
  • From: jeannie v
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Harlan Grove
• Re: What does $ stand for in an excel formula
  • From: Harlan Grove
• Re: Need to fix macro to list data underneath each other
  • From: Don Guillett
• Re: Financial calculation
  • From: Bernard Liengme
• RE: Need to fix macro to list data underneath each other
  • From: Mike
• Re: Need to fix macro to list data underneath each other
  • From: Roger Govier
• Re: Financial calculation
  • From: Vasant Nanavati
• Re: Excel 2007 backwards compatibility - nesting functions
  • From: Roger Govier
• Re: What does $ stand for in an excel formula
  • From: Nick Hodge
• Re: Solver Help
  • From: joeu2004
• Need a formula to sum no of times item no is used and sum up total quantity!
  • From: Amean1
• Re: lock cell based on a condition
  • From: Gary''s Student
• Re: Solver Help
  • From: Dana DeLouis
• Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
  • From: Ron Rosenfeld
• RE: Correct Macro so that if the person is not in the source docum
  • From: jeannie v
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: Macro with Variable Data
  • From: jeannie v
• Re: Cell displays formula instead of the formula's result
  • From: Dave Peterson
• Re: How do I delete the name for a named range i no longer require?
  • From: Chris Mitchell
• How do I delete the name for a named range i no longer require?
  • From: Chris Mitchell
• Re: How do I use Named Ranges as Data Validation Lists?
  • From: Chris Mitchell
• RE: Correct Macro so that if the person is not in the source docum
  • From: jeannie v
• How do I use Named Ranges as Data Validation Lists?
  • From: Chris Mitchell
• Re: Solver Help
  • From: joeu2004
• Re: Solver Help
  • From: joeu2004
• Re: How to change amount in figure to amount in words?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Cell displays formula instead of the formula's result
  • From: Dave Peterson
• RE: VBE Expert Help, Code linked to Cells
  • From: Mike
• RE: VBE Expert Help, Code linked to Cells
  • From: Mike
• Re: how to create macro to use cell references for data filter criteri
  • From: Debra Dalgleish
• Re: Pivot table dynamic Filter
  • From: Debra Dalgleish
• Excel 2007 backwards compatibility - nesting functions
  • From: ilia
• Re: can you tell excel to ignore #### cells when calculating
  • From: Dave Peterson
• Re: sumif
  • From: Trevor Shuttleworth
• Re: Insert a column within a range of cells
  • From: Gord Dibben
• Re: Automatic Fill of a Formula
  • From: Gord Dibben
• Re: How do I send multi-sheet documents from Excel via Outlook?
  • From: Gord Dibben
• Re: How do I find top 3 in an unsorted list?
  • From: Peo Sjoblom
• Re: Sum of a column excluding hidden rows
  • From: T. Valko
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Peo Sjoblom
• Re: Count only on visually populated cells
  • From: T. Valko
• Re: Sum of a column excluding hidden rows
  • From: Gord Dibben
• Re: Insert a column within a range of cells
  • From: krcowen
• Re: IF / SUMPRODUCT HELP
  • From: Rick Rothstein \(MVP - VB\)
• Re: conditional indirect with data range
  • From: krcowen
• Re: Automatic Fill of a Formula
  • From: krcowen
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Systemgulv
• Re: Need to know what formula to use
  • From: Roger Govier
• Re: copy from Excel 97 output put in Excel 2000, colors don't work
  • From: krcowen
• Re: Insert a column within a range of cells
  • From: krcowen
• Re: conditional indirect with data range
  • From: krcowen
• Re: IF / SUMPRODUCT HELP
  • From: Rick Rothstein \(MVP - VB\)
• Re: Problem with calculating hours in timesheet? (sysgulv)
  • From: Systemgulv
• Re: can you tell excel to ignore #### cells when calculating
  • From: ilia
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• RE: VBE Help, when linked value change, color will not
  • From: Toppers
• Re: VBE Help, when linked value change, color will not
  • From: Susan
• RE: VBE Help, when linked value change, color will not
  • From: Toppers
• Re: Ending a Sheet
  • From: Susan
• Re: Calc order in pivot table with COUNT
  • From: Debra Dalgleish
• Re: Sum Amount if two conditions are met
  • From: Roger Govier
• Re: Sum Amount if two conditions are met
  • From: PCLIVE
• Re: Sum of a column excluding hidden rows
  • From: vezerid
• RE: Need to know what formula to use
  • From: MyVeryOwnSelf
• Re: Run time error 91
  • From: S S
• Re: Converting to mailing labels
  • From: Dave Peterson
• Re: Changes cell function to answer
  • From: Dave Peterson
• Re: Changes cell function to answer
  • From: PCLIVE
• RE: Correct Macro so that if the person is not in the source docum
  • From: jeannie v
• Re: How do you display IF statement results in a different cell
  • From: Neall
• Converting to mailing labels
  • From: Dave Stitz
• RE: Correct Macro so that if the person is not in the source docum
  • From: jeannie v
• RE: VBE Expert Help, Code linked to Cells
  • From: JVANWORTH
• Re: Problem with calculating hours in timesheet? (sysgulv)
  • From: vezerid
• Run time error 91
  • From: S S
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Peo Sjoblom
• Re: Only weekdays (sysgulv)
  • From: Harlan Grove
• Re: Only weekdays (sysgulv)
  • From: vezerid
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Peo Sjoblom
• Re: SUM by unique reference
  • From: Toppers
• Re: Repost of VBA Code/Lookup question
  • From: Harlan Grove
• Re: SUM by unique reference
  • From: WendyUK
• Re: Converting Total Time hh.hh to HH:MM:SS
  • From: Roger Govier
• Re: SUM by unique reference
  • From: Toppers
• Re: Need Macro to Open Access
  • From: Launchnet via OfficeKB.com
• Re: Only weekdays (sysgulv)
  • From: vezerid
• Re: how to compare two columns on two sheets and copy associated data from one sheet to the other?
  • From: Ingolf
• Re: how to compare two columns on two sheets and copy associated data from one sheet to the other?
  • From: vezerid
• Re: Sum of a column excluding hidden rows
  • From: Roger Govier
• how to compare two columns on two sheets and copy associated data from one sheet to the other?
  • From: meghantrus
• Re: How do you display IF statement results in a different cell
  • From: Pete_UK
• RE: Correct Macro so that if the person is not in the source docum
  • From: jeannie v
• RE: Link to text and return text into a formula?
  • From: Barb Reinhardt
• RE: Link to text and return text into a formula?
  • From: Mary
• RE: Link to text and return text into a formula?
  • From: Barb Reinhardt
• RE: Link to text and return text into a formula?
  • From: Mary
• Re: changing print borders
  • From: Bernard Liengme
• RE: VBE Expert Help, Code linked to Cells
  • From: Mike
• Re: SUM by unique reference
  • From: Bernard Liengme
• Re: Autopopulation of formulae after download of data into a maste
  • From: Dave Peterson
• Re: Transfer CELL value and spread it among 24 ROWs on another sheet
  • From: Roger Govier
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Systemgulv
• sumif function
  • From: nk
• Re: Jogging Log and Elapsed time formats
  • From: Niek Otten
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Systemgulv
• Re: Jogging Log and Elapsed time formats
  • From: Rick Rothstein \(MVP - VB\)
• Re: Jogging Log and Elapsed time formats
  • From: Niek Otten
• RE: Correct Macro so that if the person is not in the source document
  • From: Socratis
• RE: VBE Expert Help, Code linked to Cells
  • From: JVANWORTH
• Re: Jogging Log and Elapsed time formats
  • From: Niek Otten
• Re: countif (I think)
  • From: Stephen Doyle
• Re: @average function
  • From: Harlan Grove
• Re: Volumes of Text in a single cell
  • From: Harlan Grove
• Re: Sum of a column excluding hidden rows
  • From: mnwild1
• Transfer CELL value and spread it among 24 ROWs on another sheet
  • From: rhhince
• Re: Sum of a column excluding hidden rows
  • From: T. Valko
• RE: Nested IF/OR/AND Statement Help
  • From: Toppers
• RE: VBE Expert Help, Code linked to Cells
  • From: Mike
• Re: OK i need help with the if function.
  • From: Harlan Grove
• RE: VBE Expert Help, Code linked to Cells
  • From: Mike
• Re: Sum of a column excluding hidden rows
  • From: Gord Dibben
• @average function
  • From: Chazbri
• Re: conditional formatting problem
  • From: T. Valko
• Re: Pivit Tables
  • From: Debra Dalgleish
• Re: Zero Lines in Spreadsheets (removing)
  • From: Debra Dalgleish
• Re: Pivot Table Calculations
  • From: Roger Govier
• Re: If logical value problems
  • From: Gord Dibben
• Re: If logical value problems
  • From: Peo Sjoblom
• Re: GREEN MARK IN THE TOP LEFT CORNER OF THE CELL
  • From: Gord Dibben
• Re: conditional formatting problem
  • From: driller
• Re: Help with using functions....
  • From: Piscator
• Re: conditional formatting problem
  • From: T. Valko
• Re: How do I insert a picture into a cell?
  • From: Meebers
• Re: conditional formatting problem
  • From: Toppers
• Re: conditional formatting problem
  • From: Peo Sjoblom
• Re: Comparing Data in Excel 2003
  • From: T. Valko
• Re: Solver Help
  • From: brownti via OfficeKB.com
• Re: how do I mail merge data from excel to word as formated?
  • From: Gord Dibben
• Re: Formula to change date when other cells are modifed
  • From: Gord Dibben
• Re: Closest value lookup?
  • From: T. Valko
• Re: conditional formatting problem
  • From: T. Valko
• RE: Repost of VBA Code/Lookup question
  • From: Steve_n_KC
• Re: Closest value lookup?
  • From: ADK
• Re: Calculating Time from Speed and Distance?
  • From: Rick Rothstein \(MVP - VB\)
• password cracker for spreadsheet
  • From: S S
• Re: removing dashes from numbers
  • From: Pat Jones
• Re: how do I mail merge data from excel to word as formated?
  • From: Peo Sjoblom
• Re: Missing count of age to a group of ages
  • From: Peo Sjoblom
• Re: Calculating Time from Speed and Distance?
  • From: Rick Rothstein \(MVP - VB\)
• Calculating Time from Speed and Distance?
  • From: John
• Re: conditional formatting problem
  • From: T. Valko
• RE: VBE Expert Help, Code linked to Cells
  • From: JVANWORTH
• Re: How do I compare two cells and display the lesser of the two cell.
  • From: toppers
• Re: How do I compare two cells and display the lesser of the two cell.
  • From: PCLIVE
• Re: Need Macro to Open Access
  • From: MH
• Re: Solver Help
  • From: Dana
• Re: Combining multiple files in Excel
  • From: Ron de Bruin
• Combining multiple files in Excel
  • From: sameep . sanghrajka
• Re: Count only on visually populated cells
  • From: T. Valko
• RE: Missing count of age to a group of ages
  • From: chedd via OfficeKB.com
• Re: conditional formatting problem
  • From: T. Valko
• conditional formatting problem
  • From: T. Valko
• Re: Combine SUMIF and SUMPRODUCT
  • From: PCLIVE
• Re: COUNTIF not working w/ cells result of SUM and VLOOKUP
  • From: Peo Sjoblom
• RE: Repost of VBA Code/Lookup question
  • From: Steve_n_KC
• Re: Need help launching PowerPointViewer from 2007
  • From: Mr BT
• Launching PowerPoint Viewer from EXCEL 2007 with vb
  • From: Mr BT
• Re: COUNTIF not working w/ cells result of SUM and VLOOKUP
  • From: VettRacer
• Re: COUNTIF not working w/ cells result of SUM and VLOOKUP
  • From: Peo Sjoblom
• Re: removing dashes from numbers
  • From: Pat Jones
• Re: removing dashes from numbers
  • From: Mark Lincoln
• Re: removing dashes from numbers
  • From: Mark Lincoln
• Re: removing dashes from numbers
  • From: vezerid
• Re: Some gridlines are not visible in Excel
  • From: Gord Dibben
• Re: Functions Expert...four (4) different colors if a specific con
  • From: JVANWORTH
• Re: COUNTIF not working w/ cells result of SUM and VLOOKUP
  • From: Peo Sjoblom
• Re: Functions Expert...four (4) different colors if a specific con
  • From: JVANWORTH
• Re: Need Macro to Open Access
  • From: Launchnet via OfficeKB.com
• Re: Converting GPS to Digital Geocode
  • From: Dana
• Re: Conditional formatting Max and Min
  • From: Bob Phillips
• Re: Conditional formatting Max and Min
  • From: vezerid
• Solver Help
  • From: brownti via OfficeKB.com
• Need help launching PowerPointViewer from 2007
  • From: Mr BT
• Re: Choose from a list
  • From: vezerid
• Re: Import Access Table into Excel
  • From: Ron de Bruin
• Re: Pivit Tables
  • From: vezerid
• removing dashes from numbers
  • From: Pat Jones
• Re: In a set of dates, can you count the number of Jan '07 instances?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Missing count of age to a group of ages
  • From: Peo Sjoblom
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Peo Sjoblom
• Re: Excel: How to insert carriage returns in a formula to manipulate t
  • From: Gord Dibben
• Re: Need help with my timesheet? regular, 50% and 100%
  • From: Rick Rothstein \(MVP - VB\)
• Re: Autopopulation of formulae after download of data into a master sh
  • From: Gord Dibben
• Missing count of age to a group of ages
  • From: chedd via OfficeKB.com
• Re: removing dashes from numbers
  • From: Pete_UK
• Re: add two numbers in same cell together
  • From: Rick Rothstein \(MVP - VB\)
• Re: Converting GPS to Digital Geocode
  • From: David Biddulph
• Re: add two numbers in same cell together
  • From: Rick Rothstein \(MVP - VB\)
• sumproduct and visible cells
  • From: Lee
• Re: Compiling information from multiple workbooks and summarizing
  • From: Ron de Bruin
• Re: Formula to pull data from one sheet to another if X = Yellow
  • From: Ron de Bruin
• Re: Import Access Table into Excel
  • From: Ron de Bruin
• Re: Using COUNTIF and NOW() together
  • From: Max
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: add two numbers in same cell together
  • From: Bob Phillips
• Re: EXCEL
  • From: David Biddulph
• Re: Looking for custom date format
  • From: Pierre
• Re: Comparing Data in Excel 2003
  • From: krcowen
• Re: Add-Ins Tab in 2007
  • From: Mr BT
• RE : upload data from excel to notepad
  • From: reachsuja . sada
• RE: Help: Creating Data List and value
  • From: Duke Carey
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Re: MINIF ????
  • From: Pete_UK
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Re: Counting date entries which are the same
  • From: Bob Phillips
• Re: countif (I think)
  • From: Bob Phillips
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• countif (I think)
  • From: Stephen Doyle
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• RE: MACRO IS NOT WORKING AS IT SHOULD
  • From: Billy Liddel
• Re: Functions Expert...four (4) different colors if a specific con
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: Why does Excel not multiply a number generated by an IF formula?
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: Cinny
• Re: Why does Excel not multiply a number generated by an IF formula?
  • From: T. Valko
• Re: number of times consective data occurs in a range of cells
  • From: T. Valko
• Re: number of times consective data occurs in a range of cells
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: T. Valko
• Re: How to return multiple cells from a data sheet in a seperate w
  • From: Socratis
• Re: number of times consective data occurs in a range of cells
  • From: T. Valko
• Re: Lookup help
  • From: Dave Peterson
• Re: Functions Expert...four (4) different colors if a specific con
  • From: T. Valko
• Re: Vlookup.... 2nd time
  • From: T. Valko
• RE: MACRO IS NOT WORKING AS IT SHOULD
  • From: jeannie v
• Re: Formula to change date when other cells are modifed
  • From: Gord Dibben
• Re: number of times consective data occurs in a range of cells
  • From: T. Valko
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Re: Assigning payment formulas to dates
  • From: Vasant Nanavati
• Re: Formula to change date when other cells are modifed
  • From: Bonzai
• Re: Adding a Row to Multiple Worksheets at Once
  • From: Vasant Nanavati
• Re: Prompt for update
  • From: Vasant Nanavati
• Assigning payment formulas to dates
  • From: alancunn
• Re: How do I insert a picture into a cell?
  • From: Meebers
• Re: printing parts of worksheet
  • From: Gord Dibben
• Formulas pulling from other tables
  • From: dicko1
• Re: Wildcards and if
  • From: David Biddulph
• calculate finishing time if night shift aren't working
  • From: Martin B
• Re: Formula to change date when other cells are modifed
  • From: Gord Dibben
• Re: Functions expert………numbering random condition in a column
  • From: JVANWORTH
• Re: How do I insert a picture into a cell?
  • From: Gord Dibben
• Re: rows 4-15 will not scroll
  • From: David Biddulph
• Re: Copying rows from one sheet to another....
  • From: Gord Dibben
• Re: Functions expert...numbering random condition in a column
  • From: Rick Rothstein \(MVP - VB\)
• Re: How do I insert a picture into a cell?
  • From: Peo Sjoblom
• Re: Functions expert...numbering random condition in a column
  • From: T. Valko
• Re: Pivot Table Date Format Question
  • From: Titanium
• RE: MACRO IS NOT WORKING AS IT SHOULD
  • From: Billy Liddel
• Re: Comparing multiple column values
  • From: Toppers
• Re: Functions expert...numbering random condition in a column
  • From: Rick Rothstein \(MVP - VB\)
• Re: Functions expert………numbering random condition in a column
  • From: Rick Rothstein \(MVP - VB\)
• Re: Prompt for update
  • From: S S
• Re: password problem
  • From: S S
• Re: Comparing multiple column values
  • From: T. Valko
• Re: Movng Data Automatically the Fits a provision
  • From: Billy Liddel
• Re: "manual page breaks error"
  • From: Susan
• Add-Ins Tab in 2007
  • From: Mr BT
• Re: "manual page breaks error"
  • From: Susan
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Jonathan Horvath
• Re: "manual page breaks error"
  • From: Susan
• Re: password problem
  • From: Gord Dibben
• Re: "manual page breaks error"
  • From: Susan
• password problem
  • From: S S
• Re: Prompt for update
  • From: Vasant Nanavati
• Prompt for update
  • From: S S
• Re: How do I import data in Excel
  • From: Gord Dibben
• Re: Automatically Hide rows with a value of zero
  • From: Gord Dibben
• Re: Need to remove cells with variable data
  • From: cthomas
• Re: Adding a Row to Multiple Worksheets at Once
  • From: Vasant Nanavati
• Re: Calculating Time Worked in Timesheet
  • From: T. Valko
• Re: Functions expert………numbering random condition in a column
  • From: Rick Rothstein \(MVP - VB\)
• Re: margin of error
  • From: David Biddulph
• Re: margin of error
  • From: Meebers
• Re: How do I insert a picture into a cell?
  • From: Meebers
• margin of error
  • From: Lexi
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Calculating Time Worked in Timesheet
  • From: Studebaker
• Re: Functions Expert...four (4) different colors if a specific conditi
  • From: Peo Sjoblom
• Re: Functions expert...numbering random condition in a column
  • From: Bob Phillips
• Re: Movng Data Automatically the Fits a provision
  • From: TheTigger
• Re: Referencing a named range based upon Range name entry in cell
  • From: Bob Phillips
• Re: STUMPED
  • From: Piscator
• Re: Looking for custom date format
  • From: Pierre
• Re: Validation source field size and function.
  • From: T. Valko
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Need Macro to Open Access
  • From: MH
• Need to remove cells with variable data
  • From: cthomas
• Re: Referencing a named range based upon Range name entry in cell
  • From: Duke Carey
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Font of drop down list is too small
  • From: Gord Dibben
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• Re: Referencing a named range based upon Range name entry in cell
  • From: Peo Sjoblom
• Re: Referencing a named range based upon Range name entry in cell
  • From: Barb Reinhardt
• Re: Best Way to download XIRR
  • From: David Biddulph
• Re: formula help
  • From: Don Guillett
• Re: Referencing a named range based upon Range name entry in cell
  • From: Peo Sjoblom
• Re: formula help
  • From: Bob Phillips
• Re: What does "cannot shift items off sheet" mean?
  • From: Gord Dibben
• Re: Fixe Range
  • From: Gord Dibben
• Automatically Hide rows with a value of zero
  • From: tim
• Re: Referencing a named range based upon Range name entry in cell
  • From: Peo Sjoblom
• Re: Why does the following formula not work: =IF(2<A1<=2.25,2.25," ")
  • From: Dave Peterson
• Re: Referencing a named range based upon Range name entry in cell
  • From: Bob Phillips
• Font of drop down list is too small
  • From: seng via OfficeKB.com
• Re: Fixe Range
  • From: Bob Phillips
• Re: What does "cannot shift items off sheet" mean?
  • From: Bob Phillips
• Re: Referencing a named range based upon Range name entry in cell
  • From: Peo Sjoblom
• Re: How to I get the tabs at the bottom of the page back?
  • From: Gord Dibben
• Re: Looking for custom date format
  • From: Pierre
• Re: Flag 1 in 5 entries
  • From: Rick Rothstein \(MVP - VB\)
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Flag 1 in 5 entries
  • From: Peo Sjoblom
• Re: Looking for custom date format
  • From: Pierre
• Re: Looking for custom date format
  • From: Peo Sjoblom
• Re: Looking for custom date format
  • From: Pierre
• Re: Looking for custom date format
  • From: Rick Rothstein \(MVP - VB\)
• Re: Flag 1 in 5 entries
  • From: Rick Rothstein \(MVP - VB\)
• Looking for custom date format
  • From: Pierre
• RE: How to fix the coding?
  • From: Eric
• Re: Random messages pop up
  • From: Vasant Nanavati
• Re: How to I get the tabs at the bottom of the page back?
  • From: Vasant Nanavati
• Re: Referencing every 5th cell in another sheet
  • From: Jan T.
• Movng Data Automatically the Fits a provision
  • From: EGerety
• Re: can you tell excel to ignore #### cells when calculating
  • From: Dave Peterson
• Re: How can I change the tab but keep the row and column constant
  • From: Dave Peterson
• Re: How can I change the tab but keep the row and column constant
  • From: MG
• Re: Referencing every 5th cell in another sheet
  • From: MartinW
• Re: excel calculates after each cell entry
  • From: Niek Otten
• Re: can you tell excel to ignore #### cells when calculating
  • From: David Biddulph
• Re: Excel Formula
  • From: David Biddulph
• Referencing every 5th cell in another sheet
  • From: Jan . Thorstensen
• Re: Can Someone tell me why this won't work?????????????
  • From: skijsh1979
• Help Nested If and And
  • From: madeleine
• Re: return TRUE if a date falls between two dates
  • From: Bob Phillips
• Re: IF COUNT
  • From: Bob Phillips
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• Re: Counting up with numbers and text
  • From: pwalters
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Re: Convert average daily yield to APY
  • From: joeu2004
• Re: Excel VLookup
  • From: Roger Govier
• Re: Closest value lookup?
  • From: T. Valko
• Re: IF COUNT
  • From: Rick Rothstein \(MVP - VB\)
• Re: return TRUE if a date falls between two dates
  • From: Rick Rothstein \(MVP - VB\)
• Re: Functions/Formulas to count multiple variables
  • From: 2many#s
• Re: IF Statement
  • From: Rick Rothstein \(MVP - VB\)
• Re: Need Macro to Open Access
  • From: Launchnet via OfficeKB.com
• Re: Need Macro to Open Access
  • From: Launchnet via OfficeKB.com
• Re: Calculating Time Worked in Timesheet
  • From: T. Valko
• Re: Calculating Time Worked in Timesheet
  • From: Studebaker
• Re: Counting up with numbers and text
  • From: christine b
• Re: How do I sort rows containing graphics?
  • From: Gord Dibben
• Re: return TRUE if a date falls between two dates
  • From: Fred Smith
• Re: Sum A Range only if no text is present in the range
  • From: AdmiralAJ
• Re: Sum A Range only if no text is present in the range
  • From: Ron Rosenfeld
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Ron Rosenfeld
• Re: Sum A Range only if no text is present in the range
  • From: Dave Peterson
• Re: Can Someone tell me why this won't work?????????????
  • From: Ron Rosenfeld
• Sum A Range only if no text is present in the range
  • From: AdmiralAJ
• Re: Functions/Formulas to count multiple variables
  • From: Peo Sjoblom
• Re: how do i sum of decimal digit in absolute terms
  • From: David Biddulph
• Re: Can Someone tell me why this won't work?????????????
  • From: Peo Sjoblom
• Re: Functions/Formulas to count multiple variables
  • From: 2many#s
• Re: COUNTIF with AND logic
  • From: Rick Rothstein \(MVP - VB\)
• Re: Odd functionality
  • From: T. Valko
• Re: How can I change the tab but keep the row and column constant
  • From: Peo Sjoblom
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: T. Valko
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: Rick Rothstein \(MVP - VB\)
• Re: How can I change the tab but keep the row and column constant
  • From: Dave Peterson
• Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?
  • From: T. Valko
• Re: pop up calendar using MS DateTime Picker
  • From: andy62
• Re: pop up calendar using MS DateTime Picker
  • From: Chip Pearson
• Re: How can I change the tab but keep the row and column constant
  • From: bj
• Re: Closest value lookup?
  • From: T. Valko
• Re: How can I change the tab but keep the row and column constant
  • From: MG
• Re: COUNTIF with AND logic
  • From: Bob Phillips
• Re: How can I change the tab but keep the row and column constant
  • From: MG
• Re: Merging 2 lists with a twist
  • From: Roger Govier
• Re: "Begins with"
  • From: T. Valko
• Re: Counting up with numbers and text
  • From: Peo Sjoblom
• Re: "Begins with"
  • From: Peo Sjoblom
• Re: Closest value lookup?
  • From: Lori
• Re: How can I change the tab but keep the row and column constant
  • From: Peo Sjoblom
• Re: COUNTIF with AND logic
  • From: Mitchell_Collen via OfficeKB.com
• Re: get a list of ticked add-in
  • From: Chip Pearson
• Re: lock cell based on a condition
  • From: Gord Dibben
• Re: Counting up with numbers and text
  • From: Gord Dibben
• RE: lock cell based on a condition
  • From: Amanda
• Re: Need Macro to Open Access
  • From: MH
• Re: COUNTIF with AND logic
  • From: Gord Dibben
• Re: How can I change the tab but keep the row and column constant
  • From: MG
• Re: Closest value lookup?
  • From: Chip Pearson
• Re: How can I change the tab but keep the row and column constant
  • From: MG
• RE: lock cell based on a condition
  • From: Gary''s Student
• Re: Closest value lookup?
  • From: T. Valko
• Re: pop up calendar using MS DateTime Picker
  • From: Chip Pearson
• Re: Positive or negative sign in a calculated cell
  • From: Michel Khennafi
• RE: lock cell based on a condition
  • From: Amanda
• RE: lock cell based on a condition
  • From: Gary''s Student
• Re: COUNTIF with AND logic
  • From: Peo Sjoblom
• RE: lock cell based on a condition
  • From: Gary''s Student
• Re: Counting up with numbers and text
  • From: Peo Sjoblom
• Re: Functions/Formulas to count multiple variables
  • From: Peo Sjoblom
• Re: "Begins with"
  • From: T. Valko
• Re: COUNTIF with AND logic
  • From: Mitchell_Collen via OfficeKB.com
• Re: Counting up with numbers and text
  • From: Gord Dibben
• RE: lock cell based on a condition
  • From: Amanda
• Re: Closest value lookup?
  • From: ADK
• Re: how do i sum of decimal digit in absolute terms
  • From: Rick Rothstein \(MVP - VB\)
• RE: lock cell based on a condition
  • From: Amanda
• Re: Positive or negative sign in a calculated cell
  • From: Rick Rothstein \(MVP - VB\)
• Re: How can I change the tab but keep the row and column constant
  • From: Peo Sjoblom
• Re: Closest value lookup?
  • From: T. Valko
• Re: Merging 2 lists with a twist
  • From: dee
• Re: Relative reference for named tabs?
  • From: Gord Dibben
• Re: Positive or negative sign in a calculated cell
  • From: Peo Sjoblom
• Re: Positive or negative sign in a calculated cell
  • From: Don Guillett
• Re: How can I change the tab but keep the row and column constant when
  • From: Gord Dibben
• Re: Merging 2 lists with a twist
  • From: dee
• RE: lock cell based on a condition
  • From: Gary''s Student
• Re: Closest value lookup?
  • From: ADK
• Positive or negative sign in a calculated cell
  • From: Michel Khennafi
• Re: Closest value lookup?
  • From: T. Valko
• Closest value lookup?
  • From: ADK
• Re: Counting up with numbers and text
  • From: Peo Sjoblom
• Re: trouble locking specific cells
  • From: Gord Dibben
• Re: SUMPRODUCT #VALUE! error
  • From: Chris Slowe
• Re: copy part of large WS to another sheet
  • From: Gord Dibben
• Re: If statement help needed
  • From: ah
• how do i sum of decimal digit in absolute terms
  • From: dhir
• Re: How can I change the tab but keep the row and column constant when
  • From: Max
• Re: COUNTIF with AND logic
  • From: Mitchell_Collen via OfficeKB.com
• Re: How can I change the tab but keep the row and column constant when
  • From: Peo Sjoblom
• Re: Relative reference for named tabs?
  • From: Dave in Fair Oaks
• Re: COUNTIF with AND logic
  • From: Bob Phillips
• Re: How can I change the tab but keep the row and column constant when
  • From: Peo Sjoblom
• COUNTIF with AND logic
  • From: Mitchell_Collen via OfficeKB.com
• Re: Trouble with Index & Match
  • From: Peo Sjoblom
• RE: How to use the if statement for Macro coding?
  • From: Eric
• Re: Trouble with Index & Match
  • From: Peo Sjoblom
• Re: How to open a new instance of EXCEL and .xls file
  • From: Launchnet via OfficeKB.com
• Re: TAN INVERSE ?
  • From: Dave Peterson
• Re: Digit to Text
  • From: Rick Rothstein \(MVP - VB\)
• trouble locking specific cells
  • From: alexisnguyen
• Re: Merging 2 lists with a twist
  • From: Roger Govier
• Find and Delete
  • From: Karen
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: Roger Govier
• Re: Cell Wrap
  • From: Pete_UK
• Re: find and replace
  • From: Karen
• SUMPRODUCT #VALUE! error
  • From: Chris Slowe
• find and replace
  • From: Karen
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Re: getting numbers divisible by 4 from random numbers in ascending order
  • From: Ron Rosenfeld
• Re: Cell reference Issue
  • From: Roger Govier
• Re: Can Someone tell me why this won't work?????????????
  • From: Ron Rosenfeld
• Re: How to return multiple cells from a data sheet in a seperate workb
  • From: tennisash
• Re: Pivot Table Quesiton
  • From: Tina
• Re: Auto Filter Range
  • From: David Biddulph
• Re: Auto Filter Range
  • From: Pete_UK
• Re: DCF
  • From: Pete_UK
• Re: Auto Filter Range
  • From: RichardSchollar
• while loop
  • From: Arun Kumar Saha
• Re: =B1/A1
  • From: Max
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: Roger Govier
• Re: =B1/A1
  • From: Pete_UK
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Re: transfer date to number
  • From: artisdepartis
• Re: transfer date to number
  • From: artisdepartis
• Re: transfer date to number
  • From: Roger Govier
• Re: transfer date to number
  • From: JzP
• transfer date to number
  • From: artisdepartis
• Re: Can Someone tell me why this won't work?????????????
  • From: Bob Phillips
• Re: How to open a new instance of EXCEL and .xls file
  • From: Bob Phillips
• Re: Convert average daily yield to APY
  • From: Greg
• Re: getting numbers that are divisible by 4
  • From: joeu2004
• Re: On File open - how to stop conversion of postcodes to numbers
  • From: DragonRider from Downunder
• Re: Convert average daily yield to APY
  • From: joeu2004
• getting numbers divisible by 4 from random numbers in ascending order
  • From: ramana
• Re: Needing to return multiple values from single column
  • From: Max
• Re: getting numbers that are divisible by 4
  • From: ramana
• Re: getting numbers that are divisible by 4
  • From: T. Valko
• Re: lookup formula
  • From: T. Valko
• Re: lookup formula
  • From: T. Valko
• Re: Macro with Variable Data
  • From: AD108
• getting numbers that are divisible by 4
  • From: ramana
• Re: converting number to words
  • From: Bernd P
• Needing to return multiple values from single column
  • From: graphite . art
• RE: Need Macro to Open Access
  • From: Launchnet via OfficeKB.com
• Re: sum column a if column b, c, d, and e are equal
  • From: jj
• Re: Advanced Excel Functions Ebook
  • From: Gord Dibben
• Re: Hard return
  • From: Gord Dibben
• RE: lookup formula
  • From: StephenAccountant
• RE: lookup formula
  • From: Teethless mama
• Re: Calculating Time Worked in Timesheet
  • From: T. Valko
• RE: lookup formula
  • From: StephenAccountant
• Advanced Excel Functions Ebook
  • From: robert
• RE: Formulas in Excel Worksheet
  • From: jeannie v
• Re: Conditional Formatting bug?
  • From: johnston
• Re: Index and named ranges selecting difficulty
  • From: ShaneDevenshire
• Sorting
  • From: Arun Kumar Saha
• Re: Hard return
  • From: Dave Peterson
• Re: Hard return
  • From: Rick Rothstein \(MVP - VB\)
• Re: Hard return
  • From: Gord Dibben
• Need Macro to Open Access
  • From: Launchnet
• RE: How to return multiple cells from a data sheet in a seperate workb
  • From: Socratis
• RE: How to return multiple cells from a data sheet in a seperate workb
  • From: Gary''s Student
• RE: Formulas in Excel Worksheet
  • From: jeannie v
• Re: lookup formula
  • From: Piscator
• Re: Pull value from column heading
  • From: Dave Peterson
• Re: formula using several colums
  • From: Don Guillett
• Re: Need to add to a SUMPRODUCT formula
  • From: Bernard Liengme
• Re: Need to add to a SUMPRODUCT formula
  • From: Bob Phillips
• Re: Excell dragging formula to change sheet/tab not column/row
  • From: Gord Dibben
• Re: Snedkeys "{F9}", true does not work
  • From: krcowen
• Re: Changing row height in the same worksheet
  • From: Gord Dibben
• Re: locking and unlocking worksheets
  • From: Gord Dibben
• How to return multiple cells from a data sheet in a seperate workbook
  • From: tennisash
• Re: Totaling Different Cell Values
  • From: T. Valko
• Re: Totaling Different Cell Values
  • From: Rick Rothstein \(MVP - VB\)
• Re: IF/COUNT Statements Help
  • From: T. Valko
• Re: IF/COUNT Statements Help
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to summarise information from 4 work sheets
  • From: Gord Dibben
• IF/COUNT Statements Help
  • From: treen333
• Re: Excell dragging formula to change sheet/tab not column/row
  • From: krcowen
• Re: Sum numbers based on specified criteria
  • From: Rick Rothstein \(MVP - VB\)
• Re: Excell dragging formula to change sheet/tab not column/row
  • From: T. Valko
• Re: Sum numbers based on specified criteria
  • From: krcowen
• Re: Sum numbers based on specified criteria
  • From: Don Guillett
• Re: Is there a 255 character limit in pivot table cells?
  • From: Dave Peterson
• RE: Macro with Variable Data
  • From: jeannie v
• Re: Snedkeys "{F9}", true does not work
  • From: Chip Pearson
• Re: COUNTIF with dates
  • From: Lori
• RE: Sumif
  • From: Arlene
• Re: formula using several colums
  • From: jv
• RE: sum column a if column b, c, d, and e are equal
  • From: bj
• Re: formula using several colums
  • From: jv
• Re: How to open a new instance of Word and its .doc file
  • From: Launchnet via OfficeKB.com
• Re: formula using several colums
  • From: Don Guillett
• Re: formula using several colums
  • From: jv
• Re: zero value from using 3D formula, value is missing
  • From: Lori
• Re: Using a series of named ranges in SUMPRODUCT
  • From: Toppers
• Re: zero value from using 3D formula, value is missing
  • From: Lori
• Re: COUNTIF with dates
  • From: JE McGimpsey
• Re: formula using several colums
  • From: JE McGimpsey
• Re: create a list dependant on info in a column
  • From: Max
• Re: formula using several colums
  • From: jv
• Re: formula using several colums
  • From: Don Guillett
• RE: If statement help needed
  • From: ah
• Re: formula using several colums
  • From: JE McGimpsey
• Re: How do I type so my words are vertical not horizontal?
  • From: JE McGimpsey
• Re: Using a series of named ranges in SUMPRODUCT
  • From: JzP
• Re: zero value from using 3D formula, value is missing
  • From: Peo Sjoblom
• Re: formula using several colums
  • From: Don Guillett
• Re: formula using several colums
  • From: JE McGimpsey
• Re: On File open - how to stop conversion of postcodes to numbers
  • From: bj
• zero value from using 3D formula, value is missing
  • From: chedd via OfficeKB.com
• RE: Macro with Variable Data
  • From: jeannie v
• Re: On File open - how to stop conversion of postcodes to numbers
  • From: DragonRider from Downunder
• RE: Macro with Variable Data
  • From: Ariel Dugan
• Re: Pivot Table Quesiton
  • From: krcowen
• Re: How can you do COUNTIF between 3 spreadsheets
  • From: vezerid
• Re: formula to add values for all the same first words in cells in
  • From: vezerid
• Re: Updating Master Log records
  • From: Sinner
• How can you do COUNTIF between 3 spreadsheets
  • From: chedd via OfficeKB.com
• Re: On File open - how to stop conversion of postcodes to numbers
  • From: David Biddulph
• Re: Using a series of named ranges in SUMPRODUCT
  • From: Toppers
• RE: Macro with Variable Data
  • From: jeannie v
• Re: Refering a cell
  • From: Dave Peterson
• Re: excel Formula help !! - urgent
  • From: ITCOM
• Re: excel Formula help !! - urgent
  • From: ITCOM
• Re: If statement help needed
  • From: Toppers
• RE: If statement help needed
  • From: Toppers
• Formula - Help !!!
  • From: ITCOM
• excel Formula help !! - urgent
  • From: ITCOM
• Re: Using a series of named ranges in SUMPRODUCT
  • From: JzP
• Re: If statement help needed
  • From: Roger Govier
• Re: If statement help needed
  • From: Roger Govier
• Re: counting names
  • From: brianjohnalford
• Re: Using a series of named ranges in SUMPRODUCT
  • From: JzP
• Re: Working with pairs of cells
  • From: vsoler
• RE: If statement help needed
  • From: Toppers
• RE: If statement help needed
  • From: ah
• Using a series of named ranges in SUMPRODUCT
  • From: JzP
• Re: If statement help needed
  • From: Roger Govier
• Re: If statement help needed
  • From: Rick Rothstein \(MVP - VB\)
• counting names
  • From: brianjohnalford
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Refering a cell
  • From: Arun Kumar Saha
• Re: what's the best way to calculate a person's years of age in excel
  • From: Niek Otten
• Re: what's the best way to calculate a person's years of age in excel
  • From: T. Valko
• Re: formula to add values for all the same first words in cells in
  • From: SAM
• Re: How do I add " to the right of a number when formatting?
  • From: Niek Otten
• Re: How do I add " to the right of a number when formatting?
  • From: Joerg
• Re: How do I add " to the right of a number when formatting?
  • From: T. Valko
• Re: umm..hard to explain..
  • From: T. Valko
• Re: option buttons help
  • From: Gord Dibben
• Re: Pivot Table Date Format Question
  • From: Debra Dalgleish
• Re: Working with pairs of cells
  • From: Max
• RE: Macro with Variable Data
  • From: jeannie v
• Re: Working with pairs of cells
  • From: Max
• RE: Macro with Variable Data
  • From: Ariel Dugan
• RE: Macro with Variable Data
  • From: Ariel Dugan
• RE: Macro with Variable Data
  • From: jeannie v
• Re: Conditional Formatting bug?
  • From: johnston
• Re: Variable Data within a Macro
  • From: Max
• RE: Variable Data within a Macro
  • From: jeannie v
• Re: Conditional Formatting bug?
  • From: johnston
• RE: Macro with Variable Data
  • From: jeannie v
• Re: create a list dependant on info in a column
  • From: Max
• How to open a new instance of Word and its .doc file
  • From: Launchnet
• Re: Conditional Formatting bug?
  • From: Gord Dibben
• Re: Pivot Table Date Format Question
  • From: Debra Dalgleish
• Re: Pivot Table Date Format Question
  • From: Fred Smith
• Re: Displaying hours and minutes
  • From: John
• Re: Index and named ranges selecting difficulty
  • From: Bob Phillips
• Re: Working with pairs of cells
  • From: vsoler
• Re: Working with pairs of cells
  • From: vsoler
• Re: Macros with variable data
  • From: Trevor Shuttleworth
• Re: How to open a new instance of EXCEL and .xls file
  • From: Launchnet via OfficeKB.com
• Displaying hours and minutes
  • From: John
• Re: sum column a if column b, c, d, and e are equal
  • From: jj
• RE: sum column a if column b, c, d, and e are equal
  • From: ShaneDevenshire
• RE: show data dependant on certain columns (2 dif questions)
  • From: Steve
• RE: show data dependant on certain columns (2 dif questions)
  • From: ShaneDevenshire
• Re: sumproduct 3 criteria inc. date
  • From: D
• Re: Index and named ranges selecting difficulty
  • From: T. Valko
• Re: Pivot Table Issue
  • From: Debra Dalgleish
• sum column a if column b, c, d, and e are equal
  • From: jj
• Re: Index and named ranges selecting difficulty
  • From: Bob Phillips
• Re: sumproduct 3 criteria inc. date
  • From: Bob Phillips
• Re: Working with pairs of cells
  • From: T. Valko
• Re: Conditional Formatting bug?
  • From: johnston
• Re: sumproduct 3 criteria inc. date
  • From: Bob Phillips
• Re: Conditional Formatting bug?
  • From: Bob Phillips
• Re: sumproduct 3 criteria inc. date
  • From: Bob Phillips
• Re: How to open a new instance of EXCEL and .xls file
  • From: Bob Phillips
• Re: How to open a new instance of EXCEL and .xls file
  • From: Launchnet via OfficeKB.com
• Re: Counting
  • From: Ragdyer
• Re: Conditional Formatting bug?
  • From: johnston
• Re: formula to add values for all the same first words in cells in
  • From: Ragdyer
• Re: Conditional Formatting bug?
  • From: Gord Dibben
• Re: Counting
  • From: Ragdyer
• Re: Counting
  • From: Don Guillett
• Re: Conditional Formatting bug?
  • From: johnston
• Re: Conditional Formatting bug?
  • From: Gord Dibben
• RE: formula to add values for all the same first words in cells in
  • From: SAM
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: Roger Govier
• Re: Columns
  • From: Stan Brown
• Re: cell protection, how to?
  • From: Stan Brown
• cell protection, how to?
  • From: S S
• Re: How to open a new instance of EXCEL and .xls file
  • From: Bob Phillips
• Re: Multi-conditional count
  • From: Bernd P
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: T. Valko
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: BEEM
• Re: Columns
  • From: Vasant Nanavati
• Re: Conditional Formatting bug?
  • From: Vasant Nanavati
• Re: Conditional Formatting bug?
  • From: Vasant Nanavati
• Re: How to open a new instance of EXCEL and .xls file
  • From: Launchnet via OfficeKB.com
• Re: Function to find 'n'th largest alphanumeric field (like "Large")
  • From: T. Valko
• Re: @average function
  • From: ShaneDevenshire
• RE: Multiply IF AND OR comparisons
  • From: ShaneDevenshire
• Re: Working with pairs of cells
  • From: vsoler
• Re: Working with pairs of cells
  • From: T. Valko
• Re: Multi-conditional count
  • From: vsoler
• Multi-conditional count
  • From: Jason@xxxxxxxxxxxxx
• Multiply IF AND OR comparisons
  • From: Hannu Laine
• Working with pairs of cells
  • From: vsoler
• Re: IF AND Function
  • From: Bob Phillips
• Re: How to open a new instance of EXCEL and .xls file
  • From: Bob Phillips
• Re: Function to find 'n'th largest alphanumeric field (like "Large")
  • From: T. Valko
• Re: replace space
  • From: Gord Dibben
• Re: don't know how to ask the Q
  • From: Henk57
• Re: Worksheet does not open in the last place it was saved
  • From: Gord Dibben
• Re: replace space
  • From: Rick Rothstein \(MVP - VB\)
• Re: Worksheet does not open in the last place it was saved
  • From: Vasant Nanavati
• Re: replace space
  • From: Vasant Nanavati
• Re: Mouse click automatically enters character into cell.
  • From: Vasant Nanavati
• Re: How to open a new instance of EXCEL and .xls file
  • From: Launchnet via OfficeKB.com
• Re: XL how to change a cell reference in a formula to variable value?
  • From: Dave Peterson
• Re: How to open a new instance of EXCEL and .xls file
  • From: Bob Phillips
• How to open a new instance of EXCEL and .xls file
  • From: Launchnet
• Re: Add cells across multiple workbooks that increase...
  • From: Ron de Bruin
• Re: How can 0 be used in the Choose function
  • From: Bob Phillips
• Re: rounding of numeros
  • From: Roger Govier
• Re: telephone number format change in Excel
  • From: Rick Rothstein \(MVP - VB\)
• RE: Countif to pur a persons age into selected caragories.
  • From: chedd via OfficeKB.com
• Re: @average function
  • From: Roger Govier
• Re: SUMPRODUCT AND TEXT INM FORMULA
  • From: Roger Govier
• Re: USE IF CONDITION FOR 2DATA
  • From: Roger Govier
• Re: Vlookup using if condition or any other way to slove problem
  • From: ShaneDevenshire
• Re: rounding of numeros
  • From: T. Valko
• Re: @average function
  • From: T. Valko
• Re: USE IF CONDITION FOR 2DATA
  • From: deen
• Re: USE IF CONDITION FOR 2DATA
  • From: deen
• Re: Mouse click automatically enters character into cell.
  • From: T. Valko
• Re: weighted average rent with growth
  • From: Fred Smith
• Re: @average function
  • From: T. Valko
• Re: Mouse click automatically enters character into cell.
  • From: Vasant Nanavati
• Re: @average function
  • From: Vasant Nanavati
• Re: I cannot select the compare and merge button
  • From: Gord Dibben
• @average function
  • From: Chazbri
• Re: Countif to pur a persons age into selected caragories.
  • From: Vasant Nanavati
• Countif to pur a persons age into selected caragories.
  • From: chedd via OfficeKB.com
• Re: if then question
  • From: Rick Rothstein \(MVP - VB\)
• Re: if then question
  • From: Don Guillett
• Re: Finding a row/column header in Pivottable
  • From: David Biddulph
• Re: if then question
  • From: Rick Rothstein \(MVP - VB\)
• Re: Header/Footers
  • From: Mike G
• Re: Array formula returning the cumulative sum
  • From: Bernd P
• Re: don't know how to ask the Q
  • From: T. Valko
• Re: I am trying to lookup a persons name in a table.
  • From: T. Valko
• Re: if then question
  • From: Don Guillett
• Re: Sumproduct multiplying instead of adding
  • From: T. Valko
• Re: Vlookup using if condition or any other way to slove problem
  • From: krcowen
• Re: What is this formula for?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Macro will work on one computer but not on another
  • From: Peo Sjoblom
• Re: Sumproduct multiplying instead of adding
  • From: Rick Rothstein \(MVP - VB\)
• Vlookup using if condition or any other way to slove problem
  • From: dhir
• Re: Macro will work on one computer but not on another
  • From: bj
• Re: if then question
  • From: Rick Rothstein \(MVP - VB\)
• Re: Add cells across multiple workbooks that increase...
  • From: Rick Rothstein \(MVP - VB\)
• Re: Looking up 3 cells based on defined value in a row/column loca
  • From: T. Valko
• Re: Cell Formatting Question
  • From: T. Valko
• Re: Looking up 3 cells based on defined value in a row/column loca
  • From: Steve
• Re: Cell Formatting Question
  • From: Peo Sjoblom
• Re: Add cells across multiple workbooks that increase...
  • From: Steve
• Re: formula range
  • From: ADK
• Re: copy an entire row IF a statement is true
  • From: Ron de Bruin
• Re: Add a row based on other criteria
  • From: Roger Govier
• Re: copy worksheet multiple times base on user's input
  • From: Don Guillett
• Re: if then question
  • From: Don Guillett
• Re: copy worksheet multiple times base on user's input
  • From: azu_daioh@xxxxxxxxx
• Re: Add cells across multiple workbooks that increase...
  • From: Roger Govier
• copy worksheet multiple times base on user's input
  • From: azu_daioh@xxxxxxxxx
• Re: Add cells across multiple workbooks that increase...
  • From: Rick Rothstein \(MVP - VB\)
• weighted average rent with growth
  • From: prussom
• Re: Array formula returning the cumulative sum
  • From: Lori
• Re: Add a row based on other criteria
  • From: Roger Govier
• Re: Assigning a Value based on Results
  • From: Rick Rothstein \(MVP - VB\)
• RE: if, and match
  • From: SteveDB1
• Re: Add cells across multiple workbooks that increase...
  • From: Roger Govier
• Re: Array formula returning the cumulative sum
  • From: vsoler
• Re: USE IF CONDITION FOR 2DATA
  • From: Roger Govier
• Re: USE IF CONDITION FOR 2DATA
  • From: PCLIVE
• Re: formula range
  • From: Roger Govier
• Re: How to use Ara and ARP fucntions on Ms Excel?
  • From: joeu2004
• Creating Same Links On All Pages
  • From: Launchnet
• Re: Count
  • From: Rick Rothstein \(MVP - VB\)
• Re: Can I use excel to send personalized emails?
  • From: Ron de Bruin
• Re: Assigning a Value based on Results
  • From: PCLIVE
• Count
  • From: brownti via OfficeKB.com
• Re: Array formula returning the cumulative sum
  • From: Harlan Grove
• Re: Can't find project or library
  • From: Bob Phillips
• Re: Array formula returning the cumulative sum
  • From: Bob Phillips
• Re: Having Excel Move Data that has a certain value
  • From: EGerety
• Re: How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
  • From: jan . patrzalek
• Re: Macro will work on one computer but not on another
  • From: Susan
• Re: formula range
  • From: Roger Govier
• formula range
  • From: ADK
• Re: Array formula returning the cumulative sum
  • From: Bernd P
• Re: How to use Ara and ARP fucntions on Ms Excel?
  • From: David Biddulph
• Re: vlookup formula problems
  • From: Simon888
• Re: Array formula returning the cumulative sum
  • From: Lori
• Re: How to use Ara and ARP fucntions on Ms Excel?
  • From: David Biddulph
• vlookup formula problems
  • From: Simon888
• Re: Array formula returning the cumulative sum
  • From: Bernd P
• Re: Sumproduct, multiple conditions.. but I also want to "minus" somet
  • From: Roger Govier
• Re: How to use Ara and ARP fucntions on Ms Excel?
  • From: David Biddulph
• Re: Sumproduct, multiple conditions.. but I also want to "minus" s
  • From: T. Valko
• Re: Array formula returning the cumulative sum
  • From: vsoler
• Re: Sumproduct, multiple conditions.. but I also want to "minus" somet
  • From: Rick Rothstein \(MVP - VB\)
• Re: Looking up 3 cells based on defined value in a row/column location
  • From: T. Valko
• Re: Looking up 3 cells based on defined value in a row/column location
  • From: T. Valko
• Re: First populated cell in row array/ Last populated cell in row
  • From: Skyscan
• Re: Help to edit a formula
  • From: T. Valko
• Re: using check boxes
  • From: Hell-fire
• RE: Holding company: Automatically modifying data on different wor
  • From: JTep
• Re: HLP! Nesting Problem??
  • From: dee
• Re: How do I make the contents of a cell appear to flash?
  • From: JE McGimpsey
• Re: HLP! Nesting Problem??
  • From: JMB
• RE: if, and match
  • From: JMB
• Re: How do I make the contents of a cell appear to flash?
  • From: Bernard Liengme
• Re: HLP! Nesting Problem??
  • From: Roger Govier
• Re: If Between Dates Function - please help
  • From: David Biddulph
• RE: if, and match
  • From: SteveDB1
• Re: excel expert with data
  • From: Gord Dibben
• Re: excel expert with data
  • From: Bob Phillips
• Re: Linking Between Sheets and #Value! Error
  • From: Bob Phillips
• Re: Array formula returning the cumulative sum
  • From: Harlan Grove
• Re: Array formula returning the cumulative sum
  • From: krcowen
• Re: Looking up a value
  • From: Bernard Liengme
• Re: Looking up a value
  • From: PCLIVE
• Re: Shift lists
  • From: T. Valko
• Re: if, and match
  • From: PCLIVE
• Re: Pivot Table Quesiton
  • From: Tina
• Re: Linking Between Sheets and #Value! Error
  • From: Peo Sjoblom
• Re: Array formula returning the cumulative sum
  • From: Bob Phillips
• Re: Linking Between Sheets and #Value! Error
  • From: Bob Phillips
• Re: Array formula returning the cumulative sum
  • From: vsoler
• Re: Pivot Table Quesiton
  • From: krcowen
• Array formula returning the cumulative sum
  • From: vsoler
• Re: If Between Dates Function - please help
  • From: Mitchell_Collen via OfficeKB.com
• Re: If Between Dates Function - please help
  • From: Mitchell_Collen via OfficeKB.com
• Re: More Secure Sheet Protection
  • From: Susan
• Lookup : Syntax Error
  • From: Steve_n_KC
• Re: If Between Dates Function - please help
  • From: Rick Rothstein \(MVP - VB\)
• Re: Linking Between Sheets and #Value! Error
  • From: Bob Phillips
• Re: COUNTIF, criteria is cell-to-cell comparison
  • From: T. Valko
• if/hide formula
  • From: Erica
• Re: COUNTIF, criteria is cell-to-cell comparison
  • From: T. Valko
• Re: Conditional row format
  • From: sephiroths816
• Re: enumeration members
  • From: Bob Phillips
• Re: If Between Dates Function - please help
  • From: Bob Phillips
• Re: Conditional row format
  • From: Roger Govier
• If Between Dates Function - please help
  • From: Mitchell_Collen via OfficeKB.com
• Remove errors
  • From: Steve
• Re: Countif?
  • From: Roger Govier
• Re: duplicate occurance, assigning an ordinal value
  • From: Rick Rothstein \(MVP - VB\)
• Re: how do I combine multiple worksheets into one? not summarize
  • From: Ron de Bruin
• Re: How do I...
  • From: Gord Dibben
• Re: Countif Multiple Criteria
  • From: PCLIVE
• Re: Countif Multiple Criteria
  • From: David Biddulph
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Re: duplicate occurance, assigning an ordinal value
  • From: Rick Rothstein \(MVP - VB\)
• Re: Conditional row format
  • From: sephiroths816
• Conditional row format
  • From: sephiroths816
• Re: LOOKUP MATCH problems
  • From: sephiroths816
• Re: How do I...
  • From: David Biddulph
• Re: LOOKUP MATCH problems
  • From: Lacty
• Re: Too many criterias...
  • From: sephiroths816
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Re: How to do the coding on UNTIL loop?
  • From: Don Guillett
• Re: MoveMiddleInitial
  • From: vezerid
• Re: Invalid date if weekend or bank holiday
  • From: vezerid
• MoveMiddleInitial
  • From: gh
• RE: Macro will work on one computer but not on another
  • From: bj
• Re: Value errors in Match function
  • From: Ron Rosenfeld
• Re: Combining multiple formulas in one cell
  • From: Bernard Liengme
• Re: Text in Data Validation drop down box too small. Is there any
  • From: Dave Peterson
• RE: Holding company: Automatically modifying data on different wor
  • From: Duke Carey
• RE: Holding company: Automatically modifying data on different wor
  • From: JTep
• RE: Holding company: Automatically modifying data on different workshe
  • From: Duke Carey
• Re: Ignore errors in range
  • From: Arvi Laanemets
• Re: Problems changing array field in formula
  • From: Harry Seymour
• RE: Macro will work on one computer but not on another
  • From: Gillian
• Re: Pivot Table Number Format
  • From: Roger Govier
• Re: Ignore errors in range
  • From: Lacty
• Re: PLS HLP! Countifs Syntax Problem?
  • From: Roger Govier
• Re: Ignore errors in range
  • From: Bob Phillips
• Re: Annual Change from Decennial Data
  • From: joeu2004
• Re: Formula
  • From: David Biddulph
• Re: Annual Change from Decennial Data
  • From: joeu2004
• Re: Combining multiple formulas in one cell
  • From: Andre van Wyk
• Re: HELP fixing GPA formula's
  • From: toppers
• Re: SUM to infinity on a column
  • From: Arvi Laanemets
• Re: duplicate occurance, assigning an ordinal value
  • From: Rick Rothstein \(MVP - VB\)
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Re: Auto Filter & Display
  • From: Debra Dalgleish
• Re: Number in words
  • From: CLR
• Re: Number in words
  • From: CLR
• Re: Multi-Cell Array Formula
  • From: T. Valko
• Re: Auto fill of cell with information from seperate sheet
  • From: Gord Dibben
• Re: Copying cells from one spreadsheet to another?
  • From: Gord Dibben
• Re: Excel 2003
  • From: Don Guillett
• Re: Array Brackets {}
  • From: Bob Phillips
• Re: How do I...
  • From: Gord Dibben
• Re: Copying cells from one spreadsheet to another?
  • From: Gord Dibben
• Re: Auto Filter & Display
  • From: Peo Sjoblom
• Re: how do i calculate what i make in a year into an hour?
  • From: Gord Dibben
• Re: how do i calculate what i make in a year into an hour?
  • From: Dave Peterson
• Re: how do i calculate what i make in a year into an hour?
  • From: MH
• Re: Pivot Table Refresh
  • From: Roger Govier
• Re: Text in Data Validation drop down box too small. Is there any thi
  • From: Dave Peterson
• Re: Multi-Cell Array Formula
  • From: SteveMax
• Re: How can I shrink a file size w/ a pivot table and many formulas?
  • From: Roger Govier
• Re: Too many criterias...
  • From: Roger Govier
• Re: Multi-Cell Array Formula
  • From: SteveMax
• Re: Multi-Cell Array Formula
  • From: T. Valko
• Re: lists urgent help needed
  • From: JE McGimpsey
• Re: Automate deletion process
  • From: Gord Dibben
• Re: Too many criterias...
  • From: PCLIVE
• Re: Too many criterias...
  • From: sephiroths816
• Re: Too many criterias...
  • From: sephiroths816
• Re: Too many criterias...
  • From: Toppers
• Re: create up and down arrows to increase and decrease value in a cell
  • From: T. Valko
• Re: Too many criterias...
  • From: Toppers
• Re: Too many criterias...
  • From: PCLIVE
• Re: Combining multiple formulas in one cell
  • From: Bernard Liengme
• Auto Filter & Display
  • From: lehigh46
• Re: Too many criterias...
  • From: sephiroths816
• Re: index and sum nonadjacent cells
  • From: JE McGimpsey
• Re: Too many criterias...
  • From: sephiroths816
• Re: nested color index within sumproduct
  • From: Bob Phillips
• Re: How can I shrink a file size w/ a pivot table and many formulas?
  • From: Dana DeLouis
• Re: Too many criterias...
  • From: PCLIVE
• Re: How can I shrink a file size w/ a pivot table and many formulas?
  • From: sephiroths816
• Re: duplicate occurance, assigning an ordinal value
  • From: Rick Rothstein \(MVP - VB\)
• Too many criterias...
  • From: sephiroths816
• Re: Pivot Table Quesiton
  • From: krcowen
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Conditional Formula
  • From: bgetson
• Re: Problems changing array field in formula
  • From: Bob Phillips
• Re: Conditional Sum Brackets { }
  • From: T. Valko
• Re: Conditional Formatting on calculated text
  • From: T. Valko
• Re: index and sum nonadjacent cells
  • From: JE McGimpsey
• Re: Array reference in =ROWS() function
  • From: Gary''s Student
• Re: SUMPRODUCT - Ignore blank rows
  • From: sahafi
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Re: Array reference in =ROWS() function
  • From: Dave Peterson
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: Problems changing array field in formula
  • From: Roger Govier
• Re: Strange calculation in PivotTable
  • From: Angus
• Re: SUM to infinity on a column
  • From: David Biddulph
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: How do I reference certain rows within array formulae?
  • From: David Biddulph
• Re: Strange calculation in PivotTable
  • From: Angus
• Re: SUMIF Multiple Workbooks
  • From: RagDyeR
• Re: Extract text from a string
  • From: RagDyeR
• Re: Timezone converter
  • From: Peo Sjoblom
• Re: How do i merge date from multiple sheets
  • From: Ron de Bruin
• Re: Strange calculation in PivotTable
  • From: Angus
• Re: tab color on worksheets
  • From: Bob Phillips
• Re: excel
  • From: ashley . odonnell
• Re: A change in one cell generates (todays) date in another
  • From: ihatetheredskins
• Re: arrange excel by street address instead of alphabetically by n
  • From: Ray
• RE: Appending or Concatenating rows by Client
  • From: Dina
• Re: Number in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: Conditional Formatting on calculated text
  • From: gin
• Re: SUM to infinity on a column
  • From: Arvi Laanemets
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Re: Extract text from a string
  • From: Roger Govier
• Re: Problems changing array field in formula
  • From: Bob Phillips
• Re: SUMIF Multiple Workbooks
  • From: krcowen
• Re: SUM to infinity on a column
  • From: Bobby
• Re: how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in ro
  • From: Bob Phillips
• RE: How to confirm the open dialogue box by using macro coding?
  • From: Barb Reinhardt
• Re: Combining multiple formulas in one cell
  • From: Andre van Wyk
• Re: How do I reference certain rows within array formulae?
  • From: Hossy
• SUM to infinity on a column
  • From: Bobby
• Re: Averageifs & Countifs
  • From: Roger Govier
• Re: Summarizing data to another sheet
  • From: David Biddulph
• RE: How to confirm the open dialogue box by using macro coding?
  • From: Eric
• Re: Extracting data inexcell 2003
  • From: David Biddulph
• Re: Extracting data inexcell 2003
  • From: John cheshire lad
• Re: Number in words
  • From: Bob Phillips
• Re: Match with yes or no question
  • From: Bob Phillips
• Re: how do i count specific text strings excluding blank cells?
  • From: Bob Phillips
• Re: how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row
  • From: Bob Phillips
• Re: using check boxes
  • From: Bob Phillips
• Re: Extracting data inexcell 2003
  • From: David Biddulph
• Re: Number in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: Extracting data inexcell 2003
  • From: David Biddulph
• Re: Calendar Control
  • From: John
• Re: Help with function/formula please!!!
  • From: David Biddulph
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Re: Calculation time
  • From: BKO
• Re: SUMPRODUCT - Ignore blank rows
  • From: Toppers
• Re: Help with function/formula please!!!
  • From: T. Valko
• Re: Help with function/formula please!!!
  • From: Ssuzs
• Re: Help with function/formula please!!!
  • From: T. Valko
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Re: Help with function/formula please!!!
  • From: Rick Rothstein \(MVP - VB\)
• RE: Sumproduct and Percentile
  • From: ryguy7272
• Re: Help with function/formula please!!!
  • From: T. Valko
• Re: How do I reference certain rows within array formulae?
  • From: Hossy
• Re: Summarizing data to another sheet
  • From: Jon Dow
• Re: arrange excel by street address instead of alphabetically by n
  • From: Gord Dibben
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Re: arrange excel by street address instead of alphabetically by n
  • From: Mike Middleton
• Re: arrange excel by street address instead of alphabetically by n
  • From: sahafi
• Re: Concatenate formula- text diff lines?
  • From: Gord Dibben
• Re: Excel: How do I auto expand Cells to show all the wrapped text?
  • From: Gord Dibben
• Re: Invert a column
  • From: Ragdyer
• Re: Averageifs & Countifs
  • From: Roger Govier
• Re: Fomat cells for IP address including leading Zeros
  • From: Ron Rosenfeld
• Re: arrange excel by street address instead of alphabetically by name
  • From: Gord Dibben
• Re: blank vs. 0 when plotting a dated timescale graph
  • From: Peo Sjoblom
• blank vs. 0 when plotting a dated timescale graph
  • From: nbayless
• Re: RATE - what is the internal function?
  • From: Harlan Grove
• RE: Pivot Table Refresh
  • From: Tom Hutchins
• Re: How do I change direction of Enter Key in EXCEL 2007
  • From: Peo Sjoblom
• Re: duplicate occurance, assigning an ordinal value
  • From: Bob Phillips
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
  • From: Bob Phillips
• Re: SUMPRODUCT - Ignore blank rows
  • From: sahafi
• Re: =TODAY()
  • From: David Biddulph
• Re: Conditional Formatting on calculated text
  • From: T. Valko
• Re: =TODAY()
  • From: Mike G
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Conditional Formatting on calculated text
  • From: gin
• Re: Generating blank or null cells that the Histogram Data Analysis to
  • From: EddyKilowatt
• Re: Calendar Control
  • From: John
• Calendar Control
  • From: John
• Re: Using Vlookup for intervals
  • From: T. Valko
• RE: Can I merge columns from one spreadsheet into another?
  • From: Barb Reinhardt
• Re: How to index the closest data(cash flow)?
  • From: vincentwady
• Re: How to index the closest data(cash flow)?
  • From: vincentwady
• RE: Pulling in data from another source
  • From: MLK
• Re: How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
  • From: Ron de Bruin
• RE: Pulling in data from another source
  • From: MLK
• RE: Can I merge columns from one spreadsheet into another?
  • From: Petersjill
• Re: Numbers in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
  • From: jan . patrzalek
• Re: How do I compare a result to a range of values?
  • From: T. Valko
• Re: Fomat cells for IP address including leading Zeros
  • From: Pete
• Re: How do I compare a result to a range of values?
  • From: Gord Dibben
• Re: Numbers in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: Countif with Conditions
  • From: Peo Sjoblom
• Re: Numbers in words
  • From: Beege
• Re: duplicate occurance, assigning an ordinal value
  • From: Rick Rothstein \(MVP - VB\)
• RE: Can I merge columns from one spreadsheet into another?
  • From: Barb Reinhardt
• Re: How do I compare a result to a range of values?
  • From: T. Valko
• Re: How do I compare a result to a range of values?
  • From: David Biddulph
• RE: Can I merge columns from one spreadsheet into another?
  • From: Petersjill
• Re: Email Macro specific Cells?
  • From: Ron de Bruin
• Re: Numbers in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: index and sum nonadjacent cells
  • From: JE McGimpsey
• RE: Can I merge columns from one spreadsheet into another?
  • From: Barb Reinhardt
• Re: How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
  • From: Ron de Bruin
• Re: Numbers in words
  • From: CLR
• RE: Invert a column
  • From: Jakobshavn Isbrae
• Re: How to index the closest data(cash flow)?
  • From: joeu2004
• Re: How to index the closest data(cash flow)?
  • From: joeu2004
• Re: Displaying percentage sign in cell
  • From: Roger Govier
• Re: Numbers in words
  • From: Rick Rothstein \(MVP - VB\)
• Re: How to index the closest data(cash flow)?
  • From: Roger Govier
• How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
  • From: jan . patrzalek
• Re: Numbers in words
  • From: Gord Dibben
• How to index the closest data(cash flow)?
  • From: vincentwady
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
  • From: Harry Seymour
• Re: Displaying percentage sign in cell
  • From: Peo Sjoblom
• Re: Two Formulas in one cell
  • From: Vasant Nanavati
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
  • From: PCLIVE
• Re: duplicate occurance, assigning an ordinal value
  • From: mcheng
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
  • From: Bob Phillips
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
  • From: Bob Phillips
• Re: index and sum nonadjacent cells
  • From: JE McGimpsey
• Re: using check boxes
  • From: Bob Phillips
• Re: duplicate occurance, assigning an ordinal value
  • From: Bob Phillips
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
  • From: Bob Phillips
• Re: Copy a worksheet from one workbook to another
  • From: Ron de Bruin
• Re: Calculation time
  • From: Bob Phillips
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
  • From: Peo Sjoblom
• Re: Copy a worksheet from one workbook to another
  • From: Ron de Bruin
• Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
  • From: PCLIVE
• Re: Having Excel Move Data that has a certain value
  • From: TGerety
• duplicate occurance, assigning an ordinal value
  • From: mcheng
• using check boxes
  • From: Hell-fire
• Re: index and sum nonadjacent cells
  • From: JE McGimpsey
• Re: Two Formulas in one cell
  • From: Roger Govier
• Re: Calculation time
  • From: bj
• Re: Macro will work on one computer but not on another
  • From: Gillian
• Re: Help with Function: Compare text and and edit in cells
  • From: CyranoDeBergarac
• RE: Automatic deletion of specific cells from multiple sheets
  • From: Jman
• Re: Macro will work on one computer but not on another
  • From: PCLIVE
• Re: Two Formulas in one cell
  • From: David Biddulph
• Re: Calculation time
  • From: BKO
• RE: Pulling in data from another source
  • From: Duke Carey
• RE: Automatic deletion of specific cells from multiple sheets
  • From: Barb Reinhardt
• RE: Automatic deletion of specific cells from multiple sheets
  • From: Jman
• Re: Counting Time
  • From: Rick Rothstein \(MVP - VB\)
• Re: IF condition using GMT and BST times
  • From: Bhupinder Rayat
• RE: Duplicate Item Numbers
  • From: Duke Carey
• Email Macro specific Cells?
  • From: neilcarden
• Re: How do I reference certain rows within array formulae?
  • From: Crazy Pete
• Having Excel Move Data that has a certain value
  • From: EGerety
• Re: matching & sorting data
  • From: Bernard Liengme
• Re: Convert SMITH to Smith and JONES to Jones?
  • From: Rick Rothstein \(MVP - VB\)
• Re: Updating Master Log records
  • From: Sinner
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Rick
• RE: Pulling in data from another source
  • From: bj
• Re: Two Formulas in one cell
  • From: David Biddulph
• Re: Two Formulas in one cell
  • From: Vasant Nanavati
• Re: Duplicate Item Numbers
  • From: Roger Govier
• Re: Duplicate Item Numbers
  • From: lehigh46
• Re: Duplicate Item Numbers
  • From: lehigh46
• Re: Duplicate Item Numbers
  • From: Domenic
• Re: Duplicate Item Numbers
  • From: Roger Govier
• Re: How do I return Multiple values using VLookup?
  • From: Domenic
• Duplicate Item Numbers
  • From: lehigh46
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: Vlookup Function?
  • From: Roger Govier
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: IF condition using GMT and BST times
  • From: Bob Phillips
• Re: IF condition using GMT and BST times
  • From: Bhupinder Rayat
• RE: Pulling in data from another source
  • From: MLK
• Re: linking cell to Pivot Table data
  • From: Roger Govier
• Re: IF condition using GMT and BST times
  • From: Bob Phillips
• Re: GETPIVOTDATA....Excel 2000....Desperation!
  • From: Roger Govier
• Scrolling in Page Break Preview
  • From: Nick Wakeham
• Re: Strange calculation in PivotTable
  • From: Angus
• Re: Strange calculation in PivotTable
  • From: Angus
• Re: Calculate monthly contributions
  • From: joeu2004
• Re: Calculation time
  • From: Bob Phillips
• Re: Vlookup Function?
  • From: Bob Phillips
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: Excel 2003 I want text quoted and then the value of a cell followi
  • From: JE McGimpsey
• RE: Strange calculation in PivotTable
  • From: Angus
• Re: how do I sort a column of random dates into Consecutive dates
  • From: Gord Dibben
• Re: how to get the 2nd max value?
  • From: Ron Rosenfeld
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Rick Rothstein \(MVP - VB\)
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Ron Rosenfeld
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Rick
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Ron Rosenfeld
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Ron Rosenfeld
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Ron Rosenfeld
• RE: Strange calculation in PivotTable
  • From: Angus
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Rick Rothstein \(MVP - VB\)
• Re: Every 1st, 3rd, 5th Tuesday
  • From: Ron Rosenfeld
• Re: Finction to find the first cell that is not zero
  • From: Ron Rosenfeld
• Every 1st, 3rd, 5th Tuesday
  • From: Rick
• Re: Finction to find the first cell that is not zero
  • From: Mark
• Re: Help with Function: Compare text and and edit in cells
  • From: Vasant Nanavati
• RE: Pulling in data from another source
  • From: MLK
• Help with Function: Compare text and and edit in cells
  • From: CyranoDeBergarac
• GETPIVOTDATA....Excel 2000....Desperation!
  • From: Kev
• Re: Vlookup Function?
  • From: Bob Phillips
• Re: formula for automatic up on numbers in cell in exel
  • From: JE McGimpsey
• Re: A validation rule on Alpha and Numeric characters
  • From: Harlan Grove
• Re: Sorting
  • From: Peo Sjoblom
• Re: Insert copied row based on value
  • From: eazyc10
• Re: Insert copied row based on value
  • From: krcowen
• Re: A validation rule on Alpha and Numeric characters
  • From: Rick Rothstein \(MVP - VB\)
• Re: A validation rule on Alpha and Numeric characters
  • From: Rick Rothstein \(MVP - VB\)
• Re: formula to add Alpha?
  • From: Trevor Shuttleworth
• Re: A validation rule on Alpha and Numeric characters
  • From: Harlan Grove
• Generating blank or null cells that the Histogram Data Analysis tool will ignore
  • From: EddyKilowatt
• Re: Find last space
  • From: Peo Sjoblom
• Re: Hiding certain decimal values
  • From: neil40@xxxxxxxxxxxxxx
• Re: Custom date formatting
  • From: Ron Rosenfeld
• Insert copied row based on value
  • From: eazyc10
• RE: Pulling in data from another source
  • From: bj
• RE: Pulling in data from another source
  • From: Duke Carey
• Re: Nested VLOOKUP
  • From: Peo Sjoblom
• RE: Pulling in data from another source
  • From: Duke Carey
• RE: Pulling in data from another source
  • From: MLK
• Re: How do I find the next blank cell in a range?
  • From: Dave Peterson
• Re: Find last space
  • From: Francis Hookham
• Re: HIDE row if CELL value is #NA
  • From: krcowen
• Re: Custom date formatting
  • From: Del Cotter
• Re: Nested VLOOKUP
  • From: ruchie
• Re: Combining multiple formulas in one cell
  • From: Bernard Liengme
• Re: Nested VLOOKUP
  • From: ruchie
• Re: How do I reference certain rows within array formulae?
  • From: T. Valko
• Re: Custom date formatting
  • From: Rick Rothstein \(MVP - VB\)
• Re: Nested VLOOKUP
  • From: Peo Sjoblom
• Re: How do I find the next blank cell in a range?
  • From: Lori
• Re: A validation rule on Alpha and Numeric characters
  • From: Rick Rothstein \(MVP - VB\)
• Re: Nested VLOOKUP
  • From: ruchie
• Re: Custom date formatting
  • From: Del Cotter
• Re: Custom date formatting
  • From: Del Cotter
• Re: A validation rule on Alpha and Numeric characters
  • From: Harlan Grove
• Re: A validation rule on Alpha and Numeric characters
  • From: Harlan Grove
• Re: A validation rule on Alpha and Numeric characters
  • From: Harlan Grove
• Re: Custom date formatting
  • From: Peo Sjoblom
• Re: formula to add Alpha?
  • From: Trevor Shuttleworth
• Re: Custom date formatting
  • From: Bernard Liengme
• Re: Custom date formatting
  • From: Ron Rosenfeld
• Re: Hiding certain decimal values
  • From: Ron Rosenfeld
• Re: Hiding certain decimal values
  • From: Rick Rothstein \(MVP - VB\)
• Custom date formatting
  • From: Del Cotter
• Re: How do I find the next blank cell in a range?
  • From: Dave Peterson
• Hiding certain decimal values
  • From: neil40@xxxxxxxxxxxxxx
• Re: Copy function with Excel 2003 not performing correctly
  • From: Peo Sjoblom
• Re: IF(AND problem to work out commissions
  • From: Don Guillett
• Re: A validation rule on Alpha and Numeric characters
  • From: vezerid
• Re: A validation rule on Alpha and Numeric characters
  • From: Rick Rothstein \(MVP - VB\)
• Re: Strange calculation in PivotTable
  • From: Roger Govier
• Re: IF(AND problem to work out commissions
  • From: Don Guillett
• Re: A validation rule on Alpha and Numeric characters
  • From: Roger Govier
• DCOUNT Help Needed
  • From: Khaledity
• Re: Long List of Numbers sorting
  • From: talltom
• Re: How to close a excel file using Macro coding?
  • From: Eric
• Re: "Between" dates in Excel
  • From: Don Guillett
• Re: Cell entry using Parenthesis
  • From: Lucky
• Re: Summarizing data to another sheet
  • From: vezerid
• Re: Function to find the first cell that is not zero-Thanks everyone
  • From: Mark
• Re: Function to find the first cell that is not zero
  • From: Mark
• Re: Function to find the first cell that is not zero
  • From: Mark
• Re: How to close a excel file using Macro coding?
  • From: Dave Peterson
• Re: Function to find the first cell that is not zero
  • From: Mark
• Re: Function to find the first cell that is not zero
  • From: Mark
• Cell entry using Parenthesis
  • From: Lucky
• Re: can I do this in excel
  • From: Bob Phillips
• Re: Find last space
  • From: Bob Phillips
• Find last space
  • From: Francis Hookham
• Re: Capital Calculation
  • From: EricB
• Re: SUMPRODUCT
  • From: Roger Govier
• Re: Pick up digist from another column
  • From: David Biddulph
• Re: How to sort data according two matching cells?
  • From: DaveFinn
• Re: SUM and IF results
  • From: T. Valko
• Re: SUM and IF results
  • From: T. Valko
• Re: SUM and IF results
  • From: Arvi Laanemets
• Re: how to get the value in the upper 5 cell
  • From: T. Valko
• Re: How to close a excel file using Macro coding?
  • From: Dave Peterson
• Re: Summarizing data to another sheet
  • From: Jon Dow
• Re: Function to find the first cell that is not zero
  • From: T. Valko
• Re: Function to find the first cell that is not zero
  • From: Ron Rosenfeld
• Re: Function to find the first cell that is not zero
  • From: Mark
• Re: Function to find the first cell that is not zero
  • From: Mark
• Re: Function to find the first cell that is not zero
  • From: Mark
• Data connectivity across two seperate .xls files, interesting
  • From: sash
• If Statement
  • From: Hank
• Re: rounding of numeros
  • From: T. Valko
• Re: rounding of numeros
  • From: David Biddulph
• Re: rounding of numeros
  • From: Bob Phillips
• Re: rounding of numeros
  • From: Bernard Liengme
• Re: dates for weekdays in non-contiguous cells
  • From: Bob Phillips
• Re: How do I get more smart tag recognizers?
  • From: Gord Dibben
• Re: Worksheet_Change
  • From: Don Guillett
• Re: Logical Functions
  • From: Erny
• Re: Please help ... comparing text
  • From: Don Guillett
• Re: Long List of Numbers sorting
  • From: Stan Brown
• Re: Excel columns do they exceed IV?
  • From: Stan Brown
• Re: How to code on Macro on saving and closing a file?
  • From: Bob Phillips
• Re: Excel columns do they exceed IV?
  • From: Roger Govier
• Re: Excel columns do they exceed IV?
  • From: Roger Govier
• Re: Excel columns do they exceed IV?
  • From: David Biddulph
• Re: Transpose?
  • From: Max
• Re: Transpose?
  • From: Harlan Grove
• Re: Hexidecimal lookup
  • From: Harlan Grove
• Re: Bowling: Handicap between Teams
  • From: Yan
• Re: Transpose?
  • From: Ragdyer
• Re: Bowling: Handicap between Teams
  • From: T. Valko
• Re: Bowling: Handicap between Teams
  • From: Yan
• Re: Bowling: Handicap between Teams
  • From: Yan
• Re: Bowling: Handicap between Teams
  • From: Yan
• Re: Bowling: Handicap between Teams
  • From: T. Valko
• Re: Long List of Numbers sorting
  • From: talltom
• Re: help to count easily
  • From: T. Valko
• Re: Excel 2002
  • From: David Biddulph
• WORKSHEETS IN ALPHA
  • From: Pamela
• Re: Formula to indicate upcoming birthdays
  • From: Victor Delta
• Re: help to count easily
  • From: Bob Phillips
• help to consolidate data
  • From: docdutton
• Re: Formula to indicate upcoming birthdays
  • From: Rick Rothstein \(MVP - VB\)
• Re: Formula to indicate upcoming birthdays
  • From: Victor Delta
• Re: Formula to indicate upcoming birthdays
  • From: Rick Rothstein \(MVP - VB\)
• Formula to indicate upcoming birthdays
  • From: Victor Delta
• Re: Match and Count duplicate names
  • From: Bernd
• RE: Copy a column leaving out any blanks
  • From: Ron Coderre
• Re: Multiple IF Statement
  • From: John
• Re: Updating Master Log records
  • From: Sinner
• Re: Summarizing data to another sheet
  • From: vezerid
• Re: Deleting Text Boxes
  • From: Peo Sjoblom
• Re: How do I activate the Link feature?
  • From: David Biddulph
• Re: Invalid data circle disappers
  • From: MartinW
• Re: Finction to find the first cell that is not zero
  • From: Stan Brown
• Re: Macro Help
  • From: Stan Brown
• Re: How can I do this?
  • From: T. Valko
• Re: Combine firstt & last name
  • From: Gord Dibben
• Re: Combine firstt & last name
  • From: Mike G
• Re: About sorting and extracting data in one column
  • From: Ting Li
• Re: Function to find the first cell that is not zero
  • From: Ron Rosenfeld
• Re: Merge contents of cells and insert line space
  • From: Gord Dibben
• Re: Sumif question
  • From: Max
• Re: Nested VLOOKUP
  • From: Max
• Sumif question
  • From: Harry Webster
• Re: Relative reference for named tabs?
  • From: Gord Dibben
• Re: Function to find the first cell that is not zero
  • From: T. Valko
• Re: How can I do this?
  • From: T. Valko
• Re: How can I do this?
  • From: Tmaxx02
• Re: Macro Help
  • From: Pete_UK
• Re: How can I do this?
  • From: T. Valko
• Re: Function to find the first cell that is not zero
  • From: Peo Sjoblom
• Re: Combine firstt & last name
  • From: Gord Dibben
• Re: Relative reference for named tabs?
  • From: Dave in Fair Oaks
• Re: How can I do this?
  • From: Tmaxx02
• Re: How can I do this?
  • From: Pete_UK
• Re: How can I do this?
  • From: JE McGimpsey
• Re: Function to find the first cell that is not zero
  • From: T. Valko
• Re: Combine firstt & last name
  • From: Mike G
• How can I do this?
  • From: Tmaxx02
• Re: SUMIF Criterion with NOT
  • From: Don Guillett
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: Don Guillett
• Re: Multiple IF Statement
  • From: David Biddulph
• Re: Multiple IF Statement
  • From: PCLIVE
• Re: Function to find the first cell that is not zero
  • From: T. Valko
• Re: Function to find the first cell that is not zero
  • From: T. Valko
• Re: How do I get a unique number on a form when I open it each time?
  • From: Gord Dibben
• Re: Function to find the first cell that is not zero
  • From: Ron Rosenfeld
• Re: Finction to find the first cell that is not zero
  • From: Ron Rosenfeld
• Re: Relative reference for named tabs?
  • From: Gord Dibben
• Function to find the first cell that is not zero
  • From: Mark
• Function to find the first cell that is not zero
  • From: Mark
• Finction to find the first cell that is not zero
  • From: Mark
• Re: Duplicate Item Numbers
  • From: lehigh46
• Re: random row numbers
  • From: David Biddulph
• Re: Summarizing data to another sheet
  • From: Jon Dow
• Re: Formula problem
  • From: Computer geek
• Re: Formula problem
  • From: Computer geek
• Re: Sumif only numbers formated as currency
  • From: Peo Sjoblom
• Re: Sumif only numbers formated as currency
  • From: Dave Peterson
• Re: auto filter on multiple rows
  • From: Dave Peterson
• Re: SUMPRODUCT - Ignore blank rows
  • From: Toppers
• Re: SUMPRODUCT - Ignore blank rows
  • From: PCLIVE
• Re: Excel Formula for Single Cell Adress
  • From: David Biddulph
• Re: problem with vlookup
  • From: ruchie
• Re: SUMPRODUCT - Ignore blank rows
  • From: sahafi
• Re: Logical Functions
  • From: PCLIVE
• Re: Finding Annual Growth Rate
  • From: joeu2004
• Re: SUMPRODUCT - Ignore blank rows
  • From: PCLIVE
• Re: Duplicate Item Numbers
  • From: Ron de Bruin
• Re: Large and if function!
  • From: T. Valko
• Re: Duplicate Item Numbers
  • From: Ron de Bruin
• Re: Nested VLOOKUP
  • From: ruchie
• Duplicate Item Numbers
  • From: lehigh46
• Re: can you make EOMONTH work without Analysis ToolPak
  • From: Ron Rosenfeld
• Re: Fomat cells for IP address including leading Zeros
  • From: Ron Rosenfeld
• Re: Worksheet Function
  • From: JE McGimpsey
• Re: Help with Formula
  • From: Pete_UK
• Re: Nested VLOOKUP
  • From: Max
• More referencing
  • From: splat
• Re: VLookup Range Help
  • From: krcowen
• Re: Fomat cells for IP address including leading Zeros
  • From: Ron Rosenfeld
• Re: Finding Annual Growth Rate
  • From: Bernard Liengme
• Re: Need help please with VLOOKUP and INDIRECT question
  • From: krcowen
• Re: Capital Calculation
  • From: Jim Cone
• Re: Need help please with VLOOKUP and INDIRECT question
  • From: JE McGimpsey
• Re: VLookup Range Help
  • From: JE McGimpsey
• Fomat cells for IP address including leading Zeros
  • From: Pete
• Re: Need help please with VLOOKUP and INDIRECT question
  • From: PCLIVE
• Re: Sum all integers of a given number
  • From: Ron Coderre
• Re: VLookup Range Help
  • From: krcowen
• Re: Sum all integers of a given number
  • From: pchr
• Re: How to display numbers as text? Ex: 203 = "two hundred, three"
  • From: Ron Coderre
• Re: Capital Calculation
  • From: Jim Cone
• Re: Sum all integers of a given number
  • From: Ron Coderre
• Re: Choose highest value duplicate
  • From: mr tom
• RE: Identifying Current Cell
  • From: Stanley
• Sum all integers of a given number
  • From: pchr
• Re: Different validation list based on cellvalue on the left
  • From: Debra Dalgleish
• Re: Choose highest value duplicate
  • From: Teethless mama
• Re: Choose highest value duplicate
  • From: Bob Phillips
• Nested VLOOKUP
  • From: ruchie
• Re: Different validation list based on cellvalue on the left
  • From: Ron Coderre
• Formula problem
  • From: Computer geek
• Re: Choose highest value duplicate
  • From: mr tom
• Re: copying formulas
  • From: vezerid
• Re: copying formulas
  • From: dimitry
• Re: SUMIF Criterion with NOT
  • From: Fred Holmes
• Re: SUMIF Criterion with NOT
  • From: Don Guillett
• Re: Choose highest value duplicate
  • From: Bob Phillips
• Re: Choose highest value duplicate
  • From: Don Guillett
• Re: Large and if function!
  • From: Yan
• Re: convert Excel sheet in 1904 format to 1900 without changing dates
  • From: Scoops
• Re: non-availability of Microsoft Community Newsgroups
  • From: David Biddulph
• Re: Weekends
  • From: Ron Rosenfeld
• RE: Identifying Current Cell
  • From: Mike H
• RE: Identifying Current Cell
  • From: #DIV/0
• Re: Autofill doesn't give the number of records filtered any more
  • From: DianeG
• Re: non-availability of Microsoft Community Newsgroups
  • From: Susan
• Re: Weekends
  • From: Ron Rosenfeld
• RE: Identifying Current Cell
  • From: Mike H
• RE: Identifying Current Cell
  • From: Stanley
• Re: non-availability of Microsoft Community Newsgroups
  • From: David Biddulph
• RE: Identifying Current Cell
  • From: Mike H
• Function to Spread Costs
  • From: andyhofer
• Re: Summarizing data to another sheet
  • From: vezerid
• Re: Multiple Criteria
  • From: vezerid
• Re: SUMIF Criterion with NOT
  • From: Bob Phillips
• Re: About sorting and extracting data in one column
  • From: vezerid
• Re: Creating a name list from if quantity value is in adjacent cel
  • From: vezerid
• Re: SUMIF Criterion with NOT
  • From: Fred Holmes
• Re: Creating a name list from if quantity value is in adjacent cel
  • From: Jive
• SUMIF Criterion with NOT
  • From: Fred Holmes
• Re: About sorting and extracting data in one column
  • From: Ting Li
• Re: Weekends
  • From: Harlan Grove
• Re: Weekends
  • From: Rick Rothstein \(MVP - VB\)
• Re: Large and if function!
  • From: T. Valko
• Re: CONCATENATE number and text from different cells
  • From: T. Valko
• Re: Large and if function!
  • From: Yan
• Re: About sorting and extracting data in one column
  • From: Ting Li
• Re: Automatically update a cell
  • From: Gord Dibben
• Relative reference for named tabs?
  • From: Dave in Fair Oaks
• copying the Hyperlink function result without copying the actual formula
  • From: mcheng
• Re: Large and if function!
  • From: T. Valko
• Re: HYPERLINK() referring value from a cell does not change when cell
  • From: mcheng
• Re: can you make EOMONTH work without Analysis ToolPak
  • From: Ron Rosenfeld
• SUMIF criterion to match the first 5 characters.
  • From: Fred Holmes
• Re: Function for all Characters after the :
  • From: mcbe
• Re: Large and if function!
  • From: T. Valko
• Re: Function for all Characters after the :
  • From: T. Valko
• Re: Function for all Characters after the :
  • From: Dave Peterson
• Vacation Accrual Formula Need Help Please!
  • From: trucker
• Function for all Characters after the :
  • From: mcbe
• Re: In series of 10 digit #s, how can I exclude 1st 3 digits in each?
  • From: David Biddulph
• Re: LOOKUP error
  • From: Kelly
• Re: math
  • From: Otto Moehrbach
• Re: Averaging
  • From: Del Cotter
• Re: math
  • From: Bob Phillips
• Re: Min Fuction
  • From: Bob Phillips
• Re: Count number of text values in a specific row
  • From: T. Valko
• Re: Date going forward
  • From: David Biddulph
• Re: can you make EOMONTH work without Analysis ToolPak
  • From: T. Valko
• Re: How do I get MROUND to only round up to the next multiple.
  • From: David Biddulph
• Re: can you make EOMONTH work without Analysis ToolPak
  • From: T. Valko
• Re: How do I get MROUND to only round up to the next multiple.
  • From: Harlan Grove
• Re: Relation betwn 2 sets of data, user to input one, sheet returns ot
  • From: krcowen
• Re: Creating a Data Validation List based on a Value in another cell
  • From: Roger Govier
• Re: Hiding Worksheets - Problem with Posts
  • From: Dave Peterson
• Re: lookup single value in a range and return specified value
  • From: PCLIVE
• Re: transposing addresses
  • From: Mike G
• Re: Conditional Formatting - Date Refresh
  • From: Peo Sjoblom
• Re: Cannot see any posts after 6/5/2007
  • From: Harlan Grove
• Re: Help with function
  • From: Computer geek
• Re: Automatically update a cell
  • From: PCLIVE
• Re: Sum based on specific condition
  • From: Harlan Grove
• Re: Copy & pasting formulas across workbook tabs
  • From: Peo Sjoblom
• Re: Breaking out individual files from a .xls worksheet
  • From: Peo Sjoblom
• Re: Multiple Criteria
  • From: bhaider
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: Conditional Formatting for cells with formulas
  • From: Peo Sjoblom
• Re: Cannot see any posts after 6/5/2007
  • From: Dave Peterson
• Re: Help Excel Formatting
  • From: Bob Phillips
• Re: formulas appear in cell as entered..
  • From: Paul B
• Help Excel Formatting
  • From: francesllee
• Re: Cannot see any posts after 6/5/2007
  • From: Gord Dibben
• non-availability of Microsoft Community Newsgroups
  • From: toppers
• Re: formulas appear in cell as entered..
  • From: toppers
• Re: Finding missing values in a column
  • From: Ron Coderre
• Re: formulas appear in cell as entered..
  • From: Roger Govier
• Re: Help with function
  • From: David Biddulph
• Re: Need Help Creating a Macro Multiple Workbooks to One
  • From: Gord Dibben
• Re: Formatting Cells?
  • From: Gord Dibben
• Re: Conditional Formatting - Date Refresh
  • From: David Biddulph
• Re: Weekends
  • From: barbara . reinhardt
• Re: Dispay two values in one cell with the / border separating them.
  • From: Gord Dibben
• Re: how can i make a list of numbers automatically
  • From: Gord Dibben
• Re: Creating a name list from if quantity value is in adjacent cell on
  • From: vezerid
• Re: Weekends
  • From: vezerid
• Re: Help with function
  • From: Ron Coderre
• Re: Help with Hlookup/Vlookup and Lookup. From multipul sheets
  • From: vezerid
• Re: Multiple Criteria
  • From: vezerid
• Re: Weekends
  • From: Peo Sjoblom
• Re: transposing addresses
  • From: Gord Dibben
• Re: Help with function
  • From: Computer geek
• Re: Weekends
  • From: Ron Coderre
• Re: Multi-Conditional Functions
  • From: PCLIVE
• Re: unable to see postings after 6/5/07
  • From: David Biddulph
• Re: Formatting Cells?
  • From: PCLIVE
• Re: Sum of Column with next column containing specific word
  • From: PCLIVE
• Re: Sum of Column with next column containing specific word
  • From: Peo Sjoblom
• Re: Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Help with function
  • From: Ron Coderre
• Re: Dispay two values in one cell with the / border separating them.
  • From: Harlan Grove
• Re: Sum based on specific condition
  • From: Peo Sjoblom
• Weekends
  • From: Bob
• Help with function
  • From: Computer geek
• Re: transposing addresses
  • From: Mike G
• Re: SUMIF Conditions
  • From: hamblin . adam
• Re: HOW CAN I MAKE AND OR ADD NEW SYMBOLS TO THE LIST?
  • From: Peo Sjoblom
• Re: transposing addresses
  • From: Roger Govier
• Re: SUMIF Conditions
  • From: Peo Sjoblom
• Re: SUMIF Conditions
  • From: JE McGimpsey
• Re: transposing addresses
  • From: Mike G
• Re: Conditional Average
  • From: JE McGimpsey
• Re: IF..THEN..ELSE
  • From: JE McGimpsey
• SUMIF Conditions
  • From: hamblin . adam
• Re: Filtering diverse values
  • From: vezerid
• Re: transposing addresses
  • From: vezerid
• Re: Round to thousands via custom format?
  • From: JE McGimpsey
• Re: Formula Help
  • From: JE McGimpsey
• Re: Round to thousands via custom format?
  • From: znelson
• Filtering diverse values
  • From: sephiroths816
• Re: Formula Help
  • From: Dave Peterson
• Re: Lookup returning incorrect result
  • From: Niek Otten
• transposing addresses
  • From: Mike G
• Re: Trouble Freezing Panes in Excel 2003
  • From: sephiroths816
• Re: Round to thousands via custom format?
  • From: Bob Phillips
• Re: About sorting and extracting data in one column
  • From: vezerid
• Round to thousands via custom format?
  • From: znelson
• Re: Summarizing data to another sheet
  • From: vezerid
• Re: how to find common cells in several columns
  • From: vezerid
• Re: Number of days in a running period
  • From: Bob Phillips
• Re: Ifsumproduct
  • From: Bob Phillips
• Re: Sum duplicates unique values and delete dupliques
  • From: Bob Phillips
• Re: Can I calculate the number of days taken off in a running period
  • From: Pete_UK
• Re: 2 Conditions + Sum of a colum matching those conditions
  • From: Pete_UK
• Ifsumproduct
  • From: stevekanc
• Re: DCOUNT function not working properly on string comparisons
  • From: Roger Govier
• Re: Sumif, having two condition
  • From: Roger Govier
• Re: lookup with INDEX MATCH formule depending on 2 conditions
  • From: Roger Govier
• Re: Sumif, having two condition
  • From: Bob Phillips
• Re: 2 Conditions + Sum of a colum matching those conditions
  • From: Bob Phillips
• Re: 2 Conditions + Sum of a colum matching those conditions
  • From: Pete_UK
• Re: 2 Conditions + Sum of a colum matching those conditions
  • From: Bob Phillips
• Re: 2 Questions
  • From: Bob Phillips
• Re: Using Sumproduct in Autofilter
  • From: Bob Phillips
• Re: Master Worksheet Display
  • From: Bob Phillips
• Re: Dana: help with your Demo() macro to "expand" formulas
  • From: Harlan Grove
• Re: Help needed in updating excel worksheet values
  • From: Arvi Laanemets
• Re: Average
  • From: Gord Dibben
• Dana: help with your Demo() macro to "expand" formulas
  • From: joeu2004
• Re: Average
  • From: Mark
• Re: Growth
  • From: Fred Smith
• Re: How to retrieve entire row (actually 26 columns) of data ?
  • From: JE McGimpsey
• Re: Converting Julian Dates to regular dates
  • From: Gord Dibben
• Re: Converting Julian Dates to regular dates
  • From: JE McGimpsey
• Re: How to retrieve entire row (actually 26 columns) of data ?
  • From: Father Jack
• Re: Averaging
  • From: Ron Coderre
• Re: How to auto data from one work to another worksheet.
  • From: David Biddulph
• Re: Calculating sales commission that changes based on a sales volume
  • From: Pete_UK
• Re: Leading Zero and the change command
  • From: Pete_UK
• Re: Copying cells from one spreadsheet to another?
  • From: Gord Dibben
• Re: Long List of Numbers sorting
  • From: Pete_UK
• Re: Excel list boxes
  • From: Gord Dibben
• Re: quick double-criteria lookup?
  • From: T. Valko
• Re: quick double-criteria lookup?
  • From: robotman
• Re: vlookup not finding matching data
  • From: T. Valko
• Re: Conditional Average
  • From: T. Valko
• Re: quick double-criteria lookup?
  • From: T. Valko
• Re: Conditional formatting
  • From: Gord Dibben
• Re: SUMPRODUCT with TEXT and dates
  • From: T. Valko
• Re: Skipping cells in a formula
  • From: Brian
• Re: Parsing a text string into separate cells
  • From: JE McGimpsey
• Re: Sum based on specific condition
  • From: Peo Sjoblom
• Re: Lookup based on two fields without merging?
  • From: David Biddulph
• Re: Lookup based on two fields without merging?
  • From: robotman
• quick double-criteria lookup?
  • From: robotman
• Re: Cell Shading
  • From: Gord Dibben
• Re: LOOKUP error
  • From: krcowen
• Re: Condititional Formtting a Column
  • From: Gord Dibben
• Re: Condititional Formtting a Column
  • From: T. Valko
• Re: Condititional Formtting a Column
  • From: vezerid
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Skipping cells in a formula
  • From: vezerid
• Re: How to merge columns from one worksheet to another worksheet
  • From: Gord Dibben
• Re: Skipping cells in a formula
  • From: Brian
• Re: LOOKUP error
  • From: vezerid
• Re: Extracting characters before or after a specific character
  • From: Brian
• Re: Skipping cells in a formula
  • From: vezerid
• Re: TIME SHEET FORMULA CONDITIONS
  • From: vezerid
• Skipping cells in a formula
  • From: Brian
• Re: Copying and pasting from a range
  • From: Don Guillett
• Re: Copying and pasting from a range
  • From: Don Guillett
• Re: Lookup based on two fields without merging?
  • From: robotman
• Re: SUMPRODUCT and Dates
  • From: vezerid
• Re: SUMPRODUCT and Dates
  • From: Don Guillett
• Re: Extracting characters before or after a specific character
  • From: JE McGimpsey
• Re: Extracting characters before or after a specific character
  • From: Beege
• Extracting characters before or after a specific character
  • From: Brian
• Re: convert number to text w/ error checking sign
  • From: Bernard Liengme
• Re: Sum based on specific condition
  • From: David Biddulph
• Re: Copying and pasting from a range
  • From: vezerid
• Re: Formula for cashflow on every 90th item
  • From: vezerid
• Re: formula for current stock count needed
  • From: vezerid
• Re: Consolidate multiple worksheets into new sheet
  • From: Peo Sjoblom
• Re: Hlookup?
  • From: JE McGimpsey
• Re: Formattting Text
  • From: Peo Sjoblom
• Re: lookup with INDEX MATCH formule depending on 2 conditions
  • From: Roger Govier
• Re: a macro that Formats a textbox based on value in a cell
  • From: vezerid
• Re: Validation in a Conditional Statement
  • From: Pete_UK
• Re: current stock formula help?
  • From: vezerid
• Re: copying formulas
  • From: vezerid
• Re: IF statement
  • From: JE McGimpsey
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: gareth . wretham
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: Roger Govier
• Re: If statements
  • From: Bob Phillips
• Re: I want to make convert a number in words in excel
  • From: Bernard Liengme
• Re: If statements
  • From: vezerid
• Re: COUNTIF
  • From: vezerid
• Re: How to sort data according two matching cells?
  • From: vezerid
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: gareth . wretham
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: vezerid
• Re: Cell reference OR INDIRECT function
  • From: vezerid
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: gareth . wretham
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: gareth . wretham
• Re: Calculating percentages based on the number of checked boxes in a column
  • From: Roger Govier
• Re: Help on sumproduct function
  • From: Roger Govier
• Calculating percentages based on the number of checked boxes in a column
  • From: gareth . wretham
• Re: Using SUMIF to update prices on a worksheet
  • From: Bob Phillips
• Re: Help on sumproduct function
  • From: sadat
• Re: LOOKUP, MATCH, INDEX?
  • From: Ragdyer
• Re: Expanding Formulas
  • From: joeu2004
• Re: How to retrieve entire row (actually 26 columns) of data ?
  • From: JE McGimpsey
• Re: when i try to fill a cell with color, nothing happens
  • From: Gord Dibben
• Re: lookup value and date from a list with restrictions
  • From: T. Valko
• Re: ecel will only open as read only
  • From: Gord Dibben
• Re: Automatic Decimal Places?
  • From: Gord Dibben
• Re: AVERAGE NUMBER IN COLUMN PROBLEM
  • From: JE McGimpsey
• Re: Expanding Formulas
  • From: Dana DeLouis
• copying formulas
  • From: dimitry
• Re: How to use =sumallsheets(b1)?
  • From: Pete_UK
• Re: Expanding Formulas
  • From: joeu2004
• Re: How to use =sumallsheets(b1)?
  • From: Chip Pearson
• Re: TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE"
  • From: JE McGimpsey
• day vs time format ??
  • From: K1KKKA
• Re: Lookup based on two fields without merging?
  • From: robotman
• Re: how can i round in excel to the nearest thousand
  • From: Rick Rothstein \(MVP - VB\)
• Re: how can i round in excel to the nearest thousand
  • From: Rick Rothstein \(MVP - VB\)
• Re: how can i round in excel to the nearest thousand
  • From: JE McGimpsey
• Re: how can i round in excel to the nearest thousand
  • From: JE McGimpsey
• RE: LOOKUP, MATCH, INDEX?
  • From: ShaneDevenshire
• Re: how can i round in excel to the nearest thousand
  • From: Rick Rothstein \(MVP - VB\)
• Re: how can i round in excel to the nearest thousand
  • From: David Biddulph
• Re: LOOKUP, MATCH, INDEX?
  • From: ShaneDevenshire
• Re: how can i round in excel to the nearest thousand
  • From: JE McGimpsey
• Re: Help with a formula
  • From: Ken Johnson
• Re: how can i round in excel to the nearest thousand
  • From: Harlan Grove
• Re: how can i round in excel to the nearest thousand
  • From: Rick Rothstein \(MVP - VB\)
• Re: Return blank cell if value you vlookup is not on pivot
  • From: T. Valko
• Re: how can i round in excel to the nearest thousand
  • From: JE McGimpsey
• Re: Creating an IF / AND statement
  • From: PCLIVE
• Re: lookup value and date from a list with restrictions
  • From: antonio
• RE: Countif with 2 conditions
  • From: Ron Coderre
• Re: Can I include a "validation drop down" in a conditional statement?
  • From: JE McGimpsey
• Re: Sum based on specific condition
  • From: Peo Sjoblom
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: T. Valko
• Re: Sum based on specific condition
  • From: Peo Sjoblom
• Re: Expanding Formulas
  • From: tralst
• Re: Date format problem
  • From: David Biddulph
• RE: Countif with 2 conditions
  • From: DTTODGG
• RE: Countif with 2 conditions
  • From: Ron Coderre
• Re: Conditional format for the whole row
  • From: sephiroths816
• RE: Countif with 2 conditions
  • From: DTTODGG
• Re: HLOOKUP INDIRECT with alpha numeric worksheets
  • From: T. Valko
• Re: Averaging values from a list, based on user input
  • From: T. Valko
• Re: search and change without replacing-excel 2002
  • From: Gord Dibben
• RE: Countif with 2 conditions
  • From: Ron Coderre
• Re: Averaging values from a list, based on user input
  • From: Peo Sjoblom
• Re: Averaging values from a list, based on user input
  • From: NBVC
• RE: Countif with 2 conditions
  • From: DTTODGG
• Re: Lookup based on two fields without merging?
  • From: JE McGimpsey
• Re: Creating an IF / AND statement
  • From: PCLIVE
• Lookup based on two fields without merging?
  • From: robotman@xxxxxxxxx
• Re: Help on sumproduct function
  • From: NBVC
• Re: Color of @IF Results Cell
  • From: Gord Dibben
• Re: formula needed to bring values to another sheet
  • From: Gord Dibben
• Re: how do I change the colour of selected auto filter tabs
  • From: Roger Govier
• Re: Conditional format for the whole row
  • From: David Biddulph
• Re: Conditional format for the whole row
  • From: Roger Govier
• Re: how do I change the colour of selected auto filter tabs
  • From: Dave Peterson
• Conditional format for the whole row
  • From: sephiroths816
• Re: Functions to ignore hidden rows
  • From: Peo Sjoblom
• Re: Color of @IF Results Cell
  • From: JE McGimpsey
• Re: Functions to ignore hidden rows
  • From: Peo Sjoblom
• Re: VIN Number sorting
  • From: Gord Dibben
• Re: Creating an IF / AND statement
  • From: PCLIVE
• Re: Text import/ Text to Column
  • From: Roger Govier
• Re: Sumif not criteria
  • From: RagDyeR
• Re: Combo Box
  • From: krcowen
• Re: Writing IF Statement
  • From: Ron Rosenfeld
• Re: Writing IF Statement
  • From: Bob Phillips
• Re: Help on sumproduct function
  • From: Roger Govier
• RE: It's a filter but not a filter
  • From: bj
• Re: My formula is =IF(B5="B",TODAY(),"")
  • From: David Biddulph
• Re: My formula is =IF(B5="B",TODAY(),"")
  • From: Chip Pearson
• Re: LOOKUP across Multiple Sheets
  • From: LeeM
• Re: Help on sumproduct function
  • From: David Biddulph
• Re: TimeSheet calculatons Overnights
  • From: Roger Govier
• RE: Text import/ Text to Column
  • From: anto
• Re: LOOKUP across Multiple Sheets
  • From: Arvi Laanemets
• Re: How do I sum cells by refering to discrete values?
  • From: Bob Phillips
• Re: give text a dollar numeric value
  • From: Bob Phillips
• Re: Count Text within Multiple Worksheets
  • From: Laffin
• Re: How do I sum cells by refering to discrete values?
  • From: Max
• Re: Help on sumproduct function
  • From: Roger Govier
• Re: How do I sum cells by refering to discrete values?
  • From: Bob Phillips
• Re: Help on sumproduct function
  • From: David Biddulph
• Re: Help on sumproduct function
  • From: Roger Govier
• RE: It's a filter but not a filter
  • From: Duke Carey
• Re: lookup with INDEX MATCH formule depending on 2 conditions
  • From: Roger Govier
• Looking up and reporting values across tabs
  • From: gareth . wretham
• It's a filter but not a filter
  • From: matthew . clegg
• Re: maybe by sumproduct or some other way with text.
  • From: Roger Govier
• Re: Custom format field
  • From: David Biddulph
• Re: Conditional Ranking
  • From: T. Valko
• Re: A1= A2 (When selected).A3 (When selected)
  • From: Joerg
• Re: Conditional Ranking
  • From: matthew . clegg
• Re: HLOOKUP INDIRECT with alpha numeric worksheets
  • From: T. Valko
• Re: Expanding Formulas
  • From: joeu2004
• Re: lookup value and date from a list with restrictions
  • From: T. Valko
• Re: Lookup
  • From: T. Valko
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: Conditional Selection
  • From: matthew . clegg
• Re: Need to 'COUNT'...
  • From: Ragdyer
• Re: Is there any way to delete a Digital Certificate
  • From: Gord Dibben
• Is there any way to delete a Digital Certificate
  • From: Mac Lingo
• RE: Auto scroll down event
  • From: andy62
• Re: Expanding Formulas
  • From: Gord Dibben
• Re: Lookup
  • From: Claudio Funes
• Re: calculating a discount rate
  • From: joeu2004
• Re: calculating a discount rate
  • From: joeu2004
• Re: Protected worksheet
  • From: Harlan Grove
• Re: How do I change minutes (1.5) to 01:30?
  • From: Peo Sjoblom
• Re: Expanding Formulas
  • From: joeu2004
• Re: How do I change minutes (1.5) to 01:30?
  • From: JE McGimpsey
• Re: How do I change minutes (1.5) to 01:30?
  • From: David Biddulph
• Re: Need to 'COUNT'...
  • From: Peo Sjoblom
• Re: Need to 'COUNT'...
  • From: JE McGimpsey
• Conditional Selection
  • From: matthew . clegg
• Re: OFFSET: Returns error when used to a linked file
  • From: Harlan Grove
• Re: Conditional Ranking
  • From: matthew . clegg
• Re: Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Calculating earliest start and latest end dates by contract
  • From: Ron Rosenfeld
• Re: Offset / Match / MAtch
  • From: Peo Sjoblom
• Re: Offset / Match / MAtch
  • From: Roger Govier
• Re: Calculating earliest start and latest end dates by contract
  • From: T. Valko
• Re: lookup value and date from a list with restrictions
  • From: antonio
• Re: Multiple Lookup Application
  • From: T. Valko
• Offset / Match / MAtch
  • From: Michel Khennafi
• Re: lookup value and date from a list with restrictions
  • From: T. Valko
• Re: Calculating earliest start and latest end dates by contract
  • From: T. Valko
• Re: lookup value and date from a list with restrictions
  • From: antonio
• Re: Choosing last set of data in column
  • From: Toppers
• Re: Date Generation
  • From: Ron Rosenfeld
• Re: Choosing last set of data in column
  • From: Erik
• Re: Choosing last set of data in column
  • From: Toppers
• lookup value and date from a list with restrictions
  • From: antonio
• Re: Date Generation
  • From: Peo Sjoblom
• Re: How do I run a macro from inside an"=IF" formula in Excel 2003?
  • From: moon
• Re: Choosing last set of data in column
  • From: Toppers
• Re: adding time
  • From: Peo Sjoblom
• Re: adding time
  • From: David Biddulph
• Re: Date Generation
  • From: Peo Sjoblom
• Re: Array Formula Using LOOKUP function.
  • From: Ron Coderre
• RE: Conditional Formatting
  • From: bj
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: combining cells
  • From: David Biddulph
• Re: combining cells
  • From: Bob Phillips
• Re: Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Lookup
  • From: T. Valko
• Re: Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Need to do an EXACT LOOKUP
  • From: Niek Otten
• Re: DCOUNT problem with numbers stored as text
  • From: Peo Sjoblom
• Re: DCOUNT problem with numbers stored as text
  • From: MJP
• Re: LOOKUP, MATCH, INDEX?
  • From: RagDyeR
• Re: DCOUNT problem with numbers stored as text
  • From: Peo Sjoblom
• Re: DCOUNT problem with numbers stored as text
  • From: MJP
• Re: How to auto fill with fifth cell in a column?
  • From: David Biddulph
• Re: DCOUNT problem with numbers stored as text
  • From: Lori
• Re: DCOUNT problem with numbers stored as text
  • From: MJP
• Re: Array Formula Using LOOKUP function.
  • From: luchshel
• Re: Autofill doesn't give the number of records filtered any more
  • From: Roger Govier
• Re: DCOUNT problem with numbers stored as text
  • From: Peo Sjoblom
• RE: VLOOKUP
  • From: Jerry
• Re: DCOUNT problem with numbers stored as text
  • From: MJP
• Re: maybe by sumproduct or some other way with text.
  • From: driller
• Re: Time Formula
  • From: Gav123
• Re: Auto Filter function only provide 2 criteria input
  • From: Kent
• Re: DCOUNT problem with numbers stored as text
  • From: Peo Sjoblom
• Re: Time Formula
  • From: Bob Phillips
• Re: Command Button to run a Macro
  • From: Bob Phillips
• Re: Auto Filter function only provide 2 criteria input
  • From: Bob Phillips
• DCOUNT problem with numbers stored as text
  • From: MJP
• Re: Conditional Ranking
  • From: Bernd
• Re: How to divide a number into various denominators
  • From: Ron Rosenfeld
• Re: Time Formula
  • From: Bob Phillips
• Re: Auto Filter function only provide 2 criteria input
  • From: Kent
• VLOOKUP
  • From: Jerry
• Re: Array Formula Using LOOKUP function.
  • From: Ron Coderre
• Re: give text a dollar numeric value
  • From: David Biddulph
• Re: ecel:create a file name from data in worksheet
  • From: Susan
• Re: give text a dollar numeric value
  • From: Bob Phillips
• Re: give text a dollar numeric value
  • From: Bob Phillips
• Re: Excel VBA help
  • From: Don Guillett
• Re: formula calculation
  • From: barry28
• Re: Basic formula - forgotton !!
  • From: Mark Allen
• Re: formula calculation
  • From: Roger Govier
• Re: formula calculation
  • From: barry28
• Re: Comparing two lists using Conditional Formatting
  • From: roniaelm
• Re: How to divide a number into various denominators
  • From: Dave Peterson
• Re: Autofill doesn't give the number of records filtered any more
  • From: Roger Govier
• Re: Basic formula - forgotton !!
  • From: David Biddulph
• Re: formula calculation
  • From: Roger Govier
• Re: Lookup
  • From: Claudio Funes
• RE: Conditional Formatting
  • From: singingsister
• Re: Array Formula Using LOOKUP function.
  • From: luchshel
• Re: Concatenate format
  • From: Bob Phillips
• Re: Concatenate format
  • From: Roger Govier
• Re: Auto Filter function only provide 2 criteria input
  • From: Bob Phillips
• RE: Ranking or sorting function
  • From: craig
• Auto Filter function only provide 2 criteria input
  • From: Kent
• Re: Master Worksheet Display
  • From: Bob Phillips
• Re: Comparing two lists using Conditional Formatting
  • From: T. Valko
• Re: Ranking or sorting function
  • From: T. Valko
• Re: Lookup
  • From: T. Valko
• Re: Look up 2 values, return result in a different workbook
  • From: T. Valko
• Re: Lookup
  • From: Claudio Funes
• Re: Lookup
  • From: T. Valko
• Re: Lookup
  • From: Claudio Funes
• RE: Auto scroll down event
  • From: excelent
• Re: Lookup
  • From: T. Valko
• Look up 2 values, return result in a different workbook
  • From: Positive
• Re: Lookup
  • From: T. Valko
• Comparing two lists using Conditional Formatting
  • From: roniaelm
• Re: Conditional Ranking
  • From: T. Valko
• Re: Array Formula Using LOOKUP function.
  • From: T. Valko
• RE: Array Formula Using LOOKUP function.
  • From: Ron Coderre
• RE: Array Formula Using LOOKUP function.
  • From: Ron Coderre
• Re: Excel VBA help
  • From: Gord Dibben
• Re: Conditional Ranking
  • From: matthew . clegg
• Re: Excel VBA help
  • From: Ron Rosenfeld
• Re: Excel VBA help
  • From: Bob Phillips
• Re: LOOKUP, MATCH, INDEX?
  • From: T. Valko
• Excel VBA help
  • From: tmobccr2
• RE: LOOKUP, MATCH, INDEX?
  • From: bob
• Re: Apply conditional formatting to individual cell Excel 2007
  • From: T. Valko
• Re: how do i create table of contents links/pg for multiple workbooks
  • From: Gord Dibben
• Re: SUMPODUCT - Some one please help !!!
  • From: Rick Rothstein \(MVP - VB\)
• Re: copy cells
  • From: Gord Dibben
• Re: copy cells
  • From: Rick Rothstein \(MVP - VB\)
• Re: copy cells
  • From: Don Guillett
• Re: function for repeated cells
  • From: Rick Rothstein \(MVP - VB\)
• Re: function for repeated cells
  • From: T. Valko
• Re: function for repeated cells
  • From: Haz
• Re: Array formula on INDEX function not working
  • From: Bob Phillips
• Re: LOOKUP, MATCH, INDEX?
  • From: ShaneDevenshire
• Re: function for repeated cells
  • From: T. Valko
• Re: Apply conditional formatting to individual cell Excel 2007
  • From: Roger Govier
• Re: function for repeated cells
  • From: T. Valko
• Re: How do I use excel for orders of 250 photos for 200 staff
  • From: Gord Dibben
• Re: Array formula on INDEX function not working
  • From: Dave Peterson
• Re: conversionof numeric data in word
  • From: Rick Rothstein \(MVP - VB\)
• Re: Array formula on INDEX function not working
  • From: Roger Govier
• Re: Array formula on INDEX function not working
  • From: vsoler
• Re: Array formula on INDEX function not working
  • From: Dave Peterson
• Re: How do I use excel for orders of 250 photos for 200 staff
  • From: MartinW
• Re: conversionof numeric data in word
  • From: Bob Phillips
• Re: LOOKUP, MATCH, INDEX?
  • From: Roger Govier
• Re: Array formula on INDEX function not working
  • From: Roger Govier
• Re: maybe by sumproduct or some other way with text.
  • From: Roger Govier
• Re: LOOKUP, MATCH, INDEX?
  • From: Ragdyer
• Re: Format Cells for Mins / Secs
  • From: Roger Govier
• Re: summary of milestone
  • From: Roger Govier
• Re: Highlighting with hyperlinks
  • From: Gord Dibben
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: T. Valko
• Re: Maximum filesize?
  • From: JLatham
• maybe by sumproduct or some other way with text.
  • From: driller
• Re: summary of milestone
  • From: driller
• Re: PER function
  • From: Ron Rosenfeld
• PER function
  • From: jpanknin
• Re: Array formula on INDEX function not working
  • From: Bob Phillips
• Array formula on INDEX function not working
  • From: vsoler
• Re: Sum from two pages
  • From: Gord Dibben
• Re: Maximum filesize?
  • From: Jen
• RE: Maximum filesize?
  • From: ShaneDevenshire
• Re: List cell values seperated by comma if criteria met
  • From: T. Valko
• Re: summary of milestone
  • From: T. Valko
• Re: Maximum filesize?
  • From: Jen
• Re: summary of milestone
  • From: Roger Govier
• Re: Extracting data
  • From: Ron Rosenfeld
• RE: Maximum filesize?
  • From: JLatham
• Re: Sum from two pages
  • From: Gord Dibben
• Re: type a 00 . It keeps changing back to 0
  • From: Gord Dibben
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: T. Valko
• Re: LOOKUP, MATCH, INDEX?
  • From: RagDyeR
• Re: LOOKUP, MATCH, INDEX?
  • From: RagDyeR
• Maximum filesize?
  • From: Jen
• Levy Jennings QC template
  • From: jimbo
• Re: LOOKUP, MATCH, INDEX?
  • From: Rick Rothstein \(MVP - VB\)
• Re: summary of milestone
  • From: JLatham
• Re: Merge of cells
  • From: Gord Dibben
• Re: Sorting errs
  • From: Dave Peterson
• Re: Sorting errs
  • From: Jen
• RE: Adjusting Timeline with a link
  • From: ¤§Tarzan§¤
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: Don Guillett
• Re: Sorting errs
  • From: Dave Peterson
• Re: SUMPRODUCT MISSING SOME ITEMS
  • From: vsoler
• Re: How do you remove some numbers in a series eg 1500024500 = 24500
  • From: Roger Govier
• Re: summary of milestone
  • From: Roger Govier
• Re: Sorting errs
  • From: Jen
• Re: Merge of cells
  • From: Heine
• RE: SUMPODUCT - Some one please help !!!
  • From: JMB
• Re: Vlookup question
  • From: T. Valko
• Re: SUMPODUCT - Some one please help !!!
  • From: Roger Govier
• Re: Vlookup question
  • From: Tremag
• Re: Quick Go To for Formula Components Other than First
  • From: excel wonk
• Re: SUMPRODUCT
  • From: JMB
• Quick Go To for Formula Components Other than First
  • From: excel wonk
• Re: Vlookup question
  • From: T. Valko
• Vlookup question
  • From: Tremag
• Re: If function help
  • From: Frank
• Re: determine wheter string has a number in it?
  • From: T. Valko
• Re: If function help
  • From: Gord Dibben
• Re: If function help
  • From: Frank
• RE: summary of milestone
  • From: JLatham
• Re: nested vlookup does not work
  • From: T. Valko
• Re: lookup a value from a list excluding a previously found value
  • From: T. Valko
• Re: How to change text color in a cell "comment" in Office 2007?
  • From: Sebation.G
• Re: Sorting errs
  • From: Pete_UK
• Re: Sorting errs
  • From: Dave Peterson
• Sorting errs
  • From: SG
• Re: Merge of cells
  • From: JE McGimpsey
• lookup a value from a list excluding a previously found value
  • From: antonio
• Re: multiple if statment
  • From: MyVeryOwnSelf
• Re: custom autofilter
  • From: Dave Peterson
• Re: splitting cell
  • From: David Biddulph
• Re: INDEX/MATCH/LARGE returning #VALUE! error
  • From: T. Valko
• Re: INDEX/MATCH/LARGE returning #VALUE! error
  • From: Roger Govier
• Re: INDEX/MATCH/LARGE returning #VALUE! error
  • From: T. Valko
• Re: SUMPRODUCT
  • From: Mark Allen
• Re: How do I change the size of the drop-down arrow after validating?
  • From: Dave Peterson
• Re: How do I change the size of the drop-down arrow after validating?
  • From: Dave Peterson
• Re: Sorting numbers with two decimals
  • From: Bernd
• Re: Merge of cells
  • From: Heine
• Re: INDEX/MATCH/LARGE returning #VALUE! error
  • From: T. Valko
• Re: Subtracting Text from Number
  • From: Peo Sjoblom
• Re: Subtracting Text from Number
  • From: PCLIVE
• Re: on time indicator
  • From: David Biddulph
• Re: copying one cell in multiple sheets into a column on one sheet
  • From: vezerid
• Re: INDEX/MATCH/LARGE returning #VALUE! error
  • From: Roger Govier
• Re: Compare data in one sheet to another
  • From: Peo Sjoblom
• Re: SUMPRODUCT
  • From: Roger Govier
• Re: SUMPRODUCT
  • From: Mark Allen
• Re: SUMPRODUCT
  • From: Roger Govier
• Re: copying one cell in multiple sheets into a column on one sheet
  • From: vezerid
• Re: SUMPRODUCT
  • From: Mark Allen
• Re: Invoices
  • From: Roger Govier
• Re: SUMPRODUCT
  • From: Roger Govier
• Re: Invoices
  • From: JE McGimpsey
• Re: Displaying calculated times - half-hours are not calculating...
  • From: Roger Govier
• Re: SUMPRODUCT
  • From: Roger Govier
• Displaying calculated times - half-hours are not calculating...
  • From: jacob
• Re: Merge of cells
  • From: JE McGimpsey
• Re: Updating Master Log records
  • From: Sinner
• Re: Counting non-blank cells in a column, excluding hidden rows
  • From: Don Guillett
• Merge of cells
  • From: Heine
• Merge of cells
  • From: Heine
• Merge of cells
  • From: Heine
• Re: If function help
  • From: JE McGimpsey
• Re: copy all and paste values for all sheets in a workbook
  • From: Ron de Bruin
• Re: I don't understand this formula {=TABLE(d19,d21)} - please help
  • From: Ridgeline . capital
• Re: sorting column data
  • From: Don Guillett
• Re: Counting non-blank cells in a column, excluding hidden rows
  • From: Don Guillett
• Re: Calculate Percentiles with dynamic ranges
  • From: vezerid
• Re: I don't understand this formula {=TABLE(d19,d21)} - please help
  • From: Roger Govier
• Re: Distribution of amount using If Cond / any other function / by VBA
  • From: vezerid
• Re: Sorting numbers with two decimals
  • From: Beege
• Re: Sorting numbers with two decimals
  • From: vezerid
• Re: What does this function do? {=table(D19,D21)}
  • From: Ridgeline . capital
• Re: Frame an Invoice from the data available in a separate sheet of excel
  • From: No News
• Re: I don't understand this formula {=TABLE(d19,d21)} - please help
  • From: Ridgeline . capital
• Re: I don't understand this formula {=TABLE(d19,d21)} - please help
  • From: David Biddulph
• Re: What does this function do? {=table(D19,D21)}
  • From: Roger Govier
• Re: I don't understand this formula {=TABLE(d19,d21)} - please help
  • From: Roger Govier
• What does this function do? {=table(D19,D21)}
  • From: Ridgeline . capital
• Re: Frame an Invoice from the data available in a separate sheet of excel
  • From: vezerid
• Re: how to find common cells in several columns
  • From: vezerid
• Re: Converting annual rate of return to quarterly equivalent?
  • From: Carl LaFong
• Re: Converting annual rate of return to quarterly equivalent?
  • From: David Biddulph
• Re: Converting annual rate of return to quarterly equivalent?
  • From: vezerid
• Re: Date question
  • From: vezerid
• Re: get a column of cells to add if current month
  • From: Roger Govier
• Re: Conditional Ranking
  • From: Bernd
• Converting annual rate of return to quarterly equivalent?
  • From: Carl LaFong
• Re: If function help
  • From: David Biddulph
• Re: Return an absolutely empty cell ... but not ""
  • From: T. Valko
• Re: Conditional Ranking
  • From: T. Valko
• Conditional Ranking
  • From: matthew . clegg
• Frame an Invoice from the data available in a separate sheet of excel
  • From: No News
• Re: If function help
  • From: Frank
• Re: Sort by week and year
  • From: Pete_UK
• Re: get a column of cells to add if current month
  • From: Dave Peterson
• Re: cannot enable redo-undo function
  • From: Dave Peterson
• Re: eliminate space at beginning of line
  • From: Roger Govier
• Re: How to Validate Excel for SOX (Sarbanes & Oxley)
  • From: JE McGimpsey
• Re: How to Validate Excel for SOX (Sarbanes & Oxley)
  • From: Harlan Grove
• Re: get a column of cells to add if current month
  • From: Roger Govier
• Re: cannot enable redo-undo function
  • From: Oldtimer
• Re: Data Validation
  • From: Pete_UK
• Re: Sort by Year and Week
  • From: Pete_UK
• Re: Sort by week and year
  • From: Pete_UK
• Re: Formatting & Formula Problem
  • From: Pete_UK
• Re: Adding and Subtracting a Time with MilliSeconds
  • From: Erny
• Re: copy all and paste values for all sheets in a workbook
  • From: cass calculator
• Re: Formatting & Formula Problem
  • From: Titanium
• Re: Fill Cells Based On Cells In Another Sheet
  • From: blackice912
• Re: Formula for Pulling partial data from one cell into another
  • From: Ken Johnson
• Fill Cells Based On Cells In Another Sheet
  • From: blackice912
• Re: Formula for Pulling partial data from one cell into another
  • From: Rick Rothstein \(MVP - VB\)