microsoft.public.excel.worksheet.functions

Date Index

Match Multiple Criteria & Return Numeric Labels across single row, Sam via OfficeKB.com
Countif formula problem, Robert Smith
- Re: Countif formula problem, T. Valko
- Message not available
  - Re: Countif formula problem, Robert Smith
Re: Formula to display column widths?, Gord Dibben
Re: referring to sheet in another file, Don Guillett
Is this even possible?, KeyAdministration
RE: day of Month, Mike H
- RE: day of Month, notaclue
  - RE: day of Month, Mike H
    - RE: day of Month, notaclue
Re: referring to a sheet in another file, Don Guillett
Re: CheckBoxes Stack up when Rows are hidden and unhidden, Dave Peterson
- Re: CheckBoxes Stack up when Rows are hidden and unhidden, Carla
Re: How do I enter 1635 and see 4:35 PM in the cell?, MartinW
- Re: How do I enter 1635 and see 4:35 PM in the cell?, muddan madhu
- <Possible follow-ups>
- Re: How do I enter 1635 and see 4:35 PM in the cell?, Don Guillett
Good post, Darknight7
- Re: Good post, Don Guillett
Formula to display data if it meets multiple criteria, Keniesha
- RE: Formula to display data if it meets multiple criteria, Gary''s Student
  - RE: Formula to display data if it meets multiple criteria, Keniesha
    - RE: Formula to display data if it meets multiple criteria, Gary''s Student
Re: Microsoft Excel 2003, Gord Dibben
Re: change rows to columns/columns to rows, Gord Dibben
Re: syntax for countif when cells fall within a numerical range, Max
- <Possible follow-ups>
- Re: syntax for countif when cells fall within a numerical range, T. Valko
Cell Change to Comment, buck . chicagocraigslist
- RE: Cell Change to Comment, Gary''s Student
  - Re: Cell Change to Comment, buck . chicagocraigslist
Re: Problems creating a result based on 2 cells being true.., Don Guillett
- Re: Problems creating a result based on 2 cells being true.., Lucky
  - Re: Problems creating a result based on 2 cells being true.., Don Guillett
Re: return text value found most frequently in a column, T. Valko
- <Possible follow-ups>
- RE: return text value found most frequently in a column, globetrotter
Re: insert cells in alternating rows?, Reitanos
Re: SUMPRUDUCT 3 Pieces of Criteria, T. Valko
Re: SUM+IF Array formula, Bob Phillips
Hiding columns based on row 4 criteria, Pierre
- Message not available
  - Re: Hiding columns based on row 4 criteria, Pierre
Pull data from various worksheet, JMac
RE: Counting cells with colored font, JockW
RE: IF Statement based on cell color, Gary''s Student
- RE: IF Statement based on cell color, Koshkii
Re: Search for a partial number, Ron Rosenfeld
Re: Vlookup areas?, Pete_UK
- <Possible follow-ups>
- Re: Vlookup areas?, L. Howard Kittle
Re: random letter generation, Ann
- <Possible follow-ups>
- Re: random letter generation, Rick Rothstein $MVP - VB$
RE: Summing Multiple Columns, SFO User
- Re: Summing Multiple Columns, Bob Phillips
Find position of first non-matching character, Greg Lovern
- Re: Find position of first non-matching character, Charles Williams
- Message not available
  - Re: Find position of first non-matching character, Greg Lovern
- Message not available
  - Re: Find position of first non-matching character, Greg Lovern
- Message not available
  - Re: Find position of first non-matching character, Greg Lovern
- Re: Find position of first non-matching character, Ron Rosenfeld
  - Re: Find position of first non-matching character, Greg Lovern
    - Re: Find position of first non-matching character, Ron Rosenfeld
    - Re: Find position of first non-matching character, Ron Rosenfeld
    - Re: Find position of first non-matching character, Harlan Grove
    - Re: Find position of first non-matching character, Ron Rosenfeld
    - Re: Find position of first non-matching character, T. Valko
    - Re: Find position of first non-matching character, Ron Rosenfeld
Re: Need to count dates in a spreadsheet, Tomcat
Re: Multi YTD Summary, muddan madhu
- Re: Multi YTD Summary, zy1972
Solver for budgeting, Taylor
- Re: Solver for budgeting, Fred Smith
Re: Escalation Formula, Dana DeLouis
- Re: Escalation Formula, Joe Gieder
  - Re: Escalation Formula, Don Guillett
Re: IF with multiple formula/variable, muddan madhu
- Re: IF with multiple formula/variable, Mtavares
RE: display the cell ref a matching number is in, Mike H
If Formula, dazoloko via OfficeKB.com
Replacing a list of codes with names, Mortir
- Re: Replacing a list of codes with names, Pete_UK
  - Re: Replacing a list of codes with names, Mortir
    - Re: Replacing a list of codes with names, Pete_UK
Re: StopWatch Macros, muddan madhu
RE: Marco To Save Column A7 As A .txt File., Chris
- RE: Marco To Save Column A7 As A .txt File., Chris
  - RE: Marco To Save Column A7 As A .txt File., Mike H
    - RE: Marco To Save Column A7 As A .txt File., Chris
    - RE: Marco To Save Column A7 As A .txt File., Mike H
- RE: Marco To Save Column A7 As A .txt File., Mike H
  - RE: Marco To Save Column A7 As A .txt File., Chris
    - RE: Marco To Save Column A7 As A .txt File., Mike H
    - RE: Marco To Save Column A7 As A .txt File., Chris
    - RE: Marco To Save Column A7 As A .txt File., Mike H
Re: How to sum a variable number of items, Peo Sjoblom
RE: Multiple condition countif for excel 2003, Stefi
- RE: Multiple condition countif for excel 2003, goayimm
  - RE: Multiple condition countif for excel 2003, Stefi
Re: How do I lookup a worksheet name in excel?, Rick Rothstein $MVP - VB$
- Re: How do I lookup a worksheet name in excel?, Rick Rothstein $MVP - VB$
Re: ?? VLookup ??, Pete_UK
RE: Formatting cells, OssieMac
Re: date calculation, Peo Sjoblom
Re: button in a cell to activate a macro, Reitanos
- <Possible follow-ups>
- RE: button in a cell to activate a macro, Dave
- Re: button in a cell to activate a macro, Gord Dibben
Re: Change 1234567890 to 123-456-7890, Rick Rothstein $MVP - VB$
- Re: Change 1234567890 to 123-456-7890, Rick Rothstein $MVP - VB$
  - Re: Change 1234567890 to 123-456-7890, Peo Sjoblom
- <Possible follow-ups>
- Re: Change 1234567890 to 123-456-7890, Peo Sjoblom
- Re: Change 1234567890 to 123-456-7890, Sandy Mann
  - Message not available
    - Re: Change 1234567890 to 123-456-7890, Sandy Mann
MAX TEXT ON A MASSEGE?, Papin
- Re: MAX TEXT ON A MASSEGE?, David Biddulph
  - Re: MAX TEXT ON A MASSEGE?, Papin
How do i name a range of data in excel, scooter
- Re: How do i name a range of data in excel, Peo Sjoblom
Re: Show text massege when formula result is true, Sandy Mann
- <Possible follow-ups>
- Re: Show text massege when formula result is true, PCLIVE
  - Re: Show text massege when formula result is true, Sandy Mann
    - Re: Show text massege when formula result is true, PCLIVE
- Re: Show text massege when formula result is true, Reitanos
- Re: Show text massege when formula result is true, Reitanos
Re: if negative figure, Stephen Bye
- <Possible follow-ups>
- Re: if negative figure, Dana DeLouis
RE: alphnumeric if then statements?, Loretta
Re: finding 75 days before current date, Rick Rothstein $MVP - VB$
- Re: finding 75 days before current date, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: finding 75 days before current date, Ron Rosenfeld
Re: Nesting Eroor - more than 64, Pete_UK
- Re: Nesting Eroor - more than 64, jaclh2o
  - Re: Nesting Eroor - more than 64, Pete_UK
Re: Worksheet autocalc with min function in error, Reitanos
- <Possible follow-ups>
- Re: Worksheet autocalc with min function in error, Niek Otten
Re: Subtracting Dates, Pete_UK
- <Possible follow-ups>
- RE: Subtracting Dates, LanceB
- Re: Subtracting Dates, muddan madhu
  - Re: Subtracting Dates, muddan madhu
    - Re: Subtracting Dates, Fred Smith
- Re: Subtracting Dates, Reitanos
- Re: Subtracting Dates, Rick Rothstein $MVP - VB$
Re: loan amortization schedule - skiped months, Niek Otten
- <Possible follow-ups>
- Re: loan amortization schedule - skiped months, Fred Smith
Re: Linking two whole worksheets, Spiky
- <Possible follow-ups>
- Re: Linking two whole worksheets, Gord Dibben
RE: Highlighting cells in one column from a formula valuein anothe, Brian H
RE: Monster of a formula!!, Tom Hutchins
- <Possible follow-ups>
- Re: Monster of a formula!!, Ron Rosenfeld
- Re: Monster of a formula!!, Rick Rothstein $MVP - VB$
Re: Highlighting cells in one column from a formula valuein another co, Reitanos
RE: is there a way to show what each cell links to?, Mike H
Re: Adding new data to tables and charts in excel sheets from 97/2003, Spiky
calculate total items meeting criteria in range with multiple shee, twototango
- Re: calculate total items meeting criteria in range with multiple shee, Domenic
  - Re: calculate total items meeting criteria in range with multiple, twototango
Re: Excel-how to link source workbook to copy of destination workbook, Spiky
Re: Conditionally highlight a row on a cell content, Spiky
Re: Trying to build reference to external, web-based sheets, Peo Sjoblom
- Re: Trying to build reference to external, web-based sheets, Error trying to sort in a Macro
Re: filtering problems, Roger Govier
Request, Support Request
Re: problem naming range, Don Guillett
- Message not available
  - Re: problem naming range, Don Guillett
- Message not available
  - Re: problem naming range, Roger Govier
Re: Alpha column lables, Reitanos
Re: Please help, Peo Sjoblom
Re: date > date function, Pete_UK
- Re: date > date function, David Biddulph
  - Re: date > date function, Pete_UK
    - Re: date > date function, Ann
    - Re: date > date function, David Biddulph
    - Re: date > date function, Ann
    - Re: date > date function, Pete_UK
- Message not available
  - Re: date > date function, Pete_UK
Re: Removing Spaces In Cells, Peo Sjoblom
- <Possible follow-ups>
- RE: Removing Spaces In Cells, Chris
- RE: Removing Spaces In Cells, Mike H
- Re: Removing Spaces In Cells, Pete_UK
  - Re: Removing Spaces In Cells, Pete_UK
    - Re: Removing Spaces In Cells, Chris
    - Re: Removing Spaces In Cells, Pete_UK
Re: Sum function when the values in an xls are color coded, Niek Otten
RE: Date - Help, pdberger
- <Possible follow-ups>
- Re: Date - Help, Reitanos
Re: countif & subtotal functions, PCLIVE
- Re: countif & subtotal functions, David Biddulph
  - Re: countif & subtotal functions, PCLIVE
Re: daily trade blotter, Don Guillett
- Message not available
  - Re: daily trade blotter, Reitanos
- Message not available
  - Re: daily trade blotter, Don Guillett
    - Message not available
    - Re: daily trade blotter, Don Guillett
Re: List of cells that contain a particular word, Max
Re: Converting COUNTIFS to 2003 format, Ron Coderre
- <Possible follow-ups>
- RE: Converting COUNTIFS to 2003 format, Teethless mama
  - Re: Converting COUNTIFS to 2003 format, Ron Coderre
Re: Find function, Dave Peterson
- <Possible follow-ups>
- Re: Find function, David Biddulph
  - Re: Find function, David Biddulph
    - Re: Find function, Eric @ BP-EVV
    - Re: Find function, Ron Rosenfeld
Re: Request for formula to refer some letters from Cell, Ron Rosenfeld
- Re: Request for formula to refer some letters from Cell, Ron Rosenfeld
  - Re: Request for formula to refer some letters from Cell, PERANISH
    - Re: Request for formula to refer some letters from Cell, Ron Rosenfeld
- <Possible follow-ups>
- RE: Request for formula to refer some letters from Cell, PERANISH
- RE: Request for formula to refer some letters from Cell, PERANISH
Re: Countif & Sumif, JulesHR
Re: Sum if function, Bernard Liengme
- <Possible follow-ups>
- Re: Sum if function, David Biddulph
Re: IF Cell A1 = Home, Cell A2 should change to 123, Pete_UK
- Message not available
  - Re: IF Cell A1 = Home, Cell A2 should change to 123, Pete_UK
Re: Sum with special requirement, Bob Phillips
- Re: Sum with special requirement, firroo
Re: what formula will get the url from a cell with a hyperlink?, Peo Sjoblom
RE: Summing distinct columns, SFO User
- Re: Summing distinct columns, Spiky
  - Re: Summing distinct columns, SFO User
calculate total number of items that meet 2 over multiple sheets, twototango
- Re: calculate total number of items that meet 2 over multiple sheets, Rick Rothstein $MVP - VB$
  - Re: calculate total number of items that meet 2 over multiple sheets, Bob Phillips
    - Re: calculate total number of items that meet 2 over multiple sheets, Rick Rothstein $MVP - VB$
    - Re: calculate total number of items that meet 2 over multiple sheets, Bob Phillips
    - Re: calculate total number of items that meet 2 over multiple shee, twototango
RE: cell reference in sumifs, Teethless mama
- Message not available
  - Message not available
    - Re: cell reference in sumifs, T. Valko
Counting highest values within groups of four, PaladinWhite
- Re: Counting highest values within groups of four, T. Valko
  - Re: Counting highest values within groups of four, T. Valko
- RE: Counting highest values within groups of four, Teethless mama
Re: Conditional Formating =mod($a2,2) = not(mod($a2,2)), Pete_UK
- Message not available
  - Re: Conditional Formating =mod($a2,2) = not(mod($a2,2)), Pete_UK
Re: Conditional formatting using If, Pete_UK
multiple cell reference from sheet to sheet, KMR R.A.
Re: Sumproduct multiple criteria, Scott Kieta
RE: unique records in specified range, adimar
- RE: unique records in specified range, Teethless mama
- <Possible follow-ups>
- Re: unique records in specified range, Spiky
Re: How to round a number up or down, David Biddulph
- Message not available
  - Re: How to round a number up or down, David Biddulph
Re: date range additions, Peo Sjoblom
- Message not available
  - Message not available
    - Message not available
    - Re: date range additions, Peo Sjoblom
Re: Sending Email with Worksheet Content, Ron de Bruin
Re: Display next to last results, Rick Rothstein $MVP - VB$
- Re: Display next to last results, T. Valko
  - Re: Display next to last results, Rick Rothstein $MVP - VB$
    - Re: Display next to last results, Teethless mama
    - Re: Display next to last results, Rick Rothstein $MVP - VB$
Re: #DIV/0! errors, PCLIVE
- <Possible follow-ups>
- Re: #DIV/0! errors, David Biddulph
RE: CountIf, gtlca
- <Possible follow-ups>
- RE: CountIf, ND Pard
  - RE: CountIf, gtlca
- RE: CountIf, gtlca
- RE: CountIf, gtlca
Re: If Statement with Two Different Logical Test, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: If Statement with Two Different Logical Test, T. Valko
  - Re: If Statement with Two Different Logical Test, Storm
    - Re: If Statement with Two Different Logical Test, T. Valko
    - Re: If Statement with Two Different Logical Test, Storm
    - Re: If Statement with Two Different Logical Test, T. Valko
- Re: If Statement with Two Different Logical Test, Aladin Akyurek
- RE: If Statement with Two Different Logical Test, ASA
Re: Linking my worksheets, Otto Moehrbach
- Message not available
  - Re: Linking my worksheets, Otto Moehrbach
Re: IF/Then Theory between two or more tabs., Otto Moehrbach
- Re: IF/Then Theory between two or more tabs., Otto Moehrbach
  - Re: IF/Then Theory between two or more tabs., ruaduck
RE: Advanced Probability., Gary''s Student
- Message not available
  - RE: Advanced Probability., Gary''s Student
    - RE: Advanced Probability., Luke
- Message not available
  - RE: Advanced Probability., MyVeryOwnSelf
- Re: Advanced Probability., joeu2004
  - Re: Advanced Probability., joeu2004
  - Re: Advanced Probability., joeu2004
    - Re: Advanced Probability., joeu2004
Re: if then statement based on another column, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: if then statement based on another column, PCLIVE
  - Message not available
    - Re: if then statement based on another column, PCLIVE
Re: incorrect calculation, Otto Moehrbach
Re: if then count sum, Rick Rothstein $MVP - VB$
- Message not available
  - Re: if then count sum, Rick Rothstein $MVP - VB$
- Message not available
  - Re: if then count sum, Bob Phillips
    - Message not available
    - Re: if then count sum, Bob Phillips
    - Re: if then count sum, David Biddulph
Re: Reviewing Large IF Statements - Any Tools available?, Niek Otten
- Message not available
  - Re: Reviewing Large IF Statements - Any Tools available?, Niek Otten
RE: Linking Texts from on sheet to another while maintaining formattin, Jim Thomlinson
Re: If, greater than, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: If, greater than, T. Valko
- Re: If, greater than, Otto Moehrbach
percentage range, geisha666
- RE: percentage range, Gary''s Student
Re: Using Worksheet Name in Code/Formula, Pete_UK
- Re: Using Worksheet Name in Code/Formula, Joe Gieder
- <Possible follow-ups>
- Re: Using Worksheet Name in Code/Formula, Rick Rothstein $MVP - VB$
using slope function with non contiguous cells, fallowfz
RE: Consoildation of data for upload, Bob
Re: Lookup Issue due to formatting, T. Valko
- Message not available
  - Re: Lookup Issue due to formatting, T. Valko
    - Re: Lookup Issue due to formatting, The Intern
    - Re: Lookup Issue due to formatting, T. Valko
Re: formula for conditional formatting, Bob Phillips
Re: Prediction, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: Prediction, Jim Cone
  - Re: Prediction, Rick Rothstein $MVP - VB$
- RE: Prediction, Marcelo
- Re: Prediction, joeu2004
Re: control end in a macro, JP
Re: format_text, PCLIVE
- <Possible follow-ups>
- Re: format_text, Ron Rosenfeld
- Re: format_text, Reitanos
Re: Macro button that others can see, Reitanos
Sumif across mutiple sheets, jwang036
- Re: Sumif across mutiple sheets, Bob Phillips
  - Message not available
    - Re: Sumif across mutiple sheets, Bob Phillips
Re: Complex IF formula w/ time, David Biddulph
- Message not available
  - Re: Complex IF formula w/ time, David Biddulph
- <Possible follow-ups>
- Re: Complex IF formula w/ time, Rick Rothstein $MVP - VB$
  - Re: Complex IF formula w/ time, David Biddulph
    - Re: Complex IF formula w/ time, Rick Rothstein $MVP - VB$
  - Re: Complex IF formula w/ time, Rick Rothstein $MVP - VB$
Re: How can I automatically replace the error #N/A with 0 in Excel?, Pete_UK
- Message not available
  - Re: How can I automatically replace the error #N/A with 0 in Excel, Pete_UK
Re: Countif Problem, Sandy Mann
Countif Function Help, Safi.
- Re: Countif Function Help, Peo Sjoblom
RE: JULIAN DATES?, Erin Leva
- <Possible follow-ups>
- Re: JULIAN DATES?, Niek Otten
- Re: JULIAN DATES?, David Biddulph
- Re: JULIAN DATES?, Rick Rothstein $MVP - VB$
  - Re: JULIAN DATES?, David Biddulph
    - Re: JULIAN DATES?, Rick Rothstein $MVP - VB$
RE: Avoiding #Value errors when referencing DB Tables, JLatham
- RE: Avoiding #Value errors when referencing DB Tables, Jeff Metcalf
RE: How do I find my worksheet tabs?, Teethless mama
- <Possible follow-ups>
- Re: How do I find my worksheet tabs?, Rick Rothstein $MVP - VB$
thru form update data store in excel, deen
Re: repeated value, Pete_UK
- Re: repeated value, Sandy Mann
  - Re: repeated value, Sandy Mann
    - Re: repeated value, Pete_UK
    - Re: repeated value, Sandy Mann
- Message not available
  - Re: repeated value, YouBetcha
- Message not available
  - Re: repeated value, Pete_UK
Re: Lookup first in column, Pete_UK
- <Possible follow-ups>
- RE: Lookup first in column, Stefi
Re: Calculating waiting times, Pete_UK
- <Possible follow-ups>
- Re: Calculating waiting times, Sandy Mann
Re: can anyone give me all the functions in the excel worksheet with, muddan madhu
Re: SUM function, Rick Rothstein $MVP - VB$
Multiplying then adding Two Rows of Numbers, BRob
- Re: Multiplying then adding Two Rows of Numbers, Rick Rothstein $MVP - VB$
How to create a Exchange Currency Rate into Excel, Blue Fish
- Re: How to create a Exchange Currency Rate into Excel, Don Guillett
  - Re: How to create a Exchange Currency Rate into Excel, Blue Fish
    - Re: How to create a Exchange Currency Rate into Excel, Don Guillett
Total OVT on monthly basis, Tia
Re: Date based IF Statements, Bob Phillips
Re: Formatting Dates, Arvi Laanemets
- <Possible follow-ups>
- Re:Formatting Dates, Dave Curtis
- Re:Formatting Dates, Dave Curtis
- Re: Formatting Dates, Ron Rosenfeld
RE: Statistics - p value, Jerry W. Lewis
- Re: Statistics - p value, anwelln
RE: Fisher statistical law, Jerry W. Lewis
Report duplicate rows, matthew . clegg
- Message not available
  - Re: Report duplicate rows, matthew . clegg
Re: calculating time for late hours, JP
Re: 4 day work week, Bob Phillips
- <Possible follow-ups>
- Re: 4 day work week, Bob Phillips
  - Re: 4 day work week, Shelly
    - Re: 4 day work week, Bob Phillips
    - Re: 4 day work week, Shelly
    - Re: 4 day work week, Bob Phillips
    - Re: 4 day work week, Shelly
Placing Col & Row identifiers into a cell as text, John
- Re: Placing Col & Row identifiers into a cell as text, Pete_UK
Re: Autoformat issue, Peo Sjoblom
- Re: Autoformat issue, Imi
Re: apply conditional format to time, David Biddulph
- <Possible follow-ups>
- Re: apply conditional format to time, Peo Sjoblom
Re: Percentage Formula, David Biddulph
How to find the first row not equal to the value in the first row?, INTP56
- Re: How to find the first row not equal to the value in the first row?, Peo Sjoblom
  - Re: How to find the first row not equal to the value in the first, INTP56
    - Re: How to find the first row not equal to the value in the first, RagDyer
    - Re: How to find the first row not equal to the value in the first, RagDyer
    - Re: How to find the first row not equal to the value in the first, INTP56
    - Re: How to find the first row not equal to the value in the first, RagDyeR
- Re: How to find the first row not equal to the value in the first row?, Jim Cone
  - Re: How to find the first row not equal to the value in the first, INTP56
Excel 2008 (Mac): Conditional formatting criteria expanded?, SanDiegoGuy
Re: An "IF" function question, Rick Rothstein $MVP - VB$
- Message not available
  - Message not available
    - Message not available
    - Re: An "IF" function question, David Biddulph
- Message not available
  - Message not available
    - Message not available
    - Re: An "IF" function question, volunteer
Count multiple cells against multiple criteria in an Excel spreads, EricB
- Re: Count multiple cells against multiple criteria in an Excel spreads, Max
  - Re: Count multiple cells against multiple criteria in an Excel spr, EricB
Re: Results from more than one criteria, T. Valko
- Re: Results from more than one criteria, Formatting challenges in frontpage
  - Re: Results from more than one criteria, T. Valko
Re: Calculating 50% complete, returning Yes or No, Niek Otten
Shared workbook errors, JC
- Re: Shared workbook errors, JP
Calculation, ab3d4u
- Re: Calculation, Don Guillett
  - Re: Calculation, David Biddulph
- RE: Calculation, dhstein
RE: sumif nightmare!, Marcelo
Re:Daily time sheets, BYRON TEMBLETT
Re: FFT function/algorithm used by Excel, Harlan Grove
- Message not available
  - Re: FFT function/algorithm used by Excel, Dana DeLouis
Re: look up max, Don Guillett
- <Possible follow-ups>
- Re: look up max, Niek Otten
Re: Universal formula to all cells, MyVeryOwnSelf
Re: Counting Merged Cells, Jim Cone
- Re: Counting Merged Cells, Whois Clinton
  - Re: Counting Merged Cells, Jim Cone
    - Message not available
    - Re: Counting Merged Cells, Jim Cone
    - Re: Counting Merged Cells, Whois Clinton
Count values only if matches and return on another worksheet, candacer
- Re: Count values only if matches and return on another worksheet, Don Guillett
  - Message not available
    - Re: Count values only if matches and return on another worksheet, Don Guillett
Re: SUM formula help PLEASE???, T. Valko
- Re: SUM formula help PLEASE???, sk8gfast
- Message not available
  - Re: SUM formula help PLEASE???, T. Valko
Re: Return the filtered value into a specific cell, T. Valko
- <Possible follow-ups>
- Re: Return the filtered value into a specific cell, T. Valko
  - Re: Return the filtered value into a specific cell, Sal
Re: SUMPRODUCT Qusetion, David Biddulph
- Re: SUMPRODUCT Qusetion, Bob Phillips
  - Re: SUMPRODUCT Qusetion, Rick Rothstein $MVP - VB$
    - Re: SUMPRODUCT Qusetion, RagDyer
    - Re: SUMPRODUCT Qusetion, Rick Rothstein $MVP - VB$
  - Re: SUMPRODUCT Qusetion, RagDyer
    - Re: SUMPRODUCT Qusetion, Bob Phillips
    - Re: SUMPRODUCT Qusetion, RagDyer
    - Re: SUMPRODUCT Qusetion, Bob Phillips
- <Possible follow-ups>
- Re: SUMPRODUCT Qusetion, T. Valko
Indirect, Paul W Smith
- Re: Indirect, Harlan Grove
  - Re: Indirect, Paul W Smith
RE: How to reference Cells AA and forward with CHAR (and a bonus quest, dhstein
- <Possible follow-ups>
- Re: How to reference Cells AA and forward with CHAR (and a bonus quest, Harlan Grove
RE: Hyperlink varaible substitution - How To, Sledge Bacon
- RE: Hyperlink varaible substitution - How To, JLatham
  - RE: Hyperlink varaible substitution - How To, JLatham
    - RE: Hyperlink varaible substitution - How To, Sledge Bacon
    - RE: Hyperlink varaible substitution - How To, JLatham
    - RE: Hyperlink varaible substitution - How To, Sledge Bacon
    - RE: Hyperlink varaible substitution - How To, JLatham
- <Possible follow-ups>
- RE: Hyperlink varaible substitution - How To, Sledge Bacon
  - RE: Hyperlink varaible substitution - How To, JLatham
How do I copy a vlookup formula without changing the data range?, VickyL872
- Message not available
  - Re: How do I copy a vlookup formula without changing the data range?, Alan Beban
Re: Can I imbed a calendar to us with functions?, soconfused
- Message not available
  - Message not available
    - Message not available
    - Re: Can I imbed a calendar to us with functions?, soconfused
getting #DIV/0! when calculating percentage, Ted
- Message not available
  - Re: getting #DIV/0! when calculating percentage, Ted
- Message not available
  - Re: getting #DIV/0! when calculating percentage, Ted
Re: Copy/ paste Error " Too many different formats", Pete_UK
RE: Need formula help, Paul
- <Possible follow-ups>
- Re: Need formula help, Don Guillett
  - Re: Need formula help, Don Guillett
Calculate time with a break and total hours, Anita
- RE: Calculate time with a break and total hours, Dave
Sumproduct, Hilton
Re: Need to sum row 7 columns based row 8 columns that are not Blank, Pete_UK
- Re: Need to sum row 7 columns based row 8 columns that are not Bla, Leew
  - Re: Need to sum row 7 columns based row 8 columns that are not Bla, Pete_UK
UK Business Days Formula, WSR
- RE: UK Business Days Formula, Teethless mama
Subtracting from Different Dates, Steve M
Re: Formulas not calculating in some fields, Dave Peterson
Re: excel workbook opens small, Dave Peterson
Finding text, Naz
- Message not available
  - Re: Finding text, Naz
    - Re: Finding text, Teethless mama
    - Re: Finding text, Naz
    - Re: Finding text, Teethless mama
Re: VLOOKUP formula results strange after copying down, Charles Williams
- Re: VLOOKUP formula results strange after copying down, Code Numpty
- <Possible follow-ups>
- Re: VLOOKUP formula results strange after copying down, Bob Phillips
Excel Scientific Format, Imi
Overtime calculations, Tia
- Re: Overtime calculations, Bob Phillips
  - Re: Overtime calculations, Tia
    - Re: Overtime calculations, Bob Phillips
Fisrt letter of every word, Graham H
- Message not available
  - Re: Fisrt letter of every word, Graham H
- Re: Fisrt letter of every word, Rick Rothstein $MVP - VB$
  - Re: Fisrt letter of every word, Graham H
Re: Can i use wildcards in Sum+If statement in excel, T. Valko
- Re: Can i use wildcards in Sum+If statement in excel, judy
  - Re: Can i use wildcards in Sum+If statement in excel, T. Valko
    - Re: Can i use wildcards in Sum+If statement in excel, judy
    - Re: Can i use wildcards in Sum+If statement in excel, judy
    - Re: Can i use wildcards in Sum+If statement in excel, judy
    - Re: Can i use wildcards in Sum+If statement in excel, T. Valko
    - Re: Can i use wildcards in Sum+If statement in excel, T. Valko
    - Re: Can i use wildcards in Sum+If statement in excel, judy
    - Re: Can i use wildcards in Sum+If statement in excel, T. Valko
Re: vacation formula and 1/2 days, Fred Smith
- <Possible follow-ups>
- Re: vacation formula and 1/2 days, Rick Rothstein $MVP - VB$
Rate Worksheet Function, PatJennings
- Re: Rate Worksheet Function, Fred Smith
  - Re: Rate Worksheet Function, PatJennings
    - Re: Rate Worksheet Function, Fred Smith
    - Re: Rate Worksheet Function, PatJennings
    - Re: Rate Worksheet Function, Fred Smith
    - Re: Rate Worksheet Function, PatJennings
Re: Average number of months, Pete_UK
Re: displaying 1st, 2nd, and 3rd in one cell, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: displaying 1st, 2nd, and 3rd in one cell, T. Valko
- Re: displaying 1st, 2nd, and 3rd in one cell, David Biddulph
copy and autoadjust formula, dimitry
- Re: copy and autoadjust formula, Gord Dibben
Re: Return on a bond, pomegranate-man
airline standby worksheet, khad
- Re: airline standby worksheet, Sandy Mann
  - Message not available
    - Re: airline standby worksheet, Sandy Mann
    - Re: airline standby worksheet, Sandy Mann
    - Message not available
    - Re: airline standby worksheet, Sandy Mann
    - Re: airline standby worksheet, Sandy Mann
Re: Greater than # but less than #, Ragdyer
- <Possible follow-ups>
- Re: Greater than # but less than #, Rick Rothstein $MVP - VB$
Re: How to "go to" cell referenced in another cell, Pete_UK
- Re: How to "go to" cell referenced in another cell, BEEJAY
  - Re: How to "go to" cell referenced in another cell, Pete_UK
    - Re: How to "go to" cell referenced in another cell, BEEJAY
- <Possible follow-ups>
- Re: How to "go to" cell referenced in another cell, BEEJAY
  - Re: How to "go to" cell referenced in another cell, Max
Re: Automatic refresh of external data, Tim Zych
How do I invert a complex matrix, Greg Conway
- Re: How do I invert a complex matrix, Bernard Liengme
Re: Excel 2007 Natural language formula, Jim Cone
- Re: Excel 2007 Natural language formula, Niek Otten
Re: Copy formulas from rows & columns, muddan madhu
- <Possible follow-ups>
- RE: Copy formulas from rows & columns, Marcelo
Re: any formula to convert numbers in word form, e.g. "2" as "Two"?, Niek Otten
Re: time calculation for airline standby, Sandy Mann
- Message not available
  - Re: time calculation for airline standby, Sandy Mann
Named range not continuous. How to display values?, Fries
- RE: Named range not continuous. How to display values?, Gary''s Student
  - Re: Named range not continuous. How to display values?, Fries
- Re: Named range not continuous. How to display values?, Max
- Re: Named range not continuous. How to display values?, T. Valko
Conditional filter using array formula, matthew . clegg
- Re: Conditional filter using array formula, Bob Phillips
- RE: Conditional filter using array formula, Teethless mama
- Re: Conditional filter using array formula, T. Valko
  - Re: Conditional filter using array formula, matthew . clegg
    - Re: Conditional filter using array formula, T. Valko
Re: vlookup help, Bob Phillips
- Re: vlookup help, Giac
names instead of numbers.., edml xodus
- Re: names instead of numbers.., Per Jessen
- Re: names instead of numbers.., Bob Phillips
Re: Vlookup selecting next highest value instead of equal or nearest l, Arvi Laanemets
- <Possible follow-ups>
- Re: Vlookup selecting next highest value instead of equal or nearest l, Ragdyer
- Re: Vlookup selecting next highest value instead of equal or nearest l, Charles Williams
Re: macro to copy range, Rick Rothstein $MVP - VB$
- Re: macro to copy range, Frank Situmorang
  - Re: macro to copy range, Rick Rothstein $MVP - VB$
    - Re: macro to copy range, Frank Situmorang
    - Re: macro to copy range, Rick Rothstein $MVP - VB$
    - Re: macro to copy range, Frank Situmorang
Re: #N/A Error w/LOOKUP Function, T. Valko
- Re: #N/A Error w/LOOKUP Function, muddan madhu
  - Re: #N/A Error w/LOOKUP Function, Peo Sjoblom
Sum and multiply, art
- Re: Sum and multiply, Ron Rosenfeld
  - Message not available
    - Re: Sum and multiply, Peo Sjoblom
    - Re: Sum and multiply, Peo Sjoblom
    - Re: Sum and multiply, Ragdyer
  - Message not available
    - Re: Sum and multiply, Ron Rosenfeld
  - Message not available
    - Re: Sum and multiply, Bernard Liengme
  - Message not available
    - Re: Sum and multiply, Gord Dibben
Re: How to add an inverted comma in a cell?, Rick Rothstein $MVP - VB$
- <Possible follow-ups>
- Re: How to add an inverted comma in a cell?, Ragdyer
Re: What formula to use?, Niek Otten
- Re: What formula to use?, hollies
  - Re: What formula to use?, Fred Smith
    - Re: What formula to use?, hollies
- <Possible follow-ups>
- RE: What formula to use?, hollies
  - Re: What formula to use?, Gord Dibben
    - Re: What formula to use?, hollies
    - Re: What formula to use?, hollies
- Re: What formula to use?, Arvi Laanemets
  - Re: What formula to use?, hollies
    - Re: What formula to use?, David Biddulph
    - Re: What formula to use?, hollies
    - Re: What formula to use?, Arvi Laanemets
    - Re: What formula to use?, hollies
    - Re: What formula to use?, Arvi Laanemets
Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE, Niek Otten
- Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE, Niek Otten
- Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Joe
  - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Peo Sjoblom
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Joe
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Peo Sjoblom
  - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Ragdyer
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Joe
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Ragdyer
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Joe
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Ragdyer
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Joe
    - Re: RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DA, Ragdyer
RE: The impact of Saving in binary format, ShaneDevenshire
- <Possible follow-ups>
- RE: The impact of Saving in binary format, Frank Situmorang
  - Re: The impact of Saving in binary format, Alan
    - Re: The impact of Saving in binary format, Frank Situmorang
Custom cell format, gary
- Re: Custom cell format, Gord Dibben
- Re: Custom cell format, Per Jessen
  - Re: Custom cell format, gary
    - Re: Custom cell format, David Biddulph
Re: counting duplicate names, Max
- <Possible follow-ups>
- Re: counting duplicate names, Bernd P
- Re: counting duplicate names, T. Valko
  - Re: counting duplicate names, twototango
    - Re: counting duplicate names, Peo Sjoblom
  - Re: counting duplicate names, T. Valko
    - Re: counting duplicate names, T. Valko
Re: Verifying and moving non matching numbers in columns, Max
Re: Sum function failure, Don Guillett
- Message not available
  - Re: Sum function failure, Gord Dibben
- <Possible follow-ups>
- Re: Sum function failure, Peo Sjoblom
- Re: Sum function failure, Bernard Liengme
RE: Goal Seek with Complex Numbers, monir
- RE: Goal Seek with Complex Numbers, monir
Re: Model & Serial Numbers, Peo Sjoblom
Re: copy row content from one worksheet to another, if a condition met, Max
Referring to a cell by entering an integer; RANGE functions, Tim Murray
- Re: Referring to a cell by entering an integer; RANGE functions, Lars-�ke Aspelin
  - Re: Referring to a cell by entering an integer; RANGE functions, Lars-�ke Aspelin
    - Re: Referring to a cell by entering an integer; RANGE functions, Tim Murray
- Re: Referring to a cell by entering an integer; RANGE functions, Ron Rosenfeld
  - Re: Referring to a cell by entering an integer; RANGE functions, Tim Murray
Find And Display Surname, robzrob
- Re: Find And Display Surname, Ron Rosenfeld
  - Re: Find And Display Surname, robzrob
  - Re: Find And Display Surname, Rick Rothstein $MVP - VB$
    - Re: Find And Display Surname, Ron Rosenfeld
    - Re: Find And Display Surname, Rick Rothstein $MVP - VB$
    - Re: Find And Display Surname, Ragdyer
    - Re: Find And Display Surname, Rick Rothstein $MVP - VB$
    - Re: Find And Display Surname, Ragdyer
Hide and seek, Boblink
- Re: Hide and seek, T. Valko
RE: Time in Excel, pdberger
- RE: Time in Excel, Gibbyky2
  - Re: Time in Excel, Bernard Liengme
    - Message not available
    - Re: Time in Excel, David Biddulph
    - Re: Time in Excel, Gibbyky2
    - Re: Time in Excel, Meebers
RE: Mult formula cell displays "0", which formula created result?, Mike H
- <Possible follow-ups>
- Re: Mult formula cell displays "0", which formula created result?, Rick Rothstein $MVP - VB$
  - Re: Mult formula cell displays "0", which formula created result?, Rick Rothstein $MVP - VB$
Re: Convert Letter to Number, Rick Rothstein $MVP - VB$
Re: Using SUMIF function and conditional formatting, Bob Phillips
Re: Lookup Hyperlink, Shane Devenshire
Re: How do I Reset Column lettering, AndrewArmstrong
- <Possible follow-ups>
- Re: How do I Reset Column lettering, Gord Dibben
- Re: How do I Reset Column lettering, T. Valko
- Re: How do I Reset Column lettering, Dave Peterson
Re: Lookup Value and Return Column Heading, T. Valko
- Message not available
  - Re: Lookup Value and Return Column Heading, T. Valko
    - Re: Lookup Value and Return Column Heading, eb
    - Re: Lookup Value and Return Column Heading, eb
Re: vlookup in a multiple sheet file, L. Howard Kittle
- <Possible follow-ups>
- Re: vlookup in a multiple sheet file, L. Howard Kittle
- Re: vlookup in a multiple sheet file, L. Howard Kittle
Re: Generically reference the previous workssheet, Gord Dibben
Re: Multiple conditions in a COUNTIF, AG
- <Possible follow-ups>
- Re: Multiple conditions in a COUNTIF, Bob Phillips
  - Re: Multiple conditions in a COUNTIF, Bob Phillips
Re: Want Col B (net recpts) to calculate a % of Col A (gross recpts), Gord Dibben
Time difference w/o weekends, AG
- Re: Time difference w/o weekends, Bob Phillips
  - Re: Time difference w/o weekends, AG
    - Re: Time difference w/o weekends, daddylonglegs
    - Re: Time difference w/o weekends, Bob Phillips
- Re: Time difference w/o weekends, Shane Devenshire
  - Re: Time difference w/o weekends, daddylonglegs
    - Re: Time difference w/o weekends, AG
    - Message not available
    - Re: Time difference w/o weekends, AG
    - Re: Time difference w/o weekends, Bernd P
    - Re: Time difference w/o weekends, AG
- Re: Time difference w/o weekends, Shane Devenshire
Re: Lookup Question Based upon 2 Variables, Shane Devenshire
- <Possible follow-ups>
- Re: Lookup Question Based upon 2 Variables, Peo Sjoblom
Re: Convert Date format, Shane Devenshire
- <Possible follow-ups>
- Re: Convert Date format, Peo Sjoblom
  - Re: Convert Date format, Newbee
Re: Saving a Custom Sort, Reitanos
Re: Indicating Rows to Repeat At Top on all Worksheets Simultaneously, Dave Peterson
- <Possible follow-ups>
- Re: Indicating Rows to Repeat At Top on all Worksheets Simultaneously, Gord Dibben
Re: Automatically Copy to new Spreadsheet, MB_HCAthleticTrainer
Alert When A Document is Changed, robzrob
- RE: Alert When A Document is Changed, ryguy7272
Re: Lookup Question with multiple dynamic variables, Peo Sjoblom
- Re: Lookup Question with multiple dynamic variables, Robin
  - Re: Lookup Question with multiple dynamic variables, Peo Sjoblom
  - Message not available
    - Re: Lookup Question with multiple dynamic variables, Robin
    - Message not available
    - Re: Lookup Question with multiple dynamic variables, Robin
    - Message not available
    - Re: Lookup Question with multiple dynamic variables, Robin
    - Message not available
    - Re: Lookup Question with multiple dynamic variables, Robin
    - Re: Lookup Question with multiple dynamic variables, Peo Sjoblom
Re: if statement, Sandy Mann
- Date based IF Statement, FXone
Re: Trying to average col c if col a = "value" and col b = "value2", T. Valko
Re: entry must match value in range, Rick Rothstein $MVP - VB$
- Message not available
  - Re: entry must match value in range, Rick Rothstein $MVP - VB$
    - Re: entry must match value in range, JayBro
Compare the Cell between + or - value, Vadhimoo
- RE: Compare the Cell between + or - value, Vadhimoo
  - Re: Compare the Cell between + or - value, Reitanos
- Re: Compare the Cell between + or - value, Jim Cone
Re: How do I remove non-numerical charaters from a string?, Rick Rothstein $MVP - VB$
Sumproduct & Numbers, Sue
- Re: Sumproduct & Numbers, PCLIVE
- RE: Sumproduct & Numbers, Sue
  - Re: Sumproduct & Numbers, PCLIVE
  - Re: Sumproduct & Numbers, Peo Sjoblom
Re: Compare 2 columns and align duplicates into same row, AGOLFA
- Re: Compare 2 columns and align duplicates into same row, Max
Re: Excel Formula from one workbook/worksheet to another, Niek Otten
- Re: Excel Formula from one workbook/worksheet to another, SuziQ
Re: IF Statement Query, Pete_UK
- Message not available
  - Re: IF Statement Query, Pete_UK
    - Re: IF Statement Query, MissV
If(and formula help please, JC
RE: Lock formulas only not data, JLatham
- Message not available
  - Message not available
    - Message not available
    - Re: Lock formulas only not data, Max
Data validation - combo box, susan
- RE: Data validation - combo box, JLatham
- Re: Data validation - combo box, Debra Dalgleish
  - Re: Data validation - combo box, JLatham
    - Re: Data validation - combo box, Debra Dalgleish
document not saved, theHoysala
- Re: document not saved, Otto Moehrbach
Re: Hyperlink destinations have changed, Dave Peterson
Re: ALL and ANY functions?, Ron Rosenfeld
Re: Completed years and monhts, Pete_UK
- <Possible follow-ups>
- RE: Completed years and monhts, Mike H
  - RE: Completed years and monhts, Sai Krishna
- RE: Completed years and monhts, Stefi
  - Re: Completed years and monhts, David Biddulph
Re: please help in excel functions., Rick Rothstein $MVP - VB$
Re: please help in excel functions, Dana DeLouis
- <Possible follow-ups>
- Re: please help in excel functions, Arvi Laanemets
  - Re: please help in excel functions, Arvi Laanemets
Re: Order form - how to automatically round what a person inputs to a, Rick Rothstein $MVP - VB$
- Re: Order form - how to automatically round what a person inputs t, Just a young fella trying to have a go
  - Re: Order form - how to automatically round what a person inputs t, Rick Rothstein $MVP - VB$
Re: Summarize in Vlookup, Pete_UK
Re: Can a sort be set up to run within another sort?, Pete_UK
Re: Why would someone buy a microsoft product?, Pete_UK
- <Possible follow-ups>
- Re: Why would someone buy a microsoft product?, Arvi Laanemets
- RE: Why would someone buy a microsoft product?, JLatham
Re: How to scroll simultaneosly through two excel spreadsheets, Debra Dalgleish
Re: convert, Fred Smith
- <Possible follow-ups>
- Re: convert, Bob Phillips
Re: functions, Bob Phillips
Re: Grading Multiple Choice Exam, Bernard Liengme
- Re: Grading Multiple Choice Exam, Jay Windley
Re: linking cells from workbooks in a folder, Ron de Bruin
- Re: linking cells from workbooks in a folder, Giles
  - Re: linking cells from workbooks in a folder, Ron de Bruin
Re: SUMPRODUCT trouble with number formattin, PCLIVE
- Re: SUMPRODUCT trouble with number formattin, Kristin
  - Re: SUMPRODUCT trouble with number formattin, PCLIVE
- <Possible follow-ups>
- Re: SUMPRODUCT trouble with number formattin, T. Valko
Re: Can I repeat rows at the top, except the last page?, Jim Cone
RE: How to get YTD Summary, ShaneDevenshire
- <Possible follow-ups>
- RE: How to get YTD Summary, zy1972
Re: Sumproduct vs countif, Lars-�ke Aspelin
- Re: Sumproduct vs countif, Lars-�ke Aspelin
Re: Excel Objects and Links function grayed out, Gord Dibben
Re: Apostrophe Infront of Text & Numbers, Gord Dibben
Re: Copying a formula but only getting the result, T. Valko
- Message not available
  - Re: Copying a formula but only getting the result, T. Valko
Image Export - Org Chart, Steve G
- Re: Image Export - Org Chart, Reitanos
Re: can you imbed a sumif, PCLIVE
Re: How to extract text from middle of a string, Reitanos
Re: Keep getting #NA, Niek Otten
- <Possible follow-ups>
- Re: Keep getting #NA, T. Valko
  - Message not available
    - Re: Keep getting #NA, T. Valko
Returning Multiple Matches, Adam Hodge
Find Duplicate in a Row, Ardy
- Re: Find Duplicate in a Row, T. Valko
  - Re: Find Duplicate in a Row, Ardy
    - Re: Find Duplicate in a Row, T. Valko
    - Re: Find Duplicate in a Row, Ardy
    - Re: Find Duplicate in a Row, T. Valko
    - Re: Find Duplicate in a Row, Ardy
    - Re: Find Duplicate in a Row, T. Valko
    - Re: Find Duplicate in a Row, Ardy
Re: Excel keeps auto-changing my formulas to include other cells., Bernard Liengme
- <Possible follow-ups>
- Re: Excel keeps auto-changing my formulas to include other cells., Niek Otten
Re: Multiple Criteria for SUMIF, Don Guillett
- Re: Multiple Criteria for SUMIF, Duncan
  - Re: Multiple Criteria for SUMIF, Don Guillett
- <Possible follow-ups>
- Re: Multiple Criteria for SUMIF, Bernard Liengme
Re: cell parameters?, Pete_UK
- <Possible follow-ups>
- Re: cell parameters?, JE McGimpsey
Re: Excel changes HDA to HAD, Dave Peterson
- <Possible follow-ups>
- Re: Excel changes HDA to HAD, JE McGimpsey
- Re: Excel changes HDA to HAD, PCLIVE
Re: Can't get NETWORKDAYS to calc elapsed banking days in a month, Bob Phillips
Re: Drop Down Lists, Reitanos
RE: Date formats English/US, Stefi
- <Possible follow-ups>
- Re: Date formats English/US, Pete_UK
Re: Simple yet I can't quite get it right, Bernard Liengme
- <Possible follow-ups>
- Re: Simple yet I can't quite get it right, Bob Phillips
- Re: Simple yet I can't quite get it right, krcowen
Re: Can i set up an overdue pop up in excel?, Susan
Re: Cell validation, Bob Phillips
- Re: Cell validation, Rick Rothstein $MVP - VB$
  - Re: Cell validation, Bob Phillips
    - Re: Cell validation, Sai Krishna
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, Sai Krishna
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, Bob Phillips
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, Bob Phillips
    - Re: Cell validation, T. Valko
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, T. Valko
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, T. Valko
    - Re: Cell validation, T. Valko
- <Possible follow-ups>
- RE: Cell validation, Stefi
- Re: Cell validation, vezerid
  - Re: Cell validation, vezerid
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, T. Valko
    - Re: Cell validation, T. Valko
    - Re: Cell validation, Rick Rothstein $MVP - VB$
    - Re: Cell validation, T. Valko
    - Re: Cell validation, Rick Rothstein $MVP - VB$
  - Message not available
    - Re: Cell validation, vezerid
lookup for last value in a row, driller
- Re: lookup for last value in a row, Bob Phillips
  - Re: lookup for last value in a row, driller
    - Re: lookup for last value in a row, Bob Phillips
    - Re: lookup for last value in a row, Mike H
    - Re: lookup for last value in a row, driller
    - Re: lookup for last value in a row, Mike H
    - Re: lookup for last value in a row, driller
    - Re: lookup for last value in a row, ryguy7272
- RE: lookup for last value in a row, driller
- Message not available
  - Re: lookup for last value in a row, Bob Phillips
    - Re: lookup for last value in a row, Mike H
Re: Error Codes, Bob Phillips
Re: countif colored numbers, Bob Phillips
- <Possible follow-ups>
- Re: countif colored numbers, Pete_UK
Importing Word file and Naming of Worksheets, James8309
Does the COUNTIF criteria parameter accepts functions?, williambbradley
- Re: Does the COUNTIF criteria parameter accepts functions?, Bob Phillips
- Re: Does the COUNTIF criteria parameter accepts functions?, Pete_UK
  - Re: Does the COUNTIF criteria parameter accepts functions?, Bob Phillips
RE: Monitoring the comparison of two dates, Paul Mathews
Re: template to calculate straight line dep over many years, Fred Smith
Re: Lookup references, T. Valko
- Re: Lookup references, T. Valko
Re: How do I refresh a column after changing the formatting?, Gord Dibben
Wrap Text - Formula View, ccnlc1
- Re: Wrap Text - Formula View, Gord Dibben
Suggestions for Excel / Access interaction?, Malvaro
Re: copying formula for horizontal data to vertical in different sheet, T. Valko
- Message not available
  - Re: copying formula for horizontal data to vertical in different s, T. Valko
Re: auto saving & closing file, Spiky
RE: Conditional Formatting using 3 Traffic Lights Formula, BureFreak
Re: Round dates to weekdays, Bob Phillips
- <Possible follow-ups>
- Re: Round dates to weekdays, Ron Rosenfeld
- Re: Round dates to weekdays, T. Valko
- Re: Round dates to weekdays, Rick Rothstein $MVP - VB$
RE: complex function----Help!, narp
- RE: complex function----Help!, Marcelo
  - RE: complex function----Help!, narp
    - RE: complex function----Help!, Marcelo
Re: password protecting cell in a protected file that are not protecte, training
Re: Using VLOOKUP results in a DSUM criteria range, Spiky
- Re: Using VLOOKUP results in a DSUM criteria range, bluefish
How can you sort an Excel table by the color a row is shaded?, Mack
RE: Excel SUMIF formula statisfying two conditions, Eva L
- Re: Excel SUMIF formula statisfying two conditions, PCLIVE
  - Re: Excel SUMIF formula statisfying two conditions, Eva L
    - Re: Excel SUMIF formula statisfying two conditions, PCLIVE
    - Re: Excel SUMIF formula statisfying two conditions, Eva L
    - Re: Excel SUMIF formula statisfying two conditions, PCLIVE
- RE: Excel SUMIF formula statisfying two conditions, Marcelo
Conditional Formatting Formula, bdmatlock
- Re: Conditional Formatting Formula, Rick Rothstein $MVP - VB$
- Message not available
  - Message not available
    - RE: Conditional Formatting Formula, Mike H
RE: Function neede which checks if a value in a cell is in a defin, Marcelo
Data Label size, Phil Stanton
Re: Lookup from a list of numbers, Dean
Re: Value a cell based on vlookup results, Pete_UK
- Message not available
  - Re: Value a cell based on vlookup results, Pete_UK
    - Re: Value a cell based on vlookup results, robeck
    - Message not available
    - Re: Value a cell based on vlookup results, robeck
    - Message not available
    - Re: Value a cell based on vlookup results, robeck
use cell text in lookup function, rsmith
- Re: use cell text in lookup function, Niek Otten
- RE: use cell text in lookup function, Marcelo
Re: IF & VLOOKUP, Pete_UK
- Message not available
  - Re: IF & VLOOKUP, Pete_UK
RE: Time, Karen
- Re: Time, T. Valko
  - Re: Time, Karen
  - Re: Time, Karen
    - Re: Time, David Biddulph
    - Re: Time, Karen
Excel 2003 - sort by more than 3 criteria?, outlook user needs shelp
- Re: Excel 2003 - sort by more than 3 criteria?, Pete_UK
Re: custom data validation, Frank Pytel
- Re: custom data validation, Gareth
- Re: custom data validation, David Biddulph
  - Re: custom data validation, Frank Pytel
- <Possible follow-ups>
- Re: custom data validation, Bob Phillips
  - Re: custom data validation, Gareth
- Re: custom data validation, Bob Phillips
  - Message not available
    - Re: custom data validation, Bob Phillips
Re: change content of a given cell as different cells are indicated, Pete_UK
Why does action on one worksheet affect all worksheets?, Confused
- Re: Why does action on one worksheet affect all worksheets?, Pete_UK
  - Re: Why does action on one worksheet affect all worksheets?, Gord Dibben
  - Message not available
    - Re: Why does action on one worksheet affect all worksheets?, Pete_UK
How can I convert text to number?, northerner
- Re: How can I convert text to number?, Niek Otten
converting text to numbers, northerner
- Re: converting text to numbers, Fred Smith
  - Re: converting text to numbers, Spiky
- <Possible follow-ups>
- RE: converting text to numbers, northerner
  - RE: converting text to numbers, Marcelo
    - RE: converting text to numbers, Marcelo
- RE: converting text to numbers, Marcelo
RE: Highlight row a random color, Gary''s Student
RE: COUNTIF with text criteria, Gary''s Student
- RE: COUNTIF with text criteria, Alexey
Count zero values before specific date, lesg46
- RE: Count zero values before specific date, Gary''s Student
Conditional sums, GTIGUY
Re: Excel - count the number of records between two specific dates., Bob Phillips
- Message not available
  - Re: Excel - count the number of records between two specific dates, Bob Phillips
    - Re: Excel - count the number of records between two specific dates, DK
Extracting part of a cell, downs . ar
- Re: Extracting part of a cell, downs . ar
  - Message not available
    - Re: Extracting part of a cell, downs . ar
- RE: Extracting part of a cell, Mike H
- Re: Extracting part of a cell, Bob Phillips
- Re: Extracting part of a cell, Gord Dibben
how do i auto copy the result of a filter, ddt
VLOOKUP help needed.!!, RickJB
- Re: VLOOKUP help needed.!!, Pete_UK
  - Re: VLOOKUP help needed.!!, RickJB
if function help, Haz
- Re: if function help, Pete_UK
- Re: if function help, Pete_UK
  - Re: if function help, Pete_UK
Why does "Show Formulas" in Excel 2007 lock column alignment, Collingwood
- Re: Why does "Show Formulas" in Excel 2007 lock column alignment, Spiky
CF 2007 - Highlight entire row based on one cell, BryGuy77
- Re: CF 2007 - Highlight entire row based on one cell, David Biddulph
Only adding nonzeroes, BryGuy77
- Re: Only adding nonzeroes, Gord Dibben
Lookup & Match question, Learn-more
- Re: Lookup & Match question, T. Valko
  - Re: Lookup & Match question, Learn-more
    - Re: Lookup & Match question, T. Valko
how many inbedded if statements can i have?, Brooke
- Re: how many inbedded if statements can i have?, Arvi Laanemets
  - Re: how many inbedded if statements can i have?, T. Valko
- Re: how many inbedded if statements can i have?, T. Valko
  - Re: how many inbedded if statements can i have?, T. Valko
- Re: how many inbedded if statements can i have?, gearcutter
EXCEL 2007 Right clik options not working, candygal
- Re: EXCEL 2007 Right clik options not working, Spiky
  - Message not available
    - Re: EXCEL 2007 Right clik options not working, Spiky
    - Message not available
    - Re: EXCEL 2007 Right clik options not working, Spiky
    - Re: EXCEL 2007 Right clik options not working, candygal
Deleting Rows Containing Protected Cells, Marge O.
- RE: Deleting Rows Containing Protected Cells, eliano
  - RE: Deleting Rows Containing Protected Cells, Todd A
Nested Functions in Excel2003, BDUB
- RE: Nested Functions in Excel2003, Teethless mama
Office web component ., Ermias
Enter number in a cell and it is to display time., Peter
Named Ranges in Array Formulas, jfitzpat
- Re: Named Ranges in Array Formulas, T. Valko
- RE: Named Ranges in Array Formulas, jfitzpat
Thanks Pete_UK & T. Valko..., robzrob
- Re: Thanks Pete_UK & T. Valko..., Pete_UK
linking workbooks, Phillip2419
Finding the Value of a range in another column and showing resulti, TXDalessandros
- Re: Finding the Value of a range in another column and showing resulti, Bernard Liengme
Excel 2003 vs Excel 2007, AuntGal
COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, robzrob
- Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, Pete_UK
  - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, robzrob
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, Pete_UK
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, robzrob
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, Pete_UK
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, robzrob
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, Gord Dibben
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, robzrob
    - Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, T. Valko
- Re: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1, T. Valko
Holding the result of a formula constant or frozen, Jumbo Jock
- RE: Holding the result of a formula constant or frozen, eliano
Re: Sum If with two ranges and condition, RobinMass
IF-more than 7 arguments in, Carolina
- RE: IF-more than 7 arguments in, bpeltzer
  - RE: IF-more than 7 arguments in, Carolina
multiple Hyperlinks one Excel cell?, Jody
- Re: multiple Hyperlinks one Excel cell?, Jim Cone
  - Re: multiple Hyperlinks one Excel cell?, ryguy7272
- RE: multiple Hyperlinks one Excel cell?, Gary''s Student
- Re: multiple Hyperlinks one Excel cell?, Dave Peterson
how to sum multiple matches to a vlookup command, LoganTaylin
- Re: how to sum multiple matches to a vlookup command, Max
- RE: how to sum multiple matches to a vlookup command, Mike H
Control tab, Fairfax
- Re: Control tab, Gord Dibben
Excell is not allowing me to click onto a single cell. WHY?, typeover
- Re: Excell is not allowing me to click onto a single cell. WHY?, Gord Dibben
Table_Array arg for VLOOKUP, TMac71
- RE: Table_Array arg for VLOOKUP, ShaneDevenshire
Subtotal variable range, JDaywalt
- Re: Subtotal variable range, vezerid
HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS, MickeyMouse
- Re: HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS, David Biddulph
- Re: HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS, Gord Dibben
Adding a variable into a range declaration, Malvaro
- Re: Adding a variable into a range declaration, Dave Peterson
Use of the COUNTIF function, JCameron
- Re: Use of the COUNTIF function, Rick Rothstein $MVP - VB$
  - Re: Use of the COUNTIF function, JCameron
    - Re: Use of the COUNTIF function, Rick Rothstein $MVP - VB$
    - Re: Use of the COUNTIF function, JCameron
    - Re: Use of the COUNTIF function, Rick Rothstein $MVP - VB$
    - Re: Use of the COUNTIF function, T. Valko
    - Re: Use of the COUNTIF function, T. Valko
    - Re: Use of the COUNTIF function, Rick Rothstein $MVP - VB$
    - Message not available
    - Re: Use of the COUNTIF function, Rick Rothstein $MVP - VB$
Summarizing data into different worksheet, Liztd
- Re: Summarizing data into different worksheet, vezerid
Count times that are more than 5 minutes in a range from a new worksheet, Lenchik
- Re: Count times that are more than 5 minutes in a range from a new worksheet, T. Valko
RE: How to tell if cell contains a FORMULA or user-entered number?, Amarpas
- Re: How to tell if cell contains a FORMULA or user-entered number?, Rick Rothstein $MVP - VB$
- RE: How to tell if cell contains a FORMULA or user-entered number?, JMB
Weeks on hand, Theawilla
- RE: Weeks on hand, Mike H
- Re: Weeks on hand, vezerid
  - Re: Weeks on hand, Theawilla
    - Re: Weeks on hand, vezerid
    - Re: Weeks on hand, Theawilla
    - Re: Weeks on hand, vezerid
- Re: Weeks on hand, Rick Rothstein $MVP - VB$
How to truncate digits?, Robert Blass
- Re: How to truncate digits?, David Biddulph
  - Re: How to truncate digits?, Robert Blass
  - Re: How to truncate digits?, Robert Blass
    - Re: How to truncate digits?, Rick Rothstein $MVP - VB$
    - Re: How to truncate digits?, Robert Blass
    - Re: How to truncate digits?, vezerid
SOMASE erra cálculo, Tomas SJCampos
- Re: SOMASE erra cálculo, vezerid
Re: HOW CAN DUPLICATES BE DELETED,NOT FILTERED?, JC
Show just middle info of a cell, zeilski
- Re: Show just middle info of a cell, Don Guillett
  - Re: Show just middle info of a cell, zeilski
    - Re: Show just middle info of a cell, Don Guillett
    - Re: Show just middle info of a cell, David Biddulph
    - Re: Show just middle info of a cell, Reitanos
Re: how to remove #n/a error in excel vlookup b/c value is not fou, zeilski
- Re: how to remove #n/a error in excel vlookup b/c value is not fou, Ammo
conditional change to absolute, COB
- Re: conditional change to absolute, Rick Rothstein $MVP - VB$
Cubevalue, Robin Krupp
RE: How to calculate a percentage formula with existing data?, Payrolldept
Create List, Wilson
- RE: Create List, Wilson
  - Re: Create List, Don Guillett
    - Re: Create List, Wilson
    - Re: Create List, Wilson
    - Re: Create List, Don Guillett
on your main page click on the worksheet name and be taken to it, chiefrockeruk
- RE: on your main page click on the worksheet name and be taken to it, Gary Brown
- Re: on your main page click on the worksheet name and be taken to it, Gord Dibben
Number of rows with a non blank cell, vsoler
- Re: Number of rows with a non blank cell, Domenic
  - Re: Number of rows with a non blank cell, vsoler
- RE: Number of rows with a non blank cell, Gary''s Student
Countif depending on the conditions across multiple columns, san
- Re: Countif depending on the conditions across multiple columns, vsoler
De-identify data, Eilean
- RE: De-identify data, Gary''s Student
  - RE: De-identify data, Eilean
Picking a value from a table using Column and Row ranges?, James Dalton
- Re: Picking a value from a table using Column and Row ranges?, Bob Phillips
  - Re: Picking a value from a table using Column and Row ranges?, James Dalton
Invisible sheets, emilh
- Re: Invisible sheets, Roger Govier
  - Re: Invisible sheets, ryguy7272
Vlookup functions which could not recognise similar alphanumerics, Shawn
- Re: Vlookup functions which could not recognise similar alphanumerics, Arvi Laanemets
Steps to performing R2 function with excel, ICP Jon
- Re: Steps to performing R2 function with excel, Jim Cone
  - Re: Steps to performing R2 function with excel, ICP Jon
    - Re: Steps to performing R2 function with excel, Jim Cone
SMALL function, Wally3178
- Re: SMALL function, T. Valko
  - Re: SMALL function, Wally3178
    - Re: SMALL function, T. Valko
    - Re: SMALL function, Wally3178
    - Re: SMALL function, Bob Phillips
- Re: SMALL function, Fred Smith
  - Re: SMALL function, Wally3178
Format changed when the cell selected, Freshman
- RE: Format changed when the cell selected, Dennis
  - RE: Format changed when the cell selected, Freshman
    - RE: Format changed when the cell selected, Dennis
    - RE: Format changed when the cell selected, Dennis
    - RE: Format changed when the cell selected, Freshman
Index & Match Function, jaipal1
- Re: Index & Match Function, T. Valko
Connect Two Cells, Freshman
- Re: Connect Two Cells, T. Valko
  - Re: Connect Two Cells, Freshman
    - Re: Connect Two Cells, T. Valko
paste-special-All, qrjhaik
- Re: paste-special-All, Spiky
  - Re: paste-special-All, qrjhaik
- RE: paste-special-All, qrjhaik
  - Re: paste-special-All, Spiky
filtering dates in order, Dawn
- RE: filtering dates in order, ryguy7272
  - RE: filtering dates in order, Dawn
    - RE: filtering dates in order, Hardeep_kanwar
sorting columns when cell results based on other cells, Dawn
- Re: sorting columns when cell results based on other cells, Fred Smith
Extracting values from formulas, servboss02
- Re: Extracting values from formulas, T. Valko
- Re: Extracting values from formulas, Spiky
  - Re: Extracting values from formulas, T. Valko
Pivot Table missing data item, acss
- Re: Pivot Table missing data item, Debra Dalgleish
filtering dates, Dawn
- Re: filtering dates, David Biddulph
  - Re: filtering dates, Dawn
    - Re: filtering dates, David Biddulph
pivot tables - add columns, Renata
- Re: pivot tables - add columns, Debra Dalgleish
Sum with Array Formula, Gary''s Student
- Re: Sum with Array Formula, Max
  - Re: Sum with Array Formula, Gary''s Student
    - Re: Sum with Array Formula, Max
    - Re: Sum with Array Formula, Gary''s Student
    - Re: Sum with Array Formula, Max
- RE: Sum with Array Formula, daddylonglegs
  - RE: Sum with Array Formula, Gary''s Student
"Find" in multiple sheets!!*********Urgent, James8309
Counting Criteria in Cells in Multiple Ranges, WalterK
- RE: Counting Criteria in Cells in Multiple Ranges, Teethless mama
  - RE: Counting Criteria in Cells in Multiple Ranges, daddylonglegs
    - Re: Counting Criteria in Cells in Multiple Ranges, T. Valko
- Re: Counting Criteria in Cells in Multiple Ranges, Max
Search for duplicates across three worksheets, Sarah_Lund
- Re: Search for duplicates across three worksheets, Dave Peterson
I am looking for help with a check box formular, Buzz Local#30
- Re: I am looking for help with a check box formular, Dave Peterson
  - Re: I am looking for help with a check box formular, Buzz Local#30
    - Re: I am looking for help with a check box formular, Dave Peterson
    - Re: I am looking for help with a check box formular, Buzz Local#30
    - Re: I am looking for help with a check box formular, Dave Peterson
    - Re: I am looking for help with a check box formular, Buzz Local#30
Is it possible to dedupe two excel lists?, LSchroeter, HRW
- Re: Is it possible to dedupe two excel lists?, Pete_UK
HELP, Pfizer Gal
- Re: HELP, Dave Peterson
- Re: HELP, David Biddulph
- Re: HELP, T. Valko
Linked cells limited to ~253 characters unless source file open, ScottFisher2004
- Re: Linked cells limited to ~253 characters unless source file open, Dave Peterson
How do I enter the formula to show the current day of the week ?, Simple, but I don't know
- RE: How do I enter the formula to show the current day of the week ?, ryguy7272
  - Re: How do I enter the formula to show the current day of the week ?, David Biddulph
- Re: How do I enter the formula to show the current day of the week ?, Max
- Re: How do I enter the formula to show the current day of the week ?, Dave Peterson
Questions about copying a Formula, Boblink
- Re: Questions about copying a Formula, RagDyer
- Re: Questions about copying a Formula, Roger Govier
  - Re: Questions about copying a Formula, RagDyer
    - Re: Questions about copying a Formula, Roger Govier
    - =B$22*$A$50+SUM($A$22:A$22) -- worked like a charm, Boblink
    - Re: =B$22*$A$50+SUM($A$22:A$22) -- worked like a charm, Roger Govier
    - =MAX(0,B11-B37), Boblink
    - Re: =MAX(0,B11-B37), Roger Govier
    - Send me the file directly,, Boblink
Can I create a button for a formula?, Kristi_ut
- Re: Can I create a button for a formula?, Susan
cells don't recognize formula, Chris D
Re: How do I remove the #div or N/A and make it 0 when using VLook, Vincent
- Re: How do I remove the #div or N/A and make it 0 when using VLook, Per Jessen
Match 3 columns to one cell, Matching 3 columns to 1 cell
- Re: Match 3 columns to one cell, Jim Cone
- Re: Match 3 columns to one cell, Otto Moehrbach
  - Re: Match 3 columns to one cell, Jeff
- RE: Match 3 columns to one cell, Jeff
  - RE: Match 3 columns to one cell, ryguy7272
why are my worksheet autosum totals one cent off?, allan
- Re: why are my worksheet autosum totals one cent off?, T. Valko
- Re: why are my worksheet autosum totals one cent off?, Jim Cone
Indentify Shift number in 24 hour period, mikebres
- RE: Indentify Shift number in 24 hour period, Jason
  - RE: Indentify Shift number in 24 hour period, mikebres
- RE: Indentify Shift number in 24 hour period, mikebres
Formulas and counting, David
- Re: Formulas and counting, T. Valko
  - Re: Formulas and counting, David
    - Re: Formulas and counting, T. Valko
    - Re: Formulas and counting, David
    - Re: Formulas and counting, David
    - Re: Formulas and counting, David
    - Re: Formulas and counting, David
    - Re: Formulas and counting, T. Valko
    - Re: Formulas and counting, T. Valko
Compare text in 2 separate spreadsheets, when match found display, cocoblue
- RE: Compare text in 2 separate spreadsheets, when match found display, ryguy7272
  - RE: Compare text in 2 separate spreadsheets, when match found disp, cocoblue
    - RE: Compare text in 2 separate spreadsheets, when match found disp, cocoblue
Excel - Formula/Programming, Ezra
- Re: Excel - Formula/Programming, Otto Moehrbach
shorten IF Statements, Flanno
- RE: shorten IF Statements, bpeltzer
- Re: shorten IF Statements, Bob Phillips
  - Re: shorten IF Statements, Flanno
Cell reference question, blumonkey
- Re: Cell reference question, T. Valko
  - Re: Cell reference question, T. Valko
    - Re: Cell reference question, blumonkey
    - Re: Cell reference question, T. Valko
Combinng functions to lookup data, DP
- Re: Combinng functions to lookup data, Pete_UK
- Re: Combinng functions to lookup data, Max
Condtional formatting on 2 separate dates, mfoster
- Re: Condtional formatting on 2 separate dates, Bob Phillips
  - Re: Condtional formatting on 2 separate dates, mfoster
Separating text into seperate fields, vanced
- RE: Separating text into seperate fields, Mike H
- RE: Separating text into seperate fields, Mike H
- Re: Separating text into seperate fields, David Biddulph
Can Excel warn me if a cell already contains entered information?, Can Excel warn me if a cell already cont
- RE: Can Excel warn me if a cell already contains entered information?, Mike H
- Re: Can Excel warn me if a cell already contains entered information?, Gord Dibben
Formula to place the same value in a specific number of cells, flarunner
- Re: Formula to place the same value in a specific number of cells, Fred Smith
  - Re: Formula to place the same value in a specific number of cells, flarunner
    - Re: Formula to place the same value in a specific number of cells, Fred Smith
    - Re: Formula to place the same value in a specific number of cells, flarunner
Referencing a worksheet name to a cell..., QuietMan
- Re: Referencing a worksheet name to a cell..., David Biddulph
  - Re: Referencing a worksheet name to a cell..., QuietMan
    - Re: Referencing a worksheet name to a cell..., David Biddulph
    - Re: Referencing a worksheet name to a cell..., QuietMan
- Re: Referencing a worksheet name to a cell..., Dave Peterson
  - Re: Referencing a worksheet name to a cell..., QuietMan
    - Re: Referencing a worksheet name to a cell..., Dave Peterson
    - Re: Referencing a worksheet name to a cell..., QuietMan
    - Re: Referencing a worksheet name to a cell..., Dave Peterson
    - Re: Referencing a worksheet name to a cell..., QuietMan
Transpond one very long column to several columns of specified len, Magnus
- Re: Transpond one very long column to several columns of specified len, Max
- Re: Transpond one very long column to several columns of specified len, Gord Dibben
countifs - what is instead in excel 2000???, amir2000
- Re: countifs - what is instead in excel 2000???, Roger Govier
- Re: countifs - what is instead in excel 2000???, Max
  - Re: countifs - what is instead in excel 2000???, amir2000
    - Re: countifs - what is instead in excel 2000???, Fred Smith
    - Re: countifs - what is instead in excel 2000???, Bob Phillips
    - Re: countifs - what is instead in excel 2000???, amir2000
    - Re: countifs - what is instead in excel 2000???, Bob Phillips
    - Re: countifs - what is instead in excel 2000???, daddylonglegs
    - Re: countifs - what is instead in excel 2000???, daddylonglegs
    - Re: countifs - what is instead in excel 2000???, Roger Govier
    - Re: countifs - what is instead in excel 2000???, amir2000
    - Re: countifs - what is instead in excel 2000???, amir2000
    - Re: countifs - what is instead in excel 2000???, Fred Smith
    - Re: countifs - what is instead in excel 2000???, amir2000
Displaying Data, Sue
- Re: Displaying Data, Max
  - Re: Displaying Data, Sue
    - Re: Displaying Data, Max
    - Re: Displaying Data, Sue
    - Re: Displaying Data, Max
    - Re: Displaying Data, Sue
conditional formula - little bit of twist for my report., driller
- Re: conditional formula - little bit of twist for my report., Bob Phillips
  - Re: conditional formula - little bit of twist for my report., driller
formula for number of goods bought - HELP!!, MO987654
- Re: formula for number of goods bought - HELP!!, Bob Phillips
- RE: formula for number of goods bought - HELP!!, Gary''s Student
Need help, Excel
- Re: Need help, Bob Phillips
- RE: Need help, Gary''s Student
conditional formula, driller
- Re: conditional formula, Pete_UK
  - Re: conditional formula, driller
    - Re: conditional formula, Pete_UK
- Re: conditional formula, Bob Phillips
  - Re: conditional formula, driller
array formula, nada
- Re: array formula, Bob Phillips
how do I make excel automat gener8 the date for 28 days l8a?, jesco0
- Re: how do I make excel automat gener8 the date for 28 days l8a?, David Biddulph
- Re: how do I make excel automat gener8 the date for 28 days l8a?, Pete_UK
Dropdown list and lookup function, Shakeel
Conditional formatting with multiple formula, HALL, Steve
- RE: Conditional formatting with multiple formula, Trish
- Re: Conditional formatting with multiple formula, Bob Phillips
Format cell so number entered will show only one way, Frustrated in AZ
- Re: Format cell so number entered will show only one way, T. Valko
  - Re: Format cell so number entered will show only one way, Frustrated in AZ
    - Re: Format cell so number entered will show only one way, T. Valko
Random Numbers with certain numbers more common than others, Steve Kasher
- Re: Random Numbers with certain numbers more common than others, Jim Cone
  - Re: Random Numbers with certain numbers more common than others, Steve Kasher
- Re: Random Numbers with certain numbers more common than others, Rick Rothstein $MVP - VB$
  - Re: Random Numbers with certain numbers more common than others, Steve Kasher
- Re: Random Numbers with certain numbers more common than others, Bernd P
Sumif on pulling out data from dates, Eagleryder
- Re: Sumif on pulling out data from dates, T. Valko
  - Re: Sumif on pulling out data from dates, Eagleryder
    - Re: Sumif on pulling out data from dates, T. Valko
Vlookup for different columns in worksheet, Haz
- Re: Vlookup for different columns in worksheet, Bernard Liengme
- Message not available
  - Message not available
    - Re: Vlookup for different columns in worksheet, Max
    - Re: Vlookup for different columns in worksheet, Haz
    - Re: Vlookup for different columns in worksheet, Max
purging empty excel files, Kayestar
- Re: purging empty excel files, Spiky
Hide rows - VB, Batshon
- Re: Hide rows - VB, Nick Hodge
  - Re: Hide rows - VB, Rick Rothstein $MVP - VB$
function update, rossita77BG
- Re: function update, Gord Dibben
  - Re: function update, rossita77BG
- Re: function update, Niek Otten
Extracting cells from a table, John
- Re: Extracting cells from a table, Ron Coderre
  - Re: Extracting cells from a table, John
    - Re: Extracting cells from a table, Ron Coderre
Lottery combinations, Kobus
- RE: Lottery combinations, Mike H
  - RE: Lottery combinations, Kobus
    - RE: Lottery combinations, Mike H
    - RE: Lottery combinations, Kobus
    - Re: Lottery combinations, Meebers
    - Re: Lottery combinations, Kobus
    - Re: Lottery combinations, Mike H
    - Re: Lottery combinations, Mike H
    - Re: Lottery combinations, Mike H
    - Re: Lottery combinations, Meebers
    - Re: Lottery combinations, Mike H
  - Re: Lottery combinations, Dana DeLouis
    - Re: Lottery combinations, Mike H
  - Re: Lottery combinations, JE McGimpsey
    - Re: Lottery combinations, Mike H
    - Re: Lottery combinations, Kobus
Excel data filtering, Lakshmi Vinay
- Re: Excel data filtering, Ron de Bruin
- RE: Excel data filtering, Lakshmi Vinay
Changing Font color automatically when Cell Format is Percentage, Teljon
- Re: Changing Font color automatically when Cell Format is Percentage, Shane Devenshire
i want to use military format for time e.g. 07:00 as 0700, awais
- Re: i want to use military format for time e.g. 07:00 as 0700, Shane Devenshire
- Re: i want to use military format for time e.g. 07:00 as 0700, Gord Dibben
Automatic Upate of NOW() function?, Ed's
- RE: Automatic Upate of NOW() function?, FSt1
- Re: Automatic Upate of NOW() function?, Shane Devenshire
Column sort with Ascending / Descending Arrows, JT
- RE: Column sort with Ascending / Descending Arrows, Joel
  - RE: Column sort with Ascending / Descending Arrows, JT
- Re: Column sort with Ascending / Descending Arrows, Dave Peterson
hyperlink to a powerpoint slide, Papu
- Re: hyperlink to a powerpoint slide, Shane Devenshire
creating a combo box that shows multiple entries., Burke
- RE: creating a combo box that shows multiple entries., ryguy7272
Auto "convert" a number to a different number, Rick
- Re: Auto "convert" a number to a different number, Roger Govier
  - Re: Auto "convert" a number to a different number, Rick
- Re: Auto "convert" a number to a different number, Nick Hodge
- Re: Auto "convert" a number to a different number, Bob Phillips
Hyperlinks change when file is saved, Grey Geek
- Re: Hyperlinks change when file is saved, Spiky
  - Re: Hyperlinks change when file is saved, Grey Geek
    - Re: Hyperlinks change when file is saved, Spiky
    - Re: Hyperlinks change when file is saved, Grey Geek
- Re: Hyperlinks change when file is saved, Jim Cone
NUMBERS RUN IN ONE CELL, SANDIND
- Re: NUMBERS RUN IN ONE CELL, Bob Phillips
  - Re: NUMBERS RUN IN ONE CELL, Rick Rothstein $MVP - VB$
    - Re: NUMBERS RUN IN ONE CELL, Bob Phillips
    - Re: NUMBERS RUN IN ONE CELL, Rick Rothstein $MVP - VB$
    - Re: NUMBERS RUN IN ONE CELL, Bob Phillips
    - Re: NUMBERS RUN IN ONE CELL, Rick Rothstein $MVP - VB$
    - Re: NUMBERS RUN IN ONE CELL, SANDIND
  - Re: NUMBERS RUN IN ONE CELL, SANDIND
    - Re: NUMBERS RUN IN ONE CELL, Bob Phillips
    - Re: NUMBERS RUN IN ONE CELL, SANDIND
Comparing cells and output text, Rocketeer
- Re: Comparing cells and output text, Gord Dibben
  - Re: Comparing cells and output text, Rocketeer
- Re: Comparing cells and output text, Max
  - Re: Comparing cells and output text, Rocketeer
    - Message not available
    - Message not available
    - Re: Comparing cells and output text, Max
vlookup/match to find column name, sailingHLA
- Re: vlookup/match to find column name, Jim Cone
Building Non-Contiguous Arrays For Use With Linest, Marston
- Re: Building Non-Contiguous Arrays For Use With Linest, Domenic
  - Re: Building Non-Contiguous Arrays For Use With Linest, Marston
    - Re: Building Non-Contiguous Arrays For Use With Linest, Marston
    - Re: Building Non-Contiguous Arrays For Use With Linest, Domenic
Totaling DATEDIF SUMS, kathi
- RE: Totaling DATEDIF SUMS, daddylonglegs
  - Re: Totaling DATEDIF SUMS, Rick Rothstein $MVP - VB$
    - Re: Totaling DATEDIF SUMS, daddylonglegs
- Re: Totaling DATEDIF SUMS, Pete_UK
Use cell references in external queries, johnb49
- Re: Use cell references in external queries, Pete_UK
change a Figures into text in my excel exp. 200->two hundred, Kems
- Re: change a Figures into text in my excel exp. 200->two hundred, Niek Otten
- Re: change a Figures into text in my excel exp. 200->two hundred, Pete_UK
NOW AND TODAY, THill
- RE: NOW AND TODAY, Gary''s Student
- Re: NOW AND TODAY, Pete_UK
  - Re: NOW AND TODAY, THill
    - Re: NOW AND TODAY, Pete_UK
- Re: NOW AND TODAY, T. Valko
  - Re: NOW AND TODAY, Pete_UK
  - Re: NOW AND TODAY, daddylonglegs
    - Re: NOW AND TODAY, T. Valko
Protection, robzrob
- RE: Protection, johnb49
- RE: Protection, johnb49
  - Re: Protection, robzrob
Adding Calendar to Worksheet, tracktor
- Re: Adding Calendar to Worksheet, Rick Rothstein $MVP - VB$
  - Re: Adding Calendar to Worksheet, tracktor
    - Re: Adding Calendar to Worksheet, Rick Rothstein $MVP - VB$
    - Re: Adding Calendar to Worksheet, Rick Rothstein $MVP - VB$
    - Re: Adding Calendar to Worksheet, tracktor
    - Re: Adding Calendar to Worksheet, Gord Dibben
    - Re: Adding Calendar to Worksheet, tracktor
    - Re: Adding Calendar to Worksheet, Ron de Bruin
- Re: Adding Calendar to Worksheet, Gord Dibben
Grouping Checkboxes, tracktor
- Re: Grouping Checkboxes, Rick Rothstein $MVP - VB$
  - Re: Grouping Checkboxes, tracktor
    - Re: Grouping Checkboxes, Rick Rothstein $MVP - VB$
    - Re: Grouping Checkboxes, tracktor
    - Re: Grouping Checkboxes, Rick Rothstein $MVP - VB$
    - Re: Grouping Checkboxes, Dave Peterson
Format a blank cell based on the value of another cell, tracktor
- Re: Format a blank cell based on the value of another cell, Rick Rothstein $MVP - VB$
  - Re: Format a blank cell based on the value of another cell, tracktor
Excel 2003 Multi Worksheet Sumproduct?, wild turkey no9
Editing Text and file location for Hyperlinks, forest8
- RE: Editing Text and file location for Hyperlinks, Gary''s Student
excel formulas, Lbruce
- Re: excel formulas, Max
emptying the contets of a cell base on the value of another cell, tracktor
- RE: emptying the contets of a cell base on the value of another cell, tracktor
  - Re: emptying the contets of a cell base on the value of another cell, Rick Rothstein $MVP - VB$
    - Re: emptying the contets of a cell base on the value of another ce, tracktor
Re: Match formula question, Max
Returning a value in one cell based on the criteria of another cel, Kirstin
- Re: Returning a value in one cell based on the criteria of another cel, JE McGimpsey
- RE: Returning a value in one cell based on the criteria of another cel, Dave
need to move data to certain column if they meet criteria, klafert
Formatting a row to insert current date and time on demand, MorseCode
- Re: Formatting a row to insert current date and time on demand, JE McGimpsey
VLOOKUP or MATCH or ?, FJ
- Re: VLOOKUP or MATCH or ?, T. Valko
  - Re: VLOOKUP or MATCH or ?, FJ
    - Re: VLOOKUP or MATCH or ?, T. Valko
AutoFill with sheet reference help, TimeCloud
- Re: AutoFill with sheet reference help, T. Valko
  - Re: AutoFill with sheet reference help, TimeCloud
  - Re: AutoFill with sheet reference help, TimeCloud
    - Re: AutoFill with sheet reference help, T. Valko
    - Re: AutoFill with sheet reference help, TimeCloud
    - Re: AutoFill with sheet reference help, T. Valko
Formulas in my Workbook, hrbsh97
- Re: Formulas in my Workbook, Spiky
how to ungroup work sheets, sreenivasan k.r.
- Re: how to ungroup work sheets, Pete_UK
Unique Records Count with AutoFilter, Danni2004
- RE: Unique Records Count with AutoFilter, Danni2004
- Re: Unique Records Count with AutoFilter, Bob Phillips
Subtract two columns, but only for cells identified by if statemen, Amanda
- Re: Subtract two columns, but only for cells identified by if statemen, Rick Rothstein $MVP - VB$
  - Re: Subtract two columns, but only for cells identified by if stat, Amanda
    - Re: Subtract two columns, but only for cells identified by if stat, Rick Rothstein $MVP - VB$
  - Re: Subtract two columns, but only for cells identified by if statemen, Rick Rothstein $MVP - VB$
    - Re: Subtract two columns, but only for cells identified by if stat, Amanda
- Re: Subtract two columns, but only for cells identified by if statemen, Bob Phillips
  - Re: Subtract two columns, but only for cells identified by if stat, Amanda
    - Re: Subtract two columns, but only for cells identified by if stat, Bob Phillips
    - Re: Subtract two columns, but only for cells identified by if stat, Amanda
    - Re: Subtract two columns, but only for cells identified by if stat, Bob Phillips
    - Re: Subtract two columns, but only for cells identified by if stat, Amanda
    - Re: Subtract two columns, but only for cells identified by if stat, Bob Phillips
Formating MONTH(), Matt S
- Re: Formating MONTH(), PCLIVE
  - Re: Formating MONTH(), Matt S
- RE: Formating MONTH(), akphidelt
  - RE: Formating MONTH(), Matt S
- Re: Formating MONTH(), Rick Rothstein $MVP - VB$
  - Re: Formating MONTH(), Matt S
- Re: Formating MONTH(), krcowen
  - Re: Formating MONTH(), Matt S
Formula for Next Sheet and Every Other Cell, JEverhart
- Re: Formula for Next Sheet and Every Other Cell, Pete_UK
  - Re: Formula for Next Sheet and Every Other Cell, JEverhart
    - Re: Formula for Next Sheet and Every Other Cell, Pete_UK
    - Re: Formula for Next Sheet and Every Other Cell, Pete_UK
    - Re: Formula for Next Sheet and Every Other Cell, Gord Dibben
    - Re: Formula for Next Sheet and Every Other Cell, Pete_UK
    - Re: Formula for Next Sheet and Every Other Cell, Gord Dibben
SumIF, Flanno
- Re: SumIF, Don Guillett
- Re: SumIF, krcowen
- RE: SumIF, Mike H
- <Possible follow-ups>
- Re: sumif, Bob Phillips
- Re: sumif, Bob Phillips
- Re: sumif, Bob Phillips
- RE: SumIF, Ron@Buy
  - Message not available
    - Re: SumIf, Spiky
RE: Can I turn the #N/A result from a lookup function to a zero?, mbpoet
- Re: Can I turn the #N/A result from a lookup function to a zero?, Gaurav
How can I add "monthly" tabs that summarize a yearly report?, eg2008
- Re: How can I add "monthly" tabs that summarize a yearly report?, Reitanos
- Re: How can I add "monthly" tabs that summarize a yearly report?, krcowen
- Re: How can I add "monthly" tabs that summarize a yearly report?, Fred Smith
another COUNTIF question, Adam
- Re: another COUNTIF question, T. Valko
Losing Cell Format In Lookup Function, Jay
- Re: Losing Cell Format In Lookup Function, krcowen
Using VLOOKUP and "AND" together, chocoman
- Re: Using VLOOKUP and "AND" together, Pete_UK
  - Re: Using VLOOKUP and "AND" together, chocoman
    - Re: Using VLOOKUP and "AND" together, Pete_UK
    - Re: Using VLOOKUP and "AND" together, chocoman
    - Re: Using VLOOKUP and "AND" together, Pete_UK
If then copy to, maggiesteele
- RE: If then copy to, Dave
RE: Remove trailing spaces from multiple columns in Excel, freetry
- Re: Remove trailing spaces from multiple columns in Excel, Reitanos
Conditional formatting of entire workbook, computhom
- RE: Conditional formatting of entire workbook, Dave
  - RE: Conditional formatting of entire workbook, computhom
    - RE: Conditional formatting of entire workbook, Dave
linking worksheets to a closed workbook, LLK
- Re: linking worksheets to a closed workbook, Pete_UK
- RE: linking worksheets to a closed workbook, ryguy7272
help with IF formula, nso
- Re: help with IF formula, Pete_UK
- RE: help with IF formula, Dave
Help with Countif, Adam
- RE: Help with Countif, Dave
  - RE: Help with Countif, Adam
    - RE: Help with Countif, Dave
Print Titles, RobinT50
- Re: Print Titles, Reitanos
Looks like a comment, but isn't.... what is the yellow box called?, Retail Services
- Re: Looks like a comment, but isn't.... what is the yellow box called?, Gaurav
- RE: Looks like a comment, but isn't.... what is the yellow box called?, Gary''s Student
"nesting"?, nso
- RE: "nesting"?, Mike H
  - RE: "nesting"?, nso
Averaging only visible cells, Bear Black
- Re: Averaging only visible cells, Gaurav
- RE: Averaging only visible cells, Gary''s Student
  - RE: Averaging only visible cells, Bear Black
- Re: Averaging only visible cells, Dave Peterson
Two columns of data - How to get the unmatching cell data to colum, Cpviv
- Re: Two columns of data - How to get the unmatching cell data to colum, Gaurav
How do I enter data on one worksheet and have it appear on another, Walker28
- Re: How do I enter data on one worksheet and have it appear on another, Gaurav
Conditional Formatting with Dates (Revised), BillXMachina
- Re: Conditional Formatting with Dates (Revised), Roger Govier
  - Re: Conditional Formatting with Dates (Revised), BillXMachina
    - Re: Conditional Formatting with Dates (Revised), Roger Govier
    - Re: Conditional Formatting with Dates (Revised), BillXMachina
- RE: Conditional Formatting with Dates (Revised), ND Pard
Conditional Formatting with Dates, BillXMachina
- Re: Conditional Formatting with Dates, David Biddulph
- Re: Conditional Formatting with Dates, GoBow777
  - Re: Conditional Formatting with Dates, David Biddulph
fill autoshape color with ref cell conditional formatting, Julie
- Re: fill autoshape color with ref cell conditional formatting, Debra Dalgleish
NPV & IRR, FA
- Re: NPV & IRR, Fred Smith
  - Re: NPV & IRR, FA
    - Re: NPV & IRR, Fred Smith
    - Re: NPV & IRR, FA
    - Re: NPV & IRR, Fred Smith
Unwanted Jump to Linked Workbook, slreilly
Here's a doozy, Wilson
- Re: Here's a doozy, Roger Govier
Formula not working, Carolina Girl
- Re: Formula not working, PCLIVE
  - Re: Formula not working, Carolina Girl
    - Re: Formula not working, PCLIVE
- Re: Formula not working, Pete_UK
Rephrased - Remove blank cells - no sorting, copy or pasting, Luke
- Message not available
  - Message not available
    - Re: Rephrased - Remove blank cells - no sorting, copy or pasting, Max
    - Re: Rephrased - Remove blank cells - no sorting, copy or pasting, Luke
    - Re: Rephrased - Remove blank cells - no sorting, copy or pasting, Luke
    - Message not available
    - Message not available
    - Re: Rephrased - Remove blank cells - no sorting, copy or pasting, Max
I want quarters not months, LiveUser
- Re: I want quarters not months, Peo Sjoblom
  - Re: I want quarters not months, LiveUser
    - Re: I want quarters not months, Peo Sjoblom
    - Re: I want quarters not months, Pete_UK
    - Re: I want quarters not months, Fred Smith
please help, need to copy row to separate spreadsheet in workbook, nso
- RE: please help, need to copy row to separate spreadsheet in workbook, nso
Date Question, GMc
- Re: Date Question, T. Valko
  - Re: Date Question, GMc
    - Re: Date Question, T. Valko
Date-Mid Function, antmorano
- Re: Date-Mid Function, Dave Peterson
  - Re: Date-Mid Function, bpeltzer
    - Re: Date-Mid Function, antmorano
    - Re: Date-Mid Function, Rick Rothstein $MVP - VB$
    - Re: Date-Mid Function, antmorano
- Re: Date-Mid Function, Fred Smith
  - Re: Date-Mid Function, Peo Sjoblom
    - Re: Date-Mid Function, Fred Smith
- Message not available
  - Re: Date-Mid Function, Rick Rothstein $MVP - VB$
    - Re: Date-Mid Function, Peo Sjoblom
    - Re: Date-Mid Function, Rick Rothstein $MVP - VB$
Find values on another sheet, Joe Gieder
- Re: Find values on another sheet, Peo Sjoblom
  - Re: Find values on another sheet, Joe Gieder
    - Re: Find values on another sheet, Peo Sjoblom
    - Re: Find values on another sheet, Joe Gieder
    - Re: Find values on another sheet, Peo Sjoblom
Is merging rows possible?, Mr BT
- Re: Is merging rows possible?, Mr BT
create a spreadsheet that would insert a current date() when opene, Testudo
- Re: create a spreadsheet that would insert a current date() when opene, Dave Peterson
  - Re: create a spreadsheet that would insert a current date() when o, Testudo
Formatting imported data, Christopher . Hislop . Evans
How can i make a cell compulsory to complete?, mrh1973
Color doesn't display -all black & white, Sally in Cleveland
IRR on conditional subset of cashflows, Schwartz
Average with Criteria, Sassy
- RE: Average with Criteria, Mike H
  - RE: Average with Criteria, Sassy
    - RE: Average with Criteria, Teethless mama
    - RE: Average with Criteria, Mike H
- RE: Average with Criteria, bpeltzer
  - RE: Average with Criteria, Sassy
- RE: Average with Criteria, Stefi
Set up many cells within a cell, jrps
- Re: Set up many cells within a cell, Bernard Liengme
  - Re: Set up many cells within a cell, jrps
    - Re: Set up many cells within a cell, Bernard Liengme
    - Re: Set up many cells within a cell, David Biddulph
    - Re: Set up many cells within a cell, jrps
    - Re: Set up many cells within a cell, Spiky
    - Re: Set up many cells within a cell, David Biddulph
Validation with if, Spade
- Re: Validation with if, Sandy
"too many different cell format", FAIZ
- Re: "too many different cell format", Pete_UK
Need to reorganize data on a separate sheet possibly using vlookup, Asa_johannesen
- Re: Need to reorganize data on a separate sheet possibly using vlookup, Spiky
  - Re: Need to reorganize data on a separate sheet possibly using vlo, Asa_johannesen
    - Re: Need to reorganize data on a separate sheet possibly using vlo, Spiky
How to input data into a workbook using print command, hwcoul
- Re: How to input data into a workbook using print command, Pete_UK
Shift Scheduler, DryCanyon
Last cell always IV4036, Learn-more
- Re: Last cell always IV4036, T. Valko
excell, scott haupt
- Re: excell, Spiky
SUMIF with criteria, jj
- RE: SUMIF with criteria, jj
- Re: SUMIF with criteria, T. Valko
Conditional formula(s) & labelling, MNF
- RE: Conditional formula(s) & labelling, Gary''s Student
- Re: Conditional formula(s) & labelling, T. Valko
  - Re: Conditional formula(s) & labelling, MNF
    - Re: Conditional formula(s) & labelling, T. Valko
make VLINKUP like vlookup; smart hyperlink by data value, wizard61
- RE: make VLINKUP like vlookup; smart hyperlink by data value, ryguy7272
  - RE: make VLINKUP like vlookup; smart hyperlink by data value, wizard61
- Re: make VLINKUP like vlookup; smart hyperlink by data value, Pete_UK
PIVOT HELP, CHARI
- Re: PIVOT HELP, Roger Govier
  - Re: PIVOT HELP, CHARI
    - Re: PIVOT HELP, Roger Govier
Excel 2007 Autofilter deleting unfiltered Data, Chris
My excel spreadsheet won't print or print preview all the pages?, whirlybird
- Re: My excel spreadsheet won't print or print preview all the pages?, Pete_UK
Using Text color as criteria in formula, Rocky48
- Re: Using Text color as criteria in formula, JE McGimpsey
How can I display the first business day of the month?, Needhelp!
- RE: How can I display the first business day of the month?, FSt1
  - RE: How can I display the first business day of the month?, Needhelp!
    - Re: How can I display the first business day of the month?, Sandy Mann
    - Re: How can I display the first business day of the month?, Sandy Mann
    - Re: How can I display the first business day of the month?, Rick Rothstein $MVP - VB$
- Re: How can I display the first business day of the month?, Ron Rosenfeld
How do I display character count on the status bar?, user061803
- RE: How do I display character count on the status bar?, Billy Liddel
  - RE: How do I display character count on the status bar?, Billy Liddel
If/then formulas, akerney
- RE: If/then formulas, FSt1
- Re: If/then formulas, Niek Otten
- Re: If/then formulas, Sandy Mann
dates for on time delivery calc., Xfree
- Re: dates for on time delivery calc., Fred Smith
  - Re: dates for on time delivery calc., Xfree
401k Match, KristiM
- Re: 401k Match, JE McGimpsey
  - Re: 401k Match, KristiM
- Re: 401k Match, joeu2004
  - Re: 401k Match, KristiM
  - Message not available
    - Re: 401k Match, joeu2004
Plus/Minus 2*Standard Deviation IF OR Statement, sm416
- RE: Plus/Minus 2*Standard Deviation IF OR Statement, bpeltzer
  - RE: Plus/Minus 2*Standard Deviation IF OR Statement, sm416
    - Re: Plus/Minus 2*Standard Deviation IF OR Statement, David Biddulph
- Re: Plus/Minus 2*Standard Deviation IF OR Statement, Rick Rothstein $MVP - VB$
Labeling Grouped & Collapsed Columns, trickyfingers28
Value Function, antmorano
- Re: Value Function, David Biddulph
  - Re: Value Function, antmorano
- RE: Value Function, Gary''s Student
How do I print grid lines?, bigred
- Re: How do I print grid lines?, Ron Coderre
RE: Help! I can not remember the password to an important Excel workb, Allen P
Counting items in one column based on criteria in another, kmc103
- Re: Counting items in one column based on criteria in another, T. Valko
  - Re: Counting items in one column based on criteria in another, kmc103
    - Re: Counting items in one column based on criteria in another, David Biddulph
    - Re: Counting items in one column based on criteria in another, kmc103
Multiple product selector, Kyle Jamison
Sum a range based on two variables, billy
- Re: Sum a range based on two variables, Don Guillett
- Re: Sum a range based on two variables, T. Valko
Working day(s)/Time between two dats (No Weekend or Holidays), B~O~B
Vlookup when have 2 or more criteria to meet, Angie
- RE: Vlookup when have 2 or more criteria to meet, billy
  - RE: Vlookup when have 2 or more criteria to meet, Angie
    - RE: Vlookup when have 2 or more criteria to meet, billy
- Re: Vlookup when have 2 or more criteria to meet, JE McGimpsey
  - Re: Vlookup when have 2 or more criteria to meet, Angie
Counting cells in a range per multiple criteria . . ., Dano
- Re: Counting cells in a range per multiple criteria . . ., T. Valko
  - Re: Counting cells in a range per multiple criteria . . ., Dave
    - Re: Counting cells in a range per multiple criteria . . ., T. Valko
    - Re: Counting cells in a range per multiple criteria . . ., Dave
    - Re: Counting cells in a range per multiple criteria . . ., T. Valko
    - Re: Counting cells in a range per multiple criteria . . ., Dano
    - Re: Counting cells in a range per multiple criteria . . ., Dano
    - Re: Counting cells in a range per multiple criteria . . ., T. Valko
    - Re: Counting cells in a range per multiple criteria . . ., Dano
    - Re: Counting cells in a range per multiple criteria . . ., T. Valko
Linking Cells, jolowe
- Re: Linking Cells, Reitanos
  - Re: Linking Cells, jolowe
  - Re: Linking Cells, jolowe
- <Possible follow-ups>
- Linking Cells, jolowe
Need correct IF(ISBLANK) formula when referencing whether one of two cells (OR) is blank, returning "no value", insitedge
- Re: Need correct IF(ISBLANK) formula when referencing whether one of two cells (OR) is blank, returning "no value", Reitanos
- RE: Need correct IF(ISBLANK) formula when referencing whether one of t, ND Pard
How to hyperlink 800 documents to spreadsheet describing each docu, Coltten
- Re: How to hyperlink 800 documents to spreadsheet describing each docu, Jim Cone
"IF" Function, Boblink
- RE: "IF" Function, Chris
  - "IF" Function (expanded), Boblink
    - Can a cell with "IF" Function be referred to by another "IF" formu, Boblink
    - Re: Can a cell with "IF" Function be referred to by another "IF" formu, JE McGimpsey
    - Help with "IF" Function, Boblink
    - Re: Help with "IF" Function, Lars-�ke Aspelin
    - =IF(B39>0,IF(B13-B44>0,B13-B44,0),0), Boblink
    - Re: =IF(B39>0,IF(B13-B44>0,B13-B44,0),0), Lars-�ke Aspelin
    - Re: =IF(B39>0,IF(B13-B44>0,B13-B44,0),0), Lars-�ke Aspelin
    - Re: =IF(B39>0,IF(B13-B44>0,B13-B44,0),0), Dana DeLouis
    - Follow-up If and MAX function questions?, Boblink
    - Re: Follow-up If and MAX function questions?, Lars-�ke Aspelin
    - Clarification of the calculations for cells "C and "D", Boblink
    - Re: Clarification of the calculations for cells "C and "D", Lars-�ke Aspelin
    - Re: Clarification of the calculations for cells "C and "D", Boblink
    - Formatting all garbled, Boblink
    - Windows Vista POSTing Update, Boblink
    - One more try (IF Forumals for 4 scenarios), Boblink
    - Re: One more try (IF Forumals for 4 scenarios), Lars-�ke Aspelin
    - the solution is near, Boblink
help with sum if, Trixie
- Re: help with sum if, Sandy Mann
  - Re: help with sum if, Trixie
    - Re: help with sum if, Sandy Mann
    - Re: help with sum if, Sandy Mann
    - Re: help with sum if, Trixie
    - Re: help with sum if, Sandy Mann
Nesting of more than 7 in an IF formula, Rachael F
- Re: Nesting of more than 7 in an IF formula, Niek Otten
- RE: Nesting of more than 7 in an IF formula, Dennis
- RE: Nesting of more than 7 in an IF formula, ND Pard
- Re: Nesting of more than 7 in an IF formula, Pete_UK
- Re: Nesting of more than 7 in an IF formula, Gaurav
- Re: Nesting of more than 7 in an IF formula, Ron Coderre
  - Re: Nesting of more than 7 in an IF formula, Rachael F
    - Re: Nesting of more than 7 in an IF formula, Pete_UK
sum a set of cells based on comparing a different set of cells, BSweeney
- Re: sum a set of cells based on comparing a different set of cells, Pete_UK
- Message not available
  - Re: sum a set of cells based on comparing a different set of cells, BSweeney
last value "greater than zero" in a range, TSW632
- Re: last value "greater than zero" in a range, Rick Rothstein $MVP - VB$
- Re: last value "greater than zero" in a range, Bob Phillips
  - Re: last value "greater than zero" in a range, TSW632
Custom number display format, bEar
- Re: Custom number display format, David Biddulph
- Re: Custom number display format, Ron Rosenfeld
  - Re: Custom number display format, Rick Rothstein $MVP - VB$
    - Re: Custom number display format, Ron Rosenfeld
Notification when file changes, Don B
Countif or Sumproduct, Wilson
- RE: Countif or Sumproduct, ND Pard
- Re: Countif or Sumproduct, Pete_UK
Formula Help pleaseee URGENT!!!!, Yossy
- RE: Formula Help pleaseee URGENT!!!!, ND Pard
  - RE: Formula Help pleaseee URGENT!!!!, Yossy
- Re: Formula Help pleaseee URGENT!!!!, Peo Sjoblom
  - Re: Formula Help pleaseee URGENT!!!!, Yossy
    - Re: Formula Help pleaseee URGENT!!!!, Beege
Help needed with Formula, Millie
- Re: Help needed with Formula, Gaurav
- RE: Help needed with Formula, Mike H
- RE: Help needed with Formula, Teethless mama
Entering several pieces of info by typing just 1 defined name, Clueless
- RE: Entering several pieces of info by typing just 1 defined name, Mike H
Return the row number of Median value of a column, J.Y.Joe
- RE: Return the row number of Median value of a column, Mike H
  - Re: Return the row number of Median value of a column, T. Valko
I NEED HELP PLEASE, Santi
- RE: I NEED HELP PLEASE, Teethless mama
  - RE: I NEED HELP PLEASE, Santi
Count number of row for Particular month, Praveen kumar.M
- Re: Count number of row for Particular month, Gaurav
- Re: Count number of row for Particular month, Ron Coderre
- RE: Count number of row for Particular month, Marcelo
Custom Number Format / Color and Sign, Werner Rohrmoser
- Message not available
  - Re: Custom Number Format / Color and Sign, Werner Rohrmoser
How do I change the contents of a Named List, BRyan
- Re: How do I change the contents of a Named List, Gaurav
Advanced Apology, Wilson
- Re: Advanced Apology, Arvi Laanemets
  - Re: Advanced Apology, Mike H
- RE: Advanced Apology, Mike H
  - RE: Advanced Apology, Wilson
    - RE: Advanced Apology, Wilson
    - Re: Advanced Apology, Arvi Laanemets
    - Re: Advanced Apology, Wilson
    - RE: Advanced Apology, Mike H
    - thanks, Wilson
- Re: Advanced Apology, Ron Coderre
  - Re: Advanced Apology, Wilson
    - Re: Advanced Apology, Ron Coderre
  - Re: Advanced Apology, Bernd P
- Re: Advanced Apology, Dana DeLouis
Reporting Highest Values, BRob
Can I create more than 3 Condidtional Format conditions or can I w, cocoblue
- Re: Can I create more than 3 Condidtional Format conditions or can I w, Ron Rosenfeld
  - Re: Can I create more than 3 Condidtional Format conditions or can I w, Ron Rosenfeld
Compare two tables, Mery
- RE: Compare two tables, Mery
  - Re: Compare two tables, Pete_UK
    - Re: Compare two tables, Mery
    - Re: Compare two tables, Pete_UK
- <Possible follow-ups>
- Compare two tables, Mery
If function, Raja
- RE: If function, Mike H
- RE: If function, Mike H
- Re: If function, Bob Phillips
- RE: If function, Teethless mama
- RE: If function, Raja
I want formula for multiple criteria using ih differnt column, PERANISH
- Re: I want formula for multiple criteria using ih differnt column, Bob Phillips
  - Re: I want formula for multiple criteria using ih differnt column, PERANISH
XIRR Problem, Dkline
- Re: XIRR Problem, Ron Rosenfeld
  - Re: XIRR Problem, Dkline
    - Re: XIRR Problem, joeu2004
    - Re: XIRR Problem, Ron Rosenfeld
- <Possible follow-ups>
- XIRR Problem, Dkline
  - Re: XIRR Problem, Ron Rosenfeld
    - Re: XIRR Problem, Dkline
  - Re: XIRR Problem, joeu2004
  - Re: XIRR Problem, joeu2004
    - Re: XIRR Problem, Dkline
    - Re: XIRR Problem, joeu2004
    - Re: XIRR Problem, Dkline
    - Re: XIRR Problem, Dkline
Is the solution Vlookup?, JPS
- Re: Is the solution Vlookup?, Pete_UK
index & match, krrish_a
- RE: index & match, ryguy7272
Sumif with Multiple Criteria, No Idea
- Re: Sumif with Multiple Criteria, T. Valko
  - Re: Sumif with Multiple Criteria, No Idea
    - Re: Sumif with Multiple Criteria, T. Valko
Return a list of cells based on data in a single cell., Tim G.
- RE: Return a list of cells based on data in a single cell., yshridhar
  - Re: Return a list of cells based on data in a single cell., T. Valko
    - Re: Return a list of cells based on data in a single cell., Tim G.
    - Re: Return a list of cells based on data in a single cell., T. Valko
column headings, mdfr28
- RE: column headings, yshridhar
How do I reorder sheets in excel, Dr Alok Modi MD
- Re: How do I reorder sheets in excel, MartinW
  - Re: How do I reorder sheets in excel, Dr Alok Modi MD
    - Re: How do I reorder sheets in excel, Spiky
    - Re: How do I reorder sheets in excel, MartinW
    - Re: How do I reorder sheets in excel, Dr Alok Modi MD
Calculation formula, Glenn
How do i disable/enable "Worksheet Move or copy" option?, Saon
- Re: How do i disable/enable "Worksheet Move or copy" option?, Spiky
simple Lookups in external xls files.., Sharon
Linking Entire Worksheet, Sarah0824
Orderign/combining data from two columns in one, Tim
- RE: Orderign/combining data from two columns in one, Tim
How to Functionally move one cell to another, KyleE
- Re: How to Functionally move one cell to another, Spiky
Anyone have spreadsheets to keep information wrt: livestock?, Dudley and the dogs
- RE: Anyone have spreadsheets to keep information wrt: livestock?, FSt1
  - RE: Anyone have spreadsheets to keep information wrt: livestock?, FSt1
Cell to read exactly what I put in cell, TJ
- RE: Cell to read exactly what I put in cell, BoniM
Nested If statement to control format of number-type cells, TB
- Re: Nested If statement to control format of number-type cells, Ron Rosenfeld
  - Re: Nested If statement to control format of number-type cells, TB
    - Re: Nested If statement to control format of number-type cells, Ron Rosenfeld
Copy and paste absolute reference, lea
- Re: Copy and paste absolute reference, Gord Dibben
  - Re: Copy and paste absolute reference, lea
    - Re: Copy and paste absolute reference, Gord Dibben
Formula Bar F9 Result differs from cell result???, Aaron
- Re: Formula Bar F9 Result differs from cell result???, T. Valko
  - Re: Formula Bar F9 Result differs from cell result???, Aaron
    - Re: Formula Bar F9 Result differs from cell result???, T. Valko
comparing two lists of last names, rbentzlin
- Re: comparing two lists of last names, Reitanos
  - Re: comparing two lists of last names, rbentzlin
- Re: comparing two lists of last names, Max
  - Re: comparing two lists of last names, rbentzlin
    - Re: comparing two lists of last names, Max
    - Re: comparing two lists of last names, Max
Formula for Excel Worksheet, Lynda
- Re: Formula for Excel Worksheet, JE McGimpsey
- Re: Formula for Excel Worksheet, Gord Dibben
  - Re: Formula for Excel Worksheet, Gord Dibben
Vlookup question, AG
- Re: Vlookup question, T. Valko
  - Re: Vlookup question, Pete_UK
- <Possible follow-ups>
- VLOOKUP Question, Susan
  - Re: VLOOKUP Question, Jim Cone
    - Re: VLOOKUP Question, Susan
  - RE: VLOOKUP Question, BoniM
    - RE: VLOOKUP Question, Susan
if formula returns a weekend - move it forward to next weekday, Z-Man-Cek
- Re: if formula returns a weekend - move it forward to next weekday, Niek Otten
- Re: if formula returns a weekend - move it forward to next weekday, T. Valko
Importing/linking worksheets into different workbooks., LLK
Re: & in formula changing date format to text ?, iashorty
move or copy sheets doesn't copy format, ColinX
- Re: move or copy sheets doesn't copy format, Gord Dibben
Daemons Tools, Morfeo
Don Where do I put the VBA Code?, ABA
- RE: Don Where do I put the VBA Code?, Mike H
  - RE: Don Where do I put the VBA Code?, ABA
    - RE: Don Where do I put the VBA Code?, Mike H
- Re: Don Where do I put the VBA Code?, Don Guillett
Side to Side feature, Dave
- Re: Side to Side feature, Gord Dibben
  - Re: Side to Side feature, Dave
Count # of times the same number shows up in Excel spreadsheet, Kasimir867
- Re: Count # of times the same number shows up in Excel spreadsheet, Dave Peterson
Combining SUMIFS and filter SUBTOTALS, elsmed
Count Colors in 2003, Whois Clinton
- RE: Count Colors in 2003, Mike H
  - RE: Count Colors in 2003, Whois Clinton
- Re: Count Colors in 2003, Gord Dibben
Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter, ABA
- Re: Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter, Don Guillett
RE: Functions & Formulas, BellaDonna
- Re: Functions & Formulas, Gord Dibben
sum by category, by month, KarlaJ
- RE: sum by category, by month, KarlaJ
Comparisoning Two Barcode Lists, Perla
COUNTIF using formatting, Suz_c_mitchell
- Re: COUNTIF using formatting, T. Valko
  - Re: COUNTIF using formatting, Suz_c_mitchell
- Re: COUNTIF using formatting, Dave Peterson
  - Re: COUNTIF using formatting, Suz_c_mitchell
looking for changes in worksheets or books, mlong
How do I view multiple tabs on the worksheet, Viewing worksheet tabs
- RE: How do I view multiple tabs on the worksheet, Teethless mama
cell size, robzrob
- RE: cell size, Teethless mama
  - Re: cell size, robzrob
    - Re: cell size, Gord Dibben
    - Re: cell size, robzrob
MATCH and #N/A, Bill
- Re: MATCH and #N/A, Dave Peterson
- Re: MATCH and #N/A, Peo Sjoblom
- Re: MATCH and #N/A, PCLIVE
- Re: MATCH and #N/A, David Biddulph
countif function excel 2007, Dave H
- Re: countif function excel 2007, T. Valko
How do I find the month, Chris
- Re: How do I find the month, Rick Rothstein $MVP - VB$
  - Re: How do I find the month, Chris
    - Re: How do I find the month, Rick Rothstein $MVP - VB$
- Re: How do I find the month, PCLIVE
- RE: How do I find the month, Teethless mama
COUNTIF or COUNTIF, A . for . Andy
- Re: COUNTIF or COUNTIF, Pete_UK
- Re: COUNTIF or COUNTIF, Bob Phillips
  - Re: COUNTIF or COUNTIF, A . for . Andy
    - Re: COUNTIF or COUNTIF, Pete_UK
Worksheet Reference, jtscpa
- RE: Worksheet Reference, Teethless mama
- RE: Worksheet Reference, Soundar
Vlookup - using a cell to reference a named array, Ronin
- RE: Vlookup - using a cell to reference a named array, Teethless mama
  - RE: Vlookup - using a cell to reference a named array, Ronin
    - RE: Vlookup - using a cell to reference a named array, Teethless mama
Conditional formatting across a row, anthony127112
- RE: Conditional formatting across a row, Teethless mama
  - Re: Conditional formatting across a row, David Biddulph
- Re: Conditional formatting across a row, David Biddulph
  - Re: Conditional formatting across a row, David Biddulph
Display a part of a cell in green (or red)..., Anne P
- Message not available
  - Re: Display a part of a cell in green (or red)..., Anne P
Excel filter won't capture everything in the column - why?, The_Warden
- Re: Excel filter won't capture everything in the column - why?, Dave Peterson
  - Re: Excel filter won't capture everything in the column - why?, The_Warden
    - Re: Excel filter won't capture everything in the column - why?, Gord Dibben
IF statements, dannyboy8
- Re: IF statements, David Biddulph
- <Possible follow-ups>
- IF statements, dannyboy8
  - RE: IF statements, BoniM
Lookup formula, Joe Gieder
Conditional Formatting: Logical AND fails to work with INDIRECT(.., Hamish
- Re: Conditional Formatting: Logical AND fails to work with INDIRECT(.., Pete_UK
  - Re: Conditional Formatting: Logical AND fails to work with INDIREC, Hamish
    - Re: Conditional Formatting: Logical AND fails to work with INDIREC, Pete_UK
    - Re: Conditional Formatting: Logical AND fails to work with INDIREC, Hamish
    - Re: Conditional Formatting: Logical AND fails to work with INDIREC, Pete_UK
remove blank cells - no sorting, Luke
- RE: remove blank cells - no sorting, Teethless mama
- Re: remove blank cells - no sorting, Ron Coderre
  - Re: remove blank cells - no sorting, Luke
    - Re: remove blank cells - no sorting, Ron Coderre
Lookup Function for Non-Alphabetical, TKS_Mark
- RE: Lookup Function for Non-Alphabetical, Teethless mama
  - RE: Lookup Function for Non-Alphabetical, TKS_Mark
    - RE: Lookup Function for Non-Alphabetical, Teethless mama
Formula for average of cells that have blanks, Security Dave
SUM IF QUESTION PLEASE HELP, llong3316
Searching for an additional item via an IF statement, Sarah (OGI)
- Re: Searching for an additional item via an IF statement, Bob Phillips
- RE: Searching for an additional item via an IF statement, Teethless mama
  - RE: Searching for an additional item via an IF statement, Sarah (OGI)
    - RE: Searching for an additional item via an IF statement, Teethless mama
- Re: Searching for an additional item via an IF statement, T. Valko
Calling an application from excel, SatyanarayanaS
Another nested formual help request, ArcticWolf
- Re: Another nested formual help request, Pete_UK
  - Re: Another nested formual help request, ArcticWolf
    - Re: Another nested formual help request, Pete_UK
    - Re: Another nested formual help request, ArcticWolf
    - Re: Another nested formual help request, Pete_UK
- Re: Another nested formual help request, joeu2004
re:code to close an excel sheet without saving it .(via msgbox), Satyam Reddy
- re:code to close an excel sheet without saving it .(via msgbox), Bob Umlas, Excel MVP
Countif - extended functionality, Mac
- Re: Countif - extended functionality, Pete_UK
- RE: Countif - extended functionality, minli
- Re: Countif - extended functionality, shaqil
- Re: Countif - extended functionality, Ron Coderre
- RE: Countif - extended functionality, Teethless mama
  - RE: Countif - extended functionality, alstubna
#value!, AFA
- RE: #value!, minli
  - RE: #value!, AFA
- RE: #value!, Teethless mama
  - RE: #value!, AFA
- <Possible follow-ups>
- #VALUE!, nso
  - Re: #VALUE!, Max
    - Re: #VALUE!, nso
    - Re: #VALUE!, Max
  - Re: #VALUE!, T. Valko
I have a problem using excel, sunny
- Re: I have a problem using excel, Pete_UK
  - Re: I have a problem using excel, sunny
    - Re: I have a problem using excel, Gord Dibben
    - Re: I have a problem using excel, sunny
    - Re: I have a problem using excel, Gord Dibben
    - Re: I have a problem using excel, sunny
    - Re: I have a problem using excel, Gord Dibben
RE: Linkage File, AFA
- <Possible follow-ups>
- Re: Linkage File, AFA
Data Validation vs VLOOKUP - Linking to data in a seperate file, Sharon
Sluggish Performance From Excel 2007?, cqdigital
- Re: Sluggish Performance From Excel 2007?, Charles Williams
  - Re: Sluggish Performance From Excel 2007?, cqdigital
How to remove duplicated items from a list?, Eric
- Re: How to remove duplicated items from a list?, TIJIPMATHEW
  - Re: How to remove duplicated items from a list?, Eric
Faster Way To Insert Defined Names??, cqdigital
- Re: Faster Way To Insert Defined Names??, Rick Rothstein $MVP - VB$
  - Re: Faster Way To Insert Defined Names??, cqdigital
  - Re: Faster Way To Insert Defined Names??, cqdigital
    - Re: Faster Way To Insert Defined Names??, Rick Rothstein $MVP - VB$
    - Re: Faster Way To Insert Defined Names??, cqdigital
    - Re: Faster Way To Insert Defined Names??, Bob Phillips
how to link different excel file, av
- RE: how to link different excel file, Gary''s Student
Macro creation, Xavier
- Re: Macro creation, Gord Dibben
How do I create keystroke macros in excel 2003, nitiman
- Re: How do I create keystroke macros in excel 2003, Gord Dibben
SUMPRODUCT Help!, Shaun
- RE: SUMPRODUCT Help!, Teethless mama
  - RE: SUMPRODUCT Help!, Shaun
    - RE: SUMPRODUCT Help!, Teethless mama
using the countif function, harrimanxix
- RE: using the countif function, akphidelt
- Re: using the countif function, RagDyer
End if without Block If, Carrie_Loos via OfficeKB.com
- RE: End if without Block If, Dave
  - RE: End if without Block If, Carrie_Loos via OfficeKB.com
    - Re: End if without Block If, Dave Peterson
    - Re: End if without Block If, Carrie_Loos via OfficeKB.com
    - Re: End if without Block If, Dave Peterson
    - RE: End if without Block If, Dave
- Re: End if without Block If, Gord Dibben
Excel File exported from Quickbooks does'nt register numbers as nu, skoo
- Re: Excel File exported from Quickbooks does'nt register numbers as nu, Gord Dibben
ABC Inventory Classification, Richard
- RE: ABC Inventory Classification, akphidelt
Mutiple Spread Sheets, ABA
SumProduct Function, mp80237
- RE: SumProduct Function, bpeltzer
- Re: SumProduct Function, T. Valko
  - Re: SumProduct Function, T. Valko
Combining Formula and Data Validation List in a Single Cell, Benny
Searching for specific text - how to, spacia
how to use cubic spline, agron
- Re: how to use cubic spline, Pete_UK
- Re: how to use cubic spline, Gord Dibben
Referencing Workbook Name in Formula, Russ
- Re: Referencing Workbook Name in Formula, MyVeryOwnSelf
- Re: Referencing Workbook Name in Formula, Rick Rothstein $MVP - VB$
- Re: Referencing Workbook Name in Formula, Pete_UK
  - Re: Referencing Workbook Name in Formula, Russ
Compile error when accessing a spreadsheet, Nat
- RE: Compile error when accessing a spreadsheet, Nat
Excel 2007 Error message when trying to record Macro, Beth
How do I hide a column from others in a shared workbook?, BradleyK2
how to solve multivariable equations, multivariable equations
- Re: how to solve multivariable equations, Alan Beban
How to order several data from different rows in one row?, Tim
Lookup problem, murrmeik
- RE: Lookup problem, John Bundy
- RE: Lookup problem, BoniM
Wild card match and then count, LITTLE PETE
- Re: Wild card match and then count, Roger Govier
- Re: Wild card match and then count, Rick Rothstein $MVP - VB$
COPYING FORMULAE, Frankie
- Re: COPYING FORMULAE, Roger Govier
Referenced Cell Values, Not Excelerated
- Message not available
  - Re: Referenced Cell Values, Not Excelerated
Help with HLOOKUP/INDEX/MATCH, WembleyBear
- RE: Help with HLOOKUP/INDEX/MATCH, akphidelt
  - Re: Help with HLOOKUP/INDEX/MATCH, wembleybear
- Re: Help with HLOOKUP/INDEX/MATCH, T. Valko
  - Re: Help with HLOOKUP/INDEX/MATCH, wembleybear
    - Re: Help with HLOOKUP/INDEX/MATCH, T. Valko
    - Re: Help with HLOOKUP/INDEX/MATCH, Roger Govier
Multiple IF statement, Kristen PS
- Re: Multiple IF statement, Rick Rothstein $MVP - VB$
- RE: Multiple IF statement, Teethless mama
- Re: Multiple IF statement, Max
  - Re: Multiple IF statement, David Biddulph
    - Re: Multiple IF statement, Max
linking error, Paul
- Re: linking error, RagDyeR
  - Re: linking error, Paul
    - Re: linking error, RagDyer
vlookup,IF function together, Ranjit kurian
- Re: vlookup,IF function together, Peo Sjoblom
- Re: vlookup,IF function together, Pete_UK
- RE: vlookup,IF function together, Teethless mama
- Re: vlookup,IF function together, JE McGimpsey
Ecxel in email, Racoca
- Re: Ecxel in email, Ron de Bruin
  - Re: Ecxel in email, Racoca
- Re: Ecxel in email, Dave Peterson
  - Re: Ecxel in email, Racoca
worksheet formulas, Trace
- Re: worksheet formulas, Peo Sjoblom
- Re: worksheet formulas, Pete_UK
Multiple Field Selection for Pivot table Values Section, pzeitlin
Can Anyone Help Please!, Santi
- RE: Can Anyone Help Please!, RLang
- RE: Can Anyone Help Please!, Teethless mama
Macros and If, DeniseCost
- Re: Macros and If, Ron de Bruin
  - Re: Macros and If, DeniseCost
    - Re: Macros and If, Ron de Bruin
    - Re: Macros and If, Ron de Bruin
Calculate Ending time using Start Time and Elapsed Time, Chief 711
- RE: Calculate Ending time using Start Time and Elapsed Time, KIM W
  - RE: Calculate Ending time using Start Time and Elapsed Time, Chief 711
  - RE: Calculate Ending time using Start Time and Elapsed Time, Chief 711
  - Re: Calculate Ending time using Start Time and Elapsed Time, David Biddulph
- Re: Calculate Ending time using Start Time and Elapsed Time, Pete_UK
Grouping in pivot table, Sanjeev Raghavan
- RE: Grouping in pivot table, Martin Fishlock
  - RE: Grouping in pivot table, Sanjeev Raghavan
Linking Rows?, jambun
- RE: Linking Rows?, Martin Fishlock
  - Re: Linking Rows?, jambun
    - Re: Linking Rows?, Martin Fishlock
how to create a formula with expiry condition, mountain
- RE: how to create a formula with expiry condition, Martin Fishlock
  - RE: how to create a formula with expiry condition, mountain
comparing two sheet of data -- cost price increases, SD
- RE: comparing two sheet of data -- cost price increases, Martin Fishlock
  - RE: comparing two sheet of data -- cost price increases, Martin Fishlock
How do I activate Recently used files? Menu route wont do it!, Mahboob Alam
- Re: How do I activate Recently used files? Menu route wont do it!, Gord Dibben
Data Validations, Christopher Naveen
- Re: Data Validations, JE McGimpsey
How to show/print guidelines over color rows & columns?, Amiris221
- RE: How to show/print guidelines over color rows & columns?, Martin Fishlock
- RE: How to show/print guidelines over color rows & columns?, Amiris221
  - Re: How to show/print guidelines over color rows & columns?, Sandy Mann
  - Re: How to show/print guidelines over color rows & columns?, David Biddulph
  - RE: How to show/print guidelines over color rows & columns?, Martin Fishlock
delete color cells, climate
- Re: delete color cells, Bob Phillips
  - Re: delete color cells, climate
    - Re: delete color cells, Bob Phillips
    - Re: delete color cells, climate
Automatic Numbering, Jodi
- Re: Automatic Numbering, Roger Govier
Hyperlinks have appeared in all my forms, how do I remove them?, legatee
Bar Graph, Jill
- Re:Bar Graph, Dave Curtis
Excel if Functions, Amy
- Re: Excel if Functions, Bob Phillips
SUMPRODUCT help, BossneedsreportASAP
- Re: SUMPRODUCT help, Peo Sjoblom
- Re: SUMPRODUCT help, Bob Phillips
  - Re: SUMPRODUCT help, BossneedsreportASAP
How to find formula for...., Jill
- Re: How to find formula for...., Fred Smith
Help on "IF" function, Jill
- RE: Help on "IF" function, Gary''s Student
- Re: Help on "IF" function, Max
excel sorting functions, Crash
- Re: excel sorting functions, RagDyer
- Re:excel sorting functions, Dave Curtis
Protection - multiple ranges at different times, PurpleMilk
LOOKUP Help Using non-First Column, RoadKill
- Re: LOOKUP Help Using non-First Column, Dave Peterson
  - Re: LOOKUP Help Using non-First Column, RoadKill
    - Re: LOOKUP Help Using non-First Column, Dave Peterson
how do i change something from CSV to XML?, research help
- RE: how do i change something from CSV to XML?, Martin Fishlock
- Re: how do i change something from CSV to XML?, David Biddulph
Selecting "odd" and "even" numbers, Rocketeer
- RE: Selecting "odd" and "even" numbers, akphidelt
  - RE: Selecting "odd" and "even" numbers, Rocketeer
- Re: Selecting "odd" and "even" numbers, T. Valko
- Re: Selecting "odd" and "even" numbers, Sandy Mann
SumIf and ranges, Katie
- Re: SumIf and ranges, Max
- RE: SumIf and ranges, Teethless mama
Counting, punkster
- Re: Counting, Max
  - Re: Counting, punkster
    - Re: Counting, Max
- Re: Counting, Reitanos
Conditional statements, Sue
- RE: Conditional statements, akphidelt
lookup functions, KD
- Re: lookup functions, Sandy Mann
- Re: lookup functions, T. Valko
- Re: lookup functions, Ron Rosenfeld
  - Re: lookup functions, KD
    - Re: lookup functions, Ron Rosenfeld
- RE: lookup functions, KD
  - Re: lookup functions, Sandy Mann
Need a formula to update data in 2 columns, MMcGee
- Re: Need a formula to update data in 2 columns, Pete_UK
Find most recent value in data range that includes SUM formulas, RPage@SF
- RE: Find most recent value in data range that includes SUM formulas, Gary''s Student
  - RE: Find most recent value in data range that includes SUM formula, RPage@SF
    - Re: Find most recent value in data range that includes SUM formula, T. Valko
- Re: Find most recent value in data range that includes SUM formulas, T. Valko
  - Re: Find most recent value in data range that includes SUM formula, RPage@SF
    - Re: Find most recent value in data range that includes SUM formula, T. Valko
Goodman-Kruskal Gamma, Chris Wahlheim
- Re: Goodman-Kruskal Gamma, Bob Phillips
I need to know how to leave the cell blank, Peter
- Re: I need to know how to leave the cell blank, Dave Peterson
  - Re: I need to know how to leave the cell blank, Peter
AND function, ytayta555
- RE: AND function, Tiago Nogueira
  - Re: AND function, ytayta555
    - Re: AND function, Bob Phillips
    - Re: AND function, ytayta555
    - Re: AND function, ytayta555
    - Re: AND function, ytayta555
Conditional Summing, RichieK
- Re: Conditional Summing, Sandy Mann
  - Re: Conditional Summing, RichieK
    - Re: Conditional Summing, Sandy Mann
- <Possible follow-ups>
- Conditional Summing, Brian
  - RE: Conditional Summing, BoniM
    - RE: Conditional Summing, Brian
    - RE: Conditional Summing, BoniM
    - RE: Conditional Summing, BoniM
How to apply a function to an entire column, Barb @ Work
- Re: How to apply a function to an entire column, JE McGimpsey
Covert Number to date, Newbee
- Re: Covert Number to date, Bob Phillips
- Re: Covert Number to date, Peo Sjoblom
- Re: Covert Number to date, T. Valko
- Re: Covert Number to date, Rick Rothstein $MVP - VB$
  - Re: Covert Number to date, Newbee
Can't get array formula to work in MATCH function, Chas Grad
- Re: Can't get array formula to work in MATCH function, T. Valko
  - Re: Can't get array formula to work in MATCH function, Chas Grad
    - Re: Can't get array formula to work in MATCH function, T. Valko
- RE: Can't get array formula to work in MATCH function, Chas Grad
  - Re: Can't get array formula to work in MATCH function, T. Valko
NEED EQUATION PLEASE, Carolan
- RE: NEED EQUATION PLEASE, Gary''s Student
  - RE: NEED EQUATION PLEASE, Carolan
    - Message not available
    - Message not available
    - Re: NEED EQUATION PLEASE, Ron Rosenfeld
    - Re: NEED EQUATION PLEASE, Carolan
    - Re: NEED EQUATION PLEASE, Gord Dibben
    - Message not available
    - Message not available
    - Re: NEED EQUATION PLEASE, Max
MIN DATE from Array, steven.britton@xxxxxxxxxxxxxxxxxxx
- RE: MIN DATE from Array, Teethless mama
  - Re: MIN DATE from Array, steven.britton@xxxxxxxxxxxxxxxxxxx
Returning Yesterday, bollard
- RE: Returning Yesterday, Teethless mama
  - RE: Returning Yesterday, bollard
- Re: Returning Yesterday, Reitanos
- Re: Returning Yesterday, Max
- Re: Returning Yesterday, Sandy Mann
adding a fixed decimal within another formula, h.
- RE: adding a fixed decimal within another formula, Teethless mama
- Re: adding a fixed decimal within another formula, Max
- Re: adding a fixed decimal within another formula, Reitanos
- Re: adding a fixed decimal within another formula, Rick Rothstein $MVP - VB$
Mulitiple functions in one cell, cgroninger
- Re: Mulitiple functions in one cell, Bob Phillips
calculating differentials based on dates, MBOF10
I'm Trying to Construct a Smart Worksheet, Santi
- Re: I'm Trying to Construct a Smart Worksheet, Pete_UK
  - Re: I'm Trying to Construct a Smart Worksheet, Santi
    - Re: I'm Trying to Construct a Smart Worksheet, Ken Johnson
If Satement formula, floreman
- Re: If Satement formula, Bob Phillips
  - Re: If Satement formula, floreman
- Re: If Satement formula, Per Jessen
  - Re: If Satement formula, floreman
    - Re: If Satement formula, Per Jessen
Converting mm/dd/yyyy to yyyy/mm/dd, joker_frowns
- Re: Converting mm/dd/yyyy to yyyy/mm/dd, Ron Rosenfeld
  - Re: Converting mm/dd/yyyy to yyyy/mm/dd, joker_frowns
    - Re: Converting mm/dd/yyyy to yyyy/mm/dd, David Biddulph
    - Re: Converting mm/dd/yyyy to yyyy/mm/dd, Rick Rothstein $MVP - VB$
    - Re: Converting mm/dd/yyyy to yyyy/mm/dd, Ron Rosenfeld
- Re: Converting mm/dd/yyyy to yyyy/mm/dd, David Biddulph
Sum of unique values within a range with blank cells, loook
- Re: Sum of unique values within a range with blank cells, Bob Phillips
- RE: Sum of unique values within a range with blank cells, Gary''s Student
- RE: Sum of unique values within a range with blank cells, Teethless mama
Reporting on Top and Bottom Sales Figures, BRob
- Re: Reporting on Top and Bottom Sales Figures, Pete_UK
  - Re: Reporting on Top and Bottom Sales Figures, BRob
Count number of values until exceeding a figure, tunupo
- Re: Count number of values until exceeding a figure, Ed Ferrero
  - Re: Count number of values until exceeding a figure, tunupo
how to print the rows more than 62000 rows, muralidhar gunde
- Re: how to print the rows more than 62000 rows, Jim Cone
Calculating a sum from a given number of rows, tunupo
- Re: Calculating a sum from a given number of rows, JE McGimpsey
- Re: Calculating a sum from a given number of rows, T. Valko
  - Re: Calculating a sum from a given number of rows, tunupo
formula for 2% annual sales increases, shepzuck
- Re: formula for 2% annual sales increases, JE McGimpsey
  - Re: formula for 2% annual sales increases, shepzuck
    - Re: formula for 2% annual sales increases, Fred Smith
    - Re: formula for 2% annual sales increases, shepzuck
Re: Spreadsheet size, NoodNutt
- Message not available
  - Re: Spreadsheet size, NoodNutt
    - Message not available
    - Re: Spreadsheet size, Beege
    - Message not available
    - Re: Spreadsheet size, Gord Dibben
    - Message not available
    - Re: Spreadsheet size, NoodNutt
    - Message not available
    - Re: Spreadsheet size, NoodNutt
    - Message not available
    - Re: Spreadsheet size, NoodNutt
    - Message not available
    - Re: Spreadsheet size, Spiky
    - Re: Spreadsheet size, Spiky
HI DOES THIS EQUATION LOOK CORRECT PLEASE, Dan
- Re: HI DOES THIS EQUATION LOOK CORRECT PLEASE, T. Valko
- Re: HI DOES THIS EQUATION LOOK CORRECT PLEASE, Rick Rothstein $MVP - VB$
- Re: HI DOES THIS EQUATION LOOK CORRECT PLEASE, David Biddulph
  - Re: HI DOES THIS EQUATION LOOK CORRECT PLEASE, David Biddulph
    - Re: HI DOES THIS EQUATION LOOK CORRECT PLEASE, Dan
How do I format cells to show date in Australian not US format?, Kevin B
- Re: How do I format cells to show date in Australian not US format?, Fred Smith
Can i Enlarge a cell by Double Clicking?, Function for this?
Adding numbers to text!, Rocketeer
- Re: Adding numbers to text!, Bob Phillips
- Re: Adding numbers to text!, Max
  - Re: Adding numbers to text!, Rocketeer
    - Re: Adding numbers to text!, Max
Help on how to use the PARETOINV function!, Rocketeer
- Re: Help on how to use the PARETOINV function!, David Biddulph
  - Re: Help on how to use the PARETOINV function!, Rocketeer
    - Re: Help on how to use the PARETOINV function!, Rocketeer
Link from a drop down list, Jose L Guillen
Conditional formatting puzzler, jaykoski99x
- RE: Conditional formatting puzzler, JLatham
  - RE: Conditional formatting puzzler, jaykoski99x
how i convert "100" to "hundred"( number to text) in excel-2007, mohanraj
- Re: how i convert "100" to "hundred"( number to text) in excel-2007, Niek Otten
Auto insert e-mail addresses, NoodNutt
move cursor on limited cells., Invisible
- RE: move cursor on limited cells., Gary''s Student
unhide row does not unhide the hidden rows, nikita
- RE: unhide row does not unhide the hidden rows, Mike H
  - RE: unhide row does not unhide the hidden rows, nikita
    - RE: unhide row does not unhide the hidden rows, Jim Evers
    - RE: unhide row does not unhide the hidden rows, nikita
Just type the word, pai
- Re: Just type the word, Gord Dibben
Merge multiple row data in one cell with delimieters, Terryrubby
- Re: Merge multiple row data in one cell with delimieters, Don Guillett
  - Re: Merge multiple row data in one cell with delimieters, Terryrubby
    - Re: Merge multiple row data in one cell with delimieters, Don Guillett
    - Re: Merge multiple row data in one cell with delimieters, Terryrubby
    - Re: Merge multiple row data in one cell with delimieters, Don Guillett
    - Re: Merge multiple row data in one cell with delimieters, Terryrubby
    - Re: Merge multiple row data in one cell with delimieters, Don Guillett
    - Re: Merge multiple row data in one cell with delimieters, Terryrubby
    - Re: Merge multiple row data in one cell with delimieters, Don Guillett
Calender function - time sheet - excel 2003/7, Peter Balcombe
- RE: Calender function - time sheet - excel 2003/7, FSt1
- Re: Calender function - time sheet - excel 2003/7, Peter Balcombe
  - Re: Calender function - time sheet - excel 2003/7, Rick Rothstein $MVP - VB$
MAX value matching multiple criteria, mwd
- RE: MAX value matching multiple criteria, Gary''s Student
- RE: MAX value matching multiple criteria, BoniM
- RE: MAX value matching multiple criteria, BoniM
- RE: MAX value matching multiple criteria, Teethless mama
- Re: MAX value matching multiple criteria, Ragdyer
  - Re: MAX value matching multiple criteria, T. Valko
    - Re: MAX value matching multiple criteria, Ragdyer
  - Re: MAX value matching multiple criteria, BoniM
    - Re: MAX value matching multiple criteria, T. Valko
    - Re: MAX value matching multiple criteria, BoniM
pay slips, michael
- Re: pay slips, Reitanos
- Re: pay slips, Reitanos
- Re: pay slips, Don Guillett
Find Smallest entry but excluding zero, jambun
- RE: Find Smallest entry but excluding zero, Mike H
  - Re: Find Smallest entry but excluding zero, Sandy Mann
    - Re: Find Smallest entry but excluding zero, Mike H
    - Re: Find Smallest entry but excluding zero, jambun
Re: LookUp to Display Last Value Populated a in Range, sony654
- <Possible follow-ups>
- Re: LookUp to Display Last Value Populated a in Range, sony654
Sorting and filtering HELP!!!!!, Yossy
- RE: Sorting and filtering HELP!!!!!, Billy Liddel
  - RE: Sorting and filtering HELP!!!!!, Yossy
formulas, Modine
- RE: formulas, Martin Fishlock
  - RE: formulas, Modine
    - Re: formulas, Gord Dibben
Move text, bgkgmg
- Re: Move text, Pete_UK
IF Function formula, Jennifer
- RE: IF Function formula, Billy Liddel
  - RE: IF Function formula, Jennifer
  - Re: IF Function formula, Bob Phillips
How do I ingnore non-numeric cells in Analysis toolpak?, toloughlin
- Re: How do I ingnore non-numeric cells in Analysis toolpak?, Jim Cone
  - Re: How do I ingnore non-numeric cells in Analysis toolpak?, toloughlin
Excel - Formulae across several sheets, Realoldchipguy
- RE: Excel - Formulae across several sheets, Billy Liddel
  - RE: Excel - Formulae across several sheets, Realoldchipguy
Formula Funtions, Garyp1961
- Re: Formula Funtions, David Biddulph
  - Re: Formula Funtions, Garyp1961
- RE: Formula Funtions, Mike H
  - RE: Formula Funtions, Garyp1961
- Re: Formula Funtions, Rick Rothstein $MVP - VB$
  - Re: Formula Funtions, David Biddulph
    - Re: Formula Funtions, Rick Rothstein $MVP - VB$
    - Re: Formula Funtions, Rick Rothstein $MVP - VB$
    - Re: Formula Funtions, Garyp1961
Cash Flow Solution: Eagle Capital Corp, gaojihuiyuan
Muti-page workbook highlight specific dates that occur throughout, hamilton_heff
- Re: Muti-page workbook highlight specific dates that occur throughout, Rick Rothstein $MVP - VB$
multiple if statements, Kwray
- Re: multiple if statements, David Biddulph
  - Re: multiple if statements, Kwray
- RE: multiple if statements, Mike H
  - RE: multiple if statements, Kwray
- RE: multiple if statements, Kwray
- <Possible follow-ups>
- Multiple If Statements, Tigerwould
  - Re: Multiple If Statements, Bernard Liengme
    - Re: Multiple If Statements, Tigerwould
    - Re: Multiple If Statements, Pete_UK
    - Re: Multiple If Statements, Bernard Liengme
  - Re: Multiple If Statements, Arvi Laanemets
    - Re: Multiple If Statements, Tigerwould
custom views troubleshoot, pb
- Re: custom views troubleshoot, Gord Dibben
Function to calculate total hours worked in one week., cahabbinga
- Re: Function to calculate total hours worked in one week., David Biddulph
  - Re: Function to calculate total hours worked in one week., cahabbinga
    - Re: Function to calculate total hours worked in one week., Dave Peterson
    - Re: Function to calculate total hours worked in one week., cahabbinga
- RE: Function to calculate total hours worked in one week., cahabbinga
  - Re: Function to calculate total hours worked in one week., David Biddulph
when I type 1 it is displayed as 0.01, Amarjeet
- RE: when I type 1 it is displayed as 0.01, Gary''s Student
- Re: when I type 1 it is displayed as 0.01, David Biddulph
Tabbing to select fields, Confused
- Re: Tabbing to select fields, Gord Dibben
  - Re: Tabbing to select fields, Confused
scroll lock, moiz
- Re: scroll lock, Sandy
  - Re: scroll lock, moiz
    - Re: scroll lock, Sandy
    - Re: scroll lock, moiz
    - Re: scroll lock, Sandy
    - Re: scroll lock, moiz
    - Re: scroll lock, Sandy
    - Re: scroll lock, moiz
    - Re: scroll lock, Gord Dibben
How do i make one cell get just the row amount from another cell?, Wuggles
- RE: How do i make one cell get just the row amount from another cell?, Mike H
- Re: How do i make one cell get just the row amount from another cell?, Rick Rothstein $MVP - VB$
- Re: How do i make one cell get just the row amount from another cell?, Pete_UK
formatting in different countries, Libby
- Re: formatting in different countries, JP
  - Re: formatting in different countries, Libby
    - Re: formatting in different countries, Bob Phillips
    - Re: formatting in different countries, Rick Rothstein $MVP - VB$
    - Re: formatting in different countries, Rick Rothstein $MVP - VB$
Need formula, Mrtvac
- RE: Need formula, Mike H
- Re: Need formula, Gord Dibben
duplicate an array and filter the list based on a grouping, jedale@xxxxxxxxx
- Re: duplicate an array and filter the list based on a grouping, jedale@xxxxxxxxx
  - Re: duplicate an array and filter the list based on a grouping, jedale@xxxxxxxxx
    - Re: duplicate an array and filter the list based on a grouping, jedale@xxxxxxxxx
    - Re: duplicate an array and filter the list based on a grouping, jedale@xxxxxxxxx
checking for Match, Craig
- Re: checking for Match, Jim Cone
  - Re: checking for Match, Craig
vlookup in the row below the target row, AG
- Re: vlookup in the row below the target row, Pete_UK
  - Re: vlookup in the row below the target row, AG
Como criar uma formula que ao atingir uma data esta muda de cor, Crocodilo
Re: How to remove duplicated data repeated in a column and keep ju, pea
VLOOKUP using 2 Cells, RoadKill
- RE: VLOOKUP using 2 Cells, Mike H
- Re: VLOOKUP using 2 Cells, JE McGimpsey
- Re: VLOOKUP using 2 Cells, Max
- Re: VLOOKUP using 2 Cells, Max
day increasing by 1 when i drag and drop, dencara
- RE: day increasing by 1 when i drag and drop, Mike H
- Re: day increasing by 1 when i drag and drop, JE McGimpsey
- Re: day increasing by 1 when i drag and drop, Peo Sjoblom
- Re: day increasing by 1 when i drag and drop, Gord Dibben
Format Name, Dax Arroway
- RE: Format Name, Mike H
  - RE: Format Name, Dax Arroway
    - RE: Format Name, Mike H
- Re: Format Name, JE McGimpsey
  - Re: Format Name, Dax Arroway
- Re: Format Name, Rick Rothstein $MVP - VB$
creating sub worksheets, Manny M
- Re: creating sub worksheets, Dave Peterson
3 variable lookup, rooter
- Re: 3 variable lookup, T. Valko
  - Re: 3 variable lookup, rooter
  - Re: 3 variable lookup, rooter
    - Re: 3 variable lookup, T. Valko
    - Re: 3 variable lookup, rooter
    - Re: 3 variable lookup, T. Valko
Danish Question HÆLDNING, Stefan DK
- Re: Danish Question H�LDNING, Hans Knudsen
  - Re: Danish Question HÆLDNING, Stefan DK
SUM if conditions are met over multiple worksheets, CMP
Conditional Result based on Multiple Columns, AnnArborBrian
- Re: Conditional Result based on Multiple Columns, Reitanos
  - Re: Conditional Result based on Multiple Columns, AnnArborBrian
- RE: Conditional Result based on Multiple Columns, AnnArborBrian
  - Re: Conditional Result based on Multiple Columns, Reitanos
    - Re: Conditional Result based on Multiple Columns, AnnArborBrian
    - Re: Conditional Result based on Multiple Columns, AnnArborBrian
Using Sumif On Two Columns of Data - How?, f252863
- RE: Using Sumif On Two Columns of Data - How?, Mike H
  - Re: Using Sumif On Two Columns of Data - How?, f252863
    - Re: Using Sumif On Two Columns of Data - How?, Mike H
Vlookup formula - help please...(soth), Soth
- RE: Vlookup formula - help please...(soth), Teethless mama
Re: Nesting, LWilson
vlookup and Sum unique values, Diggsy
- RE: vlookup and Sum unique values, Teethless mama
- RE: vlookup and Sum unique values, Mike H
select multiple records in database given conditions, MayFestivalRon
- Re: select multiple records in database given conditions, Dave Peterson
What-If Analysis, OgnjenGlisic
- Re: What-If Analysis, Niek Otten
Summing cells containing dates, Laura
- RE: Summing cells containing dates, akphidelt
- Re: Summing cells containing dates, T. Valko
- Re: Summing cells containing dates, Otto Moehrbach
- RE: Summing cells containing dates, Mike H
REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA, Security Dave
- RE: REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA, Mike H
- Re: REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA, David Biddulph
  - Re: REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE A, Security Dave
- Re: REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA, T. Valko
HELP!!, Mac
- Re: HELP!!, Otto Moehrbach
  - Re: HELP!!, Mac
    - Re: HELP!!, Otto Moehrbach
    - Re: HELP!!, Otto Moehrbach
    - Re: HELP!!, mac
    - Re: HELP!!, Otto Moehrbach
    - Re: HELP!!, mac
    - Re: HELP!!, mac
    - Re: HELP!!, Otto Moehrbach
    - Re: HELP!!, mac
- Re: HELP!!, Don Guillett
Comparing sets of data, where criteria met, sum certain columns., Kimberly
- Re: Comparing sets of data, where criteria met, sum certain columns., Otto Moehrbach
  - Re: Comparing sets of data, where criteria met, sum certain column, Kimberly
    - Re: Comparing sets of data, where criteria met, sum certain column, Otto Moehrbach
    - Re: Comparing sets of data, where criteria met, sum certain column, Kimberly
    - Re: Comparing sets of data, where criteria met, sum certain column, Otto Moehrbach
    - Re: Comparing sets of data, where criteria met, sum certain column, Kimberly
Creating multiple workbooks, Poorvi
- Re: Creating multiple workbooks, Otto Moehrbach
  - Re: Creating multiple workbooks, Poorvi
    - Re: Creating multiple workbooks, Otto Moehrbach
    - Re: Creating multiple workbooks, Otto Moehrbach
- Re: Creating multiple workbooks, Ron de Bruin
Merged cells withing Protected Sheets, Ann
- RE: Merged cells withing Protected Sheets, BoniM
  - RE: Merged cells withing Protected Sheets, BoniM
- Re: Merged cells withing Protected Sheets, Gord Dibben
date ranges, Carolina Girl
- Re: date ranges, T. Valko
  - Re: date ranges, Carolina Girl
    - Re: date ranges, T. Valko
Calculating specific increments of time across days, asynmyx
- Re: Calculating specific increments of time across days, Rick Rothstein $MVP - VB$
  - Re: Calculating specific increments of time across days, asynmyx
email Button, BadRasta!
- Re: email Button, Reitanos
  - Re: email Button, Jasfoster
- Re: email Button, Ron de Bruin
Re: How do I concatenate information in Excel and keep the number, asynmyx
- Re: How do I concatenate information in Excel and keep the number, Ron Rosenfeld
- Re: How do I concatenate information in Excel and keep the number, Gord Dibben
Multiple functions in one cell, cgroninger
- Re: Multiple functions in one cell, Peo Sjoblom
Use formula to populate cells, BadRasta!
- RE: Use formula to populate cells, Adilson Soledade
Conditional formatting troubleshooting, Matt
- RE: Conditional formatting troubleshooting, Matt
- RE: Conditional formatting troubleshooting, Bob Bridges
Excel question, dannyboy8
- Re: Excel question, Peo Sjoblom
  - Re: Excel question, dannyboy8
    - Re: Excel question, Peo Sjoblom
    - Re: Excel question, dannyboy8
Pivot table field missing, DianeG
- Re: Pivot table field missing, Debra Dalgleish
Deleting duplicates in Excel, Susan Woods
- Re: Deleting duplicates in Excel, Pete_UK
- RE: Deleting duplicates in Excel, Gary''s Student
- Re: Deleting duplicates in Excel, Gaurav
- Re: Deleting duplicates in Excel, Dan R.
Pivot table filed defaults, DianeG
- RE: Pivot table filed defaults, Tom Hutchins
  - RE: Pivot table filed defaults, DianeG
copy cell with macro and increment down each time, RJJ
- RE: copy cell with macro and increment down each time, Gary''s Student
  - RE: copy cell with macro and increment down each time, RJJ
    - RE: copy cell with macro and increment down each time, Gary''s Student
    - RE: copy cell with macro and increment down each time, RJJ
    - RE: copy cell with macro and increment down each time, Gary''s Student
    - RE: copy cell with macro and increment down each time, RJJ
COUNT FUNCTION?, Zakynthos
- Re: COUNT FUNCTION?, Otto Moehrbach
  - Re: COUNT FUNCTION?, Zakynthos
    - Re: COUNT FUNCTION?, Max
    - Re: COUNT FUNCTION?, Peo Sjoblom
    - Re: COUNT FUNCTION?, Gaurav
how to search a sheet using row and column headers, shell96
- Re: how to search a sheet using row and column headers, Pete_UK
  - Re: how to search a sheet using row and column headers, shell96
    - Re: how to search a sheet using row and column headers, Max
non match result, Belinda7237
- Message not available
  - Message not available
    - Re: non match result, Max
Format>Cells>Special>Zip Code, MichaelRobert
- Re: Format>Cells>Special>Zip Code, David Biddulph
  - Re: Format>Cells>Special>Zip Code, MichaelRobert
    - Re: Format>Cells>Special>Zip Code, David Biddulph
    - Re: Format>Cells>Special>Zip Code, MichaelRobert
    - Re: Format>Cells>Special>Zip Code, Beege
    - Re: Format>Cells>Special>Zip Code, MichaelRobert
RE: Disable Pasting into a Workbook, scottyboy
auto transfer data in sheet2 (selected data), deen
- RE: auto transfer data in sheet2 (selected data), Teethless mama
Excel 2002 VLOOKUP in another workbook returns #VALUE, EXCELDEV
- RE: Excel 2002 VLOOKUP in another workbook returns #VALUE, Bob Bridges
If function - Add if its blank, to return blank, Natalie
Repeating rows and columns, lynn
naming a workbook the same as a cell entry, des-sa
- RE: naming a workbook the same as a cell entry, Adilson Soledade
count the number of values when two conditions are met, Sophie D.
- RE: count the number of values when two conditions are met, Mike H
  - RE: count the number of values when two conditions are met, Sophie D.
    - RE: count the number of values when two conditions are met, Mike H
SEQUENTIAL NUMBERING OF WORKBOOKS, des-sa
- Re: SEQUENTIAL NUMBERING OF WORKBOOKS, Gord Dibben
Returning a value from the same row using two variables, vanslanzar
- Re: Returning a value from the same row using two variables, T. Valko
result of formula posted in different cell, BadRasta!
- Re: result of formula posted in different cell, Pete_UK
  - Re: result of formula posted in different cell, Pete_UK
SUMIF formula while filtering, djc276
- Re: SUMIF formula while filtering, T. Valko
  - Re: SUMIF formula while filtering, djc276
    - Re: SUMIF formula while filtering, T. Valko
    - Re: SUMIF formula while filtering, djc276
    - Re: SUMIF formula while filtering, T. Valko
    - Re: SUMIF formula while filtering, djc276
    - Re: SUMIF formula while filtering, T. Valko
- Re: SUMIF formula while filtering, Bob Phillips
  - Re: SUMIF formula while filtering, djc276
    - Re: SUMIF formula while filtering, Bob Phillips
Cell Format - What's wrong?, Danny
- Re: Cell Format - What's wrong?, Dave Peterson
  - Re: Cell Format - What's wrong?, Danny
    - Re: Cell Format - What's wrong?, Dave Peterson
    - Re: Cell Format - What's wrong?, Dave Peterson
    - Re: Cell Format - What's wrong?, Poorvi
    - Re: Cell Format - What's wrong?, Danny
Alternative formula to the vlookup formula?, Victor
- RE: Alternative formula to the vlookup formula?, Ted M H
  - RE: Alternative formula to the vlookup formula?, Victor
Excel drag down formula not working good.., zoola ander
- Re: Excel drag down formula not working good.., David Biddulph
- <Possible follow-ups>
- Excel drag down formula not working good.., zoola ander
- Excel drag down formula not working good.., zoola
  - RE: Excel drag down formula not working good.., akphidelt
copy field settings of a field to other fields in same pivot tbl, new22007
Database function criteria, Art
- Re: Database function criteria, Bob Phillips
  - Re: Database function criteria, Art
    - Re: Database function criteria, Bob Phillips
    - Re: Database function criteria, Art
    - Re: Database function criteria, Bob Phillips
excel, unisafe
- RE: excel, Dave
  - RE: excel, unisafe
- <Possible follow-ups>
- Re: Excel, Pete_UK
- Re: Excel, Jim Cone
Pivot Table Calculated Field using Grand Total, diaare
- RE: Pivot Table Calculated Field using Grand Total, diaare
  - Re: Pivot Table Calculated Field using Grand Total, Herbert Seidenberg
- Re: Pivot Table Calculated Field using Grand Total, Debra Dalgleish
RE: how to convert from ° ' " to decimal °, timothyl
- Re: how to convert from ° ' " to decimal °, Rick Rothstein $MVP - VB$
Formula Errors / #Value!, Mary Lou
- RE: Formula Errors / #Value!, Dave
- Message not available
  - Message not available
    - Re: Formula Errors / #Value!, Gord Dibben
sumif returns #VALUE! when linked workbook is closed, BrianL
- Re: sumif returns #VALUE! when linked workbook is closed, T. Valko
  - Re: sumif returns #VALUE! when linked workbook is closed, BrianL
    - Re: sumif returns #VALUE! when linked workbook is closed, T. Valko
    - Re: sumif returns #VALUE! when linked workbook is closed, BrianL
    - Re: sumif returns #VALUE! when linked workbook is closed, T. Valko
is there a solution to get the result in V?, Marc
- RE: is there a solution to get the result in V?, Bob Bridges
Can I pull in the filename used in Vlookup from another cell?, frustrated linker
- Re: Can I pull in the filename used in Vlookup from another cell?, Peo Sjoblom
Create a macro with a list, jeannie v
- RE: Create a macro with a list, Bob Bridges
  - RE: Create a macro with a list, jeannie v
- <Possible follow-ups>
- Create a Macro with a List, jeannie v
  - RE: Create a Macro with a List, jeannie v
I've created an Excel worksheet using the Vlookup command., LionHearted1952
- Re: I've created an Excel worksheet using the Vlookup command., T. Valko
VEhicle Maintenance, Cass
- RE: VEhicle Maintenance, Mike H
SUM TOTALS AT BOTTOM OF WORKSHEET, Denny
- RE: SUM TOTALS AT BOTTOM OF WORKSHEET, Teethless mama
- Re: SUM TOTALS AT BOTTOM OF WORKSHEET, Reitanos
Functions in Excel, Beth
- Re: Functions in Excel, Pete_UK
how can i stop formulas from displaying like this =R[-49]C+R[-25], calculator1
- Re: how can i stop formulas from displaying like this =R[-49]C+R[-25], Max
  - Re: how can i stop formulas from displaying like this =R[-49]C+R[-, KIM W
    - Re: how can i stop formulas from displaying like this =R[-49]C+R[-, Max
Excel data formatting, jreinier
- RE: Excel data formatting, Teethless mama
  - Re: Excel data formatting, jreinier
- Re: Excel data formatting, David Biddulph
How can I create a check box in an excel template, lcoggan
VLOOKUP the right choice?, RJJ
- RE: VLOOKUP the right choice?, Bob Bridges
Looking Up the Answer by Row and Column, ericm
- Re: Looking Up the Answer by Row and Column, T. Valko
  - Re: Looking Up the Answer by Row and Column, ericm
    - Re: Looking Up the Answer by Row and Column, T. Valko
- Re: Looking Up the Answer by Row and Column, Max
- Re: Looking Up the Answer by Row and Column, Lars-�ke Aspelin
  - Re: Looking Up the Answer by Row and Column, ericm
Duplicate sheet, autonumber sheet, record data on another sheet, des-sa
Question on breaking on cell into three seperate, Frank Sabella
- Re: Question on breaking on cell into three seperate, David Biddulph
Question on similar topic, Frank Sabella
- Re: Question on similar topic, Ron Rosenfeld
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar, cmazurski
- RE: Why Can't I navigate Excell 2003 Worksheets via Navigation Bar, Tom Hutchins
  - RE: Why Can't I navigate Excell 2003 Worksheets via Navigation Bar, cmazurski
    - Re: Why Can't I navigate Excell 2003 Worksheets via Navigation Bar, Gord Dibben
Function/Formula Question, John Morgan
- Re: Function/Formula Question, Gaurav
  - Re: Function/Formula Question, John Morgan
    - Re: Function/Formula Question, Rick Rothstein $MVP - VB$
- Re: Function/Formula Question, Rick Rothstein $MVP - VB$
- Re: Function/Formula Question, David Biddulph
How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time, RJJ
- Re: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time, PCLIVE
  - Re: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30, Mike H
    - Re: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30, RJJ
    - Message not available
    - Message not available
    - Re: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30, Max
- RE: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time, Mike H
  - RE: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30, RJJ
what does this forumla mean?, mmatz
- RE: what does this forumla mean?, Mike H
  - RE: what does this forumla mean?, mmatz
    - Re: what does this forumla mean?, Rick Rothstein $MVP - VB$
Number Format?, gb_S49
- Re: Number Format?, Ron Coderre
  - Re: Number Format?, gb_S49
- RE: Number Format?, Mike H
- RE: Number Format?, Mike H
- Re: Number Format?, Gaurav
- Re: Number Format?, Rick Rothstein $MVP - VB$
  - Re: Number Format?, David Biddulph
    - Re: Number Format?, Rick Rothstein $MVP - VB$
  - Re: Number Format?, Ron Rosenfeld
    - Re: Number Format?, Rick Rothstein $MVP - VB$
- RE: Number Format?, gb_S49
- RE: Number Format?, gb_S49
- RE: Number Format?, gb_S49
How can I find out what date going to be 3 month from today in ex, Shahin Khan
- RE: How can I find out what date going to be 3 month from today in ex, Susan
- RE: How can I find out what date going to be 3 month from today in ex, Mike H
- Re: How can I find out what date going to be 3 month from today in ex, David Biddulph
- Re: How can I find out what date going to be 3 month from today in ex, Ron Rosenfeld
- RE: How can I find out what date going to be 3 month from today in ex, BoniM
Summarizing updated external data, Jordan
- Re: Summarizing updated external data, Pete_UK
  - Re: Summarizing updated external data, Jordan
How do I create a staff roster in Excel?, Skwish
- RE: How do I create a staff roster in Excel?, ryguy7272
GetPivotData Question, Barb Reinhardt
- Re: GetPivotData Question, Debra Dalgleish
Lookup in dependent tables., MichaelRobert
- Re: Lookup in dependent tables., T. Valko
  - Re: Lookup in dependent tables., MichaelRobert
    - Re: Lookup in dependent tables., T. Valko
tab name, des-sa
- RE: tab name, Barb Reinhardt
  - RE: tab name, des-sa
- Re: tab name, Rick Rothstein $MVP - VB$
  - Re: tab name, des-sa
    - Re: tab name, Barb Reinhardt
  - Re: tab name, des-sa
- RE: tab name, Gary''s Student
Re: Help! I can not remember the password to an important Excel workb, Alan
- Re: Help! I can not remember the password to an important Excel workb, Dave Peterson
- Re: Help! I can not remember the password to an important Excel workb, David Biddulph
filers in more than 1 cell, kevin
- RE: filers in more than 1 cell, Gav123
Using roundup() but on a whole spreadsheet instead of since cells, bobmanuk
- Re: Using roundup() but on a whole spreadsheet instead of since cells, Bob Phillips
sheet name, des-sa
- Re: sheet name, PCLIVE
  - Re: sheet name, des-sa
    - Re: sheet name, PCLIVE
    - Re: sheet name, PCLIVE
    - Re: sheet name, des-sa
Exceel formulae, arisan
- Re: Exceel formulae, Reitanos
- Re: Exceel formulae, Gaurav
  - Re: Exceel formulae, arisan
    - Re: Exceel formulae, Gaurav
    - Re: Exceel formulae, David Biddulph
Comparing 2 dates and times, bollard
- Re: Comparing 2 dates and times, David Biddulph
  - Re: Comparing 2 dates and times, bollard
    - Re: Comparing 2 dates and times, David Biddulph
Menu options, Luis Elguezabal
- Re: Menu options, Reitanos
append worksheet with data from another, Mark B
- Re: append worksheet with data from another, Gaurav
- Re: append worksheet with data from another, Rick Rothstein $MVP - VB$
  - Re: append worksheet with data from another, Rick Rothstein $MVP - VB$
Shading of Multiple Rows in a Pivot Table, JanT
- Re: Shading of Multiple Rows in a Pivot Table, Debra Dalgleish
Email files, rkaiser
Summing a Column - Net and Absolute Values, BRob
- Re: Summing a Column - Net and Absolute Values, Pete_UK
- Re: Summing a Column - Net and Absolute Values, Ron Coderre
- Re: Summing a Column - Net and Absolute Values, JE McGimpsey
- RE: Summing a Column - Net and Absolute Values, Mike H
pivot table help, Josie
- Re: pivot table help, Debra Dalgleish
  - Re: pivot table help, Josie
    - Re: pivot table help, Debra Dalgleish
Is it possible?, forevertrying
- Re: Is it possible?, JE McGimpsey
- Re: Is it possible?, Niek Otten
  - Re: Is it possible?, forevertrying
    - Re: Is it possible?, JE McGimpsey
    - Re: Is it possible?, forevertrying
    - Re: Is it possible?, JE McGimpsey
    - Re: Is it possible?, forevertrying
    - Re: Is it possible?, JE McGimpsey
    - Re: Is it possible?, forevertrying
    - Re: Is it possible?, forevertrying
count unique in non-continuous list, Hans
- Message not available
  - Re: count unique in non-continuous list, Harlan Grove
    - Re: count unique in non-continuous list, Hans
data validation, des-sa
- Re: data validation, Debra Dalgleish
Can anyone assist me with a new workbook template for Excel 2003?, kellyta
- Re: Can anyone assist me with a new workbook template for Excel 2003?, Bob Phillips
Find Earliest Date, Elaine
- Re: Find Earliest Date, Fred Smith
- Re: Find Earliest Date, T. Valko
  - Re: Find Earliest Date, Elaine
    - Re: Find Earliest Date, T. Valko
Logical Test, AFA
- RE: Logical Test, yshridhar
  - RE: Logical Test, AFA
Insert a drop down list into an excel cell, linked to Access, Wombat
Excel queries, ah
- Re: Excel queries, Arvi Laanemets
- Re:Excel queries, Dave Curtis
How to get the result with IF function, Leng
- Re: How to get the result with IF function, T. Valko
- RE: How to get the result with IF function, Dave
Pivot tbl rpt-how to return text in a field vs. a sum/count value, bridgirrl1
- Re: Pivot tbl rpt-how to return text in a field vs. a sum/count value, Roger Govier
Lookup Issue, Jayz
- Re: Lookup Issue, Pete_UK
  - Re: Lookup Issue, Jayz
    - Re: Lookup Issue, Pete_UK
- Re: Lookup Issue, Jim Cone
- Re: Lookup Issue, T. Valko
pivot table filtering not working, Carl Henthorn
how to keep a running tally of boxes filled with info, fireman175
- RE: how to keep a running tally of boxes filled with info, Carl Henthorn
Need to copy, Lauri
- Re: Need to copy, Dave Peterson
Invisible Formatting ? or ... ?, Steve
- RE: Invisible Formatting ? or ... ?, akphidelt
  - RE: Invisible Formatting ? or ... ?, Steve
    - RE: Invisible Formatting ? or ... ?, akphidelt
    - RE: Invisible Formatting ? or ... ?, Steve
    - Re: Invisible Formatting ? or ... ?, David Biddulph
    - Re: Invisible Formatting ? or ... ?, Steve
Multiple cell value, IP
- Re: Multiple cell value, Dave Peterson
  - Re: Multiple cell value, ip2010
    - Re: Multiple cell value, ip2010
    - Re: Multiple cell value, Dave Peterson
    - Re: Multiple cell value, ip2010
    - Re: Multiple cell value, Dave Peterson
Two-variable Data Table - Problem with result/output, Chanpheng Botham
- RE: Two-variable Data Table - Problem with result/output, akphidelt
Making formula results not visible in a cell, mp smith
intercept and slope functions, midbond
- RE: intercept and slope functions, MartinW
gathering multiple spreadsheets into one, Mark B
- RE: gathering multiple spreadsheets into one, Michael
  - RE: gathering multiple spreadsheets into one, Mark B
VALIDATION, des-sa
- Re: VALIDATION, Debra Dalgleish
Cell insertion if values not matching, Susan
- RE: Cell insertion if values not matching, ryguy7272
  - RE: Cell insertion if values not matching, Susan
IF Function with ISBLANK, Steve M
- RE: IF Function with ISBLANK, akphidelt
  - Re: IF Function with ISBLANK, Steve M
    - Re: IF Function with ISBLANK, Steve M
    - Re: IF Function with ISBLANK, akphidelt
    - Re: IF Function with ISBLANK, Steve M
    - Re: IF Function with ISBLANK, akphidelt
- Re: IF Function with ISBLANK, T. Valko
  - Re: IF Function with ISBLANK, Steve M
    - Re: IF Function with ISBLANK, T. Valko
    - Re: IF Function with ISBLANK, Steve M
lookup/match mult values, Keep It Simple Stupid
- Re: lookup/match mult values, T. Valko
  - Re: lookup/match mult values, Keep It Simple Stupid
    - Re: lookup/match mult values, T. Valko
Reference sheets, KKcags
- RE: Reference sheets, Marcelo
new cell for each day, Libby
- Re: new cell for each day, Don Guillett
  - Re: new cell for each day, Libby
- Re: new cell for each day, Dave Peterson
  - Re: new cell for each day, Libby
    - Re: new cell for each day, Dave Peterson
problem summing columns with dates, lampatmyfeet
- Re: problem summing columns with dates, Pete_UK
  - Re: problem summing columns with dates, lampatmyfeet
If Question, carl
- RE: If Question, Gary''s Student
  - Re: If Question, David Biddulph
    - Re: If Question, Gary''s Student
new cell each day, Libby
- Re: new cell each day, David Biddulph
  - Re: new cell each day, Libby
  - Re: new cell each day, Libby
    - Re: new cell each day, Libby
    - Re: new cell each day, David Biddulph
    - Re: new cell each day, T. Valko
    - Re: new cell each day, David Biddulph
- Re: new cell each day, T. Valko
Calculated Fields and Pivot Tables, Mike
- Re: Calculated Fields and Pivot Tables, Herbert Seidenberg
SUMIF Criteria, JC
- RE: SUMIF Criteria, bpeltzer
- RE: SUMIF Criteria, Gary''s Student
- RE: SUMIF Criteria, akphidelt
- Re: SUMIF Criteria, dan dungan
  - Re: SUMIF Criteria, David Biddulph
Single Quote use in cell reference, Eric
- Re: Single Quote use in cell reference, Reitanos
Sum If Help, Maggie0507
- Re: Sum If Help, Reitanos
  - Re: Sum If Help, Maggie0507
- Re: Sum If Help, Don Guillett
- Re: Sum If Help, Peo Sjoblom
  - Re: Sum If Help, Maggie0507
Formula Halp - If or Lookup, Diane
- RE: Formula Halp - If or Lookup, John Bundy
  - RE: Formula Halp - If or Lookup, Diane
    - Re: Formula Halp - If or Lookup, Fred Smith
    - Re: Formula Halp - If or Lookup, dan dungan
    - Re: Formula Halp - If or Lookup, Diane
conditional formatting, KSP
- RE: conditional formatting, akphidelt
- <Possible follow-ups>
- Conditional Formatting, Rob Walter
  - RE: Conditional Formatting, des-sa
- Conditional formatting, WallyZ
  - RE: Conditional formatting, akphidelt
    - RE: Conditional formatting, WallyZ
  - Re: Conditional formatting, David Biddulph
- Conditional Formatting, GMc
  - Re: Conditional Formatting, T. Valko
    - Re: Conditional Formatting, GMc
    - Re: Conditional Formatting, T. Valko
    - Re: Conditional Formatting, GMc
    - Re: Conditional Formatting, T. Valko
- Re: conditional formatting, Pete_UK
  - Message not available
    - Re: conditional formatting, Pete_UK
- RE: conditional formatting, SandyB
To count how many are in a certain age group, LEG
- Re: To count how many are in a certain age group, Peo Sjoblom
  - Re: To count how many are in a certain age group, LEG
    - Re: To count how many are in a certain age group, Peo Sjoblom
- RE: To count how many are in a certain age group, John Bundy
  - RE: To count how many are in a certain age group, LEG
- Re: To count how many are in a certain age group, Sandy Mann
  - Re: To count how many are in a certain age group, LEG
    - Re: To count how many are in a certain age group, krcowen
    - Re: To count how many are in a certain age group, T. Valko
  - Re: To count how many are in a certain age group, T. Valko
How do I move numbers with formulas behind to new workbook?, Linda
- RE: How do I move numbers with formulas behind to new workbook?, John Bundy
Condiitonal formatting-colored cell, Diane
- Re: Condiitonal formatting-colored cell, Peo Sjoblom
  - Re: Condiitonal formatting-colored cell, Diane
    - Re: Condiitonal formatting-colored cell, Peo Sjoblom
    - Re: Condiitonal formatting-colored cell, Peo Sjoblom
- RE: Condiitonal formatting-colored cell, John Bundy
  - RE: Condiitonal formatting-colored cell, Diane
Find next value, bgkgmg
- RE: Find next value, Gary''s Student
  - RE: Find next value, bgkgmg
some worksheet columns don't update formula calculations, Vic Abrahamian
help with formula -, Soth
- RE: help with formula -, John Bundy
text for numbers, bgkgmg
- Re: text for numbers, Lars-�ke Aspelin
Accidental Currency Converted, pzeitlin
Duplicate entries in single column w/o sorting?, scoldiron
- Re: Duplicate entries in single column w/o sorting?, Peo Sjoblom
- Re: Duplicate entries in single column w/o sorting?, Bernard Liengme
vlookup on multiple values, samuel
- RE: vlookup on multiple values, ND Pard
- Re: vlookup on multiple values, Bernard Liengme
- RE: vlookup on multiple values, Teethless mama
Aging reports, LBoyd
- RE: Aging reports, Teethless mama
- Re: Aging reports, Fred Smith
Getting Count Formula Working if Column has both number and text, Nikhil Joshi
- Re: Getting Count Formula Working if Column has both number and text, Peo Sjoblom
If results for multiple cells, gfoster
- RE: If results for multiple cells, Teethless mama
Arbitrary Lookups - return ALL found values, baki
- RE: Arbitrary Lookups - return ALL found values, Teethless mama
  - RE: Arbitrary Lookups - return ALL found values, baki
  - Re: Arbitrary Lookups - return ALL found values, T. Valko
  - RE: Arbitrary Lookups - return ALL found values, baki
- RE: Arbitrary Lookups - return ALL found values, Gary''s Student
  - Thanks for the code, Tim Fisher
    - Re: Thanks for the code, Gord Dibben
- Re: Arbitrary Lookups - return ALL found values, Herbert Seidenberg
Goal Seek Goes Haywire, Dkline
- RE: Goal Seek Goes Haywire, John Bundy
  - RE: Goal Seek Goes Haywire, Dkline
    - RE: Goal Seek Goes Haywire, John Bundy
    - RE: Goal Seek Goes Haywire, Dkline
SUMPRODUCT or another function???, Paul Groth
- Re: SUMPRODUCT or another function???, Pete_UK
- RE: SUMPRODUCT or another function???, Teethless mama
using multiple sheets from a workbook in a formula, Megglesface
- Re: using multiple sheets from a workbook in a formula, Gaurav
  - Re: using multiple sheets from a workbook in a formula, Megglesface
    - Re: using multiple sheets from a workbook in a formula, David Biddulph
- Re: using multiple sheets from a workbook in a formula, Gord Dibben
Re: Percentages and whole numbers, Gaurav
Need formula like ISBLANK that returns "no value" even if there is a formula in referenced cell, insitedge
Referen to cell on other sheet not working, Pieter
- Re: Referen to cell on other sheet not working, JE McGimpsey
  - Re: Referen to cell on other sheet not working, Pieter
Advanced Criterea in Formulas, mpbhammer
- Re: Advanced Criterea in Formulas, aidan.heritage@xxxxxxxxxx
- Re: Advanced Criterea in Formulas, Bob Phillips
can excel alert you when a number is less than a particular value, Megglesface
- Re: can excel alert you when a number is less than a particular value, Pete_UK
  - Re: can excel alert you when a number is less than a particular va, Megglesface
    - Re: can excel alert you when a number is less than a particular va, Pete_UK
    - Re: can excel alert you when a number is less than a particular va, Megglesface
    - Re: can excel alert you when a number is less than a particular va, Pete_UK
    - Re: can excel alert you when a number is less than a particular va, Megglesface
- RE: can excel alert you when a number is less than a particular value, Dave
Calulate a value when date is in a range., hardymeg
- RE: Calulate a value when date is in a range., ryguy7272
- <Possible follow-ups>
- Calulate a value when date is in a range., hardymeg
  - RE: Calulate a value when date is in a range., Dave
Insert sheet linkage, Learn-more
- Re: Insert sheet linkage, Pete_UK
  - Re: Insert sheet linkage, Learn-more
    - Re: Insert sheet linkage, David Biddulph
    - Re: Insert sheet linkage, Pete_UK
Function to insert current filename into worksheet?, Ginko
- RE: Function to insert current filename into worksheet?, Learn-more
  - Re: Function to insert current filename into worksheet?, Dave Peterson
Conditonal Formatting, TSK
- Re: Conditonal Formatting, Pete_UK
- Re: Conditonal Formatting, Max
How to set Auto-Change letters into Uppercases for Data entry in E, Cpviv
- RE: How to set Auto-Change letters into Uppercases for Data entry in E, Mike H
  - RE: How to set Auto-Change letters into Uppercases for Data entry, Cpviv
    - RE: How to set Auto-Change letters into Uppercases for Data entry, Mike H
Which function do I use?, Denzoid
- Re: Which function do I use?, Bob Phillips
  - Re: Which function do I use?, Denzoid
  - Re: Which function do I use?, Denzoid
    - Re: Which function do I use?, David Biddulph
How to change color in cell when there is input, TSK
- Re: How to change color in cell when there is input, Max
  - Re: How to change color in cell when there is input, TSK
    - Re: How to change color in cell when there is input, TSK
    - How to change color in cell when there is input, TSK
    - Re: How to change color in cell when there is input, Pete_UK
    - Re: How to change color in cell when there is input, Max
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2, cwhisperer
Copy & Pasting Drop Down Boxes, Todd
How to average numbers greater than zero in a pivot table, Ken
How to protect cell with formula from being entering info, TSK
- Re: How to protect cell with formula from being entering info, Arvi Laanemets
Alternative formula for getting totals, Victor
Calculate totals for a range of names, t_perkins
- Re: Calculate totals for a range of names, Don Guillett
  - Re: Calculate totals for a range of names, t_perkins
    - Re: Calculate totals for a range of names, Don Guillett
    - Re: Calculate totals for a range of names, Don Guillett
    - Re: Calculate totals for a range of names, t_perkins
    - Re: Calculate totals for a range of names, t_perkins
    - Re: Calculate totals for a range of names, Don Guillett
- Re: Calculate totals for a range of names, RagDyer
  - Re: Calculate totals for a range of names, t_perkins
    - Re: Calculate totals for a range of names, krcowen
RE: How do I set up a formula to add column a if column b = cell c1?, NS
- Re: How do I set up a formula to add column a if column b = cell c1?, Roger Govier
Show dates based on criteria, slaga
- Re: Show dates based on criteria, T. Valko
  - Re: Show dates based on criteria, slaga
Offset/match returns #value error, Geoff
- RE: Offset/match returns #value error, Dave
  - RE: Offset/match returns #value error, Geoff
- Re: Offset/match returns #value error, T. Valko
  - Re: Offset/match returns #value error, Geoff
    - Re: Offset/match returns #value error, Geoff
    - Re: Offset/match returns #value error, Geoff
    - Re: Offset/match returns #value error, T. Valko
    - Re: Offset/match returns #value error, Geoff
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, des-sa
- Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, Bernard Liengme
  - Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, des-sa
- Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, T. Valko
  - Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, des-sa
- Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, Ken Johnson
  - Re: HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE, des-sa
Need help with formula, Ed B.
- Re: Need help with formula, T. Valko
- RE: Need help with formula, Susan
Excel 2007, nrodADAA
- Re: Excel 2007, Don Guillett
  - Re: Excel 2007, nrodADAA
- Re: Excel 2007, Bernard Liengme
  - Re: Excel 2007, nrodADAA
Re: Can I Use a Count Function for Text?, catwoman48
Formatting cell to show current Quarter, S trainer
- Re: Formatting cell to show current Quarter, David Biddulph
  - Re: Formatting cell to show current Quarter, S trainer
Look up duplicate amounts with unique batch numbers, JHL
- RE: Look up duplicate amounts with unique batch numbers, Mike H
  - RE: Look up duplicate amounts with unique batch numbers, JHL
    - RE: Look up duplicate amounts with unique batch numbers, Dave
    - Re: Look up duplicate amounts with unique batch numbers, JHL
Using Sum If and an array?, Jonathan
- RE: Using Sum If and an array?, Jonathan
  - Re: Using Sum If and an array?, Reitanos
    - Re: Using Sum If and an array?, Zack Barresse
- Re: Using Sum If and an array?, Zack Barresse
  - Re: Using Sum If and an array?, Jonathan
Count for multiple text criterias, saneedshelp
- Re: Count for multiple text criterias, Reitanos
  - Re: Count for multiple text criterias, saneedshelp
- Re: Count for multiple text criterias, T. Valko
  - Re: Count for multiple text criterias, T. Valko
    - Re: Count for multiple text criterias, saneedshelp
copy text out of a range of cells, Mark B
- Re: copy text out of a range of cells, Pete_UK
  - Re: copy text out of a range of cells, Mark B
    - Re: copy text out of a range of cells, Pete_UK
RE: How do I link cells from one excel worksheet to another?, emgee100
- <Possible follow-ups>
- RE: How do I link cells from one excel worksheet to another?, emgee100
  - Re: How do I link cells from one excel worksheet to another?, Gord Dibben
    - Re: How do I link cells from one excel worksheet to another?, larc
    - Re: How do I link cells from one excel worksheet to another?, Spiky
    - Re: How do I link cells from one excel worksheet to another?, nso
    - Re: How do I link cells from one excel worksheet to another?, Bill
COUNTIF counting incorrectly, Dave
- Re: COUNTIF counting incorrectly, T. Valko
  - Re: COUNTIF counting incorrectly, Dave
    - Re: COUNTIF counting incorrectly, T. Valko
    - Re: COUNTIF counting incorrectly, Dave
    - Re: COUNTIF counting incorrectly, T. Valko
- Re: COUNTIF counting incorrectly, Niek Otten
- RE: COUNTIF counting incorrectly, Mike H
  - RE: COUNTIF counting incorrectly, Dave
    - RE: COUNTIF counting incorrectly, Dave
Sum of Vlookup, Patrick C. Simonds
- Re: Sum of Vlookup, Gaurav
  - Re: Sum of Vlookup, Patrick C. Simonds
    - Re: Sum of Vlookup, Gaurav
Create totals for close-matching names?, t_perkins
- Re: Create totals for close-matching names?, Don Guillett
  - Re: Create totals for close-matching names?, t_perkins
    - Re: Create totals for close-matching names?, Don Guillett
    - Re: Create totals for close-matching names?, t_perkins
    - Re: Create totals for close-matching names?, Don Guillett
    - Re: Create totals for close-matching names?, t_perkins
    - Re: Create totals for close-matching names?, Don Guillett
drop down menus and corresponding hyperlinks, Kimmie40
- Re: drop down menus and corresponding hyperlinks, Pete_UK
cell extract, Igneshwara reddy
- RE: cell extract, akphidelt
  - RE: cell extract, Igneshwara reddy
Formula only works on some computers, Libby
- Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
- Re: Formula only works on some computers, T. Valko
- RE: Formula only works on some computers, Libby
  - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, Bernd P
    - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, T. Valko
    - Re: Formula only works on some computers, Bernd P
    - Re: Formula only works on some computers, T. Valko
    - Re: Formula only works on some computers, Harlan Grove
    - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, Bob Phillips
    - Re: Formula only works on some computers, Rick Rothstein $MVP - VB$
    - Re: Formula only works on some computers, Bob Phillips
Formula To Keep Certain Cells Blank, Dave
H or VLookup Help, Mark B
- Re: H or VLookup Help, MyVeryOwnSelf
Minimum Ifs Function, Jon Ratzel
- Re: Minimum Ifs Function, Pete_UK
  - Re: Minimum Ifs Function, Jon Ratzel
    - Re: Minimum Ifs Function, Pete_UK
    - Re: Minimum Ifs Function, Jon Ratzel
    - Re: Minimum Ifs Function, Pete_UK
- Re: Minimum Ifs Function, T. Valko
- Re: Minimum Ifs Function, Sandy Mann
Fill colors and high contrast, Philippeam
- Re: Fill colors and high contrast, Shane Devenshire
  - Re: Fill colors and high contrast, Philippeam
    - Re: Fill colors and high contrast, Gord Dibben
  - Re: Fill colors and high contrast, Philippeam
Counting Dates, Mark Solesbury
- Re: Counting Dates, T. Valko
- Re: Counting Dates, Sandy Mann
- Re: Counting Dates, Shane Devenshire
How to supress #N/A in an array formula., Phil
- Re: How to supress #N/A in an array formula., Gaurav
- Re: How to supress #N/A in an array formula., T. Valko
  - Re: How to supress #N/A in an array formula., Phil
    - Re: How to supress #N/A in an array formula., Peo Sjoblom
- Re: How to supress #N/A in an array formula., Shane Devenshire
Re: How can I make a drop down box visible within a worksheet?, sparrot
- Re: How can I make a drop down box visible within a worksheet?, Peo Sjoblom
- Re: How can I make a drop down box visible within a worksheet?, Shane Devenshire
- Re: How can I make a drop down box visible within a worksheet?, Bonnie
  - Re: How can I make a drop down box visible within a worksheet?, Peo Sjoblom
    - Re: How can I make a drop down box visible within a worksheet?, Bonnie
    - Re: How can I make a drop down box visible within a worksheet?, Peo Sjoblom
needing to calculate entries, but no the spaces in some cells, joflo65
- RE: needing to calculate entries, but no the spaces in some cells, joflo65
- Re: needing to calculate entries, but no the spaces in some cells, JE McGimpsey
average by date, chumley
- Re: average by date, Peo Sjoblom
  - Re: average by date, chumley
    - Re: average by date, Peo Sjoblom
VLOOKUP, but different, Cooz
- Re: VLOOKUP, but different, Herbert Seidenberg
Re: Vacation Planer, aidan.heritage@xxxxxxxxxx
- <Possible follow-ups>
- Re: Vacation Planer, Cimjet
Finding entries across columns, bollard
- Re: Finding entries across columns, Don Guillett
- Re: Finding entries across columns, Max
Macro To Remove Subtotals from ALL Worksheets, vidguru
- Re: Macro To Remove Subtotals from ALL Worksheets, Dave Peterson
  - Re: Macro To Remove Subtotals from ALL Worksheets, vidguru
Function Equivalent need, ytayta555
- RE: Function Equivalent need, Tom Hutchins
  - Re: Function Equivalent need, ytayta555
    - Re: Function Equivalent need, ytayta555
    - Re: Function Equivalent need, Tom Hutchins
    - Re: Function Equivalent need, ytayta555
- Re: Function Equivalent need, RagDyeR
CountIF Help, Glenn
- RE: CountIF Help, Harimau
  - Re: CountIF Help, Bob Phillips
  - RE: CountIF Help, Glenn
count months between years, dqm
- RE: count months between years, Harimau
- RE: count months between years, Mike H
- Re: count months between years, David Biddulph
cant insert column get error message, sheppey
- RE: cant insert column get error message, Harimau
  - Re: cant insert column get error message, Ken Johnson
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!!, forevertrying
- RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!!, Dave
  - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Martin
  - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Niek Otten
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Niek Otten
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Peo Sjoblom
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Niek Otten
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Peo Sjoblom
    - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Dave
    - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Niek Otten
    - Re: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
    - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, Dave
  - RE: VLOOKUP returning a #VALUE! error and I've not idea why! HELP!, forevertrying
Sum Pivot Table per Unit Records, Anthony
- RE: Sum Pivot Table per Unit Records, ryguy7272
Sumif multiple criteria?, Alan
- Re: Sumif multiple criteria?, Bob Phillips
  - Re: Sumif multiple criteria?, Alan
    - Re: Sumif multiple criteria?, Bob Phillips
Source for DropDown in another workbook, alexis_anne3799
- RE: Source for DropDown in another workbook, Alan
- Re: Source for DropDown in another workbook, Gord Dibben
  - Re: Source for DropDown in another workbook, alexis_anne3799
Different Language Settings..., Trevor Williams
- Re: Different Language Settings..., Ron de Bruin
  - Re: Different Language Settings..., Ron de Bruin
    - Re: Different Language Settings..., Trevor Williams
    - Re: Different Language Settings..., Ron de Bruin
    - Re: Different Language Settings..., Trevor Williams
Pivot table - display all labels (i.e: do not summarise) how to?, Martin
- Re: Pivot table - display all labels (i.e: do not summarise) how to?, Dave Peterson
Duplicating/Mirror Data into another worksheet within same workboo, TJ
Move to next line, bgkgmg
- Re: Move to next line, Max
SUMIF with text, bgkgmg
- Re: SUMIF with text, Pete_UK
Meaning of $ in function or formula, Kula
- RE: Meaning of $ in function or formula, Dennis
- Re: Meaning of $ in function or formula, David Biddulph
Percentage of the occurance of a word in a date range, Art-SNL
- Re: Percentage of the occurance of a word in a date range, T. Valko
  - Re: Percentage of the occurance of a word in a date range, Art-SNL
    - Re: Percentage of the occurance of a word in a date range, Art-SNL
    - Re: Percentage of the occurance of a word in a date range, T. Valko
    - Re: Percentage of the occurance of a word in a date range, Art-SNL
    - Re: Percentage of the occurance of a word in a date range, T. Valko
    - Re: Percentage of the occurance of a word in a date range, Alan
    - Re: Percentage of the occurance of a word in a date range, T. Valko
help with functions, angel
- Re: help with functions, Peo Sjoblom
- Re: help with functions, T. Valko
- Re: help with functions, Arvi Laanemets
Sumif data from multiple columns, Nick
- Re: Sumif data from multiple columns, Pete_UK
- Re:Sumif data from multiple columns, Dave Curtis
  - Re:Sumif data from multiple columns, Nick
    - Re: Re:Sumif data from multiple columns, T. Valko
Tracking cursor location, JonStein
- RE: Tracking cursor location, Mike
Can you create a new array based on the value in a column?, Jeff
- Re: Can you create a new array based on the value in a column?, Spiky
  - Re: Can you create a new array based on the value in a column?, Jeff
    - Re: Can you create a new array based on the value in a column?, Spiky
conditional formatting only applies to part of cell text, klkropf
- RE: conditional formatting only applies to part of cell text, akphidelt
  - RE: conditional formatting only applies to part of cell text, klkropf
    - RE: conditional formatting only applies to part of cell text, akphidelt
    - Re: conditional formatting only applies to part of cell text, Gord Dibben
    - Re: conditional formatting only applies to part of cell text, akphidelt
    - Re: conditional formatting only applies to part of cell text, klkropf
    - Re: conditional formatting only applies to part of cell text, Gord Dibben
how do I show the arrow for dropdown menu in excel?, dorinc29
- Re: how do I show the arrow for dropdown menu in excel?, Max
Count the number of values in a list that meet certain criteria, Fudgy
- Re: Count the number of values in a list that meet certain criteria, Peo Sjoblom
can you anchor an image to a cell in excel?, jy15bill
- Re: can you anchor an image to a cell in excel?, Peo Sjoblom
  - Re: can you anchor an image to a cell in excel?, jy15bill
    - Re: can you anchor an image to a cell in excel?, Peo Sjoblom
- Re: can you anchor an image to a cell in excel?, Gord Dibben
RE: frozen spreadsheet, jackie
- Re: frozen spreadsheet, Gord Dibben
Formula search, Igor
2 Macros running on same module, Travis
- Re: 2 Macros running on same module, Reitanos
  - Re: 2 Macros running on same module, Travis
Name Box, MikeL
- Re: Name Box, Zack Barresse
  - Re: Name Box, MikeL
    - Re: Name Box, Zack Barresse
    - Re: Name Box, Rick Rothstein $MVP - VB$
How do I combine Exel workbooks?, Kman
- Re: How do I combine Exel workbooks?, Zack Barresse
- Re: How do I combine Exel workbooks?, Spiky
Force excel to read dates as D/M/YYYY, S Davis
- Re: Force excel to read dates as D/M/YYYY, Roger Govier
  - Re: Force excel to read dates as D/M/YYYY, S Davis
    - Re: Force excel to read dates as D/M/YYYY, Roger Govier
    - Re: Force excel to read dates as D/M/YYYY, S Davis
    - Re: Force excel to read dates as D/M/YYYY, Roger Govier
    - Re: Force excel to read dates as D/M/YYYY, S Davis
Gridlines dissappeared behind formated cells. Get them back?, fkruz
- RE: Gridlines dissappeared behind formated cells. Get them back?, Tom Hutchins
Picking up the latest text value in a column, djmagcruznyc
- Re: Picking up the latest text value in a column, Zack Barresse
  - Re: Picking up the latest text value in a column, Rick Rothstein $MVP - VB$
    - Re: Picking up the latest text value in a column, Zack Barresse
    - Re: Picking up the latest text value in a column, djmagcruznyc
  - Re: Picking up the latest text value in a column, djmagcruznyc
add a cell reference to the start of a formula, h.
- RE: add a cell reference to the start of a formula, Bob Umlas, Excel MVP
  - RE: add a cell reference to the start of a formula, h.
    - Re: add a cell reference to the start of a formula, T. Valko
Vlookup, keydet1979
- Re: Vlookup, T. Valko
- <Possible follow-ups>
- vlookup, jhnewyork
- vlookup, TAK
  - Re: vlookup, Pete_UK
    - Re: vlookup, TAK
    - Re: vlookup, Pete_UK
    - Re: vlookup, TAK
    - Re: vlookup, Pete_UK
    - Re: vlookup, TB
    - Re: vlookup, T. Valko
    - Re: vlookup, Pete_UK
- VLOOKUP, Connie Martin
  - Re: VLOOKUP, Pete_UK
    - Re: VLOOKUP, Connie Martin
    - Re: VLOOKUP, Pete_UK
    - Re: VLOOKUP, Connie Martin
    - Re: VLOOKUP, Pete_UK
- vlookup, Dale G
  - Re: vlookup, Max
- VLOOKUP, AP
  - RE: VLOOKUP, ryguy7272
    - RE: VLOOKUP, AP
IF Statement not working, Barrett M
- RE: IF Statement not working, Dave
  - RE: IF Statement not working, Barrett M
    - RE: IF Statement not working, Barrett M
    - Re: IF Statement not working, Spiky
    - Re: IF Statement not working, David Biddulph
    - Re: IF Statement not working, Barrett M
    - Re: IF Statement not working, David Biddulph
    - Re: IF Statement not working, Barrett M
Extract Text, Peanut
- Re: Extract Text, Reitanos
  - Re: Extract Text, Peanut
- Re: Extract Text, Ron Rosenfeld
Help with IF function, Nina
- Re: Help with IF function, Gaurav
- RE: Help with IF function, Mike H
- RE: Help with IF function, Dave
Formatting and adding cells formatted to 2 decimal places, Colin
- RE: Formatting and adding cells formatted to 2 decimal places, Dave
- RE: Formatting and adding cells formatted to 2 decimal places, Mike H
- Re: Formatting and adding cells formatted to 2 decimal places, Gord Dibben
Find matching data in two workbooks, franklinbukoski
- Re: Find matching data in two workbooks, Spiky
Filter by Top 10 doesn't work, Indiana Jones
- Re: Filter by Top 10 doesn't work, Peo Sjoblom
Cal Bal Hr & Min, TSK
- Re: Cal Bal Hr & Min, Peo Sjoblom
compare two lists, lark
- RE: compare two lists, Dave
  - Re: compare two lists, lark
    - Re: compare two lists, Dave
Sumproduct #Value! Problem, deeds
- Re: Sumproduct #Value! Problem, Peo Sjoblom
  - Re: Sumproduct #Value! Problem, deeds
    - Re: Sumproduct #Value! Problem, Peo Sjoblom
    - Re: Sumproduct #Value! Problem, deeds
- Re: Sumproduct #Value! Problem, PCLIVE
  - Re: Sumproduct #Value! Problem, deeds
- Re: Sumproduct #Value! Problem, Dave Peterson
  - Re: Sumproduct #Value! Problem, deeds
Upgrade from 2002 to 2007, W Wolfe
- Re: Upgrade from 2002 to 2007, Gord Dibben
  - Re: Upgrade from 2002 to 2007, W Wolfe
    - Re: Upgrade from 2002 to 2007, Gord Dibben
    - Re: Upgrade from 2002 to 2007, W Wolfe
How to set macro to Paste Special Value to next empty column, tottigoh781
- Re: How to set macro to Paste Special Value to next empty column, Don Guillett
  - Re: How to set macro to Paste Special Value to next empty column, tottigoh781
    - Re: How to set macro to Paste Special Value to next empty column, Don Guillett
    - Re: How to set macro to Paste Special Value to next empty column, tottigoh781
    - Re: How to set macro to Paste Special Value to next empty column, Don Guillett
    - Re: How to set macro to Paste Special Value to next empty column, tottigoh781
    - Re: How to set macro to Paste Special Value to next empty column, Max
    - Re: How to set macro to Paste Special Value to next empty column, Don Guillett
    - Re: How to set macro to Paste Special Value to next empty column, Max
Re: countif two columns two criteria, Gaurav
- Re: countif two columns two criteria, Doris
  - Re: countif two columns two criteria, Gaurav
    - Re: countif two columns two criteria, Doris
    - Re: countif two columns two criteria, Gaurav
    - Re: countif two columns two criteria, Doris
How do I format cell to 0.25 resolution?, Bugman
- Re: How do I format cell to 0.25 resolution?, Gaurav
- RE: How do I format cell to 0.25 resolution?, Mike H
- Re: How do I format cell to 0.25 resolution?, David Biddulph
Validation_List_Formula (not sure how to title this post), Kimmie40
- Re: Validation_List_Formula (not sure how to title this post), Kimmie40
  - Re: Validation_List_Formula (not sure how to title this post), condevlj
Fourier Analysis, ismae
Project days allocation (better mail format), dumbaswood
- Re: Project days allocation (better mail format), Tushar Mehta (Microsoft MVP Excel 2000-2008)
  - Re: Project days allocation (better mail format), dumbaswood
    - Re: Project days allocation (better mail format), Tushar Mehta (Microsoft MVP Excel 2000-2008)
Project days allocation, dumbaswood
- Re: Project days allocation, Tushar Mehta (Microsoft MVP Excel 2000-2008)
compare 2 spreadsheets, jono
What is the formula to calculate electricity consumption, TSK
- RE: What is the formula to calculate electricity consumption, Mike H
- Re: What is the formula to calculate electricity consumption, David Biddulph
  - Re: What is the formula to calculate electricity consumption, Mike H
    - Re: What is the formula to calculate electricity consumption, David Biddulph
vlookup i think?, jono
- RE: vlookup i think?, Mike H
Re: Excel file too big even when I delete all cells, Daniel Cheng
- Re: Excel file too big even when I delete all cells, Gord Dibben
- Re: Excel file too big even when I delete all cells, Spiky
  - Thanks, Kannan Seetha
Set value to zero when result is 0 otherwise show actual value, TSK
- Re: Set value to zero when result is 0 otherwise show actual value, Pete_UK
- RE: Set value to zero when result is 0 otherwise show actual value, Gary''s Student
  - RE: Set value to zero when result is 0 otherwise show actual value, TSK
    - Re: Set value to zero when result is 0 otherwise show actual value, Pete_UK
    - RE: Set value to zero when result is 0 otherwise show actual value, Gary''s Student
Excel cannot complete this task with available resources., Ali
- RE: Excel cannot complete this task with available resources., Ali
How to set the value to zero if it negative after the substract, TSK
- Re: How to set the value to zero if it negative after the substract, Rick Rothstein $MVP - VB$
  - Re: How to set the value to zero if it negative after the substrac, TSK
    - Re: How to set the value to zero if it negative after the substrac, Rick Rothstein $MVP - VB$
    - How convert to hours & minutes, TSK
    - Re: How convert to hours & minutes, David Biddulph
    - How to calculate balance of hour and mintue, TSK
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0, tiffa
- Re: how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0, Rick Rothstein $MVP - VB$
- Re: how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0, MartinW
  - Re: how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0, Bernd P
    - Re: how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0, MartinW
DATE function, Learn-more
- Re: DATE function, Rick Rothstein $MVP - VB$
- Re: DATE function, Ron Rosenfeld
  - Re: DATE function, Rick Rothstein $MVP - VB$
    - Re: DATE function, Ron Rosenfeld
- RE: DATE function, Learn-more
Annual Wages Sheet to pick up info from Time Sheet, stallence
- Re: Annual Wages Sheet to pick up info from Time Sheet, Pete_UK
  - Re: Annual Wages Sheet to pick up info from Time Sheet, stallence
Re: Count and/or sum data within a date span., roy.okinawa
- Re: Count and/or sum data within a date span., Spiky
IF statement help, Jena
- Re: IF statement help, T. Valko
  - Re: IF statement help, inews
  - Re: IF statement help, Jena
    - Re: IF statement help, T. Valko
- Re: IF statement help, inews
RE: How to set minus value to 0, TSK
- Re: How to set minus value to 0, Arvi Laanemets
  - Re: How to set minus value to 0, TSK
    - Re: How to set minus value to 0, David Biddulph
    - Re: How to set minus value to 0, TSK
    - Re: How to set minus value to 0, Arvi Laanemets
"Labels as Names" stopped working, inews
- Re: "Labels as Names" stopped working, inews
- Re: "Labels as Names" stopped working, inews
If statement working only once, Lime
Finding & Replacing a list of Data in Multiple Columns, Me
- Re: Finding & Replacing a list of Data in Multiple Columns, Pete_UK
Trig Function seems odd., Ken McLennan
- Re: Trig Function seems odd., Ken McLennan
  - Re: Trig Function seems odd., Rick Rothstein $MVP - VB$
    - Re: Trig Function seems odd., Ken McLennan
- Re: Trig Function seems odd., Rick Rothstein $MVP - VB$
  - Re: Trig Function seems odd., Ken McLennan
- Re: Trig Function seems odd., David Biddulph
  - Re: Trig Function seems odd., Ken McLennan
    - Re: Trig Function seems odd., David Biddulph
    - Re: Trig Function seems odd., Ken McLennan
i just want to allocate $ by month, for many projects, dumbaswood
fill data automatically into another worksheet, ema
- Re: fill data automatically into another worksheet, robzrob
- Re: fill data automatically into another worksheet, Gord Dibben
work only with value without updating, mh_amri
- Re: work only with value without updating, Max
- Re: work only with value without updating, Jim Cone
Re: Calculating STDEV and other Calcs based on another cells value, T. Valko
- Re: Calculating STDEV and other Calcs based on another cells value, Scott
  - Re: Calculating STDEV and other Calcs based on another cells value, T. Valko
Formula help, Patrick C. Simonds
- Re: Formula help, T. Valko
- <Possible follow-ups>
- Formula help, balterson
  - Re: Formula help, JE McGimpsey
  - Re: Formula help, Gord Dibben
    - Re: Formula help, Gord Dibben
Standardizing Street Addresses in a Large Address Database, ambracat
- Re: Standardizing Street Addresses in a Large Address Database, Ron Rosenfeld
conditional statistics, PeSt
- Re: conditional statistics, ambracat
- Re: conditional statistics, Jim Cone
- Re: conditional statistics, Bernard Liengme
Value look up, Batshon
- Re: Value look up, Pete_UK
username, robzrob
- RE: username, Gary''s Student
- Re: username, Gord Dibben
Web-Based Time and Leave Software, liukaiyuan
Concatenation, JPS
- Re: Concatenation, T. Valko
  - Re: Concatenation, JPS
    - Re: Concatenation, T. Valko
- <Possible follow-ups>
- Concatenation, ATHER
  - Re: Concatenation, Don Guillett
  - Re: Concatenation, David Biddulph
Adding Values, Sandy
- Re: Adding Values, Jim Cone
- Re: Adding Values, Rick Rothstein $MVP - VB$
- RE: Adding Values, Sandy
Lookup order, Nordic
- Re: Lookup order, Jim Cone
- Re: Lookup order, Gord Dibben
Certain Cells Appearing, cts
- Re: Certain Cells Appearing, T. Valko
  - Re: Certain Cells Appearing, cts
- Re: Certain Cells Appearing, Jim Cone
  - Re: Certain Cells Appearing, cts
Vlookup or match function?, Belinda7237
- Re: Vlookup or match function?, T. Valko
  - Re: Vlookup or match function?, Belinda7237
  - Re: Vlookup or match function?, Belinda7237
    - Re: Vlookup or match function?, T. Valko
    - Re: Vlookup or match function?, T. Valko
    - Re: Vlookup or match function?, Belinda7237
Search Formula to collate BOM Data, Peter C
- Re: Search Formula to collate BOM Data, H�ctor Miguel
  - Re: Search Formula to collate BOM Data, Peter C
- Re: Search Formula to collate BOM Data, Herbert Seidenberg
I can't autofill cells in a column if blank cells in between, SJ
- Re: I can't autofill cells in a column if blank cells in between, Ken Johnson
Lookup text in 1 column and make notations in another, Nordic
- Re: Lookup text in 1 column and make notations in another, Gord Dibben
strange happenings with move/copy worksheet, Don
- Re: strange happenings with move/copy worksheet, Gord Dibben
Freeze Column, ManhattanRebel
- RE: Freeze Column, cmart02
- Re: Freeze Column, Rick Rothstein $MVP - VB$
  - Re: Freeze Column, ManhattanRebel
    - Re: Freeze Column, Rick Rothstein $MVP - VB$
- Re: Freeze Column, Gord Dibben
Lookup text in 1 column and note it in another, Nordic
- Re: Lookup text in 1 column and note it in another, Peo Sjoblom
RE: Spreadsheet refresh time. . ., Doris
- Re: Spreadsheet refresh time. . ., Don Guillett
string manipulation, pulling out last name from column, ap
- Re: string manipulation, pulling out last name from column, Rick Rothstein $MVP - VB$
- RE: string manipulation, pulling out last name from column, Teethless mama
- Re: string manipulation, pulling out last name from column, ap
  - Re: string manipulation, pulling out last name from column, Teethless mama
- Re: string manipulation, pulling out last name from column, ap
  - Re: string manipulation, pulling out last name from column, Teethless mama
- Re: string manipulation, pulling out last name from column, Ron Rosenfeld
Blinking text, somaloft
- RE: Blinking text, Gary''s Student
Comparing Data, henriques
- RE: Comparing Data, Tanya
- RE: Comparing Data, henriques
  - Re: Comparing Data, Max
How do I past data into the Find and Replace box Excel 2003?, Cpence
- Re: How do I past data into the Find and Replace box Excel 2003?, Max
how to align text to 45 angle without angale boarders, asa
- RE: how to align text to 45 angle without angale boarders, Tanya
- Re: how to align text to 45 angle without angale boarders, David Biddulph
  - Re: how to align text to 45 angle without angale boarders, Gord Dibben
a few condition, teratak
- RE: a few condition, Kassie
- Re: a few condition, Nozza
- Message not available
  - Re: a few condition, Dave
- RE: a few condition, Teethless mama
- RE: a few condition, BoniM
Copying formula to sum multiple columns, Kathy
- Re: Copying formula to sum multiple columns, T. Valko
  - Re: Copying formula to sum multiple columns, Kathy
    - Re: Copying formula to sum multiple columns, T. Valko
basic opertors, Tanya
- Re: basic opertors, T. Valko
  - Re: basic opertors, H�ctor Miguel
    - Re: basic opertors, Tanya
    - Re: basic opertors, H�ctor Miguel
    - Re: basic opertors, Tanya
    - Re: basic opertors, H�ctor Miguel
    - Re: basic opertors, Tanya
    - Re: basic opertors, H�ctor Miguel
  - Re: basic opertors, Tanya
    - Re: basic opertors, T. Valko
Two subjects: Column sort and True/False in cell, dilynn17
- Re: Two subjects: Column sort and True/False in cell, T. Valko
  - Re: Two subjects: Column sort and True/False in cell, dilynn17
    - Re: Two subjects: Column sort and True/False in cell, Tanya
Guidance/Help to Highlight Cell contentts Based on Min/Max, Vince
- Re: Guidance/Help to Highlight Cell contentts Based on Min/Max, Pete_UK
  - Re: Guidance/Help to Highlight Cell contentts Based on Min/Max, Tanya
I tried to get around the problem of the pivot table field setting defaulting to Count instead of Sum by running a macro of change the setting from Count to Sum. However, when I tried to run the Macro, I got error message of run time error 1004, unable to get the pivot fields property of the pivot field class., Enda80
- Re: I tried to get around the problem of the pivot table field setting defaulting to Count instead of Sum by running a macro of change the setting from Count to Sum. However, when I tried to run the Macro, I got error message of run time error 1004, unable, Fred Smith
Need Help: Multiple Criteria, Chris McKenzie
- Re: Need Help: Multiple Criteria, Pete_UK
  - Re: Need Help: Multiple Criteria, Chris McKenzie
    - Re: Need Help: Multiple Criteria, Pete_UK
Re: In Excel, conditional format (font red) referencing another ce, Please explain more specifically
- Re: In Excel, conditional format (font red) referencing another ce, Gord Dibben
  - Re: In Excel, conditional format (font red) referencing another ce, Steve
    - Re: In Excel, conditional format (font red) referencing another ce, T. Valko
lock cells, John R
- Re: lock cells, Gord Dibben
  - Re: lock cells, Dave
    - Re: lock cells, Gord Dibben
    - Re: lock cells, Dave Peterson
    - Re: lock cells, Dave
check if an entry is a multiple of another cell, JMM
- RE: check if an entry is a multiple of another cell, Mike H
  - Re: check if an entry is a multiple of another cell, Jerome
- Re: check if an entry is a multiple of another cell, JE McGimpsey
  - Re: check if an entry is a multiple of another cell, Jerome
Copy from another sheet, cottage6
- Re: Copy from another sheet, Max
- Re: Copy from another sheet, Gord Dibben
  - Re: Copy from another sheet, cottage6
"Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas, Exceller
extract data from one worksheet to another worksheet, Jeff
- Re: extract data from one worksheet to another worksheet, Peo Sjoblom
- Re: extract data from one worksheet to another worksheet, Reitanos
  - Re: extract data from one worksheet to another worksheet, Reitanos
- Re: extract data from one worksheet to another worksheet, Max
- RE: extract data from one worksheet to another worksheet, Teethless mama
math formulaes arent working in excel, Russ Johnson
- Re: math formulaes arent working in excel, Niek Otten
- RE: math formulaes arent working in excel, Mike H
- Re: math formulaes arent working in excel, Reitanos
Excel Typing, Dutch
- Re: Excel Typing, Reitanos
  - Re: Excel Typing, Dutch
- Re: Excel Typing, Gaurav
  - Re: Excel Typing, Dutch
QP formulas not working in Excel, Westech
- Re: QP formulas not working in Excel, Spiky
  - Re: QP formulas not working in Excel, Westech
count text entries, pja
- RE: count text entries, ryguy7272
  - RE: count text entries, pja
    - RE: count text entries, Dave
    - Re: count text entries, Gord Dibben
Find the lowest value in a row, jlo
- RE: Find the lowest value in a row, ryguy7272
- RE: Find the lowest value in a row, Mike H
date computing and sum issues, lampatmyfeet
- Re: date computing and sum issues, Pete_UK
  - Re: date computing and sum issues, lampatmyfeet
    - Re: date computing and sum issues, Pete_UK
- RE: date computing and sum issues, kathi
  - Re: date computing and sum issues, Pete_UK
Average # in total group with multiple criteria?, Jonathan
- RE: Average # in total group with multiple criteria?, ryguy7272
  - RE: Average # in total group with multiple criteria?, Jonathan
    - RE: Average # in total group with multiple criteria?, ryguy7272
    - RE: Average # in total group with multiple criteria?, Jonathan
- RE: Average # in total group with multiple criteria?, Teethless mama
  - Re: Average # in total group with multiple criteria?, Domenic
Need VBA script to auto-insert value upon row insert, Phil
- Re: Need VBA script to auto-insert value upon row insert, Otto Moehrbach
  - Re: Need VBA script to auto-insert value upon row insert, Phil
    - Re: Need VBA script to auto-insert value upon row insert, Otto Moehrbach
- Re: Need VBA script to auto-insert value upon row insert, Otto Moehrbach
Inserting blank rows for missing data in order to transpose, jmhorne
- Re: Inserting blank rows for missing data in order to transpose, Otto Moehrbach
  - Re: Inserting blank rows for missing data in order to transpose, jmhorne
    - Re: Inserting blank rows for missing data in order to transpose, Otto Moehrbach
Return Time for Duplicate Files & Times, Mayte
- Re: Return Time for Duplicate Files & Times, Bob Phillips
  - Re: Return Time for Duplicate Files & Times, Mayte
    - Re: Return Time for Duplicate Files & Times, Bob Phillips
    - Re: Return Time for Duplicate Files & Times, Mayte
conditional format, day of month, Amber
- Re: conditional format, day of month, Reitanos
RE: How do I add a portion of a day to a date?, notanexcelguru
Look-up and Merge, Michael D
- RE: Look-up and Merge, Teethless mama
  - RE: Look-up and Merge, ryguy7272
Pdf hyperlink not opening in excel worksheet - nothing appears., Yaser
- Re: Pdf hyperlink not opening in excel worksheet - nothing appears., Dave Peterson
how do I add portion of days for scheduling, notanexcelguru
- RE: how do I add portion of days for scheduling, ryguy7272
3 months prior and 3 months post a date, renee
- RE: 3 months prior and 3 months post a date, Mike H
- Re: 3 months prior and 3 months post a date, Bob Phillips
Sum a different number of items, mr tom
- Re: Sum a different number of items, Bob Phillips
  - Re: Sum a different number of items, mr tom
- Re: Sum a different number of items, T. Valko
  - Re: Sum a different number of items, mr tom
    - Re: Sum a different number of items, T. Valko
Re: Return horizontal and vertical values, karl
- Re: Return horizontal and vertical values, T. Valko
Formula within a formula, CSmith
transpoe with formulas, dragomira
- RE: transpoe with formulas, ryguy7272
- Message not available
  - Re: transpoe with formulas, dragomira
    - Re: transpoe with formulas, Gord Dibben
formula to compose a list of values, PeSt
- RE: formula to compose a list of values, Gary''s Student
- RE: formula to compose a list of values, Teethless mama
LOOKUP, Connie Martin
- Re: LOOKUP, Pete_UK
- Re: LOOKUP, T. Valko
- RE: LOOKUP, Connie Martin
  - Re: LOOKUP, T. Valko
  - Re: LOOKUP, Pete_UK
- <Possible follow-ups>
- Re: LookUp, Spiky
Re: How to transpose linked data and keep it linked?, dragomira
Comparing info on 2 spreadsheets, Jenn
- RE: Comparing info on 2 spreadsheets, ryguy7272
Maximum characters in cell, atvandle
- Re: Maximum characters in cell, Peo Sjoblom
  - Re: Maximum characters in cell, atvandle
Help with credit Limit Summary, Robin
- Re: Help with credit Limit Summary, aidan.heritage@xxxxxxxxxx
Edit Replace the third digit only of a number, Hammertime
- RE: Edit Replace the third digit only of a number, Dennis
- Re: Edit Replace the third digit only of a number, Max
- Re: Edit Replace the third digit only of a number, JE McGimpsey
RE: changing date format, util
- Re: changing date format, Fred Smith
- Re: changing date format, Gord Dibben
Re: Pivot Table - How to Set and Preserve my Formating for all future pivots, Negda
freeze frames button inactive, woody
- Re: freeze frames button inactive, Reitanos
  - Re: freeze frames button inactive, woody
    - Re: freeze frames button inactive, Gord Dibben
MONTH, Connie Martin
- Re: MONTH, Reitanos
- Re: MONTH, Max
- Re: MONTH, Peo Sjoblom
- RE: MONTH, Connie Martin
  - Re: MONTH, Peo Sjoblom
Insert rows based on value per day, Mayte
- RE: Insert rows based on value per day, Mayte
- RE: Insert rows based on value per day, ryguy7272
Condition format a row based on a formula, Tysmema
- <Possible follow-ups>
- Condition format a row based on a formula, Tysmema
  - Re: Condition format a row based on a formula, Max
  - Re: Condition format a row based on a formula, Cimjet
Concatenate numbers, Colin G
- Re: Concatenate numbers, Pete_UK
  - Re: Concatenate numbers, Colin G
    - Re: Concatenate numbers, Spiky
- Re: Concatenate numbers, Ron Rosenfeld
  - Re: Concatenate numbers, Colin G
    - Re: Concatenate numbers, Spiky
    - Re: Concatenate numbers, Ron Rosenfeld
nested functions using insert function, Annie
- Re: nested functions using insert function, Bob Phillips
Using List details within a sum, forevertrying
- Re: Using List details within a sum, Bob Phillips
  - Re: Using List details within a sum, forevertrying
    - Re: Using List details within a sum, Bob Phillips
    - Re: Using List details within a sum, forevertrying
    - Re: Using List details within a sum, Bob Phillips
if condition doubt, deen
- RE: if condition doubt, Mike H
- Re: if condition doubt, Spiky
how to add new items to a list, peter pan
- RE: how to add new items to a list, Gary''s Student
- Re: how to add new items to a list, Ken Johnson
macros over different sheets, Robb.rich
- RE: macros over different sheets, Gary''s Student
Change value of cell automatically if entered the wrong number, Pair_of_Scissors
- RE: Change value of cell automatically if entered the wrong number, Mike H
  - RE: Change value of cell automatically if entered the wrong number, Mike H
    - RE: Change value of cell automatically if entered the wrong number, Pair_of_Scissors
    - RE: Change value of cell automatically if entered the wrong number, Pair_of_Scissors
    - Re: Change value of cell automatically if entered the wrong number, Gord Dibben
    - Re: Change value of cell automatically if entered the wrong number, Pair_of_Scissors
    - Re: Change value of cell automatically if entered the wrong number, Pair_of_Scissors
Help to pick string value if match happens, Eddy Stan
- Re: Help to pick string value if match happens, Dave Peterson
How to determine the values?, Eric
- Re: How to determine the values?, H�ctor Miguel
  - Re: How to determine the values?, Eric
    - Re: How to determine the values?, H�ctor Miguel
    - Re: How to determine the values?, Lori
    - Re: How to determine the values?, Eric
    - Re: How to determine the values?, Lori
Why has my mouse pointer response slowed to a crawl speed ?, Roddyman
- RE: Why has my mouse pointer response slowed to a crawl speed ?, ryguy7272
pulling data in rows!, via135
- RE: pulling data in rows!, Teethless mama
  - RE: pulling data in rows!, ryguy7272
    - Re: pulling data in rows!, via135
    - Re: pulling data in rows!, via135
- RE: pulling data in rows!, yshridhar
Calculate interest between two date ranges, Legal Learning
- Re: Calculate interest between two date ranges, Fred Smith
  - Re: Calculate interest between two date ranges, Legal Learning
    - Re: Calculate interest between two date ranges, Fred Smith
    - Re: Calculate interest between two date ranges, Legal Learning
Sum results from 2 columns that meet criteria, Laura Larson
- RE: Sum results from 2 columns that meet criteria, Teethless mama
Average highest 16 numbers on a column of 32 numbers, Frank
- Re: Average highest 16 numbers on a column of 32 numbers, Max
- Re: Average highest 16 numbers on a column of 32 numbers, Ron Rosenfeld
- RE: Average highest 16 numbers on a column of 32 numbers, Teethless mama
OLAP Pivot Table returns #N/A for custom calc., VPDan
Is It False ??, Gary''s Student
- Re: Is It False ??, Fred Smith
- Message not available
  - Re: Is It False ??, Gary''s Student
- RE: Is It False ??, Teethless mama
Move data from one worksheet to another., JCreationBoy
- Re: Move data from one worksheet to another., Gaurav
Multiple formats in a single cell with multiple formulas, Zakhary
Flipping Names in same cell, Raymie Younkin
- Re: Flipping Names in same cell, Don Guillett
convert length of time to minutes from hundreths, JICDB
- Re: convert length of time to minutes from hundreths, Peo Sjoblom
  - Re: convert length of time to minutes from hundreths, JICDB
Please Help with complicated SUM formula, mrl
- Re: Please Help with complicated SUM formula, Gaurav
  - Re: Please Help with complicated SUM formula, mrl
    - Re: Please Help with complicated SUM formula, Gaurav
- Re: Please Help with complicated SUM formula, RagDyer
  - Re: Please Help with complicated SUM formula, mrl
Formula Problem, gwolfe
- RE: Formula Problem, JLatham
  - RE: Formula Problem, gwolfe
  - RE: Formula Problem, JLatham
- <Possible follow-ups>
- Formula problem, Joyce
  - Re: Formula problem, Bob Phillips
  - Re: Formula problem, Gaurav
- Formula problem, GVegas
Find the number of the lowest filled row, Roberto Villa Real
- Re: Find the number of the lowest filled row, RagDyer
  - Re: Find the number of the lowest filled row, T. Valko
    - Re: Find the number of the lowest filled row, RagDyeR
How do I restore the ability to see shading on screen?, bill50
- Re: How do I restore the ability to see shading on screen?, Gord Dibben
What is the difference between relative and absolute cell referenc, Heather
- RE: What is the difference between relative and absolute cell referenc, ryguy7272
- RE: What is the difference between relative and absolute cell referenc, Mike H
- Re: What is the difference between relative and absolute cell referenc, Gord Dibben
Productivity, Michelle
- RE: Productivity, ryguy7272
beginners help..., Daniela
- RE: beginners help..., ryguy7272
- Re: beginners help..., Herbert Seidenberg
Countif with multiple criteria, bradsalmon
- Re: Countif with multiple criteria, Dave Peterson
- Re: Countif with multiple criteria, Bob Phillips
- Re: Countif with multiple criteria, bradsalmon
  - Re: Countif with multiple criteria, Pete_UK
  - Re: Countif with multiple criteria, Dave Peterson
finding last number in row excluding 0's, Joe
- Re: finding last number in row excluding 0's, Peo Sjoblom
- RE: finding last number in row excluding 0's, Tom Hutchins
- Re: finding last number in row excluding 0's, T. Valko
  - Re: finding last number in row excluding 0's, Bob Phillips
    - Re: finding last number in row excluding 0's, T. Valko
    - Re: finding last number in row excluding 0's, Joe
    - Re: finding last number in row excluding 0's, Ron Rosenfeld
Vlookup with the result being once cell below the orginal value, Alex
- Re: Vlookup with the result being once cell below the orginal value, Peo Sjoblom
- Re: Vlookup with the result being once cell below the orginal value, Don Guillett
- Re: Vlookup with the result being once cell below the orginal value, T. Valko
how to auto calculate difference between cells like c1=a1-b1, Jill
- RE: how to auto calculate difference between cells like c1=a1-b1, Gary''s Student
- Re: how to auto calculate difference between cells like c1=a1-b1, Gaurav
Insert a cell as part of a if/then function in Excel?, Cyndy
- Re: Insert a cell as part of a if/then function in Excel?, David Biddulph
Indirect function, Libby
- Re: Indirect function, Dave Peterson
  - Re: Indirect function, Libby
    - Re: Indirect function, Dave Peterson
Re: xirr #N/A, Terry McCoy
- Re: xirr #N/A, Terry McCoy
3D reference question in inventory Worksheet, Chef Bob
how do I add another item to an existing drop down., Rosalie Andrews
- Re: how do I add another item to an existing drop down., Reitanos
Re: PICalcDat function results in #NAME?. How do I fix this?, TDS
Change Boolean / Logical Operator using Input Cell, Sam via OfficeKB.com
- Message not available
  - Re: Change Boolean / Logical Operator using Input Cell, Sam via OfficeKB.com
Re: SUMPRODUCT excluding multiple conditions, tmwilkin
Adding days to a date cell to get a new date, Pete Derkowski
- Re: Adding days to a date cell to get a new date, Bob Phillips
  - Re: Adding days to a date cell to get a new date, Pete Derkowski
    - Re: Adding days to a date cell to get a new date, Rick Rothstein $MVP - VB$
- RE: Adding days to a date cell to get a new date, ryguy7272
  - Re: Adding days to a date cell to get a new date, Pete Derkowski
    - Re: Adding days to a date cell to get a new date, Peo Sjoblom
RE: renumber automatically, JICDB
If function with Another Function, Alex
- Re: If function with Another Function, Bob Phillips
- RE: If function with Another Function, ryguy7272
  - Re: If function with Another Function, Rick Rothstein $MVP - VB$
Chart with two series, one high, one low, nathan_savidge
- Re: Chart with two series, one high, one low, David Biddulph
  - Re: Chart with two series, one high, one low, ryguy7272
Help Wanted, Shiblie Bshara
- Re: Help Wanted, David Biddulph
formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!, Coolchick
- RE: formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!, Mike H
- Re: formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!, Niek Otten
- Re: formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!, David Biddulph
Data Grand Total in Pivot Table Row Area, stuart62
- RE: Data Grand Total in Pivot Table Row Area, ryguy7272
Adjusting numbers to nearest preferred number, BRob
- Re: Adjusting numbers to nearest preferred number, Niek Otten
lige uger i excelformel, Frode
- Re: lige uger i excelformel, Per Jessen
Re: Pivot Table, Roger Govier
- <Possible follow-ups>
- RE: Pivot Table, nathan_savidge
- Re: pivot table, Fred Smith
Checking values in 2 columns, BRob
- RE: Checking values in 2 columns, Mike H
- Re: Checking values in 2 columns, Rick Rothstein $MVP - VB$
  - Re: Checking values in 2 columns, ryguy7272
Re: Complicated working days function, Bob Phillips
Sumif 2 criteria - 1 in a Row and 1 in a Column, Qicea
- RE: Sumif 2 criteria - 1 in a Row and 1 in a Column, Mike H
  - RE: Sumif 2 criteria - 1 in a Row and 1 in a Column, Qicea
Formula for cell to get information from other worksheets, new2excel
- Re: Formula for cell to get information from other worksheets, Bob Phillips
Total Dollar Amounts From Different Worksheet, roy.okinawa
- Re: Total Dollar Amounts From Different Worksheet, Bob Phillips
  - Re: Total Dollar Amounts From Different Worksheet, roy.okinawa
    - Re: Total Dollar Amounts From Different Worksheet, roy.okinawa
    - Re: Total Dollar Amounts From Different Worksheet, Bob Phillips
    - Re: Total Dollar Amounts From Different Worksheet, roy.okinawa
Date Function to include a day and automatically updated each new, Kula
- RE: Date Function to include a day and automatically updated each new, Kula
Re: Populate Cell with another cell, but only if the date equals t, GaryS
- <Possible follow-ups>
- RE: Populate Cell with another cell, but only if the date equals t, GaryS
Adding Data from Date Range base on relative dates, GaryS
- Re: Adding Data from Date Range base on relative dates, Max
Sum based upon matching data in different columns, Stan
- Re: Sum based upon matching data in different columns, T. Valko
Re: Number of vehicles, Kula
- Re: Number of vehicles, Max
How can I use a UDF in a SUM Function?, MrFez
- RE: How can I use a UDF in a SUM Function?, Dave
- Re: How can I use a UDF in a SUM Function?, Bob Phillips
Linking two worksheets, Sam
- Re: Linking two worksheets, Roger Govier
  - Re: Linking two worksheets, Sam
    - Re: Linking two worksheets, Roger Govier
Re: Excel 7.0 - removing duplicates, Bernard Liengme
- Re: Excel 7.0 - removing duplicates, wonderbug
  - Re: Excel 7.0 - removing duplicates, Peo Sjoblom
    - Re: Excel 2007 - removing duplicates, wonderbug
How do I create a formula in excel to multiply two items from two, Liz
- Re: How do I create a formula in excel to multiply two items from two, David Biddulph
  - Re: How do I create a formula in excel to multiply two items from, Liz
    - Re: How do I create a formula in excel to multiply two items from, David Biddulph
Re: Sum Problem requiring help, NoodNutt
- Re: Sum Problem requiring help, Pete_UK
  - Re: Sum Problem requiring help, Spiky
Match() worksheet function, WCM
- Re: Match() worksheet function, T. Valko
  - Re: Match() worksheet function, WCM
    - Re: Match() worksheet function, T. Valko
    - Re: Match() worksheet function, WCM
    - Re: Match() worksheet function, T. Valko
    - Re: Match() worksheet function, WCM
    - Re: Match() worksheet function, T. Valko
    - Re: Match() worksheet function, WCM
    - Re: Match() worksheet function, T. Valko
    - Re: Match() worksheet function, WCM
Printing a page from a cell, bnwash
Re: Need help!, Pete_UK
Excel into executable, MrBT
- Re: Excel into executable, T. Valko
- RE: Excel into executable, FSt1
Re: Run a macro when clicking a cell., Gord Dibben
- Re: Run a macro when clicking a cell., kevroden
  - Re: Run a macro when clicking a cell., Gord Dibben
    - Re: Run a macro when clicking a cell., kevroden
    - Re: Run a macro when clicking a cell., Gord Dibben
    - Re: Run a macro when clicking a cell., kevroden
Re: Address List, Gord Dibben
Re: Unprotecting an Excel Spreadsheet, Gord Dibben
- <Possible follow-ups>
- Re: Unprotecting an Excel Spreadsheet, Pete_UK
  - Re: Unprotecting an Excel Spreadsheet, Annie
Re: HOW DO I PRINT CONFIDENTIAL IN THE WORKSHEET, Gord Dibben
Re: Data Validation Drop Down List Question., Gord Dibben
Re: Match Multiple Columns, phuser
- Re: Match Multiple Columns, Pete_UK
  - Re: Match Multiple Columns, phuser
    - Re: Match Multiple Columns, phuser
  - Re: Match Multiple Columns, phuser
    - Re: Match Multiple Columns, phuser
Re: calculation problem, Pete_UK
Formating cells, Adrian
- RE: Formating cells, DazzaData
  - RE: Formating cells, Adrian
- Re: Formating cells, Rick Rothstein $MVP - VB$
  - Re: Formating cells, Adrian
- Re: Formating cells, Gord Dibben
  - Re: Formating cells, Adrian
Re: format function, Spiky
- Re: format function, fhl
- Re: format function, Gord Dibben
  - Re: format function, fhl
    - Re: format function, Meebers
    - Re: format function, fhl
    - Re: format function, Gord Dibben
    - Re: format function, Spiky
Re: excel formula, Spiky
Re: Drop Down List - Select Multiple Items, VLH
- <Possible follow-ups>
- Re: Drop Down List - Select Multiple Items, Gord Dibben
  - Re: Drop Down List - Select Multiple Items, VLH
    - Re: Drop Down List - Select Multiple Items, Gord Dibben