- Create a formula to chose cells at random
- Sorting Rows, Cell Reference not Following
- Formula to match several criteria
- Formula Help
- Match Preexisting data with imported data
- Extracting just the last name in a text string
- Adding if cell equals""
- displaying Values in an entire column in another worksheet
- Can i make a character into a integer value?
- Count rows with value between 1 and 10 in column B
- ask about a function
- Macro to list staff names automatically
- Sum with a twist
- convert text to value
- INDEX & MATCH or VLOOKUP??
- add and subtract depending
- Text to Columns Formula?
- Formula working but not working
- Increasing and decreasing depending of column C
- Strip text in cell
- Dynamic Historical Data Formula
- Multiple Factors in IF Function
- Make groups
- Filter without autofilter
- Filter issue
- Is this is If Formula possible
- Multiple Condition IF Statements
- Help with vlookup QuickBooks exports
- If formula: M1 = Y then A1 = fill color
- Some advice needed - Collating data sources and merging into one
- VLOOKUP & COUNTIF Complex
- Looking for proper Formula
- Need help finding duplicates between 2 rows.
- Complicated lookup - file attached
- Text result based on IF Formula
- Last edit date of a range of cells?
- Calculating steps
- Last cell in column
- counting text across multiple columns with a filter
- Add apostrophe to field
- Grouping Question
- Help needed asap please!
- Iteration question
- replacing '0' with a blank cell; working out %'s as and when figures are entered.
- Urgent help required!!!
- Time Functions
- rand function producing negative numbers
- Filling in names according to corresponding numbers
- numbers to text with correct charcter placement
- Scrubbing a Database in Excel
- Dependant Concatenation
- MIN(INDEX(( 'Not working
- Having trouble with vlookup
- selection equal to corresponding cell
- generate actual date workbook is opened
- Creating a Formula to use a specific text identifier for a range parameter
- function needed to compare lists
- counting with two conditions!
- Macro to Hide/Unhide Rows
- Insert a word/text before a list of words
- Lookup the value from a Named Range after splitting a value in a cell
- Reference Cell on Criteria
- Select Graph with a Combo Box
- Return a reference from LARGE function
- SUMPRODUCT Function with text value...
- time to general format
- Advanced Blinking/Flash cells
- Counting partial weeks in a month
- Pivot Tables
- Intelligent vlookup forumla
- IF formula that = true if subject written in BOLD
- Sumproduct
- Add number of items used
- Give values to some elements
- Excel 2003 - How to extract domain names frm email
- IF formula with ranges
- counta/lookup help
- Pivot Formulas
- Not Counting Zeros With Rank Function
- Add numbers by week
- What is the formula to total hours and minutes in a column?
- Help with count if and vlookup together.. maybe
- Excel able to calculate Variances and Sum all to "0"?
- Invoice totals
- vlookup help
- Lookup with multiple identical values
- Hyperlink to Files with IF or MATCH function
- creating dates in the past with given date
- Using a "Drop Down Box" that has a dynamic range
- Match multiple values to then lookup
- adding 1 to a section of numbers?
- Hide Un-used Fields?
- Reverse Order in a Row for List Box
- IF - very long IF formula
- Which row has the minimum
- Vlookup (3 critera)
- Shared Workbook
- Sum of Rolling 12 months formula
- Highlighting cells based on today's date
- Nested Vlookups and cell references
- Calculating a fuel surcharge
- help for unique counting
- VLOOKUP to find next value greater than the criteria
- Conditional Formatting
- Multiple Sheets
- Trunc Function not performing
- Most recent date
- Can't Select Macros From Tools Menu
- using countif and trying to search the whole workbook.
- I am lost...
- Making "X" into One
- Count value from B column based on A column content
- Quicker way?
- Dynamic range with count ?
- Help to put a range of numbers in a formula
- If statement help
- Help with a % formula please
- Rounding Problem when calculating 4 equal instalments of a given total
- Apply % increase to collection of cells?
- Separate Functions in One Cell
- Need formula for a check register (balance column)
- Adding weekends and holidays
- date formula
- Formula - total of how many rows area filled in
- Running 12-months formula
- Data validation Q?
- Football Predictions...yet again
- Hide column if it contains no values or "" value
- What Type of Functions Should I Use and How?
- If formula that has to look at two cells to see if they are blank
- Average/IF function problem
- clear #div/0! error in cell
- To automate a list based of mutliple column criteria
- IF function resulting from two different cells......or LOOKUP????
- If function
- Random Number Generating
- Forecasting Overtime Hours Required to Complete a Project
- Calculating the Average
- calculate hourly data
- Aging Data in terms of days
- Formula for "assuming that a cell has this value"?
- Percentrank
- Formula when I enter a number or text in cell D3 a figure is automatically entered in
- formula to remove text at end of string???
- IF formula
- VLOOKUP question
- [SOLVED] can I count cells until criteria is met?
- how to get Year-to-Date sum by hlookup ???
- Need To Input Data Automatically In One Cell Based On Data In Cell Next To It
- Comparing 1 column then 2nd column
- Auto-fill in a pivot table
- VLOOKUP - how to get last found matching value??
- Formula to show the Filename (without path/extension) in a cell
- Count then Multiply
- Transposing columns to rows
- sumif function
- VLOOKUP/LOOK Advice
- Consolidating rows
- If statements using "AND" "OR"
- Need to see the name of the descendent worksheet
- Fit picture in cell
- Calculating averages to ignore cells with formulas
- Average / Index function help
- LOOKUP function for unsorted data
- Duplicate Check with 2 conditions
- #VALUE! Error while using VLOOKUP()
- Selecting more than two items in an AutoFilter
- I want to average a specific range. Complicated!
- What is the formula function to use to come up with a list related to another list?
- Ranking conditional groups... but negative figures...
- Finding part of a text string in a cell
- What formula do I need for this?
- Repeating values in multiple columns
- Finding the point at which a series of numbers crosses zero, or not
- Filtering data by a Criteria column
- Index formula returning incorrect result
- Lookup and Data Formats
- Increment by column from data in rows
- 8th function on an IF(AND(
- Wildcard search for IF command
- Auto Filter
- IF function for dates range
- Skip Circular Reference...
- Using SUMPRODUCT to count 2 text variables....
- VLOOKUP-If cell is empty display text
- Viewing content of target cell
- Quick way to match data
- IF, VLookup & Average
- Automatically extract nominated items
- Advanced Conditional Formatting
- =now() Date Function, I format to YYYYMMDD, Want that value...
- Printing DATA found in another column with text in front of it on a different column.
- Match/Vlookup help
- Multiple Ifs
- Pivot Table Source Data Errors
- Split screen for an entire workBOOK.
- Vlookup - most lookup cells returning value from the closed table, some arent
- Calculating & Summarizing
- List Look Up From Another File?
- Multiplying Formulated Cells
- Multiple Lookup Challenge!
- Days between dates
- Matching two sets of Data
- Timesheet
- Formula to find week-ending date?
- Automatically insert amount monthly
- DSUM database field across multiple ranges
- Sumifs with date
- Match Max formula?
- highschool teacher needs help with markbook
- Multi-Table VLOOKUP?
- Is there a "let"-style function?
- Array Formula help
- "Formula is too long" - shorten formula?
- Date manipulation
- Lookup For Displaying Multiple Values
- Pull down Menu size
- Deleting some data from worksheet
- CountIf function
- Sum Product Question
- Second last number in a column
- Table "same as" feature
- Show active cells contains in other cell
- Last Digit in Cell...
- Summarizing data to reveal trends
- Broken hyperlinks
- To sort and summarise
- vlookup help to generate labels
- SUMIF total function
- Excel 2003 - Create a Shopping Cart type idea
- completion date projection formula
- 3 table lookup and sum
- Lookup functions
- SUMPRODUCT calcs....
- commission function
- Search and Left Function
- CountIf - Trading Tracking Chart...
- Automatic shading
- Order form drop down list issue
- Match Value and Populate
- get cash flow recovered from 4 columns of data
- vlookup/match/index function?
- Converting monthly data into yearly averages
- Countif - Stock Trading Template Tracking
- Lookup, Compare, and highlight
- Anyone Have a Project Management Excel Templete?
- Sort of like a sumif?
- Shadow text.. Watermark
- Zero Crossings
- True if cell contains "U"