- Adding "Spaces"
- Is it possible to filter based on ceel format
- Need help with macro
- Lookup returns N/A
- comment
- How do I tab to areas on spreadsheet?
- basic questions
- Finction INFO
- Sum of combination
- Sort Formula for TEXT
- border around rotated text
- Empty Cell
- Latest Input To Appear
- Re: Protect Worksheet Tabs
- ron@rondebruin.com
- broken links
- Highlighting Duplicates
- How to convert dates entered as text to values
- Re: Returning a unique alpha list
- looking up portions of a list
- help with formula to enter page numbers
- Re: Returning a unique alpha list
- Formulas on a template
- Re: Returning a unique alpha list
- Re: Hiding sheet tabs
- Count the Days in a Range if
- Saving Excel Sheets that are read-only?
- Lists
- Cell Ranges
- Making a name worth a value
- WORKDAY FUNCTION
- Return value of "YES" when range contains one cell that has data
- Using a common worksheet name in a SUM formula
- validation
- Simple COUNTIF not working
- How do I ref. a cell range and populate adjacent cells?
- Extract data from table to make a list of cell values
- Formula with conditions
- if statement with vlookup
- Sort via a colume bring up incorrect values
- How to ignore blanks in clacs ?
- Separate Street Addresses - Text to Columns
- Multiple IF in single Cell
- excel VBA - userform combox problem
- if formula not working on date comparison
- Countif with two seperate name criteria
- copying data column based on a formula result
- Sheet names in a formula
- Shortcut Keys
- Excel VBA - problem with formula
- Convert text format to BARCODE IN EXCEL
- timestamp (please help)
- Formula calling a function problem
- Returning a query on a separate spreadsheet.
- Chart Formatting
- formula
- standard deviation
- macros don't work when workbook saved under new name
- Look-Up Question
- Periodic File Linking Performed Automatically
- How to return the last value from a range
- Increase value formula
- colouringf a stacked bar chart
- Alternating between the worksheets
- Script To Apply Format To A Chart
- Extract unique values with criteria, and sort them
- Most frequent
- Random variable bug
- Indirect validation possibility?
- MEMORY issue
- Deleting Duplicate Entries
- Hide Specific rows.
- problem when opening an existing file
- Vlookup in Excel
- please help with formula
- defining a cell in multiple worksheets
- defining cell names in more than one worksheet
- If Function
- Looks Like a Pivot Table But Isn't...
- Copy Worksheet Problem
- taking off 5 characters from right side of cell data
- Insert date time in another cell when dropdown selection is made.
- CUMIPMT and PPMT Functions
- Cannot perform "Save As" function
- Possible to capture negative time errors?
- get data from a text file and insert them in datasheet to show a chart in VBA
- Circular Ref was working fine - now :(
- If Date
- @CHOOSE Equivalent Function
- @CHOOSE Equivalent Function
- @CHOOSE Equivalent Function
- Sorry for Multiple Posts
- Report
- Excel 2000
- help_pivot page fields on different sheets ???
- look up tables
- Grades
- Re: Changing date to physical year.
- Add Condition
- Complex Array Formula
- Re: Changing date to physical year.
- Re: changing name format
- please help again
- DATE CONVERSION
- standard deviation with geometric mean
- SumIf
- change name format
- IF Statement that Returns Multiple Results
- Conditional formating
- Linked Workbooks
- Conditional Sum
- Convert Cell Content To Table Name
- Relative Worksheet Reference
- command button
- Help
- Date counting formula
- Re: chip tuning
- VARYING COMPOUND INTEREST
- Navigating around my worksheet
- VARYING RATES OF COMPOUND INTEREST
- Functions in VBA
- Form Design with tracking into database
- VALUE MESSAGE
- automatically refresh macro
- Protect Sheet
- keep from duplicating numbers when creating a list
- not duplicating numbers in a list
- Find First populated cell in row - grab column heading
- excel conversion from 2000 to text in 2002
- COUNTIF?
- Figuring totals by periods (Monthly, Quarterly, etc.)
- COPY FORMULA
- Converting Decimal to hours.
- Auto Date Conversion Not Requested
- Blank Cell
- Disable screen refresh during long macro execution
- To Conditions
- Function to return sound?
- Insert Comment into Protected Sheet
- Comment Boxes Re-sizing
- Sum If question
- reference in text box
- Help for the maths challanged - PLS
- Data Validation for drop down lists
- Vlookup algorithm
- Converting Decimal to hours.
- Calculating Due Dates
- Find date difference between two cells
- Using hlookup to return a cell Address
- Comparing values with a cell
- Add Number
- copy formulas
- Multiple VLOOKUPs
- Basic sum function returns zero value
- hot to multiply
- Error function
- Lookups: One Value --> Many Results
- Can't record Global Macro
- Macro question
- Selecting value from second list when date is within date range on first list
- Excel Lookup or IF function, Don't know which to use
- Search formula for multi occurences
- labels?
- delete all occurances of a specific value
- Nesting "IF" statements
- Counting Cells that contain Specific text
- Sum of differences using SUMIF?
- Validate a cell - Workdays only
- Equation: knowing y - wanting x..
- Division in Excel
- Lookup with multiple finds
- Linking Data and Ignoring Zero values
- major stressor
- Bracket Automation
- disabled macros-
- Goal Seek
- Highlight Changes without Tracking?
- Summing Certain cells
- Print preview
- Transfer string From one cell to n cell
- Suming with multiple conditions
- Pasting problems from Word into Excel
- Need site
- Deleting partial cell data?
- CUMIPMT
- Using a new column to flag changes in other fields
- Is there a way to capitalize everything within a workbook?
- Removing macros from a wokbook
- Filtering Withing a Protected Worksheet
- Problem opening workbook
- =Countif statement
- Wrap Text in Cell
- XIRR versus IRR
- getting started with formula
- Referencing a date cell in a formula
- year to date calculation
- Changing font sizes in drop down lists,etc
- goal seek multiple lines at one time
- Merging multiple columns of data into one column
- Drop Down Lists
- Making Row Numbers in Range in a Formula Variable
- convert value to text.
- Nested If Statement Maximum Reached
- Custom cell formatting
- Conditional Formatting Based On Content Of Another Cell
- Linking functions very slow
- Convert Dates
- Scrolling Multiple Worksheets
- Select Data from more than one worksheet
- Paste Special Merged Cells
- function for true/false calculation on a range of cells
- Loss Data in Shared Worksheet Enviroment
- Sumproduct formula
- Slight change needed for my script
- countif function
- how to make repetative value unique?
- how to make a column of repetative data become unique?
- Adding
- How can I do this? (2)
- Changing And Updating Links
- Automatic Updates between worksheets
- Excel Worksheet Protection Passwords
- Excel formula AND
- Counting Consecutive Occurences
- = Right((Cells(2, 2)), 4)
- help with a nested Function
- Clear
- wrapping text in an if statement
- #DIV/0! error when using IRR function
- Is it possible to use wildcard characters in array formulas?
- Decimal places
- Microsoft Excel
- enter data in single worksheet, appear in multiple
- Roundup to the nearest number that is divisible by 3
- INDEX / MATCH Question
- Portuguese version of Excel uses keyword "SOMA" instead of "SUM"
- Converting Date Time format to Month YEar format
- quadratic equation and linest
- Breaking numbers out of a string
- Returning a Value
- Need Lookup & Product formula combined
- Extracting Hyperlink
- Extracting Hyperlink
- How to print multiple tabs on same page
- SUMIF w/multiple conditions
- Different Page Setup on the same sheet
- Alphanumeric sort
- DROP DOWN LIST
- Need help with nested IF comparison....
- MOD errors
- Sort on Protected Worksheet
- COUNTIF Function
- Need help with lookup formula
- Time Calculation
- split screens
- Sum Question
- Create a Comment in a cell via a Worksheet function (not using macros)?
- Manually setting Y-axis values in line chart
- Password Protect the Unhide Sheet Function
- (re)formatting Comments-HELP!!
- Question about create address label from excel
- Copy data from one tab to the next... read more
- Help with OFFSET function
- Validation of a Sheet Name already existing in a workbook
- Time
- Advancing by One Month
- Menu Bar for Excel
- multiple if functions
- Do I use an IF function?
- Changing links - source file.
- stopping a macro at the 'Sort' entry screen
- Getting Wrong Time Total
- Conditional Formatting
- Excel does not show result on formual
- automating chart generation from excel spreadsheet
- Total
- Want to put range values in a column into two columns
- Disappearing formulae
- Conversion Table
- summery of several worksheets
- Subtraction problem - finding the difference
- Pick Cells in Column A but no duplicates
- Create multiple copies of a worksheet
- Function Help
- Cell Popup notes
- Multiplying a negative time value by a monetary rate!!
- How to show image?
- Range("A975").Select
- Need Help with Formula!
- Macro formula for a Button
- Excel 2002 Formulas
- If function won't let me return the correct result-PLEASE HELP!!
- units on answers on calaulations
- Lookup and Average?
- Trap Keys
- Finding Next Blank Cell
- sheet1 function
- having a cell show a value before input
- using a named cell in a fuction
- Syntax of Excel Find Function in VBA
- Using + / - to hide unhide rows or columns
- Constant Expression Required
- using the solver to graph all posible results
- Two IF conditions
- Merge - not wanting data to print
- calculus in excel
- CarryOver Balance
- convert from small letter to capital letter in word or excel
- Date Problem!!!
- setting up a bill
- @npv
- Excel 97 Event problem
- How to use if analysis
- Worksheet Reference
- Date Functions in Excell
- Sumproduct Date criteria
- Spreadsheet says CALCULATE when there is nothing to calculate
- Printing using vlookup
- Converting Time!!
- URGENT: converting exel to text file
- Problems with excel formula AND
- Printing Cells
- onelist from two
- use print in 2 workbooks
- To Bob Phillips
- Lookup Problem
- summing in same column based on another cell value
- Vlookup
- PRICE function, frequency
- return blank
- MS Excel 97 "countif" function
- Conditional Formatting Issues
- Histogram, importing text file
- Trying to Get a Negative Difference in Date
- Histogram, importing text file
- Next Cell on "Enter" Key
- Flow text
- Calculating Time
- Macro: Exit active workbook without save?
- Display Value if Time Between X & Y [Semi-Urgent]
- Direct to specify worksheet when open a file?
- Strings in Excel Worksheets
- Screen resolution?
- Hide Menu Bar / Toolsbar / disable save button?
- Re: Printing Problem
- Text
- Hyperlink Function
- Creating Macro in Excel that communicates with Outlook
- Count based on date
- sorting data
- quick question about PivotTables
- gross margin if statement
- Formula help
- Transposition for a 3,000 provider directory worksheet
- SUMPRODUCT formula not working
- Changing colors of text with functions
- function based on format
- Ranking My Products
- Vlookup
- (C) turns into copyright symbol?
- Hyperlink Compatability Issue
- Re: Triple-Nested formula?
- Change in function_num in Excel 2003
- Re: Triple-Nested formula?
- Nested IF Statement
- user function in function wizard ?
- Round up to the nearest divisible quantity
- return formula type?
- IF statement
- Subtotal Function
- TOTAL BOX AT BOTTOM OF WORKSHEET
- calculate amount of time difference
- Excel-Excel Mail Merge Possible?
- Getting Counts
- Adding an overall percentage to price list
- HELP! inventory wekly usage average
- Who can join these two VBA Codes together?
- swapping numbers...
- Turning date into month
- Can not set Print area
- excel
- toggle through list using first letter of word
- Unique values from a list
- Send current workbook
- move cells to other sheet(s) based on color
- Formulas
- How can I get to this cell
- Working hours formula
- Color text based on value
- how to return 5 largest values from 7 cells?
- Scroll speed too fast
- Revealing and removing Text Boxes
- Conditional formula help
- Copy a Formula
- Comparing two columns
- Oldest Date
- Excel-which formula?
- Excel 97 Subtotals Formatting
- analysis tool-pak add-in not working
- Quotes in Formula
- IF (AND) functions
- Count unique values
- VBA Code Help
- convert text to date
- Spellcheck protected worksheet
- Re: Command Bar
- Input Mask/Format for Column Entries
- SaveAs tab delimited text file
- SaveAs for tab delimited text file
- Arjen Jongeling, een oude bekende
- Array Search
- Using Dates to find value
- EXCEL97 WorkSheet Function Analysis Pack SR-2 HEX2DEC
- maximum amount of rows?
- Referring to form controls in formula
- question about random function
- Comment Boxes and Gridlines
- Grabbing Dynamic Values and Freezing Them
- Excel 2002
- Formatting cell with formula
- Average function with a difference
- Conditional Formatting
- SUMPRODUCT with calculated text strings returning Zero
- Average formula with a difference.
- Text Box Problem
- Workbook Links
- Re: Entering multiple formulas in one cell
- find multiple entries in worksheet
- Edit Formula Button
- CopyCellValues
- Excel Count Function
- Autofilter Custom Problem
- Counting Parentheses
- Counting Parentheses
- Counting Parentheses
- Copying a column from several similar sheets into one sheet
- SumProduct of nth Largest over non contiguos cells
- Sat Sun etc
- calculate shares for heirs at law
- Buttons for macros?
- Cut and paste without altering cell reference
- data not sorting correctly
- Replacing Text using VBA
- Date calculation (If then type)
- cell protection
- Sumif statement
- cross reference
- Excel Columns
- Counting repeated values
- Controlling Stock Level
- Numbers
- minus quantities
- 2400 hour function required
- Cells
- Formula depending on dates & text
- Get Rid of N/A
- Calculations
- Challenge with dates
- Help with SUMPRODUCT
- sum of a kolumn based on text in an other kolumn
- run macro based on cell value
- Eliminate partial string
- Automatic Cell re-sizing
- inporting folder directories
- Mark up % question
- WORKSHEET CONCERNS
- add cell with itself
- Problem with Workbook Links
- Time to number value
- Combine two cells
- Deleted Work Sheet
- Alternative to COUNTIF ?
- Counting $ Signs
- Re: Minus key on number pad
- Returns the number of days in the pipeline
- font type conditional formatting based on if
- Q: How to select all cells of all the worksheets?
- Calculating a Work Day Date
- VLOOKUP without #n/a and zeros
- Countif Help
- Help with if formula
- Copying Worksheet without links to parent workbook
- Pivot Table Sort
- Using a Custom Date in Cell
- Excel 2002 Error Flags
- Formatting cell colour based on colour of other cell
- #VALUE!
- Calculating Row Number for a Formula
- Unable to change date format
- data validation & formulas
- Auto-populate?
- Scan 12 columns from right to left and return the first value that is not zero?
- Excel subscript/superscript
- Formula for returning a value
- How do I copy a combo box?
- excluding the blanks
- Vlookup Help
- If function help
- Displaying "Tab" name in a file
- Sorting
- Re: How lookup code descriptions from table?
- Count function-conditions
- Sorting with Groups
- Formula needed
- Merge and center, text disappear
- Re: #Value! Error as result of Calculation
- Re: #Value! Error as result of Calculation
- SUMPRODUCT OR LOOKUP
- Sum formula not working
- LookUp 2 Cells / 1 Table
- I want to display the sum of my monthly expenditure...
- Updating links to another workbook after sorting
- Sorting
- Re: #Value! Error as result of Calculation
- Need formula to automatically bold rows of data
- Update link to another workbook w/o absolute ref
- Chip code problem - conditional formatting colors GetStrippedValue
- Chip code problem - conditional formatting colors GetStrippedValue
- count between one date and another
- SumIf Question
- Chip code problem - conditional formatting colors GetStrippedValue
- Chip code problem - conditional formatting colors GetStrippedValue
- formula advice
- Chip code problem - conditional formatting colors GetStrippedValue
- Chip code problem - conditional formatting colors GetStrippedValue
- Formula
- large div#0
- Conditional Sumproduct
- hide a row dynamicly
- Highlight active row
- angle from pitch
- INDEX Help Again!
- Web posting interactive worksheet
- Het zal toch niet zijn wie ik denk dat het is?
- Formula Please
- Create quote System
- Sumif, Sumproduct or....?
- Real-Time Data Printout Sheet
- Column also Row
- Highlighting a Row using a conditional format
- "Count" specific field
- Countif a range of dates
- Excel memory consumption
- formula
- formula for allocating crane insurance costs
- Stock Profolio Formula
- "Improvements" in LINEST function in Excel 2003
- Retrieving data from various worksheets
- Draw horizontal line every fifth row on output list?
- Reference a sheet name through a cell
- Tough book choice?
- File Not Found
- Help - I need to rename multiple entries
- Square each idividual cell and add them together
- If-Then statement problem
- sum if question
- Excel Query - calculated field
- simple formula problem
- Information after formula result
- another simple formula
- transposing by worksheet function
- Re: transpose a row
- Hyperlinks
- Re: transpose a row
- Fing value in column and associate result to it
- IMPORTING JPEGS INTO EXCEL
- Re: Multiple worksheet formula
- Re: Multiple worksheet formula
- Re: Multiple worksheet formula
- Format problem
- Referencing Workbook Tabs
- Calculate a list based on prior result
- Don't Know What Funct to Use
- removing accents from characters in strings
- Re: transposing row
- Help combining two worksheets
- Help
- Re: transposing row
- Help summing only certain cells
- $DIV/0!
- Re: Using wildcards with SUM?
- Dates
- Checkboxes
- combining the match & offset function
- What Function to Use?
- 3-d references
- Function to take of characters, letters, etc.
- Word-wrap does not function properly in multiple line cell entries
- Re: Inserting Asterisks into a column
- either/or in a formula
- advanced filtering
- vlookup
- text spilling over into next cells
- Linking to Consecutive Cells is it possible?
- Count formated cells
- Clear cell function
- Copying CONCATENATE formula to other cells in column
- Time & Gantt Chart Like Display
- Mail Merge help again
- copy?
- Getting rid of !ZeroDivide error
- newworkdays
- Re: Working with arrays of different sizes
- What's Wrong with This?
- Text Question
- Want to print my excel file but want only fuctions to print
- List of matches
- Backup - Date Included in file name - Macro
- same range name on multiple sheets
- Formula for loan repayment with a future value
- Need to create email address from URL
- Tab
- Bug in Solver parameters?
- not sure what formula
- Alt Tab
- Cut Row of Data and Paste to another Sheet???
- formula help
- Fill Series Date with a twist
- Counting based on multiple criteria
- Same Text Contents in Separate Cells gives "FALSE" when compared
- Absolute date/Saved at -date
- Finding Dates & Adding Values
- Copying formulas
- Formula help reqd
- NUM SCRL
- enable selection - protection
- which formula to use?
- excel problem
- Re: Finding Dates & Adding Values
- File linkage
- Computer crash on closing Excel
- transposing row
- Excel PageBreaks from .Net
- Wrong Result--Help!
- Non-adjacent cell range in formula
- Re: Find but no format & Sheet tab no colour?
- Rounding a Number Up or Down-Depending on Situation
- drop down boxes
- Syntax Modification Help
- Re: Inserting Asterisks into a column
- "Find" through entire Workbook
- Date functions
- Changing date information
- Re: Indirect function in sumproduct
- Need Help on special formula for budget sheet
- Re: Indirect function in sumproduct
- Re: Indirect function in sumproduct
- locking spreadsheets
- Sumif
- color format
- Re: commission formula
- Set password using macro
- color format
- find /replace within whole workbook and Macro question
- hh:mm to decimal time .25
- move to next number value
- COUNTIF, Dates, and Variables
- getpivotdata function and dates
- Auto Filtering
- Use of color shading for "IF" function selection
- Referring to changing spreadsheets in a function
- Array Formula Over Network?
- Formula Auto-Fill Stopped Working?
- Copy and Paste
- advanced filtering
- Ignoring Blank Cells
- Lowest number greater than zero
- YTD formula
- SUMIF() with AND() function??
- copy a range from closed workbooks
- copy and paste
- Continuous update of NOW() function
- nested @if's of more than 7
- Using TEXT Function in Excel
- auto install add-in
- Macro in closed workbook
- What does the "--" mean when placed before a function/formula?
- Help with Random Numbers
- collating game scores
- Sharing a workbook over a network
- How to copy selective rows?
- PRINT 11 BY 8.5
- date function
- And function
- Macro or Formula to Hide Rows and Col's
- Deleting Extra Lines
- lookup
- Sheet Names
- Auto Filter value
- Extract a First Name from a String
- Column headings in Excel w/sheet
- Problem with MIN
- length from angle of hypotenuse
- Permanent Formatting of New Comments
- No data series line for 0 values in chart
- associations
- Multiple Functions ?
- Excel Formula - IF Formula & Conditional Formatting
- Match & Index Combined Row & Multiple extractions
- using sumif for 2nd level arrays
- Macro - Fill first & then go next
- Cannot Print
- How to hide the symbol DIV/0
- RE: Using wildcards with SUM?
- Show the current value
- adding the results of 2 sheets
- Converting Excel 97 to Excel 2003
- Help with Lookup or Index
- Vlookup variation
- Excel Filters
- TVM Formula
- MATCH function with text - confused
- Decimal to Time
- Add or Subtract Time
- Networkdays function not working
- Lookup not working, appears to be finding the nearest match ??
- Week End Formula
- conditional dynamic filtering..
- what is consolidated command
- SUMIF
- Return the Thursday Date before an Input Date Q
- antilog function
- Macro
- large
- Automatic initial capital letters
- =CONCATENATE("today_is ",TODAY())
- Re: Calculating Working Hours
- Problem with INDEX Formula
- [SEMI-URGENT] Making a Bar Graph like Schedule
- formula problem- minimum cell values
- Re: Printing Cell Notes
- Loop Checking function?
- Extending a Series
- SUMIF Formula?
- Maintain fixed section of formula in series
- More than 7 nested if statement
- Inserting a space between #'s and text within a cell
- if function, sum function problems
- reading data from a cell to a string
- Sorting/Filtering
- Savings setting on Excel autosave
- field increase
- dynamic range help
- large
- Possible?
- large
- reverse range lookup/VLOOKUP
- Is there a way to limit "search area"?
- If worksheet function range and logical test criteria
- Adding selected rows from several worksheets to a summary worksheet