- Planning system
- Convert all zeros to blank cells
- Open workbook macro
- Urgent Help -Converting cell from "K" value to Full Value
- URGENT: Adding Text to existing text
- LINEST
- Time based question
- Converting number to month
- Worksheet CodeName
- Count Number of Dates in Date Range
- 2 values to one column
- Excel drop down list problem
- Read from Excel and write into another Excel
- Data analysis in Excel
- Text referencing method
- calculate Score by function
- autofilter in protected worksheet?
- Autofill misbehaving
- RISKTNORMAL
- Excel training exercises
- Borders not printing
- Drop down box
- Formula or Macro?
- Return address of last cell
- Excel : Calculating Elapsed Time
- Removing last few letters of string
- Day/Date problem
- if function...i'm not sure..please help
- *.xls:1
- Set a column to not print
- zero vs. null value
- Re: If Then statements and format of results
- Re: If Then statements and format of results
- Days left until...
- Weighted Average for Different Aggragates of Duplicate Entries?
- Extract specific rows into other worksheet
- Calculating Calendar Dates
- please help
- Urgent Macro help needed !
- sheet name
- Re: sumif function
- Cell Color
- RSQ Visible Cells
- SORTING
- fmax function?
- Transposing Formulas
- calculating dates based on workdays only
- Re: linked cells - named vs range
- vlookup function
- Consolidate data from different files
- Date Stamp: date last changed Macro
- Add 2 Range Names
- If statement with more parameters
- Drop Down
- Re: Scaning a document
- Consolidating 2 fields into 1 ???
- 3d worksheets simoultaneously changing information in both
- Re: Sum, IF, Subtotal ???
- Excel Reference or VLookup?
- Sum, IF, Subtotal ???
- Data format change
- Command button
- Sorting protected cells
- Protect Worksheet and Keep Grouping Functionality
- sum based on specific criteria
- Edit function on macro tool will not highlight/function
- Transpose Question
- Name change of dynamic data
- Search and find latest revision
- Sorting Pre-1900 dates
- Help with Graphs!
- Hiding rows across sheets.
- Sorting pre-1900 dates
- Calculating elapsed time in hours:minutes (minus weekends [48 hours])
- Verification of cell content
- A tough one!
- Date format it text cell.
- Printing a list in columns!
- splitting adress and zip-code
- round off?
- networkdays formula
- Conditional Formationg Color
- String seach within an Array
- Upside Down Text
- breaking links
- Sum Values after finding last cell
- FORMULA FOR DUPLICATING COLUMN CONTENT
- Re: sum based on specific criteria
- Help with formulas!
- Locked Shared Workbook
- Re: Referencing a cell open a workbook
- ActiveWindow.ScrollColumn (Question)
- Adding data and date
- Convert positive numbers to negative
- vlookup
- Running Macros
- Vlookup or if then
- Removing a calculation formula leaving the result in the cell
- Re: Running Macros
- OLE Size
- FV function (pv argument)
- Converting unc to mapped
- Hyperlink
- Time Question
- Re: Time Question
- Re: Time Question
- links and weighted least squares
- Changing Text color when a date has past
- Formula Error
- duplicating sheets
- Re: duplicating sheets
- Re: duplicating sheets
- Exporting information to Word
- Formatting Cells
- formula to count subtotaled rows
- Linked File Updates
- Formula for budgeting
- Shared Workbooks and Taskbar
- multiple if statement
- Using A Scroll Bar Control
- Vlookup help
- "and" "or" in formulas
- Formula
- conditional formatting
- countif formula
- Re: prime function
- formula
- Getting the reference path that a cell is pointing to
- Can't Total Value in Given Cells
- Finding lowest used range from several columns.
- If And Or?
- Conditional Format - new
- Does Not Recognize Dates Entered
- linking worksheets (ex. =sheet1!A2)
- interrelated constraints
- I NEED HELP ORGANIZING DATA BY DATE!
- Formula Help
- Command Button to open File
- Data Validation
- Re: 3D array/sumif formula
- Macros
- using functions with macros
- function shall retun #NV
- Re: Drop Down Menu problem
- Date and Data
- Excel 2000 Using COUNTIF statment with OR statement
- Re: prime function
- Re: Multiple selection of drop down list
- Re: Multiple selections from a drop down box
- Re: Macros
- Linked workbooks
- Time Counting Function
- excel sheets
- Return nth value from list
- email function
- Formula meaning
- Saved macros
- Help please
- question
- Unable to record macro
- command button
- Re: prime function
- Lists (Using INDEX vs. MATCH function)
- Re: Running Macros
- Is there a FFT function?
- Copying Conditional Formatting
- Excel Formula CountIf
- upper function
- FiItered results not displayed
- Excel - filter results in column, need to find adjacent column data
- importing data
- Consolidate data
- Margins Do Not Fit Page Size
- Re: range name vs multiple cells
- Random integers
- Gegevens zoeken
- Counting unique instances of data in 2d range
- Array formula help
- quickjump problems
- Scrolling in a cell?
- Degrees Minutes and Seconds
- Range names selected from within a cell
- Excel worksheets
- Finding same cell
- Mixing both text and a formula/function in the same cell possible?
- Employee Reviews Pulled by Date Range
- Copy Row into Column
- vlookup using 2 reference columns
- How to pass parameter in "open" function
- Filtering based on two different range criteria
- Countif, Lookup, Match ?? unsure newbie!
- Scroll Bar
- Guys,can u help me in this ??
- Problem with DATEVALUE
- Countif
- Protect a group of cells
- Sheet Properties
- Chart options?
- Enter the same value for a group cells.
- FileName.xls:#
- Merging sheets
- MID function
- DGet Function
- Defined names and SUMPRODUCT
- Link a cell to file name
- Please disregard previous two posts
- Re: Defined names and SUMPRODUCT
- Number codes
- Would use Array formulas but....
- VLOOKUP in a macro to...
- help with vlookup or if you have other suggestions
- replacing text/ data throughout workbook
- Using ISBLANK questions
- Watermarks
- Formula Help (Continued)
- Link a cell to file name
- Figuring Profit Margins - HELP ME!! PLEASE!!!
- Macro help needed...
- Re: Defined names and SUMPRODUCT
- Comparing 2 Tables
- Importing data
- Text
- If Statement and Validation Lists
- Automatically Bold Portion of Text within Cell
- Age using date formula.
- formulas: adding columns
- VLOOKUP
- Workday
- Age using date formula
- Re: Workday
- =RIGHT function
- Re: Workday
- Re: Workday
- Re: Workday
- Can you combine SUMIF & MID functions?
- Repeat a value down a column until a new value comes up
- Formatting SSN as Text
- Subtotal a list
- Function
- Replace text in files
- Macro mistake.
- Re: Multiple LookUps?
- Employer Spreadsheet
- Recognizing SSN
- excel function for sorting by month
- Long Formula...Can it be shortened
- Is there a between 2 numbers function
- Excel spread sheet cell
- Copy entire table to a column
- SUMIF for two or more columns
- Function for rankings
- Small List Question
- Userform.show Pops Up Underneath Spreadsheet
- Excel 97 & VBA Runtime Error 1004 with Find
- Need help in 3D worksheets
- why don't my formulas adjust as they shift down rows?
- skip cells on data entry
- Recognizing SSN again
- Drop-down list - process automatically.
- Reference a ToggleButton in Cell Formula
- Help: Iterative Operations for Election 2004 Project
- help with Conditional Formating
- array help
- Save As Command
- Email address
- Re: Multiple LookUps?
- Function to exclude cells from formula
- Validation Lists and IF statements
- change multiple formulas at once
- Copy cell data to 2 cells
- excel 97 piv tabs
- Fill combo box with column entries
- Complicated ?? IF/AND Formula Question
- Re: Hyperlink to sort data
- Re: Osama Found Hanged
- If Statement Help!!
- Function to Display Sheet Name in A cell
- VBA Conditional Formating Color
- Combo Boxes, List Boxes
- COUNTIF
- Re: Object Binding and Scope
- equation is true but i can not bring the number i want
- GETPIVOTDATA with Date
- GETPIVOTDATA with Date Criterion
- Re: IF with V-Lookup
- Executing a string as a function
- macro help
- Re: Time Value of Money
- Re: Time Value of Money
- Re: Time Value of Money
- Re: IF with V-Lookup
- GETPIVOTDATA with Date
- Help with a date modification
- Re: blinking cell
- Normal Distribution Curve
- VLookUp "#N/A" message
- Copying a string, capitalized
- Re: blinking cell
- Calculating months
- Fill / Series / Alpha
- blinking cell
- USING QUOTATION MARKS AS A TEXT STRING WITH THE CONCATENATE FUNCTION
- TYPE(B290:B295) in Excel 2000
- Please help!
- SUMIF font color
- Add/subract the same value to every line in a column
- which financial function?
- Does AND and OR work in an Array?
- format date 20040701
- Re: DSUM and Blank Cells
- Re: Lookup, verify and calculate dates from an entry then...
- Counting negative & positive numbers
- Re: DSUM and Blank Cells
- Re: Summing values with Multiple criteria
- Custom AutoSort for multiple years
- return Column as string
- Formatting cells to auto number??
- Re: FIlter text within a field
- Re: Summing values with multiple criteria
- Extending the the visiable area of a validation list
- Conditional formatting and "autoselecting" cells
- excel
- LOOKUP functions from cells containing formula . . .
- Recognising text as data
- ranges in arrays, is this possible?
- Re: I've lost my brackets
- Counting letters for male/female
- DGET not updating
- countif question
- excel xp2003 file: can it be red, shared and modified with xp2002
- Using the Fill Function for Alpha
- AVERAGEIF problem
- =ROUNDUP formula question
- AverageIF problem... (Continued)
- Multiple column array
- how to switch a #N/A value into 0
- how to switch a #N/A value into 0
- Need Formula Help!
- Re: Executing a string as a function
- Time Counting Formula
- EXCEL
- SUMIF question
- IF statement w/ several requirments
- Linking to Another Workbook
- Pasting large amount of text into a single cell
- Hyperlinks.Delete without losing formatting?
- Re: Creating Pivot Charts
- HELP CREATING A FORMULA
- Formula with a text result
- Counting multiple occurances within a cell
- Re: Conditional formatting row
- Degrees minutes seconds to degrees
- Average of Date
- Backfilling monthly volume forecast based on annual forecast
- Simple Math
- How to take out comma (,) in name format
- "Function Not Valid" - Getting Rid of the "@" symbol
- How to remove Comma In name fornat
- How to use ISERROR
- Formula explanation
- Matching formula
- Thank you
- link 2 tables from 2 different workbooks
- complicated formula
- COUNTIF Function
- Find & Replace
- Name Box
- Counting frequency of value in a range
- Formula: Yes or No IF cell contains one of two letters
- Help with formula please
- Date viewed as number
- Calculating Elapsed Time
- counting cells in a range w/two attributes
- Sumproduct and Subtotals
- Fill Function for an Alpha Series
- Return values in a row from a value in a column - Help
- sumif based on fill color
- OFFSET
- Expanding groups in a protected sheet
- "IF" statement displays "False" instead of "0"
- Size of worksheet
- need help with nested IF AND OR function
- Another VLOOKUP question
- Re: Concerning lookup tables
- using arrays to sort data?
- Msg Box
- Counting Conditional Formatted Cells
- indirect
- Re: What formula to use
- Re: What formula to use
- creating a "time stamp"
- Date function question
- "Between" Formula
- Using Lookup or Match?
- conditional formatting
- Re: Calculation a running total w/out creating a circular reference er
- speach in Excel 2000
- can't figure out how to add cells in ColB if cells in Col A match.
- Sum if in value in a comma delimited list in one cell
- User Functions/Personal.xls
- drop down menu calculation
- Re: testing for zero
- Automatic calculation failure
- Re: Lookup & Reference
- Re: testing for zero
- testing for zero
- Calculating Wage Increases on a Sliding Scale
- Re: Lookup & Reference
- Re: testing for zero
- Re: Lookup & Reference
- Error: Undefined or non-rectangular name
- pushing results to another cell
- Re: Lookup & Reference
- DAVERAGE isn't working
- Re: sumproduct
- What formula would I use?
- dget() on l_o_n_g text
- Subtotal not working?
- Worksheet sharing
- Average # of Days by Name
- Testing a cell for a function
- Linking Workbooks
- Display
- Number of n's in a range
- Get username from windows
- Big Problem, can't get sheet to calc correctly
- How to categorize a range of text data based on specific words in the sentence
- RE: formulas: adding columns
- If statement problem
- formula needed to convert a numeric value to text.
- How do I add a find feature to Excel Spreadsheets?
- Custom fill in series
- Dget problem. More than one row
- financial functions not in 2002
- apostrophe in front of all my text
- protect code
- ignoring text?
- vlookup
- Please help me to create a formula for my database....
- My hyperlinks address has chenged in my workbook
- Merging Documents in Excel
- Formatting cells to Accounting
- converting time
- Calculating a cell address
- Multiple Vlookups in a range
- Clearing cells with formulas
- Unique Data Filter Help
- Lost Edit Menu on some of my spreadsheets
- EXCEL IF Function problem
- #Value
- Formula evaluates to #NAME!
- = function
- Match builtin Excel function
- Match builtin Excel function
- templates
- if statement help
- Another Question Frank
- Transfer of Balances
- IF function
- IF only.....IF only....
- How do I display negative numbers with brackets
- using the forecast function
- Max length for formula
- Shared spredsheet #NAME? error!
- Combobox Help
- filtering dates
- Vlookup and Hlookup in a forumla
- dates & lists
- #VALUE
- Username
- No Border?
- dates & lists
- dates
- Date stuck as text
- Sum of 2 columns
- Using External Data Ranges on a network
- =Value(A1) returns #VALUE
- help needed...
- Sumif ???
- #div/0! error returned from function
- conditional formatting
- formula question
- conver amount in words
- lookups
- Hyperlink to ASPX page
- "Last saved" information
- countif date function
- formula help
- Changing negative numbers to positives..
- Bulk Faxing ???
- Vlookup post codes/zipcodes query
- Trying to total the number of times a word occurs
- Dividing information within a cell.
- Referencing a cell
- Referencing a cell
- please help...
- count instances based on two criteria
- adding numbers
- Capturing File Attributes
- Text
- Saving as .pdf in adobe
- opening a read only file
- dates
- Conditional Formatting Formula
- Find Button in Excel Spreadsheet
- macro / function?
- Subtotal Quirkiness
- VLookup not finding lookup value
- Convert Number to Time
- Re: Removing duplicate numbers
- Formula issue
- Single Use Values in a Specified List
- Deleting & Inserting Rows
- Macro again
- Creating MM/DD/YY from 3 separate columns
- Re: IF worksheet functon
- Unable to diable macros
- Collapsing Dates into Categories
- Mouse events on an Excel sheet
- Any Date...
- IF Statemement using dates.
- SUMIF AND
- Inputting info on one worksheet and having it post on another worksheet by location
- Excel IF Function Problem
- weekdays per month
- Holidays in a Lookup
- counting cells
- TEXT
- Text in Formula Answer
- Re: Excel Football Prediction competition
- If statement
- Text in formula answer2
- IF
- Turning off auto date formatting
- move text from one cell to another
- Is there any function wich returns a range as text?
- Formula trouble
- Deleting columns
- FORMULA NOT WORKING
- Sorting Data Within the Same Cell
- Time stamp
- SumIF/CountIF data
- how to conditional sum in a matrix
- Lookup with variable name
- VLOOKUP #N/A
- "Unable to Record" a macro in excel 2000
- using Vlookup to find multiple results
- Named of Named Ranges for validation
- Re: COUNTIF TO REF. A WORKSHEET ?
- Re: SUMIF with multiple criteria
- COUNTIF TO REF. A WORKSHEET ?
- custom formats (xxx-0000)
- VLOOKUP #N/A
- SUMIF with multiple criteria
- Conditional Format
- Changing format of imported data
- Days in Month
- Nested IF
- Re: Days in Month
- Re: extracting part of a cell value
- Re: If functions
- VLOOKUP Or HLOOKUP or any other?
- Re: Custom Function Problem
- Re: Change this formula for military time?
- Re: VLOOKUP , MATCH ?
- Re: Vlookup#N/A
- Re: Calculate a rate based on whether or not a date is between 2 other
- VLOOKUP #N/A
- Re: pivot table drop list
- Sum in column dependent on another column
- Q: Dynamic Sum function?
- Q: Dynamic Sum function?
- question/trouble saving worksheet
- Re: If Formula with Dates
- Simple IF Statement
- Re: VLOOKUP #N/A
- Re: Sorting problem
- Autofill updating sheets
- RE: VLOOKUP , MATCH ?
- more than vlookup
- Macro Help
- Re: Sum of cells
- SUBTOTAL Second Count / sub-count of Filtered Visible Cells
- Extracting data from a table
- IF, AND, BUt
- CountIf Function
- Combo Box
- Excel
- Search either of two items
- MROUND Function
- auto underline
- Re: I get a Message.. No more new fonts may be applied to this workboo
- Re: return formulas from lookup results
- help!! please!!
- Re: Finding roots of non-linear equations in Excel
- V lookup
- Re: Search Function
- How do I return a list from hyerlinked total
- Re: Hard to describe this one
- Re: Hard to describe this one
- Re: Macro help
- Help with long formula - how do it shorten?
- Copying Data from One Sheet to another
- Frank, I need your help, PLEASE
- Re: IRR (INTERNAL RATE OF RETURN)
- Re: looking values in tables
- Re: looking values in tables
- Re: looking values in tables
- Print area ?
- Round up to the next 200
- Re: Changes from Excel 2000 to Excel 2002
- conditonal formatting
- Lookup and then some
- Lookup
- If nested function
- Excel comments
- delete files
- help with macro please !!!
- Find a space from the right
- How to sum up one column depending on two conditions?
- complicated share of market
- RE: Limits for the MMULT function
- Strip off all formatting
- Re: Days in Month
- Matching function
- Date Query - Look up or IF????????
- Is there an XOR function??
- Date Query - Look up or IF????????
- error with XL XP array functions
- CONVERT EXCEL DATA INTO WEB PAGE
- Adding extra columns (More than 256)
- comparing todays volume to yesterdays
- worksheet tab stuck
- Excel's IF function
- Address Function
- IF function
- Problem with the lookup.
- vlookup - #N/A
- copying data from a different sheet and autofilling.
- print command
- Excel 2003: Need help converting from text to date/time format please
- Drag Handle
- nesting in array formula
- Conditional formatting
- IF statement Problem
- Trying to reduce # of logical tests in "if" statement
- changing time format when concatenating
- Use a cell value to refer to another worksheet
- Re: How do I create a SUM formula where the range is a function? Look at INDIRECT!
- Formula for postal codes
- Freeze buttons?
- excel spread sheet.
- Convert dollar amount to text
- Convert dollar amount to text
- Re: Getting address of a maximum
- Re: Getting address of a maximum
- Re: Cell number of a maximum value
- Picking out dates
- Re: Avoiding zero when using vlookup
- Cell number of a maximum value
- Nested IF to deep
- Can Formulas be used with Combo Boxes?
- And function
- Finding a list in a string
- Re: Cell number of a maximum value
- Re: Rounding the result of an IF function
- Re: Rounding up the result of an IF function
- Re: Rounding the result of an IF function
- Re: Finding roots of non-linear equations in Excel
- Setting Cell background color using an IF statememnt
- Determining if cell contains formula or value
- Re: Linking to Dynamic Named Ranges (Excel 2003)
- Using Pivot Table with VLookUp
- IF
- Upgrade From ME to XP, Excel formulas do not work
- Creating a dynamic link in a workbook?
- Puzzled by simple MPH calculation?
- Re: Adding cells which include IF Function
- Re: Adding cells which include IF Function
- How can I count the number of n/a and na in a row
- Re: IF and SUM
- Re: IF and SUM
- RATE function
- Re: IF and SUM
- Random function - alpha/numeric
- date between dates
- date formula problems
- Problems with an array formula using "sum, if, or & vlookup"
- Re: Printing Comments
- Fixed cell reference
- shading alternate rows
- Filtering a Shared Workbook
- SUM & Array Functions
- IF statement help please.
- Currency Rate
- Problems with Vlookup
- Missing Formula Bar
- autosum formula skips cell
- Use of Data Filters on a protected worksheet
- Column widths
- Vlookup or Hlookup
- transposing problem, may need some kind of function
- if statement with partial text searching
- Inclusion of all text in two columns, adjacent and fixed-width
- subtracting dates help
- can't print worksheet as report
- Re: Calculating ROI in Excel
- Excel AVERAGE formula - Selective averaging in an array
- formula update
- updating formulas in groups
- How to perform an automated AutoFilter sort
- Combo Box
- ListBox
- Multiple conditions with COUNTIF function
- Margins in file with textboxes
- CSV file delimiter
- Summing from multiple worksheets
- Columns to rows
- ? Directory Validation Bug???
- Need Matrix Lookup Formula
- Sharing worksheets LARGE files
- Moving only certain cells to another worksheet.
- Still struggling with border
- How to calculate from display of cell with formula in it
- Shading Cells depending on the data
- Publishing worksheets as a webpage
- Sum of cells based upon text in next cell
- Formula to fill a cell
- Re: help me...please
- help me...please
- How do you protect individual cells?
- countif
- Re: Random Number Generation
- Random Number Generation
- Re: Random Number Generation
- Re: Random Number Generation
- Custom functions...
- Hardware inventory
- Toggle
- Sorting by use of formulas...
- How to count number of code in VBA?
- Analysis Toolpack - NETWORKDAYS - Add in
- sumproduct not working with 4th arg
- Trying to transpose and format large matrix
- Vlookup on concatenated field.
- Re: Sum of cells based upon text in next cell
- MAX and MIN within array formulas
- formulas for postal codes
- VLOOKUP #NA unless retyped
- Help creating a shift rota spreadsheet