microsoft.public.excel.worksheet.functions
- searching for just the month
- Re: How do I extract the numerical value of '325.00' to next column
- Re: Combo Box
- Re: showing an empty cell instead of a zero in a formulated cell.
- Re: Need to seperate
- Re: Need to seperate
- Re: look up formula
- RE: Help me write a conditional formula - please!
- Re: Need to seperate
- Re: Nesting Address function in Offset without Quotes???
- Re: Sumproduct across worksheets
- Re: VLOOKUP
- Re: Subtracting Time using mm:ss.00 format
- saving as an add-in?
- Re: look up formula
- Re: How do I extract the numerical value of '325.00' to next column
- Re: Work Week, Excel 2000 & 2003
- Re: macros
- Re: A formula to AVERAGE IF but only average a set number of values
- Re: Auto Populate from a Mater List into Sub Sheets
- Re: When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval?
- Re: Using Trim with wildcards possible?
- Re: VLOOKUP
- Re: Sumproduct across worksheets
- Re: Transaction Classifications in Checkbook
- RE: Help me write a conditional formula - please!
- Re: Multiple data forms in a column
- Re: macros
- Re: A formula to AVERAGE IF but only average a set number of values
- Re: Sumproduct across worksheets
- Re: VLOOKUP
- Re: How can I concatenate text with leading zeros
- Re: How to vlookup and bring over fill colors as along with the data
- Re: Duplicate entries in more than one column
- Re: How to enable Macro automatically
- Re: When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval
- Re: When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval?
- Re: When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval
- When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval
- When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval
- Re: How to count array with OR condition
- When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval?
- When Using VLOOKUP With MATCH How Do I Handle #NA On Data Retrieval?
- Re: Multiple data forms in a column
- Re: Macro to close workbook with prompt
- Re: How do I show what the percentage is of one figure to another?
- Re: How can I concatenate text with leading zeros
- RE: selecting specific rows with a algorithym!?
- Re: how to match data
- Macro to close workbook with prompt
- VBA Help
- Sumproduct across worksheets
- Re: how to match data
- RE: Fixed typo: How to count array with OR condition
- Fixed typo: How to count array with OR condition
- How to count array with OR condition
- A formula to AVERAGE IF but only average a set number of values
- Re: How to enable Macro automatically
- Re: Absolute $ for a number
- Re: Duplicate entries in more than one column
- calculating time difference
- selecting specific rows with a algorithym!?
- Re: Dates on a worksheet
- RE: Valided alphanumeric value
- Re: How to copy formula with one cell constant
- Re: change header for each worksheet
- Re: if zero, then return blank/empty
- Re: Absolute $ for a number
- Re: if zero, then return blank/empty
- Re: Absolute $ for a number
- Re: if zero, then return blank/empty
- Re: if zero, then return blank/empty
- Re: Countif Function Using "AND"
- Re: need help with lookup formula
- Re: need help with lookup formula
- Re: Countif Function Using "AND"
- Re: need help with lookup formula
- Re: need help with lookup formula
- Re: Nesting sumif functions
- need help with lookup formula
- Re: Combo Box
- Re: Search for value in a range
- Re: Search for value in a range
- Re: Importing from Access
- Re: how to tighten up unwieldy formula
- Re: Search for value in a range
- Re: Nesting sumif functions
- Re: Search for value in a range
- Re: Importing from Access
- Re: Search for value in a range
- Re: Nesting sumif functions
- Re: SUMIF question
- Work Hours
- Re: AutoFilter does not include ascending or descending options
- Re: Duplicate entries in more than one column
- Re: AutoFilter does not include ascending or descending options
- Re: SUMIF question
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: Duplicate entries in more than one column
- Re: Absolute $ for a number
- Re: AutoFilter does not include ascending or descending options
- Re: Absolute $ for a number
- Re: Duplicate entries in more than one column
- Re: Cell names = sheet names
- Re: Cell names = sheet names
- Re: Absolute $ for a number
- Re: SUMIF question
- Re: SUMPRODUCT problem
- Re: Formula to point to another cell if an option is chosen.
- Re: Run time error '1004'
- Re: Cell names = sheet names
- Re: Cell names = sheet names
- RE: Lookup function
- Re: VLOOKUP WITH 2 CRITERIAS...
- Re: chart from drop down list of ranges
- Re: Convert minutes into hours
- RE: Am trying to autofill a formula and it will not increment down?
- Re: Can we create a viewport in Excel like Autocad?
- Re: STEP MULTIPLY FUNCTION
- RE: Lookup function
- Re: SUMPRODUCT problem
- Re: Lookup function
- Re: SUMPRODUCT problem
- RE: multiple vlookups in one statement
- RE: Function to populate cells??
- RE: multiple vlookups in one statement
- Re: how to tighten up unwieldy formula
- From: Rick Rothstein \(MVP - VB\)
- Re: Looking for certain months and summing the totals
- Re: Multiple IF function (maybe OR)
- Re: Multiple Scenario Condition Formula
- Re: Calculating Dates
- Re: Looking for certain months and summing the totals
- Re: Looking for certain months and summing the totals
- RE: Function to populate cells??
- Re: Looking for certain months and summing the totals
- Re: Looking for certain months and summing the totals
- RE: Assigning macro to toolbar - only works sometimes!
- Re: VBA Function
- Re: Looking for certain months and summing the totals
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: Looking for certain months and summing the totals
- Re: VBA Function
- Re: Count of a time range
- Re: Looking for certain months and summing the totals
- Re: Before Save code
- Re: VBA Function
- Re: VBA Function
- Re: VBA Function
- Re: VBA Function
- Re: Absolute $ for a number
- Re: VBA Function
- Re: The right formula is?
- VBA Function
- Re: Count of a time range
- Re: how to tighten up unwieldy formula
- Re: Crazy If
- Re: Linking cells in different spreadsheets
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- how to tighten up unwieldy formula
- Re: Looking for certain months and summing the totals
- Re: Count of a time range
- Re: Before Save code
- Re: Count of a time range
- Re: Formula to record the date
- Re: Formula to record the date
- Re: Formula to record the date
- Re: Count of a time range
- Re: Count of a time range
- Re: Formula to record the date
- Re: Count of a time range
- Re: avoid embedded if statements
- Re: avoid embedded if statements
- Re: Count of a time range
- Re: avoid embedded if statements
- Re: copy data of two cells from Sheet 2 into one cell in Sheet 1
- Re: choose table_array in VLOOKUP from list of multiple worksheets?
- Re: copy data of two cells from Sheet 2 into one cell in Sheet 1
- Re: Formula to record the date
- Re: Formula to record the date
- Re: Absolute $ for a number
- Re: Formula to record the date
- Re: Formula to record the date
- Re: The right formula is?
- Re: Formula to record the date
- Re: Formula to record the date
- Re: Formula to record the date
- Re: Count of a time range
- Re: interpolation
- Re: copy data of two cells from Sheet 2 into one cell in Sheet 1
- Re: is TEXT function appropriate?
- Re: is TEXT function appropriate?
- is TEXT function appropriate?
- Re: SUMIF or SUMIFS
- Re: Date value content format
- Re: LARGE 1, LARGE 2, LARGE 3, LARGE 4
- Re: default format for remarks
- Re: Date value content format
- Re: Before Save code
- Re: Before Save code
- Re: Please help on array search & result
- Re: Please help on array search & result
- Re: Calculating Dates
- Re: Please help on array search & result
- Re: Record entry by date
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: when autofiltering a spreadsheet need to know number of records
- Re: interpolation
- Re: interpolation
- Re: lookup one value in list and return multiple results
- Re: lookup one value in list and return multiple results
- RE: WORK HOURS DIFFERENCE BETWEEN TWO DATES
- Re: Counting unique entries across two or three columns
- Re: Different comparison criteria in sumproduct
- Crazy If
- Re: Different comparison criteria in sumproduct
- Re: comparing one to one cell within range
- Re: when autofiltering a spreadsheet need to know number of records
- Re: >4.5
- Re: Different comparison criteria in sumproduct
- Re: comparing one to one cell within range
- Re: Converting hours, minutes, seconds, to hours
- Re: Same Worksheet, want to transfer information from one tab to anoth
- Re: comparing one to one cell within range
- Re: Determine Value of Cell?
- Re: How to copy formula with one cell constant
- Re: Data validation lists help?
- Re: Offsetting and HLOOKUP
- Re: Numerous criteria in sumproduct
- Re: Running macro depending on cell value
- Re: Networkdays between columns
- Re: Determine Value of Cell?
- Re: Converting hours, minutes, seconds, to hours
- Re: Calculating Dates
- Re: Count of a time range
- Re: Determine Value of Cell?
- Re: Summarizing Date and Time
- Re: Converting hours, minutes, seconds, to hours
- Re: Determine Value of Cell?
- Re: Converting hours, minutes, seconds, to hours
- Re: Converting hours, minutes, seconds, to hours
- Re: Data validation lists help?
- Re: Copy specific records from a worksheet to another
- RE: Determine Value of Cell?
- Determine Value of Cell?
- Re: Count of a time range
- Re: Excel 2007 Not Responding
- Re: Summarizing Date and Time
- RE: Paste value from a formula
- Re: >4.5
- Re: Offsetting and HLOOKUP
- Re: help
- RE: multiple subtraction from one field
- Re: Numerous criteria in sumproduct
- Re: need help with IF
- Re: VLookup not working
- Re: SUMIF or SUMIFS
- Re: vlookup or index match function
- Re: SUMIF or SUMIFS
- Re: Calculating Dates
- Re: VLookup not working
- SUMIF or SUMIFS
- RE: Pulling cell information from one workbook to another
- Re: "table of contents" senario
- Re: Pulling cell information from one workbook to another
- Re: Pulling cell information from one workbook to another
- Pulling cell information from one workbook to another
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: If (M1>0,M1)
- Re: Name - relative reference doesn't calculate
- Re: Paramater driven value
- Re: Averageif function
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Assigning macro to toolbar - only works sometimes!
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Macro for Copying
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Statistical Calculation
- Re: using a result of a formula to generate text in Excel 2003
- RE: Duplicate Numbers when using the Large Function.
- RE: Numerous criteria in sumproduct
- Re: Offsetting and HLOOKUP
- Statistical Calculation
- Re: Adding weight measures
- Re: Offsetting and HLOOKUP
- Re: Averaging
- Re: Is a Match ?
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: Offsetting and HLOOKUP
- RE: Solving Sudoku with EXCEL
- From: LynnI via OfficeKB.com
- Re: Solving Sudoku with EXCEL
- From: LynnI via OfficeKB.com
- Re: sum cells that meet a specific condition
- Re: Averageif function
- Re: Averageif function
- Re: Averageif function
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: How do I locate a circular reference error?
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: Counting unique entries across two or three columns
- Offsetting and HLOOKUP
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: sam518 via OfficeKB.com
- Re: Counting unique entries across two or three columns
- Re: Name - relative reference doesn't calculate
- Re: Adding weight measures
- Re: IF statement
- Re: Running macro depending on cell value
- Running macro depending on cell value
- Re: Text to the left and right of a character
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: IF statement
- Re: Text to the left and right of a character
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: Text to the left and right of a character
- Re: "table of contents" senario
- Re: Text to the left and right of a character
- From: Rick Rothstein \(MVP - VB\)
- Re: Calculating Dates
- Text to the left and right of a character
- Calculating Dates
- Re: Counting unique entries across two or three columns
- Re: Counting unique entries across two or three columns
- Re: If (M1>0,M1)
- Re: Where no value, display "NA" - if statement?
- Re: validation
- Re: How do I set up a validation list?
- Re: external refs and dropdown validation
- Re: If (M1>0,M1)
- Re: If (M1>0,M1)
- Re: how do I interpolate numbers
- Re: How do I set up a validation list?
- Re: external refs and dropdown validation
- Re: If (M1>0,M1)
- Re: Sum cells
- Re: Where no value, display "NA" - if statement?
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Exclude Unique Values
- Re: Name - relative reference doesn't calculate
- Re: Duplicate Numbers when using the Large Function.
- Re: Where no value, display "NA" - if statement?
- Re: Name - relative reference doesn't calculate
- Re: IF function OK to use?
- Re: "table of contents" senario
- Re: variable column
- Re: How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: Data validation lists help?
- Re: If (M1>0,M1)
- Re: Formulas in 2007 not working in 2003
- Re: Formulas in 2007 not working in 2003
- Re: Seperate out rows to make a new page in a workbook
- Re: Set Defaults in File Import of a Text File
- Re: Subtract Date Q
- Re: Data validation lists help?
- Re: If (M1>0,M1)
- Re: Name - relative reference doesn't calculate
- Re: Formulas in 2007 not working in 2003
- Re: Name - relative reference doesn't calculate
- Re: Formulas in 2007 not working in 2003
- Re: Data validation lists help?
- Re: Name - relative reference doesn't calculate
- Re: Formulas in 2007 not working in 2003
- How to copy variable data from 2 worksheets into a seperate 3rd worksheet
- Re: [Excel 2000] Saving to .csv
- Re: Formulas in 2007 not working in 2003
- Re: Combining Hlookup and vlookup
- Re: [Excel 2000] Saving to .csv
- Re: Subtract Date Q
- Re: If (M1>0,M1)
- Re: Data validation lists help?
- If (M1>0,M1)
- Re: Subtract Date Q
- Subtract Date Q
- Re: Name - relative reference doesn't calculate
- Re: Macro for Copying
- Data validation lists help?
- [Excel 2000] Saving to .csv
- Re: Postcode distances
- Re: Name - relative reference doesn't calculate
- Finding matching values
- Work Week, Excel 2000 & 2003
- Re: Name - relative reference doesn't calculate
- Re: Postcode distances
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Name - relative reference doesn't calculate
- Re: Macro for Copying
- sumif and contains
- Re: Macro for Copying
- Re: Name - relative reference doesn't calculate
- Re: Macro for Copying
- Name - relative reference doesn't calculate
- Re: Duplicate Numbers when using the Large Function.
- Re: Average
- Re: Creating Lists from attendies of a Conference
- how to check More than one criteria and get the value
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- RE: Duplicate Numbers when using the Large Function.
- Re: change sign of a column of figures from + to -
- Re: Macro for Copying
- Re: Postcode distances
- Re: ALPHANUMERIC
- Re: ALPHANUMERIC
- Re: ALPHANUMERIC
- Re: auto sum from multiple worksheets
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: ALPHANUMERIC
- Re: Sum cells
- Re: Names with If function
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: auto sum from multiple worksheets
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: auto sum from multiple worksheets
- Re: Sum cells
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: auto sum from multiple worksheets
- Re: Create a Command Button to Send E-Mails to selected recipients
- RE: auto sum from multiple worksheets
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Sum cells
- auto sum from multiple worksheets
- Re: How do I calculate variance between numbers?
- Re: How do I calculate variance between numbers?
- Re: How do I calculate variance between numbers?
- Re: how do i autofill a cell a certain colour based on it's value?
- Re: Sum cells
- Re: ALPHANUMERIC
- From: Rick Rothstein \(MVP - VB\)
- Re: how do i autofill a cell a certain colour based on it's value?
- ALPHANUMERIC
- Re: Using pop up boxes to supply a variable within a macro
- RE: finding total from 2 seperate columns
- Re: Using pop up boxes to supply a variable within a macro
- Re: Using pop up boxes to supply a variable within a macro
- Re: Using pop up boxes to supply a variable within a macro
- Re: Running total for inventory
- Re: Combining Hlookup and vlookup
- Using pop up boxes to supply a variable within a macro
- Re: EOMONTH Formula
- Rectangle Box
- Re: EOMONTH Formula
- Re: Using date format in the cells how determine percent complete
- Re: Combining Hlookup and vlookup
- Re: What function-bring me the info in the next column-same row?
- Re: EOMONTH Formula
- Re: EOMONTH Formula
- Re: vlookup and match functions
- Re: EOMONTH Formula
- Re: EOMONTH Formula
- Re: Using "Non-Empty Cell"
- From: Rick Rothstein \(MVP - VB\)
- Re: Using "Non-Empty Cell"
- From: Rick Rothstein \(MVP - VB\)
- Re: change sign of a column of figures from + to -
- Re: Using "Non-Empty Cell"
- Re: Easy Calculator
- Using "Non-Empty Cell"
- Re: create two lines in one cell
- Re: Referencing cells according to date
- Re: Referencing cells according to date
- Re: Formulas in 2007 not working in 2003
- Re: Formulas in 2007 not working in 2003
- Re: Results table help please
- Re: Results table help please
- Re: Allocation formula
- Re: create two lines in one cell
- Allocation formula
- Re: Results table help please
- Re: Formatting Code for SI Units in Excel
- Re: how do I do conditional formatting for absolute values?
- Results table help please
- Referencing cells according to date
- VLOOKUP - recover missing data source
- Re: Min Year in an Array
- Re: worksheet protection
- Re: How to add 30 days to date in another column, including Sat/Sun?
- Re: How to add 30 days to date in another column, including Sat/Sun?
- Re: Formulas in 2007 not working in 2003
- Re: Formula for counting more than one criteria
- Re: How do I set up a validation list?
- Re: FORMULAES
- Re: FORMULAES
- Re: how do I do conditional formatting for absolute values?
- Re: Commas in Excel textbox moves my sentence to the next row
- Re: Wildcard Searches across Worksheets
- Re: Save one worksheet as PDF?
- Wildcard Searches across Worksheets
- Re: Save one worksheet as PDF?
- Re: Skipping Cells
- Re: counting unique names - again
- Re: How do I find multiple text in diff cells in another worksheet?
- Re: counting unique names - again
- Re: Skipping Cells
- Re: REPORTING unique values
- Re: Skipping Cells
- Re: summing the same cell in multiple workbooks
- Re: Save one worksheet as PDF?
- Re: VLOOKUP WITH RANGES
- Save one worksheet as PDF?
- Re: Cell names = sheet names
- Re: Skipping Cells
- Re: Formulas in 2007 not working in 2003
- Re: Need HELP! Solve for mortgage interest rate with following variabl
- Re: counting unique names - again
- Re: Email one worksheet to email address on worksheet
- Re: Email one worksheet to email address on worksheet
- Re: Value of String used in Calculation?
- Re: Email one worksheet to email address on worksheet
- Email one worksheet to email address on worksheet
- Re: summing the same cell in multiple workbooks
- Re: Dynamic Ranges
- summing the same cell in multiple workbooks
- Re: EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
- Re: EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
- Re: formula to reference cell on previous worksheet
- Re: Inserting a picture or chart into one cell in Excel
- Re: Trying to do a Lookup
- Re: formula to reference cell on previous worksheet
- Re: Formulas in 2007 not working in 2003
- Re: Monthly Change Using Nested IFs?
- Re: Trying to do a Lookup
- Re: Formulas in 2007 not working in 2003
- Re: Monthly Change Using Nested IFs?
- Re: Cell coloring according to the other cell's value
- Re: export information from excel to word doc template
- From: Aaron Hodson \(Coversure\)
- Re: Cell without its own format?
- Re: What function tests for whole number (no decimals)?
- Re: exel 2007 process
- Re: Exclude Unique Values
- Re: export information from excel to word doc template
- Re: remove leading spaces
- Re: remove leading spaces
- Re: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D
- Re: exel 2007 process
- Re: SUMIF with two conditions
- Re: export information from excel to word doc template
- Re: Formulas in 2007 not working in 2003
- Re: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D
- Re: export information from excel to word doc template
- From: Aaron Hodson \(Coversure\)
- Cell coloring according to the other cell's value
- Re: SUMIF with two conditions
- Re: export information from excel to word doc template
- Re: SUMIF with two conditions
- Re: IF formula using a range of values in a cell
- Re: IF formula using a range of values in a cell
- Re: SUMIF with two conditions
- export information from excel to word doc template
- From: Aaron Hodson \(Coversure\)
- Re: SUMIF with two conditions
- Re: SUMIF with two conditions
- SUMIF with two conditions
- Re: Formatting Code for SI Units in Excel
- Re: Formatting Code for SI Units in Excel
- Re: Formulas in 2007 not working in 2003
- Re: Formulas in 2007 not working in 2003
- Re: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D
- Re: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D
- Re: REPORTING unique values
- Re: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y
- Re: Cell without its own format?
- Re: Formulas in 2007 not working in 2003
- Re: Cell value when conditions are met
- Re: Auto-fill formulas Excel 2003
- Re: If in specific cell in any worksheet but worksheet one add to spec
- Re: Auto-fill formulas Excel 2003
- Re: calculate remaining pay periods
- RE: If in specific cell in any worksheet but worksheet one add to spec
- Re: Drop down menu and validation over mulitiple sheets
- Re: Auto Sum Function
- Re: calculate remaining pay periods
- Re: If in specific cell in any worksheet but worksheet one add to spec
- If in specific cell in any worksheet but worksheet one add to spec
- RE: Compare value in current cell to previous cell
- Re: Drop down menu and validation over mulitiple sheets
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: can I compute the bounds of a 3D reference
- Re: Formulas in 2007 not working in 2003
- Re: Formula
- Re: Drop down menu and validation over mulitiple sheets
- Re: Drop down menu and validation over mulitiple sheets
- Re: Auto Sum Function
- Re: Auto Sum Function
- Re: Formula
- Re: Compare value in current cell to previous cell
- Re: Insert Columns in multiple sheets
- Re: CONCATENATE Date formatting
- Re: Formulas in 2007 not working in 2003
- Re: REPORTING unique values
- Re: I need to Write a Formula
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: Lookup a value in a row and the sum the corresponding rows in
- Re: CONCATENATE Date formatting
- Re: REPORTING unique values
- Re: CONCATENATE Date formatting
- From: Rick Rothstein \(MVP - VB\)
- Re: Insert Columns in multiple sheets
- Re: remove leading spaces
- Re: Solving Sudoku with EXCEL
- Re: CONCATENATE Date formatting
- CONCATENATE Date formatting
- Re: remove leading spaces
- Re: Formulas in 2007 not working in 2003
- Re: remove leading spaces
- Re: vlookup formula
- RE: Insert>Name>Define
- Re: Insert>Name>Define
- Re: Lookup a value in a row and the sum the corresponding rows in
- Re: vlookup formula
- Re: conditional formatting for <= +- 1.0%
- Re: time guru needed
- Re: Formulas in 2007 not working in 2003
- Re: Copying the sum from the lower right hand side of the excel window
- Re: Average time between 2 dates
- Re: Average time between 2 dates
- Re: Macro for Copying
- Re: remove leading spaces
- Re: Automatically change case is Excel when typed
- Re: vlookup formula
- Re: REPORTING unique values
- Solving Sudoku with EXCEL
- From: LynnI via OfficeKB.com
- Re: Cell value when conditions are met
- Re: if range b6:n6 has no content, return A6
- Re: if range b6:n6 has no content, return A6
- Re: if range b6:n6 has no content, return A6
- Re: Vlookup plus other function/s combinations required?
- Re: time guru needed
- Re: Macro for Copying
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Bug or wrong approach
- Re: Bug or wrong approach
- Re: Bug or wrong approach
- Re: Bug or wrong approach
- Re: Counting unique entries across two or three columns
- Re: SUM function across multiple worksheets within one workbook
- time guru needed
- Re: MS Excel Nested Functions
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: Counting unique entries across two or three columns
- Re: Counting unique entries across two or three columns
- Re: MAX Array?
- Re: Lookup a value in a row and the sum the corresponding rows in colu
- Automate adding in a reference number if the adjacent cell contains text...
- RE: Dynamic Row Formula
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Allow no action to be taken
- Re: Sumproduct with 2 criteria.
- Counting unique entries across two or three columns
- Re: Interpret a squence of cells as an array
- Re: Interpret a squence of cells as an array
- RE: Automatically change case is Excel when typed
- Re: REPORTING unique values
- Re: Merge and remove duplicates?
- Re: Allow no action to be taken
- RE: How to insert rows based on change in data
- RE: Dynamic Row Formula
- Re: Interpret a squence of cells as an array
- Re: Automatically change case is Excel when typed
- Re: results of value_if_false = no change to cell
- Re: Error Handling for xlCellTypeFormulas
- Re: MAX Array?
- From: Rick Rothstein \(MVP - VB\)
- Re: Interpret a squence of cells as an array
- Re: Attrition
- Re: MAX Array?
- From: Rick Rothstein \(MVP - VB\)
- RE: Automatically change case is Excel when typed
- Re: vlookup formula
- RE: Automatically change case is Excel when typed
- Re: vlookup formula
- Re: MAX Array?
- RE: results of value_if_false = no change to cell
- Re: How to
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- RE: Automatically change case is Excel when typed
- Re: MAX Array?
- Re: How to insert rows based on change in data
- Re: Bug or wrong approach
- Re: Bug or wrong approach
- Re: Bug or wrong approach
- Error Handling for xlCellTypeFormulas
- Re: MAX Array?
- From: Rick Rothstein \(MVP - VB\)
- Re: Bug or wrong approach
- MAX Array?
- RE: Incremental forumla needed
- Re: Bug or wrong approach
- RE: Incremental forumla needed
- Re: SUM function across multiple worksheets within one workbook
- Re: Bug or wrong approach
- Re: Macro for Copying
- Re: how do i make a formula to multiply two values?
- Re: Sumproduct with 2 criteria.
- Re: Sumproduct with 2 criteria.
- RE: results of value_if_false = no change to cell
- Re: IF Function Question
- Re: SUM function across multiple worksheets within one workbook
- IF Function Question
- Re: Can't remove formatting from copied data in Excel worksheet
- Re: Attrition
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Interpret a squence of cells as an array
- Re: Can't remove formatting from copied data in Excel worksheet
- Re: Having Trouble Inserting a Column
- Bug or wrong approach
- Having Trouble Inserting a Column
- Attrition
- Re: Easy Calculator
- Re: Easy Calculator
- Re: Easy Calculator
- RE: Column with repeated numbers
- Re: replace all function - excel 2003
- Re: My Excel Spreadsheet now has numbers on both axes - why?
- Re: How do i get more then 3 colours conditions in one sheet in excel
- RE: SUMIF Question
- Re: MS Excel Nested Functions
- Re: MS Excel Nested Functions
- Re: How to
- Re: Remove #VALUE! from ConCat Range Function
- Re: Cell value when conditions are met
- Re: Remove #VALUE! from ConCat Range Function
- Re: Cell value when conditions are met
- Re: Remove #VALUE! from ConCat Range Function
- Re: Remove #VALUE! from ConCat Range Function
- Re: Cell value when conditions are met
- Re: format cells
- Re: Date format
- Re: auto change font color in formula/cell
- Re: Cells changes colour if....
- Re: millisecond
- Re: Functions
- From: Rick Rothstein \(MVP - VB\)
- Re: Can't remove formatting from copied data in Excel worksheet
- Re: Year & Month format
- Re: Why does this code not do what I want
- From: Rick Rothstein \(MVP - VB\)
- Re: Automatically move to next cell...
- Re: Can't Access Add-Ins
- Re: Why does this code not do what I want
- Re: Modify a UDF please?
- Macro for Copying
- Re: How to delete blank worksheets
- Re: Why does this code not do what I want
- From: Rick Rothstein \(MVP - VB\)
- Re: What function-bring me the info in the next column-same row?
- RE: Why does this code not do what I want
- RE: Why does this code not do what I want
- Re: I want to count the cell if contains 111 or 1111
- From: Rick Rothstein \(MVP - VB\)
- How to count occurrence when there is an "AND" relation?
- Re: FORMULA
- From: Rick Rothstein \(MVP - VB\)
- Why does this code not do what I want
- Re: Page Filters
- Re: Editing an Office 2003 Document using Office 2007
- Re: EXCEL 2003
- Re: how do i make a formula to multiply two values?
- Re: time seperation
- Re: Multiple Logical Functions in one Formula
- Re: This should be easy, but can't find an answer...requesting your in
- Re: Exclude Unique Values
- Re: Replace the Find Function with a formula
- Re: How to
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: More help on a UDF please. Urgent!
- Re: Modify a UDF please?
- Re: Getting a list of returned values from an array
- I have doubt regarding the find a result with two criteria's!!
- Re: Populate Order worksheet from Quote worksheet
- Re: I want to count the cell if contains 111 or 1111
- Re: Date changes mysteriously
- Re: Page Filters
- Re: MVP articles
- Re: MVP Published articles
- Re: Calculate number days + hours to complete a project
- Re: countif with variabel criteria?
- Re: nested MATCH within Array formula?
- Re: Advanced Array Formula Problem
- Re: vlookup formula
- Re: How do I use the spell check on a protected sheet in Excel?
- Re: VB file renaming.
- Re: How to
- Re: vlookup formula
- Re: Find unique data by row
- Re: Syntax help with date calculation
- Referencing Cells
- Re: How do I use the spell check on a protected sheet in Excel?
- Re: totalling phone minutes
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: changing date format
- From: Rick Rothstein \(MVP - VB\)
- Re: SUMIF? Question
- RE: Pivot Table Wizard Fails to Recognize New Rows of a Named Rang
- Re: Functions
- Re: Text lookup array and match specific data
- Modify a UDF please?
- A problem with nested IF's
- Use an If function to result in more then one answer
- Re: Populate Order worksheet from Quote worksheet
- Re: index\large help....UPDATE
- Re: index\large help....UPDATE
- Re: Populate Order worksheet from Quote worksheet
- Re: Populate Order worksheet from Quote worksheet
- Re: Populate Order worksheet from Quote worksheet
- Re: How to find a third true-false relationship between three groups of variables knowing two
- Re: How to find a third true-false relationship between three groups of variables knowing two
- Re: counting numbers??
- Populate Order worksheet from Quote worksheet
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: counting numbers??
- Re: How to find a third true-false relationship between three groups of variables knowing two
- Re: counting numbers??
- Re: counting numbers??
- Re: counting numbers??
- Re: counting numbers??
- Re: Sum Count of Numeric Duplicates: appears x2 in any Row
- Re: getting 3% from a work sheet
- Re: getting 3% from a work sheet
- Re: index\large help....UPDATE
- getting 3% from a work sheet
- Re: index\large help....UPDATE
- Re: index\large help....UPDATE
- counting numbers??
- Re: How to find a third true-false relationship between three groups of variables knowing two
- Re: index\large help....UPDATE
- Re: How to find a third true-false relationship between three groups of variables knowing two
- Re: index\large help....UPDATE
- Re: Text lookup array and match specific data
- Re: index\large help....UPDATE
- From: Rick Rothstein \(MVP - VB\)
- Re: replace all function - excel 2003
- Re: Filter Across Multiple Sheets
- Re: replace all function - excel 2003
- How to find a third true-false relationship between three groups of variables knowing two
- Re: Editing an Office 2003 Document using Office 2007
- Re: E-mail Sort
- Re: Create Acronym (Extract first letter of each word)
- Re: Formula apparently successful but #VALUE displayed
- Filter Across Multiple Sheets
- Re: index\large help....UPDATE
- Re: E-mail Sort
- E-mail Sort
- Re: Formula apparently successful but #VALUE displayed
- Sum Count of Numeric Duplicates: appears x2 in any Row
- From: Sam via OfficeKB.com
- Re: Using list functionality
- HELP: Sort of AutoComplete feature or i don't know
- Formula apparently successful but #VALUE displayed
- Re: replace all function - excel 2003
- Re: index\large help....UPDATE
- Re: index\large help....UPDATE
- Re: if then
- From: Rick Rothstein \(MVP - VB\)
- Re: changing date format
- From: Rick Rothstein \(MVP - VB\)
- Hide a row and set print area
- Re: Delete all data on a worksheet
- Re: How to
- Re: Custom number code [conditional] help
- From: Rick Rothstein \(MVP - VB\)
- Re: Populate order sheet with data from work sheet
- Re: Custom number code [conditional] help
- Re: Populate order sheet with data from work sheet
- How to
- Re: adjacent cells?
- Re: changing date format
- Re: changing date format
- Using list functionality
- Re: Date stamp when a value is entered in a cell
- Re: Date stamp when a value is entered in a cell
- Re: Date stamp when a value is entered in a cell
- Re: Date stamp when a value is entered in a cell
- Re: changing date format
- Re: choose table_array in VLOOKUP from list of multiple worksheets?
- Re: choose table_array in VLOOKUP from list of multiple worksheets?
- Re: Delete all data on a worksheet
- RE: replace all function - excel 2003
- Re: SUMIF? Question
- Re: SUMIF? Question
- Re: Combining AND, MID, and OR
- Combining AND, MID, and OR
- Re: vlookup?
- Re: Populate order sheet with data from work sheet
- Re: I have a DB of auction items sold, how can I create receipt?
- RE: How can I set up a dynamic data entry form?
- adjacent cells?
- Re: Populate order sheet with data from work sheet
- Re: Data Validation 2003, Named Ranges/Formulas
- Re: Custom number code [conditional] help
- Re: How do I use the spell check on a protected sheet in Excel?
- Re: if a vlookup returns "#n/a" how can I make that zero?
- Re: Delete all data on a worksheet
- Re: Somewhat Complex: Allocation of Payments
- Re: Custom number code [conditional] help
- From: Rick Rothstein \(MVP - VB\)
- Re: Custom number code [conditional] help
- Re: 2003/XP Macros in 2000
- Re: vlookup formula
- Re: Do I use "IF" or something else?
- Re: Custom number code [conditional] help
- Re: if then
- Populate order sheet with data from work sheet
- Re: Custom number code [conditional] help
- Re: Custom number code [conditional] help
- Re: if then
- Re: Custom number code [conditional] help
- Re: if then
- Re: Custom number code [conditional] help
- From: Rick Rothstein \(MVP - VB\)
- Re: Custom number code [conditional] help
- Re: Somewhat Complex: Allocation of Payments
- Re: Custom number code [conditional] help
- Re: Custom number code [conditional] help
- Custom number code [conditional] help
- index\large help....UPDATE
- RE: choose table_array in VLOOKUP from list of multiple worksheets?
- Re: vlookup?
- Re: Somewhat Complex: Allocation of Payments
- Re: millisecond
- Re: SUMIF? Question
- Re: Somewhat Complex: Allocation of Payments
- Re: Do I use "IF" or something else?
- Re: Somewhat Complex: Allocation of Payments
- Re: millisecond
- Re: millisecond
- Re: SUMIF? Question
- Re: SUMIF? Question
- RE: Pivot Table Wizard Fails to Recognize New Rows of a Named Range
- Re: Somewhat Complex: Allocation of Payments
- Re: I have a DB of auction items sold, how can I create receipt?
- Re: Somewhat Complex: Allocation of Payments
- RE: Can I link/lock rows so they move together in a sort?
- Re: How do I use the spell check on a protected sheet in Excel?
- Re: How to get text
- RE: How to get text
- Re: Selecting from drop down list enters multiple cell data
- Re: Count of entries meeting criteria
- Re: Negative time calculations
- Delete all data on a worksheet
- Re: phone number format
- Re: phone number format
- From: Rick Rothstein \(MVP - VB\)
- Re: index/large..help please
- Re: vlookup formula
- Re: index/large..help please
- Re: Forever
- phone number format
- Re: vlookup formula
- Re: excel spreadsheet
- Re: Help with adding pages
- Re: Text lookup array and match specific data
- Re: Functions
- Re: index/large..help please
- RE: Excel 2007 Problem with Filter
- Text lookup array and match specific data
- Re: Extract data from database
- Re: Can I convert a number(1-365) to a month and day of a year?
- Re: totalling phone minutes
- RE: referencing mult drop down list
- Re: Keyboard Shortcut for Drop Down List
- RE: referencing mult drop down list
- RE: Excel 2007 Problem with Filter
- Re: vlookup?
- Re: Help with adding pages
- Re: excel spreadsheet
- Help with adding pages
- Re: totalling phone minutes
- Re: Negative time calculations
- Re: Do I use "IF" or something else?
- Re: Do I use "IF" or something else?
- Re: Negative time calculations
- Re: Do I use "IF" or something else?
- Re: excel spreadsheet
- Re: index/large..help please
- Re: Disable Excel Print
- Re: Cond Format - C6 when G6 contains any text
- Re: Disable Excel Print
- Re: Negative time calculations
- Re: Do I use "IF" or something else?
- Re: Negative time calculations
- Re: Do I use "IF" or something else?
- Re: Disable Excel Print
- Re: Do I use "IF" or something else?
- Re: vlookup?
- Re: Negative time calculations
- Re: index/large..help please
- RE: Disable Excel Print
- Re: Negative time calculations
- Re: Negative time calculations
- Re: index/large..help please
- Re: index/large..help please
- Re: whole price sheet change
- Re: whole price sheet change
- From: Rick Rothstein \(MVP - VB\)
- Re: Do I use "IF" or something else?
- Re: Do I use "IF" or something else?
- Re: whole price sheet change
- Re: whole price sheet change
- whole price sheet change
- Re: Can I convert a number(1-365) to a month and day of a year?
- Re: index/large..help please
- Re: How do I use the LOOKUP feature in Excel
- Re: 2003/XP Macros in 2000
- Re: Cond Format - C6 when G6 contains any text
- Re: Can I convert a number(1-365) to a month and day of a year?
- Re: Can I convert a number(1-365) to a month and day of a year?
- Re: Cond Format - C6 when G6 contains any text
- Re: Extract data from database
- Re: index/large..help please
- Re: How to return a number into letters?
- Re: Cond Format - C6 when G6 contains any text
- index/large..help please
- Re: Excel Sequential Numbering of cell within worksheet
- Re: Excel Sequential Numbering of cell within worksheet
- Re: Functions
- From: Rick Rothstein \(MVP - VB\)
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: How to determine the value?
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: SUMPRODUCT gives incorrect total
- Re: changing dates and years with less keystrokes
- Re: Recover Excel file that was saved over
- Re: Economical grouping of lengths out of much longer lengths
- Re: Recover Excel file that was saved over
- RE: Regression with zero intercept
- Re: changing dates and years with less keystrokes
- Re: Recover Excel file that was saved over
- Re: Recover Excel file that was saved over
- Re: Create Acronym (Extract first letter of each word)
- Re: changing dates and years with less keystrokes
- Re: Regression with zero intercept
- Re: Recover Excel file that was saved over
- Re: changing dates and years with less keystrokes
- Re: Move Specific Data to Another Worksheet
- Re: Move Specific Data to Another Worksheet
- Re: Recover Excel file that was saved over
- Re: Functions
- From: Rick Rothstein \(MVP - VB\)
- Re: formula for pairing 60 different products into 5 price groups
- Re: changing dates and years with less keystrokes
- Re: changing dates and years with less keystrokes
- Re: How do you determine a total number of worksheet entries?
- Re: Excel 2007 Not Responding
- Re: can I find the area under a plotted curve?
- Re: vlookup?
- Re: Borders and conditional formating
- Re: Borders and conditional formating
- RE: Extract data from database
- Re: Borders and conditional formating
- Re: changing dates and years with less keystrokes
- Re: "add parenthesis"
- Re: Borders and conditional formating
- Borders and conditional formating
- Re: changing dates and years with less keystrokes
- vlookup?
- Re: Year to date sales
- Re: changing dates and years with less keystrokes
- Re: Selecting from drop down list enters multiple cell data
- Re: changing dates and years with less keystrokes
- Re: Worksheet Protection
- Re: IF function question
- Re: Worksheet Protection
- Re: Year to date sales
- Re: "add parenthesis"
- Re: Sales Commission Calculation
- Re: Can you use multiple SEARCH functions in one cell
- Re: Year to date sales
- Re: Conditional Formatting help, please
- Re: Conditional Formatting help, please
- Re: How to reference a cell depending on the value in another cell
- Re: Can you use multiple SEARCH functions in one cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Conditional Formatting help, please
- From: Rick Rothstein \(MVP - VB\)
- Year to date sales
- Re: Conditional Formatting help, please
- Re: Can you use multiple SEARCH functions in one cell
- Re: Defined Names in Workbook
- Re: Conditional Formatting help, please
- Conditional Formatting help, please
- Re: Excel formulas
- Re: How can I delete all matches in a workbook?
- Re: Excel formulas
- Re: Sumif for groups and subgroups / Excel 2003
- Re: how do I write the formula to find the mean in a column of number
- Re: how do I write the formula to find the mean in a column of number
- Re: Sum column based on text of another
- Re: amortization table
- Re: Sum column based on text of another
- Re: Function To Lookup Unique Records In 2 Sets Of Data
- Re: vlookup formula
- Re: Extract data from database
- Re: Sumif for groups and subgroups / Excel 2003
- RE: Sumif for groups and subgroups / Excel 2003
- Re: Finding the last entry in a column based on criteria
- Re: how do I lock formulas, but still allow rows to be added or delet.
- Re: Sumif for groups and subgroups / Excel 2003
- Re: Defined Names in Workbook
- Re: how do I lock formulas, but still allow rows to be added or delet.
- Re: Excel formulas
- Re: Defined Names in Workbook
- Re: Array Functions
- Re: "add parenthesis"
- Re: Copy first few letters from a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Copy first few letters from a cell
- Re: changing dates and years with less keystrokes
- Re: Too much data?
- Re: Too much data?
- Re: "add parenthesis"
- Re: Selecting from drop down list enters multiple cell data
- RE: Finding duplicate numbers in a spreadsheet
- Re: Finding duplicate numbers in a spreadsheet
- RE: vlookup / index / match?
- Re: vlookup / index / match?
- Re: "background" formatting possible?
- Re: How to reference a cell depending on the value in another cell
- RE: Automating excel with outlook
- Re: How can I delete all matches in a workbook?
- vlookup / index / match?
- RE: creating a report with macros
- Re: why does my "TAB" key skip a column in excel spread sheets?
- Re: How-to create a list from a summary table? (Office 2007)
- Re: How-to create a list from a summary table? (Office 2007)
- Re: How to check for a date range match in one column and then count the values equal to in another
- Re: Check Date Range and Multiply Stock Qty
- Re: How to check for a date range match in one column and then count the values equal to in another
- Check Date Range and Multiply Stock Qty
- Re: vlookup formula
- Re: How to check for a date range match in one column and then count the values equal to in another
- Re: How to check for a date range match in one column and then count the values equal to in another
- Re: Queries/Extracting
- Re: How to check for a date range match in one column and then count the values equal to in another
- How to check for a date range match in one column and then count the values equal to in another
- Re: Finding the last entry in a column based on criteria
- Re: Find one character or another and display
- Re: Find one character or another and display
- Re: Find one character or another and display
- From: Rick Rothstein \(MVP - VB\)
- Find one character or another and display
- Re: GETPIVOTDATA with date in referenced cell
- Re: Assign a date
- Re: Assign a date
- Re: Queries/Extracting
- Re: How do I count occurances of a specific character in a range?
- Re: Cell Shading
- Re: Queries/Extracting
- Re: keyboard short cut for highlighting a field
- Re: Removing #N/A from formula results
- Re: Removing #N/A from formula results
- Re: Removing #N/A from formula results
- Re: Queries, extracting
- Re: keyboard short cut for highlighting a field
- Re: Cell Shading
- Re: keyboard short cut for highlighting a field
- Re: keyboard short cut for highlighting a field
- Re: keyboard short cut for highlighting a field
- Re: need to move cursor to specific fields
- Re: Making a list of numbers with 16 digits
- Re: Worksheet change Event
- Re: Need help with formula
- Re: Need help with formula
- Re: Count If And Contains
- From: Rick Rothstein \(MVP - VB\)
- Re: VB file renaming.
- From: Rick Rothstein \(MVP - VB\)
- Re: Copy first few letters from a cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Copy first few letters from a cell
- Re: Copy first few letters from a cell
- Re: How can I delete all matches in a workbook?
- Re: Copy first few letters from a cell
- Re: Need help with formula
- Re: vlookup formula
- Re: How can I delete all matches in a workbook?
- Re: Help with spreadsheet
- Re: Need cell to equal another cell if certain criteria is met?
- Help with spreadsheet
- Re: Validation - e-mail
- From: Rick Rothstein \(MVP - VB\)
- RE: creating a report with macros
- Re: vlookup formula
- Re: question re: SUMPRODUCT format
- Re: question re: SUMPRODUCT format
- Re: question re: SUMPRODUCT format
- Re: Count If And Contains
- question re: SUMPRODUCT format
- Re: Create alternate line of data
- Re: Formatting color and font to a logical statement result?
- From: Rick Rothstein \(MVP - VB\)
- Re: How can I create one column (stacked) from a large table of data..
- Re: Formula or function displays after edit and not its result
- Re: Create Acronym (Extract first letter of each word)
- Re: Formatting color and font to a logical statement result?
- Re: scatter plot
- Re: Formatting color and font to a logical statement result?
- Re: Validation - e-mail
- Re: Count If And Contains
- Re: I can't get Excel to caluate dates in the 1800's. #VALUE!
- Re: vlookup in 20 sheets..
- Re: vlookup formula
- Re: Finding the last entry in a column based on criteria
- Re: scatter plot
- Re: Create Acronym (Extract first letter of each word)
- RE: Validation - e-mail
- Re: Count If And Contains
- Re: Linking Files
- Re: How to return a number into letters?
- From: Rick Rothstein \(MVP - VB\)
- Re: Formula or function displays after edit and not its result
- Re: Count If And Contains
- Re: Insert a row with simaler data using a function
- Re: Formula or function displays after edit and not its result
- Re: Total A Range
- Re: Conditional format issue
- From: Rick Rothstein \(MVP - VB\)
- Re: Count If And Contains
- Re: IF function question
- Re: Create alternate line of data
- Re: IF function question
- Re: IF function
- Protect borders only excel spreadsheet
- GETPIVOTDATA with date in referenced cell
- Re: Conditional format issue
- Re: Excel formula reference question
- RE: creating a report with macros
- Re: IF function
- Re: adding function- can you hide the 0.00 in the total column
- RE: creating a report with macros
- Re: Conditional format issue
- From: Rick Rothstein \(MVP - VB\)
- Re: Conditional format issue
- From: Rick Rothstein \(MVP - VB\)
- RE: vlookup formula
- Re: problem trying to change page breaks
- Re: Linking Files
- Re: Linkage File
- RE: creating a report with macros
- Re: problem trying to change page breaks
- Re: Conditional format issue
- Re: Excel formula reference question
- Re: Excel formula reference question
- Re: not sure how to do a formula
- Excel formula reference question
- vlookup in 20 sheets..
- RE: vlookup formula
- RE: vlookup formula
- Re: Filtered field
- RE: vlookup formula
- Re: Numbering different products
- Re: Numbering different products
- Re: Numbering different products
- Re: Count the number of AutoFiltered records
- Filtered field
- Re: Count the number of AutoFiltered records
- Re: Create Acronym (Extract first letter of each word)
- vlookup formula
- Re: Count the number of AutoFiltered records
- Re: Conditional format issue
- From: Rick Rothstein \(MVP - VB\)
- Re: Finding the last entry in a column based on criteria
- Re: Keyboard Shortcut for Drop Down List
- Conditional format issue
- Re: Formula VLOOKUP I think
- Re: how do i sort an excel spreadsheet by column
- Re: Year & Month format
- Re: Count the number of AutoFiltered records
- Re: Formula VLOOKUP I think
- Working with the forms in different workbooks...
- Re: Data inputting question
- Re: Can you save 1 sheet from a large file into another file?
- Re: How to show original comment in cell when using Vlookup in Exc
- Re: complicated excel formula
- Re: Formula VLOOKUP I think
- Re: complicated excel formula
- Re: (V)LOOKUP question
- Re: Returning a Cell Value
- Re: complicated excel formula
- Formula VLOOKUP I think
- RE: Create Acronym (Extract first letter of each word)
- Re: complicated excel formula
- Re: Validation look-up lists showing in 8 point, too small read easily
- Re: Returning a Cell Value
- Re: Returning a Cell Value
- Re: (V)LOOKUP question
- Re: How to show original comment in cell when using Vlookup in Excel?
- Re: naming cells
- Re: SubTotal function to return number of rows returns only zero
- Re: SubTotal function to return number of rows returns only zero
- Re: SubTotal function to return number of rows returns only zero
- Re: (V)LOOKUP question
- complicated excel formula
- Re: How to show original comment in cell when using Vlookup in Excel?
- (V)LOOKUP question
- Re: naming cells
- Re: Grayed Out Columns
- Re: Date format
- Re: Edit Multiple Cells
- Re: REPORTING unique values
- Re: How can I count the frequency that a number is repeated?
- Re: naming cells
- Re: VLOOKUP
- Re: naming cells
- Different font characteristics in concatenated cell
- Re: Merge data from xcel to word
- Re: Excel color-formatted cells printing in black
- Re: naming cells
- Re: Merge data from xcel to word
- Re: Excel color-formatted cells printing in black
- Re: Count consecutive cells then start over
- Re: conditional format help please
- Re: Can you save 1 sheet from a large file into another file?
- Re: Count consecutive cells then start over
- Re: Count consecutive cells then start over
- Re: Vlookup plus
- Re: Count Blocks of Data
- Re: sorting imported data
- Re: 3 column lookup within range
- Re: not sure how to do a formula
- Re: Count consecutive cells then start over
- RE: Sales Commission Calculation
- Sales Commission Calculation
- Re: Count consecutive cells then start over
- Excel color-formatted cells printing in black
- RE: Create a macro to eliminate certain words from several columns
- Re: Grayed Out Columns
- Re: Create a macro to eliminate certain words from several columns
- Re: Create a macro to eliminate certain words from several columns
- Re: Grayed Out Columns
- RE: Create a macro to eliminate certain words from several columns
- RE: Create Acronym (Extract first letter of each word)
- RE: Create Acronym (Extract first letter of each word)
- Re: Cycle Time if in a Specific Year
- Re: Vlookup DETAILED directions
- Re: Cycle Time if in a Specific Year
- Re: Count consecutive cells then start over
- RE: Create Acronym (Extract first letter of each word)
- RE: Create Acronym (Extract first letter of each word)
- Re: Finding the last entry in a column based on criteria
- Vlookup DETAILED directions
- Re: Can I separate two words in a column?
- Re: Can I separate two words in a column?
- Re: Duplicates Formula
- Re: New to functions. Is this possible???
- Re: Changing the value in a cell (but a bit more complex than that <G>)
- Re: Changing the value in a cell (but a bit more complex than that <G>)
- Re: Selecting data from cells that are 5 rows apart and groung in
- Changing the value in a cell (but a bit more complex than that <G>)
- Re: Selecting data from cells that are 5 rows apart and groung in
- Re: sumif
- Re: Date format
- Re: sumif
- Re: sumif
- Re: Date format
- Re: Count consecutive cells then start over
- Re: Adding a Custom Column based on an existing Column (EXPERT)
- Re: Date format
- Re: Data inputting question
- Re: Date format
- Re: uncombining columns
- Re: Adding a Custom Column based on an existing Column (EXPERT)
- Re: Adding a Custom Column based on an existing Column (EXPERT)
- Date format
- Re: Driving me nuts trying to figure this formula
- Re: Delete a row without dirupting the formulas in the following rows
- Re: How do I select more than one item from a drop down pick list?
- Re: Count names and occurrences
- Re: Adding a Custom Column based on an existing Column (EXPERT)
- Re: Duplicates Formula
- Re: Duplicates Formula
- Re: Splitting the characters in the cell
- Re: Splitting the characters in the cell
- RE: formula
- Re: excel search formula
- Re: WORK HOURS DIFFERENCE BETWEEN TWO DATES
- Re: 3 column lookup within range
- Re: Finding the last entry in a column based on criteria
- Re: Import .csv File Problems
- 3 column lookup within range
- Re: Import .csv File Problems
- RE: Splitting the characters in the cell
- RE: Splitting the characters in the cell
- Re: Edit Multiple Cells
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: Concatenate Question
- Re: Edit Multiple Cells
- Copying data to a different row
- Re: Need help with formula
- RE: calculate formula of another cell
- Re: calculate formula of another cell
- Re: VLOOKUP
- Re: Concatenate Question
- Re: Concatenate Question
- Re: Concatenate Question
- Populate an order form with Data
- Re: Edit Multiple Cells
- Re: Returning an array of unique values?
- Re: Sort Daily Staff sales into Sales BY PERSON for month?
- Re: uncombining columns
- Re: drap copy without increasing the value
- Re: Selecting data from cells that are 5 rows apart and groung in 1 co
- Re: Need help with formula
- Re: Need help with formula
- Re: Drag Copy
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Fun Place
- Re: Find Formula
- Re: Need help with formula
- Re: Find Formula
- Re: uncombining columns
- Need help with formula
- Re: Selecting data from cells that are 5 rows apart and groung in 1 co
- Re: drap copy without increasing the value
- Re: Creating a proprer macro in Excel
- Re: Creating a proprer macro in Excel
- Fun Place
- Re: Get Values from another Worksheet
- Re: Selecting data from cells that are 5 rows apart and groung in 1 co
- Re: Creating a proprer macro in Excel
- From: Derek Upson - Pioneer
- Re: Count names and occurrences
- Re: networkdays function
- Re: Count names and occurrences
- Re: networkdays function
- Re: Count names and occurrences
- Re: networkdays function
- Re: Extracting List of Occurrences
- Re: Returning an array of unique values?
- Re: Driving me nuts trying to figure this formula
- Re: Number Formatting in a concatenated cell
- Re: Number Formatting in a concatenated cell
- Re: Count names and occurrences
- Re: HOW DO I SYNC EXCEL FILES ON A LAPTOP?
- Re: Creating a proprer macro in Excel
- Re: Driving me nuts trying to figure this formula
- Re: networkdays function
- Re: Count names and occurrences
- Re: Creating a proprer macro in Excel
- Re: Driving me nuts trying to figure this formula
- Re: Driving me nuts trying to figure this formula
- Re: Driving me nuts trying to figure this formula
- Re: Number Formatting in a concatenated cell
- Re: networkdays function
- Re: Creating a proprer macro in Excel
- From: Derek Upson - Pioneer
- Re: networkdays function
- Re: Count names and occurrences
- Re: Auto fill icon...
- Re: HOW DO I SYNC EXCEL FILES ON A LAPTOP?
- RE: Color cell if spell check finds an error
- RE: Creating a proprer macro in Excel
- Re: How Can i use the cell colors as logical tests?
- Creating a proprer macro in Excel
- From: Derek Upson - Pioneer
- Re: Is solver different between Office versions?
- RE: Need Help..
- RE: Color cell if spell check finds an error
- Re: Combining columns?????
- Re: Using COUNTIF for multiple text data creating a logic statment
- RE: Need Help..
- Re: Sorting "State" Column onto separate worksheets in same workbook.
- Re: Sorting "State" Column onto separate worksheets in same workbook.
- Re: What would Excel Assume if DATE left blank
- Re: DATE() Month in Letter NOT Number
- RE: Adding single cell in multiple worksheet then averaging
- Re: conditional format help please
- Combining columns?????
- Re: What would Excel Assume if DATE left blank
- Re: Identify if a cell contains a numerical string
- Re: How to delete an repeatitive entry from a worksheet
- Re: Returning an array of unique values?
- Re: Show the top three items in a list
- RE: Data Validation Fail
- Re: Identify if a cell contains a numerical string
- Re: DATE() Month in Letter NOT Number
- Re: Return cost with 2 criteria
- Re: Date Question
- Re: conditional format help please
- Re: conditional format help please
- Re: Date Question
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: conditional format help please
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: conditional format help please
- Date Question
- Re: Between one number and another
- Re: Returning an array of unique values?
- Re: Between one number and another
- Re: Between one number and another
- conditional format help please
- Re: Between one number and another
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: "background" formatting possible?
- RE: Data Validation Fail
- Re: Identify if a cell contains a numerical string
- Re: Return cost with 2 criteria
- Identify if a cell contains a numerical string
- Re: Is it possible to save only a specific sheet within a workbook
- Re: Running a macro
- From: Derek Upson - Pioneer
- Re: conditionally format anumber format
- Re: Returning an array of unique values?
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Show the top three items in a list
- Re: Running a macro
- From: Derek Upson - Pioneer
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: conditionally format anumber format
- From: Rick Rothstein \(MVP - VB\)
- Re: conditionally format anumber format
- Re: find all same numbers in a column without dropdown listing
- Re: find all same numbers in a column without dropdown listing
- Re: Capitalize first letter in sentence
- Re: Is it possible to save only a specific sheet within a workbook
- Re: Is it possible to save only a specific sheet within a workbook
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Accumulating Attendance Base upon Age Group
- RE: Is it possible to save only a specific sheet within a workbook
- Running a macro
- From: Derek Upson - Pioneer
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Use Formula to sort two strings
- Re: DATE() Month in Letter NOT Number
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Auto populate data from a table into cells after a match is fo
- Re: Auto populate data from a table into cells after a match is fo
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Auto populate data from a table into cells after a match is fo
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Using COUNTIF for multiple text data creating a logic statment
- Re: Calculating time
- Re: Calculating time
- Re: Auto populate data from a table into cells after a match is found
- Re: Ranking with Duplicates
- Ranking with Duplicates
- Re: Convert numbers to words
- From: Rick Rothstein \(MVP - VB\)
- Re: Returning an array of unique values?
- Re: Autocomplete combo box
- Returning an array of unique values?
- Re: Convert Number to Words
- Re: How to reference a cell depending on the value in another cell??
- Re: Edit Multiple Cells
- Re: Edit Multiple Cells
- Re: How to reference a cell depending on the value in another cell??
- Re: Capitalize first letter in sentence
- Re: Convert Number to Words
- Re: Convert numbers to words
- Re: add file extensions to a column
- Convert numbers to words
- Convert Number to Words
- Re: nested MATCH within Array formula?
- Re: Remove Negative Signs from Formula Results
- Re: Autocomplete combo box
- Re: Remove Negative Signs from Formula Results
- Re: DATE() Month in Letter NOT Number
- Re: DATE() Month in Letter NOT Number
- Re: DATE() Month in Letter NOT Number
- Re: Average & Deviation
- Re: DATE() Month in Letter NOT Number
- Re: DATE() Month in Letter NOT Number
- Re: Remove Negative Signs from Formula Results
- Re: If Then Or Statement
- Re: Editing formula results so zeros appear blank
- Re: Get Values from another Worksheet
- Re: Calculating time
- Re: Edit Multiple Cells
- Re: Calculating time
- Re: Edit Multiple Cells
- Re: Editing formula results so zeros appear blank
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: Editing formula results so zeros appear blank
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: DATE() Month in Letter NOT Number
- Re: Capitalize first letter in sentence
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: Capitalize first letter in sentence
- Re: Extracting List of Occurrences
- Re: DATE() Month in Letter NOT Number
- From: Rick Rothstein \(MVP - VB\)
- Re: add file extensions to a column
- Re: Capitalize first letter in sentence
- Re: DATE() Month in Letter NOT Number
- Re: Extracting List of Occurrences
- Re: DATE() Month in Letter NOT Number
- Re: Extracting List of Occurrences
- Re: DATE() Month in Letter NOT Number
- Re: DATE() Month in Letter NOT Number
- Re: add file extensions to a column
- Re: invalid references
- Re: Leave Cell BLANK if no criteria met
- Re: Leave Cell BLANK if no criteria met
- Re: Capitalize first letter in sentence
- Re: Capitalize first letter in sentence
- Re: Capitalize first letter in sentence
- Re: I have the checkmark beside print gridlines and they won't print
- Re: Capitalize first letter in sentence
- Re: Extracting List of Occurrences
- Re: Capitalize first letter in sentence
- Re: Capitalize first letter in sentence
- Re: Extracting List of Occurrences
- Re: Extracting List of Occurrences
- Re: I have the checkmark beside print gridlines and they won't print
- Re: Capitalize first letter in sentence
- Re: Worksheet tab labels
- Extracting List of Occurrences
- Re: NOT equal to
- Re: I have the checkmark beside print gridlines and they won't print
- Re: NOT equal to
- Re: NOT equal to
- From: Rick Rothstein \(MVP - VB\)
- Re: NOT equal to
- Re: Array or SumProduct or other?
- Re: Explode field
- Re: convert text to number in excel
- Re: Explode field
- From: Rick Rothstein \(MVP - VB\)
- Re: SUMPRODUCT, INDIRECT, dates...
- Re: Worksheet tab labels
- Re: convert text to number in excel
- Re: SUMPRODUCT, INDIRECT, dates...
- Re: reference first cell in a named range
- Re: SUMPRODUCT, INDIRECT, dates...
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Converting a Formula stored as String to real Formula
- Re: Probelm with macro
- Re: Nesting SUMIF with Wildcard
- Re: average(if not working properly
- Re: SUMPRODUCT, INDIRECT, dates...
- Re: What function do i use?
- Re: Worksheet tab labels
- Re: constant date
- Re: Probelm with macro
- Re: reference first cell in a named range
- Re: Converting a Formula stored as String to real Formula
- Re: SUMPRODUCT, INDIRECT, dates...
- Re: reference first cell in a named range
- Re: No. of Saturdays between 2 dates
- Re: Probelm with macro
- reference first cell in a named range
- Re: 6 cell sum
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: Probelm with macro
- Re: referencing a 3D Named Range
- Re: Probelm with macro
- Writing a macro
- Re: No. of Saturdays between 2 dates
- Re: average(if not working properly
- Re: referencing a 3D Named Range
- Re: Nesting SUMIF with Wildcard
- RE: Duplicates in a spread sheet
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Duplicates in a spread sheet
- Re: Accumulating Attendance Base upon Age Group
- Re: average(if not working properly
- Re: No. of Saturdays between 2 dates
- Re: Nesting SUMIF with Wildcard
- RE: "Grouping" based on value in a column
- Re: Worksheet tab labels
- Re: average(if not working properly
- Re: average(if not working properly
- Re: average(if not working properly
- RE: "Grouping" based on value in a column
- Re: Basic Statistics - which function?
- RE: average(if not working properly
- average(if not working properly
- Re: Automatic Drop Down List
- Re: how to sum only specific coloured cells
- Re: how can i write an equation in polar form in excel
- Re: Macro error
- Re: how do i bring back excel sheet ?
- Re: how do i bring back excel sheet ?
- Re: Problem encountered when saving worksheet as a text file
- RE: Converting a Formula stored as String to real Formula
- Converting a Formula stored as String to real Formula
- RE: clear the file now available msgbox
- Re: Problem encountered when saving worksheet as a text file
- Re: Express a Formula that is + or - 20% from a Value Q
- Re: Problem encountered when saving worksheet as a text file
- Re: Express a Formula that is + or - 20% from a Value Q
- Re: Express a Formula that is + or - 20% from a Value Q
- Express a Formula that is + or - 20% from a Value Q
- Problem encountered when saving worksheet as a text file
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: How do i use a 24 hour clock format on my timesheet?
- Re: Autocomplete combo box
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: How do i use a 24 hour clock format on my timesheet?
- From: Rick Rothstein \(MVP - VB\)
- Re: Edit Multiple Cells
- Re: Edit Multiple Cells
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: Edit Multiple Cells
- Re: Edit Multiple Cells
- Re: New version of Excel doesn't show my other worksheets!
- Re: Autocomplete combo box
- Re: Autocomplete combo box
- Re: need a function or property to extract the hyperlink from a cell
- Re: large database with multiple rows
- need a function or property to extract the hyperlink from a cell
- Re: how can i write an equation in polar form in excel
- Adding criteria to loop
- Re: how can i write an equation in polar form in excel
- Re: problem data validation and copy/paste
- RE: Using a macro to paste into first empty row in a new worksheet
- large database with multiple rows
- Re: Can I VLOOKUP in 7 different worksheets in 1 formula?
- Re: autocomplete from specific list
- Re: Count occurences from one worksheet to another with "IF" Crite
- Re: "SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
- Re: "SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
- Re: convert text to number in excel
- Re: problem data validation and copy/paste
- Re: "SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
- Re: convert text to number in excel
- Re: VLOOKUP IF
- Re: Excluding cell in formula
- Re: Excluding cell in formula
- Re: Excluding cell in formula
- Re: Excluding cell in formula
- Re: Basic Statistics - which function?
- Re: Extract part of a text string
- Re: Extract part of a text string
- Re: Extract part of a text string
- Re: Extract part of a text string
- Re: Extract part of a text string
- Re: Extract part of a text string
- Extract part of a text string
- Re: how to I determine frequency
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: Basic Statistics - which function?
- Re: Formula for "counting" numbers - not cells!
- RE: Formula for "counting" numbers - not cells!
- Re: Formula for "counting" numbers - not cells!
- Re: Omitting right part of text string
- Re: autocomplete from specific list
- Basic Statistics - which function?
- Re: autocomplete from specific list
- Re: autocomplete from specific list
- Re: Printing a specific area containing data and not formulas
- Re: custom add formula
- Re: custom add formula
- Re: Count occurences from one worksheet to another with "IF" Criteria
- RE: summarizing data
- Re: custom add formula
- Re: custom add formula
- Re: custom add formula
- Re: custom add formula
- Re: Printing a specific area containing data and not formulas
- Re: change event macro to add cells
- Re: Printing a specific area containing data and not formulas
- Re: Printing a specific area containing data and not formulas
- Re: Omitting right part of text string
- From: Rick Rothstein \(MVP - VB\)
- Re: SUBTOTAL with a condition
- Re: Omitting right part of text string
- Re: how to I determine frequency
- Re: how to I determine frequency
- Re: change event macro to add cells
- Re: Omitting right part of text string
- Re: autocomplete from specific list
- Re: Omitting right part of text string
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel - disable automatic function
- Re: Need hyperlink function to obtain range name from a cell (contents
- Re: Automatic Drop Down List
- Re: autocomplete from specific list
- summarizing data
- Re: change event macro to add cells
- Re: autocomplete from specific list
- Re: autocomplete from specific list
- Re: Automating Worksheet Names
- Re: Accumulating Attendance Base upon Age Group
- Re: Automating Worksheet Names
- Re: Transaction Classifications in Checkbook
- Re: Automating Worksheet Names
- autocomplete from specific list
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: Automating Worksheet Names
- Re: change event macro to add cells
- Re: change event macro to add cells
- Re: Criteria field in dsum formula
- Re: Printing a specific area containing data and not formulas
- Re: Equal formula keeping both content and format
- Re: What is ;
- Re: Auto Populate from a Mater List into Sub Sheets
- Re: change event macro to add cells
- Re: What is ;
- Re: How do I set an average to not count blank cells as zeros?
- Re: Transaction Classifications in Checkbook
- Re: actual/360 and 30/360 amortization?
- Re: open file in current directory
- Re: VLOOKUP
- Re: Accumulating Attendance Base upon Age Group
- open file in current directory
- Re: Transpose and Paste Link
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Accumulating Attendance Base upon Age Group
- Re: Replaced a file but need the old file back
- Re: Wrapping cell data to a new column or page in Excel
- Wrapping cell data to a new column or page in Excel
- Re: Drop Down List Size
- Re: Conditional Proctection?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Replaced a file but need the old file back
- Re: How do you automate cells to poplulate fields in separate workshee
- Re: Using auto-fill to populate a table using data from several tabs
- Re: Upper and Lower Case "within" a formula
- Re: Equal formula keeping both content and format
- Re: Naming working sheets
- Re: Conditional formatting
- Re: How do you automate cells to poplulate fields in separate workshee
- Re: Excel - disable automatic function
- Re: Replaced a file but need the old file back
- Re: Printing a specific area containing data and not formulas
- Re: Custom Functions
- From: Rick Rothstein \(MVP - VB\)
- Re: Embed an array?
- Re: conditional headings
- Re: Help me with a pdf converted into excel
- Re: conditional headings
- Re: "Date Format" v.s. "##/##/####"
- Re: "Date Format" v.s. "##/##/####"
- Re: disable Warnings in Excel
- RE: AUTOMATIC SPELL CHECK
- Re: Macro is not responding
- RE: AUTOMATIC SPELL CHECK
- Re: Using auto-fill to populate a table using data from several tabs
- Re: Function for stopwatch times
- Re: Help me with a pdf converted into excel
- Re: Drop Down menu w/ info in other columns
- Re: Function for stopwatch times
- Re: Bold the number only in a concatenated with text formula...
- RE: Not enough conditional formatting
- Re: Bold the number only in a concatenated with text formula...
- Re: Custom Functions
- Not enough conditional formatting
- Re: Custom Functions
- Re: Custom Functions
- Re: Formula for "counting" numbers - bot cells!
- Re: Formula for "counting" numbers - bot cells!
- Re: how do I tie multiple worksheets to one sheet in Excel?
- col heading help
- Re: match function for 2 values
- Re: How do I average only if data in another column = "X"?
- Re: Formula Error #value
- Re: Formula Error #value
- Re: linking worksheets
- match function for 2 values
- Re: Replaced a file but need the old file back
- Importing into excel PROBLEMS
- Re: Equal formula keeping both content and format
- Re: Equal formula keeping both content and format
- Re: How to repeat cell downwards in a column?
- Re: Embed an array?
- Re: Interpolating Yield Curve
- Re: PLEEEEEASE HELP
- Re: how to use vlooup for date as like
- Re: final return!
- Re: Naming working sheets
- Re: PLEEEEEASE HELP
- Re: actual/360 and 30/360 amortization?
- RE: Excel - disable automatic function
- Re: How do I turn off format painter so it doesn't keep popping up?
- Re: Excel - disable automatic function
- Re: Need Better Examples for VLOOKUP and the like
- Re: final return!
- Re: final return!
- final return!
- Re: index and match closest
- Re: actual/360 and 30/360 amortization?
- Re: How do i consolidate 13 spreadsheets onto one
- Re: Excel - disable automatic function
- Re: Upper and Lower Case "within" a formula
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: Excel
- Re: How do I fix a YMD format?
- Re: How do I turn off format painter so it doesn't keep popping up?
- Re: Conditional formatting
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: SUBTOTAL with a condition
- Re: help with lookup and range
- Re: index and match closest
- Re: transferring data between sheets
- Formula to match 7 columns of non adjacent data
- Re: Excel - disable automatic function
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: Embed an array?
- Re: Embed an array?
- Re: Embed an array?
- Re: Embed an array?
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: Copying data based on filter criteria
- Re: Embed an array?
- Re: Embed an array?
- Re: Embed an array?
- Re: Moving Info from onw sheet to another
- Re: Linking text
- Re: Embed an array?
- Re: Highlight a cell with a specific word in it
- From: Rick Rothstein \(MVP - VB\)
- Re: Embed an array?
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: INDIRECT & SUMPRODUCT QUESTION
- Re: How do I fix a YMD format?
- linking worksheets
- Re: Conditional formatting to test blank text cell
- Re: Long "IF" formula
- Re: Long "IF" formula
- Re: Embed an array?
- Re: Embed an array?
- Re: Long "IF" formula
- Re: Sorting by colors
- Re: Highlight a cell with a specific word in it
- From: Rick Rothstein \(MVP - VB\)
- Re: Highlight a cell with a specific word in it
- Re: Linking text
- Re: Long "IF" formula
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: what do the brackets { } mean around a formula?
- Re: excel 2000
- Re: excel 2000
- Re: Can't see all text in Excel Cell
- Re: How do I modify database criteria at formula level?
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: Moving Info from onw sheet to another
- Re: If Then Or Statement
- From: Rick Rothstein \(MVP - VB\)
- Re: Conditional formatting to test blank text cell
- Re: Moving Info from onw sheet to another
- Re: If Then Or Statement
- Re: Conditional formatting to test blank text cell
- Re: I want to link an Excel cell to a contact record in Outlook
- Re: Auto Copy Text from one work sheet to another
- Re: Moving Info from onw sheet to another
- Re: Missing sum bottom of excel window
- Re: How can I transfer formulas between 2 Excel workbooks?
- Re: SUM odd/even Rows?
- Re: How do you merge worksheets
- Re: Moving Info from onw sheet to another
- Re: Moving Info from onw sheet to another
- RE: Auto Copy Text from one work sheet to another
- Re: How do I modify database criteria at formula level?
- Re: Moving Info from onw sheet to another
- Re: Missing sum bottom of excel window
- Re: Moving Info from onw sheet to another
- Re: Travesing to one cell value based on other cell value!!
- Re: How could I flag a cell. Ex. Cell B is less than Cell A. Flag B
- adding up sheets that arent there yet
- Re: Keeping formulas that reference a tab that changes daily?
- Re: Keeping formulas that reference a tab that changes daily?
- Re: Query equasion for dates
- Re: short cut for inserting rows
- Re: Pivot Tables to summarise a column in one row?
- referencing a 3D Named Range
- Pivot Tables to summarise a column in one row?
- Re: Moving Info from onw sheet to another
- Get data between two values
- Re: remove convert/extract the number from'12345.56; ie remove ' sign
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: range usage question
- Re: Vlookup plus other function/s combinations required?
- Re: Vlookup plus other function/s combinations required?
- Re: calculating probabilty of x number of successes with multiple
- Re: Vlookup plus other function/s combinations required?
- Re: Moving Info from onw sheet to another
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: adding numbers with letters
- Re: How can I count data after I apply a Filter in MS Excel
- Re: Moving Info from onw sheet to another
- Re: Vlookup plus other function/s combinations required?
- Re: range usage question
- Re: adding numbers with letters
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: calculating probabilty of x number of successes with multiple
- Re: SUM odd/even Rows?
- Re: Using INDIRECT
- Re: SUMPRODUCT question
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: Can I get Excel to automatically BOLD dates 30d before expiration?
- Re: Using INDIRECT
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: SUM odd/even Rows?
- Re: SUM odd/even Rows?
- Re: Convert Seconds to Minutes
- From: Rick Rothstein \(MVP - VB\)
- Re: Photos in cells?
- Re: SUM odd/even Rows?
- Re: Photos in cells?
- Re: Using INDIRECT
- Re: Advanced Filter By Cell Contents
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: SumIf Problem...trying to sum multiple columns
- Re: If / And / Or Macro
- Re: Set line color in a spread sheet
- Re: SumIf Problem...trying to sum multiple columns
- Re: SumIf Problem...trying to sum multiple columns
- Re: How can I sort when the worksheet is locked?
- Re: if formula
- Re: I need help with a formula.
- Re: SumIf Problem...trying to sum multiple columns
- Re: SumIf Problem...trying to sum multiple columns
- Re: Formula Help
- Re: Multiple Criteria, Count If, Sum Product to get count across r
- Re: if formula
- Re: Subtotal - Based on DATE
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Subtotal - Based on DATE
- Re: adding numbers with letters
- SumIf Problem...trying to sum multiple columns
- Re: Multiple Criteria, Count If, Sum Product to get count across r
- Re: Excel automatically updates inserted date
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I modify database criteria at formula level?
- Re: Transpose array sum
- Re: Transpose array sum
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: adding numbers with letters
- How do I modify database criteria at formula level?
- Re: Multiple Criteria, Count If, Sum Product to get count across range
- Advanced Filter By Cell Contents
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- RE: Multiple Criteria, Count If, Sum Product to get count across r
- RE: Multiple Criteria, Count If, Sum Product to get count across range
- Re: Not all Functions seem to be on my computer with Excel2003
- Re: how to extract duplicated data from two seperate worksheets?
- Re: Moving Info from onw sheet to another
- Re: excel 2000
- Re: excel 2000
- Re: Can u put an "IF" inside of another "IF"??
- Re: Can u put an "IF" inside of another "IF"??
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- excel 2000
- Re: CSE formula disregard blank cells
- Re: Conditional Formatting =IF($B1>0, TEXT("dddd"))?
- Re: HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE
- Re: Conditional Formatting =IF($B1>0, TEXT("dddd"))?
- Re: how to extract duplicated data from two seperate worksheets?
- RE: index/match or vlookup or similar
- RE: Link from 1 worksheet to 4 different worksheets
- Re: adding numbers with letters
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Conditional Formatting =IF($B1>0, TEXT("dddd"))?
- Re: How do I use moving averages in Excel 2007?
- Re: how to extract duplicated data from two seperate worksheets?
- Re: Moving Info from onw sheet to another
- Re: Confused about setting up functions based on variables?
- Re: Macro is not responding
- Conditional Formatting =IF($B1>0, TEXT("dddd"))?
- Re: how to extract duplicated data from two seperate worksheets?
- Re: IF, AND, OR Function
- Re: Confused about setting up functions based on variables?
- Re: Using INDIRECT
- how to extract duplicated data from two seperate worksheets?
- Re: Macro is not responding
- Re: Using INDIRECT
- Re: Macro is not responding
- Re: Moving Info from onw sheet to another
- Re: auto-complete from a drop down list and from a different workbook
- Re: Moving Info from onw sheet to another
- Re: Moving Info from onw sheet to another
- Re: Using INDIRECT
- Re: can windows vista edit shared document from windows xp
- Re: Convert Seconds to Minutes
- From: Rick Rothstein \(MVP - VB\)
- Re: CSE formula disregard blank cells
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Using the CountIf function with multiple criteria?
- Macro is not responding
- Re: Using the CountIf function with multiple criteria?
- Re: Countif text in individual cells
- Re: Using INDIRECT
- Re: CSE formula disregard blank cells
- From: Rick Rothstein \(MVP - VB\)
- Re: How Do You Stop Annoying Excel Message Boxes?
- auto-complete from a drop down list and from a different workbook
- Re: Using the CountIf function with multiple criteria?
- From: Rick Rothstein \(MVP - VB\)
- RE: Automatically update spreadsheet from another spreadsheet
- Re: Using INDIRECT
- Re: Using INDIRECT
- Re: Using the CountIf function with multiple criteria?
- Re: Using the CountIf function with multiple criteria?
- RE: Automatically update spreadsheet from another spreadsheet
- Re: Moving Info from onw sheet to another
- Re: CSE formula disregard blank cells
- Re: Confused about setting up functions based on variables?
- Re: CSE formula disregard blank cells
- Re: Moving Info from onw sheet to another
- Re: Confused about setting up functions based on variables?
- Re: Opening an .mdb file in Excel
- Re: IF, AND, OR Function
- Re: Using the CountIf function with multiple criteria?
- Re: Days between dates including start day and weekends
- Re: IF, AND, OR Function
- Opening an .mdb file in Excel
- Re: Using INDIRECT
- Re: Using the CountIf function with multiple criteria?
- Re: Convert Seconds to Minutes
- Re: Using the CountIf function with multiple criteria?
- Re: Moving Info from onw sheet to another
- Re: Days between dates including start day and weekends
- Re: Moving Info from onw sheet to another
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- RE: Creating running clocks in multiple cells.
- Re: Query equasion for dates
- Re: vacation formula and 1/2 days
- Re: Convert Seconds to Minutes
- Re: Convert Seconds to Minutes
- index/match or vlookup or similar
- Re: Query equasion for dates
- Re: Using INDIRECT
- Re: Query equasion for dates
- Re: Stop excel rounding my 16/17 digit numbers
- Re: Stop excel rounding my 16/17 digit numbers
- Re: Hyperlink to Named Range Based On Cell Contents
- Re: Using INDIRECT
- Re: copy many sheets into one
- RE: Creating running clocks in multiple cells.
- Re: Photos in cells?
- Re: Query equasion for dates
- Re: Calling AutoFit using macro in XLCALL.h
- Re: Days between dates including start day and weekends
- Re: Dave Peterson
- Re: What is the NNTP for this newsgroup?
- Re: Photos in cells?
- Calling AutoFit using macro in XLCALL.h
- RE: Creating running clocks in multiple cells.
- Re: filter dates by quarter
- Re: Extract everything to the right in cell when a number is encou
- Copy Unique Entries
- Re: vacation formula and 1/2 days
- Re: editing a query
- RE: Creating running clocks in multiple cells.
- Re: adding numbers with letters
- Re: editing a query
- RE: Creating running clocks in multiple cells.
- Re: filter dates by quarter
- calculating and coloring
- Re: YEAR and IF
- Re: Using INDIRECT
- RE: Creating running clocks in multiple cells.
- Re: Using INDIRECT
- Re: Photos in cells?
- RE: link data to worksheets
- Re: Extract everything to the right in cell when a number is encounter
- Re: Working with worksheets
- Re: Creating running clocks in multiple cells.
- Re: Working with worksheets
- Using INDIRECT
- Re: nahrum@hotmail.com
- Re: What is the NNTP for this newsgroup?
- nahrum@hotmail.com
- Re: What is the NNTP for this newsgroup?
- Re: Working with worksheets
- Re: VBA to reattempt to open if file is read only
- Re: VBA to reattempt to open if file is read only
- Re: Working with worksheets
- Re: VBA to reattempt to open if file is read only
- Re: MAX formula?
- RE: VBA to reattempt to open if file is read only
- Re: Created IF functions - Need sum of results
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Created IF functions - Need sum of results
- Re: Function for visible cells only
- Re: If statement when two cells are the same
- Re: Created IF functions - Need sum of results
- Re: Photos in cells?
- Re: Photos in cells?
- Re: calculating probabilty of x number of successes with multiple tria
- Function for visible cells only
- Re: calculating probabilty of x number of successes with multiple
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: lookup function, I need hlep
- Re: Dave Peterson
- Re: MAX formula?
- Re: lookup function, I need hlep
- Dave Peterson
- Re: Created IF functions - Need sum of results
- Re: vlookup on first occurrence of X after Y?
- RE: vlookup on first occurrence of X after Y?
- #VALUE & #DIV0
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: calculating probabilty of x number of successes with multiple tria
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: IF, Then
- Re: vlookup on first occurrence of X after Y?
- Re: What is the NNTP for this newsgroup?
- vlookup on first occurrence of X after Y?
- Re: copying data to different worksheets in the same workbook
- Re: Excel Formula Question
- Re: Running Sum question
- Re: Figuring Late Payment on Mortgage
- Re: Opening a file stops a Macro
- Re: adding numbers with letters
- Re: adding numbers with letters
- copying data to different worksheets in the same workbook
- Re: RANK without a tie
- Re: RANK without a tie
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Index Function
- Re: Running Sum question
- Re: Selecting from drop down list enters multiple cell data
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Opening a file stops a Macro
- Opening a file stops a Macro
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- Re: Sumif / Countif - Not certain - want to extract data from cell
- RE: Selecting from drop down list enters multiple cell data
- Re: adding numbers with letters
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: formula for counting the occurence of more than one condition
- Re: IF, Then
- Re: Count all "Z" in a Range
- Selecting from drop down list enters multiple cell data
- RE: Running Sum question
- Re: Count all "Z" in a Range
- RE: Running Sum question
- Re: Column List to Multiple Columns
- Re: formula for counting the occurence of more than one condition
- Re: How do I Hi- lite the max of last 20 entries
- From: Rick Rothstein \(MVP - VB\)
- Re: Count all "Z" in a Range
- RE: link data to worksheets
- RE: Extracting data from hyperlinked spreadsheets
- Re: How do I Hi- lite the max of last 20 entries
- Re: Column List to Multiple Columns
- From: Rick Rothstein \(MVP - VB\)
- Re: Hyperlink
- Re: Column List to Multiple Columns
- Re: Create a Command Button to Send E-Mails to selected recipients
- Re: Column List to Multiple Columns
- Re: Some text won't print from my worksheet
- RE: calculating probabilty of x number of successes with multiple
- Index Function
- Re: Hyperlink
- Re: Where are the add-ins
- Re: How do I change a file displayed in thousands to millions?
- RE: calculating probabilty of x number of successes with multiple
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: How do I change a file displayed in thousands to millions?
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Column List to Multiple Columns
- RE: calculating probabilty of x number of successes with multiple
- Re: adding numbers with letters
- From: Rick Rothstein \(MVP - VB\)
- RE: calculating probabilty of x number of successes with multiple tria
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Using INDEX and it Returns a #N/A
- Re: How do I Hi- lite the max of last 20 entries
- From: Rick Rothstein \(MVP - VB\)
- Re: How Do You Stop Annoying Excel Message Boxes?
- Column List to Multiple Columns
- Re: Pivot Table Source
- adding numbers with letters
- Re: Pivot Table Source
- Re: Percentage function
- Re: Excel 2007 Vlookup Using New Table Syntax
- Re: First working day of the month
- Re: First working day of the month
- Re: Pivot Table Source
- Re: Photos in cells?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Can function be applied to range in sumif prior to criteria check?
- Re: Can function be applied to range in sumif prior to criteria check?
- Re: Obtain row number of active cell
- RE: Obtain row number of active cell
- RE: Obtain row number of active cell
- RE: Obtain row number of active cell
- Macro to change time format....
- Re: SUMIF <>
- Re: Tables in Excel Spreadsheets
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Percentage function
- Re: Making Cells Mandatory and Running Checks
- Re: Photos in cells?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: View Values Formula is using?
- Re: Auto Capital Letter in a cell
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Count Products
- Re: How do I Hi- lite the max of last 20 entries
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Photos in cells?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Identify the row with specific criteria
- Re: Calculating quarterly investment returns---XIRR or another function??
- RE: Identify the row with specific criteria
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: format a cell
- Re: How do I combine text from adjacent cells?
- Re: IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: format a cell
- Re: How do I combine text from adjacent cells?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Photos in cells?
- Re: Sum of digits in a number
- Photos in cells?
- Re: Sum of digits in a number
- Re: Sum of digits in a number
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Percentage function
- Re: Can't see all text in Excel Cell
- Re: Percentage function
- Re: Percentage function
- Re: Excel 2007 Vlookup Using New Table Syntax
- Excel 2007 Vlookup Using New Table Syntax
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: IF statements
- From: Rick Rothstein \(MVP - VB\)
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Variabilize File Path or File Name in SumProduct (and Vlookup too)
- RE: If not, then populate.
- Re: AutoFit function
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Date Calcuation with Blank Cells
- Re: Date Calcuation with Blank Cells
- Re: Date Calcuation with Blank Cells
- Re: Greater Than formula
- Re: Greater Than formula
- Re: Greater Than formula
- AutoFit function
- Re: Greater Than formula
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: how touse features:enter, tab etc while typing text in excel cell
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Autofill in Various Tabs
- Re: how touse features:enter, tab etc while typing text in excel cell
- Re: In Excel how to make changes that be repeated in the other spread.
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: View Values Formula is using?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Label template for Excel in Avery size 8160?
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: Calculating quarterly investment returns---XIRR or another function??
- Re: How Do You Stop Annoying Excel Message Boxes?
- RE: Incorporating the first 40 out of 250 rows in column values
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: View Values Formula is using?
- Re: View Values Formula is using?
- Re: View Values Formula is using?
- Re: Excel data sort
- Re: Conditional statements
- Re: How Do You Stop Annoying Excel Message Boxes?
- Re: Highlight automatically a specific cell
- Re: View Values Formula is using?
- From: Rick Rothstein \(MVP - VB\)
- Re: View Values Formula is using?
- Re: Formula
- RE: View Values Formula is using?
- View Values Formula is using?
- Re: Trying to get total mileage for a specific month
- Re: Conditional statements
- Re: Conditional statements
- Re: Formula
- Re: HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE
- RE: Identify the row with specific criteria
- Re: Conditional statements
- Re: Formula
- Re: Import .csv File Problems
- Re: Formula
- Calculating quarterly investment returns---XIRR or another function??
- Re: Conditional statements
- Re: Conditional statements
- Re: Formula
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: worksheet to worksheet subtotals
- Re: adding subtotals from several worksheets
- Re: Formula
- Re: How Do You Stop Annoying Excel Message Boxes?
- RE: Identify the row with specific criteria
- Re: How do I set an average to not count blank cells as zeros?
- Re: HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE
- From: Rick Rothstein \(MVP - VB\)
- RE: can i avoid repeating rows when adding calculated item in pivo
- RE: Incorporating the first 40 out of 250 rows in column values
- Re: adding subtotals from several worksheets
- Re: Trying to get total mileage for a specific month
- Re: How do I set an average to not count blank cells as zeros?
- Re: Trying to get total mileage for a specific month
- Re: How do I set an average to not count blank cells as zeros?
- Re: Making Cells Mandatory and Running Checks
- Re: Making Cells Mandatory and Running Checks
- Re: Trying to get total mileage for a specific month
- Re: Trying to get total mileage for a specific month
- Re: If Formula question Excel 2003
- Re: Annuities
- How Do You Stop Annoying Excel Message Boxes?
- Re: Nest SumIf
- From: nybaseball22@xxxxxxxxx
- Re: Nest SumIf
- From: nybaseball22@xxxxxxxxx
- Nest SumIf
- From: nybaseball22@xxxxxxxxx
- Re: Help on data style issues....
- Re: "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4
- Re: worksheet to worksheet subtotals
- Re: Formula Help Please
- Re: "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4
- Re: Formula Help Please
- Re: Excel Formula Error
- Re: Formula Help Please
- Re: "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4
- Re: "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4
- Re: Formula Help Please
- Re: Excel Formula Error
- From: Rick Rothstein \(MVP - VB\)
- Re: lookups
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: Formula Help Please
- Re: Excel Formula Error
- From: Rick Rothstein \(MVP - VB\)
- Re: want to use a barcode scanner in excell need formula "if" "then" ?
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: Formula Help Please
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: Excel Formula Error
- Re: Formula Help Please
- Re: Default Number Format for all Worksheets
- Re: Default Number Format for all WEorksheets
- Re: How do I use a cell value as a parameter
- Re: Formula Help Please
- Re: Cell Equality
- Re: Formula Help Please
- Re: How do I use a cell value as a parameter
- Re: How do I use a cell value as a parameter
- Re: How do I use a cell value as a parameter
- Re: How do I use a cell value as a parameter
- Re: Annuities
- Re: Annuities
- How do I use a cell value as a parameter
- Re: Import .csv File Problems
- RE: Table with complex calculations
- Re: Formula to Sum cells below a target call
- Re: want to use a barcode scanner in excell need formula "if" "then" ?
- Re: Formula Help Please
- RE: Table with complex calculations
- Re: Formula Help Please
- Re: How to time-limit an Excel file installation
- Re: Default Number Format for all WEorksheets
- Re: How to time-limit an Excel file installation
- Re: Formula to Sum cells below a target call
- Re: Formula to Sum cells below a target call
- Re: worksheet help
- Formula to Sum cells below a target call
- worksheet help
- Re: If Formula question Excel 2003
- Re: If Formula question Excel 2003
- Re: If Formula question Excel 2003
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: countif column d equals x and column a noblank
- Re: countif column d equals x and column a noblank
- Re: countif column d equals x and column a noblank
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Pivot Table Sales Projections column
- Re: Default Number Format for all WEorksheets
- RE: Conditional Formatting based on top values
- Re: Dragging Cell References/Formulas
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: how to link two worksheet with different criteria
- Re: Fix EXACT function so it always compares in the same row.
- Re: how to link two worksheet with different criteria
- Re: HOW DO I SET UP AN IF STATEMENT THAT WILL UPDATE MONTHLY
- Re: Interpolating Yield Curve
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: auto compute
- Re: Type once and the info goes into other cells
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Type once and the info goes into other cells
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Formula Help Please
- Re: Formula Help Please
- Re: Type once and the info goes into other cells
- Re: Formula Help Please
- Re: increase serial number
- RE: Formula Help Please
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Formula Help Please
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Fix EXACT function so it always compares in the same row.
- Re: Interpolating Yield Curve
- Re: Fix EXACT function so it always compares in the same row.
- Re: Pivot Table Sales Projections column
- Re: Keeping Adjacent Columns Attached to a Pivot Table
- Re: total amounts acquired through formula's referencing other sheet
- Re: HOW DO I SET UP AN IF STATEMENT THAT WILL UPDATE MONTHLY
- Re: How to time-limit an Excel file installation
- RE: Combine data
- Re: How to time-limit an Excel file installation
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Sumif / Countif - Not certain - want to extract data from cell
- Re: Is it possible to lock-in or freeze formatting?
- Re: IF HELP
- Re: Sumif / Countif - Not certain - want to extract data from cell and
- Re: Sumif / Countif - Not certain - want to extract data from cell and
- Re: Conditional Statement
- Re: Named ranged selection problem
- Re: How to time-limit an Excel file installation
- Re: IF HELP
- Re: Is it possible to lock-in or freeze formatting?
- Re: Sumif with 2 ranges & 2 criteria
- Re: forms
- Re: Conditional Statement
- Re: How to apply a bracket to right side of a series of text cells?
- Re: More than 2 IF options
- From: Rick Rothstein \(MVP - VB\)
- Re: No printing of drop down box
- Re: Conditional Statement
- Re: forms
- Re: How to apply a bracket to right side of a series of text cells?
- From: Rick Rothstein \(MVP - VB\)
- Re: forms
- From: Rick Rothstein \(MVP - VB\)
- Re: No printing of drop down box
- RE: Formula Error
- Re: Sumif with 2 ranges & 2 criteria
- Re: Formula Error
- Re: How to apply a bracket to right side of a series of text cells?
- Re: Formula Error
- Re: Formula Error
- Re: Formula Error
- forms
- Re: How to time-limit an Excel file installation
- Re: IF HELP
- REFERENCE ... VLOOKUP ... OFFSET... MATCH?
- Re: Conditional Statement
- Re: IF HELP
- Re: Auto Filter - Calculating Median
- Re: More than 2 IF options
- Re: More than 2 IF options
- Pivot Table Sales Projections column
- Re: Pivot table calculated field error
- Re: Function to use...
- Re: IF HELP
- Re: IF HELP
- Re: Conditional Statement
- RE: calculation property error in 2007
- Pivot table calculated field error
- Re: What function to use?
- Re: Function to use...
- Re: Blank cells: ISBLANK = FALSE, ISTEXT = TRUE
- Re: What function to use?
- Re: What function to use?
- Re: Holiday and sick leave records
- RE: Sum all Values in a changing Column
- RE: calculation property error in 2007
- Re: Tables in Excel Spreadsheets
- Re: filtering a spreadsheet
- Re: Visual Basic Editor - Time and Date Entry Continued
- Holiday and sick leave records
- Re: increase serial number
- Re: VLookup with multiple conditions
- RE: VLookup with multiple conditions
- Re: VLookup with multiple conditions
- RE: VLookup with multiple conditions
- Re: increase serial number
- Re: Average of multiple range with error values
- Re: VLookup with multiple conditions
- Re: Use Combo Box value to determine macro used
- Re: Average of multiple range with error values
- Re: Dragging Cell References/Formulas
- Use Combo Box value to determine macro used
- VLookup with multiple conditions
- Re: Average of multiple range with error values
- Date Entry error In Microsoft Excel 2000
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Average of multiple range with error values
- Re: Blank cells: ISBLANK = FALSE, ISTEXT = TRUE
- Re: Formula based on formatting?
- Re: Blank cells: ISBLANK = FALSE, ISTEXT = TRUE
- Re: Average of multiple range with error values
- Blank cells: ISBLANK = FALSE, ISTEXT = TRUE
- Average of multiple range with error values
- Re: Excel2003 - Automatically sum a variable number of rows
- Re: Excel2003 - Automatically sum a variable number of rows
- Re: Excel2003 - Automatically sum a variable number of rows
- Re: Excel2003 - Automatically sum a variable number of rows
- Interpolating Yield Curve
- Re: Keeping rows synchronised
- Re: Keeping rows synchronised
- Re: Keeping rows synchronised
- Re: Visual Basic Editor - Time and Date Entry Continued
- Re: Matching name from one worksheet to another
- Re: combining text from separate excel spreadsheets into one spreadshe
- Re: Keeping rows synchronised
- Re: Excel spreadsheet comment boxes keep shrinking smaller than te
- Re: Help Writing Function
- Re: Help Writing Function
- Re: Time and Date Entry Shortcuts?
- Re: Help Writing Function
- Keeping rows synchronised
- RE: How to tell if cell contains a FORMULA or user-entered number?
- Re: Help Writing Function
- RE: calculation property error in 2007
- Re: Computation of total work days
- Re: Help Writing Function
- Re: Matching name from one worksheet to another
- Matching name from one worksheet to another
- Re: Matching name from one worksheet to another
- Re: how to update a worksheet and have data copied to another sheet?
- Re: how to update a worksheet and have data copied to another sheet?
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: VBA? Function? Not sure...
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: editing a query
- Re: editing a query
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: fill color not displaying in preview or print
- Re: fill color not displaying in preview or print
- Re: Time
- Re: Excel Formulars
- Re: Calculation with Decimal
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Combining IF, ANd and SUM functions in a formula
- Re: Columns to Rows
- Re: fill color not displaying in preview or print
- Re: Conditional Statement
- Re: SUMPRODUCT with Date() -60
- Re: sorting lists
- Re: Pivot table: Most recent price for an item?
- Re: Excel Formulars
- Re: Time
- Re: SUMIF & INDIRECT problems
- Re: sorting lists
- Re: Conditional Statement
- Re: sorting lists
- Re: SUMPRODUCT with Date() -60
- Re: separate text string
- Re: separate text string
- Re: Calculation with Decimal
- Re: Unable to get a correct total when changing data within a formula
- Re: Convert a number to a text string
- Re: Pivot table: Most recent price for an item?
- Re: Time
- Re: Calculation with Decimal
- Re: tab names
- Re: Lookup function
- Re: Pivot table: Most recent price for an item?
- Re: Lookup function
- RE: Lookup function
- Re: How to time-limit an Excel file installation
- Re: Convert a number to a text string
- Pivot table: Most recent price for an item?
- Re: How to time-limit an Excel file installation
- Re: SUMIF & INDIRECT problems
- Re: how to sum, if column name is F02 and row name is Federal
- RE: Vlookup where table array is in text format
- Re: Condtional Formatting
- Convert a number to a text string
- RE: Vlookup where table array is in text format
- RE: How to tell if cell contains a FORMULA or user-entered number?
- Re: Sum all Values in a changing Column
- Re: SUMIF & INDIRECT problems
- Re: installing XIRR
- Re: How can I change the size of a cell and hide what is in the cell?
- Re: installing XIRR
- RE: Copying between Worksheets
- Re: installing XIRR
- Re: How to search a worksheet for text-value matches?
- RE: Sum all Values in a changing Column
- Re: installing XIRR
- Re: Subtracting more than 24 hours from a Date/Time
- Re: Calculation with Decimal
- Re: SUMIF & INDIRECT problems
- RE: Sum all Values in a changing Column
- Re: Time and Date Entry Shortcuts?
- Re: separate text string
- installing XIRR
- RE: Sum all Values in a changing Column
- Re: SUMDIVISION formula function - does it exist?
- RE: Sum all Values in a changing Column
- Re: Time formulas
- Re: Conditional Formatting based on top values
- Re: Subtracting more than 24 hours from a Date/Time
- RE: apr to apy
- Re: VLOOKUP with date as an argument
- Re: SUMDIVISION formula function - does it exist?
- Re: SUMIF & INDIRECT problems
- Re: macro comand question
- Re: SUMIF & INDIRECT problems
- RE: Sum all Values in a changing Column
- SUMIF & INDIRECT problems
- Re: SUMIF / IF
- RE: HOW TO WEED OUT DUPLICATES IN AN EXCELL DATABASE
- Re: Convert textfiles into excel
- Re: negative time input
- RE: How to change a reference when the sheet change the folder?
- Re: SUMIF / IF
- RE: Sum all Values in a changing Column
- RE: Sum all Values in a changing Column
- RE: Sum all Values in a changing Column
- Re: Condtional Formatting
- Re: Dont want #DIV/0!.
- Re: Dont want #DIV/0!.
- Re: Differnce function and argument for amounts in adjacent cells
- Re: negative time input
- Re: hyperlink - clicking on hyper link to select cell in another sheet
- Re: Columns to Rows
- Re: hyperlink - clicking on hyper link to select cell in another sheet
- From: Aaron Hodson \(Coversure\)
- Re: negative time input
- Re: Differnce function and argument for amounts in adjacent cells
- Re: Excel spreadsheet comment boxes keep shrinking smaller than te
- Re: Differnce function and argument for amounts in adjacent cells
- Re: hyperlink - clicking on hyper link to select cell in another sheet
- Re: Data Validation Conditional Formatting....or both?
- Re: How to maintain references when copying lookup formula
- RE: Copying between Worksheets
- RE: Copying between Worksheets
- Re: Conditional formattig
- Conditional formattig
- hyperlink - clicking on hyper link to select cell in another sheet
- From: Aaron Hodson \(Coversure\)
- RE: How to maintain references when copying lookup formula
- How to maintain references when copying lookup formula
- Re: 2 Sum Problem
- From: Rick Rothstein \(MVP - VB\)
- Re: excel - rows repeat on top
- Re: lookup 2 columns
- RE: Copying between Worksheets
- Re: lookup 2 columns
- Re: How can I count specific words found across multiple spreadsheets.
- Re: List Creation from Static tab
- Re: lookup 2 columns
- lookup 2 columns
- Re: SUMDIVISION formula function - does it exist?
- Re: Slow validation
- RE: 3 text lookup tables use to define contents of a cell
- Re: Time formulas
- Re: vlookup with a range result
- Re: SUMDIVISION formula function - does it exist?
- RE: How can I count specific words found across multiple spreadshe
- Tab variable
- RE: 3 text lookup tables use to define contents of a cell
- Re: Is it possible to lock-in or freeze formatting?
- Re: SUMDIVISION formula function - does it exist?
- Re: Creating an Index
- VBA? Function? Not sure...
- RE: 3 text lookup tables use to define contents of a cell
- SUMDIVISION formula function - does it exist?
- Re: Formula to calc. semi-annual int. only pmt. with balloon in 10 yr
- Re: List Creation from Static tab
- RE: How can I count specific words found across multiple spreadsheets.
- Re: Condtional Formatting
- Re: vlookup with a range result
- Re: Can SUMIFS use the OR function?
- Re: Use FIND for / or \ or -
- Re: List Box - For Input Range can I use named range in another workbo
- Re: Worksheet tab labels
- Re: Sort sheet based on particuilar sort order
- Re: Changing text dates to date serial numbers
- Re: Adjusted for inflation wages?
- Re: Changing text dates to date serial numbers
- Re: Changing text dates to date serial numbers
- RE: Can SUMIFS use the OR function?
- RE: Sort sheet based on particuilar sort order
- RE: List Creation from Static tab
- Re: always visable header row
- Re: Changing text dates to date serial numbers
- Re: vlookup with a range result
- Re: Use FIND for / or \ or -
- From: Rick Rothstein \(MVP - VB\)
- RE: Copying between Worksheets
- Re: Adjusted for inflation wages?
- Re: Creating an Index
- Re: always visable header row
- Re: Excel function, incrementing value
- Re: Adjusted for inflation wages?
- Re: Creating an Index
- Re: Creating an Index
- Re: Excel function, incrementing value
- Re: Adjusted for inflation wages?
- RE: Creating an Index
- Creating an Index
- Re: Use FIND for / or \ or -
- Re: Adjusted for inflation wages?
- Re: Excel function, incrementing value
- Re: Excel function, incrementing value
- Re: Excel function, incrementing value
- Re: Multiple conditions for one function
- Re: business day date from a specific date based on a number of days
- Re: Use FIND for / or \ or -
- Re: Excel function, incrementing value
- Excel function, incrementing value
- Re: Multiple conditions for one function
- Re: sorting numbers with decimal points
- Re: negative time input
- Re: In Excel how do you clear data without losing a formula?
- Re: subtracting time
- RE: Copy picture and paste hyperlink
- Re: Multiple conditions for one function
- RE: subtracting time
- Re: Adjusted for inflation wages?
- Re: Can SUMIFS use the OR function?
- RE: Can SUMIFS use the OR function?
- RE: List Creation from Static tab
- Re: subtracting time
- RE: List Creation from Static tab
- Re: Adjusted for inflation wages?
- Re: Dragging Cell References/Formulas
- Re: Adjusted for inflation wages?
- Re: Dragging Cell References/Formulas
- Re: Dragging Cell References/Formulas
- Re: Adjusted for inflation wages?
- Re: Adjusted for inflation wages?
- Re: Develop formula for cash flow
- Adjusted for inflation wages?
- Dragging Cell References/Formulas
- Re: subtracting time
- Re: Condtional Formatting
- Re: Excel spreadsheet comment boxes keep shrinking smaller than text.
- Re: Stopping reference following when rows are inserted.
- Re: using a cell's reference to return a value.
- Re: using a cell's reference to return a value.
- Re: Condtional Formatting
- Re: using a cell's reference to return a value.
- using a cell's reference to return a value.
- Re: how to link two worksheet with different criteria
- Re: Using MATCH
- Re: need help :D
- Re: No range option in format control for combo box
- Re: need help :D
- Re: Cell Validation
- Re: Calculate value at the end of nth year using CAGR
- Re: Stopping reference following when rows are inserted.
- Re: Calculate value at the end of nth year using CAGR
- RE: Send active workbook as attachment via hyperlink
- RE: creating cheque printing
- Re: date formula returns the 15th or the end of month
- Re: date formula returns the 15th or the end of month
- From: Rick Rothstein \(MVP - VB\)
- Re: Worksheet & Formula Help Please!!
- Re: date formula returns the 15th or the end of month
- Re: date formula returns the 15th or the end of month
- Re: date formula returns the 15th or the end of month
- Re: date formula returns the 15th or the end of month
- Re: date formula returns the 15th or the end of month
- From: Rick Rothstein \(MVP - VB\)
- Re: Time difference calculation question
- date formula returns the 15th or the end of month
- Time difference calculation question
- creating cheque printing
- Re: Referencing a Cell
- RE: Worksheet & Formula Help Please!!
- RE: Worksheet & Formula Help Please!!
- RE: Worksheet & Formula Help Please!!
- Re: need help :D
- Re: Condtional Formatting
- Re: In Excel how do you clear data without losing a formula?
- Re: In Excel how do you clear data without losing a formula?
- Re: how to convert number in figures to words in excel?
- Re: Referencing a Cell
- Re: Referencing a Cell
- Re: need help :D
- Re: Condtional Formatting
- Re: Date function
- Re: Date function
- From: Rick Rothstein \(MVP - VB\)
- Re: Date function
- Referencing a Cell
- Re: Date function
- Re: Date function
- From: Rick Rothstein \(MVP - VB\)
- Re: Date function
- Re: Date function
- From: Rick Rothstein \(MVP - VB\)
- Re: Date function
- From: Rick Rothstein \(MVP - VB\)
- Re: Date function
- Re: Date function
- Re: some kind of IF or lookup???
- Re: Date function
- Re: Date function
- Re: Date function
- Re: COUNTING BASED ON CONDITIONAL FORMAT?
- Re: some kind of IF or lookup???
- Re: some kind of IF or lookup???
- Re: How do I find age in years from anniversary date (Age funtion)?
- Re: how do i set up a debit and credit formula on the worksheet
- How do I find age in years from anniversary date (Age funtion)?
- Re: how do i set up a debit and credit formula on the worksheet
- VB
- Re: need help :D
- Re: how to link two worksheet with different criteria
- Re: Slow validation
- Re: how to link two worksheet with different criteria
- Re: Repeat a formula with interval
- Re: Formatting cell
- Re: Repeat a formula with interval
- Re: Formatting cell
- Re: Formatting cell
- RE: Using names, and related information, in a Pivot Table?
- Re: Formatting cell
- Re: Formula for Negative Values - ?
- Re: Detect strings in a range
- Re: Repeat a formula with interval
- Re: Help Required
- Re: Formatting cell
- Re: Repeat a formula with interval
- Re: Repeat a formula with interval
- Re: COUNTING BASED ON CONDITIONAL FORMAT?
- Re: COUNTING BASED ON CONDITIONAL FORMAT?
