- =rand()....Help?!
- Little trick with ","
- Function problems, please help
- #REF error - WHY?
- Find last value in an array
- Ages help please!
- IF A1="foobar" THEN change background colour for cells A2:A7?
- Help
- hmm..
- adding increasing numbers in column to existing text
- Combining Data without Duplication?
- I have no idea how to do this one
- Timesheet Overtime & Spread to Expense Account
- COUNTA trouble
- How did they do it? Index the rows?
- Help with "0"
- Concatenate with CSV?
- Sum non-consecutive cells matching pre-set value
- Countif Troubles
- Need help with Formula
- clear button
- change color and value of cell by formula
- Date overdue...
- Invoice number generating...
- Someone help my poor formula please.
- Lookup Function
- Need Help
- Function doesn't save locally
- Formula for returning certain value
- offset trouble
- Separate Names
- Excel dummy needs help!!!
- How do I post a different answer in the same cell?
- caluclate total time for those that were present
- time help
- Add all dollars for each account in timesheet
- Dates again
- creating a series from alphanumeric data?
- Get the Weekday Name but if blank, ignore
- Min and Max with a range
- Concatenate dynamically
- Trying ti figure out Inventory By Product ID for Multile Locations.
- Forumla for calculation function
- formula needed for condition 2 of conditional formating
- Locating peaks
- Need Help with formatting a function:
- Referencing merged cells
- Looking up cells
- data filter
- UDF doesn't appear in Insert Function list
- How to tell if a number exist in a range of numbers?
- Counting numbers in one cell
- Replace #N/A using VLOOKUP function
- Evaluate control info in cell formula
- Date formula
- Dynamic range reference in VLOOKUP?
- Formula confusion
- Dynamically filtering/updating worksheets
- How: Countif greater than 1000 and less than 1500
- If
- List (based on if statement)
- Count cell contents in 2 columns?? SUM? SUMPRODUCT?
- DATE formula
- Formula Function that copies data from one sheet to another
- Counting rows in Pivot table column
- Problem OFFSET
- remove #N/A from vlookup
- Linking Updates
- Help with sum function
- Hyperlink
- if and vlookup
- trying to count unique occurences w/in data that matches multiple criteria
- Calculate row totals of Yes/No
- ASAP HELP NEEDED ranges for a tax bracket
- Ranges for an age spreadsheet
- averaging across worksheets
- Using Nested IF's in ranges of numbers
- Searching Range in "=IF"
- Weekly Compound Interest
- chosing a table and searching in it
- Filter issue (I think)
- Conditional Formatting / not selectable option
- I want random numbers generated without repeating
- Link a worksheet title to a cell in the worksheet
- Summing and sorting
- need help vlookingup
- Show the lowest number in a column as a colour
- Finding smallest number
- Using the 'OR' in an 'IF' function
- Zero cell
- Copying relative worksheet references
- Need to update cell references to separate workbook
- Linking Check Registry to Income and Expense
- Scientific Notation Formatting Question
- Formula Assistance
- SumIF on names
- Array vs. Non-Array formula??
- Sequential Date Quantity Divided
- If date greater than
- Possible? Trying to do a wild card search...
- Adding 2 different percentages to figures
- MOD Function
- sum function
- looking text in range
- Date Forumla/Conditional Formatting
- IF and MAX in one formula but two criterias
- Sumproduct Problem
- Sum Multiple Match Returns
- Sequential time scheduling over days that have 12 hr periods
- Custom format
- How do I solve for n in =4^n=64
- Sorting Non-adjacent columns
- formula for commissions based on unit range
- Grade point average using AVERAGE, IF, AND, is not doing what I want
- Can vlookup look for 2 different values??
- Replace #N/A using Index Match function
- "Floating" Cels?
- IF AND OR - an easy one!
- Rounding up
- Formula works, but works too well...
- Pivot Table Custom Formula
- Conditional Formatting - if insert a comment
- Loan cost caculator
- Correlation Coefficient function CORREL
- Listing The Names Beside The Marks
- add (insert) lines
- Calculating the Average of Every Nth Value, Excluding Zeros
- Add 50 to each cell
- Converting Numbers into Text
- Columns SUBSTRACTION or something
- LIST duplicates AND references of cells where found
- MATCH, FIND & Conditional Formatting
- Multiple entry check
- Need to sort my pivot tables
- Hourly Pick Rate.
- If Range is empty, be empty, if range is not, then SUM
- whats wrong with if??
- Using Countif with another functions
- Total varies cells, need to put in one cell
- CountIf
- incrementing a column of numbers
- Create pivot table from mutiple worksheets
- Complex Lookup table...Help!
- Worksheet name plus 1?
- Too many Ifs for me
- test for sheet then delete it
- Information from another workbook and counting content and displaying in another work
- Search for instances of text and return ending position
- Changing formula in macro after row insert
- Using "IF" function for the first time
- Extracting text from a group of cells
- How do I calculate two different prices based on a given quantity?
- Choosing a name from a list on another worksheet
- Meeting Deadline Formula Help
- Concatenate 1st Initial Last Name
- Vlookup help?
- Table Rank & Sort Formula...
- Help
- display certain rows containing certain words
- Concatenate
- Inserting A word automaticly to a cell contents
- Multiple row if statements
- mileage log in mi instead of $.
- sumif when not strikeout and secodn column is not 0
- Separating text to columns
- comparing mail addresses
- Populate spreadsheet
- linking cells
- Help with Conditional Formatting
- Dealing with #DIV/0!
- amount in words
- exclude =today() in =sumproduct
- Duplicates Show 1 Or 0
- Advanced Sorting Formula
- Conditional Formatting
- Averaging from different sheets
- help!
- Validation Lists [Drop Down Arrows]
- Conditional Formatting
- Array with #DIV/0! issues
- how to exclude cells with formulas from counts?
- Round to the nearest '5'
- scheduling
- Sumproduct and dates
- Changing formula result to text?
- Sum Cells based on Another Cell
- How to Merge Two Columns of Data into One?
- Sumif Or Sumproduct?
- Serach for text
- Nested Function using MATCH and/or INDEX
- Using IF to identify range
- Filtering by Results of Conditional Formatting
- Cell range value
- counting values
- Vlookup - last value again
- Read from file
- Help with offset
- IF date THEN SUM...
- Simplify and add to IF
- Counting a variable
- more than 7
- External data constantly updating, how do i retain a certain value??
- If value found in data range (multiple columns) return row data
- Calculating a date 30 months ahead from a given date
- IF function HELP
- Vlookup last value
- How to spread out data based on dates and weeks.
- Heres a challenge (maybe)
- format help
- Making a cell return data from a chart
- And
- Text with formula - how to?
- MAX function
- lookup/match/if/index can anyone help me please?
- raised to the power
- Column letters
- macro help
- auto filter doesn't return cells containing the custom search wor.
- How to Manipulate formula for Binomial Distribution
- Countif with Two Criteria
- Data in cell changes then another cell data to change
- How do I auto-highlight a 'below limit' number in an average
- Rapidly Approaching Meltdown
- How to seperate OT and Reg. Hours from total hours
- How to match bits to a certain value
- How do I calculate the inflection point?
- plot graph from multiple worksheet as embedded chart object on every worksheet
- how do I create formula to sum hours & min's
- Change text based on other cell criteria?
- Grabbing the filtered data in a list?
- Grabbing the filtered data in a list?
- how do I combine two pivot table?
- Multiple field match?
- is there anyway to use sumif using 2 criteria
- VLOOKUP and its properties
- end number keeps changing to '0'
- Conditional Formatting
- How can I get a worksheet name appear in a cell?
- to convert columns to rows having mulit independent group columns
- Conditional Count 2 Columns
- keeping a running total in a single cell
- Help getting first column data based on criteria?
- add blank space in cell if first name is not blank
- need help with SUMIF
- Due Date with year using IF for several cells
- How to automatically create hyperlinks with excel
- Consolidating a Row of data from many worksheets
- Rows and columns in 2007 1,048,576 rows by 16,384 columns
- sumproduct with dates
- how to install microsoft exel