- Using Function "MIDB" on mac causes Excel to quit
- cell refresh
- copying two referenced sheets
- filtering a summed column
- comparing two prices with IF
- Trying to Filter rows from one spreadsheet
- search for multiple text strings?
- How can I display my count down
- Named Data Ranges & Chart
- Background function check.
- Trying to drop it down dependently while it's hot!
- using an array, if, and count if command
- Add number to cells then multiply all
- Countif Counting Drop Down List Of Names
- Convert Cell To Text
- How do i get a total at the end of a row with formulas in???
- Calculate eBay Final Value Fees
- calculate how many errors are given to checkers
- IF & COUNTIF statement
- automatize same formulas in different rows
- connecting sheets for data & chart
- Formula help needed to solve equation?
- SUMIF & Count IF - Multiple Criteria
- Sorting using Formula
- intersection cell of a row with a column
- how do i work out a percentage
- Insert new row question
- 4-1 E-BOOKs, worth it??
- Excel if or round function?
- Multiple Criteria
- Counting number of days less weekends.
- Copy from one worksheet to another automatically
- removing oldest duplicates by date
- Sort list of names by surname
- Lookup woes
- Automatic transfer of values between spreadsheets
- Drawing Log Problem Using Offset And Match Functions
- Export Search Results
- Blank Instead Of 01/00/1900
- Duplicate entries
- randomise numbers in cells
- if or Lookup formula
- Total per client
- cell reference from other workbooks
- Extending VBA conditional formatting
- explain what these symbols attached are
- Looking Up a range against another range?
- Using the IF function
- Linking multiple excel files with multiple pages
- Formula+format
- Working with Time
- Most Recent Score
- finding next instance of text in a cell
- Vlookup is un-italicizing my italics
- Negative Differences between two times
- How can I extend the series of a hyperlink
- Summing Filtered Columns
- Converitng Numbers into times for costings issue
- Divide all combinations from 2 columns
- removing duplicates in a string of text
- vlookup?
- Strange values appearing..why
- Array Formula
- Using Goal Seek to determine value within Range
- Two deminsional lookup
- PivotTable summery of duplicate rows
- Using Formatting (bold italics underline) to include a value in the total
- Counting a date....
- Convert text to formula.
- Count values in one column depending on value in a second
- Convert "Time Interval" in "hours : minutes : seconds" to seconds
- reference a row
- Reference to worksheet name using cell value
- changing a value in a formula depending on a criteria
- cross ref over more than two columns
- Change the formula based on data in another cell.
- Creating a list from a larger array
- Calculation of Column Based on Month
- How can I hide the #N/A and similar
- TriLookup
- ranking numbers in a row, smallest=1
- rows side by side - looking for discrepences in numbers.
- returning the location of a number or text
- Can Excel do rankings?
- Conditional Formatting of sorts
- Match Multiple Criteria
- How to update a cell with every click
- Using Median as a field setting
- Analyzing rows and columns to get a price
- Calculating Monthly Growth Rates
- Indirect Formula Within Index Formula
- IF the name does not match the description - FLAG
- Finding value corresponding to max value
- Subtotalling a list weekly
- Comparing data in two worksheets
- Averaging non continuous cells, and ignoring cells with errors
- How do i count blocks of data..???
- word to excel references
- search for number in string
- Colours in formula
- Finding first instance in an array
- Multiple variable equation formula?
- Multiple variable equation formula?
- Prevent #VALUE error
- Clear two cells if third cell is Null
- Returning Row Heading for Top 'X' values in a range
- Easiest one-cell formula for multiplying array elements
- Analyzing both the Row and column headers
- Decimals and Wildcards
- setup an expense worksheet, but can't get all columns to sum properly.
- How to calculate 1 hour is worth 1.175
- INDEX & MATCH Function
- Total By Month
- vlookup dynamic reference
- Auto Generate List
- HOW-??accumulating values from same cell in multiple worksheets
- Concatinate
- Multiple IF Argument
- lookup function?
- VLOOKUP by address
- Sum nested within Sumproduct
- Numbering Column B
- Sumif
- date lookup and item counts
- cumulative monthly figures - whats the best approach??
- Formula for grading workbook.
- Filter/sort question
- Offset Data List
- COUNTIF for multiple values
- Reading from a database
- VLookUp for large dataset in closed workbook
- Formula for next unique value
- VLOOKUP and indirect references
- VLookup 2 Colums 2 spreadsheets
- IF Formula
- referencing patterned cells
- Drop High & Low
- Pivot table Multiple consolidation of Ranges
- Can't get relative cell reference to change with this formula!
- Pivot Table
- Nested If Statement Help
- Excel Automation Inside Worksheet Functions In C Api
- VLOOKUP with empty cells
- HLOOKUP without any fixed array
- Sorting Multiple Columns Issue
- Return a particular text within a cell
- Copy Sheet to new Workbook and keep links "relative"
- Lists for more than one column
- Rounding Down to Nearest 1/8
- Function to choose between numbers
- Copy & Pasting
- Allocate Labour Expense to Hundreds of Entries
- Address Function, how to search the whole sheet
- last entry in a column function
- VLookup with IF function
- add more to if function?
- Roll up data
- countif formula
- =VLOOKUP function
- Chinese characters in linked spreadsheets
- Fix A Formula
- probability function?
- statistical standard error of a set of data
- Combining data in non-adj rows
- Average function!
- Dont want #DIV/0! to appear.
- counting zeros
- Working out 2 way Total Problem
- counting problem
- compare data
- Creating summary totals
- Return pivot table range...not the data table, the PIVOT TABLE!
- If isnumber
- Return cell address for max value
- IF function with a range of cells
- Copying formula across columns where row sumber remains static
- Replace or substitute formula maybe? Not sure what one to use?
- Countif Problem
- Question about using a SUMIF statement with two sets of criteria
- Compound daily interest
- Multiple validation problem
- vlookup question
- 3D name and using Max
- Read Data from file
- trying to total times
- complex SUMPRODUCT statements
- Conditionally Locking Cells
- Keeping a Static Formula
- Five reference Formula one answer.
- VLOOKUP and workbooks
- Populating a date field with todays date when data is entered in another cell
- Formula Result not Updating
- How to make blank cells be ignored in a formula
- Merge Report / Find Duplicates ?!?
- Copied Data Not Calculating
- Calculated Field in a pivot table
- Formatting and Calculating Time
- Finding text in a list, and returning the row next to it.
- I told Excel NOT to display zeros in cells w/out value, but functions create zeros
- Sumifs error in formula
- Rank list from top score to low score
- Editing numbers without removing formula
- Canīt use my user defined functions.
- Auto Change Cells
- VLOOKUP with contains function?
- MIN function problem
- Problem with SUM function; won't display result.
- count values in a column, but only if the value does not appear in the previous cells
- Add working hours only to a date and time
- Return values from a range of values
- amortization schedule.. kinda
- remove text after and before specific words
- move data from one spreadsheet to another
- Trying to dominate date formatting once and for all
- Lookup Cell
- Sorting Data and IF Function
- Sum If?
- autoformat to add rows between values
- Check value in a time range
- search for max date and display other cell value
- Sorting based on highlight color
- Formulas for salaried workers
- Simple conditional if function?
- to number a specified column of cells according to a value I've entered
- Xl07 - Lookup products that end in H using the VLOOKUP formula
- Calculation according to Color Coding??
- Conditional Format or ?
- Calculating Calendar Months
- Removing Spaces from cells
- Xls Files In One
- hyperlink date parameter problem
- Precedent and Dependent Arrows
- trend?
- locking an auto-count
- workaround for exceeding 7 nested functions in Excel?
- create a formula to look to calculate average payment based on rep and date
- Finding the 2nd to last data in table
- Entering Formual for a column
- What character = "line return" for formulas
- Using calculated cell references in a formula
- While Replacing Text Getting Error-Formula Too long????
- How do I have worksheet tabs on separate lines?
- IF/OR function
- Auto Filling data into a Master Workbook from a number of other sub-workbooks
- Programming a Find Loop?
- changing a cell to number format using a formula
- GPA Calculator
- Control Panel - Date Formats
- Help with running scenarios
- Find and replace cell data