- multiple conditions
- Protecting Sheets within a workbook
- worksheet protection
- and & countif?
- "Last saved" information
- Last Saving Date
- Last saved informations
- list boxes
- Protecting Worksheets
- Protecting Worksheets
- trying to create month end report....
- Find the First Blank Cell In a range
- Advanced countif() help needed
- Formula to Count Condional Formatting
- Re: If function in a formula
- Re: If function in a formula
- Re: If function in a formula
- If function in a formula
- SUMPRODUCT as subtotal
- Help with formulas for block of cells
- Converting text to date (please help!)
- Filter macro using criteria in a list (not autofilter drop down list)
- Indirect and lookup to left
- Excel Sort() Algorithm
- test
- test2
- Re: Finding the first blank cell in a range
- For =IF function to display a picture as its value.
- Re: Finding the first blank cell in a range
- Sort Question
- HELP....
- Random Numbers
- condition and color
- Combo Box - HELP!!
- Rounding number to closest 50 or 100 on exel
- IF function I think???
- countif if bolded ?
- Data base
- Increment an Invoice number
- Custom Function & Personal.XLS
- Advanced Replace globally in all worksheets
- Sorting Countifs
- calculation
- summing one range based on another range
- I have a problem !! - Need to Merge Two Rows !!!!
- DELETE ROW
- MACRO HELP
- SUMIF ?
- Goal Seek, multiple cells
- lookup problem
- protecting single cell
- Comparison of non-numeric arrays
- Copying formulas on worksheet
- Find MAX, look down 4 rows from the MAX, return that value
- Calculating Date Number
- Linking spreadsheet to Word doc
- Path Name
- Re: Range Names
- SUMIF on Cell Result
- worksheets and workbook
- Date Calculations
- Lost in Menus
- formula with 2 criteria, Excel 2002
- help on formula
- Re: Range Names
- Permission to use object denied.
- Comparable Excel Formula?
- function for identifying different entries
- Re: Highlighted Cells
- Re: Highlighted Cells
- Pivots - please help!
- Financial Calculation needed
- Still Struggling with PRINTER--Macro
- Countif Else?
- Locating a phrase in a woorksheet by formula
- Using Sumif on multiple tabs
- Remove leading spaces
- Excel 2003 - locking down spreadsheet
- if(and( Getting past the seven IF's
- Function value always the same
- Formula too long
- Sorting by the last numbers in a long number
- Do until? For next? Help
- How to calculate days:Hours:Minutes:
- Using cell references in formulae
- Is there a formula for a decreasing montly balance of a mortgage?
- Re: Macro to control query
- Form Validation
- collumns to rows & vice-versa
- Why can't Solver solve my one-variable query, when Goal Seek can?
- create own data
- Which function to use to open an .asc file?
- XL4 Macro Reference
- Help creating a sheet
- set no. of digits to value
- if function
- "IF" Function
- Excel XP question working with array's
- Search with wildcards symbols in IF fnction
- Array Function?
- Excel Function
- Utilization calculation challenge
- formula problem inside a macro
- Sharing Violation & Unexpected file Lock
- State Machine in Excel
- Relative & Absolute References
- right() not working
- Nested If Statements
- formula giving a target
- Time difference
- filter results
- formulas needed
- business schedules
- Dynamic Worksheet reference
- Forms
- adding on formulas in a worsheet
- Excel mail marge
- Setting Cell to Worksheet Name
- writing a formula
- Novice - Lookup Relative Data
- removing duplicate entries into tables, formatting tables
- Need Help: Moving Left to Column A
- Automating Footers
- Autosum in Macro
- Pivot code - new data
- Returning to a column
- MULTIPLE CONDITION FORMULA
- linking two sheets in a third sheet
- summing visible data
- Excel Sumproduct problem
- Adding array brackets {} to all cells in a column??
- Excel- Cell formatting
- Summing values in a specific column in a named range
- Save and Close Macro
- Slight change needed for Code!
- vlookup not looking up text
- Moving Rows To Columns in A Table
- >> Dynamic Range
- If/Then Matrix? Can Excel do this?
- Function for Differently Formatted Sheets
- Sports draw
- Using macros on custom toolbars in templates.
- Excel Grid to Template/Form?
- Novice - Locating a name on another sheet, then returning several specified values
- Combining upper and lower case functions
- Rounding Help Please
- Optimization
- Multiple IF
- Summary Sheet??
- Weekday shown as text for clarity
- how to put " in a cell thru macro
- LAST SAVE DATE/TIME
- Conditional Formating cocor VBA
- Change printer Macro
- Info disapeared
- Re Info Disapeared...
- hour to number
- Function autoupdate, relative addressing
- Custom Menu return to Excel Menu
- NETWORKDAYS formula to exclude weekends, holidays and days not worked by part-timers
- NETWORKDAYS
- NETWORKDAYS
- Do I Need a Macro For this?
- links to PowerPoint
- links to PowerPoint
- Hyperlink to file always opens with Exployer - WHY???
- Unique Count in PivotTables
- Smart worksheets???
- Finding cell by headings
- dynamic data
- Deleting redundant records
- Target times
- formula reference in cell
- Tab control
- sumproduct lookup #value! (frannnk, oh frannkkkk)
- GETWORKDAYS function does not always work
- Auto filtering
- How To: Extract data from Worksheet Tab
- Who are you Guys
- Who are you Guys
- Who are you Guys
- Who who
- Who who
- who r u guys
- Comments
- IF THEN to test for numbers/words/empty spaces
- template formatting
- Displaying total minutes in the form of hours and minutes
- Displaying total minutes in the form of hours and minutes
- Displaying total minutes in the form of hours and minutes
- Displaying total minutes in the form of hours and minutes
- Displaying total minutes in the form of hours and minutes
- Re: SUMPRODUCT
- Excel 2000
- What function do I use?
- Countif based on background
- Dates And TImes
- Dates And TImes
- Random function - odd error and not sure why
- template
- help: drop down list
- Can i activate a macro from an IF statement?
- duplicate entries
- Re: calculate training price list
- Quick Summing Question
- calculate training price list
- Worksheet protection
- Formula Macro
- excel function
- Cells not updating
- worksheets as series
- Disable Paste
- Is there a way to disable Macros by code?
- help adding to my formula
- display 1st day of each week and week number
- Cell Contents Saved in File Name?
- combining columns on the worksheet
- SUMIF
- VLOOKUP with the Smith and Jones of the world
- removing 'o' when referencing to a cell
- dsum or not?
- SUMIF function not working with Date
- Match customer number to customer name
- Re Target Times
- Frank, another function question
- different results from linest function in Excel2000 and Excel2003
- vlookup help
- Compare cells and return occurrences
- Want to write function/macro for DNA reverse-complement
- Allowing access by password to a worksheet in a workbook and hiding other worksh
- Fill Colour for an IF statement
- Fill Colour for an IF statement
- Copying worksheets
- Excel Subtotal
- Excel Subtotal
- Highlighting rows using conditional formatting?
- Is this lookup possible?....
- Re: multiply multiple cells by a specific value
- Re: multiply multiple cells by a specific value
- Re: multiply multiple cells by a specific value
- finding duplicates?...
- Re: Creating Reports
- setting limit on count function?
- Timesheet calculation
- Can a formula look for data in a number of worksheets?
- One click workbook email?
- Re: Find the next available row.
- Re: Find the next available row.
- "Find" Macro not working
- Text Box Control In A Cell
- Creation of Pivot Table in VBA
- Re: Hide a groupbox (group box)
- Lookup / If formula
- Formula for rounding down numbers
- Calculating percentages per group
- Urgent - Array Formula
- "Conditional formatting" via VB?
- Changing Column Width
- Sum Functions - cell prompting
- week ending "Sunday" date function
- Adding Debits & Credits within One Column
- Use funtion to "jump" to worksheet
- Table lookup problem
- using IF function
- Automatically resizing a cell
- Skipping to the next cell in a worksheet
- Left function returning first word
- IF THEN statement error
- Calculate formula w/in one worksheet but 2 diff. pages
- Avoid linking update to another spreadsheet
- Greater Than and Less Than Formulas
- A "Strikethrough" Condition
- Update:Conditional formatting" via VB?
- Changing conditional formatting based on seperate cell value
- Rate of Return Custom Formula
- Nick Berg Found Alive
- Countif from multiple pages
- search for text string within an array
- Multiple workbooks
- MTD Formula help!
- Frank: strikethrough condition
- Text Truncated in Excel Cell
- sheet reference
- Sorting Columns
- circular reference
- invalid file format
- Lookup the most recent date from a column....involves 3 columns
- How Do You Hide The #Value
- Problem with complicated formula
- Excel help
- COUNTIF
- selecting multiple worksheets
- Comment in a cell
- IRR - #NUM error
- Counting numbers in a range
- IRR - #NUM error
- Auto Filter
- sheet result of validation in a formula
- display a year
- Format......?
- Dynamic Column
- 'find' values
- Hiding Rows/Columns
- Countif and Sort
- Timesheet calculation
- Allowing data entry into cell only if another cell has a value
- getting a macro to change the value selected in combo box
- splitting a column
- HYPER LINK
- Calculating cells
- Add missing zero's to customer number
- Limitation in line lenghth of space delimited prn files
- Excel If Then equation how to question.
- Searching a text string in an array
- Timesheet
- Re: setting up quick keys.
- Cell References
- Calculating Cells
- Format Axis Alignment
- Formatting Cells
- Change Formula to use Named Range
- Vlookup with two reference columns
- Browser Control in Excel 2003
- Selection Lists
- splitting cells
- Help Can it be done? I am confused?
- SUMIF using Background Colour
- Excel Files Transferred via email that contain hyperlinks
- Re: Problem with Date
- Problem with Date
- changing date format
- ranking with the same values
- Monthly fills
- Cut and paste problem
- #DIV/0! instead of total
- Re: Excel 2000 - Formula Calculating Daily Hours Worked in Timesheet
- Re: circular reference
- Count unique rows and columns
- missing formatting options
- Can COUNTIF use a cell as a criteria reference?
- Piviot Table Setup
- data extract
- Help with CONCATENATE
- MACROS
- Math operation
- Color codes
- Help with importing dynamic worksheets
- Daily interest calculation
- Keep IDs as is with no date conversion
- List of duplicates needed
- array formula-f
- Excel Combo Box using External Excel data...
- Emailing pages of a worksheet
- strikethrough condition
- How to move from 1 sheet to another using macros
- Trig and Excel Functions
- Duplicate Entries
- help with a couple functions
- keep bllank cells blank
- Color Fill Function
- public thanks to Frank from Germeny
- Inserting Rows to Include Column Formula
- Re: Count ONLY the cells that are entered with a date?
- mid command to locate commas
- Using a Worksheet's Name in a Formula
- Re: Countif two criteria - Date and vendor
- Excel Hyperlink to Word DOcument
- Re: Countif two criteria - Date and vendor
- Assign Functions to Control Button
- Excel HELP with finding data in form and showing location
- Drop Down lists
- Auto Filter
- Re: Count ONLY the cells that are entered with a date?
- Re: IF statement, copy/pasting cells
- Rows to columns
- Array...
- Vlookup
- Countif ??
- Copy of a Row
- pivottable hyperlinks
- Trying to import several million rows- help!
- Difficult (?) average calculation
- Excel IF Function
- Graph List
- Remove duplication accross 2 columns
- Hours:minutes in excel
- Calculating Times
- Or condition in SUMIF
- Formula for conditional formats
- Using the ADDRESS function embedded in AVERAGE function
- #DIV/0! error - trying to make formula conditional
- Open file
- Data comparison
- Help - Using indirect to return external values
- Printing
- calling a cell from another sheet
- Forgotten password in excell 2000 document
- Double Excel Formula Problem!!
- Can I round to the nearest nickel@
- subtotal function to get average
- Cell Filtering
- Lookup Statement
- Sorting a protected worksheet
- Concatenate w/ Sumifs format
- Re: Count ONLY the cells that are entered with a date?
- converting phone numbers in column
- Compounding Inflation
- Add #'s in one cell...Solution in other cell
- Re: Number of Sundays between 2 dates
- Re: Number of Sundays between 2 dates
- formulas!!
- Add numbers in one cell
- Re: Average three greatest values
- Re: Average three greatest values
- counting problem
- Re: Average three greatest values
- Locking Rows for Sorting
- If Function
- sound warning with conditional formatting
- Re: Number of Sundays between 2 dates
- Putting the "&" in a worksheet heading
- data import
- Shared Drives
- Removing duplicate rows
- Custom formatting a cell
- If / Then Question
- Multi conditional UDF
- Importing a Text file into Excel
- No Date Conversion Please!
- Template file save to database
- Every 20th line
- Re: Macro for deleting a row
- Fill In Zeros
- Print Settings
- Formula for dates
- Find Replace Dialog Box Close button
- Conditional Format Formula
- Conditional Formatting with Dates
- Subtotaling columns
- If / Then Question
- RE: Need Help
- Re: Need Help
- Coin Toss
- Fill rows in columns
- Re: Copying Text
- Worksheet Tab Color
- Time Sheets
- Find the average of fields containing text
- Timesheet
- Timesheet
- column of items - determining frequency
- Data > Table purpose
- Interest Calculation
- Is it Possible to increase Conditional Formatting?
- Re: Copying Text
- Spreadsheet Protection
- formatting text strings
- Re: Copying Text
- Is there such a formula?
- IF function
- file views
- Trying to make a fromula conditional on at least one cell containg a value (not blank
- Mail Merge like with Excel but without word
- sql.request - ODBC add-in for Excel 2003 - where can I find this
- Cells won't format
- Sorting; While maintinaing some row associations, like a title.
- sorting text using formulas
- Filtering Duplicates
- IF function help
- Data missing from workbook
- Print Cell-Information in Page-Header/Footer
- Converting A Row of Addresses
- losing rows when sorting in worksheet
- Very Slow column insertion
- Prevent copies of a spreadsheet
- automatic insert pictures
- VAB question
- Page breaks after subtotals
- Help needed with school records spreadsheet.
- Excluding non-work hours
- Re: VLOOKUP FUNCTION
- VLOOKUP FUNCTION
- Re: Help looking stuff up automatically in columns
- Sum offset formula to add every other column
- Finding the MAX Value in a list
- Re: VLOOKUP FUNCTION
- Re: COUNTIF AND
- Re: COUNTIF AND
- Re: COUNTIF AND
- Getting around a circular function??
- Modified Date Variable
- Saving from a Macro
- footer
- Removing duplicates in a list
- how to make an income tax calculator in excel
- Conditional Format to indentify an empty cell
- Compact or Repair?
- A newcomer on macros.....
- Rouding Decimals
- I NEED HELP ASAP!!!!
- Sorting on Multiple Columns
- Finding the MAX Product sold by Salesperson
- Does excel max out for lookups?
- Converting a date to the day of the week
- Summing on 2 criteria
- Home mortgage amortization with two different interest rates?
- an alternative for the Choice function
- Error in Excel-' Not enough sysytem resources to display completely'
- Help Needed
- Index/Match Problem
- wildcard function
- Linking formulas
- pivot table question
- Displaying the result of a formula in a different cell
- Excel financial spreadsheets
- Pivot Table Question
- calculation between cells in different formats
- INDIRECT function
- Macro generates error 1004
- Error message with Data -> Form
- using Excel for a survey
- Sove this equation
- How to select a cell from another work sheet base on a formula
- Sum of Shaded Cells
- Blank Document not blank
- Lookup, Match or simple formula?
- working with cells
- Re: working with cells
- How do import banking statements into excel?
- Making First Letter Of A Text In Upper Case
- Sum a range based upon a criteria in ANOTHER column
- advanced filter: duplicate result
- not found problem
- Efficiency Formula: Help requested
- RE: COUNTIF AND
- Follow up on my previous "INDIRECT formula" question
- advanced conditional formatting
- Formatting Formula Results to Text
- Linking sort results
- Countif doesn't work
- copy vertical values from a column across a rows
- If then statement help
- paste Formula using VBA
- Where did my macro recorder tool bar go??
- IF
- drop down menu
- CUMPRINC Function Returns #N/A
- concatenate button
- Adding a symbol or test to an existing cell
- Hope this partially helps.
- Conditional Formatting
- If Statement with Like?
- change a table to 3 columns only (Rows instead of Table)
- Or Statement?
- conditional link
- Msgbox code needs tweeked
- HELP--ARRAY Formula help
- multiple conditions for sumif
- Date calculations using functions
- functions to check it a worksheet exist in a workbook
- Re: Xenon 2
- Sum Cell value by font color
- Protection
- Formula help with circular reference
- Absolute value resolution
- Hiding "error codes" in cells
- retrieve values from several cells into one cell
- Unstack column or an array?
- mistake
- Changing the date with macros
- active cell's movement from up/down/left/right adjacent to other select cells
- Formulas not working
- IF statement returns #VALUE
- Countif or another Solution Needed
- Random Numbers
- Select numbers from a Random of numbers
- using SUMIF function with compound conditions
- If And Statement
- To Jerry Lewis
- adding specific cell with todays date
- Nested IF Troubles
- SumProductIf?
- need to print "formula" in cell
- Data functions Lost or Disabled?
- excel forumla
- Problems With Custom Worksheets
- Credit related formulas
- mconcat
- Multiple Use Of Auto Filter
- Reference Previous Row with ROW
- proper formula for countif (a1:b10, "apple && pie")
- Replace comma with hard return
- Sum to exclude blank row
- Count the number of times a charecter repeats in a Cell
- Date and formulas
- Copy Conditional Formatting
- conditional summing formula problems
- Is it possible to mix up a list of numbers
- Extracting a # of days from a date range
- Delete Characters
- Hiding Zero Cells
- Counting list entries on 2 criteria
- should i use offset?
- covert text to e-mail address
- =DAYS360 Function
- Formula question
- Importing data and sorting into different worksheets
- IF then statement in conditional format
- vlookup and hlookup ? required
- Unique text strings
- #N/A = FALSE
- Decimal places
- Count days
- Printing
- If / or/ then
- Count days formula
- Grouping Sheets
- linked workbooks
- sum products with ANDs
- Adding days to a date
- subtotals
- Re: If you can figure this one out, youre a Genius
- Re: If you can figure this one out, youre a Genius
- Trouble using "Day" function in a formula
- Protecting functions without stopping Auto filter
- I need help
- Hopefully an easy one...
- worksheet row limit/pivot table
- Conditional for Object??
- Concatenation
- Concatenate...If...Need to roll up text.
- Row()/Column() Function Does not Work with CoVar() and Offset()
- Column Problems
- Copy cells to a row specified in another cell
- Re: Problem with evaluating dates and rates to use
- Find relevant sheet name
- SUMPRODUCT does not work
- SUMPRODUCT Problem
- TRANSPOSE and MMULT don't work together
- TRANSPOSE and MMULT don't work together
- TRANSPOSE and MMULT don't work together
- cell protection
- Rounding Up to the next .50
- auto format
- IF function gone wrong
- Re: If you can figure this one out, youre a Genius
- zeroes
- Re: If you can figure this one out, youre a Genius
- Counting entries in filtered spreadsheet
- External workbook references with variable components ??
- ANOVA
- VLOOKUP multiple conditions ...
- adding a table in a sheet
- How can i trap the rename event of an excel sheet?
- Re: Pivot table fonts
- TIME / NOW
- Cell contains text - count by multiple criteria
- ActiveX / Forms Combo Box issues
- How do I alpa a workbook
- Min
- looking at for the latest date
- Named Range and multiple entries in Define Name
- Sumproduct using contains rather than equals
- Fussy matching?
- Formula Problem
- Filter for cells by locked/unlocked status
- Running a macro through an IF function
- Re: today() function and text
- 2-line address in one cell
- Formula query
- Use lookup table in another WB?
- Function to replace
- divide by 0
- Re: trying to input number from another cell automatically
- Format or function to drop decimal
- COUNTIF
- Printing
- Inserting Text into worksheet???
- Sort by column Color
- Pivot Tables
- formula for excel sheet
- Perpetually summing totals for a rolling 6 month period
- RE: Function to replace
- How to sort by birthdate
- hiding formula
- Macros disabled message
- Comparing 2 Tables
- changing row and column indicators
- isnumber won't work
- Concatenation
- Formula or Macro for Scheduling, with lookup
- Formula incorrectly calculating
- Future Value calculation
- Re: Thanks People
- Fill in missing cells
- vlookup matching two columns
- autorank
- Re: lookup help
- Re: comparing matching same values in two different columns
- Re: lookup help
- Re: link cells from one workbook to another by left clicking the cell.
- autosave question
- Partial formula value increment
- More COUNTIF
- Dmax Criteria
- Custom Date format in formula
- Timesheets - again!
- Im stuck in VB!
- Finding a value
- Excel workbooks
- RE: Changing path of Template Wizard
- CONCATENATE but skip the blanks
- Re: Time and If function or something else
- drop down menu
- avg percent
- checkbox
- How do I express the value of (the geometric constant) pie in Exc.
- How do I apply LTRIM to entire Sheet?
- Copy then Paste more than once
- Auto Formua Calculations
- Multiple file
- Multiple fie
- filtering info out of a list
- Overflow Problem
- Can't insert a simple row
- Check my Conditional Format Formula
- Ignoring the higest values in an arry, and the average of the rest
- Extract part of a text
- Returns last number
- Monthy Averages
- Previous Cell
- multicondition if
- Compare Text in Array of Text
- Fixed Decimal in Excel
- Requesting Frank Kabel's Help / Comparing 2 Tables
- Stationary Columns
- Extraction from a cell
- Return a value if a date lies between two dates
- transpose and link??
- find text split across cells
- Sumproduct w/ month and year
- RE: Sumproduct w/ month and year
- using vlookup to find the next highest item in the list
- Rev Date Function
- Re: Help! Need to extract or pull data into new workbook to e-mail
- Re: Conditional Formatting Fun!
- "Sorting" away emty lines in between
- Distribution in time
- merging data in cells
- Calculating hours worked with an hourly rate