- spreadsheet to keep track of phone numbers
- keep track of phone numbers
- Document Specific Autocorrection
- sumif < date
- Excel Loan Repayment Schedule template.
- Replacing Part of a Cell's Content
- INDIRECT
- insert column header in cell below result of max FUNCTION
- Populate cell range
- how to change font in form contollers
- Ranking
- Extact minutes from text field?
- sum between a range of dates
- Auto populate a cell by comparing lists
- Lock or Unlock Range of Cells on Worksheet_Change Event
- How do you alphabetize street addresses within a column?
- <>= Formula ?
- Flying Hours
- how to have auto calc cells be blank unless entry made
- Weekly Totals Based on Dates
- clear cell based on text in opposing column
- vlookup returns wrong answer (off by one row)
- Need Simple List...Multiple Columns and Multiple Worksheets
- Histogram bins driving me crazy-please HELP
- How to print entire workbook 9 pages to a sheet?
- Formulas
- Selecting cells with the mouse
- countif and sum if if two condition are satisfied
- HYPERLINK - Jump to another sheet in the same workbook
- Subtotalling taking long time to complete
- vlookup not returning a match even when there is one
- counting values ignoring duplicates
- Pivot Chart Formating
- an IF function that can take no action?
- PERCENTILE exceeding 8191 points
- Average time
- How can I choose more than one item from list in a form in Excel?
- Gradient and intercept on data with errors
- controlling pivot table
- Counting data in a range
- Sum of continous cell
- edit data in multiple cells
- Count IF
- count if unique entries
- Find matching values in two different columns
- Dynamic Link to Quickbooks
- Sort Chart Values
- If statements looking for nonblank cells
- Dynamic Scatter Charts
- Filtering failed moving on...HELP
- Validation function with helper column
- Auto Fill Color Cell
- Help with a formula
- How do I find minimum duplicated values in a range?
- Fprced data entry on multiple worksheets
- Compare lists when one column contains multiple entries
- Vertical lookup of pictures
- Can I copy a field from another spreadsheet based on search?
- Creating a formula which would affect multiple cells
- different phrasing
- Extracting Specific Data from one sheet to another.
- SUMPRODUCT: dividing the formula of one cell by another.
- Formula question
- How do I display the result of a function on seperate worksheet e.
- I need help with an if statement that has more than 7 nested condi
- Buttons
- Function to Produce a Number Pattern?
- Lookup Need Help fast
- Command Button Shades annoying
- auto populate dates
- Auto filter by (ALL) custom from other sheet.
- total a column in which there are sum formula
- DP jog macro.
- Multiple Criteria Lookup Results
- cell color
- Formula at alternate Cell Values
- Countif with two conditions
- formula alternate column call value
- Re: formula alternate column call value
- Total of a specific name
- SUMPRODUCT - Using Month
- Re: SUMPRODUCT - Using Month
- 2008 East Coast US Excel User Conference
- Using COUNTA for a variable array
- vlookup in pivot table
- Random Sampling - Please Help!
- Converting from 12-hour to 24-hour format
- Looking to replace "dots"
- Mid Function
- If formula error
- Formula Error
- Match forst four letters
- counting two ranges for one criteria
- how do i copy a worksheet to another work book
- Cell Background Color
- Pivot Table
- add cells together from different sheets within a workbook
- date flexibility
- Combining date and time data
- Pivot Table Help
- How do I calculate the mode for a column of text?
- Upper to Lowercase in Excel
- Automatically adjusting chart reference
- Check box in Filters
- Anchoring Excel Cells
- Using the Subtotal function
- SUM ONLY CELLS INA RANGE THAT ARE NUMBERS
- Handling cells with multiple data entries
- Workdays/Networkdays #Name? Error
- How do i convert diagonal text into horizontal text
- IF Formula Error
- can you link a text box to a cell in excel?
- Referencing Table Data
- subtracting date/time
- IF Formula and multiple formulas
- Paste, Paste Special
- MIN and Year Functions
- Display a Date when a cell is Modified
- excel formating
- Define fiscal year
- Match and Insert Value
- Conditional formatting to a different cell and it contains a formula
- PivotTable Grand Total Error using Calculated Field
- Finding cells with a value ending in '.0'
- Replacing characters with numbers in cells
- how do I protect a column on a worksheet
- INDEX function
- Sum the amount of times a number appears in a column in Excel?
- Combination...SumProduct, Index, Match?
- Sum up all up changes and down changes
- Function for grouping range of data
- text in mm:ss to time
- DATABASE REACHED MAXIMUM SIZE
- Custom functions
- Hyperlink Function
- I have a text cell and I want to inport a value into the cell
- Multiple Critiera Sum Array - One critiera to be between two numbers
- How do I automatically put like data into several worksheets?
- Paste Special
- This formula can not work in Excel 2007
- Count Function
- Time query
- Excel still not recognising equal values
- how to get the answers from 3 conditions
- How to set the enter key to move every 2 rows instead of one row
- Locking Cell through Validation
- Macro To Make Workbook Demonstrate Itself
- Data Validation - select AcctName and AcctCodes shows
- Can't view all text in a cell
- how do I Count number of records beteen two dates- Excell 2007
- Column hidden and Auto filter
- Non-table look ups
- multi-if then formula i think
- Chronological Numbering
- Selecting the latest date reference
- CHANGE THE HEADER NAME
- Spreadsheet
- applying formulas for all sheets selected
- Sumproduct with If
- How do I create macro to add 8 rows at a time?
- Sumproduct
- need formula to apply to entire column not just one line
- Pivot Table - How to exclude info without showing?
- conditional format equal function
- Removing a listbox from excel spreadsheet
- Complex Conditional
- Date of worksheet comes out numbers on other linked worksheet
- Conditional Formatting: Adding more then 3
- Min +1
- Seeing Linked Information
- Macro for Edit/Copy/Paste Special
- SORTING WORKSHEETS?
- Vlookup problem
- How to simplify a L O N G functional argument
- Question on the countif function and times
- HOW TO CREATE AN ARCHITECTURAL NUMBER FORMAT
- Counting a range of cells
- blank date shows up as s 1/0/00
- Mutually exclusive cells - Excel 2003
- Need a formula
- past date cell colour change
- color change after date
- semi-interquartile range function?
- Count cells based on whether another cell is blank or not
- Vlookup or getpivot? two entries
- Using Table Column Data in MATCH
- Tabs
- What is the math divide funtion in Excell?
- Why QUOTIENT function is not being recognized?
- How do I insert a work sheet populated with data into another?
- Formula help
- Sliding commission rates in excel
- RANGE addresses. Getting from other cells.
- Transposing from two dimensional to one dimensional
- Aouto filter by macro
- automatic inserting the values
- Need to remove text with strikethrough - Excel 2007
- Changing Data Source
- SEPARAT NUMBERS FROM TEXT
- Problem with "Currency Convert to Text"
- help with function/formula
- Auto updates with checkbox that affects total
- count occurences meeting criteria
- Advanced sorting
- How do I only pull rows if the data matches a named range?
- SUMIF sum range
- Formula Help
- Connecting multiple IF THEN formulas in one cell
- Conditional Formatting on empty cells
- Pivot Table, Calculated Field, Running Total
- Cant use indirect() and dynamic ranges together?
- 1 parameter for multiple pivot tables
- Is MSNstockquote only for stocks?
- how to get the median of cells that meet a given criteria in excel
- Formula Question
- fixed asset life table
- VLOOKUP and HLOOKUP
- Hyperlinks
- whats the formula
- emailing active sheet with macro
- formula based on first two charachters of a cell
- VLookup is not working correctly
- how to sort addresses in microsoft excel
- Negative time numbers
- Update formula automatically for inventory
- multiple values in column
- Blank date column return datel 00-Jan-00
- Exact Precedents
- Columns into 2 way tables
- =If( statement for 80-90% condition then write "ME"
- worksheet functions
- Excel Documents
- how to format a complex number
- how to combine Logical if and Vlook up
- Focus on a cell based on date
- Help in formula
- Sum from a Drop down menu using value in the cell below
- Sum and If Function Problem with Excel 2007
- COMBO BOX FOCUS
- Hyperlink an excel spreadsheet to a specific Powerpoint slide
- Excel - Compare spreadsheets and indicate matched data
- Analysis Toolpak
- Count functions with multiple conditions/ranges
- Excel not converting file
- Alpha conditional statements
- Date Function needed
- LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT?
- Excel 2003 - Copy Down Function to Reference Next Worksheet
- Add top numbers
- Counting rows that meet conditions in multiple columns
- Sum and If Assistance Please
- past cell by date
- How do I SUM multiple results from a VLOOKUP?
- Average of a difference between 2 cels in a table/array
- Explaination of Logical If Then Statement
- Count instances of text in date entries
- VLOOKUP Keeps Returning #N/A
- Keyboard shortcut for Paste Special-Values
- Countifs with same reference?
- No question
- conversions
- Scoring Formula helop
- Referencing Checkbox Names
- Excel Formulae 'Help'
- Excel Formulae
- Nesting if/or/and
- Want to add help file for custom function but excel 2007 is flaked
- separating numbers from text
- 40 sheets/Formula to advance to next worksheet
- Using IF and MAX functions together
- can you link an excel workbook to a live word doc
- Sum Of Last Three Entries In Rotating Columns
- Excel mobile help please
- change order of 5 letter word based on another cell containing 5 numbers
- Locking cells with formulas
- Any ideas why a reference that works will in 2003 has problems in
- Templates
- To find data
- FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE
- Stuck in a Sub Loop
- I Need An Argument
- Sort excel columns as a function
- Letter Replace Help!!
- sumproduct with wildcard for text?
- RE: Sort
- Sorting
- RE: Sort
- how do I copy automatically from one worksheet to another
- Excel Function
- Sorting a table on 2 columns
- Sorting columns into a table
- Returning a value based on a query
- Conditional Average
- Formula Returning Records # of Days from Today in Excel
- Drop down lists and macros
- Lookup Function
- Convert Indirect row reference
- Sorting out negative numbers
- Allocating the numbers from the total
- need help formating a cell
- Count items in range
- sumproduct
- copy and paste not functioning, think clipboard problem
- Multiply with conditions
- help text for user defined formula
- Summarizing specific data from one worksheet on another
- SumProduct Question
- Long If Statement
- Lotus 123 has a function called "rvbalance", does excel have?
- Index, Large and Match??
- Cells linked to another workbook with a formula.
- Vlookup based on 2 criteria
- Purchase Order Form
- Filling speadsheet with INDIRECT functions?
- Max function
- rounding problems
- Help with Functions (IF)
- VBA Help
- Prevent alpha character from being entered into a numeric field
- rounding problems
- If and/or Look Up function
- compare cells in column to criteria, then average next column cell
- How do I export report and have info appear on 1 line?
- [XL07] Conditionally format fill color for entire row
- NOTES FOR A CELL
- grouping cells
- Search/Match/Find ANY part of string to ANY part of Cell Value
- Mid Statements
- Row reference formula not working with a VLookup
- Conditional Formatting
- Multiple if statements based on two columns of information
- conditional formatting #
- TRUE/FALSE function in IF statement
- Excel 2007 Lookup
- Cell on Cell interaction help
- Make a cell not equal less than a certain number
- IF Function Question
- Autofill reference formula but repeating n times before incrementi
- Pivot Table
- convert feet & inches to decimals
- MATCH not working in IF statement
- EXCEL Formula Microsoft Product ID
- How do I compare two columns and return a number count
- Combining data from 2 sheets - advanced help please
- I want help to fill data of sheet 2 in sheet 1
- Linking formulas between several woorkbooks
- If, Lookup, Match or a combination of all
- The hyperlink reference doesn't changes when I insert Rows and co.
- why do I get an error message when i try to merge cells?
- VLOOKUP? SUMPRODUCT? not sure how to do this
- formulas
- use source formatting with protected worksheet
- 3D References
- Which functions do I use
- =If(A1:D1="Pass","Y","N")
- Conditional Formatting Question
- How do I copy specific information from a master sheet?
- POSTIVE PAY FILE FORMAT
- How best to use sumproduct instead of conditional sum:
- Retain font/cell color on lookup/copy
- Conditional Format - Hide/Unhide
- How do I copy cells containing drop downs?
- Pos Pay
- append column data
- Copy Paste filtered column ok in 2003 not in 2007
- match, lookup two column data
- Conditional Hyperlinking
- Dates - Custom - Pos Pay Format
- Nested if using range names
- "A pivot table report cannot overlap another pivot table report"
- Data Validation Question
- Change tracking in Excel
- Copies From The Internet
- How to use a range name in a macro
- define name with 2 lists
- VLOOKUP Question - Can I Keep the Same Aray with Drag?
- How to count for 3 columns
- Case Sensitivity in Lookup Functions
- Really large files, not sure why
- invalid reference for vlookup
- counta
- Remove Rows That Are NOT Duplicates
- Comment insert
- IF function, nested with 2 source cells?
- Formulae stop working
- I think I know how to ask this sumproduct question now:
- RE: Combine 6 Worksheets to 1 Worksheet with total amounts
- Re: month text in calculation
- Re: month text in calculation
- Question about Comparing Data
- COLUMN & ROW EQUAL
- Multiples conditions in an array
- Collapse/Expand Buttons in a Pivot Table
- format a right justified zero filled field to a prn file
- certain time
- Concatenate a formula
- unhiding formulas
- Excel filtering of split panes
- Removing Digit Separator
- Date Calculation in Conditional Formatting
- print range is gray and i cannot change
- sumproduct_zafar
- Adding a sort to a working query asks for a parameter value
- Replace mutiply sign *
- why do I lose cell format in a pivot table?
- I have year based data want to convert into weekly basis
- Entering changing months with a cell
- Use tab name in Vlook Up
- MCONCAT
- Pivot Table Question
- how do I set up or adjust my column chart?
- How to Create Macro to Increase Cell Value to one and Print Worksheet
- IF
- Annual Leave automatic calculation
- Extracting data from Outlook to Excel using VBA
- Vlookup on Dates
- how to change formula in shared sheet without loss of change histo
- calculate percentage of numbers <= zero in a given range
- correct formula
- Insert Graphics File into Worksheet via Formula
- Adding duplicates...
- Expansion of COUNT if Question
- Printing with ""
- change formula in a shared worksheet without losing change history
- Separating Strings
- Conditional Sum of cells
- Pivot Table data
- Generate list
- if statement syntax help
- Help with combining lists
- Excel Function - Date evaluation
- Create macro with button in excel spreadsheet
- Protected Workbook, no comments?
- MACRO for Matching Two List
- Calculating dates of holidays
- Re: Changing worksheet reference in a VLOOKUP
- NON SEQUENTIAL DATE RANGES
- Get rid of $ signs in formulas
- How do I intergrate lines added so they follow in descending order
- Using SUMIF with RIGHT()
- How do I delete the refernce a formula when copying and pasting?
- perfoming ANOVA test
- assigning grades
- Getting a Count
- Date Calculations
- Convert int ccyymmdd to date(time)
- Cell Underline problem underlines across width of cell
- Nested Forecast Formula Help
- CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN
- return values in the table with multiple conditions
- Excel 2007 Autofilter vs Excel 2003
- EXCEL - COUNT help
- calculating Leave
- Hiii - Please help
- sumproduct_zafar
- sumproduct _zafar
- Cannot insert worksheet in exel - not available in insert menu
- drag across multiple data sets
- VBE Error (Project unviewable)
- Need help ( Hope i made it clear this time)
- formulae corruption in excel
- Cell references in SUMIF formulas
- how to extract caracters up to comma in excel cell
- INDIRECT reference to another worksheet in same workbook
- Graph and updating
- Countif numbers fall between two values
- SORTING CELLS
- How to conditional format columns in a range based on
- Counting Empty Dates within a Range?
- Summary help!
- Query: Automatically transfer complete rows?
- Sales mark up formula
- Inserting data into next blank cell down in next sheet
- column reference in an Excel spreadsheet
- Excel 2000
- Scroll Bar Disappears
- Look up Function
- Macro to copy an image (or picture) from one workbook to a new sheetin another workbook
- have date show in cell when only entering numbers
- Linking appointment dates
- Color coding cells
- How do I create a table on a new worksheet from other worksheet da
- excel text formula does not calculate after editing
- How to dealing with functions with 30+ variables?
- =COUNTIF & how to make it apply to consecutive cells
- excel won't save the border lines
- Hyperlink option is greyed out
- Filtering
- setting multiple conditions in one cell
- ?Advanced? Hyperlinking
- can i create formula to make cell PLURAL if other cell is >1?
- need help with sumif function
- VLOOKUP
- how to make an IF function that has the same result as COUNTIF?
- DATA VALIDATION
- If and Date Ranges
- Function choice
- Using IF and date ranges
- COUNTIF
- Average if and networkdays
- MODE - Second most frequent value
- using error type and if statement to return a value.
- How to use LEN & LEFT on last name to show only 3 letters
- How to ID numbers in Excel sheet that add up to specific sum?
- Use Len and Left to make name 3 letters
- Remove dashes from phone numbers in a spreadsheet
- getting list of files
- Excel 2007 lookup problem continuing ...
- just wondering, do they have smthing called XMIRR
- Calculating present age if date of birth is given.
- alphabetize ignoring hyphen
- Enter a value in wks1-Find that value on wks2-Auto fill cells in w
- create a summary sheet
- Simplification of IF Statement
- Create a time-tracking sheet in Excel
- linking a jpeg file to an excel cell
- HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET
- new to excel need help with function
- EXCEL 2007 Worksheet expanding to maximum size unwanted
- large amount of data moving to excel
- Shared Document & Hyperlinks
- Auto Sum entries in a cell
- Excel Spreadsheet
- vlookup() function
- Counting the ones, twos and threes - Please Help
- Logical if more than 7
- Date Question
- Associating a STATE or TIME with a phone number
- Need something other than IF function
- Multiple Lookups in one Cell
- Using Countif with multiple worksheets
- Excel Help: tracing formulas between cells within workbopok
- VLOOKUP for multiple colums
- Linked sheets, blank cells and adding new rows
- remove #n/a from the columnI've used a function
- Total rows allowed on spreadsheet 2007 version
- Moving linked data and retaining link
- Cell Paste using cell link option Half works
- Multiple Conditonal Comparison
- Lookup MIN Date
- Seperate Cell contenets in to different columns on basis of leadingspaces
- Re: Lookup MIN Date
- ANOVA with two factors
- Get External Data - Missing last row
- Need help with formulas
- Caps formular please help
- Trying to get work days out of two dates
- Formula greater than
- Excel Script to Auto pick next
- INDEX using range
- Msnstockquote
- Variable named range in worksheet function
- Replacing ISERROR Formula
- Need Help on formal - output a sum
- Alphanumeric
- Formula for multiple cells
- Formula for multiple cells
- TABBING BETWEEN PARTICULAR CELLS
- Formula for Adding cells up
- discounted cash flow analysis
- difference between exel 2003 and 2007
- Formula Not Working
- How do I copy a VLOOKUP into a column and keep a constant array?
- WORKDAY() results appear to be inconsistent...
- Need help creating formula for given data
- finding out denominations.!
- Formula
- Vlookup (pickup the last row...
- capturing all of the data
- Freeze a title only
- Break a forgotten worksheet password
- Freezing Panes
- Re: AVERAGEIF
- file names
- Find & Replace - Limit search to a specific column
- protecting worksheets
- Drop down lists to transfer data between worksheets
- ACREDITE FUNCIONA!!!!!
- Adding Rows
- Multiple If Statements in the same cell
- Report Function
- Exporting data
- Data List Header Row
- Vlookup with multiple corresponding values
- hlookup
- Password
- all dates in a column have gone back four years
- How we convert number in to word
- Different password for different worksheet
- Calculate the time difference excluding weekends and out of businesshours ( i.e. 8AM - 5 PM)
- Using auto filter after my worksheet is protected
- Sums - D4 MINUS D3 EQUALS D5
- lookup or vlookup
- Lookup automatically specified arrays
- Search for data and return cell reference
- Help required
- Not allow data to be entered beyond a specified row.
- VLOOKUP()
- how to delete continously data
- File Conversion - why does this appear when I open excell wk book
- Ignore blank cells when calculating date for If, Then function
- Conditional Formatting in Excel 2007
- How to combine two columns into a new column
- Problem with IF Statement
- SUMIF
- Deleting/Sorting
- Write a formula using two arrays, across two worksheets
- tracing precedents
- How do I uncheck numerous Excel2003 form toolbar check boxes?
- If Statement On Two Conditions
- excel 2007 formulas
- How to use the IF function to resolved more than one creteria
- How do I format cells as custom and keep text formatting?
- Excel worksheets
- Creating a data entry form in excel
- Creating a data entry form in excel
- Count if problems
- Converting entered data into a different output
- If then else
- Still need help with IF and Count Function
- How do I use a variable as a reference to an array in INDEX
- Need to report a count that meets multiple criteria.
- HELP linking access table to excel
- Formula being replaced by =#N/A
- MS Excel 2007
- Lowest two values
- Lookup Formula Question
- Adding sums from different worksheets
- displaying the correct value.
- Copy & paste block of text number of times equal to value in cell
- Regarding Formula for Date and time
- sumproduct help.
- RE: Apply a percentage factor to a base number
- RE: Apply a percentage factor to a base number
- Multiple Data Validation
- convert US dates to UK dates
- Is it possible to filter using row height in Excel
- Lookup Function Not in Ascending Order
- if val in col3 is one of 13 codes (list), apply factor to val in c
- Lastrow
- Excel not correctly calculating formula
- If with multiple or
- How to check if a date falls within a range(2 cells: Start/End Dat
- 2008 East Coast US Excel User Conference
- Functions for inventory
- how to make a cell mandatory in the excel sheet
- MATCH working but not....
- Summing between two dates
- Exporting list from Excel to PP, I want a new slide for each cell
- Counting Records Between Two Dates
- "IF" Condition
- How can I calculate total spend on items that have different values
- IF function
- How to clear data in pivot table?
- find the cells that represent a code in one cell
- XL2002 - VLOOKUP with variable Sheet Name
- Autofilter with pivot table
- Sumproduct
- How do I use the SumIF function with a criteria of a cell color?
- Hyperlinking to Excel and the resulting cell shading displayed.
- #VALUE! error message in simple sum function
- What would I set up this formula
- Vacation Tracking
- How can I filter just 2 columns (separated by another column)?
- count if with multiple criteria
- How do I automatically delete a row, if one cell equals zero?
- Short Way to Calculate Salary Increases
- Condensing a list with duplicates to a list with non-duplicates
- Filter by Date of Birth
- How to Combine Cells using Other Cell
- average formula
- How to Change Column Header from numbers back to letters
- index(match) Wind Uplift Calculations (match four conditions)
- Display row of the maximum in a list
- Rolling Monthly Average
- Pivot Table with source spread across multiple worksheets
- IF and ISBLANK
- Calculating the value of a cell from another cell
- cell reference formula
- Make cell contents blank upon opening worksheet
- How can I get DGET to return all records that meet the criteria?
- lookup and display
- when I enter a number, only ###### shows?
- Simple problem with Dates and Times is driving me nuts
- display.. help
- sorting problem.
- Macros in Excel
- two variables to get result
- Order of columns in Workbook Connections
- Function indicating a row have empty value on several columns
- SumProduct?
- Previous visible cell
- Excel conditional sum
- find and Summarize data in a table from a different sheet?
- 1st sheet
- Import from Text dropping rows from .csv
- Names and addresses
- Fill color with if function
- can assign a picture to a cell ?
- Find duplicate, but only if an adjacent cell is identical
- Look up for a value in a s et of ranges
- Round to the nearest minute if more than 6 seconds
- How to use the IF Function for 3 conditions
- Delete unprotected cells in protected worksheet
- Better performance Vlookup or Index/Match?
- count number of instances a number occurs
- Enter a User Name When Changes are Made
- Min Function
- Pop Up Message
- Work Sheet Association
- Conditional Formatting in Pivot tables
- Excel showing files as read only , when they aren't.....
- Determining the text mode from a variety of data types
- Add days to a date, but exclude holidays
- iferror
- formula for unique values
- putting help text in the animated bubble
- Determining work hours between dates / hours
- Need function that will work in Excel 2003 like "Countifs" in 2007
- Vlookp-matching names between sheets
- Conditionnal Formatting
- Pulling Data from External Worksheets
- Averages
- match values in two column and return value in
- NETWORKDAYS formula
- Can be here some changes for a faster speed ?
- Need Function for Year-to-Date spent total
- filter in a filter
- Can a page number be displayed in a cell?
- Need button to add rows on protected worksheet
- Delete row 1 based on condition in cell on row 2
- Product - Conditions - Edited Results
- Conditional Format to Highlight the Active Cell
- left and right functions
- List of when functions where added
- averages on grades, how to input formula when it has a percentage
- Dates And Pivot Tables
- VLOOKUP question
- VLookup worksheet name
- Picking up data from workbooks which may not exist yet
- Summing Problem In A Pivot Table
- Decimal to Time Format.
- Using a function/formula for copying text
- How do I count sets of cells in two columns?
- Need help with this formula
- Løbende nummerering
- How to check previous entries in column for same contents
- Rounding Time.
- Sum Time.
- Count a range of cells using an IF
- Formula with multiple variables
- How do you Position WordArt behind data
- Filtered Data-Linking
- Data Base Functions
- Cell offset issue
- Identify missing numbers in list
- Need help with an IF formula
- VLOOKUP - MULTIPLE RETURNS
- Quick way to change file name
- If conditional + Vlookups
- Formula
- Counting time
- Complex cost allocation formula
- macro help to change row colour automatically
- Formula using worksheet names
- Filter on more than one cells (text)
- need help mutiple worksheets to create monthly report sheet
- Sumproduct calculation for January 09
- Sum multiple worksheet sales data by month
- VBA code to hide blank rows
- Can I use solver for this?
- vlookup
- I Need get work this formula
- Networkdays to open previous day's file
- Excel PERCENTRANK help
- SumProduct with optional conditions
- Conditional format when text contains using cell reference
- Pivot Table Calculations
- V_Lookup question!
- Using LARGE function with criteria
- This function returns incorrect value sporadically
- Find Function
- Analysing data imported from MS Money
- For Mr. RagDyer please
- skipp blank cell
- Lookup formula?
- Min Values minus 18 months
- if formula
- Percentage ranges within data range - help needed
- Using Autofilter to exclude dates
- Difference between 2 cells (growing column)
- Additional Columns past IV?
- Mann-Whitney U test
- Excel worksheet
- Another Cool Macro
- Another Cool Macro
- Activate second macro only after the first macro is run
- FORMULA, DAYS WORKED TO VACATION DAYS
- Data/Validate/List
- IF Formula Not Working
- Two "IF" functions in one cell
- Look for duplicates within a range
- IF function
- Rounding Numbers.
- IF with Search/Find???
- Need help creating a function
- Delete only specific fill colored rows?
- Need Formula
- Conditional Cell Lock
- Drop Down & V Lookup
- what is the role of *.
- Cumulative totals
- Security Warning Message Bar to update External Links in Excel 200
- What purpose is the INDIRECT function?
- How can Excell automatically fill in a default function for a colu
- Add a checkbox to a spreadsheet
- COUNT IF but not if 'X' IS NULL
- RE: Vacation Calculator
- Countif Range not working
- Re: data analysis/comparison
- RE: find a sequence
- Re: find a sequence
- Excel Page orientation
- RE: find a sequence
- Nested IF with >= and <= choices
- I need to add one more criteria to this function
- trying to use the index function when #N/A can be part of data ran
- How to check previous cells for same data and return Y/N
- Re: Lookup MIN Date
- Re: Email hyperlink
- What formula do i use?
- Hide all "except" the visible selected range(s)?
- Find & Replace
- Index/Match Amateur Question
- How do I one larger column into 3 subcolumns?
- Conditional Formatting in XL2007
- Hyperlink
- Restrict Data Values Allowed
- Copy a range of cells repeatedly
- Figure future date
- Can images be incorporated into a lookup formula?
- Automatically populating fields in excel
- Automatically Populating a Worksheet
- how to convert 112" to 9'4" with a formula in Excel
- Subject: how to convert 112" to 9'4" with a formula in Excel
- index match
- % of Subtotal In Pivot Table
- is this possible ?
- Notes and Coinage for Wages
- Re: averaging in a pivot table
- Re: Chart and date data
- Conditional Sum based on independent evaluation
- Need to add to nested IF
- How do I append 20 worksheets in single sheet.
- Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages
- Conditional Formatting Q
- Summation Operator
- Need help with formula
- Re: Hide all "except" the visible selected range(s)?
- Copying and adjusting formulas
- Copying and updating formulas
- Copying and updating formulas
- Copying and updating formulas
- SumProduct CountIF issue
- SUM COUNTIF problem
- Lock after entering
- how do i allign worksheet of excel to left.
- Using the if function in a formula,
- HELP - If and but's formulas?
- Need Help with Formula-urgent
- edate missing
- Complex formula
- edate missing - still stumped
- find and add vaules
- Lookup formula & an error to find the match
- Need help creating formula to sum tables
- how do i use vlookup and add all the results in pulls?
- compare and merge workbooks
- Autosum of various cells
- How to convert fractions from linear to diminuative in Excel?
- Total of a certain currency
- dynamic range and chart - big help!!
- Printout using MFC
- SUM function settings
- please try this
- Turn off auto sequence in fill down?
- is there a formula for rounding down time to nearest 1/2 hr
- INDEX OR INDIRECT
- Using lookup formula
- If I draw a shape in Excel (say a triangle), can I colour it?
- Summing a variable range
- Re: Hide all "except" the visible selected range(s)?
- Auto Lookup and Populate
- Excel Formula Help
- Setting a minimum currency value
- Duplicate Worksheet
- How to delete a 'return' symbol in cell for data thats been import
- conditional formatting
- Moving / sharing Macros between workstations
- Sumproduct range changing with deletions
- Proctected cell - Lost password
- adding an amount to each cell
- Problem calculating Using a Percentage
- Array formula
- Tracking inventory in excell or access
- using solver question
- How to pull in rows based on Column A data?
- Concatenate with leading zeros
- 2 VLookups
- Seperating information in a cell
- How can I password protect a particular column?
- Linking worksheets, but exceptions
- counting frequency using multiple ranges/criteria
- Lookup Multiple Values from a variable table size
- Hyperlink to a chart
- formula to add six months to date
- automatically show modified date?
- Simple Worksheet Protection
- how do i use symbol of degree in excell work sheet using key board
- SUMIF criteria
- Track Changes in Excel
- Merge & Sort Dynamic Lists w/ Data Validation
- smpte time code
- How to protect a cell with conditional format?
- Logical IF statements
- Replacing cell reference on multiple sheets in one go....
- How do I find out date of birth from an age?
- Copying formulas between sheets and keeping original ref
- how do i send an automated email from excel using an if statement
- Countif - shown blank cell
- How can I format a cell to have the same text with a number
- How do i find a sequence
- Dropdown box display only data dependent on another dropdown box?
- Formula using worksheet names 2
- OFFSET Formula Question
- How do I add (say 13) working days to an existing date?
- Extracting Data from another worksheet based on user input
- How do I place the word VOID across and Excel spreadsheet?
- Summing differences with multpile criteria
- FIND function does not return ZERO when text is not found
- Please help me with this function? I am struggling..
- Calculate flying times using 24hour clock and 0000 general format
- Picking a cell that is next to a cell
- Multi funtion worksheet
- VLookup
- How to make up an excel book that I can import other programs in
- Sorting a Pivot Table
- Formula to figure an average on a range of cells with an "if" form
- Compound Average Annual Growth Rate
- How can I make an excel doc 'un'-Shared?
- Multiple Fonts in Excel Equation
- How do I reference a cell to another in the preceding worksheet
- Create a drop-down list from a range of cell
- Copy custom footer across multiple sheets
- Fill Color If Statement
- show value of row one based on min of row two
- reference a closed filed from a cell and formula in an open file
- formula to drive plus or minus as operator
- Why would an Excel worksheet scroll at 45 degree angle?
- format color without conditoinal formating
- Validation question
- My rounding error in a simple IF
- Can Tab name in worksheet change automatically by referencing a ce
- YTD Average Formula to continue on new worksheet
- Fill Mon-Wed-Fri dates?
- Shift Differential TimeSheet Formulas
- Vlook Up
- Finding a value or the one next to it in a range NOT array
- Formulas showing as correct but not working
- update workbook
- Automaticcly insert rows
- return 4 lots of data when a corresponding number is entered
- Get vaçues in multiple sheets
- Sort of subsheet
- Re: Lookup or...?
- password protects different worksheets n upload on the web
- How do I create a formula to add to a cell value, up to a set maxi
- precentage formula
- Multiple Vlookup
- formula drag down when using filter in 2007
- Excel 2003
- sort when using VLOOKUP
- IF Statement
- Filtering totals - Reps per Province
- Cross-sheet formula and sort data
- Using two formulae
- SUMIF
- column subtotal
- How do I increase the font size when creating a drop down list?
- Counting numbers in an array
- Compare data from two worksheets and display difference into 3rd s
- convert yyyy-ww date to actual date
- copy down
- Formula Error
- adding function to an existing formula
- Rounding Up
- remove duplicate rows from specific data in a column; excel 2007
- Keep Dependent Value While Deleting Precedents
- How to keep a set range in a Search function
- Vlookup not returning correct value