- wildcard characters and if statements
- creating drop down lists
- count, frequency
- Excell and use of resources
- Calculating a rolling calendar year
- Re: listing cell values
- Increasing numbers by day
- sumproduct worksheet function
- Average formula
- How to calculate total hours
- IF Statement
- moving text in cells when scrolling
- Using FileOpen
- Calculation the of week out of the year
- member lookup
- Inserted Word Doc in a Worksheet
- Absolute cell references across worksheets
- SUMIF Question
- Excel import into Access97
- Re: formula's contribute alot to file size
- Re: formula's contribute alot to file size
- Re: formula's contribute alot to file size
- Sum and Vlookup Array Problem
- Problems with a SumProduct Calculation
- sumproduct again
- Adding to part of a number
- increase day by day
- increase day by day
- Calculating dates
- button with hyperlink
- numbers default to date
- FUNCRES.XLA
- Re: Linking Excel Comments
- Find MIN value in filtered list
- Excel Date Formula
- If help please
- Pivot Table Top Filter
- >= formula not calc as expected
- Return characters left of a dash
- limits for DSUM( ) ?
- Linking formulas
- AutoFilter -- Indicate Value of Condition
- Command Button formula determiner
- window menu showing files.
- Re: Linking Excel Comments
- How to Calculate APR in excel
- Print Macro needed
- Date Help Please In Excel.
- How would I....
- How would I....
- Re: Count incidences of part numbers
- Formula linkage between files: Update
- Re: Count incidences of part numbers
- Re: Count incidences of part numbers
- checking name of file
- desperate... trim function issue...
- VLookup with Offset Function
- Pls help me
- Excel 2000 Problem
- Time question
- Help with IF Sum Function
- columns
- Entering data in cells given a certain date
- Meaningful averages
- Excel 2003
- Re: Linking Excel Comments
- Protect my Formulas from idiots
- Formatting
- easily linking cells from various worksheets
- Automatic data entry
- Matching and highlight cell with colours
- Need Help
- How to identify and mark duplicates
- identifying unique values
- Lookup and highlight matching cell with colours
- Lookup and highlight matched cell with colours
- Worksheets
- FWD: Taste this important patch from the MS Corp.
- Help with Lookup and Match Functions
- Random Number Generators
- formula for daily consumption
- Date formulas (date + no of days to return date mon-dri only)
- Newbie: How to rename the application window label
- Working w/ Date and Time in SUMIF
- SUMIF w/ 2 Criteria
- Vlookups and dates
- Auto Fill Series of Dates & Times
- Loan calculations
- SUMIF With Two Criteria
- Display 00:00 in time field
- Get workbook version
- If functions
- Second of Two Conditional Formats Not Functioning??
- A sorting question
- Displaying Auto-Filter Conditions
- Multiple worksheet editing
- spinners
- Should I use if-then function?
- Returning Top Results
- lookup
- Relative worksheet references
- Max Reference func?
- Funtion Help
- V lookup
- Embedded IF statement in an IF()
- To Fran Kabel
- Changing text to a date
- Problem With Exporting To Excel Using ASP
- Sorry if this a repost
- Excel Formula
- Can't delete a button
- Re: 3D function problem
- Excel 97 Importing to Access 97
- Last Reference Name function
- tab order
- Array w/ Sum
- If statement question
- Worksheet question
- ROUND
- Adding Worksheets
- Date formula
- Auto inserting date of change
- HLOOKUP function help
- Newbie Question on Extra Space After Numeric Values
- Comparing columns of data
- Merging text from two cells into one
- test
- VLOOKUP using dates problem
- References between cells
- Format Cells
- Dates Appear Different on Screen
- Sumif to Countif ? Please
- formula to hide row
- Vlookup
- Find Month to Date data - from weekly data
- College Tuition spreadsheet
- Need addition to Macro Please
- protecting sheets
- Help with Lookup / Match functions
- V-Lookup
- formula
- Check Boxes
- "File not completely loaded" error
- Matrix
- Tricks With Iteration
- Excel XP Nested If Function Problem
- Days and hours
- A picture within excel file/database
- Reference Excel Tab name in formula
- Value
- Per Diem Caculation
- Find MIN but not zero.....
- Making Macros available to other users?
- Show pages
- maximum in a cell
- maximum in a cell
- set Excel to not print certain rows
- Hiding A Sheet Command Button With VBA
- Changing Color of Worksheet Tab
- Word counting in Excel
- "BLINK"
- would nested work
- Nested IF function
- Removing a circular reference in a worksheet
- Lookup in Excel
- Averaging
- date format appearing improper
- Import data from mysql
- Attaching to mail
- if - then for range
- copying formula to a randow row
- total random cells
- Excel comparative search
- Funtion Match
- Autofiltering
- Convert phone directory to an excel spreadsheet
- multiply hours
- Count If Conditions Are Trus
- @cellpointer
- Advanced Filtering
- Dynamic formula to sum across rows
- Advanced Sorting
- Advanced Sorting
- Highlight
- maximize window
- Sorting
- XIRR
- How to get data Using SQL
- finding related cells
- Data validation - Listing
- Menu Help
- COUNTIF On Multiple Lists Causing Problems
- Excel Numbers and text
- Macros
- Tab Name
- VLOOKUP
- Re: Count incidences of part numbers
- Keyboard function (switching between formula and value)
- problem with cell names
- Finding Top Ten repeated entries in list
- Cell Format
- Update sheets
- get pivot data
- Creating formula to calculate future dates...
- Calculating commisions to be paid
- IF function will not work? Can you see why??
- Object Library Not Registered
- How to retrieve a column number and apply it to define a range?
- Re: Merging Workbooks
- NEED TO CREATE A SCHEDULE WITH VARIOUS FIXED AND RANDOM VARIABLES
- Is there a function to retreive the parameters of a filter?
- Rounding a range?
- Making Cells Absolute
- Delete Print Areas
- sum
- computing CA income tax withholding
- Convert decimal number into hours and minutes
- File Sizes too big
- Not able to "Save AS" Excel worksheet
- Re: Calculating the mode based on an IF statement
- Paste only two decimal places
- indirect
- adding up multiple sheets
- Resolve cell references in worksheet function arguments
- runtime error 1004 can anybody help?
- Re: Calculating the mode based on an IF statement
- Newbie - How to Remove An Extra Character at the Beginning of a Cell?
- IF function - fixing a formula
- Summarizing Data
- count multiple conditions
- Format Report Option missing from 2003 version -pivot table
- Color Tabs on Worksheets
- vlookup help
- Shifting Cells
- Preventing a cell from being deleted
- Concatenation problem
- formula question (HELP)
- Worksheet Header
- Worksheet Header
- Re: Request for a macro with a loop
- Re: Request for a macro with a loop
- Very Hard formula
- Printing a one page document
- Using ApplyNames across ALL worksheets in a workbook
- Lookup values with criteria
- I have a negative number when finding the difference between 2 dates
- Hours and week days
- Cell Format
- Set focus don't work
- Refresh Advanced Auto Filter
- array help
- Microsoft Excel - "Edit Cell Comment" abnormality
- Excel 2002 Page Setup created in Excel 98
- array help again
- Re: spreadsheet computations
- Recode genetic data
- Canadian Mortgage Formula
- hlookup help with grading chart
- hlookup help with grading chart
- Edit entire column of existing formula's
- Substitute Function: Trying to incorporate variables.
- VLOOKUP won't calculate....
- IF in sumproduct
- how many file u hv linked
- formula not calculating correctly
- Array Formula help- Can this be done?
- SQL.Request in Excel 2003
- Problem with Dates Lookup
- formatting cells
- countif
- Copy/Move multiple WorkSheets
- Concentrate values
- if function
- "Can't Find Project or Library"
- will not paste multiple copies
- increment cells by one
- Increment cells by one
- Threshold of Acceptance?
- Make a negative # =0
- continue a number if less then previous
- count, sumif, sumproduct
- Excel 2002
- Automating a Macro to run every 5 Seconds
- Concatenate different text formats
- Vlookup
- External Links and OFFSET
- COUNTIF
- Protected Worksheets
- CUMIPMT with balloon payment
- DROP DOWN
- Printing formulas entered in cells
- Re: Difference in value between two cells.
- Re: Difference in value between two cells.
- Re: Difference in value between two cells.
- Invoice template, Date
- SUMPRODUCT Issue
- Stuck on a formula
- advanced protection?
- changing row color based on value in cell
- SUMIF Problem
- Re: or function
- Re: or function
- Re: or function
- IS THERE A FORMULA FOR THIS PROBLEM ?
- Protection Issues
- Pivot Tables and Groupings
- Printing template created in Windows 98
- Excel 2000 Read only alert fails
- Windows task
- Conditional running of an element embedded in a macro
- Match and offset
- Can't Deselect Cells - Please Help
- Rounding issues
- What formula can I use, Help please!!!
- sorting column values
- In-cell Dropdowns don't work
- Hex to Decimal - Function??
- OR Function Help
- Can i make some worksheets auto and others manual calculation
- Leave Cell Blank?
- Inserted Object
- I have complete function disfunction
- Excel slow to scroll
- manual sort in a pivot table field
- Mouse Pointer Stuck
- Nested IF statement HELP
- If Statement Error
- Re: hex2dec function
- Sumproduct
- vis basic & creating an invoice
- How to round currency values to a number divisible by another number?
- Ken Wright :toggle autocalc, workbook vs. worksheet
- Timesheets
- (blank)
- VLookup issue
- Using SUMPRODUCT function with date ranges
- Find the next active cell and HLOOKUP above it...
- Function to check if a number will divide equally
- Rounding Issues
- Reformating Updated Cells
- Hours worked computation???
- Count Days
- Delete empty rows
- Problem Printing - Can anyone help?
- IF Looking for exsample of 3 problem IF satment
- Multiple Criteria
- Borders in Excel spreadsheet.
- Delete Empty Rows --still not working
- Make CountIF work like SUMIF
- Convert a sum formula to a count formula
- Comparing ARRAY elements with RANGE data and created a 2nd array
- Match first few characters in a cell to another
- Tiered prices
- sumif a 3d reference
- link problem
- Excel hyperlinks
- Converting numbers into words
- How can I Filter a sheet to exclude some datas of another sheet ?
- Which function use?
- VLOOKUP question
- OptionButtons in Excel
- SUMPRODUCT
- How to generate next number?
- Count Funtion
- percentage
- Lookup Formula??
- Help Me
- Formula Bar
- IF, Then Statement Using Multiple Worksheets
- How can I call a Excel Macro from VB?
- Random numbers
- Formula to count age by month
- Annoying array formula
- Retrieving Data from Multiple Sheets
- Re: T function
- Time difference (Formula rqd)
- Weighted Average
- ranking a list of numbers above or below the average
- Re: Calculating Business Hours
- functions/events based on user selections
- Auto update for date field
- Tallying data
- compact cells
- VLOOKUP??
- Re: Display # from another cell if another cell's # is within range
- Re: Display # from another cell if another cell's # is within range
- Re: Display # from another cell if another cell's # is within range
- Re: How to formulate a cell with a condition in macro
- Locating duplicate numbers in a column
- Match function just won't work!
- Nested IF Statements
- ALPHABETIZE INCELL
- Excel 2000 Solver AddIn: Model Load & Reset Have Excessive Delay
- Recording Excel Macros
- Re: automatic worksheet opening
- Find item in list by referencing two conditions
- Get 0 instead of #N/A in Formula
- Re: Count data using multiple conditions
- multiple column match
- sorting subtotals
- Re: Sum a column of hours and minute calculations (02):11
- inserting specific page number into footer
- Removing "-" from several fields
- formula based on expiration
- inserting specific page number into footer
- Hours worked = pay
- Re: Sum a Column of Hour and Minute Calculations
- Auto height for rows
- Tick Marks
- Tick Marks
- RE: Sum a Column of Hour and Minute Calculations
- IF.......it's possible....
- Need Help!!!
- Vlookup across multiple sheets
- Need formula
- updating all sheets at once?
- Hours Worked
- No Rounding - need full decimal value
- filtering and counting
- Currency formulas in Excel
- Printing comment notations
- Print comment notations
- Computing Cmpd Return on Irregular Investments
- How to use a formula with a condition
- I want to return a formula instead of a value in an IF function
- Problem with INDEX formula..
- Printing a list of Worksheet Tabs
- print only certain sheets
- Help - Linking sheets and data from Sheet 1 to blank worksheet
- Short Time
- adding lines
- required rate of return
- How do I get rid of alerts?
- VLookup functions
- How do I reset a sheet completely?
- Seperating 1 column into 2
- Need help w/a counting formula
- hidden rows
- Excel formulas
- HELP ME!
- SIN/ASIN Question
- would appreciate your help. thanks
- multiple spreedsheets need help summing based on a text entry
- formula
- Re: required rate of return
- Currency formulas used in Excel
- npv mystery
- new to excel
- Need help changing name order
- red triangle in upper left of some cell
- Macros in XP
- Sorting Data Using Cell references
- Removing Spaces in text
- variables in cell references in formulas
- Multiple Choice?
- SumIf Formula help to figure CA Overtime Laws
- Excel formula to convert number to words
- Hyperlink based on a cell value
- Finding numbers in a cell
- Using and IF formula for a cell value between two amounts
- Transposing
- Lookup based on multiple variables
- Function for adding days
- "IF" function
- Re: Adding up Weekdays
- Sorting
- Re: Adding up Weekdays
- Compound VLOOKUPS
- Tally no. of "VName" in column C and "Owner" in column M
- Macro needed data query
- Compound interest....?
- Month Serial number to Month name
- UDF recalc question
- Number/Digit Replacement
- Turning off sort warnings.
- AUTO ADDITION
- How can I total Preview Sheet in Little League Database
- Re Hyperlink based on cell value
- Premium Pay
- Re: Military time computation/Overtime??
- counting among several sheets
- Got me stumped
- Re: Looking up based on a returned value for a calc
- Array Formulas
- Automate naming of worksheet tabs
- Empty cells reporting a value
- Factset formulas - NT to XP compatibility
- Re: #N/A GO AWAY
- Pivot table
- switching 2 Y axis graphs
- Including saved path in header/footer
- Tabs
- Combo Box Control - CONTROL tab missing from FORMAT CONTROL dialogue
- RE: #N/A GO AWAY
- Mouse trouble - selecting a range of cells
- CountIf and And
- #NULL!
- Compare Worksheets and Copy/Paste Data
- Removing + from cell
- Re: Not Sure What Happened
- links
- Re: What's Wrong With This?
- changing numeric value to text (in words)
- Data reference in Formula
- RE: #N/A GO AWAY
- Conditional formating
- is there a formula that can count a range of cells with text?
- Formula/function shortcut?
- If, then formula
- VLOOKUP and LARGE functions
- WEEKNUM function
- Setting Print Titles on multiple worksheets
- conditional format to indicate duplicate entry
- Formulas aren't working
- Looking up multiple criteria to find missing data
- Multiple IF Statement
- sumif/Countif
- Import And Export
- ImportAccessTable
- Data transfer
- Percentage to work out bonuses and penalty's
- Data transfer2
- limit amount of words...
- Queries Within a Spreadsheet
- Combined conditions
- DateFunction
- Importing large ammounts of data (over 65536 lines)
- RE DateFunction
- Is anyone bright enough to help?
- DateDif
- converting time to decimal
- Removal of "dot" following last digit
- i need to increment a numbered column when the data is in quotes
- end of worksheet problem
- Importing unicode text file into Excel 2002
- Write To And Retrieve From Another Workbook With VBA Code
- Counting Records That meet Multiple Criteria
- "pick from list"
- Omitting a row during printing
- frequencies?
- LOOKUP
- NEED ROW BELOW 65536 NO CELL
- Nesting multiple "IF" functions
- COUNTIF Help
- conditional sums
- Data Validation - restricted entry
- Excel problem - Reference another workbook using last week date as name
- Return Date vaule in cell.
- Can I link a cell in several worksheets to a master worksheet?
- Determining first and last areas on multiple cells
- Identifying if a Value is the MAX in a data series
- lookop or index?
- if and sumproduct
- Need Help ASAP .. PLEASE
- Dual monitor support for multiple spreadsheets
- Cannot change cell color?
- indent text
- Hex to Dec conversion formula for Excel...
- Using military time
- Conditional Format
- Database Criteria
- transferring data between sheets
- Excel 2000 Autofilter
- Need to get Worksheet names from ADO
- Re: VLOOKUP
- Re: total days in month minus all sundays
- Re: total days in month minus all sundays
- Putting a COUNTA function in an Array Formula
- Choosing largest number in range
- Date formula?
- Re: total days in month minus all sundays
- formula to display only part of acct #
- Re: total days in month minus all sundays
- Match function Excel
- list box
- CONCATENATE
- Networkdays
- Can I Link Merged Cells to a Single Cell?
- If function or something else?
- Data Validation - Prevent Blank Cells
- finding the column number where data is located
- Re: # of days gone
- custom format
- SMALL Function
- Filtering
- Out Of Memory ' HELP
- Initial Caps
- Time Calculations
- Drop Down Boxes and Correlating Data
- IF function
- Test in Formulas
- Re: Macro in excel
- Excel Formula - Date Fixing
- Macro question Excel 2000
- vlookup and if
- Auto Filter on Date Fields Problems
- Transfering specific rows (more complicated than it sounds)
- Troubles with VLOOKUP (keep getting #REF)
- Is this possible ?
- What is the function to tell me the current Month
- Lookup Function
- I need to write a sentence that contains references to cells in a workbook. Help?
- subtraction across cells
- Tax Table function
- Need help on calculating multiple clts data
- if statement with multiple criteria
- problem with sumproduct
- sumif question
- Data Extract To Range
- password is not function
- .rtf (Text) importing into Excel
- Entering Credit Card Numbers
- Help with Security related to cells in a shared file
- Function for consolidating numbers
- MS Word
- Ever encountered #DIV/0 problems with COUNTIF
- Updating charts - monthly
- Duplicating use of buttons/macros over many charts
- Need Formula Help
- incorrect result of nested functions
- inputting feet and inches
- Partial Derivatives
- YTD Budget Totals
- vlookup function
- Alphabetizing worksheets
- Inventory
- Pivot Table with Duplicate Field Names
- Simple Excel Question
- Salescodes
- Put WORKSHEET TAB name into a CELL ?
- Worksheet links
- combo box
- Shared workbook not loading
- password on a worksheet
- how do i make a reference to cell names/cells in other workbooks WITHOUT links?
- copy paste problem in excel 2002
- RSQ problem: zero denominator
- Re: macro - need help
- time and hours?
- Need help with sumproduct and dynamic columns
- if or sum
- Floating decimal
- Deleting Empty Rows
- vlookup modification
- How Do I Modify a Record from a UserForm
- I need a formula
- HLookup to link data across several worksheets
- Excel Character spacing
- No Repetition RAND and converting text to cell reference
- Date Question
- Regional Seeting Property
- Using a Macro copy paste
- Sort Function
- This years birthday date
- Open Add-In Type File in Microsoft Excel
- Pointless rant about order of terms in functions
- Sort and print?
- Filtering Duplicates
- i need a formula
- Lookup words
- EXCEL problem with function" if"
- Excel Date Grabbing First 2 Numbers
- Re: Hyperlink to chart sheet
- inserting a space in Concatenation
- Splitting a multiline cell into rows
- "mm_dd" element embedded in a VLOOKUP
- Function answers change colors
- decimals
- Index/Match/Min
- Can this be written as a formula?
- sumproduct using 'or' logic
- COUNT
- Headers
- Hyperlinking a specific worksheet ina workbook
- Insert worksheet name
- Function changes when user cuts and pastes
- Countif trouble
- Sum() Formula won't pick up text
- Re: CF ROW once cell is populated
- Offset formula
- If cell contains "text"
- Show the last 3 lines of a table
- Help: how to return the col & row of result cell
- Help with writing Text strings that pull data from cells (formatting troubles)
- Calculations based on cell selection
- Combo box
- Pasting to disconnected ranges
- Using COUNTIF function on a filtered result
- Date formula
- Pivot Table vs. Subtotals
- wrapping text and autofit in merged cell
- Copy every nth cell across columns
- Round Up negative numbers
- Nested IF/COUNTIF
- If and Lists problems
- Help Me please - Excel Lookup function returning results N/A
- Modify "Remove Dots" function
- Formula to autonumber cells
- Updating cells referenced to worksheets in same workbook
- Summing Filtered Rows
- Comparing 2 spreadsheets
- Linking Workbooks
- Date Formats
- If Formula
- Right click menu dissappeared
- negative figures
- worksheet
- Problem filtering data
- If Formula
- Vlookup
- How do I delete a Scroll Bar Control?
- How do I continue a sales invoice such as a page 2 or 3 etc? (using the invoice template)
- "IF" COMMAND
- Sumif criteria that's not a blank
- formula : reference column cells into rows
- Nesting an IF within a COUNTIF
- formula : reference column cells into rows
- If/Vlookup formula resulting in #N/A
- Generating purchase order numbers
- Continuous day countdown excluding weekends and public holidays (urgent)
- Re: Continuous day countdown excluding weekends and public holidays (urgent)
- short cut key
- Re: If/Vlookup formula resulting in #N/A
- GL Template
- Lookup problem
- adding values from another worksheet by matching criteria
- Re: adding values from another worksheet by matching criteria
- Re: Continuous day countdown excluding weekends and public holidays (urgent)
- flexi date
- calculation decimal limit
- Re: short cut key
- Macro to call different sheets...
- Display a number as + or -
- Re: sEARCHING
- If() and then putting formual in the cell
- RE: Lookup problem
- insert the date automatically, and insert a number automatically
- Annual Rate where Rate known for x Years
- Display True for both cells
- Creating graph of stacked %
- Problems with MIN
- OT Mentor/Tutor Help please. Xpost.
- Lookup
- If Statement/Lookup/Help
- Problems with lookup functions
- Formula Problem - 3 conditions
- coping sheets with names and macro and functions
- Indirect
- Subtracting dates
- how to select random rows?