- Column Headings
- Adding just the negative amounts possible?
- inserting a null cell using IF
- time calculations
- Sorting where data in columns is slightly different
- Counting values in different columns
- clustering tabs
- Sharing data between different documents in an excel spreadsheet
- Extracting combinations of letters from within a word
- Using index to lookup over large area
- Want to count how often some values appeared
- Sumproduct & Average
- find min in one row return value from another
- resorting after a data change??
- search a unique value determined by 2 variables
- If statement question
- Repetitive calculation across a range of cells.
- Checking two cells for zero with =IF function
- Creating Search Bar
- Hi all! Noob here with a question.
- extending formulae & value; Don't change lines
- Sum & Cell Format Question
- Inacurrate Summing
- modifying formula dynamically
- Top Ten List
- cant figure out what I'm doing wrong or missing...
- How to convert "Jan 1983" to "Jan 83"
- summing totals from codes
- find first thing in a column
- FALSE error message
- cell repeating?
- Sum C for similar text in A
- Lookup / Dynamic sorting of data
- Vlookup
- IF function with multiple criteria
- Vlookup query (aren't they always?)
- VLOOKUP query
- Extracting numbers from a combined text & number string
- Reading numbers in web query
- How to create drop-down list in cells?
- summing only bold entries
- Troubleshooting Covariance Errors
- Updating different cells based on one's value
- referencing a cell and displaying different values
- floating balance?!?
- Summing different datas in different woorksheets
- Sumproduct, Sumif, or Array Formula?
- simple 'lookup' question
- IF Function
- Determine a techs general area.
- sum from text
- Countifs
- Create tabs using macro
- Averages from Drop Down
- XIRR: Different cash flows but same answer. Why?
- down and across
- Sorting Names and Times
- Copying data
- tax table H or Vlookup
- User Defined Function Update problem. Strange!
- Extending repeated if function for continuous cells
- formula for adjusting allowable percentages
- IF AND Question
- Matching list to main title
- combine date and time entries for plotting
- text lookup and match
- "master" sheet - that is, generate a list combining all lists
- COUNTIF looking for BETWEEN numbers
- Calculate difference between two dates, in hours, excluding holidays/weekends
- [Group]
- Question about IF/THEN
- Comparing Spreadsheets
- Can YOU solve my Problem?
- Can IF conditions be used to change line colors on graph?
- Countif using multiple variables within a column
- How to show 0 if there is the error #value!
- Find Last Non-Zero in a Range
- convert number 104052 to time 10:40:52
- How to convert "2.02 -" into -2.02?
- how to put many functions into 1
- #VALUE! error
- problems with a range
- Variable data
- text and =sum same cell?
- combining columns
- COL_INDEX_NUM fixed in VLOOKUP in Excel 2007
- Countif function
- Sorting results automatically
- multiple if's and case sensitivity
- Counting text values in column
- combining 2 formulas markup roundup
- Financial Functions
- Converting USD$ to AUD$
- Identify then input
- Create a variable rate bond table
- How do I maintain the integrity of array in a formula...
- Convert Field to Include HTML Tags...
- Cell Value Reference
- List with ability for user to add selection
- Insert letters
- Consolidating Lists with link to data for text and data fields
- nested formulas
- Writing a complex cell formula: y = y + sinycosy + 4/3(1-cos^3y)
- Counting Items
- joint two columns
- Addresses by household/individual-how to
- Convert . to , and move the last caracter to the front.
- cannot change format of cell unless I open it
- How to copy formula
- delete dupe addresses????
- Protection
- Bold if Value < X
- Looking for Formula
- delete rows in a patterned sequence
- working with data in different spreadsheets
- Search()
- Accumulation in Excel ???
- Counting unique occurences with criteria
- input sheet
- Excel- text to columns
- Shared workbook - merge cells unavailble
- Finding top 2 values per group based on multiple criteria
- Pasting
- Cell lookup and output issue...
- Choosing random entries from a list
- is this possible?!?!
- If And Date Function Problem
- Re-organising a table of data ?
- Calculate numbers stored as text
- Mutiply
- Filter a column of birthdates
- Finding the 2nd instance in a lookup
- Format all cells with formulas
- choosing a default value of 0
- Excel 2007 - Icon Sets
- Count and sum cells meeting two conditions
- Formula for future value
- Vlookup
- drop down box to relatively update its cell link
- Worksheet Change Event for Multiple Rows
- drop down
- Vlookup Problem
- Calculation Of Last Payment Made
- calculate of total working time of an employee
- Cell function problem
- Using Autofill in a macro with variable rows
- New user with mortgage formula question
- Auto Formating
- Finding Text / Totalling It Up
- Cliff
- SumProduct question
- Excel formula question re duplicates
- Can't lock specific cells.
- Work Schedule
- Transaction per minute
- Auto Delete Repeating Values
- XIRR: a bug?
- Profit /loss calculations
- Calcolation disabling parzially
- text to number in drop down box
- how to find matching names in two columns ??
- VLOOKUP in another sheet
- lookup/match
- ignore merged cells when filling
- Avoiding Wildcard effect in VLOOKUP
- SUMIF function w/ external reference
- Compare Data
- Dragging Problem
- Row+1 with Vlookup?
- Sumproduct and Subtotal Question
- iserror #n/a can't solve
- Locking Columns
- VLookup
- Formula to automatically expand each week as new data comes in
- IF function, & VLookup
- Compare lists of text
- Mapping
- Choosing cells dependant on values
- trying to modify IF Statement result
- Countif and non adjacent cells range
- Counting Dates
- VLookup Mutliple
- Address Return Nincumpoopery
- Problem with Sum function
- Dates in Sumif
- data validation list box
- Lookup a cell based on 2 criteria
- Run a script when the document opens?
- Merge Excel row data with text template
- SUM(IF across multiple sheets
- What functions would I use to get money values over 30, 60, and 90 days old?
- Change Text number entry to Currency format
- Determine Top 5 in Column
- Counting by Color
- If function
- Vlookup problem
- Remove Duplicate Email Addresses
- best way to total items on order form
- Viewing Gridlines
- Search Function
- grab all info right of @ symbol
- IF function and circular reference
- conditional problem.. am I missing something
- IF Statements
- Aging analysis formulae
- Profit /loss calculations
- function
- Method for drop box sheet1 from list sheet2
- Disable a form button
- Increment cell
- Data lookup and matching
- Simpler Array Sum/Match Function?
- How do I put clipboard text into a var?
- Formatting TEXT using TEXT function
- IF statement for inconsecutive cells
- Excluding Blank Cells in Conditional Formatting
- Restricting Text
- Pivottable Question
- If And
- Link rows for sorting
- copying conditional formatting
- Percentage Formula Unknown. Plz Help!!!
- Extracting and sorting data from one workbook in another
- Pivottable question
- Linking rows to another worksheet based on contents of a field
- Passing variables
- !!??Using a formula to change the colour of font!!??
- Lookups
- Validation
- Uneditable Range of Cells
- spreadsheet formula
- Hiding an #N/A error
- Reference Functions
- VLookup question
- Parcing spacific data from a cell
- Properly linking data from 2 sheets in a workbook
- Looking up values in a table
- countif
- Compiling all data from multiple sheets as its entered
- Using a cell value on the current worksheet in a formula referencing another workshee
- logical condition
- help to backtest my trading signals
- linking spreadsheets and reporting initials
- setting up sum
- Pls help
- function to sum based on date
- One more question in function
- Getting the Total right
- CountIF Between 2 Dates
- Insert user name