- Another Date related question....
- Relative, absolute & mixed references in many cells
- SUMIF variation?
- add and subract in one sum
- Formula for calcing dates
- how to look up values with two independent variables
- VLOOKUP Query
- adjusting decimal place in protected worksheet in excel 2007
- adv filter
- Queation about monthly and weekly averages
- Please help me (urgent)
- Fixing some bugs
- A "ConcatenateIF" Function in Excel
- Extremely frusterated. 3 quick questions
- TROUBLE RENAMING A WORKSHEET IN EXCEL 2000
- how do I calculate minutes when given two times?
- How do I get rid of an extra page before printing on an excel sp.
- Can vlookup be used to search in more than one worksheet?
- sumif, countif, sumproduct?????
- A Tricky One......
- I love this forum! need help again!
- Help!!
- Problem understanding dependant lookups
- dynamic lookup
- How do I change color pattern based upon a formula within a cell?
- IF Statement
- I am getting a strange round off error in excel
- Relative references
- Inventory Spreadsheet
- DATE function clarification
- cell math to decrement/increment a cell
- VLOOKUP
- comparison
- validation from two columns
- Reset Worksheet Size
- Lookup table for two conditions
- excel cannot accepted the password and finily cannot open file
- How do you add figure with a word in?
- on excel file cannot acceted the password
- Combining spread sheets
- Error: The text string you entered is too long.
- Can anyone help please?
- Hyperlinks in pull downs . . .
- condtional format to
- If A1 has a #, that is displayed, if D1 has a # that is displayed
- Question about having the date autofill for schedule sheets
- Merging 3 workbooks when they are not exactly the same
- Formula bar doesn't have an equal sign
- Data downloaded with green triangle(indentation)
- Add to an IF statement
- Linking in the same workbook
- Using Error Message as test Criteria
- Extracting multiple entries in a cell into their component pieces
- Lookup Value in Range/Array and Return Column Header Value
- delete all values in column?
- find and paste formula
- Frequency of occurence
- Use concatenated text as name in formulas
- [sorting rows]
- data validation
- If Statement - With Formated text
- Using Replace command for replacing a character by an ALT+ENTER
- Finding unique entries among two columns of alphanumeric data
- vlookup or #N/A
- help with lookup please
- Counting unique records
- Re:Final days - London Excel Conference Registration giveaway
- Formula using INDEX and MATCH
- Data in Cells
- Calculate due date from a starting day
- custom validation
- count coloured cells
- Excel find/replace should allow values to be pasted in.
- countif criteria
- How to find avg for step size?
- Time (Hours) calculation
- help needed for Internal rate of return
- "Show all" button not work in protected worksheet
- Starting another program out of Excel VB??
- Average of lowest 5 of 20 values?
- web query help.. delay?
- finding duplicate rows
- How do I make a date appear in a cell only when I mouseover it?
- Adding category totals
- Contitional formatting help
- Find & Search Function
- "IF" functions for Excel?
- How to spread 15,000 into 12 months at 10% ?
- Display cell based on multiple cross-references
- Excel should let me set print gridlines as a default
- lookup error!
- time calculations
- Copy sum formula to Other columns not working
- How to change data in a cell, based on the date
- Function to sum a list of rows with different text except for one
- how to calculate the area under the curve in the excel?
- excel 2003 If function
- VLOOKUP using another table for comparison values
- complex average formula
- #N/A in mode worksheet function
- how to select cells with keyboard if the arrows don't let you go out of the formula
- Nesting Functions in a worksheet
- Help... in excel.
- How do I make the cell flash on and off ?
- Excel: want neg numbers to show red/pos green via if-then formula
- calculating adjacent columns in a work schedule
- Working spreadsheet highlighting function for Excel 2007
- how do I lock values in excel
- Sumif Across multiple worksheets
- Intersection of row and column based on input
- tagging unique items in a list
- RE: calculating adjacent columns in a work schedule
- Excel Formula or access ?
- RE: calculating adjacent columns in a work schedule
- using vlookup between two separate sheets
- Double lookup without using vlookup?
- Adding one month to noncontiguous cells
- Formula for computing day of the week and time
- Beetween Sheets
- Creating a formula using RAND
- convert column values
- How do I set up a formula to throw out the 2 lowest scores?
- I AM TRYING TO USE BETWEEN IN IF THEN ELSE
- Assistance with Formula
- Need help with averaging a time but dates are messing up the result I am trying for.
- Simple SUMIF, I think...
- HELP WITH A FORMULA
- if or problem
- DATE ISSUE!
- indirect function within sumif to reference other sheets
- Inserting variables within file names
- Is there any File Auto Save Function for Excel and Word 2007 (Bet
- How i can create a formula that combine subtotals and sumif
- Need formula help!
- If this and this, then do a) b) or c)
- Filter formula
- Need to make a mark up table with more than 7 if statements
- Variable Cell Referencing
- remove #DIV/0!
- use the OR function inside an IF function
- Need step by step instructions to try, not a demo. Can't remember
- Need step by step instructions to try, not a demo. Can't remember
- vlookup on non-contiguous ranges
- Use of IF function
- how to hide worksheet using VB
- Extend series
- count criteria excell
- spreadsheets and auto General Journals postings
- vlookup help!!
- Difficult IF Function (For me at least) help
- Keeping the hyperlink address hidden in a cell.
- lookup latest entered match
- Copying information from 1 WB to another and loosing style
- matching values
- excel, can put name in one cell and get ther# in the next cell?
- how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
- How do I avoid duplicating names in excel?
- IF function with date
- Deleting blank worksheets
- Migrating information into another sheet.
- Need help with an embedded IF statement
- Insert Picture
- paste only subtotals, not individual date that makes up subtotal
- What is the formula used to calculate the 1st and 3rd quartile?
- EXCEL - PASTE SPECIAL COULD HAVE AN OPERATION TO REVERSE ORDER
- Protect my formulas!
- locked cells with 2 different passwords?
- Import Cell Data
- I need help with the IF function
- VLOOKUP in 4 work sheets
- Networkdays formula
- MATCH and OFFSET
- Yet another issue
- How do i find the counts of data with a condition of other cells
- is it possable to run an macro or script at start up as you could
- Double if statement
- IMPORTANT! HELP PLEASE! Formula
- variance %
- How can I make the box remain empty instead of N/A#
- How do I make the column & row heading bold Type
- formula question?
- Questions should be simple please help
- How do I break down a number by multiples in Excel?
- Help with cell formatting
- function help needed
- merge workbooks
- Formula Please help
- Remove dash(s)
- Sending automatic e-mails by date from Exel
- create 2nd list dependent on 1st list
- Using formulas to source a value based on 2 variables
- lbs ounces drams
- How do I color code the "SHEET1" Tab in Excel?
- "Too many different cell formats" error in Excel
- div/0 and #num!
- using a calculation in a list on another worksheet
- Paste Links not updating automatically.
- Complicated formula please help asap!
- changing dates.
- Using countif with a name of a range
- Please help - formula works in some cells but evaluates to #value in others
- Convert cubic centimeters to fluid ounces and cubic centimeters
- Matching Picture to Reference
- Worksheet numbering
- Filter isn't working with a VBA Code
- lookup field and copy the row across
- IF Function
- Check Box Macro to hide and unhide a column
- How to replace a cell if value is alphabetic
- Please Help With Days Elapsed And Days Remaining Calculation
- How do I select a value from a table based on 2 conditional refs?
- vary the vlookup array depending on the value in a cell
- How to insert rows in transposed data table?
- dynamic print area based on cell value
- Can a function do this?
- Help Please, Worksheet Change
- What are the reasons if the "the solver" will not install?
- Excel worksheet functions question.
- how do you nest ROUNDDOWN in an IF formula?
- Comparison Function
- I was creating a histogram; now i have data but no histogram.
- How do I compare lists in cells Excel
- Help with IF function
- Vlookup for multiple criteria
- insert picture excel 2007 from scanner or camera
- All Capitals
- Search for first instance of text & return the value
- Formula Help please
- Averaging seconds
- Formula to show zero if reference cell is zero? tricky!
- How do I get the grouping dialogue box to appear in Pivot Tables?
- functions to count Yes & No
- How To Lock Cells and Columns without Protecting Worksheet
- how do I automatically hide or suppress zero balance rows
- Help with an Excel formula please. - it is beyond me!!
- Create 5 unique value between 1 and 14?
- Pivot table and Dsum security
- How can I CUT and paste to convert columns to rows?
- =Now()
- Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?
- In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
- How to convert cell contents
- maximum repeated value
- Dame: identifying duplicate numbers within a column
- unhide rows when cell is clicked
- unlock a spreadsheet without password
- converting month name to number
- MEGA FORMULA
- User defined functions without using VBA.
- User defined functions without using VBA.
- how can i ignore an error in a formula
- Compound Lookup, Large/Small, Match...
- Still a problem with DSUM function
- Help with SUBTOTAL formula
- Dare Format
- Convert a julian gregorian date code into a regular date
- Externalizing formulas.
- Please help!
- excel function
- how do I perform a lookup on an 80,000 line array?
- Hlookup search in more than one sheet of excell?
- Multiple hyperlinks from drop down box
- Total Minutes
- turn off convert text to date (i.e. 4-9 to April 9, 2006)
- Copy Worksheets
- Conditional COUNTIF Function
- IF Statement, including AND
- How do I Change the value in a count function from 1 to .25
- Xcel Formula # rows With value X in colF AND Value A or B in colJ
- Web toolbar in Excel 2007 beta
- Moving cell data and separating or deleting
- need value from referenced cell
- I need to count data in one colum based on data in another column
- Moving left of a cell reference
- Re: Moving left of a cell reference
- query in excel
- Find and replace Comments
- London Excel Conference Registration giveaway
- RE-submitting of: constructing (complex) variables with worksheet functions
- MSQuery
- Hyperlinks
- do loops
- Max and lookups
- how do i save a large amount of data in a worksheet excel 4
- find value one row in advance of specified value
- if again
- if specific value from list A equals one of the values from list b...
- RANK, duplicate ranking but no gaps in rank
- Selection of Drop down list that allows you to go to a particular cell
- Running Sum across columns but only to a certain point
- How to parse a string with a date?
- making cells change relative to each other? cant figure it out
- making cells change relative to each other?
- Need a pareto of a text table
- Excel Workbook
- IF Function with equation and text
- Passing a WorkSheet from a Function???
- copy cell from one sheet to another
- place a number in a cell
- look up a value in one column to another colum
- Calculating Compounded Growth Rates
- formula error
- Displaying result in parentheses
- help. Excel shows formulas, not answers
- How do I rename an Excel worksheet when the feature is grayed out.
- Complex logical/conditional formula
- Adding A Not(IsBlank) To IF Statement(help)
- using VB to read in a column of values of varying length into an array
- searching all workbook sheets
- Compare and copy unique values
- finding a name in a string
- changing datas when adding row ?
- Datedif using cell references Excel 2000
- Rows into Columms
- How do I covert rows to columms?
- How are empty cells referenced in Excel in IF statements?
- How to smart count a table with words in it!
- EXCEL HELP
- Trying to replace "false" in IF statement...
- Apply Absolute Reference to multiplie cells
- Shrink to fit Macro Button
- Type in Part number which pulls info from another wksheet
- comparing ranges/arrays
- How do I change the IRR formula for MONTHLY periodic payments?
- How can I connect a word of text to a certain dollar value?
- <HELP> modified reference
- production cost
- How many characters in a box..?
- Using vlookup - how can I obtain a sum of values, not just first v
- Can anyone help?
- Stock data manipulation
- Compare Two Lists
- Date Function formula that will return the date of a specific week
- Automatically number lines
- Excel 2007 worksheet headers do not print
- lookups and match
- Customise the summation function / button
- Personally Identifying information in Excel Sheet
- Excel Data Sort in Excel2000
- Determine Future Value to Meet Average
- Factorial (like =FACT) function?
- Excel
- How do I open several worksheets from the same workbook on screen
- Arranging Names in a cell
- Speed fill function for MS Ecel 2007 (Beta)
- Prom with the DSUM function
- Formula to count cells between dates.
- Vlookup returns line number
- If Function with OR
- Counting cells using multiple criteria
- Date minus 3 months
- how to add a charater in front of part number
- Spreadsheet Alarms
- Formula
- How to get a cell with a zero errorto show the cell as blank
- alphabetcal order
- take numbers from one cell and add to another
- serial number decode
- percentages
- How to change a tab name with cell reference and formula?
- how can avoid considering of blank cells in IF function
- Is it possible to search tabs in excel?
- get back a document replaced by another
- Change the work sheet name in a formula by using cell reference
- HLookup and how it works
- Macro hangs up often but sometimes works fine
- nested if function
- Title in one cell covering space of 3 cells underneath
- vba linking Excel and Word
- Last week for regular registration - London Excel User Conference - July 19-21
- Sum & two column conditions
- How to Add Restrictions to ComboBox...???
- Countif Problem
- Separate two words in cell
- change date format
- IF formula
- creating a quote looking up from tables
- Page set up for a workbook, so each sheet gets the same format ?
- CreateObject("Excel.Application")
- Internet Query?
- Ignoring Blank Cells
- counting responses - please help
- load one vendors prices to a master workbook
- Compare and Merge Workbooks
- formula typed contains an error
- Parse from the Right
- Select from drop down list via typing text?
- Excel problem trying to format columns of data
- =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2
- Age from birthdate
- Combo Box
- create list is missing from data menu
- 5 days week date (mon to fri)
- Calculate relative frequency?
- Template & Database Question
- I need to know what kinda Function to Use in A Worksheet
- What Formula To Use
- What Fourmula Would I use and How
- Newbie question Different decimal place values for columns
- vlookups error message
- Date issue
- Errors in "vlookups" formula
- what is the formula from british pounds to American dollars
- Basic Question on Subs
- cell reference changes and conditional formatting
- using logical functions
- HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
- HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
- Need column evaluated to count total of occurrences of "Y". How?
- Pivot Table
- Formula
- Pivot Table
- I want columns of worksheet to become rows and vice-versa.
- a exact string search inquiry
- How do I add the same dollar amount to all cells in excel?
- Average non zero values
- DCOUNT / COUNT IF???
- numbers in Excel
- IF with OR and AND - the Sequal
- finding value from table
- Does anyone have a solution for nesting an OFFSET in an HLOOKUP?
- IF with OR and AND
- Help with 2 sheets with data to work together
- Last Non Blank
- Circling cells based on a value
- Pivot table: sum of durations
- Would like help with displaying data if are a certain value is pre
- Confused on a function
- Zero starts of a number
- IF Function
- Find category value based on date range?
- looking for another same value cell in a range and returning a coresponding value
- New to Excel functions and need some help
- In Excel I want to copy text from spreadsheet to spreadsheet
- I need a date stamp that doesn't change when you enter text
- Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function
- Allow user to "switch" contents of two boxes in Excel
- calculation errors
- Formula Help
- Macro for column sum
- Worksheet not showing up in VBE
- Counting only Unique cells
- Help :-( - Auto Population
- Formatting smallest number in a range?
- hOW CAN i CHANGE HEADER ON ALL PAGES IN EXCEL?
- Using the =NOW() Function
- Desperately need help with 3 calculations
- can i execute a calculation in a cell at a certain time of the day
- Hyperlink trouble
- How to update an external excel sheet
- Hyperlink trouble
- Countifs and multiple columns...
- How to print a selected number of sheets?
- Printing selected sheets.
- PERCENTAGES
- Histogram Average
- Hyperlink trouble
- Name
- Final days for regular registration - London Excel User Conference - July 19-21
- Counting each time text appears in range???
- How to calculate odds in excel (for instance matching pairofdice)
- Cash Book
- closest match
- VLookup function to right!
- sequential invoice numbering
- Count number of pages
- How to change a link to another worksheet by changing a value in a cell?
- paste to next blank cell/row
- Cpk value calculation in excel
- Compare product prices from two supliers and produce report
- Macro Help
- if and function
- Can formats follow formulas?
- How do I lookup multilple criteria and return a single value
- how do I sum all of the $ payments made between two dates
- Running total array?
- What's wrong with this formula?
- when i enter time in cell it changed, why?
- How to validate
- formula references change when data entry sheet is modified
- Find most recent date
- Email addresses in Excel need to format for mass email
- Function for days between dates and an if statement (HELP)
- VLookup Multiple Data Rows
- Rank(A1,C1:C5) - Rank using 2 ranges
- Can't see all the text in a cell when using file links
- % or Nr
- count # of instances in cell (a b a) answer 2 formula if possible
- changing money
- Column Headings in Lists
- SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
- How do I keep column headings from showing on a list?
- Format number using CONCATONATE
- Automatic Population?
- Page TOtal
- Hyperlink trouble
- How to import data based on a variable
- Count Number of Different Cells
- Page TOtal
- why cond sum wizard returns diff result as when formula typed out
- IF,And,OR Help
- Function Question
- Macro for copying conditional data
- f statistic, p value definition
- Automatic Product Functions
- Formula Needed to Compare Dates and return a running total
- how do i sum A1*B1 through to A12*B12 in one easy forumla?
- I'm trying to link two excel spreadsheets so they update automati
- Database Functions - Strange results
- How can i convert an ASCII character to decimal/hex in Excel?
- calculate the sum of hours exceeding 23:56
- World cup spreadsheet help
- reference in another workbook related to the name of material
- Transpose Question
- Formula too long - text
- Trouble writing an excel formula.
- Protecting columns?
- How do I retrieve the text string from the right of a cell
- PivotTable:Using a calculated field result in another calculated f
- Validation Links
- AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS
- if and then formula
- Paste Special - Values
- End (bottom) of worksheet
- insert picture from file based on cel value/content
- average function
- Comments Printing Problem
- what is the "random" function in Excel in spanish?
- Returning column header as result
- Two links changed on my site
- Lookup function for a value that has multiple instances
- Using DCOUNTA to count only Unique values
- Retrieve specific date from one row of one column that is changing
- How to sum cells but not show zero if cells are blank?
- Extracting the most frequently occuring text from a range
- 2 levels of worksheet protection?
- How do I alpha short worksheets in a workbook:
- Macro Question
- Help in data comparison
- 3-D reference
- How can I lable a colomn group in Excel?
- Data Importing?
- macro to copy multiple rows to separate worksheets
- how i change thai text to english text
- Save sheets in a folder
- dumb question
- Converting letters to numbers
- Baseball sumproduct/array formula?
- Add a new row under a changing list
- Inserting automatic text in Excel
- How can I check the "P" or "A" in the attendance sheet
- Percentage
- Percentages between two cells
- Manipulating Data Problem
- Drag a Named Formula
- How to mark down the time when entering input to a cell?
- Comparing columns from 2 different worksheets.
- Averaging a column with 0's
- How to define the 1st, 2nd and 3rd element
- Formula-Cell has a letter (C=100, M=1,000) and needs to divide?
- Conditional Formula help required
- mileage
- Formula not recalculating
- lookup and move rows to other workbook
- visual basic (copy and paste)
- Auto Filter by Criteria
- Modify database
- Matching Adjacent Columns?
- Excel 2000 filter problems
- A function to indicate whether a cell contains formula or value?
- Converting a formula to its value
- Insert currency numbers from spreadsheet such as 48 = $48.00
- Text Compare Function
- Running macros on ALL Excel tabs
- Moving automatically from one cell to another
- Sumprpoduct Help
- I want to add a plus sign behind a number and keep the leading zer
- limit text length after importing data
- How do I change the default spreadsheet size in Excel?
- Determine if a value in a range is close to the value of another c
- RE: Determine if a value in a range is close to the value of another c
- NOW Function For Time Changes With Each New Macro
- Pivot Table - Deleting data rows while maintaining them in the tot
- PULL Function
- One column with various widths
- Conditional FIND and REPLACE
- retreiving cell address of vlookup value
- Macro Question
- Replacing a number value with text from array
- Can't add 7th IF statement to long formula.
- reset certain cells to a default value
- Help with INDIRECT
- How to get the right-most word from TEXT
- create & name multiple worksheets
- xirr - hi! i need some urgent help
- what formula in Excel will identify the first zero in a row and...
- Dissecting the contents of a cell
- Maintain Formula Reference (sort of)
- Req for help using INDIRECT or alt solution
- Number format in cells
- Pivot Table Question
- Time sheet calculations
- Concatenate in a string
- Counting data between 2 values
- Convert Text to Columns with Excel 2007 beta does not work well
- Conditional Format Issue
- Drawing on a chart
- How to create a calendar view from data in Excel?
- Help Need Formula for Calculator
- 3 data validations
- How do I copy columns between worksheets if the columns don't matc
- Conditional Formatting to Compare to Lists
- Searching for string in other cells
- If AND Statement
- Excel formula - help needed!
- How do I get an IS and IF statement to work together in excel?
- working with time in minus
- deleting sheets in Excel 2007 ( Beta 2 )
- deleting sheets in Excel 2007 ( Beta 2 )
- Selecting particular rows containing interesting data
- I have 2 lists of email addresses and I want them to match up
- Deleting blank rows
- How to specify cell ranges dynamically?
- Averaging Only the X Highest Numbers in a Row
- Vlookup
- Sunday Function
- help with coding in excel
- input box within macro
- reverse cut and paste
- how to add values of cells only if a corresponding cell has information on it
- hyperlink in menubar
- a function that counts the number of cells with information
- Linking cells by name only to another worksheet....
- HOW DO YOU SPECIFY A RANGE TO SORT?
- copy rows to another worksheet
- Modify Excel Formula
- greyed out compare and merge document
- vlookup problem
- Why does a column add incorrectly when usng autosum?
- How can I link a cell in Excell and keep the same formatting?
- HOW CAN I FIXED FORMULA THAT DISPLAYS #NA
- How do I set up a formula to add column a if column b = cell c1?
- Hyperlink in an IF statement
- GETPIVOTDATA
- Hyperlink in an IF statement.
- EXCEL WILL NOT LET ME INSERT COLUMNS
- Auto-Fill From Table
- Template update database, auto move down 1 row
- sum of multiple IF statements
- v-lookup problems
- Conditional Formatting if cell content is a formula
- count
- Moving Information
- countif problem
- Vlookup doesn't work in new workbook
- Need to get a count on an hourly basis
- Formulas go away
- Evaluting 2 cells, adding one to largest for another cell.
- isna & if functions
- blanks in data validation list dropdown
- How to create hyperlink from 2 cells, then open Word
- How do I merge data in the same workbook?
- formula
- Count if Lower case
- Sumproduct
- return one value from list
- Comments don't stay the size I choose.
- sumif 2 text conditions
- Calc cost pro rata (nested IF's and macro to find empty row)
- I want to jump to a worksheet from a contents sheet
- Sorting Outlines
- Credit Card Number
- Credit Card Number
- IF & AND statements
- linking one column or varying range to another column using same f
- retrieve last entry in column
- Removing "Spaces" Entire Workbook
- Totaling from seperate worksheets
- Copy formula with skipping rows
- functions on imported database
- protect sheets against cutting / pasting
- Finding/counting a given character within a cell
- add a rule line to excel
- Data validation with hyperlinks
- Pick a Random name from a list.
- How to click on a cell and have the content of the cell display in a different cell
- if this equals that
- Offset, VHookup - Confused
- Matrix Question
- Adjusting Formula
- Count Formula
- Excel pivot table
- Worksheet names 2
- Excel hyperlinks open Netscape not IE
- Nesting IF function
- how do i get the mid function to work with a zero
- function help
- worksheet names
- vlookup across more than one sheet
- Problem with nested if function. PLS HELP
- Linked Cells Staying With Cells Once Linked Workbook Update.
- How to use IPMT and PPMT to compute Interest and Investment paymen
- How do I grab the date from a text string?
- IF vlookup return "value"
- Color
- How do I delete all but one page on a worksheet?
- looking for simplified formulas
- A formula maxif, similar with sumif or countif
- Compare row contents w/Sumproduct or Array formula?
- Sum Function Needed
- If Function - Date Problem
- sum cells in table using column and row conditions
- Delete rows if specific criteria not met.
- Inserting blanks or changing dimensions
- formula help
- two formulas in one cell
- how to make a formula ignore blank cells
- Linking cells with text to each other
- On protected Excel sheet users be able to group/ungroup rows/colum
- Calculate polynomial curve
- From B0101 to 101
- SUM Product
- I get some negative numbers when I use the RAND() function--Why?
- formulas and drop down lists
- SUMIF(AND()
- Counting cells based on formatting
- "&" in Excel footnote as text
- Retrieving a specific cell from multiple worksheets
- Is the equation: =COUNTIF B:B, <9/31/2005 AND >9/1/2005 possible?
- New Excel function SUMABOVE
- VLOOKUP specific data for month required via dropdown list
- Counting Months
- I'm looking for a formula to calc # of days left in a month
- What if Formulas
- VLOOKUP specific monthly accounting data by selecting drop down li
- How to generate sets of random numbers without having duplicates
- Set an array on based on duration of months
- Conditional Formatting With Grades
- Importing from Password Protected Sheet
- comparing text cells
- Split numbers in cell
- If then statements
- I want to use sumif( > a cell reference) and not a value. How?
- carrying over a column formula from one sheet to another copied sh
- Using WORKDAY function
- offsetting values of multiple cells!
- Look up Help!
- Moving information to a different page
- using option button to highlight cells
- @vlookup returns the formula instead of the value - why?
- converting concatenated text strings into formulas
- Cell Propogation
- Solving for discount rate in present value calculation
- IF and AND statements
- How to move a formula from one sheet to another
- Trying to total payments for months, need help with my function
- click/unclick a box and make other info. appear?
- multiple conditions sum
- Counting instances based on two criterias
- Locking portions of a formula
- formula help
- Color Fill for a cell does not appear on Excel screen
- Can you round up numbers to the nearest multiple of ten?
- How can I project the values of intersection of curves in chart on
- I would like to Count values in two columns.
- Circular Reference
- sorting two columns at the same time
- Pivot tables
- macro sheet position
- Defining a range using a cell reference
- A validated List which link to selected cells according to what is selected on the list
- The Autofilter misses some numbers
- Macro wont update after file "read only"
- conditional formatting
- Hiding/Unhiding Columns
- date formula
- what are the new features of excel 2003?
- How do I use ISERROR in functions to hide error values
- Link cell between WS w/o dest display 0-jan if no entry at source
- Formulas IF()
- how to insert an email hyperlink in an excel header
- hiding column using VB
- Translation Exercise ...
- excel sales invoice template
- Excel function help Please
- shortcut ALT +0252 doesn't bring up the check mark symbol?
- How to copy personal.XLS macros to a Cd for use on all XP compuers
- How can I nest ISTEXT and IF functions?
- autoupadting a counta
- Expiring
- sum with text in cell
- E-mail a worksheet
- FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT
- Count with 2 conditions, second one OR
- Sort does not preserve string of additions
- Auto dates
- SUMIF with only Month
- Adding time
- repair outlook inbox
- What is DBRW as used in Excel cell formula ie =DBRW(
- check for duplicate names in spreadsheet
- insert a new row in VB
- Combining two formulas
- Using SUMIF function with multiple criteria for Aging
- reference to a cell which then changes its place?!
- Combining an IF and MAX function
- SUMIFS() error?
- table to xyz list
- Formula for amount owing subtract amount paid
- How does one sort a block of inter-related information in Excel?
- Countif Using Multiple Logic Tests
- Looking for excel spreadsheet for account receivable cust. histor
- two formulas per one cell
- How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
- Delete specific text in spreadsheet
- ColorIndex
- Is this possible?
- How do I specify a tab order in a sheet
- Formula help
- retrieve filenames from given directory into excel
- unable to delete page break on Excel spreadsheet
- VLOOKUP, correct funtion?
- ranking a colum of numbers
- Help! Current Date in a column
- Is there a easy way to delete blank lines to clean up worksheets?
- 1st,2nd OR3rd EQUALS $10,$15 OR $25
- How do I set up a column
- help needed
- Sum with array problem using SRC/BusinessObjects software
- adv filter wont accept criteria
- Please help...
- alternative to VLOOKUP
- Using an IF function for a total
- rank problem
- Delete (') from Excel cells
- How to count last number
- Creating a Search Field?
- Have payroll sheet and having trouble subtracting 1AM from 5PM
- how can i set a static date and time in excel
- Unprotecting worksheets
- Summing columns in Excel?
- Getting column value based on month
- two worksheet reference formula help
- taking two worksheets together
- ? sort data in a drop down box w/ initial cell entry
- sorting a range with conditional formatting
- formula/function that prints only positve numbers
- SumProduct + cells
- reference current worksheet name (tab name) in a formula
- 2 days of frustration....Please help
- Excel worksheet slows computer
- Bless you, Debra Dalgleish & Pejo Sjoblom!
- Help with Sum if (or something else not sure)
- drop down list of a drop down list
- Disabling click and right-click on the Picture I inserted in an Excel document
- In Excel - can I create a formula based on a filter?
- Formula help
- validation - anyway to select multiple choices in the pull down?
- which function to use
- $ or !
- How do I fix my formulas in Excel?
- How do I make letters not show up in a alpha-numeric string?
- Link worsheets in Excel
- Running total formula
- Is there a way to find a value in a set of cells?
- Lookup multiple workbooks
- Excel Lookup
- creating excel macros
- if function
- Copying a link
- UDF to sort array with multiple columns
- averaging times
- splitting cells
- Extract Specific Text
- Track progress to lookup percent complete on another worksheet.
- Costom format -> 0.0061 to 6.1
- bank cal for interest on cd
- Hidden Function?
- Unprotect use 2 passwords possible??
- Spell Numbers
- My formula cell has stopped adding the preceding cells.
- Formulas
- Copying Formulas
- July - UK Excel User Conference
- Can I use the Goal Seek function on multiple cells simultanously?
- SET SATURDAY AS WORKING DAY IN EXCEL
- Forms in Excel 2007
- Search for dublicates
- How to make a cell trigger a Sound in Excel
- Setting up tasks by a conditional roster
- How do I format a cell to blink or Flash?
- Identifying adjacent cells
- Show's #N/A please to showblank.
- Auto complet is checked
- Need help with Countif function
- formula cell value multiply by percentage
- HELP NEEDED FOR IF Function Inside a Macro
- find text in a string formula
- Summarizing field quantities for specific records
- Excel Formula
- SUBSTITUTE
- *Tough Math Question*
- why wont my formulas copy all the way down my excel spreadsheet???
- Vlookup Please Help
- VALIDATION IN EXCEL
- Two Criteria with the COUNTIF function or somthing else?
- SHARING EXCEL WORKBOOK
- WHAT FUNCTION 2 ENTER SO THE CELL TURNS RED AFTER CURRENT DATE
- scan a document and pull into excel spreadsheet to edit
- Re: Weighted moving average
- conditional formatting 2 cells
- help with formula
- Remove Punctuation?
- WildCard Characters
- Extract just numeric part of mixed text/number entry?
- Counting ranges, please help
- HERE'S A REAL BRAIN TWISTER:
- How do I use section breaks in excel?
- Transpose Mailing List to Columns
- Display Unique Values Question
- Interest calculation
- DELETE ROWS BY USING A IF/THEN QUERY
- HELP - Excel 2003 formulas don't work-as if cell values aren't num
- How do I get excel to generate Random nos for my data?
- i need a number total derived from words
- matching formula
- EMERGENCY!! PLEASE HELP!!
- Is there a way to limit the content of a cell to 5 choices?
- How do I use a logical IF statement with TEXT in EXCEL
- Summing a function
- If And
- Weighted moving average
- #value!
- Two criteria for CountIf?
- Not able to Paste into other cells
- Updating links
- Enhancement Request: Give us ability to lock/freeze tabs in Excel
- Sum a range but exclude and negative values
- Sum a range of absolute values
- Compare lists for additions and subtractions
- In MS Excel 03, how do I determine an end date (with weekends)?
- problem
- wild card with if logical function
- wild card with if logical function
- Help with SUMIF function
- SUMIF function help
- If Function
- Comparing two different Worksheets
- compare cells of different external documents
- vlookup and hlookup simultaneously
- Urgent SUMIF problem
- I can't type in a column in excel it's frozen
- Can XLS automatically insert file properties fields into a header
- convert cell content to filename
- Real Time Charting
- Excel formulas on different Powerpoint Slides
- Need excel formula help
- Calculate current date from fixed time?
- search for and return more than one row in a sheet
- Check In
- How to convert Euro's to Canadian dollars?
- time sum incorrect
- Help With A Tricky SUMPRODUCT Function
- If statement using multi columns
- numbers automatically format
- fromatting formulae with text & dates
- How do I repeat an item in multiple formulas w/out retyping each
- Lock a cell from others to edit?
- Columns To Rows
- Program "Enter" Key
- Copying and Pasting a cell with a constant number
- Index / Match Help
- Upcoming Date alerts
- #REF using =INDIRECT...
- Help with getting data from a worksheet
- Another SUMIF question
- need help with drop box please!!
- Inconsistent results with =LOOKUP?
- MODIFICATION IS NOT ALLOWED
- PivotTable Question
- string/char CONTAINS function?
- Sum If ???
- SUMIF function help
- Drop down menus
- lookup function .... I think???
- Default Page Settings
- Adding a Function to a cell when inserting a row from a macro
- Adding and Deleting rows - update formulas help needed.
- Summing
- RE: Need conditional statement to paint a cell
- Copy Formula Problem
- how do i format cells with preceeding zeros & minus sign
- refreshing linked workbooks
- HIGHLIGHTING
- "Last Saved" date in Excel 2000
- Global Custom Formats
- If Calculation
- Adding only the filtered results
- Max value within a set of rows
- SUMPRODUCT problem