- reformulation question
- Place a set value in a cell from a drop down list name reference
- increment cell value automatically
- Date & Time function
- binomial distribution
- How can I group a bunch of cells together, so I can sort by colum.
- Time Calcs
- Is there a way to use the space bar to delete?
- Data manipulation help required !
- vlookup returns n/a
- Distinct Value With Countif
- Another date function question
- Using Average function when number is zero
- IF function displays wrong amount
- Keeping Array values?
- vlookup function in excel referencing an access table
- Why do formulas turn to values wen copying in Excel 2003...
- Nesting A Function
- countif
- Comparing Date Fields
- countif
- Formula not updating
- Worksheet names
- Autofill Questio
- Goal Seek - reference a cell for "To value" field?
- Help With The Upper Function
- Data Validation List Option Affecting Other Cells?
- offset and vlookup
- Modify Row & Cell based on Multiple Data
- How do I insert a line break when using the CONCATENATE function?
- Do I need nested IF statements?
- Need to add the same cell from several workbooks
- Auto color change to tabs in worksheet
- How do I get the COUNTIF criteria to recognize only month and yea.
- Using a worksheet name in a formula
- UPPER Function
- links not linking
- links not linking
- generating Unique ID numbers for students
- Excel 2000 - Advanced IF AND ELSE COUNTIF??
- import data protection
- Timesheet calculation
- Countif
- removing green triangle in cell
- Data Validation List Option Affecting Other Cells?
- Multi pick into database
- How do i change the numbering shceme of my rows?
- Syntax For Conditional Formula
- auto update
- to express degrees & power of a number in excel
- How to return min, mean, max using criteria?
- find LAST match in column
- HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS.
- Lookup Functions
- How do I get a pivot table to sum instead of giving me a count?
- Naming Sheets Tabs
- Difference between two dates in months with decimals
- Another date function question
- Tabs on Excel 2000
- auto update
- Vector lookup function
- projecting growth
- Macro did not run after download file from net
- Difference between two dates in months with decimals
- Excel: How to return count for each cell within date range criter.
- Count If Formula
- How to sum-up alternate rows ?
- How to add up a number of colums (posted on 29/10/04)
- Value Increase/Decrease/No Change
- auto update
- Using Indirect & Creating a worksheet Macro
- Help with function
- sumif calculate
- IF/ LOOKUP FUNCTION - Excel 2000
- Countif/Sumif function question
- count function
- vba to sort group copy paste to another sheet
- Pivot table : Excel cannot complete this task with available resou
- Formula to Extract Data from a Table
- Creating Links
- Calculated fields-Pivot tables
- Excel should allow "select all" and also "insert bookmark" as Wor.
- average by operand
- Returning the Week Number of a Specific Date on a Month
- I have an "IF"Statement problem...please help!!
- How to return min, mean, max using criteria?
- blank cells that include text
- how to remove label formatting (eg label to number)
- Price rounding - exception formula required
- find LAST match in column
- Modify Row based upon cell value
- Extract Pixel Values to Excel?
- Apply formuls to whole row (multiply ColumnC*.00274)?
- Sending Text Messages with Excel???
- How do I modify a row depending upon what a cell value is?
- last data entry in column
- Summing values of corresponding columns
- 30 Day Aging Report Using Conditional Formating
- Unknown Character removal
- Summing values of corresponding columns
- Excel, problem with hiding formulas.... please help!
- Select or Filter by Fill Color
- ?odd results for =left(F#,2)
- how do i create drop down menu in excel
- How to do consecutive numbers in separate docs
- IF-SEARCH
- cell reference show cell name (ie. D45) and not cell value
- Importing Data Into Formula Based Cells
- make list of information from different cells
- Text to Speech toolbar problems
- Getting Speech to work
- formula help
- import problem on huge xls file
- Calculate the number of workdays between 2 dates
- If function
- formula
- help
- Can I use a cell reference in the criteria for the sumif function.
- How do I find the first value in a column less than a number?
- Decimal places in Excel 2003
- How to use Vlookup
- Chart question insert
- Adding column data
- An instant sorting problem
- Calculate the number of workdays between 2 dates
- HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE
- Lookup a date between other dates
- "Is Between" Function Solution --- Many Thanks
- Number Format Issues-Decimal Places
- single quote 10-digit number that has leading zeroes & then conca.
- Vector lookup function
- Needing to know how to use a "and" in a formula....
- Can Excel be pre-formatted to apply "double quotes" to data enter.
- Excel Time Duration Formula
- "Is Between" function?
- GetPivotData
- Alphabetizing
- can i colour a cell on basis of results of a formula e.g clour bl.
- The Auto Filter button lost the column specified option.
- Importing Data Into Formula Based Cells
- Using Workday syntax
- Average/Min column of numbers, but skip 0's and Null's in the form
- Find AVG/MIN of a Column, excluding 0's and NULL's?
- Why does Excel freeze and have to close when I hold Alt down and .
- Average Column, but Skip Null and 0?
- Linking an entire worksheet from a restricted drive?
- Linking an entire worksheet from a restricted drive?
- Re: Vlookups and multiple returns (again!)
- unique records
- Not quite the same lookup?
- How do I delete duplicate entries?
- GradeBook
- Adding column data
- What function or formula do I use to calculate ROI with this data?
- how to count the nr of occurrences of a text string in a cell rang
- Look up or Index?
- convert numeric to text
- Countif Problem
- forming a new column by using the other column
- Excel Function
- Comment associated with a cell
- consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc
- Count Comments
- Hlookups + Vlookups
- can I merge two different workbooks, with the same format, just d.
- TRANSPOSE()
- Summing Formula
- Conditional Formatting for dates
- < and > functions aren"t working for me
- Create a total based on multiple conditions is not giving correct.
- remote data query and sum not working
- Combining Defined Names to New Name For Validation
- lookup problems
- How do I limit the number of rows in an Excel worksheet.
- How do I build a feature into a cell that would send an email rem.
- Navigating between worksheets.
- What is the easiest way to learn math functions in excel .
- Need to learn about formulas
- Using Cell references in VLookUp
- Help-IF Function
- Parsing text in Excel
- Copying Rows when hiding other rows
- countif
- Need help on Select Case
- unrecognized fuctions evapp etc
- Excel 2003 isn't updating my cells
- Comparing Data in two columns
- Sorting merged cellsHow do I sort merged cells not identically siz
- getpivotdata() by position
- no repeats in a column
- How can i get my whole workbook highlighted in the page break pre.
- format numbers into feet / inches
- What's wrong with this?
- Pivot table, how do you exclude counting cells with formulas as a
- Count distinct
- how do I 'count' the number of cells with a text in red or black?
- Sorting problem
- Calculating Average Values Using Arithmetic Equations
- need a formula for cumulative grade
- 2-Dim Lookup
- Double-Click a Hyperlink
- Calculating Average Values Using Arithmetic Equations
- Date Alert
- Adding text before a function
- If's and Isna's and stuff
- How do I reference multiple rows
- macro to not print blank value rows in invoice
- Freezing panes
- If Formula
- Is there a way to use the space bar to delete?
- Is it possible to send a worksheet without the unhidden data?
- Display excel formula on worksheet
- Convert text to dates
- Help! - with a formula please
- Countif, Sumif, If - help!
- Activating the Send As Attachment option
- How do you delete one cell from a range of protected cells
- Extract date from cell
- Deleting/IDing Rows that Don't Meet Criteria
- Duplicate fields does not match up! If statement
- If statement needed
- Edit Hyperlinks Globally
- sort option is greyed out in excel
- How do I set up a worksheet to let me know when a birthday is comi
- Do any newer versions of Excel (2003 or XP) offer more than 65,53.
- How can I format a cell to accept feet and inches and add them
- Seriessum is not quite it...need help, please
- #N/A In Max min Average Formula
- Adding TR to the end of each value in a column..formula
- Count data entries and date problem
- conditional format for text
- do we have semilog paper
- vlookup.
- Lookup with logic
- Maps.........Having Trouble Loading things
- RANDBETWEEN query
- data validation on sth else
- How to Concatenate Time with some operator?
- #div/0! problem - please help
- Drop Down List not Appearing
- variable range countif
- How to Set a fix # of days per month
- Returning the Week Number of a Specific Date on a Month
- Extracting data
- Import file names into cells
- Deleting/IDing Rows that Don't Meet Criteria
- Need to learn about formulas
- How do I set up a min and max function in the same caluclation?
- Another Lookup function, please
- Returning the Week Number of a Specific Date on a Month
- Lookup Function
- Using Countif
- How Do I (Macro Function)?
- real estate formulas
- If and (and) formula to allow a zero answer
- Workaround for UPPER(F31:F10000)
- Use of Exact(or other) function for alternate rows?
- Identifying exact values in alternate rows
- Formulas
- Function Macro for Nested IF
- Copy/paste Subtotals
- How I use SUMIF & AND
- How I use SUMIF & AND
- Referring to Pivot Table in Excel 2003
- If Statement
- Re: IF Statement difficulty
- How I use SUMIF & AND
- HOW DO I CREATE MULTIPLE CURRENCY
- Calculation Question
- Help!
- How do I put a graphic behind the grid in Excel?
- returning a text cell based on a number cell
- Can you create an administrator for an excel file that is not sub.
- Forced Distribution
- how do i display formulas in only certain cells?
- CHIINV error
- FORMULA
- CHIINV error
- How do I conditional format for data that's repeated
- CHIINV error
- Concatenate and make uniform
- Excel to Access
- Getting rid of curly brackets within formula
- parse cell and insert rows?
- Counting problem again!
- Deleting content in a column
- Linking Data between worksheets in a workbook
- differentiating between "and"/"or" in a formula
- repeated numbers
- first week of year - according to european standard
- Getting rid of curly brackets within formula
- COUNTIF
- how to display heading of column corresponding to the cell
- How do I protect one cell in a spreadsheet?
- how do i create a blank cell in excel using a formula
- How do I prevent tied results when ranking data?
- Getting rid of curly brackets within formula
- If..then quesiton.
- RANDBETWEEN query
- How do I find downloads for workbooks for Accounting homework?
- Concatenate and make uniform
- why are nested subtotals coming out below outer subtotals?
- dynamic 3d sum
- Automatic date change when spreadsheet changes
- Add numbers for duplicate entries then delete
- CHOOSE Function
- How do I calculate the hours spent on a project by entering a sta.
- find and match the max
- Re: Grouping data within intervals
- Archive
- Excel row headings
- listing linked cells
- Address
- find and match the max
- find and match the max
- Where can I see VBA code for financial functions?
- RE: Printing Problem
- Find & Replace questions
- Cell Validation.
- A different "Fill Color" problem
- dynamic 3d sum
- search multiple worksheets for an item and return the Wsheets name
- Excel-value in a range of cells for two cross references
- Using Pick Lists
- generate random numbers
- Calculating due date?
- Identify if Cell is Formula or written number
- SUMPRODUCT using offset from ROW if X marks the spot
- Import file names into cells
- Calculating due date?
- Grading Function Question...
- Deleting content in a column
- When do you use 3-D reference?
- Web Saving Help
- making calculated fields constant.
- making a column of formuls constant
- making variables constant
- IF Statement
- Subtotals
- copy and paste
- Saving Charts to .htm
- Excel can't find the end of the spreadsheet (Ctrl+end)
- Excel Formula Question
- Sum and Count Function
- high lite a row
- Upgrading Problems: Excel from 2000 to 2003
- COPYING CONDITIONAL FORMATTING TO A COLUMN
- copying conditional formats to a whole column
- Macro for sorting different rows
- Lookup a date between other dates
- how do I make a function to count days?
- solver can not solve polynomial eq. where one variable is five di.
- accessing worksheets
- Sumproduct #N/A elminate?
- How do I stop the autopaste function in Excel?
- Data Sorting
- record count using two different cells
- count based on two fields- need as quick as possible
- count based on two fields - need quickly
- countif, again
- Need help with a formula
- Formula for date function
- If statements
- XIRR Function Error
- Automatic date change when spreadsheet changes
- count if
- A different "Fill Color" problem
- Count certain changes between columns
- How can I use count function in excel where I have several criter.
- combining countif formulas
- Save Excel file - prompts to save - no Volitile functions used
- Formula results in font color change
- counting entries between two dates?
- VBA: Update worksheet when txtBox data changes.
- Stumped! Collecting values into one cell.
- variation on countif?
- What is the formula to calculate Age when I have Date of Birth?
- What is the formula to calculate Age when I have Date of Birth?
- Data from one tab to another
- Re: Averaging cells which contain #DIV/0!
- multiple vlookup
- Summing a Column wit errors?
- Conditional Formatting "OR" function
- #REF error
- Formulas with If/ and results
- VBA: Update worksheet when txtBox data changes.
- random number generation
- Stumped! Collecting values into one cell.
- grouping
- Combine & Display “Fixed” & “Automatically Updated” Date Parts
- Data from one tab to another
- dynamic 3d sum
- Function to return colour of formatted cell
- Why do the ActiveX text boxes move when I print preview?
- Grading Function Question...
- No value entered
- excel won't work with peachtree
- Hiding rows based on date
- Display result as Yes or No
- vlookup
- =SUM Then insert word.
- Problem with array and msgbox
- Outlook with excel
- help please
- Excel Programming help
- Random
- Static Dates in Footers
- vlookup to see 2 values?
- Counting a Running Column
- Average determination
- open ended multi page sum
- <
> - COUNTIF Question
- Circular reference
- function about hyperlink
- RE: Break-even point function?
- How do I create complex functions?
- How do I set up a formula in excel that is the tenth root of 7 ve.
- Workaround for UPPER(F31:F10000)
- How do I set this up?
- sort automatically
- Web Tool Bar
- sorting automatically
- open ended multi page sum
- COUNTIF Question
- How Do I created a nested sumif - if this column has this and thi.
- Have a question on scrolling sum with Excel.
- Have a question on scrolling sum with Excel.
- open ended multi page sum
- Workaround for UPPER(F31:F10000)
- COUNTIF Question
- Workaround for LOWER(A1:A100)
- How to lock a worksheet and enable the PivotTable refresh data opt
- How to use a table index from a formula
- Lookup, IF, Then help
- How do I stop automatic page breaks in excel
- Graphs and sheet referencing?
- Autofilter - Return a Value
- Is there a way to link a received outlook email to a cell?
- Help with Interpolating for a value.
- How to control worksheet initialization upon opening a workbook
- Deleting Zero after Subtotal
- How do I create automatic cell movement when using excel
- Help w/ algebra equations (wrong formula used in my first 2 posts!
- Stumbling with IF THEN in Excel.
- Lookup value in colA whos row matches row of index value in colB
- Highlite a row
- Why is it important to check the range placed in the SUM function.
- Lookup value in colA whos row matches row of index value in colB
- open ended multi page sum
- Sumproduct on filtered cells
- Whats Wrong with this??
- Worksheet Reference
- Statistical Excel Function Question within Excel 2000...
- sorting
- Grayed Out Worksheet Tabs
- How do I email selected excel cells to multiple recipients?
- populate one worksheet from another
- count the no.of records between two dates
- Algebraic functions
- If both dates are entered into a cell then answer is yes
- Finding real values of a function
- Nesting If Statement with "AND", "OR" conditions
- IF Statement
- calculating weeks worked
- Sorting dates
- works 6.0 spreadsheet
- Is there a short cut to switch between worksheets?
- random alphanumeric string
- calculate with dates before 1-1-1900
- How do I transfer the format of one worksheet into another?
- filename with folder
- compacting UPPER/LOWER & column reference
- find top 25 codes
- How do I use conditional formatting for multiple rows?
- Cut and Paste
- How do you keep the date using =TODAY() from changing?
- Days of the Month
- Formulas not calculating
- How do I stop other circles in other cells to stop selecting?
- Calculating Net Position and Average Price
- finance charge on credit card
- How to look up and return multiple values
- How do you change the color of the cell hi-lite border
- is there a way?
- Formula for Extracting Alphabetic Part of a Product Code
- =data!c23
- pasting formulas into a selection
- lookup and copy
- How to use Proper formula?
- How do I "Wrap Text" & "Autofit" within Merged Cells in Excel?
- Formula for Extracting Alphabetic Part of a Product Code
- Can Excel add a set percentage to a cell automatically when you type in a number
- Conditional Format With SUMIF
- Using the Month function to sum another column
- Percentage format
- VBA: Looked up data / now how do I change it?
- help please
- end of worksheet question
- Finding duplicate nuumbers in a column
- VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True
- I am having trouble deleting sheets in Excel
- Re: Autofilter Stops Working
- How Do I sort an IP address by the 3rd Octet?
- How do I shade cells using the "IF" function?
- Reference
- Formula for Extracting Alphabetic Part of a Product Code
- Look Up Function
- CountIF across multiple sheets in a workbook
- Average Formula
- Add apostrophe
- Help with Formula
- Major cost of time.
- get count of row without duplicate entries
- Pro rata calclation
- Smart subtotals
- Insert\Name\Apply.... problem
- how to add up number of columns based on month eg feb = 2 oct = 1.
- Re: Recalculation takes too long - help!!!!
- How to Make the text blink in Excel?
- Exceptions to Validation Rules
- Problem with array and msgbox
- Hire purchase interest
- Conditional Formatting Work around?
- Vlookup - indexing
- How to shade a row of cells using conditional formatting
- sum difference cells on multiple sheets
- PRIME FACTOR
- Date Question
- how to accumulate value and put in other sheet
- Finding and Showing the Largest
- Display selected rows from one worksheet to another
- How do you embed an input form into excel?
- print a specific area within a worksheet by clicking on print?
- Finding and Showing the Largest
- Problem with Sum of Sums in Excel
- vlookup help!!!
- How do I create a formula that will multiply a 5% of a value >$150
- Function / formula to be used if cell contains a letter.
- How to populate column with formula based on value in cell
- How do I automatically shade cells depending on data entered?
- How do I create a button or control that will automatically go to
- Cell Shift
- How do I ensure dates inputted are during the work week?
- IF Statement
- How can I add a numeric value to a TIME cell?
- need to save values from a function before it changes
- Removing Spaces in a Cell
- trendline - request power --> get linear
- end of worksheet question
- How do I stop other circles in other boxes to stop selecting?
- Calculating using data from another worksheet
- Sum function on multiple date fields
- VLookup resulting in a blank cell...
- Sorting a list with subtotals
- How do I insert a circle in Excel?
- Can I use SUMIF with < and >?
- How do I insert a selectable circle in Excel?
- Insert column entries from a master list
- Insert column entries from a master list
- Insert column entries from a master list
- time-clock calculation
- Sum a range across multiple sheets
- Pivot Table Limitations in 2000
- Right margin will not change.
- Creating a dynamic list
- Creating a dynamic list
- Creating a list from an existing list.
- Need to find Min value based on date range entered
- Can Formula Change the Font Color?
- SUMIF based on 2 conditions
- sort numbers in EXCEL?
- How to link endings balances to beginning balances on different sh
- Excel & Copying Formulas
- Re: How to Replace numbers and text with numbers only?
- extracting comments
- If cellA is blank or 0 then cellB is blank
- Macro for formulas
- Return the end of month date from a date
- time-clock calculation
- Problem with array and msgbox
- What formula do I use to link worksheets together within one spre.
- How do i set up if function with more than level limits?
- How can I make autofilter show the filtered number of rows
- Can i automatically format cells to be a certain color if the val.
- Why can't my macro use Auto Filter when I told the Sheet Protecti.
- Is there a formula that can be used here
- Copying formulas
- Dependent List Query
- If cellA is blank or 0 then cellB is blank
- Creating a summary from existing spreadsheet data ...
- end of worksheet question
- How can i unprotect a workbook in Excell when I forgot the passwo.
- Validation - List - Separate Worksheet
- Hyperlinks in Excell
- How do I change the appearance of my drop down lists?
- What formula should I use
- RE: Can I create a dynamic email address in Excels hyperlink?
- Excel: Need Nper
- Attempt to register XLODBC32.DLL failed when trying to load SQL-R.
- IF and ISODD Formula Help
- counting
- Timings, need assistance
- Lookup Function
- lookup in colum a and compare values in colum b
- Changing a Parameter Of A Formula
- Changing a Parameter Of A Formula
- vlookup
- Report on data in worksheet?
- How to enable grouping in a protected sheet
- VBA: Return Searched Value Inputed by End-User
- Conditional Hide function for Excel
- is there a instrRev function in excel functions?
- counting
- Increase the max characters allowed in excel formula to much >102
- Lookup Function
- Customise Right Click Menu
- is there a instrRev function in excel functions?
- Re: SUMIF(AND) FUNCTION
- Need find cell b3 value on another worksheet!
- matching problem using VBA
- Re: Closest number match help ...
- Editing Multiple E-Mail Addresses...
- Add a string to a cell
- Need find cell b3 value on another worksheet!
- Using ROUND formula to calculate tax
- Need find cell b3 value on another worksheet!
- Date formula by decade
- Need formule which would find cell (exmp b3) value on another worksheet! please help!
- Need find cell b3 value on another worksheet!
- Add a string to a cell
- Re: double lookup, nest, or macro?
- Calculating commission schedule (will pay for help!)
- Calculating commission schedule (will pay for help!)
- Calculating commission schedule (will pay for help!)
- How to plot B2:B11 versus A2:A11
- end of worksheet question
- SUM function over infinite number of sheets?
- Changing number in same cell
- RE: Count rows based on multiple criteria
- SUM function over infinite number of sheets?
- end of worksheet question
- Re: Need Formula Help
- Re: using a reference in vlookup with excel 2003
- how do I get excel 2003 to round up
- RE: A formula to check differrent cells
- Conditional Sum
- how to get name of worksheet in a workbook?
- formula simplification
- Get cell value from 2 lists
- How can set how a number rounds up in excel
- Need to find Min value based on date range entered
- vlookup and IF function
- Calculating commission schedule (will pay for help!)
- Feed text from one cell to another no cut & Paste
- Using the Indirect.Ext function
- Conditional Sum
- Use MATCH to find position of max in 2D range?
- How do I create a crosstab process to determine patterns in surve.
- continuous cell function
- There should be a Refresh All feature, enabling all pivot tables .
- Please help create a formula
- extracting numbers with no more than 8-digits using advanced filtering
- How do I hide a formula message?
- RE: Cells won't format
- Conditional Formatting
- SUMPRODUCT CAPTURING DATA FROM ANOTHER SPREADSHEET
- how do you subtract military time? example 12:00 - 07:00 = 5 hour.
- how do I get a calculation to repeat various number of times?
- vlookup
- How do I create a column that has a 'drop box'
- How do I create a column that has a 'drop box'
- index match and sum
- MIN >0
- Insert rows based on specific value
- Re: average of everytwo rows?
- copy worksheet ... formulas do not update
- Count cells with the red color
- Excel
- Need to sum values of columns 1 - 13 and 4 - 15
- HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ?
- Pasting onto filtered cells
- Average Range
- To me this is huge, need some assistance
- Using the Indirect.Ext function
- Re: index to a range of cells
- Pasting onto filtered cells
- Re: Tricky formulas needed
- Re: Formula HELP
- Read excel workbook
- Add months and adding partial monhts
- Help!! What formula do I use?
- lookup combine vlookup with hlookup
- sumif 2 criteria
- Count cells with the red color
- Get cell value from 2 lists
- VLOOKUP Pls help!!!!
- Re: extract list of names and elimanate duplicates
- Re: Why isn't Excel dragging the right value?
- how can i make a cell always show text in caps