- [SOLVED] problem finding the median
- Simple function I am unfamiliar With.
- Find double numbers function...
- Counting special characters inside a cell.
- transferring code between workbooks
- Linked cells changing when entering lines
- Comission Calculator Formula problem
- Help on an array using MIN function
- Needing to move resutls from one sheet to another
- Function for Multiple Variables
- PreText for a cell?
- Excel workbook named formula problem
- Sort with Partial Text Match
- Capacity Calculation
- Auto Sort Alphabetically
- Hyperlink to specific text in another worksheet
- formula to return data from previous column
- [SOLVED] Function not getting the correct answer
- [SOLVED] Character limit?
- If & calculation formulas needed
- split info in a cell to different cells.
- Excel Homework trouble: IF function
- [SOLVED] Excel worksheet formula returning nothing
- index/match lookup - with If statements
- Reading the next name down
- I get error in VLOOKUP
- if functions and circular references
- Unsure how to properly execute tricky if function
- Add "if blank" to a Formula
- Automatically resorting adjusted data
- Basically swap first two columns of table
- Year function to get age but...
- Football Predictions
- Cell for user input or else function?
- Copy or print list from drop down filter
- Sorting data into 10% bins
- IF using words and average
- xlsx file, how to open
- Excel Formula for Creating a Dependent Cell
- Adding in a ADD statement
- Matching words from two different worksheet
- Random Time Generator
- Complex counting time function
- average question
- Formula to calculate which day its weekend
- [SOLVED] Formula to extract data from database
- If function
- Looping Columns & conditional text
- Average of last 5 cells with data in them.
- I want to show only weekdays on sheet
- [SOLVED] Error counting words in cell when there are zero
- Rank visible cells with autofilter
- CASE-type function in Excel?
- hourly rate and overtime factor?!
- could anybody help me? :)
- [SOLVED] Compute the FuTure Date when Start Date,Lead Date,Weekly Offs,Leaves and Holidays..!
- Goal Seek
- IF Than
- Ranking scores/names from multiple sheets on summary page
- [SOLVED] Using INDEX with named range reference
- Count in a range too high....
- Extra to previous thread by spitinyari
- [SOLVED] Troubleshooting Sumproduct and Countif formula
- function to search and replace
- drag formula and skip blanks rows
- VLOOKUP Return Horizontal Cell, Then Move Down Rows
- Vlookup on Multiple Worksheets
- Calculating needed responses
- [SOLVED] Vlookup to access data based on a drop-down list
- formula with arrays
- Workbook with muliple sheets
- [SOLVED] If / concatenate
- [SOLVED] using a vlookup and returning a cell reference
- [SOLVED] Adding ever extending data based on conditions
- SUMIF 2 conditions are met
- Time duration
- funtion argument
- Lock cells so content or formula can't be changed
- IF then funtion for 2 conditions
- VLOOKUP Changes Itself
- [SOLVED] Vlookup
- How to do this? Copy rows down based on number...
- glass pricing sheet, matching an m2 area to a price range
- [SOLVED] Take Two Columns and merge them without losing data
- Changing cell values depending on drop down selection
- [SOLVED] Using conditional formatting to find the respective remarks
- [SOLVED] Display negative time?
- How to count unpaid installments.
- Advanced Filtering question
- autofilter/comment problem
- Conditionally adding a border to a range of cells
- IF forumla needs revision.
- Malfunctioning SUMIF function???
- excel function help
- Inventory Running Balance
- [SOLVED] Formula for Both Base and OT Wages
- 1st of the month!
- Need help with organizational formulas
- search and match an unsorted list
- [SOLVED] How to format numbers into amounts
- [SOLVED] Modify NETWORKINGDAYS
- Delete specfic word
- delete a selective word
- Ceiling levels to a round figure
- [SOLVED] Conditionally collect data in one cell?
- cross sheet lookup issues
- [SOLVED] SUMPRODUCT combined with other functions
- formual to deduct vat
- Dependent counting
- Trying to take an average of numbers in specific cells...
- [SOLVED] Lookup from another sheet
- Formula to compare data in different pivot tables?
- split data in a cell
- [SOLVED] Function inside textstring
- [SOLVED] Index/Lookup formula
- [SOLVED] Coping specific rolls of a sheet to a specific rolls in another sheet
- Is there a function to link a cell to a fomula?
- [SOLVED] Pushing data across column when new data it entered.
- Another IF statement nesting problem
- Linking 2 spreadsheets without using vlookup or range lookup
- sql.connect
- Multiple correct in data validation drop down box
- [SOLVED] hyperlink mailto function, need to take body text from cell
- How can i shorten my formula
- Put 2 IF STATEMENTs together
- Formula?
- [SOLVED] Lookup Formula with two lookup values
- [SOLVED] If Statement based on validation list
- [SOLVED] Count number of dates older than 30 days
- Sumif across columns
- Selecting specific cell if score falls within specific range
- Average? sub Average?
- [SOLVED] Match and Index
- Concatenating columns
- Replacing Subproduct - Slow Calculation
- [SOLVED] Formula to copy some rolls to specific rows in another worksheet
- Find and Add data
- Separating Text & numbres
- [SOLVED] Worksheet search display problem
- [SOLVED] Problem with OFFSET function used in Named Ranges
- [SOLVED] Summing decimal time entries
- [SOLVED] Count number of entries in a Sheet
- Problems using Date in Advanced Filter
- [SOLVED] ISNUMBER problem
- array or match - I'm confused!
- Cell pattern in function
- calculate end date using start date and number of specific weekdays
- Building a comma delimited string from Cell Range
- How to sum accounts and subaccount
- [SOLVED] Calculate prices using values entered by size
- [SOLVED] Work around to the 7 function limit with the IF function
- [SOLVED] sum for mutiple returns - formula needed. sumif?
- [SOLVED] Value Pulled Per List Drop Down selection
- Multiple "IF" commands with different formulas calling from a Table.
- Populating a table from Pivot data
- Linking worksheets using common data
- Remove duplicates issue
- [SOLVED] Display the top 5 values withinin a range on a different row.
- [SOLVED] Non-nested IF Function?...
- [SOLVED] IF Statement
- [SOLVED] Looking for a counting formula...
- [SOLVED] Lookup or match
- picking up figures
- INDEX, MATCH Multiple Values
- [SOLVED] Total number of unique matches in two columns
- offset function
- Little programme for company
- [SOLVED] Find/Replace (Selection only)
- [SOLVED] lookup values in two different sheets
- [SOLVED] Preventing Cell Reference Deletion
- Average formula for non-hidden rows only
- Basic VLookup function doesn't work in large data set from msquery
- Subtracting Date/Time w/ Criteria
- Search (match) through columns and find ALL matches
- [SOLVED] Using Named functions = Error. (#VALUE!)
- Automatically add data by quarter
- [SOLVED] Summing totals through IF function...
- [SOLVED] Filtering a LONG list to entries in a shorter list
- [SOLVED] Using Lookup function in a larger formula
- [SOLVED] Difference between two times - thank you!!
- How do I return the next lowest value in an array?
- [SOLVED] Counting multiple conditions
- [SOLVED] merge 2 named ranges
- New Sheet Add, Sheet visible & Menu disable problem
- [SOLVED] Lookup across various sheets
- vlookup for date values
- [SOLVED] Conditional formatting across worksheets
- Columns with the most similar data
- To give a solution in another cell
- Generating a Leaves Table in the specified format.
- Unique values in a column with duplicates
- [SOLVED] Matching and Sorting Non-Identical Row Pairs
- After copying sheet I get this message?
- [SOLVED] Conditional Formating - Adding & Deleting Rows
- how to organise this into spreadsheet?
- [SOLVED] finding or matching data
- [SOLVED] Find Data that matches query
- IF AND OR Complications...
- [SOLVED] Display the value of a cell
- [SOLVED] SUMPRODUCT to accurately calculate tiered sequential pricing.
- type in values in column A and then just print the rows that have a value in column A
- [SOLVED] customer records data sheet
- IF statement
- [SOLVED] Can we use two ranges in Networkday Function?
- [SOLVED] Placing the date (1-JAN-2008) in the right column for DAY
- merging data from two cells
- [SOLVED] Formatting Cells From Another Cell
- [SOLVED] Flagging Duplicates based on Multiple conditions
- [SOLVED] To get the Alphabetic Name for a Column No
- Mround function
- If statment on cell with fractions
- split the phone number and email id into two different columns....
- [SOLVED] Excel Can't Multiply...why is simple multiplication incorrect?
- [SOLVED] Can you Track the date a different field was updated?
- counting changes made today
- [SOLVED] Counting multiple text conditions
- DMEDIAN or DMODE ??
- ctrl-shift-enter problem transpose
- Vlookup & offset?
- Vlookup to different workbooks
- Vlookup - Dynamic Columns
- Combining few columns logically
- atMerged cells not allowing Index Mch function to give value
- Forumla for creating yearly event calendar
- Multiple Criteria Data Filtering
- Using Index and Match to organize by rank
- Word count
- Simple question regarding IF statements
- [SOLVED] IF FUNCTION (maybe)
- countif and multiple named ranges
- [SOLVED] Using vlookup to get a sales volume but need to meet 2 criterias
- comparing values in two sheets of same workbook
- Formula - poss countif and sum
- AVERAGEIF Function in Excel 2003
- [SOLVED] IF/THEN Statement with Calculation
- Multiple Part Cells?
- using x as cell number hard to explain
- IF + ROUNDUP hierarchy
- I need a warning message!
- Formula to return Unique Entries Only
- Sumproduct help!
- [SOLVED] Formula not Calculating Except After Using Text to Columns
- 24 hour time to change date
- Put colums with data together
- Copy rows to new sheet if value of cell entered greater than 1
- Need Help with sorting functions
- Mouse Over Behavior
- Sorting Cells in a Clump?
- Referring to defined names from cell contents
- formula matching 2 separate factors to lookup a 3rd entry