- IF function: Mixing "text" and field values
- Determining the average of the 50 largest values in a column
- Lookup problem
- =sum(xxxx!b4:b10)
- G/L Income Statement Template Setup
- Monthly Percentage
- Summary page using Cell colour
- If Statement?
- date(s)
- Summary page using Cell colour
- Calculating Average Days
- help with index link
- HELP NEEDED with COUNTIF in multiple sheets
- Tricky Formula - SUMIF function
- formula issue
- Data conditionaly display between sheets
- Urgent help with arranging data!
- Excel formula help
- new to excel - help
- Need help with concatenating strings
- Use of a name defined range in formula
- Help with percentage forumla please
- Double Minus "--" Question
- Countif, then average needed
- entering info to 2 workbooks
- Searching a String of text for a character...
- Multiple conditions within a sumif function...
- countif
- hewo
- hi, i could use some help...
- Excel Useful Links (see last post for new additions)
- How to use the IF formula for multiple conditions?
- Could some one help me do the following task...need a formula
- Conditional Macro
- Replacing negative numbers
- Need to change workbook reference only once
- Joining text in columns
- How to find sheet in formula by (part) cell reference. use Indirect ???
- Counting Conditional Formating
- Countif Based Upon Text Length
- displaying data based on selected worksheet
- IF statement
- Safe Guarding Excel Worksheet - Cells
- Copy Formula on Open
- total of hours worked
- Hours and number calculation - how
- Smallest number which is not 0
- Countif or Sumif with multiple criteria
- Prob with SUM Function
- Extract a part of a text string
- Subtotal Function
- Need help with text and numbers
- Need help with linking sheets (without source sheet)
- More Help needed again
- Next Avail Cell
- Mapping to another workbook
- Help with IF statement
- Combining spreadsheets
- conditional formatting
- COUNTIF with Date formula
- Insert Multiple Columns Between Data
- Display name of highest score
- HLOOKUP Row_index_num help
- need help w/ mail merge excel to word
- SCGA Formula Help
- Simple problem...please help
- Searching for specific text within a cell
- Search column and report all row data for each occurrence of a test score <90
- IF statements
- Remove contents formatting?
- Dividing a markup
- Function to generate next available number
- advanced dynamic range question
- Help with macro
- Help with Dates and IF Statements
- Help needed...
- CountIF
- Help with IF (again)
- Display a text in a cell
- Sum If with Multiple Criterias???
- Please hlep , I think this is easy for you.
- How do I change cell format from text to Hyperlink?
- another vlookup based on text entry
- Help with changing a number automatically
- program handicap 36 system
- Need Help with "SUMPRODUCT" fx
- Help needed with a Lookup
- COUNTIF using both > and <
- Searching data that contains wildcards
- Help with this please
- Will A filter do this??
- aantal.als - Countif
- countif subtotal
- Searching from bottom
- Looking Up & Transferring Data
- left lookup - return multiple values
- Conditional Borders?
- Sum (A1:n)
- Check box Help
- Find & Replace "Singular Case"
- Disabling GETPIVOTDATA
- excel sum unique values
- How do you get rid of one character?
- Having Cell Color Change Automatically Based on Value
- Finding Text in a Text Box
- I need help. With numbers
- Stock Quote Query
- Subtracting Weeks
- Estimator? Need a function
- How to substitute values between two worksheets
- Urgent HELP for Formula for a date problem on Excel!
- Delete Last Character if its an 'N'
- Auto Update Cell - Date and Time
- Count in a cell where there is several words...
- IF Function - Last Value
- what Fx will compare 2 cols & report falloffs?
- Concatenation of a variable inside a formula
- OFFSET/COUNTA merged cells
- How to reference cells in Next/Prev Sheets automatically?
- Copy Formula (Transpose) Cells While Incrementing Cells by 4
- Logical Function for three criteria?
- Shipping Calculator?
- Use IF, ISERROR??? multi-column match
- Data Validation-Different Sources
- % by "x" and color
- Data Validation and Indirect
- Multiple Questions Confusing me a lot :(
- testing and applying by data position
- retail price averaging and rounding
- Returning all matches
- VLOOKUP Troubles
- Blank Cell Result
- Is this Possible? and HOW?
- spreadsheet to automatically track funds - is it possible??
- Text response to the lowest value
- Simple File Handling Stuff
- Making data copy itself to another cell
- Calculating rent by year
- Insert Column Between Data
- cell splitting?
- SumIf with a twist?
- How do find Median of a set of totals and find the relating grade
- #na
- How to change format h:mm to [hh]:mm
- Problem with FIND
- Plus sign then cell reference
- Forcing Excel to insert relative reference
- Lookup
- Drop Down Menu HELP ...please
- Work Sheet Sum of Cells
- Average IF MOD - Stuck?
- Removing single quotes from cells without changing the formatting (bold)
- Need text in column fixed
- Preserving text format/style - concatenate function
- Re-ordering cells changes the formula
- Listing Nth Letter; A+2=C,C+2=E,E+2=G
- Count by value AND by font colour
- How to calculate duration of time
- Filter & Merge Cell
- Pounds and Pence
- SUMIF problem
- Help with Formula "Proper"
- Need your help: Using min, max, if & then statements
- Average only the Sheet/Cell with data...
- When Cell Value lies between two values?
- Time Sheet Help
- Date and time calculations and automatic date changes
- Auto Bingo
- Help: Need to find oldest date based on a location
- Need Help!
- Quick way to see position of each team
- Sum function
- Sum a range of cells containing numbers with letters concatenated
- Printing Question(s)?
- Sumproduct changing range
- Changing the value of a cell based on the value of another cell
- Search problem
- using TRUE FALSE chk boxes to determine a cell value
- Pivot Table dealing with duplication
- Skip Blank Cells
- If Statement issue
- Help looking up data that a lookup function won't!
- need help calcutating sum based on two criteria
- If Statement Help
- How to make the same range displayed in each sheet I switch to in my workbook
- Need Help calculating sum only for certain values
- Ranking/points
- Help Please
- Advanced if statement?
- Keep a single range static when filling?
- Converting Numbers to description in words
- date calculator
- counting single occurances
- Add number
- Filtering info
- need help with conditional formula
- Trying to create a variable link to another Excel file
- Help with copying
- Help! - Check 2 Values and count?
- Need help with an IF statement
- Over Rule - Formula Function!
- If Cell Contains 12
- HELP: Storing value / Counter?
- Sort values
- Whats wrong with this formula?
- Custom Filters
- Require help calculating longest winning streak
- Days and Years between dates
- formual to transfer data to next non-blank cell
- Cell Colour
- Sumproduct
- Vlookup - finding a value on one sheet and entering it on another
- Networkdays() And Now()????
- Hyperlink Help
- Compacting images
- Avoiding #VALUE! error
- matching date with NOW()
- Conditional Formatting and Re-sorting
- Dimensions formula
- AAAaaahhhh Multiple Sheets Multiple Criteria
- 1question
- excel formula
- Index sheet name
- Traffic Light Weekly Report.....
- Looking for help with concatenate formula - or something similar
- categorising columns into rows
- Add formula.
- IF Formula
- Is my IF statement too long? (determining quarter)
- Age adjusts relative to Birthdate
- Link not updating (OFFSET)
- totalling columns when both are populated
- format within an & operator embedded in an IF statement
- multiple conditions
- Workbook/Worksheet Data Transfer
- More date stuff?
- Time based Values??
- Sorting a league
- How do you protect cells on condition of other cells having data inputted?
- Help with VB code
- how do i VLOOKUP for partial value?
- Bar Code Scanner
- sumproduct question
- formula lost
- Combining
- Importing Names from another worksheet
- Change Cell Ref inside a formula
- Is there a way?
- Looking for help trimming data from a cell...
- Data Link