- Index-match for data on mulitple rows
- Simple SUM problem
- Reset ack. values at certain points
- Check if a cell is a date
- Problems that needs to be solved using Excel.
- Palindromic Problems! Please Help!
- COUNT non zero cols in a row (non-contiguous cols)?
- Vlookup help
- Macro Help - Opening Book
- function - data sheet1 that I would like to copy to Sheet2
- Loop formula
- Search Values Between 2 Dates
- Transposing in a big way
- How to read long ways and sideways
- Transfer data from a workbook to another one
- Conditional Average help
- Matching text from separate columns...
- Column containing positive and negative values
- worksheet function help...
- Function for suggested order
- SUMIF to include several conditions?
- Calculating Rate of Pay and displaying
- List A, List B, List C - All possible combinations
- Count if numbers in cell to left
- Formula Referencing another cell
- Pasting a series with Index()
- add to =if(and(c5>1,d5>1,i5=0),"order","")
- Index-Match
- Formula Notes
- Using VLOOKUP to apply an ARRAY formula
- Checking multiple cells
- Averaging value based on condition
- convert to 2 digit number
- using dates in IF statement
- Countif Function
- Sorting, Inserting and Subtotaling Groups
- Nested IF, ANDIF, between date ranges Question
- Copying data if it matches criteria
- Dynamic Pivot Table Probems
- Extract values on either side of "+"
- How to extract data if a value is present
- Comparing Data with certain criterias
- Conditional Formatting statement
- ageing report
- Named formula parts
- If Formula
- Conditional formatting 1 cell
- Range name Help
- Conditional formula (subtraction)
- Looking for Daily Earnings Sheet
- Automated tasks for multiple excel files
- Need formulas to extract names & phones from 2 data sources to match addresses in 3rd
- text fomula help
- Complex IF
- Coloring row based on cell value
- Adding the 5 greatest values of a row
- Conditional Formatting, Create a rule?
- Minimizing IF statements
- Forecast vs. Trend
- Find first instance of a number after a value
- Counting Products Sold Per Rep
- Formula to produce the nearest business day
- Mail shot from list of email addresses
- Auto entry Calendar
- Macro to gather data from other workbooks
- Auto entry Calendar
- Excel 2003, returning 2 largest values
- Vlookup and Match function
- not sure how to apply nested if to my problem
- extracting text strings from a cell
- Countifs... with a twist.
- Timesheet to calculate No Hours?
- Formula looking in 2 columns
- If 2 cells values are both 0 show 'No Order=, otherwise show " "
- Matching values in one column with values in another
- Change date to the following Sunday
- Duplicate row [A1] times?
- Trying to copy formulas.... I think??
- [SOLVED] Long Calculating Time
- If/then help: today minus 12 months, sum of related column
- Distinct randoms
- Stats reporting
- Sumif Values with a name somewhere in the word
- Referencing multiple items
- Averageif in Excel 2003
- #N/A Help
- If/then LookUp Function or a Function to copy data for sheet to sheet
- Auto complete cells after choosing data in drop down list
- Combining formula and text
- VLOOKUP Combo Box
- Sum values on specific date within a daterange (multiple ranges)
- IF function help - If something is true, then...
- Function to create Hyper-Text-Link
- Data automation
- Display autofilter definition?
- Lookup in merged cells
- Is it possible to automate text boxes!??
- Look Up
- Trim Function
- Query to find similar data..
- sum formula processing delays
- SUM specific entries
- Combo box as a cell?
- Help needed for formula
- Cross Linking 2 Dropdown Listbox
- Adding Multiple Lines when "IF" is True
- Adding rows whilst retaining formulas and formatting
- how to simplify the long formula
- VLookup Problem
- Nested IF's
- Look for biggest number minus next largest
- Help with roulette data
- Multi Criteria combo box returning array values
- Calculation of interest
- Need to remove some contents of a cell.
- Formulas to Fill Range with Date
- If Formula Or LOOKUP Formula Not sure
- wish to sum values of rows matching condition
- help with formual
- How do I use lookup to find data based on 3 criteria?
- Drop Down Lists - how to auto-populate with first few letters typed?
- Getting an variable index as a function parameter
- Seperating decimals and numericals
- Why won't SUMPRODUCT recognize some equalities?
- Stumped on tabbing function
- Sumproduct using Month as one of the criteria
- Pull partial text from a cell
- VLOOKUP - Formatting issues
- How do I refer to a cell after look up by text
- [SOLVED] Paid vs Unpaid
- VLookUp from Column 2
- can I use circular Refference to get Desired Output?
- MINIF help
- per page total at the bottom
- Complex SUMMARY page
- 6 Character limit on userform combo box source?
- linking to a sort on mastersheet?
- inserting Dates
- Combo Box returns from array formula
- Save last position of spreadsheet
- Monthly Extractions
- SUMIF Excluding hidden rows
- VLOOKUP With static Table_Array
- Rank a value within a range
- Lookup Column Number
- Subtotal problem
- HYPERLINK function without filename
- Vlookup - finding multiple occurances
- Student Database
- Using the LARGE function to rank by alphabet
- I need a basic function
- Indirect for Workbook Name
- Help with if function in excel
- Financial Functions Question
- Setup data for Pivot Table
- Substitute in a vlookup
- Filling in a cell based on another cells date criteria
- Subtotals
- OR and NOT statement
- Looking up data across two worksheets
- Conditional Formatting - Help !!
- Analysis of number in cell range
- Formula to mark record as overdue or current
- Finding data on a dump file, populating rows in a summary file
- How to add up products across a row based on a price list?
- IF, SUMPRODUCT, VLookup-most efficient?
- Average Data Corresponding to same Date.
- what is "^"
- Find Specific string
- Min function problems
- Wildcard in Hyperlink formula
- Rounding numbers down
- Formula links
- Calculate date based on multiple cells
- [SOLVED] Military time wont total correct in a column
- Replacing a formula with another cell
- Relative Data Validation
- [SOLVED] Mirroring vertical data horizontally.
- color formula
- Copying certain cells if there are blanks formula
- Index & Match function problem
- [SOLVED] Nested LEN and RIGHT formula
- DSUM - Criteria is a blank
- SUMIF Issue
- nesting IF functions
- Dynamic Correlation Calculation
- Subtotal and Index formula
- Search dates in column A and return 'year' in column B
- Rank values after sum by vlookup (or something)
- automatically sorting data
- how to count the number of times something turns up and display it as dots
- +/- Current Month
- Using Query to Import Data from Multiple Workbooks
- Counting columns until certain data is found
- hyperlink function with a match/lookup
- shortcut keys problem
- Merging cells with common information
- If cell is not blank, insert number
- Reverse Concatenate?
- Counter/Lookup
- Indirect Help
- Find and Paste
- Getting mass scatered data from one sheet to another
- REPLACE Function
- ISTEXT function
- [SOLVED] How to sum the totals on one column, if two other columns are true?
- Validation/Lookup/maybe forms problem (I think)
- how to count back X no. of cells
- Sum to one Formula
- If a cell has content,
- [SOLVED] Nesting countif?
- "IF" Function
- last value in column w/multiple choices
- average formula
- joining symbols within a string
- Change cell content to "A" automatically
- extracting numbers from alphanumeric strings
- conditional formatting.
- add the sum of cells by color??? with different values??
- Formula - Copy data to remote cell
- goal seek
- [SOLVED] What does confirm do?
- change row color based on input in one cell?
- A formula to count yes's
- Adjust an Index formula to limit results to a certain criteria
- Date Index Match Formula?
- Get address results in #name? error
- moving decimals and customized rounding
- =NETWORKDAYS and negative values...
- Best match for two values to return a third
- Return average and count from multiple criteria in a list or array of data
- how to test if a value is and INTEGER?
- merge cells and combine contents of both cells?
- How can i do a frequency distribution by machine automatically?
- Subtracting one worksheet from another that has common values
- Random Time Generator
- Limit a formula to only look in a certain range
- vlookup, match??
- Mean Average of a Percentage
- multiple criterias or smth...
- Time entry tool
- Calculate the CAGR
- Weekday() Function Error "791"
- Picking a value from a certain cell
- REPLACE 2 different sets of variables?
- Want to delete many rows!!!!
- index? lookup? match? Which to use?
- Conditional IF Function
- Protect formula's in a list
- Lookup for Multiple Values