- Re: SUM a Vlookup Array Formula
- Dependent drop down dynamic range formula, off sheet.
- Re: sum up a column ignoring values coloured red
- Re: Vlookup Match and Index Assistance
- Vlookups not working
- Applicability of LBT
- Formula (or code) return the largest number of duplicates in a list.
- Re: No save function if
- Re: No save function if
- IF function help please?
- How to filter Unique values from Duplicates
- Re: Lock Cell After Data is Entered on Particular Cell
- Arrayformulas with either/or nested to sumproduct if eitherconditions are true
- Selecting rows.
- Re: Invisible typing!!
- Changing Sum Range Based on Date Chosen from Drop Down List
- How to count the maximum number flanked by zeros
- Is it possible to have an image as a background?
- SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel.
- Help With Sorting
- Remove the weekends from a pivot chart x axis
- TRANSPOSE a row to Uneven column
- Re: Complex Filtering Formula
- Re: Help with an Excel formula problem
- Break Total (SUM question)
- Re: Excel gives me false IRR values|How do I find the real IRR on this investment
- Re: Problem with looking up a value.
- Re: If Formula
- Re: Help with an Excel formula problem
- Re: How to sum adjacent cells based on values of each cell?
- COUNT rows on external sheet if between date range
- numbering
- Conditional formatting on a dynamic range - workaround
- Re: SUMIF across multiple sheets
- Re: How to feed master W/S into two
- Re: How to feed master W/S into two
- Re: Can't insert a new worksheet
- Re: Can't insert a new worksheet
- Subtracting based on 2 conditions
- RETURN VALUE OF ROW 1
- Match a UK postcode from a table of postcodes
- min if horizontal
- How do I get Rid of the Circumflex Accent (Caret)
- Upgrade question
- Dynamic col_index_num in VLOOKUP?
- Re: Need a formula which shows the table..
- IF FUNCTION
- Average of Subtotals in Pivot Table
- Workday Formula to include date
- Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that
- Re: Autofill Formulas
- Re: Autofill Formulas
- #N/A In Cells
- Lookup returning wrong results
- SUMIF, 3D FORMULA, EXCEL FORMULA HELP
- ADVANCED: Need to sum values in different worksheets based on a rowand column criteria.
- Return Min & Cell address
- Re: non repeating Random number generation
- Intercept and Slope of visible rows, please.
- Excel Macros help
- Re: How do I update my worksheet? Need Help
- Re: Time Zone Conversions
- Re: What formula would i need for this??
- Different renderings of same pixel heights
- Complex search and replace macro based on input variables.
- change all below or equal to an input number
- Convert Decimal fractions to binary and vice versa
- Weighted average till sum of exposure reaches a threshold
- Really need some help with a multi conditional SumProduct
- Re: difference between two cells
- Calculate focal length from FOV on cameras
- TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS
- Sorting day names chronologically
- Re: return a value of specific text within a sentence
- Delete rows based on contents of Col A
- Check for two sheets. Add or subtract as necessary.
- want to track time while paste value in multiple column of same roe
- Re: Is multiple IF statements what I'm looking for?
- Re: Is multiple IF statements what I'm looking for?
- Re: Count multiple specific terms
- Augmenting an integer in a column to reflect duplicates in another
- Two spreadsheets, filling data from one to the other.
- Is it possible to make Excel assume a time happens after another time?
- How to add straight line from cell value in pivot table chart.
- Re: Cell Auto Lock
- Re: Cell Auto Lock
- worksheet is not open and copy
- Re: Converting formula from Lotus123 to Excel
- hidden rows problem
- Reference the same cell based on tab name
- Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL
- How to enter start and end date/time in excel based on some specific value.
- year cant change
- Re: Index match formula with multiple conditions
- VBA to Filter on variable column
- Finding missorted cell in range
- Drop Down with dynamic named range offsheet source list
- Re: Vlookup an array and report min, max and average as a result
- Find Duplicates in a Schedule (Two fields: Time and ApplicantID)
- Re: Help with sumproduct
- Re: Help with sumproduct
- Sum every Nth Row (almost working)
- Re: Help
- Percentage of month passed formula
- Copy corresponding cell in Column B if cell in A contains certain text?
- Need to get minimum difference
- Making a Sheet copy
- Formula than understands midnight?
- Finding the weighted average of text that have been given values
- Re: Limit drop down items based on another cell
- Re: Countif or other formula needed for multiple data/critera results
- Autofill alphanumeric prefix in Excel
- Re: Countif or other formula needed for multiple data/critera results
- Re: Using multiple Lookup Functions
- add pass and fails
- Transpose Cell Contents
- Date / month / year
- Searching the formula (not the value) for a text string
- Re: Testing the case of text in a cell
- Calculate After hours
- Conditional Formatting Amendment
- Pivot Table with Data Model Connection - getpivotdata reference issue
- Formula to answer YES or No
- How can i put text in a cell depending on colour
- Help With VLOOKUP
- Re: Using =SUM...just can't figure this simple thing out...
- COUNTIFS ?
- Re: how to copy and paste value from one sheet to another
- Re: Lookup or search using the * character
- Re: List items based on the count given
- copying_data_using_FillHandle
- time_report_date-wise_employee-wise
- Problem formatting dates from CSV file
- Hide columns based on row values
- Created invoices in Excel - not working in Drive
- Pivot Table Data Aggregation
- Re: Cells not updated automatically
- Re: IF Statement on multiple levels
- Re: IF Statement on multiple levels
- how to do data validation in excel
- VanillaSoft Changes
- Re: Excel is too complicated for me
- Payment calculation
- Re: Match issue
- SUMIF Help
- Re: VLookup + IF
- SUMPRODUCT formula I think w/ wild card & number vs number as text
- Subtracting time...again
- Re: Adding cells until they are greater than a lookup cell and returning a value
- Re: Excel is too complicated for me
- Re: Excel is too complicated for me
- How to get largest date from a Vlookup
- Re: Sumif apllying to all sheets in workbook
- Returning 1 of 4 values if conditions are met
- Re: Sumif apllying to all sheets in workbook
- Function in Excel to count and list number of entries of text valuesin a row.
- Excel Average dates help
- Expanding Date Formula
- Need to convert an array of numbers to two columns in excel
- PLS HELP ME TO SOLVE THIS PROBLEM
- DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET
- need help on either doing a loop and counting specific values orusing subtotal function
- work hours with different hour prices
- Re: Getting a formula to reflect added columns
- using the =page! feature to transpose a row to column
- Payout based on hours rate and designation
- Simple nested if and statement
- Finding location (or start cell) of highest consecutive values
- Multiple arguments
- IRR of McDonalds expansion plan
- Finding NROI - no return on investment and RONI - return on noinvestment in Excel
- Wotksheets
- SUMIF between 2 dates
- SUMIF between date range
- Re: State Tax Business Calculations Help
- Pasting a range to a single cell
- Excel: counting times and dates during non-traditional hours
- Re: Formula not working properly
- Re: Carry over YTD balance to next worksheet
- Merging cells and formats
- IF formula
- Avoiding auxiliary cells
- add hyperlink using sheet names and cells(i,j)
- Time Sum in Excel
- IF function says too many nested
- Formula to multiply numbers intervals
- Re: XIRR vs. IRR Function
- Syncing between source worksheet and dependent worksheets
- How to update data entry to a linked worksheet and then return thenew value back to a master worksheet?
- Sort Question
- countifs Function not giving desired result with date criteria
- Need a ) somewhere in ISERROR formula but don't know where to put it
- Depedent Dropdown and INDIRECT($P$8) with a twist
- Re: XIRR vs. IRR Function
- calculating average handling time
- Re: Copy 2 cells to 1 cell
- Re: index function
- Conditional formatting dates
- Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell.
- Print on only one page
- Conditional Highlight
- Adding recognised Zeros
- Re: Filtering data
- lookup vaules which are not exist in a table
- Calculate End Date Using Start Date and No. of Days excluding specific days.
- Help with time function
- Re: need help with function
- Sum Values from different column
- Spacing in Column headers
- Re: XIRR vs. IRR Function
- Re: create pull down menu
- search function
- Close all without saving and exit without prompts
- #REF!
- Count columns that meet criterias
- can a cell be both input and output?
- Re: Help with a formula for a Time Sheet.
- Re: How can i find the max value within a time range ased on two cells
- Freeze Panes loss
- Re: How to refer to a criterie in a cell using excel sum.if function
- Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid?
- Re: Protected Sheet - Using Groups without a Macro
- Re: simple but can't make it, delete blank pages?!?!
- Re: Is it Possible?
- Re: Is it Possible?
- Re: Need formula for calculating time
- Re: Is it Possible?
- Creating a template that I can reproduce every month by keying ininformation from SAP
- I NEED HELP
- Re: Merge Name List Within Excel Spreadsheet
- Advanced Filter return blank
- Re: SUMPRODUCT(SUMIF(INDIRECT...returns #N/A
- Nested IF AND OR statement
- Change Color of cell
- excel time function
- I need Time Range to return Value
- vlookup or some other function that counts rows
- Event recognition.
- Drop Downs, Index Match or what?
- Restricting Cell entry to certain letters
- Sports summary sheet - think I put this in wrong place originally
- Sumproduct formula problem
- Conditional Formatting from a group
- Re: What does this mean'=ROUND(((F8/$C$4)*($C$4-E8)),)'
- Re: Data Validation - Custom question (multiple conditions)
- Re: Data Validation - Custom question (multiple conditions)
- Supress DIV/0
- Re: Need countifs forumla to analize in a time range
- Re: IF(OR statement not working
- Re: Finding Duplicate Rows & Highlighting them
- Re: Email?
- drop down box code
- Re: Finding Duplicate Rows & Highlighting them
- Extracting just the time portion
- NETWORKDAYS HELP
- Re: vlookup not working on calculated time
- Re: Month days over a time period
- rows height
- Count range of cells if not next to each other
- Sumproduct not working
- Re: converting number to dollar
- Re: converting number to dollar
- Re: Reconciliation... Again
- Excel help separating /
- Re: Help calculating scaled commissions please
- Re: Formula's to Find/Delete Duplicates from a list
- Re: Formula's to Find/Delete Duplicates from a list
- Tiered Pricing Formulae - is this possible?
- Re: Import multiple photos into excel
- Re: Weighted ranking of a series
- A find formul looking at two named ranges for two strings
- Re: Extracting data/using COUNTIFS
- IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows
- Determining if a number got hit before another
- Multiple Criteria, One Answer
- Re: Basic Statistics
- Re: IF AND Function Date Range Issues
- Re: IF AND Function Date Range Issues
- Peculiar default cell format
- Re: Need help with average/lookup formula
- Re: =substitute
- Re: =substitute
- Want To Shrink Formula
- Avoiding redundant calculations
- Trying to find additional ranges outside of min, max, and average
- Re: What Multiple functions do I need?
- Re: Round Down
- MROUND Help
- Re: COUNTIFS (the numbers in a column, when subtracted meet a certain criteria)
- Re: return multiple values when within range (greater than and less than)
- Re: return multiple values when within range (greater than and less than)
- Application.OnTime
- Re: Vlookup
- Re: trouble with (complicated) vlookup searching another workbook
- Re: trouble with (complicated) vlookup searching another workbook
- Link To File That No Longer Exists
- find out specific month and year
- Search function
- move worksheet to end of another workbook
- Match and delete rows on two different sheets from reference numbers
- SUM Char
- Calculating Average, Count, Min & Max against a range of Values
- What is the "--" (double dash) in MS Excel formula?
- Re: Excel formula help for calculating freight.
- Re: date mismatching
- Re: comparing sheet to sheet and adding value
- Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geometric Series
- Re: Using a Date and corresponding weekday to pull amounts
- Re: File upload
- Re: File upload
- excel copy and paste...
- Complex date VBA - insert a certain weekday
- Re: Unable to identify appropriate formula for very simple scenario
- use month in cell date to sum all relevant cells
- Help with a basic condition
- Delete rows that contain duplicates
- Use & with two formulas
- Re: Excel Formula Issue
- Re: Excel Formula Issue
- Re: Referencing cells in consecutive rows
- #DIV error
- Re: Userform to update rows of data
- Lookup formula of some sort
- Re: Progressive number with Excel then print a unique Pdf file
- Indirect formula errors if file is closed
- Re: Copy text into blank rows
- Re: How do I make #DIV/0! error message go away?
- hyperlink function fails in excel 2010
- Lower-Case Characters
- Re: Find Last instance colum A and return corresponding B Value
- Re: Simple Macros Table Count
- Re: Simple Macros Table Count
- Re: Conditional Formatting help (2003)
- Mapping strings to integers
- adding up time over & under a specified amount
- Re: Alternate Row Shading with Filter
- Convert multiple series into single series
- Re: Vlookup?
- Mapping integers to strings
- Re: Help With Formula for Posting
- Re: Force Distribution/ Force Ranking for Bell Curve
- comapering two sheets in excel 2010
- Re: 3 IFs argument in one formula
- Finding dynamic maxima
- Re: Pulling background color from master to other sheet
- How to record changing value of a cell
- Re: Dragging a formula down isn't working - where am I going wrong?
- Unhide column difficulty
- Re: Searching for text and returning text
- Re: IF Statement Table Help
- finding repeating numerical pattern using array functions?
- Re: Function or Sub to help with text string
- Re: Formula for calculating target hours against actual hours
- Re: Formula for calculating target hours against actual hours
- Questionnaire using Excel
- How do you Combine Two IF formulas
- Re: Macro to change referenced column to the next one
- if and replace function?
- Re: Advanced Drop-down Menu
- Re: Varying cell ranges in formulas according to number of cells with certain value
- Re: Automatically populate value of cell dependent on adajecent cell
- Re: Automatically populate value of cell dependent on adajecent cell
- Formula to add two spaces into a number stored as text
- Re: Generate series according to range and increment
- Re: Dynamic Ranges Adding Extra Row
- CONDITIONAL FORMATTING IN EXCEL 2010
- Re: Text Dates/times to d:hh:mm:ss
- Comparing two lists
- Re: Multiple VLOOKUP lookup values
- Removing #N/A from an "If/Then" statement
- Nameing a function
- Re: Converting a number into a cell reference
- Re: Converting a number into a cell reference
- Pulling From Multiple Sheet
- SUMIF with criteria "<>" & "="
- using duplicate function
- Re: Look up one value and return multiple corresponding values
- Re: Problems with conditional average
- Re: adding a forumla to cells with formula in them already
- Re: Help with an if then scenario
- Re: Excel PMT Function Help
- Re: Conditional Formatting
- Re: Conditional Formatting
- Re: Finding a Name
- Re: problem with time subtraction
- Re: Custom Autonumber with Prefix and Category Grouping
- Re: problem with time subtraction
- Re: Displaying Returns from another worksheet that change?
- weekday last year
- Curly Brackets
- Re: Counting multiple occcurrences between date range
- drag formula down from columns that go acros
- calculating volatility
- separating date and time
- Re: Multiple IF conditions
- Re: How do I combine 2 data sets using date?
- Re: linest internals
- Re: linest internals
- Re: linest internals
- Excel Formula question
- Re: Easter day formula.
- Re: Dividing after a long formula
- Re: Dividing after a long formula
- Re: Lower case date
- Re: If then formula with multiple Ifs
- Formula to tell day of week
- Re: 2 Formulas needed!!! :)
- Re: 2 Formulas needed!!! :)
- Re: Multiple column scroll
- Re: Multiple column scroll
- Help needed regarding calculating time
- Re: Can I disable the Save As Function?
- Sumproduct Help!
- Conditional Time Calculation
- Re: Sort by placement value from left to right & adding trailingzeros for short
- Re: Sort by placement value from left to right & adding trailingzeros for short
- Re: LOOKUP trouble
- Hlookup 3 criteria??
- Formatted cell column in drop down list
- Re: need help in creating a formula
- Re: CheckBox Control Copy and Paste
- Conditional formatting
- Macro to open CSV files
- SUM Q
- Hyperlinks with lookups
- Re: Combing a V Lookup result with ("00"&A2)*1 in same formula
- Financial Time Value of Money calculations
- Re: Needs help combining functions.
- Mick & Clause & Experts Please help me on this issue one more time
- VBA code for Sum and diff
- Gears
- Re: Delete Text in Multiple Cells
- Re: Count Word in long string
- Re: Delete Text in Multiple Cells
- Countifs bites again
- counting repeats.
- Re: Getting sum of values in another sheet while using condition
- Re: Help with lots of formulas
- INDEX return multiple columns
- Sumproduct?
- Re: calculate average values for 100 records in the shortest way?
- Re: Excel Countif Function - Calculating Between Two Sets of Values
- Re: Identifying text in a string
- Re: Identifying text in a string
- Re: Cell Auto Lock After Entering
- Changing Pivot Table Value Field Labels with VBA
- Combining an IF with another formula
- Calculate elapsed time excluding specific timeframe
- Absolute References and worksheets
- Re: Using a vlookup to search multiple criteria for one result?
- Re: Using a vlookup to search multiple criteria for one result?
- Re: Returning a value from a range
- Proprietary text on popup buttons
- Ms Excel Multiple Logical Test Function
- Re: I need a lot of help with MS Excel 2010
- Re: Multiple Columns in Sum Range using SUMIFS
- Numerals conversion
- workbook opens to the same sheet every time not the one it was saved as?
- Get percentage of whole
- New group but no Star to click...?
- Vlookup to reference offset
- Re: Problem using IF statement with dates as part of the formula
- Re: Problem using IF statement with dates as part of the formula
- Ttest across multiple worksheets
- Re: Excel help needed: Skipping cell without skipping cell reference
- Dragging a formula in a column
- Re: Excel 2010 Conditional Formatting
- Re: If Function
- Excel 2010 If Then logic - with time
- Function for summing or counting cells based on a specified fill color
- Go To a Named Range (2nd posting)
- Auto Change Formulas - Please Help.
- Conditional Formatting
- Re: help to remove space before the data
- Limit to MOD function
- Re: Time Calculation
- check value in cell
- Re: help to remove space before the data
- Re: help to remove space before the data
- Re: Index/Match Functions to Return Concatenated Response
- Re: Help with IF Function for times.
- Re: Help with IF Function for times.
- using mid find to either extract a number with 2 decimals or excludeFROM A STRING
- Excel check value i cell
- LINEST multiple known_x's separated arrays
- Re: Counting unique instances of a text string
- Re: Inequalities Function
- Re: Inequalities Function
- Can UDF return a customized hyperlink?
- Re: Excel Function Help
- Re: Why is excel rounding my numbers in VBA?
- Re: Why is excel rounding my numbers in VBA?
- Re: Divide a # into 3 #'s rounded to a whole #
- somewhat complex if statement help PLEASE!!!!
- Re: Divide a # into 3 #'s rounded to a whole #
- How Do I Avoid #REF! In Formulas?
- Re: Define a Range based on Cell Values
- Re: text to number graph
- Re: Variable interest rate loan calculations- PLEASE HELP!!!
- SUMIF "value if false" not working
- Data Validation - Complex Q
- Re: Looking up other sheet for value X depnding on sheet Y and Z colums
- If - Then Fields
- vlookup formatting problem
- product code a value
- Go To a Named Range
- lookup two different variables
- Re: Show value from one cell in another cell if today falls between a date range
- Re: Show value from one cell in another cell if today falls between adate range
- Re: Elementary SUMPRODUCT Question
- Re: Formula to predict future data
- Length cutting optimizer
- Calculating weighted average of Percent Change
- Re: Autosize Merged Cell
- Re: Sum Function has small remainder
- Generating a cut list
- Re: Auto populate date VBA code
- Re: =sum with a filter
- Rounding cents
- Index Match on Columns and Rows
- Re: Sumproduct giving #Value error
- Re: Sorting problem. My header rom is getting sorted with the rest.
- Re: Concatenate cells with line breaks in them
- Re: Year End totals
- Re: Rolling 12 month
- Re: Recurring Items in Spreadsheets
- Copying formulas across columns
- Re: Concatenate cells with line breaks in them
- Numbers in word
- Re: Rolling 12 month
- How Do I Find Different Values In A String?
- Line chart based on 3 columns
- complex sort search and replace macro
- Re: sumproduct
- Re: Can XIRR Work on Dates That Move Backwards in Time?
- Re: Can XIRR Work on Dates That Move Backwards in Time?
- Yes or blank, depending if value equals or exceeds value found inVLookup table.
- CountIf with And
- Re: sumproduct by year
- Percentage Increase
- Re: Help with a running total on multiple sheets
- Re: Vlookup doesn't work: results are wrong
- Macro to concatenate with previous bold cell
- How can I count deviations between two rows?
- multiple SUMIF help/advice
- Formula help needed please
- Re: Control F
- Find partial text and retrun value in corresponding column
- Re: Smoothing Data in Columsns in Excel 2012
- Copying a cell value to another sheet by using If statement
- TIME CALCULATION
- Re: Comparing MONTH and YEAR inside Formula ??
- Re: IF validation for time totaling
- Re: Drop Down List Dependant Formula
- Re: YTD SUMIF based on current date
- Testing a cell value for a specific weekday.
- How to ignore a column of numbers in Grand Total for rows
- COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
- Re: How to calculate time percentage of number of parts being pick in a timeframe
- Copy columns, but not hidden ones
- Can I add a range and then divide that sum by a specific value?
- VLOOKUP, a table with text and numerics
- Re: Lookup in multiple & separate cells
- sum character
- Re: If value between 2 numbers
- Re: If value between 2 numbers
- How to reset excel worksheet form lilstbox and combo box
- Re: Multiplying a Number Found in an Alphanumeric String
- count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
- Re: Antilog
- Re: excel formulas
- 2 dimensional date sort
- Calculate total by row number
- Re: Match/Index/Sum function with date range
- Re: Calendar Logic: Recurring Dates
- Learning arrays.
- Countifs with different restrictions
- Re: Index and match if field contains specific text in it
- Re: *Issue* Concatenate dates in a large range of cells in a row.
- Re: *Issue* Concatenate dates in a large range of cells in a row.
- How do I assign "Apple" to a cell reference in this evaluate code?
- Need help writing VBA module
- NumberFormat for small non-zero numbers?
- NumberFormat instead of an IF
- Re: Replace data to right of string problem
- Re: Replace data to right of string problem
- date & Time
- COUNTING THE SAME VALUES IN A SHEET
- Protect and Edit Object
- sorting noncontiguous data with exceptions
- Re: Matching two columns of data
- Re: Matching two columns of data
- Re: Simplifying multiple IF statements?
- Re: return a value depending on two previous values
- Vlookup and return sheet name also
- Re: Bitwise Functions?
- Re: Identifying common data between 2 cells
- Re: Multiple VLOOKUP in an IF statement
- Re: Evaluate Multiple Cells for any Value
- Re: Multiple VLOOKUP in an IF statement
- Re: Need help finding a substring in a array of strings.
- copying column multiple times
- Re: Validation of cell based on Drop down list
- Return Column Header from an Index/array, finding Large with a userinput date
- Re: Need formulas for searching for a value in a table and returning row/column name
- Re: Using IF, AND and OR functions together
- Re: Need help calculating probabilities
- Re: Month Calculation
- Re: Search Text and Add a Blank Line
- Re: Month Calculation
- Re: Pls Help - blank cell/formula issue
- Re: Help. Trying to do the opposite of VLOOKUP
- names dates & amounts stated multiple times in document
- Re: Help on the Sumif Function
- Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
- Remove punctuation mark, Split cells & average accross column
- Re: Median Formula not working properly
- Help Needed : how do i compute this?
- Re: Copy values for every nth cell
- Re: Date reformatting question
- Countif with two criteria
- Re: Date reformatting question
- Re: Date reformatting question
- Re: Vlookup
- Re: Copy values for every nth cell
- Calculating Future Value
- LOOKUP function??
- Re: Generate 1 or 0 in xls with input probability
- Re: Simple COUNTIF function help
- Re: Help Needed! Using complex IF function
- Convert Number to Text for Index/Match
- Re: Help needed: Minimum value based upon either/or criteria
- Re: Help needed: Minimum value based upon either/or criteria
- Sort column beginning with blank?
- INDEX MATCH SMALL
- Re: Name break into half and reverse to upper case
- Re: help w indirect and index,match
- Re: Please Help! Delete all cells in range except "1934 - 1934"
- Re: how to count rows if 2 columns partially match
- Extract the 2 Lowest %
- Calculating time for 3rd shift
- Computer Properties
- Club Accounts
- Re: Extract Alphabets and Numbers from a Cell
- Re: Possible Sumproduct with Or Function
- preserving zeros in spreadsheet
- Re: coding descriptors
- Re: Extract Alphabets and Numbers from a Cell
- Re: Lookup Value From Sheet2
- range definition by cells numbers
- Logical formatting for multiple values
- Preserving trailing zeros for a fixed width file
- Re: Multiple Criteria Lookup
- Re: Conditional Formatting Formula
- Re: Conditional Formatting Formula
- VLOOKUP return cell location and hyperlink
- Re: Formulas won't function
- Re: Automatically sort alphabetically ignoring header
- Re: need help with Formula
- Re: Simple (maybe) percentage forumla
- Re: percentage calculation
- #value error for sumproduct using RIGHT cmd
- Re: percentage calculation
- Re: Series command grayed out
- Convert number to text as displayed
- Extract first and last login time for each day only
- Add time when working 3rd shift
- Re: help!
- Re: Nested If Statement help
- Re: Detailed Countdown
- Excel 2010,Voice Win7
- Re: Counting cells with SUMPRODUCT and conditionals...?
- Re: help!
- Distribution of capital contribution
- Re: VLookup sum multiple matches
- Re: Vlookup Returning Zero For Every Cell
- Re: Vlookup a subtotal
- Re: Display next available number
- Re: Vlookup Returning Zero For Every Cell
- Show latest date
- Re: Search for string based on two columns
- Re: Help with complex IF statement
- Re: Return a value if a range of cells contain text
- Re: Search a range for instances of a text string, return neighboringcell values each ti
- Extract Date formula Only
- Re: Complex Lookups
- Re: Complex Lookups
- Re: Problem with formula for finding last greater than/less thanor equal to value
- Re: Unable to nest my IF statements properly
- Re: Problem with formula for finding last greater than/less than orequal to value
- Calculating aggregate donation sums for a list of names
- Re: Unable to nest my IF statements properly
- Return the value from one range that does not exist in another
- Re: Complex Lookups
- Re: Using IF and VLOOKUP for range of cells
- Re: Using IF and VLOOKUP for range of cells
- Re: Using IF and VLOOKUP for range of cells
- Re: Using IF and VLOOKUP for range of cells
- Re: display Column Header based on cell value in a range
- Wage Calculator Q
- Re: Calculating days spent to complete a task
- Re: Deriving several lists from a master list
- Re: Deriving several lists from a master list
- Re: Sum of values in column A based on 0/1 of column B
- Re: How to calculate difference between two date & time along withworking hours and days
- Re: How to calculate difference between two date & time along with working hours and days
- Display data for rows where cell consists of whole number
- Re: Trying to count based on multiple criteria & cell comparisons
- Re: Trying to count based on multiple criteria & cell comparisons
- Compare 2 lists and return value
- Help! Is this possible
- Excel time leading 1st ZERO
- Solve for a number (x)
- Sorting by frequency
- Re: Urgent help with Excel formula. Please please help
- Re: Findiing highest and lowest in rows and columns
- Re: Findiing highest and lowest in rows and columns
- Re: Making data in appear in one worksheet from another
- Re: Conditional concatenating!!!
- Command Button to create a folder
- Re: Joining VLookups with line breaks but ignoring blanks
- conditional formatting update issue
- Re: Compressing multiple functions across an array into one cell
- Re: Multiple Nested If Function
- Re: Multiple Nested If Function
- Re: Multiple Nested If Function
- Re: One lookup option
- Re: Function to Combine Names and Middle Initital In Various Formats
- putting number against certain words formula
- Re: Countif year = help needed
- Solver Compiler issue
- Re: Conditional Formatting discarding zeros
- Re: Sum of Variable Cells in a fixed Row
- Re: Sum of Variable Cells in a fixed Row
- Re: Help in Median of a quartile
- Re: Index Match function for lookup HELP
- Re: Index Match function for lookup HELP
- Re: How do I convert cubic feet to cubic meters?
- Re: VLOOKUP Help
- Re: Lookup function to return highest value
- Re: Totaling Categories - Monthly and YTD
- Re: consolidation data in one row
- Re: consolidation data in one row
- Re: Excel Template required for Daily managing daily income andexpense at Mobile shop
- Re: 12 columns by 8 rows to one row
- Array formula lock-up
- Re: Use an "OR" around nested IF statements
- Re: Use an "OR" around nested IF statements
- Re: calulation
- Re: Help with count/sumif