- Indirect
- Subtracting dates
- how to select random rows?
- Adding min, max, avg to charts
- Re: Formula Layout Excel
- Using a sinlge "Variable" across spread sheet - Maybe simple
- Linking Excel files
- excell 2002 sort function
- Method 'ActivePrinter' object_applicated failed
- Strange problem - probably simple fix.
- Freezing a value in a cell
- Formula for colored numbers in a cell
- Re: Formula Layout Excel
- Format Social Security Number as Text
- Reference WorkSheet Name
- Text Validation
- Disable File, Edit, View, etc. command bars
- changing field properties on a linked table
- excel
- SINGLE CHARACTER DELETION
- Values returned by VLOOKUP
- MATH HELP!
- Or Formula
- Help I need to resolve this by 10:00 GMT 17th Mar :o(
- VLookup Function
- Dedupe Function works/works not
- Toggle Buttons - off and on controls
- excel worksheet
- GNU GSL & Excel
- How to tell the difference between a zero and a blank cell value
- setting the end cell
- Criteria induced column coloring
- ranking
- Convert WEEKNUM into last day Date
- Move data from one column to another
- Using MODE in Pivot Tables
- Nested LEFT/IF statement
- Summary worksheets
- TIME CONDITIONAL
- Is there one Larger???
- protected sheet won't execute macro
- Commands Functions
- "Convert" error
- stopping find and replace
- Add every 7th Row
- creating a list from an existing list
- Calculating rate per hour
- countif
- show last saved time?
- countif
- Return Reference to VLOOKUP
- fractions
- Count between the nubmers
- Re: return range of cells based on conditions
- Count specific information in a certain range
- Re: Count? Summarize? Lookup? Match?
- transposing within a list
- Re: Count? Summarize? Lookup? Match?
- Statistical Functions - Expected Value?
- lookup question
- basic Autofilter question
- an IF formula needed
- How do I get totals to carry over to the next wooksheet in a work book?
- Oh no~ I set a password and forgot
- DATEDIF generating error
- Vlookup- truncate?
- -- before an argument
- also about date
- Linking worksheets
- Range Labels connecting multiple files
- Help with functions
- HELP - difference of Average and median
- Filter help needed
- if statement in a macro
- Month to date (MTD) calculation
- EXCEL
- Change Order of Values in a Pivot Table Column Field
- Using Find & Replace
- Minimum in which year?
- FORMULAS
- vlookup? index? match?
- Cell Protection
- New document formating
- Format text
- Index calculating
- Find text in a range of cells
- Counting the numbers in a formula?
- Conditional Unique Number Count
- How to display value in a range with a specific format
- converting amount of seconds to mm:ss format
- Formula results in dreaded #VALUE!
- Formulae exceeding 1024 characters
- Conditional Formatting More Than Three Conditions
- is it possiable?
- Conditional Formatting
- Linked Data
- Automate Merge process on a shared workbook
- HTML IMPORT
- vlookup difficulty
- LIKE Function Available in Excel?
- Need a function/suggestion for specific spreadsheet task please.
- Sharing a worksheet- Help
- Top Ten average (conditional)
- Help in Formula
- formula application to cells
- Yield Function with Monthly Frequency
- Re: SumIf with conditions
- Yield Function with Monthly Frequency
- Arrays to return a written text and numerical values
- Filling in blanks in a form
- Duplicates in a list
- MODE calculation in Pivot Table
- Formula/function to eliminate duplicates?
- Re: Variable Named Range
- Linking Data Between Multiple Files
- Rounding issue
- How do I keep add-ins on the tools menu?
- KPI spreadsheet help please!!!
- Need Help With Excel Formula
- How to nest SUM function in LOOKUP function?
- IF Function based on Autofilter results
- Seperate First Last name from single cell
- time/date stamp
- incorrect date
- Work days
- =ALEA()
- How can I alphatize my worksheets
- converting date to day
- Count number of chars or digits in a cell? Parse out last char?
- Using COUNT in a spreadsheet
- HyperLinks On Excel 2000
- copying custom formated #'s
- Conditional Formatting
- relative address
- No pasting Hiden Columns
- Re: Sumif over multiple pages with two criteria
- Re: Sumif over multiple pages with two criteria
- Sumif over multiple pages with two criteria
- cell reference
- Remove letters from pasted data
- Re: Merging worksheets and finding duplicates
- returns cell reference
- conditional formatting triggered by macro
- IPMT Function
- Excel VBA-conditional statement
- VB codes
- Reference to a nonexistant worksheet
- count Students' Grades
- numbers not adding up
- ole
- Changing a formula's result to text output
- IF Function
- Time card calculations in Excel
- multiple conditional counts
- Interest
- Multiple if statements in one formula??
- me operator
- CountIF Function
- Drop down lists & formulas
- 3-D cell reference returns 0
- Seconds to Minutes to Hours
- Create an autofilter routine
- Circular Reference for inventory
- Header/Footer field for User?
- Import Excel Into Access
- How to use a specified date by user and output it in another cell using if statement
- Excel Function Help
- Advanced Filter Problem
- Excel 2000 Setting first sheet active
- Window ce excel spreadsheet
- How to get time code serial number
- Automatic Sorting
- Simple Standard Deviation
- How do I get Excel to put in the date at the end of the month? (So I can calculate invoice amts owing)
- Countif & wildcard formula error...
- lookup function problem... :(
- Re: Date & Time Format
- Newbie question
- Subtracting numbers
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- Find the First Date entry for a given month
- if calculations?
- j-walk excel 2003 review
- Data Sort
- Quick Question
- nesting formulas
- Copy Spreadsheet between workbooks with out links
- Change actual value to formatted value?
- using transpose function
- Help with formulae/condition please
- Changing multiple reference links from one workbook to another
- Copy Values Without Opening A Sheet.
- What is the meaning of both formulas
- Write a formula that can look up and match a specific number and return the results for that specific number
- Advanced formula question
- Colored A Tab Of Sheet
- calculation across different columns/cells
- Sheet name in formula
- Naming Ranges
- Naming Ranges
- Converting Excel to Lotus 1,2,3, Release 9 files
- Criteria in Advanced Filter
- Auto Sort
- Sorting
- vlookup question
- Limit of number of selected cells
- Disable Command Bars
- #N/A
- Re: FORMULAS
- Update with time
- Format function...I think
- Blanketty blank rows
- Relative Reference to another sheet?
- adding worksheets
- VLOOKUP Error
- $1.00 as "One dollar"
- conditional sum based on range headers
- Disable Button Macro Command
- VLOOKUP and wildcards
- Protecting selected Worksheets at Once
- "strike through" option???
- Display List of Tabs
- Sorting in same column by 2 critieria ?
- Excel file size grows
- Only Formula shows Not Results
- Enter Numbers as Text in Social Security Number Format
- Formula across multiple sheets
- Re: RE: Write a formula that can look up and match a specific number and return the results for that spe
- Button Click
- Data Validation
- Counting appearances in ranges
- Text Formats In Formals
- Re: Data Validation
- vlookup, IF or Match? or is a custom function required?
- Inverting order of rows
- How to combine multiple cells into 1 cell with comma between each number
- Lookup Macro?
- MSQuery in Excel question
- Need a formula to add 2 weeks to a date...
- Re: Data Validation
- Cell formatting
- Look up problem
- combine dates
- EXCEL if Help
- Client Stats
- RE: FORMULAS
- lost worksheet
- Dialog.Box and drop-down list boxes
- Trouble with "if"
- Multiple if or sumproduct?
- Custom formatting cells
- Force a negative value
- Data Validation in =IF()
- Pivot table filter field entries
- Can't return Query
- OFFSET Function
- Excel's Potential for Teachers
- Compounding problem
- Link Max formula in workbook please
- Please help with FILTER problem
- printing headings on every sheet
- IPMT Function DOESN'T WORK!
- how to stop the rand() function
- Highlight Selected Cell
- Excel and Word together
- How to automaticly move to another cell after entering more then 4 digits to one cell?
- Excel Formula/Function
- Cell runs a command or macro
- Sum of Every Other cell
- percentage
- Comparing data in columns
- No date in cell
- Incrementing within a Cell
- How does this work?
- CONCATENATE and spacing problem
- Forcing text format
- Dropdown Menu in a cell
- Inserting Row in Multiple Worksheets
- SUMIF & OFFSET
- Re: sum of selected cells in a range
- Re: sum of selected cells in a range
- Hard Formula
- joining rows in Excel
- IF help
- Find last non-zero cell in a range
- Divide "Name" into First & Last
- Return value based on number of letters in cell
- Delete a letter next to a number
- Create multiple rows of Worksheet Tabs
- Paste and cut to a worksheet with column validations
- Selecting empty cells
- Date Formula
- Conditional concatenation in VB
- Red Asterisk at line 500 inside a sheet
- linked WorkSheets...
- Re: Sports Schedule
- Re: Sports Schedule
- Nested If Question
- What If Analysis???
- circular reference error
- date in comment box
- If statement
- excel not accepting formula
- Time not Date?
- Lookup
- Column Width
- Sum column of numbers based on date in another column
- Formula request please
- SUM + IF function
- Last entry in a column
- Average of every other cell
- Personell Coverage in a timesheet
- COUNTIF Problem
- Re: Working out average of every other cell if....
- Average
- Re: Filter rows for text
- How to fix the cell value
- =SUM(OFFSET(D14,,,1,D24))
- NOT <> function
- Conditional Formatting
- Return Value Of Current Cell Position
- Counting cells which contain a specific word
- How was this done....
- if / substitue ???
- compare columns
- excel format issue
- Copying formula
- Any other funky stuff?
- Match Part of text in a cell and "sum"
- comparing data
- Linking cells or something?
- calculating units
- Data from Column into another worksheet
- if (true) (false) function
- Excel- Inserting a varying number of rows
- Substituting #DIV/O! for blank
- pivot table on protected sheet
- Test only
- Sumproduct and zero's..help please
- Calling all MVP's
- Can you amend this formula?
- Copying a Formula from NotePad to Excel
- Excel IRR Function
- Calculating hours between a shift time to include core hours only
- Changing a Cell Value in Multiple Sheets
- Returning a value from another worksheet
- protection
- Transpose Problem
- Desktop Wallpaper
- pretty print
- Formulas
- How to customize right-click menu on Excel?
- Find Last Cell For A Named Range
- MAX with Text and Numbers
- count number of values using countif
- SUMIF function. need help!!
- #DIV/0
- recalculating and updating
- Is there a way to calculate UNIQUE data?
- Using SIN in Excel
- how to get merged cell values to unmerged cells
- hyperlink
- Lost Cut function
- Count if...
- How to get excel to find the numbers of times 2 numbers appear
- activecell - transfer value
- charting weight
- Pivottable conditional format
- activecell - "x" in adjacent cell
- Comparisons
- Comparisons
- To Frank Kabel
- data in a cell
- Another SIN Problem
- Date Function
- Automatic Relinking Function
- macro that will insert today's date
- How do I match one column of data to another when they have a different number of rows?
- Display Only Last 4 Characters If A Cell
- Trying to put text in on a condition
- Deleting hyperlinks
- How Do You Call Several Named Ranges From A Named Range
- Removing of preleading character in a cell
- Using Countif ? to count number of rows.
- Excel Search Problem
- DISPLAY CONTENTS OF ANOTHER CELL
- Sum of several sheets
- Text in row odd, text in row even
- Make Countif Work Like Sumif
- How to avoid the file that conatain macros
- Mailto Hyperlink
- Problem with sorting
- Merging worksheets in a workbook
- In solver, linear regression
- hlookup or index/match?
- If then statement using text that changes
- display textl based on vaule of another cell
- Calculating rows with "a,b,c" type of data? Possible?
- Question on Date Function
- Conditional Formating a Row
- Format a cell as a percentage without showing "%"
- Summing fields on dual or more critiera fields
- add in, specifically "filename" function
- Disable Ctrl and/or Alt Key
- Limit number of characters in a cell
- date row last modified - debug
- Combo Box Format
- Still not understanding how use IF...AND
- LOGO
- Showing billions in a value
- Date & Time merging
- Help With A College Project
- Time difference
- General Function Question
- All cells in wksht to be multiplied by B3 (canadian conversion rate)
- Pivot Table - fill in the blanks
- vlookup
- Help with IF formula
- ROUNDING TO THOUSANDS
- autocorrelation of data
- setting up a search function
- Filter .... sort of ...
- Define formula
- Average Duration
- CountIf
- FYI
- Calculating rows with "a,b,c" data? Possible?
- What the heck is Sin-1
- Formula needed
- Formatting Column ??
- Need Solution
- Re: Add dates excluding weekends
- Is It Working
- Need To Make List From Columns
- Buttons for macros
- Ranking
- Checkmark function
- Re: #n/a
- Fixed Decimal
- Re: #n/a
- AVG If w/multiple criteria
- countif multiple columns
- Drop Down List
- auto filter problem
- Saving an Excel spreadsheet as pipe delimited.
- Lost my menus
- Help! I need a formula or 2
- validation list in multiple worksheets in a single workbook
- Excel Formula adding 45 days
- Default opening to certain sheet of workbook
- Creating a less than or greater than formula
- Defining week number
- Formatting cell colour dependant on result...
- Ctrl Alt F9
- How to stop continuous mouse scrolling
- New problem - probably a simple answer!
- vlookup and hlookup mix.....
- Is it possible to use dynamic Sheetnames?
- Protected Sheet
- DatedIf worksheet function to calculate %
- =SUM() inconsistency, Can someone explain this to me?
- Shared Workbook problem!
- Found a value on another sheet and change color
- writing criteria in access and using pivot in excel
- converting from US to EURO date format
- IF Function
- Syntax Help with IF/AND Statement
- Active cell in sorting
- Spelling
- Vlookup quit working
- Week Function
- date syntax
- Is there easier way to match data?
- subtotals
- Type over words
- Run Macro on sworkbook open
- 24 HOUR CLOCK MATH
- =counta
- Locking Worksheets
- automatically generated numbers
- automatically generated numbers
- Comparing and matching data of two columns not of the same size (countif?)
- TIME() function - Fractions of a Second
- Return Last Value in Column
- How to determine duplicate records
- Lookup or Dget?
- SUMIF problem
- Determine duplicate records
- how to link workbook to invoice?
- absolute value
- Create Live Reference
- Text before a Number in the same cell
- Excel XP - Multiple workbooks problem
- Rounding to fixed values
- sumif criteria rules
- conditional formatting question
- Deleting a formula, but keeping the data
- Can entered text produce numbers in another cell?
- help
- Subtotal Not Working - Over 64000 Rows
- Insert worksheet AFTER current?
- Re: P.O. Auto Numbering
- Re: If a value is 0 then the change is 0
- Re: Auto Number a P.O.
- Re: P.O. Auto Numbering
- Re: Auto Number a P.O.
- look-up
- Re: Auto Number a P.O.
- removing empty cells
- How to populate null cells with a zero
- cell numbers in sequence
- countif with condition
- weighted percents
- excel2000
- Formatting numbers that aren't recognized
- please help
- complicated Excel record association formula
- VLOOKUP with 2 criteria
- Lookup with Data NOT Sorted
- To Choose Vlookup Or Any Other Suitablle Function - Urgent
- text=number
- Randbetween Function
- Summing columns
- Running a MS Project Macro in Excel
- Re: Calculating right placed negative signs
- Transferring data to another "sheet"
- Ghosting or scroll lock
- Adding Text
- Add text in front of value
- compacting/expanding lists
- IF works - nearly!
- Re: Date calculation
- multiply time with hourly rate
- count characters in a cell
- Inventory
- What Function to use????
- dynamic criteria
- how do i creat batting averages
- help with formula
- Object Error 424
- VLOOKUP TEXT
- Mins and Hours totals not working properly
- Macros
- Conditional formatting
- Named Ranges
- Worksheet name from cell contents?
- Convert Date
- How do I change '#N/A' to a value so I can sum a column?
- help with counting rows with conditions across >1 one column
- Note
- need formula/multiple worksheets
- SUMIF
- Headers
- Buttons for Macros
- Look for an excel formula
- Cell CODE equals #VALUE!
- COUNTIF Help
- Custom COUNTIF
- Spreadsheet File Size
- Spreadsheet File Size
- Formating negative numbers
- Excel: Templates & Databases
- Re: Spreadsheet File Size
- Sorry
- How can I get my formulas to update automatically without pressing the F2 key?
- Blank Cell Function
- Data Analysis Regression Equation
- Significance of =+ in formulas
- please help
- my concatenate is broken
- Recent Microsoft Excel Updates - March 24, 2004
- Help with formula #value! Error
- Vacation Accrual
- Change Default Pivot Table Summary
- Change View SIze on all Worksheets at once
- counting Non-text/Non-numerical entries
- insert rows into a "referred to" worksheet
- Re: Identify and count unique numbers in a list.
- cross-sheet lookup
- Re: VLOOKUP with an IF condition
- Convert Number to Text String
- lookup
- template
- Coefficients of Quadratic and Log Fits?
- Can Vlookup retrieve a range of cells from source to target sheet or any other fx
- drop down list / combo box
- drop down list / combo box
- Column letters replaced with numbers
- cal. pay with overtime
- NPV, IRR, and MIRR help
- feet/inch to decimal
- Find
- Workaround for disabled AutoFilter when sheet protected
- What got changed on my defaults
- Pivot Tables Calculated Fields
- copy entire row based on a condition in a column
- auto entry of month
- Resetting "End" "Home" After Deleting Rows
- keep records
- What Am I Doing Wrong?
- Re: blank rows
- Re: blank rows
- Re: blank rows
- Interactive Sheet Pages
- Rightmost Column won't auto-fill like all the others.
- How-to Not show if balance hasn't changed?
- Formula with a blank cell
- MS-Office 2k to Office XP Pro..help with Macros please
- How do I link to a blank cell without linked cell displaying "0"
- Can A Macro "Add" Content To A Cell Without Replacing The Original Content?
- dotted decimal ip addresses in excel
- PRINTING SELECTED ROWS ONTO ONE PAGE
- Formula
- Finding Smallest, 2nd Smallest Values
- Sumproduct
- Compare worksheets
- Office 97 - Record Macro
- Back to basic? How to sum?
- Adding Values
- IF ISNA VLOOKUP problem
- Convert workdays to calendar days?
- Automatic Page Numbering
- Absolute worksheet referencing
- Can Vlookup retrieve a range of cells from source to target sheet or any other fx
- HELP PLEASE !
- Cut and Paste Subtotals
- Vlookup and VBA
- Advanced Filter + auto filter
- Conditional Sumif Problem
- areas and centroids
- Re: Function works opposite than expected
- Functions as text instead of formulating
- Re: Compare worksheets
- Autofilter/filter in Excel only shows 1000 rows in dropdown list.
- row separation
- Inserting an explanetory note in a cell
- Sumif values depending on dates
- Auto Calculating Net Profit and YTD Profit - How?
- VLOOKUP
- Superscipt note in a cell
- Re: Can I use Excel for reconciliations
- Why does < and > remove text in a worksheet
- RE: Can I use Excel for reconciliations
- How can I make excel move an Item from one sheet to another automatically
- comparing data
- Cell range copy to second workbook
- how to delete space
- Microsoft Excel Queries
- Minimum? Formula
- conditional sum if
- Automatic Dates
- Nested Countif??
- Recoding large data sets
- Defined Names in an If Statement
- Inserting a Map into Excel like in Excel 97
- name box
- Counting w/ multiple criteria using named ranges
- Color range from other sheet
- Fill Zeros
- Running Balance show at top
- Control End
- Filtering data
- Re: copying formulas
- Re: copying formulas
- Excel VBA - Copying Sheets to Closed Workbooks
- XNPV and XIRR
- Calculation
- function to place page number in a cell
- VLOOKUP - Multi Condition
- Storing Data
- copying formulas
- Thanks - now how do I store my data?
- Separate First and Last name from one cell into two
- table look up help!
- Re: Array formula and autofilter
- Excel mouse lock?
- Add format and value to the # "0"
- Conditional Formatting on DIFFERENT cell
- COUNTA - date driven
- Decimal Place Problems
- Re: Read only conversion
- Multiple condition COUNTIF
- Colum comparing
- Help! How do you merge two Excel spreadsheets?
- Worksheet for team Comparison (Testing a Text Value)
- programs and softwares
- negative number
- Sub Worksheet _Change()
- headers/footers
- Calculation pt2
- ACCRINT
- Paging David Braden Re: Regression
- To Combine Two Or More Pivot Tables Into One
- String Length functions in a worksheet help
- SUMIF/COUNTIF w/ Dates
- printing excel spreadsheet in word
- Multiple conditions in a COUNTIF function
- Re:compare to array in another workbook and record results
- one time calculation for a cell
- Converting Text
- Re: Percents
- Sum; If; IsText
- When I sell an item, I want the cost to appear in a cell
- Parse a string in VBA?
- Conditional Formatting on Different Sheets
- Exists
- Multi-Conditional SUMIF
- "insert proof" VLOOKUP & HLOOKUP ?
- if statement help
- Percents
- Help finding out if a set of values exists in a larger array of values
- Maximum number of worksheets in workbook
- How to get Excel to email changes upon Exit?
- Alternative formula to HLookup
- Multi-Table Multi-Condition CountIf
- Hyperlink for worksheet - syntax error
- Pie Charts - Percentage & Value
- Changing a value's cell to trigger an event i get a loop
- Jumping to a reference cell
- Russian character set question
- Re: automatic date entry
- Rounding up to nearest 5cents
- entering data without duplication of supplier names
- Next Value Ignoring Blanks
- Function For Auto Filter / Predictive Text
- dividing 4 decimal places and receiving inaccurate results
- SSIA Investment
- Formulas
- Checking each cell for a value prior to calculations
- Copying Cells without changing data
- Re: Repetitive Values or Text
- COUNTIF with more than 1 condition
- Detecting Formula Result
- Splitting Value
- cant create new rows
- countif and vlookup
- Count by criteria
- Count by criteria
- AVERAGE function
- Macro buttons ...help please
- Percent of total
- case sensitive comparison in sumif/countif