- Can Sumproduct return Text values
- Calculating a percent decrease
- Networkdays two years
- Conditional Formatting
- Data Validation w/an If Statement
- How do I lookup from a table
- does a value exist in another workbook
- Cell formatting won't work
- converting text into years
- Average
- Goal Seek
- List of workbook tabs
- ~Time Calculation
- Need help giving a response a number value
- Need a program to make a work shift schedule that is staggerered
- Count Numbers
- How to extract specific text from a string of characters
- Excel 2003: Match Names; View Unfound Matches?
- auto extend formulas
- TODAY() function problem
- Round up
- Addition of 2 cells is not correct
- Nested IF & MAX Function
- AVG or Return 1 value from either of 2 cells if one is blank
- Data gathering and reporting
- Using = Named range
- Correct #N/A Value
- Subtotal by 2 different criteria
- Subtotal by Month and supplier
- Reverse Lookup question
- INA help
- Column and Row labels are numeric
- add color to a cell
- Cross matching .
- looking for the next value
- How do I autosum a filtered column
- Re-post as I still can't seem to get this to work 100%
- Compare cells in different worksheets
- find a value in a table based on 2 different criteria
- Count Unique Values
- Vlookup between two sheets
- if formula with variables
- Build a reference to another worksheet from cell values in currentsheet
- Templates
- db count if...
- Here again for help
- =Large function returns #NUM!
- Counting Member numbers?
- Index Match Problem
- Format Changes 2007
- shortcuts to formulas
- Combining 4 Conditions into 1 Formula!
- enter data simultaneously on multiple worksheets, but NOT same loc
- Adding entries if date entered in another column
- Calculating future values for assets & liabilities based on ror
- Check Boxes
- Formulas between worksheets
- Custom Number Format to abbreviate to Millions
- Import external data link disappears
- Need help with "Function to do what auto-filter does"
- multiple criteria count formula with duplicate data
- Sum multiple cells based on vlookup
- Is there a way to sum monthly or weekly reports into one report
- =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?
- =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes,
- Excel 2007 Freezes
- How do i delete a saved rectangle in excel?
- VLOOKUP DUPLICATE VALUES
- Index Question
- Help - sumif help on sales data between dates?
- What does the $ sign mean in spreadsheet calculations?
- Addiing Tex
- Remove link to formula source
- Calculate Filtered cells with satisfying toomany arguments..
- calculate filetred cells only
- HYPERLINK VALUES AND REMOVING MACROS
- How to return a cell reference as result of a formula
- HELP PLEASE!!! "Different kinda of function"
- what does ^ do in a formula when used in Excel
- Sum a column that contains if statement that reference cells with
- rearrange the data with a new table
- Functions (search within search result) reply to this please
- Functions (search within search result)
- WORKBOOK INDEXING
- SUM & OFFSET
- Conditional Formatting
- Wildcard search
- sum of cells in different rows & columns & criteria
- Using ISERROR with more than 2 cells of data
- XML Column to Multiple Columns
- Grouping in Pivot Tables
- Count Unknown Text
- Consolidating Data
- Need your help Shane
- Vlookup and If statement help
- Need help of you people
- need your help
- Need help of you people
- 2003: Having trouble with conditional formatting with custom user function (Repost)
- If statment help
- Excel 2007 Is it possible to vary the column width between rows?
- #VALUE!
- Conditional formatting
- Pivot Table Totals
- Count unique
- Custom list in a excel 2007 chart
- TO ROUND 37.75 UP TO 38 OR DOWN TO 37.5 FOR PAYROLL
- Hyperlink with a target - is it possible??
- Count Duplicates in text values
- Equity beta
- Does anyone have any suggesitons on how to do it for worksheet?
- Print Preview Spacing
- Conecting Drop down lists
- Simple INDEX MATCH Question
- Inserting new rows without inheriting protection from row above/be
- Combining INDIRECT
- 2 columns have same data:Sort column E, but column A changes as we
- Adjust the number of lines when pressing page down
- how to use if formula in list (data validation list)
- Using a wild card in SUMPRODUCT
- concatenate within an Index/Match formula, or is another approach needed?
- Convert 1.1B to 1,100,000.00
- How do I reference a "range" for a specific table_array in VLOOKUP
- IN MICROSOFT OFFICE 2007 WHERE IS THE FORMULA FOR DOLLAR SIGN
- To move automatically right or down at the push of tab or enter?
- AUTOSUM WON'T CALCULATE
- Find next good data in a column
- automatic display of last 2 entries in tHe column to specified cel
- to Don: display last entry to cell automatically
- numbering system
- display last entry into a cell automatically
- Copy Excel functions formula and auto refresh refresh
- Saving A One Off IF Result
- Variable Cell Reference
- Protect of Single Row or Column
- COUNTIF - Summing non-numerical items in cells
- Pick of random ID's
- Another Array Mystery
- Calculating Military Time
- Erisson FREE Laptop
- Copy corresponding cell if value is >0
- Count function
- auto copy total from one workbook to another workbook
- protecting certain cells in Ecxel 2007
- Will VLOOKUP and MATCH work to find combinations of pulley diamete
- formatting the Cell color directly in an IF formula
- How do I "insert copied cells"? used to be "alt i e" still work
- LOOKUP multiple entries, return last
- Text box does not populate linked cell
- Formula Help
- IF statement on a range of cells in Excel 2007
- find files from a dropdown list
- HELP WITH EXCEL FORMULA
- I WANT TO CREATE MANDATORY CELLS
- Date fomula not working
- XBRL Tool
- Filter - Excel 2003
- "how do I calculate age by using date of birth details"
- Ahmed Sayeed Khan
- Ahmed Sayeed Khan
- Ahmed Sayeed Khan
- Count Unique with Multiple Criteria
- function on date
- Re: Dynamic Cells
- choose from list to fill cell
- Dynamic Cells
- Choose from list to fill a cell
- Choode from list to fill a cell
- What is this function? { }
- Match function
- Choose from list to fill in a cell
- Conditional frmatting issue
- Choose from list to fill a cell
- How to remove the seconds on a mirror = cell coded in VB?
- How to remove the seconds on a VB mirror = cell
- Remove Duplicates
- Using cell's contents as an index to a row ... ?
- Using cell's contents as an index to a row ...?
- Using cell's contents as an index to a row ... ?
- Formula Working With Positives and Negatives
- Averageifs & median
- AVERAGE of AVERAGEIFS problem
- IF Statement Modifications
- Cell Reference
- formula to count sets of repeating numbers
- Need a formula for time conversion
- How to eliminate everything but duplicates
- Row Title
- Arrays and Averages
- Calculating Cost Per Minute
- Formula to lookup item for Qty?
- test MS web interface to ngs
- decimal numbers to word
- decimal numbers to word
- SUM, IF, AND, OR array
- SUM, IF, AND, OR array
- SUM, IF, OR, AND array
- Print changeing one cell on form
- arrays and averages
- arrays and avgs
- inverse of the column function? i.e. input a number, output thecorresponding column text label
- Sumproduct Help
- Arrays, averages
- Avg Arrays
- Problem calculating
- Arrays and Average
- Vlookups to return a N/A value
- $30 Pass4Sure to pass microsoft certification exams.
- Lettering rows
- Filtering on upper/lowercase letters
- Filtering/sorting on upper/lowercase
- Filtering/sorting question
- If Statement
- sequential numbering
- Populate Cell Date Value with Active X Calendar Control
- not sure if this is possible
- Need urgent help selecting correct test!!
- If Then And Statement
- Not even sure this is possible.
- Hope to change order of vertical cells when pasting
- on opening an existing file I get blank blue screen
- Nested If with Lookup
- Parsing Column of Numbers into 5 separate columns
- .NET RTD on Excel 2007 & Vista
- posting problem
- Vlookup & "space" vlookup
- Quick question...
- Counting two columns with specific criteria
- Date filter in weeks.
- IF Formula
- Dependent Validation
- How do I display text when a cell value is 0 for accounting?
- How do I display text when a cell value is 0 for accounting?
- How do I display text when a cell value is 0 for accounting?
- How do I display text when a cell value is 0 for accounting?
- Calculating Variances using formulas
- CF
- Change 4 to Wiri
- remove characters on both sides
- lookup based on date range
- Lookup based on a date being between a range
- sorting question
- inter-dependency
- Applying change to selected cells
- Removing a picture box from an Excel 2007 spreadsheet
- concatenating
- multiple selection....
- Continuous calculation of a formula.
- Date Array Problem
- Arrays/vlookup???
- date range table array formula
- running total of actual cost
- running total of actual cost
- Running total of Actual cost
- running total for costs
- Running total for actual cost
- Running Total for costs
- How to format Text by function
- Dependent Validation
- Dependent Validation
- Simple formula question
- Need to add rows to entire wksht that includes a pivot table
- count a word recurrent in many cells
- count how many rows a word appears in
- percentage formula
- formatting numbers as 1st 2nd
- Sum of items in a column if they meet two criteria in another colu
- Need help not excel smart
- interpolation within subranges
- need help w/ formula not very excel smart
- Comment box
- Auto insert a comment box.
- Auto Insert Comment box in Excel
- Need help comparing data in two columns
- Auto Insert Comment box in Excel
- Creating Templates
- no leading zero for minutes and seconds
- Returning Bottom 10 Percent in another spreadsheet
- Returning Bottom 10 Percent in another spreadsheet
- Return a given value if the value of a cell is in a given range
- Please help me add something to this macro
- Need help on this macro
- Locating duplicates within range of time punch data
- zeros
- if Then
- A formula to discount percentage
- Filter Multiple Columns on Multiple Criteria and count the last co
- Continuous calculation of a formula.
- Continuous calculation of a formula
- Help
- Copying first three characters of text in a cell
- Sorting & sub-totaling data on an excel spreadsheet
- Based on Mulipple Criteria acrossed Column count last column
- Calculating payroll $$
- Calculating payroll cost
- Use formula result as the formula for another cell.
- Select which formula to use in a cell.
- Cell format will not update
- I need calculated time in a "real number" format
- Custom list in a excel 2007 chart
- hidden rows reappearing when using filter
- hidden rows reappearing when using filter
- Excel 2007 single cell selecting muliple cell
- Calling the contents of a random cell
- How to remove PivotTable format.
- unique values with multiple criteria
- VLOOKUP Reading Wrong Record
- Getting rid of PivotTable format
- Formatting cells for letters and numbers
- Question for Math whizzes
- Formatting cells for text and numbers
- Ignore Blanks in Countifs statement
- unique record count with multiple criteria
- Indirect alternatives
- Formatting cells for text and numbers
- Automatic entering of information from another worksheet if given
- Auto Lettering Rows
- Auto Lettering
- Auto Lettering
- Returning 2nd smallest value in a range
- Finding 2nd smallest number in range
- Using Small to return 2nd smallest value
- Using function on column?
- Using function on column?
- How can I use an if formula that works on a cell with column?
- How do I change the size of one cell or groups of cells?
- How do I change the sizes of individual cells not whole sheet?
- potential duplicate max values
- Specific custom list in excel 2007 chart
- Specific custom list in a excel 2007 chart
- Specific custom list in a excel 2007 chart
- How to force the use of a specific custom list in a excel 2007 cha
- How to force the use of a specific custom list in a excel 2007 cha
- Counting multiple criteria across columns and rows???
- Counting multiple criteria across columns and rows???
- To Refer particular Month in large datas
- Transpose columns to rows using first columns repeated.
- Formula that will increase an integer added to a value based on..
- Formula that will increase an integer added to a value based on..
- Compare two datasets and extract unique records from each
- How to code macro for worksheet?
- arithmetic on minutes and seconds without leading zero
- radius formula
- return a value
- Shortcut key for Excel 2003 SP3
- Pick Ref# randomly on an average
- Find Function
- Find cell entry contained anywhere within a text string
- Find a number on another worksheet
- msg box for eache value
- VBA isn't subtracting properly
- Swapping two word and placing them in another cell
- Swapping two words in one cell
- Swapping two words in a cell and placing them in another cell
- Swapping two words around in teh one cell
- Shortcut Key Creation
- Splitting the Year from Dates
- Splitting Year from Dates
- Transferring data from multiple sheets in workbook to one sheet
- How do I disable the date & time functions?
- How do I disable the date & time functions?
- Transferring data from multiple sheets in workbook to one sheet
- Lookup value in col D when Col A & B are listed multiple times
- Conditional Formula
- Problem with date - can't enter 15th!
- Conditional Formula
- Negative Numbers
- Return a list based on +/- of a cell value
- Return a list based on +/- of a cell value
- Return a list based on +/- of a cell value
- Return a list based on a +/- of a cell value
- Return a list based on +/- of a cell value
- How to force the use of a specific custom list in a excel 2007 cha
- vlookups
- vlookup & summing
- Two Matches, then Sumproduct of Values
- Transferring data from multiple sheets in workbook to one sheet
- Creating drop downs for multiple cells
- "Send To" Function in File Menu
- typing (c) in excell
- Can three separate sections of rows be sorted in the same order?
- Data Validation and Sort
- Creating a list of Excel formulas
- color fill
- Data Validation Date Format
- SUMPRODUCT help
- IF and ISBLANK Functions
- Why can't I link to a cell that contains a date or a time?
- XL VBA function needed for a list of items
- How to get a linked workbook to return a blank value?
- Apologies for multiple posts
- extracting text between two keywords
- extracting text between two keywords
- extracting text between two keywords
- Extract text within two specific values within a cell
- Text Entry
- monthly capturing of information
- IF and ISBLNAK functions
- Need help witha forumla?
- Setting Up a Series of Formulas
- SUMPRODUCT using a list?
- IF and ISBLANK functions
- IF and ISBLANK functions
- Lookup Formula
- RE: Lookup Formula
- RE: Lookup Formula
- Using cell referencces as values in MDX formulas - cubemember
- Array Formula Help
- Array Formula Assistance
- Test
- Dropdown entry by Keyboard
- Extra string before a specific character
- How to force the use of a specific custom list in a excel 2007 cha
- How to force the use of a specific custom list in a excel 2007 cha
- Prevent Duplicate Records
- Counting sales
- Prevent Duplicate Records
- Finding e-mails
- Finding E-mails in different columns and trying to put them in one
- Forcing to recalculate
- Cell Function Protection
- Multiple Row and Column Criteria
- Sumproduct across multiple rows and columns??
- Multiple Criteria across multiple Columns
- Criteria across multiple columns and rows
- Specify columns to add for months MTD Diff
- Specify MTD Diff by month's columns
- specify which month's columns to use in mtd calculation
- Specify a column by the month to calculate it's data
- Formula needed to generate report!
- Need assistance with calculation for leave loading
- Drop Down Plus Match, I think!
- References
- PMT function
- sum if function
- vlookup
- vlookup
- Need formula to change cells from negative numbers to a zero.
- Merging data from 2 worksheets
- sum product with criteria from 2 wkshts
- 1hyperlinks and macros
- sumproduct using criteria from 2 worksheets
- sumproduct using criteria from multiple columns in a separate wksh
- getpivotdata custom subtotal cell reference
- Help with Vlookup Match and IF statement
- getpivotdata custom subtotal
- Help with IF and VLookup Match Statement
- Help with If and Vlookup Statement
- Difference between NOW() and TODAY()
- by using the if statement:have all like numbers marked in column
- getpivotdata custom subtotal
- cell value instead of formula?
- Array Formula Help
- HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl
- Array Formula help
- Array Formula Help
- count day's
- Data Aligning with out cutting and pasting
- Converting a time calculation to a value to do math with
- Converting a time calculation to a value to do math with
- Excel 2007 using arrow keys
- Matching two values
- Match two values
- Counting Formula Needed
- Sorting Columns/Rows Automatically
- d
- format a cell when I type 10 it will multiply 10 by .585
- Dropdown selection by keyboard
- Dropdown selection by keyboard
- Sorting Columns/Rows Automatically
- dropdown entry with keyboard
- Linking Date range to cell Formatting
- Help needed urgently..:(
- countifs with multiple dates
- Sorting Rows/Columns Automatically
- Seperating and extracting text from parentheses
- Seperating and extracting text from parentheses
- Sorting Rows/Columns Automatically
- Seperating and extracting text from parentheses
- Seperating and extracting text from parentheses
- Sorting Rows/Columns Automatically
- Sorting Rows/Columns Automatically
- Sorting Several Columns/Rows Automatically
- Worksheet to another Worksheet
- compare two columns in same worksheet for similarities
- needed formula
- counting multiple dates in a range
- formula needed
- forula needed
- Difference between NOW() and TODAY()
- perfoming calculation on randon cells
- Using SUM with INDIRECT function
- COPY / APPEND`
- Rename tab to cell contents
- formula to look up employee name and return reoccuring net pay
- formula to lookup employee name and return data from multiple rows
- Countif
- Change the color of Selected Row, column or cells
- Referencing a cell in another worksheet within the same workbook
- Referencing a cell in another worksheet within the same workbook
- Unable to obtain relative reference using conditional formatting
- Unable to obtain relative reference using conditional formatting
- Averaging
- Ooops - My Bad.
- Write data from one cell to another cell
- Write data from one cell to another cell
- Write data from one cell to another cell
- Adding Two Columns
- Formula to set color in a cell
- Continuos addition of two columns
- Creating an auto-adding set of columns
- countif
- Units Produced / (finish time minus start time)=Units Per Hr
- Moving Data between sheets in the same workbook and moving data between Workbooks.
- printing page # on sheets
- Spreadsheet Corruption?
- Is there an Excel formula to show the highest letter in a row?
- writing text to different cell after comparing
- How to lock a photo in a cell
- Using IF
- Using IF to compare multiple cells to one another
- Vendor Lookup
- Test of Multiple Conditions in an IF statement
- How do I format a cell based on the contents of a different cell?
- Calculating Hours
- searching between dates
- if cell blank color "red"
- Trouble constructing IF statement
- Pivot table formulas
- Testing for conditions with IF statement and AND function
- Nested IF statements using AND / OR
- not sure what formula to use? IF???
- Not sure what formula to use? If??
- Countif? or IF statement??
- making numerical date return mmmm format
- inserting [ ] around text in a cell
- & if
- Summing only numbers, not formulas
- Pivot Chart Dual Category Axis not Preserving Formatting
- IF Function
- IF Function
- In VBA Name a Table with Relative refer.
- How can I determine the modification date of a cell?
- Excel Biweekly SS with Weekly Overtime totals
- Can you copy formulas only across a large sheet, under data?
- turn a cel a color based o todays date
- Arabic Numbers
- VBA not working - Messy.
- IF (I think!)
- IF (I think!)
- IF (I think!)
- how do I lock the fill color in a cell
- How do I create colums within a colum
- vlookup by date
- Delete cells with 0 as the tenth digit
- Sort Not Working on Column of Numbers
- How to Copy Excel Workbook - Hyperlinks - Folder of Photos - to CD
- How to Copy Excel Workbook - Hyperlinks - Folder of Photos - to CD
- Code modification help
- formulas
- Formulas help
- Duplicates
- vlookup
- vlook up and return formula
- VLOOKUP and return formula
- Eliminate Blank Columns
- List Box - Scroll Wheel on mouse crashes spreadsheet
- Percentage
- Percentile formula
- SUMPRODUCT Formula Error, please help... ;o(
- Greatest Number
- Add a unique (sequential) number to "usuername"
- Add a unique (sequential) number at the end of usersnames
- Add a unique (sequential) number at the end of usersnames
- Looking to add unique (sequential) number to already generated Use
- Lotus Notes - Unable to Copy Paste Special in macro
- Hep with Conditionals actions please.
- how do I lock the fill color in a cell
- inserted lines move how to place lines in proper cell?
- Formula Help please
- advanced filter - blanks
- HYPERLINK AND VLOOKUP help
- need macro from button to open selectable file
- copying conditon formats with $
- Condition formats have $ sign problem copying
- Problems with embedded merged
- VLOOKUP help
- Code/Function to Look at Previous Entry to Validate Data
- how to I make the tabs at the bottom of excel larger (large font)
- Excel 2002
- Incorrect Date function
- EXCEL
- What number appears the most with a certain number
- Frequency
- What number appears the most?
- How to auto sum cells if letters are in cells?
- Locking cells
- Format cells with 0 as the tenth digit
- count with multiple critirea
- count with multiple critirea
- count with multiple critirea
- Time Zone, how to default to PT Time
- Data Validation with 2 criteria
- convert day of year to numeric value format year+day in 4 digits
- Countif(and
- How do I place a picture instead of words in a hidden comment box
- Lookup value based on 2 cell values
- Trade Distributor and Store Merchandise Wanted
- Test 2 numbers
- nice shopping plaza
- Excel 2007 vs 2003 menus.
- How to get the number from text?
- Find the UPPERCASE letter in a string
- Vlookup question
- Referenced cell change when row is blank
- RE: Referenced cell change when row is blank
- RE: How to get the number from text?
- RE: Vlookup question
- Creating a formula
- The If function
- Formula Help
- Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
- Can i make text in cells c60@n60 bold & black if sum of C59 is gre
- userform date issue
- How do I use countif like sumif ie (range,criteria,count_range)
- SUMIF function
- aging category calculation for open purchase order report in Excel
- Question on which function to use
- sum function
- Compare and then copy cell to separate worksheet
- My current formulas in documents have quit working
- dividng numbers using the sumif function
- Count Unique Numbers if Names Match
- Fill Macro II
- Copying data across a workbook -- Office 2003 vs 2007
- Partially refreshing spreadsheet
- Function to find truncated entries?
- Conditional formatting comparing times
- SUMIF FUNCTION works in all cells but those related to one account
- Getting rid of VLOOKUP N/A
- How can I write mm square, with 2 show up on top of mm.?
- VB Code
- "go to" "blanks" after using a formula
- Date functions and #value!
- how do i compare two text columns
- EXcel problem
- Copying a Range of Cells having data only
- getting excel to recognise copied data as mm:ss not hh:mm
- Is it possible to offset a worksheet reference?
- Find and replace dilemma
- Count one character in a string across a range of cells?
- Sorting amounts in columns by due dates
- Validating Date Format
- Fill down without formatting macro
- Calculating ratios: Is there a formula that can do this?
- Copy non merged to merged cells again
- Conditional Formatting on #VALUE!
- Conditionl format for 3 cells Skipping the center cell
- Error message
- Formula please
- Recognize Color and Insert Symbol
- IF TODAY()<
- Sumproduct Help
- Help with time conversions
- How to change picture
- Hard return in concatenate
- Cell reads "Value" without an entry
- Count No of days past due
- conditional formula
- Newbie
- newbie
- How do I set up 12 month financial report for church in Outlook
- How to reference Worksheets in VBA properly
- List Box - Multi Select Issue
- Vlookup Multiple Matches
- process order with IF statement
- finding multiple code dates for multiple item number
- Hyperlink changed???
- Worksheet Tabs
- subtracting dates leaves date/number or date
- conditional Formatting based on a value in another cell
- RE: subtracting dates leaves date/number or date
- 'Disable' Field?
- formula error- ("Nesting more than 7 functions"- Feb4)
- Hyperlinks in Excel 2007
- Count the number of cells that conatin a "." in a range
- Conditional Formatting: Referencing from a different cell
- Vendor Name Lookup
- copying a cell that has been formatted to cell with conditionals
- Pivot Table Chart Drop Down Box
- Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered
- countif function
- Excel 2007 - Issue moving a row of data (cut and insert)
- how do i default a footer in all the excel files i open
- COUNTIF with multiple criteria
- Charts don't copy with new sheet
- Find and Replace with formated data
- Copy non merged to merged cells
- Copy paste non merged to merged cells
- Again printing with hidden rows
- Return Blank Cell in case of false If
- How to format text 'exactly' as entered.
- Print with hidden rows
- x = 1 or a value
- DIV/0 error
- Count No of Types.
- Conditionl format for 1 cellthat looks at 3 cells.
- serial numbers
- count days from a one date to another date
- RE: count days from a one date to another date
- Image Named Range
- difference of date/time only calculating workingdays/hours
- Sum of Numbers
- Data Validation - copy paste !
- Match function
- RE: Match function
- Tricky Excel De-Dupe Problem
- formatting cells for time
- Worksheet went grey!
- Morefunc stopped working
- Time Stamp
- Sorting problem
- RE: Sorting problem
- Syntax question
- Returning Multiple values
- Find a cell's content in another cell but only as whole word(s)
- Vlookup issue
- activate cell
- Split a cell diagonally and apply a different conditional format.
- Date in cell + 77 days
- Re: Date in cell + 77 days
- Locate changed cells with Worksheet_Calculate()
- I need to add an IF condition to a formula
- pulling info from internet
- link cell to open a worksheet
- sum all rows with multiple matching criteria
- Are contents of at least one cell in a group a substring of a dif
- Nested, Conditional, IF formula - fomatting disappears
- Array formula works on first row only
- Consolidate Rows
- formula 2 display selected objects ONLY in new sheet from another
- Excel Sheet Size
- combining worksheets into one sheet
- RE: combining worksheets into one sheet
- Format a Concatenated cell
- Option Buttons, Forms Control, Excel 2007 - 3 options
- Calculating costs
- enter 45, display 45 kilos
- How do I close the footer feature in excel 2007 once entered
- IF function
- nesting more than 7 functions?
- Drilling down pivot data to classes
- show last used cell in a column at the bottom of column.
- Pivot Table Drop Down Box Disappears in Chart
- Running code on workdays
- Separate MAX for different formats
- Removing minutes from hours:minutes in Excel
- List activation on Excel
- Conditional format color is set correct, yet color will not change
- Excel formulas pulling from another worksheet changes when sorted
- Need formula to list words
- Multiple entries from a list
- Count Unique Records
- Conditional formatting by results in two different cells
- IS IT POSSIBLE IN EXCEL WITHOUT WRITING CODE.
- Simple Math Question
- calculated celles according to more then 1 condition
- Use SUMIF, VLOOKUP, HLOOKUP, LOOKUP, AND ??
- #NAME?
- If then, If then, If then.....
- vlookup not updating from external workbook
- Making Blank Cells
- How do you insert a calculated field within a pivot table
- When I open a workbook, cell protection is not fully active
- Will sumproduct work?
- Modifying If Statement
- Making a Cell Go Blank
- Excluding Negative Numbers
- If logic for text
- validate data using formulae
- Multiplying Empty Cells
- Rows to Colums for Mail Merge
- Counting rows that contain any one item listed in another row
- Coonditional formatting
- Inexperienced Use Need Help
- A staying on schedule formula:
- extracting data from one sheet based on data in another - VLookup?
- Delete rows with date more than 48 hours with a condition..
- Getting rid of +/- in date subtraction..
- Subtracting Dates with Empty Cells
- finding text and performing a calculation
- Convert to hyperlink
- IF Function
- SUMIF and AND/OR/NOT
- Help with MID Function?
- Excel function =if(istext(c25:c31),text," "). What is wrong?
- Filler color
- Adding, multiple datasets to include all combinations
- Combining data from multiple worksheets into master worksheet
- Looking for "Select where in" type function
- Group data and maintain grouped data on dedicated pages
- Sumproduct Lookup with multiple critera?
- Extract numeric characters plus one character...
- Linked Cells – If Statement
- I need to set pointer to change a cell(s)with 1 click
- Greater Than 24 But Less Than 48 - If Statement
- Data validation
- Workdays
- How Do I Query a Named Range
- conditional formulas with 12 conditions
- Sorting
- Character search and replace
- Excel Formula Question
- strange time value
- update columns
- help with spreadsheet
- Countif statement using dates
- Protect or Hide all worksheets in a workbook except 1
- How to I set a limit on the value returned by a cell
- Lookup function in Excel
- Copy of a Worksheet Does Not Update Chart References
- work sheet
- calculating a value if adjacent cell has value
- Unknown Formula Error
- Index & Match Question
- if condition and locking cells
- Worksheet Calculations not working
- Excel formular to Count values in cells of rows that meet criteria
- Absolute Reference not working
- APR formula for irregular transactions
- Can i run 2 IF statements in one formula?
- Gas Temperature correction factors in an excel spreadsheet.
- Followup to "worksheet function"
- Average Over Multiple Sheet Tabs with Multiple Values
- VLOOKUP
- Query on Null (#n/a)
- Creating calendar that autopopulates dates based on event date ent
- Formula Help
- Count with 1 variable & 1 constant criteria formula
- Data Validation (copy paste error)
- Count subset-totals in column
- Looking up a row of data
- Subtracting 24hr clocks?
- Display contents of adjacent cells
- Help converting text to date & time?
- matching text to text in excel
- Excel 2007 problem nesting If & And
- Excel 2007 problem nesting IF & AND
- Formula - assign a cell to show the next
- Pulling out values
- How can I show a validity by a prompted symbol in colour?
- copying data to summary sheet
- cumprinc, not sure how to use it, someone please show me steps ple
- sumif and complex sum_range formulae
- Duplicates and unique values
- Copying data to summary sheet
- V Lookup & IF
- V Lookup & IF
- copy & paste
- Fill series of dates across worksheets in excel
- Double (triple?) Index Lookup
- how do you find many data?
- How do you insert & delete rows in a protected worksheet?
- Rank using two different categories within a multiple time period
- IF Statments in Excel
- names and drop down lists
- show all characters in a cell
- Hyperlink "friendly-name" won't preserve links in PDF publishing
- removing the "-" sign in a calucation
- round up
- How do I find dups across different columns
- Average
- PASTE SPECIAL
- Please explain this formula
- Subtotal
- Help with creating a function
- convert text to hyperlink
- Not sure whether to use VLOOKUP or an IF statement
- how can i use countif to count sundays in excel
- time calculation
- Different answers when using cell references as opposed to actual
- can I define validation range by function?
- to separate date and time formula
- how do I click on a drop down list and go to that data
- formula to add year to date figures
- Date Conversion
- WorkBook Update
- Multi IF function not working
- Can anyone explain why my excel file won't scroll downwards?
- Command Button
- #DIV/0! error using Avgerage
- COUNT COMMON DATA
- Excel 2003 using a list from another workbook
- Duplicate entries
- Yes or No Value if Dollar amount between two numbers
- how to Calculate the discount ex. 9-63%=3.33 in excell
- Conditional Formatting based on a vertical Array.
- worksheet function...
- IF statements help
- Calculate AVERAGe with #MISSING!
- Triggering a Flag after 10 days that excludes weekends and holiday
- Numbering after using autofilter
- Numbering cells that have been filtered
- coditional Page Break
- Help with IF Statemet
- How do I auto highlight a cell with the same data as another cell
- VLOOKUP, MATCH or something else entirely?
- default font color in excel
- Changing the colour of a range of cells, some with formulas.
- Transfer certain data from Sheet 1 to sheet 2
- Running totals when letters entered. IF statement
- In excel, how do we pull the first letter from words in a sentence
- Quartiles
- IF FUNCTION?
- Conditional Format
- sumif from multiple columns
- textbox autosum
- How to Create Spreadsheet w/Dates
- countif
- Reference
- Referencing entire column of data from another sheet.
- Having a value automatically change color
- FORMULA FOR TABLE
- Request for formula
- Format changes in a merged cell
- Drop Down Menu
- 2 Different Font Colors in 1 Cell
- How do I select a range?
- AutoRun Macro
- array search
- capping percents
- Data Valadation
- Excel 2007
- Autosum - Sigma or Epsilon
- Function Arguments dialog vanishes when clicked an inserted shape
- Sumif problem with zero value and blank cells
- Percentage is wrong
- how to enter numbers on a cell
- Count hyperlinks in a mixed range
- The sum of multiple returns on a vlookup
- what formula do I use
- count spacing violations between values in column
- Excel Tracking Changes
- Use of Check Boxes
- Tool to automatically install a macro + button on 200+ instances ofexcel?
- sorting and adding totals
- Is there a function like Vlookup that works with cell colors?
- Calculating Previous Pay Dates
- Linking Worksheet to Database?
- Pivot Table Filters
- Calciation
- Formula Needed
- correlation between two data sets
- tricky if statement
- building comments from text cells
- Referencing data next to a date
- Excel- Conditional Formatting
- SUMIF result including values not specified in sum-range
- Today() function
- Excel worksheet first column - the row indicator column
- Can't change Pivot Table data source
- Issue with VLOOKUP
- Sorting the cells of a formula causes the formula to not work
- SUMPRODUCT OR COUNTIF
- Problems with Ctrl-D
- add two criteria that should not be met to sumproduct
- COUNTIF/SUMPRODUCT??
- The difference = Question
- Lookup problem
- Excel Crashes when typing "False" in VLookup formula
- need answer- copy between workbooks
- Function error
- How to change "xxx CR" and "y,yyy DB" to "+xxx" and "-yyyy"
- Count
- HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S?
- how do i sum a column ignoring cells strikedthrough
- VBA Autofilter Arrays
- Deleting the text without deleting the formula
- Whether VLOOKUP can find Text
- Return a 3 digit number
- IF Statement JER
- SUMIF no longer working
- need help with sum formula
- Match Function
- Possible to auto-fill in gaps between numbers on straight line bas
- Can I have a cell change to red/green if not equal to:
- Formula Question - please help
- Help with Formula
- Prompting users with a message box on certain cells
- IF/OR Logic Function
- Wild card * in Array
- Sum + IF Array wrong sum
- Inserting comment in unlocked cell of protected Excel worksheet?
- excel sum function
- Problem - lookup formula
- Preventing user input for individual cells
- Looking for a formula
- How can I obtain the average of the middle quartile of an array?
- Can I use a 'calculated' array in a function?
- DAVERAGE