- Copying cell colours
- Not sure what function to use?
- IF statement with AND or OR?
- how compear two or more values into the same function
- Match & Index
- Excel / Access User Conference - Oct 24-26, St Loiuis
- Please keep is simple.
- Worksheet name
- A problem with the function "NOW"
- help with formula
- using cell contents in a formula
- Calculating from values in pivot tables
- help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
- sumif array function
- have cell in sheet 1 look up last row of column 'x' in sheet 2
- to get value
- dialog box to input data?
- Defaulting test to Upper case
- Clearing cells when selecting from a drop down list
- Condition formatting & Formulas
- Round time to quarter hour
- if then formula for total time ;overtime hours versus regular
- Decimal Places
- Multiple Password
- Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
- Macro HELP!
- Calculating Turn Around Time
- I have 4000+ rows in a worksheet, how to delete 100's at a time?
- How do I build a sensitivity analysis table?
- Excel headers
- Can cells be formatted so that if A2 says "Joan", G2 says "$25"
- minimum and the corresponding value
- Limitation on MID function? - very large string
- Subtotals Nesting Error - Totals Above
- Copy of data from word into excel
- Help with Dates
- Rank formula
- how can i choose the highest number in excel range
- how to put three columns into one dialog box?
- Conditional Formating
- Count Occurance
- comments in cell and web pages
- Prevent duplication across sheets
- sumif formula
- Link to Workbook(s) received by email
- Help with formula
- Warning Message
- Date reporting in cell
- percentage negative values in column
- distinct
- Data insertion
- incrementing
- Conditional formatting
- Probability & Profit
- how do i turn on view side by side
- Date Stamp
- Date format
- sumif-sumproduct
- Function to change cell color
- Validating & Error checking function
- Rounding time
- creating a formula for racing
- using value of cell to differentiate 3 group of testing sequences
- RANDOM # around a MEAN with STANDARD DEVIATION
- How to format number and not return ######
- what is the excel formula for market volatility?
- Muliple lookup in one cell
- excel won't print boarders
- Display "this week" column headers w/date & day of week?
- Conditional printing based on cells greater than zero
- Help with look up formula
- Adding cells that have varying contents
- Compare worksheets for duplicates and copy data to 1st worksheet
- If Then Else Formula for Excel Worksheet
- Formulas "PPMT", "IPMT
- Fast Fourier Transform outputs in Excel
- Calculation results as static data not formula.
- macro
- Multiple references
- How do I set up a counter cell?
- excel formula's
- Counting number of times data matches
- Update Date Cell when any of target cells change
- Nested IF, reports incorrectly, can't find anything like it to ref
- Time
- Formula
- How can I insert rows without getting error"cannot shift objects o
- numbering folders
- Data Validation list order
- IF formula to highlight?
- Statistical Funtion
- Formula help
- Data Validation Update Validation Selection
- If/Then
- Link excel comments to cells
- Problem with dates
- Using VLOOKUP with a 3D range
- Returning a range using IF
- run programme error occuring
- how do I print only horizontal gridlines in an excel worksheet?
- Averages
- display 0 instead of #DIV/0!
- A Microsoft Excel recall spread sheet using calendar dates.
- Negative number formats?
- Degrees of Freedom in TTest
- Breaking out data in a cell
- Ranking
- Day Conversion
- Rerouting connectors
- Calculating time from a specific paycheck period
- Paste visible cells?
- present value of a future amount
- Complex Time Window / date based calculation
- average that includes estimates if data not available
- Find Function
- Can not access small cross to pull-down data
- Count number of sheets
- Change Day to Month - VBA
- How can I evaluate whether a trend is positive or negative?
- Character limit when retrieving indirect text from external sheet
- Embedded pdf file stack when Autofilter is applied
- Do not allow Narrow Down with AutoFilter
- Copying the data's
- IF Function Help
- IF Function
- COUNTIF
- Check if cells contain the word "Thailand", return "TRUE"
- IF formula
- Excel formula question
- Help with my coding problem?
- Page Break Save
- Mailing a spreadsheet
- Simple IF statement
- How do I update a checkbox as true when another has been updated
- applying both Phil Peso & Euro decimal system in one spreadsheet
- array formula
- Insert rows without effecting formulas
- fill color not working in excel 2007
- find the frequency a number appears with another number within a s
- Formula for Inputing a Value based on a Condition
- Sumproduct for partial text
- Counting Coloured Row
- Need to sort a row of data and automatically copy in to another ro
- How do I set up automatic email when change is made to Excel wrks
- I have a sub total need to find the GST & QST any formula
- total Hours Worked for week PS thx for the formulars everyone!
- Hide $0.00
- Depreciation of assets - no. of yrs required
- hyperlink
- change parameters of a range to be summed
- Problems with VLOOKUP
- Multiple IF formula needed....
- "Nested" COUNTIF's
- Copy & Pasting Excel Spreadsheet to CorelDraw
- DSUM AND Condition
- Return Formula results to specific row of matched criteria
- In Excell how can i get a total hours worked value from 2 times?
- IF statement pulling from Product List
- Formula to look at a table with "0-34,999, 34,000-79,999, etc.
- How do I move daily data from one sheet to a 'yearly sheet'
- Excel 2003 Identify a single character in column
- Excel applications for a Barcode scanner
- IF function
- Sliding scale commission percentages formulas
- How do I import a date from a project scehdule task into excel?
- Excel 2003 - Calculation production schedule using solver
- Button for list
- charting question
- VBA ?
- check for worksheets
- Shared workbook
- workbook creates a backup evertime I save it. how to remove?
- SUMPRODUCT to count items with duplicates where another column contains two defined items
- SUMPRODUCT
- Need help with Circular (?)
- VBA Project - Open/Close with Macro
- Pasting values from another worksheet doesn't activate the change in Visual Basic in excel to run why? tia sal2
- Can you change a format WITHIN a formula?
- cell with static current time
- Subtotal sorting
- Dynamic Picture defined by Name using a formula loses link when sa
- print a blank customized schedule
- Pivot Table sorts date as Alpha, not as Date
- Total 12 columns starting with first non blank column
- LOOKUP problems
- Designating color in one cell based on data entered in another cel
- Copyright Year Re-Formatting
- Splitting data from sheets into seperate workbooks based on formul
- IF statement checking if a cell's text is red
- Deduct Months from a Date
- Error in subtracting time - Help
- Complex formula
- how do you select every 8th cell
- I need help with formula
- SUM IF returns a zero value
- How can I get Excel (2003) to return just the first 4 words (of another cell)?
- FORMULA TO LOCATE NEXT DATE
- countif for 0
- Mutliple Criteria Count function
- Sending Difft Sheet as a seperate file thru email
- Adding Data from Multiple Spreadsheets
- Excel 2003 - help with formula please
- When I open an excel workbook to mail merge nothing is shown
- how can I change the color of the menu list in a data filter?
- VLOOKUP LEFT VS RIGHT
- Using IF & AND and getting #NAME?
- "freeze" an imported realtime updated cell value
- Add data every 14 days?
- Sort doesn't recognize current region
- formula required
- HELP: Use the autofilter result on one workbook to filter the next list on another workbook
- IF three functions are.......
- How do I make a cell in Excel default to the negative value?
- Help with complex If statement
- Cell reference in header
- Bold & add line after subtotal row
- AddIn Analysis Pak not working anymore
- Corrupted File during Office 2003 upgrade.
- Shortcut to change change cell reference to Absolute reference?
- Counting odd & even #s
- Macro To Open a User selected File
- absolute reference to workbooks
- Merging Worksheets from different employees
- COUNT function... I think!
- Array Formula
- VLookup question
- Selective Copy from other excel file, sort, then deleteon a condition
- Selective Copy from other excel file, sort, then deleteon a condition
- Deleting information in cells
- =NOW()
- Formula to Insert Rows
- COUNT - How To
- Formatting Cells using an If Statement
- Calculations within Project
- summing first 'n' values in a column or row
- Transposing data?
- multiple dropdown selections
- Post Code
- Transferring data from one sheet to another if criteria are met.
- Linking to ranges in another file
- pop up calander in an excel spreadsheet
- Data Validation using Dates
- getting information from several columns
- IF Statement problem
- consecutive numbers
- Problem with If Statement
- IF Statement problem
- IF Statement problem
- Problem with If Statement
- I wish to fomat numbers in Excel
- How to disable the automatic getpivotdata function in excel?
- How to disable the automatic getpivotdata function in excel?
- New sub-folder in Excel using a formula
- link data from multiple workheets
- lineintx
- What is the furmulla to extract Rs.44325/t
- Search, find or lookup defined text in text string
- Bullet Points
- Hiding rows based on a criteria thru and event proceedure
- Finding the Row number based on contents of a cell
- Concatenation Formula needed
- Creating sheet references
- Alternative to a drop down list
- filtering rows depending on onother sheet
- Copying cells with the mouse
- Returning a value in one cell from values in two other cells
- A rounding function
- Partial Annual Periods (Repost)
- stop a clicked on cell being left blank
- Summing between 2 dates
- formula too long
- Some more help to edit some formulas
- Rolling Calculations
- VBA Code for Deleting a Row
- Partial Year Adjustments (Mod Function)
- Can you count cells by color?
- Macro to delete rows based on a condition
- Add, subtract time
- date specific formula
- if then statements
- counting periods Excel
- Converting month name to number
- Will Conditional Formatting work?
- vlookup not looking through all the values
- Autofill
- unable to solve array formula syntax
- PIVOT and lookup
- Invoicing Problem
- Conditional Formating
- Comparing two lists
- Moving Subtotals
- Conditional formatting changing relative when copied to other cell
- SUMPRODUCT - Tweak
- VBA Password Question
- open ftp file with password
- IF function and wildcards
- blank error
- I do not want a hyperlink to be automatic when you click on that c
- Converting Hours:Minutes to Decimal
- conditional: stop function under certain condition
- Complicated formula help needed please
- Calculating Time
- Data Import
- Rating according to 2 criteria.
- Random Numbers
- Dates in Excel
- to John Boy
- need help with networkdays formula
- How do I get a total adding cells from other sheets for a roll-up
- Create list of unique entries for use in validation
- Yearfrac error?
- Count difference based on Range
- how to sum items in a column if there exists some more refernces
- sumproduct?
- Filter setting
- how do I add a various check boxes to a list in a specific cell
- auto SUM bottom page
- find first and last in row of numbers
- Excel 2003 formula question
- Date Conversion dd.mm.yyyy to dd/mm/yyyy
- traspose data with formulas
- Conditional Named Ranges
- Want to display financial formula result... not the formula
- Adding values from a different worksheet
- protected file
- Get all Sundays
- Easy one...
- Sumif on Currency format
- Looking up data by row and column (Arrays, Lookups, Index, Match??
- Can I create a dropdown list to select multiple items
- Identify top 20 clients/coditional formatting
- Unable to paste in worksheet
- how do i transfer necessary rows/data from a master sheet
- how do i transfer necessary rows/data from a master excel sheet
- how do i put color in a cell based on data in a second cell
- Macros I think
- click on one cell to locate another cell
- Function for adding lines
- Invoice Formula
- i need help with formula
- formula question
- highlight group of rows
- Formula for finding data from 2 worksheets
- how to prevent a worksheet from being recalculated?
- Pivot table and customer analysis
- Time and lunch breaks
- concatenation
- Concatenate function adding double quotes to both ends of results
- Adding up various columns based on the value of one changing cell
- Paste changing cell contents to consecutive cells in a column
- Phone with/without area code format
- VLOOK up returning #N/A even though value exists in lookup array
- sumproduct bllank function handling
- Conditional formatting and time
- filter dropdown menu so 2nd drop menu is customized
- using a formula for a column or range
- Compare and Return Value
- Convert Time
- Look Up or Maybe IF formula
- Conditional Formatting Help
- Time Problem
- Linking Excell Spread sheets
- Excel 2K and parsing data
- I CANT VIEW CELL/TEXT COLOR UNLESS IN PRINT PREVIEW
- VLOOKUP returns #N/A and causes VBA routine to halt
- nested countif
- appending worksheet records into 1 worksheet
- Test cell interior color by worksheet function?
- vLookup from 2 different lists
- Lookup and return value 12 rows below
- move data to another sheet depending on criteria
- Using Excel Solver or Goalseek on multiple Sheets in a Workbook au
- IF - not equal to
- Advanced charting in Excel 2007
- count filtered rows based on condition greater than forty
- counting the number of times a word appears
- IF with 3 options
- calculate a date X number of days before/after given date
- How to read the value of a cell
- How do you truncate 2.22 to just 0.22?
- How to make these formula's?
- IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
- Keyboard Shortcuts in Excel 2002 suddenly quit working
- how to keep a word of same sentence starting w a capital next lin
- 2007 and running balance across worksheets
- Counting the number of cells that have the same value
- Lookup value in other sheet - return coresponding value
- How do I add hours worked in exel
- Can this formula be reduced?
- Convert date to text
- Can a replaced excel file be recovered?
- Array - matching data
- Count letter string, e.g. h/EL/p
- INDIRECT and Defined Names
- Vlookup return NA for numbers format as general
- Help
- Advanced Filter - extracting unique records
- I need a cell to populate as a one when 2 cells meet criteria
- How do I asssign a values to two cells and multiply them together
- Looking up a name in a list and returning only the column with dat
- Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
- Problem face in Validation Command (Pop-up Error Box)
- PDF'ing in MS Excel 2003
- syntax for "IF" commend to check for multiple empty cells bf comma
- Sorting challange
- Formula for Detecting Currency Format
- Countif not working
- Conditional format
- date recognition problem
- Need some macro help.
- conditional formula question
- Returning contents of a cell based upon the minimum value in a ran
- find, Index?
- Win
- Win
- replicating formuleas?
- Tricky IF/Then Date based formula needed
- Change Currency Format of Cell based on another Cell
- Matching numbers and text
- Match WORKSHEET
- calculating time
- Converting NOW contents to TIME
- Matching records and posting them separately.
- Is there a way to compare one column with another?
- Why does my tab move to the end of the visable field instead of 1
- Function Range
- Locking non-Validation cells in ranges
- Copy worksheet with internal hyperlinks
- Linking tables and worksheets
- Can the If function be used on blank cells?
- Need Macro To Open URL Link
- Can I use a named range in the criteria for a sumif?
- IF Function/Validation List/Totals
- Category
- last occurance in a array
- the Row # from the result of Vlookup formula
- How to modify the code for different type of input?
- Removing the constant link from Spinner
- Time format
- Subtotal out of sequence
- Sumif, And Statements - multiple conditions
- whats up?
- whats up?
- Using " Forecast" financial function
- in excel, can I use values based on color for an "if, then" condi
- drop down lists and forms
- Merge sheets to Workbook
- Conditional placement of an item
- Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Column
- Using a function to delete blank cells
- Dynamic Non Consecutive Named Range?
- Workhours Calculation
- Data filters in Excel 2007 not working for one file
- Shading a cell relative to three other cells & repeat
- Fixed path to other workbooks
- G4 is =C4+D4+E4 , what each one value is?
- VLOOKUP & TWO DIFFERENT RANGES
- Worksheets
- SumProduct Help
- IF function query (complex)
- How to GetText() from TextBox under Visual C++ application?
- vlookup or dget with multiple condition - help please
- How do I prefix a worksheet of numbers with a Minus (-) Sign
- How do I set up a check that matches names of companies in excel?
- Table of contents
- How can I copy the header and footers onto every page on a workboo
- VBA Code; need linked cells to change color if condition met
- Testing if a point is falling within the bounds of intersecting cu
- Mouse scroll failure when looking at code
- display what the function mean
- Convert time to fraction of an hour
- If formula
- keeps turning off
- IF statement
- formula for adding a date
- Tally feature
- Dynamic Range Names?
- date formatting in excel
- Searching for data
- links vs. lookup
- Converting text to numbers
- Feeback
- Can you pivot a table using a formula on a different sheet?
- subtotal formatting
- How do I enter a Formula for entire column?
- Function to count numbers in one Cell IE 1+2+10
- Rounding to the nearest quarter
- Formula won't calculate
- Count occurance of a month in a column of dates?
- Vlookups
- convert number to word
- Need Function Help
- Sort by Date Function
- workbook protection
- vlookup formula editing based on numbers treated as text
- how do you shuffle a range of numbers at random
- Need a formula
- Date range selection? Anniversary dates
- Cell working as a button? Cell color control
- Data values
- weekly labor total
- VLOOKUP referencing a cell with a URL
- formula for % passing
- convert time
- Formula for Solver
- Excel problems
- Copy/ move selected data from workbooks to seperate worksheets or workbooks
- Creating a Function
- Blank cells instead of zero
- Creating a Function
- easily change external references
- VLOOKUP
- Function that accepts and returns a decimal, is it possible?
- SUMPRODUCT, calling a value from a cell as a value to search on
- U.S. Holidays that the date moves
- time function
- changing formula
- Reference to the N-largest value in an array
- Formula by which meaning of word can be found out in another cell
- linking values and formats on from different sheets
- Form image
- character value function?
- Improduct function
- Date format
- filter or validate to avoid repeated data
- Need help in deleting specific data.
- Conditional Column Average
- Macro Time stamp Help
- Matching.....
- Retrieve whole row of data
- comparing cell to row, return all matchs
- How do I NOT get synchronous scrolling in multiple panes in Excel
- Index Lookup Question
- Comparing characters in one cell to multiple cells
- RESTRICT PASTE
- Counting conditional cells in multiple rows
- How to calculate based on Validation LOV items?
- Help Required: Pulling data from a workbook into a worksheet.
- dynamic character counter for merged cell text field
- VLookup and a Cell Reference
- How do I count two conditions using a wildcard?
- Macro for Unlocking Multiple Worksheets
- How do you append one row to another?
- Concatenate help
- format
- Need help with calculation - Duration or Time multiplied by cost
- Extract portion of formula resident in a cell
- remove spaces in linked worksheet object
- Listing Folder Contents into a Column
- Counting Days or Months
- Count if one cell has a name in it and another column does not
- Prevent duplicate data from being entered into the same column
- Excel 2003 and AVERAGE function
- vba outcome
- vba outcome
- plus and minus
- need help
- need help
- INK Annotations function in a protected sheet
- test for falling with the bounds of intersecting 2 dimensional cur
- need help
- need help
- Move first 12 ranked rows to another area
- Expert VBE help for cell color change
- Expert VBE help for cell color change
- Can't delete validation arrow
- updating external data sheet causes loss of data on linked pages
- assiging categories
- Combining Two tables into One
- cell formatting with formula
- Need tips on new features in Excel 2007 pivots, names, views
- Setting and Locking the default language for Excel Worksheets?
- An if statment tat returns a true blank
- Several Table, need the total discount
- Name lookup
- Oopps!
- "LOOKUP" within a condition?
- Match function won't recognize values unless I type them
- Reference to a different spreadsheet
- Dynamic Ranges
- copying formulas forward and have the column refference move backw
- convert column of text email addresses to hyperlinks all at once
- Macros and sort function
- XP versus Vista spreadsheet
- Sorting and Deleting Help
- Function for fixed amounts spread over 12 payments
- Sort anomaly
- SUMPRODUCT Help
- If date in cell falls between date range...
- Change cell name
- Group and count a list of dates
- =IF(OR question
- vba help
- Help with OR function
- Help, Office 2007 "Rows to Repeat at Top"
- Mega Stat Addin
- How to calculate a mortgage payment?
- copy cells
- How to Delete empty rows in excel in b/w rows with values
- copy cells
- Ranking Spread Points
- INDEX & MATCH functions
- Help with Concatenation
- Having a cell prompt for a hyperlink
- HMATCH star matching
- to put a picture in steatments
- Format a cell
- Getting an ActiveX command button to do a spreadsheet function
- Entering an array formula
- Sorting a spreadsheet with Excell 2007
- Using Indirect with Named Ranges
- Variable Worksheet Names
- Lookup
- Conditional Format for a date 1 month before Expiration in Excel 2
- Test please ignore
- Can I sort data that contains calcualtions?
- DSUM function
- Excel Average function not returning expected result
- Max Number in Formula
- Find empty cells, fill with text from cell above
- Copy Worksheet
- converting continuous data into binary data
- sumif2
- how to print labels directly from an excel database
- dynamic PROCV
- How do I specify cell contents for the Criteria in SUMIF?
- Sum totals of 55 worksheets on Sheet 55?
- SUM formula results returns 0 value
- sumif
- Getting a Result in vlookup dependent on another formula
- Visual BASIC in Excel
- Visual BASIC in Excel
- Summing
- Black Lines in Excel 2003 Spreadsheet
- IF Statements and multiple columns
- join date & time & add hours
- Create the Sea Battle game in a Excel sheet
- Copy Formula
- ROUND the result of a formula
- converting a figure into words
- Omit header from first page without embedding header in code
- Excel 2007 Solver Error
- Printing curtain cells
- Vlookup returning multiple answers
- time format problem
- Are the non-gradient chart patterns missing from Excel 2007?
- Index Function
- Adding a graphic to a worksheet as a result of If/Then Statemet
- Calculate a date based on period and year
- Formula for product based on criteria?
- How to index teammembers within in a pool?
- Lost the passwork for protected worsheet
- Set up tracking schedule
- Pivot Table lookup
- Searching for data and placing in new worksheet
- Creating Forms in Excel 2007
- Array Help Please
- Tab function within cells
- Function which handles numerous variables
- How to display negative times
- Dynamic Range
- database
- Excel Function
- Find Numeric data
- Creating Nested If Fuctions
- Macros in Excel 2002
- Formula for Asset calculations
- Basic Excel formula
- Help - Consolidation refreshing
- Excel 2002
- Searching Text that contains particular WORDS.
- Calculating time without using time functions...
- How to valid the values?
- Crosshaires
- Value trouble!!!
- Formula with fixed details
- "if formula"
- rank function error
- addins & UDF
- Can I short worksheets ascending or descending order ?
- What is use of "<>" in Excel
- how do i select in aleatory way 3 numbers from an array of 10
- Selected Cell in a Range Appears in another Cell
- Replace non printable characters
- Color fill
- How do the data of any cell will be graded out?
- jump around a spreadsheet
- SUMPRODUCT - DIFFERENT DATES
- Problem with concatination result. Last digit change to 0
- Match - Array Problem
- formula to work with Acssets
- sumproduct ?
- Formulas
- updated cell with current time\date if any data in a row has chan
- copy cells in a row to another sheet
- Conditional Summing
- retrieve & count text
- Array Formula
- Web Query from multiple varying length pages
- discount formula help
- copy cells in a row to another sheet
- Copy certain cells in a row to another sheet, based on certain val
- External Links in Excel 2007
- strange...
- strange...
- Excel Spreadsheet?
- Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr
- Help dealing with a fiscal year rather than a calendar year
- &TEXT formula
- IF function for multiple variables
- Need clarification on why my formula works
- Formula to FIND DUPLICATE DEBIT AND CREDITS
- How can I insert a header only once in excel with many tabs
- SUMPRODUCT, count & sum
- How to insert cells with data only If they meet certain requiremen
- How to count the matched values?
- How do I incorporate ref. range(like OFFSET() ) in a function?
- IF statement with range
- Named Ranges
- How to divide the each digit of the phone numbers into different c
- Worksheet will not print out on Legal size page
- Help with 'if' formula
- Please help.I went into the websitebyconture and its not workingfo
- how to count the number of cells it takes to reach a certain sum
- Macro to Filter Information in Multiple sheets and Make graph
- Question: Linking Cells
- Help on index addressing using variable sheets & cell references
- Please help. Need drop down menu for name&price to pop up automat
- Sorting excel worksheet data, and ALWAYS maintain "row data" (in l
- Copy drag formula down cells
- HLookUp
- Re: Help with formula (IF)
- Why is worksheet.usedrange empty?
- vlookup - can't pick up table array
- How to extract text from middle of a string
- Sum of cells under a condition
- onlineyearbooks-books printing
- Excel Doest Not Update and F9 Doesn't Do It
- Counting Weeks in a year
- Help with formula ,"")
- Convert IRS pdf forms to printable excel
- Formula help!!!
- formula for data base
- I need to pair each item on one list to each item on another list
- Formula - Period Quarter End
- add page numbers to selected sheets
- automatically add to cell formula
- Changing the color of cells by formula
- Clear cells to a preset value
- Clear cells to a preset value