- Putting a date in a sentence dynamically.
- Formula not adjusting to correct cell
- Alternative to Indirect Function
- Excell Pivot tables
- Wildcard in IF() function
- Regression statistics
- IF statement within a IF statement
- Saving Formulas
- Circular Reference
- Concatenating data on a new line(within the same cell)
- Results of calc as part of formula
- outside reference where there should not be an outside reference....
- Re;Excel
- DSUM
- Is there a function......
- Date formula
- Need value of last cell that <> na() in my range?
- Consolidating Files
- datedif partial months??
- Counting sheets in a workbook.
- combining worksheet data
- Auto Save
- "IF" Function
- Re: comparing formulas between two spreadsheets
- numbers to text
- Wildcard in conjunction with data comparison
- Cell values not recognized
- Sum only numbers in red font color
- open Excel97 from Excel2000
- COMPARING AND SORTING
- compare
- ISERROR
- weighted distributions whole numbers
- Re: SUMIF Calculation
- Why Comments Displaced to Top of Spreadsheet?
- UNDO MACRO in Excel
- CountIf across multiple columns?
- YES/NO Result
- Re: help
- rounding numbers to NEAREST odd integer?
- macro that cleans single the unblocked cell
- Hiya, I'm a newby to the group and I've got a question.
- EXTEND DATA BASE
- Data Validation List Formatting
- Continued: VLookup with Variable Data Sets
- Re: Splitting and/or Merging Cell Data
- Invoice numbers
- Hyperlinks
- Formulas not data 0
- return of selected cell references?
- Turnoff Autoformat in Excel
- Please help
- Function Help Please
- Re: "IF(ISERROR(FIND)" function
- lookups
- Error message
- Re: Splitting and/or Merging Cell Data
- Info Transfer Problem
- Is there a way...
- Need formula
- spellnumber function
- scientific non linear curve fitting in excel - how do I get it?
- Worksheet
- Re: Print Range
- Last Entry in Column
- I need help
- subtracting Time
- symbol function for inflation rate
- IS ERROR - VLOOKUP Combination
- I make to write in a cell list validation?
- Re: Print Range
- thank you Paul, Anon, Arvi, Mike
- Re: Can you use the value in a cell to as a cell reference?
- test
- % Problem
- % Problem
- Re: % Problem
- Spellnumb
- Re: % Problem
- Re: % Problem
- Re: complicated date function
- Re: Printing Schedule
- Re: Printing Schedule
- Re: IF STATEMENTS
- Re: Excel hyperlink to folder
- how to left trim a cell......
- Brain Teaser -- Cell References
- #N/A
- formula help please
- Re: Date Formula help
- Re: Date Formula help
- How to convince Excel a cell is "blank"
- vlookup
- changing the DAY(NOW()) code to say "third" instead of 3
- Walkenbach Charactor
- Cell Self Reference
- Move 4th Charachter to !st
- What!
- DEDUPING RECORDS
- Removing ######### result
- MS Excel Sheets...how to copy and paste ?
- MS Excel Sheets...how to copy and paste one excel sheet into another?
- Date Format
- Formula Fill Help
- Re: how to merge 2 colums
- how to merge 2 colums
- Re: Dates after 1900 formatting
- Formula Help
- Dates after 1900 formatting
- LOOKUP Function
- Rounding in Excel
- Filter function
- Re: Rounding in Excel
- Rounding in Excel
- Locking cell color pattern when sorting rows?
- Recalculation
- Re: Using Indirect?
- Re: Lock Worksheet
- Re: serial number translating into date
- how to merge 2 colums
- Can you set the max number of rows for a spreadsheet?
- documantation control file
- Re: how to merge 2 colums
- Updating dates.
- "Changeable" External References
- Need Today function along with text
- Re: complicated date function
- Convert dollars (numbers) to text words
- Excel XP - using Var formula
- #REF! does not show
- Name of sheet required to be adjusted when copied from sheet to sheet
- compare months
- Sorting dates without the year
- Creating spreadsheets from a datebase list
- Calling a user form by clicking in a cell
- Validation-Tiny List Items??
- Plugging Addresses Into Formulas
- Simple Formula to calculate subtotals in cells
- Locking Cells
- Re: Top 3 and Bottom 3
- Re: Top 3 and Bottom 3
- Pivot table sub totals
- Re: Values to highest three scores...
- Naming Worksheet
- Complex? Simple? Filtering Sheets
- References last cell in a continually lengthening column.
- Re: Date Formula help
- Re: Values to highest three scores...
- Printing
- Values to highest three scores...
- Re: Standard Deviation with larger numbers
- forecolor on groups changing based on values in cell
- Extracting information froma cell
- Re: Standard Deviation with larger numbers
- Calculated row number
- How To Count Colored Cells
- linking and summing cells from multiple workbooks
- Saving diff print settings for each tab
- Convert text to number
- Sum groups of data in same column
- Function F3 key assignment
- Re: Standard Deviation with larger numbers
- My Mind Has Left Me
- Text Cell reference
- VLOOKUP
- Fonts changed on it own
- Re: Time Stamp upon data change
- Formula Help??
- Formula error
- Re: Formula for parsing
- Excel
- Problem with INDIRECT arguments in the CORREL function
- Excel Linking
- txt file format
- Excel 2003 Cell changes color when other cell is FALSE
- I use =IF command to determine Trus False agguments, but.......
- Naming ranges
- Re: serial number translating into date
- Autofilter arrows don't display
- VLOOKUP QUESTIONS
- import text file but sop at 65536 row
- Replace value for each cell in a row at once
- Automatic Printing
- Dates -well months anyway
- Hidden Sheets
- COUNTIF Function Failure
- Re: Automatic Printing
- Re: Formulas
- Vlookup - intermittent problem
- Tool/AddOns
- Re: linking 5 cells together or create macro
- how do I
- Security - Locking specific cells
- Re: @IF() Function Options
- printing duplicate headers and footers
- List box
- update vlookup directory
- Currency Values
- checkboxes & formulas
- a summation problem
- #N/A Help
- Vlookup problem
- Possible ROUND formula
- Unable to insert worksheet in a workbook
- Formula to count characters with criteria
- formula to return most recent entry
- Re: Excel 97 and Security
- Re: Fast formula help, please
- Combined column formatting
- Cell References
- #REF! does not show
- Formula
- Re: excel counting
- Convert text to table_array label?
- Re: Fast formula help, please
- WOS
- Using conditional linking (if that makes sense)
- Complicated Formulas
- Re: AutoCalculate Function
- Re: Conditional Formating
- Re: APPLYING TOTALS USING AUTO FILTER
- Re: APPLYING TOTALS USING AUTO FILTER
- PASTE FUNCTION DIMMED OUT ver 2000
- Re: Is there any way to use time in a formula?
- V-Lookup Formulas
- Re: Is there any way to use time in a formula?
- Excel array formula not working
- Sorting Based on From/To Scenario
- Re: Is there any way to use time in a formula?
- HTML Hyperlinks to a specific range work in Excel 2002 but not in Excel 2000
- Locking an entire workbook
- clearing zeros
- sorting within formulas
- inventory controls
- Re: Excel Macros
- RAND() Function
- COUNTIF function
- Change data orientation
- Finding Links within formulas
- Re: Problems using conditional formatting/copying formatting
- Hyperlinks to Excel
- need HELP on a formula
- excel test
- multiple formulas
- copy & paste not working
- Vlookup function
- automatically highlighting every other row
- Need help Summarizing Moving values in Summary Sheet
- Re: Sorting Worksheets
- Erroneous sheet/cell references appearing
- calculating sell through based on running total
- Re: formulae
- concatenation
- Insertina a space between numbers in a column
- numbers in XX:X format
- Re: Different computer used different seperator e.g. "," and ";"
- Re: Moving Information
- Getting text answers without using Lookup functions
- Changing data orientation
- Invoice Counting
- Date formats incorrect with CSV files
- Using COUNTIF with arrays
- Running Total Calculation
- Re: Counting Question
- Wildcard in IF Function
- Checking for duplicate entry
- "if" function.
- Re: offset countif
- Re: Merge help needed
- Excel Header & Column
- Re: nested IF( ) limits exceeded
- Date ranges in functions
- a formula challlenge ... need some help
- Re: nested IF( ) limits exceeded
- Re: nested IF( ) limits exceeded
- Please help convert row labels to column headers!
- Finding the difference in days between two date fields?
- Converting a number to a string
- Re: footnotes
- Re: Column multiplication
- Colour enquiry!
- How to return a range address from a range name reference
- Re Quad combinations
- Re: Column multiplication
- if function
- Default Settings
- Re: Jenks Optimization
- assigning value to a letter
- Indexing Range Labels
- Re: Counting Problem
- convert numbers into times
- Re: Lost sheet
- refresh of cell formulas
- Sorting and linking
- Re: Counting Problem
- Pivot Table Group by Weeks & Months
- ccrptmr.dll
- Re: MACROS
- Links and Excel 2002 (XP)
- Save as backup
- Re: FORMULA FOR ADDING TIMES AND NUMBERS
- Re: Array Formula
- Link not working correctly
- Embedded Word doc w/links crashes when closed
- Re: Array Formula
- COUNTIF
- Re: If(and) question
- Re: If(and) question
- Re: count and tally text
- Re: Conditional Formatting??
- Re: count and tally text
- Count Unique Values
- Re: MACROS
- Re: Help with an INDEX/MATCH function...
- conditional hide columns
- Custom Number Format
- Re: headers and footers
- Dates in Excel
- VLOOKUP with many files? How else?
- Re: Average formula for only cells with numbers
- IF statement and colors
- Re: Average formula for only cells with numbers
- It's a "sin" to use bad syntax.....
- Evaluating data within an array
- Re: MACROS
- Different colour for Autofilter in Excel 2000
- Re: Auto-populate
- cell reference math
- AutoComplete doesn't work well
- Conditional Formatting??
- Cell Reference Problem
- Send To option for mail
- matching and eliminating duplicate data
- Formula is too long
- Is there a limit for this formula ?
- Re: Return value if text found in a field...
- Re: Days between two dates
- Importing And Exporting Favourites Into Excel 2000
- Re: Help with an INDEX/MATCH function...
- "Freezing" rows on worksheet
- Transition Formula Evaluation
- Vlookup question
- Text sentence with a formula ... is it possible
- Reversing column direction
- Formula Manual
- Conditional Sum (In Need of an Excel Guru)
- Index / Match question or other LOOKUP
- Excel Workbook Shared On A Network With Multiple Users
- Formula result as text or number
- formulas excel
- Excel 2002 Formulas
- formulas excel
- Function to filter duplicate values
- Print Worksheets
- I can't open some Excel 97 files in Excel 2000
- Circular Reference
- working with entries in XX:XX format
- How to turn OFF auto hyperlink???
- Re: ?????????????
- SUMIF curly one!
- colouring tabs
- Re: Date Time Picker Control in Excel
- Date Time Picker Control in Excel
- Running excel macro from IE hyperlink
- contain in filter
- Entering dates in spreadsheet
- Linking Worksheets
- Lookup formula
- INDEX/MATCH/LARGE revistied...
- Re: Checking for an existing file
- MACRO TOOLBAR POPPING UP
- VBA Update to Excel Checkbox
- Worksheet Reference
- Converting Time-Date code to MM/DD/YY
- Dates
- End of Cell
- sumif with multiple criteria..
- Data Arrays
- Page Cut
- SUBSCRIBE NEWSGROUP
- Formula/way to compare 2 worksheets
- Subtracting an earlier time from a later time , plus now()
- Worksheet
- Re: dialog box
- Offset and cell formulas
- menu bar disappears
- Adding : to imported numbers
- excel 97: substitute or replace
- Re: What's the difference here?
- excel 2000
- If Cell Contains, then move
- Need help creating a function or macro
- Re: Formula similar to MID function
- Re: Formula similar to MID function
- Re: Formula similar to MID function
- Re: Standard Dev.
- Re: Requesting Formula Help - CAPM / Beta
- Multiple Combo Boxes to return data
- Formula similar to MID function
- Excel 98
- Excel 97 - simple logical function that I can't figure out
- Re: Comparing numbers and matching it to letters in a col
- Re: Protect workbook from being deleted?
- Change Highlight color of active cell
- Formatting Excell cell
- Need Excel Multi-Condition Formula
- time calculation
- Data Sort
- Lookup an address
- Auto up dates of dates in a cel
- Don't Want Zero
- SUMIF or SUMPRODUCT Help
- excel formula
- What's the meaning of [TWN] and [ENG] in Excel number format?
- Re: Data Sort - exclude headers
- Re: Formula similar to MID function
- What is it "Intellisense"?
- Pivot Table Output
- Re: Worksheet name reference in worksheet
- How to expand/collapse a group of rows?
- renameing columns at top of the page
- Excel formula length
- cell lock and small to capital change
- Remove unprintable charactars
- hide colums in excel
- Deleting Duplicate Records
- hyperlinking dropdowns
- Paste Links fails
- Excel 97 counting instances.....
- Re: changing a cell to a combo box
- changing a cell to a combo box
- Excel IF country
- Referring to other sheets within a workbook
- Conditional formatting a row
- Pivot Table and Vlookup
- Re: alternative to IF function?
- Too many rows in Pivot
- Copying and Deleting problems
- Setting Constant Lookup Cells
- AVERAGE FUNCTION
- Row Height
- Incorrect date formats
- Creating a dynamic list sorted alphabetically
- Counting Negative Times?
- Selection structure
- Converting Formula to it's value
- Linking Files
- need a formula
- Excel 2002 Custom Autofilter
- Problem with VLOOKUP and 15 digit serial numbers (IMEIs)
- unlocking option buttons
- CONCATENATE
- How do I recreate a previous calculation?
- Macro that inserts rows
- missing keystroke functions
- Placing Text from Cell on One Sheet into Cell on Another Sheet
- Rounddown formula needed
- combo boxes
- cell change
- Protecting a drop-down box
- Re: lost ALT+O+C+H
- Re: Return last row that is visible
- conditional formula
- Check boxes
- Re: How to Create Drop-down menu (list) in Excel
- Finding data match in range of data
- converting formula in to text or value
- data keeps getting corrupted...URGENT HELP NEEDED!!!
- formula to capture tab name?
- rounding down in excel
- Formulas extend to all cells in column
- Re: Formulas extend to all cells in column
- Re: summary lookupvalue if it appears several times several times
- Obvious math error in Excel
- open Excel 97 file from Excel 2000
- If( ) statement against Alpha character range
- lottery worksheet?
- cells won't calculate
- Help with time and date stamping entries
- Re: function/formula help
- macro referring to a previous sheet
- Re: Workday function in Excel
- "Help with Formula/Decision"
- Protecting individual cells in multiple worksheets
- Drop in Cell Values for Linked Workbooks
- Re: Workday function in Excel
- Site with formulas
- Between 2 Dates lookup and sum help
- Re: How to Create Drop-down menu (list) in Excel
- Printing sheets with consecutive numbers in a cell?
- converting excel worksht to lotus 123 files
- Site I found has some frre addins
- insert rows
- IF statements/ AND Statements
- Re: Counting values in Excel - Office 97
- pivot table based on increments
- Re: INDEX function nested in SUM function
- Advanced Filter
- Re: If statement help please!
- Re: If statement help please!
- Re: If statement help please!
- Convert seconds into hours:minutes:seconds
- advanced filter
- Re: count?
- Re: Undo & Redo Buttons?
- Re: count?
- Re: count?
- Lookup Help
- Chart Problem
- Delete lines within worksheet
- Re: Discontinue message when workbook opens regarding links
- How to replace K with 000
- Changing links for next months spreadsheet
- Excel 2000--printing borders
- non-contigous range ref
- sorting a column when there are drop down lists used
- Re: Creating a database
- Re: "Simple" lookup, confusing terminology
- If statement help please!
- Re: last value in column
- Re: database in workbooks
- Re: last value in column
- Looking for prediction using quadratic curve fit
- DELETE LINKS
- VLOOKUP in external worksheet - Syntax Error?
- Sub Total
- Re: last value in column
- Subtotals and Protection
- Updates?
- Operation on columns
- Excel and MailingLabels
- hidden files
- Formula showing the wrong result in Excel 97
- Editing a Column of Numbers to remove duplicates
- Hiding cells
- userform
- Re: Simple Formatting when cell values already exist
- Context Menu Help!!
- Adding the dialer function to telephone numbers on excel 2000
- Please help with Array Formula
- Opening Old Excel Files
- Autofill date?
- Re: formula toolbar
- Re: Subtracting Time
- Re: formula toolbar
- Count function
- if statements with text
- Save me from a macro...
- number of field in forms for database in Excel
- Row height
- Re: Combo List selection returns position value, not actual list value
- Small Sheet "Too Large" to Copy to A:
- Reference question?
- Cond. Format Formula
- Drop-down Menu
- Links
- Re: Adding time (durations in hours and minutes)
- Defining a range based on a condition
- Calculate the sum of a Time formate column
- Coding for msg box
- SUM AND COUNT
- Assign macro to custom button
- Template Dates
- Separation of VBA Code and spreadsheet
- adding formula to existing data
- Re: "Go to" cells with numbers
- Re: Nested Formulas
- Tabs to worksheets disappear
- Percentrank Limitation?
- For EZ Money re Row Height
- Matching list in excel
- Linked Worksheets
- Memory Limitations and the Use of ""
- Problem Formulas Referenced to PivotTable
- Linking from a Pivot Table
- templates
- INDEX & MATCH ON 2 COLUMNS OF DATA
- Re: Auto Calculate
- Re: Auto Calculate
- Merging Data
- Re: Merging Data
- Carry data from/to master log
- Pivot Table calculations wrong
- continous update
- (Simple) VBA Question
- Re: Links
- Formula result different from value shown in cell
- Excel 2002 Functions
- count date time overnight
- Re: vlookup index number
- SUMIF
- Drop-down menus
- Re: Auto Calculate
- CONCATENATE
- named ranges and vlookups
- Auto Print Funtion
- Moving word tabels to excel
- Combining 3 Arrays
- Re: Countif case sensitive
- Formula for conditioned lookup
- formulas
- Designing a form with background color?
- EXCEL XP: can't open an excel file
- Conditional Format?
- formulas
- Hide/Unhide
- Yield to Maturity function
- Making a large spreadsheet more manageable
- INDIRECT and VLOOKUP
- Re: Formula file reference
- Formula file reference
- Choosing a value in a row
- Re: Formula file reference
- Duplicate Records In A Workbook
- Navigating after find and replace
- Autosum in Excel not working on XP - any ideas?
- Re: Countif case sensitive
- Conditional Formatting in an 'if' statement
- Dateif
- function to count items in two columns
- Re: Rank function not working properly
- Numbers not recognised
- countif for a range
- Re: Rank function not working properly
- formula for finding value in a cell based on date
- Separate address column
- SUMPRODUCT FORMULA
- formulas
- Re: Rank function not working properly
- Search and find
- Excel Spell check
- Auto date population
- Terminology
- Date as Day of Week
- isnumber formula?
- Re: SUM of cells with error values
- USing EXCEL 97, Legal page
- Linking worksheets with a formula
- Linking worksheets with a formula
- Re: SUM of cells with error values
- DATE FORMULAS
- Go To: Special:Visible Rows Only command IS HORRIBLE DESIGN
- Array functions
- Help importing data to word labels
- 3D chart
- Auto Sum from another worksheet?
- staticrand function in Excel xp
- Combo Box Within A Cell
- Fv function in Excel
- Re: Charting Question
- Re: sumif with multiple criteria
- Re: can't use values pasted from web in formula
- IF including a variable cell number
- Re: Charting Question
- Adding 2.5 hours to 4:30 AM ??
- Re: Writing a User Defined Function using Year()
- Cannot move or copy sheet to front of large notebook
- Re: Rank not working correctly
- Password On Sheet Only
- Date format
- Psswd
- Vlookup?
- Rounding up to nearest 5
- unlink a file?
- Vlookup Formula
- Macro - Hide Empty rows
- Re: Excel opens all files in directory
- Re: Excel opens all files in directory
- adding an increment of 1 to existing values
- Re: Vlookup Formula
- disable to create a function in a cell
- Re: Formatting of data from bubble plot !.
- formula display
- Help on a Formula
- Change sort
- Putting the subject field in SendMail
- Extracting date from a cell
- highlighting formulas vs text?
- Re: Display current time when opening document
- Re: Display current time when opening document
- protecting part of a pivot table
- List Box in Excel 97
- Re: Help on a Formula
- Excel 2002 and hidden rows
- Re: Excel 2002 and hidden rows
- Psswd
- Moving multiple columns data to single column
- Moving multiple columns data to single column
- Deleting a Macro you can't find.
- Searching different worksheet for a value
- filter
- Case formula?
- Excel 97 SR-2 Removing a Macro
- lost hyperlinks when sorting
- somme.si et nb.si
- Re: Upper Function
- Matching text strings
- group into Week End dates
- New Line
- Titration Curve
- Re: Problem with formula
- Re: Searching different worksheet for a value
- simple question
- excel question
- conditional format?
- Listing Other Worksheet Information
- Custom Cell Validation
- Extracting Link from a cell
- Goal Seek (in VBA)
- Re: Fuzzy Match Function, Macro or Product
- Re: scanning an excel doc. into excel on computer
- Re: Conditional Sum
- Re: sum of 3 different worksheets
- Changing cell contents
- Looking for Solutions
- Re: Fuzzy Match Function, Macro or Product
- how to COUNT letters
- Window Menu
- Time Calculation
- OCR Program
- Copying formula
- referencing arrays using statistical functions
- Re: Keeping data current
- Lookup functions
- Multi Conditional SUMIF
- Internal error
- Multiple sheet formula
- Re: Number of different elements in a range
- Remove laeding space
- Please help with array function
- Date modified
- Validation source on another worksheet
- Deleting "0.000"
- Protect cell to create a formula
- Help needed with array formula
- list naming
- Re: Calculation error in subtraction: Bug in Excel?
- Re: Calculation error in subtraction: Bug in Excel?
- Looking up half of a cell in the same sheet though
- Function
- Re: Function
- Re: Counting by weekday, week, month and year
- Print header on each page
- showing an array in a cell
- Re: Football scores
- Re: Calculation error in subtraction: Bug in Excel?
- Re: VLOOKUP Help
- how to COUNTIF with more than one
- Possible to calcilate COUNT and sort to show most frequest rows 1st ?
- Open Workbook to Specific Sheet