- aligning two columns
- in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz
- formulas and cells
- 'Alias' for file name.....
- Easy formula question
- count function problem
- test forumla rather than result
- in VBA Sheets("mysheet").Copy Before:=Sheets(1) how do i get a reference to the newly created copy of this sheet?
- sumproduct bombs out
- Hiding rows from a formula
- How do I lock a formula in a cell in an Excel worksheet?
- Calculating a date in Excel...
- Compare data on 2 separate worksheets.
- How do I insert 2 decimal places to a number in cell?
- How do I return the highest value in a range of cells
- need help comparing data in 2 separate worksheets
- Smart Report
- Data Validation
- Excel
- problem with msn money stock quote add in
- Making a file and worksheet reference into a variable....
- Maximum of a formula
- Excel - linking cells
- Display Weekday Only
- Need help with my formula please
- Deleting a rows from multiple worksheets
- Adding multiple worksheets
- CLEAR FIND BUFFER UPON CLOSING
- Forcing a sum formula...
- RIGHT_worksheet_function question
- Multi functions
- Problem With Reference Update
- LOOKUP
- Protecting formulas in a workbook
- Excel worksheet linking
- Excel macro that opens new MS Word file and pastes data as a pictu
- simple if then function
- toolbox controls in excel are invisble ?
- HELP!I need a specification template purchasing Interior Design it
- Data Validation (Specific Decimals or Whole #)
- Sound / Audible Alert in a Woksheet ?
- count unique with conditions
- How do I use a cell's text, "A1", and put it in a formula?
- Pivot table help
- Assistance please?
- formulas based on a date
- How do I increase a table values by 1.2 for example?
- multiple worksheets input to one
- Condensing lists
- INDEX problem
- How to print 2 worksheets (different col/rows) on the same page
- Where is data analysis tool?
- vba excel macro question...ranges
- Best method of cloning the contents of a worksheet.
- matrix multiplication
- Autofilter after hyperlink to a page
- Analysis Toolpak Translator - Anyone got it???
- Analysis Toolpak Translator - anyone got it?
- Subtotals multiple columns
- Squares for carriage return
- what is short key to move from one sheet to another
- Subtract text in one cell from another?
- Why doesn't my audit arrows show up?
- keep first row fixed
- Round a number in nested function
- How do I attach data to auto complete
- sorting data in order
- #VALUE!
- select a range using "cells()"
- Calculate weeks cover
- Use a multiplier to change List Prices to Net prices
- is there anyway to create a clone of an excel sheet in vba?
- sum totaling doesnt work
- Can't get back to Sheet 1. Seems to be lost. Tried unhide, does n
- Change sheet name in formula
- #N/A problem
- slow replace function
- Forms
- Creating a drop down list to change decimal value in another cell
- looking for a formula for a worksheet
- how do I ensure that the sum of two cells does not exceed a set fi
- Conditional Calculation
- Contents of adjacent cell from a function
- can it be done without vb
- Sum product if value present
- Need some help returning a value
- "Suggest a match" from a list or drop down.
- Formula problem
- Automatically compare and ecit two workbooks
- Counting using 9-key pad
- Copy a cell
- Sum values between dates
- Battleship Code
- Adding an Audible Alert To A Worksheet
- blank cells in calculations
- How do I get a macro to record selections in a dialog box?
- Eliminating digits
- Reserved by - Protected
- How can I link cell colours from worksheet to worksheet/workbook?
- Excel 2003 formula to calculate date
- Time Format Question
- problems with background images
- a function on decimals
- excel [HHHHH]:mm add subtract hours mins inc lnegative
- sorted
- vlookup avoiding #N/A
- IF statements if the value is True it changes the cell colour?
- referencing the value of a cell containing an array formula
- Figuring military time for total hours
- Sum Product Question
- binder
- countif across worksheets
- Condensing a list/range with blank cells to a new list/range without blanks
- Sort rows across multiple worksheets - Excel 2003
- Lookup based on 2 criteria
- Problem with formula
- how do i unlock an excel document
- IF equals this OR this
- prevent overtyping cells
- FORMAT NUMBERS IN CRORE FORMAT (##,##,##,###)
- excel shouldnt need a symbol before the first number in an equati
- Help with setting up a statistical report?
- Autofilter problem
- Subtotals multiple columns
- How to link worksheets so editing one will edit others automatica
- Should be really easy lookup !
- Look up Function Need
- How do I sort a group of calculated cells in Excel?
- Again-revealing the contents of formula
- What can I add to a vlookup formula to give me a 0 not #n/a
- averages formula
- Can VLookup function find and list multiple records?
- Using Concatenate inside a vlookup
- Pivot Table vs. Formulas
- Date, Day of week
- Something similar to sum() but ignoring error value arguments!
- calculate anniversary of date after specified date
- Creating your own reference
- What is the formula for cube root on Excel?
- calculate problem in excel
- sumif with 2 conditions ?? can this be done??
- Some cells can't be formatted after converting from Quattro Pro.
- Calculating Pay based on time of day hrs worked
- Tabulation order in excel
- Cell Reference
- VB Required??
- excel should have a floating "custom view" toolbar
- IF function - need to evaluate cell content in 2 separate files-#N
- If Statement Question
- Search data formulas - HELP!!
- averages formula
- How to display as normal when workbook has been protected
- convert numbers to words
- trendind data from compact flash card to excel
- Counting number of grades in a row
- GetProperty function
- Creating combo box with different number of variables
- Setup Unique Records
- how can excel recognize strikethrough?
- Validation problem...
- Too many arguments-VLOOKUP instead?
- How to change default page size in Excel
- CountIF
- Calculate running target by days in the month
- "how to combine multiple lines into a pull down option?"
- Reverse order in column
- Excel - return a picture or range rows as the result of a formula
- how many square feet to an acre
- how to input a calculation in excel to find the geometric mean
- Finding Links
- #NA
- Please Help with format
- Beyond VLOOKUP Clarification
- Vlookup returning No data.
- Looking for how to do a double FIND formula
- excel dup copy of workbook
- How can I compute a kids age based on his birthdate
- Automatic column width adjustment
- Using Vlookup in formula arrays
- Any ideas for a more customized data entry?
- Serial number allocation - Array formula
- 3 stupid, simple IFs
- match and count words
- #NA as zero value
- Dates
- Mark up and Margin
- Time: 11.45 = 11:45
- Thanks
- % error calculating grades
- How do I extract 3 middle results and average them in excel
- linking ranges of cells
- linking whole rows of cells
- Excel Pivot tables refresh
- revealing the contents of a formula
- how do i change the format for excel to day-month
- How do I use the TABLE worksheet function?
- Date format
- Averaging selected values
- Combine FREQUENCY and SUM of Associated Values
- Up Arrows / Down Arrows
- TIME function used in Excel
- Reset Button in Excel?
- Eliminate Excel copies that have no file type
- IF with additonal Functions
- vlookup help needed
- Entering and Adding Time
- Syntax problem
- How do I extract just the month
- Beyond VLOOKUP
- Help on this formula
- IF problem using Solver
- Fixing a single cell reference keeping others dynamic
- SUMPRODUCT((A2:A210<>"")/COUNTIF(A2:A210,(A2:A210&"")))
- How do I delete data in worksheet, but not the associated formula
- Conditional Countif
- counting functions
- Return Consecutive Values - Pairs
- Problems with time
- How do I calculate # of weeks between 2 dates in excel?
- Equation and roundup in the formula bar
- Excel Formula Help
- IF, THEN formulas
- Number Lookup in Matrix
- Lookup Text in Comments
- How do I put a watermark under cells in excel and make it print?
- Pivot Table - Multiple consolidation Range
- *URGENT*
- Vlookup
- Help - Date Format
- Using Vlookup with validation
- create macro for learning purposes
- Changing the columns to copy
- Finding Bottom of Sheet
- conditional formatting
- Performing a function on a column of variable length
- Calculate APR from ARY
- cell validation
- Simple count function
- condensing information onto one worksheet
- Duplicated data
- trouble with date
- multiple substitutes
- msg box with finished time, please read
- scheduled hours total
- Current year function
- Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions
- Ignore Blanks in Data Validation
- Conditional Formatting lowest # if it only appears once
- yield function
- sum of a series of exponents
- multiple sheets vs. 1 sheet
- printing cells
- How do you work with drop down list to show a name, diff payment?
- Linking Pictures in Cells
- Reversing POWER Formula
- Text in Formula bar displays vertical in Excel, How?
- Finding the CI in t-test analysis
- check if value occurs within a range
- If statements
- SUMIF
- Nested If statement
- How do I import formmail data to a custom excel template?
- Complex query question
- Conditional countif
- Combobox Number Formats
- specify range name in formula with concatenated string
- Is there a function, if cell1=Text then cell2=#? Excel 03
- What does this formula mean?
- Quick question: What does "--" in an equation do?
- is there an equal fxn for 'InStr' in excel. Not Find or Search
- Need to remove hypens from typed in telephones (not formatted)!!
- multiple criteria then sum
- pdf conversion
- countif question using 2 conditions
- Data validation
- Sumproduct HELP
- List not omitting blank cells....??
- Keep autofilter after macro is run
- Telling the difference between zero and blank in IF statement
- Copying a Formula into Every other Cell In a Column
- Major linking problems
- Lookup function skipping columns
- Vlookup
- Invisible Text designation in cell?
- Open A Locked Workbook
- lookup a value on a table
- Subtotal and Names - Excel 2003
- FILE SHARING
- Subtotal and Names
- convert time value of 14.58 to 2:35 pm
- How to display hidden rows maybe defined by scenario
- IF function to change color of cell?
- In Excel, change phone from 555-555-5555 to 5555555555?
- problem with Array Formula
- How to copy and paste same formula in multiple cells?
- Excel should have a function to output T Stat
- I keep getting the message "too many different cell formats"
- Adding a Drop Down List to a Column?
- sortArray
- HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK
- In Excel: Paste Special should have a "Link Value" Selection
- cell ref
- how do i step thru a text field looking for 6 numeric characters
- sorting in order
- sorting in order
- Nesting 2 If functions
- HOW MANY 'IF CONDITIONS' CAN BE USED IN ONE SUCH USAGE?
- Using Match function with duplicate values in an array
- Can I enter a formula in a comment?
- =FORMULA(CELL(A1)) ?
- How do I print excel worksheets double sided
- average range function
- Lookup function problem (kg)
- Calculating working hours
- how do I switch from one window to another
- How do I stop rows from hiding when sorting a worksheet?
- return array result in cell based on comparing dates
- copy database to another sheet
- Formula please
- Counting
- Formatting a cell with a function (IF statement)
- problem tagging duplicate entries
- formatting a cell with a function (IF statement)
- Sequential numbering
- Question about seriessum()
- calculating the minimum value ignoring o
- How do I combine IF and OR?
- WHEN EDITING VALUES IN A FORMULA, IT DOESN'T CHANGE TOTALS
- help??
- calculating with dates
- School teacher
- Averaging different numbers of cells
- Sumif across columns
- If Statement Problem
- Help with week day count with range
- macro to change text to time
- updating a column in existing excel sheet
- extracting last name
- =Lookup()
- when I tab in Excel - it move two spaces instead of one
- Help to condense a formula
- PDF output with Cell as filename
- COUNTIF 2 conditions
- Using a formula to create named range reference
- Need Function Help
- Array Question
- Formula
- Automatic Quote Numbering
- Copy Data to Another Worksheet
- any way to redisplay column headings after page break?
- how to show row number in cell
- can I use GO TO results in a formula?
- how can i get excel to sequentially add numbers to new worksheets?
- Macro / Compile Error / Duplicate Declaration
- Allowing Data Entry ONLY???
- Counting text only
- Difficult conditional formatting
- Cell shows only formula, no result
- How to set up AutoFilters?
- How can I convert all Caps to first letter caps in Excel?
- How do I eliminate spaces/characters from the beginning of a cell
- How to randomely distribute non-numerical values across rows?
- How can I get excel to mail merge zip codes plus 4 correctly?
- Count OR Sum Or if
- Filter mode
- Trend Line - break
- Sales Chart
- Countif
- link formulas in excel
- #VALUE! Problem
- 2 formulae to go in one cell
- Round a number to the Nearest .25
- How do I add one number to all cells in excel?
- Excell - How do I "force" cell to be filled or return error mge.
- How to place a border on every page in excel?
- placing NOW function in IF function
- spreadsheet dropping leading zeroes when exporting from SQL Serve.
- 2005 Excel User Conference
- Table copied from Excel to powerpoint print all bold?
- my mouse moves diagonally when i scroll on mouse?
- MROUND function. Getting the following error: #NAME?
- VBA help please
- Can I conditionally format tab names in excel?
- Using = sign will link data between sheets but not colour. Why?
- SUMIF using two columns in both Range and Criteria
- Pivot Table - Multiple Worksheets
- Blocking specific cells
- Help with a conditional formula
- Schedule an xl file
- typing mistaken for date format
- Arrays parameters in Functions
- Time sheet problem
- Defining non worksheet specific names...
- Hello, Need help with time msg
- If Statement and copying all of cell contents.
- SUMIF positive values only from database
- Macro and Formula
- SUBSTITUTE(Outward!B5,"-","0")+0
- Pull data - Advance Filter
- How to make an exponential series?
- Pivot Table - Data Source problem
- If function with Vlookup
- Pass an array to Rank
- Function to return the current Worksheet name?
- to many 'IF's'??
- Links between workbooks and emailing workbook
- Difference between two Excel Date/Time Stamps
- How do I undo all Page breaks in Excel
- Migrating Locations
- Automate simple calculation/formula
- Vlookup with multiple criteria
- Divide worsheet and save as separate files
- Delete all rows where Column A contains Text
- How to change negative to positive
- IF on dates
- How to change a MS Word file to an Excel file
- Autofill type feature.
- advanced filter criteria "begins with" and "does not begin with"
- I need a formula to calculate shift differentials in excel
- Sum Function
- Custom percent format needed
- Mod 10 & 11
- Averaging/Rounding Equation Problem
- MIN or DMIN ?
- Microsoft Query
- Using other workbooks..
- Search for more than one word
- Pivot Table Question
- Excel 2002 "Protect Sheet", but allow "Hide Columns"?
- Excel 2002 "Protect Sheet", but Allow "Insert Comments"?
- How to show 2 MAX values in a list
- value of indirect cell
- Exporting from Access
- sumif - multiple conditions
- How do I import Names of Windows files into an Excel Spread sheet
- Finding the 3rd largest number in a list
- Change Cell Color if in current Month
- workbook sheets into separate files
- I have a long equation which I need to repeat 16 times!
- Trying to get the next date exactly 5 years ago..
- Formula with options
- sheet protection
- Complex if and mid function.
- how to count unique entries with multiple condition
- sorting and filtering
- How to type correctly formula in calculated field in a pivot?
- How do I filter based on color in Excel?
- Autofill
- Changing Positive to Negative
- Database
- Use INDIRECT function to reference a value in closed file
- Linking multiple data into one worksheet.
- Using ~ in VLookup function
- Weeknum
- popup message if certain criteria met in formula result
- how do i cumulatively add in a single column?
- Summing only coloured cells
- SUMIF Problem
- excel worksheets
- custom vertical footer?
- how to change margins for multiple worksheets in Excel?
- Avoiding typing similar formula 600 times
- Excel won't fill formulas
- template
- how do i add cells in checkbook register template with formulas?
- Hide empty field error
- Decimal Points
- pivot table selection
- Add on 10%
- Positions of Comments
- Using other workbooks..
- how do i rename worksheet to equal cell name
- Help with formula
- Excel 2003: can I insert a "last edited" date function?
- countif text formula help
- 2 ?, Size and copying?
- Vlookup or If statement Help
- Goal Seek On Members of an Array within Array
- Add-In: "HPVAL"
- Equal Sign Issue
- Need a function
- hilght cells at a give day
- IF statement help
- Re: How wrong can you be with your NPV and MIRR functions in EXCel
- hlookup #N/A
- Why doesn't the finance rate in MIRR impact the formula result?
- Trouble with dates......
- Cell shows only formula, no result
- Need Help With A Find Formula
- Is there a keystoke to navigate between worksheets?
- How to calculate/properly display significant figures ending in 0
- clear data from workbook
- Help with multiconditional sumif with range
- How do I insert a date created in a cell in excel?
- can I sum information in a list
- how to save and print information
- can I sum information in a list
- Returning a numeric value for text
- Using the Mid function.
- Date : =today()
- MATCH FUNCTION?...challenge
- SumIf help needed plz...
- template for check requests
- More Pilot Logbook Help....
- Page Number removal
- How do I eliminate leading zeros from downloaded data?
- Worksheet to Column Distance
- Count number of times a specific number is displayed in a cell ran
- Need "reverse" amortization; calculate loan amount
- dynamic, double vlookup, match, index, dget?? different workbooks
- place text seperated by a space in a column into seperate columns
- USE CONCATENATE function to connect 2 formulas
- Absolute Values
- Can I do this? =VLOOKUP(A4,D1,2,FALSE); Where D1 has "$A$4:$B$18"
- Page numbering for a whole WorkBook
- How can I prevent the "division by zero" error in this formula
- Need Formulas for counting multiple conditions
- Pull numbers from a cell
- Range Names
- Is this decent?
- IF Function maybe?
- I am trying to use get pivot data with variable criteria
- 2005 Excel User Conference
- Dependent Lists in Excel
- 6 or more conditional formatting
- How to get the data randomnly in excel worksheet?
- Conversion of Dec numbers to Bin, Oct and Hex and visa versa
- Problems with SUMIF function and Wildcards (* and ?)
- Can a worksheet pull from a specific cell value in a separate wrks
- how do I use variable column and rows using other cell reference .
- lookup with sheet name
- Problem with counting characters in a cell
- assemble link from different cells and return value
- Multiple Contional Formatting
- Get MAX value according to TRUE/FALSE flag
- automatic printing
- Only calculate specific worksheet automatically?
- Summing Values In Current Month Only
- Importing data into excel
- syncronize excel worksheets between laptop and main computer
- Character Search.
- 3 Time frame
- How can you use count with an array formula similar to using sum
- Adding values from previous worksheets
- I need information from a cell intesected by a column and row.
- =right and =vlookup
- Summing across multiple sheets with a twist
- column variables
- Need an excel amortization schedule formula with a grace period
- help NEEDED URGENTLY (I HAVE TRIED SOME SUGGESTIONS BUT THEY DONT WORK UNLESS I AM DOING THEM WRONG
- vlookup function
- A few questions if anyone has a moment?
- Functions which can be used any number of times in excel-2003
- How can I calculate flowrate?
- How can I calculate flowrate?
- Currency Converter
- LOOKUP VALUES
- Weekly Schedule, help create form
- Identify the contents of column in a filtered range
- Formula used to calculate daily employment hours ...
- Formula used to calculate daily employment hours ...
- How to subtract two numbers in excel ?
- Symbols in Data Validation List
- copy formula referencing sheet name to another sheet
- Evaluate string as a formula
- How do I maintain format of worksheets when combining several?
- How do I analyze data from a survey in excel
- How do I use = command on only first few letters or so?
- Time to text
- How can I edit in the spreadsheet viewer?
- set a date in columns 7 days apart
- how to auto increment a number each time i open the worksheet
- Drop list affected by previous choice
- Open template automatically
- Looking up values
- Function from sheet to sheet
- IF Function (I Think!)
- SERVICE PACK 2
- Sum values from diferent workbooks
- Spreadsheet functions
- Vlookup Count confusion !
- Problems with IF, AND + OR statment
- Separating Over/Short Amts.
- mulitple conditional formatting
- Embeded Cell / Object reference
- CHINITA
- Conditional Formatting
- How do I add data from two worksheets and display on the third Wks
- How to Concatenate with a text & number
- Referencing Columns in a Row. PLEASE HELP!!
- How do I change the colour of the 'filter arrows'
- How to subtract value in one cell from aanother cell value?
- counting specific words
- how to analyze freight expense?
- In Excel combine tables from multiple worksheets in to one sheet?
- Conditional Range w/Sum
- AutoFilter Failure
- Trouble with dates......
- Sumproduct...how to use *contain*?
- contents of 1 combo box depends on choice of another
- Extract multiple records matching criteria from list
- Layered "If" statement.
- Is there a way to color the cells based on the numeric value?
- Calling another workbook not working
- Can I use multiple criteria in SUMIF funqtion?
- How do I arrange worksheet tabs In alpha order
- Having trouble totaling columns in excel 2003, always worked b4
- Difficult look up formula
- * Character
- Graphing A Time Series of Multiple Stock Prices
- HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
- If statement where the logical test is a range that equals a word
- Finding Max values
- pleas help: sumproduct function returns #value or #ref error
- #VALUE!
- how do i look through worksheets in a workbook to find duplicate
- How do I convert a list of date of births into age in Excel?
- How do I use the wildcard character and the NOT function?
- HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT
- using dget
- Sum of Categories by Record across Multiple Worksheets
- sumproduct function returns #value or #ref error
- Convert a number of minutes like 400 into hours and minutes
- Formula question
- need help with a simple xls equation !!
- Excel workbook to be used by multiple users at same time....possible???
- Adjustable Scroll Stop in Excel
- Hyperlink
- Concatenating cells to produce a cell ref from another excel file
- Excel 97 freezes up when using hyperlink to another excel rpt file
- Unhide Pivot data tab
- Referencing a cell for a row
- Ctrl+Y not working
- Meeting two conditions before summing
- text in formula explaining formula not to print
- Can any one suggest code/formula for finding the CAGR
- Sum a cell within all worksheets
- Abbreviation for "Rear Derailleur" as "RD"
- Counting the number of cells meeting conditional formating criteria
- Update to : Pulling my hair out, need some help building formula
- formula
- automatic sort
- Generate Payment Statement
- help me out plz?
- "E" or "O" for the first, even or odd digit in a number
- lookup
- someone must how to do this. :):)
- Transpose formula
- Concatenate Multiple Instances in Array
- Find Median of Positive numbers only in Range
- combination of vlookup and match question
- Help
- ROUNDUP IN 0.2 INCREMENTS
- Cell Combining Question
- is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password?
- how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab.
- using time functions when hours are greater than 10000
- how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.
- What is this kind of average called?
- is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?
- Worksheet data function
- how can i get rid of duplicate records in excel?
- Parsing in Excel?
- Nested IF(AND is not working
- How do i check if something non numeric is in a range & return'Y'
- saving the format when emailing
- Summary of Max Hourly entries
- Display only surname
- Address from one worksheet to another
- Cannot protect worksheet if it includes a list
- HELP: Cell Value as Filename?
- Scenarios
- Need a formula that counts orders
- how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel?
- Extracting from a text string
- Counting cells with intervals
- Format text in one cell based on value in another cell
- is there anyway in an excel macro to reorder the sheet tabs from left to right?
- in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell?
- automate creation of sheets in excel
- dget function
- Sumproduct
- How can a formula in a cell automatically update when inserting a.
- copying subtotals in Pivot tables
- I need an Excell formula that will add x$'s every 30 days
- highlighting required fields
- Help creating dynamic refrence cells
- if greater then 99 then 1 if greater then 199 then two
- RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE
- Copy data in other sheet
- Excel subtotal group sort
- Create a pick list to use to go to a text cell in Excel
- Conditional Formating
- IF Function
- Control Toolbox
- Dynamic Formula?
- Result in Cell is Wrong
- need Excel function like INDIRECT but can't open all spreadsheets
- Formula for Colin F
- How can I make a cell mandatory and only accept a Y or N?
- Excell linked to outlook contacts
- calculating hours
- If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
- Moving formulas
- lists and validation
- The ROUND function
- Trend Forecast Help
- not equal to zero
- Help with Formulas please!!!
- "E" for even numbers. "O" for odd numbers.
- COUNT IF NOT EQUAL TO ZERO
- Realtime Automatic sorting of data in rows in new work sheet
- Setting a reminder up
- Conditional Format to highlight blank cell
- How to represent an empty cell in excel formulae?
- an error.type test
- Problem with function "Worksheet_Change"
- Sumif where sum range is more than one column?
- How to setup a hyperlink to an indirect function?
- Autoexec Macro
- Display count of rows
- find and replace cell reference to a new worksheet
- Help with Excel Macro.
- I need to return the name of a worksheet in another worksheet cell?
- How do I calculate APR for interest-only loans
- How do I allow users to make a choice in a worksheet?
- Ref from table - complete
- Ref from table to cell
- How to match sort and lineup 2 sets of data
- Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)
- julian dates in Exel
- Matching Date From Two Groups
- Help creating single cell Pop-up
- Sorting dates
- HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL?
- Semi transparent chart fill
- Another of Excel's idiosyncrasis
- left click on a cell and more cells are highlighted
- how do i MAX to display the person who got MAX
- How to dynamically reference a dynamic named range
- Worksheet e-mailing
- Cell Calculations
- conditional formatting
- format cell to recall client name
- how do I customize product sales pipeline management template
- IF function
- How to link cells in seperate spreadsheets without the $
- Improve visibility of Excel AutoFilter Filter selections
- Converting a link to values to multiple cells.
- Adding cells based on condition
- Compare 2 columns & format row
- Array Function Question
- Counting Across Multiple Ranges, Based on Condition
- Is there a template for creating outline in Excel as opposed to W
- Lookup help needed
- Function to find row with most current date
- Find min/max in 2 combined columns
- Appending excel worksheets
- Pivot Tables
- Hyperlink-Programable replacement of Text with Its Actual Address
- I want to use if based on two cells (if... and)
- How can I put the median on a pivot table?
- IF Function returns False instead of 0
- Extending a balance sheet
- Global Replacement of Test to Display
- Copy down
- Need formula to count number of books sold
- Auto dates
- SumIf based on two criteria
- Cond Format:re color 2 cols, skip 2 cols
- Hiding columns using a formula
- Limit to the number of items in a cell
- VLookup
- format cell to capitlize
- Auto increment over multiple worksheets
- Problems with PULL function, INDIRECT.EXT and so forth
- Lookup Match
- RIGHT of character
- Problem adding a range using Sumif function.
- Year-to-date return
- countif question
- Prevent A Macro From Running If SpreadSheet is Filtered
- Comparing data on 2 workbooks
- Calculating starting balance
- Compare List and Show Mismatched
- Data from closed workbooks (pull func, indirect.ext, etc ....)
- How do I setup criteria in DSUM to sum values NOT equal (<>)
- How can i get autoformat name of range in excelsheet?
- How can I convert an 8 character Hex word to binary for a lookup?
- Get aveages for last few days
- problem lookup function
- Problem with nested IF_OR statement
- Help! Need Product: Feet/InchesXFeet/Inches=DoubleDecimal SQ.FT.
- Match and Concatenate ??
- IF from a range of cells
- Still could use help on a tough VLOOKUP
- RE: Roundup to the nearest number that is divisible by 3
- How can i count pasted values in Excel?
- Array Formula, noncontigous range
- large spreadsheet
- How do i unlock protected worksheets?
- function to show if two fields in a column have the same data.
- Formating the text of a formula?
- If OR Vlookup???
- =IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
- Re: replace "#DIV/0!" error with blanks
- Excel Function to Match Power Trendline in Chart?
- Attachments
- VLOOKUP function
- Insert Animated picture like GIF
- totaling difficulties
- Return a unique value
- export excell data as xml
- Loosing Zeros
- Loosing Zeros
- count no. of entries in range for a day
- How do I get stock quotes in Excel without text?
- Formula indicator in cells???
- Copy Code Needed
- number increase by 1
- Pulling my hair out, need some help building a formula
- skip blank rows when pasting formulas
- HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT?
- countif
- How to write a formula that will prevent appearance ERROR MESSAGE
- Sharing of one single Excel file/workbook
- Simple formula help
- Simple formula help
- Conditional Lookup on Multiple Criteria
- Pivot Table
- How to sum the last 5 non-blank cells in a row?
- LookUp and Concatentate
- Lookup Issues / List Auto-Adjust
- HELP - Room booking spreadsheet hell
- if function that i dont get
- CountIf function
- Sharing a workbook
- Pivot Tables
- HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL
- summing up daily data in a monthly compilation
- how to merge 2 worksheets and highlight differences
- Need to Count number of occurrences and get percentage of total
- IF Functions
- how do u copy a formula in over 100 cells and have it adjust
- Can this be done?
- Using the IF function
- remove a drop-down list
- How do I hide rows in excell 2003, and see the + sign to open?
- how can i test whether cell contains keyed constant or a formulae
- finding an answer
- How to filter on a date field during mail merge
- Transfer A Row From Sheet 1 To 2
- Macro to omit blank cells needed
- Finding possible sums to match a figure
- How to change outline when tracking changes in Excel?
- Indirect, Concatenate, & ?
- cell pointer content Info
- EXCEL
- add "0" to the beginning of each value
- convert 500.00 to Five Hundred
- i change a source and the other cells wont change
- match multiple criteria & return value from array
- Date calculation
- Loosing Zeros
- Rounding
- Formula to count number of days in range which are less than today
- Out of Ideas, need help with Auto Fill
- select records with a specific value
- List Unique Occurences and Count
- Find first data
- convert numbers to text.
- Function or formula needed
- Problem with Frequency() formula
- How do you convert (change) a column into a row?
- Sheet(Array( Won't print as I expect it to
- validation rule
- formula to calculate the average of a range basing on condition
- Need Help with an IndexMatch
- Problem writing Excel formulas via ODBC
- I NEED HELP with the SPELLNUMBER Function
- CHI SQUARE TEST
- Need help with RANK function
- Lookup data from multiple sheets
- EXCEL: FLOOR/SPACE RATIO CALCULATION
- getting name value in cell from If formula
- Currency format
- Summing with multiple criteria
- for each problem
- More- AutoFill with Non-Seqeuntial Cell References ?
- Why is XL lying to me??
- My formula does not work!
- filename pointer
- intellimouse
- OR & IF Functions Together
- How to input additional text to multiple of existing cells that has text
- Multi Criteria then sum
- My formula won't work
- Averaging and Rounding problem
- Random Name Generation
- Is there a (non-binary) "if x then enter y" forumula?
- How do you copy RANK w/o it changing the range?
- Is there such a function?
- Delete rows if Col C has a 0 value in it.
- Nested if
- Links to 2nd closed worksheet fail when using offset function ??
- Adding a fixed date to a cell
- Combo Box
- Excell Workbook problem
- ytd sum by selecting month
- XIRR function
- IF statement with lists and dropdowns
- Compound Rate of Return
- Formulas dealing with text data
- have value in A1 & want value after 20 cells is it =a1+20 ????
- Underlines with autosum
- &[Tab] is available as data in headers but not cells?
- Checking that any cells are null
- concatenating cells with their formats
- Formula syntax {;;;}
- Non zero weighted average
- Largest Value
- PRINT MORE THEN ONE WORKSHEET
- i want to use the =if function to apply a colour to other cells
- Countif for multiple criteria
- Exce Hide / Unhide function
- Sorting Account Numbers
- Brake & Move Columns
- Calculate 52 weeks
- How do I count two variables in different columns in excel?
- automatic printing
- Creating a bar graph manually
- Hyperlink referencing
- Copying selected rows to another sheet
- Filter Indicator on Column top should be white, not dark blue
- Checking for empty cells in a range
- locking cells based on results at runtime
- SUMPRODUCT help
- Getting External data
- CREATE LIST OBJECT IN EXCEL
- How do I compare in between two worksheets?
- how to set up one cell that assigns a value based on the value of another cell
- Another rounding issue
- SUMIF Alternative?
- Fill down error for Vlookup
- Need help with reverse phone lookup
- Dynamic reference to a sheet
- how do you use the text function?
- round up in own cell
- Copying into ranges
- AutoFill with Non-sequential Cell References ?
- filtering dates
- how can convert 15 to Fifteen
- Excel Analysis Add-in EOMONTH generates #NAME? error
- How to tell if cell contains a FORMULA or user-entered number?
- soduko
- Need Excel Function that will return # of char in preceding cell
- Search/lookup/cell reference
- prevent more than one value in a cell
- date/time stamp
- " "
- General Question
- Conditional Validation - Using a "part-time" drop-down list
- how to use the Prob function in a list of averages to find the le
- Windows cant open excel spreadsheet.xls?
- download will not open in usable form
- How do I assign a text value to a variable number of rows?
- Match Function
- VLOOK
- SUMIF function retrieves "0"
- how do i setup a running invoice number in excel
- if then statement color coding (or another function???)
- formulas
- how can i calc averageif
- Excel Formula/Worksheet maybe Macro Question
- Using color in lookup
- Adding an AND Statement to COUNTIF
- formula to find and flag dates older than 30 days
- Cannot get CUMIPMT to work in Excel
- hyperlink functions
- use sumif with array
- Drop down lists are displaying end of list, how to make it top?
- Sum if statements with conditions
- HyperLink Function
- help please - trouble with sumproduct function
- Removing Duplicates
- Worksheetfunction.vlookup and #value error
- Need Help Computing Workdays for a project
- More time questions and IF function problem
- hiding worksheets
- The { formula } type of formula
- help please - complex countif, etc. functions
- Problem Assigning Macros
- font size changes w/ control focus
- Did not see any reply from yesterday. Need data formatting help
- Cross workbook referencing based on cell input
- How can I add up how often certain text occurs?
- SUMIF over multiple columns
- Filter range of only active cells???
- Sorting an Address List
- If function help