microsoft.public.excel.worksheet.functions
- Re: Combining data from multiple workbooks
- Re: Dates - Need to display date one month prior to user-entered date
- RE: adding and subracting credits
- Re: Why are blanks being ignored by my MIN function?
- Re: In Excel: Time Entering
- Re: In Excel: Time Entering
- Re: Dates - Need to display date one month prior to user-entered date
- Re: I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER
- Re: Variable Ranges
- Re: Why are blanks being ignored by my MIN function?
- Re: Finding the longest sequence of 0's in a row
- Re: links to a second workbook doesn't work if origin not open
- Re: Why are blanks being ignored by my MIN function?
- Number of non-zero values in a column
- Re: if format problem
- Re: conditional formatting
- Re: Finding the longest sequence of 0's in a row
- Re: Conditional Formatting option "Grayed Out"
- Re: if format problem
- Re: Conditional Formatting option "Grayed Out"
- Re: if format problem
- Re: Finding the longest sequence of 0's in a row
- Re: if format problem
- Re: How can I add down a list a specified number of cells?
- Re: if format problem
- Re: Finding the longest sequence of 0's in a row
- Re: Finding the longest sequence of 0's in a row
- Re: Create "other" filter
- Re: WORKDAY
- Re: Create "other" filter
- Re: Multiple conditions
- Re: How do I keep the "tab" key from jumping over adjacent cell
- Re: create a formula to produce a color in excel
- Re: How to time-limit an Excel file installation
- Re: if format problem
- Re: Create "other" filter
- Re: COUNTIF/SUMIF comparing two rows of data
- Re: Create "other" filter
- Re: How do I keep the "tab" key from jumping over adjacent cell
- Re: WORKDAY
- Filtering Issue
- Re: COUNTIF/SUMIF comparing two rows of data
- RE: COUNTIF/SUMIF comparing two rows of data
- Re: if format problem
- Re: Column changing
- Re: Converting Time to decimals and then converting decimals to time
- COUNTIF/SUMIF comparing two rows of data
- Re: if format problem
- Re: How can I add down a list a specified number of cells?
- Converting Time to decimals and then converting decimals to time
- Drawing Sample
- Re: Multiple conditions
- EXCEL - formula for linking dates and prices
- Re: sumif with more than 1 criteria
- Re: How can I add down a list a specified number of cells?
- Re: Multiply CountIf in one formula
- Re: Format for Whole number and 1 Decimal in same Cell
- Re: How to time-limit an Excel file installation
- Re: create a formula to produce a color in excel
- Re: Create a function to add one to the count
- Re: How can I add down a list a specified number of cells?
- Re: Format for Whole number and 1 Decimal in same Cell
- Re: Format for Whole number and 1 Decimal in same Cell
- Re: How can I add down a list a specified number of cells?
- Re: How can I add down a list a specified number of cells?
- Re: How can I add down a list a specified number of cells?
- Re: How can I add down a list a specified number of cells?
- Re: vlookup formula fails to return data search item is text
- Re: Multiply CountIf in one formula
- Re: Colume Headings
- Re: Format for Whole number and 1 Decimal in same Cell
- Re: Cell Format
- Re: Multiply CountIf in one formula
- Re: IF - looking in a cell for a specific value
- Re: IF - looking in a cell for a specific value
- Re: IF - looking in a cell for a specific value
- Re: Column changing
- Re: Mod Function
- Re: Create "other" filter
- Re: how to write a number in words in excel worksheet?
- Re: If Condition Problem
- Re: User created function not "updating"
- WORKDAY
- If Condition Problem
- Re: sumif with more than 1 criteria
- Re: converting time
- Re: "Backsolve" Poisson function
- Re: Multiple conditions
- Re: How to time-limit an Excel file installation
- Re: Data Validation -- Dates
- From: Rick Rothstein \(MVP - VB\)
- RE: Chart Source Data
- Re: Substitute function yields #VALUE! when add the instance_number
- Re: One more step in the Formula Please
- How to time-limit an Excel file installation
- Re: cannot format date at all
- Re: Colour Fill
- Re: Cursor position to get colour
- Re: create a formula to produce a color in excel
- Re: create a formula to produce a color in excel
- Re: #DIV/0! - how to get rid of it
- Re: Cursor position to get colour
- Re: formatting issue- date format dominates
- Re: Substitute function yields #VALUE! when add the instance_number
- Re: looking for a function
- Re: One more step in the Formula Please
- Re: Data Validation -- Dates
- Re: Calculating number of weeks between dates?
- Calculating number of weeks between dates?
- Re: One more step in the Formula Please
- Re: Data Validation -- Dates
- Re: One more step in the Formula Please
- Data Validation -- Dates
- Re: One more step in the Formula Please
- Re: Substitute function yields #VALUE! when add the instance_number
- Re: Help with function
- Re: find maximum and minum variables for multiple names
- Re: if any 3 of 5 cells have 0 then 0.
- Re: Cursor position to get colour
- Re: Cell Format
- find maximum and minum variables for multiple names
- From: hamad.fatima@xxxxxxxxx
- Re: looking for a function
- Re: looking for a function
- Re: looking for a function
- Re: looking for a function
- looking for a function
- Re: Substitute function yields #VALUE! when add the instance_number
- Re: Selecting every 200th row
- Re: sum if less than and more than a time range
- Re: Text Formula Question
- Re: Using COUNTIF to count based on multiple cell criteria.
- Re: Query Named Range Return Single Column Value
- Time format graph
- Re: Using Data Filter
- Re: Using COUNTIF to count based on multiple cell criteria.
- Re: Text Formula Question
- Re: Substitute function yields #VALUE! when add the instance_number
- Format for Whole number and 1 Decimal in same Cell
- Re: Cell Format
- Re: Choose function in Excel 2003
- Re: Choose function in Excel 2003
- Re: Cross referencing
- Re: sum if less than and more than a time range
- Re: Calculate a number for 80% of column
- Re: sumif with more than 1 criteria
- RE: selecting an answer based on a 3 way logic
- Re: Automating Worksheet Names
- Re: sum if less than and more than a time range
- Re: formatting issue- date format dominates
- selecting an answer based on a 3 way logic
- Re: Mod Function
- Re: Choose function in Excel 2003
- Re: Choose function in Excel 2003
- Re: Choose function in Excel 2003
- Re: Query Named Range Return Single Column Value
- Re: formatting issue- date format dominates
- Re: Choose function in Excel 2003
- Re: rounding a number with a formula already in cell
- Re: formatting issue- date format dominates
- Re: sum if less than and more than a time range
- Re: formatting issue- date format dominates
- Re: Text Formula Question
- Re: formatting issue- date format dominates
- Re: formatting issue- date format dominates
- Re: Excel Formula
- Re: formatting issue- date format dominates
- Re: Text Formula Question
- RE: Mod Function
- Re: create a formula to produce a color in excel
- Re: Mod Function
- Re: Text Formula Question
- Re: Sumif with multiple criteria
- RE: cannot format date at all
- Re: cannot format date at all
- Re: Excel 2003/7 VBA (Un) Protection not working
- Excel 2003/7 VBA (Un) Protection not working
- Re: Cursor position to get colour
- Re: User created function not "updating"
- Re: jumping rowsand highlighting cells
- Re: create a formula to produce a color in excel
- Re: Create a function to add one to the count
- Re: User created function not "updating"
- Re: Cross referencing
- Re: Pivot Tables
- Re: Ignore calculation if text
- Re: Cursor position to get colour
- User created function not "updating"
- Re: Cursor position to get colour
- Re: Using Data Filter
- Re: Pop-up: "Too many different cell formats"
- Re: Pop-up: "Too many different cell formats"
- Re: Copy content of coloums between different workgroups
- Re: Colour Fill
- Cursor position to get colour
- Re: Create a function to add one to the count
- Re: Determining an annual review date from an employee start date
- Re: Create a function to add one to the count
- Re: Create a function to add one to the count
- RE: Excel copying heading to another cell in a selection is made
- Re: Create a function to add one to the count
- Re: Format change when user select a Factor on drop down box
- Re: Create a function to add one to the count
- Re: Character limitations for excel fields
- Re: create a formula to produce a color in excel
- Re: create a formula to produce a color in excel
- Re: create a formula to produce a color in excel
- Re: create a formula to produce a color in excel
- Re: Determining an annual review date from an employee start date
- Re: Dragging a range
- Re: How do I create a formula for a Chart of Account list?
- Re: How do I create a formula for a Chart of Account list?
- Re: Formula for searching spreadsheet
- Re: External Data needs to be separated
- if any 3 of 5 cells have 0 then 0.
- Re: Dragging a range
- Re: Using COUNTIF to count based on multiple cell criteria.
- Re: Applying a formula to a broad range of numbers.
- Re: Applying a formula to a broad range of numbers.
- Re: Using COUNTIF to count based on multiple cell criteria.
- Re: Protecting Worksheets
- Re: create a formula to produce a color in excel
- Using COUNTIF to count based on multiple cell criteria.
- Re: NETWORKDAYS: using correct funtion?
- Re: sum if less than and more than a time range
- Re: Referencing Non-bold in a formula
- Dragging a range
- Re: Color
- Re: Referencing Non-bold in a formula
- Re: create a formula to produce a color in excel
- Re: average function for a series
- Re: Formulas Becoming Inactive?!?
- Re: Formula to pick out, cut and paste
- Re: HOW DO I REMOVE UNIQUE VALUES IN EXCEL?
- Re: Excel Formula
- Re: Check Boxes
- Re: NETWORKDAYS: using correct funtion?
- Re: Excel Formula
- Re: Create a function to add one to the count
- Re: average function for a series
- Re: Create a function to add one to the count
- Re: Create a function to add one to the count
- Re: find number within a range
- Re: Excel
- Re: average function for a series
- RE: Create a function to add one to the count
- Re: average function for a series
- Re: Multiple conditions
- Re: find number within a range
- Re: create a formula to produce a color in excel
- Re: average function for a series
- Re: Locking Cell Once Data is entered
- Multiple conditions
- Re: create a formula to produce a color in excel
- Re: Use a string as a Variable Name
- Re: Check Boxes
- Re: sum if less than and more than a time range
- Re: attendance based pay for Army reserve
- RE: excluding my country's weekends
- Re: how do i sort a spread sheet and remove duplication
- Re: Sum results of VLOOKUP
- Re: Link or Cell Reference Within Text String
- Re: how to get rid of #N/A
- RE: average function for a series
- Re: External Data needs to be separated
- Re: How can I remove extra characters from a list- phone numbers in ex
- Re: create a formula to produce a color in excel
- Re: NETWORKDAYS: using correct funtion?
- RE: drop-list with different colors for the same charachter
- Re: how do i sort a spread sheet and remove duplication
- Re: COUNT based on conditions in 2 or more columns
- Re: NETWORKDAYS: using correct funtion?
- RE: divided value by amount of rows
- RE: Grouping data
- Re: Colour Fill
- Re: Colour Fill
- RE: drop-list with different colors for the same charachter
- Re: Character limitations for excel fields
- RE: NETWORKDAYS: using correct funtion?
- RE: divided value by amount of rows
- Re: Vlookup vs Hlookup or Both?
- RE: drop-list with different colors for the same charachter
- Re: Worksheet or Spreadsheet
- Re: How to convert Number into words in EXCEL same or a new cell ?
- Re: how to change word 500 to text five hundred
- Re: COUNTIF
- Re: Jumping reference cell in dependent cell formula
- Re: Colour Fill
- Re: "Backsolve" Poisson function
- Re: Read Excel row values
- Re: Read Excel row values
- Re: Read Excel row values
- Re: Read Excel row values
- Re: Password Protection for Worksheets already protected
- Read Excel row values
- Re: Password Protection for Worksheets already protected
- Re: Use a string as a Variable Name
- Re: Password Protection for Worksheets already protected
- Re: Password Protection for Worksheets already protected
- Re: Name List
- COUNTIF
- Re: Formula for searching spreadsheet
- Re: Finding first occurence of a number
- Re: Conditional formula
- Re: Password Protection for Worksheets already protected
- Re: Finding first occurence of a number
- RE: Password Protection for Worksheets already protected
- Re: How do I fill every other line with a color?
- Re: IF THEN color cell red
- Re: How do I fill every other line with a color?
- Re: IF THEN color cell red
- Re: IF THEN color cell red
- Re: Vlookup
- Re: Latest date with condition
- Re: Vlookup
- Re: Password Protection for Worksheets already protected
- Re: Latest date with condition
- Re: calculating median and mode
- Re: NEST A IF WITHIN A IF
- Re: Vlookup
- Re: How do I fill every other line with a color?
- Re: Latest date with condition
- RE: Password Protection for Worksheets already protected
- Re: Formulas Not Calculating Correctly
- RE: Password Protection for Worksheets already protected
- Re: Formulas Not Calculating Correctly
- Re: Password Protection for Worksheets already protected
- RE: Chart Source Data
- Re: Formulas Not Calculating Correctly
- Re: Latest date with condition
- RE: Password Protection for Worksheets already protected
- Re: Formulas Not Calculating Correctly
- Re: Password Protection for Worksheets already protected
- RE: drop-list with different colors for the same charachter
- Re: Summing filtered data
- Re: NEST A IF WITHIN A IF
- Re: Microsoft Excell
- Re: Date Range
- NEST A IF WITHIN A IF
- Re: Link or Cell Reference Within Text String
- Re: Count and Sum if Date
- Re: Count and Sum if Date
- Re: Conditional formula
- Re: Overlaping conditions....may be
- Re: Conditional Formatting Q
- Re: Vlookup
- Re: #DIV/0! - how to get rid of it
- Re: #DIV/0! - how to get rid of it
- Vlookup
- RE: #DIV/0! - how to get rid of it
- Re: Link or Cell Reference Within Text String
- Re: Overlaping conditions....may be
- Re: Count and Sum if Date
- Re: Count and Sum if Date
- Re: Conditional formula
- Count and Sum if Date
- Re: Overlaping conditions....may be
- Re: Microsoft Excell
- Microsoft Excell
- Re: Mach
- Re: Naming tabs
- Mach
- Re: vlookup
- vlookup
- calendar/schedule
- Re: Naming tabs
- Re: Auto alphabetic
- Re: Link or Cell Reference Within Text String
- Re: Use a string as a Variable Name
- Re: Find/Replace
- Re: can excel print data flow diagrams of an existing excel database?
- Re: Overlaping conditions....may be
- Re: search and filter
- Re: Use a string as a Variable Name
- Re: Link or Cell Reference Within Text String
- RE: Find/Replace
- Re: Sumproduct formula problem
- Re: Counting blank unique entries
- Sumproduct formula problem
- From: chedd via OfficeKB.com
- Re: Indirect Function
- Re: search and filter
- Link or Cell Reference Within Text String
- Re: Indirect Function
- RE: Grouping data
- Re: Indirect Function
- Re: Problem with morefunc addin
- Re: Indirect Function
- Re: Indirect Function
- Re: Offset function in Excel 2003
- Re: AddPeriodToCharaceter
- Re: Counting blank unique entries
- Re: Conditional formula
- Re: Overlaping conditions....may be
- Re: dele navn
- Re: Offset function in Excel 2003
- Re: Conditional Formatting Q
- Re: Determining an annual review date from an employee start date
- Conditional Formatting Q
- Auto alphabetic
- Problem with morefunc addin
- try
- "Backsolve" Poisson function
- Re: COUNTIF
- Determining an annual review date from an employee start date
- Re: search and filter
- Re: Formula for searching spreadsheet
- Re: Formula for searching spreadsheet
- Re: Formula for searching spreadsheet
- Re: COUNTIF
- Default zero with use macro
- Re: Offset function in Excel 2003
- Re: Convert String to Function Reference
- Re: Substition for data validation, dropdown list
- Re: Substition for data validation, dropdown list
- Re: Conditional formula
- Re: Substition for data validation, dropdown list
- Re: Offset function in Excel 2003
- Re: Row Hide Or 0 value
- RE: AddPeriodToCharaceter
- Re: AddPeriodToCharaceter
- Re: Scatter Plot Point Labels
- Re: Linking Worksheets to a Summary Worksheet
- AddPeriodToCharaceter
- Re: Formula for searching spreadsheet
- Re: Macro print range not dynamic like I wanted it to be
- Re: Macro print range not dynamic like I wanted it to be
- Re: SUMIF function criteria options
- RE: calculating median and mode
- Re: Substition for data validation, dropdown list
- Re: Finding first occurence of a number
- Re: Formula for searching spreadsheet
- Re: Form to open when workbook is opened
- Re: Macro print range not dynamic like I wanted it to be
- Re: Conditional formula
- Re: Macro print range not dynamic like I wanted it to be
- Re: Naming tabs
- Re: Overlaping conditions....may be
- Re: Form to open when workbook is opened
- Re: Conditional formula
- Re: Macro print range not dynamic like I wanted it to be
- Re: Macro print range not dynamic like I wanted it to be
- Conditional formula
- Re: Macro print range not dynamic like I wanted it to be
- Re: how can worksheets be deleted in Excel?
- Re: Finding first occurence of a number
- Re: IF STATEMENT
- Re: Macro print range not dynamic like I wanted it to be
- Re: Naming tabs
- Re: Finding first occurence of a number
- Re: IF STATEMENT
- Re: IF STATEMENT
- Re: IF STATEMENT
- Re: Indirect references to an offline book
- Re: search and filter
- Re: PPMT function replacement
- Re: Overlaping conditions....may be
- Re: Offset function in Excel 2003
- Re: Overlaping conditions....may be
- Re: I have a pricelist. How can i link my quote sheet with it?
- Re: Overlaping conditions....may be
- Overlaping conditions....may be
- Re: Indirect references to an offline book
- Re: IF, Else function
- Re: SUMIF function criteria options
- Indirect references to an offline book
- Re: Finding first occurence of a number
- Re: Finding first occurence of a number
- RE: Lookup Values & Transpose
- Re: Formulas Not Calculating Correctly
- Re: Finding first occurence of a number
- Re: Help
- Re: Finding first occurence of a number
- Re: Need a forumla help
- Re: Count duplicate cell values per month
- Re: Formulas Not Calculating Correctly
- Re: Vlookup - modify dropdown lists
- Re: Need a forumla help
- Re: Need a forumla help
- Re: Finding first occurence of a number
- RE: SUMIF function criteria options
- Need a forumla help
- RE: SUMIF function criteria options
- Re: Formulas Not Calculating Correctly
- Re: how can worksheets be deleted in Excel?
- Re: date in text format as a real date
- Re: IF, Else function
- CompareCurrencyColumns
- Re: I have a pricelist. How can i link my quote sheet with it?
- Re: how can worksheets be deleted in Excel?
- Re: Count duplicate cell values per month
- Re: frequency/sort/sumproduct
- Help
- From: How do i make a chart
- how can worksheets be deleted in Excel?
- Re: Help needed with a calculation question
- Re: sumproduct text if
- Re: active cell address with worksheet function
- Re: sumproduct text if
- Re: Help needed with a calculation question
- Re: Highlight cells with certain number values
- Re: sumproduct text if
- Re: sumproduct text if
- Re: Vlookup - modify dropdown lists
- Re: frequency/sort/sumproduct
- Re: sumproduct text if
- Re: sumproduct text if
- date in text format as a real date
- Re: How to link a drop down menu to another one?
- Re: Auto Filter
- How to link a drop down menu to another one?
- Re: Row Hide Or 0 value
- Re: How to convert CVS into XLS
- Re: VLOOKUP formula question
- Row Hide Or 0 value
- Re: make it 12 rows from 1 row
- Re: How to get last amount in a column
- Re: swap values between two cells
- Re: swap values between two cells
- From: Rick Rothstein \(MVP - VB\)
- Excel Inport External Data - new queries
- Re: Substition for data validation, dropdown list
- Re: Substition for data validation, dropdown list
- Re: Substition for data validation, dropdown list
- Re: INDEX MATCH #N/A Error
- Re: swap values between two cells
- Re: wild card in sumproduct
- Re: Substition for data validation, dropdown list
- Re: How to get last amount in a column
- Re: Vlookup vs Hlookup or Both?
- Re: Multiple Functions
- Re: Multiple Functions
- Re: Multiple Functions
- Re: Identifying cells without certain text strings
- Re: worksheet function to summarise a list of text?
- Re: wild card in sumproduct
- From: BNT1 via OfficeKB.com
- Re: SUMPRODUCT HELP
- Re: frequency/sort/sumproduct
- Re: How to get last amount in a column
- Re: worksheet function to summarise a list of text?
- Re: Sum results of VLOOKUP
- Re: How to get last amount in a column
- Re: How to get last amount in a column
- Re: VLOOKUP formula question
- Re: Substition for data validation, dropdown list
- Re: Sum results of VLOOKUP
- Re: formula to change font or cell colour
- Re: formula to change font or cell colour
- Re: trailing minus
- Re: trailing minus
- How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank
- SOLUTION FOUND ! Thank you Allen Wyatt !
- From: GEORGE ZEIGLER, SAN DIEGO
- Re: sumproduct with indirect
- Re: Vlookup vs Hlookup or Both?
- Re: Sum results of VLOOKUP
- Re: Sum results of VLOOKUP
- Re: Sum results of VLOOKUP
- Re: Conditional List
- Re: SUMPRODUCT HELP
- Re: SUMPRODUCT HELP
- Re: Re:WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) ...CELL T
- From: GEORGE ZEIGLER, SAN DIEGO
- Re: Re:WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) ...CELL TRUNCATED
- Re: trailing minus
- Re:WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) ...CELL TRUNCATED
- From: GEORGE ZEIGLER, SAN DIEGO
- Re: SUMPRODUCT HELP
- Re: 100*50 to =100*50
- 100*50 to =100*50
- Re: WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0)
- Re: trailing minus
- Re: trailing minus
- Re: trailing minus
- Re: I want to do Autosum by pressing "Alt=", instead I get 3/4. Why?
- Re: Use 100 separator inspite of 1000 separator in excel
- Re: trailing minus
- Re: Comparing times..
- Re: What is the easiest way to do this.
- Re: How can i Recall a Value?
- Re: #REF error in named formula
- Re: wild card in sumproduct
- wild card in sumproduct
- From: BNT1 via OfficeKB.com
- Re: trailing minus
- Re: trailing minus
- Re: Changing to a usable format - number
- Re: excel clear button
- Re: Vlookup - modify dropdown lists
- Re: trailing minus
- Re: Vlookup vs Hlookup or Both?
- trailing minus
- Re: Help with a lookup
- Re: I have a pricelist. How can i link my quote sheet with it?
- Re: PivotTable - Show labels on every row?
- Re: Auto Filter
- Changing to a usable format - number
- Re: HOW DO I CONVERT LOTUS 123 (ON DOS) TO EXCELL?
- HOW DO I CONVERT LOTUS 123 (ON DOS) TO EXCELL?
- Re: Auto Filter
- Re: Auto Filter
- Auto Filter
- Re: excel golf scores, how do I add the scores for all par 3's etc
- Re: excel golf scores, how do I add the scores for all par 3's etc
- Re: how do i restore a copied over worksheet
- Re: Named Ranges Not Working in Data Validation
- Re: Help with a lookup
- Re: How can I creat userdefine function
- Re: How can I creat userdefine function
- Help with a lookup
- HOW TO WORK
- Re: replace error with blank
- Re: replace error with blank
- Re: How can I creat userdefine function
- Re: Use 100 separator inspite of 1000 separator in excel
- Re: countif
- Re: Find Row in a named range
- Re: Conditional List
- Re: Find Row in a named range
- Find Row in a named range
- Re: Data Form, Macro and Countif
- Re: formula to change font or cell colour
- countif
- Data Form, Macro and Countif
- Preventing printing
- Re: Count duplicate cell values per month
- Comparing times..
- Re: Count duplicate cell values per month
- Re: Count duplicate cell values per month
- Re: calculating number of days between first day to last day, inclusiv
- Re: Name in cell ref used in a formula
- Re: replace error with blank
- PivotTable - Show labels on every row?
- Re: Named Ranges Not Working in Data Validation
- Re: Calculating business days minus holidays
- Re: Named Ranges Not Working in Data Validation
- Re: Calc days between two dates and exclude leap year days
- Re: future value
- Re: Calc days between two dates and exclude leap year days
- Re: Named Ranges Not Working in Data Validation
- How to sort column data regardless of col length
- Re: #N/A in lookup function
- Re: #N/A in lookup function
- RE: #N/A in lookup function
- Re: Calc days between two dates and exclude leap year days
- #N/A in lookup function
- Re: Sharing workbook
- Re: How can I creat userdefine function
- Sharing workbook
- Re: in excel: format font conditional on content of adjacing cell?
- Re: in excel: format font conditional on content of adjacing cell?
- Re: replace error with blank
- RE: More lines to one
- RE: Automatic copy triggered by change in date
- Re: Name in cell ref used in a formula
- RE: LInking workbooks
- Re: How can I creat userdefine function
- Re: Formula modification
- Re: Formula modification
- Re: replace error with blank
- Re: Formula modification
- Re: Formula modification
- Re: Formula modification
- Re: Name in cell ref used in a formula
- Re: Weird Multiplication!
- Re: #VALUE error
- Re: #VALUE error
- Re: Conditional Formatting 2007
- Re: Comparing two columns and return a third
- Re: Comparing two columns and return a third
- Re: How to convert function return value to text?
- Re: How to convert function return value to text?
- Re: How to convert function return value to text?
- Re: Conditional Formatting 2007
- How to convert function return value to text?
- Re: Comparing two columns and return a third
- Re: sort function for dates does not sort properly in Office 2007 Exc.
- Re: Named Ranges Not Working in Data Validation
- Re: Formula
- Re: #VALUE error
- Re: #VALUE error
- Re: #VALUE error
- Re: #VALUE error
- Re: vlookup left
- Re: sumproduct with indirect
- From: BNT1 via OfficeKB.com
- Re: lookup left
- Re: What are the calcs in PMT
- Re: sumproduct with indirect
- Re: What are the calcs in PMT
- Re: sumproduct with indirect
- From: BNT1 via OfficeKB.com
- Re: Vlookup vs Hlookup or Both?
- Re: sumproduct with indirect
- Re: Multiple vlookup //
- Re: Excell
- Re: SUMIFS Compatiblilty for Excel 2000
- Re: Weird Multiplication!
- Re: SUMIFS Compatiblilty for Excel 2000
- Re: Multiple vlookup //
- Re: Excell
- Re: How to delete same column in every sheet
- Re: Weird Multiplication!
- Re: Weird Multiplication!
- Weird Multiplication!
- Re: What are the calcs in PMT
- Re: How do I apply a formula to multiple rows at the same time?
- Re: Formula for the first working day of the year
- sumproduct with indirect
- From: BNT1 via OfficeKB.com
- Re: if statement
- Re: Conditional Format to highlight entire row if a condition is m
- Re: if statement
- Re: GRAPHS
- Re: unprotect subtotals
- RE: call distribution
- Re: call distribution
- Re: Formula for the first working day of the year
- Re: How to delete same column in every sheet
- RE: call distribution
- Re: How to delete same column in every sheet
- unprotect subtotals
- Re: call distribution
- Re: How to delete same column in every sheet
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: How to delete same column in every sheet
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: HOW WILL MOVE TO 2ND WORKSHEET
- Re: how can find sheet on workbook have so many sheet ?
- Re: Formula modification
- Re: Formula modification
- Re: Formula modification
- Re: How to calculate with #div/0! error?
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: How to calculate with #div/0! error?
- Re: Formula for the first working day of the year
- Excel 2007 Problem with Filter
- Re: Count date in 2 column
- Re: Formula modification
- Formula modification
- Re: Formula to Identify Col Data-Pairs that Differ by 2*pi
- Re: Pivot Table Averages at Subtotal
- Re: data validation, dynamic ranges
- Re: Removing a period and leaving maintaingn a fixed #of numbers
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: print button macro & specific tabs to print
- Re: Calculating business days minus holidays
- Re: Calculating business days minus holidays
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: print button macro & specific tabs to print
- Re: LINREGR
- Re: Help please with a lookup problem
- Re: How to calculate with #div/0! error?
- print button macro & specific tabs to print
- Re: Redirecting a formula in an "IF THEN" statement
- Re: Macro to save file as different filename
- Re: Help please with a lookup problem
- Re: Help please with a lookup problem
- Re: Add up all numbers in VLOOKUP that has identical lookup value
- Re: Add up all numbers in VLOOKUP that has identical lookup value
- From: ssolomon via OfficeKB.com
- Re: Add up all numbers in VLOOKUP that has identical lookup value
- Re: Macro to save file as different filename
- Re: How do I count the # of unique occurences of a text in a colum
- Re: Can I have the formulas instead of computation on the screen.
- Re: Can I have the formulas instead of computation on the screen.
- Re: Macro to save file as different filename
- Re: Macro to save file as different filename
- Re: Compare two Cells and highlight third cell
- Re: Add up all numbers in VLOOKUP that has identical lookup value
- Re: Formulas for multiplying cells
- Re: Excell nested function question....
- Re: Macro to save file as different filename
- Re: How do I count the # of unique occurences of a text in a colum
- Re: Can I have the formulas instead of computation on the screen.
- Add up all numbers in VLOOKUP that has identical lookup value
- From: ssolomon via OfficeKB.com
- Re: How do I count the # of unique occurences of a text in a colum
- Re: How do I count the # of unique occurences of a text in a colum
- Re: unmerge cells when the merge and center button doesn't work
- Re: Help please with a lookup problem
- Re: How do I count the # of unique occurences of a text in a colum
- Re: Name in cell ref used in a formula
- Re: vlookup combine indirect
- Re: Need to extract certain text from text string
- Re: Scale numbers for Y Axis.
- Re: Need to extract certain text from text string
- Re: Formulas for multiplying cells
- Re: Compare two Cells and highlight third cell
- Re: Using a macro to paste into first empty row in a new worksheet
- vlookup combine indirect
- Re: Formulas for multiplying cells
- Name in cell ref used in a formula
- Re: Validate Sku No in Sheet 1 against Sheet 2
- Formulas for multiplying cells
- Re: Conditional Format to highlight entire row if a condition is met
- Re: can font color be controled in an IF statement
- Re: Excell
- Re: loan payments
- Re: conditional formating with isodd and iseven
- Re: sum the difference in a range
- Re: loan payments
- Re: Custom Worksheet Function - Absolute...?
- Re: How do I combine worksheets
- Re: How do I combine worksheets
- RE: can font color be controled in an IF statement
- Re: Line up rows to corresponding row of larger master list in exc
- Re: Calculate Number of Days in a Month
- Re: Linked Cells
- Re: counting data across worksheets
- Re: need to lookup a value in one column to fill in another
- Re: More than 7 embeded if statements
- Re: Linked Cells
- Re: counting data across worksheets
- Re: Spreadsheet Function creation?
- Re: Line break within a field
- Re: conditional formating with isodd and iseven
- Re: counting data across worksheets
- Re: Linked Cells
- Re: Formula for the first working day of the year
- Re: loan payments
- Re: loan payments
- Re: Custom Worksheet Function - Absolute...?
- Re: Print multi invoices from a spreadsheet
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: Circumventing the 255 character header/footer limit
- Re: Create a function for the next number to be issued
- Re: Insert new rows based on Data in other rows
- Re: Line up rows to corresponding row of larger master list in exc
- Re: Automatically insert rows with formula
- Re: Evaluate function
- Re: Create a function for the next number to be issued
- Re: Redirecting a formula in an "IF THEN" statement
- Re: use function to change a string to function's parameter
- Re: Formula for the first working day of the year
- Re: Evaluate function
- Re: Evaluate function
- Re: Formula for the first working day of the year
- Re: Evaluate function
- Re: Formula for the first working day of the year
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: Evaluate function
- Re: Formula
- Re: Evaluate function
- RE: use function to change a string to function's parameter
- Re: Evaluate function
- Re: HOW WILL MOVE TO 2ND WORKSHEET
- RE: use function to change a string to function's parameter
- Re: Help with date formula
- HOW WILL MOVE TO 2ND WORKSHEET
- Re: How to calculate with #div/0! error?
- Re: why isn,t my mail to recipient as attchment not working on excle
- Re: Help with date formula
- Re: formula to show the message that number already entered
- Re: Line up rows to corresponding row of larger master list in exc
- Re: conditional formating with isodd and iseven
- Re: Spreadsheet
- Re: conditional formating with isodd and iseven
- Re: Redirecting a formula in an "IF THEN" statement
- Re: How to match date criteria then calculate an average of matche
- Re: conditional formating with isodd and iseven
- Re: conditional formating with isodd and iseven
- Re: Line up rows to corresponding row of larger master list in exc
- Re: Line up rows to corresponding row of larger master list in exc
- Re: loan payments
- Re: How to match date criteria then calculate an average of matche
- Re: Numbers & text in same cell - conditional formatting
- Re: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: Circumventing the 255 character header/footer limit
- Re: conditional formating with isodd and iseven
- Re: Removing a period and leaving maintaingn a fixed #of numbers
- RE: Pivot Table Column Widths
- Re: conditional formating with isodd and iseven
- Re: count 2 criteria text or numbers
- Re: How to sort data that is the result of a sum function
- Re: what is the formula
- Re: what is the formula
- Re: what is the formula
- RE: auto sorting help needed thank you!
- Re: Dropdown lists in Excel
- Re: Create a function for the next number to be issued
- Re: conditional formating with isodd and iseven
- Re: Vlookup vs Hlookup or Both?
- Re: Line Item
- RE: to pull from multiple sheets-index,match,vlookup,if,and,or???
- Re: Create a function for the next number to be issued
- Re: Line Item
- Re: Unprotect a protected worksheet
- Re: what is the formula
- Re: conditional formating with isodd and iseven
- Re: If isna match vlookup formula
- Re: Return Value that exists more than all other values
- Re: How do I print row numbers in an excell document?
- Re: How to match date criteria then calculate an average of matche
- Re: If ABS statement
- RE: min value not zero
- Re: If ABS statement
- RE: Conditional Format
- Re: How do I print row numbers in an excell document?
- RE: Conditional Format
- Re: How to calculate with #div/0! error?
- Re: Unprotect a protected worksheet
- Re: linking colour format between sheets
- Re: Function
- Re: Function
- Re: count 2 criteria text or numbers
- From: BNT1 via OfficeKB.com
- Re: count 2 criteria text or numbers
- Re: Line up rows to corresponding row of larger master list in exc
- count 2 criteria text or numbers
- From: BNT1 via OfficeKB.com
- Re: Numbers & text in same cell - conditional formatting
- Re: Excel how to be alerted when cells reach preset number?
- Re: If isna match vlookup formula
- Re: conditional formating with isodd and iseven
- Re: what is the formula
- Re: what is the formula
- RE: Expanding on the INDEX function
- Re: Custom Worksheet Function - Absolute...?
- Re: data validation, dynamic ranges
- RE: Conditional Format
- Conditonal Formating Excel 2007 - Duplicate Values
- Re: formulae for cash flow
- Re: COUNTIFS Formula Problem
- Re: How to calculate with #div/0! error?
- Re: Formulate a cell to change color when above/below an amount?
- Re: Display in a selected cell the 1st negative value's matching date
- Re: Formulate a cell to change color when above/below an amount?
- Re: Create a function for the next number to be issued
- Re: Create a function for the next number to be issued
- Re: If isna match vlookup formula
- Re: If isna match vlookup formula
- data validation, dynamic ranges
- RE: Conditional Format
- Excel Macros - Any Major Differences Between 2003 and 2007
- Re: Removing a period and leaving maintaingn a fixed #of numbers
- Re: Nested if statements
- Re: Circumventing the 255 character header/footer limit
- Re: IFISTEXT() function problem
- Re: IFISTEXT() function problem
- Re: IFISTEXT() function problem
- Re: IFISTEXT() function problem
- Re: ISTEXT() function problem
- Re: How to calculate with #div/0! error?
- Re: How to calculate with #div/0! error?
- Re: Calculate a number for 80% of column
- Re: Redirecting a formula in an "IF THEN" statement
- Re: Return Value that exists more than all other values
- RE: Conditional Format
- RE: Conditional Format
- Re: Excell
- Re: Line up rows to corresponding row of larger master list in exc
- RE: Conditional Format
- Re: Circumventing the 255 character header/footer limit
- Re: =CELL("color",a1)
- Re: =CELL("color",a1)
- Re: conditional formating with isodd and iseven
- Re: Conditional Format
- Re: =CELL("color",a1)
- Re: =cell(color,a1)
- Re: extact certain information from sheet 1 to shhet 2 columns e:e and
- Re: Pivot Table Averages at Subtotal
- Re: =CELL("color",a1)
- Re: Help with date formula
- From: Rick Rothstein \(MVP - VB\)
- Re: use more than 3 condition in conditional format
- Circumventing the 255 character header/footer limit
- Re: Return Value that exists more than all other values
- Re: extact certain information from sheet 1 to shhet 2 columns e:e and
- Re: Help with date formula
- Re: Help with date formula
- From: Rick Rothstein \(MVP - VB\)
- Re: Line up rows to corresponding row of larger master list in exc
- Re: conditional formating with isodd and iseven
- Re: use more than 3 condition in conditional format
- Re: conditional formating with isodd and iseven
- Re: If isna match vlookup formula
- Re: If isna match vlookup formula
- conditional formating with isodd and iseven
- If isna match vlookup formula
- Re: MODE function for text entries
- Re: writing a macro to save a workbook
- Re: How to match date criteria then calculate an average of matches
- Re: Line up rows to corresponding row of larger master list in exc
- Re: Macro to delete row
- Re: formulae for cash flow
- Re: How to write a formula to show the "last date" of a month
- Re: worksheet function
- Re: Redirecting a formula in an "IF THEN" statement
- Re: IF Statement with text
- Re: NPV of cashflows to assess contribution to a joint venture
- Re: Relative reference? in macro
- Re: Data Validation w/If Statement
- Re: Round a negative decimal
- Re: extracting data from a string
- Re: IF Statement with text
- Re: IF Statement with text
- Re: Need for ISERR and ISNA Makes formula too Long
- RE: IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT
- Re: Data Validation w/If Statement
- RE: IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT
- IF Statement with text
- Re: MODE function for text entries
- RE: Conditional formatting by key words
- Re: Conditional formatting by key words
- Re: Redirecting a formula in an "IF THEN" statement
- i need to look for text in column and
- From: Garyr via OfficeKB.com
- Re: Conditional formatting by key words
- RE: Conditional formatting by key words
- Re: formula help PLEASE!
- RE: Redirecting a formula in an "IF THEN" statement
- Re: Creating Custom Commands on a Toolbar
- Re: Need help with a look up forumula I haven't seen before
- Re: Need help with a look up forumula I haven't seen before
- Re: Round a negative decimal
- Re: Redirecting a formula in an "IF THEN" statement
- Re: Using a date formula!
- RE: Round a negative decimal
- Re: Using a date formula!
- Re: change the color of one word throughout a worksheet
- Re: Need for ISERR and ISNA Makes formula too Long
- Re: Round a negative decimal
- RE: Redirecting a formula in an "IF THEN" statement
- change the color of one word throughout a worksheet
- Re: Need for ISERR and ISNA Makes formula too Long
- Re: Need for ISERR and ISNA Makes formula too Long
- RE: Redirecting a formula in an "IF THEN" statement
- Re: Need for ISERR and ISNA Makes formula too Long
- Re: Need for ISERR and ISNA Makes formula too Long
- Need for ISERR and ISNA Makes formula too Long
- Re: Date Sorting
- Re: TOTALING ONE COLUMN FROM INFO IN ANOTHER
- Re: TOTALING ONE COLUMN FROM INFO IN ANOTHER
- Re: extracting data from a string
- Re: Updating Date on all worksheets linked to master worksheet
- RE: LInking workbooks
- Re: Rank order of errors
- Re: Dropdown lists in Excel
- RE: LInking workbooks
- Re: Updating Date on all worksheets linked to master worksheet
- RE: LInking workbooks
- Rank order of errors
- RE: LInking workbooks
- Re: Checking Dates against Bank Holidays
- Re: Checking Dates against Bank Holidays
- Re: can't add
- invalid references
- Re: Text Wrapping
- Re: Version Problem
- Re: Help needed with a function
- Re: Help needed with a function
- Re: Help needed with a function
- Re: Help needed with a function
- Re: Changing cell format from text to currency
- Changing cell format from text to currency
- RE: NOTHING WORKS2-HELP
- Re: IF function
- Re: bring information from one sheet to another
- Re: Sorting in Excel
- Re: Macro to be used with Combo box
- Re: use vlookup with offset function
- Re: Data Validation List
- Re: Version Problem
- Version Problem
- Re: Data Validation List
- Re: bring information from one sheet to another
- Re: Sorting in Excel
- Re: Sorting in Excel
- Re: Combine First and Last Name colums to create thrid column of f
- Re: Combine First and Last Name colums to create thrid column of full
- Re: Calculations - Max and Min
- Re: Calculations - Max and Min
- Re: can't add
- Re: SUM Function
- Re: Sorting in Excel
- Re: find a specific or several values in a massive datasheet
- Re: pivot tables, eliminating "0" values
- Re: Sorting in Excel
- matching columns
- Re: calculating wage increases for multiple employees.
- Re: counting recurring #'s in a column
- Re: Creating a column with just data before comma in another column
- Re: counting recurring #'s in a column
- Convert number to words with formula for Indian System.
- Re: use vlookup with offset function
- Re: Creating a column with just data before comma in another column
- Re: Macro to delete row
- Re: Macro to delete row
- Re: use vlookup with offset function
- Re: Vlookup - need the array to be constant
- Re: Vlookup - need the array to be constant
- Re: converting text strings into dates
- Re: converting text strings into dates
- Re: copy&paste 28 individual files into one file/28 work sheets
- copy&paste 28 individual files into one file/28 work sheets
- From: Yvez T.T. Constance
- Re: how do I create a fifo formula in exel
- Re: converting text strings into dates
- Re: extracting data from a string
- Re: converting text strings into dates
- Re: converting text strings into dates
- Re: converting text strings into dates
- converting text strings into dates
- Re: use vlookup with offset function
- Re: use vlookup with offset function
- Re: Macro to delete row
- Re: Building a spread sheet for oil field use
- Re: Macro to delete row
- Re: Macro to delete row
- Re: Not Calculating
- Re: VLookup Tables
- Re: VLookup Tables
- Re: Day from year in 1 column & day & month in another
- Re: How do I highlight 'Delete sheet' in cells group.
- Re: Day from year in 1 column & day & month in another
- Re: pivot tables, eliminating "0" values
- Day from year in 1 column & day & month in another
- Re: Building a spread sheet for oil field use
- Re: VLOOKUP - Allowable Number Sequence
- Re: *** Urgent help formula * Need to sum values in a column if all ..
- Re: VLOOKUP - Allowable Number Sequence
- to pull from multiple sheets-index,match,vlookup,if,and,or???
- VLOOKUP - Allowable Number Sequence
- Re: if function
- Re: if function
- Re: Open pdf from a cell
- Re: Open pdf from a cell
- Re: getpivotdata
- Re: Macro to delete row
- Re: COUNTIFS Formula Problem
- Open pdf from a cell
- Re: Macro to delete row
- Re: Macro to delete row
- Re: Line up rows to corresponding row of larger master list in excel
- Re: Macro to delete row
- Re: Macro to delete row
- Re: Macro to delete row
- Re: using a table as reference in creating formula
- RE: auto sorting help needed thank you!
- Re: Variable in arguments
- Re: Subtracting Dates
- Re: Need help with a look up forumula I haven't seen before
- Re: use vlookup with offset function
- Re: use vlookup with offset function
- Re: use vlookup with offset function
- Re: What are the calcs in PMT
- Re: function like INDIRECT to return a range?
- Re: function like INDIRECT to return a range?
- Re: COUNTIFS Formula Problem
- Re: use vlookup with offset function
- Re: Clicking on linked cells
- Re: Return Value that exists more than all other values
- Re: Find next occupied row up in another column
- Re: in excel 2000 work sheet excel commands are showing how to rectif
- Re: Not Calculating
- Re: Auto-fill follow-up
- Re: how do I view excel rows in name order infirst column?
- Re: count dates in a column
- count dates in a column
- Re: I want to calculate overtime hours for employees
- Re: Not Calculating
- Re: Subtracting Dates
- Re: Subtracting Dates
- Re: Subtracting Dates
- Return Value that exists more than all other values
- Re: Not Calculating
- Re: Find next occupied row up in another column
- Re: Not Calculating
- Re: Confusing multiple answer function
- Re: What are the calcs in PMT
- Re: Find next occupied row up in another column
- Re: Find next occupied row up in another column
- Re: Formula debugging
- Re: Find next occupied row up in another column
- Re: Find next occupied row up in another column
- Re: Subtracting Dates
- Re: Date not defaulting to current year
- Re: Find next occupied row up in another column
- Re: Clicking on linked cells
- From: www.exciter.gr: Custom Excel Functions!
- Re: Not Calculating
- Re: Find next occupied row up in another column
- RE: auto sort
- RE: auto sort
- Subtracting Dates
- RE: auto sort
- Re: Not Calculating
- Re: Not Calculating
- Re: Combo Box for a list of records
- Find next occupied row up in another column
- Re: Formula to use one or the other cell amount
- Re: Formula to use one or the other cell amount
- Re: Solver
- RE: Multiple lookup values and adding multiple rates across together
- From: ssolomon via OfficeKB.com
- Re: Date not defaulting to current year
- Re: Formating Question
- Re: Formating Question
- Re: How to get less than dates if Data in another column equals da
- Re: Why does excel sometimes subtract numbers incorrectly?
- Re: formula or vba to cut and paste
- From: Garyr via OfficeKB.com
- Re: Why does excel sometimes subtract numbers incorrectly?
- formula or vba to cut and paste
- From: Garyr via OfficeKB.com
- Re: How to get less than dates if Data in another column equals da
- Re: vlookup error
- RE: Multiple lookup values and adding multiple rates across together
- Re: How to get less than dates if Data in another column equals da
- RE: Multiple lookup values and adding multiple rates across togeth
- From: ssolomon via OfficeKB.com
- Re: how do I view excel rows in name order infirst column?
- Re: How to get less than dates if Data in another column equals da
- Re: TABLE function - not recalculating correctly
- RE: Gathering totals from various worksheets
- Re: Gathering totals from various worksheets
- Re: Formula to find average of the best 2 of 3 scores
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: How to get less than dates if Data in another column equals data
- RE: Formula to find average of the best 2 of 3 scores
- RE: Multiple lookup values and adding multiple rates across together
- Re: Formula to find average of the best 2 of 3 scores
- Re: Conditional Locking of Cells-Excel 2003
- Re: Macro functionality
- how do I view excel rows in name order infirst column?
- Re: Gathering totals from various worksheets
- Re: match data to another sheet and return all the data on that row
- Re: Date not defaulting to current year
- Re: Date not defaulting to current year
- Re: Stop specific cell from recalculating?
- Re: TABLE function - not recalculating correctly
- Re: Formula in a cell to calc FUTA tax
- Re: Easter date macro
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Gathering totals from various worksheets
- Re: Not Calculating
- Re: Not Calculating
- Re: Not Calculating
- Re: Not Calculating
- Re: Help with VBA Text
- Re: rdounding numbers with text
- Re: Formula in a cell to calc FUTA tax
- Re: Formula in a cell to calc FUTA tax
- Re: rdounding numbers with text
- Re: vlookup error
- Re: Formating Question
- RE: how do I create a fifo formula in exel
- Re: VLook UP formula question
- Re: Formating Question
- RE: Stop specific cell from recalculating?
- Re: delete rows with empty cells throughout the data
- Re: delete rows with empty cells throughout the data
- Formating Question
- Re: TABLE function - not recalculating correctly
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Macro functionality
- Re: Help with VBA Text
- RE: NOTHING WORKS2-HELP
- Dropdown lists in Excel
- Re: Displaying cell contents as part of a formula
- Re: Displaying cell contents as part of a formula
- Re: Force excel to open on a specific sheet
- Re: Force excel to open on a specific sheet
- Re: delete rows with empty cells throughout the data
- Re: TABLE function - not recalculating correctly
- Excel AverageIF issue... PLEASE HELP!
- Re: Force excel to open on a specific sheet
- Re: Not Calculating
- Re: Not Calculating
- Not Calculating
- delete rows with empty cells throughout the data
- Help with VBA Text
- Re: I am trying to convert a signed packed field in Excel. Is there .
- RE: Automatic updated averages
- From: ssolomon via OfficeKB.com
- Re: Solver
- Re: I am trying to convert a signed packed field in Excel. Is there .
- Re: Do Vlookup calculate quicker using named ranges?!
- RE: Automatic updated averages
- Re: How to SUM TWO ARRAY formula results
- Re: How to SUM TWO ARRAY formula results
- Do Vlookup calculate quicker using named ranges?!
- Re: How to SUM TWO ARRAY formula results
- RE: Stop specific cell from recalculating?
- Automatic updated averages
- From: ssolomon via OfficeKB.com
- Re: Pay rate Calculation for different shifts
- RE: NOTHING WORKS2-HELP
- Re: Formulas confussed
- Re: Add up Values if Find Matches x 2
- Re: Formula Question
- Re: Add up Values if Find Matches x 2
- Re: Calculating Patch Tuesday
- Re: Options Button
- Re: Options Button
- Re: How do I layer info in Excel. Have large amts of data to sort.
- Re: bring information from one sheet to another
- Re: How do copy a conditional format formula downards?
- Re: Merging data between worksheets using reference index?
- Re: Add up Values if Find Matches x 2
- Merging data between worksheets using reference index?
- Re: Confusing multiple answer function
- Re: Formula debugging
- Formula Question
- Re: Add up Values if Find Matches x 2
- Re: Add up Values if Find Matches x 2
- Re: Formula in a cell to calc FUTA tax
- Re: Populate a changing daily value to other workbooks and sheets
- Re: Add up Values if Find Matches x 2
- Add up Values if Find Matches x 2
- Re: use vlookup with offset function
- Re: use vlookup with offset function
- RE: Sumproduct-Countif variation
- Re: Formula in a cell to calc FUTA tax
- RE: Sumproduct-Countif variation
- Re: Pivot table data source
- Re: COUNTIF with 2 variables. HOW???
- Re: Populate a changing daily value to other workbooks and sheets
- Re: COUNTIF with 2 variables. HOW???
- Re: Formula in a cell to calc FUTA tax
- Re: Summing data from multiple woorkbooks
- Stop specific cell from recalculating?
- Re: Confusing multiple answer function
- Re: How do you make Conditional Formating work?
- Re: Using Multiple Array Criteria - Determine Average Result
- Re: search and filter results macro
- Re: right-click on a control button and view code does nothing
- Re: How do you make Conditional Formating work?
- Re: How do you make Conditional Formating work?
- Re: Variable in arguments
- Re: Variable in arguments
- Re: How do you make Conditional Formating work?
- Re: right-click on a control button and view code does nothing
- Re: How can I seperate text and number from alphanumeric cell?
- Re: Look up functions and a one to many relationship
- Need help with a look up forumula I haven't seen before
- Re: Number list
- Re: How to Change Reference
- Re: Auto-fill
- Re: Number list
- Re: Number list
- Re: How to Change Reference
- Re: Hide the zero values in a work book
- Re: Number list
- Re: Cumulative totals carrying over to several spreadsheets
- Re: How to Change Reference
- Re: dont know which function to use.
- Re: conditional formula
- Re: conditional formula
- Re: How can I seperate text and number from alphanumeric cell?
- Re: dont know which function to use.
- Re: No colour in cells when blank in list
- From: Rick Rothstein \(MVP - VB\)
- Re: CountA and ArrayFormula
- Re: Assigning Macros
- Re: columns stop at IV
- Number list
- Confusing multiple answer function
- Re: intersection of two lines defined by points
- RE: running total
- RE: How do I do several formulas in one cell?
- Re: dont know which function to use.
- Re: how do I create a fifo formula in exel
- Re: Hide the zero values in a work book
- help with search/lookup
- RE: auto sort
- Re: Calculating Patch Tuesday
- Re: Formulas
- Re: right-click on a control button and view code does nothing
- Re: running total
- Re: right-click on a control button and view code does nothing
- Re: Formulas
- Re: right-click on a control button and view code does nothing
- RE: auto sort
- Re: CountA and ArrayFormula
- Re: Formula
- Re: Calculating Patch Tuesday
- dont know which function to use.
- Auto-sorting rows & best case scenario
- Re: Cumulative totals carrying over to several spreadsheets
- Re: Calculating Patch Tuesday
- Re: Look up functions and a one to many relationship
- Re: Cumulative totals carrying over to several spreadsheets
- Re: Flipping text
- Re: Using Multiple Array Criteria - Determine Average Result
- Re: Display external data inside of an Excel 2007 Spread sheet
- Re: sorting in a cell
- Re: Formula to Find Matching Data
- Re: Calculating Patch Tuesday
- RE: sorting in a cell
- Re: intersection of two lines defined by points
- Re: CountA and ArrayFormula
- Re: Return worksheet name containing value found in 3D reference f
- Re: Look up functions and a one to many relationship
- Re: Calculating Patch Tuesday
- Re: Merging fields question
- Re: V/HLOOKUP in both directions?
- Re: Formula to return date of following Friday
- Re: Flipping text
- Re: Return worksheet name containing value found in 3D reference f
- Re: intersection of two lines defined by points
- Re: Return worksheet name containing value found in 3D reference funct
- Calculating Patch Tuesday
- Re: Return worksheet name containing value found in 3D reference funct
- Multiple lookup values and adding multiple rates across together
- RE: ROUNDDOWN function produces different results?
- Re: Formula to return date of following Friday
- Re: Lookup working days
- Re: use more than 4 condition in cf without using macro
- Re: Formula to return date of following Friday
- RE: ROUNDDOWN function produces different results?
- Re: Formula to return date of following Friday
- Lookup working days
- Re: SUMIF Function
- Re: COUNTIF + Month
- RE: Automate Combine 2 Spreadsheets into two worksheets
- Re: Vlookup or IF function ?
- Re: Capatilising text
- Re: macro that opens file named in cell doesnt work
- Re: COUNTIF + Month
- Re: Capatilising text
- Re: Lookup value
- Capatilising text
- Re: Merging fields question
- Re: Lookup value
- macro that opens file named in cell doesnt work
- Re: Lookup value
- Re: Inserting MROUND into existing data
- Lookup value
- Re: change color of entire row by use conditional format
- Re: COUNTIF + Month
- Re: column heading formula
- Re: Very Peculiar DV error Q
- Re: Function Conflicts with an If/Then Statement
- Re: column heading formula
- Re: Can i set a cell to alarm if a date isnt enterd before a set d
- Re: column heading formula
- Re: column heading formula
- Re: column heading formula
- Re: column heading formula
- Re: How do i set up a formula that fillcolor the cell if ....?
- Re: Can i set a cell to alarm if a date isnt enterd before a set date
- Re: Create new worksheet from template for each value in range
- Re: how do I record the time data is entered into a spreadsheet?
- Function Conflicts with an If/Then Statement
- Re: reverse a series of numbers from 1 cell into another
- Re: how do I record the time data is entered into a spreadsheet?
- Re: reverse a series of numbers from 1 cell into another
- reverse a series of numbers from 1 cell into another
- Re: AutoFilter Unavailable?
- Re: right-click on a control button and view code does nothing
- Re: How do you make Conditional Formating work?
- Re: Ranges
- Re: Excel
- Re: function like INDIRECT to return a range?
- Re: right-click on a control button and view code does nothing
- Re: Excel
- function like INDIRECT to return a range?
- Re: How do you make Conditional Formating work?
- Re: right-click on a control button and view code does nothing
- Re: Excel
- Re: Excel
- Re: CELL return value without double quotation marks
- Re: Products name only with the codes
- Re: More help w/ Match or Lookup
- Re: Create multiple sheet tabs from multiple cells.
- Re: More help w/ Match or Lookup
- Re: Easy one for you pros!
- Re: Removing a character
- Re: Removing a character
- Re: Conditional Locking of Cells
- Re: Easy one for you pros!
- RE: Conditional Locking of Cells
- Re: AutoFilter Unavailable?
- RE: Autofilter shuts off
- Re: Display external data inside of an Excel 2007 Spread sheet
- RE: Create multiple sheet tabs from multiple cells.
- Re: Identifying text to split into columns
- From: Rick Rothstein \(MVP - VB\)
- RE: Conditional Locking of Cells
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Identifying text to split into columns
- From: Rick Rothstein \(MVP - VB\)
- RE: Setting up a worksheet
- Re: Rank (but not returning same value)
- Re: Easy one for you pros!
- Re: Easy one for you pros!
- Re: Easy one for the Pros!
- Re: Easy one for the Pros!
- Re: Identifying text to split into columns
- Re: AutoFilter Unavailable?
- Re: AutoFilter Unavailable?
- Re: how do you create a new special cell format in Excel?
- Re: Frustrated Professor
- Re: Drop down calendar function
- Re: Creation of a formula
- From: Rick Rothstein \(MVP - VB\)
- Re: Combining Average, Offset & Vlookup
- Re: AutoFilter Unavailable?
- Re: Autoformat
- Re: HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT?
- Re: Very Peculiar DV error Q
- Re: AutoFilter Unavailable?
- Re: Very Peculiar DV error Q
- Re: Excel Function .. I sthere one out there somewhere?
- Re: changing tab from another sheet cell
- Re: formula help
- Re: How can I use a sheet in a formula based on the value in a cell
- Re: Very Peculiar DV error Q
- Re: Identifying text to split into columns
- From: Rick Rothstein \(MVP - VB\)
- RE: Macro that runs when worksheet is automatically updated
- Re: Identifying text to split into columns
- Re: Excel Function .. I sthere one out there somewhere?
- Re: Round time to quarter hour
- From: Rick Rothstein \(MVP - VB\)
- Re: Define a sheet in an array using a cell value
- Re: Excel Function .. I sthere one out there somewhere?
- Paste Consistently Occuring Rows
- Re: Old DOS to Excel ?
- Re: Character
- Re: Character
- Re: Formula Adjustment?
- Re: Vlookup to account for working hours mon-fri (9-5)
- Re: Round time to quarter hour
- Re: Autoformat
- From: Rick Rothstein \(MVP - VB\)
- RE: remove time stamp from date in excel
- RE: remove time stamp from date in excel
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Frustrated Professor
- Re: Excel Function .. I sthere one out there somewhere?
- Re: Extracting unique entries
- Re: Why is E3=>4 FALSE?
- Re: Excel Function .. I sthere one out there somewhere?
- Re: Excel in Office 2007
- Re: Left worksheet function
- Re: Left worksheet function
- Re: corresponding text and numeric cells
- Re: Very Peculiar DV error Q
- Re: Very Peculiar DV error Q
- Re: Left worksheet function
- Re: Left worksheet function
- Re: Left worksheet function
- Re: Left worksheet function
- RE: Latest LOOKup
- Re: Very Peculiar DV error Q
- RE: ROUNDDOWN function produces different results?
- Latest LOOKup
- Re: Very Peculiar DV error Q
- Re: Round time to quarter hour
- From: Rick Rothstein \(MVP - VB\)
- Re: realtime
- Re: mad cows disease?
- Very Peculiar DV error Q
- Re: changing tab from another sheet cell
- Re: Combining Average, Offset & Vlookup
- Re: Combining Average, Offset & Vlookup
- Re: Pivottable, new funtion?
- Re: NEED HELP!!!
- Re: Round time to quarter hour
- Re: Round time to quarter hour
- From: Rick Rothstein \(MVP - VB\)
- Re: Combining Average, Offset & Vlookup
- Re: Highlighting Entire Row using CF
- Re: Round time to quarter hour
- Combining Average, Offset & Vlookup
- Re: What a drag - changing the formula
- Re: What a drag - changing the formula
- Re: Not sure what function to use and how.
- Re: Round to .99?
- Re: Average
- Re: Tabbing to a specific cell
- Re: Switch between sheets with keystrokes?
- Re: % Retainage info ---Sorry DUH!
- Re: mad cows disease?
- Re: mad cows disease?
- Re: NEED HELP!!!
- Re: mad cows disease?
- Re: Re Picture Stock Brochure TIA
- Re: mad cows disease?
- Re: mad cows disease?
- Re: mad cows disease?
- Re: sumproduct - validating codes & dates
- mad cows disease?
- Re: concatenate "if"
- Re: changing tab from another sheet cell
- Re: Copying formulas
- Re: Conditional Formatting
- Re: SUM fx drops or adds 1 to total
- Re: Tabbing to a specific cell
- Re: If data is returned then delete data
- Re: Pricing formula
- Re: Automatically insert rows with formula
- Re: SUM fx drops or adds 1 to total
- Re: AutoFilter Unavailable?
- Re: Auto Filter not showing all data
- Re: Extracting unique entries
- Re: Extracting unique entries
- Re Picture Stock Brochure TIA
- Re: Count values in a range of cells
- Re: Count values in a range of cells
- Re: Count values in a range of cells
- Re: Emulating Text to Columns -- Separating Data into Appropriate
- Re: Create new worksheet from template for each value in range
- Re: Round time to quarter hour
- From: Rick Rothstein \(MVP - VB\)
- Re: Emulating Text to Columns -- Separating Data into Appropriate
- Re: Old DOS to Excel ?
- Re: Emulating Text to Columns -- Separating Data into Appropriate
- Re: Round time to quarter hour
- Re: Round time to quarter hour
- Re: Pricing formula
- RE: How do I copy a format that.........
- Re: Round time to quarter hour
- Re: Emulating Text to Columns -- Separating Data into Appropriate
- Re: How do I copy a format that.........
- Re: How can I use a sheet in a formula based on the value in a cell
- RE: How do I copy a format that.........
- Re: Emulating Text to Columns -- Separating Data into Appropriate Colu
- Re: Time it took to travel
- RE: How do I copy a format that.........
- Re: Pricing formula
- Re: Removing spaces from cells
- Re: Get logarithmic values?
- Re: Removing spaces from cells
- Re: AutoFilter Unavailable?
- Re: Removing spaces from cells
- Re: How do I refresh Pivot Table from an external source ?
- Re: How do I refresh Pivot Table from an external source ?
- Re: How do I refresh Pivot Table from an external source ?
- Re: Conditional Formatting Question.
- Re: Look up functions and a one to many relationship
- Re: Embeded ComboBox
- From: Rick Rothstein \(MVP - VB\)
- Re: Look up functions and a one to many relationship
- Re: Look up functions and a one to many relationship
- Re: Create Drop Down List
- Re: need help with nested formulas please
- Re: concatenate "if"
- Re: Extracting unique entries
- Re: Extracting unique entries
- Re: concatenate "if"
- Re: concatenate "if"
- Re: Extracting unique entries
- Extracting unique entries
- Re: Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
- Tabbing to a specific cell
- Re: Old DOS to Excel ?
- Re: Indirect a range that spans multiple sheets
- Re: Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
- Re: Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
- Re: Conditional Formatting
- Conditional Formatting
- Re: Indirect a range that spans multiple sheets
- Re: Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
- Re: Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
- Re: Date formula
- Re: ROUNDDOWN function produces different results?
- Re: average-if-and formula
- Re: Converting datetime from character string
- From: giel.vanboxtel@xxxxxxxxxxxx
- Re: average-if-and formula
- Re: Indirect a range that spans multiple sheets
- Re: average-if-and formula
- Re: Date formula
- RE: I can't find vlookup values!
- From: ragtopcaddy via OfficeKB.com
- Re: Converting datetime from character string
- From: giel.vanboxtel@xxxxxxxxxxxx
- Re: Help w/Match or Lookup
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: Converting datetime from character string
- From: giel.vanboxtel@xxxxxxxxxxxx
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: What does Excel's RAND function really do
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: Help w/Match or Lookup
- Converting datetime from character string
- From: giel.vanboxtel@xxxxxxxxxxxx
- Re: Columns and Conditional Formattin
- Help w/Match or Lookup
- Re: Converting datetime from character string
- Re: Columns and Conditional Formattin
- Re: Insert column : lose inclusion in functions
- Re: Copying formulas
- RE: Automate Combine 2 Spreadsheets into two worksheets
- Re: formula question
- Re: Possible If Function?
- Re: changing tab from another sheet cell
- Re: changing tab from another sheet cell
- Re: changing tab from another sheet cell
- Re: Sum.if date is in an interval...
- Re: Sum.if date is in an interval...
- Re: % Retainage info ---Sorry DUH!
- RE: Vertical Concatenate function
- Re: Possible If Function?
- Re: Possible If Function?
- changing tab from another sheet cell
- Re: data import
- data import
- RE: Vertical Concatenate function
- Re: Fred saves the day % retainage
- RE: Vertical Concatenate function
- Re: Sum.if date is in an interval...
- Re: Get logarithmic values?
- Re: Sum If multiple conditions
- Re: formula question
- RE: Using Forcast Function in Excel
- Re: worksheet function to summarise a list of text?
- Re: Counting cell colours
- RE: Vertical Concatenate function
- Re: Sum If multiple conditions
- Re: Begging one more time....Stuck on this....tracking Retainage %
- Re: Help sorting text as numbers
- Help sorting text as numbers
- RE: % Retainage info ---Sorry DUH!
- Re: Counting cell colours
- Re: Conditional Formatting with absolute references
- Re: Indirect a range that spans multiple sheets
- Re: Finding the oldest date in a column
- Re: Finding the oldest date in a column
- Re: Finding the oldest date in a column
- Re: Conditional Formatting with absolute references
- Re: Finding the oldest date in a column
- Re: Begging one more time....Stuck on this....tracking Retainage %
- Re: Begging one more time....Stuck on this....tracking Retainage %
- Re: What does Excel's RAND function really do
- Re: Finding the oldest date in a column
- Re: SUMPRODUCT Help PLEASE
- Re: Help with Sum Product - lots of posts before but none work!?!? PLE
- Re: Why is E3=>4 FALSE?
- Re: Why is E3=>4 FALSE?
- Re: Help with Sum Product - lots of posts before but none work!?!? PLE
- Re: Finding the oldest date in a column
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Re Picture Stock Brochure TIA
- Re: Indirect a range that spans multiple sheets
- Re: SUMPRODUCT Help PLEASE
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: sum everything but errors
- SUMPRODUCT Help PLEASE
- Re: sumproduct Formula PLEASE HELP
- Re Picture Stock Brochure TIA
- RE: Using Forcast Function in Excel
- Re: sum everything but errors
- Sum If multiple conditions
- Re: Convert a letter to a numeric value
- Re: Why is E3=>4 FALSE?
- Re: Convert a letter to a numeric value
- Re: Convert a letter to a numeric value
- formula question
- Re Picture Stock Brochure TIA
- Re: INDIRECT Formula with an IF Then issue
- Re: Function to convert to email address?
- Re: Function to convert to email address?
- Re: 2003 excel basic edition
- Re: COUNTIF based on several criteria incl. a "does not equal" cri
- Re: First zero doesn't show up in zip code mail merge.
- Re: Need formula to sum
- Re: Function to convert to email address?
- Re: Function to convert to email address?
- Re: Need formula to sum
- Re: Excel 2000
- Re: INDIRECT Formula with an IF Then issue
- Function to convert to email address?
- Re: Excel in Office 2007
- Re: INDIRECT Formula with an IF Then issue
- Re: formula
- From: Rick Rothstein \(MVP - VB\)
- Re: COUNTIF based on several criteria incl. a "does not equal" cri
- Re: 2003 excel basic edition
- Re: INDIRECT Formula with an IF Then issue
- Re: formula
- Re: 2003 excel basic edition
- Re: INDIRECT Formula with an IF Then issue
- Re: 2003 excel basic edition
- Re: Picture Stock Brochure TIA
- Re: How do I create a drop down box with the date in it
- Re: Check Box
- how to find gaps in the hours scheduled to ensure shift coverage
- Re: INDIRECT Formula with an IF Then issue
- Re: Average Function
- Re: Format Fill Down to Last Row
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Average Function
- Re: 2003 excel basic edition
- Copying text from a cell
- Re: how do i do an excel formule like "if, then"?
- Re: INDIRECT Formula with an IF Then issue
- Re: Check Box
- Re: Column and Row Titles
- Re: Check Box
- Re: Average Function
- Re: Maddening Dilemma - Compare each cell within column a to each cell
- Re: Average Function
- Re Picture Stock Brochure TIA
- Re: can a tab name/# chg. when a cell name/# chgs. automatical Excel
- Re: SUMIF with two conditions (or)
- Re: What does Excel's RAND function really do
- Re: Check Box
- Re: Excel 2003 Lookup function
- Re: counting text across multiple columns
- Re: Excel in Office 2007
- From: frustrated Professor
- Re: counting text across multiple columns
- Re: Format Fill Down to Last Row
- Re: Average Function
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: counting text across multiple columns
- Re: Sum.if date is in an interval...
- Re: Picture Stock Brochure TIA
- Re: I can't find vlookup values!
- RE: Counta or daveragea functions
- Picture Stock Brochure TIA
- Re: COUNTIF & AND
- Re: Can you Pre-fill file name in SaveAs dialog
- RE: Format Fill Down to Last Row
- Re: Excel in Office 2007
- I can't find vlookup values!
- From: ragtopcaddy via OfficeKB.com
- RE: Format Fill Down to Last Row
- From: Keep It Simple Stupid
- Re: COUNTIF & AND
- Get logarithmic values?
- Re: COUNTIF & AND
- Re: Sum.if date is in an interval...
- remove rows in one sheet from similar rows in another
- Re: sumproduct Formula PLEASE HELP
- Re: How do I add up cells that are autofiltered?
- Re: sumproduct Formula PLEASE HELP
- Re: copy formula from 1 workbook to another & not carry the extens
- Re: Automatically Updating Data from Multiple Worksheets into One
- Re: sumproduct Formula PLEASE HELP
- Re: Help with sum based on dates
- Re: How do I add up cells that are autofiltered?
- Re: Help with sum based on dates
- Re: Adding one to cell value
- Using Forcast Function in Excel
- Vlookup Calculations
- Re: complex SUMIF
- Re: SUMIF (Excel '97)
- Re: Excel in Office 2007
- Excel in Office 2007
- From: frustrated Professor
- RE: Automatically Updating Data from Multiple Worksheets into One
- Re: alternative cells
- From: BNT1 via OfficeKB.com
- Re: realtime
- Re: realtime
- How to insert a pop-up window showing line information?
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: Making 'True' =1 "false" =0
- Re: Making 'True' =1 "false" =0
- Re: complex SUMIF
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: Making 'True' =1 "false" =0
- Re: COUNTIF based on several criteria incl. a "does not equal" criteri
- Re: sumproduct - validating codes & dates
- Re: Making 'True' =1 "false" =0
- Re: Making 'True' =1 "false" =0
- Re: #Value Being Returned for Blank or Non Zero Value
- RE: Automate Combine 2 Spreadsheets into two worksheets
- Re: Sum.if date is in an interval...
- Re: SUMPRODUCT
- Re: excel spreadsheets
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: Insert Button in Excel
- Re: Conditional Formatting
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: excel spreadsheets
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: #Value Being Returned for Blank or Non Zero Value
- Re: SUM IF Function......
- Re: Insert Button in Excel
- Re: Sum If? Help
- Re: find and replace nonzero values with 1
- Re: find and replace nonzero values with 1
- #Value Being Returned for Blank or Non Zero Value
- Re: Exel increment date problem wrt todays date.
- Exel increment date problem wrt todays date.
- Re: Why is E3=>4 FALSE?
- Re: SUMPRODUCT
- Re: Why is E3=>4 FALSE?
- Re: Why is E3=>4 FALSE?
- Re: Why is E3=>4 FALSE?
- Re: Formulas
- Re: Excel Filter Question/Problem
- Re: SUMPRODUCT
- Re: formulas - hard to explain
- Re: Excel Filter Question/Problem
- RE: Automate Combine 2 Spreadsheets into two worksheets
- Re: formulas - hard to explain
- Re: SUMPRODUCT
- Re: Adding Numbers
- RE: HOW TO CALCULATE
- RE: Moving scattered cell data to new column?
- Re: Change dates to a formula
- HOW TO CALCULATE
- Re: Adding Numbers
- Insert Button in Excel
- Re: Change dates to a formula
- Re: SUMIF with two conditions (or)
- Re: Excel Filter Question/Problem
- Re: Excel Filter Question/Problem
- Change dates to a formula
- Re: SUMIF with two conditions (or)
- Re: SUMIF with two conditions (or)
- Re: SUMIF with two conditions (or)
- Re: SUMIF with two conditions (or)
- SUMIF with two conditions (or)
- Re: If then go to - With a drop box? - Follow Up Question
- Re: If then go to - With a drop box? - Follow Up Question
- Re: Formula Advice
- Re: Formula Advice
- RE: If then go to - With a drop box? - Follow Up Question
- Re: Formula Advice
- Re: Formula Advice
- Re: SUMIF (Excel '97)
- RE: If then go to - With a drop box? - Follow Up Question
- Re: Formula Advice
- RE: If then go to - With a drop box? - Follow Up Question
- Re: insert a date that is updated in an excell cell
- Re: Convert Multiple Column Values into 1 column
- Re: traffic in erlang
- Re: Dynamic Worksheet functions
- Re: traffic in erlang
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Excel Filter Question/Problem
- Re: Dynanic Worksheet functions
- Re: Formulas
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Excel Filter Question/Problem
- Re: Negative time calculations
- Re: Dynanic Worksheet functions
- Re: Dynanic Worksheet functions
- Re: Negative time calculations
- Re: SUMIF (Excel '97)
- Excel Filter Question/Problem
- Re: SUMIF (Excel '97)
- Negative time calculations
- Re: Formula Advice
- Re: Hlookup-row_index_num question
- Re: Name Cell or Worksheet
- Re: Formula Advice
- Re: SUMIF (Excel '97)
- Re: Depending on Account cell is gray or white question.
- Formula Advice
- Re: SUMPRODUCT
- SUMPRODUCT
- SUMPRODUCT
- Re: SUMIF (Excel '97)
- Re: international postal codes
- Re: international postal codes
- Re: Subtract 3 days from Date with a Twist Q
- RE: hyperlink - PDF file - relative reference
- Re: If then go to
- Re: Subtract 3 days from Date with a Twist Q
- Re: Subtract 3 days from Date with a Twist Q
- Re: Subtract 3 days from Date with a Twist Q
- Re: Subtract 3 days from Date with a Twist Q
- Subtract 3 days from Date with a Twist Q
- Re: Code for dragging the last column
- RE: If then go to
- Re: color entire row by using conditional format
- Re: Name Cell or Worksheet
- Re: Pivot Table Formatting
- Problem in Excel while opening after a power failure
- Re: deduplicate rows matching three columns
- Re: HOW DO I REMOVE AND UNWANTED FUNCTION IN A CELL OR GROUP OF CELLS
- Re: HOW DO I REMOVE AND UNWANTED FUNCTION IN A CELL OR GROUP OF CELLS
- Re: sumproduct - validating codes & dates
- Re: Hlookup-row_index_num question
- Re: HOW DO I REMOVE AND UNWANTED FUNCTION IN A CELL OR GROUP OF CELLS
- Re: Excel 2003 sp2 autosum gets inserted automatically
- Retrieving a document
- Re: Hyperlink or not??
- Re: IF formula
- Re: SUMPRODUCT w/ 3 criteria
- Re: alternative cells
- Re: Calculating Regular time, overtime and double time
- Re: Calculating Regular time, overtime and double time
- Re: Splitting dd/mm/yyyy hh:mm
- Re: Excel 2003 Lookup function
- Re: Hlookup-row_index_num question
- Re: Formula Subtracting Business Days
- From: Rick Rothstein \(MVP - VB\)
- Re: Command to change the value of a cell within same cell
- Re: international postal codes
- Re: Create new worksheet from template for each value in range
- RE: how to make rows 'sort with' between sheets during separate so
- Re: Calculating Regular time, overtime and double time
- Re: Lookup
- Re: Count age ranges
- Re: Code for dragging the last column
- Re: Command to change the value of a cell within same cell
- Re: Code for dragging the last column
- Re: Code for dragging the last column
- Re: Find unique value in list (TIME), not working
- Re: Lookup
- deduplicate rows matching three columns
- Re: Count age ranges
- Re: Pivot Table Formatting
- Re: Code for dragging the last column
- Re: Making email address from name column
- Re: Count age ranges
- Re: Count age ranges
- Re: Making email address from name column
- Re: Count age ranges
- Re: Lookup
- Code for dragging the last column
- Re: Lookup
- Re: Count age ranges
- Re: Depending on Account cell is gray or white question.
- Re: cell formatting won't update
- Re: Incremental Numbering whitin a formula
- Re: MAX from different columns
- Re: MAX from different columns
- Re: Formula/Approach Question
- Re: function for counting how many times a Q is answered wrong
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: dsum evaluating only the beginning of a string?
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- Re: Adding date/time in format dd/mm/yyyy hh/mm
- RE: dsum evaluating only the beginning of a string?
- compare and match test
- Re: alternative cells
- From: BNT1 via OfficeKB.com
- RE: Cell Format
- RE: PEARSON versus CORREL
- Re: alternative cells
- RE: Cell Format
- RE: Cell Format
- Re: "Deactivating" Cells
- Re: goal seek multiple cells
- Re: Value Prediction
- alternative cells
- From: BNT1 via OfficeKB.com
- PEARSON versus CORREL
- RE: Lookup valid combination of multiple cells
- Re: when I drag a formula to other cells the reference is the same
- Re: match 2 cell with chinese character value
- Re: Find unique value in list (TIME), not working
- Re: countif2
- Re: Countif?
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Depending on Account cell is gray or white question.
- Re: Counting matches from more columns
- Re: Concatenation in Excel 2003
- Re: Vlookup displays wrong result
- Re: How to clear multiple cells of input data in Excel simultaneou
- Re: How to clear multiple cells of input data in Excel simultaneously
- Re: How to clear multiple cells of input data in Excel simultaneously
- Re: Dates
- Re: Dates
- Re: Need Formula Help Form Table
- Counting matches from more columns
- Re: Old DOS to Excel ?
- Re: Need Formula Help Form Table
- Re: Increment
- Re: Adding one to cell value
- Re: Adding one to cell value
- Re: Vlookup displays wrong result
- Re: IF Formula take 2
- Re: Increment
- Re: Vlookup displays wrong result
- Re: use button to return random numbers
- Re: Need Formula Help Form Table
- Re: Creating If Then statements from table
- Re: Need Formula Help Form Table
- Re: How keep Excel from counting empty cells when calculating formula
- Re: Concatenation in Excel 2003
- Re: IF function help
- Re: IF function help
- Re: Making email address from name column
- Re: Vlookup displays wrong result
- Re: IF function help
- Re: IF function help
- sumproduct - validating codes & dates
- RE: Old DOS to Excel ?
- Re: IF function help
- Re: Value Prediction
- Re: Prevent a Weekend date entry
- From: Rick Rothstein \(MVP - VB\)
- Re: Creating If Then statements from table
- Re: Vlookup displays wrong result
- Re: substitution: a better method?
- Re: Create new worksheet from template for each value in range
- Re: Value Prediction
- Vlookup displays wrong result
- Re: Old DOS to Excel ?
- Re: Concatenation in Excel 2003
- Re: Unsorting after save
- Re: IF function help
- Problem consolidating data.
- Re: Value Prediction
- RE: Old DOS to Excel ?
- Re: Prevent a Weekend date entry
- From: Rick Rothstein \(MVP - VB\)
- Re: How can I set up a validation list and source to another workshee
- Re: Depending on Account cell is gray or white question.
- RE: Unique names in a list reported everyday
- RE: Concatenation in Excel 2003
- Re: Concatenation in Excel 2003
- Re: option button grouping
- Manipulating Arrays
- Re: Unsorting after save
- RE: option button grouping
- Re: IF Formula take 3
- Re: substitution: a better method?
- Re: cell formatting
- From: Rick Rothstein \(MVP - VB\)
- Re: Unsorting after save
- Re: IF Formula take 3
- option button grouping
- Re: Unlocked Cells in Protected Sheet
- Re: cell formatting
- From: Rick Rothstein \(MVP - VB\)
- Re: cell formatting
- Re: Unlocked Cells in Protected Sheet
- RE: Formatting? may be
- Re: Hyperlink to range of cells
- RE: Unique names in a list reported everyday
- Re: Alt + enter is not inserting a line break within a cell in Excel?
- Re: IF Formula take 2
- Re: substitution: a better method?
- RE: substitution: a better method?
- Formatting? may be
- Re: Transposeing data
- Re: Separating information in cell
- Alt + enter is not inserting a line break within a cell in Excel?
- Re: Depending on Account cell is gray or white question.
- Re: Average the POSITIVE values only
- Re: IF formula with 3 possible outcomes
- RE: Lookup valid combination of multiple cells
- Re: Indirect - Multiple Sheets/Cells
- Re: How can I get date of file creation to XLS cell in date format?
- Re: IF Formula
- Re: IF Formula
- Re: remove colored rows
- Re: IF formula with 3 possible outcomes
- From: Aaron Hodson \(Coversure\)
- Re: Formaulating in Execel
- RE: Depending on Account cell is gray or white question.
- Re: Indirect - Multiple Sheets/Cells
- Create new worksheet from template for each value in range
- Re: Depending on Account cell is gray or white question.
- Re: Depending on Account cell is gray or white question.
- Re: Price Function
- RE: substitution: a better method?
- Re: substitution: a better method?
- Re: Return the minimum number in a range excluding zero
- Re: Transposeing data
- Re: Return the minimum number in a range excluding zero
- Transposeing data
- Re: IF formula with 3 possible outcomes
- RE: Value Prediction
- Re: Price Function
- Re: Price Function
- Re: IF formula with 3 possible outcomes
- From: Aaron Hodson \(Coversure\)
- Re: IF formula with 3 possible outcomes
- From: Aaron Hodson \(Coversure\)
- RE: Lookup valid combination of multiple cells
- IF formula with 3 possible outcomes
- From: Aaron Hodson \(Coversure\)
- Re: remove colored rows
- Re: INDEX FORMULAS & MULTIPLE TABLES
- From: Aaron Hodson \(Coversure\)
- Re: Question re Vlookup function within Excel.
- Re: Question re Vlookup function within Excel.
- Re: Counting the number of errors in a worksheet
- Re: Counting the number of errors in a worksheet
- Re: Question re Vlookup function within Excel.
- Re: How to replace sheet name in a formula?
- Re: Get address into 1 cell
- Re: Average the POSITIVE values only
- Re: Min function excluding zero
- Re: Formula help
- RE: Hyperlink to range of cells
- Re: Formula help
- Re: how do you find the earliest date when using an IF function?
- Value Prediction
- Re: how do you find the earliest date when using an IF function?
- Re: Min function excluding zero
- Re: how do you find the earliest date when using an IF function?
- Re: AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
- Re: Average the POSITIVE values only
- Re: rdounding numbers with text
- Re: Formula Help
- Re: Help with SUMPRODUCT please : )
- Re: Pivot Table Sorting
- Re: Help with SUMPRODUCT please : )
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Can I use wildcard characters in array formulas
- Re: offset
- Re: Separating information in cell
- Re: Help with SUMPRODUCT please : )
- Re: How can dynamically set a range name in a HLOOKUP command?
- Re: Separating information in cell
- RE: sorting multiple columns
- RE: sorting multiple columns
- Re: rdounding numbers with text
- Re: rdounding numbers with text
- RE: sorting multiple columns
- Re: Counting formula question
- Re: Counta or daveragea functions
- Re: Help with SUMPRODUCT please : )
- Re: SUMPRODUCT with 2 criterias
- Re: rdounding numbers with text
- Re: Help with SUMPRODUCT please : )
- Data Validation
- Re: spectral decomposition
- Re: How to use sum/average function on 3 consecutive values
- Re: count specific weedays remaining in quarter
- Re: SUMPRODUCT with 2 criterias
- Re: SUMPRODUCT with 2 criterias
- Re: How do I sort in English Date format
- Re: How do I sort in English Date format
- How to use sum/average function on 3 consecutive values
- Re: Counta or daveragea functions
- RE: Sheet Code
- Re: Help please!
- Re: Formula Help please
- Re: Copy cell to another cell using Macro
- RE: auto fill color of row
- RE: how to make rows 'sort with' between sheets during separate so
- Re: Copy cell to another cell using Macro
- Re: counting function but not double counting duplicates
- Re: Counta or daveragea functions
- Re: Max/Min function help
- Re: Counting
- Re: Counting
- Re: Subtotal Formula
- Re: Subtotal Formula
- Re: Formula Question
- Re: Hyperlink to range of cells
- Re: Subtotal Formula
- Re: Formula Question
- Re: Subtotal Formula
- Re: Copy cell to another cell using Macro
- advanced lookup?
- RE: Sheet Code
- Re: HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN
- Re: Copy cell to another cell using Macro
- Re: vlookup and sort error
- Re: how do I find the copy down function
- Re: vlookup and sort error
- Re: INDEX FORMULAS & MULTIPLE TABLES
- Re: delete uncolour row
- RE: Hyperlink or not??
- Re: Question re Vlookup function within Excel.
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: count specific weedays remaining in quarter
- Re: cut & paste IF?
- RE: Hyperlink to range of cells
- Re: count specific weedays remaining in quarter
- Re: Formula Question
- Re: AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
- Re: remove colored rows
- From: joytickle@xxxxxxxxx
- Re: AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
- count specific weedays remaining in quarter
- Re: find a number within data by formula
- Re: Extracting duplicates with row ref's to a list
- Re: AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
- Re: find a number within data by formula
- RE: Hyperlink to range of cells
- Re: Comparing figures across 2 columns.
- Re: how convert numbers to words
- Re: how convert numbers to words
- Re: how convert numbers to words
- Re: INDEX FORMULAS & MULTIPLE TABLES
- From: Aaron Hodson \(Coversure\)
- RE: remove colored rows
- Re: Comparing figures across 2 columns.
- Re: adding range of numbers to if statement with three criteria
- Re: Get address into 1 cell
- Re: Formula Help please
- Re: financial function / annual rate of return
- Hyper link in Excel
- Re: How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell
- Hyperlink to range of cells
- Re: HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN
- Re: Max/Min function help
- Re: delete uncolour row
- Re: HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYING 6.
- Re: setting the date to monday
- setting the date to monday
- Re: VLOOKUP - Help wanted
- Re: Extracting duplicates with row ref's to a list
- HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYING 6.
- Re: Max/Min function help
- Re: Max/Min function help
- Re: Max/Min function help
- Re: Max/Min function help
- The ebay of Loan Websites
- From: eauclaire101@xxxxxxxxx
- The ebay of Loan Websites
- From: eauclaire101@xxxxxxxxx
- The ebay of Loan Websites
- From: eauclaire101@xxxxxxxxx
- delete uncolour row
- Re: Copy cell to another cell using Macro
- Re: Max/Min function help
- Re: Time Calc
- Re: Lookup
- Re: Array Lookup to Find Closest Date and Next Closest Date
- Re: Alt+Enter not giving me a line break
- RE: Formula Help please
- Re: Array Lookup to Find Closest Date and Next Closest Date
- Re: Extracting duplicates with row ref's to a list
- Re: links to other data sources
- Re: VLOOKUP - Help wanted
- Re: CountIf question
- Re: Formula Question
- Hyperlink or not??
- Re: Formula Question
- Re: Formula Question
- Re: Lookup
- RE: loan amortization loan in months
- From: joeu2004@hotmail.com
- Re: Pivot table NOT showing zero value calculations
- Re: formulas
- Re: How do I compare rows where there are 30+ columns
- Re: Look up data on the next line
- Re: Date Formulas
- Re: links to other data sources
- links to other data sources
- Re: How to show all precedent arrows on whole worksheet at same time?
- Date Formulas
- Re: Lookup data based on data comparison
- Re: conditional summing of data from another worksheet
- RE: If formula
- Re: Increase amount to achieve target
- Re: financial function / annual rate of return
- Re: Lookup
- Re: Time Calc
- Re: Time Calc
- Re: How do I compare rows where there are 30+ columns
- Re: Increase amount to achieve target
- Time Calc
- Re: IF STATEMENTS NOT WORKING
- Re: Making labels out of specific entries in Excel
- Re: Fill Values in Cells to the right
- Re: REPORTING unique values
- Re: In Excel, how do I make a cell equals the sheet name?
- Re: Formula Omits Adjacent Cells
- Re: Formats and Data validations changes are not sticking
- Re: loan amortization loan in months
- Re: In Excel, how do I make a cell equals the sheet name?
- Re: Formula Omits Adjacent Cells
- Re: Formula Omits Adjacent Cells
- Re: VLOOKUP - Help wanted
- Re: VLOOKUP - Help wanted
- Re: IF STATEMENTS NOT WORKING
- Re: loan amortization loan in months
- Re: IF STATEMENTS NOT WORKING
- Re: Array Lookup to Find Closest Date and Next Closest Date
- Re: REPORTING unique values
- Re: Cell containgn a date and a text
- Re: IF STATEMENTS NOT WORKING
- Re: loan amortization loan in months
- Re: Lookup data based on data comparison
- Re: Rounding up or down in the same formula
- Formula For Labeling Part Numbers
- Re: Referencing Cells on Different Worksheets
- Re: loan amortization loan in months
- Formats and Data validations changes are not sticking
- Re: conditional summing of data from another worksheet
- Re: Limiting a returned calc to 195
- Re: Searching for a contact without going through the whole list.
- Re: Array Lookup to Find Closest Date and Next Closest Date
- Re: Array Lookup to Find Closest Date and Next Closest Date
- Re: financial function / annual rate of return
- Re: Rounding up or down in the same formula
- Re: Searching for a contact without going through the whole list.
- Re: Formula Omits Adjacent Cells
- Re: Formula Omits Adjacent Cells
- Re: Rounding up or down in the same formula
- Re: sumif for months and year
- Re: Workbook performance is too weak
- Re: Rounding up or down in the same formula
- Re: Rounding up or down in the same formula
- Re: To change the application to start if i run a hyperlink
- Re: Lookup
- Re: Combo Box enable and disable
- RE: Lookup
- Re: Limiting a returned calc to 195
- Re: EXCEL: how do I add multiple one digits in a singe cell? (tally)
- Re: IF STATEMENTS NOT WORKING
- Re: Fill Values in Cells to the right
- From: excelexpert1973@xxxxxxxxx
- Re: Limiting a returned calc to 195
- Array Lookup to Find Closest Date and Next Closest Date
- Re: Indirect.ext
- Re: Limiting a returned calc to 195
- Re: dates in excel show up as text numbers in merge with word doc
- Limiting a returned calc to 195
- Re: Automatically insert rows with formula
- Re: Get address into 1 cell
- Data Selection and Averaging
- Re: Indirect.ext
- Re: Using cell reference in a formula instead of the obtained value
- Re: Indirect.ext
- Re: Logical test if cell uses formatting..
- Re: INDEX FORMULAS & MULTIPLE TABLES
- Re: AND function using COUNTIF
- RE: POP UP WINDOW
- Re: Formula
- Re: AND function using COUNTIF
- Re: Annual Cost of Equipment
- Re: AND function using COUNTIF
- Re: Annual Cost of Equipment
- Re: Annual Cost of Equipment
- Re: auto fill color of row
- Re: Question re Vlookup function within Excel.
- Re: PivotTable Field Name
- Re: Formula
- Re: INDEX FORMULAS & MULTIPLE TABLES
- From: Aaron Hodson \(Coversure\)
- Logical test if cell uses formatting..
- Re: auto fill color of row
- Annual Cost of Equipment
- Re: Cell containgn a date and a text
- Re: Comparing figures across 2 columns.
- Extracting duplicates with row ref's to a list
- Re: complex SUMIF
- Re: Comparing figures across 2 columns.
- RE: Comparing figures across 2 columns.
- Re: Create Comments
- Re: how to seen diference colour after before 30 days
- To change the application to start if i run a hyperlink
- Re: REPORTING unique values
- Re: REPORTING unique values
- complex SUMIF
- automatic capital letter in a cell
- Re: function & column labels
- Re: Problem with COUNTIF ...
- Re: Referencing Cells on Different Worksheets
- how to seen diference colour after before 30 days
- Re: REPORTING unique values
- Re: Using cell reference in a formula instead of the obtained value
- Re: Lookup
- Re: Vlookup+ Select Next Earliest Value (Array formula?)
- Re: Lookup
- Re: Cell containgn a date and a text
- Re: Display formulae instead of showing values in cells
- Re: Is there a Best Of Function in Excel?
- Re: REPORTING unique values
- Re: Is there a Best Of Function in Excel?
- Re: VLOOKUP data missed
- RE: Lookup
- Re: Lookup
- Re: Get address into 1 cell
- Fill Values in Cells to the right
- From: excelexpert1973@xxxxxxxxx
- Re: Automatically insert rows with formula
- Re: EXCEL: how do I add multiple one digits in a singe cell? (tally)
- Re: EXCEL: how do I add multiple one digits in a singe cell? (tally)
- Re: (Max - Min) for a dynamic range within a table
- Re: Hyperlink formula with destination in same worksheet
- Re: mortgage payment
- Re: (Max - Min) for a dynamic range within a table
- From: steven.britton@xxxxxxxxxxxxxxxxxxx
- Re: Get address into 1 cell
- Vlookup+ Select Next Earliest Value (Array formula?)
- Re: REPORTING unique values
- Re: Cell containgn a date and a text
- RE: Lookup
- Re: VLOOKUP
- RE: Lookup
- Get address into 1 cell
- RE: REPORTING unique values
- Re: Summing
- Re: Summing
- Re: Lookup data based on data comparison
- Re: Summing
- Re: Summing
- Re: summing non-contiguous array cells
- Summing
- Re: Cell containgn a date and a text
- Re: PivotTable Field Name
- Re: REPORTING unique values
- Re: REPORTING unique values
- Re: REPORTING unique values
- Re: summing non-contiguous array cells
- Lookup
- Re: REPORTING unique values
- Re: REPORTING unique values
- Re: summing non-contiguous array cells
- Re: REPORTING unique values
- Re: summing non-contiguous array cells
- Re: REPORTING unique values
- Re: REPORTING unique values
- Re: summing non-contiguous array cells
- Re: summing non-contiguous array cells
- Re: summing non-contiguous array cells
- Re: summing non-contiguous array cells
- Re: (Max - Min) for a dynamic range within a table
- Re: summing non-contiguous array cells
- RE: (Max - Min) for a dynamic range within a table
- Re: change background color in cells
- Re: change background color in cells
- Re: matching/comparing lists
- Re: Different Results in each time I click on F9
- (Max - Min) for a dynamic range within a table
- From: steven.britton@xxxxxxxxxxxxxxxxxxx
- Re: Filters
- Re: Help with Logical Formula
- Re: Automatically insert rows with formula
- Re: Large Time totals not summing.
- Re: conditional format question - I think...
- matching/comparing lists
- Re: conditional format question - I think...
- Re: Large Time totals not summing.
- Re: Combo Box enable and disable
- Re: VBA help for functions
- Re: conditional format question - I think...
- conditional format question - I think...
- Re: Large Time totals not summing.
- Re: Large Time values not summing
- Re: Large Time values not summing
- Large Time totals not summing.
- Calculating and posting when a qty will go negative.
- Re: Pivot on a shared workbook
- Large Time values not summing
- Re: Pivot Table Calculations
- Re: Filters
- Re: Lookup data based on data comparison
- Re: Lookup data based on data comparison
- RE: DocumentProperty
- RE: DocumentProperty
- RE: DocumentProperty
- Re: Lookup data based on data comparison
- Re: Replicating worksheet references
- Re: INDEX FORMULAS & MULTIPLE TABLES
- Re: worksheet function to summarise a list of text?
- RE: DocumentProperty
- RE: DocumentProperty
- Re: INDEX FORMULAS & MULTIPLE TABLES
- Re: minif
- Re: INDEX FORMULAS & MULTIPLE TABLES
- From: Aaron Hodson \(Coversure\)
- Remove headers in file
- RE: IF Statement: cell referencing
- Re: INDEX FORMULAS & MULTIPLE TABLES
- INDEX FORMULAS & MULTIPLE TABLES
- From: Aaron Hodson \(Coversure\)
- Re: using 3 tables in one spreadsheet and utilising index formula to retrieve information
- From: Aaron Hodson \(Coversure\)
- Re: Replicating worksheet references
- Re: CountIf question
- RE: Vvlookup and count
- Re: Vvlookup and count
- Shared Worksheet--secure last entry
- Auto insert row:
- RE: Vvlookup and count
- Re: Vvlookup and count
- Re: minif
- RE: IF Statement: cell referencing
- Re: Comparing data in 2 cells to create an output for a 3rd cell
- RE: Comparing data in 2 cells to create an output for a 3rd cell
- Re: IF Statement: cell referencing
- Comparing data in 2 cells to create an output for a 3rd cell
- Re: CountIf question
- Re: Protect cell range
- Re: Replicating worksheet references
- Re: Populating a Range Dependant on a List
- DocumentProperty
- Re: Autofiltering
- Re: VLOOKUP data missed
- VLOOKUP data missed
- Re: using the if command I think
- Protect cell range
- Re: How to define and select the last (bottom) number in a column?
- Re: percentage
- Re: percentage
- percentage
- CountIf question
- Re: counting the number of events in a year
- Re: Help with a formula
- Re: using the if command I think
- Re: worksheet function to summarise a list of text?
- Re: RTD Function
- Re: worksheet function to summarise a list of text?
- RTD Function
- Re: Populating a Range Dependant on a List
- Re: Populating a Range Dependant on a List
- Re: Exponential
- Re: please help with lookup function
- Re: Help with a formula
- Re: please help with lookup function
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Re: Any good excel websites?
- Any good excel websites?
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Trying to check 2 columns for text and add a 3rd col to total
- Trying to check 2 columns for text and add a 3rd col to total
- Re: SUMPRODUCT & INDIRECT?
- Re: Populating a Range Dependant on a List
- Re: Populating a Range Dependant on a List
- Re: Advanced Sum or marco needed????
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: Circular
- Re: Populating a Range Dependant on a List
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: Circular
- Re: SUMPRODUCT & INDIRECT?
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: formula adjustment
- From: Rick Rothstein \(MVP - VB\)
- Re: formula adjustment
- TECHNICS U EVER DREAMED OF ....
- From: TECHNICS U EVER DREAMED OF ....
- TECHNICS U EVER DREAMED OF ....
- From: TECHNICS U EVER DREAMED OF ....
- Re: Circular
- Re: Circular
- Re: SUMPRODUCT & INDIRECT?
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: please help with lookup function
- Re: SUMPRODUCT & INDIRECT?
- Re: formula help
- Re: cell referencing
- Re: cell referencing
- cell referencing
- Re: Circular
- Re: How do I separate wrap text in excel spreadsheet?
- Re: How can I clear all cells containing #n/a on a spreadsheet?
- Re: Formula Help needed
- Re: formula help
- Re: How to define and select the last (bottom) number in a column?
- Re: Macros to cells, formula only not data locked
- Re: Populating a Range Dependant on a List
- Re: Macros to cells, formula only not data locked
- Re: How do I separate wrap text in excel spreadsheet?
- SUMPRODUCT & INDIRECT?
- RE: formula help
- POP UP WINDOW
- Re: Maximum Number of Blank Cells between Non Blank Cells in a Range
- Re: Excel 2007 Not Responding
- Re: Maximum Number of Blank Cells between Non Blank Cells in a Range
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: How to define and select the last (bottom) number in a column?
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: How to define and select the last (bottom) number in a column?
- Re: Macros to cells, formula only not data locked
- Re: i need help with a function application with multiple arguments
- Re: i need help with a function application with multiple arguments
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to define and select the last (bottom) number in a column?
- i need help with a function application with multiple arguments
- Re: Advanced Sum or marco needed????
- Re: Maximum Number of Blank Cells between Non Blank Cells in a Range
- Re: Populating a Range Dependant on a List
- Re: Advanced Sum or marco needed????
- Re: Maximum Number of Blank Cells between Non Blank Cells in a Range
- Advanced Sum or marco needed????
- Re: "--" (was "DCOUNT Unique Values")
- Re: Change colour of cells depending on entry in one cell
- Re: Will macro work in shared workbook
- Maximum Number of Blank Cells between Non Blank Cells in a Range
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Excel 2007 Not Responding
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: search for any lowercase immediately followed by an UPPERCASE
- Re: Populating a Range Dependant on a List
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to define and select the last (bottom) number in a column?
- Populating a Range Dependant on a List
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Rank/Large Help
- Re: VBA help for functions
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Inputed Interest / Present Value
- RE: Inputed Interest / Present Value
- Re: Time
- Re: Inputed Interest / Present Value
- RE: Time
- RE: Inputed Interest / Present Value
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Want to dump text written on page 1 to page 2 in excel
- Re: ALT E Problem in Excel
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Want to dump text written on page 1 to page 2 in excel
- Re: Will macro work in shared workbook
- Re: Hyperlink changes when I email work sheet how do I prevent this?
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: ALT E Problem in Excel
- Re: Matching two column ranges with a date
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- Re: How to define and select the last (bottom) number in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: VBA help for functions
- Re: VBA help for functions
- RE: Rank/Large Help
- Re: Is there a way to set a cell value to be constant in formulas?
- Re: Matching two column ranges with a date
- Re: using 3 tables in one spreadsheet and utilising index formula to retrieve information
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: Moving a button on worksheet
- Re: Moving a button on worksheet
- using 3 tables in one spreadsheet and utilising index formula to retrieve information
- From: Aaron Hodson \(Coversure\)
- Re: 3d array not working
- Re: 3d array not working
- Re: minif
- Re: Autofiltering
- Re: Autofiltering
- Re: Calculate average of ratings as a function of length
- RE: search for any lowercase immediately followed by an UPPERCASE
- Re: Restrict open access
- From: www.exciter.gr: Custom Excel Functions!
- Re: minif
- Re: Moving a button on worksheet
- Re: "--" (was "DCOUNT Unique Values")
- Re: specified time / copy worksheet + save
- Re: Moving a button on worksheet
- Re: Change colour of cells depending on entry in one cell
- Re: cell content into a note
- Re: specified time / copy worksheet + save
- Re: Is there a way to set a cell value to be constant in formulas?
- Re: Is there a way to set a cell value to be constant in formulas?
- "--" (was "DCOUNT Unique Values")
- Re: Round, but give at least a value of 1 Q
- Re: Visual basic, form does not show date correctly....
- Round, but give at least a value of 1 Q
- RE: search for any lowercase immediately followed by an UPPERCASE
- Re: I can't open up a file, its says I'm missing xlr.. what is that
- Restrict open access
- Re: Is there a function to get column # of cell with matching value
- search for any lowercase immediately followed by an UPPERCASE
- Re: Would I use "Lookup" to pick names for a Christmas grab bag
- Re: Drop Down/List w/Code and Definition, only code entered when selec
- Re: finding duplicate cell and deleting both
- Re: cell content into a note
- Re: FORMATING WITHIN CELL
- Re: Round formula
- Re: Vertical footer placement
- Re: Excel 2007 Not Responding
- Re: ALT E Problem in Excel
- Re: Split one cell in the middle and fill each with one color
- Re: How do I very nice reports from excel Please ?
- Re: FORMATING WITHIN CELL
- Re: cell content into a note
- Re: Excel 2007 Not Responding
- Re: ALT E Problem in Excel
- Re: FORMATING WITHIN CELL
- Re: Excel 2007 Not Responding
- Re: FORMATING WITHIN CELL
- cell content into a note
- Re: FORMATING WITHIN CELL
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: automatic cell numbering
- FORMATING WITHIN CELL
- Project Purchase & budget tracking tool
- Re: how to increment time & subtract time?
- Re: convert string to number
- Re: Problem with using INDIRECT with SUMPRODUCT and ROW()
- Re: convert string to number
- Re: convert string to number
- Re: convert string to number
- convert string to number
- Re: Round formula
- Re: Seems simple, but...Please Help!!!
- Re: Round formula
- Re: How do I very nice reports from excel Please ?
- Re: finding duplicate cell and deleting both
- Re: Seems simple, but...Please Help!!!
- Re: How do I...
- cell background color and cell text color
- Re: how to increment time & subtract time?
- Re: Returning a Value from a Table, dependant on the word Typed
- Re: VLookup Returning last cell??
- Re: how to increment time & subtract time?
- From: Rick Rothstein \(MVP - VB\)
- RE: lower case to Proper help needed in Excel Office 2007
- Re: how to increment time & subtract time?
- Re: Excel 2007 Not Responding
- Re: Split one cell in the middle and fill each with one color
- Re: Split one cell in the middle and fill each with one color
- Re: Split one cell in the middle and fill each with one color
- Re: Muliple Worksheet Lookup
- Re: Seems simple, but...Please Help!!!
- Re: how to increment time & subtract time?
- Re: can I use Indirect function within range definitons for names?
- Re: How to insert formulas from four worksheets into one worksheet
- Re: VLookup Returning last cell??
- Re: VLookup Returning last cell??
- Re: Prevent edit of cells
- Re: VLookup Returning last cell??
- Re: VLookup Returning last cell??
- Re: VLookup Returning last cell??
- Re: Multiple Logical Conditions With Date and String Comparison No
- Re: VLookup Returning last cell??
- Re: How do I...
- Re: how to increment time & subtract time?
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I...
- Re: Pivot Table Template
- Re: A Query
- Re: open up a pop up window in excel 2007
- Re: how to increment time & subtract time?
- Re: Returning a Value from a Table, dependant on the word Typed
- RE: lower case to Proper help needed in Excel Office 2007
- Re: how to increment time & subtract time?
- From: Rick Rothstein \(MVP - VB\)
- Re: Desparate..please help
- Re: Macro to email worksheet
- Re: prorate formula
- Re: Loss Run on Excel worksheet......Any Ideas??
- Re: alphabetical sort
- Re: how to increment time & subtract time?
- Re: alphabetical sort
- Re: Loss Run on Excel worksheet......Any Ideas??
- how to increment time & subtract time?
- Re: alphabetical sort
- RE: lower case to Proper help needed in Excel Office 2007
- Re: Desparate..please help
- Re: Find last name in multi-part name?
- Re: How do I sum transactions for one bank when 4 banks are listed?
- Re: Find Special Characters
- Re: Change colour of cells depending on entry in one cell
- Re: lower case to Proper help needed in Excel Office 2007
- Re: Pivot Table Template
- Re: Desparate..please help
- Re: Find last name in multi-part name?
- Re: Change colour of cells depending on entry in one cell
- Re: IF and VLOOKUP functions for a matrix overview
- Re: Change colour of cells depending on entry in one cell
- Re: VLookup
- Muliple Worksheet Lookup
- VLookup
- RE: VLookup
- Re: IF and VLOOKUP functions for a matrix overview
- Re: Loss Run on Excel worksheet......Any Ideas??
- Desparate..please help
- SQL & Like Query function in excel
- Re: Find last name in multi-part name?
- Re: COUNTIF Function
- Re: COUNTIF Function
- Re: SUM formula not working correctly
- Re: COUNTIF Function
- Re: Loss Run on Excel worksheet......Any Ideas??
- Re: Loss Run on Excel worksheet......Any Ideas??
- Re: Returning a Value from a Table, dependant on the word Typed
- Re: Change colour of cells depending on entry in one cell
- Re: Find Special Characters
- Re: Excel= can I count how many times letter a appears in 1 cell?
- Re: A Query
- Re: formatting of numbers within a string
- RE: Formulas not working correctly
- Re: VLookup Returning last cell??
- Re: Formulas not working correctly
- From: Rick Rothstein \(MVP - VB\)
- Re: formatting of numbers within a string
- From: Rick Rothstein \(MVP - VB\)
- Re: formatting of numbers within a string
- Re: formatting of numbers within a string
- Re: A Query
- formatting of numbers within a string
- Re: A Query
- Find Special Characters
- Re: Macro to email worksheet
- Re: Macro to email worksheet
- Re: Visual basic, form does not show date correctly....
- Re: Visual basic, form does not show date correctly....
- VLookup Returning last cell??
- Re: Conditional formatting and IF
- Re: Degrees Minutes Seconds
- Re: Counting function
- Re: Conditional formatting and IF
- Re: Degrees Minutes Seconds
- Degrees Minutes Seconds
- Re: Excel 2007 Not Responding
- Re: A Query
- Re: A Query
- Re: locate data from a chart by inserting data into a cell
- Re: conditional format if cell value 0 pattern red value blank nothing
- Re: How do I create a formula that continuously numbers my invoices?
- locate data from a chart by inserting data into a cell
- From: Aaron Hodson \(Coversure\)
- Re: Is there a way to create a list in excel with smilies instead of .
- Re: formatting page with VBA
- A Query
- Re: Counting function
- Re: Sumif date range
- Re: Excel= can I count how many times letter a appears in 1 cell?
- Re: Multiple Logical Conditions With Date and String Comparison Not wo
- Re: How can I clear all cells containing #n/a on a spreadsheet?
- Re: EXCEL:Can't open any file without error saying it's ALREADY open???
- Re: Excel= can I count how many times letter a appears in 1 cell?
- EXCEL:Can't open any file without error saying it's ALREADY open???
- Re: Excluding Hidden Rows from calculations
- Re: Normalize time series
- Re: date validation
- RE: Normalize time series
- Re: Using the returned value to look up an item
- Re: COUNTIF
- Re: Sread sheet that sorts and totals as you enter new lines
- Re: GETPIVOTDATA
- Normalize time series
- Re: Another formula problem
- Re: Round formula
- Re: Indicator lights
- Re: Indicator lights
- Re: Excluding Hidden Rows from calculations
- Re: Round formula
- Re: Vlookup a text string
- Re: Round formula
- Re: Excel= can I count how many times letter a appears in 1 cell?
- Re: Excluding Hidden Rows from calculations
- Re: How can I dynamically change a file link in a formula?
- Re: How can I dynamically change a file link in a formula?
- Re: Compare 2 Worksheets and return differences in a third.
