- consolidate miutiple worksheets
- FILL Down Help Request
- sumproduct can this be done?
- Sumif or Sumproduct with Multiple Rows & Columns
- dynamic list/employee OT
- Way to highlight non-incremental data?
- Conditional formatting & 1 column to the right?
- sort order help
- Duplicating data from one worksheet to another
- Sorting row with a alphanumeric value.
- Convert cell containing numbers as text into a sum...
- If Then for a scoresheet
- Is there a way to have a function continue after you insert a row?
- Which Function Do I Need?
- Sumproduct
- if between function as a single argument
- Summing cells between 2 highlighted cell
- IF Between Function
- lookup single value in one sheet, return multiple results from the other sheet
- Index question
- If statement
- Add current date to a cell
- Finds number matches!
- Vlookup?
- IF Statement Based on 2 Cells
- Auto Populate Character Upon Click In Cell
- Return horizontal and vertical values
- sumproduct issue
- Find num via refer array!
- Use vlookup to return column header?
- Hlookup stonedead in excel 2002
- Finding 4 unquie non-double numbers!
- lowest via highest nums!
- Setting date of column if another not blank
- match numbers function!
- Requirement that merged cells be identically sized
- Calculating Birthday's in One Cell
- Coping cell contents
- alphabetize help
- how to use dates in equations
- Function to pull out data from one column to another without duplicates
- Filing data into drip slots
- Calculations with equation of a trendline...
- Auto Filter Problem
- How to plug data from 1 worksheet to another - not just linking 1 by 1
- if x or x = this!
- Conditional format formula with multiple conditions
- find two large numbers!
- group seach!
- Formula for assigning points for incremental values
- Value if "Today" greater than stated Date
- Column Has Text and Numbers, Need To SUMIF Only Numbers
- Control countif range!
- Stop adding dates after the 15th.
- Sumif problem
- Use number portion only of a cell in a function?
- Using FREQUENCY to sum instead of count
- Count blanks
- income and budget workbook
- Pivot Table Not Populating Correctly
- Search For Data
- IF function yet want to stop counting when another cell has data entered.
- sum with variables
- Blank cells are being counted as zeroes in a percentage. function to exclude them?
- Defect per million DPMO
- COUNTIF/VLOOKUP/MATCH combination
- Can we creating Thumbnails on Excel 2000?
- Calculating Overtime
- Use a function in a chart range so it doesn't include a cell if blank?
- Multiple IF Statement? Or Lookup?
- Countif only when a cell is blank.
- making vlookup start from the bottom going up
- Sumif?
- multiple countif function with text
- Using a countif function to count 2 variables?
- given loan amount, emi and tenure, how to calculate interest rate?
- Two-column lookup
- designing an array
- #DIV/0! error where there was none before
- Change Time to Hrs & Mins
- can't subtract one time from another
- Complex countif
- sort data to new worksheets
- Tabulating survey results
- Looking for: return max value and neighboring cell
- Number search
- Oraganization with Excel?
- Calculate Hours & Mins
- Sum the totals of multiple items
- Counting in between ranges
- Adjustment to MIN/INDEX formula
- creating a drop down list for names and addresses
- Convent cell digits to hold number!
- Using 2 seperate worksheets to validate data
- Matching Data in multiple worksheets and writing needed parts in a new worksheet
- Cell Overlapping issue?
- Calculating Totals(sum)... by company
- matching data in two side by side column
- matching data
- Conditional Formatting Function Help
- basic sumif question
- Re-calculating column totals on filtered data
- Shortening text with MID
- Help using excel functinos and trickery PLEASE
- Extracting specific text from 1 cell
- Combining lookup and forecast formulas
- rule of 78?
- total time
- Summing a worksheet with Subtotals
- Calculate pay-hours based upon variable time window.
- Calculate the # of work days between 2 dates
- IF column B = closed, then calculate # of days between dates in Column C and Column D
- cannot seem to calculate APR in Excel
- assistance with array formula
- save column wizard results in template/profile?
- Splitting Cell Data + Formula
- Specific Cell Value
- VLOOKUP function #REF error
- excel function
- MAX, INDEX, and Date parameter
- Tabbing Throught Cells
- Allow read only on a shared workbook
- Counting dates in particular ageing brackets
- referencing part of a named range
- vlookup
- Make now() function static?
- Calculate How Many Above 95%
- Calculate With Criteria
- Excel Autofilters
- Deleting all non-numeric characters in a text-string?!
- Coding not reading numbers
- calling function with variable amount of results
- counting number of months
- "if" "and" String Problem
- Picking out data and combining it from 2 columns
- Formulas for dates
- countifs...
- Conditional Format a Column
- SUMIF and NOT
- Vlookup using two columns
- Hlookup
- Fiscal Quarters with July as your start
- Getting an IF statement to ignore formulas
- Count text as value of 0.5 not one
- VLOOKUP and #N/A
- Placing a number based on the rage of another cell
- Creating a formula that has 2 formulas in it
- Recalling info with reference number
- Compare Worksheets
- Cell References data that doesn't exist?
- Sumproduct
- IF function
- Live sorting? and referencing data between sheets
- Hidden Table in Excel Sheet
- Including Sheetname in Document
- Get column title from lowest row value
- Populating Cell Only If Multiple Criteria Matches -- Repost
- Pulldowns - hard to find data
- Date Function (Next Month)
- H / V Look-up?
- Figuring letter grades
- Recalculating Prize List when ties occur
- hiding formulas in menu bar
- Sumif?
- Look up value and retrieve maximum corresponding value
- How to get payment to date
- Auto Populate Fields
- Sheet protection problem
- Unique occurrences
- Probably Simple IF-Then statement for Recipt and Inventory Correspondance
- increases/decreases from a quote to a booking
- Sum where?
- Closest Match
- Countif: more than 1 range?
- IF or "OR" function
- vlookup question
- Max/min in a floating serie
- Nested If Funtion Question.
- How to Set TabKey to Jump Across Columns
- vlookup pricelist question
- conditional formatting with blank cells
- scroll bar usage with data validation
- need to extract text from a cell
- Changing date time formats in EXCEL
- text color of the amounts in Column A change whenever I indicated that it's been paid
- Vlookup - last event
- dynamic range for index/match formula
- Data Validation
- SUMPRODUCT question
- Doubts in Formula
- Comparing a number to a lookup table
- formula to find last figure in a column
- Creating Summation Worksheet.
- Vlookup (Range data)
- sum of last N values
- Calculating school year from DOB
- Summing across worksheets from first to current sheet
- Distance from streaks
- Excluding numbers from Max
- if/and statement
- Extract data from each record and put into another worksheet
- Looking in Mulitiple Worksheets
- If(ISNA?
- Clock and Formular
- vlookup and IF I think
- Need to separate data from one cell to different cells
- Jump to todays date function.
- Extract a number from a text?
- formula when with no values
- Format not copying
- convert dates to calendar schedule showing how much to bill them each calendar month
- VLookup Question
- formula to auto change some cells to bold font
- Adding numbers within a total
- An 'If Then' Formula
- Allocating points to values within given cell range?
- Combining Data
- sliding periodic average?
- Trouble hiding a cell based on conditions
- multiplying a cell by another which contains a formula
- Populating Cell Only If Multiple Criteria Matches
- Match and extact values
- Counting cells containing a certain background Colour
- SumIf, CountIf, ???
- Locking Workbook
- Euro conversion & IF function
- Excel data retrieval for pizzeria
- How to automatically change the value of undefined to 0?
- Multiple Criteria
- Advanced filter - display null or non-null
- Query woes
- Vlookup against 2 criteria
- Multiple criteria - multiple results?
- List Rows where a cell meets criteria
- Calculating Network days and hours
- Return full row from drop down or similar.
- Count if <>
- Reverse Index and Match functions
- Hide Text
- Multiplying B with C and answer in D column
- Function - total percentage YTD
- Weird depreciation in integers
- Combining 2 worksheets
- Problem creating this function
- something like vlookup
- Results by Month and Week of Month
- Big Time IF Statement
- date vlookup fomatting
- Goal Seek
- Date Formula in Excel