- List Cell Value In Another Cell
- Number Formatting within an If statement
- finding kth largest value in an array
- Copy Duplicate rows
- Parameters to sum entries
- Help: Calculating loan payments
- Workbook print in black and white
- Opening multiple worksheets
- Need VBA code or MACRO to disable the printing of Excel worksheets
- Re: leading equal sign assumes formula
- combination equation?
- Ensure accurant entry
- populating cells using rank in other sheet
- Headings
- count & if statements?
- How to read values off graph?
- same doc, print different numbers
- elapsed time formatting
- Formating Text/numbers
- Conditional summing question
- Vlookup and dropdown box
- Repeating characters to fill cell width
- Linking a range in an inactive workbook
- IF Statemmtns
- Macros
- variable cell references in function
- Comparing data in a field to data in a table
- spreadsheet
- Copying to another worksheet
- Formula Question - Multiply with Divide
- when printed, the cells are not colored
- If Function
- Re: formulas
- error message appears when I close a specific excel file
- Visual Basic Code help
- MAX and LEN in single cell
- text wrap problem
- formula
- Data Tracking with Template Wizard
- Sum If Challenge
- Sorting / Protected Worksheets
- Day of Week
- run macro on opening
- active cell row reference
- launch macro from a formula
- Excel Sheets
- Visual Basic Code help
- retrieve disk space
- timesheet formula
- Counting items within a cell
- incorporate a button within the document
- Function to find the second largest number in a series of numbers
- 7 IF Statements.............
- Importing Text into Rows
- Advanced Filter
- Index function
- RE: formulas
- Formulas not allowing proper sorting
- DATEDIF question
- Sorting by date
- Junk e-mail
- Time Entry
- Formula
- =NOW() in cell without change next day
- formula
- automatic unhide action when editing
- SUMIF and IF
- which function should use?
- SUMIF and IF
- Subset of workbook B in workbook A
- Help Splitting Values
- graphic representation of a formula with one variable
- Vlookup & if Statement, PLEASE HELP!!(kevin or george??)
- CHANGING VALUES IN A CELL
- dynamic sums
- Finding Text Value in Column
- BESSEL FUNCTION
- countif Function
- Executing a macro in a formula. How?
- Counting Filtered Records
- HELP - formatting issue when upgrading from XL97 TO XL2002
- Moving to next row
- Re: Copy formula problem
- Re: Date related question
- find position of last . in a cell
- Re: Date related question
- Add same colored cells only
- sort colored cells
- Formula Help Needed to Spread Days Across Months/Years
- Copy formula problem
- Adding the Degree symbol in Fahrenheit to an excel spreedsheet.
- Linked worksheets
- If & SumProduct
- How to present Excel on data projector?
- Cell Reference Question
- Tab Through excel spreadsheet
- Concatenation question
- Open to a particular cell in a particular worksheet
- IF Function and business days
- Multiply 2 columns
- Function to figure vacation accrual
- Countif value between two dates
- Calculating weekdays
- Cell reference
- Adding months to a date
- insufficient memory
- SUM Bins of Data
- Referencing different workbooks
- IF Functions with only Business Dates
- hours x rate calculation
- Conditional Formating based on other cell values??
- how to protect a cell
- Validation
- unselect option button for printing
- Count # Workdays b/t two dates?
- Refreshing the displayed rows
- Footers in Excel
- EXCEL
- My brain hurts...
- vlookup issue?
- conditional formating limits?
- Conditional Formatting in another cell
- Look up
- VLookup help please!
- Show a subset of Sheet A on Sheet B
- If Function Question
- Calculating Age
- Execute from With Excel
- quick formula question....
- Lookup for worksheet name
- convert column number to letter(s)
- Formula to count cells ignoring highest and lowest values
- Devide value by 0 or ""
- DSum function
- multiple lookup
- Re: lookup function
- Re: lookup function
- Re: Advanced filter?
- Sendmail in Excel
- Validation effecting other fields
- Returning cells with ID column in another sheet
- UDF not recalculating
- VLookup Help
- Calculating weekdays
- SumIf where sum_range contains text
- Find an intersecting value in a range with two criteria
- Calculating elasped time
- Time Difference (negative)
- 2 conditions which gets applied first?
- adding up text
- Round values to 0.05 or 0.00
- remove blank cells from list ?
- Pulling in data from a table - conditional on period
- Referencing data in a variable field
- Count cells with multiple criteria
- copying hyperlink
- Cell calculation
- How to calculate a page number
- Is there a Subtract If function
- Count text
- lookup for a range around a cell in another workbook
- LOOKUP to various different worksheets
- Excel's precision problem
- Counting instance of a formula occurance
- How to create drop down list having options to the right of cell
- Excel formulas
- Auto form number
- Polynomial Regression
- Can't get INDEX MACTCH to work
- cell reference problem - help!!!!
- show repeated item automatically
- Loop Problems
- Re: Can a Hyperlink include a Cell Reference
- Count of Cell's contents ie Text,characters & numbers
- LOOKUP _ Pulldown menu
- Conditional Formatting
- MPH, MPG Calculation
- How to code an event to call a macro?
- Fantastic
- repeating rows on certain pages
- EMERGENCY - INDIRECT FUNCTION PROBLEM
- Data Validation
- 1-700 clean up
- DDE Link Question
- inventory spreadsheet
- pull down box
- Resampling an array while ignoring zero values
- subscript shortcut
- Need EXCEL advice
- Chart question
- Excel Formula query
- Finding Last Relevant Cell
- Avg automatically
- Tool bar functions greyed out!
- Help please
- sql.request help
- index function
- countif
- Null Value - now a $2,000,000 Question
- Mass renaming of hyperlinks
- Macro to change text color
- Functions are replaced with the wrong results when coping worksheets
- Import text file drops leading zero
- Arrow Keys
- References workbooks
- Expressing a ratio in its lowest common form
- vlookup and fonts
- Find differences between two columns of data
- Format for date in cell
- min conditional statement
- printing error
- Help with a Formula
- Grouping
- Automatic Insertion of a File Path
- datevalue under office xp - doesn't work same as office 2000?
- Rotating a text box or autoshape
- Excel Word Count
- Calculate cell reference
- Returning cells from one sheet to another
- Copy after Filter Error
- pivot tables
- Re: HELP HELP - COUNT IF A SPECIFIC MONTH
- Seek highest value, but reflect column header instead
- dated sum calculation
- RE: HELP HELP - COUNT IF A SPECIFIC MONTH
- Re: HELP HELP - COUNT IF A SPECIFIC MONTH
- Increasing invoice number
- VLookup w/ Error.Type
- Formula text showing instead of result...
- VLookup & Sum function
- Excel linked to net send
- subtracting time
- Single word subjects and anonymous posters
- Problem with date in Combo Box
- External References
- Re: how do i use the IF function with the AND function in th e same formula
- Re: how do i use the IF function with the AND function in th e same formula
- Re: how do i use the IF function with the AND function in th e same formula
- keeping one column stationary
- COUNT DATA
- Function
- How to display Col1 and Col5 for the largest 3 values of Col5
- IF
- Conditional color based on formula in cell
- IF(OR or IF(AND with EDATE I think!
- IF fuction for a RANGE of cells
- greying-out Excel cells
- Date last modified
- TIME FUNCTION CALCULATION
- Help with a formula
- Modifying a Macro - Auto Save WorkSheets as Workbooks
- auto SUM a FILTERED List
- OR Function Problem
- Help with formula
- Average
- A B C D column names and 1 2 3 4
- Excel formula not activating??? -- Pls. help
- Autogenerated order number
- How To: Aggregating multiple workshheets
- Array formula - updating
- Inverse of HYPERLINK worksheet function
- Extracting the chars to the left of a " ("
- roots
- how to match two array
- Did I record that?
- Keeping Data intergrity while sorting
- Inserting series every 4th cell?
- Unique combinations of 4 numbers between 1 to " N"
- Detecting Cell Format Using Named Formula
- Unique combinations of 4 numbers between 1 to " N"
- Macro for Bolding a Cell
- Re: OT: Microsoft Security Bulletin Release - November 11, 2003
- Assign Macro to AxtiveX objects
- Using Access forms to enter data
- Help. A twist on summing visible rows
- Need help!!
- How to count the populated rows in excel
- Import Excel into Access
- Help on if function
- IF Function
- Relative Cell Reference when recording macros
- Formula Help
- Showing contents of cells in other xls file
- Displaying Pivot Table Totals
- referencing previous sheet
- HLookup
- Validate students name and ss# on two seperate spreadsheets?
- macro for saving worksheets as workbooks
- finding quarter date information for accounting
- Have Excel Open to a certain Worksheet
- Excel "Columns&Rows" sizes
- Help on if function
- Macro warning
- using cell background color as basis for formula
- linking data in excel
- Problem with INDEX function to return top 3 objects and sizes from a list
- "Link" cell data if invoice numbers match
- Sorting based on a drop down list
- Question
- workbook.xls:2
- Excel 2003 bug
- Re: conditional formula
- conditional formula
- Excel Page Count Query.
- Importing Blank Cells
- Macro: Save Sheets as Workbooks Part 2
- Dynamic Range
- text after formula
- complex array formula: help! range change works only sometimes
- Re: is there an option
- Checking a cell to see if it ISBLANK?? HELP PLEASE!!!
- Re: help with a formula
- Year/Month Calculation
- Listing filtered data from related spreadsheet
- manual calculation doc
- combine two lists of data into one list in sheet or PivotTable
- Printin in Excel 2003
- excel automatic add-ing
- Excel highlighting
- Helpfunctions to Analysis ToolPak
- Search function - Urgent
- SUM formula for adding time durations
- dynamic averaging
- Pivot Table and Countif Function
- Display ASP Results in DIFFERENT worksheets
- Copy Unique Records ... Formula?
- Macro / close a workbook without saving
- Text Import Wizard
- newbie - saving macro for use on another comp
- Encryption to change contents of a cell
- Finding capitals in a cell
- fill series data
- shortcut keys
- divide equally
- Linking workbooks
- Howto: relative & absolute cell references
- problem with vlookup
- First three positions from a column
- Autofilter and zero's in blank field questions.
- Question mark key made everything disappear
- How do I use ADVANCED FILTERS?
- Function to find a match a given result
- negative hour/min values
- length formulas
- Formula needed thanx
- How to change the column reference from R1C1 to A1 Style
- Fill Down
- Merge date formats..... and more
- Highest and lowest value from column
- Date format in cell
- Excel/Percentage
- IF statement??
- changing to proper text
- Convert seconds to mm:ss
- Coloring Subtotals
- How to convert text to numbers?
- user defined date/time format
- Displaying text based on a formula
- =Rand() Help
- Find Wont Find Value
- disable macros
- excel form lines /and print command
- changing text in a formula
- Credit Card Number Suppression
- More help on a current issue
- COUNTIF & INDIRECT
- Can I have four logical questions?
- Data Validation
- 1 pivotable, 2 different data source
- Tabs
- Count the occurrence of words in Excel
- Creating a Custom Excel Formula
- Copying Calculations
- Help with averages. Please!
- Data
- How to create formula for combining two cells as one cell
- Locking formulas in cells
- Name Range + Data Validation
- Using IF function with Text?
- Return last completed cell in a column
- RANGE NAMES
- Paste Less Decimal Places
- Advanced VLookup
- Finding Last Contiguous Column Cell Entry
- hyperlinks
- What's wrong???
- For "Dan E" <nospam.danlelliot@nospam.hotmail.com"
- similar to # with '...what about a formula with ' before it
- Array Function - cell to remain blank
- Array Function - cell to remain blank
- Array Function - cell to remain blank
- How to Convert Numeric Values into Text Values with a Formula
- Copy Data to Sheet2 if cell in Sheet1 is not blank
- locking formula reference
- Graphing data
- Unpivot
- Which function? - Frequencies for three set criteria
- Hyperlink "empty"
- Grouping Dates in Pivot Table
- Assign a multiple commands
- EAN Check Digit Calculation
- External References
- External References
- Re: letter and numbers substitute
- date formula - help
- Comparing Two Text Based Lists
- hlookup to propigate validation table
- Sheet backgrounds disappear intermittently
- Reading and populating a worksheet
- Multiple Source Data for what-if-funtion?
- Compounding
- Adding up numbers again
- Discounting Cashflows
- Automatic links shows up as a #Value# error in EXCEL XP but not in EXCEL 2000
- Getting Formulas to calculate
- Comparing 2 worksheets-HELP
- Reference another worksheet based on a cell value
- Names of Columns
- Present value several sums
- USER
- Is there a different function for Getting a Date?
- calc hours from date/time to date/time
- Summing multiple categories - Help!!!
- Exporting multiple worksheets to one .CSV
- Changing Text From Across to Up and Down
- Repeating Numbers In Numerical Order
- excel 2000. format tab color, available?
- Using .bmp or .ico for custom excel toolbar buttons
- ? for Harald Staff on copying 52 worksheets
- Using a popup calendar for cell entry
- unknown function
- Combining columns
- Standard Error function
- Copy and paste?
- Can't remove unwanted HTML icon
- Sorting numbers with ' preceding it
- EXCEL
- Forumula Help?
- RED cell in ROW move to Sheet2
- sum if duplicate
- Extract data from a list within a specific date range
- "Gray" excel charts out w/- no Graphics
- Date Intervals
- Stock quote does not work in Excel
- Link to different tab on worksheet
- Zeros and blanks ruin average and median
- How to change color if 1 month old?
- Identyfying unique values in a range
- if statement
- spliting a matrix in 1 column
- Identifying unique values in range
- Change sign of entire column of numbers
- Tool Bars
- Coloring Rows Automatically
- Excel file Size Issue
- How to Transpose a table to a single column
- IRR
- Sorting
- Create a macro to copy worksheet 52 times & rename
- Can Quicken information be imported into Excel automatically?
- Data Validation
- getting vlookup to return a formula instead of a value
- Summing problem
- Making up a grade sheet for school
- subtracting time
- Nesting IF statements with {..}
- Lookup? find name in cell
- Is it at all possible to turn off Worksheet Menu Bar ?
- open templates at especific time
- Nesting a nested function with {..}
- Dropdown Box to Select Data from Another Sheet
- open templates at especific time
- COUNT, COUNTIF Counting Help Please
- Help with a formula
- FILL A RANGE OF NUMBERS
- "IF" Function Arrays in Pocket Excel
- getting a cell address from a VLOOKUP
- Nested Loops - If function
- not eqaul
- Difference in time (in minutes)
- SUMIF Formula
- A dilly of a question!
- Forecasting sales volume totals
- Long Formulas
- Combo boxes
- Summing compounded growth rate periods
- Compare and Merge
- Excel / Email Macro
- designing & installing icon add-in for macro
- Is it possible to automatically sort cells easily? (I'm going mad!)
- An autofilter that can filter arrays of time
- Irr function
- Delete a link
- changing a circular funtion into one that works
- Production Tracking
- Logical test to return one of three values
- nested if and ranges
- how to tag an excel file with location on drive
- VLOOKUP
- HELP! Return data if cell in row contains data
- Macro for Selecting Several Worksheets / Ron de Bruin
- VLookup is odd
- Pivot Tables and Formatting
- Array Formla
- Auto Sheet sorting
- Macro - SendThisSheet
- Password protect & read only
- Delete/Removed Linked Worksheets
- Data validation query
- number formats
- FINDING A COMBINATION FROM A LIST TO EQUAL ...
- Combo Box referring to selections of another combo box
- All pastes from other apps altered after macro - not what I wanted
- Macro for Selecting Several Worksheets....
- Percentage difference between two numbers
- Automatic calculation
- sumif between dates
- vlookup from more than 1 sheet.
- SORTING
- Excel Right-Mouse Click
- Use date document created in formula?
- Unique Entries with a Twist
- Macro to read to end of column list
- count conditional format colour
- Need to reduce amount when another amount is entered
- Hyperlink in formula
- xirr function
- MAX function
- xy scatterplots
- Fonts appear very large sometimes when I open my spreadsheet
- Excell time sheet
- Countif multiple criteria in same cell
- Substring not found
- Is it possible to print without the colored cells printing any color?
- Error with data validation/vlookup
- table lookup function
- File Properties Information
- attachment
- CountIF
- automatically sorting values ina range
- Convert UNIX dates
- If statement help, repost, number result from text
- Re: Avoid copying non-blank cells
- compare Excel files ?
- Trend lines
- Re: Calculation
- Re: Calculation
- Excel Treats All Dates from the Previous Century as TEXT & Can't Change Format
- #N/A when array size mismatch
- Excel
- Concatenate
- Re: DATE
- Re: saving workbook upon closing program
- Re: DATE
- Re: Macro pop up warning
- Re: Sort does not work
- DATE
- DATE
- DATE
- Finding a Circular Reference
- IF THEN Statements...
- help with a formula
- Re: Formatting and concatenate ?
- RATE function code
- Last Name, First Name
- Rounding Up to Nearest 1/4 Decimal
- "OR" function
- how to find 80% value using formulas?
- Rolling chart
- ComboBox choice to cell, = headache
- Move selection after Enter
- linking data from dbase to spec sheets
- VLOOKUP and Combo Boxes
- IF help
- IF Then statements
- Percentile Function
- How to Change the Color of multiple cells when multiple cells returns text of "x"
- Where can I find help on terms like offset range and activate?
- Averaging a range of numbers
- Do not print
- Format Cell is Disabled?
- Excel worksheet stop calculating; no answers
- VisualBasic/Excel "GetOpenFileName"
- What If function
- Excel-Logical Function (Question#2 of 3)
- Excel formula
- Excel-Date Calculation Question#1 of 3
- What function do I use?
- Data Analysis
- lookup function?
- COUNTIF and SUMIF Functions when there are 2 criteria
- Supresing zeros in a field of a Pivot Table
- GetOpenFileName
- Getting rid of n/a in Vlookup
- moving blocks of text
- Formula for cost mark up
- IF statement based on "nonblanks"
- Adding cells on worksheets
- ZIP or Compress FIles
- Data Entry Box
- Re: Format Cell is Disabled?
- Multiple Column Lists - Different!
- Re: Format Cell is Disabled?
- sumif in combination with vlookup
- How Long
- Automated copying of Blocks of data
- Removing Leading Zeros
- hiding a cells
- solver help
- God
- View 2 different Excel worksheets
- auto printing
- indirect worksheet references
- Need another formula
- Calculate and rounding function
- date changed when sheet changes
- Return value in row if range of columns contains something
- Excel "branching" Macro
- Excel "branching" Macro
- Greater than, less than formula
- Avg amount per day - Excel XP/2002
- Decimal?
- Returing a value depending on hi-lo range
- Help - my toolbars have disappeared
- Calculating currency values
- Embed the value in a cell within the offset command
- Automatically anchoring a range of selected cell
- Vlookup frustration!!!
- navigate on a sheet down "x" rows
- formula adjusting
- Reference worksheet tab in cell, vice-versa
- Copying subtotals
- #N/A
- Link to different tab on worksheet
- Rounding to the nearest 5 cents
- Msg Box Popup
- formula or function
- Change case in database fields from CAPS to Proper
- inserting Blank Rows
- XIRR
- density probabilities
- Need a formula
- Can You Reference a Cell in a Hyperlink?
- Max # rows to process in excel
- Formula Help
- Pivot tables
- Sumif question
- Blank cells
- 2 stage vlookup or option
- Row Validation???
- Bullets in Cells
- Shading every other line
- macro to save a workbook as a .csv file type
- Sorting worksheets
- Find & replace
- Need formula to post data from one workbook to another workbook
- Table of Contents and Idexing
- Dropping leading zeroes on import
- Sumproduct, text label and errors...
- counting number of unique entries in a list
- How accurate is Excel (2000)
- Word/Excel Linked Templates not saving on exit
- Count text if another range has met criteria
- Leading zeroes
- auto sum function
- Combo Boxes and Dates
- Pulling info from one worksheet to another
- convert numbers to alphabet
- Re: formulas
- Random function
- Help Please with Growth Formula
- Excel - Vlookup
- AVERAGE function does not work
- insert result into different cells depending on value
- Comparison worksheets
- zero
- Formula references when copying a workbook
- How do I Rank Dates?
- multiple arrays in single statement
- Random function
- content coloring
- look up x and y axis
- I need a MATCH formula that can return "true" or "false"
- asp to Lotus
- MSQUERY: Linking EXCEL & ACCESS
- Getting Rid of Duplicate entries?
- Need help with Rank function
- Averaging-completed e-mail question
- Square Root Forumula
- Table "What If" Set Up If I Change One Or Two Variables
- any way to change array size?
- I would like in column A to display names of all my worksheets.
- count function??
- count function??
- Numeric Operations to a Filtered List
- Change items from down - to across
- Pulling Text from 2 Cells and Joining in a Third Cell
- Count function...i think
- INDIRECT & Closed Worksheet
- paste link and transpose simultaneously
- column width
- File Name Retrieval
- =sum with 2 criteria
- Can I "sign" my own macros? or some other fix for the message about security and macros?
- Opening multiple files in numeric order
- format ssn to show w/o dashes
- Conditional Sum Help
- array or IF formula problem (?)
- formula for averaging months
- DEFAULT
- no duplicates
- NETWORKDAYS Function
- How do I format this cell
- converting
- Engineering Notation
- GOTO
- Check Boxes And Macro HELP
- Calculating Ages
- Worksheet compare?
- macros in excell 2000
- Allowing access to 'grouped rows' whilst worksheet protected
- Fomatting Text
- Convert a column of data cells to a row?
- document named ranges
- For Ron de Bruin
- Time in hunderds of seconds
- Amort: known pmt yields how much loan amt?
- Statistics
- sum if (problem: number text
- Need formula to find cells that contain only lower case text entries
- Conditional format
- Trend watch
- formulars
- Linking a number automatically to several sheets
- Linking Numbers from one sheet to another
- Protect VB
- Finding the Value in a Last-Filled Column-Cell
- Resetting horizontal scrollbar
- awarked calculation
- formatting text in cell
- number formatting time codes
- Check Boxes
- COUNT function - problems
- 'IF' Function - More than 1 Logical Test's
- Duplicated Values
- filtering data
- copying one sheet to another
- Hyperlink
- Delete rows with "-" cells in VBA
- IF statements