- transfering numbers into teams
- Setting formula to give info from rows with certain criteria
- How do I sort addresses in excel?
- Calculating a sum of various lenght
- Calculate the difference between two times
- how do I test for Integer?
- Sorting into quintiles
- Start spreadsheet with WinXP start
- How do I test for a prime number?
- Counting the number of rows
- How many different customers in a list?
- how do i convert from rands to zambian currency
- Help! Formula to find the address of particular value in sheet
- Date range criteria and Pivot tables (again!)
- consolidating workbooks
- How do I make a calculation?
- details of month
- Modify a Formula to Display Blank
- Multiple conditions
- cell validation even for values pasted into cells
- Time between two dates (Excluding Non-bus Hrs)
- a cell reference in a 3d reference
- Using autofilter and excel form format
- Count names
- How do I remove all text in a cell after a specific character?
- How do I limit what text is displayed?
- Absolute Reference
- Date function
- Figure out the hours worked for the week
- How do I delete all named ranges in a sheet at one time?
- Change row selection
- Worksheet tabs viewing there of
- text manipulation
- More Multiple conditions
- How can you jump to a selection in a validation drop-down?
- Plotting daily changes
- Removing a page break from excel
- How can I use a time difference in a subsequent formula in Excel?
- VlookUp that does not return #N/A
- Duplication of function
- Validation 'Jump To'
- row and cell reference
- How do I multiply a whole column by a number?
- Printout doesn't match screen view (columns wrap differently).
- Reference
- comparing lists
- calculation to exclude weekends
- highlighting a change in value
- Match Formula
- How do I turn off automatic date function in XL?
- Re: Finding number of particular days in a period
- Interest only payment
- if a1 value changed then date in b1
- How do I change dates in student attendance?
- Array Formula w/ Multiple SumIf Criteria
- calculating number of days (e.g., Mondays) between two dates
- Second appeal for help
- Concatenating Functions
- adding values with text
- MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
- Count Not Appearing when using AutoFilter?
- GETPIVOTDATA -- How do I shut it OFF!
- I Need to Count Number of Entries Based on Two Criteria
- Arithmetical Mode of Criteria in Multiple Non-Adjacent columns
- Linking and formatting multiple worksheets
- formula
- Converting Time Data
- Running a Macro automatically from Excel
- Desktop file sharing
- Display latest date in a column
- Help with Formula
- Filtering by criteria in two columns
- vlookup returning a n/a result
- How do I create ccolumn headings diagonally?
- interest only
- DB (depreciation) function Help question
- Time functions, how do I work out number of hours
- How to filter 7 columns in a 20 column spreadsheet?
- Conditional Sum by Row
- Levels in Subtotals
- Function help please
- Transpose Macro
- How to fix a link in excel
- apply autofilter to more than one table
- two worksheet linking
- Can solver do this?
- Match and Index
- Vlookup for 2 items
- Sum function for non-continuous range
- funcation
- Column of check boxes
- lookup value froma filtered list
- VLOOKUP blows up file size
- index / match /lookup ? help
- How to Add a Calculation to a Pivot Table ?
- future dates
- Is it possible to have multiple splits in one worksheet?
- How can I capitalize multiple cells that were entered in lowercase
- Return first 'n' characters
- reduce a balance from severel cells
- Validation Based on a Date
- Purge functions leaving only calculated data?
- Filter by Color
- mapping with excel
- Date X Data
- Excel 2003, Insert Function, create full name & descriptions
- "." & a "+" added 2 a table reformatd as text in Word???
- If a cell is blank do no let a user print or save?
- functions 33242
- compute values in a range
- how do i keep a time/date register of every change occurred in a c
- IF function
- How to calculate values in multiple values with multi conditions
- Using a Formula in a Conditional Statement?
- Using the autofill function but increment by certain number in function
- Calculate sum of numbers with conditions
- I need to put text after the value of a referenced cell (=B4'MS')
- Conditional Filtering
- Sum func. is adding cells not in specified range
- If statement
- Can data from one ws transfer to another IF cell has text?
- Is there a function that will return the page number?
- Is there a way to average if in excel when looking at a range of d
- The # in my vector is absent from my array. Can I make it 0?
- How do I Provide a specific result given multiple criteria?
- How do you...
- Limit of # of tabs
- How do I open multiple hidden worksheets all at once?
- ???is there a way to keep one row in view while scrolling down???
- Set a cell to have a pop-up calendar for date selection in Excel?
- Recording simple macro
- vlook up
- To show blank please
- Date conversion
- Create a button in excel that can open an outlook appointment?
- Am I asking to much from vb codes?
- vlookup returning sum
- conditional autofill???please?
- How can I force a worsheet to recall functions.
- get total hours from 2 dates
- To have the cell blank please
- Turn off cursor from automatically highlighting cells in Excel?
- lookup function 1
- Calculating the sum with multiple conditions
- our cost to customers cost
- Sumproduct
- Incrementing a worksheet number in a formula
- Incrementing a worksheet number in a formula
- Function to calculate the number of years, months and days between
- I have forgotten my password and have no excess
- Re: Question regarding how to search a column and print a row(s)
- Value 0
- Finding the first blank or zero value
- Sum Multiple Criteria or DcountA
- Is there a formula for IF a cell CONTAINS certain text...
- How to convert the dates from the YY:DD forma to MM/dd/YYYY format
- A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
- Renaming multiple sheets
- time subtraction problem
- save as webpage?
- Searching TEXT in formulae, rather than results of formulae
- format method
- Getting timestamp from a file in Excel
- How to reference to the previous worksheet regardless of title?
- Choose data from a particular column based on a specific value
- Dates
- Bars in a chart???????
- Automatically transpose when pasting data in excel
- common entries between 2 columns
- adjacent data count from a binary column
- How to calculate a pay-back period by the accumulated cash-flow automatically?
- Bonus Calculation problem
- What is the purpose or why would I use watch cell?
- Count the occurance of a value x a value in another cell in excel
- converting from lotus 123
- Is there a way to transpose and invert the order of data in Excel.
- How do I display the tab name in a formula
- Need Subtotal Help
- RE: Question regarding how to search a column and print a row(s)
- Move between worksheets
- Using average in two condition arrays...
- Finding min/max of adjacent data in a range of cells
- Formula between two worksheets
- What cells in a array equal my value?
- Show Dollars in Millions
- Need Help with custom function!
- If with a range
- Changing the color of a list entry based on a tolerance
- sort 2 or more rows of cells linked to one row of data
- Sorting Data from 2 sheets, one sheet which is already sorted
- return zero from a blank cell
- How I need correct formula, that no t rounding?
- SUM every other 14th cell
- creating an invoice for work
- Variable Column references
- Stock Update
- How do I format 1 column of alphabetical listings into 3 columns?
- ASCII extended set is different in Excel, than MS's Website?
- Daily water meter readings
- Countif Function
- hh:mm - mm formated 2 round to .25, .50, .75 & 1
- IF A CELL HAS THE VALUE OF 0, I WANT IT TO GO CHECK THE NEXT ONE
- VLOOKUP problem
- GO FROM ONE WORKSHEET TO ANOTHER WITHOUT CLICKING
- Macro help???
- excel formulas with text
- Excel fields in a row instead of column...
- In Excell how do I just type in an amount w/o it inserting a $
- Sorting
- Problems using a variable as a Table_Array in VLOOKUP
- conditional formating....
- Sumproduct based on substring?
- how do i set up my main categorie row to repeat on other pages
- Workday Function Question
- our cost to customers cost
- Vlookup With A Twist
- recursive sums
- summary of customers?
- Quarterly tax percentages
- Help with Formula for Text Entries
- INPUTING TIME FORMAT
- HEADER ?
- Identify Numbers
- PIVOT TABLE?
- Progressive Addition Formula
- can i get excel to add variables
- why does my excell worksheet start with only a gray view, no data
- Comment
- Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns
- culmulative calculations
- This is Weird - Dead Simple Issue with Sum Function
- Need formula for a fixed cell minus last entry on ongoing log
- Using Excel macros from Vision objects
- Concatenating a cell address
- Answering a question in a cell
- Displayed contents of cell in target row if column criteria is met
- my formatting changes do nothing to the data
- How do I filter names using only the first letter?
- returning a count if two conditions are met
- automatic filling in cells in excel
- Using non defined names from another sheet
- Page Numbering Function?
- Need Formula for Last Occurance
- Timer function needs improvement
- Rounding numbers to the nearest 5 or 0
- Why help?
- count date ranges
- copy numbers progressively
- HELP!!! On SumProduct
- Help keep incompetents in business
- match cell in array1 with all cells in array2
- Data Validation
- Thank You both! n/m
- Merge files & sorting data
- Why does the Sort function stop recognizing Header Rows?
- My print preview is only showing one page to be printed
- Issue with sumproduct
- quatro pro to excel
- How do I please.
- To leave the cell Blank
- datevalue
- perform calculation only if current time is after 10 am
- .wb3 file convertion
- How do I sort dates stored as 1-Jun-05 in order of day & month
- How do I change a cell's contents to it's formula's value?
- mixing text and formulae in same cell
- CURRENCY INDEX FOR EXCEL
- Same Name refers to local ranges
- Text from text box to cell
- Multiple text boxes selection
- macros
- Formulae
- How do I compare data between spreadsheets?
- Array Function
- SumIF is not working
- Can I create a dropdown that will show a 2-month calendar?
- text formulas
- trouble filtering a list. Why isn't column filtering?
- DOnt calculate leap year
- Counting Duplicate Entries
- Microsoft Excel Spinner's
- Combo Box View
- Complicated lookup function
- Ranking
- Macro Question
- LOOKUP
- Printing
- Merge text list
- Comparison
- Validate Cell contents in formlua
- Problem with compound IF statement
- AVERAGE problem
- calculate the number of days from date received
- IF and MIN functions
- lookup help
- Wildcards in functions
- first value > 0
- How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd?
- Indexing a row
- I need to merge lots of info, w/o copy paste?
- Consecutive Numbers down a column not to Exceed 49
- sort list of players by team from player list on separate sheet
- percent change
- Conditional Formatting
- Count if number between two numbers in Excel?
- excel formula to convert lat/lon degrees to DDD MM SS.SS?
- Totalling formulas
- How to lock worksheet and still able to click on grouped rows
- using VLOOKUP to compare 2 columns to find new information
- cell links
- COUNTIF temporarily missed some cells
- Why are cumulative interest payment calculations different?
- Problem in using Vlookup (1st time user)
- Excel: match two cells in one sheet to two cells in another and return a third cells value
- Show in Z the last entry from A thru N
- vlookup in a pivot table
- Cells with a value between two dates
- Making mulitple IF statements.
- Tab key movement Excel 2002
- Count if 2 conditions are true
- Data parsing question
- Multi-condition vlookup
- Listpro
- Can I Find one word in a formula
- Conditional format with a formula
- Create summary based on specifc value in a different sheet
- excel paste special should allow text
- Formular Question
- How to copy the data in row to column?
- replace function
- comments in excel
- NETWORKDAYS
- how do I set up a pricing template in excel
- Help with sum up or down in cells
- What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??
- create a list from 2 sheets
- index match formula
- index & match with links for updating to other workbooks
- VLookup for multiple values!!
- How do I ignore values while copying from hidden rows?
- Question on using time in Excel
- If, Then Function
- how to combine the multiple rows into one rows?
- excel worksheet
- Group values
- How do I change the number format within the concantenate function
- Return data from multiple cells
- IF, THEN statement
- Calculations on only a selection
- Algorithm Challenge
- Cell Protection
- How to automatically capture a tab name in a cell?
- Looking for a way for excel to count unknown repeating values?
- Referencing cells containing tab names?
- Is there a function for a 'year to date' sum
- Excel Function To Access
- How do I check for existence of a worksheet?
- Subtotaling based on more than one group
- Creating Text lists
- find-replace box should not float but be fixed line on tool bar
- formula help - Is this possible?
- Auto Update
- formula problem - UK national curriculum levels
- Conditional Formatting, date.
- I've tried Sumproduct, SumIf, Vlookup and Hlookup.
- EXCEL worksheet
- Excel database
- move data from multiple cells in one row to another
- how do i use spreadsheets wider than 256 columns?
- truncate
- Formula problem
- Can I add a flashing message to a spreadsheet?
- vlookup fails on data from a pivot table
- can I add a flashing message to a spreadsheet?
- Moving one workbook page to a new workbook
- Can I use excel to find y = f(x,z)?
- If Then, not using values, or not counting blanks
- Copy sheet 1 data to sheet 2 cells.
- random numbering
- if else construct
- Automatically Enter Data
- excel spreadsheet with e-mail notification when due date arrives
- refresh auto filter
- Finding the minimum in a selected number of rows of the same colum
- trying to import excel database into outlook need to name ranges
- Setting up some sort of cutting and pasting loop
- MS Excel Data function missing
- using Goal Seek inside a recorded macro
- LOOKUP funciion giving an error
- Excel If then Else function in Worksheet
- Excell Formula
- enable commentaries when is protected
- Change case...help please
- Avoiding the dreaded #div/0 error
- Setting All Worksheets To The Same Scroll Position
- numerical value of a letter
- Compare cell value
- Variable Input Range for Combo Box
- Date Calculations
- How do I LOOKUP text values
- Subtract Hours
- Sum and Skip Negative Numbers
- #div/0 Error
- If Then Lookups - If Someone helps me, Then I will be happier!!!!
- conditional formatting with formula
- how do I calculate the annual interest when I know the compound
- sort by SUMIF results
- Combine several spreadsheets for an emailmerge (perhaps using Acce
- Index Row and return data in a Single Column
- Function help!
- Cell format
- lookup specific character place
- How do I get rid of the #DIV/O in a cell?
- Vlookup across multiple tabs
- Simultaneously change values in multiple cells?
- vlookup more than one exact match
- text and numbers same cell and formulas still work (like lotus)
- Is there a help on the TABLE worksheet function in Excel?
- VLookup
- Re-Calculation on a single worksheet
- adding values based on criteria
- using a file dsn in sql.request to connect to sql server
- Average Time
- Re: hyperlink help
- pivot table sorting
- Comparing 2 worksheets
- I need help with an "If" Statement
- can macros change cell color daily, i.e. green to red everyday?
- Linking Entire Worksheets
- Assigning Macros to Buttons in Excel
- Insert a new worksheet after subtotal
- I need help with an folmula for hunting / matching names and value
- Average Non-Continuous Cells Without Zero's
- Combo Box
- Lookup??
- Excel Grouping
- How can I show the total sum of items in a filtered column
- Determine which cells from a specific range equal a certain sum
- Search for specific words
- pivot table
- Filter/find/isolate one specific term?
- Conditional Formating with Checkbox
- How do I remove a date at the bottom of an excel sheet?
- Comparing Data
- Drop AM and PM from date
- How do I auto change text colour in excel to reflect the value ent
- Conditional Formatting on Whole Numbers?
- how do i shift from tab to tab using keyboard(same file)
- Some formulas need file refresh in same worksheet
- consecutively number cells in a column range
- Complicated sumproduct help reqd.
- Calendar template on Excel
- Desperate Help needed with a function.
- problem with #value!/zero
- SumIf
- Lookup across 2 or more columns to match a row
- How repeat numbering for raffle tickets eg. 000001 - 000001
- list to table
- Pls Help Me!
- Lookup on different sheet
- sumif help
- Help with this formula!
- Drop down box
- Probabilities, random numbers and dice throws
- sequential numbering for invoice
- How do I apply a % +/- to a range of figures please
- Question on Vlookup
- Date controlled function execution
- How do I copy a reference formula onto multiple worksheets
- Conditional Formatting
- I want to correct a #div/0! error but the IF function doesnt work
- Can I lock a row so that it's always the last row on the page?
- Shadow current field box as it moves?
- find a sum from a list of numbers
- How do I get a hyperlink (entire row) to data sort alphabetically
- I need to count while using multiple criteria
- Percentage Calculation
- How do I break links in a workbook?
- Dynamic reference to workbook
- Dates and times with PST,PDT
- More sumproduct/table multiplication help
- format cell based on results of vlookup function
- How can I count items in a filtered list?
- How to solve y =f(x,y) using matrices?
- countif function
- PDF file into EXCEL
- Can taxes be totalled on separate sheet when using Excel invoices
- Using cell references as text in a formula
- How can I copy cell formats in functions?
- Get Past the 7 Nested IF limit
- average annual return
- Sum error
- Printing data validation scenarios
- Using Search with either vlookup or match and index
- How to automatic calculation and macro execution between 3 workbooks?
- Autoshapes and objects disappearing
- Suming up a Lookup
- DAYS360
- excel
- summing up contents on ceratin cells depending on selection criter
- Can't get an Excel spreadshe doc. to export into Oultook Contacts
- reverse week count calculations
- Finding a character type within a cell
- I need to use a number in one worksheet to match text in another
- Custom Cell Format Will Not Save Correctly
- Making Font Color Changes in IF Statements
- Same row different Answer.
- Numbers
- calculating term of financial transaction
- large binary numbers
- Can I HIDE cells with a conditional argument?
- Random Numbers
- reference #value error
- Store max value of changing cell
- Move a Column of 500 Email Addresses into BCC Field of an Email
- How to get reult in text
- Using Wildcard characters in sumproduct
- Match function...random search?
- product calculation in excel
- help with spaces in funtions
- Excel Doctor
- COUNTIF Bug in Excel 2003
- what is '
- Indirect used in an array formula
- width of column is zero
- having the same workbook in different file
- can I make worksheet name equal a cell
- Retrieving non adjacent data from other workbooks?
- sumif function with a difference
- Conditional Formating
- RE: Excel Doctor
- cells will not calculate
- worksheet sorting
- collecting cell data from every 33rd row
- sharing a macro
- Calculate matching cells
- Cell Reference, Multiple Sheets
- Create Windows Directories from column entries?
- Conditional Formatting
- How to Use Group and Outline function when locked sheet
- Changing case on mailing lists I receive in Excel 2003?
- Copying chart to another sheet
- Conditional Formatting
- Returning expected dates
- Let me see if I can explain this...
- How do I get data to automatically flow to another sheet? excel 20
- Template for printing-orientation, header-footer setup
- How do I hide a combo_box on a condition?
- another simple problem...
- multiple and round
- Digit seperator
- Question for use of offset and range
- coping a formulas to another cell.
- Question regarding dynamic range setting
- Random Number Generator
- automatically copy data from one worksheet to another
- VARIANCE PERCENT
- ISBLANK Formula Help Request
- Function to write out numbers
- format-row-autofit not working
- Using autocomplete
- how to copy just the number that a formula creates
- cells will not accept decimals.will not allow any retype with deci
- Need help with Combinations, told to come here
- Advanced Lookups
- Count Intervals of Filtered TEXT values in Column and Return Count across a Row
- Formula Help
- Vlookup text values
- Sum If on muliple conditions
- Excel should allow more options for formatting cells
- rounding in quarter increments
- Excel sorting problems
- MegaStat for Excel
- referring a worksheet
- Copy Text Only
- copy color
- How can I complete a spreadsheet using macros?
- VLOOKUP Problem
- Arranging columns
- Find first positive value in row 3 and return date from row 1
- How to return a dollar value for a part number entered in a cell
- Find last nonblank in a column
- worksheet email address to outlook xpress contact
- Passing Excel NAMED Range to VBA
- Two arrays need highlight duplicate in one of the array
- create a function for Discount if qty > 50 then take 5% off total
- Rounding time to nearest Hour
- how to close print preview
- dynamic cell reference within a text string
- Can I hide a worksheet and set a passwd to unhide it?
- How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx
- Find values from cells in multiple sheets
- Excel pointer problem
- continuous page numbering multiple sheets of a single workbook?
- date counting
- ISNA
- Average last 6
- Master invoice number
- tab name
- Wrap text ceases to function in Excel if cell exceeds 9 lines
- Auto Filter + subtotal
- Extract last and next-to-last entries in a range
- What function allows me to compare 20 repetting text.
- What function allows me to compare 20 repetting text.
- How do I show the VALUE in a linked cell?
- Spinner macro for Pivot Tables.
- Matching unsorted lookup values
- Adding Cell Range with Text
- IF Help
- Macro to scroll to Cell A5 please
- changing type style and colour within a worksheet function
- Inserting Rows
- Additional Conditions for Conditional Formatting
- Text
- Using VBA to insert Columns
- how can i secuire Sheet Same time Update the Pivot Table
- Filtering dates using a formula
- COUNTIF and automatic type conversion problem
- concatenate
- SUBTOTALIF function
- Vlookup
- how i open a file XLS extension[ exelspreadsheet file]
- calculating the difference between 2 numbers
- how to use a cell reference in a formula
- Which function can be used to Read the number in a cell ?
- DATA TABLES and multiple sheets
- Tell me what to enter to Export Excel address book to Microsoft O.
- sumproduct producing #VALUE!
- Erro in Formula, Pleas Help?
- Sorting & Filtering in Shared Workbook mixing up data
- anyone know a formula?
- Not sure which function and how to use it. Help
- Sales Commission calculations
- drawdown
- How do I take a column of dates and add six months?
- AVGIF
- Excel not always summing correctly
- Offset Function works in cell, not in named range
- How do you export MathType from Word into Excel and be able to so.
- Formula to lookup last number in colum
- How do I create a formula
- use central formula on many worksheets, central affect allsheets
- Formatting / Time
- convert text to numeric vba add-in?
- Trying to Create a Conditional Drop down list
- Updating, Deleting and inserting rows over two Excel Sheets
- need to find a max count without knowing what I'm counting (list of names)
- automatic numbering
- cursor goto a5 in Sheet1 but
- Newbie question: Matching data/2 wkshts copying info over
- sumproduct question
- Help....please.....having problems in Excel with Functions
- How to use a variable for a range
- conditional formatting or vba?
- Ignore Non-Alphanumerics When Comparing Text
- Looking for an income anutiy template
- Clearing all Active Cells
- I need Help!!!!!!
- Truncating a columns worth of cells not just a single cell.
- Converting cell contents to a formula
- Mirror Image
- How do i auto create multiple files from 1 with multiple sheets
- Using INDIRECT to refer to different workbooks
- 'IF' Statement for a Concaterate Formula
- 'IF' Statement for a Concaterate Formula
- To save and close
- Mode-1
- patterns
- countif results
- program excel worksheet to automatically not print blank rows
- Hidden column A
- Calculation of Selection Group using Arrays (or VBA?)
- Dates in Excel
- Incorporating Numbers into a text string
- VLookup to sum cell values
- Vlookup help
- Formatting result of Index function
- Wildcard search functions within Vlookup
- formula for filtering and a defaulting date
- @SUM Total Changes
- MAKING A CONTRACT FROM DATA FROM A WORKSHEET
- Open as read-only
- Trim and Keep the Trimmed Data
- Pivottable across network
- Open as read only Problem
- Dynamic formulas including worksheet references
- Need help with a formula
- After using a formula how can I filter out answers I don't want?
- how to convert text to value
- help with formula
- Is it possible to do this ...
- How do I use DAverage in Excel?
- How do I use DAverage in Excel?
- DAverage Function help needed
- Results from a combo box into a formula
- average based on weekday
- Checking if a cell entry is correct before adding it to another
- I NEED TO FIND TWO FORMULAS
- Font Help!!!! Urgent!!
- How do I round last number without a decimal point
- Need formula for 5 yr high/low
- Need formula
- Need Help With ARRAY Formula
- remove leading zeros from text strings
- sum formula equals zero
- sumproduct
- Referenced cell does not automatically update
- How do I count to different variables in excel
- Sumproduct help
- Can a single cell be protected in Excel 2003?
- Building a Filename
- copying text across sheets
- how do i extract a number from a cell with no spaces?
- Selecting the 2nd highest value in a row.
- simple chart question
- How do I edit a Named Range using macro's
- Copy a formula maintaining a constant cell
- How Do I organize sheets and clients by town?
- How do I link a cells formatting from one worksheet to another?
- How do I count the number of cells in a list, e.g. H6:H12, J4, J7:
- Want to extract from a list of 4700 rows each 185th row to a new w
- How are relay leg times or driving times entered and totaled?
- Dynamically compare two slightly different copies of a table
- Conditional Formating
- Urgent - Formula for incr/decrease of 5 cells
- Count Function Help
- How to randomly select from a list with condition
- how to ignore hidden cells with a countif
- Use CountIF with conditional formulas
- SEARCH IF
- Extract one numerical value from single cell with multiple values?
- VLookUp Problems
- Adding values from several worksheets - would appreciate the help
- Excel calendar
- Copying files
- Counting Values on a condition
- Mode Problem
- calculating time with text
- Excel Formula
- INDIRECT.EXT help needed
- MathText in Excel
- Max date
- Return cell contents based on conditional lookup
- Need formula to figure compound interest of a deposit for a year
- font style of worksheet functions
- please help!
- Is it possible to use data from different workbooks in formulas?
- cell = tab
- linked workbook updates
- compare -neg and +pos number that cancel each other in a column
- not showing pivot values of zero
- column values to a cell with comma seperated
- Excel 2003 view formula within pivot table
- Worksheet function in excel only works once
- How to run a macro when a worksheet is selected
- converting formula from lotus.123 to excel
- how do set a number so that it automatically changes
- SUMIF where values to be summed are formula
- excel validation, enter particular score in only one cell of a ran
- Dependant Droplist showing distinct records
- How do I change the color of the indicator cell in row and column
- Is this even possible
- how do I copy info from one sheet to another via a formula?
- Time Calculation
- Linking to workbook
- display day
- need help with an equation in worksheet to populate numbers onto c
- count date occurances in range of dates...
- HOW TO MERGE TWO TABLES
- How do I group multiple data entries in sub-groups
- Conditional Formatting
- How do I change letters at top of excel to custom headers
- provide ability to undo a save - saved by mistake
- Excel needs to have the ability to insert "SUB" worksheets
- multiple conditions formula
- using OR in conditional formatting
- Probability calculation
- cell/range with formula not recalculating
- IF Statement with a range
- rounding numbers, with-out decimals. IE:4507 to 4510
- calendar with scheduled projects from spreadsheet
- How do I compare two times to see if one is "late" or "on time"?
- copying addresses from one workbook to another into several worksheets
- Countif and then some...
- USING THE BALANCE SHEET TEMPLATE, ANY WAY TO EXPAND?
- Countif formula and then some...
- Ugh..another time and date problem...HELP
- copy data in one sheet to multiple sheets in same workbook
- Conditional color fill whole line...
- colors
- currency & formulas
- The Excel cells are not automatically calc. existing formula.
- Partially protect a cell?
- HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
- sharing a workbook and incorporating changes from multiple users
- why can't you move colums in Excel like in Outlook?
- ExcelFreezePanes shoud work horizontially and vertically together
- looking up value in chart
- how to alter cell format if cell contains text
- Conditional Formatting
- Coloring Cells
- How do I put worksheets in alphabetical order
- formula to count occurence of criteria in 2 columns
- If Function Help, Please!
- Update and add new row of data help?
- Vlookups or Match to find multiple information
- at, if statement with text, such as if(product), then (price)
- Conditional Formatting
- count problem
- Convert rows into 1 cell or 1 string
- How to use variable in reference
- Help with multiple Index
- Due Date Flagging
- time calculation with military time
- Edit Links - Combo Box Problem
- Rounding off numbers in Excel 2003
- 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
- If Then Formulas
- make negative number value to zero
- make negative number value to zero
- Name the worksheet by a formula
- empty cell question
- Function for Auto Populate
- Text
- Accidentally converted date mm/dd/yy to a 5 digit number
- One more Argument.
- Conversion of a Number into English Text
- How do I copy cell values (derived from formula), not references?
- yearfrac problem
- count problem part 2
- counting characters issue
- Summing a variable range of columns
- COUNTIF / SUM problem
- Creating a list of worksheet names on a Summary PAge
- Date difference
- Double lookup
- sharing a workbook
- Dates in a week number
- Count if array contains cells of a certain value
- How do I get/copy the (same) layout from a linked worksheet?
- Using solver with function with multiple outputs
- Conditionial formatting for merged cells, function Len($A$4)
- using formulas in a drop down box
- HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?
- Searching for a criteria in array of cells within an IF statement
- help
- Summing Columns
- MAKING A CONTRACT FROM DATA FROM A DIFFERENT FILE
- Working with sub-totaled data
- indirect function?
- how do i set up a date stamp formula in excel?
- format workbook
- Field Source Error for Pivot Table
- I am looking for a formula for calculating APY on CDs.
- last number array from string
- Inserting commands in Macros
- AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER
- Time Elapse Formula
- Excel Functions
- IF, Match, Index ? which One do I use
- Excel 2002 Pivot Table Date
- Text to Numeric
- counting based ona number of variables.
- How do I pull certain data from several worksheets in one sheet?
- If Date=x then do y
- Help with Sumproduct with Indirect
- Negative r-squared?
- Excel formulas
- Problem using AND()
- Count error frequency in huge column
- searching
- Do you know of a Calibration Control spreadsheet in Excel?
- Excel Help
- excel function
- Removing a matching code from another cell
- Re: Comma Woes
- countif function
- HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
- RE: Newbie With A Question
- text
- Returning a 0 Value
- How do I calculate a running balance?
- REALLY COMPLICATED--the sooner you can help the better
- Lock in formatting
- I need help with a macro which will copy a worksheet and..
- Font in Comment Box
- Needs to Show blank please
- Which function do I use
- 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
- Which function do I use?
- automatically update links without opening file
- How to put color on if function
- problems with RATE function returning #NUM
- IF Function
- My IF(AND passes logical, but doesn't reveal correct results
- Advice sought: Multiple column sorting
- Choose From a Range
- Protection and Filters
- Creat a formula to calculate working hrs according to number of da
- Conversion formula (Proper Case)
- Is it possible?? If it is then please tell me how.
- Automatic updating of 2nd sheet from first
- How Do I Enter Data Into A Single Cell
- Function help with Calculating Interest for two different investme
- TTest with values in non-contiguous ranges
- List only red entries
- If function help
- Easy formula, but need help please
- Possible to insert cell data in the middle of line of text?
- deleting a Text Box in a worksheet
- Need help in calculation at specific location
- Need help to reflect number of days in a month.
- math problem
- Number of Items open longer than 1 week but less than 2 weeks
- Polynomial trendline
- How do I set view page breaks as a default.
- Summarising data from several tables
- csv format drops a text character when reopened in Excel
- How to change the footer only, on multiple worksheets in Excel?
- how do I create or add to a formula . . .
- jackh
- working with sub-totaled data without the detail
- counif but not all the cells
- Multiple Functions IF, AND, COUNTIF, MATCH
- How do I work with part of a cell entry?
- Totaling Hours in Standard Format
- HOW DO CONVERT EXCEL INTO WORDS FORMAT
- advanced if?????
- retrieve cell formatting with IF(HLOOKUP) formula
- Multiple conditions on a countif
- Quotations and blanks cells (that aren't)...
- how do I add another page with different cell sizes?
- Index, Match, Offset? Not sure which to use
- undefined function error when creating xls pivot from mdb qry
- My needs are simple-apparently, so am I
- Referencing lists in a nested IF formula
- How can I round a number to the nearest "50" or "100" in excel 200
- Borders in an inserted row
- how do I print a page with only grid lines showing
- Help with conditional formatiing?
- Convert to VB
- Can I get Excel not to save a file if certain information is not i
- In Excel, how do we convert text into number (value)?
- Import External Data
- Excel and access should permit sorting by last character
- Password protection of worksheet when copied and pasted.
- Help with "IF" Formula
- Need a little help w/ COUNTIF
- VLOOKUP - dealing with lookup_value differences
- UPDATED - Referencing named Ranges within a Nested IF formula
- Indirect or Vlookup Function
- Drop Down Boxes
- filedialog
- How can I convert Text into numbers?
- change headers from letter to number/number to letter
- How do I pull a date from a separate worksheet using the IF functi
- How can I replace the path of the linked spreadsheet in a cell?
- IF & AND Functions together
- Using the tab key...
- autosum problems
- Joining String with function in IF()?
- Clearing multiple cells in 1 click?
- sumproduct problem
- Automatic date
- info in cel needs to propt other cels to automatically enter text
- how can I create a ODBC database in excel
- How do I generate random lottery numbers in Excel?
- Extracting Text only
- Formula pull factor from chart based on value of diff field?
- Sumproduct and wildcards
- Drop-Down Colours
- Link a cell to another workbook with a different path
- look up number in column
- Excel
- Using text and data in formula.
- search a series of rows for a specific formating
- Strip leading spaces from cell
- Error Handling #N/A with AVERAGE Function - Average of values in Row
- how to use shift and down arrow keys in a macro?
- my tools menu does not have Letter and Mailings option
- Count number of values in a cell
- =Cell("color",[reference])
- HELP!!!! sumif or sumproduct ??? :(
- HELP!!!! sumif or sumproduct ??? :(
- Can cell get tab value
- How do you add numerous subtotals in a spreadsheet?
- count distance in column
- How to count a range of values in a single cell?
- More Help Needed with Count formula
- Auto Repeat Data
- Auto Repeat Data
- Removing '0's' in cells
- INTRATE function
- What's wrong with my code ?
- Copy worksheet question
- How can I find items that have a certain prefix and define?
- To Leave Cell blank Please
- #div/0! how do i supress?
- how can i trace position in marks sheet
- Need help with a simple Time calculation