- Re: email
- Zip code lookup?
- Saving a Module/Worksheet as an Add-In
- Re: Inserting Named Formula
- Re: Inserting Named Formula
- Copying a call contents from the left to the right
- Error summing same cell multiple worksheets!
- How can I detect a red background in a field and perform an action?
- Absolute position question
- excel spreadsheet- work schedule
- How to retrieve the last "Text" value in a column
- Display result in a text box
- Cells which stand out
- RE: Nesting Funtions Limitations
- How do I to format minutes:seconds into usable format?
- Subtotals and Totals
- Linking or grouping sheets in Excel
- Sum/Count of cells spanning different columns/rows
- How to get unique rank numbers when two or more items rank the same.
- Leading zero's in text join
- Alternative to calc differences of DSUM functions (with 5 or 6 criteria)
- Query column for unique values
- Sheet Tab Colours
- Matching Debits and Credits
- Sumif function
- pulling worksheet name from page data
- how do i get excel to display the text in the cell??
- CHAR() help
- file search issue
- Linked data
- Converting a SUMPRODUCT formula to COUNTA active...
- Excel symbols!!! HELP!!!
- How do I find "invalid reference"?
- Call Up A Macro When Exiting A Cell
- Super Stuck! - Recall values from another sheet... huh!
- Hyperlink with copy value to target cell
- Cost
- Macro
- UDF
- correl() function - create matrix??
- Re: Call Up A Macro When Exiting A Cell
- How do I add Sequential numberring after text
- Formula
- Changing Text In Macro
- Median function in pivot fields (summarize by)
- Convert Excel 4 Macro Functions
- sheet tabs gone!
- functions appearing as text
- Format a cell for auto calculation of an input value
- Format a cell to auto calculate a input value
- LookUp & SumIF?
- Ctrl-Home, Ctrl-End disabled
- blinking cell
- Converting from first name first to last name first
- VLOOKUP and IF function problem
- ANOVA Results Interpretation
- None
- how to search a cell that existing in another column
- LookUP from a List
- Less Than / Greater Than Formula-Code
- Automating formula copying
- Mouse is scrolling slowly
- testing only
- test only
- Data Analysis Plus
- Formatting one cell. Autosum and copying formulas.
- #REF! error during copy and paste
- From different files
- Enable Macros pop-up
- Reset/Default Button
- counting based on two criteria
- Print the Difference?
- align & center
- Network Hours
- Function Errors
- VLOOKUP lookup values as range
- Notes
- Excel, action on a selected item
- Split grouped items into one per line
- Auto-populating data from one sheet to another
- Data Validation
- Hyperlink .jpeg; .jpg files
- Many Thanks......
- NUM
- Extracting URL from hyperlink cell
- Vlookup x 2 +#N/A and IF statement
- residual variance function?
- Sending data from one spreadsheet to another
- Sumproduct Help
- Conditional Format Problem
- How to Insert a row(col)?
- Time to Decimal point
- Entry in cells error, Excell
- xls 2003 filter
- Green mark
- Cell Format
- Automatic insertion of the = sign
- Change linked sheet-locations
- Increasing financial years
- Changes the value i get a loop ..... Problem Continues
- macro's manipulating data
- Merged Cells / Wrapped Text
- Function that sorting rows and paste the result in one cell
- merged data into one
- Return Location of k-th largest in data set
- REMOVE MAIL FROM EXCEL FILE
- Drop down box list
- Data Validation List
- Removing #'s from text field
- Back to if...and adding another and
- Re: Assistance with this one!
- Re: Assistance with this one!
- Elapsed Time
- Scheduled job - can't create Excel object
- Sorting with Calculations
- Excel - Formula to link column title
- Re: Unwanted number signs
- Length of contents of the active cell
- help with a conditional formatting formula
- Invisible Cells are being copied
- Help with Delay function
- exclude blank cells from print range
- Date Format
- Auto filtering Question
- Linking to a list?
- Word Wrap in Cell
- Re: simple formula to calculate a %
- Re: formula assistance
- Re: simple formula to calculate a %
- Re: simple formula to calculate a %
- Re: simple formula to calculate a %
- Re: formula assistance
- Re: simple formula to calculate a %
- Re: formula assistance
- Re: simple formula to calculate a %
- EXCEL FUNCTIONS
- How can i find the cell reference of a number im searching for?
- Formatting two cells i think
- Excel functions Or VBA?
- OR Function
- Re: Date and time calc formula question
- any pivot table experts?
- Workstation location function...toughie...
- Excel restarting
- Auto Color Fill
- How do I get text in cell a depending on text in cell b?
- formula assistance
- Re: Using Data Validation on a Range of Cells
- substitute function
- Challenging Data Cleanup Function
- Date function
- Table Lookup
- Copying same value to all sheets in a workbook
- 3d reference question
- #DIV/O error
- Indirect function only for open workbooks?
- Data Input Screen
- Trying to create a Delay function
- LookUp, If or Match.....?
- Using different fonts in a single cell
- Sumproduct/Countif Question
- Complex People Formula Problem :]
- Formula cell references when sorting values in another worksheet
- cells with formulas not updating
- More than 2 CountIf/SumProduct criteria
- countif
- Question: Trying to find 1st Workday of Month <excluding Holidays
- matching text
- is there a function
- drop down menus in excel
- Query
- Pivot Table
- Pivot Table (limitation)
- SUMPRODUCT with incremental values
- Pivot Table.
- Recalculating schedule
- custom list?
- superscript
- SUMIF based on 2 conditions
- linking 2 work sheet to update one sheet
- thank you
- Data Visualisation: Changing font size of list? HELP!!!!
- Best 4 months Commission
- Repost - Time Calculation After Date and Time.
- VLookUp
- Re: Comparing lists
- Re: Comparing lists
- Opening Files
- GetPivotData of data not visible in pivottable
- Re: VLOOKUP
- Re: VLOOKUP
- Function help!!!
- I wanna send email from Excel, how can i do?
- IF Function?
- Formula Help
- Macros and Formula
- Advanced Paste Function
- Re: subtotals
- Autofilter useing conditional formatting
- re: simple formula to calculate a %
- if, countif, vlookup
- pull Function
- Single-sample T-test
- Functions--I don't know what else to call them
- Re: Lookup values in a reference table
- Re: linking two worksheets PLEASE HELP!
- Re: Lookup values in a table...Help!
- conditional formating
- Paste Special - Transpose
- TODAY function
- Count cells that meet a specific criteria
- Placing Workbook Modified Date in WorkSheet Cell
- Text + Cell value
- Passing multiple references as one argument
- Number subtraction problem
- Vlookup
- Syntax of excel
- Balance sheet..any software available within Office XP pro please?
- SUMIF command with multiple criteria
- rounding numbers\nearest 1/4
- Spreadsheet Linking
- MACRO RUN TIME ERROR
- Getting rid of empty cells
- Paste Special
- zip special format issue's
- separating text into different columns
- Re: Letter grade display
- Copy Cell Value Above
- T value
- Repackage my Excel workbook into software
- changing date format
- Parsing Text
- Re: merging data between worksheets
- 3 term contitional function
- Counting Cell Values that Meet Certain Criteria
- Re: Can you copy a list of subtotals and paste it w/o all the data used to get the subtotal
- Re: Can you copy a list of subtotals and paste it w/o all the data used to get the subtotal
- Need help ASAP (Sort chronologically)
- Spreadsheet linking
- Calculating average allocation using dates
- Cells equal a number
- Re: Long text
- formula
- Test in cell
- Functions
- VLookup 2 columns?
- Date to Month
- Buttons or Boxes
- comparison of two columns in excel
- counting months from dates
- Simple formula nested in ISERR
- using the same formula for entire rows
- Nested VLOOKUP's
- locking button before user entry
- Inserting date variables into the paths of equations?
- Can I count??
- manipulate a row of information based on the contents of a single cell within a row?
- edit/delete macro
- Re: Long text
- Assigning a named cell in the Cond Sum If
- Vlookup within a vlookup function
- Locgical test with nesting
- formula help
- Document not saved error
- Excel Birthdates and Age
- Showing the months of a FY
- finding duplicates
- Excel 2K
- vlookup is what I think I need but its doing my head in
- merge, compare and update spreadsheets
- which function use?
- rounding to nearest 0.25p
- Formula Help
- Counting words
- Number Conversion Function
- Function Help
- Re: Copying macro with workbook.
- Nested "sumif" functions
- Hiding formula results when blank cell within formula
- Date format
- COUNTIF for multi columns
- COUNTIF for multi columns
- names
- Concatenating Text + Date
- Conditional Statement With a Series
- only few users can access the worksheet... is that possible?
- Workspace Files
- Negative amount in cell
- UTC Excel conversion
- simplify fuction to sum part of cell
- Re: Checkboxes
- Re: Checkboxes
- Need Formula Help.
- Inserting Rows
- Re: List Box with descriptions
- Re: Linest help
- DIV/0 Error
- Number formatting
- Re: Linest help
- Vlookup ??
- Return does not work!
- Calculating Calendar Days
- Printing Worsheets
- IF function - Boleen logic
- IF, AND Logical statements
- Re: Question on formula
- how to hide an excel sheet
- Re: Pushing formula results
- Wrapping Text
- Refresh Hyperlinks
- Logic to check a range for an existing sequence?
- Re: Automate naming of cells
- Re: function and formulas
- Re: Selective Totals
- Paste or a Macro
- CountIf with AND
- Search for character strings in an array?
- Merging Data
- Counting X's
- query problem
- Formatting Numbers
- Re: Function to determine whether a cell contains a formula?
- Re: Finding last name in a first last name string
- Re: Function to determine whether a cell contains a formula?
- Re: Finding last name in a first last name string
- IF Function logic statements
- Re: Function to determine whether a cell contains a formula?
- CONCATENATE within VLOOKUP
- Visible??
- Search for an entire word
- Conditionall Formatting Question
- Converting a constant to a number
- Nesting ISERROR and ROUND
- Help with formula
- Re: Converting to Days and percentage of 24 Hours.
- Re: Converting to Days and percentage of 24 Hours.
- SUMPRODUCT when you want to use all rows in column
- leading 0 in zip code dropped
- Why: Macro takes longer when NIC connected???
- Re: Converting to Days and percentage of 24 Hours.
- Pasting data to first available cell in other worksheet.
- Rounding
- Last used Rows and Columns
- Is there a function
- Conditional Formatting - How To Get It To Check To See If The Celll Contains A Certain Charachter?
- Formula recalculation
- Lock a column depending on Date
- How do I call an excel macro from outside the workbook?
- Need help putting sort order back
- Need help putting sort order back
- Need help putting sort order back
- "IF statement"
- "IF statement"
- Function for % gain?
- leading 0 - concatenate -zip- needs a fix
- Pivot Table - unselect all
- Printing Worksheets - for Frank Kabel
- match and vlook up
- Tab Name into Cell
- Renaming referenced worksheets
- Copying cells
- Lookup by reference to months?
- Normal Distribution
- largest number
- Odd formula error
- Multiple If-Then answers/results
- sum
- COPYING FUNCTIONS
- compare data
- Can we convert Lotus to Excel?
- using match, lookup, index
- General format to Time format
- Adding numbers across multiple worksheets
- Deselecting a cell in macro
- SUMPRODUCT with AND() or OR()
- Re: Lookup / Index / Match
- Looking for Book which explains ActiveX & Form Controls
- INDIRECT HELP!
- Concatenating a Calculation with Text causes the Calculation to be incorrect??
- Copy and Paste hidden rows
- countif
- Visual Basic....Calculate Button
- Re: If Then Help
- Lists
- Reference a cell value in a vlookup function
- Abbreviated indirect??
- Capital Budgeting - Profitability Index
- Font coloring function
- Cell reference equation??
- Excel vs Q-Pro
- removeing dublication across to sheets
- Extract data from one cell into 2
- Date Calculation
- RAND number LOCKING IT?????
- Excel Count Function
- MOVE SUBTOTAL TEXT
- Formula to subtract NCAA upsets
- Re: Function HELP!
- Function HELP!
- SUM problem with too many results
- Formula not just quite right
- Formula Help with Rounding
- Description Box
- Month and Year calc
- Modifying a RemoveAllMacros Function
- Contains Text
- IF AND help
- Can't Show & Hide Pivot Table Detail Using OLAP
- How to add in Solver - Have excel 97
- Can't read file
- Easy way to write complicated Ifs
- invalid reference...please help...asap
- Lookup
- VBA description of function
- Capping Numbers in Cells
- Reference cell in Active Window-possible?
- Excel Protected Sheet Loses Reference/Format
- help with Excel function
- File references
- Circular reference- any1 got it what it takes to solve it???????
- error - integer divided by a real number
- Adding/Deleting Rows between linked Worksheets
- Adding/Deleting Rows between linked Worksheets
- sumif and average
- Conditional formatting inconsistently applied
- Using a conditional sumif which allows a cell name as one of the criteria
- Updating
- Re: Function to Ignore duplicates in a data validation list
- Trying to sum a spreadsheet by dates
- sumproduct problem
- removing part of string
- custom number formats not saved
- Worksheet Tab Name
- excel gridlines
- split and freeze window
- Get address from MIN()
- Macro problem
- Nper
- Printing worksheets using borders
- TREND worksheet function for polynomials
- Calendar Functions
- I want my concatenate to display the date and not the number behind the text!
- homework
- Negative times
- Failed keyboard shortcut
- Heat Map
- Function Problem HELP!
- Applying Functions to Another Cell
- Counting problem
- COUNTIF Function
- "colorif" function
- equation help.
- Invoice numbering
- saving data
- VLOOKUP - location of value
- worksheet password protected user forgot password
- Trying to sort lists
- VLOOKUP and COMBO_BOX interface
- Extracting Text
- Threads - for David McRitchie
- Sorting 3 columns as a whole (not independently ) - Help on Karaoke Song List sheet
- Re: Formula for changing time periods
- Comparing across workbooks
- Linking to the Web from a Combo Box
- Percentage UP
- Delimiting Numeric values in a cell separated by a hard return
- Recursive Functions in Excel?
- Re: formula
- Calculating value based on a category
- Formula question
- Obtaining the sum of like part no.s from list of part no.s
- Re: Data Validation
- Question????
- Re: Macro- Today's date
- ELECTRONIC SIGNATURE
- Re: Macro- Today's date
- Re: Array Formulas to calculate five highest salary years
- Re: Macro- Today's date
- Value of the worksheet index
- Simple Math Question
- Re: Macro- Today's date
- Less than equal to FORMULA
- Deleting Links
- changing column headers to letters?
- Macro debug - Runtime error 1004 - no data to parse?
- Hyperlink to Hidden Sheet
- Can I do a Double CountIF Statement
- Datedif function doesn't work when I use the cell with a date as start date reference
- formula
- Calculating Paycheck with Overtime.
- Hiding Worksheets & Formulas
- compare data
- keeping date formate when using concatenate fromula
- hlookup
- Re: password protection
- Column widths
- workdays calculation
- Can anyone help
- Piece per hour
- Spreadsheet to calculate multiple accounts with due date and amount
- combo box text
- Formula help appreciated
- geomean
- Average
- Record Macro Toolbar Not Visible
- SUMIF Help
- Holiday Payroll Function
- breakeven equation
- sumif to divide cell A1 by A2 unless A2>A1
- editing vlookup formula causes failure
- Wildcard
- format cell: decimal or integer needed
- Sum of workstations
- Markup Costs
- Help!!! I only have until Monday.
- for next loop
- Sum consecutive columns
- Time Formats and formulas
- Find and Replace
- Need help with function
- Formulas, Functions, Formatting, and Web Queries
- formula returns text
- Find the lowest value, and report back...
- Making a larger print aera?
- Updating prices on spreadsheets
- Escaping the '*' Character
- Excel 2003 Analysis ToolPak Add-In
- IF, VLOOKUP, and Matching in Same Formula?
- Random
- excel 2000 text in formulas
- retain sum of cells after clearing addends
- Excel formatting problem when pasting
- Problem subtracting cells in Excel 2000
- How to write macros
- Time Calculation
- Help creating a Histogram
- Calculate Price Increase
- Assigning negative and positive numbers in a formula
- Formula help
- Formula
- =b1-a1+(b1<a1)
- Help: variation on *Day N of X Days*
- Details of sumproduct
- Go_to cell funtion
- count function
- vlookup
- Subtotals without the use of pivots or groups
- Formating results
- How to use the content of one cell for naming another cell
- ADDING MORE THAN 3 CONDITIONAL VALUES
- Conditional Format - add more than 3 values.
- ??Repot sheet name W/ A function on a different sheet??
- Email hyperlinks
- YEARFRAC
- VLOOKUP
- return to default when worksheet opened
- Need help with coding
- Formula
- use non-adjacent cells for an argument
- sumproduct for getting counts
- Match Index Choose
- Convert time to Value
- search worksheet
- stop printing
- Values
- What excell expression should I use??
- Conditional Formatting
- RAND
- What to use to know how many items from 1 colums are in common with other column
- Writing a custom function
- Renaming a Worksheet with Code Q
- distributing entries from worksheet 1 to several other worksheets
- MS Query installation error
- Creating a index/page of contents
- IF COUNT function
- Re: Drop down Lists
- Re: Drop down Lists
- Running Dates - Month
- Data Vlidation seems simple
- Roundup Function
- Defined Range | Validation List
- Function for duplicating Merged cells
- formula issue
- Re: Drop down Lists
- Relative cell references does not work
- =offset and dynamic range
- Re: =offset and dynamic range
- ranges vs. entire worksheet
- worksheet function help
- "*"
- Using the MAX Function
- Time Format
- Alphabetizing Worksheets
- Using conditional sum to calc. based on format
- Copy/Paste Functions and Formatting
- Making negative numbers zero
- Excel VBA - Complicated Problem
- date column based on existing date column
- How to set a default cell value if left blank, otherwise show text in cell?
- Error trapping for VLOOKUP...doesn't work so help!
- Validation List Dependencies
- When I moved data from one workbook to another...
- Worksheet disappears when I use hyperlinks
- Averaging
- Formula help
- trouble with < = > formula
- Re: Countif functions with multiple criteria
- Wrapped text disappears in merged cells
- Formula Modification
- Trouble with Adding Custom Formats
- Somebody hit me with a bigger hammer... I forgot how to..
- MODE equivalent for text
- Average and Mean Formula Needed
- Re: Lookup??
- Execute wav. File when IF function is true
- date concatenation confusion
- Time when an entry was made
- accumulate comp time for employees
- Unprotect Worksheet
- Numbers in Excel
- Re: Relative cell references
- Julian Date Conversion
- Same edit to multiple cells.
- sort worksheet
- Blianking Empty Lines In a Report
- Pocket Excel 2002 formula?
- Help w/ User-Defined Function
- e-mail 1 sheet of workbook
- Negative numbers
- Can this be scripted !
- Frequecy with logical value
- subtract from vlookup?
- Smallest missing integer
- Calculating hours
- Auto Filter
- Transfer values according to date entered?
- Sorting question
- Remove the - from a zip+4 cell
- RADIO OR SCROLL BUTTON PROGRAMMING QUESTION
- Inserting a space into a text string
- Formating data
- PV - stream of rates
- Random Sort?
- spreadsheet - with text document
- VLOOKUP - return cell is before lookup column
- customise date
- Printing multiple columns on the same sheet
- Help with referencing DATE cells...
- CHITEST
- Another Excel Auto Number using OLE
- #VALUE error working with dates.
- truncating a value
- lookup date less than or equal to
- Auto Format of Merged Cells
- Extracting text
- Formula Question
- help with complex formulas
- Pivot Table functionality
- Excel 97
- Date Problem
- Re: Full Diplay of Number in Text form
- Conditional Sum Wizard
- Excel Hours
- Row Height Function
- Formula help
- keeping formula from changing
- @sum(range)
- looking for a quick way to fill cells (with a twist)
- Re: Tries 10 out of 10
- Re: Tries 10 out of 10
- Importing a text file to excel
- Subtotals in Excel 2003
- Identifying duplicate records
- Re: Tries 10 out of 10
- I Need an "Occurs between" date function
- complex formula
- RE: Tries 10 out of 10
- IF funciton
- Formula Help
- Re: Help!
- Need help with sum function!
- Re: Need a little help.
- Re: Need a little help.
- Tries 10 out of 10
- Error with Index + Match formula
- Big INDIRECT Linking Issue
- conditional format based on sheet name
- Re: Difference between regression in VBA and a worksheet function
- Counting across a row with text in the value
- vlookup sh1 to sh2
- Laptop: PageSetup slow when connected to net
- Re-post Formula Question
- Annual Percentgage Rate Formula
- Re: Formula Help please
- Add Interactivity using Excel
- For: Frank Kabel
- Macro Debug - Personal macro not opening
- PROPER Text Function
- Any experts on "countif" formula using nested conditions
- Re: Can "countif" formula be nested using dates
- Count Distinct?
- Looking up the highest value
- Another vlookup question
- Help with scatterplot
- autosum question
- Re: If-Then Text statement
- Transpose Formula onto New Sheet
- I guess only super computer can solve this
- Current Date
- prevent scientific notation display
- Current date by the system
- Uneven Cash Flows
- If-Then Shading
- Cell combine
- Test
- Excel functions - making flexible "range" in COUNTIF
- LARGE
- Re: Tries 10 out of 10
- Extracting text in a string.
- bubble chart
- If-Then Text statement
- renaming worksheet tabs
- Random Numbers
- multiple IF functions
- Hidden Rows
- Line Break
- Excel Tracking
- Round round get around
- Summarizing Data
- Time in 2.0 (for 2:00) erronous display
- Adding color to pivot tables
- Worksheet Protection and Grouping
- Looking Up Values - INDEX?
- Add-ins
- Countif Function using more than 1 criteria
- AutoSum problems
- Re: Auto Copy TEXT cells
- Formatting Cells - Automatically divides by 1000
- copying data by way of a formula
- Re: Add a drop down list to a cell
- Re: Add a drop down list to a cell
- Add More Columns After IV
- Time period
- Time period
- Count occurrences of words in a list
- Leftmost/Rightmost Cell
- Re: Alphabatizing names and company names onto two sheets??
- Excel Forces Workbook to Be Open when Linking
- Count function
- SQRT