- Finding cells incorrectly completed
- Linking the Table array of Hlookup to a cell
- Formula for time in a cell + 30 minutes?
- If a value = another value replace with another value
- Making a master calender linking other worksheets
- Invoice w/ pulldown autofill
- Column Editing
- -- in SUMPRODUCT function?
- For every "X" amount, do "Y"
- Countif (Number of values in a range)
- Compare and restrict available numbers in two lists
- VLOOKUP and decimal places
- realtime filters update
- Setting Automatic Difference Across Columns Like AutoSum
- Circular Reference with COUNTA
- Calculating multiple critera
- Exact Vlookup or similar function!
- Conditional Count
- Sorting Group
- Deleting records
- Data Validation Dependence
- Averaging and STDev based upon conditions
- Multiple Criteria and Date references
- Data Validation
- Applying formulas to a table of filtered results
- Created Dropdown list - How to change Font?
- lookup
- Cursor locked on one cell
- Choose part of a cells value via formula
- how to populate field based on previous drop down list selection?
- Calculating percentages based on multiple criteria
- List as true IF value
- multiple condition if
- Start Date, End Date=#of days not working
- Countif > then cell contains
- Pre-loading a cell
- Referencing other Sheets through Cell content
- Add 5 hours to a military time column
- Why wont max work on cells that have a formula
- formula to determine students' final restult based on multiple criteria
- Require SUMIF conditions,
- excel chart and formula
- Left / Right Function
- Plotting blank cells (w/formulas?)
- Need VLOOKUP to return no value
- Custom tab movements
- Sumif
- COUNTIF answer in another thread
- Lookup (Unknown errors?)
- Rounding The Whole Sheet...
- divide by zero
- using formulas on multiple books
- Proof/Safety Valve formula
- Calculate paper sizes
- Cell shape/format question
- Conditional synchronization of workbook
- How to add zero values before numbers having less range
- Countif no longer good enough
- PMT and RATE formulas
- Variable Cell Reference
- ifa=in and b>0 then c =yes
- countif X and Y, but not both
- LOOKUP and returning row for COUNTIF
- IF(ISNA(Vlookup giving an error...
- How can i use "solver" function
- If / and / then formula
- Search column for non-empty cell and display results?
- Bill of Materials
- duplicate rows
- Combining numeric cells
- Selecting equation based on previous cells result
- cell format question
- External reference with variable sheet name
- force input data to be uppercase
- Start month, end month and cost.
- Providing Area Into Cell If Hit
- Hyperlink to a sheet through a cell containing that sheetname
- Counting Dates + Sumproduct
- Using MATCH with Time
- if/then function?
- formula visable in one cell answer in another
- assignment - If statements etc
- passing values in cells between sheets
- "Fill Down" - don't need to auto-increment
- Calculate percentages
- Calculations Based on Cell Format
- Linking spinners to two cells and validation rules
- Cell formats within VLOOKUP fuction.
- IF function dealing with numbers
- Chart Columns
- dynamic range
- COUNTIF Formula
- VLookup/IF Statements and Multiple Variable Lookup Not Working Correctly
- Vlookup function not working if alphabet coming after '-' in the search term
- Referencing Changing File Names
- Splitting text (un-concatenate)
- Array Formula
- find value from the datasheet by matching two fields?
- Creating Single row by cobining data from two coloumns
- Returning information after selecting a drop down
- Hi, I need some help!
- Sumproduct
- Another Sum Question
- Lookup Function
- search column "A" for every occurrence of the current part number
- IF statements not working
- Very Large Data Set
- Summing Vlookup Values
- vlookup, different spreadsheed, relative path
- index and match across multiple worksheets
- How to Calculate Days elapsed where Weekend is calculated as 1 Working Day?
- Looking up value by qualifying on two columns
- Inlist Function
- Removing Trailing Live Breaks
- Quotes within quotes
- Moving Named Ranges
- copy, paste - modification
- Calculation using percent
- if query
- Formula to identify key words
- Lookup and Cell reference
- 2007 Macros
- Merging duplicates and adding their unique values
- Lookup function
- Flow Routing in Reservoirs!
- MS Script Editor - <x:Connection>DSN=DSCH_CAP;UID=eqdb
- ODBC from not mapped Drive
- Formula to import data
- COUNTIF (A1:A10=8) but only if the cell next to it is "X"
- PERCENTILE function: application to a range
- String to Hex
- scrolling issue
- What a drag - changing the formula
- Solver add-in?
- If or Macro or something else???
- Function to mimic SQL-style lookup
- linest function to develop a model for forcasting current month sales
- V-Look up and further formula
- Inserting Dashes in Formula
- Rounding up calcluations
- array formula question
- Multiple range lookup functions.
- conditional formatting
- totaling figures in rows based on criterior incolumns
- Problems with the month on January..
- lost my functions
- Concatenate fractions and text
- Calculating totals from groups using defined lists
- Linking 'text' into formulas
- Autosum on protect sheet
- Concatenate with Formatting
- Referencing a calculated value in VLOOKUP and INDEX-MATCH
- Vlookup depending on multiple columns.
- ranking by three columns
- Disapearing Data Validation!
- IF statements from VLOOKUP result?
- Summing cells to the right
- number of characters in a cell
- Input Box Instructions/restrictions for filtering data
- Count If New?
- VLOOKUP - Finding the nearest value
- SUMIF Question
- updating new named ranges in existing formulas
- Reference sheetname in a cell
- Sumproduct
- backward lookup
- how to modificate this function
- sheet name in a formula?
- converting table to list
- Count Function
- Vlookup --> table_array with ranges
- Formula Headaches.
- ctrl-shift-enter problem transpose
- Conditional averaging
- How can i show and embedded object as a link instead of an icon?
- Using COUNTIF in multiple worksheets
- Autoname Tabs by changing cell
- Schedule and Inventory
- Nested if error
- Duplicating data between worksheets
- Find last number and insert
- listing the 2, 598, 960 different poker hands in separate cells
- Making a worksheet sort information, and file it into a workbook
- Highlight repeating numbers
- sales percentage lookup
- Return value in cell row in adjacent row to cell containing max value?
- divide zero by zero and not get an error??
- Date Formula mon to fri- Excel 2002
- Managing reverse scored data
- extracting random data and sorting into cells
- multiple averages, long datasheet-quickest method?
- determine what my multiplier should be based on a range of numbers
- return multiple columns/rows of data in formula?
- Moving hyperlinks
- Analysing data from multiple columns
- Match and Index
- "What If Formula"
- Vlookup
- SUMIF Problem With Moving Cells
- Google rankings side-by-side
- Offset, Sumif or Sumproduct or....?
- Formula to solve for "X"
- Multi-Sheet Question
- Multiple conditional if statements
- Clock or counter function in excel?
- Writing a formula that sums groups of cells based on position in an outline
- Complex Lookup Functions
- Change date format using SEARCH function
- modify column values that starts with 1
- Look into an array and return the same row in another column
- Rates from DATA SHEET automaticaly
- Formula combing IF AND OR doesn't work
- Excel autocorrect
- Looking for formula
- Change Colour with VLOOKUP
- Monday to Friday
- Disabling the Advanced filter function
- Sumproduct
- Sum cells continuously start from the first non-zero number
- Link New Worksheets to Master Source Data in New Format
- Rounding
- Copying Formulas to other cells
- SUMIF criteria?
- How do I list records from a query horizonally?
- Using <> and ><
- Inputting question
- Dynamic Range with no result "-"
- Stripping Letters from Numbers
- Formating Solution for already in use sumproduct formula
- Formatting a cell to show height *' *"
- Transposing Frequency data
- nested if statement
- SUMIF not working?
- Evaluate Text based Formula
- Nested If and Or fxn for multiple cells
- Setting up multiple filters
- Function that returns a week number
- Replacing #VALUE! error with an empty cell
- Copying data to row which has a smallest number
- fix a multiple IF statement
- Combining vlookup with offset?
- Date field will not up date automatically
- Count Rows
- cells random sorting
- Count Function
- Replicating: Fill, Series..., Growth trend.
- Hyperlink Macro to Internet
- Month as text
- duplicate max numbers
- how do you fill a formula across only changing part of the formula???