- Trimming Spaces before and after
- Filtering duplicates
- Open jpeg in new IE window
- Trailing 12 Months Formula
- IF calculation
- Calculate IF with parametres
- compared two columns, obtain cell differences
- Using LOOKUP?
- Comment in cells
- Return tomorrow's date if after 1PM
- Linking cells?
- Lookup 2 Columns Simultaneously
- Randomly select from alphabet based on letter frequency distribution.
- Random set of lists with item limits
- viewing values vs formulas
- If function?
- VLOOKUP variation to yield multiple text values for same customer not just first text
- SUMPRODUCT Using <>
- Reference to dates across a table of data.
- Pull information in one tab based on field in another tab.. HELP!
- if function
- Remove Toolbars/Go Fullscreen but keep scrollbars
- Index formula?
- final maturity amount!
- eliminate pivot table
- Table Styles?
- concatenate function
- using VLOOKUP and RANK when multiple cells in the list have the same number
- More then 3 Conditional formats, maybe if?
- COUNTIF function
- counting function? maybe?
- How to add data in sheet 1 to auto update in Sheets 2 & 3
- Rounding up time with formula problem
- Speeding Up File with Calculations
- Referring to todays date
- sorting data in order problem
- Drop down list question
- Lookup command reading user input cell
- Sumif using date range
- Rolling average across columns with criteria
- blank cell vs $0.00
- rank function on condition
- Referencing date in another cell in text
- Adding cricket overs - base 6
- Problem with VLOOKUP
- Counting cells that are colored in
- Working with Dates
- Worksheet name
- Multiplying columns of numbers
- SUMPRODUCT for particular dates
- Display corresponding value...
- Sorting data into columns
- COUNTIF with two conditions
- Number of occurences
- Reduce File Size
- Data Validation like Drop-Down Box
- Issue looking up Matching data
- sumproduct with (or)
- If statement Don't Show Data if cell is empty
- what function to convert convert 34234 to 99999
- If statement using weekday to give result
- adding cells
- lookup values using two criteria
- How to add months to a certain date?
- How to hide sub totals in pivot table?
- IF statement unable to process negatives
- Problem with summing data
- Removing and displaying information from a string.
- Sumproduct with 2 types of spefic critiria
- Cell Length Shortening
- Sorting Data automatically
- Counting using R1 and C1
- The formula from hell!
- offset/compound lookup formula wanted
- If statement (Ignore blank)
- Royalty formula
- Worksheet "tree" navigator for Excel?
- Too Many Arguements For Function?
- Look Up Multiple Records
- Problem with a long formula
- Convert text to text?
- If Else Conditional... in a while loop?
- Polynomial coefficients
- Finding totals of changing cells
- Filter Tool?
- The SECOND largest
- read off excel produced graph
- alternative from Coutif to Sumproduct
- Counting Cells base on Cells
- Bug in Excel?
- IF Formula with 2 condtions in it...
- Counting Occurances
- IF formula for text string
- Formula / array to return multiple values
- rounding issues
- if if if
- Function to dispaly text.
- How to clear formula without clearing cell contents
- Using if/thens for non numerical variables?
- Rename data range
- Numbers In Succession In Column
- Matching Field to Field
- How to get worksheet name and use in formula
- page numbers
- Shortening array formula
- one master sheet and four update sheets?
- formulas transferring dates
- Only to copy summary data.
- Dependant Data Validation
- protecting worksheet with drop dowm lists
- Check sum of Columns and Rows match
- attendance spreadsheet
- date and amount
- Hidden Column
- Using blank cells in mathematical operations
- How do I find the inverse of a MOD function
- Multiple cells and ignore empty cell
- Converting all my old excel books into 2007 in one shot
- How do I get Excel to add numbers to this string?
- Link together different cells in specific order?
- Remove #n/a error message
- Moving Down Rows using indirect and address function
- Date assosiated formula
- Converting minutes to hours and minutes
- Count column C if not empty
- merging text and data fields with zeroes
- Data validation - Cell to increment by 1
- Search and compare
- auto refresh of web data
- If Statement
- Named Range : refer to Current WorkSheet
- Dropdown & Vlookup
- Linking rows on worksheets of the same workbook.
- check range of cells in one step
- clear a page on a certain date.
- How to work out hours based on known percentages
- Nesting Formula Issue???
- Conditional format rows with differing dates
- Data ranges in Excel
- Finding a value >30 in different cells
- Formula to "define name" for a dynamic spreadsheet
- Array Formula
- Final Row of column on sheet
- Deleting entries that contain numbers?
- Can you count format change?
- Vlookup
- cell format problem
- Date Time Problem - stop updating that each time the document is opened
- OWC Picking Data from Acces
- Formula to "look" for columns
- SUM / IF Function
- CommandButton Programming
- Countif with multiple criteria.
- Limiting decimal points doing division.
- Autoformat/continue series
- removing blanks from list by formula
- multiple match
- Multiple additions
- IF statement for multiple cells
- number identifier
- If statement to result in Cell Format Change?
- If statement
- Problem w IF Function
- As Sum Approaches zero indicate number.
- Auto Update Chart - excel 97 to 2003
- Transportation Status Report
- question with autoshapes
- fixed column, row number from another cell
- Formula Based On Multiple Criteria
- Copying non zero value from one coloumn to another
- Deleting rows of invalid data
- Adding multiple spreadsheets
- Values change based on date
- Excel Salary Calculations
- Date Difference
- conditional result
- Stopping COUNTIF
- convert date format.
- Adding Line of with total highligts
- Splitting Strings
- Date import/convert problem
- IF 3 cells = (biggest value) then (change back fill color)
- trying to make a complicated IF
- getting a value error
- Hyperlink function to Current Workbook Only
- If Function?
- Want to know how to use VLOOKUP
- Using a list in an IF function
- retaining equations
- formulating Max Lookup(?)
- If Statement and Average
- Time calculation issue - tryng to add times
- Trying to generate a table of unique values from an array...
- Drop drop and autofill question
- IF statement for multiple cells
- SUMPRODUCT consuming memory
- If statement searching for highlighted cells???
- Stopping VLOOKUP's
- IF and many logical tests at same time
- Top ten not using Auto Filter
- IF statement?
- finding dup vales and remove corrospoding record
- Formula to move data if next cell contains an x
- Challenge... counting contingent on ranges
- Challenge... counting contingent on ranges
- copying worksheets
- SUMIF across all worksheets
- excel drop down boxes
- Trying to Skip a Range of Cells
- Finding Dupicates
- Formula / Lookup
- Vlookup style function...
- Populate static dates based off entry of another cell
- Time w/in Each Hour of Day btwn a Time Range
- Index & Match with IF statement
- Excel =mode problem
- If Function
- date calculation
- Adding "UPPER" to a formula.
- Formula for finding duplicates
- Combining IF(OR(ISBLANK...
- IF function to remove 0s
- Using SUMIF with other workbook
- reverse a number
- custom number format in formula
- Copying data
- Conversions
- appropriate function to get the result
- How to append and delete from sheets
- Finding column Heading based on max row value
- Counting By Date
- One Entry - text in one cloumn, number in another
- Sum function
- conditional formula for a column
- Summarise & sort Production data
- IF function
- Averaging cells
- Recalling info into another row
- Weekly input to a data sheet
- Dropdown's to lookup data
- Populating one table with data from another in different tab
- Filters?
- Simple Excel Formula
- Switch for selecting specific worksheets
- Data Entries
- Excel automatically selects multiple rows
- Search or Find Name in a range??
- Restricting VLOOKUP return
- Profit & GST Return Calculation Program
- Column A by Column B, for entire worksheet