- IF, THEN HELP
- Format a dollar amount to text
- Help with lookup
- using GETPIVOTDATA feature and need to keep formatting
- negative value
- Re: Copy is criteria met
- Combine an And OR function
- Re: Copy is criteria met
- dates on worksheets
- When I search on my name "Meenie" I don't get 2010 posts
- need formula to add two different criteria in a range
- Copy is criteria met
- sumif formula
- result given from content of selected cells.
- Dragging values down a range using a colum to determine its length
- How does one put a watermark in an Excel worksheet?
- Imperial Weights in Excel
- Counting Characters In A String
- if statement, change cell only if true
- Build 'show 0 as -' into existing formula
- Advanced Data Filter
- Adding data from multiple cell and linking to a new worksheet
- Slope??? help please!!!
- Adding Fractions and Displaying as a percentage.
- Vlookup - Returning 2nd match
- Record time by formula
- formula help
- adding time in a work schedule
- HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
- Which (logical) function?
- Sorting a portion of a worksheet
- Running calculation of a frequency
- Excel Workbook with Multiple worksheets
- Reverse $String1, String2 to $String2 $String1?
- splitting cell content from 1st column into 4 columns
- Find duplicate emails within a single Excel column
- Average formula where blank cells are counted as zeros
- taking numbers in vertical cells putting them in horizontal cells
- Formula Help
- Average IFS (Multiple Criteria)
- Average IFS (Multiple Criteria)
- Possible to have various sections of worksheets print on 1 page?
- Average IFS (Multiple Criteria)
- Pull info from one excel file to another depending on values of O.
- Index Match Problem
- Pivot Table Comparison
- How to remove a bunch of zero's
- How do I get warpped data to auto fit in merged cells?
- Default Cell Values at Change
- date from sheet name
- Deleting/Clearing duplicate range of cells
- Using wildcard characters in find & replace
- HOW DO I COLLECT TEXT DATA FROM A COLUMN
- Keeping the format but update the data
- Calculate Accrued Time
- SUMIF Help
- If column A = B then pick up value in D.
- Using cell reference with logical operator in DGET expression
- Establishing a Time Window
- Increase PF Usage
- SUMPRODUCT with conditions
- Help with Vlookup
- To deal with #NA
- How to find the custom xml tags in a workbook
- Drop Down Menu AutoPopulate Contact Info?
- Average Unique
- Average If...
- How do I set a constant multiplier in an equation?
- How can I merge unprotected cells in a protected worksheet?
- if function help
- How do I delete a calendar function from a spreadsheet
- compound if equation?
- FDIST Function
- Removing items on Sheet1 that are common to Sheet2
- FAO Mike H - Formula Answer provided
- How to use autofilter in excel with formula reference changing
- "Can not empty the clipboard"
- Need solution for wildcard use in array
- Formula to fill one cell from another
- Correlation tool says Input range must be contiguous reference.
- How to?
- MSN Stock Quote
- Significant digit causing wrong value?
- Using VBA to find a value and select a range
- Formula help
- Worksheet relative reference
- Counting dates within a range
- Missing values from a pivot table field
- add two cells from seperate work sheets into a cell on seperate wo
- is it possible to insert a pdf document into a excel worksheet
- Ctrl V paste coding was lost
- Date formula needed
- Identifying the top five values in multiple groups
- how do I double check that there are no formulas
- Calendar
- error alert for invalid date
- Cell Formatting of a Conditional Statement
- Modify general format to date format.
- Index using a defined name array
- Nested IF & AND functions
- Suppress First Page Numbering
- What is the formula to Round an average to the nearest 100
- Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible
- excel: How to set up a formula for a range of numbers ie. 3.5-5..
- Can Excel trigger Outlook reminder?
- Formula Help
- Formula addition causes random #REF!
- Fill/Extend Series adding decimal points to some numbers
- colating data from a table - for bespoke report
- Is there a function to solve for an unknown in an equation?
- what should be simple
- question related to merging multiple statements
- Date + relative number reference
- Help Needed with Dynamic CountIF
- Referencing relative to a formula reference
- limit comments to only 600 words
- Excel Formulas
- IF function
- Finding matches in two columns
- Show matching data in several worksheets
- Find second to last value in cell
- Referencing formula using Indirect
- SUMPRODUCT
- how do I copy the last 20 entries in an expanding list
- Head scratchin for hours.... Help with a formula please...
- Drill down via page fields
- Satisfying two conditions?
- Format Data Labels
- INDIRECT reference or ?
- Excel formula help needed!
- Reference: forum discussion dated 17-18April2010
- List the UNIQUE certain fields from the database
- Count the frequency for every change in numbers
- Formulas not updating
- Cells Are Not Updating
- Daily totals from a monthly log
- Links not working in Excel 2007
- Creating a formula
- problem with lookup function
- How do I use a percentage formula?
- Locking Worksheet Security Name
- Pre-Populating Fields
- Word lists
- Dynamic DropDown list from Unsorted vector
- Calculate number of days
- COUNTIF Formula
- Change a cells value with a function
- Need a code
- Shared Excel File
- VLookup between date ranges ?
- Excel Formula for years and months
- ODBC Query
- Despite formula I use (for example SUM) result is always zero.
- VLOOKUP and IF together
- How to select other random cells
- Can not copy a sheet to another book
- Formulas do not update
- Lookup
- Automatically hide/unhide rows
- Help me (Vlookup)
- how can i transfer data from one sheet to another without blank li
- Count first and last characters
- Import underscore in coding every after 2 digits
- How to Sum infinite formula
- GETPIVOTDATA and (blank)
- 11 months and 1 day from a given date
- how to remove all formatting
- Copying Cells with Fill Handle
- background colour of sheet gone gray need to change to whit
- "#VALUE!" Cell Value
- Conditional Formatting in Excel 2007
- How do I use sumifs -
- Sumproduct with 4 variables
- Counting by color
- why this strange result with vlookup
- Percentages in Pivotal
- looking for a function that will populate opening a worksheet or t
- Grouping on protected worksheets
- When refreshed, some Pivot Table columns retain formatting, some d
- multiple IF calculations
- Excel - How to get tab to go to next unlocked cell across columns
- Default Cell value in changing environment
- identify the numbers cancelling by amounts
- Centreing Text In Excel Cells
- copy paste value
- I want to compare two coloumn particular text, then count total
- More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
- vlookup with two recors
- Reference different lines in the same cell
- Which formula combination will solve my anticipation
- How do I search for the second largest value in the array?
- combine multiple spreadsheets into one workbook
- Installing service reminder popup windows in excel
- How do I get the formula icon back on my toolbar?
- Conditional Formula Words
- logical (if a1=specific word, can c1 = value entered in a2?)
- Excel 2003 make 1 date cell automatically change another date cell
- Keep lines when one column equals certain criteria
- how do i create a repeating student certificate using excel
- Text to values
- How do i set up a concecutive numbers in Microsoft excel sheet?
- GETPIVOTDATA and Date-type field (Excel 2007)
- Categorizing Data Question
- Rounding Seconds in 4/21/2010 4:30:23 PM
- Conditional more than one iif
- How do I update links from .xls sheets to .xlms sheets
- Logic Formula using colors in the formula?
- Formatting question with Round
- COUNTIF: everything in a row larger than zero over multiple worksh
- Vlookup + sumif , but how????
- Display formula Excel uses for internal functions (STDEV...)
- Conditional format will not work without $ (removed to allow copyi
- Conditional Formatting Question with 'OR'
- Reorder $String1, $String2 to $String1 $String2?
- Excel 2007 Page Break Adjustments causes a page break each cell
- Excel 2007 on Vista
- Combine two sets of overlapping Date/Time data into 3 columns.
- Help with Date Function
- VLOOKUP in VBA
- Search Macro
- Counting values in an array where value in one column is not null
- Count values in array of data where no blanks in one column
- Pulling/Collating Data from Workbooks
- Range Vlookup
- Return cell characters after space
- multiply value based on quantity
- Convert times to text string
- Looking For Sales Projections Run-Off Formula
- comparing more then one column with numbers and letters
- combining columns and using concatenate
- Filter
- excel - horizont line above font X
- Open multiple spreadsheets and pull data
- How to hide infromation in Excel?
- If then
- Text to Date
- Total a column (or row0 by highlighting cells
- Lookup value that falls between two values in a range and then som
- pulling a list of hyperlinks from a worksheet
- transfer cell value from 1 sheet to another without copy/paste?
- Calculating daily totals from multiple worksheets (Excel 2003)
- Count If.....help
- Automatic update to SUM formula cell references.
- Vlookup issue
- IF and Right Functions
- Sum Function Visible Cells only
- Avg % above 0%
- Changing the range for averages with out changing the formula.
- Functions / Drop Downs won't calculate
- Show zero values in specific area
- Saving & Removing VB Code from WB
- worksheet
- Reconciling Invoice & Credit
- Conditional formula
- Getting the average from a column using date constrants
- Counting consecutive negative value
- Excel corrupts when asking to update vlookups
- Formula Excel
- conditional formula needed
- COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
- how do I drag and fill hyperlinks?
- Averaging times that are not in a range
- Data Encryption
- Getting a value by comparing 2 columns
- Id'ing tabs that contain #REF!'s
- COUNTIF Function
- Dynamic formula
- revised q on report from tables
- Custom Functions Available for all Workbooks
- Function to Use when compare sums another column
- Pivot table to calculate variance showing budget and actual.
- Text from Referenced cell truncated
- formula similar to "countifs" function in excel 2007
- Help with formula
- Too Few Rows to copy sheet to another book
- single report on data in 20 tables
- Drop Downs and lookups from other sheets
- Excel Toolbar
- i dont know if sumif ,,,,, please help
- Automatically insert rows/copy formula
- Date refrencing
- finding 10 smallest numbers from last 20 input
- Formula assistance please . .
- COUNTIF PROBLEM
- Check the lasta character
- hiden cells copied automatically to another workbook, can I stop .
- Compare two columns with different codes
- need help with formula
- Finding duplicate addresses
- Deleting Row
- compare 2 columns, enter data from other column
- Conditional Copy from one worksheet to another
- Complex functions
- How do I match 3 different workbooks information for similar data?
- how do I perform an interpolation analysis using Excel?
- Multi NetWorkDays Calculation
- Vlookup and Data Validation Q
- What does this formula mean [$-F400]h:mm:ssAM/PM
- Top half of covariance matrix
- Linking to other worksheets
- Sorting
- m4=b4 only if
- Lookup Question
- What happened to setting up a constant using F4?
- Linking Totals Across Multiple Worksheets
- to CONCATENATE from the smallest date with at least 2 criteria
- Font by way of function?
- Store formulas in Vlookups? (another try ;)
- SUM determined by drop-down list
- Validation of UK VAT Number
- Date question
- Function to seacrh for a word across multiple columns
- Add text automatically by recognized value
- Sumproduct with mixed data?
- counting groups of words
- formatted cells
- Converting PDF or HTML to Excel
- Count if past today () - 30 days
- If 3 If's, then sum
- Dynamic Filtering...Need Help
- Finding the lowest cost for a product from a list
- RE: multi-worksheet sum
- Using text and formatting sum function in formula
- Identify the windows just below the menu
- Can you sum the amount of type a word appears?
- Formula
- excel 2007 macro recorded pivot table
- concatenate
- networkdays issue
- Week ending Thursday formula
- Sum of retuned valus as digits
- search a row for a word and if found
- Concentration Analysis
- Finding NEXT to last, non zero numeric value in a row
- copy formula
- Conditional Formatting Date Range
- SUM
- If function help
- copy/paste malfunction
- Maybe too hard to do?
- Interval between now and next birthday
- Function similar to "LEFT"
- annuity calculation for monthly payments but quarterly compoundin
- Average numbers in noncontiguous columns ignoring 0's.
- spreadsheet
- Need function to return numbers at beginning of text
- VLOOKUP returning formula
- Standard deviation and bell curve
- Can excel data be encrypted?
- CONCATENATE
- comparing data in excel
- Add no. of days to a workday to get new workday?
- Compare 1 cell to column of cells returning adjacent cells info?
- Sort
- Pulling a cell reference--clickable cells?
- Logical function please
- #N/A help please
- copying a formula down wards
- Rounding Up question
- Add values based on text color with the criteria of a date
- rounded # to correct #
- Sumproduct with a twist
- creating a report from a table, pivot table not suitable
- Pivot table show all days of a month even if no data
- VLOOKUP & IF
- Convert percentage into margin
- pounds shillings pence format in excel
- Help with If Sum statement - i think....
- Can I combine a Vlookup with an IF formula?
- Sumif with multiple sum ranges in a sheet
- Setting up an electrical register in Excel with expiry dates
- directing cell contents dependent on its value
- Directing cell contents to one of two cells dependent on its value
- Vlookup
- How do I recover a forgotten password?
- Countif/SumProduct
- Excel IF Formulas
- how do I import data in excel form SQL server?
- How can I add the values based the color of font and the date
- Filldown starting from F2 instead of F1
- Changing Source Data using V-lookup
- data links on subsequent worksheets
- Excel 2003 - deleting Duplicates under conditions
- Protecting Sheets with drop down boxes
- Adding a value to a customer ID?
- Show time as a negative figure
- multiple dependent drop down lists
- If argument
- workday, networkday or something else?
- consolidating data for a report - HELP - pivot tables no good for
- Auto Calculate Keeps Resetting to Manual
- 2 worksheets--3 questions
- Vlookup and if formula
- Ad-In Rowliner
- SumIf
- Icon sets - conditional formatting - in Excel 2003
- Sumproduct with sumif over mutiple worksheets
- Use Vlookup to store formulas?
- Vlookup & relative cell reference?
- Countif for finding a Time input
- Days in Text to Dates SPECIAL
- Formula referencing a changing range??
- Conditional Formatting based on match to external list
- General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
- How do i convert dates to text but keep the date format
- Help needed with If & Today function
- changing formula
- If & Vlookup statement
- Validation list with formula?
- Change the weekends
- Rounding
- vlook up w- multiple variables
- Date Diff - excluding working days
- Median with Criteria
- using CountIF function or Array?
- Conditional IF formula using multi-dimensional arrays
- stock control template
- Auto-insert same value each Monday in cashflow worksheet?
- Adding totals from different columns
- Hyperlink won't open in excel
- Find and Replace
- Pulling/Collating Data
- Array Formula Help Needed
- Sum amount of days in another coloumn
- updating cell range depending on input value
- Vendor List
- Unable to set the FormulaArrary property of the range class
- Help with formula
- Conditional formatting with expired dates after current
- I want to add formulas from multiple sheets to master form
- row height issue
- Lose Formatting
- Average using Sumproduct
- vlookup and match first value greater than
- Need to extract specific data from a text column
- ISNA VLOOKUP does not recognize 63023
- Combining text from multiple cells
- data validation using named range from another file
- Counting with 2 criteria
- Nested IF(OR(AND) Statement with Two AND Conditions
- Can I color a cell with "If" formula
- I need to write a PRODUCT formula that mimics a SUMIF
- Average For Filtered Cells
- Averaging many non-contiguous cells if they are blank
- Can I use Sumproduct with the LEFT Function?
- visible cell only
- Combining Cells
- Duplicates formula
- Ignore Hidden Rows and Count of distinct values
- sumif - with 2 conditions - rows and columns
- Sum VLOOKUP?
- Counting Array element
- formating
- Count if if
- Invoice: customer database and billing information
- If function with calculation
- Merge Cells
- using if in a range
- Consolidate excel 2007
- Look for Min and second Min
- Look for Max and second Max
- Counting frequency in unsorted data
- Basic Question on autocomplete function
- how to key in a1 information on e1 wil appear at b1
- excel formula
- Adding dates in columns
- Non-contiguous range and Sumproduct to average
- Find 2 highest point to form resistance line
- Find 2 lowest point to form a trendline
- date Concatenation
- Extract if 1 shows up
- Delete 3 end row
- Removing multiple duplicate events
- Unprotect problem
- Customize accounting format
- different colour font in same cel
- Countif using cell refences
- Summing based on dates
- Summing based on dates
- Pivot table field list missing
- Macro - onAction arguments
- Running total based upon current date
- separate text and number
- Help Creating Excel Formula
- Searching based on text
- vlookup formula error
- How do I set up a formula to give me an average based on IF?
- How to set up a conditinal formula w/letters vs numbers?
- Average with Conditions
- Excel 2007 - AVERAGEIF on rows that are non-continuous
- =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
- Format cell based on cell color
- Return 0 if cell has data, of copy if it doesn't
- Time elapsed calculation
- sum column based on single cell match?
- Help for Medical Records sorting
- Counting Merged Cells
- Excel
- return 0 if cell has data?
- #VALUE error-- some cells?
- How do I truncate linked text?
- IF Formula
- Help with function, not sure which one
- Clearing fields when differnt function selected
- Help With A Spreadsheet for a silent auction
- Format custom number: C-0000-L
- How do I stop Excel from automatically resizing my row height?
- Return column header based on last value in row
- Excel is reading formula as a value
- Protecting sheets with drop down boxes
- open workbook to specific sheet
- Help to resove this problem.
- Combine several spreadsheets with multiple worksheets into 1 file
- COUNT BLANK AND ZERO AS THE SAME THING
- Save As Macro
- Help with N/A in formulas
- Checking the results of a number of IF formula
- Sum with 3 conditions
- Include CDF to workbook
- Multiple variables to sort and sum, return values<0 with sum refer
- Calculation of weighed average
- How do I filter cells based on character case in Excel
- How do I write an IF function using dates?
- sumif..
- SUMIF with OFFSET
- hyperlink help
- Alphabetizing
- Conditional Formatting Confusion...
- How to count merged cells
- SUMIF Function
- Match a value to multple criteria both in rows and columns
- Excel 2003 formula
- How enter time DURATIONS mm:ss (not clock times), then sum?
- Summing Data based upon a condition
- How to copy & paste a worksheet but change 1 bit of the formula?
- Sorting
- complicated drop down menu question
- Automatic refresh in linked worksheet if row is added
- change multiple links at once
- .csv to .txt
- Multiple IF statement
- Hiding rows and printing
- Date chart formula question?!?1
- Return of value when copying a formula
- to Sohail
- how to count#cells w/= value in other column and not count blank c
- Hostname from IP address
- Pivot Table Totals
- How do i compare and remove common names from 2 excel work sheets
- Depreciation Spreadsheet
- Better Workday function.
- excel crashes when changing web query
- how do I change number format from 3,999.89 to 399989
- How do I count # of cells with same value other column?
- RE: Formula to Return age
- Hyperlink to the meat of a cell
- copy data from one sheet to another using a combo box
- trouble with closed workbook
- How do I write this logical argument?
- Function Lookup
- Formatting does not follow when copying from one cell to another
- Printing problems with hidden rows
- Excel data disappeared after getting message about compatibility M
- Changing coler of tracking cells
- conditional formatting?
- @Count
- Why won't text show in SOME cells?
- What is the most straightforward (elegant) way to write this formu
- Counting text within an Entire Workbook
- Countifs
- editing a hyperlink
- Summing 2 columns based on variables
- IF equation will not calculate
- Remove Arrow
- speeding up calculation: replacing array formula with databasefunction?
- Formula for counting frequency then sorting
- Using Worksheet Name
- Formatting background colors
- How do I sum cells that have values from a text formula?
- shared workbook is set up is not 'shared' on network
- Sumif weekday
- Excel Beginner-need help creating speeding fines system with butto
- Need to copy and match data from one workbook to another workbook
- Inserting a calculated field in a Pivot Table in Excel 2003
- cell selection
- H and V lookup or match?
- my paste special function won't let me copy formulas
- data
- Leading zero's trail Number
- Sumif across a table
- excel 2007 filter 3 text values at the same time from the same co.
- Auto fill
- How to stop time format changing when I merge cell contents?
- summarising_data..!
- Creating macro
- Explain INDEX MATCH
- Calculating Time?
- Ending Macro in Last Row within a column of Printable Items
- Repeating rows not wanted
- Sumproduct error
- numbers in a column are not sorting ascending
- Count Unique text in 3 different columns
- Sum Indirect
- Sumif for unique values
- Help with interpolating values
- Formula assistance required
- How do I use 'between' 95% and 100% for a nested IF function?
- count identical values in 2 rows
- How do I find the minimum value in a range while ignoring zeros?
- VLOOKUP not working with data from PeopleSoft
- Automatic Sumning of Same Cell from Different Sheets
- Vlookup formula combining two columns
- Trying to calculate # of times text string is displayed
- Match Account ID from combining street names and numbers
- Date Format
- calculate diffence between old salary and new salary
- Need help with ISNA, INDEX, MATCH
- Style worksheets differently
- copy excel spread sheet & graph to word doc without formulas
- VLOOKUP & Hyperlinks
- How to use VLookup with a range of numbers?
- Using multiple IF statements
- Excel 2007 - Personal Macros
- Complex If
- Weeknum formula
- Coloring
- Excel's COMBIN and integers
- Data moving 3
- Cell selection - turn it off
- Time difference calculation
- WHEN ENTER NUMBER , DISPLAY IN WARDS ?
- Address of cell in VBA
- How to combine Combo Box function with Vlookup function
- How to consolidate data from different files?
- lookup help. lookup result based on data in 2 columns
- Automate calculation...
- VLOOKUP
- Multiple IF statment help
- Calculations
- Multiple table lookup
- SUMIF returns no value
- hiding rows with an if statement
- Time Functions
- referencing in tables
- function to populate a cell where formula is NOT located
- Dynamic Table Problem
- RE: New to VLOOKUP ...merge addresses?
- total point
- Drop down list
- MS excell 2007 Data verification list
- Excell mistake in addition
- Follow up question about consolidating dups and sums
- rearranging_names
- I have a complex formula where I need to build in a MAX function
- Data moving 2
- Working Days of Week and DUE DATE for PAYMENT
- consolidating duplicate values and summing their corresponding val
- don't know what function to use
- Calculating a Target time from an Actual Time...
- references rename!
- Compare text in 2 different files
- NONFUNCTIONING FORMULA
- first some general questions about populating...
- Custom Zeros
- Count dates until complete or Cancel
- Index, Match help
- Formula Assistance - Vlookup
- COUNTIFS BETWEEN WORKSHEETS HELP
- How do I change the format to allow a zero as a first digit?
- Weeknum function help
- numbers need to be numbers
- Countifs for multiple worksheets
- Text to Number format
- eliminate duplicates on a sheet
- Printing Forms
- shortcut has change or move so this shortcut can not open
- Simple Consolidation of Worksheets
- Measure on the date different
- Rules for locking controls
- vlookup returns na
- vlookup doesn't return value
- can i short data with excel formula
- Conditional formatting with formula (multiple criteria)
- How do I reference the cell which returned a lookup value?
- Counting Filtered Results Using Autofilter
- Calculating new date by entering number of additional workdays
- Conditional Formatting 4th Condition
- Conditional Formatting: comparing cell values
- Need to separate and rearrange names
- Figuring Dates quit working!
- Help for sharing a worksheet from a excel sheet
- HOW DO I CALCULATE WEEKLY PAYMENTS THAT VARY BY LENGTH OFTHE MONT
- VBA to sidestep popups...
- See if cell value appears within a value range given by another cell.
- Absoute Cell Ref Changes When Inserting New Row in Referenced Shee
- Formula/Function for parsing data
- I want to show only the first three columns
- Conditional
- Dup check 2 columns - need it to delete correct one
- How do I make first row sort in table
- rearranging_names
- how do I sort by picked-up date in Excel
- Change formulas in a column based on a selection.
- counting colored data
- Sorting in Excel
- help with formula
- In Excel, changing a range of cells to all caps.
- How do I create a drop down box within a drop down box?
- Round formula
- IF - Date falls between two dates, place here
- Problem with Excel getting correct # of records back from Access
- Think I need a MAX / MIN formula here (help needed)
- Adding an aditional forumla to this one
- how can you freeze links in excel? no #Ref upon opening the file?
- Handling Dashes in IF statement
- Range of values
- Consecutive numbering
- problem with linked workbook
- save by & date, time
- Autosum problems
- Unique filtering to another sheet ?
- IF formula not working
- Lookup within a 2 dimensional array
- Looking a value up for a
- multiple cells are often selected when I click in only one cell
- Macro to get rid of #DIV/0!
- Relative Range Reference in a sumifs formula
- I have a workaround
- Data Range with more than value
- Additonal info into newly created Subtotal row
- Count Data in Series
- Automatically copy formula in column when adding new row....
- sum if one or another criteria
- Really need some help with a tricky formula
- VBA Macro help
- Return Value from a Range (depends on input to determind month)
- Data moving
- Looking up whether one item has a certain matching item
- Frequency Counting
- Removing duplicate records based off of date
- Populating Row with dates
- Custom Formating Letters to Numbers while Displaying Letters
- excel conditional formatting
- Adding certain cells in one column
- Maintain lowest value in an "external connection" cell
- index, match in array setup question
- Return range of cell values based on current date
- UNABLE TO SAVE FORMATTING
- Automatic recognition of a starting point for a column calculation
- Checkbox - Output results to a csv file
- Sumif with a or condition.
- Make copy of workbook based on selected criteria
- another sumifs plea
- Tabs Names
- Force entry in one cell due to the value in the other
- GETPIVOTDATE Funtion
- Formatting Phone Numbers in Excel 2007 Help
- Countif function to show how often numbers within a range are pres
- Need Help
- IF statement help please
- Conditional Formating Highlight Results
- Protected Sheets
- Need a type of lookup / find formula PLEASE
- Lookup function question
- Programming style with worksheet functions - discussion invited
- Unique Rank with Duplicate Entries
- Array function - I think!
- Formula for counting cells with value 'x' provided Col U = 'y'
- setting cell values based on a 3rd cell
- Unique Rank with Duplicate Entries
- 1-4-1 is not a date how do I stop excel from changing whats enter
- Rows to table
- copy formulas with fill handle
- to lookup data for 'today()'
- cell vlue based on cell back colour
- EXCEL
- Alert Message After Somthing Changed
- Folder listing
- Calculating column A * column B = Results in another column
- how to number cells (1,2,3...) w/o having to manually type them al
- Dates changing colors
- Writing an IF statement in Microsoft Query
- Conditional Formatting on Range of Cells
- Share a workbook
- Sumproduct with more than one valid criteria
- INDEX and MATCH with range
- Unique Rank with Duplicate Entries
- ISERROR on VLOOKUP
- Adding A Date To Adjacent Cell
- RE: how do I create independent results?
- Excel Functions
- Auto fill text columns based on rows
- If-Then logics
- Grouping and percentage calculations
- Networkdays and misleading results from blank column
- Need some help BAD with conditional formatting
- Doing a countif against a substring of the range to be scanned
- SUMIF with NAME RANGE
- Count # items in ColA if blank in ColB
- How do I page break in the middle of a row in Excel?
- MSNstockquotes option quotes
- I need to copy half of the info in a cell...
- Trim varying decimals from column of numbers
- count if for blanks with 'or'
- VALUE appearing (referencing blank cell)
- Creating column
- Help with IF stament (getting result FALSE in some cases)
- Using rank to rate the winners in a competition
- Table Data Missing
- =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
- Generating Possible Combinations and Assigning ID Number
- excel
- datevalue returns #value
- how to copy 3 spreadsheets and get the formulas to work
- Why can't I use the MONTH function within the SUMIFS statement?
- Conditional Sum - Moving Average
- Conditional Sum - Moving Average
- Help? with extracting unsorted data from a worksheet, no blank lin
- Re: Copying rows down into cells across until row=false ?
- HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)?
- Excel's COMBIN and integers
- Worksheets are stuck on default text format with left align
- How specify number format of cell value in concatenate function?
- how do i set an alarm to work on excel
- Multiple Conditionals in MS Excel 2007
- change position of data
- Updating Next Consecutive Cell in Range
- someone please shorten this formula...
- Combine Two Arrays Into One. Tough.
- Changing Content in one coulumn using given content in another
- Copying rows down into cells across until row=false ?
- If and Vlookup
- Excel formula
- sorting in Excel 2007 problem
- SUMPRODUCT with two valid criteria
- How can I figure square footage for 2 or 3 numbers in a row?
- Help with Value in one column...
- Color Me Red
- using a IF statement to return a value
- show pages on a pivot in 2007
- vlookup, indexing, oh my....
- Multiple conditional formating for one cell
- FORMULA BAR DISAPPEARED IN 2007, HOW DO I RESTORE PLEASE?
- I need to indicate a missing # in a series
- creating macros
- Adding and then sorting data into an already existing Excel 2007 w
- Date Function
- How do I get functions added within EXCEL?
- how do i find out what data is hidden i excel
- Is there some 'secret' to getting 'End' to work when stopping func
- Unable to Unlock Workbook
- IF with function as false return
- Using DCOUNT
- Toolbar question
- IF or VLOOKUP
- Button, now too thin, cannot select to delete
- How to carry Excel balance on 1 w/s to another?
- ISERROR and INDEX Funcion question
- List the last amount that is state
- hOW TO CREATE A BOOKMARK IN EXCEL+
- Using VLOOKUP to find colours
- Filter formula
- Calculating percent of times a value is in a column and total #
- Imposs? Speed up
- Calculating greatest number in a range
- Round
- can't use append xml results. Its always grayed out
- Updating Consecutive Cells in a Range
- Drag Mouse and Add-up
- Ageing dates
- excel dates
- COUNTIF for 2 columns
- data not carrying over from access to excel
- feet and inches to meters
- Calculate the number of days to exclude Sunday & Holidays
- Combining data
- sorting data
- Jpeg links opening in Explorer instead of Picture Manager
- convert vertical to horizontal
- Trying to match 1 value to multiple columns
- Repost - Functions on filtered data
- Sumproduct with Multiple Criteria
- First Day of the month
- Array formula to find date
- Print Preview Different than What I see in the Excel File
- reference cell from advanced filter
- Removing ''VALUES''
- Functions on filtered data
- SUMPRODUCT help
- Formula for multiple countifs
- How can I use a pivot table as source for a second table?
- IF - more than seven arguments
- General Calculator
- counting based on two conditions in excel 2003
- How can I count values in multiple non-consecutive cells?
- Entering Formula - Cannot select cell as it is hidden by formula
- Missing Record in Table Lookup
- How can I allow users to sort a protected table using dropdowns?
- find
- Filling formulas with specific cell references remaining the same
- Use vlookup within offset?
- Sorting Function
- Segrigation of different datas from one colum
- Formula Question
- Last cell with data in a range
- Sumproduct, but errors in column
- Excell Spreedsheets
- Excel data from spreadsheet to database
- count values in a column, but. . .
- group/ungroup protected sheets?
- Row Height Adds Blank Space at End of Text
- Select 'Sort By' column by simply typing heading letter
- Vlookup possibly ?
- Circular Reference Warning ???
- mark up
- adding result of "if" statement..
- count number of dates in range
- SELECT SUM(h) WHERE e = 'eBay Payment Sent'
- Count filled cells in range if they are one after the other
- adding figures that match 2 true and 1 false if statement conditio
- Date Formatting
- Excel not pasting the formula or reference
- Too many rows highlighted
- Sumproduct?
- Complicated IF statement - desperately need some help
- HELP!
- In new Office 2007 EXCEL, can more the 8 IF statements be used?
- Looking for Text strings
- Pivot Table - Calculated Field
- Excel 2007 - Autocomplete Alpha List
- Downward column
- Data Connection Wizard
- Hidden column
- formula question...
- Collecting data from Excel form
- Convert Date in Text to month and Year
- file names
- Data Validation drop-down width, with named range source (XL03 and
- Calculate Number of Days worked in Each Month by Project
- Matching two sets of data?
- VLookup with Search for in String
- Calculating Resolution Rates
- Indirect and Sheet Name
- "AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
- Multiple IF function
- Nesting Lookup Functions
- Using Sumproduct when some of the values are null
- Justify across selection
- Data Validation List from a Dynamic Named Range on Another Workshe
- SUMIFS using a text range
- SUMIFS using a text rage
- SUMIFS using a text rage
- Date Format
- macro shortcut help
- counting function with weekdays only
- Lookup on a combo box
- How do I create a travel expense report by employee, by campus, b.
- Pivot Table Refresh
- IF Multiple Conditions
- date format error in cell
- Column Average Given 2 Criteria
- How do I validate / verify the output from a spline curve
- Link an entire Row with a Key Word
- testing range of cells for part of cell content
- Lookup 2 values to return 1
- DATEDIF FUNCTION NOT LISTED IN HELP
- Excel 2003 Macro - Finding rows with data to copy
- Publish interactive data to the Web using Excel (Problem)
- How to sort duplicates?
- formula for multiple criteria inc. date range
- Data Validation List - Can I have multiple ranges displayed?
- How to generate a cell reference from multiple cells
- Conditional Formatting
- Last number in a column shows in the total/summay line cell
- combo box
- Trying to convert mm/yy in text to Dec-07, it adds day & current y
- Create an automatic worksheet with two variables
- Need help with macro for conditional formatting using number forma
- Removing Special Characters
- find all instances of a search item and put result in a single cel
- How to know if a worksheet was unlocked
- Way do do search/replace on beginning/end of cell w/o functions?
- annualize sales for remainder of year
- Help with a IF formula
- Redistribution of values after reaching maximum
- Counting for multiple situations
- Is this an Index/Match formula?
- HLOOKUP into another xls file
- multiple correlations with one click?
- EOMonth function
- Conditional Formatting Help when a Cell is Blank
- how to get rid of default dates in Excel?
- the criteria pane and table panes have disappered.
- formula for displaying only the last entry of a group of cells
- IF, INDEX and MATCH
- How do I stop text from disappearing when I wrap text in Excel?
- Question about syntax for conditional formatting
- Using match but data needs to be split.
- Staff Overtime Form
- Line Feed in Formula Adds Double Quotes?