- Random integers
- Re: range name vs multiple cells
- Margins Do Not Fit Page Size
- Consolidate data
- importing data
- Excel - filter results in column, need to find adjacent column data
- FiItered results not displayed
- upper function
- Excel Formula CountIf
- Copying Conditional Formatting
- Is there a FFT function?
- Re: Running Macros
- Lists (Using INDEX vs. MATCH function)
- Re: prime function
- command button
- Unable to record macro
- question
- Help please
- Saved macros
- Formula meaning
- email function
- Return nth value from list
- excel sheets
- Time Counting Function
- Linked workbooks
- Re: Macros
- Re: Multiple selections from a drop down box
- Re: Multiple selection of drop down list
- Re: prime function
- Excel 2000 Using COUNTIF statment with OR statement
- Date and Data
- Re: Drop Down Menu problem
- function shall retun #NV
- using functions with macros
- Macros
- Re: 3D array/sumif formula
- Data Validation
- Command Button to open File
- Formula Help
- I NEED HELP ORGANIZING DATA BY DATE!
- interrelated constraints
- linking worksheets (ex. =sheet1!A2)
- Does Not Recognize Dates Entered
- Conditional Format - new
- If And Or?
- Finding lowest used range from several columns.
- Can't Total Value in Given Cells
- Getting the reference path that a cell is pointing to
- formula
- Re: prime function
- countif formula
- conditional formatting
- Formula
- "and" "or" in formulas
- Vlookup help
- Using A Scroll Bar Control
- multiple if statement
- Shared Workbooks and Taskbar
- Formula for budgeting
- Linked File Updates
- formula to count subtotaled rows
- Formatting Cells
- Exporting information to Word
- Re: duplicating sheets
- Re: duplicating sheets
- duplicating sheets
- Formula Error
- Changing Text color when a date has past
- links and weighted least squares
- Re: Time Question
- Re: Time Question
- Time Question
- Hyperlink
- Converting unc to mapped
- FV function (pv argument)
- OLE Size
- Re: Running Macros
- Removing a calculation formula leaving the result in the cell
- Vlookup or if then
- Running Macros
- vlookup
- Convert positive numbers to negative
- Adding data and date
- ActiveWindow.ScrollColumn (Question)
- Re: Referencing a cell open a workbook
- Locked Shared Workbook
- Help with formulas!
- Re: sum based on specific criteria
- FORMULA FOR DUPLICATING COLUMN CONTENT
- Sum Values after finding last cell
- breaking links
- Upside Down Text
- String seach within an Array
- Conditional Formationg Color
- networkdays formula
- round off?
- splitting adress and zip-code
- Printing a list in columns!
- Date format it text cell.
- A tough one!
- Verification of cell content
- Calculating elapsed time in hours:minutes (minus weekends [48 hours])
- Sorting pre-1900 dates
- Hiding rows across sheets.
- Help with Graphs!
- Sorting Pre-1900 dates
- Search and find latest revision
- Name change of dynamic data
- Transpose Question
- Edit function on macro tool will not highlight/function
- sum based on specific criteria
- Protect Worksheet and Keep Grouping Functionality
- Sorting protected cells
- Command button
- Data format change
- Sum, IF, Subtotal ???
- Excel Reference or VLookup?
- Re: Sum, IF, Subtotal ???
- 3d worksheets simoultaneously changing information in both
- Consolidating 2 fields into 1 ???
- Re: Scaning a document
- Drop Down
- If statement with more parameters
- Add 2 Range Names
- Date Stamp: date last changed Macro
- Consolidate data from different files
- vlookup function
- Re: linked cells - named vs range
- calculating dates based on workdays only
- Transposing Formulas
- fmax function?
- SORTING
- RSQ Visible Cells
- Cell Color
- Re: sumif function
- sheet name
- Urgent Macro help needed !
- Calculating Calendar Dates
- Extract specific rows into other worksheet
- Weighted Average for Different Aggragates of Duplicate Entries?
- please help
- Days left until...
- Re: If Then statements and format of results
- Re: If Then statements and format of results
- zero vs. null value
- Set a column to not print
- *.xls:1
- if function...i'm not sure..please help
- Day/Date problem
- Removing last few letters of string
- Excel : Calculating Elapsed Time
- Return address of last cell
- Formula or Macro?
- Drop down box
- Borders not printing
- Excel training exercises
- RISKTNORMAL
- Autofill misbehaving
- autofilter in protected worksheet?
- calculate Score by function
- Text referencing method
- Data analysis in Excel
- Read from Excel and write into another Excel
- Excel drop down list problem
- 2 values to one column
- Count Number of Dates in Date Range
- Worksheet CodeName
- Converting number to month
- Time based question
- LINEST
- URGENT: Adding Text to existing text
- Urgent Help -Converting cell from "K" value to Full Value
- Open workbook macro
- Convert all zeros to blank cells
- Planning system
- SUBTOTAL Second Count / sub-count of Filtered Visible Cells
- Automatically adding pages to a worksheet
- Sort or macro
- Excel Playing Up
- Data Consolidation
- Worksheet not accepting formulas
- golf handicap formula
- convert decimal to hours and minutes
- formula trouble
- CALCULATION OR FUNCTION ERROR
- Looking Up Specific Non-Blank Text Data in a Range
- Sum of VLOOKUP
- Excel hyperlink to jpg always opens with I-net Exployer
- Function for Air Travel Time
- letters and numbers
- Centralizing text in Merged Cell
- Excel - sorting
- Click or Double Click
- Duplicate info on worksheet
- Within a range....
- Copy cell - fill all blank - multiple range
- Need Help for a Formula
- Regression
- GetPivotData with variable criteria input?
- Unexpected #VALUE! error
- Indirect function refer to other workbook
- Re: transpose data ????
- transpose data ????
- recorded macro keeps disappearing
- calculating time spent working
- concatenate formula
- Header
- Daily Total Issue...
- multiple regression function?
- LOOKUP A .JPG
- Start up window on spred sheet
- Start up window on spred sheet
- Start up window on spred sheet
- Excel List/Function Problem
- Adding unique items using an Array formula
- Blank cell if #N/A
- Exacting only last name f/cell
- Hiding a row?
- Excel unable to find outlook to send page via email
- adding cells from different workbooks
- Help needed..
- Adding values in different workbooks
- Real Time without a colon
- New problem with formula
- Re: Date Functions
- an interesting read
- Using a list to pick from.
- Re: xlDialogOpen
- Multiple Criteria in Count formula
- COUNTIF >=8 AND < 9
- Get External Data
- Run time error on formula
- Date last changes made function
- Re: Date Functions
- Shifting objects off sheet
- Re: question on a formula
- Excel 2000 [% calculation]
- Text String Calulations
- Fomula to check formating of a cell.
- function referencing range to compute mean and stdev
- Mixed Text & Numbers -- Increment the Number
- Re: cell has formula when formated for general
- Date calculations
- Stock Quotes (Money Central) in 2003
- excel SUM function
- excel worksheet
- "IF" function probelms
- Making Excel build a Gant Chart
- cumprinc & cumipmt not matching reality
- Re: Time Sheet?
- Re: Create macro botton onto worksheet to refresh datas
- Time Format ?2
- Time Format?
- conditional formatting
- Deleting columns
- Re: Avoid date falling on weekend
- Re: Avoid date falling on weekend
- Avoid date falling on weekend
- Re: Avoid date falling on weekend
- Worksheet functions
- Excel golf handicap formula
- Pivot Table Range for Muliple Worksheet
- Creating Template from function
- RE: fomatted date column won't accept entry
- formatting help
- How to find duplicate numbers in seperate columns
- Formula Assistance
- Unique values in column based on condition in another column
- Excel file save
- Referencing related data
- Standardisation of number length
- auto cell & sheet referencing
- Standardising number length
- Formula Issue
- Cross Tabulation
- Auto insertion of date and time
- calculate day using date
- daily total before the next date
- Help: Election 2004 Project -- iterative operations
- Maybe a macro?
- Formatting button with preset formats
- Do not Open but direct to Save as into...
- PASS or FAIL?
- time calculation
- Select specific row
- Thanks.
- VLOOKUP or IF?
- TEXT Function Troubles
- filter
- Sumproduct
- Check Book Calculation
- Sumproduct to count
- Index headache
- ##### to be blank
- Collapse data within a cell
- Is there an Include Function?
- Function to extract specific records
- How to automatically compare values across columns
- need julian-like dates
- How to shade every other row
- Multiplying time formats
- How to search and add an additional reference in a cell
- cumprinc
- linked workbooks
- Gotit
- Re: Nested IF w/ SEARCH function problem
- Monthly Average Previous 12 Months
- unwanted highlights of cells
- Modified Date in Worksheet
- count if
- return filtered criteria to a cell
- Re: Is it possible to use Excel's SLOPE function on a non-continuous r
- Is it possible to use Excel's SLOPE function on a non-continuous r
- Validation List
- Drop Down Menu
- counting functions
- Can anyone help ------ please!
- Re: Totals of vertical values based on Column Header
- Re: Duplicate cells in Excel
- autofilling a series of email addresses
- Re: Sum data together based on Header Product Description
- Macro Help
- Re: Sum data together based on Header Product Description
- VLOOKUP Problem
- count the number of fails if the level exists
- Pivot Table Macro: Needs editing...
- INDEX help
- Function in Excell
- formula for creating percentages
- "Last update" date programming
- How to search and delete
- Alternate sheet printing
- auto save, auto backup
- simple..validation..
- Automate naming of tabs
- Date customization
- Re: Round Down whole integer to nearst 25 possible?
- Round Down whole integer to nearst 25 possible?
- Pivot Table formatting
- Excel possibly MATCH/CHOOSE problem
- VLookUp
- adding a character to all cells in one column
- RE: Rounding
- Multi-criteria SUMIF syntax
- EXCEL COUNTIF problem
- PERCENTILE Problem??
- Insert Tab name in sheet?
- Rounding
- Variable column width by page?
- VLOOKUP ?
- Return Page# Function?
- excel locks on first cell I click
- first cell i click into locks and i get range box
- VLOOKUP question
- Excel database lookup
- Copy pages, delete certain values
- Pay roll equations
- Referencing external workbooks
- RE: Hide Rows <> Today()
- Thats not possible because..
- linked array formula returns 0?
- Auto Date and Time.
- Percentage formula, part 2
- how to generate a range of number
- Re: Percentage formulas
- nested functions
- Can I nest functions?
- IF true THIS, IF false leave as it is..
- Percentage formulas
- Rounding up to nearest quarter
- If Statements
- Compare fila A to file B
- Re: Is there a function excluding the weekends on a formula?
- Re: Is there a function excluding the weekends on a formula?
- DSUM only works if reference workbook is open
- Excel shows column header's names as numbers(1,2,3) instead of chars (A,B,C,...)
- How to derive cell info from a lookup
- Excel 97
- Math Formula, I hope!
- Turn my #div/0 into a 0 please.
- cells involved with formulas
- Pivot Table Macro
- Autosum
- Change source on links error
- Excel Question
- Excel - Read Files Depending On Variable
- Pivot Tables with text fields
- Re: minimum values
- Sum-Count-Offset-IF- Match
- how do i track time
- Re: minimum values
- Re: minimum values
- Re: time count
- Concatenate,IF
- COUNTIF
- Function Help!
- Add additional criteria
- Fault with defined range
- Re: multiple page breaks
- Rounding
- Re: Converting to Adobe
- Formula
- Sort by Date, Add and Total Macro
- time stamping & tracking
- do nothing when false is returned
- Re: another time problem
- STDEV
- vlookup ... I'm kicking the Dust ...
- SUMIF Cell Reference as Criteria
- Lookup date of first and last values in a range
- Re: IF under 18 or over 18
- Re: IF under 18 or over 18
- Re: IF function
- Worksheet copy problem
- Inserting Page Breaks
- Changing value in cell
- Re: Find formula
- Re: Find formula
- Re: Find formula
- COUNTIF after an IF statement
- Last value
- Re: Using the IF statement
- Statistical help
- not printing cell border
- Find First Occurrence
- help2
- help
- Tab function?
- Rounding and Solver constraint
- VLOOKUP returns "0"
- Vlookup Function
- Addition of Logic Test Results
- Excel MATCH Function problem
- Audio file in worksheet
- averaging percentages
- Ask for a help of Excel
- countif function - need assistance badly
- Help with lookup (I think?)
- drive, folder, file
- Tally matches??
- RE: Determine a new cells ending value formula - CountA(), Index() ??
- Running totals
- Re: Can I print all the replies to a question at one time??
- Reliability analysis
- RE: Can I print all the replies to a question at one time??
- Display file names in a form
- Concatenate Cell with a custom number format
- SELF TOTALING BOX
- NESTING THE IF COMMAND WITH THE OR COMMAND
- SELF TOTALING CELL
- NESTING THE IF COMMAND WITH THE OR COMMAND
- Date update - a formula
- chnaged formula 2
- Help with an array
- Changing text to hyperlink
- ##
- Advanced filter criteria
- IF formula
- Re: Calculate Weightage
- Re: discovering a solution
- Dynamic Worksheet Name in a Link
- averages within columns
- using symbols
- Re: #Value! Error
- VLOOKUP Return Incorrect Values
- Re: #Value! Error
- Formulas at intersections - FRANK, HELP!
- Re: Selection Box Moves after Preview
- Variables in Functions?
- List
- Bond Pricing
- Formula at intersection
- Parenthesis
- Transferring Formulas between Sheets
- VLOOKUP case sensitive
- VLOOKUP case sensitivity
- Re: Enter Text in chart data table
- If formula?
- look up a value in another sheet bases on vaues ound in another cell
- Pivot Table
- Accounting for HOLIDAYS
- Printing With no page number on First Page
- Re: Return a vaule from a grid !!!
- Combo Box Position
- Re: Return a vaule from a grid !!!
- Re: Finding minimum values in multiple worksheets
- Formula Help, Please!
- Not able to format Date
- Script code
- changing color if value exceed speficied amount
- Not able to format a Date
- One Worksheet to Many
- Lookup Question???
- Re: Finding minimum values in multiple worksheets
- Open file at certain times of day...,
- Copy text formula?
- copying Text
- Counting duplicate entries
- Conditional Formating Limits
- Months between dates - round up
- training
- Re: match cells
- Determine a change in value
- Letters to a graph or formula?
- One column with two prices
- Countif question
- Remove Non-Printing Symbols
- IF Function to change font
- Macro to transfer data
- WENN mit Uhrzeiten
- Help
- Formula Help,
- Value '0' when apply paste link
- Pivot Table refresh
- merge file
- email?
- Bond Functions, ODDF... & ODDL...
- Obtaining Subtotals - is there a function available?
- Date Update in a Cell
- COUNTIF Question
- Sorting/Filter Data
- consolidating info from one tab to another
- Capital Letter in Date format
- Random mix up
- Constraing a count using two columns. . .
- Pop Up Box
- Finding Number of Particular Dayns Problem in a Period
- Finding Number of Particular Days Problem in a Period
- Event for Worksheet Name Change
- Compare 2 spreadsheets
- hyperlink from on cell to another worksheet cell
- multiple sheets
- file names in a combo box
- Lookup function
- Re: Simple way to calculate workdays in a month?
- Interest Formula Help!
- Re: Conditional count in range w/#N?A's
- Re: Conditional count in range w/#N?A's
- Subtotals
- Averaging Cells from Separate Worksheets???
- Erratic Sizing Functions UPDATE!
- help with formula
- Re: updating all worksheets in a file
- e-mailing worksheets
- Erratic Sheet Sizing functions???
- Re: INDIRECT With named ranges
- SUMPRODUCT help
- Re: 3-D Reference
- Conditional Formatting
- A conditional sum
- Re: Calculate a NPV for a user selected range of dates
- Macro - automate copy then close
- How to access Excel-Sheets from outside Excel ?
- Referencing Tab Sheets
- Change Positive to Negative
- Countif Statement
- Excel IF/LARGE Function problem
- Excel 2000
- Text - contains - IF
- Formatting the results of a lookup..
- Need help with formula looking for dual lookups
- Adding Cell from certain worksheets.
- copying absolute references
- adding 5% and round off the result
- Working days in a month?
- linked cells
- Re: INDIRECT With named ranges
- =Sumif Problem
- Re: INDIRECT With named ranges
- Meters to Feet and Inches
- Formula confusion
- Vlookup
- Conditional Formatting
- Q: locking some, but not all, properties of a cell
- Changeable sum value
- Pulling domains from a list of emails in excel
- Solver Protection
- how could i find the nearest precedent cell with given formating
- SUMIF Problem
- Saving CommandBar with Workbook
- most significant bit extraction
- How do you quary a column of data?
- Count records inside other files
- Display calendar
- Sizing cells differently in the same row?
- Finding number of particular days in a period
- Help. Exporting to Excel Workbook using ASP.NET,C#
- PivotTable Data Source Questoin
- Rank Percentage Shown 0%
- Wrap text
- Copy & paste a worksheet...
- absolute ref formula troubles
- Set Tab Sequence
- In Excel, a Hyperlink to a .jpg always uses Inet Exployer
- Getting prices from data Base to a work sheet in Excell
- ms works less vba
- Looking for In depth write-up of Array Forulas syntax?
- ms works and vba
- open another excel file
- % profitability spreadsheet
- Create a custom A/R Aging in Excel
- someone must know !
- Annuity function
- IRR worksheet function
- dates sort
- RE: Countif question
- Finding two records in a row then return the result.
- put everything after comma, into next column?
- Startpage using Excel 2000
- To JE McGimpsey
- converting a text string into a formula?
- SUMIF related question
- Re: Hyperlink from Excel to a specific slide in PowerPoint
- 13 periods per year
- Easter Date
- Calculating current investment value, current mortgage balance
- Macro to find and replace whole data with values in another spreadsheet?
- How to Consolidate Columns?
- SMS with excel.
- Embedding values within a cell containing HTML
- Norman Harker - 1 more question
- If a1=1 then e1 =c1+17 - dates
- =LEFT(Sheet1!E2,3) gives an error I don't understand
- count days
- Excel
- Computing dates
- minus using pivot table
- Followhyperlink - Brings up popup IE window
- Hiding Cells on a Shared Workbook
- Formula for the sum of percentages of different stages of an amoun
- Use a cell to tell function the sheet name?
- LOOKUP function problem
- Make "False" cell blank
- Text formula results do not display - Formula is UNchecked in View
- Percentages...
- re Easterdate
- SumIf
- Linking from Excel to a bookmark in Word
- Formulas displaying in cell not results
- Linking from Excel to a bookmark in word
- Printing backgrounds
- Pivot table
- combining functions (VLOOKUP and SUM)
- Re: Bob Philips - summary of grades
- Weighted average
- match index error
- Format code reference printing?
- Re: HELP! rolling three month average function
- Subtotals and Autofilter Errors Office 2003
- Increment one cell reference when copying formula
- Compare one list with another
- Add Same Cell From Each Sheet
- Hide 'excess' cells
- Re: HELP! rolling three month average function
- Re: Countif question
- newspaper style printing
- Match
- HEX2BIN Help
- how to combine sum and vlookup functions
- Re: HELP! rolling three month average function
- Hidden rows and sum
- return random number of values
- Changing a UDF to something that won't register as a security threat.
- Prepare, combine and check for differences in 4 w/s
- Pulling #'s from multiple spreadsheets
- UDFs - need help to share functions with spreadsheet
- middle function
- Trying to count the number of times a "type" of value occurs
- Advance Filtering #2
- Automatic Bolding and BackColoring
- Absolute references
- repeating a data sort
- Advance Filtering
- Re: repeating a data sort
- RE:Domenic - Sum with condition
- Need to convert formula into excel
- Trying to count the number of times a "type" of value occurs
- Excel Sort - Alternate Sequence
- Format existing text to numbers
- background images
- Please help me figuire this out ive been to vlookup site by mr. ritchie. no luck
- CountIF Calc
- Count Unique Records
- CountIF Calculations
- Double VLOOKUP
- How to show decimal value in Monthly function ?
- Return Specific Value with IF Statement
- highlight duplicates
- Formula or Macro???
- 'portable' UDFs ???
- match/lookup/find -fuction that returns TRUE/FALSE
- Excel object error
- What formula would give a value of a last negative value in a range?
- Excel Combobox
- HELP.. formula required
- Help: Election 2004 Project -- Iterative Operations
- User Defined Functions
- Unhide row or column doesn't work
- Function Wizard Problem
- Easterdate
- Re first intials
- First, let me say THANKS!!!
- Open files automatically within an excel file
- Counts all cell containing even numbers in the range
- First initials
- Inputbox Auto Close
- Text Problem..PLEASE HELP!
- #N/A
- Formula Indirect with path
- Two formulas
- looking into a cell
- Display reference value
- =LEFT help
- counting entries in a range of data
- Consolidating 2 sets of data
- Covert a Date in to a number
- Format Repeated Values
- vlookup
- Cell Fill Format Function??
- Re: Performance & Optimization
- concatenating a 2 decimal place number
- averaging time values excluding zero
- Total Count of 5 columns with different numbers in each cell acros
- sumif with multiple criteria
- Forluma Performance
- Re: Macro
- Unique values from a column based on condition in another
- How to sort into a new table
- Macro help
- Average function
- Re: Macro
- match, if, and vlookup
- What function should I be using for...
- Values between Worksheets
- character extraction and replacement
- Date and Time
- Mouse to Define Variable
- Subtracting dates
- Conditional Formating excel 2k
- Date format
- importing
- Re: Value of ="" causing problems with MATCH("*",Range,-1)
- Re: Using INDIRECT with dynamically named ranges
- Re: Value of ="" causing problems with MATCH("*",Range,-1)
- Remove all numbers
- Using INDIRECT with dynamically named ranges
- Re: Category condition selection
- Re: Extra Pages in a sheet of the workbook
- Some kind of crazy lookup
- Array formula in merged cells