- Refer to a named range indirectly
- Derive Average
- Renaming worksheets
- COUNTIF Question
- auto filter
- Header/Footer on entire workbook
- Linking data?
- how to display my cursor cell content in another cell....
- Excell< another dillemmmmaaaa please help!!!
- excell big dilemma
- Delete a toggle button overlaying data
- EXCEL FIND A SPECIFIC TOTAL
- Function to return the last value in a contiguous set of data
- Pivot Tables (Sumif)
- CALCULATE PROFIT/LOSS
- Vlookup for multiple results
- Format Cell
- SUMPRODUCT Help
- finding the earliest date in an array of cells
- New row(s) macro
- If Month?
- Reverse SumProduct function
- Survey Form And Tracking Results
- Forecast Formula
- DSUM to pull data from Access DB
- 4 IFs
- ROUNDUP to nearest 1/16 (in decimals)
- Value of particular column
- Copy format
- how to find cubed root of a number
- To Calculate the qty b/w two dates
- IF Function in Excel
- 3 zero instead 1 zero
- Can a formula tie the fill colours of two cells?
- Filtering the Column headers that contains data for resources
- How to get 2003 Excel pivot table to work correctly?
- HELP! Need to sum columns where credit balances are shown as ###CR
- help with calculating average prices and profit/loss
- HELP! Need to divide all columns by same number to get sell price
- i want to count how many times an entry occurs in an array
- IF Statement, multiple criteria
- Formula to run report
- how to create row with data
- How will hyperlink cell reference update after copy paste?
- Subtract 10 months from a Speficic Date
- subtotals in excel
- specific percentage formula
- sum of every 4th cell in a row.
- Copy only letters, not numbers
- Drop Down List Question
- Creating an if then function to manage deductions from different c
- Evaluate based on Actual Month
- How to paste phase and seperate into another cell by a symbol of.
- Nesting the roundup Function in a larger formula
- Excel Office 2007
- Conditional Formula
- Sumproduct excluding multiple criteria
- Multiple criteria in 2 different columns for a sum in a 3rd column
- forecast using a four parameter logistic equation
- Print first column on each page
- Formula (not adv. filter) to list unique values from list
- Conditional Formatting, multiple conditions
- data return using multiple conditions
- why does excel 2007 subtract 2009 from 2015 = 1900?
- divide column b by column a
- Copy cell contents depending on font colour
- VLOOKUP results is duplicating first value
- Using range names in functions
- Printing different work sheets in colour when the default is b&W
- Protection Macro
- Counting Cells With Text
- How do I select cells for a specific month in Excel 2003?
- exam marks into grades
- Formula not working
- IF Function
- Calculation of Quarter
- Show in another cell only >0 from a range?
- reporting with pivot table?
- Create A Master List From Several Lists
- Help!!! - logical function for someone not very logical
- Repayment of loan excel sheet with variables of principal free pay
- Insert Date
- How do I count cells with specific value?
- Moving formula results to blank line
- Repaymen of loan excel sheet with grace period etc...
- First Time Macro
- Find column letter of the first unused cell
- Function Question
- data entry problem after upgrade to Excel 07
- corrupted excel files
- Using MIN & MAX
- Cell referencing
- Find amount in row.
- difference of 2 dates
- page numbering of worksheet
- Find the Date of the Next Friday
- Hep with Find and Replace
- Need help with formula in excel
- Time difference function
- convert number to intext
- fromula error
- workbook_open() does not execute if there are conditional formats
- sumif - if the text has LCI in it
- 0.5883698 Does This Look Good? ... 0.7272271
- can I write a function that automatically changes over time
- Eliminating duplicated data completely or something similar
- Links won't update if file is closed
- Time & Date Formulas
- Item Lookup
- Link from 2007 to 2003 Version
- Click and drag a formula
- How can I create multiple tables of figures?
- How to display result of 3 possible outcomes
- DATEDIF function in excel
- Count If trouble
- Importing CSV Data from Web?
- TOTAL OF A RANGE SHOULD BE
- Cell color changes when date gets closer
- creating tabs with sub tabs
- Nearest Month
- Difficulty cleaning some char(63) characters
- Adding a zero to the front of numbers
- Format Cell using letter & number to use in mail merge
- transpose data
- Selecting data in a specific date range using COUNTIFS function
- EXCEL: find string in vector & return cell reference
- Combinations - multiplied sum of doubles, triples, quadruples.....
- Conditional format Order
- Absolute Reference Changes
- Sum values in string in a cell
- macro protection
- Coding Custom Date Functions in Excel
- how format date with TEXT() function for international usage?
- moving from one sheet to another from a cell of a sheet
- One less than Max
- Trying to HLOOKUP a value from another sheet and display all the d
- Lookup or Vlookup?
- permutations
- Vlookup issue
- what does the & symbol do in a formula?
- How do you assign a Workbook Location Path to a cell?
- Many possible variations
- COUNTIF greater than one column and less than another
- Conditional formating based on multiple comparisons
- conditional formatting using formulas
- Typing in a list to locate name (Excel 2003)
- weighted exams, predicting what the final exam needs to be to pass
- Can Excel's field fill colors be changed using "IF" statements?
- IF with and OR
- Can the Excel cell fill color be changed using "IF" statements?
- Cannot verify XNPV with PV or HP-12C
- Sum of Price Given Specific Dates
- Excel 2007-SUMMING from different worksheet conditional to the dat
- Assign password to "Very Hidden" worksheet
- Flagging dates with conditional formatting
- Rapidly Create a Large Number of Named Ranges
- Conditional Formatting
- change a group of cells to absolute
- Transferring CERTAIN Data from one worksheet to another
- Sharing data from one worksheet to another
- Conditional Formating
- If I am within the time specified..?
- How do I remove auto filters from a file I exported out of Salesfo
- SUMPRODUCT formula
- Counting text in two different columns
- INFO("directory") function
- If Function
- Row Number of VLOOKUP result
- Is this function supposed to work?
- stop error message "too many different cell formats"
- Adding cells of same conditional formatting
- Temp vaiables in formulas?
- If cell not null use that value
- Data is not printing inside cells in excel
- how do i see my whole document in the workbook
- Conditional formula
- IF Formula Question
- countif = to
- EXCEL function;find string in entire column & return cell referenc
- adding TIME through midnight calculates ok, but subtract doesn't
- Formula for giving point to particular no.
- Attendance formula
- Text from a comment box into a cell
- copy cells daily and automatically
- Lookup for a word in a table
- Sum of constant decrement
- got #REF! with fomula PRICE()
- Conditional Testing of an array
- CountIf on Date / Time
- calendar control for week day
- if formula
- ISTEST Function
- Calculate items based on calendar year ending today
- Please help - Find & copy Macro
- VLookup - find new items
- Calculate End Date (excluding weekends and holidays)
- Como alterar o cabeƧalho das coluna de algarismo para letras
- Text from a comment box into a cell
- How do I link 2 spreadsheets to insert amounts on a defined date?
- decrease integers to zero
- Dynamic List of names?
- Find and copy for inventory
- Cell Protection
- PDF macro button
- Help with Lookups
- Subtotals in Excel 2007
- sort and blank cells problem
- how to count charactors in a cell
- convert seconds to hours and days
- Excel - Check Box Functions
- IF Statement
- Hide Blank Rows
- Help with LOOKUPS
- In Excel 07, how do I merge two sprdshts with a common column?
- IF Statement using several columns
- Vlookup in multiple columns
- push result from one cell to another
- auto/coditional format
- Weeknum
- Solution for if x = 1 and Y =2 goto C3
- Displaying multiple non-adjacent cells with 1 criteria
- Vlook up with if statement
- How can I get a drop down to update the range of a formula
- can we count words in a row which has links from other file
- Fill Series function question
- Change Row Colour if certain criteria is met
- Multiple variable lookup tables
- Conditional Format
- How to use formula to the Ans
- Fill down not working in Excel 2007
- using the address referenced in a linked cells
- Sum Across Multiple Sheets
- Excel Formulas
- Number of characters in a cell for a Index/match function
- RE: Converting Values to Columns??
- Question about condition formatting?
- How do I set a maximum value (e.g. cap at 200)
- If Function returning 0 instead of cell value
- dragging formulas across rows
- Converting Minutes and Seconds ([mm]:ss) to Decimal
- Copy last cell with data in column E on one sheet to cell on anoth
- Count NonBlank Rows with Criteria in another column
- counting the number of rooms
- Go to cell address
- how can I isolate the data in a worksheet from the rest of the pa
- Splitting data from cells into multiple lines
- lock cell whit first value
- Assigning a Worksheet Name to a Cell
- Formula for attendance record
- fix #N/A error
- setting up networkdays
- "copy"
- in range?
- Generate reports on separate tabs from data in file
- while entering credit card numbers last number changes to zero
- COUNTIF on NonContiguous Cells?
- vlookup lookup_value text
- Need an expression that's larger than my skill
- List to Table - formula
- Using Indirect for conditional Formating
- Learn Macro & VB Code that usually put in Excel.
- sumproduct formula help
- Vlookup Question
- How do I use vlookup to return a formula not a result
- Highlight selected cells only
- Upper case to Lower case
- Formula or Macro
- AVARAGE TIME
- Search of particular combinations
- how can you add attachment at the spread sheets
- GETPIVOTDATA on Excel 2000
- Updating a Formula Based on Multiple sheets
- Deleting rows
- Calculate score from Scale
- I enter a formula but the results are not displayed
- IF Statements using previous cell references
- partial match in vlookup with table array
- VBA code for find function (reference cell value)
- Edit formula over a range
- Help with 'If' function
- sumif any text is criteria
- Percentage of Multiple Rows
- Using COUNTIF and OR
- repeating the answer in A2 cell to A3:A20
- Financial Functions, in particular, the INTRATE function
- "Go Back" Feature and hyperlink
- repeat row labels in pivot table
- CountIf Functions
- Lookup 2 values and return a third
- Cell reference within array
- Export row depending on column to various sheets
- How do I locate cells that contain a certain text?
- How do I sum the last 5 nonzero numbers in a row?
- Developing Aging report-problem with 'if' statement
- Std Dev of Aged Inventory
- Getting the "0" out of an auto populate cell.
- More than one variable for Countif
- running macro's in Excel 2007
- Hiding Formula Answers in Specific Cells
- how do I reverse alphabetizing?
- Auto-adjust formulas
- Hiding sum formula answers in select cells
- Countif range contains part of a value
- AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT
- How do I get my Excel 2007 worksheet to go beyond 65536 rows?
- Conditional formula based on 2 pre-conditions
- How can I stack worksheets (I have 30 worksheets)
- ifblank function
- =sum
- days and time functions
- Approximate match on string of text
- To work out how many days, weeks, months to I retire on 20 Sep 201
- COUNT and SUM (please help!)
- hlookup value within a range
- Is there a way to use Formula to resolve
- Removing Mulitple Carriage Returns Within a Concantenate Formula
- Search a name in one sheet and entry it into another sheet
- unions, intersections or array constants
- copy conditional format without using format painter
- Formula/Sum Question
- COUNT and SUM
- Column Titles
- Counting the number of occurrences...
- address of first and last number in a row
- How to reference last non-blank cell value from a column cells?
- Duplicating check boxes with formulas
- countif question
- How do I get my shortcuts to stay on the Quick Access Toolbar?
- count across 3 columns
- Can anyone
- COUNTIF Function Provides Text Feedback, Not Values
- How to set up a devilery schedule calendar from excel database
- Problem with VLOOKUP
- Can users perform a reverse lookup
- counting in columns
- convert [h]:mm:ss to real number that I can use as a multiplier
- Sheet direction, extract data from comment
- Help on IF (i think)
- When there is a tie for "MAX" values...
- workbook totals
- Exce Formating
- Help IfBlank use data from next cell
- Display Multiple Worksheets
- Displaying Cell Formulas (without using Tools/Options/View-Formula
- GETPIVOTDATA Excel 2000
- looking for a rental property expense income worksheet
- Background and Calendar
- How do I weight numbers when some are zero without getting DIV0
- Formatting Cells and then deleting the reference column
- Need additional coding help
- counting in columns
- return second or third word in a cell
- change feet and inches to decimal inches
- Ties using Rank Function
- information automatically changes
- have an entire row populate with a link when the data in a cell ch
- have an entire row populate with a link when the data in a cell ca
- help with date funciton
- Another table lookup question
- Counting values in column B in condition of A
- comparing two columns revisited
- Conditional Formatting Problem - Dynamic Formula??
- sorting data
- Determine decimal
- Embed Data from a named Range into a text box
- comparing two columns
- Combine IF function with manual entry
- Re: my excel spread printed the cell numbers and letters/what's wrong
- my excel spread printed the cell numbers and letters/what's wrong
- How do I?
- what is the purpose of . bars
- Need multiple IF questions & return a value from another worksheet
- variable in data validation
- If statement to copy an entire row to other worksheet w/ in same b
- Data sorting formula
- VBA Sheets.Add disabled
- Can't edit worksheet
- Sumproduct not works
- Sumproduct not works
- Formula to get the Ans
- Formula to get
- Number to word
- Customise a Date to display as something else
- How to calculate worked weekend days
- COUNTIF or SUMPRODUCT
- Excel work book
- if then statements
- Vlookup with Match - no results issue
- How do you reference another worksheet without using its name
- How do you reference another worksheet without using its name
- How do you reference another worksheet without using its name
- Countif ā Multiple column criteria ā with ādoes not containā
- compare rows for a match and sum the matches
- Multiple values for LOOKUP? Maybe add IF clause?
- Conditional Formatting HELP
- Excel
- worksheet
- Why would a vlookup function stop working in excel 2003?
- Trailing zeros
- Number of days in a specific month between various start and end d
- Drop down menus
- How to average random cells with out counting zero?
- Convert a 8X3 table to a vertical range of the Unique strings only
- Excel Function
- expandable Text Box
- How does a module of VB work in a Worksheet?
- Invalid outside procedure (creating a PDF button as a macro)
- filter imported data to columns
- Conditional formatting - case sensitive text
- CF to grey out the two unused options
- 2 conditions for IF function?
- Regex Syllables, Harlan Grove?
- how do i add same prefix any text or number to the large datas?
- Sumproduct - multiple Sum ifs
- Mark certain cells
- How to get timein hh:mm format
- Allow Delete cells but not rows
- VLOOKUP Errors with Date formats
- How to get rid/hide #NUM! error in Excel 2003?
- Getting data by calling out date
- How do I lock a section of cells in place
- How to return unique values only
- Automatically add a column to summary sheet if another worksheet i
- formulas
- Sum a range that IS NOT NULL
- Extract value from a text string
- Combining use of Check Box and Option Button
- date & time
- Nested formula Value error
- Advanced Filter - Named Ranges
- handle error in IF ELSEIF statement
- How to convert "read only" to a working sheet?
- Function =Trim()
- Function =Trim()
- Hide Alternate Rows temporarily to Edit worksheet
- Largest number 2
- calculate fractions using dates
- How do I create an Inventory list using Excel
- Largest number
- Split screens
- Multiple cells to look up and return values to another spreadsheet
- Fill Color related to % complete
- VLOOKUP PROBLEM
- Excel is seeing the date as dd/mm/yyyy
- Leap Year
- Summarize & Delete
- Summarize & Delete
- Pivot Tables: Excel 2003 vs Excel 2007
- V LOOKUP
- count number of dates falling in the next seven days
- Display time in text
- Countif
- Vlookup & return multiple unique values
- Excel conditional format only if all cells contain values?
- Help with automatically sorting data
- Stat testing %s between 2 groups
- Equation Efficiency?
- HOW to built a IF formula , if any test fails, none of the other onesto be done ?
- combining COUNTIF and OR functions
- HOW to built a IF formula , if any test fails, none of the other onesto be done ?
- count month when date is in day/month/year format
- Help with Average formula
- Need a fresh pair of eyes
- Highlight Cell Changes When Using Data Connections to Access
- Bold a line
- Change Color on rows, after an IF Funtion is answered
- Text to number value
- Duplicate Difficulties
- Calculating Time
- Data Tools - Consolidate Excel 2007
- Formula
- How do I get numbers to foot across rows and colums?
- How do I get numbers to foot across rows and colums?
- conditional formatting is not avaible
- how do I merge multiple csv files in one Excel file?
- Due date - change cell color
- Benford law option available in Microsoft Excel
- Multiple selection criteria
- Calculating Dates
- How do I create a custom button that combines format settings?
- If Unction with text
- LOOKUP between two columns of diff. size
- Can't merge info from Excel onto address labebls
- Substitute
- Is there a formula to calculate the least common denominator?
- Hyperlink
- Automatic notifications of changes?
- Conditional lookup
- CountIf Condition based on lookup in a list of values
- How do i create a drop down list from information on another works
- From multiple reporting people able to indentify next due report
- sumif function
- How to check the whole column at the same time?
- Help! Rounding Up Formula
- Vlookup across several sheets
- Help with formula to round up to next higher multiple of 5
- SUMPRODUCT formula help??
- Currently using '97 version.... Should I buy Office 2007 or 2003??
- Countif IsErr
- Max Value of conditional list
- Cell Reference Issue
- Duplicate Rows
- using COUNTIF I want to count multiple values
- YTD Calculation using SUM and OFFSET
- Macro for Proper function
- Consolidate Multiple Workbooks - Excel 2007
- How do I carry the calculations over to the various worksheets
- If fomula
- Posted in excel.public.programming ... Count only theformula/function find the same value ...
- Flashing cells
- flashing cells
- How do I calc the time difference in hh:mm for shift work?
- Formula Help
- Excel 07 worksheet problem - HELP!!
- help with vlookup and return based on a formula
- Differences between columns
- Need to get Address() to Average Function Range argument
- Return first date populated
- Please HELP!
- data alteration
- Finding Multiple Instances in a List
- Time difference btwn entries
- How to change the row1 content of the existing excel file automically
- Missing info on worksheet
- Multiple Instances in a Column
- Column Number of a cell with text
- Formula to count the number of unique dates
- Conditional formatting, change row to certain color
- Hyperlink to cell in separate workbook
- Open XL - A Powerful Excel Addin
- Open XL - A Powerful Excel Addin
- Creating new worksheets
- Filtering based on Value
- Pick up some text in a cell
- Excel 2002 count color
- Tranfer of data via v &/or h lookup
- How can I transpose cells associated with a merged cell?
- to pull out information from certain cells of hundred identical wo
- Challenging SUMING situation!
- Conditional Formatting
- How do I find the distribution of a sample mean????
- Coutn specific cell with specific value
- I need a self calculating time sheet for Excel 2000
- Function to autofill remaining width of a cell
- combining vlookup and hlookup functions
- Copy functions from one file to another file
- Function to display text
- scrolling
- Long Date Format
- two column lookup
- Excel to inport data
- view excel worksheet & freeze internet window synchronously
- random between function
- Excel formula help
- Having trouble printing without the cell gridlines on new system
- Vlookup using a dropdwn list, check different tables based on drop
- link data from several speadsheets
- Flow Chart
- How to refresh links across workbooks
- Trapping errors in a VLOOKUP function
- Extracting all matches
- Flashing cells
- returning a SUM from text.
- why does worksheet require two different forms of same formulas
- comparing and isolating duplicates in two columns
- Variable reference in a function
- How do I move addresses in my contacts into an excel format?
- HYPERLINK
- finding top 80% line from a descending list
- Trying to randomly choose a number from a set list of numbers
- Trying to randomly choose a number from a set list of numbers
- Trying to randomly choose a number from a set list of numbers
- calculate percentage??
- Count Num of unique items in col? by 3 criteria
- Count Num of Unique items in col ?
- linking between spreadsheets
- Macro with sum function
- Text Search
- view excel in full screen view
- Open Workbook Formula
- Vlookup, Column Index Num and Autofill
- Extracting certain text from text string
- Insert a cell value into a link to another worksheet.
- Counting cells that have a checkbox that is marked
- compare date and perfom calculation
- Re: Outline/group data below
- Office 2003 Excel funtion - data table
- Synchronize the Pivot table page field selection in 2 tables?
- Values Distribution Across Months
- IF value in Y cell = X color Z cell
- Delete All Links to Worksheet
- SUMPRODUCT usage
- What does 'floating dollar sign' mean?
- How do you use a blank in a formula in Excel - If a1 is blank
- moving several columns into 1 continuous column
- Cell flashing
- IF value in a cell, return another cell's value to original cell
- VLookup?
- Linked workbooks
- Locking Columns in excel
- Finding duplicate cells within a worksheet automatically
- Hyperlink
- PPMT Function Repost
- IF Help
- Formula suggestions
- Formula Help data match up
- in the worksheet, a1 to a10 have numbers. I want to calculate to a
- Locate data from 1 column in another
- Is there a formula that doesn't change current cell if false?
- conditional formating if and And
- Revome blank spacing from ending Numbers
- EXCEL Help please
- COLUMN() problem with array formula
- PARTIAL MONTH DISTRIBUTION
- array formulas counting substrings across rows
- Need Improved String Formula
- SUM Formula and Logical Values
- Convolution
- Getting wrong answer with Match Function
- Euro symbol displays as dollar symbol in Excel
- Update a hyperlink in excel spreadsheet
- Average by Multiple Criteria.
- Formula Help for Counting categories in a column
- comparing columns to find dup's
- Formula Help
- Date Prompt for 1 day
- Variable Symbol
- Consolidate 3 lists with duplicates into one list
- Transpose columns into continuous rows
- Autofill column from data (code) in column next to it
- Returning multiple values that are NOT in a single column or row
- Multiple If Statements
- 1 Vlookup multiple results in different columns
- If formula
- Duplex Printing Macro
- Top 25 List of Times
- index and match on 2 criteria
- Data Sort header row
- Accumulator
- Format text in formula line
- Problem with Vlookup
- Average function
- Row increments -
- Converting decimals to Time
- Max number in list of duplicates
- per centages and sums error
- Is there a formula for....
- how to create an absolute value
- SUMPRODUCT - Creating a weighted score in column with subtotals
- Nesting IF to correct #VALUE! Error Message
- Nesting IF funtions
- Dependant drop down list with more than two words in the options
- Check for a word
- Transfer Information
- 2007/macros not working
- If - Then statement
- Find and replace *
- Custom date fields for pivot tables
- Check Box
- create a automatice invoice from a data extract
- Conditional Formatting
- SUMIF, wrong result, strange behaviour
- Conditional formula with multi tasks
- How to consolidate 580 file's data in 1 sheet without oppening all
- bug in excel 2007 for sorting function?
- Want a trace a same values exist in two different sheet
- Matching & adding text in the respective column
- Formula for Multiple Variables.
- first and last occurance
- How to get text which is inside the brackets in excel sheet
- RANK ABSOLUTE NUMBER AND WITHOUT GAP
- linked data
- Start Day of Bi-Monthly Pay Period
- Define cell value in a matrix to add up 2 constraints value
- compare two or more ranges
- Compare ranges
- Cleaning a list in Excel
- create table of selected rows
- Lookup Question
- Date open file with date saved
- calculating percentage of year passed (for sales reports)
- Average a group of numbers within an date range.
- Not Counting cells that have a formula with ""
- I need a lookup function using range names!
- Custom Toolbar from Excel 2000 to Excel 2003
- Drop down list from another worksheet
- Sumif based on criteria on another cell
- Counting rows that meet multiple criteria
- Counting rows that meet multiple criteria
- Multiple formulas in a single cell referencing a drop down box.
- Data Validation
- How to sum cells based on conditions
- Custom Number Format
- EXCEL Pivot Table
- Worksheet is not calculating
- Drop Down List
- Sumif based on value in cell
- Automatically insert a line
- conditional formatting based on different cells with more conditio
- What function do I use
- sum table
- Conditional Function
- MROUND
- Look Ups and Matches, Sorry if current thread exists- Clueless
- List Box and IF function
- Duplicate data entries
- Vlookup Different tabs based on Dates
- simlple question
- Lookup table for rates?
- concatenate won't work
- minimum value in a column, which row no?
- Conditional Formatting Using Min/Max
- Using V or H lookup
- "Validation" question
- Converting time to number, i.e. 2:32 to 2.32
- Countifs
- Concatenate Dates
- Sumif query
- Automatically add and subtract
- Formula behind functions
- Comparing 3 Columns
- combobox listfillrange network
- Automatic add & subtract
- One text for particular period
- average with N/A
- Formula to count duplicates
- Pull cell contents from one wksh to another if condition is met
- Conditional functions on portions of cell data
- Logging information
- Keep Leading Zeros in Concatenation
- Formula for selecting a Leap Year.
- Track Changes- Working Partially
- LOOKUP returning wrong values
- All my textbox disappear..
- IF and AND statement
- close match
- unique entry sum
- How do I convert 1000 to One Thousand (i.e numberic to words)?
- Sum if unique and another criteria
- insert and copy
- disable brian baulsom's worksheet change based on cell value.
- how do i open an ods file in excel?
- Forumals not showing correct result (unless edit and enter)
- Excel formula question...
- Self Population of Date Function
- count number of dates in a row of cel before or after a variable d
- VLOOKUP displaying "NO ANSWER" instead of "0"
- Can I use cell data for a web search & bring back in the results?
- vlookup???
- Medians of data
- conditional formula with lots of conditions
- Can't sort with Excel 2007
- conditional list
- search data and display colunm headers
- Vlookup and column reference problems
- TURN OFF AUTO-HIGHLITE
- change date format without retyping dates
- symbals
- Close Match
- Copying Cells to new row on different worksheet
- Link to another workbook path issue
- extract items from filtered list
- comparison function
- vlookup removing characters
- circular reference - iteration
- Need help with a function for a golf match spreadsheet
- How do I make a box with a check mark when clicked?
- INDEX MIN function?
- Math Functions Not Working Properly
- Countifs
- Random Sample with multiple data points
- Return two random lines
- Vlookup Using a Reference as a Table Array
- How can I remove the header and footer on the excel 2007 sheet?.
- Drop down menus
- Excel Formula
- Excel: graduating fees based on account value
- Viewing of protected locked or unlocked cells
- Count if unique
- Vlookup questions
- how do i filter records with greater number across rows
- Need a function to match up jobs
- IF Function and pulling data across
- Validation I Hope
- Count With Multiple Criteria, please help!!
- Excel Conditional Formatting (Compare Vals in 2 Columns)
- add another subtotal row to an expense column?
- Copying Conditional Formatting rule
- Unprotect 2003 excel files when opening in Excel 2007
- Unprotect a worksheet
- Another IF statement question
- Return filtered values into report worksheet based on filtered valueon the data worksheet
- Step up or Down payments
- FORMAT CELL TO MILLIMETERS
- perpetual inventory - stock level - math flow??
- Auto Correct Option
- Searching String for phrases/multiple text strings
- Macros
- Using VLOOKUP to locate an answer in one of multiple columns
- Count If Column A = x and Column B = y
- Concatenate N cells (where N is a worksheet value)
- EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD?
- Refer to Another Spreadsheet in a Formula
- Excel 2007 overwriting Hidden Rows
- Mulitple value lookup
- Automatic Macros
- PPMT Function
- how do i rearrange columns in a work sheet
- DCOUNT Help
- Hyperlink
- Watch Window
- how to add date and time to a single cell in MS Excel 2007
- Hide Rows If Condition True
- To choose the best field in EXCEL
- Transpose Issue from Columns to Rows...
- Accumulated percentage calculation
- Copying a formula
- formulas do not work
- To extract content fo cells from many workbokks which are identica
- Calculation based on certain criteria
- Calculation of incentive
- Problem with >= in function
- Help with worksheet event
- Apply Conditional Formatting to other rows
- Value function
- Estimates with multiple look ups
- A UNIQUE FORMULA
- 9 Assessments but want the students 7 best results
- IF FUnctions that produce TEXT results
- Conditional formatting multiple cells from one cell to another
- Excel formula question
- EXCEL 2007 - INSERT NEW WORKSHEET
- How to make SUMPRODUCT work over range that includes text?
- On error
- Naming Cells Using Relative Cell References
- I want to undo 'move or copy worksheet'
- loan to value function?
- Capturing Top 5 Performers
- I want to tally my sheet
- Sorting Linked Data Between Sheets
- how we find specific word from string in excel and compaire it.
- Running Total
- Worksheets
- Help with data total
- sort source data sheet while destination shows same data
- IF function using two worksheets and various data
- Constant in Excel Formula
- INDIRECT(ADDRESS) inside a VLOOKUP
- need sumproduct to return text values...
- Length of Service and Vacation Hours Accrued
- Grouping IF/AND/OR in a single formula
- Breaking down a cell to create a function
- IF cell contains part of text
- Format for a cell with a formula in it but I don't want the 0 to c
- Reference previous worksheet within VLOOKUP
- Vlookup Cell Format
- PASTE DOESNT WORK
- new macro to format worksheet
- SumIf or SumIfs or something else?
- Lottery function - how to randomly select cells
- What is the function to randomly select a cell, like for lottery?
- Concatenating two variable fields into a static length text field
- use Hlookup to look up two or more values
- roundup with index,match,subtract,divide and add formula
- If Statement Question
- IF Formulas
- Apply Global Formula
- repeating formula on calendar
- Multi column sumproduct
- Sumif linked to different workbook
- FIND IF A CELL CONTAINS TEXT
- entering a number and having a word appear in excel
- how do I substitute precedants in long excel formulas
- Macro
- normalize score
- vlookup (indirect, or sumproduct) using three tabs
- Data Validation
- matching Data
- Copying formulas in range and pasting in a selection
- Pickup the content of Cells ( in formula)
- display first or second match instead of #REF in INDEX ROW formula
- Select data from two worksheets to the left
- Use Like in Vlookup
- Slicing Data (Alternative to SUMIFS)
- Sumproduct Question
- Formula Help
- SUMIFS and dates
- index and match, then subtract, divide and add for my final answer
- "IF" function returns function instead of result
- Sorting Unorganized Data Into Different Spreadsheets
- IF function returns function statement rather than result
- COUNTING
- Finding an item in a list & returning a specific value
- How to convert PDF tables into Excel??
- Help with VLOOKUP & MATCH formula
- Format single character
- Current Cell location
- Alternative to using 10 V-lookup formulas
- Text into Columns
- Lookup Dynamic Value in a Table
- Method for creating formulas to reference different worksheets?
- How do I recalculate cell only if reference cell value changes?
- Percentage over a date range
- data associated with latest date
- data in 2nd column associated with =MAX(H1:H100) from another colu
- CANT INSERT CELLS, ONLY ROWS & COLUMNS
- how to move contents in column up one cell
- How to count/tally entries?
- Can't save Excel spreadsheets
- Today() function
- Text to rows
- How do I complete this nested if formula
- Lookup Function
- Calculate the number of hours in a date/time cell
- Is there a Conditional Sum Wizard in Office 07? If so Where
- Time/priority problem
- Using Indirect with an Index Match Function
- Errors encountered when using If & Vlookup formulas
- How to equal a cell in another worksheet incl fill colour
- Taking Average ignoring #DIV/0! in the range...
- EDATE Function disappears intermittently
- Quarters
- solver an uxexpected internal error ocurred, or available memory
- filtering or selecting data baseed on time of day
- displaying changes
- How does one use a formula to bring over the formatting as well
- Deleting rows or columns
- SUMIF formula with non contiguous cells
- how do I look for cells showing dates less than a certain date?
- Calculate Interest Rate
- EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
- Display a number in feet inches and fractions of and inch
- combining data from multiple workbooks
- Adding a pre-fix to each item in a cell
- Stuck on Formulas
- Duplicate check
- macro writing
- Split text file into Excel sheet and separate the final results intoa new sheet
- Return column header as solution to lookup
- Vlookup with multiple workbooks
- Cell format for an array formula containing text
- Copy worksheet from one workbook to a master workbook
- External reference to a Column
- Macro to apply parsing rules for strings and list the substrings
- Help Calculating Partial Months between 2 dates.
- Confirmation Security
- Vlookup
- Calculate Date
- Pearsons
- Data Validation using a table
- Text to Number
- How do I only send 1 worksheet of a file in an e-mail?
- IF Statements
- I cannot use DIAS.LAB in my Excel (Spanish)
- IF(AND(OR function returns #VALUE! error
- Headings of columns now have numbers, need to change them to lette
- Pivot Table - Old remaining values for rows
- count formula question
- Help Calculating Time
- Date Range
- Flatten password file
- style sheets vs cell formatting
- How do I ADD characters to the data for a group of cells?
- Time Calculations
- Adding values in first "X" number of rows dynamically
- Highest Values Comparison
- mean of range of dates
- Lookup Problem with Index and Match
- Vlookup Error
- HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME
- Multiple results of Unique Values
- SUM depending on date
- Excel virus?
- How do I bracket text in cells by formatting a whole column?
- Check register running balance to another worksheet
- how do I use a cell from one worksheet in the equation of another
- Numbers of repeats of a string
- External excel file for pulldown list source
- Sum cells that have both alpha and numbers
- excel function help
- Increase Values by Percentage
- Highlighting the entire row with conditional formatting
- Need Function Help
- Subtracting Military Time
- Symbols
- Percntages
- Advanced Filter
- Displaying "0" Values
- Can't Prevent Recalculation
- how do I create a nonadjacent series for autofill to go by?
- Cell not available when inputting formula
- Convert numbers to words
- Difference between 2 dates&time(format 0000), and excludes weekend
- Concatenate unique values among duplicates
- Excel Charts with Data Tables
- Remove e-mail address from general text field.
- Searching on 2 columns and putting result in third column.
- Macro for detect palindromes and repeats in letters/numbers string
- I need help desperately !! I need a formula that will allow me to match cells...
- Conditional Format