- Names with If function
- auto sum from multiple worksheets
- How do I calculate variance between numbers?
- ALPHANUMERIC
- how do i autofill a cell a certain colour based on it's value?
- finding total from 2 seperate columns
- Duplicate Numbers when using the Large Function.
- Using pop up boxes to supply a variable within a macro
- Sum cells
- Rectangle Box
- Using date format in the cells how determine percent complete
- vlookup and match functions
- Combining Hlookup and vlookup
- EOMONTH Formula
- change sign of a column of figures from + to -
- use sub-totals and average in same calculation
- Using "Non-Empty Cell"
- How to calculate the total area under a curve in excel?
- Allocation formula
- Nezkop*ruj* se vzorce v konting. tab. z jednoho sešitu do druhého
- create two lines in one cell
- calculating working hours between 2 dates
- Results table help please
- Referencing cells according to date
- VLOOKUP - recover missing data source
- Min Year in an Array
- How to add 30 days to date in another column, including Sat/Sun?
- worksheet protection
- How do I get full tab color?
- Formula for counting more than one criteria
- FORMULAES
- Fill Down Formulas
- how do I do conditional formatting for absolute values?
- How do I set up a validation list?
- Wildcard Searches across Worksheets
- Commas in Excel textbox moves my sentence to the next row
- How do I find multiple text in diff cells in another worksheet?
- Save one worksheet as PDF?
- Skipping Cells
- counting unique names - again
- Need HELP! Solve for mortgage interest rate with following variabl
- Cell names = sheet names
- Email one worksheet to email address on worksheet
- excel 2000 images
- summing the same cell in multiple workbooks
- VLOOKUP WITH RANGES
- Value of String used in Calculation?
- Macro to Extract Template Data to New Worksheet
- EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
- formula to reference cell on previous worksheet
- Inserting a picture or chart into one cell in Excel
- VLOOKUP
- Copying cells from one workbook to another
- Trying to do a Lookup
- Monthly Change Using Nested IFs?
- can i put in numbers and have the computer randomly draw 1?how?
- What function tests for whole number (no decimals)?
- Dynamic Ranges
- How do I add hours and minutes without 24 hour limit
- Cell coloring according to the other cell's value
- export information from excel to word doc template
- SUMIF with two conditions
- IF formula using a range of values in a cell
- exel 2007 process
- COPY DATA FROM ACCESS - PASTE IN EXCEL
- link to web
- Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y
- Cell without its own format?
- calculate remaining pay periods
- If in specific cell in any worksheet but worksheet one add to spec
- How do I freeze a data range when I drag it to a new cell?
- Drop down menu and validation over mulitiple sheets
- Auto Sum Function
- Retrieving data based on most recent date
- Compare value in current cell to previous cell
- Formula
- Formatting Code for SI Units in Excel
- I need to Write a Formula
- Trying to get a value using two conditions
- can I compute the bounds of a 3D reference
- Lists
- Looking for formula to place score in a range of scores
- Formula Problem For Checkbook Register
- SUMPRODUCT against rows, columns
- Insert Columns in multiple sheets
- CONCATENATE Date formatting
- Re: Seeking advice for complex charting algorithm (16K attachment)
- Insert>Name>Define
- conditional formatting for <= +- 1.0%
- Auto copy data from another database
- Average time between 2 dates
- Copying the sum from the lower right hand side of the excel window
- remove leading spaces
- lookup problem
- I am in search of formula
- Formulas in 2007 not working in 2003
- Seeking advice for complex charting algorithm (16K attachment)
- Running total for inventory
- Solving Sudoku with EXCEL
- if range b6:n6 has no content, return A6
- Connecting Worksheets
- time guru needed
- Automate adding in a reference number if the adjacent cell contains text...
- sum column based on multiple criteria
- Auto-fill formulas Excel 2003
- Lookup a value in a row and the sum the corresponding rows in colu
- Counting unique entries across two or three columns
- Merge and remove duplicates?
- Allow no action to be taken
- importing data form access
- Dynamic Row Formula
- Notify when cell value changes - Excel 2007
- Hot To Copy Pivot Table formats
- Automatically change case is Excel when typed
- How to insert rows based on change in data
- Error Handling for xlCellTypeFormulas
- How do I transfer data with hyperlinks to a pivot table without l.
- MAX Array?
- Copying only selected items to another worksheet
- Incremental forumla needed
- Sumproduct with 2 criteria.
- IF Function Question
- SUM function across multiple worksheets within one workbook
- Interpret a squence of cells as an array
- Bug or wrong approach
- Having Trouble Inserting a Column
- Attrition
- results of value_if_false = no change to cell
- Easy Calculator
- Hot Fragrances For The Holidays
- My Excel Spreadsheet now has numbers on both axes - why?
- Column with repeated numbers
- excel worksheet export into access table
- Adding code to a macro
- INDEX error
- How do i get more then 3 colours conditions in one sheet in excel
- MS Excel Nested Functions
- Conditonal lay-out
- Remove #VALUE! from ConCat Range Function
- Macro for Copying
- How to count occurrence when there is an "AND" relation?
- Why does this code not do what I want
- Can't remove formatting from copied data in Excel worksheet
- What function-bring me the info in the next column-same row?
- Date format
- I have doubt regarding the find a result with two criteria's!!
- Filters using multiple sheets
- FORMULA
- FORMULA
- how do I have a heading row repeat on each page while working?
- Cell value when conditions are met
- Need help with formula
- Add worksheets in excel
- How to delete blank worksheets
- Formula Help
- SUMIF Question
- create yearly subtotals in pivot table
- SUMIF Question
- CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
- countif with variabel criteria?
- Date changes mysteriously
- I want to count the cell if contains 111 or 1111
- Excell
- Need help with a worksheet
- Getting a list of returned values from an array
- Help w/Validation List & VLOOKUP
- Multiple Logical Functions in one Formula
- Calculate number days + hours to complete a project
- Cell content
- trying to get worksheet to automaticcaly update form row to row
- Mode Statistic Function
- Cells changes colour if....
- How Can I Insert A Column in A Spreadsheet With This Error Message
- need to return next match of table, only finding first match...HEL
- insert worksheet order
- auto change font color in formula/cell
- Date format
- Advanced Array Formula Problem
- only returning 1st matching entry in table, need to find next matc
- test
- Test
- Referencing Cells
- Referencing Cells
- More help with a UDF
- Question about COUNTIFS
- time seperation
- Referencing Cells on Another Sheet
- This should be easy, but can't find an answer...requesting your in
- MVP articles
- Can't paste cells between sheets and have formulas follow
- how do i make a formula to multiply two values?
- EXCEL 2003
- MVP Published articles
- Find unique data by row
- A problem with Nested IFs
- Modify a UDF please?
- A problem with nested IF's
- Exclude Unique Values
- Page Filters
- Modify a UDF please?
- Replace the Find Function with a formula
- A problem with nested IF's
- More help on a UDF please. Urgent!
- Excel Chart
- A somewhat complex (to me at least) Nested IF issue
- Use an If function to result in more then one answer
- How do I hlookup a text document object and then display it?
- Can't Access Add-Ins
- Syntax help with date calculation
- format cells
- Automatically move to next cell...
- Populate Order worksheet from Quote worksheet
- getting 3% from a work sheet
- counting numbers??
- How to find a third true-false relationship between three groups ofvariables knowing two
- Filter Across Multiple Sheets
- E-mail Sort
- Sum Count of Numeric Duplicates: appears x2 in any Row
- HELP: Sort of AutoComplete feature or i don't know
- Formula apparently successful but #VALUE displayed
- Hide a row and set print area
- How to
- Using list functionality
- Date stamp when a value is entered in a cell
- changing date format
- Combining AND, MID, and OR
- adjacent cells?
- How can I set up a dynamic data entry form?
- Data Validation 2003, Named Ranges/Formulas
- Populate order sheet with data from work sheet
- if then
- Custom number code [conditional] help
- index\large help....UPDATE
- Editing an Office 2003 Document using Office 2007
- Date stamp when a value is entered in a cell on another worksheet
- choose table_array in VLOOKUP from list of multiple worksheets?
- SUMIF? Question
- millisecond
- Pivot Table Wizard Fails to Recognize New Rows of a Named Range
- dropdown list within IF statement?
- Hyper link between excel worksheets
- I have a DB of auction items sold, how can I create receipt?
- Somewhat Complex: Allocation of Payments
- How to get text
- Count of entries meeting criteria
- Delete all data on a worksheet
- Output of the =IF(COUNTA) Function
- phone number format
- Text lookup array and match specific data
- Functions
- referencing mult drop down list
- Interpolate two or more data points
- Help with adding pages
- totalling phone minutes
- Can I link/lock rows so they move together in a sort?
- excel spreadsheet
- Negative time calculations
- Do I use "IF" or something else?
- whole price sheet change
- retrieve data from worksheet
- auto filtering?
- Create a rule>
- How do I use the LOOKUP feature in Excel
- Can I convert a number(1-365) to a month and day of a year?
- Macro to Move Specific Data to Another Worksheet
- Cond Format - C6 when G6 contains any text
- index/large..help please
- Excel Sequential Numbering of cell within worksheet
- 2003/XP Macros in 2000
- how do I add a solid color fill to a photo inserted into excel
- SUMPRODUCT gives incorrect total
- How to determine the value?
- Recover Excel file that was saved over
- Move Specific Data to Another Worksheet
- Functions
- formula for pairing 60 different products into 5 price groups
- Urgent help needed
- How do you determine a total number of worksheet entries?
- can I find the area under a plotted curve?
- Borders and conditional formating
- vlookup?
- Hyperlink
- If Statement
- Worksheet Protection
- Year to date sales
- Regression with zero intercept
- Can you use multiple SEARCH functions in one cell
- Conditional Formatting help, please
- how do I write the formula to find the mean in a column of number
- amortization table
- Sum column based on text of another
- Economical grouping of lengths out of much longer lengths
- Sumif for groups and subgroups / Excel 2003
- Defined Names in Workbook
- how do I lock formulas, but still allow rows to be added or delet.
- changing dates and years with less keystrokes
- Array Functions
- Excel formulas
- "add parenthesis"
- Too much data?
- Why does my print preview (and print) not reflect the chosen margi
- Finding duplicate numbers in a spreadsheet
- vlookup / index / match?
- Excel 2003; using a date in a formula
- Help Vlook up returning N?A
- why does my "TAB" key skip a column in excel spread sheets?
- How-to create a list from a summary table? (Office 2007)
- Check Date Range and Multiply Stock Qty
- Extract data from database
- How to check for a date range match in one column and then count thevalues equal to in another
- Function To Lookup Unique Records In 2 Sets Of Data
- Assigning A Macro to A Button
- Find one character or another and display
- Disable Excel Print
- Automating excel with outlook
- Assign a date
- How do I count occurances of a specific character in a range?
- Removing #N/A from formula results
- Cell Shading
- Queries/Extracting
- Queries, extracting
- keyboard short cut for highlighting a field
- UDF that returns a date
- need to move cursor to specific fields
- Making a list of numbers with 16 digits
- VB file renaming.
- Copy first few letters from a cell
- How can I delete all matches in a workbook?
- Help with spreadsheet
- Need cell to equal another cell if certain criteria is met?
- question re: SUMPRODUCT format
- How can I create one column (stacked) from a large table of data..
- I can't get Excel to caluate dates in the 1800's. #VALUE!
- Formatting color and font to a logical statement result?
- scatter plot
- Autofill dates not in contiguous cells
- More Planned and Actual Cycle Times
- Formula or function displays after edit and not its result
- How to return a number into letters?
- Total A Range
- Validation - e-mail
- Insert a row with simaler data using a function
- Protect borders only excel spreadsheet
- GETPIVOTDATA with date in referenced cell
- Count If And Contains
- IF function question
- IF function
- adding function- can you hide the 0.00 in the total column
- IF Error
- Sumproduct but exclude labels
- Worksheet change Event
- Create alternate line of data
- Excel formula reference question
- problem trying to change page breaks
- Display if cell contains data
- creating a report with macros
- Linking Files
- Numbering different products
- Filtered field
- vlookup formula
- Keyboard Shortcut for Drop Down List
- Conditional format issue
- Linkage File
- Count the number of AutoFiltered records
- Year & Month format
- Working with the forms in different workbooks...
- need help on excel sheet formula
- you are help me
- cancelling copy command after reactivating workbook
- Formula VLOOKUP I think
- how do i sort an excel spreadsheet by column
- Validation look-up lists showing in 8 point, too small read easily
- Returning a Cell Value
- complicated excel formula
- (V)LOOKUP question
- SubTotal function to return number of rows returns only zero
- How can I count the frequency that a number is repeated?
- How to show original comment in cell when using Vlookup in Excel?
- Different font characteristics in concatenated cell
- web query
- naming cells
- Can you save 1 sheet from a large file into another file?
- not sure how to do a formula
- Sales Commission Calculation
- VLOOKUP
- Count Blocks of Data
- FYI - Microsoft Acknowledges XL Flaw
- Excel color-formatted cells printing in black
- sorting imported data
- Vlookup plus
- Merge data from xcel to word
- Grayed Out Columns
- Vlookup DETAILED directions
- Cycle Time if in a Specific Year
- Create a macro to eliminate certain words from several columns
- Create Acronym (Extract first letter of each word)
- Can I separate two words in a column?
- New to functions. Is this possible???
- Column has emails & other stuff. Want to create a column w/ just e
- Changing the value in a cell (but a bit more complex than that <G>)
- sumif
- Freeze pane works in some workbooks but not others
- Fill cell with a worksheet name?
- META Tags Explained And How To Use Them For Ranking
- Count consecutive cells then start over
- new
- Data inputting question
- Date format
- Delete a row without dirupting the formulas in the following rows
- Find and count (sumproduct)
- Adding a Custom Column based on an existing Column (EXPERT)
- Duplicates Formula
- How do I select more than one item from a drop down pick list?
- WORK HOURS DIFFERENCE BETWEEN TWO DATES
- excel search formula
- 3 column lookup within range
- Splitting the characters in the cell
- Copying data to a different row
- VLOOKUP
- Concatenate Question
- calculate formula of another cell
- Have code check cell contents on edit.
- Collapse and expand data
- Populate an order form with Data
- Drag Copy
- Need help with formula
- uncombining columns
- Link to Pivot
- drap copy without increasing the value
- Find Formula
- Fun Place
- Selecting data from cells that are 5 rows apart and groung in 1 co
- loan amortization schedule
- dates older than 1900
- Number Formatting in a concatenated cell
- networkdays function
- Count names and occurrences
- HOW DO I SYNC EXCEL FILES ON A LAPTOP?
- Driving me nuts trying to figure this formula
- Copying Data from Multiple Sheets to One sheet
- Creating a proprer macro in Excel
- Sorting "State" Column onto separate worksheets in same workbook.
- Is solver different between Office versions?
- Combining columns?????
- What would Excel Assume if DATE left blank
- statistical process control
- How to delete an repeatitive entry from a worksheet
- Date Question
- conditional format help please
- Between one number and another
- Identify if a cell contains a numerical string
- "background" formatting possible?
- Need Help..
- Data Validation Fail
- Auto fill icon...
- Show the top three items in a list
- Return cost with 2 criteria
- conditionally format anumber format
- find all same numbers in a column without dropdown listing
- Adding single cell in multiple worksheet then averaging
- Replacing a Table-array with a cell reference in vlookup
- formula
- Is it possible to save only a specific sheet within a workbook
- How Can i use the cell colors as logical tests?
- Running a macro
- Challenge: Return the rightmost 12 values (rolling 12 months)
- Difficulties with date in conditional calculations
- Use Formula to sort two strings
- copy and paste.
- Using COUNTIF for multiple text data creating a logic statment
- Auto populate data from a table into cells after a match is found
- Find value in more than 100 worksheets at once
- Ranking with Duplicates
- #VALUE! from SUMPRODUCT
- Copy specific records from a worksheet to another
- Returning an array of unique values?
- How to reference a cell depending on the value in another cell??
- Convert numbers to words
- Convert Number to Words
- nested MATCH within Array formula?
- how do I enter a reoccuring event like once every 9 days
- Average & Deviation
- Problem w/formula referencing another sheet
- Remove Negative Signs from Formula Results
- Calculating time
- count(if(... using array formula: can I use a named range in my ca
- Editing formula results so zeros appear blank
- DATE() Month in Letter NOT Number
- add file extensions to a column
- Leave Cell BLANK if no criteria met
- Get Values from another Worksheet
- Bill Payment Form
- Extracting List of Occurrences
- Capitalize first letter in sentence
- DCOUNTA question
- NOT equal to
- Not all words in sentence prints - row is set autofit HELP?
- I have the checkmark beside print gridlines and they won't print
- Explode field
- Array or SumProduct or other?
- Color cell if spell check finds an error
- Consolidating worksheets
- What function do i use?
- SUMPRODUCT, INDIRECT, dates...
- reference first cell in a named range
- Paste from clipboard only
- Excel macro spreadsheet that is rejected by other firewall. Why?
- converting .html to regen lost .xls file
- Not sure which function to use - need multiple lines of data
- 6 cell sum
- Writing a macro
- how do I change a date to show the year only?
- Nesting SUMIF with Wildcard
- Duplicates in a spread sheet
- date entry
- constant date
- Probelm with macro
- No. of Saturdays between 2 dates
- average(if not working properly
- "Grouping" based on value in a column
- Macro error
- how to sum only specific coloured cells
- If Then Or Statement
- Converting a Formula stored as String to real Formula
- how do i bring back excel sheet ?
- Is there a way to turn off the auto save function?
- Express a Formula that is + or - 20% from a Value Q
- Problem encountered when saving worksheet as a text file
- How do i use a 24 hour clock format on my timesheet?
- Conditional Formatting with Percentages - only 2 of 3 working
- Edit Multiple Cells
- New version of Excel doesn't show my other worksheets!
- need a function or property to extract the hyperlink from a cell
- Adding criteria to loop
- Autocomplete combo box
- Macro HELP
- large database with multiple rows
- how can i write an equation in polar form in excel
- Can I VLOOKUP in 7 different worksheets in 1 formula?
- "SUM" DOESN'T RE-CALCULATE WHEN A ROW IS INSERTED ABOVE IT
- Excluding cell in formula
- Extract part of a text string
- Vlookup -Difference between 2 versions
- convert text to number in excel
- Compare two lists; return only unique records
- VLOOKUP IF
- Formula for "counting" numbers - not cells!
- Basic Statistics - which function?
- Count occurences from one worksheet to another with "IF" Criteria
- automatically update hours
- problem data validation and copy/paste
- custom add formula
- how to I determine frequency
- Omitting right part of text string
- summarizing data
- how to enable formula auditing in a protected worksheet?
- Need hyperlink function to obtain range name from a cell (contents
- Automatic Drop Down List
- autocomplete from specific list
- Service Charge Allocation
- Criteria field in dsum formula
- What is ;
- change event macro to add cells
- Automatically extracting unique values
- VLOOKUP
- open file in current directory
- Wrapping cell data to a new column or page in Excel
- Creating a new "record"
- hiding error message when dividing by 0
- Auto Populate from a Mater List into Sub Sheets
- Transaction Classifications in Checkbook
- Accumulating Attendance Base upon Age Group
- Auto column insertion based on a number
- Transpose and Paste Link
- Drop Down List Size
- Conditional Proctection?
- How do you automate cells to poplulate fields in separate workshee
- Re: Printing a specific area containing data and not formulas
- conditional headings
- "Date Format" v.s. "##/##/####"
- disable Warnings in Excel
- Conditional Formatting across worksheets
- AUTOMATIC SPELL CHECK
- Bold the number only in a concatenated with text formula...
- Drop Down menu w/ info in other columns
- Not enough conditional formatting
- Function for stopwatch times
- Using auto-fill to populate a table using data from several tabs
- Adding a yearly calendar to excel spreadsheet
- Help me with a pdf converted into excel
- col heading help
- Formula for "counting" numbers - bot cells!
- Row reference in a formulas
- Automating a printing of pages that are Hyperlinked to external so
- Custom Functions
- Formula Error #value
- Column question...
- match function for 2 values
- Value from List Box?
- Importing into excel PROBLEMS
- How do I average only if data in another column = "X"?
- Replaced a file but need the old file back
- Equal formula keeping both content and format
- Editing Comments
- Create new worksheets per pivot page field
- Naming working sheets
- Conditional formatting
- PLEEEEEASE HELP
- How to repeat cell downwards in a column?
- final return!
- How do i consolidate 13 spreadsheets onto one
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- How do I turn off format painter so it doesn't keep popping up?
- actual/360 and 30/360 amortization?
- SUBTOTAL with a condition
- Formula to match 7 columns of non adjacent data
- transferring data between sheets
- Conditional formatting
- Excel - disable automatic function
- Excel - disable automatic function
- Upper and Lower Case "within" a formula
- Autofill Array Functions
- linking worksheets
- How do I fix a YMD format?
- INDIRECT & SUMPRODUCT QUESTION
- Copying data based on filter criteria
- Embed an array?
- checkbox in a protected worksheet
- index and match closest
- Sorting by colors
- Highlight a cell with a specific word in it
- Linking text
- Long "IF" formula
- what do the brackets { } mean around a formula?
- merging 2 excel sheets
- Count with condition range
- help with lookup and range
- how do I tie multiple worksheets to one sheet in Excel?
- how do I tie multiple worksheets to one sheet in Excel?
- Excel
- If Then Or Statement
- Conditional formatting to test blank text cell
- How can I transfer formulas between 2 Excel workbooks?
- How do you merge worksheets
- Auto Copy Text from one work sheet to another
- Missing sum bottom of excel window
- How could I flag a cell. Ex. Cell B is less than Cell A. Flag B
- I want to link an Excel cell to a contact record in Outlook
- adding up sheets that arent there yet
- Keeping formulas that reference a tab that changes daily?
- short cut for inserting rows
- referencing a 3D Named Range
- Pivot Tables to summarise a column in one row?
- Copy links between excel workbooks using citrix?
- Linking Excel Worksheets
- Get data between two values
- remove convert/extract the number from'12345.56; ie remove ' sign
- Result of Multiplication is comming up as zero
- Travesing to one cell value based on other cell value!!
- How can I count data after I apply a Filter in MS Excel
- range usage question
- Vlookup plus other function/s combinations required?
- SUMPRODUCT question
- Control + Grave accent doesn't show formula result, format is gene
- SUM odd/even Rows?
- Multiple Variable Formula Help
- Retaining cell reference in destination, when sorting source file
- Formula Help
- I need help with a formula.
- Subtotal - Based on DATE
- SumIf Problem...trying to sum multiple columns
- if formula
- Excel automatically updates inserted date
- How do I modify database criteria at formula level?
- Transpose array sum
- Can I get Excel to automatically BOLD dates 30d before expiration?
- Advanced Filter By Cell Contents
- edit directly in cell - scroll with mouse
- CountIf, SumIf formula ques.
- Multiple Criteria, Count If, Sum Product to get count across range
- Conditional Formatting for more than 3 conditions
- Set line color in a spread sheet
- Ordering Columns in Pivot Tables - Excel 2000
- excel 2000
- How can I sort when the worksheet is locked?
- Can u put an "IF" inside of another "IF"??
- If / And / Or Macro
- How do I Propogate Cell Selection Pattern?
- Conditional Formatting =IF($B1>0, TEXT("dddd"))?
- How do I use moving averages in Excel 2007?
- Re: IF, AND, OR Function
- how to extract duplicated data from two seperate worksheets?
- Macro is not responding
- auto-complete from a drop down list and from a different workbook
- Opening an .mdb file in Excel
- Automatically update spreadsheet from another spreadsheet
- IF, AND, OR Function
- Using the CountIf function with multiple criteria?
- Confused about setting up functions based on variables?
- Moving Info from onw sheet to another
- Link from 1 worksheet to 4 different worksheets
- CSE formula disregard blank cells
- index/match or vlookup or similar
- Convert Seconds to Minutes
- copy many sheets into one
- Stop excel rounding my 16/17 digit numbers
- can windows vista edit shared document from windows xp
- Query equasion for dates
- Hyperlink to Named Range Based On Cell Contents
- Calling AutoFit using macro in XLCALL.h
- Days between dates including start day and weekends
- Iserror is too cumbersome as I use it - is there an alternative?
- Countif text in individual cells
- Copy Unique Entries
- filter dates by quarter
- calculating and coloring
- vacation formula and 1/2 days
- YEAR and IF
- Using INDIRECT
- Creating running clocks in multiple cells.
- Extract everything to the right in cell when a number is encounter
- Pages in a worksheet linked, how to unlink??
- clear the file now available msgbox
- Working with worksheets
- Formula displayd as text ???
- VBA to reattempt to open if file is read only
- If statement when two cells are the same
- Function for visible cells only
- Dave Peterson
- Created IF functions - Need sum of results
- #VALUE & #DIV0
- Equate numbers to text
- vlookup on first occurrence of X after Y?
- lookup function, I need hlep
- What is the NNTP for this newsgroup?
- DSUM
- copying data to different worksheets in the same workbook
- RANK without a tie
- Excel 2003
- Opening a file stops a Macro
- Selecting from drop down list enters multiple cell data
- IF, Then
- Figuring Late Payment on Mortgage
- Running Sum question
- formula for counting the occurence of more than one condition
- Excel Formula Question
- General Ledger Template
- Count all “Z” in a Range
- Merge problem
- Create a Command Button to Send E-Mails to selected recipients
- Index Function
- Some text won't print from my worksheet
- Hyperlink
- ODBC AfterRefresh Event and Shared Workbook
- MAX formula?
- Using INDEX and it Returns a #N/A
- Column List to Multiple Columns
- Lock cell formats (conditional format)
- adding numbers with letters
- calculating probabilty of x number of successes with multiple tria
- How do I change a file displayed in thousands to millions?
- Extracting data from hyperlinked spreadsheets
- First working day of the month
- Pivot Table Source
- Where are the add-ins
- Can function be applied to range in sumif prior to criteria check?
- link data to worksheets
- Copying Worksheets
- Macro to change time format....
- Obtain row number of active cell
- SUMIF <>
- format a cell
- How do I combine text from adjacent cells?
- Photos in cells?
- Count Products
- Sum of digits in a number
- How do I Hi- lite the max of last 20 entries
- Can't see all text in Excel Cell
- Percentage function
- Excel 2007 Vlookup Using New Table Syntax
- IF statements
- New workbook from template on ftp site
- Variabilize File Path or File Name in SumProduct (and Vlookup too)
- Date Calcuation with Blank Cells
- AutoFit function
- Greater Than formula
- can't click on cell to reference to another workbook
- Autofill in Various Tabs
- Help with workbook procedure
- how touse features:enter, tab etc while typing text in excel cell
- In Excel how to make changes that be repeated in the other spread.
- If not, then populate.
- Excel data sort
- Highlight automatically a specific cell
- View Values Formula is using?
- If Statements & Combining Cells
- Auto Capital Letter in a cell
- Calculating quarterly investment returns---XIRR or another function??
- Conditional statements
- Formula
- Array extended formula - sort
- HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE
- Setting up Email Reminders
- Making Cells Mandatory and Running Checks
- How do I set an average to not count blank cells as zeros?
- Trying to get total mileage for a specific month
- adding subtotals from several worksheets
- How Do You Stop Annoying Excel Message Boxes?
- INDIRECT FUNCTION - I want to freeze reference when inserting rows
- Nest SumIf
- worksheet to worksheet subtotals
- Help on data style issues....
- "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4
- lookups
- Excel Formula Error
- Not sure what function, macro, etc to use
- Incorporating the first 40 out of 250 rows in column values
- Cell Equality
- How do I use a cell value as a parameter
- Import .csv File Problems
- Annuities
- Worksheet to Worksheet
- want to use a barcode scanner in excell need formula "if" "then" ?
- Table with complex calculations
- Formula to Sum cells below a target call
- worksheet help
- If Formula question Excel 2003
- countif column d equals x and column a noblank
- Top-alignment in cells / Normal Style
- Default Number Format for all WEorksheets
- auto compute
- Type once and the info goes into other cells
- Formula Help Please
- TEMPLATE EXCEL
- Fix EXACT function so it always compares in the same row.
- HOW DO I SET UP AN IF STATEMENT THAT WILL UPDATE MONTHLY
- total amounts acquired through formula's referencing other sheet
- Keeping Adjacent Columns Attached to a Pivot Table
- Sumif / Countif - Not certain - want to extract data from cell and
- forms
- How to apply a bracket to right side of a series of text cells?
- Formula Error
- No printing of drop down box
- Sumif with 2 ranges & 2 criteria
- pull drop down list result into another cell
- REFERENCE ... VLOOKUP ... OFFSET... MATCH?
- Pivot Table Sales Projections column
- how do i break information into columns after importing
- More than 2 IF options
- Combine data
- Auto Filter - Calculating Median
- Pivot table calculated field error
- Function to use...
- IF HELP
- What function to use?
- Multiple Combo Box Query
- Holiday and sick leave records
- filtering a spreadsheet
- Use Combo Box value to determine macro used
- VLookup with multiple conditions
- Date Entry error In Microsoft Excel 2000
- Blank cells: ISBLANK = FALSE, ISTEXT = TRUE
- Average of multiple range with error values
- Formula based on formatting?
- increase serial number
- Tables in Excel Spreadsheets
- Identify the row with specific criteria
- Interpolating Yield Curve
- Excel2003 - Automatically sum a variable number of rows
- combining text from separate excel spreadsheets into one spreadshe
- Keeping rows synchronised
- Computation of total work days
- Help Writing Function
- calculation property error in 2007
- Matching name from one worksheet to another
- how to update a worksheet and have data copied to another sheet?
- Visual Basic Editor - Time and Date Entry Continued
- editing a query
- Pivot Table - Blank SubTotal in Calculated Field
- Combining IF, ANd and SUM functions in a formula
- fill color not displaying in preview or print
- Is there a way to link a cell (only) to an Outlook task?
- Named ranged selection problem
- Excel Formulars
- sorting lists
- SUMPRODUCT with Date() -60
- Excel 2003 -Links
- Conditional Statement
- tab names
- WHEN OPEN EXCEL WORKSHEETS ALL COLUMNS COMPRESSED DOWN SMALL WHY
- Pivot Table and Chart for Previous Week
- Lookup function
- Pivot table: Most recent price for an item?
- Time
- Unable to get a correct total when changing data within a formula
- Convert a number to a text string
- Vlookup where table array is in text format
- how to sum, if column name is F02 and row name is Federal
- How can I change the size of a cell and hide what is in the cell?
- installing XIRR
- separate text string
- excel 2003
- populate cell with muti lingual text
- Subtracting more than 24 hours from a Date/Time
- Conditional Formatting based on top values
- Time and Date Entry Shortcuts?
- macro comand question
- SUMIF & INDIRECT problems
- apr to apy
- Retrieving hyperlink from cell
- HOW TO WEED OUT DUPLICATES IN AN EXCELL DATABASE
- Calculation with Decimal
- SUMIF / IF
- How to change a reference when the sheet change the folder?
- Dont want #DIV/0!.
- Columns to Rows
- Differnce function and argument for amounts in adjacent cells
- VLOOKUP with date as an argument
- VLOOKUP with date as an argument
- How to search a worksheet for text-value matches?
- Conditional formattig
- Date Entry error In Microsoft Excel 2000
- hyperlink - clicking on hyper link to select cell in another sheet
- How to maintain references when copying lookup formula
- serial updation in locked rows
- 2 Sum Problem
- excel - rows repeat on top
- lookup 2 columns
- HOW TO CONCATENATE TWO CELL(IF ENTERED A AND B DIPLAY AT A)
- can i link pivot tables
- Data Validation Conditional Formatting....or both?
- Time formulas
- vlookup returning Errors (ISNA formula)
- Tab variable
- VBA? Function? Not sure...
- SUMDIVISION formula function - does it exist?
- Formula to calc. semi-annual int. only pmt. with balloon in 10 yr
- 3 text lookup tables use to define contents of a cell
- How can I count specific words found across multiple spreadsheets.
- Is it possible to lock-in or freeze formatting?
- List Box - For Input Range can I use named range in another workbo
- Worksheet tab labels
- vlookup with a range result
- Changing text dates to date serial numbers
- Sum all Values in a changing Column
- Copying between Worksheets
- always visable header row
- Creating an Index
- how can i display a comment in another worksheet
- How do I invert an Excel table (collumns become rows)?
- business day date from a specific date based on a number of days
- Budget Worksheet
- Use FIND for / or \ or -
- Excel function, incrementing value
- Copy picture and paste hyperlink
- sorting numbers with decimal points
- Multiple conditions for one function
- Sort sheet based on particuilar sort order
- negative time input
- locking excel 2003 custom column width
- Can SUMIFS use the OR function?
- use formula to copy database to another
- List Creation from Static tab
- Adjusted for inflation wages?
- Dragging Cell References/Formulas
- Develop formula for cash flow
- subtracting time
- using a cell's reference to return a value.
- No range option in format control for combo box
- copy row high
- lookup value
- Calculate value at the end of nth year using CAGR
- date formula returns the 15th or the end of month
- Time difference calculation question
- creating cheque printing
- Send active workbook as attachment via hyperlink
- Link Cells from one spreadsheet to another
- Worksheet & Formula Help Please!!
- Excel spreadsheet comment boxes keep shrinking smaller than text.
- Stopping reference following when rows are inserted.
- how to convert number in figures to words in excel?
- Referencing a Cell
- External Reference Not Valid ?
- Date function
- How do I find age in years from anniversary date (Age funtion)?
- how do i set up a debit and credit formula on the worksheet
- Happy New Year to All
- some kind of IF or lookup???
- Getting a fill color on a certain date
- Formula for Negative Values - ?
- Repeat a formula with interval
- COUNTING BASED ON CONDITIONAL FORMAT?
- Formatting cell
- Slow validation
- Name error messages...
- How do I fill a formula on another sheet that repeat every 50 cell
- IF, AND, OR Formula Help
- Cell Validation
- Using names, and related information, in a Pivot Table?
- Vlookup and Conditional Formatting