microsoft.public.excel.worksheet.functions
- Re: Validations: provide the ability to format the fonts in the li
- Re: AutoComplete - Forms Combobox
- Re: Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu
- Re: how to add a row between rows of data
- Re: Counting Entries in two lists
- Re: I Have two files that i need to compare?
- Re: Finding total via entered text
- Re: How to Breakup text in to two parts ina cell
- Re: can't edit a cell with a formula
- Re: Can i add up all green filled cells in a workbook?
- How to group multiple items in to three groups.
- can't edit a cell with a formula
- need help guys
- Re: How to Breakup text in to two parts ina cell
- Re: Add amount if record contains a value
- Re: Linear interpolation between two points found using a lookup funct
- Add amount if record contains a value
- Re: how do I find prime factors of a number
- Re: subtotals in a pivot table
- Re: how to split data from 1 row into two rows continuously
- Re: return multiple corresponding values using INDEX
- Re: Validations: provide the ability to format the fonts in the li
- Re: Validations: provide the ability to format the fonts in the li
- Re: unable to view color fill changes unless I print preview
- Re: Validations: provide the ability to format the fonts in the li
- Re: Validations: provide the ability to format the fonts in the li
- Re: Unwanted Repeats
- Re: Unwanted Repeats
- Re: How do I make the D.O.B. Column calculate in Age Colum in Excel?
- Re: Correct coding entry of VBA macros in Excel worksheet
- Re: Minif / Maxif ?
- Minif / Maxif ?
- Compound interest
- Re: Tables tab under the Insert tab
- Re: Using a 'Select' (Data Validation) List?
- Re: Calculation in left corner
- Re: Function Help Needed
- Re: Linear interpolation between two points found using a lookup funct
- Function Help Needed
- Re: SumIf
- Re: Countif? or Vlookup? Lost??
- Re: formula help
- Re: retrieve unique items with 2 criteria
- Re: How do I extract hyperlink as text from an array of hyperlinks?
- Countif and date check for second criteria
- Countif and date check for second criteria
- Re: look up function and sum values
- Re: Formula Instead Of A Pivot Table
- Re: Formula Instead Of A Pivot Table
- Re: This should be easy...
- Re: Editing a simple macro
- Re: SumIf
- This should be easy...
- Re: Formula Instead Of A Pivot Table
- Re: how to use sumbycolor fuction?
- Re: How do I format Excel to add new rows automatically?
- Re: IF function with value_if_true and value_if_false as equations
- Re: IF function with value_if_true and value_if_false as equations
- Re: retrieve unique items with 2 criteria
- Re: how to use sumbycolor fuction?
- Re: Count Number of Times Something appears
- Re: retrieve unique items with 2 criteria
- Re: Forecasting using arrays
- importing csv files and dates
- Re: Where's it gone?
- Re: Formula Instead Of A Pivot Table
- Re: Where's it gone?
- Re: Array Formula Problem
- Re: If Funtion
- Where's it gone?
- Array Formula Problem
- Re: formula help
- Re: Is it possible to create a workbook within a workbook?
- Re: COUNT or SUM with multiple criteria
- Re: Array Reference
- Re: how do I find prime factors of a number
- Re: Summing if several conditions apply
- Re: on a calander how do i enter more than one event in one square
- Re: extract decimal place digit
- Re: formula help
- Re: Count Number of Times Something appears
- Re: how do I find prime factors of a number
- Re: Count Number of Times Something appears
- Re: how do I find prime factors of a number
- Re: COUNTIF function when 2 conditions exist?
- Re: how do I find prime factors of a number
- extract decimal place digit
- Re: SumIf
- Re: COUNT with Multiple Criteria Error
- Re: Array Reference
- Re: COUNT with Multiple Criteria Error
- RE: Summing if several conditions apply
- Re: how do I find prime factors of a number
- Re: Sumif function with multiple criteria
- Re: VLOOKUP?
- Re: SumIf
- Re: results of "SUMIF" test criteria
- Re: VLOOKUP?
- Re: How to stop file open macro prompt after deleting all macros?
- Re: countif functions
- Re: How do I convert numbers to text like bahttext but in sterling
- Re: COUNT with Multiple Criteria Error
- Array Reference
- Re: Print all from list
- Re: VLOOKUP?
- Re: How do I make the D.O.B. Column calculate in Age Colum in Excel?
- Re: #NUM! in Date field calculation
- Re: how do I find prime factors of a number
- Re: VLOOKUP?
- Re: VLOOKUP?
- Re: Compare 2 columns - new worksheets
- Re: #NUM! in Date field calculation
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- From: Sam via OfficeKB.com
- Re: HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC
- VLOOKUP?
- Re: countif functions
- Re: HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC
- Re: HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC
- Re: formula help
- Re: Minimum but One??
- Re: Minimum but One??
- Minimum but One??
- Re: countif functions
- Re: countif functions
- Re: countif functions
- Re: Ignoring zero cells in IF statements
- Re: countif functions
- Re: How to Breakup text in to two parts ina cell
- Re: how do I find prime factors of a number
- Re: How to Breakup text in to two parts ina cell
- Re: Is This Possible?
- Re: Offset delivers value error with Named range
- Re: number convert to text
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- Re: selecting one from multiple occurrences
- Re: test if column isblank
- Re: Text Strings Swap
- Re: Is This Possible?
- Is This Possible?
- Re: Force format change in excel
- Re: Ignoring zero cells in IF statements
- Re: Validations: provide the ability to format the fonts in the list
- How to Breakup text in to two parts ina cell
- Re: Locking Sheets / Hiding Sheets
- Re: in excel conditional formatting find the greatest value in 4rows
- Re: how do I find prime factors of a number
- Re: minimum from various columns without zeroes
- Re: Locking Sheets / Hiding Sheets
- Re: minimum from various columns without zeroes
- Re: Unwanted Repeats
- Re: minimum from various columns without zeroes
- Re: minimum from various columns without zeroes
- Re: Locking Sheets / Hiding Sheets
- Re: how do I find prime factors of a number
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- From: Sam via OfficeKB.com
- Re: how do I find prime factors of a number
- Re: Zero replaces blank field when paste special is used
- Re: How do I pull a random sample of people from a list in excel?
- Re: how do I find prime factors of a number
- Re: How do I pull a random sample of people from a list in excel?
- Re: minimum from various columns without zeroes
- Re: how do I find prime factors of a number
- Re: Locking Sheets / Hiding Sheets
- Re: turn off auto subtotal
- Re: How do I pull a random sample of people from a list in excel?
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- Locking Sheets / Hiding Sheets
- Re: how do I find prime factors of a number
- Re: Delete text in cells but keep formula
- Re: Weird problem
- Re: Is there a "rank" like feature for alpha?
- Re: Is there a "rank" like feature for alpha?
- Re: Calculating averages excluding outliers...a question
- Re: Best way to tackle this problem...
- Re: Indexing/Matching True/False results
- RE: True or False
- From: joeu2004@hotmail.com
- Re: Unwanted Repeats
- Re: True or False
- Re: Calculating basic averages...a question
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- From: Sam via OfficeKB.com
- Best way to tackle this problem...
- Re: Calculating averages excluding outliers...a question
- Re: Calculating averages excluding outliers...a question
- Re: CONDITIONAL FORMAT
- Re: How do I perform multiple regression in Excel using two independe
- Re: Calculating basic averages...a question
- Re: Calculating basic averages...a question
- Re: Is there a "rank" like feature for alpha?
- Re: Can anyone help me Create Excel list of files in windows folders
- Re: I get error messages in Excel cells once I save a file
- Re: Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- Re: I can't delete a whole sheet in Excel. Option is grayed out.
- Re: How do you do a VLookup with two conditions?
- Re: how do i combine IF and OR function
- Re: How do I change the date format when importing a txt file?
- Re: How do you do a VLookup with two conditions?
- Re: Sumif function with multiple criteria
- Re: COUNT or SUM with multiple criteria
- Re: Calculating basic averages...a question
- Re: How do I pull a random sample of people from a list in excel?
- Re: Calculating basic averages...a question
- Is there a "rank" like feature for alpha?
- Re: COUNT or SUM with multiple criteria
- Re: Calculating averages excluding outliers...a question
- Calculating averages excluding outliers...a question
- Calculating basic averages...a question
- Summing if several conditions apply
- From: bexi_reyes@xxxxxxxxx
- Re: How do you do a VLookup with two conditions?
- Re: How do you do a VLookup with two conditions?
- Re: MCONCAT
- Re: How do you do a VLookup with two conditions?
- Hiding Columns
- Re: Filter problem
- Simple password generator
- Re: Vlookup max value only
- Filter problem
- Re: How do I pull a random sample of people from a list in excel?
- Re: Data falls in a range +/-1
- Re: results of "SUMIF" test criteria
- Re: how to remove gridlines from part of a worksheet only
- Re: Dispalcement, Vlookup problems.
- Re: Dispalcement, Vlookup problems.
- Re: Dispalcement, Vlookup problems.
- Re: Problem with lists
- Re: Nested Formula
- Re: Protest sheet but allow sort
- Re: Formula - Count multi filter ???
- Re: MCONCAT
- Re: Formula - Count multi filter ???
- Re: Protest sheet but allow sort
- Re: GESTEP
- Re: Modifying A Sumproduct Formula
- Re: Stop Loss Formulas for Stock Trading
- Re: One worksheet to calulate different items simultaneously
- Re: how to remove gridlines from part of a worksheet only
- Re: Vlookup max value only
- Re: Dispalcement, Vlookup problems.
- Re: Data falls in a range +/-1
- Re: EXTRACT NUMBERS FROM TEXT STRING
- Re: One worksheet to calulate different items simultaneously
- Re: Zero replaces blank field when paste special is used
- Re: Vlookup max value only
- Re: how to remove gridlines from part of a worksheet only
- Re: One worksheet to calulate different items simultaneously
- Re: Average of top 3 numbers.
- Vlookup max value only
- Re: Event Macro adjustment needed - need to change font color also
- Re: Ignoring zero cells in IF statements
- Re: Formula - Count multi filter ???
- Re: Dispalcement, Vlookup problems.
- Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
- From: Sam via OfficeKB.com
- Re: Ignoring zero cells in IF statements
- Re: using lookup to return more than one answer in date format
- Re: It seems to me that I need an event Macro,
- Re: Average of top 3 numbers.
- Ignoring zero cells in IF statements
- Re: MCONCAT
- Dispalcement, Vlookup problems.
- Re: selecting every eg 5th cell in a worksheet
- Re: sum number of cells based on letter/title criteria
- Re: Event Macro adjustment needed - need to change font color also
- Re: How do I pull a random sample of people from a list in excel?
- Re: in formulas how can I use contents of a cell?
- Re: Excel Function
- Re: how to remove gridlines from part of a worksheet only
- sum number of cells based on letter/title criteria
- Formula - Count multi filter ???
- Re: Help with using range names in sum function
- Event Macro adjustment needed - need to change font color also
- Re: Help with using range names in sum function
- Re: How do I include only visible cells in a range?
- Re: the answer to appear in more than one cell
- Re: Sort by Location
- Sort by Location
- Help with using range names in sum function
- Re: Excel Function
- Re: Editing a simple macro
- Re: COUNTIF or SUMIF or ??
- Re: Indexing/Matching True/False results
- Re: in formulas how can I use contents of a cell?
- COUNTIF or SUMIF or ??
- Re: Excel Function
- Re: Excel should have a formula for amortization.
- Re: MCONCAT
- Re: Need help again :D
- Re: What formula captures specified rows of data?
- Re: i forget my Microsoft Excel files password tell me the solution
- Re: i forget my Microsoft Excel files password tell me the solution
- Re: CONDITIONAL FORMAT
- Re: Data validation issue
- MCONCAT
- Re: how to remove gridlines from part of a worksheet only
- Excel Function
- Re: SUMIF INDIRECT
- Re: SUMIF INDIRECT
- Re: Please help me with a formula
- Re: How do I change data spacing in a column
- Re: Unwanted Repeats
- Need help again :D
- Re: Custom Format alphanumberic value with spaces
- Re: Please help me with a formula
- Re: Zero replaces blank field when paste special is used
- Re: SUMIF INDIRECT
- Re: SUMIF INDIRECT
- Re: What formula captures specified rows of data?
- Re: Found a SERIOUS bug in Excel !!!
- Re: excel function help
- Re: CONDITIONAL FORMAT
- Re: SUMIF
- Re: Found a SERIOUS bug in Excel !!!
- Re: Common Numbers Formula
- Re: Please help me with a formula
- Found a SERIOUS bug in Excel !!!
- Getting info from Internet
- Re: Unwanted Repeats
- Re: countdown dates by month
- Re: Average of top 3 numbers.
- Re: meaning of this function
- Re: It seems to me that I need an event Macro,
- Re: It seems to me that I need an event Macro,
- Re: Custom Format alphanumberic value with spaces
- Re: It seems to me that I need an event Macro,
- Re: adding a ' ie 'xxxx instead of xxxx
- Re: Auto fill multiple cells depending on single cell value
- Re: adding a ' ie 'xxxx instead of xxxx
- Re: Average of top 3 numbers.
- Re: It seems to me that I need an event Macro,
- Re: how to remove gridlines from part of a worksheet only
- Re: adding a ' ie 'xxxx instead of xxxx
- Re: DROP DOWN LISTS
- Re: Nested Formula
- Re: What formula captures specified rows of data?
- Re: adding a ' ie 'xxxx instead of xxxx
- Re: A difficult conditonal calculation
- Re: Pulling a Letter from a cell and filling another cell with info
- Re: DROP DOWN LISTS
- From: eternal_cat via OfficeKB.com
- Re: Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?
- From: Sam via OfficeKB.com
- Re: Help With Formula
- Re: Help With Formula
- Re: adding a ' ie 'xxxx instead of xxxx
- adding a ' ie 'xxxx instead of xxxx
- Re: Help With Formula
- Re: How to copy data in one cell into different rows
- Re: Class not registered dialog when trying to load Excel add-ins.
- How to copy data in one cell into different rows
- Re: How to create a drop down menu for objects
- Re: Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?
- From: Sam via OfficeKB.com
- Re: I need a formmula to gives a % split for dif. $ amounts
- Re: Help With Formula
- Re: Help With Formula
- Re: Labor Rate %
- Re: Variable Criteria?
- Variable Criteria?
- Re: Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?
- Re: Pulling a Letter from a cell and filling another cell with inf
- Re: Adding Worksheet To Formula
- Re: Labor Rate %
- Re: Pulling a Letter from a cell and filling another cell with inf
- Re: Labor Rate %
- Re: Pulling a Letter from a cell and filling another cell with inf
- Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?
- From: Sam via OfficeKB.com
- Re: "the formula in this cell differs from the formula in this area o.
- Re: Formula encompassing conditional formating
- Re: I saved it by mistake!!!!
- Re: I saved it by mistake!!!!
- Re: Average of top 3 numbers.
- Re: results of "SUMIF" test criteria
- Re: Data validation issue
- Re: Data validation issue
- Re: how to remove gridlines from part of a worksheet only
- Data validation issue
- Re: Calculations from date and time values
- A difficult conditonal calculation
- Re: Average of top 3 numbers.
- Re: Average of top 3 numbers.
- Re: Average of top 3 numbers.
- Re: CAN YOU PUT MULTIPLE % BRAKE DOWNS IN 1 CELL
- Re: Average of top 3 numbers.
- Re: Average of top 3 numbers.
- Re: Increment column by column from data row by row
- Re: Increment column by column from data row by row
- Re: Increment column by column from data row by row
- Re: Increment column by column from data row by row
- Password hyperlink or macro?
- Re: Increment column by column from data row by row
- Re: Increment column by column from data row by row
- Increment column by column from data row by row
- Re: CAN YOU PUT MULTIPLE % BRAKE DOWNS IN 1 CELL
- Re: formatting won't apply to my cell with a formula
- Re: I need a formmula to gives a % split for dif. $ amounts
- Re: formatting won't apply to my cell with a formula
- Re: formatting won't apply to my cell with a formula
- Re: formatting won't apply to my cell with a formula
- Re: results of "SUMIF" test criteria
- RE: Pulling a Letter from a cell and filling another cell with inf
- RE: Pulling a Letter from a cell and filling another cell with inf
- Re: formatting won't apply to my cell with a formula
- Re: formatting won't apply to my cell with a formula
- Re: Pulling a Letter from a cell and filling another cell with info
- Re: drawing rect function graph in excel
- RE: Pulling a Letter from a cell and filling another cell with info
- Re: Pulling a Letter from a cell and filling another cell with info
- From: blackburnjl@xxxxxxxxx
- Re: Pulling a Letter from a cell and filling another cell with info
- Re: results of "SUMIF" test criteria
- Re: Formula Convert Digits to Words (1000 write One thousand)
- Re: Formula Convert Digits to Words (1000 write One thousand)
- Re: meaning of this function
- Re: results of "SUMIF" test criteria
- Re: results of "SUMIF" test criteria
- Re: results of "SUMIF" test criteria
- Re: Common Numbers Formula
- Re: Help summarizing data needed
- Re: Help summarizing data needed
- Re: need help on a formula for this problem
- need help on a formula for this problem
- Re: Need Formula to find worksheet
- Re: Need Formula to find worksheet
- Need Formula to find worksheet
- Re: How do I change default number settings?
- Re: meaning of this function
- Re: x and x+1
- Re: x and x+1
- Re: x and x+1
- Re: commissions by range
- Re: from disc to cd why does it always become read only
- Re: meaning of this function
- Re: meaning of this function
- Re: Date Last Modified Function
- Re: results of "SUMIF" test criteria
- Re: Sumif function with multiple criteria
- Re: Common Numbers Formula
- results of "SUMIF" test criteria
- Common Numbers Formula
- Re: Using data from coloured cells in a chart
- meaning of this function
- Re: formatting
- formatting
- Re: Move merged cells with conditional formatting?
- Re: commissions by range
- Re: commissions by range
- Re: Move merged cells with conditional formatting?
- Re: commissions by range
- Re: sumproduct based on format
- Re: calculating commissions for a range of values
- Re: commissions by range
- Re: commissions by range
- Re: How can I update all workbooks in one go
- Re: commissions by range
- Re: Extract last and next-to-last entries in a range
- Re: Move merged cells with conditional formatting?
- calculating commissions for a range of values
- commissions by range
- Re: Excel should have a formula for amortization.
- Re: excel %
- excel %
- Re: date that updates itself daily, plus another formula please??
- Re: Move merged cells with conditional formatting?
- Re: How many rows have I selected ?
- Re: Automatic calculation as sefault
- Re: One worksheet to calulate different items simultaneously
- Re: Indexing/Matching True/False results
- One worksheet to calulate different items simultaneously
- Re: How many rows have I selected ?
- Re: How many rows have I selected ?
- Re: Automatic calculation as sefault
- Re: How many rows have I selected ?
- Automatic calculation as sefault
- How can I update all workbooks in one go
- Re: Consolidate multiple workbooks
- Re: Date Last Modified Function
- Re: how many rows did I selected
- Re: from disc to cd why does it always become read only
- Re: How do I point to another cell
- Re: How to find square roots on paper
- Re: from disc to cd why does it always become read only
- Re: drawing rect function graph in excel
- Re: from disc to cd why does it always become read only
- Re: How to create a drop down menu for objects
- Date Last Modified Function
- Re: limited lines in check register
- Re: linked worksheet formulas
- Re: Excel - how about allowing colored worksheet tabs for organizing
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: linked worksheet formulas
- Re: Nested Formula
- Re: Consolidate multiple workbooks
- From: Randall Senn via OfficeKB.com
- Re: ="Printed " & today()
- Re: how do i combine IF and OR function
- Re: ="Printed " & today()
- Re: Editing a simple macro
- See if this works
- ="Printed " & today()
- Re: excel.worksheetfunctions
- Re: How do I point to another cell
- Re: excel.worksheetfunctions
- Re: Need Help with complex formula
- Re: I don't Understand
- Re: linked worksheet formulas
- Re: Editing a simple macro
- Problems with HYPERLINK in Excel 2002 and 2003
- Re: Finding a value associated with a range
- Re: Excel 2002; copy formulas to one workbook to another diff data
- Re: Editing a simple macro
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: Finding a value associated with a range
- Re: Finding a value associated with a range
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: Finding a value associated with a range
- Re: excel.worksheetfunctions
- Re: excel.worksheetfunctions
- Re: I need to "cross-foot" from worksheet to another
- From: Randall Senn via OfficeKB.com
- Re: Variable Links to tabsheets
- Re: How do I point to another cell
- excel.worksheetfunctions
- Re: charting your data automatically
- Re: Spreadsheets are cut off when you paste and link?
- charting your data automatically
- Re: Month to date sales - reset in new month???
- Re: Counting Data in a Column
- Re: Offset delivers value error with Named range
- Re: help needed in VLOOKUP function
- Re: Offset delivers value error with Named range
- Re: help needed in VLOOKUP function
- Please help me with a formula
- help needed in VLOOKUP function
- Month to date sales - reset in new month???
- Re: Conditional Formatting
- Re: create a goto button in excel
- Re: CONDITIONAL FORMAT
- Re: Need Help with complex formula
- Re: Formula needed
- Re: CONDITIONAL FORMAT
- Re: Remove html markup
- Re: Conditional Formatting
- Re: Counting the number of values in a list between two specified valu
- Criteria to use to dump it excel
- Need Help with complex formula
- Re: Excel cell show sum upto 500 Exceede delet without if else conditi
- Re: Remove html markup
- Re: unprotect sheets
- Re: Zero replaces blank field when paste special is used
- Re: Excel cell show sum upto 500 Exceede delet without if else conditi
- Re: help needed in IF function
- Re: can I reference a cell as someting like: cell(1, 1) ?
- Re: Remove html markup
- Re: Remove html markup
- Re: Variable Links to tabsheets
- Re: Move merged cells with conditional formatting?
- Re: Counting the number of values in a list between two specified valu
- Re: #DIV/0! in the array function
- Re: Colouring a row depending on data entered in a column
- Re: Indirect Formula
- Re: help needed in IF function
- Re: can I reference a cell as someting like: cell(1, 1) ?
- Re: convert numercials into words
- Re: How do I convert a text string into a date?
- Re: How do I convert a text string into a date?
- can I reference a cell as someting like: cell(1, 1) ?
- Re: Indirect Formula
- Offset delivers value error with Named range
- Re: help needed in IF function
- Re: calculate ranges
- Re: Validation List
- Re: help needed in IF function
- help needed in IF function
- Re: calculate ranges
- Re: calculate ranges
- Re: Find max date
- Re: linked worksheet formulas
- Re: Help with formula
- Re: calculate ranges
- Re: In Excel: select the last 20 rows of data in a column
- Re: Validation List
- Re: Problems with setting up a billing budjet
- Re: calculate ranges
- calculate ranges
- Re: linked worksheet formulas
- Validation List
- Problems with setting up a billing budjet
- Re: linked worksheet formulas
- how to change absolute path to relative path
- Re: Move merged cells with conditional formatting?
- Re: Nested Formula
- Re: In Excel: select the last 20 rows of data in a column
- Re: vlookup using two lookup values?
- Re: aLPHAnUMERIC validation
- Re: complex amortization
- Re: Move merged cells with conditional formatting?
- Re: Find last non-blank row with a worksheet function
- Re: Remove html markup
- Re: Move merged cells with conditional formatting?
- Re: Rounding
- Re: How easy is it to loop in VBA based on cell contents?
- Re: How easy is it to loop in VBA based on cell contents?
- Re: best formula to use
- Re: ="Printed " & today()
- Re: best formula to use
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- best formula to use
- Re: Move merged cells with conditional formatting?
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: How to summarize the first 4 numbers greater than 0 from a lis
- Re: How to summarize the first 4 numbers greater than 0 from a lis
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: Count cell
- Re: Selecting a range of values for another function
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: Error in "IF" formula
- Re: Variable Links to tabsheets
- Re: Why is my printer printing white fonts as black?
- Re: how to create the formula "cumsum" in excel
- Re: CONDITIONAL FORMAT
- Re: Selecting a range of values for another function
- Re: Why is my printer printing white fonts as black?
- Re: how to create the formula "cumsum" in excel
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Why is my printer printing white fonts as black?
- Re: returning a cell's value and a corresponding value
- Re: how to create the formula "cumsum" in excel
- Re: How to summarize the first 4 numbers greater than 0 from a list.
- Re: Two dimensional lookup
- RE: Help!
- Re: How to summarize the first 4 numbers greater than 0 from a list.
- Re: How to summarize the first 4 numbers greater than 0 from a list.
- Re: Count cell
- How easy is it to loop in VBA based on cell contents?
- Re: Move merged cells with conditional formatting?
- Count cell
- Re: Is this possible please someone help me ??
- Re: how can I fix a missing formula bar in Excel?
- Re: Find max date
- Move merged cells with conditional formatting?
- Re: Hour and minute
- Re: Is this possible please someone help me ??
- Re: Time code cell format
- Re: SumProduct Solution?
- Re: Matrix Dimension
- Re: Calculating percentages in pivot tables on subtotals
- Re: Find max date
- Re: Find max date
- Re: Find max date
- Re: Click button to automatically add row
- Re: Excel - need a function to compare lists
- Re: how can I fix a missing formula bar in Excel?
- Re: how can I fix a missing formula bar in Excel?
- Re: Find max date
- Click button to automatically add row
- Is this possible please someone help me ??
- Re: VLOOKUP Problem
- VLOOKUP Problem
- Re: Help!
- Find max date
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: drawing rect function graph in excel
- Re: I would like the worksheet auto name itself with a formula
- Re: aLPHAnUMERIC validation
- Re: CONDITIONAL FORMAT
- aLPHAnUMERIC validation
- Re: Selecting a range of values for another function
- Re: CONDITIONAL FORMAT
- Re: SumProduct Solution?
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: Rounding
- Re: Variable Links to tabsheets
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: How do I do an amortization schedule knowing the princ, int rate,.
- Re: Active cell counting in particular print page (one sheet having different print area)
- Re: Part of text as criteria
- Re: Help with SUMPRODUCT
- Re: Help with SUMPRODUCT
- Re: Help with SUMPRODUCT
- Re: Help with SUMPRODUCT
- Help with SUMPRODUCT
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Re: Part of text as criteria
- Re: populating empty cell with value from above
- Part of text as criteria
- Re: How to tackle Division by zero for DAVERAGE function
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: formula looking up multiple information.
- how to fetch a row and post the row into another sheelt
- Active cell counting in particular print page (one sheet having different print area)
- Re: returning a cell's value and a corresponding value
- returning a cell's value and a corresponding value
- Re: Rounding
- Re: formula looking up multiple information.
- Re: Two dimensional lookup
- Re: formula looking up multiple information.
- Re: GETPIVOTDATA question regarding adding "rows"
- Re: How to create a prefix containing text and zero?
- Re: Two dimensional lookup
- Re: How to find square roots on paper
- Re: match values in two different columns
- Re: match values in two different columns
- Re: Have 2 items in dropdown, want warning if one selected
- Re: Match Last Occurrence of Numeric Value and Count BACK to Previous
- From: Sam via OfficeKB.com
- Re: Variable Links to tabsheets
- Re: Formula/Array question with dates
- Re: Match Last Occurrence of Numeric Value and Count BACK to Previous
- From: Sam via OfficeKB.com
- Re: Variable Links to tabsheets
- match values in two different columns
- Variable Links to tabsheets
- Re: Match Last Occurrence of Numeric Value and Count BACK to Previous
- Re: DROP DOWN LISTS
- Re: Referencing a different Workbook
- Re: Zero replaces blank field when paste special is used
- Re: Match Last Occurrence of Numeric Value and Count BACK to Previous
- networkdays
- RE: DROP DOWN LISTS
- From: eternal_cat via OfficeKB.com
- Re: populating empty cell with value from above
- Re: vb code - Automatic transfer of data from one sheet to another
- Re: Column labels
- Re: Printing Certain Columns
- Re: Vlookup multiple worksheets
- Re: Mileage Calculation
- Re: How to create a prefix containing text and zero?
- Re: Nested IF with OR Function
- Re: if statements
- Re: if statements
- DROP DOWN LISTS
- From: eternal_cat via OfficeKB.com
- Re: How to create a prefix containing text and zero?
- Match Last Occurrence of Numeric Value and Count BACK to Previous
- From: Sam via OfficeKB.com
- Re: How to create a prefix containing text and zero?
- Re: Mileage Calculation
- Re: How do I point to another cell
- Re: In Excel: select the last 20 rows of data in a column
- Re: I need to Sum the value D2:G1000
- Re: Nested IF with OR Function
- Re: Hour and minute
- Re: how many if statements can i use in a single cell ?
- Auto fill multiple cells depending on single cell value
- Re: how many if statements can i use in a single cell ?
- Re: Can criteria in countif statement be a color?
- Re: Autofilter Locks???
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: How do I set up a conditional cell from a drop down list in Excel
- Re: Time and Business Hours
- Re: Ignoring Time in a Date Time Calculation
- Re: What excel function to use?
- Re: Multiple Validations in for 1 cell
- Re: Ignoring Time in a Date Time Calculation
- Re: count and lookup
- Re: Nested --- Subtotal IF function
- Re: Nested --- Subtotal IF function
- Re: How to add a column of accumulated data in pivottable?
- Multiple Validations in for 1 cell
- Re: Nested --- Subtotal IF function
- Re: how many if statements can i use in a single cell ?
- Re: Refering cells between worksheets
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Nested --- Subtotal IF function
- Re: Calculate Hours and overtime by week
- Re: How do I set up a conditional cell from a drop down list in Excel
- How to return the text data of the first col after getting the max value from the 2nd col
- Re: Nested IF with OR Function
- Re: Indexing/Matching True/False results
- Re: Last Number to Average
- Re: Vlookup in large named range
- Calculate Hours and overtime by week
- Re: Filter one column for all "Pending"
- Re: Last Number to Average
- Re: Calculated fields-Pivot tables
- Re: Excel formula
- Re: Indexing/Matching True/False results
- Last Number to Average
- PMT function
- Indexing/Matching True/False results
- Re: Return of blank cell if lookup fails
- Re: Vlookup in large named range
- Re: Overtime Hours
- Re: Regular Time and Over Time
- Re: Return of blank cell if lookup fails
- Re: Return of blank cell if lookup fails
- Re: Regular Time and Over Time
- Re: Dates - Months & Years
- Re: Overtime Hours
- Re: color fill cells based on IF function or formula
- Re: Excel formula
- Re: Dates - Months & Years
- RE: Empty Lines
- Re: Number Formatting Question
- Re: Dates - Months & Years
- Re: Dates - Months & Years
- Re: Hour and minute
- Re: Excel - how about allowing colored worksheet tabs for organizing
- Re: SUM Days (to 30), Months (to 12) and Years
- Re: Problem with TRUNC
- Re: SUM Days (to 30), Months (to 12) and Years
- Re: Excel formula
- Re: Number Formatting Question
- Re: populating empty cell with value from above
- Re: Too few arguments
- populating empty cell with value from above
- Number Formatting Question
- Re: SUM Days (to 30), Months (to 12) and Years
- Re: Too few arguments
- Re: Problem with TRUNC
- Re: populating empty cell with value from above
- Excel formula
- Re: Problem with TRUNC
- Re: Creating a Summary Worksheet
- Re: indirect?
- Re: How do I count in a range of dates?
- Re: How to create a prefix containing text and zero?
- Problem with TRUNC
- Re: How to create a prefix containing text and zero?
- Re: importing data
- Re: Referencing a different Workbook
- Re: How to create a prefix containing text and zero?
- Re: indirect?
- Re: how many if statements can i use in a single cell ?
- vb code - Automatic transfer of data from one sheet to another
- vb code - Automatic transfer of data from one sheet to another
- Re: Creating a Summary Worksheet
- Re: how many if statements can i use in a single cell ?
- Re: indirect?
- Re: -ve no with -1; positive with sign+ and 0 no sign? Tks.
- Re: indirect?
- Re: How to save the current worksheet as JPEG, TIFF or DICOM?
- Re: Lookup same word "value" across multiple cells
- Re: Delete Cell Function
- Is it possable?
- Re: Do I Need to Use an IF Statement?
- Re: indirect?
- indirect?
- Re: How to create a menue bar of numbers in a cell?
- Re: Finding the Max of a related Value Lookup
- Re: Calculating slope, intercept, LOGEST with empty cells in data
- Re: Column labels
- Re: Remove html markup
- Re: Logarithmic curve formulas in charts and LOGEST fx values?
- Re: Remove html markup
- Re: Pivot Table Subtotals - Difference
- Re: Refering cells between worksheets
- Re: format cells
- RE: Remove html markup
- RE: Remove html markup
- Re: Finding the Max of a related Value Lookup
- RE: Remove html markup
- RE: Remove html markup
- RE: Remove html markup
- RE: Remove html markup
- Re: Concatentate Join Identifier
- Re: Formula for growth chart?
- Re: Tab Key
- Re: Index Match function for multiple linked variables
- Re: Excel formula help needed
- Re: How do I create numbers for a Chinese Auction?
- Re: Index Match function for multiple linked variables
- Re: Do I Need to Use an IF Statement?
- Re: Index Match function for multiple linked variables
- Re: Difficult Excel Problem
- Re: Calculate duration in Excel 2000
- Do I Need to Use an IF Statement?
- Re: Index Match function for multiple linked variables
- Calculate duration in Excel 2000
- Re: How do I create numbers for a Chinese Auction?
- Re: deleting macros that are not really in my workbook?
- Re: How do I select form a drop down box by typing the first part?
- Re: VB Protection problem
- Re: F5 function for zeroes?
- Re: How do I create numbers for a Chinese Auction?
- Re: Formula questions
- Re: Now()
- Re: Now()
- Re: Now()
- Re: Now()
- Re: Now()
- Re: I get 0:00 when I format cells 4 time no matter what # I enter
- Re: Is there an "auto tab" option in excel?
- Re: Index Match function for multiple linked variables
- Re: Nested IF problem - help please
- Re: Getting #N/A from Vlookup when matching value exist in the lookup data range.
- Re: Getting #N/A from Vlookup when matching value exist in the lookup data range.
- Re: Dealing with numbers that begin with a 0
- Re: What is the "--" used for - or how do I ask excel for help
- Getting #N/A from Vlookup when matching value exist in the lookup data range.
- Re: Possible? If total in a worksheet > 0, highlight worksheet ta
- Re: Average
- RE: nested if functions in Excel 2002
- Re: Nested IF problem - help please
- Re: Nested IF problem - help please
- VB Protection problem
- Re: Average
- Re: Dealing with numbers that begin with a 0
- Re: entering date functions
- Re: Average
- Re: Interrupting A Worksheet Calculation
- Re: Nested IF problem - help please
- Re: Index Match function for multiple linked variables
- Re: Displaying seconds in hh:mm:ss format
- Re: Copying a total from another Sheet
- counting the number of times something is bought during a month
- Re: Finding values based on color
- Re: Nested IF problem - help please
- Re: Index Match function for multiple linked variables
- Re: Difficult Excel Problem
- Re: programming date functions
- Re: Displaying seconds in hh:mm:ss format
- Re: Displaying seconds in hh:mm:ss format
- Re: Displaying seconds in hh:mm:ss format
- Re: Index Match function for multiple linked variables
- Displaying seconds in hh:mm:ss format
- Re: entering date functions
- Re: Display text depending on values of 3 different cells?
- Re: EXTRACT NUMBERS FROM TEXT STRING
- Re: Display text depending on values of 3 different cells?
- Re: How do I compare the difference in two spreadsheets?
- getting the last cell value in a column
- Re: Is there an "auto tab" option in excel?
- Re: Display text depending on values of 3 different cells?
- Re: Display text depending on values of 3 different cells?
- Re: I get 0:00 when I format cells 4 time no matter what # I enter
- Re: Display text depending on values of 3 different cells?
- Re: VLOOKUP used only when IF condition is met
- Re: Display text depending on values of 3 different cells?
- Re: Using a Pivot Table Calculated Field to get a Unique Count
- Re: VLOOKUP used only when IF condition is met
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Display text depending on values of 3 different cells?
- Re: Nested IF problem - help please
- Re: formulahelp
- Re: Possible? If total in a worksheet > 0, highlight worksheet tab?
- Re: Find a negative number in a range
- Re: formulahelp
- Re: drawing rect function graph in excel
- Re: how can I calculate VAT for selective data in the same column of a
- Re: remove all ","
- Re: Index Match function for multiple linked variables
- Re: how can I calculate VAT for selective data in the same column of a
- Re: Rolling 3 mth Average
- Re: Nested IF problem - help please
- Re: Formula Problem - interrupted by #VALUE! in other cells!?
- Re: Searching for multiple results in one cell
- Re: Insert-Subtotals makes Column Outlines disappear
- Difficult Excel Problem
- Re: Index Match function for multiple linked variables
- Re: count and arrange cell numeric values
- Re: #N/A is not text, cannot use it in functions
- Re: OT? Microsoft Works Database Import?
- Re: #N/A is not text, cannot use it in functions
- IF statement
- Re: OT? Microsoft Works Database Import?
- Re: Nested IF problem - help please
- Re: Copying a total from another Sheet
- Copying a total from another Sheet
- Re: How do I filter out duplicate values in Excel 2000?
- OT? Microsoft Works Database Import?
- Re: get a total based on criteria in two columns
- Re: F5 function for zeroes?
- Re: Function has worked for 5 years is now in error
- Re: Can somebody help me with this formula
- Re: IF function
- Re: get a total based on criteria in two columns
- Re: Formula for growth chart?
- Re: Index Match function for multiple linked variables
- Re: Index Match function for multiple linked variables
- Re: vlookup using two lookup values?
- F5 function for zeroes?
- Re: IF function
- Re: Formula for growth chart?
- Re: Formula for growth chart?
- Re: I don't Understand
- Re: Sumproduct
- Re: formula ignores last infor - please help
- Re: formula question
- Re: XIRR with non contigous cells
- Re: Lookup type formula
- Lookup type formula
- drawing rect function graph in excel
- Re: ROUND CENTS TO EITHER 49 OR 99 AMOUNTS
- Re: ROUND CENTS TO EITHER 49 OR 99 AMOUNTS
- Re: This should be easy
- Re: This should be easy
- Re: shift right 5 columns
- Re: sumProduct (gimme a 1 if this is true, gimme the value) what i
- Re: sumProduct (gimme a 1 if this is true, gimme the value) what i
- Re: This should be easy
- Re: sumProduct (gimme a 1 if this is true, gimme the value) what i
- Re: sumProduct (gimme a 1 if this is true, gimme the value) what i
- Re: This should be easy
- Re: is there a standard formula for this?
- shift right 5 columns
- Re: Jumping colums in Excel 2000
- Re: Index Match function for multiple linked variables
- Re: Breaking up a string into separate columns
- Re: how to use "IF" to do nothing if a cell is blank
- Re: Calculations from date and time values
- Re: OPPOSITE FORMULA
- Index Match function for multiple linked variables
- Index Match function for multiple linked variables
- Re: Excel formula help needed
- Re: sumProduct (gimme a 1 if this is true, gimme the value) what is th
- Excel formula help needed
- Re: Cross-referenced drop-down menu (nested drop-downs?)
- Re: Logarithmic curve formulas in charts and LOGEST fx values?
- Re: Cross-referenced drop-down menu (nested drop-downs?)
- Re: Clearing #N/A's in one go?
- Re: Functions
- Re: Clearing #N/A's in one go?
- Re: I don't Understand
- Clearing #N/A's in one go?
- Re: copying and pasting a formula
- Re: Vertical Lookup problem
- Re: Lookup same word "value" across multiple cells
- Re: delete series of letter in spreadsheet
- Re: Calculations from date and time values
- Re: Data Validation
- Re: Vertical Lookup problem
- Re: Sumproduct
- Re: Make stair columns
- Re: vlookup using two lookup values?
- Re: Calculations from date and time values
- Re: Lookup same word "value" across multiple cells
- Re: vlookup using two lookup values?
- Re: Help with #VALUE! error please...
- Re: IF function
- Lookup same word "value" across multiple cells
- Re: delete series of letter in spreadsheet
- help me on rearrange cells based on its numerical values without repeating any number
- Re: vlookup using two lookup values?
- Re: Using a 'Select' (Data Validation) List?
- Re: vlookup using two lookup values?
- Re: Very weird error
- Re: vlookup using two lookup values?
- Re: Make stair columns
- Re: vlookup using two lookup values?
- Re: Trim Function
- Re: Data Validation
- Re: Trim Function
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Re: Make stair columns
- Re: Data Validation
- Re: Trim Function
- Re: HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?
- Re: IF function
- Re: IF function
- Make stair columns
- Re: Trim Function
- Re: How can I get excel to ignore formula in dependant cells...
- Re: how can I count blank cells as a zero, when using formula please??
- Re: count and arrange cell numeric values
- Re: count and arrange cell numeric values
- Global Print Specs
- Re: Calculations from date and time values
- Re: Logarithmic curve formulas in charts and LOGEST fx values?
- Re: Frustrated Cook
- RE: Formula help
- Re: How can I get excel to ignore formula in dependant cells...
- Re: Help with #VALUE! error please...
- Re: Print titles: can noncontiguous columns at left be printed & how?
- Re: Very weird error
- RE: Formula help
- Re: How can I get excel to ignore formula in dependant cells...
- Re: Change Excel default Workbook Template?
- Re: Count If Array Formula
- is there a standard formula for this?
- Re: Jumping colums in Excel 2000
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Re: Formula Problems
- Re: Combining Text on statement
- RE: Formula help
- Re: Using a 'Select' (Data Validation) List?
- Re: Macro to delete rows with same data
- Re: Combining Text on statement
- Re: lookup to return larger value
- Re: Combining Text on statement
- Help Please: SUMIF function
- Re: Help with #VALUE! error please...
- Re: Should I use STDEVP
- Re: Working with dates
- Re: Very weird error
- Re: Dynamic Data Range
- Using a 'Select' (Data Validation) List?
- Re: Dynamic Data Range
- Re: Sumproduct
- Re: Entering numbers to get the time
- Re: lookup to return larger value
- Re: vlookup on a cell with a formula
- Re: circular reference (Excel 2000)
- Re: Formula Problems
- Re: vlookup on a cell with a formula
- Re: Struggling for a solution
- Re: count and arrange cell numeric values
- Re: count and arrange cell numeric values
- Re: XIRR with non contigous cells
- Re: Date & time short cut
- Re: Combining Text on statement
- Re: Nested IF problem - help please
- Re: Logarithmic curve formulas in charts and LOGEST fx values?
- Re: Sumproduct
- Re: Nested IF problem - help please
- count and arrange cell numeric values
- Re: Combining Text on statement
- Re: help with vlookup function
- Nested IF problem - help please
- Re: Date format default problem
- Re: Date format default problem
- Re: Frustrated Cook
- Re: Change Excel default Workbook Template?
- Re: Frustrated Cook
- Re: help with formula
- Re: MATCHING DATA IN COLUMNS
- Re: vlookup
- XIRR with non contigous cells
- Re: Can you recalculate an individual excel cell in isolation?
- Re: help with formula
- Re: Excel Boffins help please ! ! !
- Re: Function has worked for 5 years is now in error
- Function has worked for 5 years is now in error
- Re: vlookup on a cell with a formula
- Re: Cells with dates...
- Sumproduct
- Re: Cells with dates...
- Cells with dates...
- Re: Count cells with dates
- Re: Frustrated Cook
- Excel Boffins help please ! ! !
- Re: circular reference (Excel 2000)
- Re: circular reference (Excel 2000)
- Re: Count cells with dates
- Re: Vlookup
- Re: Count cells with dates
- Re: networkdays
- Re: Count cells with dates
- Vlookup
- Count cells with dates
- Re: excel help
- Re: excel help
- Re: circular reference (Excel 2000)
- Re: I don't Understand
- Re: I don't Understand
- Re: I want to be able to count the number of checked boxes in a fo
- Re: networkdays
- Re: Frustrated Cook
- Re: Frustrated Cook
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Re: Jumping colums in Excel 2000
- Re: I don't Understand
- Re: TEN OLDEST DATES
- 'problem starting the Office Assistant'
- Re: Frustrated Cook
- Re: worksheet formula problems
- Calculating Time elapsed
- Re: help with formula
- Re: the sum of all bolded numbers
- Re: How to show sheet tabs in Microsoft Excel
- Re: How can I replace zeros with blank spaces during calculations
- Re: how do i sum dollars & cents in different columns
- Re: help with formula
- Re: Entering numbers to get the time
- Re: Struggling for a solution
- Re: Frustrated Cook
- Re: Checking for dublication of text
- Re: what means 'blank cell'??
- Re: Checking for dublication of text
- Struggling for a solution
- Re: Frustrated Cook
- Re: How to automatically update the date any time the Excel is openned
- Re: How to retrieve orignial file excel that is renamed
- Re: Frustrated Cook
- RE: Show top five records based on meeting multiple criteria
- Re: Top Five selections based on sum of items meeting criteria
- Re: Frustrated Cook
- Re: how do i sum dollars & cents in different columns
- Re: the sum of all bolded numbers
- Re: formula to calculate age using birth date and current date
- Re: the sum of all bolded numbers
- Re: formula to calculate age using birth date and current date
- Re: Showing #VALUE!
- Re: how do i sum dollars & cents in different columns
- Re: Showing #VALUE!
- Re: Showing #VALUE!
- Re: the sum of all bolded numbers
- Re: How would I display the word "Paid" if the value of another cell=
- Re: how do i sum dollars & cents in different columns
- Re: How would I display the word "Paid" if the value of another cell=
- Re: vlookup
- Re: how do i sum dollars & cents in different columns
- Re: How would I display the word "Paid" if the value of another cell=
- Re: Showing #VALUE!
- Re: Fill color not showing up on cell tables
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Frustrated Cook
- Re: the sum of all bolded numbers
- Entering numbers to get the time
- Re: vlookup
- Re: Combo boxs
- the sum of all bolded numbers
- Re: How to nest functions with SUMIF function in excel
- Re: where is the accent key on the keyboard?
- Combo boxs
- Re: change font color of cell based on critera
- change font color of cell based on critera
- Re: Ok, here is the Correct equation I am having trouble with. (fr
- Re: Ok, here is the Correct equation I am having trouble with. (fr
- Re: ??SUMPRODUCT? other solution?
- Re: Ok, here is the Correct equation I am having trouble with. (fr
- Re: SUMIF with two conditions?
- Re: sumif
- Re: Top Five selections based on sum of items meeting criteria
- Re: Checking for dublication of text
- Checking for dublication of text
- Re: where is the accent key on the keyboard?
- Re: where is the accent key on the keyboard?
- Re: increase conditional formating options
- Re: increase conditional formating options
- Re: plot
- Agreed.
- Re: increase conditional formating options
- Re: How do I save my 'sort criteria' in an Excel file?
- From: PATRICK AND CHERY LANANE
- Re: sumif
- Re: Ok, here is the Correct equation I am having trouble with. (from T
- Re: find cells that contain specific characters
- Re: find cells that contain specific characters
- Re: increase conditional formating options
- Re: Problems adding formula together. Please Help!
- Re: Problems adding formula together. Please Help!
- Re: Problems adding formula together. Please Help!
- Re: Dispalying negative times
- Re: How can I replace zeros with blank spaces during calculations plea
- Re: increase conditional formating options
- Re: increase conditional formating options
- Re: find cells that contain specific characters
- Re: how do I get this
- Re: Dispalying negative times
- Re: vlookup and calculation questions
- Re: vlookup and calculation questions
- Re: It is some functions who insert rows?
- Re: Delete rows by content
- Re: Need assistance linking workbooks by date
- Re: Delete rows by content
- Need assistance linking workbooks by date
- Re: Calculating frequency?
- Re: Calculating frequency?
- Calculating frequency?
- Re: Follow up to "Recalculate" problem
- Re: Excel OR function
- Re: Excel OR function
- Re: Don't understand PMT(d412,e4,-c4) what is it asking me or means?
- Re: How Do You Hide a #DIVO! Return in a cell
- Re: calculating fees from hours and minutes
- Re: how do i do an accounting spreadsheet
- Re: lock tab in sheet 2 until cell in sheet one is completed
- Re: calculating fees from hours and minutes
- Re: count a number that is less than a number and greater than a numbe
- Re: IF SUM
- Re: how do i do an accounting spreadsheet
- calculating fees from hours and minutes
- Re: count a number that is less than a number and greater than a numbe
- Re: Show top five records based on meeting multiple criteria
- RE: Drop Down Menus - 2nd Problem
- Re: IF SUM
- Re: double records
- Re: Follow up to "Recalculate" problem
- Re: sumif
- Re: IF SUM
- Re: sumif
- Re: Show top five records based on meeting multiple criteria
- Follow up to "Recalculate" problem
- Re: sumif
- Re: counting number of times value is greater than previous week
- Re: sumif
- Re: sumif
- Re: Drop Down Lists - assign a value based on selection
- Re: double records
- Re: Finding values
- Re: working
- Re: Finding values
- Re: Finding values
- Re: Finding values
- Re: Finding values
- Re: working
- Re: Regression - Standard Error X Variable 1
- Re: nested if functions in Excel 2002
- Finding values
- Re: Regression - Standard Error X Variable 1
- Re: Linking Data
- Re: how do I lookup data based on two columns of data
- Re: How to add all positive and negative numbers?
- Re: SUMIF with two conditions?
- Re: SUMIF with two conditions?
- Re: SUMIF with two conditions?
- Re: SUMIF with two conditions?
- Re: SUMIF with two conditions?
- Re: Help with a f(x) formula
- Re: Linking Webpage to Excel Data
- Re: SUMIF with two conditions?
- SUMIF with two conditions?
- Re: delete series of letter in spreadsheet
- Linking Webpage to Excel Data
- Re: how do I lookup data based on two columns of data
- Re: An Inquirey on the Round function
- Re: Creating a dynamic list
- Re: Adding hrs
- Re: Summing Arrays
- Re: I get 0:00 when I format cells 4 time no matter what # I enter
- Re: Why can't I write in a document that is not read only?
- Re: I want to be able to count the number of checked boxes in a form?
- Re: Counting based on values in two columns?
- Re: Counting based on values in two columns?
- Re: barcode scan changes last 2 digits in excel 2003
- Re: VLookup Issue
- Re: It is some functions who insert rows?
- Re: vLOOKUP
- Re: Match and sort
- Re: total a range of cells in Excel into a different worksheet
- Re: barcode scan changes last 2 digits in excel 2003
- Re: How do I create a function to search a range for a number and...
- Re: Updating the Sum of a cell
- Re: It is some functions who insert rows?
- Re: How do I save my 'sort criteria' in an Excel file?
- Re: barcode scan changes last 2 digits in excel 2003
- Re: Help please
- Re: Effective interest paid - need formula/function
- Re: IRR Logic
- Re: Updating the Sum of a cell
- Re: vlookup
- RE: nested if functions in Excel 2002
- RE: nested if functions in Excel 2002
- Re: barcode scan changes last 2 digits in excel 2003
- Re: Purge or transfer old data automatically?
- Re: Macro to delete rows with same data
- Re: How do I convert text to time
- Re: How do I convert text to time
- Re: How do I convert text to time
- Insert-Subtotals makes Column Outlines disappear
- Re: How to show sheet tabs in Microsoft Excel
- Re: another sumproduct question
- RE: nested if functions in Excel 2002
- Re: Macro to delete rows with same data
- Re: Auto-copy the last entry in a column to a new cell
- Re: another sumproduct question
- Re: Macro to delete rows with same data
- Re: another sumproduct question
- Re: formula to insert picture
- Re: How to convert minutes to fractional hours
- Re: another sumproduct question
- Re: networkdays
- Re: Help summarizing data needed
- Re: Macro to delete rows with same data
- Re: Multiple Vlookups
- Re: Calculation within Text
- Re: another sumproduct question
- Help please
- Re: Purge or transfer old data automatically?
- Re: nested if functions in Excel 2002
- Re: counting number of times value is greater than previous week
- Re: Summarizing worksheets
- Re: another sumproduct question
- Re: Calculation within Text
- Re: Formula for inserting blank row
- Re: LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
- Re: Count Function
- Re: Extract last and next-to-last entries in a range
- Re: Calculation within Text
- Re: Calculation within Text
- Re: Calculation within Text
- Re: Calculation within Text
- Calculation within Text
- Re: IF statements with more than 7 variables
- Re: IF statements with more than 7 variables
- Re: Inserting rows into worksheets that are protected
- Re: $ definition
- $ definition
- Re: Count Function
- From: bplumhoff@xxxxxxxxx
- Re: networkdays
- Re: networkdays
- Re: drop down option in a cell
- Re: count on condition / Formula
- Re: another sumproduct question
- Re: Problem with Slow ReCalculation of Dynamic Range Using OFFSET
- Re: Count Function
- Re: another sumproduct question
- Re: Need help with Excel formulas
- Re: another sumproduct question
- another sumproduct question
- Re: Look Up Values Within a Range
- Re: Need help with Excel formulas
- Re: Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more
- Re: lottery drawing
- Re: eliminate partial content from the cell
- Re: Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more
- Re: IF statements with more than 7 variables
- Re: IF statements with more than 7 variables
- Re: display words in a formula result in Excel
- Re: drop down list in Excel
- Re: display words in a formula result in Excel
- Re: Drop Down List
- Re: DateDif problem
- Re: Dropdown list with named cells
- Re: IF statements with more than 7 variables
- Re: Condense formula
- Identifying #N/A cells
- Dropdown list with named cells
- Re: drop down list in Excel
- Re: TEN OLDEST DATES
- Re: How do you write an excel formula to sum data in every second cell
- Re: How do you write an excel formula to sum data in every second cell
- tagging / tracing / referencing duplicate values
- Re: Can I do this?
- Re: Referencing cell in another sheet yields null?
- Re: countif and concatenate
- Re: countif and concatenate
- Re: Financial Functions
- Re: IF statements with more than 7 variables
- Re: ??SUMPRODUCT? other solution?
- Re: ??SUMPRODUCT? other solution?
- Re: IF Function to test formula in a cell
- Re: getting active cell value in another cell
- Re: ??SUMPRODUCT? other solution?
- Re: Using worksheet functions in macros in Excel2000
- Re: IF Function to test formula in a cell
- getting active cell value in another cell
- IF statements with more than 7 variables
- Re: How to convert minutes to fractional hours
- Re: ??SUMPRODUCT? other solution?
- Re: Formulas
- Re: ??SUMPRODUCT? other solution?
- Re: Cascade Validation
- Re: Can I do this?
- Re: Conditional Formatting
- Re: drop down option in a cell
- Re: LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
- Re: Formulas
- Re: What is the formula to average alpha?
- Re: problem with FIND
- Re: What is the formula to average alpha?
- Re: drop down box in cell
- Re: Cascade Validation
- Re: colour due to conditional formatting & hyperlink/shortcut to a directory
- Re: Is there a way to automatically change the location of a formula?
- Re: Are different column widths possible on the same worksheet?
- Re: Formula for inserting blank row
- Re: Count nonblank cells with multiple criteria
- Re: Count nonblank cells with multiple criteria
- Re: In excel, how can i delete 1 digit and the decimal point?
- Re: Lookup values in one column to return another
- Re: Mode between two serial dates/times
- Re: Lookup values in one column to return another
- Re: Count nonblank cells with multiple criteria
- Re: If ? maybe.....
- Re: Validation Help
- Re: Delete first two digits in column
- Re: Lookup values in one column to return another
- Mode between two serial dates/times
- Re: Lookup values in one column to return another
- Re: Reference Cell Content
- Re: Count if a number is between X and Y
- Re: Count if a number is between X and Y
- Re: Are different column widths possible on the same worksheet?
- colour due to conditional formatting & hyperlink/shortcut to a directory
- Re: Conditional Formatting
- Lookup values in one column to return another
- Re: Are different column widths possible on the same worksheet?
- Re: Can I do this?
- Re: Validation Help
- Re: Validation Help
- Re: Can I do this?
- Re: Can I do this?
- Re: Can I do this?
- Re: Automatic Date Update
- Re: Count According to Date
- Re: Count nonblank cells with multiple criteria
- Re: SUMIF 2 conditions are met???
- Re: Formula Needed...
- Re: Formula Needed...
- Re: Are different column widths possible on the same worksheet?
- Re: If ? maybe.....
- Re: Are different column widths possible on the same worksheet?
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: Date from text to Date format
- Re: Formula for inserting blank row
- Re: Combine 2 formulasinto 1.
- Re: Checking a number of sheets
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: Validation Help
- RE: Return Array with Array
- Re: SUMIF 2 conditions are met???
- Re: Count Function
- Re: SUMIF 2 conditions are met???
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- SUMIF 2 conditions are met???
- Re: Validation Help
- Re: Validation Help
- Re: How do I copy comments into cells
- Re: Count Function
- Re: If ? maybe.....
- Re: multiple Lookup
- Re: Validation Help
- Re: search for text within text
- Re: Validation Help
- Re: IF formula
- Re: Count Function
- Validation Help
- Re: How can you add an "&" in a footer?
- Re: separate name and address
- Re: How do I highlight duplicate data on a spreadsheet?
- Re: separate name and address
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: Converting numbers to text
- Re: Date from text to Date format
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: separate name and address
- Re: averging prices real problem
- Re: IF formula
- Re: function to insert a picture
- Re: Use Index to get range
- Re: Return Array with Array
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: Count Function
- Re: IF formula
- Re: Date from text to Date format
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: How can you add an "&" in a footer?
- Re: How do I copy comments into cells
- Re: Formula Needed...
- Re: How can you add an "&" in a footer?
- Re: Count Function
- Re: Date from text to Date format
- Re: Date from text to Date format
- Re: Count Function
- Re: Count Function
- Re: How do I convert hours and mins into just minutes in excel?
- Re: Date from text to Date format
- Date from text to Date format
- search for text within text
- Checking a number of sheets
- Re: how can i ignore blank cells when multiple cells?
- Re: Formula that sums the values if you have 2 criteria and 2 differe.
- Re: help on lookup functions
- Problem with random inputs
- Re: How do I highlight duplicate data on a spreadsheet?
- Re: Formula Needed...
- Re: averging prices real problem
- Re: averging prices real problem
- Re: Return entry in column above/below cell
- Re: averging prices real problem
- Re: how can i ignore blank cells when multiple cells?
- Re: averging prices real problem
- Re: eliminate partial content from the cell
- Re: How can I automate something to be added to a formula in excel?
- Re: Dates in Excel
- Re: Use Index to get range
- Re: hyperlink changes when doc emailed
- Re: Vlookup and forecast
- Re: Formulas
- Re: text modification
- Re: SUMIF Returns a #VALUE error when external source is closed
- Seperation of prime and sub inventory units
- Re: trying index match
- Re: Help summarizing data needed
- Re: How do I find....
- Re: how do you link rows of cells to other work pages?
- Re: how do I make rows and columns appear when I print a spreadsheet
- Re: how do I make rows and columns appear when I print a spreadsheet
- Re: how do I make rows and columns appear when I print a spreadsheet
- Re: How do I find....
- averging prices real problem
- Re: Problem with Slow ReCalculation of Dynamic Range Using OFFSET
- challenging "share stock" average prices
- Re: calender drop down in an exel sheet
- Re: LIST function
- Re: calculations in excel
- Re: Calculating elapsed time
- Re: problem with FIND
- Re: trying index match
- Re: Database
- Re: calculations in excel
- Re: formula
- Re: sumproduct
- RE: Conditional Formatting
- Re: liked workbook
- liked workbook
- Re: Display Part of the cell value
- trying index match
- Re: Excel Cell Criteria Effect
- Re: Calculating elapsed time
- Re: sumproduct
- Re: "IF"- "THEN" type Formula based on Null value
- Re: Excel Cell Criteria Effect
- Re: Excel Cell Criteria Effect
- Re: excel help
- sumproduct
- Excel Cell Criteria Effect
- Re: Macros
- Re: how do i list the name off all my worksheets on a sheet
- Re: Date format issue
- Re: One line of list show up in different sheet
- Re: Logical formula problem
- Re: Financial Functions
- Re: Using Excel in different countries
- Re: how do i list the name off all my worksheets on a sheet
- Re: How can I globally set "error message" parameters in Excel
- Re: how do i list the name off all my worksheets on a sheet
- Re: How can I globally set "error message" parameters in Excel
- Re: how do i list the name off all my worksheets on a sheet
- Re: How can I globally set "error message" parameters in Excel
- Logical formula problem
- Database
- Re: How can I globally set "error message" parameters in Excel
- Re: how do i list the name off all my worksheets on a sheet
- Re: How do I bring totals from Expenses wkshet into Monthly Totals wks
- Re: Does anyone know how to turn off the GetPivotData function?
- Re: How do I bring totals from Expenses wkshet into Monthly Totals wks
- Date format issue
- RE: data sorting
- Re: TEN OLDEST DATES
- Re: Using Excel in different countries
- Re: How do I bring totals from one worksheet onto the second worksheet
- Re: Financial Functions
- Re: TEN OLDEST DATES
- Re: TEN OLDEST DATES
- Re: problem with FIND
- Re: IF NOT FOUND
- Re: program to open excel sheets without excel
- Re: IF NOT FOUND
- problem with FIND
- Re: Function determine if date is even or odd
- Re: Is there a logical test for a cell's format instead of contents
- Re: program to open excel sheets without excel
- Re: Bug in help for Excel SUMIF function
- Re: How to correctly write a cross-sheet "IF" formula in Excel
- Re: Is there a logical test for a cell's format instead of contents
- Re: Formula Needed...
- Re: How do I find....
- Re: I would like to print the titles of files inside a folder.
- Re: how to diferentiate integers with decimals in the IF formulas
- Re: Number of work sheets
- How do I find....
- Re: Search for record with specific name in a cell
- lookup & match solutions
- Re: Converting a number to a letter in Excel
- Re: DateDif problem
- Return entry in column above/below cell
- Re: "FIX" is displayed on status bar
- Re: VLOOKUP issue
- Re: Converting a number to a letter in Excel
- Re: Nesting Index and Match Functions
- VLOOKUP issue
- VLOOKUP issue
- RE: Conditional Formatting
- Re: If ? maybe.....
- Re: how do I count the number of times text in column A matches text i
- Re: INVOICE COUNTERS
- Re: Conditional Formatting
- Re: Nesting Index and Match Functions
- Re: Return Array with Array
- Re: Merg Worksheets
- Re: Return Array with Array
- Re: Return Array with Array
- Re: Converting decimal calculation to h:mm format
- Re: Sumif or Sumproduct
- Re: Selecting specific row/column from a named range
- Re: Sumif or Sumproduct
- Re: Referancing differant sheets
- Re: MAX function for a given Position Title
- Re: SUMIF Returns a #VALUE error when external source is closed
- Re: Referancing differant sheets
- Re: SUMIF Returns a #VALUE error when external source is closed
- Re: Bug in help for Excel SUMIF function
- Re: How do I write the formula to calculate someones time worked
- Re: How do I write the formula to calculate someones time worked
- Re: How do I write the formula to calculate someones time worked
- Re: Running a macro if any data is entered in a range of cells
- Re: Nesting Index and Match Functions
- Re: change values globally
- Re: Newbie needs help with incrementing a series of cells
- Re: Counting cells base on a predetermined range
- Re: Cell text based on 4 condition test
- Re: Formula Needed...
- Re: Formula Needed...
- Re: Selecting specific row/column from a named range
- Re: Nesting Index and Match Functions
- Re: change values globally
- Re: change values globally
- Re: MAX function for a given Position Title
- Re: Icon for "Wrap" and for "Centre Across Selection"
- Selecting specific row/column from a named range
- Re: Formulas
- Re: countif
- Re: Sorting and Adding Space
- Re: Text is being converted to Date
- Re: Holiday Dates
- Counting cells base on a predetermined range
- Re: Text is being converted to Date
- Re: Date(Y,M,D) 'feature' or problem?
- Re: If formula result is false, how do I auto-delete that rows?
- Re: FLOATING CELLS
- Re: Date(Y,M,D) 'feature' or problem?
- Re: =SUM(A1:A5)*24 for totalling hours and minutes is not working
- Re: Nesting Index and Match Functions
- Re: Date(Y,M,D) 'feature' or problem?
- Re: Constructing range address given row and col numbers of boundaries
- Re: Constructing range address given row and col numbers of boundaries
- FLOATING CELLS
- Re: Date(Y,M,D) 'feature' or problem?
- Re: Constructing range address given row and col numbers of boundaries
- Re: Constructing range address given row and col numbers of boundaries
- Re: Running a macro if any data is entered in a range of cells
- Re: Date(Y,M,D) 'feature' or problem?
- Re: Nesting Index and Match Functions
- Re: Significant digits
- Constructing range address given row and col numbers of boundaries
- Re: Excel filter dropdown shows all data
- Re: formula that will go up one space if no value in specified space
- Re: Date(Y,M,D) 'feature' or problem?
- Re: How to repair 2005-2006 student attendance record?
- Re: Macros
- Re: Formula help
- Re: Significant digits
- Re: Significant digits
- Re: if command for yes or no
- Re: How to project usage.
- Re: How do I set up an "IF" formula?
- Re: Inserting rows into worksheets that are protected
- Re: How do I set up an "IF" formula?
- Re: Date(Y,M,D) 'feature' or problem?
- Re: Automate a date referenced in a formula pointing to another sh
- Re: Date(Y,M,D) 'feature' or problem?
- Re: How do I set up an "IF" formula?
- Re: Display Part of the cell value
- Re: Display Part of the cell value
- Re: Holiday Dates
- Re: Display Part of the cell value
- Re: How to change number to text in new column from another worksh
- Re: Display Part of the cell value
- Re: Totals
- Re: Totals
- Inserting rows into worksheets that are protected
- Display Part of the cell value
- Re: Formula is entering a default time when it comes across an empty cell..
- Re: vlookup problem, possibly due to "noise"
- Re: Show trial solution
- Re: How to change number to text in new column from another worksheet?
- Re: vergelijken tabblad naam met waarde uit cel
- Re: Entering Same Formula to A Full Staring from Say Row 5 Column.
- Re: vergelijken tabblad naam met waarde uit cel
- Re: vergelijken tabblad naam met waarde uit cel
- Re: Condense formula
- From: Derek Y via OfficeKB.com
- Re: vergelijken tabblad naam met waarde uit cel
- Re: vergelijken tabblad naam met waarde uit cel
- Re: How Can I call any form or macro..
- Re: How can I call a macro or form. in the moment that enable any shee
- Re: how to change a list of possitive numbers to negative
- Re: Multiple Criteria for COUNTIF and SUMIF
- Re: Number of work sheets
- Re: Icon for "Wrap" and for "Centre Across Selection"
- Re: How to get date averages
- Re: How to get date averages
- Re: How to get date averages
- Discrete "Normal" Curve Function?
- Re: countif followup
- Re: countif followup
- Re: countif followup
- countif followup
- Re: conditional fraction - sumif?
- Re: countif problem - am I bonkers?
- Re: countif problem - am I bonkers?
- Re: conditional fraction - sumif?
- Re: countif problem - am I bonkers?
- Re: conditional fraction - sumif?
- countif problem - am I bonkers?
- Re: conditional fraction - sumif?
- Re: How to get date averages
- Re: How do I prepare a debt acceleration worksheet in Excel?
- Re: One line of list show up in different sheet
- Re: Cell text based on 4 condition test
- Re: how do i name a excel worksheet and make it appear in cell a1
- Cell text based on 4 condition test
- Re: Transferring data between worksheets
- Re: How do I prepare a debt acceleration worksheet in Excel?
- Re: Transferring data between worksheets
- Re: Identify missing record numbers
- Re: Transferring data between worksheets
- Re: Transferring data between worksheets
- Re: Transferring data between worksheets
- Re: Transferring data between worksheets
- Re: removing pre-set characters from comments
- Re: Is there a macro to convert times between 2 places dep. on date?
- Re: Averaging a Value Between Two Serial Dates
- Re: vlookup problem, possibly due to "noise"
- Value in cell refers to value in another cell
- Re: How to repair 2005-2006 student attendance record?
- Re: Suppress array formula #NA
- Re: todayif??
- Re: Compare range with another range in other workbook
- Re: search funtion
- Re: Forms Toolbar in Excel 2003
- Re: Count rows if date is between two specified dates
- Another Date issue.
- Re: Calculating elapsed time
- Re: Compare range with another range in other workbook
- Re: wrong year
- Re: removing unnecessary spaces from multiple cells
- Re: Column A = X, Column B =y count = count +1
- make custom formatting permanent
- Re: multiple formulas in one cell
- Re: Comparing 2 columns if they are the same
- Re: One line of list show up in different sheet
- " / " Changing Decimal number format to Fraction on Protected Cell
- need help righting script to sort rows alphabetically then seperate them to line up
- Re: help me on tough sum on conditions issue
- Re: Excel Help
- " / " Changing Decimal number format to Fraction on Protected Cell
- Re: Automate a date referenced in a formula pointing to another sh
- Re: Number of work sheets
- Re: can an array do this.....
- Re: can an array do this.....
- Re: formatting date-time values in macro
- Re: Simple Formula (I thought)
- Re: Formula is entering a default time when it comes across an empty cell..
- Re: sort in excel using end of email address
- Re: Count excluding Duplicates
- Re: sort in excel using end of email address
- Re: how do I autofill an excel worksheet with contacts from outlook?
- Re: sort in excel using end of email address
- Re: Count excluding Duplicates
- Re: Count excluding Duplicates
- Re: Count excluding Duplicates
- Re: how do you make negative numbers show up as 0 in Excel?
- Re: Multiple if or multiple vlookup
- Re: Text string and sum
- Multiple if or multiple vlookup
- Re: Condense formula
- From: Derek Y via OfficeKB.com
- Condense formula
- From: Derek Y via OfficeKB.com
- Re: Select rows based on criteria
- Re: 2nd attempt ~ Faster/Shorter formula
- Re: Select rows based on criteria
- Re: Multiple countifs
- Multiple countifs
- Re: With formulas does anyone know the order of precedence BOMDAS
- Re: Formula is entering a default time when it comes across an empty cell..
- Re: Text string and sum
- Re: extract numbers from cell containing text & numbers
- extract numbers from cell containing text & numbers
- =250/1440 format as [h]:mm:ss
- Re: I have alot of text in a cell, I just want to see the top line
- Re: Linked Combo Boxes
- Re: Linked Combo Boxes
- Re: if data in one cell, then date in adjacent cell
- Re: creating hyperlinks
- Re: combo Box
- Re: Auto Inserting numbers
- Re: if data in one cell, then date in adjacent cell
- Re: if data in one cell, then date in adjacent cell
- Re: if data in one cell, then date in adjacent cell
- Text string and sum
- Re: Countif with more than one criteria
- Re: Chart fixed r2 has a bug, use LINEST instead!
- Re: Macro to replace data within a worksheet
- Re: Headers getting lost in multiple sort
- Macro to replace data within a worksheet
- Re: Renaming Sequential Rows to create serial numbers
- Re: COMPUTING TWO COLUMNS
- Re: CF in a filter
- Re: Suppress array formula #NA
- Re: Q - Excel 2000: How to refer to worksheet in the same book?
- Re: can you use countif function for noncontiguous cells
- Re: can you use countif function for noncontiguous cells
- Re: VLOOKUP? Need to have value returned when select from drop-down list
- Re: Date format
- Re: How to make an input in one column determine dropdown list in
- Re: How to make an input in one column determine dropdown list in anot
- Re: World Clock
- Re: World Clock
- Re: Summing large numbers...
- Re: sequence of numbers
- Re: Help!!! Vlookup!!
- Re: Help!!! Vlookup!!
- Re: Countif with more than one criteria
- Re: Countif with more than one criteria
- Re: An Inquirey on the Round function
- Re: How can I sort one column and have the entire row sort. (bindi
- Re: part number with 'E'
- Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
- Re: Counting text across multiple sheets with a specific criterion
- Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
- Re: Help formatting cells
- Re: help me please on if function
- Re: Help formatting cells
- Re: Help formatting cells
- Re: frequency formula with criteria
- Re: Help formatting cells
- Re: Auto Sort using Macro
- Re: sequence of numbers
- Re: auto insert invoice number that increases by one each time opened
- sequence of numbers
- Re: Formula is entering a default time when it comes across an empty cell..
- Re: Formula is entering a default time when it comes across an empty cell..
- Re: Counting text across multiple sheets with a specific criterion
- Re: Financial Functions
- Re: How can I sort one column and have the entire row sort. (bindi
- Re: Average to date
- Re: Average to date
- Re: frequency formula with criteria
- Re: linest r-squared bug when calculating forced through zero?
- Renaming Sequential Rows to create serial numbers
- Re: How do I subtract using formulas?
- Re: If function for workday & weekend
- Re: Excel, turn off the hyperlink format when formula is @sum
- Re: If function for workday & weekend
- Re: Q - Excel 2000: How to refer to worksheet in the same book?
- Re: Display text > 1024 characters in a cell
- Re: Display text > 1024 characters in a cell
- Re: plot
- Re: Q - Excel 2000: How to refer to worksheet in the same book?
- Re: Q - Excel 2000: How to refer to worksheet in the same book?
- Auto Sort using Macro
- frequency formula with criteria
- Re: Performing Math with Time over 24 hours
- Re: Recalculation taking a massive 11 seconds
- Re: Counting text across multiple sheets with a specific criterion
- help me getting value of column based on condition
- Re: Referencing cell in another sheet yields null?
- Re: How can I use autosave from excel2000 in excel2003
- Re: VLOOKUP function
- Re: Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RA
- Re: transposing links
- Re: IF Function to test formula in a cell
- Re: IF Function to test formula in a cell
- Re: IF Function to test formula in a cell
- Re: linest r-squared bug when calculating forced through zero?
- Re: Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
- Re: Timesheet maximum hours problem
- Re: is there a function for getting the content of a cell?
- Re: transposing links
- Re: is there a function for getting the content of a cell?
- Re: is there a function for getting the content of a cell?
- sum of last 7 numbers
- Re: Recalculation taking a massive 11 seconds
- Re: looking for latest selling price..
- is there a function for getting the content of a cell?
- Re: Add excel horizontal & vertical ruler
- Re: Add excel horizontal & vertical ruler
- Re: Function newbie
- Re: drop down for excel?
- Re: Add excel horizontal & vertical ruler
- How to connect two columns in Excel VBA??
- Re: how to add 17.5% vat formula
- Re: VLOOKUP function
- VLOOKUP function
- Re: percentage
- Recalculation taking a massive 11 seconds
- Re: how to add 17.5% vat formula
- Re: Can I randomise the order of a number of rows?
- Re: Can I randomise the order of a number of rows?
- VLOOKUP? Need to have value returned when select from drop-down list
- Re: how to add 17.5% vat formula
- Re: transposing links
- Re: Multiple Range Pivot Table
- Re: How do I add a symbol between numbers in a column?
- Re: IF/THEN Average Problem
- Re: questions being addressed
- Re: IF/THEN Average Problem
- Re: IRR Calculation issues
- Re: How do you use the > < funjctions when calculating negative numbe
- Re: questions being addressed
- Re: 2nd attempt ~ Faster/Shorter formula
- Re: Pivot Table Question
- Re: prevent empty rows from printing
- Re: Timesheet maximum hours problem
- Re: Timesheet maximum hours problem
- Re: workday date function
- Re: Nesting SUMIF formulas
- Re: Input Range for a List Box
- Re: extract year
- Re: extract year
- Re: Validate drop down box
- I need to link only certain cell...
- Re: Colour full row in CF
- Re: Colour full row in CF
- Re: Conditional SUMIF???
- Re: Colour full row in CF
- Re: best way to get reference to all used cells
- Re: ##value error
- best way to get reference to all used cells
- Re: Colour full row in CF
- various values and listing them
- Re: Conditional SUMIF???
- Re: Colour full row in CF
- Re: Is there a function to give us the highest value in a list of tex
- Re: Excel Function returning negative 0
- Re: SUMPRODUCT
- Re: Excel Function returning negative 0
- Reformatting dates as text
- Excel Function returning negative 0
- Re: workday date function
- Re: Show timesheet time in and out in regular time versus military tim
- Re: need help with determining a formula
- Re: transposing links
- Re: With formulas does anyone know the order of precedence BOMDAS
- Re: Match help
- Re: With formulas does anyone know the order of precedence BOMDAS
- Re: countif condition problem
- Re: Help I am going crazy with this formula.
- Re: questions being addressed
- Re: Spreadsheet will not sort
- Re: sum>1 --> count = count +1
- Re: How do I compare excel spreadsheets, tracking the differences?
- Re: Columns in excel 2003
- Re: Columns in excel 2003
- Re: SUMIF question with multiple criteria
- Re: IF STATEMENT PROBLEM
- Checking for duplicate items in list
- Re: Reverse numerical values
- Re: Reverse numerical values
- Re: Multiple SUMIF Criteria
- Re: Worksheet tabs in a Macro
- Hour Sum
- Re: Calender Help
- Re: Replacing Values in Cells Via Formula
- IF statements and moving data to different columns
- Re: formula QUESTION
- Re: Help I am going crazy with this formula.
- Re: Change event fails to work
- Calender Help
- Re: combobox not working
- Re: ... I would like to apply more than 3 conditional formats ...
- Re: trend for polynomial curve fitting by regressing
- Help I am going crazy with this formula.
- Re: Showing the contents of a cell based on another cell
- Re: formula QUESTION
- Re: how can I have Excel total a column of # that were derived by form
- Re: COMPUTING TWO COLUMNS
- Re: Conditional Formatting
- Re: Conditional Formatting
- Re: Can I limit the amount of characters in a cell?
- Re: Cell reference to current cell minus 1
- RE: IF/AND/OR/DATEIF Issue...sorry...long post...
- Re: How to I get a warning message box
- Multiple SUMIF Criteria
- Re: Delete rows listed less than 8 times???
- Re: max and lookup
- Re: max and lookup
- Re: templates
- Delete rows listed less than 8 times???
- Formula is entering a default time when it comes across an empty cell..
- RE: how do i add every fifth row in a spreadsheet?
- RE: comparing many cols of data to one col
- Re: how do i add every fifth row in a spreadsheet?
- Re: How to I get a warning message box
- Re: How do I change hexadecimal number to binary in excel
- Re: Seting up an Indirect Formula
- Re: Footage to seconds (# to mm:ss).
- Re: Footage to seconds (# to mm:ss).
- Search for instances of X in a sheet
- Re: Macro?
- Re: Macro?
- Re: shortcut for merging selected cells would be nice.
- Re: If Function
- Re: Showing the contents of a cell based on another cell
- RE: function problem
- Re: ... I would like to apply more than 3 conditional formats ...
- Re: Nested IF's with Rank Problem
- Re: function problem
- From: bplumhoff@xxxxxxxxx
- Re: Showing the contents of a cell based on another cell
- Showing the contents of a cell based on another cell
- Re: How do I select & use contents of first non-blank cell in row?
- Re: is it possible to make a spreadsheet display '0' when negative
- populate data valadation list by criteria
- Re: using the same function to convert a column of numbers
- Re: pricing problems
- Creating Combinations
- Re: LOOKUP
- Nested IF's with Rank Problem
- New Auto Selecting Cell Question
- Re: Excel multiline formulas
- Re: Using Two Worksheets To Capature Data
- Re: Conditional Formatting
- Re: How do I set up an IF function with text and numbers?
- Re: Searching for a particlar value and matching to a name..
- Re: How do I set up an IF function with text and numbers?
- Re: Calendar - vlookup based on dates
- Re: How do you count data that matches more than one condition?
- Re: sum
- Re: counting 0 in a row
- Re: counting 0 in a row
- Re: sum
- Help matching entries in two sheets???
- sum
- Re: Copied nubers is not possible to add
- Re: Copied nubers is not possible to add
- Re: SSN Format not showing
- Re: Formula Help
- Re: Using Autofilter with Protection on
- Re: splitting names can't see whats going wrong (Save My Sanity )
- Re: Worksheet tabs in a Macro
- Re: STRING functions
- Re: What function can I use
- Worksheet tabs in a Macro
- Re: STRING functions
- STRING functions
- Re: How to AUTO SORT A-Z new data in a column (not menual sorting)
- Re: counting 0 in a row
- Re: Can someone give me a hand with this formula please?
- Re: Autofilter stops responding
- Re: how to automatically convert a number to words in Excel
- Re: Function IN VBA
- Re: two cases for countif
- two cases for countif
- Re: Autofilter with Subtotal Sumif
- Re: how to automatically convert a number to words in Excel
- Re: Calc Diff Between Two Julian Date
- Excel Crashes
- Autofilter stops responding
- Re: Can someone give me a hand with this formula please?
- Re: Autofilter with Subtotal Sumif
- Re: Can someone give me a hand with this formula please?
- Re: How can I add data analysis function in tool?
- keep active sheet view and cursor position
- Re: pricing problems
- Re: Can someone give me a hand with this formula please?
- Re: Vlookup doesn't work until i edit(but not change) the lookup cell
- Can someone give me a hand with this formula please?
- Re: Autofilter with Subtotal Sumif
- Re: Complicated IF Formula
- Re: Vlookup doesn't work until i edit(but not change) the lookup cell
- Re: How to Append the Data to the Master Table
- Re: Need help creating a formula to summarize data!
- can we round time in excel
- Re: Need help creating a formula to summarize data!
- Re: How do you average if your data contains a 0?
- Re: Vlookup doesn't work until i edit(but not change) the lookup cell
- Re: Calendar - vlookup based on dates
- Re: Autofilter with Subtotal Sumif
- Re: Average with a 0 in the equation
- Re: Need help creating a formula to summarize data!
- Re: Formula Help
- Re: Limiting the range of a lookup function
- Re: dynamic summed range based on a variable
- Re: Count and Sum cells with certain format (e.g. color)
- Count and Sum cells with certain format (e.g. color)
- Re: splitting names can't see whats going wrong (Save My Sanity )
- Re: Searching for a particlar value and matching to a name..
- Re: lookup tables
- Re: lookup tables
- Re: Time Sheet frustrations
- splitting names can't see whats going wrong (Save My Sanity )
- Re: How can I display a "sliding" range?
- Re: Delete Formula
- Re: IF statement containing OR
- Re: pricing problems
- Re: Calc Diff Between Two Julian Date
- Re: Logon Screen
- Logon Screen
- Drop-down boxs
- Re: Non-Blank Cells: Conditional Counting
- Re: Multiple IF
- Re: Non-Blank Cells: Conditional Counting
- Re: counting 0 in a row
- Re: VLOOKUP Problem (limitation)?
- VLOOKUP Problem (limitation)?
- Re: "Rows to repeat at top" option under page setup
- Re: Vlookup returning Hyperlinks
- Re: IRR Guess Problem
- Re: {=AVERAGE(IF((C3:C325<M4), C3:C325))}
- "Rows to repeat at top" option under page setup
- Re: import external data too many rows for one worksheet
- Re: Creating a league table based on results
- {=AVERAGE(IF((C3:C325<M4), C3:C325))}
- Re: How do I lookup a corresponding value in another table
- Re: How do I lookup a corresponding value in another table
- Re: Columns with "zero" width
- Re: Time sheets
- Re: Columns with "zero" width
- Re: Confused beginner
- Re: overcoming nested IF limitations...with VBA?
- Re: Creating a league table based on results
- Re: event macros - xl 2003
- Re: How to Append the Data to the Master Table
- Re: Vlookup returning Hyperlinks
- Re: Goodness of fit function
- Re: embeding a picture into a cell
- Re: How to return a value Referring to the other cell.
- Re: embeding a picture into a cell
- Re: toclearasell
- Re: How to Append the Data to the Master Table
- Re: unable to open file
- Re: need a function to calculate a mortgage payment
- Re: How to Append the Data to the Master Table
- Re: Excel Holiday Roster Calender
- Re: conditional subtotal counting
- Re: Average, IF
- Look up a list of prices
- Re: Counting Age
- Re: Counting Age
- Re: IF Function
- Counting Age
- Re: Average, IF
- Re: Average, IF
- Re: conditioning
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: counting 0 in a row
- Re: conditioning
- Re: Average, IF
- Re: Vlookup worksheet function
- Re: MATCH Limitation?
- Conditionally Fill a sheet row if cell value in another sheet >0
- Re: Bessel function/directivity function
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: Vlookup worksheet function
- Re: Auto Selecting Cells
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: Average, IF
- Re: E-mail sent for a cell in a sheet that lists a birthday as today
- Re: I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
- Re: excel formula to enter "0" if cell blank
- Re: Limiting the range of a lookup function
- Vlookup worksheet function
- How to Append the Data to the Master Table
- Re: event macros - xl 2003
- Re: Finding Bad Web Queries
- Re: How to make data in one workbook appear automatically In another
- Re: Merging Text Help
- Re: Merging Text Help
- Re: How can I use the same validation for an entire column?
- Re: How can I use the same validation for an entire column?
- Re: Auto Selecting Cells
- Re: Auto Selecting Cells
- Re: want sumif function's range to evaluate 2 columns
- Re: linking columns
- Re: want sumif function's range to evaluate 2 columns
- Re: mortgage calculator formula
- Re: problem with #value!/zero
- Re: Dynamic Average
- Dynamic Average
- Re: change the colour of text in cell for minus figure
- Re: Confused beginner
- Re: Percentages
- Percentages
- Re: Confused beginner
- Re: change the colour of text in cell for minus figure
- Re: Workingday Calculations
- Re: Confused beginner
- Re: Lock row in Excel
- Re: Workingday Calculations
- Re: Workingday Calculations
- Re: Confused beginner
- Re: Auto Selecting Cells
- Re: Auto Selecting Cells
- Re: How to add date format into if statement?
- New Menus - attaching but menus are reset
- Re: How to add date format into if statement?
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: How to highlight a row containing specific phrase?
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: How to return a value Referring to the other cell.
- Re: How to return a value Referring to the other cell.
- Re: After adding Analysis Tool Pack, still no PRICE function, why?
- How to return a value Referring to the other cell.
- Re: Some rows sort incorrectly in Excel. How do I correct the problem.
- Re: linking columns
- Re: don't allow users to assign the cntrl+s as a short cut for macro
- Re: Hyperlink Formula to call up browser
- Re: YEAR and MONTH confusion
- Re: anova post-hoc analysis: tukey test
- Re: Finding Min Cell values excluding zero in alternate columns
- Re: How do I hide #N/A, ### in cells not yet worked on?
- Re: column and row headings
- Re: Number of hours worked between 18:00 and 06:00
- Converting functions into numbers
- Re: Hide text in shaded cell
- Re: Cell reference in diff worksheets
- subtotal
- Hyperlink Formula to call up browser
- Re: adding rows of hours and minutes to get a total
- adding rows of hours and minutes to get a total
- Re: Using MAX to reference a row
- Re: sumproduct based on format
- Re: Sumif
- sumproduct based on format
- Re: Getting Excel to Calculate All Combinations of a Set of Data?
- Re: Sumif
- Getting Excel to Calculate All Combinations of a Set of Data?
- Re: How to blank a cell with a formula
- Re: Range used in a macro needs to be variable
- Re: How can I correct this Time formula
- How to blank a cell with a formula
- Average given criteria, HELP!
- Re: Ordering fields formatted YYYY Mth in a Pivot
- Re: How can I correct this Time formula
- Re: Ordering fields formatted YYYY Mth in a Pivot
- Re: Need to Sum Mon-Sat each seven days; Average Sunday
- Re: How can I correct this Time formula
- Re: Income Tax Payable from table with escalating marginal percentage rates.
- Re: Hide 0% figures in Pivot Table
- How can I correct this Time formula
- Link A Cell In O ne Workbook To A Formula In Another Workbook
- Count cells with strikethrough font?
- Re: Is there a pull down Box to alert for minus balance such as ($5.00
- Re: Referring to Cells in a forumula using a function
- Re: could someone help!
- Re: simple MAX + comparison formula
- simple MAX + comparison formula
- Number of hours worked between 18:00 and 06:00
- =if(and(....
- Re: significant digits for decimals
- Re: Links only update when external workbook is open
- Re: Translating an IF formula from Lotus 1-2-3 to Excel
- Re: isolating different aspects of worksheets...as objects? through section breaks?
- Re: Convert mins:secs to seconds only
- Re: Links only update when external workbook is open
- Re: Income Tax Payable from table with escalating marginal percentage rates.
- How do you link 2 drop-down menus?
- Re: Why doesn't my resized worksheet have a minimize or close box
- Re: Vlookup based on designated occurrence of value
- Re: Countif using Wildcard * and number 1
- Re: significant digits for decimals
- Re: Eliminating blank cells in a list on a ROW
- Re: "IF" function - 7 nested limit
- Locking linked cells
- Counting the number of times a specific character appears in a cell
- Re: search all tabs for tab name specified & lookup reference?
- Re: "IF" function - 7 nested limit
- Re: significant digits for decimals
- Re: Vlookup based on designated occurrence of value
- Re: Convert weeknr to a date
- From: converting 05445 to 2005-10-04
- Re: Finding a value within two rows
- Re: search all tabs for tab name specified & lookup reference?
- Eliminating blank cells in a list on a ROW
- Re: Using CountIf with criteria on another sheet
- Re: Payroll analysis
- Navagating issue
- Re: Creating a Web Query
- Countif using Wildcard * and number 1
- Re: Unusual data format
- Calculate Total Sales from a Database
- Re: formula to calculate future date from date in cell plus days
- listing and selecting data
- Re: How do I write a formula in Excel
- Re: How do I write a formula in Excel
- Re: Editing Repeated Text
- Re: Random Date Generation
- From: bplumhoff@xxxxxxxxx
- Re: Compare worksheets and generate list of missing data?
- Moving a sheet from one work book to another?
- Re: formula cut and paste
- Re: formula cut and paste
- Re: Just a test message to be deleted
- Re: Conditional Formatting
- Re: useform autosize to fullscreen problem
- Re: Points Ranking Formulas
- Re: Returning one text value in a long list?
- Re: Charting
- Re: Returning one text value in a long list?
- useform autosize to fullscreen problem
- From: Pierre via OfficeKB.com
- Just a test message to be deleted
- Re: Extract Fractional Numbers as Numbers NOT Date
- Re: Combining sheets on one
- Re: Convert mins:secs to seconds only
- Convert mins:secs to seconds only
- Re: How do I write a formula in Excel
- Unusual data format
- Re: formula to calculate future date from date in cell plus days
- Re: update multiple worksheet in single book
- Re: Vlookup based on designated occurrence of value
- Vlookup based on designated occurrence of value
- Re: Combining sheets on one
- Re: Translating an IF formula from Lotus 1-2-3 to Excel
- Re: hide sheets use data
- Re: update multiple worksheet in single book
- Re: update multiple worksheet in single book
- Conditional format combined with functions
- Re: Text to Number
- Re: Need to Sum Mon-Sat each seven days; Average Sunday
- Re: How can the count of filtered records always display?
- Text to Number
- Re: Extract Fractional Numbers as Numbers NOT Date
- Re: can't find custom function code
- Re: Copy data to another column Macros
- Re: Copy data to another column Macros
- Re: Formula for a time card
- Copy data to another column Macros
- Re: Extrapolate numeric values from text string
- Re: Convert weeknr to a date
- Re: vlookup function return all values
- Re: vlookup function return all values
- Re: Changing a Formula in Conditional Formatting
- Re: Using a cell value for row in R1C1
- Currency button
- Re: Text displays as ### in a cell.
- Re: How can I type Excel numbers to show as a barcode?
- Re: I need a " IF THIS THEN _" formula
- Re: I need a " IF THIS THEN _" formula
- Re: Using a cell value for row in R1C1
- Re: multiplying with excell
- Re: Need Help with Replace Function
- Re: Yup - another question!
- Using a cell value for row in R1C1
- Re: Why does / key act like Alt+F and highlight file menu not type /
- Re: Need to Sum Mon-Sat each seven days; Average Sunday
- Re: Need to Sum Mon-Sat each seven days; Average Sunday
- Re: Hourly rates
- Returning one text value in a long list?
- how to let the userform autosize depending on the screen resolution
- From: Pierre via OfficeKB.com
- color the interior of a range
- From: Pierre via OfficeKB.com
- Re: Range Lookup in VLookup ?'s
- Re: Hourly rates
- Re: Combining sheets on one
- Re: numbers to time
- numbers to time
- Re: If True Concatenation
- Re: Simple find with right function
- Re: If True Concatenation
- Re: how to I make an excel spreadsheet into a label format?
- Re: how to I make an excel spreadsheet into a label format?
- Re: anova post-hoc analysis: tukey test
- Re: Convert Text to Number
- Re: Has anyone had formulas change automatically with no explanation?
- Re: Function or Formula
- format combobox in userform to accept dates
- Re: SUMPRODUCT as array formula?
- Re: How to lookup row # based on content of another column's cell
- Re: Need Help with Replace Function
- Re: Simple find with right function
- Re: Function or Formula
- Re: Vlookup using text
- Re: Function or Formula
- How do I write an 'if exist" statement
- Re: Function or Formula
- Re: Need Help with Replace Function
- Re: Find a "date" in a column of dates in Excel 2000
- Re: Lookup Value between 2 ranges
- Re: Historical Quotes
- Re: index / match ?
- Re: # of Worksheets
- Re: Countif with star operator in criteria
- RE: Max and MIN question
- RE: Max and MIN question
- Re: Countif with star operator in criteria
- Re: update multiple worksheet in single book
- anova post-hoc analysis: tukey test
- Re: large / sumproduct combo
- Re: Progressive Calculation
- Re: Showing Mininum $ for items
- Re: Indirect in combination with ROW
- Re: adding color to cells based on a formula
- Re: Date Format
- Re: large / sumproduct combo
- Re: How to extract the data
- Re: If True Concatenation
- Re: update multiple worksheet in single book
- Re: Can Excel calculate the effect of extra principal on loans?
- Re: Progressive Calculation
- Re: Data Validation List Length
- Re: Data Validation List Length
- Re: IF text statements
- Re: 12 digit code sorting
- Re: IF text statements
- Re: Indirect in combination with ROW
- Re: Radio Buttons
- Re: IF text statements
- Re: DIAS.LAB function poblem
- Re: Commission Calculation
- Re: Commission Calculation
- Re: 12 digit code sorting
