- sorting coloums
- related columns
- formulas to return first and last value in a row
- Thanks!!
- NETWORKDAYS, Holiday problem
- X Most Frequent Numbers
- HowTo create an IF function....i think?
- Formula/function help
- COUNTIF - WTD, MTD, YTD and criteria
- Using array-entered formulas for calculation average
- Compare text arrays
- find first and last value in a row and return it
- Deleting links
- Re: find first and last value in a row and return it
- calculate missing data
- Re: find first and last value in a row and return it
- keep formula after typing in a value in a excel cell
- Maximum Worksheet Size for Excel 2003
- Width of drop down lists
- "Select" type statement
- get pivot data
- Calendar Dates
- Searching and returning information ??
- Conditionally Populate one column from another
- protection in cells
- unhighlight selected cell
- Average Question
- Share
- beginnersproblem copying formulas to cells
- Time tallying
- Help with formula
- Help Please-get pivot data
- adding text /macro to insert text in cell
- shortcut to text within cell
- Excell question
- Array Formula
- Formula wizard
- comparing spreadsheets
- Formula conversion, result to text
- Counting the number of times a character appears in a cell
- Concatenating data
- CUMPRINC #NAME? error when file saved with new name
- @Vlookup w/ Multiple answers
- How do you add a constant number to a group of cells?
- Moving Array
- using sumif nesting
- Zero fields in IRR
- Multiple Filter
- deleting a data field from a pivot table
- Cell width and height measurements
- Emailing a Single Worksheet
- Copy a macro between workbooks
- user-defined function...
- IF statements
- Inserting same text in every cell of column
- Using the SEARCH function
- How can I make a cell have no formula?
- Convert .xls to .txt
- Average
- Excel - Data search and count within a cell
- Populating data from a list
- User form in Excel
- Why are pictures in my worksheets blurry?
- Hiding Negative Numbers
- Help Please
- Formulas
- Blank Cells with Formulas
- erasing spaces.
- IF Statement
- Using 2 worksheets to create a third
- Macro / VBA Help needed
- Don't display result unless a value in this column
- 8th Len() fails in nested ifs??
- Sorting a worksheet
- Sumproduct and Month Function
- Hiding SS#s
- Concatenate Failure
- Formula
- VLOOKUP rounding
- Logical Function Override
- Re: find text string, but return cell contents
- e-mail a excel file
- Headers
- Re: Size
- Extract A String
- A fault with the Excel Sum function
- disallow unhide using copy/paste - pls help
- Troubleshoot question,RE:a bug
- Formula
- disallow unhide using copy/paste
- multiple condition help thanks
- Multi-cell Range
- what if analysis
- Can A Named Range Be A Variable?
- formulas
- Return to previous workbook
- #NUM! when using column reference in formulae
- Pivot Table compatibility
- SUMIF-selecting certain cells
- How to extract specific data from a log txt file
- Creating Names Problem
- Copying every row with Jan date automatically onto another worksheet?
- count the number of unique entries in a column; with a certain filter
- Exporting a range of cells to Outlook
- How to find interest rate?
- Combining Worksheets Formula
- disabling auto dating
- Vlookup with Dates - undocumented error!
- How Do I Get Rid of "Overwrite" popup when I save?
- Ranking function
- Data Validation List- Auto-Type
- Stacked & Non Stacked Columns in Same Chart
- How Do I Get Rid of "Overwrite" Popup when I Save?
- Sum formula for criteria between two dates on separate sheets
- backup value when VLOOKUP gives #N/A
- Email a Worksheet and Get it back?
- Removing the automatic macro for date
- date format within concatenated stream
- Worksheet Name used in formula
- Respond to Excel Pop Up within Macro
- Counting the digits in a range
- on new month start want information from different cell
- PROPER formula?
- Copying macros
- Use Cell as Checkbox
- If Statement
- VLookup
- Date Calculation
- function for counting cells in combinations
- Multiple Combo Box Question
- Re copy macro
- Lotus 1-2-3 in Excell
- RoundUp Return Value of a Function
- Does cell contain a formula?
- Printing??
- Excel opening a works worksheet
- Pivot Table - suppress (blank)
- I have formula, but need better one
- Extract variable number of chars from variable start position?
- Subtotals or Pivot Tables
- Sum formula
- how to remove the #div/0 from this formula?
- Data Grouping when worksheet password protected
- INDEX function displays zero when the source value is blank
- Use Cell as Checkbox-2nd Question
- Can't figure out a formula
- YIELDDISC vs. DISC
- finding the formula of a created function
- Is there a Function...
- Finding Duplicates
- Formula display: automatic wrap or adjust
- Summing with #N/A in thr range.
- Base 60
- Array Help
- can't insert extra worksheet in workbook
- Auto-Fill Glitch
- pull down memus
- Re: Function to count with hard criteria (Help Please)
- Date and Time Function
- Slight adjustment needed to formula!
- Excel Pivot Table - 2 Reports With Same Page Fields
- Referencing to last cell in a coulmn
- Selecting a range
- The opposite of concatenation?
- those crazy line enter boxes
- help with automate please
- entering time in and time out
- COUNTIF
- disallow unhide using copy/paste
- Find value for each month based on date & criteria
- Years Subtotal
- monthly sales forecast
- Control on Control toobox functions
- Making a cell act like a textbox
- column size in custom format with word wrap
- To: Ken Wright: re: Pivot table
- Consolidate data in multiple worksheets
- Autosort cells
- how to auto run the macro
- SubTotals
- how to enable back macro
- Concatenate
- how to avoid macro warning dialog box????
- Logic Functions: One works One won't
- Weird cell formatting (sequential numbering and dates)
- Inset new row in Shared Workbook & keep formatting & Validation?
- macro trusted sources
- Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet
- trusted sources 2
- Find Average time to fill - Month to Date
- Sumif problem
- percentatges
- Soting dates chronologically
- Positive regression co-efficients
- Pls help me!!
- RE: Array Formula
- Find Duplicates in a column
- why Ca Root Certificate not trusted?
- Data validation for Capital Letter
- Splitting Forename & Surname in one cell
- New Formulae
- Capitals
- counting rows of text - any text!!
- Formula
- Rank
- Same Data - Different Layouts / Order on Other Tabs
- populate a table from excel
- Help with defining which cell the cursor goes to after you hit enter
- occurence of two values.
- suitable reference/lookup function?
- Need a function to return leftmost number in row of columns
- Re: SUMPRODUCT for multiple criteria
- Lookup
- Page Breaks
- limiting options to insert
- Cells as checkbox-3rd Question
- Possible to track who accesses my spreadsheet?
- Wildcard in SUMPRODUCT for multiple criteria
- Close workbook with VBA Script fail
- Multiple spreadsheets in one HTML file in Excel 2000
- Vlookup function limitation
- counting string information help please
- Test for shaded cell?
- Median of differences between two columns??
- Copy and Paste from Web with data
- rounding numbers in a calculation
- counting trouble
- SUMIF to total sub-accounts
- permanent formating
- Conditional Formatting (only until field is populated)
- Re: Return text to cell other than the one with the formula in it?
- comparing between different columns
- SUMIF to subtotal accounts?
- excel formulas
- Using "IF" function for formating
- Splitting a cell
- Macro for Listing Unique Cells
- Re: Display "last update" date in a cell
- Double lines of text in one cell
- Re: LOOKUP/REFERENCE/CHOOSE/???--not sure what I need
- Re: LOOKUP/REFERENCE/CHOOSE/???--not sure what I need
- LOOKUP/REFERENCE/CHOOSE/???--not sure what I need
- Re: More specific... Is there a send text to function out there somewhere?
- Problem adding one more IF statement to formula
- More specific... Is there a send text to function out there somewhere?
- Highlighting the entire row of a selected cell
- SUM, COUNTIF?
- Adding autofiltered values
- Linking excel products together
- vlookup doesn't always work in this situation
- Re: SUMPRODUCT vs SUMIF Function
- Re: SUMPRODUCT vs SUMIF Function
- Golf Score Spreadsheet
- text to column
- Password
- Cells(1,1)
- Pivot Table
- workday formula
- PivotTable Calculated Field
- Re: Standard Deviation
- copy 2 columns and paste to one
- Re: SUMIF with 2 criteria
- Re: SUMIF with 2 criteria
- Re: SUMIF with 2 criteria
- function vs formula
- Currency sybol- euro
- filename function
- dsum
- date formats
- How to do an average formula ?
- Calculating Date
- Max size of cell
- Is there any way that I can do this
- Can't Delete Named Range
- Using look up or filter to show only data requested
- Out of memory.
- Finding top 10 scores out of 15, adding top 10, finding average
- Finding the Lowest Number
- Need help with worksheet spanning macro
- Year-to-Date Daily Averages
- Help with Filtering data and matching two data sets?
- Use of Indirect with Row() as part of argument
- Filter and delete
- Delete the blank rows
- Last Update
- Protect and Filter
- Rounding a Number
- Display a number of significant digits
- Help with conditional formatting
- formula
- how to enforce to run macro
- How to make list of unique values?
- Pls help me !
- Lookup Help
- Concatenate Superscripts
- How would I freeze the internal clock time in a worksheet or form
- INDIRECT function
- disable macro button in warning box - how to do the coding
- enable insert worksheet
- Referencing a text formula
- rearrange sheet sequence
- Formatting Cell
- find all / replace all used in a selected range
- applying conditional formatting on empty cell
- accelerator key
- DoWhile..
- Time Calculation to showing negative value?
- EXcel auto filter problem
- Can Excel do this?
- Multiple SUMIF functions ?
- Re: GETPIVOTDATA function in Excel 2000
- General Setup!!
- Array reference from current row to bottom of column
- Automactically Updating Date Runs SLOW
- Cell Format
- XIRR
- profit/loss
- Change Headers
- Cell Formatting
- Expanding a range
- Pressing ENTER
- Re: Julian Date to Calendar Date
- Unhide Worksheets
- Data Validation with letters and numbers
- Sum only positive or negative numbers
- Adding values from diff rows + columns
- VB to highlight select cells with a value
- excel sum function
- SUM causes strange error
- Referring to filename in macro
- Flag Duplicate Entries
- Advanced paste function - OFFSET function
- array formula
- Help with Count(If(.....
- Changing formulas via F2 edit
- Excel SUMIF Problem, cell ref as criterion
- text box
- Nested IF statement
- Excel worksheet functions
- Time Conversions
- Date formatting
- Formula Help
- Calculating Ratios
- Execute command from cell
- IF Statement Help
- Counting only visible rows and not using a filter
- Formula copy and paste problem
- adding only filtered values
- force new cell
- input message boxes
- Is there a cell function that will insert the sheet name into the cell?
- Slanting Cells in first Row
- Formula help
- Missing content
- Extract First and Last Names
- inserting drop down menu in a cell
- CELL("filename")
- Pivot Table
- Lookup formula
- summarizing data from different sheets.
- "Look up" with multiple hits?
- Showing Only Non-Zeroes
- Date
- COUNTIF with changing criteria
- working out sums over a number of sheets
- Lookup function that returns multiple values in column 2
- Sort
- timer
- Color Coding For 5 Separate Ranges
- What's wrong with this array formula??
- Count only displayed cells/rows
- Re: Julian Date to Calendar Date
- Password protecting multiple sheets
- Re: drop boxes
- Why can't COUNTIF condition reference a cell?
- auto change date
- Numeral defaults to "0" at the 16th character space in a cell
- Drag and Fill with VBA
- microsoft.public.excel.misc
- Frozen Screen in Shared Workbook with Filters
- Data validation on different workbook
- Print font upside down
- Advance fliter; filtering Blanks
- automatic search and delete
- How do i Analysis a range of cells to c which cells sum to a total i have
- Help with vlookup, please!
- An Excel Stocktaking Formula Required
- SUM of ABS values
- complex repetitive calculations probllem
- VLOOKUP on non-unique values
- Conditional Formatting
- (blank) displayed in pivot table
- Complex VLOOKUP
- Dropdown list and vlookup in combination
- Validating Cells
- Filtering
- Date Problem
- Inserting calculations upon data refresh
- Lookup a cell intercept?
- timesheet
- How to display the plus sign for positive numbers.
- Re: Enable spell-check on a protected worksheet
- sum last nth cells
- Print settings on multiple sheets
- Last value Cell/Row
- LOOKING F/IDEAS
- Formula for a report
- slope function
- IF, MATCH, LOOKUP problem
- Excel Counting
- shading rows and conditional formating
- Buidling a string to ref cell in other book
- formula's in cells
- counting cells per content
- Pivot Table Question
- If Statement Help
- ISNUMBER problem
- Which function to use????
- blank cells
- Problems with linked workbooks
- IF Function and length of wait query
- IF(AND...
- convert text to a date
- Networkdays
- Default Normal Style
- re: delayed response to functions
- matching rows
- getting data from a table
- matching rows
- another question on the lookup or match and if function
- Excel Formula Problem
- Cash by priority
- Need Shell to open program
- How do you calculate elapsed clock time?
- Not sure what to use
- Getting INDIRECT/ADDRESS to return results from another Worksheet?
- Excel Sorting Problem
- ODBC connection within Excel sheet
- IMPORTING AND EXPORTING
- Tough One, trying to count occurences of string based on string in separate column
- protect & hide 1 column & worksheet can continue edit
- max number with conditionals
- invoice numbering
- using a decimal point changes cell to label
- Excel
- Sorting complex data
- If ___, then calculate ___
- Getting Cell A1 to match the sheetname?
- Filter data by using From and To dates without using Macros
- IF/AND/OR
- Time Help
- Multiplying all cells: HELP!
- EXCEL FORMULA: ALL CELLS
- VLookup - Need Zero (0) Value Not #N/A When False
- matching items, comparing price changes in rows from 2 sheets
- Sum Question
- Excell can't add
- Max number in cell
- if functions-Can you format cells?
- simplify formula
- No!
- long formula
- Current Page # in a Cell
- changing behavior of autofill?
- pasting a value to a merged cell
- HowTo: Find and delete link to external spreadsheet
- 4m 46.1s to seconds only
- multiple condition
- Next Column over
- LOOKUP Function
- Help
- Re: macro - need help
- Remove Blank Cell
- Works vs. Excel
- refer to different workbook based on value in current workbook
- Vlookup and Sumif
- Maybe this
- Columns to Rows?
- Hidden info in cells
- Custom cell formatting question
- Comparing two columns & counting
- Excell Function-Compare a Cell to a Column of Names to return a value
- Duplicates in a list of numbers.
- Remove blank n dupilicate record
- Formula for times
- average & iserror formula
- contents of cell referenced into formula
- Conditional format ISERROR()
- Return blank cell from IF()
- Re invoice numbering
- Excel XP (2002) Auto Filter problem
- conditional formatting grayed out on drop down
- Vlookup + Hopefully for the Last Time
- Eliminating a letter before numbers
- Managing Text Lists
- Screen not scrolling with Filters on
- Please help..activating array formulas in a range of cells without going cell by cell
- countif "between" criteria
- Excel Basic Math Spreadsheet Calculation Error?
- need a macro
- Multipling entire columns b a single factor
- P/W Protected Workbook...
- Number references
- How to move cells into another cell
- vlookup
- Pls help me!
- Excel Function/Formula help...Variable inside a SumIf ?
- default active sheet
- Need help with Excel
- conditional format
- Occupancy Rates
- How to check a cell value is a date ?
- Count with two conditions
- AutoExpanding User Defined Function Output
- Microsoft Visual Basic - Class not reqistered
- Insert content from another cell
- Using R1C1 stylewithin A1 style
- Offset function and references
- Pls help. Need help with formula and conditional formating
- Excel equivalent ov VAL function
- Age Calculation
- Enter Password to run a macro
- profit/loss formula
- Re: Number of conditional formats
- Re: Number of conditional formats
- Return Number of day per month
- Counting of dates before today
- Positive sign
- The & function
- Value greater than zero
- re-sorting numbers randomly in a column
- Restricting fields for whole/decimal numbers only
- Pivot Table Results
- Referencing and calculating merged cells
- Mulitple Conditionals without lookup table?
- Auto calculating a VAT rate
- number display error with auto calculation
- Max value with selection
- Sum multiple pages, NOT in order
- &*%%$!!! UNSAVE!!!! Help!!!
- &%* UNSAVE, Help!!
- Another Pivot Table Question
- States Codes
- Excel 2003 -- copy/paste error
- Formule
- Split a colum
- Function for a nested if statement
- Weather
- Database-type joining of spreadsheets
- SUM IF Help needed
- worksheet protection
- IF statement with a date
- Match function
- status bar
- MSN Messender
- day of the week
- Header & Footer function
- =cell("filename")
- Assign values to range?
- Vlookup and sum
- Cell Reference
- How can I limit the value of blank cells
- I need help calculating blank cells
- How Do I Select a File From The Server?
- Excel Macro Pop-up Message
- Geomean in an Array Formula
- Copy cell in reverse
- Converting a date range to number of months or weeks
- Showing and viewing gridlines in .htm from .xls
- Please HELP me!
- Re: How to get 2 but not 0. whats wrong in formula c3
- "Match" Function - how to find multiple matches ??
- Array formulas
- Are there any improvements in Formula Auditing in Excel 2003 over Excel 2002?
- How to make a cell look empty
- return
- Return (again)
- calling a stored procedure on MS SQL Server within MS Excel 2000
- How to desable recalculate
- filling a range of a column by macro/function
- Convering String to Date
- Vlookup
- Excel macro
- Formula for months
- Marco Relative Referencing Button
- Excel formula to find identical cells
- Excel Formats
- An old problem
- Need help with an IF formula
- conditional formating
- Increasing file sizes when deleting formulae
- Sumif using 2 conditions
- Autofill - repeating values
- excel
- HELP!!
- HELP!!!
- Date and time
- worksheet formatting
- Calculating number of days
- drop down menu
- ANOYING HELPERS
- adding multiple cell contents
- An old problem
- Re: use formula for entire row (with header)
- Re: use formula for entire row (with header)
- Finding the Max value
- #value
- Selecting multiple entries on a dropdown list
- Goal Seek - show formula?
- Re: Average Paste Function
- PLEASE HELP - Display number in extended text
- Autofill Questions
- formula results question
- Data Validation List
- If with Array
- Rounding time to nearest 15 min
- (Semi-)Automatic cell selection in calculations
- Concatenate Dates
- Conditional Summing
- Convert Dates to current year
- Re: SUMIF matches text color in cell
- Olap Cube Error
- Excel formula does not work
- Sum not working
- DECISION
- calculating within a pivot table
- Indirect?
- can't access the add-ins to get to data analysis
- data consolidation
- Excel 2000- Pivots- Group by date
- EXCEL IF() Statement?
- IRR, Goal Seek and Solver
- trace dependents
- Rounding function
- If Statement Question
- Pivot Tables
- Can "COUNT" and/or "COUNTIF" look at dates?
- Changing a Date to a Number
- Countif Criteria
- counting specific words
- Excel Add-Ins
- jumping to next entry cell
- Auto Date Formula
- Sort Ascending issue
- Invoice numbering
- Using LOOKUP only if a value exists
- HPVAL function in excel XP (2002)
- excel sum functin
- Finding Data and Moving Data From An Adjacent Cell...
- Save and reuse sorts
- If/then for three items
- sumation function
- If/then
- probleme macro vba (xl 2002)
- Selecting Data between 2 dates-Excel
- Help on commands
- number permutation formula
- How to find repeated name in the list
- Conditional Format Paste
- Sharing an Excell Spreadsheet
- Excel 2000 - Problem with Autofilter
- Using Lookup to find the most recent event
- Outside dates and between dates
- Remove all Pictures
- Copy data
- copying filtered data to a new spreadsheet
- Count Colours Formula.
- Formula is malfunctioning
- Text conditional
- calculate compound growth
- cell reference question
- sorting rows
- Excel 2002 Fill Handle give same answer?
- Vlookup with multiple conditions?
- File Creation Date Function
- function
- Format numbers with suffixes
- Sorting with references to other sheets?
- if statement
- Boss changed his mind
- Substitue text strings
- Creating a complete filename for use with functions.
- IF Formula criteria .
- Auto-number down a column
- auto changes dates
- Excel VBA function not refreshing
- How to combine email addresses in one cell?
- Re: Totals of Color Filled Cells
- Pivot Tables
- VB - path location in footer
- Re: Scrollbar
- Cross reference offset numbers
- worksheet protection
- Need help in formula
- UNDELETE
- Seperate a column into 2 columns
- Rank
- Determing number of days
- trigger event sheetchange from DDE Link
- concatenate 4 rows...
- Excel Number Sorting
- multiple instances
- Bold Formula
- Re: cursor highlighting
- breaking / removing links to external data source
- FRANK
- Conditional Sum
- Re: cursor highlighting
- SUMIF and IF Functions on Range(s)
- Can you format a date cell to produce a quarter reference?
- Please Help w/ Functions
- Frank. Re: Sorting with references to other sheets?
- Caculating A.P.R. in a mortgage
- compare texts
- help with IF statement
- Fields in a pivot table
- comparing spreadsheets plus-
- Global Changes across multiple worksheets
- add to web page
- Function Question - is it possible to ....
- Down to Across
- pivot table
- hyperlinks in a workbook- return a sheet and cell other than indicated
- Anchoring a cell.....
- Lowest Common Multiple (LCM)
- Disabling today's date on invoice template
- quickly look up functions in XL 2003?
- FRANK
- 2 5-range color codes on the same sheet
- Shaded Number on center of page - Removal
- Comparing two lists (ListA vs ListB)
- Return value IF
- how do I...please help?
- Sumif problem...
- multiple results search
- If/then over entire row
- Numbers not adding up
- auto insert copy of worksheet
- If a cell has any text at all, need formula
- Nested Data Tables
- Help with a Worksheet Function please
- SumIF Array
- IF Statement
- SUM- hidden rows
- Functions parameters separator
- Nested if statements
- Looking up the tab name from a cell
- Autofill dates across worksheets
- can you move location of worksheet tabs ?
- Creating a workbook with multiple sheets