microsoft.public.excel.worksheet.functions
- Re: nested if
- Re: Delete in row C if it is repeated in row D
- From: squenson via OfficeKB.com
- Re: counting numbers in a range
- RE: Extracting Numbers froma Text String
- counting numbers in a range
- Re: Compare a value and if is true copy the line to other workshee
- RE: Extracting Numbers froma Text String
- Re: =sumproduct(round(
- Re: How can I name Worksheet Tabs based on some king of reference?
- Re: ########### error
- Delete in row C if it is repeated in row D
- RE: Extracting Numbers froma Text String
- Re: Extracting Numbers froma Text String
- From: Rick Rothstein \(MVP - VB\)
- RE: Extracting Numbers froma Text String
- Re: Linear Regression in Excel
- Re: =sumproduct(round(
- Re: Formatting a cell to turn "white" when filled in...
- Re: EXCEL - unable to get "TEXT" to wrap, even though cell is formatte
- Re: RUNNING TOTALS...FORMULA NEEDED
- Re: How do I return the 10th day of the following month?
- Re: EXCEL - unable to get "TEXT" to wrap, even though cell is formatte
- Re: How can I name Worksheet Tabs based on some king of reference?
- Re: =sumproduct(round(
- Re: How do I sum column D and F based on multiple column criteria?
- Re: Question Involving COUNTIF and Possibly DCOUNTA
- Re: Question Involving COUNTIF and Possibly DCOUNTA
- Re: Question Involving COUNTIF and Possibly DCOUNTA
- Re: Question Involving COUNTIF and Possibly DCOUNTA
- Re: Question Involving COUNTIF and Possibly DCOUNTA
- Re: Print Area Question
- Re: How can I find percentages of a number
- Re: calculating a formula for a service level
- Re: Data is not visible in merged and wrapped cells
- Re: Greater of Two Cells
- Re: How can I find percentages of a number
- Re: Change Military time on Imported Cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Compare side by side stuck
- Re: sumproduct
- From: squenson via OfficeKB.com
- Re: Compare side by side stuck
- Re: is there a way to format the date in an excel footer eg just year
- Re: Compare arrays
- Re: Not understanding MROUND
- Re: Edit Paste Special Formulas
- Re: Excel formula
- Not understanding MROUND
- Re: Formating Cells for Time
- =sumproduct(round(
- Re: nested if
- Formating Cells for Time
- Re: nested if
- Re: month plus one - excel 2003
- Re: month plus one - excel 2003
- Re: nested if
- Re: HELP ON AGE RANGES
- Re: HELP ON AGE RANGES
- Re: HELP ON AGE RANGES
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel formula
- Re: Dynamic link to website
- Re: HELP ON AGE RANGES
- From: squenson via OfficeKB.com
- HELP ON AGE RANGES
- Re: Dynamic link to website
- correlation when the cell references vary
- Dynamic creation, or something different needed?
- Re: finding all cells that match a certain value
- Re: Change Military time on Imported Cell
- From: Rick Rothstein \(MVP - VB\)
- Re: finding all cells that match a certain value
- RE: Pivot Tables with text
- Re: Change Military time on Imported Cell
- From: Rick Rothstein \(MVP - VB\)
- RE: How can I find percentages of a number
- Re: Rounding issue
- Re: Copy cells to specific sheets
- Re: Lookup for smallest number?
- Re: Edit Paste Special Formulas
- Re: How do I add a simple calculator ( Like the one found in accessori
- Re: Rounding issue
- Re: Change Military time on Imported Cell
- From: Trevor Shuttleworth
- Re: Change Military time on Imported Cell
- From: Trevor Shuttleworth
- Re: How do I return the 10th day of the following month?
- Re: Change Military time on Imported Cell
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I add a simple calculator ( Like the one found in accessori
- Re: finding all cells that match a certain value
- Re: How do I return the 10th day of the following month?
- Re: How do I add a simple calculator ( Like the one found in accessori
- Re: summing all results in a vlookup
- Re: Rounding issue
- Re: Conditional comparison of values.
- Re: finding all cells that match a certain value
- Re: a check mark next to something means what?
- From: Rick Rothstein \(MVP - VB\)
- enter user in cell
- Re: how to muliply
- RE: Bringing Data From Access To Excel
- Re: Formula for time cards
- Re: macro change formatting
- Re: Copy Cells
- Re: Excel filters
- Re: a check mark next to something means what?
- Re: Can the function window be expanded?
- Re: Copy Cells
- sheet duplicate
- Re: how to muliply
- Re: how to muliply
- Re: how to muliply
- Re: Copy cells to specific sheets
- Re: How do I return the 10th day of the following month?
- how to muliply
- Re: Dynamic average
- RE: Bringing Data From Access To Excel
- Re: Sum in Excel
- Re: how to use towords formula
- RE: CountIf embedded in an IF statement
- nested if
- RE: CountIf embedded in an IF statement
- RE: Calculating cost of product
- RE: CountIf embedded in an IF statement
- That it's been checked!
- Re: Can the function window be expanded?
- Re: Hello
- Re: Conditional comparison of values.
- Re: Need formula assistance ASAP
- Re: Need formula assistance ASAP
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif within and if statement
- From: Rick Rothstein \(MVP - VB\)
- Re: Need formula assistance ASAP
- From: Rick Rothstein \(MVP - VB\)
- Re: how to use towords formula
- From: Rick Rothstein \(MVP - VB\)
- Compare text string of a cell in Column A VS another cell in Colum
- Re: Merging Columns
- Re: Bringing Data From Access To Excel
- Re: SUM
- Re: Filtering a column and not all cells are available
- Re: The formula does not calculate properly... Help me if you could..
- Re: Lookup for smallest number?
- Re: Lookup for smallest number?
- Re: SUM
- Re: The formula does not calculate properly... Help me if you could..
- Re: Lookup for smallest number?
- Re: Lookup for smallest number?
- Re: Please help!!!
- Re: Three sheets total!
- Re: Merging Columns
- Re: Importing Data Into Excel
- Re: Changing portrate to landscape within publisher
- Three sheets total!
- Changing portrate to landscape within publisher
- From: chedd via OfficeKB.com
- RE: Create a "cell button" to hide selected cells.
- Re: Finding a number based on a criteria
- Re: Finding a number based on a criteria
- Re: Merging Columns
- Re: Applying pop up calendar to entire worksheet
- Re: finding all cells that match a certain value
- Re: finding all cells that match a certain value
- Re: finding all cells that match a certain value
- Re: finding all cells that match a certain value
- Re: paste greyed out
- RE: BwiSwy Help Please
- Re: Summing a ranking of several categories
- Re: finding all cells that match a certain value
- RE: dismiss blanks in lookup
- Re: Extract specific text
- Re: Extract specific text
- From: Rick Rothstein \(MVP - VB\)
- Re: Summing a ranking of several categories
- Re: Extract specific text
- RE: dismiss blanks in lookup
- Re: Extract specific text
- Re: Highlite the cell if above 5:31
- From: Rick Rothstein \(MVP - VB\)
- Re: Merging Columns
- RE: Copy Data only if the cell has a value
- Re: Multiple "lookup_value"
- RE: Copy Data only if the cell has a value
- Re: Calculating cost of product
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Extract specific text
- Re: Merging Columns
- Re: Extract specific text
- From: Rick Rothstein \(MVP - VB\)
- Re: Merging Columns
- Re: Merging Columns
- Re: Merging Columns
- Re: Summing a ranking of several categories
- Re: Extract specific text
- Re: Extract specific text
- Re: Multiple "lookup_value"
- Re: changing cell references
- Re: Insert calender
- Re: Applying pop up calendar to entire worksheet
- Re: Extract specific text
- Re: Extract specific text
- Re: Extract specific text
- From: Rick Rothstein \(MVP - VB\)
- Re: Extract specific text
- Re: changing cell references
- Re: Change number of years
- Re: Excel 2003
- Re: blinking number
- Re: Frequency formula
- Re: Multiple "lookup_value"
- Re: regional settings
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Multiple "lookup_value"
- Re: Order/Rank
- Re: NonLinear R-squared (R2)
- Re: Order/Rank
- Re: blinking number
- Re: changing cell references
- Re: Order/Rank
- Re: blinking number
- Re: Multiple "lookup_value"
- Re: Excel 2002: How to Select Greater Value of Numerous Cells?
- From: Rick Rothstein \(MVP - VB\)
- Re: Multiple "lookup_value"
- Re: count and return pair numbers
- From: Rick Rothstein \(MVP - VB\)
- Re: Multiple "lookup_value"
- Re: count and return pair numbers
- Re: count and return pair numbers
- From: Rick Rothstein \(MVP - VB\)
- Re: count and return pair numbers
- From: Rick Rothstein \(MVP - VB\)
- Re: count and return pair numbers
- From: Rick Rothstein \(MVP - VB\)
- Re: Order/Rank
- Re: Multiple "lookup_value"
- Re: First day of month
- Re: insert images in a protected worksheet
- Re: seperating data from one cell to multiple cells?
- Re: Top Ten List by Individual Volume
- From: squenson via OfficeKB.com
- Re: Finding the earliest date from a range of cells
- From: squenson via OfficeKB.com
- Re: Finding the earliest date from a range of cells
- Finding the earliest date from a range of cells
- Finding the earliest date from a range of cells
- Re: Order/Rank
- Re: First day of month
- Re: Function refering sheet index.
- Re: Dynamic average
- Re: insert images in a protected worksheet
- Re: insert images in a protected worksheet
- Re: Combining worksheets with common column but different number o
- Re: How do you calculate a negative percentage
- Re: Date issue
- Re: posting
- Re: negative and positive sums
- Re: Formula to determine selling price with cost known @ X margin?
- From: Rick Rothstein \(MVP - VB\)
- RE: Dollar/Euro/Pound Excel macro
- RE: Dollar/Euro/Pound Excel macro
- Re: Order/Rank
- Re: Order/Rank
- Re: Order/Rank
- Re: Formula to determine selling price with cost known @ X margin?
- Re: Formula to determine selling price with cost known @ X margin?
- From: Rick Rothstein \(MVP - VB\)
- Re: increasing a cell value on each use
- Re: How do I permanently delete a custom toolbar in Excel?
- Re: Dynamic average
- Re: DSUM Partial Match
- Re: DSUM Partial Match
- Re: increasing a cell value on each use
- Re: Date issue
- Re: ComboBox - Link Cell that Accumulates
- Re: Date issue
- Re: How do I permanently delete a custom toolbar in Excel?
- Re: Combining worksheets with common column but different number of ro
- Re: Help with lookup (vlookup)
- RE: Dollar/Euro/Pound Excel macro
- Re: Function to return a month name from a number (1-12) that is not a
- Re: If function with and
- Re: posting
- Re: multiple IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: How do you calculate a negative percentage
- Re: Count of Value based on another value
- Re: multiple IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: Count of Value based on another value
- Re: multiple IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: multiple IF statements
- Re: Excel Formula Help
- Re: How do I permanently delete a custom toolbar in Excel?
- Re: multiple IF statements
- Re: Color Banding
- Re: multiple IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: posting
- Re: multiple IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I print comments individually?
- Re: Help! I need a formula to add numbers separated by commas wit
- Re: multiple IF statements
- Re: Function to return a month name from a number (1-12) that is not a
- Re: insert images in a protected worksheet
- Re: Dynamic average
- Re: insert images in a protected worksheet
- Re: Macro Problem
- Re: insert images in a protected worksheet
- Re: insert images in a protected worksheet
- Re: Dynamic average
- RE: Calculate Selected cells only.
- Re: multiple IF statements
- Re: Importing Data Into Excel
- Re: Display data retrieved from website and have it update periodicall
- Re: Dynamic average
- Re: Copy row below
- Re: Dynamic average
- Re: multiple IF statements
- Re: insert images in a protected worksheet
- Re: Copy row below
- Re: sumproduct - multiple conditions
- Re: multiple IF statements
- Re: Dynamic average
- Re: Function refering sheet index.
- Re: spreadsheets
- Re: spreadsheets
- Re: Macro Problem
- Re: Unexpected #N/A error from INDEX-MATCH combo
- Re: Function refering sheet index.
- Re: remove preceding zeros
- Function refering sheet index.
- Unexpected #N/A error from INDEX-MATCH combo
- Re: First day of month
- Re: Forecast and Trends
- Re: paste greyed out
- Re: sumproduct - multiple conditions
- Re: Dynamic cell reference using INDIRECT..
- From: Jason.Alden.Benoit@xxxxxxxxx
- Re: sumproduct - multiple conditions
- Re: sumproduct - multiple conditions
- Re: Preserve format, right tab using concatenate
- Re: separate an address street/city,state,zip within a cell?
- From: Rick Rothstein \(MVP - VB\)
- Re: Dynamic cell reference using INDIRECT..
- Re: Dynamic cell reference using INDIRECT..
- From: Jason.Alden.Benoit@xxxxxxxxx
- Re: my excel worksheet will not display gridlines
- Re: First day of month
- Re: First day of month
- Re: First day of month
- Re: my excel worksheet will not display gridlines
- Dynamic cell reference using INDIRECT..
- From: Jason.Alden.Benoit@xxxxxxxxx
- First day of month
- RE: PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE.
- Keeping column name in view when scrolling
- Re: compound rate of return calculation
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- RE: Dollar/Euro/Pound Excel macro
- Re: compound rate of return calculation
- Re: posting
- Re: separate an address street/city,state,zip within a cell?
- Re: separate an address street/city,state,zip within a cell?
- Re: posting
- Re: separate an address street/city,state,zip within a cell?
- Re: compound rate of return calculation
- Re: compound rate of return calculation
- Re: R squared
- Re: Count occurrences of text within a cell
- Re: calender
- Re: R squared
- Re: Count occurrences of text within a cell
- Re: sumproduct - multiple conditions
- Re: How do I remove the 'end' function in Excel 2003?
- Re: sumproduct - multiple conditions
- Re: How do I permanently delete a custom toolbar in Excel?
- Re: Dynamic average
- Re: Lookup values in 2 columns, count and then multiply??? HELP!
- Re: Count occurrences of text within a cell
- Re: Function explaination need
- Re: Lookup values in 2 columns, count and then multiply??? HELP!
- Re: Formula displays, not value
- Re: Function explaination need
- Re: Splitting text in a cell
- Re: RENAMING WORKSHEETS
- Re: Dynamic average
- RE: Dollar/Euro/Pound Excel macro
- Re: Month name to number of months YTD
- Re: Date Formula
- calender
- RE: Trying to match up variables to a common list and confirm
- Re: How do I remove the 'end' function in Excel 2003?
- Re: Month name to number of months YTD
- RE: Trying to match up variables to a common list and confirm
- Re: Splitting text in a cell
- Re: Month name to number of months YTD
- Re: Macro Problem
- Re: Converting from Norwegian Krone to US Dollars format
- Re: Workbook_BeforeClose Question
- RE: Trying to match up variables to a common list and confirm
- RE: Trying to match up variables to a common list and confirm
- RE: Trying to match up variables to a common list and confirm
- Re: Workbook_BeforeClose Question
- Re: Converting from Norwegian Krone to US Dollars format
- Re: Trying to match up variables to a common list and confirm
- Re: Workbook_BeforeClose Question
- Re: Macro Problem
- Re: Month name to number of months YTD
- Re: Month name to number of months YTD
- Date Formula
- Re: Trying to match up variables to a common list and confirm
- Re: vlookup returning a value in more than one cell
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- Re: Formula displays, not value
- Re: Excel 2003
- Re: Using the "Count" function with filters?
- Re: Using the "Count" function with filters?
- Re: column alignment
- Re: Work Sheet failed to open fully & stuck at one cell only
- Re: vlookup returning a value in more than one cell
- Re: vlookup returning a value in more than one cell
- Re: Copying a formula which uses indirect()
- Re: How to remove duplicated data repeated in a column and keep ju
- Re: seperating data from one cell to multiple cells?
- Re: vlookup returning a value in more than one cell
- Re: vlookup returning a value in more than one cell
- Re: seperating data from one cell to multiple cells?
- Re: Copy from one sheet to another
- Re: Macro Problem
- Re: How to remove duplicated data repeated in a column and keep just o
- Re: vlookup returning a value in more than one cell
- Re: Subtract a future month from the current month to get remaining m.
- Re: Help! I need a formula to add numbers separated by commas wit
- Re: Converting from Norwegian Krone to US Dollars format
- Re: Finding the value of x
- Re: Finding the value of x
- Count of Value based on another value
- Re: Vlookup returns #N/A correctly...but...
- Re: Vlookup returns #N/A correctly...but...
- Re: Vlookup returns #N/A correctly...but...
- RE: Create a "cell button" to hide selected cells.
- Re: vlookup returning a value in more than one cell
- Re: How can Iextend a cell conditional formating to an entire line ?
- Re: Lookup values in 2 columns, count and then multiply??? HELP!
- Re: Function to return a month name from a number (1-12) that is not a
- Re: Function to return a month name from a number (1-12) that is not a
- Lookup values in 2 columns, count and then multiply??? HELP!
- Re: Average with #div
- Re: Excel count based on value in another column
- Re: Rounding problems
- Excel count based on value in another column
- RE: VLOOKUP using two criteria
- [ot]Re: How to format cell to display "NIL" if value of cell is zero in Ex
- Re: Rounding problems
- Re: Rounding problems
- Re: Rounding problems
- Re: posting
- Re: posting
- Re: Rounding problems
- Re: Need to creat dependent drop down list
- Re: How to format cell to display "NIL" if value of cell is zero in Ex
- Re: How to calculate the Date occurs
- DATE
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- Re: negative and positive sums
- Re: Need a formula, please!
- Re: How to format cell to display "NIL" if value of cell is zero in Ex
- Re: Difference of two dates
- Re: How to run a macro with the IF command
- Re: How to calculate the Date occurs
- Re: Difference of two dates
- Re: Need to creat dependent drop down list
- Re: Average nesting within Sumproduct?
- Re: finding all cells that match a certain value
- RE: Create a "cell button" to hide selected cells.
- finding all cells that match a certain value
- Re: Sheet Background does not print
- Re: Formula displays, not value
- Re: R squared
- Re: Help! I need a formula to add numbers separated by commas wit
- Re: Sheet Background does not print
- Re: Help! I need a formula to add numbers separated by commas within
- Re: Sheet Background does not print
- Sheet Background does not print
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- How to calculate the Date occurs
- Re: LOOKUP Formula
- Re: R squared
- Re: vlookup returning a value in more than one cell
- Re: Help! I need a formula to add numbers separated by commas within
- Re: Help! I need a formula to add numbers separated by commas within
- Re: posting
- Re: I need to calculate a Geometric mean
- Re: I need to calculate a Geometric mean
- Re: I need to calculate a Geometric mean
- Re: posting
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- Re: vlookup returning a value in more than one cell
- Re: vlookup returning a value in more than one cell
- Re: Extracting Rows to Make A Totals Sheet
- Re: Work Sheet failed to open fully & stuck at one cell only
- Re: R squared
- Re: Can excel list combinations
- Re: posting
- Re: posting
- Re: [OT] posting
- Re: posting
- Re: Copy from one sheet to another
- Re: R squared
- Re: Sorting dates
- Re: R squared
- Re: R squared
- Re: plus 1
- Re: Workbook_BeforeClose Question
- Re: posting
- Re: How to run a macro with the IF command
- Re: Trying to insert a row. Insert wont Activate
- Re: Calculating how many Saturdays there are between two given dates
- Re: How do I caluclate an Annual Percentage Rate in Excel?
- Re: Counting unique items based on date
- Re: vlookup returning a value in more than one cell
- Re: When I enter a formula, Excel shows the formula not the result
- Re: When I enter a formula, Excel shows the formula not the result
- Re: Counting unique items based on date
- Re: Backwards? lookup function
- Can excel list combinations
- RE: Finding The MAX Value
- RE: Finding The MAX Value
- Re: When I enter a formula, Excel shows the formula not the results
- Re: sum question
- Re: When printing, I get 5 extra blank pages. How do I delete them
- Help with Index / Match function
- Re: When printing, I get 5 extra blank pages. How do I delete them?
- Re: R squared
- Re: [OT] posting
- Re: [OT] posting
- Re: Calculating how many Saturdays there are between two given dates
- Re: Cell reference to make a directory path
- HLOOKUP with 2 values and choose 1 value
- Re: Cell reference to make a directory path
- Re: take the green pill or take the SUMPRODUCT?
- Re: take the green pill or take the SUMPRODUCT?
- Re: Cell reference to make a directory path
- Re: Cell reference to make a directory path
- Re: plus 1
- take the green pill or take the SUMPRODUCT?
- Re: Cell reference to make a directory path
- Re: Another Quetion about lookups with errors
- Re: negative and positive sums
- Re: Cell reference to make a directory path
- Re: Calculating how many Saturdays there are between two given dates
- Re: Change cell background based on multiple cells
- Re: Calculating how many Saturdays there are between two given dates
- Re: Calculating how many Saturdays there are between two given dates
- Re: Calculate Average on specific items
- Re: Cell reference to make a directory path
- Re: Cell reference to make a directory path
- Re: Calculate Average on specific items
- Re: [OT] posting
- Re: posting
- Re: [OT] posting
- HLOOKUP and choose one value among 2 values
- Calculating how many Saturdays there are between two given dates
- Re: [OT] posting
- Re: posting
- Re: posting
- Re: [OT] posting
- [OT] posting
- Re: Calculating Mintues
- Re: Freeze panes
- Re: for Toppers and Barb
- Re: How to connect to database?
- Re: Calculating Mintues
- Re: Freeze panes
- Re: Change to day format
- Change to day format
- Re: Array
- Re: Conditional Formatting for alternate client refs
- Re: Sum multiple arrays of data according to criteria
- Re: VLookUp
- Re: Sorting dates
- Importing Data Into Excel
- Re: Function in objects.
- Re: what is the difference between a worksheet and a workbook?
- Re: 'IF','LOOKUP' or 'HLOOKUP'?
- Re: 'IF','LOOKUP' or 'HLOOKUP'?
- Re: Average nesting within Sumproduct?
- Re: LOOKUP Formula
- Re: LOOKUP Formula
- Re: LOOKUP Formula
- Re: Function in objects.
- Unit Forcast
- Re: LOOKUP Formula
- Re: Trying to insert a row. Insert wont Activate
- Re: Decimal place + - button use in protected worksheet
- Re: Decimal place + - button use in protected worksheet
- Re: Decimal place + - button use in protected worksheet
- Re: Decimal place + - button use in protected worksheet
- Re: Sorting dates
- Decimal place + - button use in protected worksheet
- Re: Counting unique items based on date
- Re: Need a formula
- Re: How can I lookup when match has more than one value?
- Re: Final day of month
- Re: a second call for the goddezzez and godz of SUMPRODUCT
- a second call for the goddezzez and godz of SUMPRODUCT
- Re: Current Mortgage Balance
- Re: Counting unique dates based on selected criteria in a list
- Re: Current Mortgage Balance
- Re: Counting unique items based on date
- Re: Current Mortgage Balance
- Re: LOOKUP Formula
- Re: Final day of month
- Re: Current Mortgage Balance
- Re: Current Mortgage Balance
- Current Mortgage Balance
- Re: How do I write a macro that will allow users to set thier own
- Re: How do I write a macro that will allow users to set thier own
- Need a formula
- Re: find email address in a cell
- Re: how to pull out the last day data in an array?
- Re: Counting unique items based on date
- Re: Extracting Rows to Make A Totals Sheet
- how to pull out the last day data in an array?
- Re: Conditional Formatting on Null Value
- reference the latest date's data in an array
- Re: finance functions not available
- Re: xml
- Re: Formula help please
- Re: finance functions not available
- Re: How can I lookup when match has more than one value?
- Re: finance functions not available
- Re: How do I write a macro that will allow users to set thier own
- Re: Sum multiple arrays of data according to criteria
- Re: negative log
- Re: Fill Series
- Re: Fill Series
- Re: Formula help please
- Re: Sum multiple arrays of data according to criteria
- Re: change a spreadsheet from single spaced to double spaced?
- Re: Sum multiple arrays of data according to criteria
- Re: Cell References
- Re: Sum multiple arrays of data according to criteria
- RE: Sum multiple arrays of data according to criteria
- Re: Formula help please
- Re: How do I write a macro that will allow users to set thier own pass
- Re: finance functions not available
- Re: Cell References
- Re: Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A"
- Sum multiple arrays of data according to criteria
- Re: Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A"
- Re: finance functions not available
- Re: finance functions not available
- Re: finance functions not available
- Re: How to run a macro with the IF command
- Re: Change cell background based on multiple cells
- Change cell background based on multiple cells
- Re: Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A"
- Re: ID and/or filter rows with 'Fill Color'
- Re: help with match? I don't know what formula use
- Re: Formula help please
- Re: Using a cell value in its own calculation
- RE: Create a "cell button" to hide selected cells.
- Re: Using a cell value in its own calculation
- RE: worksheet amalgamation
- Re: Payouts based on hours and rounding down if hour is not in list.
- Payouts based on hours and rounding down if hour is not in list.
- Using a cell value in its own calculation
- Re: How to connect to database?
- Re: How can I do this Formula???
- Re: Sum If
- Re: How to connect to database?
- Re: Sum If
- Sum If
- Re: How do I get a calculated amount to round to the nearest nickel?
- Look up text value
- Re: time in minutes and seconds and .00
- Re: LOOKUP Formula
- Re: what exactly prevents INDIRECT from accessing closed worksheets?
- Re: LOOKUP Formula
- Re: Sumproduct - formula to return data OTHER than given criteria
- Re: Track New Values
- Re: Track New Values
- Re: Sumproduct - formula to return data OTHER than given criteria
- Re: How do I hide #N/A, ### in cells not yet worked on?
- Re: LOOKUP Formula
- Re: WEIBULL formula to get probability rate
- Re: How do I get a calculated amount to round to the nearest nickel?
- Re: How do I get a calculated amount to round to the nearest nickel?
- Re: How can I lookup when match has more than one value?
- Re: what exactly prevents INDIRECT from accessing closed worksheets?
- Re: How can I lookup when match has more than one value?
- Re: Sumproduct - formula to return data OTHER than given criteria
- Re: Referencing cells in another worksheet
- Re: Fill Series
- Track New Values
- Re: Time Question
- RE: Create a "cell button" to hide selected cells.
- Re: Is SUMPRODUCT the right function to use?
- Re: How can I do this Formula???
- Re: Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A"
- Re: Can't Stop Date Values from Changing to Formulas
- Re: Fill Series
- Re: Can't Stop Date Values from Changing to Formulas
- Re: Count function
- Re: select and extract rows of data to new excel worksheet
- Re: Referencing cells in another worksheet
- RE: SUMIF & COUNTIF based on dates
- Re: Time to time range formula???
- Re: Time to time range formula???
- Re: Run Macro for all worksheets
- From: saman110 via OfficeKB.com
- Re: Time to time range formula???
- Re: Formula is being quirky
- Re: Run Macro for all worksheets
- Re: COPY FROM COLUMN TO ROW
- Run Macro for all worksheets
- From: saman110 via OfficeKB.com
- Re: Time to time range formula???
- Re: cell height
- Re: Canadian Postal Code format?
- Re: Formula is being quirky
- Re: Time to time range formula???
- Re: Formula is being quirky
- Re: Make #N/A blank if no value is returned
- Re: Referencing cells in another worksheet
- RE: SUMIF & COUNTIF based on dates
- RE: IF STATEMENT HELP CHOOSE AND GET COST
- Re: Formula is being quirky
- RE: SUMIF & COUNTIF based on dates
- RE: SUMIF & COUNTIF based on dates
- Formula is being quirky
- Re: WEIBULL formula to get probability rate
- Re: Looking up multiple results with VLOOKUP
- RE: IF STATEMENT HELP CHOOSE AND GET COST
- RE: IF STATEMENT HELP CHOOSE AND GET COST
- RE: SUMIF & COUNTIF based on dates
- RE: SUMIF & COUNTIF based on dates
- Re: Referencing cells in another worksheet
- RE: SUMIF & COUNTIF based on dates
- Re: Looking up multiple results with VLOOKUP
- Re: Looking up multiple results with VLOOKUP
- Re: Looking up multiple results with VLOOKUP
- RE: IF STATEMENT HELP CHOOSE AND GET COST
- Re: Time Question
- RE: IF STATEMENT HELP CHOOSE AND GET COST
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Vlookup reference the row below
- Re: What do you call values used with a functions?
- Re: What do you call values used with a functions?
- Re: What do you call values used with a functions?
- Re: Vlookup reference the row below
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Time Question
- Time Question
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Count function
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Count function
- Re: INDIRECT Link of Variables for VLOOKUPs
- Count function
- Re: INDIRECT Link of Variables for VLOOKUPs
- Re: INDIRECT Link of Variables for VLOOKUPs
- Re: VLookUp
- VLookUp
- Re: regional settings
- Re: regional settings
- Re: WEIBULL formula to get probability rate
- Re: Conditional function
- Re: Conditional function
- Re: Conditional function
- Re: WEIBULL formula to get probability rate
- Re: Assigning point values?
- RE: Match a currency with its corresponding value
- Re: Match a currency with its corresponding value
- Re: too many levels of nesting
- Re: vba
- Re: Excel - Fill empty cells
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Canadian Postal Code format?
- Re: Help understanding what a formula does and why it's 'faulting'
- From: neil40@xxxxxxxxxxxxxx
- Re: Insert newline in cell through formula (excel 2003)
- From: Rick Rothstein \(MVP - VB\)
- Re: too many levels of nesting
- Re: Canadian Postal Code format?
- Re: Canadian Postal Code format?
- Re: Canadian Postal Code format?
- Re: Canadian Postal Code format?
- Re: Totally wierd
- Re: Canadian Postal Code format?
- Importing Data Into Excel From LONG Web Page With URL Ending With .cfm
- Re: WEIBULL formula to get probability rate
- Re: product formula not totaling
- Re: product formula not totaling
- RE: WEIBULL formula to get probability rate
- Re: too many levels of nesting
- Re: too many levels of nesting
- vba
- vba
- RE: renaming worksheets/objects in VBA
- Re: how to apply bold within string text
- Re: Inserting/deleting rows between worksheets
- Re: Excel 2007 table option
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Excel - Fill empty cells
- Re: Inserting/deleting rows between worksheets
- Re: Inserting/deleting rows between worksheets
- Re: Excel - Fill empty cells
- RE: Counting unique items based on date
- Re: Test if a number falls between 2 values
- Re: Test if a number falls between 2 values
- From: Rick Rothstein \(MVP - VB\)
- Re: inverse error function
- Re: Test if a number falls between 2 values
- Re: Populating sequentialcombo's or fields
- Re: Another Conditional Formatting Formula needed?
- Re: I have no colours in Excel
- Populating sequentialcombo's or fields
- Re: I have no colours in Excel
- From: garfield-n-odie [MVP]
- Re: Test if a number falls between 2 values
- From: Rick Rothstein \(MVP - VB\)
- RE: how to apply bold within string text
- Re: Sumproduct again?
- Re: how to apply bold within string text
- Re: how to apply bold within string text
- From: Rick Rothstein \(MVP - VB\)
- Re: Test if a number falls between 2 values
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Calculation Question
- Re: Test if a number falls between 2 values
- WEIBULL formula to get probability rate
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Another Conditional Formatting Formula needed?
- Re: How do I use sumif and mid function in same formula
- RE: Counting unique items based on date
- how to apply bold within string text
- Re: Can I make one or more spreadsheets unopenable?
- Re: Can I make one or more spreadsheets unopenable?
- Re: Regular Expressions & Middle Name
- Re: inverse error function
- Re: INDIRECT Link of Variables for VLOOKUPs
- Re: Regular Expressions & Middle Name
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Regular Expressions & Middle Name
- Re: Is it possible to Macro a Pivot Table?
- Re: Can I make one or more spreadsheets unopenable?
- Re: #DIV/0!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Checking cells for 2 conditions
- Re: Test if a number falls between 2 values
- Re: Test if a number falls between 2 values
- Re: under standing if statments
- Re: Delete certain records in Excel and then Change a # in another
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Help understanding what a formula does and why it's 'faulting'
- From: neil40@xxxxxxxxxxxxxx
- Re: under standing if statments
- Re: Test if a number falls between 2 values - Random Number Generator "between"
- Re: Test if a number falls between 2 values
- Re: Test if a number falls between 2 values
- RE: Counting unique items based on date
- Re: How do I arrange columns alphabetically by column label?
- internet connection via excel macro at timed intervels & save data to excel file.
- RE: Counting unique items based on date
- Re: Dates formula
- RE: Need to work out a timesheet with times going into next day (>
- RE: Need to work out a timesheet with times going into next day (>
- Re: Need to work out a timesheet with times going into next day (>
- Re: Dates formula
- From: Rick Rothstein \(MVP - VB\)
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Validation
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Need to work out a timesheet with times going into next day (>24 h
- Re: Formula for Matching Names and Conditional Formatting!
- Re: Test if a number falls between 2 values
- Re: Dates formula
- Re: Test if a number falls between 2 values
- Test if a number falls between 2 values
- Re: Dates formula - Correction to previous post.
- Re: Dates formula
- Dates formula
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Linking Data for Proposal
- Re: Regular Expressions & Middle Name
- Re: Regular Expressions & Middle Name
- Re: Counting unique items based on date
- Re: macro to delete the last value in each column - 90% correction
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: In over my head with calendar 8.0
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Counting unique items based on date
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: Help understanding what a formula does and why it's 'faulting'
- Re: inverse error function
- Re: inverse error function
- Re: Checking cells for 2 conditions
- Re: inverse error function
- Re: Workbook_BeforeClose Question
- Re: Workbook_BeforeClose Question
- Re: Checking cells for 2 conditions
- Checking cells for 2 conditions
- Re: Pls help me to solve this problem...
- Re: inverse error function
- Re: macro to delete the last value in each column - 90% correction
- Re: macro to delete the last value in each column
- Re: Less Than MATCH()
- Re: My Final #DIV/0! that I'd like to say Goodbye to!
- Re: Counting unique items based on date
- Re: macro to delete the last value in each column
- Re: Multiple Users in One Sheet
- Re: Do you want to save
- Re: Summing By Week
- Re: i need help creating a function that will extract words from a string of text
- Re: i need help creating a function that will extract words from a string of text
- Help understanding what a formula does and why it's 'faulting'
- From: neil40@xxxxxxxxxxxxxx
- Re: Pls help me to solve this problem...
- Re: #DIV/0! Error-Another Twist, assistance please?
- Re: Less Than MATCH()
- Re: #DIV/0! Error-Another Twist, assistance please?
- Re: Copying formulas from one workbook to another
- Re: #DIV/0! Error-Another Twist, assistance please?
- Re: Can I make one or more spreadsheets unopenable?
- Re: Linking Data for Proposal
- Re: plus 1
- Re: Validation List AutoFill
- Re: Multiple Users in One Sheet
- Re: macro to delete the last value in each column
- Re: #DIV/0! Error-Another Twist, assistance please?
- Re: Multiple Users in One Sheet
- Re: #DIV/0! Error-Another Twist, assistance please?
- Re: i need help creating a function that will extract words from a string of text
- Re: macro to delete the last value in each column
- Re: Counting unique items based on date
- Re: How to use index match for multi lookups?
- Re: macro to delete the last value in each column
- Re: macro to delete the last value in each column
- Re: Less Than MATCH()
- Re: Pls help me to solve this problem...
- Re: combining multiple sheets into one
- Re: Pls help me to solve this problem...
- Re: This is probably an Array Formula?
- Re: macro to delete the last value in each column
- Re: This is probably an Array Formula?
- Re: INDIRECT Link of Variables for VLOOKUPs
- Re: Simple If, If part 2 (clarification)
- Re: combining multiple sheets into one
- Re: macro to delete the last value in each column
- Re: Pls help me to solve this problem...
- Re: Counting unique items based on date
- Re: ActiveCell or ActiveSheet
- From: Launchnet via OfficeKB.com
- Re: how do I display the current worksheet name in a cell?
- Re: This is probably an Array Formula?
- Re: Pls help me to solve this problem...
- Less Than MATCH()
- Re: Auto Open Macro
- From: Launchnet via OfficeKB.com
- Re: Regular Expressions & Middle Name
- Re: lookup formulas
- RE: Counting unique items based on date
- Re: Right-to-Left direction
- Re: Pls help me to solve this problem...
- Sumproduct again?
- RE: Counting unique items based on date
- Re: how do I display the current worksheet name in a cell?
- Re: Regular Expressions & Middle Name
- Re: Text Import Wizard, Step 3 (converting .tsv file to Excel)
- Processing Time
- Re: Do you want to save
- Re: Excel Conditional Summing
- Re: INDIRECT Link of Variables for VLOOKUPs
- Regular Expressions & Middle Name
- Re: INDEX - MATCH with three variables
- Re: Simple if, if ?
- Re: How can you round numbers to the nearest quarter (i.e. .63=>.75)
- Re: INDEX - MATCH with three variables
- Re: INDEX - MATCH with three variables
- Re: Pivot Table Problems
- Re: Formula Too Long error
- Re: How can you round numbers to the nearest quarter (i.e. .63=>.75)
- Re: Simple if, if ?
- Re: This is probably an Array Formula?
- Do you want to save
- Re: Summing By Week
- Re: Multi-sheet sumif help
- Re: Multi-sheet sumif help
- Re: How can you round numbers to the nearest quarter (i.e. .63=>.75)
- Re: How to break out data combined in a single cell
- copying formulas to multiple sheets
- Re: Multi-sheet sumif help
- Re: Formula Too Long error
- Re: Multi-sheet sumif help
- Re: Excel Conditional Summing
- RE: Counting unique items based on date
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- Re: Counting unique items based on date
- Multi-sheet sumif help
- Re: look up / match / reference cell
- Re: Pls help me to solve this problem...
- Re: Formula Too Long error
- RE: Return the data from 3 columns
- Re: how to compare 2 cells in range
- Re: how to compare 2 cells in range
- Re: Pls help me to solve this problem...
- RE: lookup formulas dependent upon lookup formulas
- how to compare 2 cells in range
- Re: return partial string
- Re: plus 1
- Re: Formulas not updating
- Re: Match a currency with its corresponding value
- Re: Pls help me to solve this problem...
- Re: Pivot Table Problems
- Two CSV file data to new excel file
- Top 5 in a List - Alterntive to Pivot Table
- Re: PMT: Daily interest compounding; monthly payment
- Array Formulas
- Re: Auto Open Macro
- Re: Auto Open Macro
- Re: Type Mismatch Error - Help Please
- Re: Auto Open Macro
- From: Launchnet via OfficeKB.com
- Re: formula in excel that will highlight a cell that is left blank?
- Re: formula in excel that will highlight a cell that is left blank?
- Re: Auto Open Macro
- Re: Auto Open Macro
- From: Launchnet via OfficeKB.com
- Re: Auto Open Macro
- RE: how can I compensate this...please contribute...
- Auto Open Macro
- Re: Converting Letter to Numeric Value
- Re: Can IF do this?
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: Linking Data for Proposal
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: Retrieve data for previous 3, 6, 12 month given current month
- Re: Converting Letter to Numeric Value
- Re: Converting Letter to Numeric Value
- Re: dot count
- Re: Converting Letter to Numeric Value
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- Re: dot count
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,
- RE: how can I compensate this...pleass contribute...
- Re: separate a text cell to many number cells
- Re: Retrieve data for previous 3, 6, 12 month given current month
- Re: using offset function
- Re: How to break out data combined in a single cell
- Re: plus 1
- separate a text cell to many number cells
- Re: using offset function
- Re: Remove Characters Until a Specific Character is Reached
- RE: conditional formatting with vba
- Re: Problem getting values
- RE: conditional formatting with vba
- Re: validation
- Re: Can IF do this?
- Re: Remove Characters Until a Specific Character is Reached
- ActiveCell or ActiveSheet
- Re: Need to Count Occurences in Multiple Ranges
- Re: Challenging formatting formula
- Re: How do I flag up duplicate data entry in an excel spreadsheet?
- Re: relation between 'items' en 'prices'
- Re: Need to Count Occurences in Multiple Ranges
- Re: Excel Conditional Summing
- how can I compensate this...pleass contribute...
- Re: Excel Conditional Summing
- Re: SUMIF Function
- Re: dot count
- RE: conditional formatting with vba
- Re: Randomly sort a set group of integers
- Re: Randomly sort a set group of integers
- Re: How do I use VLOOKUP to find part of string?
- Re: Excel Conditional Summing
- Re: IF Clause
- Re: Shorten the Excel Sheet
- Re: change "true" and "false" to "availble" and "out of stock"
- Re: How do I delete everything after a / in a column?
- Re: validation
- Re: Error.Type or IsError to trap #VALUE! and #NUM!
- Re: Finding max and min in column
- Re: How do I use VLOOKUP to find part of string?
- Re: dot count
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- RE: Type Mismatch Error - Help Please
- From: Launchnet via OfficeKB.com
- Re: IF Clause
- Re: IF Clause
- Re: Excel Conditional Summing
- Re: How do I delete everything after a / in a column?
- Re: Matching 2 columns
- Error Trying to add Calculated Items to a pivot table
- Re: Average Selected Cells From a Range
- Re: How to set One value from Multiple Lookup Value
- Re: AND, IF, and SUM IF Functions
- Re: Excel Problem
- Re: How do a set a parameter in cell - choose A or B options?
- Re: How do a set a parameter in cell - choose A or B options?
- Re: How do I delete everything after a / in a column?
- Re: AND, IF, and SUM IF Functions
- RE: Type Mismatch Error - Help Please
- From: Launchnet via OfficeKB.com
- Re: IF Clause
- Re: Average Selected Cells From a Range
- Re: Matching 2 columns
- Re: IF Clause
- Re: return partial string
- Re: Excel must display error message if two blocks don't have same
- return partial string
- Re: plus 1
- Re: How to break out data combined in a single cell
- Re: IF Clause
- Re: interest only loan amortization schedule
- Re: IF Clause
- Re: Pivot Table Problems
- Re: IF, between two numbers
- Re: How to set One value from Multiple Lookup Value
- RE: Type Mismatch Error - Help Please
- Type Mismatch Error - Help Please
- Re: Counting Staffs Reports
- IF, between two numbers
- Counting Staffs Reports
- Pivot Table Problems
- Re: Import data from 1 cell on 1 worksheet to othr cell(s) in another
- Re: count pieces of records meet conditions in different columns
- Re: Can the conditional format box be locked to the cell
- Re: How do I add more than 30 arguments in a formula
- Re: Excel Conditional Summing
- Re: Financial functions in excel
- Financial functions in excel
- Re: How do I delete everything after a / in a column?
- Re: can no longer insert new columns & unhide hidden columns
- Re: How do I delete everything after a / in a column?
- Re: Getting more than one lookup results in array
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- Re: Challenging formatting formula
- Re: How do I delete everything after a / in a column?
- Re: How to count(if) column B IF column A says "x"
- Re: How do I delete everything after a / in a column?
- Re: How do I delete everything after a / in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I delete everything after a / in a column?
- Re: How do I delete everything after a / in a column?
- Re: counting x instances of a string across columns...
- Re: Challenging formatting formula
- Re: How to count(if) column B IF column A says "x"
- Re: Shorten the Excel Sheet
- Re: Comparing Text
- Re: How can i make numbers have text format without insering ' at each
- Re: How to count(if) column B IF column A says "x"
- Re: How do I make cells subtract?
- Re: How do I delete everything after a / in a column?
- Re: Date
- Re: How do I delete everything after a / in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: how to make value whole (remove decimal point)
- Re: How do I delete everything after a / in a column?
- Re: Comparing Text
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I delete everything after a / in a column?
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel Conditional Summing
- Re: How to count(if) column B IF column A says "x"
- Re: counting x instances of a string across columns...
- RE: Challenging formatting formula
- Re: Shorten the Excel Sheet
- RE: Challenging formatting formula
- Re: How to count(if) column B IF column A says "x"
- RE: Challenging formatting formula
- RE: Challenging formatting formula
- Re: counting x instances of a string across columns...
- Re: Calculating to add years - including leap year
- Re: counting x instances of a string across columns...
- Re: counting x instances of a string across columns...
- Re: Comparing Text
- From: Rick Rothstein \(MVP - VB\)
- Re: How to count(if) column B IF column A says "x"
- Re: populating a master worksheet with variables in other workshee
- Re: help on averaging function
- Re: Excel Function IF AND
- Re: help on averaging function
- Re: How to count(if) column B IF column A says "x"
- Re: How to count(if) column B IF column A says "x"
- Re: Lookup help (I think)
- Re: Getting more than one lookup results in array
- Re: counting x instances of a string across columns...
- Re: counting x instances of a string across columns...
- Lookup help (I think)
- Re: How to count(if) column B IF column A says "x"
- Re: counting x instances of a string across columns...
- Re: How to count(if) column B IF column A says "x"
- Re: Shorten the Excel Sheet
- Re: How to assign a formula to a letter?
- Re: Excel Function IF AND Wrong sequence in tests
- Re: Excel Function IF AND
- Re: How to count(if) column B IF column A says "x"
- Re: Excel Function IF AND Wrong sequence in tests
- Re: How to count(if) column B IF column A says "x"
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: How to assign a formula to a letter?
- Re: Excel Function IF AND Wrong sequence in tests
- Re: Excel Function IF AND
- Re: Excel Function IF AND
- Re: Calculating to add years - including leap year
- Re: Excel Function IF AND
- Re: Excel Function IF AND
- Re: Excel Function IF AND
- Re: sumproduct a whole column
- Re: Shorten the Excel Sheet
- Re: How to count(if) column B IF column A says "x"
- Re: how do I cross out something in a cell to keep it visible
- Re: How do I add more than 30 arguments in a formula
- Re: I, too, am having problems with SUMPRODUCT
- Re: Excel Function IF AND
- counting x instances of a string across columns...
- Re: Excel Formulas
- Re: How to count(if) column B IF column A says "x"
- Re: Excel Function IF AND
- Re: Make #N/A blank if no value is returned
- Re: again
- Re: Loan Amortization Schedule
- Re: Make #N/A blank if no value is returned
- Re: again
- Re: How do I make cells subtract?
- Re: How do I add more than 30 arguments in a formula
- Re: How do I add more than 30 arguments in a formula
- Re: Get highest value and adjacent cell value
- Re: Excel Function IF AND
- Re: Excel Function IF AND
- Re: Do not paste in hidden cells
- Re: sumproduct a whole column
- Re: sumproduct a whole column
- Re: sumproduct a whole column
- Re: Pivot Tables
- Re: Excel must display error message if two blocks don't have same num
- Re: sumproduct a whole column
- Re: Delete a Column when in a Macro-Worksheet Event?
- Re: sumproduct a whole column
- Pivot Tables
- Re: How do I replace text within a formula with a diff cell value?
- Re: VLOOKUP and OFFSET
- Re: again
- Re: Advanced filter dates and nulls
- Re: Make #N/A blank if no value is returned
- Re: sumproduct a whole column
- Re: cell contents
- Re: Create search in excel
- Re: How do i create a tick box in excel? 2003 version
- Re: Flipping a Spreadsheet
- Re: Make #N/A blank if no value is returned
- Re: Subtotaling minus negative numbers and posative numbers
- Re: again
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Getting more than one lookup results in array
- Subtotaling minus negative numbers and posative numbers
- Re: Make #N/A blank if no value is returned
- Re: how can I add degrees? ie 300degrees + 100 degrees = 40 degrees
- Re: How can i make numbers have text format without insering ' at each
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- Re: Make #N/A blank if no value is returned
- Re: Transpose cell contents from multiple worksheets into rows
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: =OR(IF(AND(....),HYPERLINK....
- Re: vlookup lookup_value
- Re: help on averaging function - Yet another example of much ado about nothing.
- Re: populating a master worksheet with variables in other worksheets
- Re: FORMULA TO FIGURE AGE
- Re: help on averaging function
- Re: help on averaging function
- Re: how to count without included duplicate records
- Re: FORMULA TO FIGURE AGE
- Re: FORMULA TO FIGURE AGE
- Re: FORMULA TO FIGURE AGE
- Re: IF functions
- From: Australian Arrow Propriety Limited
- Re: FORMULA TO FIGURE AGE
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function - Yet another example of much ado about nothing.
- Re: help on averaging function
- Re: populating a master worksheet with variables in other worksheets
- Re: again
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Formatting and Possible Transpose
- Re: again
- Re: look up / match / reference cell
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: help on averaging function
- Re: again
- Re: help on averaging function
- Re: linked formatting
- Re: Importing Data
- Re: help on averaging function
- Re: help on averaging function
- Re: formula for Canadian postal codes
- Re: help on averaging function
- Re: Transpose cell contents from multiple worksheets into rows
- Re: Copy range and past on another sheet
- Re: help on averaging function
- Re: help on averaging function
- Re: Repeat title to top of each worksheet
- Re: help on averaging function
- Re: dates and 1st Tuesday of month
- Re: help on averaging function
- Re: help on averaging function
- Re: Getting more than one lookup results in array
- RE: Need help please-SUMPRODUCT and Dynamic Range
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: dates and 1st Tuesday of month
- From: Rick Rothstein \(MVP - VB\)
- Re: help on averaging function
- Re: i need help creating a function that will extract words from a string of text
- i need help creating a function that will extract words from a string of text
- RE: Sumif or sumproduct
- Re: Find a Cell Value In a Range
- From: Rick Rothstein \(MVP - VB\)
- Re: dates and 1st Tuesday of month
- Re: dates and 1st Tuesday of month
- Re: dates and 1st Tuesday of month
- Re: Find a Cell Value In a Range
- From: Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar - So much ado about nothing
- Re: Date issue to automate calendar - elegance
- From: Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar - elegance
- Re: vlookup lookup_value
- Re: linked formatting
- RE: Need help please-SUMPRODUCT and Dynamic Range
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: Need help please-SUMPRODUCT and Dynamic Range
- Re: dates and 1st Tuesday of month
- From: Rick Rothstein \(MVP - VB\)
- RE: Need help please-SUMPRODUCT and Dynamic Range
- Re: Transpose cell contents from multiple worksheets into rows
- Re: formula for Canadian postal codes
- Re: formulas populating dates - 1st Tuesday
- Re: dates and 1st Tuesday of month
- From: Rick Rothstein \(MVP - VB\)
- Re: formulas populating dates - 1st Tuesday
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar - elegance
- From: Rick Rothstein \(MVP - VB\)
- Re: dates and 1st Tuesday of month
- Re: dates and 1st Tuesday of month
- Re: compare dates using a variable
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar - elegance
- From: Rick Rothstein \(MVP - VB\)
- Re: Finding the list of the question I have asked
- Re: Transpose cell contents from multiple worksheets into rows
- Re: IF LEN formula
- Re: Displaying a time value, conditionally.
- Re: Displaying the current system time - 2nd Try
- Re: Displaying the current system time - 2nd Try
- Re: Date issue to automate calendar - elegance
- Re: IF LEN formula
- Re: Date issue to automate calendar - elegance
- From: Rick Rothstein \(MVP - VB\)
- Re: IF LEN formula
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar
- Re: Date issue to automate calendar - elegance
- Re: plus 1
- Re: how to count without included duplicate records
- Re: Date issue to automate calendar - elegance
- Re: Shortcut for Referencing Tab Data?
- Re: Date issue to automate calendar - elegance
- Re: Worksheet protection with grouped rows?
- Re: Date issue to automate calendar
- Re: Date issue to automate calendar - elegance
- Re: Date issue to automate calendar
- Re: How do I make a cell in Excel "blink" if conditions are met?
- Re: Make #N/A blank if no value is returned
- Re: Drop down or Combo Box Help with VBA code and formula
- Re: Advanced filter dates and nulls
- Re: Copy range and past on another sheet
- Re: I, too, am having problems with SUMPRODUCT
- Re: Weekly average in pivot
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Worksheet protection with grouped rows?
- Re: Weekly average in pivot
- Re: Month Calculation
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Change :47:57 to 0:47:57
- Re: how to count without included duplicate records
- Re: Finding the list of the question I have asked
- Re: advance level of sorting data? by Ting
- Re: How do I press TAB and get Excel to move through certain grid ref
- Re: Change :47:57 to 0:47:57
- Re: Weekly average in pivot
- Re: compare dates using a variable
- Re: compare dates using a variable
- From: Rick Rothstein \(MVP - VB\)
- Re: look up / match / reference cell
- Re: Weekly average in pivot
- RE: My Problem - Help Please
- Re: "list unique" instructions fr xldynamic site doent work
- Re: selecting a row
- Re: selecting a row
- Re: Weekly average in pivot
- Re: Finding the list of the question I have asked
- Re: look up / match / reference cell
- Re: compare dates using a variable
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- compare dates using a variable
- RE: My Problem - Help Please
- Re: Shortcut for Referencing Tab Data?
- Re: Copy range and past on another sheet
- Re: Shortcut for Referencing Tab Data?
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- Copy range and past on another sheet
- Re: Shortcut for Referencing Tab Data?
- RE: My Problem - Help Please
- Re: an exact number if a number is less than
- Re: Shortcut for Referencing Tab Data?
- Re: dynamic range and data validation
- Re: dynamic range and data validation
- Re: Shortcut for Referencing Tab Data?
- RE: How to automate datasheet stuffing?
- Re: average in excle - works in 2007 and prior - Address correction
- Re: average in excle - works in 2007 and prior.
- Re: I, too, am having problems with SUMPRODUCT
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions
- Re: Weekly average in pivot
- Re: Test for outline level of cell
- Re: Problems with the Right & Find functions
- Re: Excel 2007 - table style default
- Re: Formula with color fill?
- Re: I, too, am having problems with SUMPRODUCT
- Re: Shortcut for Referencing Tab Data?
- Re: Get highest value and adjacent cell value
- Re: How to display empty text boxes
- Re: Correction to original post.
- Re: Excel 2007 - table style default
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions Second Look.
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions
- Re: Problems with the Right & Find functions
- Re: sumif functions based on multiple data
- Re: Using a dynamic pathname in VLOOKUP
- Re: sumif functions based on multiple data
- Re: Correction to original post.
- Re: IF FORMULAS NEEDED
- RE: formula to track timeframe by automatically highlighting cells
- Re: Shortcut for Referencing Tab Data?
- RE: formula to track timeframe by automatically highlighting cells
- Re: Using a dynamic pathname in VLOOKUP
- Re: Do not paste in hidden cells
- Re: Get highest value and adjacent cell value
- Correction to original post.
- Re: average in excle
- Re: Excel 2007 - table style default
- Correction to previous post
- Re: Formula with color fill?
- Re: average in excle
- Re: SUMIF Value error
- Re: IF FORMULAS NEEDED
- Re: Problem with SUMPRODUCT....help please!
- Re: SUMIF Value error
- RE: formula to track timeframe by automatically highlighting cells
- RE: formula to track timeframe by automatically highlighting cells
- Re: A formula to look for a value in a blok (eg E1:J10) data
- RE: My Problem - Help Please
- From: Launchnet via OfficeKB.com
- Re: Using a dynamic pathname in VLOOKUP
- Re: SUMIF Value error
- RE: formula to track timeframe by automatically highlighting cells
- Re: changing text values to a different string
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Formula to return position of the next Non-blank cell in a column
- Re: SUMIF Value error
- Re: SUMIF Value error
- Re: Formula with color fill?
- Re: Formula to return position of the next Non-blank cell in a column
- Re: SUMIF Value error
- Re: average in excle
- Re: Formula to return position of the next Non-blank cell in a column
- Re: What may cause macro modules to be created by accident?
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Formula to return position of the next Non-blank cell in a col
- Re: changing text values to a different string
- Re: Formula to return position of the next Non-blank cell in a column
- Re: Formula to return position of the next Non-blank cell in a column
- average in excle
- Creating a macro to line up data in 2 worksheets.
- Creating a macro to line up data in 2 worksheets.
- Creating a macro to line up data in 2 worksheets.
- Creating a macro to line up data in 2 worksheets.
- Re: Formula to return position of the next Non-blank cell in a column
- RE: maybe it's simple with macro for this one?
- Re: Formula to return position of the next Non-blank cell in a column
- Re: SUMIF Value error
- Formula to return position of the next Non-blank cell in a column
- DATEDIF() The hidden function - You may find it useful.
- Re: Finding Non-Duplicates
- Re: Finding Non-Duplicates
- Finding Non-Duplicates
- Re: What may cause macro modules to be created by accident?
- Re: SUMIF Value error
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: changing text values to a different string
- What may cause macro modules to be created by accident?
- Re: CHAR funtcion with double letter columns
- changing text values to a different string
- Re: Synchronized combo box in excel form
- Re: CHAR funtcion with double letter columns
- Re: Formula with color fill?
- Re: Using a dynamic pathname in VLOOKUP
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: CHAR funtcion with double letter columns
- Re: CHAR funtcion with double letter columns
- Re: OFFSET
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- Synchronized combo box in excel form
- Re: Excel Newbie...How To Re-Order Data from PDF File
- Re: 'name of spreadsheet' function... please help
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Excel Database function
- Re: plus 1
- Re: Int'l R1C1 or R1K1 or L1C1...
- Re: Month Calculation
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- RE: very green at this formula stuff?
- Re: Currency format
- Re: Month Calculation
- Re: test expression for empty cell in =SUMIF()
- RE: My Problem - Help Please
- Re: Currency format
- very green at this formula stuff?
- My Problem - Help Please
- From: Launchnet via OfficeKB.com
- Re: Month Calculation
- Re: test expression for empty cell in =SUMIF()
- Re: Date
- Re: test expression for empty cell in =SUMIF()
- Re: Excel 2003 - setting the Comment font size default
- Re: Make it Simple!
- Re: test expression for empty cell in =SUMIF()
- Re: Make it Simple!
- Re: test expression for empty cell in =SUMIF()
- Re: Find last cell in column then SUM in cell directly below
- Re: Find last cell in column then SUM in cell directly below
- From: Rick Rothstein \(MVP - VB\)
- Re: Test for outline level of cell
- Re: Currency format
- Re: =SUM returns 5.54365E-11 instead of 0 (zero)
- Re: Find last cell in column then SUM in cell directly below
- =SUM returns 5.54365E-11 instead of 0 (zero)
- Re: Find last cell in column then SUM in cell directly below
- Re: Make it Simple!
- Re: Make it Simple!
- Re: Make it Simple!
- Re: Find last cell in column then SUM in cell directly below
- Re: test expression for empty cell in =SUMIF()
- Re: #N/A value is returned
- Re: #div/0 errors and blank cells
- Re: # of days in month
- Re: Condition depending on tab colour
- Re: #div/0 errors and blank cells
- From: Rick Rothstein \(MVP - VB\)
- Re: #div/0 errors and blank cells
- Re: # of days in month
- Re: Currency format
- Re: Extracting Data back and forth between Sheets
- Re: test expression for empty cell in =SUMIF()
- Re: test expression for empty cell in =SUMIF()
- From: Rick Rothstein \(MVP - VB\)
- Re: test expression for empty cell in =SUMIF()
- From: Rick Rothstein \(MVP - VB\)
- Re: Currency format
- Re: SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2
- Re: Currency format
- Re: Next number function
- Re: SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2),1,
- Re: Excel Newbie...How To Re-Order Data from PDF File
- Re: Procedure to change Column heading from R1C1 to A1?
- Re: Matching a value, which does not exceed Min or Max.
- Re: Excel Newbie...How To Re-Order Data from PDF File
- Re: Excel Database function
- Re: Excel database function
- Re: how to use MS Excel 5.0 Dialog
- RE: Matching a value, which does not exceed Min or Max.
- Re: Excel Database function
- Re: copy cell based on date
- From: Rick Rothstein \(MVP - VB\)
- Re: Creating a Work place time sheet.
- From: Rick Rothstein \(MVP - VB\)
- Re: copy cell based on date
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: Condition depending on tab colour
- Re: Countif
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: Update Formula's based on drop down list value
- Re: Update Formula's based on drop down list value
- Re: Update Formula's based on drop down list value
- Re: Condition depending on tab colour
- Next number function
- Condition depending on tab colour
- Re: Excel database function
- Update Formula's based on drop down list value
- Re: Excel database function
- Re: Countif
- Re: Countif
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: sum cells based on criteria in first set of cells
- From: Rick Rothstein \(MVP - VB\)
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: Help - VBA Password Lost
- Re: sum cells based on criteria in first set of cells
- Re: Countif
- Re: Countif
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif
- Re: SUMIF using color
- Re: Vlookup
- RE: Vlookup
- Re: Help - VBA Password Lost
- Re: Sum many unconnected cells
- Re: Help - VBA Password Lost
- Re: how do I generate lists in worksheets based on a master list works
- Re: how to sort a column of Randomly selected numbers?
- Re: offset and Sum function
- Re: Help - VBA Password Lost
- Re: Sound File
- Re: Excel database function
- Re: Help - VBA Password Lost
- Re: auto save feature in excel
- Re: Easy Question
- Re: Can I have a formula with inputs from multiple pages?
- Re: how to sort a column of Randomly selected numbers?
- Re: SUMIF using color
- Re: how do I generate lists in worksheets based on a master list w
- Re: how do I generate lists in worksheets based on a master list w
- Re: how do I generate lists in worksheets based on a master list w
- Re: how do I generate lists in worksheets based on a master list works
- Re: how do I generate lists in worksheets based on a master list w
- Re: how do I generate lists in worksheets based on a master list w
- Re: how do I generate lists in worksheets based on a master list works
- Re: how to sort a column of Randomly selected numbers?
- Re: Updating a range automatecally
- Re: How many Standard Deviations above and below the mean each number is.
- Re: Hyperlinks and Email Addresses in Excel
- Re: Updating a range automatecally
- Re: How many Standard Deviations above and below the mean each number is.
- Re: Updating a range automatecally
- RE: maybe it's simple with macro for this one?
- Re: EXCEL Worksheet
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel Newbie...How To Re-Order Data
- Re: Easy Question
- Re: Excel Newbie...How To Re-Order Data
- Re: Macro that Fills Sequential numbers
- Excel Newbie...How To Re-Order Data
- Re: Easy Question
- From: Rick Rothstein \(MVP - VB\)
- Re: Easy Question
- Re: Easy Question
- From: Rick Rothstein \(MVP - VB\)
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: How many Standard Deviations above and below the mean each number is.
- Re: EXCEL Worksheet
- Re: How many Standard Deviations above and below the mean each number is.
- How many Standard Deviations above and below the mean each number is.
- Re: Easy Question
- Re: Easy Question
- Re: Easy Question
- Re: Auto-tab
- Re: Easy Question
- Easy Question
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: Updating a range automatecally
- Re: = or
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: SUMIF using color
- Re: Sum many unconnected cells
- Re: offset and Sum function
- Re: Filter Totals in a Pivot table?
- Re: Excel 2007 - table style default
- Re: Sound File
- Re: How do you create a pushbutton lookup control
- Re: SUMIF using color
- Re: offset and Sum function
- Re: Status Bar box problem
- RE: maybe it's simple with macro for this one?
- Re: Updating a range automatecally
- Re: Hyperlinks and Email Addresses in Excel
- Re: Display scenario name
- Re: plus 1
- Re: Repeat title to top of each worksheet
- Re: Status Bar box problem
- Re: Formula with color fill?
- Re: Linking Workbooks using file names in a range
- Re: Formula with color fill?
- Re: Sound File
- Re: Updating a range automatecally
- Re: Formula with color fill?
- Re: I want to change the column width on a spread sheet?
- RE: maybe it's simple with macro for this one?
- Re: Drop down or Combo Box Help with VBA code and formula
- RE: maybe it's simple with macro for this one?
- Re: How can I determine what the compound interest rate is
- Re: Formula with color fill?
- Re: again here's my another problem
- Re: How do I link a value into a sentence in Excel?
- Re: again here's my another problem
- Re: Formula with color fill?
- Re: Sum many unconnected cells
- Re: Formula not working
- Re: simple, counting the last character in text
- Re: again here's my another problem
- Drop down or Combo Box Help with VBA code and formula
- Re: Formula with color fill?
- Re: How do I link a value into a sentence in Excel?
- Formula with color fill?
- Re: sumproduct? sumif(sumproduct)?
- Re: Using a dynamic pathname in VLOOKUP
- Re: Sum many unconnected cells
- Re: Sumproduct - sort of
- Re: SUMIF using color
- Re: SUMIF using color
- Re: selecting a row
- From: Trevor Shuttleworth
- Re: I Then logic help
- Linking Workbooks using file names in a range
- Re: Offset every # of Rows
- Re: again here's my another problem
- plus 1
- Re: My column cell values are -ve how do I make all cell value +ve,
- Re: My column cell values are -ve how do I make all cell value +ve,
- Re: Sumproduct - sort of
- MROUND formula problem, help please!
- Re: Getting a response other than true/false with an IF formula
- RE: shared advice appreciated
- Re: Sumproduct - sort of
- Re: How do I change the font to all caps for the entire worksheet?
- Re: excel: count uppercase letters in a cell
- Re: Formulas in subtotal worksheets?
- Re: Excel Solver constraints
- Re: Stripping text from numbers in a cell
- Re: SUMPRODUCT formula messed up
- Re: Formula not working
- Re: Right-to-Left direction
- Right-to-Left direction
- Re: Excel 2007 sheet and workbook protection
- Re: Excel 2007 sheet and workbook protection
- Re: offset and Sum function
- Re: offset and Sum function
- RE: DBSUM function but with function as criterion, not a range
- Re: offset and Sum function
- Re: Stripping text from numbers in a cell
- Re: Excel 2003 - setting the Comment font size default
- Re: Networkdays function
- Re: Getting a response other than true/false with an IF formula
- Re: IF functions
- Re: make one cell identical to another
- Re: creating pivot from a horizontal table
- Re: read the values from a excel row
- Re: creating pivot from a horizontal table
- Re: Get highest value and adjacent cell value
- Re: Typing problem
- Re: selecting a row
- From: Trevor Shuttleworth
- Re: Typing problem
- Re: formula for Canadian postal codes
- Re: Return the value in the last cell of the list
- Re: excel: count uppercase letters in a cell
- Re: Excel Formula
- Re: Excel 2007 sheet and workbook protection
- Re: Offset every # of Rows
- read the values from a excel row
- Re: Getting a response other than true/false with an IF formula
- Re: Return the value in the last cell of the list
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: Stripping text from numbers in a cell
- RE: shared advice appreciated
- Re: Conditional Formatting
- Re: Get highest value and adjacent cell value
- Re: Status Bar box problem
- Re: Cosmetics Capitals
- Re: Linking a single number or text to a cell
- Re: formula for Canadian postal codes
- Re: Worksheet Protection / Security from Viewing
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: Formulas in subtotal worksheets?
- Re: Get highest value and adjacent cell value
- Re: Text to Number
- Re: Text to Number
- Re: again here's my another problem
- Re: Indirect Use of XLM in Excel 2000 and Prior
- RE: shared advice appreciated
- Re: Linking a single number or text to a cell
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: Offset every # of Rows
- Re: Combining one row into two
- Re: named range with criteria.
- Re: formula for Canadian postal codes
- Re: Getting a response other than true/false with an IF formula
- Re: row lookup formula
- Re: Return the value in the last cell of the list
- Re: Using a dynamic pathname in VLOOKUP
- Re: Inserting Buttons as Hyperlinks
- Re: Excel Formula
- Re: row lookup formula
- Re: Getting a response other than true/false with an IF formula
- Re: Getting a response other than true/false with an IF formula
- Re: Getting a response other than true/false with an IF formula
- Re: formula to find all possible combinations
- Re: Getting a response other than true/false with an IF formula
- Re: SUMPRODUCT formula messed up
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: formula for Canadian postal codes
- Re: Getting a response other than true/false with an IF formula
- Re: Offset every # of Rows
- Re: Combining one row into two
- Re: Getting a response other than true/false with an IF formula
- formula for Canadian postal codes
- Re: SUMPRODUCT formula messed up
- Re: RANDBETWEEN in a conditional format gives error
- Re: SUMPRODUCT formula messed up
- Re: Macro that Finds the First Value in a range using a Combobox (drop
- Re: SUMPRODUCT formula messed up
- Re: How do i display a negative time as a res of distracting 2 times?
- Re: Turn around Time
- Re: simple, counting the last character in text
- Re: Excel: How to insert current time (static) to the nearest seco
- Help with excel array - select, add and calculate result
- Help with Excel array functions - select, add & return result
- Re: Using a single cell refernce to change multiple formulas
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: Formula not working
- Re: named range with criteria.
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Turn around Time
- From: instereo911 via OfficeKB.com
- Re: If - then help.
- From: Rick Rothstein \(MVP - VB\)
- Re: Dragging formulas
- Re: Formula not working
- Re: Conditional Format Formula Issue
- Re: Dragging formulas
- Re: named range with criteria.
- Re: named range with criteria.
- Re: How i display True/Fale in one or two colum
- Re: If - then help.
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: If - then help.
- From: Rick Rothstein \(MVP - VB\)
- Re: named range with criteria.
- Re: Inserting Buttons as Hyperlinks
- Re: simple, counting the last character in text
- Re: Excel 2007 sheet and workbook protection
- Re: Converting embedded objects in excel versus word
- Re: simple, counting the last character in text
- From: Rick Rothstein \(MVP - VB\)
- Re: excel: count uppercase letters in a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel: How to insert current time (static) to the nearest seco
- Re: named range with criteria.
- Re: Indirect Use of XLM in Excel 2000 and Prior
- Re: excel: count uppercase letters in a cell
- Re: excel: count uppercase letters in a cell
- Re: RANDBETWEEN in a conditional format gives error
- Re: Nested IF Functions with OFFSET
- Re: Annualize/ Estimate year-to-date from monthly expense
- Re: allowed/taken
- Re: RANDBETWEEN in a conditional format gives error
- Re: RANDBETWEEN in a conditional format gives error
- Re: display a number in another cell
- Re: Long formula
- Nested IF Functions with OFFSET
- Re: Conditional Format Formula Issue
- Re: Inventory Control
- Re: Macro do works in excel...
- Re: display a number in another cell
- Re: Formula not working
- Re: Countif with Dynamic date ranges.
- display a number in another cell
- Re: Formula not working
- Re: sorting excel data
- Inventory Control
- Re: Macro do works in excel...
- Re: How do I show web addresses in Excel, rather than their name
- Modified:-> Macro to Generate a new Column!!!
- Re: pivot tables for likert-scale type survey items
- Re: excel: count uppercase letters in a cell
- Re: Formula not working
- Re: pmt function
- Re: Conditional Formatting
- pmt function
- Re: Using a single cell refernce to change multiple formulas
- Indirect Use of XLM in Excel 2000 and Prior
- Re: excel: count uppercase letters in a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: excel: count uppercase letters in a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: JIS / ASC Functions in Excel 2007
- Re: Formula not working
- Re: excel: count uppercase letters in a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Annualize/ Estimate year-to-date from monthly expense
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I show web addresses in Excel, rather than their name
- Re: Is there a way?
- Re: JIS / ASC Functions in Excel 2007
- Re: Do not paste in hidden cells
- Re: Conditional Format Formula Issue
- Re: Please Help...
- Re: vlookup
- Re: Conditional Format Formula Issue
- Re: Conditional Format Formula Issue
- Re: Long formula
- Re: excel: count uppercase letters in a cell
- Re: Calculate value in a text filled cell
- Re: PROPER FUNCTION
- Re: excel: count uppercase letters in a cell
- Re: Get highest value and adjacent cell value
- Re: Do not paste in hidden cells
- Re: Is there a way?
- RE: How do I insert cells in a macro?
- Re: Extract Middle Initial from Name
- Re: NZ function equivalent in Excel
- Re: Conditional Format Formula Issue
- Re: delete macros
- Re: Do not paste in hidden cells
- Re: Macro do works in excel...
- RE: How do I insert cells in a macro?
- RE: How do I insert cells in a macro?
- RE: How do I insert cells in a macro?
- Re: Worksheet
- Re: Macro do works in excel...
- RE: How do I insert cells in a macro?
- RE: How do I insert cells in a macro?
- Macro that Finds the First Value in a range using a Combobox (drop down menu)
- Re: Formula not working
- Re: PROPER FUNCTION
- From: Rick Rothstein \(MVP - VB\)
- Re: Formula not working
- RE: How do I insert cells in a macro?
- Re: Formula not working
- RE: finding exact matches
- Re: Macro do works in excel...
- Re: PROPER FUNCTION
- Annualize/ Estimate year-to-date from monthly expense
- Re: Spss verse excel
- Re: Macro do works in excel...
- RE: Extending Logic beyond the numbers and into a Name! Is it Poss
- Re: Macro do works in excel...
- Re: Convert Function
- Re: Extract Middle Initial from Name
- From: Rick Rothstein \(MVP - VB\)
- Re: Please Help...
- From: Rick Rothstein \(MVP - VB\)
- Re: Extract Middle Initial from Name
- Re: Extract Middle Initial from Name
- RE: Extending Logic beyond the numbers and into a Name! Is it Poss
- Re: Spss verse excel
- Re: NZ function equivalent in Excel
- Re: Using a single cell refernce to change multiple formulas
- Re: Average with multiple conditions
- Re: Spss verse excel
- Re: Form drop down list
- Re: 17 random numbers between 1 to 65
- Re: Extract Middle Initial from Name
- From: Rick Rothstein \(MVP - VB\)
- Re: If, vlookup, data validation & dependent list
- Re: sorting excel data
- Re: sorting excel data
- Re: sorting excel data
- Re: sorting excel data
- Re: sumproduct spanish version
- Re: 17 random numbers between 1 to 65
- Re: 17 random numbers between 1 to 65
- Re: sorting excel data
- RE: sorting excel data
- Re: Extract Middle Initial from Name
- RE: sorting excel data
- RE: sorting excel data
- sorting excel data
- Re: Trial Has Expired and I can't open spreadsheet created in trial -
- Re: Conditional Formatting
- Conditional Formatting
- Re: Using a single cell refernce to change multiple formulas
- Re: Average with multiple conditions
- Re: Trial Has Expired and I can't open spreadsheet created in trial -
- Re: Worksheet
- Re: Trial Has Expired and I can't open spreadsheet created in trial -
- RE: How do I insert cells in a macro?
- Re: Convert Function
- Re: Formula / Counting
- Re: Formula finding last cell in row containing data
- Re: range, cell refrence, but with a new twist
- Re: calculation in pivot table with value of a column
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I maintain cell formatting when I export to a mail merge?
- Re: How do I link text from mulitple cells to another spreadsheet
- Re: How do I enter the same data no multiple cells with current data?
- Re: How do prevent your column widths from changing in Excel?
- Re: Long formula
- Re: Pivot Tables and VLOOKUP
- Re: calculation in pivot table with value of a column
- Re: Long formula
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I maintain cell formatting when I export to a mail merge?
- Re: Long formula
- Re: range, cell refrence, but with a new twist
- Re: range, cell refrence, but with a new twist
- Re: Calculate value in a text filled cell
- Re: Formula Disappears, converts to a value
- Re: Formula Suggestion Please?
- Re: Formula Suggestion Please?
- Re: Formula Suggestion Please?
- Re: Need a formula to look up 2 values and return result from 3rd
- Re: Formula that compares data in adjoining cells
- Re: Count IF/Sum IF
- Re: Calculate value in a text filled cell
- VLOOKUP insert rows
- Re: Need help with =IF formula
- Re: VLOOKUP Question...
- Re: Need help with =IF formula
- Re: Need help with =IF formula
- Re: Long formula
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: 2 Part Formula
- Re: Need help with =IF formula
- Re: 2 Part Formula
- Re: Need help with =IF formula
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: 2 Part Formula
- Re: change fill color in 2 cells when data entered in one
- Re: how do i change a formula to its value
- Need help with =IF formula
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: Conditional Formula w/Date=Where did I go wrong?
- RE: Need a formula to look up 2 values and return result from 3rd
- Re: Long formula
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: change fill color in 2 cells when data entered in one
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: When copying dates, they change by 4 yrs & 1 day, why?
- Re: When copying dates, they change by 4 yrs & 1 day, why?
- Re: Convert Function
- Re: Two Separate Conditions for Cond. formatting
- Re: Conditional Formula w/Date=Where did I go wrong?
- Re: Formula finding last cell in row containing data
- Re: change fill color in 2 cells when data entered in one
- RE: any macro
- RE: Cell Refences
- Re: Dynamically Megre/Unmerge Cells
- Re: Long formula
- From: Rick Rothstein \(MVP - VB\)
- Re: #N/A value is returned
- Re: Long formula
- Re: any formula
- Long formula
- Re: paste special / skip empty cells doesn't work!?
- Re: sumproduct spanish version
- RE: Rank
- Re: vlookup glitch
- Re: paste special / skip empty cells doesn't work!?
- Re: #N/A value is returned
- Re: randbetween(1.1,1.25)
- Re: #N/A value is returned
- RE: vlookup glitch
- randbetween(1.1,1.25)
- Re: vlookup glitch
- vlookup glitch
- Re: paste special / skip empty cells doesn't work!?
- paste special / skip empty cells doesn't work!?
- Re: I need a formula to calculate rates based on current age
- RE: Rank
- Re: I need a formula to calculate rates based on current age
- Re: Identify New Added Rows
- Re: Import data from a website to excel
- Re: Edit numerous cell entries
- Re: Dynamically Megre/Unmerge Cells
- Re: VLOOKUP Question...
- Re: Dynamically Megre/Unmerge Cells
- RE: Rank
- Re: Dynamically Megre/Unmerge Cells
- Re: Dynamically Megre/Unmerge Cells
- Re: Modified:-> Macro to Generate a new Column!!!
- RE: Rank
- RE: Rank
- RE: Moving values from one colum to another when there is spaces b
- Modified:-> Macro to Generate a new Column!!!
- Re: Macro to generate a new column denpending upon existing one!
- Re: how get many days in March repeate in column have many dates
- RE: Rank
- RE: Rank
- Re: Get list of row #s with certain value
- Re: Dependant Data Validation - for Whole Column
- RE: finding and summing data in somewhat complex matrix.
- Macro to generate a new column denpending upon existing one!
- Re: Get list of row #s with certain value
- Re: Get list of row #s with certain value
- Re: Convert Function
- Re: Using a single cell refernce to change multiple formulas
- RE: Calculating productivity: widgets per hour
- Re: Problem with getting numbers in some range values!?
- Worksheet disappear when saving on shared workbook
- Re: Microsoft Excel Sheet
- Re: Return Value of last cell in column with a value in Excel?
- Re: any formula
- Re: combining sheets from different files into one file?
- Re: Make each tab/worksheet into a separate document
- Re: How to set up variable data ranges in nested functions
- Re: Return Value of last cell in column with a value in Excel?
- RE: Calculating productivity: widgets per hour
- Re: Federal tax withholding calculations - using IF statements..?
- Problem with getting numbers in some range values!?
- Re: Vlookup value of #NA
- Re: Leading "0"
- Re: Leading "0"
- Re: Negative Numbers in a Pivot Table
- Re: any formula
- Re: Formula Disappears, converts to a value
- Re: How do I print certain (specifics) columns in Excel spread sheet?
- Re: Export Explorer Metadata to Excel
- Re: Make each tab/worksheet into a separate document
- Formula Disappears, converts to a value
- Re: Ignoring #N/A in an Autosum range
- Re: deleting the blank rows from the sheet
- Re: Protect Workbook
- Re: Subject: return a result from multiple conditions.
- Re: How do I print certain (specifics) columns in Excel spread sheet?
- Re: Pivot table aging report sort order
- Re: How do I reference an empty cell in a formula?
- Re: How do I reference an empty cell in a formula?
- Pivot table aging report sort order
- Re: Extract first second "word" from a Cell..
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I print certain (specifics) columns in Excel spread sheet?
- Re: Dynamically Megre/Unmerge Cells
- Re: Get list of row #s with certain value
- Re: Extract first second "word" from a Cell..
- From: Rick Rothstein \(MVP - VB\)
- Re: Recalculating in a circular reference
- Re: Make each tab/worksheet into a separate document
- Re: Formatting a number
- RE: Recalculating in a circular reference
- Re: Clear Contents Of Cell If Value = 0 or Error
- From: Rick Rothstein \(MVP - VB\)
- Formatting a number
- RE: finding and summing data in somewhat complex matrix.
- Re: DSUM criteria
- Re: Dynamically Megre/Unmerge Cells
- Re: Sorting the spreadsheet!
- Re: automatically update macro
- Re: Clear Contents Of Cell If Value = 0 or Error
- Re: Dynamically Megre/Unmerge Cells
- Re: Federal tax withholding calculations - using IF statements..?
- Re: Please Help...
- From: Rick Rothstein \(MVP - VB\)
- Re: Please Help...
- Re: DSUM criteria
- RE: finding and summing data in somewhat complex matrix.
- Re: Federal tax withholding calculations - using IF statements..?
- Re: DSUM criteria
- DSUM criteria
- Re: Get highest value and adjacent cell value
- RE: finding and summing data in somewhat complex matrix.
- RE: finding and summing data in somewhat complex matrix.
- Re: Ignoring #N/A in an Autosum range
- Re: Can you convert this formula to 2003 from 2007?
- Re: Federal tax withholding calculations - using IF statements..?
- Re: Slightly OT (Maybe) printing problem
- Re: Prohibit manual entry via Drop Down
- Prohibit manual entry via Drop Down
- Re: Federal tax withholding calculations - using IF statements..?
- Re: Federal tax withholding calculations - using IF statements..?
- Re: Excel Formulas
- Similar to paste special from another workbook
- Re: sumif between dates (quarters)
- Re: How can I handle negative time values?
- Re: Excel file size too large
- Re: Rounding up for a decimal
- Re: Rounding up for a decimal
- Re: Rounding up for a decimal
- Re: Get list of row #s with certain value
- Re: Excel Formulas
- Re: Referencing a different tab according to a formula result
- Re: Federal tax withholding calculations - using IF statements..?
- Re: How can I handle negative time values?
- Re: Protect Workbook
- Re: Federal tax withholding calculations - using IF statements..?
- Re: How can I handle negative time values?
- Re: Too many nested IF functions!
- Re: Formula
- Re: Summation question
- Re: Summation question
- Re: averages without zero
- Re: coefficients of trend line
- Re: Get list of row #s with certain value
- Re: sumif between dates (quarters)
- From: Rick Rothstein \(MVP - VB\)
- Re: Slightly OT (Maybe) printing problem
- Re: Federal tax withholding calculations - using IF statements..?
- Re: Slightly OT (Maybe) printing problem
- Re: Federal tax withholding calculations - using IF statements..?
- Pivot Table - How to keep data hidden
- Re: Paying fee to someone who could extract data from web-page to excel!
- Paying fee to someone who could extract data from web-page to excel!
- Re: Federal tax withholding calculations - using IF statements..?
- Re: IF 5 years old by Dec 1 they will start Kindergarten
- From: debbiep@xxxxxxxxxxxxxxxxxxx
- Re: remove hyphens from a list of part numbers
- Re: IF 5 years old by Dec 1 they will start Kindergarten
- Re: How to use goal seek
- IF 5 years old by Dec 1 they will start Kindergarten
- From: debbiep@xxxxxxxxxxxxxxxxxxx
- Re: Vlookup
- Re: sumif between dates (quarters)
- Re: Vlookup
- From: Rick Rothstein \(MVP - VB\)
- Re: Vlookup
- From: Rick Rothstein \(MVP - VB\)
- Re: sumif between dates (quarters)
- Slightly OT (Maybe) printing problem
- Re: Get list of row #s with certain value
- Re: range,cell refrence
- Re: conditional formating
- Re: Get highest value and adjacent cell value
- Re: Get list of row #s with certain value
- Re: Get list of row #s with certain value
- Re: Vlookup
- From: Rick Rothstein \(MVP - VB\)
- Re: Negative Column ????
- Re: Maximum Columns in Worksheet
- Re: Update reference in multiple formulas
- Re: Update reference in multiple formulas
- Re: Conditional Formatting for Duplicates
- From: Trevor Shuttleworth
- Re: coefficients of trend line
- Re: range,cell refrence
- Re: Maximum Columns in Worksheet
- Re: Maximum Columns in Worksheet
- Re: formulation setup() from 2003 good for 2007
- Re: Does excel have text effects?
- Re: Does excel have text effects?
- Re: Maximum Columns in Worksheet
- Re: invisible color
- Re: invisible color
- From: garfield-n-odie [MVP]
- Re: I'm still confused
- Re: invisible color
- RE: Maximum Columns in Worksheet
- Re: Maximum Columns in Worksheet
- RE: Maximum Columns in Worksheet
- Re: Insert Row "Missing" from my list
- RE: Maximum Columns in Worksheet
- Re: IF function results not displayed in cell
- Re: personal.xls
- PivotTable question about grouping numbers in it
- Re: personal.xls
- Re: Formula HELP
- From: Rick Rothstein \(MVP - VB\)
- Re: conditional formating
- From: Rick Rothstein \(MVP - VB\)
- Re: Insert Row "Missing" from my list
- Re: conditional formating
- Re: Insert Row "Missing" from my list
- Re: conditional formating
- From: Rick Rothstein \(MVP - VB\)
- RE: Maximum Columns in Worksheet
- Re: Array Formula and 2 Tabs!
- Re: How to calculate bond value and current yield
- Re: How to use goal seek
- Re: personal.xls
- Re: please help with formula for same cells in different sheets
- Re: Relative Cell References When Linking
- Re: conditional formating
- Re: conditional formating
- conditional formating
- Re: Array Formula and 2 Tabs!
- Re: please help with formula for same cells in different sheets
- Re: formulation setup() from 2003 good for 2007
- Re: Return Cell Address of MIN value - array formula
- Re: Return Cell Address of MIN value - array formula
- Re: personal.xls
- Re: personal.xls
- Re: personal.xls
- Re: personal.xls
- Re: Get highest value and adjacent cell value
- Re: personal.xls
- Re: Array Formula and 2 Tabs!
- Re: Help to rename files
- Re: personal.xls
- Re: personal.xls
- Re: personal.xls
- Re: personal.xls
- Re: Negative Column ????
- Re: Negative Column ????
- From: Rick Rothstein \(MVP - VB\)
- Re: Negative Column ????
- Re: MAX returns correct column, but row -1?
- Re: Formula to subtract a $ value based on specific date
- Re: Saving file using value in cell as the filename
- Re: Formula to subtract a $ value based on specific date
- Re: Negative Column ????
- Re: Sumproduct with OR
- Re: Get highest value and adjacent cell value
- Re: Dynamic Formulas
- Re: Return Cell Address of MIN value - array formula
- Re: conditional formula in Excel
- Re: How can I combine data from two sheets where field contents ma
- Re: Return Cell Address of MIN value - array formula
- Re: Return Cell Address of MIN value - array formula
- Re: I'm still confused
- Re: Excel Formula
- Re: Get highest value and adjacent cell value
- Negative Column ????
- Re: How can I combine data from two sheets where field contents ma
- Re: qn on counting in drop down menus and protecting/hiding specif
- Re: Sumproduct with OR
- Get highest value and adjacent cell value
- Return Cell Address of MIN value - array formula
- Re: conditional formula in Excel
- Re: conditional formula in Excel
- From: Trevor Shuttleworth
- Re: conditional formula in Excel
- Re: I'm still confused
- RE: Need to find highs and lows formula and how-to
- Re: Excel Formula
- Re: Excel Formula
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Deleting a consistant portion of all cells in a given column
- Excel Formula
- Re: Deleting a consistant portion of all cells in a given column
- From: Rick Rothstein \(MVP - VB\)
- Re: How can I combine data from two sheets where field contents match?
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Deleting a consistant portion of all cells in a given column
- From: Rick Rothstein \(MVP - VB\)
- Re: How can i randomly select 780 rows from 4000 rows of data
- Re: seperate field
- From: Trevor Shuttleworth
- RE: Need to find highs and lows formula and how-to
- Re: A Formula for tracking Data on It's own tab in my spreadsheet?
- Re: referencing a different tab by referencing a list in the curre
- Re: Assigning numerical value
- Re: Formula Cannot Be Converted - Function Not Available
- RE: Need to find highs and lows formula and how-to
- Re: referencing a different tab by referencing a list in the current s
- Re: Adding blank rows between groups of similar names
- Re: Adding blank rows between groups of similar names
- Re: is there a formula to count something like this....
- Formula Cannot Be Converted - Function Not Available
- Re: Is there a formula to capture data between "Tabs" on a spreads
- RE: Need to find highs and lows formula and how-to
- Re: is there a formula to count something like this....
- Re: copy graph from a Worksheet based on a field in another Worksh
- Re: Assigning numerical value
- Re: Dynamic Formulas
- Re: copy graph from a Worksheet based on a field in another Worksheet
- Re: Assigning numerical value
- Re: MAX returns correct column, but row -1?
- Re: averages without zero
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Adding percentages
- Re: Reference Previous Worksheet Built-in Function
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: 'COUNTIF' and 'AND"
- Re: Dynamic Formulas
- Reference Previous Worksheet Built-in Function
- Re: Help to rename files
- Re: Excel work Book Order
- Re: please help with formula for same cells in different sheets
- Re: qn on counting in drop down menus and protecting/hiding specif
- Re: Help to rename files
- Re: Help to rename files
- Re: Automatic value is malfunctioning
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Excel function
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Re: Help to rename files
- Re: Is there a formula to capture data between "Tabs" on a spreads
- Help to rename files
- Re: please help with formula for same cells in different sheets
- Re: Add one more criteria
- Re: If & Array
- Re: seperate field
- From: Trevor Shuttleworth
- Re: spreadsheets
- Re: find matching text
- Re: Reference a Worksheet Tab in Formula
- RE: Is there a formula to capture data between "Tabs" on a spreads
- Re: Change time format from :0 to 0:0
- Re: cannot remove read-only from a file
- Re: count if on Visible - Filtered
- Re: Does a number exist in a range
- Re: MAX returns correct column, but row -1?
- RE: Maybe a macro or whatever can do this easily...
- Re: Match and Lookup
- Re: vlookup formulas
- Re: Create a credit (negative) column in Excel?
- vlookup formulas
- Re: CONCATENATES
- MAX returns correct column, but row -1?
- RE: Calculating productivity: widgets per hour
- Re: Quiero usar la funcion buscarh buscando un valor distinto de 0
- Re: Page Break Column Headers
- Re: Create a credit (negative) column in Excel?
- Re: Quiero usar la funcion buscarh buscando un valor distinto de 0
- Re: averages without zero
- Re: CONCATENATES
- Re: EXCEL CLOSES
- Re: I need to sum the last column - is there a formula for this
- Re: File Size Function
- From: Rick Rothstein \(MVP - VB\)
- Re: Help avoiding a circular reference
- Re: Change time format from :0 to 0:0
- Re: Sumproduct with OR
- Re: Quick solver question
- Re: Create a credit (negative) column in Excel?
- Organizing data to sort in a spreadsheet.
- Re: Saving file using value in cell as the filename
- RE: Maybe a macro or whatever can do this easily...
- Re: Average with #div
- Re: Need a way to determine the # of Saturdays in a month
- Re: Consolidating with empty-string ("") cells removed
- Re: Consolidating with empty-string ("") cells removed
- Re: I need to sum the last column - is there a formula for this
- Re: Combining Worksheets
- Re: How can excel 2000 users open a 2007 .xlsm workbook
- Re: Largest value in Col B for each unique value in col A
- Re: I need to sum the last column - is there a formula for this
- Re: Keep Same Cell Reference
- Re: Reference a Worksheet Tab in Formula
- Re: conditional formula
- Re: Does a number exist in a range
- From: Rick Rothstein \(MVP - VB\)
- Re: Largest value in Col B for each unique value in col A
- Re: how to identify unique list of 200 random entries from a list of 3
- Re: create new paper size
- Largest value in Col B for each unique value in col A
- Re: Clear Contents Of Cells Where Value = 0
- Re: How to extract right-most word?
- Re: conditional formula
- Re: Reformat spreadsheet
- Re: conditional formula
- Re: Is there a way to require a cell to be completed in Excel?
- Re: How can I calculate a due interest of annuities for a certain peri
- Re: Reference a Worksheet Tab in Formula
- Re: Is it a formula or input data?
- Re: How to insert a space between display results
- Re: Reference a Worksheet Tab in Formula
- Re: How to extract right-most word?
- Re: How to extract right-most word?
- Re: function add ins for english language
- Re: Assign values to find Current Month in a Range
- Re: function add ins for english language
- Re: Insert Row "Missing" from my list
- Re: Need a way to determine the # of Saturdays in a month
- Re: A Formula for tracking Data on It's own tab in my spreadsheet?
- Re: How to extract right-most word?
- Assign values to find Current Month in a Range
- From: sharann via OfficeKB.com
- Re: Insert Row "Missing" from my list
- Re: Insert Row "Missing" from my list
- Re: Find lowest 3 values and sum
- Re: How to convert a static formula to dynamic formula ?
- Re: How to convert a static formula to dynamic formula ?
- Re: Find lowest 3 values and sum
- Re: Maybe a macro or whatever can do this easily...
- Re: Find lowest 3 values and sum
- Re: A Formula for tracking Data on It's own tab in my spreadsheet?
- Re: How to extract right-most word?
- RE: Maybe a macro or whatever can do this easily...
- Re: How to extract right-most word?
- Re: How to extract right-most word?
- Re: Hide / UnHide - is there a Function to automate this ?
- Re: conditional formula
- Maybe a macro or whatever can do this easily...
- Re: Gray Out Expired Records
- Re: Too many nested IF functions!
- Re: User time input
- Re: User time input
- Re: Vlookup Returning #n/a
- Re: Consolidating with empty-string ("") cells removed
- Re: Vlookup Returning #n/a
- Re: Vlookup Returning #n/a
- Re: How to extract right-most word?
- From: nomail1983@xxxxxxxxxxx
- Re: conditional formula
- Re: Sumif banding on a condition
- Re: Consolidating with empty-string ("") cells removed
- Re: Multiplying non consecutive rows, then adding it.
- From: Rick Rothstein \(MVP - VB\)
- Re: Sumif banding on a condition
- Re: Sumif banding on a condition
- Re: User time input
- From: Rick Rothstein \(MVP - VB\)
- Re: User time input
- Re: Sumif banding on a condition
- Re: How to extract right-most word?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to extract right-most word?
- Sumif banding on a condition
- Re: Multiplying non consecutive rows, then adding it.
- Re: Multiplying non consecutive rows, then adding it.
- Re: Multiplying non consecutive rows, then adding it.
- Re: conditional formula
- Re: Multiplying non consecutive rows, then adding it.
- RE: How to extract right-most word?
- Re: Finding highest values
- Re: How to extract right-most word?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to extract right-most word?
- Re: How to extract right-most word?
- From: Rick Rothstein \(MVP - VB\)
- Re: How to extract right-most word?
- From: nomail1983@xxxxxxxxxxx
- Re: How to extract right-most word?
- Re: Return Text or Blank
- How to extract right-most word?
- From: nomail1983@xxxxxxxxxxx
- Re: Too many nested IF functions!
- From: Rick Rothstein \(MVP - VB\)
- Transferring cell contents from selected rows only.
- Re: Scoring three groups, each with 6 levels
- Re: How to fill a blank cell down to a filled cell
- Re: Inserting a range of cells
- Re: Too many nested IF functions!
- Re: Sorting
- Re: Too many nested IF functions!
- Re: Find/Replace External Data Web Query
- Re: Too many nested IF functions!
- Re: Scoring three groups, each with 6 levels
- Re: time
- Re: automatic copy of results to another page
- Re: Linking a selection in a drop down list to a calc in another cell
- Re: Linking a selection in a drop down list to a calc in another c
- Re: Linking a selection in a drop down list to a calc in another c
- Re: Linking a selection in a drop down list to a calc in another cell
- Re: User time input
- Re: Linking a selection in a drop down list to a calc in another cell
- Re: Workbooks.Open Filename
- Re: Linking a selection in a drop down list to a calc in another cell
- Sorting
- Re: Return Text or Blank
- Re: read data from a cell absolutely
- Re: SUMIF ?! .... not quite enough....
- Re: User time input
- From: Rick Rothstein \(MVP - VB\)
- Re: time
- Re: Find/Replace External Data Web Query
- Re: Hide / UnHide - is there a Function to automate this ?
- time
- Re: Hide / UnHide - is there a Function to automate this ?
- Re: Return Text or Blank
- Re: User time input
- Re: Hide / UnHide - is there a Function to automate this ?
- Re: Converting hours over 24 into decimal format
- SUMIF ?! .... not quite enough....
- Re: User time input
- From: Rick Rothstein \(MVP - VB\)
- Re: User time input
- Re: read data from a cell absolutely
- Re: Hide / UnHide - is there a Function to automate this ?
- Re: Hide / UnHide - is there a Function to automate this ?
- Re: Hide / UnHide - is there a Function to automate this ?
- Hide / UnHide - is there a Function to automate this ?
- Re: Finding tops and bottoms using stock data
- Re: Gray Out Expired Records
- Re: Gray Out Expired Records
- Re: How to fill a blank cell down to a filled cell
- Re: min, dmin, etc
- Re: If & Array
- Re: Finding tops and bottoms using stock data
- Re: If & Array
- Re: How do I create a first page index of worksheets in my workbook?
- Re: How do I create a first page index of worksheets in my workbook?
- Re: How do I create a first page index of worksheets in my workbook?
- Re: qn on counting in drop down menus and protecting/hiding specif
- Re: How do I create a first page index of worksheets in my workbook?
- Re: Vlookup derived wrong value
- Re: Vlookup derived wrong value
- Re: How do I create a first page index of worksheets in my workbook?
- RE: excel 2003: how to match records of 2 tables according to 2 column
- RE: excel 2003: how to match records of 2 tables according to 2 column
- excel 2003: how to match records of 2 tables according to 2 columns?
- Re: Huge sum function formula
- Re: creating numbers to a fixed length string...
- Re: Help with editing a formula
- Re: how to create macro to use cell references for data filter cri
- Re: Help with Formula
- Re: Sumproduct to find monthly bonuses
- Re: Help with Formula
- Re: Can excel export to an organizational chart?
- Re: Help with Formula
- Re: Help with Formula
- Re: Sumproduct to find monthly bonuses
- Re: Return Text or Blank
- Re: Return Text or Blank
- RE: Autofill columns
- Re: Consolidating with empty-string ("") cells removed
- Re: Working with Time
- Re: Working with Time
- Working with Time
- Re: how to encirle a word
- Re: Huge sum function formula
- Re: Workbooks.Open Filename
- Re: Date format in a text string
- Workbooks.Open Filename
- Re: Quick solver question
- Re: Consolidating with empty-string ("") cells removed
- Re: Quick solver question
- Re: Date format in a text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Date format in a text string
- Re: Date format in a text string
- Re: Date format in a text string
- Re: Date format in a text string
- Re: Quick solver question
- Re: Date format in a text string
- Re: IF, OR, AND FUNCTION HELP
- Re: hiding huge formula's in an excel sheet
- Re: Sumproduct to find monthly bonuses
- Re: Sumproduct to find monthly bonuses
- Re: Bring Forward Balances and Formulas in a Spreadsheet
- Re: how do i change (or add) colour to the worksheet tabs (in excel)
- Re: how do i change (or add) colour to the worksheet tabs (in excel)
- Re: Counting for unique values using 2 cells
- Re: Quick solver question
- Re: Sumproduct to find monthly bonuses
- Re: Quick solver question
- Re: hiding huge formula's in an excel sheet
- read data from a cell absolutely
- Re: Date format in a text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Using IF to find text + wildcard?
- From: Rick Rothstein \(MVP - VB\)
- Re: countif multiple conditions
- Re: countif multiple conditions
- Re: How to make the First alphabets in the cell to be blank.
- From: Rick Rothstein \(MVP - VB\)
- Re: Formula to return blank
- Re: Formula to return blank
- From: Rick Rothstein \(MVP - VB\)
- Re: Formula to return blank
- Re: How to make the First alphabets in the cell to be blank.
- Re: Date format in a text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Searching two columns for information
- RE: countif multiple conditions
- Re: Using IF to find text + wildcard?
- From: Rick Rothstein \(MVP - VB\)
- Re: Date format in a text string
- Re: Using IF to find text + wildcard?
- From: Rick Rothstein \(MVP - VB\)
- Re: MegaStat Add-In
- RE: countif multiple conditions
- RE: How i can set two different rows as header and footer
- Re: Excel to form email in outlook
- Re: Date format in a text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Quick solver question
- Re: EXCEL MAXIMUM VALUE AND VLOOKUP NESTED?
- countif multiple conditions
- autopopulate multiple users personal info
- Re: Quick solver question
- Re: qn on counting in drop down menus and protecting/hiding specific w
- Re: Making a Formula Contingent on Check Boxes
- Re: EXCEL MAXIMUM VALUE AND VLOOKUP NESTED?
- Re: Making a Formula Contingent on Check Boxes
- Re: qn on counting in drop down menus and protecting/hiding specific w
- EXCEL MAXIMUM VALUE AND VLOOKUP NESTED?
- Quick solver question
- Re: Adding bytes, gigabytes, and megabytes in Excel
- Re: sumproduct last 30 rows
- Re: Summation question
- Re: Summation question
- Re: Summation question
- Re: Macro for a Pop-Up Box help....
- Re: Index to define a range
- Re: Excel, how to copy conditional formats in sequential order 1,2,3
- Re: Excel, how to copy conditional formats in sequential order 1,2,3
- Re: How do I?
- Re: How do I?
- Re: Using Index & Match functions to find data on separate worksheet.
- Macro for a Pop-Up Box help....
- Re: Using Index & Match functions to find data on separate worksheet.
- RE: qn on counting in drop down menus and protecting/hiding specific w
- Re: Using Index & Match functions to find data on separate worksheet.
- Re: Counting for unique values using 2 cells
- Re: One more try!!
- Re: Capturing a word sequence as part of a text in a spreadsheet cell
- Re: reorganize string
- Using Index & Match functions to find data on separate worksheet.
- Using Named Ranges with Charts: Part 2 (!)
- Re: Counting for unique values using 2 cells
- Re: SPREADSHEET
- Re: Date format in a text string
- Re: Help with editing a formula
- Re: Difficulty displaying text
- Re: Help with editing a formula
- Re: URGENT: Using Named Ranges with Chart Wizard
- Re: Date format in a text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Date format in a text string
- Re: Use of the Contents of a cell as a worksheet name in a functio
- Re: Use of the Contents of a cell as a worksheet name in a function
- RE: qn on counting in drop down menus and protecting/hiding specific w
- Re: Help with editing a formula
- Re: Help with editing a formula
- Re: Help with editing a formula
- Re: Help with editing a formula
- Re: Counting for unique values using 2 cells
- Re: static date
- Utilizing a Cell even with a Formula located inside it
- RE: calculate various cells to acheive a specific value
- From: Jennifer_C via OfficeKB.com
- Re: calculate various cells to acheive a specific value
- From: Jennifer_C via OfficeKB.com
- Re: calculate various cells to acheive a specific value
- From: Jennifer_C via OfficeKB.com
- Re: data validation with a formula
- Re: My formula is =Sum(E38). How can I add text to the formula?
- Re: Consolidating with empty-string ("") cells removed
- Re: My formula is =Sum(E38). How can I add text to the formula?
- Consolidating with empty-string ("") cells removed
- Re: Making a Formula Contingent on Check Boxes
- Re: Making a Formula Contingent on Check Boxes
- Making a Formula Contingent on Check Boxes
- Re: Data validation dependencies
- Re: My formula is =Sum(E38). How can I add text to the formula?
- Re: Need formula
- RE: Goal Seek Algebra Formula
- RE: sumproduct formula
- RE: Goal Seek Algebra Formula
- Re: Sum the first x cells in a range
- Re: Need formula
- Re: Adding bytes, gigabytes, and megabytes in Excel
- Re: One more try!!
- Re: Sum the first x cells in a range
- Re: Sum the first x cells in a range
- Re: Rename Sheet using Cell Reference
- RE: sumproduct formula
- Re: One more try!!
- Re: SUMPRODUCT formula messed up
- Re: Rename Sheet using Cell Reference
- Re: Rename Sheet using Cell Reference
- qn on counting in drop down menus and protecting/hiding specific worksheets
- SUMPRODUCT formula messed up
- Re: Look up 2 values, return result in a different workbook
- RE: sumproduct formula
- Re: Counting for unique values using 2 cells
- Re: sumproduct formula
- RE: sumproduct formula
- Re: Rename Sheet using Cell Reference
- Re: how to insert a special character (arrow) in IF statement
- Re: concatenate link
- Re: One more try!!
- Re: Solver Help
- From: brownti via OfficeKB.com
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Auto Fill days of the month (not including weekends)
- Re: Auto Fill days of the month (not including weekends)
- From: Rick Rothstein \(MVP - VB\)
- Re: Is there a better formula than this Q
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Is there a better formula than this Q
- Re: URGENT: Using Named Ranges with Chart Wizard
- Re: URGENT: Using Named Ranges with Chart Wizard
- Re: Auto Fill days of the month (not including weekends)
- Re: Auto Fill days of the month (not including weekends)
- Re: Showing Cummulative Top5 results with an array-formula...?
- URGENT: Using Named Ranges with Chart Wizard
- Re: Is there a better formula than this Q
- Re: Is there a better formula than this Q
- Re: Split text to multiple cells
- From: Rick Rothstein \(MVP - VB\)
- RE: Split text to multiple cells
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- Is there a better formula than this Q
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: One more try!!
- Re: Index & multiple sheets in one workbook
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: Showing Cummulative Top5 results with an array-formula...?
- RE: Dollar / Euro sign
- Re: static date
- Re: Showing Cummulative Top5 results with an array-formula...?
- Re: One more try!!
- Re: Showing Cummulative Top5 results with an array-formula...?
- Showing Cummulative Top5 results with an array-formula...?
- Re: data validation with a formula
- Re: data validation with a formula
- Re: How to
- Re: data validation with a formula
- Re: Can I use an array formula with multiple criteria in the same
- Re: Multiple Lookups - SIngle Result
- How to
- Re: How do I get my rows and colums to show up when printing??
- Re: Multiple Lookups - SIngle Result
- Re: data validation with a formula
- Re: SPREADSHEET
- Re: data validation with a formula
- Re: Average of only cells containing numeral value
- Re: data validation with a formula
- data validation with a formula
- Re: can i add colours cells only in excell
- Re: Formula to identify character formatting (bold, italic, etc)
- Re: Index & multiple sheets in one workbook
- Re: Index & multiple sheets in one workbook
- Re: Validation - clear blanks from drop down
- Re: Average of only cells containing numeral value
- Re: Multiple Lookups - SIngle Result
- Re: Index & multiple sheets in one workbook
- Re: Insert a progressive invoice number
- Re: need help please inserting multiple rows based on cell value then copying to data sheet
- Re: Insert a progressive invoice number
- Re: Index & multiple sheets in one workbook
- need help please inserting multiple rows based on cell value then copying to data sheet
- Re: Calculating the sum if two criteria are met?
- Re: Validation - clear blanks from drop down
- Re: Inserting a Row
- Re: Inserting a Row
- Re: Inserting a Row
- Re: Ignore Blank in Validation not working
- Re: Validation - clear blanks from drop down
- RE: Challenging Formula. Need help with writing a formula
- Re: Ignore Blank in Validation not working
- Re: Showing Top 30 with array-formula?
- Re: Ignore Blank in Validation not working
- Re: Can I use an array formula with multiple criteria in the same
- Re: Array Formulas with multiple criteria in the same row?
- RE: Challenging Formula. Need help with writing a formula
- Re: I want result of a function in the cell and not the function itsel
- Re: Showing Top 30 with array-formula?
- Re: Index function - problem copying to other cells
- RE: calculating sample sizes for independent groups
- Re: Average of only cells containing numeral value
- Re: Index function - problem copying to other cells
- Re: Index function - problem copying to other cells
- RE: Does loop function cause this problem?
- RE: Problem with IF statement
- Re: Showing Top 30 with array-formula?
- Re: Problem with IF statement
- RE: Problem with IF statement
- RE: calculating sample sizes for independent groups
- RE: Does loop function cause this problem?
- Re: Returning a column name or number
- Re: Showing Top 30 with array-formula?
- Re: Multiple Lookups - SIngle Result
- Re: Returning a column name or number
- RE: Challenging Formula. Need help with writing a formula
- Re: Array Formulas with multiple criteria in the same row?
- Re: Array Formulas with multiple criteria in the same row?
- Re: Referring to Sheet locations in a formula
- Re: Can I use an array formula with multiple criteria in the same row?
- Re: Referring to Sheet locations in a formula
- Re: Showing Top 30 with array-formula?
- Re: Multiple Lookups - SIngle Result
