- How do I use nested countif statements?
- disregard a cell on occasion when there is text in it instead of V
- Average Functin
- FIND type mismatch error, but don't see it
- Database Functions
- Months of review
- matching columns using text strings!
- Count & Multiply Months for Hours Budgeting
- need help with counting...
- How do I delete object "Calender Control 11.0" ?
- Excell 2003 Charts
- Summary File
- Amaising for me, IF condition
- Vlookup in a pivot table
- How do i stop numbers stringing together ? AB
- Creating a Subset Report
- default name and value in input cell
- keyboard shortcut for Σ symbol?
- Months
- Comma Deleted File into Excel doc
- Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2003
- handle #VALUE exception
- formula 4 number of cells/rows in a range
- Problem to close a group of columns
- Image (object) offsets in Web show mode
- sumif based on cell comparison in excel
- Arrays/Functions/Different datatypes in a formula?
- How do I change automatically figures into words in Excel
- Partial / Conditional Sum of a Column
- Disable copy paste option on a particular cell
- Need Help With a Excel 2003 Formula
- What formula do I use to count if value in other column?
- Auto Send email from IF command
- Remove content when saving / loading spreadsheet
- IF Function
- VLOOKUP Help
- Partial match lookup question
- Macro Button
- headers in worksheet
- eliminating matched records!
- how can I increase nested function 'IF' in EXCEL upto 10 levels
- Help with an Excel formula please?
- Automatic text
- looking for one value in a range of values
- Spreadsheet name = cell content?
- Pivot Table Problem
- number patterns
- REF# error on summing ranges
- HOw to create a pivot of pivot tables
- Report Help from Bagram
- Can I create a line graph based on a formula
- SumIf for Variable Conditions
- Lookup multiple results with gaps
- Lookup Multiple results has gaps
- Lookup multiple results that has gaps
- Lookup multiple results with gaps
- how can i set up rand or rand between to give only -1 or 1?
- vlookup shows result one cell above the expected result
- Conversion Formula
- excel date scheduling not msProject
- EOMONTH() question
- add OR to already nested If function - help required
- Lookup in array formula - loss of inspiration
- eliminating records!
- DCOUNT with different files
- Copying Worksheets
- Indirect Function
- How to clear content from unprotected Field
- changing password in Excel workbook
- Read worksheet in excel
- Attandance counting
- sum
- Incresing % per annum
- All Worksheets in a Data Validation combo
- return a collum heading
- import excel to Access has a problem with text field
- Last data entry made time and Date show in each worksheet
- finding the last row in another worksheet
- SumIF
- Formulas
- how do I use OR in a way that true return calculation
- Last Cell in a Column Value
- maro to save wooksheet & open in sheet 1
- Sorting a Spreadsheet with locked cells
- Export Excel Calendar to Outlook
- OR function
- Index,Indirect, and Match
- lookup formulas
- Pivot Table newbie help..
- linking (?) fields from one worksheet to another?
- VLOOKUP with IF function
- Can Excel do survey cross-tabulations?
- Remove the fomula...?
- Default cell name and value
- vlookup with dynamic table_array
- Getpivot date w/ relative reference
- Bringing together multiple columns into one from least to greatest?
- Way to Concatonate cells in a row based on the order they were entered?
- Add a Sheet From a Previous Sheet Macro
- Conditional Formatting
- n00b Q - Regarding the inner workings of pivottables
- should it be if() or another logical function?
- cell displays function not value of function
- Displaying negative time in excel
- help with formatting a sheet with text and numbers
- Countif & "AND"
- Excel Formula
- 2 sheets 2 rows grab 1
- Sheet Reference is not working
- How do I count cells with a specific cell shading?
- How do I enter a formula in a cell that changes per another cell's
- Worksheets with password protection
- Function that copies a charts format
- Function that copies a charts format
- Functiono that copies a charts format
- Macro to search a website from a cell
- Way to conditionally hide rows?
- Looking for help to build a predictive sales model
- How to subtract 2 dates to get number of days.....please
- Count the non blank cells
- Do I need SUMPRODUCT?
- IF and OR functions to obtain text descriptions
- Add Between Two Dates Q
- IF function
- Write HTML Scripts On Excel
- Sumif with two criterias
- Changing worksheet names
- WORKSHEET FUNCTION or PROGRAMMING.
- Excel 2003 - How do I sort subjects in a worksheet by column?
- Excel 2000 versus 2003 and the TEXT Function
- Nested If statement to find greater than but less than numbers
- how do i set up a weekly scedule in excel to track time worked
- How can I set up an auto return to the next column in excell?
- Formula Macro
- Macro to pull from different applications
- Copying named lists used in drop downs from one workbook to anothe
- How to trick a Dynamic Name to be Static when SOLVER is ON...
- LONG IF (diff columns) STATMENT(s)
- insert row into worksheet when date missing
- Using a comparison and taking data from one sheet and putting it i
- COUNTIF FUNCTION
- Moving cells
- How to return a value if a range (not a cell) contains a certain v
- Conditional Formatting Formula
- Enter a new name in the Name Conflict dialog box
- re: which function to choose?
- lookup
- Summarizing in Excel
- between dates
- Can't figure this out!!!
- Which function to choose?
- ARE THERE CONDITIONAL FORMULAS TO CHANGE TEXT COLOR?
- how to work out an age from a date of birth
- List all sheets present in Workbook
- Advanced Filter for multiple criteria, including blank cells
- Conditional Formating A Row
- How to Subtract times on 24hour clock and avoid error message in .
- need help with conditional formatting 3 criteria
- Formula for copying tap info into a cell
- How do I count in column A when it meets all criteria in three col
- Replace all empty or " by the content of the cell above it
- How to set the time as condition within if statement?
- search and sum
- I need an If statement for Excel that excludes empty cells
- Pulling text from a cell
- Using an offset formula for the reference in a relative reference
- how to sum cells from multiple work sheets
- how to use tier system
- Setting up conditional drop down lists in Excel 2003?
- couting dates as events per month
- Count the non blank cells
- Worksheets.add in VBScript overwrites existing worksheet
- Using =TRIM()
- copy text A1*7
- ^ Carrot in a Formula
- Worksheet name
- Calulating hours, minutes and seconds
- about functions...
- Google search box on excel
- VLOOKUP query
- Sum function
- Formula Error when entire row is deleted
- improve formula, Possible Genious needed !!!
- Extract Data by keyword and export to new Excel sheet
- Conditional Formating - More then 3 conditioned with formula
- formula exercises
- Userform
- How do I create a popup notification in excel ?
- looking for auditor tickmarks to add to excel toolbar
- #N/A coming up in VLOOKUP when visibly the two cells are same
- How do I count the items in one column if another column is blank
- vlookup problem
- How to force workbook to always open on the index sheet tab
- Dynamic name
- Wildcard character in an "If" statement?
- how many times a specific value is in a range...?
- help with database function
- shortcut issue - ctrl S
- Recommondation for training sites for Pivot Tables in Excel 2000?
- Total of pages
- VLOOKUP with a non-numerical columindex number
- Any way to have a dynamic range for ranking, based on criteria?
- Passwords in Excel
- How do I get the date for the 2nd friday of each month?
- Mail Function?
- VLOOKUP Help
- How do I hide a tab automatically?
- copying data in multiple sheets
- Separate data and put them into one line
- lookup
- Define Name
- Time Function Problem
- When data match, copy adjacent value to adjacent column
- lookup
- vLookup Help
- Allllen you rock!!!
- Convert a file to an ASCII
- Formatting a row into a column
- Counting events since last occurences
- Update Value Box
- negative dates or times are displayed as # # # #
- Hyperlink Destination Positioning On Screen
- How do I prevent editing in a cell based on the value in another?
- Average If
- Deleting Repeated Rows
- inserting hard CR in a formula
- Interaction of form controls and pictures in Excel 2007
- Return adjacent cell if conditional formatting exists.
- Help with spreadsheet
- Delay Calculation of Worksheet Functions
- inserting a dash into a column of numbers
- File Exists Formula
- need help converting text codes to names
- Calculate minutes from timecard
- IF statements with * character doesn't work
- Creating a form for multiple users
- Save button-shortcut
- Help, my macro always opens up spreadsheet it was created in
- Multiple Configurations Addition for Sum
- vlookup with 2 values
- #VALUE error with valid formula
- IF function
- Autofilter on a worksheet with merged cells
- Need help with a formula
- Compare And Merge Workbooks
- multiple column comparison on 2 worksheets
- Excel Functions
- Paste 2 different things from Excel to other programs
- Find record
- Email Hyperlinks
- DATEDIF formula enhancement
- Data Validation Error
- track changes on an excel sheet
- Counting Update
- Counif multiple condition
- Identify the cell with Max & Min values
- Excel Formula
- Macro to change a formula to a value
- #Value Error
- formula for +- comparison check Excel 2003
- Need to pull a selected segment of numbers/text from a large strin
- Invert excel data
- Keyboard command
- New Office 2007
- Go to functionality
- Wow, never seen this error before (Excel science experiment)
- Adding an AP to a worksheet automatically
- DSum criteria
- Converting Text
- Timecard question
- MIN and MAX Functions
- Dynamic unlock a cell (under condition)
- IF statement for time data not working properly
- Finding Location of Maximum Value in 2D Array
- If help
- Excel spawning a new window when opening a file
- In excel, how do I enter unique cell information in a column
- Reference a cell in another worksheet?
- Array UDF?
- calculating ages
- Why do Excel worksheets imbedded in a Word document sometimes corr
- calculating decimals
- How to copy formulas with clustered data?
- check for duplicates
- Excel 2007
- Weird Worksheet Issues
- How to make a nested SUMIF possible
- Display results of formulas
- Polynomial Treandline Coefficients
- Question re: calculation time and Index formula
- #value error when opening spreadsheet
- how can i set a date reminder to check on something in a certain.
- How to create a copy of a folder having five files in it, & rename
- create view tabs
- Re: how to perform a Mann-Whitney test?
- Pivot tables - page section
- conditional sum query
- Need help implementing EPA rounding method
- how to perform a Mann-Whitney test?
- data validation invalid in dynamic validation list
- filtering/autofill problem
- Ranking exam marks
- Counting "Question Marks"
- Physical Constants for Excel
- Applying J-Walk's SheetOffset() to SUM across sheets - possible?
- Format cells to pick up the name of the person who opened the excel in a network
- Format cells to pick up the name of the person who opened the excel in a network
- Copy & Paste
- if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG!
- Excel 2003 - Simple IF() Formula Will Not Work For Me
- Shared workbook
- How do I merge and replace matching cells from different workshee
- creating table of content in excel workbook
- Excel commands
- Debra Dalgleish Question
- Automatic Calculation Turns Off Intermittently
- My Auto Sum Function is not Automaticlly summing the cells
- Two columns of data in pivot table?
- How does one turn off gridlines only in a group of cells?
- double match formula
- Calculations in Pivot Table.
- IF Date formula
- Array problem - TIA
- Average
- RE: Display the source for a pivot table page field
- highlighting changes by color in an Excel column
- Using the MATCH formula and list the duplicates
- percentages
- Conditional formating between 2 workbooks.
- MultiCriteria for Conditional Formating
- how to view sage tool bar
- Automatic evaluation of custom worksheet function
- sumif in Excel2007 on Vista doesn't work.
- Nest vlookup within large function
- How to input 'Used time' data ?
- delete worksheet
- Getting #VALUE
- Weighted average question
- I was trying to protect a worksheet and my outlook tool bar is loc
- Lookup Function Referencing cells, not text values
- Using macro to select a range
- use field data from 1 pivot table in another?
- use field data from 1 pivot table in another?
- count entries
- AutoSum
- Any way to shorten this up?
- Find Numeric sign in a string
- Creating a Vendor ID from Vendor Name...
- Can you write your own NETWORKDAYS function?
- What if delete sheet is whited out?
- Cell reference
- Help finishing array formula!
- Generate random number from a list
- Re: conditinal If statement with 3 outputs
- Create formula in VBA
- How to skip the blank cells for calculating StdDev?
- I want to get remaining text after using LEFT function
- Simple VLOOKUP problem
- How to skip the blank cells for calculating StdDev?
- to recover deleted work sheet from file
- User form problem
- Delete rows that are empty across columns
- adding quotations / brackets
- #N/A
- Evaluate a column and extract last value
- Is there a way to change Lowercase or Proper to ALL CAPS?
- automatically move cell data in 1 workbook to another workbook
- Displaying trendlines in legend (or not)
- VLOOKUP weirdness
- Lost my built in menu bar in excel 3
- sumif with 2 condtion
- Counting
- Add sum of cell from another worksheet
- Sum a range of cells starting from an offset date list from TODAY()
- How do I prevent saving an excel file if cells are blank?
- Make Function ignore 0 and error values
- Compare
- NEWSGROUP MESSAGE URGENT
- NEWSGROUP QUESTION URGENT
- Sum Cells Based on Condition (2 problems)
- How to count occurrences where 2 columns are required to be true?
- Lost all my worksheet tabs on excel
- how to collectly put data in each cell from magnetic card reader data
- looking to create a time + text history when a button is clicked?
- Changing hyperlink addresses (global)?
- creating formula help
- Protect Sheet but allow sorting
- How do I make a spreadsheet w/ original price and then %?
- selected extraction of cell ref in a series of cells in a row/colu
- How do you calculate text into numerical answers?
- Is there a better way?
- HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
- Is there an easier way to pull URLs out of Web Query?
- Jump to next cell after selecting from drop down list
- excell search function
- lowest number in a set EXCLUDING zero
- Excel not recognizing equal values
- Has anyone a template for a surveyors field book
- selecting using option buttons in excel
- Conditional Format & Formula
- Major Goof, I deleted data HELP
- Rounding Up in Cells With Formulas
- How can I paste a worksheet to an other program through a HYPERLIN
- ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE
- How can I change 080402 to 08/04/02?
- How do I show only the last portion of text in a multi line cell?
- Problem with VB string character limit.
- How do I calculate within a range?
- Finding multiple values of a function
- Tip(s) from Excel User Conference
- Help with Custom View
- flaging items as "org","dup",etc.
- Worksheet function?
- Find and replace numbers using a formula
- 12 Month Average
- IF THIS AND THIS BUT NOT THIS!?!? HELP!
- Formula to extract a specific word from text string
- formula for text string
- How do you represent a=t1+t2 divided by t3+t4 in excell
- Columns to rows
- End of Year
- how do I put in the IF function only integer as true values?
- Grouping with a pivot table
- Formula to detect color?
- Use Excel to randomly generate selections for cyle counting?
- I want to hide values if no data in target cell
- If lower, highlight
- Parse an email address
- Parse an email address
- Return a value
- Conditioning??
- Numbers not adding together correctly
- Is there an "Appear Behind Text Function in Excel" for a picture?
- how do I make excell show time values greater than 24 hrs?
- Enter text and formula in a cell
- MSNQuotes.Function Add In
- Excel File Double's in size?
- If statement
- In excel can we prevent the column width from change
- Excel 2002: Merging cell content with a comma seperattor
- Excel 2002 - Internet Explorer Windows opening up uncontrollably
- help on indirect()
- Driver Hours Of Service
- relative reference when creating a link to another workbook
- automatic passage to next cell
- Date To Quarter, Plus Next 3 Quarters
- how to set column check
- Calculations based on cell value
- Excell Macros
- Command Button
- How do I copy and move selections of data to other sheets?
- how to do matching 2 criterias
- entering a matrix that contains formulae
- Formula Help Needed
- SUMPRODUCT- double unary vs. *
- need scenarios function to running MPS for production planning
- Time difference - again!
- Count Non-Blanks in one column based on criteria in another
- Dates That Change
- Paste is acting up
- Create a function to calculate Mean time Before Failure
- SMALL(IF( across multiple worksheets
- Create mutli-level subtotals
- How do I lock/protect cells so they can't be changed
- Most resource-hungry functions?
- Can't Access Paste Special Anymore
- I'm trying to import fields from one Excel file to another
- using nested OR
- How do I change fraction to fraction characters?
- need help
- Conditional Counting
- How to ALWAYS have footer automatically?
- dynamic vlookup?
- Calculating Mode for multiple arrays based on criteria in another
- how do i change row font color based on cell value in that row
- Rounding results by ranges
- How to copy rows that meet criteria to another sheet in Excel
- Why are my formulas not adding up automatically
- Generating random numbers with the occasional outlier
- EXCEL formula
- date
- HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
- Pasting data with hidden columns
- Copying Formulas From One Column To Another??
- Hiding Specific Rows Based on Values in Other Rows
- Vlookup with 9E+307
- Pivot Table Conditonal Format of the Grand Total
- Text Function
- VLookup does not work with "("
- drop down box
- VLOOKUP problem
- IF Then HELP!!!!
- SUMPRODUCT + CSE
- protecting formulae!
- Factoring
- Formula to calculate 401(k)
- Auto Fill from Drop Down list
- EXCEL
- function
- do not copy data to another sheet if exists
- Hyperlink Problem
- grouping
- About workbook_Open madro
- Excel 2003 Functions
- each number in cell should be 10 digit
- Countif Limit
- IF function
- Add sheets using macro
- smart tags
- Restricting Duplicate Entry
- Automatic Update of Dropdown List Box data
- Adding rows without the links moving
- Need help in formula - IF + Find + Vlookup
- putting a number that is greater or lesser into different cell .
- How do I fill mutiple cells with one pull down menu?
- Offset.
- Warning text triggered by values of a cell range
- lookup function, returning the same format.
- Calander in Spreadsheet
- INDEX/MATCH Functions with row-arranged table.
- Link Excel to Access
- Simple excel question for newbie
- How do I get excel to sum a range without including hidden cells?
- N/A
- Sumproduct(N and --
- Searching a range with MS Query
- Conditional Formatting on one cell based on value in another
- How to link a cell in date format without displaying it as 0-Jan?
- using IF statement to compare text
- Finding how many events since last occurence in a database list
- Repeating an Excel Formula
- MIN function
- show current value
- How do I create a unique spreadsheet reference?
- combining text and numbers in a string
- Paste Special Not Working
- Excel won't calculate formulas unless I press F9 - HELP!!!
- SUMPRODUCT
- Change the "Insert Function" display for mail merge
- Fixing a Total on a page
- Vlookup
- How do I use the (=) symbol for cut/pasting in excel?
- in Excel, how to put gridline every ten rows
- how to apply the same header or footer to all sheets in workbook
- Get count for a table of dates
- How do I change hyperlink targets in a group of fields at once?
- Combining two work sheets using a column in both as a key
- Sumproduct question
- Can COUNTIF be nested to search two ranges
- How do i protect specific cells in a shared workbook?
- Resize the Check Box ActiveX Control
- Is there an easy way to find/display merged cells in excel
- how do I write an IF/other statement to cut off time data?
- How do I work with swedish excel 2003 that uses EDATUM
- MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING
- I need conditional formatting to apply to maximum %
- Formula to subtract values in one cell only...
- Formula to subtract values in one cell only...
- cell value<>presented value
- how can I multiply number of hours and minutes by hourly rate?
- Drop down dependency stuff
- Re: How to switch position of columns and rows respectively?
- How do I set up for greater than 3 formats in excel?
- How do I get Excel to open email for single sheet?
- Re: How to switch position of columns and rows respectively?
- Not getting messages in OE
- RE: How to switch position of columns and rows respectively?
- Help - Looking for a Sumproduct formula
- Hi--how do I scramble a list randomly?
- percentage completed and colors
- Eliminate second browse box when right clicking for hyperlink
- Worksheet, selection macro
- text box linked to cell
- Array Fromula
- Auto Navigate Cells
- Ask user for information
- Wildcard character inside sumproduct
- vlookup returns bad data
- SUMPRODUCT, COUNTIF and wildcard
- Does anyone know if there is a symbol for the "except" in formula?
- Function Key for Calculating Average?
- how to use GETFORMULA() in EXCEL 2003?
- countif Column A and excule column B if it's cancelled
- Find String in another string - only between spaces
- Looking Up Datas when Key Values are Identical
- Counting cells with multiple data
- Need help with COUNTIF
- Array formula with a constant?
- Restricting rights to save a spreadsheet
- Restricting a Spreadsheet so users cannot save changes
- Sumproduct value error
- How can I use Excel to mark student's tests?
- lotus 123 worksheet function conversion
- Date determination and sums
- How to create Cascading Drop-Down Lists?
- Filling values in a grid
- how can i capitalise text in an existing workbook
- Lookup and summing comparison
- Count cells in a column that has a autofilter
- Help please - looking for a formula
- Referencing another worksheet via a cell
- use track changes and macros
- Same page with Different Page numbers
- COUNTIF
- BackFill Zeros
- I need to add check boxes to my Excel spreadsheet,checked and not
- NULL Cells
- How do I seperate a full name field out into three seperate columns?
- Soundex converter formula?
- how to change the insertion point color?
- Looking up a value from one cell in another range of cells
- Match cells with cells on another workbook
- Can the contents of a drop down box differ from what's entered?
- Excel Group & Sum function
- Advance Sumproduct calculation
- cancelling getpivot formula when setting formula outside pivot ta.
- MATCHING DATE TO A WEEKDAY
- How can I get a cell to Flash if it meets a certain criteria in Ex
- How do you protect Headers and Footers in MOFFICE
- How do I calculate Return on Investment in Excel
- Show input box with cell value
- Conditional formats using more than 3 conditions
- How do i calculate the saved amount ?
- Format Date
- Date Interval Predictions
- Move data
- Splitting cells - please help!
- Maximum length of a number
- How do I selectand copy only subtotals in a sheet
- Stop Excel from evaluating formulae unless I want it to
- Filtering using Formulas
- Send e-mail from a Excel file
- Text to rows...at wits end
- Worksheet naming using visual basic
- Any macro experts out there?
- cannot paste link using equal sign
- Read only files? Lost tabs on worksheetstoo!
- convert time functions to numbers
- FV Calculation problem
- Fv
- How to concatenate an array of four stings using formulae (not UDF)
- Auto e-mail message
- text box
- Help with SUM and IF
- When I open a file in excel, I cannot open any of the sheets
- MATCH FUNCTION AND SERIAL DATE CONFLICTS
- How can I concatenate a number and preserve the formatting?
- look up sequential cells
- Drop Down List choice selecting another drop down list
- auto input
- Yes and No
- Quickly Review Data
- formula that sums cells yet does not round the number up or down.
- Is there a Way to Find the Cell Row and Column From my UDF
- IF across multiple worksheets
- Formula works but formula shows in cell???
- entering same formula in multiple sheets
- Last entry in a column/row function?
- How on Earth do I use the GHK Function?
- "Replace" problems
- How to set up an excel formula to copy cells to another worksheet?
- go to last filled cell in a column shortcut
- SMALL() on unknown length of list
- refresh option of pivot table not working
- conditional formatting error message
- Tracking Check Boxes
- How do I make JUST the header row always visible in Excel?
- weighted scores
- How do I get items from sheet 3 to show up on sheet 1 and 2?
- formula for counting
- index_match_error!
- Quarter Dates
- Matching Quarters
- "Magic" Formula
- Use custom format to add text to a text entry.
- copy formula every x rows
- vlookup on 3 different tables - please HELP
- Formula Too Long
- lookup on Table including blanks -
- Link
- Sorting a Soccer PointsTable
- Lookup and change to italic italic
- Can i set up tabs within tabs on Excel?
- Excel math formula
- Importing local OLAP cube in Excel 2007
- Macro problems
- Alphabetizing in Library Format
- Can I set up a default footer that will appear in every spreadshee
- Format Cells - Hyperlink
- Linking Sheets
- Writing a Marco
- Pulling data
- average values in non-contiguous cells, ignoring 0 values
- Formula to count numbers
- What is the meanding of the term • Financial Functions
- UK Postal codes in Excel
- 2 different ?'s: Date? Macro?
- Summing cell totals across columns
- Make Custom Macro always Available
- Text vs Number format
- Sumproduct error
- change the calendar to reflect the current year
- change the calendar to reflect the current year
- How to retrieve last date and amount from columns?
- Calulating the number of days an employee works
- Using the "Count" function with filters?
- SUM and IF statements
- How to write a quote formula using only the cells selected with va
- Pivotable Columns
- TEST FOR EXACT TEXT
- Formatting columns with either a date OR a numerical figure
- Move curser to specific cell when closing
- Calculate date 28 days from now if hours reduce
- Average if
- Formula Help
- How do I caculate 24 hour military times
- can excell convert a file from 'works'?
- I have a master spreadsheet, how do I create a copy?
- excel vlookup not working correctly
- Make merged cells a feature that can be used in a shared workbook
- check for duplicate numbers
- CELL ( )
- CHAR(10) = ALT+ENTER??
- formula needed for this one...
- Custom Cell Formatting
- how do i get to top of excel page it seems to be missing
- Outlining in nested subtotals not working
- In Excel fill & font colors not working
- analysis
- table data
- total schedules
- List in a cell
- Help - saving files
- How to concatenate 3064 and 01 with 306401 as a result?
- sum of cells until reach empty cell
- Topic did not show up?
- APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN
- EXcel 2007 - Unable to sort by font and cell colors
- Employee Time Sheet
- Sorting on a protected worksheet in Excel 2000
- SUMIF - Sum_Range is misleading
- Concatenate Problem
- Convert a range to a 2sequence of numbers?
- Modify a Macro
- A challenge: referencing cell contents in nested function formula
- Type set amount of digits in one cell then automatically move to n
- Link "page-by" drop-down in two pivot tables
- Copy Paste issue
- DSUM when database is part of a pivot table
- convert string to date & time
- Embedded Reference
- How to change cell reference within formulas
- Embedded Reference
- Advanced Filtering is Unavailable
- Using the VLOOKUP Command
- Can you make a tab entry form in excel like you can in word
- Auto refresh
- Calculate with or without Symbol
- Question on setting up excell to solve a math problem
- Summing across Worksheets
- Adding +1 to a text
- where is the search/replace command located
- bottom sheet tab disappears
- How do I get drop down pick list comments to appear over selection
- text wrap
- INSERT HORIZONTAL PAGEBREAK AFTER EACH LINE IN ENTIRE WORKSHEET .
- Transposing
- Quick Question
- How create my own Funtion
- Help With Dynamic Range
- match two cells from one worksheet to another
- Error 1324 during installation of addtional components
- excel sort problem
- I need to link check boxes to 3 different cells
- How can I put Goal Seek into a cell formula?
- Quick help needed...
- I need an Excel formula for converting hours to days?
- How to create link b/n Excel worksheet (cell) and Word document?
- APR - RATE Function
- Mathematical Problem
- Vlookup with #N/A
- how can i transfer fourmular results as a value in a second formu
- Locked Cell - can still edit
- Sudoku hints
- Drop down boxes
- New to functions, 'If' isn't working for me
- flipping a spreadsheet
- how to get zero befor no. means eg 065 in excel
- Excel Problems
- Sorting by Two Columns
- Workbooks run on foreign language computers
- FirstName, LastName and vice versa
- Excel equivalent of sql group by count
- Trunc/Pmt Different Results same formula same sheet
- Conditional Queries?
- How do I find and replace null values in Excel 2002 worksheets?
- how do I create a link for both content and format of the cell?
- Removing Data
- How to caclulate porfolio returns over different time periods
- DateDif Problem
- How to calculate portfolio returns over different periods of time
- looking for a lookup function
- sum cells compare cells
- convert 28:55 (mm:sec) to 28.92 (mm.mm)
- How to make IF function not change cell value?
- How do I select the last alphanumric word in an excel column with.
- getting a degree symbol (celsius) in each cell
- Conditional Cell Locking
- Dates, Years and Seasons
- Take a Cell and add it to the Footer or Tab
- Excel should let me sort by highlight color.
- Help with 2 formulas together
- GETPIVOTDATA used with a central pivot table - values vanish
- In Excel, can Boolean logic be applied to conditional formatting?
- What is this symbol?
- IF function? Moving the same info from one worksheet to another.
- How do I accomplish this?
- How do i create a template that will only allow Times New Roman?
- SUMPRODUCT
- Setting up a formula HELP
- how do I create a Date field format for mm/dd/yyyy (10 digits)
- Retrieving data from another table or array ..
- Viewing Funciton Arguments
- password protect multiple spreadsheets in a workbook
- SUMIF (embedded if???)
- Cannot start the source application for this object
- How To in Excel
- =IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
- Vlookup w/sum?
- how to change formula into value exel cells
- VLookup in to columns
- Rounding Up
- Formula That Totals Extracted Values
- separating data in columns
- Excel headings
- IF formula question
- How do I find data in separate worksheets and normalise?
- Page Numbering
- IF statement with a range
- Don't change cell content in Excel by dragging
- Arrays fonctions
- How to make negative numbers to become 0?
- HOW DO I ROUNDUP A RESULT OF A FORMULA TO NEAREST WHOLE NUMBER
- show only the subtotals and grand total in a pivot table
- Determining AM or PM in text string
- IF month and day match, then...
- two dimension look up table
- How can I link and deduct one cell from a budget in another?
- =IF(AND Function
- Tie a Calendar week to a Scoped Projected Week
- how to search a word in a excel file which appears twice
- Multiple if senerio
- How can I stop csv files converting 19-05-53 to 19/05/1953
- Ordinal Numbers
- Formula For Summarizing Data
- using indirect throughout a sheet
- can macro edit text?
- probability density function
- Date
- OTHER EXCEL FUNCTION COUNTER SOLUTION ?
- what are the columns (1 2 3) which appear right of line # column
- Can you make a checkbox larger?
- How can I format cells with data that meets certain criteria?
- how to amend pivot table structure
- Pivot table with more than 3 columns
- how to add a record to a pivot table
- Reading the Latest Value into a cell
- PLEASE HELP!! # of Nested If's - Have 7 but Excel Still Won't Acce
- running balance using split cells
- Calendar/Date Calculations
- Conditions in sumproduct
- Find Many String options in ONE String
- countif within array
- make heading stationairy
- Excel pull data based upon one specific word between two date
- Creating an algebraic substitution for use in formulas
- Calculations in Pivot Table
- search/delete duplicate entries in excel '02?
- Lookup with Variables
- PivotTable - Where have the units/records gone?
- SUM
- converting julian dates
- How do I import multiple e-mail addresses from website to excel
- Help picking a random number from a given distribution
- dynamic range name
- look up multiple values, to return only one value
- How to format a cell to only allow multiples of a number
- Cell formatting
- copy and paste
- Find and Replace ROUNDUP(stuff, 0)
- check for two blank cells before populating a 3rd.
- SumIf - More then 1 criteria - Please assist
- 2.5-0.89¢-#VALUE!-2.5 - =IF((F3/H3)>0,TEXT(F3/H3,"$0.00") No work
- How do I insert a symbol as part of a formula
- using "&" in the header (not date autofill)
- find string within other string
- Cascading macros to new workbooks
- How I do protect linked information if the link source is deleted
- SUMPRODUCT formula - help!
- Using a cell to reference sheetname in vlookup function
- Correlating items from 2 different spreadsheets
- Excel formulas
- if a condition is met I want an x in a cell
- Is it possible to sort or filter data by color of the field?
- VBE Geeks in Volatile Functions
- How do I merge 2 workbooks by comparing one column
- Lock cells, but still be able to trace
- Finding descrete valuse
- Merge/Combine address lists
- Easy for the experts: Lookup,index,match....
- Lock/Unlock cells
- extract first name only from full name
- why is the INDIRECT function volatile?
- Variable external data through a Microsoft Query
- Add-in function - language
- Excell function
- how do I create a football team syndicate?
- parse comma separated text to multiple cells and remove duplicates
- copying formula
- Check if result is an integer?
- Copy
- sum a column
- time diffrence with 24 hour clock
- WEEKNUM() Question
- I Need a Formula to return a zero value
- Countif worksheet function frustrations
- Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D
- COUNTIF says Null = Blank but Blank <> Null
- Isolating single row based on date comparison
- pivot table, grand total no negatives
- How to print the circles in formatting audit circle invalid data
- MAX, IF statements?
- how to reposition the dataset from top to bottom in a column?
- 16.36 convert to 16:36 (min:sec)
- DAILY WORKSHEET
- sort subtotal groups
- Amortization with up front skips
- if statements in sumproduct formula
- Calculate time within time
- Excel Formula
- standard deviation
- I need an amortization schedule with the first 6mo no payment?
- how to create a if statement, if true turn colour
- How do I set up a "Random Number" button in Excel?
- Multiple criteria for lookup table
- total the column anyway
- NETWORKDAYS
- copy workbook files without losing data that was in the org. work
- Fill color not functioning in newly installed version of excel.
- autocomplete in dropdown list in Excel as I begin typing
- Trouble With Data Validation And Filtering On A Dropdown
- Keep non-duplicates only
- find number in multiple columns and rows
- How to search a column that is not the first of the table
- Reforecast budgets
- Is there a way to name tabs so that they will ascend in order?
- Forecast using 2 data sets
- Function within a function?
- sequential number code
- copy unique data
- Excel VBA bug?
- Formula Help
- meaning of : IF(Switch; Average(array A, array B); array A)
- Worksheet function: last saved date
- how do I caluclate return on investment, compounded quarterly?
- How to make userform work publically with hidden sheets?
- Calculating time increments from dates during working hours
- Extract Symbol
- Keep cursor in 1 cell
- Counting multiple values within single cells
- Warning message if one column contains any text and another column is blank
- Cell to cell hyperlinking does not work, please help
- Count months away betwwen a strat and end date by month
- advantage of Database functions
- Need to Color Record in Duplicates
- How do I summarise what I want....
- Lookup Tables
- How do I count rows within a cell?
- measure calculation time for multiplication of two matrices
- Passwords in macros
- Can I increase the length data from a formula in a cell?
- HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL
- What is evaluate formula?
- Unique list of entries
- conditional format range set-up in Excel 2000
- Criteria for datbase function in one row?
- what does { and } mean in an Excel formula?
- Hyperlink mailto - ref cell for mail subject
- =IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula
- Change Tab colour using Macro
- hyperlink to .png file
- Possible to keep a macro seperated from a sheet?
- Formulae Help, should be easy...
- annual growing rate formula or funtion needed!!
- add text in a cell to trigger a calculation
- Need to color 1 record of each set of Duplicate Records
- matching two worksheets and return to different value
- 5 minutes intervals
- Copy a table from a web site, then manipulate the data?
- Lookup value in table