- Solver Help
- Removing zero value lines
- Conditional formatting Max and Min
- Need help launching PowerPointViewer from 2007
- Nested IF/OR/AND Statement Help
- Referencing within a GetPivotData function
- removing dashes from numbers
- Pivit Tables
- Some gridlines are not visible in Excel
- Choose from a list
- In a set of dates, can you count the number of Jan '07 instances?
- Missing count of age to a group of ages
- Excel: How to insert carriage returns in a formula to manipulate t
- Blank cells
- Need help with my timesheet? regular, 50% and 100%
- sumproduct and visible cells
- Import Access Table into Excel
- Using "Fetch" function
- add two numbers in same cell together
- Converting GPS to Digital Geocode
- EXCEL
- Using COUNTIF and NOW() together
- Comparing Data in Excel 2003
- RE : upload data from excel to notepad
- Formula to pull data from one sheet to another if X = Yellow
- Excluding subtotals from SUMIF function
- Autopopulation of formulae after download of data into a master sh
- MINIF ????
- Counting date entries which are the same
- countif (I think)
- Displaying 'IF' Function result (text) over cells containing formu
- Sorting with matching header
- Help: Creating Data List and value
- Why does Excel not multiply a number generated by an IF formula?
- lookup in 1 workbook to get data for another workbook
- Lookup help
- Vlookup.... 2nd time
- How to retrieve the value from formula?
- number of times consective data occurs in a range of cells
- assign an incremental number to a cell, for each new spreadsheet
- Correct Macro so that if the person is not in the source document
- Assigning payment formulas to dates
- Vlookup with Multiple criteria and multiple sheets
- Formulas pulling from other tables
- Compiling information from multiple workbooks and summarizing
- printing parts of worksheet
- calculate finishing time if night shift aren't working
- Wildcards and if
- multiple users to update the spread sheet at one given time
- Need to know what formula to use
- RE: Need to know what formula to use
- Conditional Formatting of a text box ? - update (from pg.9)
- Formula to change date when other cells are modifed
- Copying rows from one sheet to another....
- Add-Ins Tab in 2007
- linking to other workbooks
- Pivot Table Problem
- rows 4-15 will not scroll
- More specific question about adding color code
- password problem
- Prompt for update
- margin of error
- How do I insert a picture into a cell?
- Functions Expert…..four (4) different colors if a specific conditi
- Looking to add color code alert
- Adding a Row to Multiple Worksheets at Once
- Calculate the difference between two times - getting '#VALUE!' err
- Functions expert………numbering random condition in a column
- "manual page breaks error"
- How do I import data in Excel
- Need to remove cells with variable data
- timeline chart
- STUMPED
- Validation source field size and function.
- Automatically Hide rows with a value of zero
- formula help
- excel 2002 macro
- Best Way to download XIRR
- Font of drop down list is too small
- Why does the following formula not work: =IF(2<A1<=2.25,2.25," ")
- Pivot Table with Quarter Subtotals across the top
- Referencing a named range based upon Range name entry in cell
- help with Blank Dates in a Range
- What does "cannot shift items off sheet" mean?
- Fixe Range
- Looking for custom date format
- Flag 1 in 5 entries
- MACRO IS NOT WORKING AS IT SHOULD
- Movng Data Automatically the Fits a provision
- How to I get the tabs at the bottom of the page back?
- & with COUNTIF
- Random messages pop up
- DATEVALUE gives #VALUE! error
- How to fix the coding?
- Refresh a Pivot Table
- excel calculates after each cell entry
- Excel database
- can you tell excel to ignore #### cells when calculating
- Referencing every 5th cell in another sheet
- Excel Formula
- How do i insert drop down menu using multiple cells.
- Help Nested If and And
- summing
- Subtotal function not available
- Now() Function...Help Needed
- Excel VLookup
- IF COUNT
- IF Statement
- return TRUE if a date falls between two dates
- setting up option buttons
- Creating a list of value from an array
- how do i make bootstrap
- Sum A Range only if no text is present in the range
- Need to summarzie a "status" flag
- how can i automate the copy-insertion of a specific number of rows
- Odd functionality
- How do I sort rows containing graphics?
- Can you use IF function in pivot tables?
- get a list of ticked add-in
- spell check in excel 2007
- Using A Table In Two Sheets (maybe VLOOKUP)
- Limit to nested IF(ISNUMBER(SEARCH)) functions?
- Turn off recalculate to send data into TM1 and vice versa.
- pop up calendar using MS DateTime Picker
- Duplicate Work Order Numbers
- Positive or negative sign in a calculated cell
- Closest value lookup?
- Excel / Access User Conference
- Counting up with numbers and text
- vlookup format problem
- how do i sum of decimal digit in absolute terms
- lock cell based on a condition
- COUNTIF with AND logic
- How can I change the tab but keep the row and column constant when
- Trouble with Index & Match
- TAN INVERSE ?
- trouble locking specific cells
- Find and Delete
- Conditional Formatting
- SUMPRODUCT #VALUE! error
- find and replace
- Merging 2 lists with a twist
- Cell reference Issue
- Digit to Text
- Cell Wrap
- Auto Filter Range
- DCF
- while loop
- =B1/A1
- reorder data
- transfer date to number
- How to use the if statement for Macro coding?
- getting numbers divisible by 4 from random numbers in ascending order
- sum alternate rows
- Can Someone tell me why this won't work?????????????
- getting numbers that are divisible by 4
- Convert average daily yield to APY
- Needing to return multiple values from single column
- copy part of large WS to another sheet
- Calculating Time Worked in Timesheet
- Advanced Excel Functions Ebook
- Sorting
- how do I look for duplicate house addresses in a column in Excel?
- Need Macro to Open Access
- Hard return
- Functions/Formulas to count multiple variables
- lookup formula
- Help with formula please
- Pull value from column heading
- If Function, looking for formats in values
- Need to add to a SUMPRODUCT formula
- How to return multiple cells from a data sheet in a seperate workbook
- Repost of VBA Code/Lookup question
- IF/COUNT Statements Help
- Totaling Different Cell Values
- Sum numbers based on specified criteria
- Snedkeys "{F9}", true does not work
- Excell dragging formula to change sheet/tab not column/row
- SendKeys "{F},true does not work
- Formulas in Excel Worksheet
- can I ignore words when sorting excel columns?
- How to make a value only show at the uppermost row for the same ID
- Is there a 255 character limit in pivot table cells?
- Sumif
- Advanced Filter - Automatic Update
- Working with Drop Down List
- COUNTIF with dates
- How do I type so my words are vertical not horizontal?
- how do I delete hidden rows or columns without doing it manually?
- formula using several colums
- zero value from using 3D formula, value is missing
- excel processing
- Merge Sheets
- Changing row height in the same worksheet
- locking and unlocking worksheets
- Conditional formating
- Excell Vlookup formula
- Custom data validation doesn't work well
- How can you do COUNTIF between 3 spreadsheets
- On File open - how to stop conversion of postcodes to numbers
- Formula - Help !!!
- excel Formula help !! - urgent
- converting number to words
- Using a series of named ranges in SUMPRODUCT
- Refresh Autofilter
- counting names
- How to summarise information from 4 work sheets
- Refering a cell
- If statement help needed
- what's the best way to calculate a person's years of age in excel
- How do I add " to the right of a number when formatting?
- umm..hard to explain..
- Autofilter with drop down menu
- option buttons help
- Conditional Format a row based on a cell?
- Macro with Variable Data
- How to open a new instance of Word and its .doc file
- Pivot Table Date Format Question
- Displaying hours and minutes
- create a list dependant on info in a column
- sum column a if column b, c, d, and e are equal
- Index and named ranges selecting difficulty
- Macros with variable data
- sumproduct 3 criteria inc. date
- Pivot Table Issue
- Counting
- cell protection, how to?
- show data dependant on certain columns (2 dif questions)
- excel prob - cant save worksheet if someone has it open in a veiwe
- Variable Data within a Macro
- Columns
- Conditional Formatting bug?
- Pivot Table
- mortgage Loan amortization schedules
- Multi-conditional count
- Multiply IF AND OR comparisons
- Working with pairs of cells
- IF AND Function
- replace space
- XL how to change a cell reference in a formula to variable value?
- How to open a new instance of EXCEL and .xls file
- Worksheet does not open in the last place it was saved
- How can 0 be used in the Choose function
- sales receipts
- Function to find 'n'th largest alphanumeric field (like "Large")
- telephone number format change in Excel
- SUMPRODUCT AND TEXT INM FORMULA
- merge database or sort?
- @average function
- Countif to pur a persons age into selected caragories.
- Mouse click automatically enters character into cell.
- I cannot select the compare and merge button
- Keep formatting while using drop-down list
- don't know how to ask the Q
- Header/Footers
- What is this formula for?
- Conditional formatting of a text box ?
- Sumproduct multiplying instead of adding
- Vlookup using if condition or any other way to slove problem
- I am trying to lookup a persons name in a table.
- Cell Formatting Question
- 3D range problem
- copy an entire row IF a statement is true
- if then question
- copy worksheet multiple times base on user's input
- weighted average rent with growth
- SumByColorFont question
- Creating Same Links On All Pages
- USE IF CONDITION FOR 2DATA
- Count
- Add cells across multiple workbooks that increase...
- Assigning a Value based on Results
- Linking data from one worksheet to another worksheet
- Undo delete button action
- Add a row based on other criteria
- Conditional Merging of 2 Spreadsheets
- Can I use excel to send personalized emails?
- Can't find project or library
- formula range
- how to link data from one source sheet to multiple sheets
- vlookup formula problems
- Error suppressing with INDEX/MATCH
- How can I find links too other data sources
- How to use Ara and ARP fucntions on Ms Excel?
- Sumproduct, multiple conditions.. but I also want to "minus" somet
- Help to edit a formula
- rounding of numeros
- Look up of cells
- Finding a row/column header in Pivottable
- XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS
- How do I make the contents of a cell appear to flash?
- Looking up 3 cells based on defined value in a row/column location
- HLP! Nesting Problem??
- excel expert with data
- Looking up a value
- if, and match
- Array formula returning the cumulative sum
- Sorting Spreadsheet Selection - Recurring Sort
- More Secure Sheet Protection
- INDEX, MAX, OFFSET, MATCH
- Lookup : Syntax Error
- Shift lists
- Incrementing Large Ranges
- if/hide formula
- COUNTIF, criteria is cell-to-cell comparison
- If Between Dates Function - please help
- Remove errors
- Linking Between Sheets and #Value! Error
- Countif?
- enumeration members
- formula to add values for all the same first words in cells in a r
- Countif Multiple Criteria
- how do I combine multiple worksheets into one? not summarize
- Conditional row format
- Conditionally formatting currency
- LOOKUP MATCH problems
- MoveMiddleInitial
- How to do the coding on UNTIL loop?
- Invalid date if weekend or bank holiday
- HELP!! SUMIF QUESTION
- Holding company: Automatically modifying data on different workshe
- Flow sequence
- Count number > 75% and < 90%
- Value errors in Match function
- Ignore errors in range
- Conditional Formatting
- Sheet order & speed
- Number in words
- PLS HLP! Countifs Syntax Problem?
- Auto fill of cell with information from seperate sheet
- Pivot Table Number Format
- Array Brackets {}
- How do I...
- how do i calculate what i make in a year into an hour?
- LOOKUP, INDEX, MATCH (?) Formula
- lists urgent help needed
- Formulas
- Multi-Cell Array Formula
- how do you write format results of a function within a function?
- Auto Filter & Display
- Text in Data Validation drop down box too small. Is there any thi
- HELP fixing GPA formula's
- create up and down arrows to increase and decrease value in a cell
- Excel 2003
- Too many criterias...
- nested color index within sumproduct
- Pivot Table Quesiton
- Conditional Formula
- Form Buttons Connected to a Macro - Want to remove the button
- Formula
- How can I shrink a file size w/ a pivot table and many formulas?
- Conditional Sum Brackets { }
- Array reference in =ROWS() function
- Automate deletion process
- Timezone converter
- How do i merge date from multiple sheets
- Automatically duplicate variables
- tab color on worksheets
- function to retrieve a list of unique characters from a column
- Calculated Field Total formula not working
- IRR Guess
- Problems changing array field in formula
- SUM to infinity on a column
- Conditional averages
- First populated cell in row array/ Last populated cell in row arra
- Extract text from a string
- Create new list with defined ranges
- Create new list with defined ranges
- SUMIF Multiple Workbooks
- Find 2nd, 3rd, etc Result with index/match
- how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row
- First Input on a Form
- Multiple results
- how do i count specific text strings excluding blank cells?
- Number in words
- Extracting data inexcell 2003
- Links not updated when primary worksheet is sorted
- Need to "merge" two subtotaled lists and show variances
- How to confirm the open dialogue box by using macro coding?
- how do you get the first column to have headding arrows
- Match with yes or no question
- Help with function/formula please!!!
- Excel: How do I auto expand Cells to show all the wrapped text?
- Splitting a Cell
- blank vs. 0 when plotting a dated timescale graph
- Lookup value If cell is hilighted
- How do I change direction of Enter Key in EXCEL 2007
- arrange excel by street address instead of alphabetically by name
- Conditional Formatting on calculated text
- =TODAY()
- Pivot Table Refresh
- Averageifs & Countifs
- Calendar Control
- A change in one cell generates (todays) date in another
- Using Vlookup for intervals
- Is there a way to reference 2 separate worksheets with validation
- Countif with Conditions
- How do I compare a result to a range of values?
- delimiters and manipulation
- RATE - what is the internal function?
- How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
- How to index the closest data(cash flow)?
- Invert a column
- Displaying percentage sign in cell
- Numbers in words
- duplicate occurance, assigning an ordinal value
- sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
- excel lines are purple I want black
- using check boxes
- Copy a worksheet from one workbook to another
- index and sum nonadjacent cells
- base de inquerito
- Macro will work on one computer but not on another
- Email Macro specific Cells?
- Counting Time
- Having Excel Move Data that has a certain value
- matching & sorting data
- Convert SMITH to Smith and JONES to Jones?
- Two Formulas in one cell
- Duplicate Item Numbers
- Off Set printing
- How to delete the first word in every cell in a column
- Scrolling in Page Break Preview
- IF condition using GMT and BST times
- Memory hungry worksheets and workbooks
- Calculation time
- Automatic deletion of specific cells from multiple sheets
- Calculate monthly contributions
- How do I return Multiple values using VLookup?
- Excel 2003 I want text quoted and then the value of a cell followi
- how do I sort a column of random dates into Consecutive dates
- how to get the 2nd max value?
- Every 1st, 3rd, 5th Tuesday
- Loosing data in shared worksheet.
- Help with Function: Compare text and and edit in cells
- GETPIVOTDATA....Excel 2000....Desperation!
- Vlookup Function?
- formula for automatic up on numbers in cell in exel
- Can I merge columns from one spreadsheet into another?
- linking cell to Pivot Table data
- Sorting
- Generating blank or null cells that the Histogram Data Analysis tool will ignore
- Insert copied row based on value
- Pulling a value from another sheet, based on date
- Sumproduct and Percentile
- Combining multiple formulas in one cell
- Pulling in data from another source
- formula to add Alpha?
- Custom date formatting
- How do I find the next blank cell in a range?
- Formatting
- Hiding certain decimal values
- Copy function with Excel 2003 not performing correctly
- Formulas
- design of CIS25 payment forms
- DCOUNT Help Needed
- Logical Functions
- Help adding letters in column
- Multiple Line Display Of Worksheets
- Matching cells and adding a value to the match.
- "Between" dates in Excel
- IF(AND problem to work out commissions
- HIDE row if CELL value is #NA
- Cell entry using Parenthesis
- How do I reference certain rows within array formulae?
- A validation rule on Alpha and Numeric characters
- can I do this in excel
- Scenario in formula
- Find last space
- Strange calculation in PivotTable
- SUM and IF results
- how to get the value in the upper 5 cell
- Pick up digist from another column
- How to close a excel file using Macro coding?
- rounding of numeros
- Copying Functions
- Linking cell content
- Data connectivity across two seperate .xls files, interesting
- If Statement
- dates for weekdays in non-contiguous cells
- rounding of numeros
- Double quote delimiter script
- How do I get more smart tag recognizers?
- Worksheet_Change
- Help on sorting function
- How to code on Macro on saving and closing a file?
- Excel columns do they exceed IV?
- Please help ... comparing text
- Make a list using a Lookup
- Transpose?
- Bowling: Handicap between Teams
- Sort function
- Excel 2002
- WORKSHEETS IN ALPHA
- help to consolidate data
- help to count easily
- Formula to indicate upcoming birthdays
- Match and Count duplicate names
- Deleting Text Boxes
- How do I activate the Link feature?
- Copy a column leaving out any blanks
- Invalid data circle disappers
- Sumif question
- Merge contents of cells and insert line space
- If & and
- Combine firstt & last name
- How can I do this?
- Multiple IF Statement
- Function to find the first cell that is not zero
- Function to find the first cell that is not zero
- Macro Help
- Finction to find the first cell that is not zero
- Updating Individual Sheets from a master
- How do I convert numbers to words in Excel
- random row numbers
- in put cells into email
- Sumif only numbers formated as currency
- Logical Functions
- Keeping a Macro in a new book
- How do I get a unique number on a form when I open it each time?
- SUMPRODUCT - Ignore blank rows
- Excel Formula for Single Cell Adress
- Duplicate Item Numbers
- I would like to merge in some data in an Excel spreadsheet to ano
- More referencing
- auto filter on multiple rows
- Help with Formula
- Restricting Data Elements in Pivot Table
- Appending or Concatenating rows by Client
- Data referencing
- Fomat cells for IP address including leading Zeros
- Worksheet Function
- Need help please with VLOOKUP and INDIRECT question
- VLookup Range Help
- Capital Calculation
- How to display numbers as text? Ex: 203 = "two hundred, three"
- Sum all integers of a given number
- Referencing tab based on Variable
- Nested VLOOKUP
- Formula problem
- Different validation list based on cellvalue on the left
- How to enter or edit data to multiple worksheets on different ce
- Adding a date prompt to get external information
- Make a sheet to enter score and score is copy to the proper cell..
- Choose highest value duplicate
- Function to Spread Costs
- Identifying Current Cell
- Can a date in excel be linked with outlook to serve as a reminder
- SUMIF Criterion with NOT
- CONCATENATE number and text from different cells
- Relative reference for named tabs?
- copying the Hyperlink function result without copying the actual formula
- convert Excel sheet in 1904 format to 1900 without changing dates
- SUMIF criterion to match the first 5 characters.
- Link Excel Workbook to Powerpoint
- Vacation Accrual Formula Need Help Please!
- Function for all Characters after the :
- In series of 10 digit #s, how can I exclude 1st 3 digits in each?
- Is VLOOKUP what I need?
- Large and if function!
- Thanks
- math
- Min Fuction
- Count number of text values in a specific row
- can you make EOMONTH work without Analysis ToolPak
- How do I get MROUND to only round up to the next multiple.
- Creating a Data Validation List based on a Value in another cell
- Hiding Worksheets - Problem with Posts
- Date going forward
- Relation betwn 2 sets of data, user to input one, sheet returns ot
- lookup single value in a range and return specified value
- How do I merge info. from 2 sheets using common numbers in Excel?
- Automatically update a cell
- Copy & pasting formulas across workbook tabs
- Breaking out individual files from a .xls worksheet
- Conditional Formatting for cells with formulas
- Index and vlookup assistance
- SUMPRODUCT with TEXT and dates
- Ændring fra rækker til kolonner
- Help Excel Formatting
- How do i click on the iSeries book in excel worksheet?
- non-availability of Microsoft Community Newsgroups
- Cannot see any posts after 6/5/2007
- formulas appear in cell as entered..
- Finding missing values in a column
- Function Troubleshooting
- Conditional Formatting - Date Refresh
- Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets
- Need Help Creating a Macro Multiple Workbooks to One
- Multi-Conditional Functions
- Projections Formula
- Formatting Cells?
- Creating a name list from if quantity value is in adjacent cell on
- Weekends
- Sum of Column with next column containing specific word
- Help with Hlookup/Vlookup and Lookup. From multipul sheets
- Help with function
- Multiple Criteria
- Dispay two values in one cell with the / border separating them.
- HOW CAN I MAKE AND OR ADD NEW SYMBOLS TO THE LIST?
- how can i make a list of numbers automatically
- unable to see postings after 6/5/07
- SUMIF Conditions
- Conditional Average
- Filtering diverse values
- transposing addresses
- recent postings not seen
- Trouble Freezing Panes in Excel 2003
- Lookup returning incorrect result
- Round to thousands via custom format?
- sorting contents from right to left
- Number of days in a running period
- Sum duplicates unique values and delete dupliques
- Can I calculate the number of days taken off in a running period
- Set 'Print Entire Workbook' as default?
- Ifsumproduct
- Sumif, having two condition
- Help needed in updating excel worksheet values
- 2 Conditions + Sum of a colum matching those conditions
- Dana: help with your Demo() macro to "expand" formulas
- Summarizing data to another sheet
- Average
- 2 Questions
- Using Sumproduct in Autofilter
- Converting Julian Dates to regular dates
- IF, ADD TEXT. DELETE LINES AND RETURN VALUE...
- Averaging
- How to auto data from one work to another worksheet.
- Calculating sales commission that changes based on a sales volume
- Copying cells from one spreadsheet to another?
- Leading Zero and the change command
- Long List of Numbers sorting
- Conditional Average
- vlookup not finding matching data
- Protect some sheets in an xls but not all.
- Index Max Off other sheet
- SUMPRODUCT with TEXT and dates
- How do I keep a "running total" from wrksheet to wrksheet?
- Parsing a text string into separate cells
- How do I fix a GPA formula with a null value
- quick double-criteria lookup?
- Selecting part of a number in a cell
- Navigating
- Cell Shading
- Navigating
- Condititional Formtting a Column
- Growth
- How to merge columns from one worksheet to another worksheet
- LOOKUP error
- Skipping cells in a formula
- Old function is not working.
- TIME SHEET FORMULA CONDITIONS
- DCOUNT function not working properly on string comparisons
- I can't see my last post, but its been answered- help!
- Extracting characters before or after a specific character
- SUMPRODUCT and Dates
- URL Encode
- Copying and pasting from a range
- Formula for cashflow on every 90th item
- convert number to text w/ error checking sign
- Date problem
- Formattting Text
- Consolidate multiple worksheets into new sheet
- Excel: How to forecast 12 months' figures but force a 10% growth?
- formula for current stock count needed
- Translation Formulat Entry
- Hlookup?
- a macro that Formats a textbox based on value in a cell
- Validation in a Conditional Statement
- current stock formula help?
- How do we make Inclusion-Exclusion Principles on Excel?
- Excel User Conference
- IF statement
- If statements
- I want to make convert a number in words in excel
- COUNTIF
- Calculating percentages based on the number of checked boxes in a column
- Cell reference OR INDIRECT function
- How to sort data according two matching cells?
- format control on large number of checkboxes
- Format Control on large number of check boxes
- when i try to fill a cell with color, nothing happens
- How to retrieve entire row (actually 26 columns) of data ?
- Using SUMIF to update prices on a worksheet
- AVERAGE NUMBER IN COLUMN PROBLEM
- copying formulas
- ecel will only open as read only
- How to use =sumallsheets(b1)?
- TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE"
- day vs time format ??
- multiple worksheets linked to a master worksheet
- Copy data from multiple sheets into new sheet
- format control for large number of check boxes
- Hiding Comment
- how can i round in excel to the nearest thousand
- How do I make all worksheets inherit certain characteristics
- protecting cells from change
- Return blank cell if value you vlookup is not on pivot
- Can I include a "validation drop down" in a conditional statement?
- Create a box where I can input data
- HLOOKUP and INDIRECT alpha numeric
- Sum based on specific condition
- Date format problem
- Original subtotals should not be within nested subtotals in excel
- Automatic Decimal Places?
- drop-down menu in an excel spreadsheet
- Averaging values from a list, based on user input
- Lookup based on two fields without merging?
- search and change without replacing-excel 2002
- Countif with 2 conditions
- Conditional format for the whole row
- how do I change the colour of selected auto filter tabs
- Color of @IF Results Cell
- Creating an IF / AND statement
- formula needed to bring values to another sheet
- Functions to ignore hidden rows
- Writing IF Statement
- My formula is =IF(B5="B",TODAY(),"")
- VIN Number sorting
- TimeSheet calculatons Overnights
- LOOKUP across Multiple Sheets
- Combo Box
- How do I sum cells by refering to discrete values?
- Help on sumproduct function
- lookup with INDEX MATCH formule depending on 2 conditions
- Looking up and reporting values across tabs
- It's a filter but not a filter
- Custom format field
- About sorting and extracting data in one column
- A1= A2 (When selected).A3 (When selected)
- Is there any way to delete a Digital Certificate
- HYPERLINK() referring value from a cell does not change when cell
- Conditional Selection
- find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK")
- How do I change minutes (1.5) to 01:30?
- How to merge data in Excel - one sheet to template sheet?
- Need to 'COUNT'...
- HLOOKUP INDIRECT with alpha numeric worksheets
- Pivot table calculated field
- OFFSET: Returns error when used to a linked file
- Offset / Match / MAtch
- Excel list boxes
- Expanding Formulas
- columns to rows based on record criteria
- Can you attach, hyperlink or embed Email Items in a SS?
- Calculating earliest start and latest end dates by contract
- Having trouble nesting function.
- lookup value and date from a list with restrictions
- matching fields between two workbooks
- adding time
- Date Generation
- Protected worksheet
- How do I run a macro from inside an"=IF" formula in Excel 2003?
- combining cells
- calculating a discount rate
- Need to do an EXACT LOOKUP
- Can I have the TAB name be a calculated field...?
- Multiple Lookup Application
- Choosing last set of data in column
- How to auto fill with fifth cell in a column?
- Average
- DCOUNT problem with numbers stored as text
- Command Button to run a Macro
- how to change coloum to row
- problem updating links unless sources are open
- Fomulas with tex and numbers in same cell
- VLOOKUP
- summing
- Time Formula
- give text a dollar numeric value
- Multiple VBA script
- How to divide a number into various denominators
- formula calculation
- Basic formula - forgotton !!
- Concatenate format
- Auto Filter function only provide 2 criteria input
- Autofill doesn't give the number of records filtered any more
- Master Worksheet Display
- Calculation of Area Under a Plotted Graph
- Ranking or sorting function
- Look up 2 values, return result in a different workbook
- Comparing two lists using Conditional Formatting
- Lookup
- linking some templates automatically to the consolidated template?
- Excel VBA help
- Array Formula Using LOOKUP function.
- how do i create table of contents links/pg for multiple workbooks
- copy cells
- ecel:create a file name from data in worksheet
- function for repeated cells
- Apply conditional formatting to individual cell Excel 2007
- How do I use excel for orders of 250 photos for 200 staff
- conversionof numeric data in word
- Format Cells for Mins / Secs
- Auto scroll down event
- Highlighting with hyperlinks
- maybe by sumproduct or some other way with text.
- PER function
- Array formula on INDEX function not working
- List cell values seperated by comma if criteria met
- Weekend
- Sum from two pages
- type a 00 . It keeps changing back to 0
- Maximum filesize?
- Levy Jennings QC template
- LOOKUP, MATCH, INDEX?
- How do you remove some numbers in a series eg 1500024500 = 24500
- Checking Dependence Before Deleting Worksheet
- Quick Go To for Formula Components Other than First
- Quick Go To for Formula Components Other than First
- Shorcuts or Macro for Creating If Else Statements
- Vlookup question
- determine wheter string has a number in it?
- How to change text color in a cell "comment" in Office 2007?
- Sorting errs
- summary of milestone
- lookup a value from a list excluding a previously found value
- nested vlookup does not work
- splitting cell
- custom autofilter
- SUMPODUCT - Some one please help !!!
- multiple if statment
- How do you Control the fill color using an if statement formula?
- How do I change the size of the drop-down arrow after validating?
- How do I change the size of the drop-down arrow after validating?
- ?? What Function Do I Need ??
- Tab Key
- Drop Down Box with Check Box Selections
- Subtracting Text from Number
- on time indicator
- How to sort protected worksheet in Excel 07? Doesn't work.
- INDEX/MATCH/LARGE returning #VALUE! error
- Compare data in one sheet to another
- Updating subtotals
- Invoices
- SUMPRODUCT
- Displaying calculated times - half-hours are not calculating...
- copying one cell in multiple sheets into a column on one sheet
- Merge of cells
- Merge of cells
- Merge of cells
- Counting non-blank cells in a column, excluding hidden rows
- Vlookup in vlookup - taking the result as array name
- sorting column data
- Distribution of amount using If Cond / any other function / by VBA
- Sorting numbers with two decimals
- What does this function do? {=table(D19,D21)}
- I don't understand this formula {=TABLE(d19,d21)} - please help
- VALIDATION LIST ORDER
- Linking Excel and Access to import a single record from DB
- how to find common cells in several columns
- Converting annual rate of return to quarterly equivalent?
- Return an absolutely empty cell ... but not ""
- Conditional Ranking
- Frame an Invoice from the data available in a separate sheet of excel
- eliminate space at beginning of line
- get a column of cells to add if current month
- How to Validate Excel for SOX (Sarbanes & Oxley)
- I feel so dumb - please help - this is a Range issue
- Sort by Year and Week
- Sort by week and year
- is the polynomial regresson analysis in excel possible
- Fill Cells Based On Cells In Another Sheet
- Formula for Pulling partial data from one cell into another
- Worksheet Formulas
- Data Validation
- copy all and paste values for all sheets in a workbook
- I created a UDF but I can't run the function ...
- percentages of subtotals
- Separate lines in Excel cell
- Linked cells and text wrap / autofit function
- Unhandled exception - Not implemented
- Pop up Calendar error
- how to push data to another cell
- Change time h:mm to a decimal number based on hours
- ISTEXT TRUE then copy formula from cell X
- Identify & List unique values from a list using functions/formulas
- Adding and Subtracting a Time with MilliSeconds
- Subtotal Formula
- Accounting for Duplicates in Rank
- =OR and =IF Help
- vlookup error
- how to sort column with cell pairs
- Updating Master Log records
- In Excel, how do i automatically re-direct the cursor to a new spr
- Text import/ Text to Column
- How do i set up a dropdown listbox of values in a column of cells
- Date question
- add text to cell
- Color changing of fonts by using the IF function
- Command Button
- SUMPRODUCT assistance
- dynamically changing text color
- Trace Precedent
- If function help
- Corrosponding excel generated numbers with 1st row numbers
- VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to incorporate. TIA for help
- Use a formula in custom autofilter
- Count blank with multiple criteria
- Require mandatory info input in order for Exel to save changes.
- average last four rows in a column
- help on GPA formulas with null value
- HELP
- cannot enable redo-undo function
- Excel, date-sensitive, 2-part formulas
- array range in seperate sheets
- Help with Pivot Table and totals
- Hide VBA code help
- Transpose a text string while copying adjacent column data to new
- 27-May-2007 is a WORKDAY?
- Sumif with criteria help
- Listing names and id and corresponding software
- For Danielle
- SUMIF with dates
- count not working in pivot table
- HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
- Returning same value cell in a column but different row.
- Exported file to WP as merge. Now is corrupt. Data lost. Help
- Returning other cells with the same value in a column, but different row.
- Tabbing to cells
- Returning cells with the same value in a column, but on different rows.
- HLOOKUP second column
- How do i add a new entry to an existing drop-down list in Excel?
- Transpose a String
- Coomplete the formula
- how to extend the column limit on a worksheet
- Number of Saturdays within a range of dates
- Displaying Excel data in flattened hierarchy
- Date Format
- If function Help
- How to select a cell to the left of the right aligned cell with th
- moving items within the page
- vlookup problem when value absent
- Conditional Formatting
- Fraction Formatting and Averages
- how do i change a full excel sheet to proper after it has been ty.
- how to call the event of other worksheet
- COUNTIF oddity
- Count with multiple criteria based on cell not blank?
- How to sum unique values in a column
- HOW DO I SET UP A PRECEDENCE DIAGRAM?
- Comparing worksheets
- Excel formula help
- ### in row & won't "auto fit" - how do I show all text?
- Time after midnight
- return N/A when no first match but do nothing if no second match
- Help Drop Down List
- File Calculation
- sumif/sumproduct formula help
- autofill @ intervals
- Date Calculation
- set value in column based on value in ajoining column
- Setting up a database in excel
- How do I custom calculate within a PivotTable?
- Easiest way to extract characters in a cell LEFT or RIGHT of a sym
- Normalize score
- Befuddled by Count blank cells Formula!
- Vlookup bug?
- prevent big white screen
- Last Name
- excel range formulas
- COUNTIF for single word in text
- Why can't I enter a valid number in a cell with data validation
- SUMIF(NOT)
- BIG Dilemma.....HELP!!
- How to concatenate a value in cell
- Pivot Table: Limited nr of Calculated fields to show?
- How do you format an auto update to delete rows with expired date
- Tadays date
- vlookup average()
- How do I make a report listing Names and corresponding programs?
- Error message in my Excel sheet
- my TEXT function won't work
- my TEXT function won't work
- update worksheet keeping formula
- vlookup sum()?
- Pop up message on 1 in 5 entries
- Linked Spreadsheet rows
- Dynamic Avarage
- Display Elapsed Time
- Conditional Formatting - Draw Line every 10th Row
- Consolidate formula
- vlooup formula and if(),isna etc
- Advanced Filter to another location
- How to create a macro to help with lookup.
- How do I create a worksheet using a drop down list?
- Insert range of cells with a function
- Vlookup & hlookup
- how do i extract records
- Lookup formula?? or other
- How do I get a txt file to go to excel and have the columns work?
- Formula box character needed
- Random Placement whilst fitting constraints
- If statement trouble
- Excel - """"
- Dumb Question
- Elapsed time problem....again!
- Automated " delimiter adder?
- reference worksheet name in cell in another worksheet
- Offset code for dynamic row# & multiple columns in LINEST function