- How do I round last number without a decimal point
- Font Help!!!! Urgent!!
- I NEED TO FIND TWO FORMULAS
- Checking if a cell entry is correct before adding it to another
- average based on weekday
- Results from a combo box into a formula
- DAverage Function help needed
- How do I use DAverage in Excel?
- How do I use DAverage in Excel?
- Is it possible to do this ...
- help with formula
- how to convert text to value
- After using a formula how can I filter out answers I don't want?
- Need help with a formula
- Dynamic formulas including worksheet references
- Open as read only Problem
- Pivottable across network
- Trim and Keep the Trimmed Data
- Open as read-only
- MAKING A CONTRACT FROM DATA FROM A WORKSHEET
- @SUM Total Changes
- formula for filtering and a defaulting date
- Wildcard search functions within Vlookup
- Formatting result of Index function
- Vlookup help
- VLookup to sum cell values
- Incorporating Numbers into a text string
- Dates in Excel
- Calculation of Selection Group using Arrays (or VBA?)
- Hidden column A
- program excel worksheet to automatically not print blank rows
- countif results
- patterns
- Mode-1
- To save and close
- 'IF' Statement for a Concaterate Formula
- 'IF' Statement for a Concaterate Formula
- Using INDIRECT to refer to different workbooks
- How do i auto create multiple files from 1 with multiple sheets
- Mirror Image
- Converting cell contents to a formula
- Truncating a columns worth of cells not just a single cell.
- I need Help!!!!!!
- Clearing all Active Cells
- Looking for an income anutiy template
- Ignore Non-Alphanumerics When Comparing Text
- conditional formatting or vba?
- How to use a variable for a range
- Help....please.....having problems in Excel with Functions
- sumproduct question
- Newbie question: Matching data/2 wkshts copying info over
- cursor goto a5 in Sheet1 but
- automatic numbering
- need to find a max count without knowing what I'm counting (list of names)
- Updating, Deleting and inserting rows over two Excel Sheets
- Trying to Create a Conditional Drop down list
- convert text to numeric vba add-in?
- Formatting / Time
- use central formula on many worksheets, central affect allsheets
- How do I create a formula
- Formula to lookup last number in colum
- How do you export MathType from Word into Excel and be able to so.
- Offset Function works in cell, not in named range
- Excel not always summing correctly
- AVGIF
- How do I take a column of dates and add six months?
- drawdown
- Sales Commission calculations
- Not sure which function and how to use it. Help
- anyone know a formula?
- Sorting & Filtering in Shared Workbook mixing up data
- Erro in Formula, Pleas Help?
- sumproduct producing #VALUE!
- Tell me what to enter to Export Excel address book to Microsoft O.
- DATA TABLES and multiple sheets
- Which function can be used to Read the number in a cell ?
- how to use a cell reference in a formula
- calculating the difference between 2 numbers
- how i open a file XLS extension[ exelspreadsheet file]
- Vlookup
- SUBTOTALIF function
- concatenate
- COUNTIF and automatic type conversion problem
- Filtering dates using a formula
- how can i secuire Sheet Same time Update the Pivot Table
- Using VBA to insert Columns
- Text
- Additional Conditions for Conditional Formatting
- Inserting Rows
- changing type style and colour within a worksheet function
- Macro to scroll to Cell A5 please
- IF Help
- Adding Cell Range with Text
- Matching unsorted lookup values
- Spinner macro for Pivot Tables.
- How do I show the VALUE in a linked cell?
- What function allows me to compare 20 repetting text.
- What function allows me to compare 20 repetting text.
- Extract last and next-to-last entries in a range
- Auto Filter + subtotal
- Wrap text ceases to function in Excel if cell exceeds 9 lines
- tab name
- Master invoice number
- Average last 6
- ISNA
- date counting
- continuous page numbering multiple sheets of a single workbook?
- Excel pointer problem
- Find values from cells in multiple sheets
- How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx
- Can I hide a worksheet and set a passwd to unhide it?
- dynamic cell reference within a text string
- how to close print preview
- Rounding time to nearest Hour
- create a function for Discount if qty > 50 then take 5% off total
- Two arrays need highlight duplicate in one of the array
- Passing Excel NAMED Range to VBA
- worksheet email address to outlook xpress contact
- Find last nonblank in a column
- How to return a dollar value for a part number entered in a cell
- Find first positive value in row 3 and return date from row 1
- Arranging columns
- VLOOKUP Problem
- How can I complete a spreadsheet using macros?
- copy color
- Copy Text Only
- referring a worksheet
- MegaStat for Excel
- Excel sorting problems
- rounding in quarter increments
- Excel should allow more options for formatting cells
- Sum If on muliple conditions
- Vlookup text values
- Formula Help
- Count Intervals of Filtered TEXT values in Column and Return Count across a Row
- Advanced Lookups
- Need help with Combinations, told to come here
- cells will not accept decimals.will not allow any retype with deci
- how to copy just the number that a formula creates
- Using autocomplete
- format-row-autofit not working
- Function to write out numbers
- ISBLANK Formula Help Request
- VARIANCE PERCENT
- automatically copy data from one worksheet to another
- Random Number Generator
- Question regarding dynamic range setting
- coping a formulas to another cell.
- Question for use of offset and range
- Digit seperator
- multiple and round
- another simple problem...
- How do I hide a combo_box on a condition?
- Template for printing-orientation, header-footer setup
- How do I get data to automatically flow to another sheet? excel 20
- Let me see if I can explain this...
- Returning expected dates
- Conditional Formatting
- Copying chart to another sheet
- Changing case on mailing lists I receive in Excel 2003?
- How to Use Group and Outline function when locked sheet
- Conditional Formatting
- Create Windows Directories from column entries?
- Cell Reference, Multiple Sheets
- Calculate matching cells
- sharing a macro
- collecting cell data from every 33rd row
- worksheet sorting
- cells will not calculate
- RE: Excel Doctor
- Conditional Formating
- sumif function with a difference
- Retrieving non adjacent data from other workbooks?
- can I make worksheet name equal a cell
- having the same workbook in different file
- width of column is zero
- Indirect used in an array formula
- what is '
- COUNTIF Bug in Excel 2003
- Excel Doctor
- help with spaces in funtions
- product calculation in excel
- Match function...random search?
- Using Wildcard characters in sumproduct
- How to get reult in text
- Move a Column of 500 Email Addresses into BCC Field of an Email
- Store max value of changing cell
- reference #value error
- Random Numbers
- Can I HIDE cells with a conditional argument?
- large binary numbers
- calculating term of financial transaction
- Numbers
- Same row different Answer.
- Making Font Color Changes in IF Statements
- Custom Cell Format Will Not Save Correctly
- I need to use a number in one worksheet to match text in another
- Finding a character type within a cell
- reverse week count calculations
- Can't get an Excel spreadshe doc. to export into Oultook Contacts
- summing up contents on ceratin cells depending on selection criter
- excel
- DAYS360
- Suming up a Lookup
- Autoshapes and objects disappearing
- How to automatic calculation and macro execution between 3 workbooks?
- Using Search with either vlookup or match and index
- Printing data validation scenarios
- Sum error
- average annual return
- Get Past the 7 Nested IF limit
- How can I copy cell formats in functions?
- Using cell references as text in a formula
- Can taxes be totalled on separate sheet when using Excel invoices
- PDF file into EXCEL
- countif function
- How to solve y =f(x,y) using matrices?
- How can I count items in a filtered list?
- format cell based on results of vlookup function
- More sumproduct/table multiplication help
- Dates and times with PST,PDT
- Dynamic reference to workbook
- How do I break links in a workbook?
- Percentage Calculation
- I need to count while using multiple criteria
- How do I get a hyperlink (entire row) to data sort alphabetically
- find a sum from a list of numbers
- Shadow current field box as it moves?
- Can I lock a row so that it's always the last row on the page?
- I want to correct a #div/0! error but the IF function doesnt work
- Conditional Formatting
- How do I copy a reference formula onto multiple worksheets
- Date controlled function execution
- Question on Vlookup
- How do I apply a % +/- to a range of figures please
- sequential numbering for invoice
- Probabilities, random numbers and dice throws
- Drop down box
- Help with this formula!
- sumif help
- Lookup on different sheet
- Pls Help Me!
- list to table
- How repeat numbering for raffle tickets eg. 000001 - 000001
- Lookup across 2 or more columns to match a row
- SumIf
- problem with #value!/zero
- Desperate Help needed with a function.
- Calendar template on Excel
- Complicated sumproduct help reqd.
- consecutively number cells in a column range
- Some formulas need file refresh in same worksheet
- how do i shift from tab to tab using keyboard(same file)
- Conditional Formatting on Whole Numbers?
- How do I auto change text colour in excel to reflect the value ent
- Drop AM and PM from date
- Comparing Data
- How do I remove a date at the bottom of an excel sheet?
- Conditional Formating with Checkbox
- Filter/find/isolate one specific term?
- pivot table
- Search for specific words
- Determine which cells from a specific range equal a certain sum
- How can I show the total sum of items in a filtered column
- Excel Grouping
- Lookup??
- Combo Box
- Average Non-Continuous Cells Without Zero's
- I need help with an folmula for hunting / matching names and value
- Insert a new worksheet after subtotal
- Assigning Macros to Buttons in Excel
- Linking Entire Worksheets
- can macros change cell color daily, i.e. green to red everyday?
- I need help with an "If" Statement
- Comparing 2 worksheets
- pivot table sorting
- Re: hyperlink help
- Average Time
- using a file dsn in sql.request to connect to sql server
- adding values based on criteria
- Re-Calculation on a single worksheet
- VLookup
- Is there a help on the TABLE worksheet function in Excel?
- text and numbers same cell and formulas still work (like lotus)
- Simultaneously change values in multiple cells?
- vlookup more than one exact match
- Vlookup across multiple tabs
- How do I get rid of the #DIV/O in a cell?
- lookup specific character place
- Cell format
- Function help!
- Index Row and return data in a Single Column
- Combine several spreadsheets for an emailmerge (perhaps using Acce
- sort by SUMIF results
- how do I calculate the annual interest when I know the compound
- conditional formatting with formula
- If Then Lookups - If Someone helps me, Then I will be happier!!!!
- #div/0 Error
- Sum and Skip Negative Numbers
- Subtract Hours
- How do I LOOKUP text values
- Date Calculations
- Variable Input Range for Combo Box
- Compare cell value
- numerical value of a letter
- Setting All Worksheets To The Same Scroll Position
- Avoiding the dreaded #div/0 error
- Change case...help please
- enable commentaries when is protected
- Excell Formula
- Excel If then Else function in Worksheet
- LOOKUP funciion giving an error
- using Goal Seek inside a recorded macro
- MS Excel Data function missing
- Setting up some sort of cutting and pasting loop
- trying to import excel database into outlook need to name ranges
- Finding the minimum in a selected number of rows of the same colum
- refresh auto filter
- excel spreadsheet with e-mail notification when due date arrives
- Automatically Enter Data
- if else construct
- random numbering
- Copy sheet 1 data to sheet 2 cells.
- If Then, not using values, or not counting blanks
- Can I use excel to find y = f(x,z)?
- Moving one workbook page to a new workbook
- 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?
- Formula problem
- truncate
- how do i use spreadsheets wider than 256 columns?
- move data from multiple cells in one row to another
- Excel database
- EXCEL worksheet
- I've tried Sumproduct, SumIf, Vlookup and Hlookup.
- Conditional Formatting, date.
- formula problem - UK national curriculum levels
- Auto Update
- formula help - Is this possible?
- find-replace box should not float but be fixed line on tool bar
- Creating Text lists
- Subtotaling based on more than one group
- How do I check for existence of a worksheet?
- Excel Function To Access
- Is there a function for a 'year to date' sum
- Referencing cells containing tab names?
- Looking for a way for excel to count unknown repeating values?
- How to automatically capture a tab name in a cell?
- Cell Protection
- Algorithm Challenge
- Calculations on only a selection
- IF, THEN statement
- Return data from multiple cells
- How do I change the number format within the concantenate function
- Group values
- excel worksheet
- how to combine the multiple rows into one rows?
- If, Then Function
- Question on using time in Excel
- How do I ignore values while copying from hidden rows?
- VLookup for multiple values!!
- index & match with links for updating to other workbooks
- index match formula
- create a list from 2 sheets
- What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??
- Help with sum up or down in cells
- how do I set up a pricing template in excel
- NETWORKDAYS
- comments in excel
- replace function
- How to copy the data in row to column?
- Formular Question
- excel paste special should allow text
- Create summary based on specifc value in a different sheet
- Conditional format with a formula
- Can I Find one word in a formula
- Listpro
- Multi-condition vlookup
- Data parsing question
- Count if 2 conditions are true
- Tab key movement Excel 2002
- Making mulitple IF statements.
- Cells with a value between two dates
- vlookup in a pivot table
- Show in Z the last entry from A thru N
- Excel: match two cells in one sheet to two cells in another and return a third cells value
- Problem in using Vlookup (1st time user)
- Why are cumulative interest payment calculations different?
- COUNTIF temporarily missed some cells
- cell links
- using VLOOKUP to compare 2 columns to find new information
- How to lock worksheet and still able to click on grouped rows
- Totalling formulas
- excel formula to convert lat/lon degrees to DDD MM SS.SS?
- Count if number between two numbers in Excel?
- Conditional Formatting
- percent change
- sort list of players by team from player list on separate sheet
- Consecutive Numbers down a column not to Exceed 49
- I need to merge lots of info, w/o copy paste?
- Indexing a row
- How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd?
- first value > 0
- Wildcards in functions
- lookup help
- IF and MIN functions
- calculate the number of days from date received
- AVERAGE problem
- Problem with compound IF statement
- Validate Cell contents in formlua
- Comparison
- Merge text list
- Printing
- LOOKUP
- Macro Question
- Ranking
- Complicated lookup function
- Combo Box View
- Microsoft Excel Spinner's
- Counting Duplicate Entries
- DOnt calculate leap year
- trouble filtering a list. Why isn't column filtering?
- text formulas
- Can I create a dropdown that will show a 2-month calendar?
- SumIF is not working
- Array Function
- How do I compare data between spreadsheets?
- Formulae
- macros
- Multiple text boxes selection
- Text from text box to cell
- Same Name refers to local ranges
- CURRENCY INDEX FOR EXCEL
- mixing text and formulae in same cell
- How do I change a cell's contents to it's formula's value?
- How do I sort dates stored as 1-Jun-05 in order of day & month
- .wb3 file convertion
- perform calculation only if current time is after 10 am
- datevalue
- To leave the cell Blank
- How do I please.
- quatro pro to excel
- Issue with sumproduct
- My print preview is only showing one page to be printed
- Why does the Sort function stop recognizing Header Rows?
- Merge files & sorting data
- Thank You both! n/m
- Data Validation
- match cell in array1 with all cells in array2
- Help keep incompetents in business
- HELP!!! On SumProduct
- copy numbers progressively
- count date ranges
- Why help?
- Rounding numbers to the nearest 5 or 0
- Timer function needs improvement
- Need Formula for Last Occurance
- Page Numbering Function?
- Using non defined names from another sheet
- automatic filling in cells in excel
- returning a count if two conditions are met
- How do I filter names using only the first letter?
- my formatting changes do nothing to the data
- Displayed contents of cell in target row if column criteria is met
- Answering a question in a cell
- Concatenating a cell address
- Using Excel macros from Vision objects
- Need formula for a fixed cell minus last entry on ongoing log
- This is Weird - Dead Simple Issue with Sum Function
- culmulative calculations
- Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns
- Comment
- why does my excell worksheet start with only a gray view, no data
- can i get excel to add variables
- Progressive Addition Formula
- PIVOT TABLE?
- Identify Numbers
- HEADER ?
- INPUTING TIME FORMAT
- Help with Formula for Text Entries
- Quarterly tax percentages
- summary of customers?
- recursive sums
- Vlookup With A Twist
- our cost to customers cost
- Workday Function Question
- how do i set up my main categorie row to repeat on other pages
- Sumproduct based on substring?
- conditional formating....
- Problems using a variable as a Table_Array in VLOOKUP
- Sorting
- In Excell how do I just type in an amount w/o it inserting a $
- Excel fields in a row instead of column...
- excel formulas with text
- Macro help???
- GO FROM ONE WORKSHEET TO ANOTHER WITHOUT CLICKING
- VLOOKUP problem
- IF A CELL HAS THE VALUE OF 0, I WANT IT TO GO CHECK THE NEXT ONE
- hh:mm - mm formated 2 round to .25, .50, .75 & 1
- Countif Function
- Daily water meter readings
- ASCII extended set is different in Excel, than MS's Website?
- How do I format 1 column of alphabetical listings into 3 columns?
- Stock Update
- Variable Column references
- creating an invoice for work
- SUM every other 14th cell
- How I need correct formula, that no t rounding?
- return zero from a blank cell
- Sorting Data from 2 sheets, one sheet which is already sorted
- sort 2 or more rows of cells linked to one row of data
- Changing the color of a list entry based on a tolerance
- If with a range
- Need Help with custom function!
- Show Dollars in Millions
- What cells in a array equal my value?
- Formula between two worksheets
- Finding min/max of adjacent data in a range of cells
- Using average in two condition arrays...
- Move between worksheets
- RE: Question regarding how to search a column and print a row(s)
- Need Subtotal Help
- How do I display the tab name in a formula
- Is there a way to transpose and invert the order of data in Excel.
- converting from lotus 123
- Count the occurance of a value x a value in another cell in excel
- What is the purpose or why would I use watch cell?
- Bonus Calculation problem
- How to calculate a pay-back period by the accumulated cash-flow automatically?
- adjacent data count from a binary column
- common entries between 2 columns
- Automatically transpose when pasting data in excel
- Bars in a chart???????
- Dates
- Choose data from a particular column based on a specific value
- How to reference to the previous worksheet regardless of title?
- Getting timestamp from a file in Excel
- format method
- Searching TEXT in formulae, rather than results of formulae
- save as webpage?
- time subtraction problem
- Renaming multiple sheets
- A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
- How to convert the dates from the YY:DD forma to MM/dd/YYYY format
- Is there a formula for IF a cell CONTAINS certain text...
- Sum Multiple Criteria or DcountA
- Finding the first blank or zero value
- Value 0
- Re: Question regarding how to search a column and print a row(s)
- I have forgotten my password and have no excess
- Function to calculate the number of years, months and days between
- Incrementing a worksheet number in a formula
- Incrementing a worksheet number in a formula
- Sumproduct
- our cost to customers cost
- Calculating the sum with multiple conditions
- lookup function 1
- Turn off cursor from automatically highlighting cells in Excel?
- To have the cell blank please
- get total hours from 2 dates
- How can I force a worsheet to recall functions.
- conditional autofill???please?
- Am I asking to much from vb codes?
- vlookup returning sum
- Create a button in excel that can open an outlook appointment?
- Date conversion
- To show blank please
- vlook up
- Recording simple macro
- Set a cell to have a pop-up calendar for date selection in Excel?
- ???is there a way to keep one row in view while scrolling down???
- How do I open multiple hidden worksheets all at once?
- Limit of # of tabs
- How do you...
- How do I Provide a specific result given multiple criteria?
- The # in my vector is absent from my array. Can I make it 0?
- Is there a way to average if in excel when looking at a range of d
- Is there a function that will return the page number?
- Can data from one ws transfer to another IF cell has text?
- If statement
- Sum func. is adding cells not in specified range
- Conditional Filtering
- I need to put text after the value of a referenced cell (=B4'MS')
- Calculate sum of numbers with conditions
- Using the autofill function but increment by certain number in function
- Using a Formula in a Conditional Statement?
- How to calculate values in multiple values with multi conditions
- IF function
- how do i keep a time/date register of every change occurred in a c
- compute values in a range
- functions 33242
- If a cell is blank do no let a user print or save?
- "." & a "+" added 2 a table reformatd as text in Word???
- Excel 2003, Insert Function, create full name & descriptions
- Date X Data
- mapping with excel
- Filter by Color
- Purge functions leaving only calculated data?
- Validation Based on a Date
- reduce a balance from severel cells
- Return first 'n' characters
- How can I capitalize multiple cells that were entered in lowercase
- Is it possible to have multiple splits in one worksheet?
- future dates
- How to Add a Calculation to a Pivot Table ?
- index / match /lookup ? help
- VLOOKUP blows up file size
- lookup value froma filtered list
- Column of check boxes
- funcation
- Sum function for non-continuous range
- Vlookup for 2 items
- Match and Index
- Can solver do this?
- two worksheet linking
- apply autofilter to more than one table
- How to fix a link in excel
- Transpose Macro
- Function help please
- Levels in Subtotals
- Conditional Sum by Row
- How to filter 7 columns in a 20 column spreadsheet?
- Time functions, how do I work out number of hours
- DB (depreciation) function Help question
- interest only
- How do I create ccolumn headings diagonally?
- vlookup returning a n/a result
- Filtering by criteria in two columns
- Help with Formula
- Display latest date in a column
- Desktop file sharing
- Running a Macro automatically from Excel
- Converting Time Data
- formula
- Linking and formatting multiple worksheets
- Arithmetical Mode of Criteria in Multiple Non-Adjacent columns
- I Need to Count Number of Entries Based on Two Criteria
- GETPIVOTDATA -- How do I shut it OFF!
- Count Not Appearing when using AutoFilter?
- MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how?
- adding values with text
- Concatenating Functions
- Second appeal for help
- calculating number of days (e.g., Mondays) between two dates
- Array Formula w/ Multiple SumIf Criteria
- How do I change dates in student attendance?
- if a1 value changed then date in b1
- Interest only payment
- Re: Finding number of particular days in a period
- How do I turn off automatic date function in XL?
- Match Formula
- highlighting a change in value
- calculation to exclude weekends
- comparing lists
- Reference
- Printout doesn't match screen view (columns wrap differently).
- How do I multiply a whole column by a number?
- row and cell reference
- Validation 'Jump To'
- Duplication of function
- VlookUp that does not return #N/A
- How can I use a time difference in a subsequent formula in Excel?
- Removing a page break from excel
- Plotting daily changes
- How can you jump to a selection in a validation drop-down?
- More Multiple conditions
- text manipulation
- Worksheet tabs viewing there of
- Change row selection
- How do I delete all named ranges in a sheet at one time?
- Figure out the hours worked for the week
- Date function
- Absolute Reference
- How do I limit what text is displayed?
- How do I remove all text in a cell after a specific character?
- Count names
- Using autofilter and excel form format
- a cell reference in a 3d reference
- Time between two dates (Excluding Non-bus Hrs)
- cell validation even for values pasted into cells
- Multiple conditions
- Modify a Formula to Display Blank
- details of month
- How do I make a calculation?
- consolidating workbooks
- Date range criteria and Pivot tables (again!)
- Help! Formula to find the address of particular value in sheet
- how do i convert from rands to zambian currency
- How many different customers in a list?
- Counting the number of rows
- How do I test for a prime number?
- Start spreadsheet with WinXP start
- Sorting into quintiles
- how do I test for Integer?
- Calculate the difference between two times
- Calculating a sum of various lenght
- How do I sort addresses in excel?
- Setting formula to give info from rows with certain criteria
- transfering numbers into teams
- Cse ?
- DSUM with External Database
- unrestricting drop down lists
- Validating email address formatting
- Is this POSSIBLE IN EXCEL ?
- Pivot -- want to use Max and Sum in same table
- Offsetting the Rows of a VLookup Result
- How can I add a percentage sign to a cell with data validation
- Adding times
- 30 Arugments limit- SUM, AVERAGE, etc.
- perform caculations on displayed value in Excel 2000
- referencing another worksheet
- freeze panes
- How do I show dates older than present date?
- F4 key does not toggle relative/absolute cell references.
- Perform the square root function in excel.
- Explain return of #N/A
- To Biff: Using Match with multiple criteria
- Rounding currency.
- searching for a space " "
- Need Function for Double If
- Help: I need a function for finding next cell vertically with value
- finding data
- EXCEL
- Calculating percentages in pivot tables on subtotals
- toolbar for "standard tickmarks"
- Using functions to paste from one worksheet into another
- label caption equal excel value
- can I put a note in an excel formula
- Lookup or Match ?
- Sum & copy color format...?
- Substitute for Pivot tables?
- Excel Rounding Up to Nearest Multiple
- I have had difficulty in creating user defined functions in Excel
- Excel will not add cells automatically together when selected?
- can it be copied instead of referenced
- Pivot Tables
- Negative Working Hours
- can anyone help with repeating the same action on different ranges?
- Copy VLookup Values
- Generating a table
- Sum product help needed with an extra variable please and thankyou
- In excel the sum is not calculating
- Count how many "name" in a column
- future dates
- Import Format Using Vlookup
- Can Vlookup check a cell to the left?
- AUTOMATIC SORTING PROBLEMS
- Filling excel entire row/column instead of single cell from an array
- autocorrelation function (ACF)
- dynamic cell references
- countif function
- formula to populate while skipping blank fields
- can't figure it
- Can excel give value in words of number entered in another cell?
- how to convert Lotus 123 to Excel directly and can running normal
- In a protected worksheet allow users to delete rows
- Function for more than 1 criteria
- How do i change the date 6302000 to 6/30/2000 ?
- I am trying to figure out how to add per 1000
- how to get the number of days between two date formatted fields in vba for excel?
- Macro's
- sort dates by day then month, not by year.
- SaveNClose
- Leading Zeros and decimal points
- how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet.
- Sum Count of Single Criteria in Multiple Non-Adjacent columns
- PMT function
- renaming copied worksheets deleting .xls]
- Same data box on two pages?
- Using Match with multiple criteria
- is it possible to select and change the values of cells in a minimized excel spread sheet from vba?
- Sub SaveNClose()
- Duplicate P/N and sums
- average
- How do I view a JPEG file from data selected in Excel
- Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA
- Compare 2 columns to see differences
- countif
- Blank cells
- autofill next sheet with next set of dates
- how do i solve 'file not found' error when linking notebooks?
- how can i assign i set of numbers (1-16) without repeating them?
- Function for Rounding of Number
- Auto Filter not showing all data
- change data source for many queries at once?
- Enabling sub menu items via vba
- Counting months
- Ingoring text in a formula
- Text To Columns Function
- Can I find and replace "white space" in a cell in Excel?
- What function(s) to use?
- difficult calculation
- convert interval to various separate date , time, hr, minutes
- How can I use the random function?
- Using VLookup and typing in values to be "looked up"
- Nested Formula
- How to combine text from multiple cells?
- How to get number of rows which match criteria
- can excel convert number into words (like 10 to ten)?
- Problems with .Refresh BackgroundQuery:=False
- How do I produce a centroid fit to excel data?
- The formula Watch Window in Excel should allow more than one row
- Find the combination of numbers that when added equal a reqired total??
- Using sheet name in formula
- Formula is missing
- print area poser
- excel printing
- Adding text in formulas
- Un - Concatenate?
- histogram for time values
- Help with a Function
- Can I set more than three criteria for conditional formatting?
- link from one workbook to another workbook using a dropdown?
- Part Number Lookup
- Need formula that reads value and then displays value from same row, different column
- random number without repeating?
- counting diffeneces in range
- Confusion on adding percentage of cost to that cost.
- CMD Button Help!!!!
- FORMULAS
- How Do I reverse axis in a spreadsheet
- formulas in pivot table
- printing problem
- How to calculate and then show up as a percent?
- solving for all possible combinations of a set of numbers
- header row
- Function to Count Number of Consecutive Rows with a Specific Criteria?
- Do I need a formula or Macro?
- Help with drop down menu
- USING INDEX AND RECIEVING #VALUE ERROR MESSAGE
- how can i design a 2 page a day diary / appointment book
- compare time in IF statement
- protection and inserting rows
- VLOOKUP from another sheet, VBA
- List Query
- IF previous cell value is < 0,(neg)then add it to this cell value
- Help please simple drop and drag I can't make work
- total subtotal cells
- sum function for minutes and seconds in Excel
- sorting whole numbers
- totaling figures in colum
- how to overwrite a value without loosing the formula?
- Find then If then Replace
- Find then If then Replace
- INDIRECT Function impact on Copy Worksheet
- How to create formula to convert?
- calling a new function Excel gives me #NAME?
- sort ascending tab is not active. Why?
- EXCEL - Please add a date format - yyyy mmm dd (mmm being letters
- Help formating Cells
- Problem with an "if" relating to a range
- How to add the 10 smallest numbers out of a range of 20 numbers.
- a problem with if invovling a range of cells
- sumif depending on 2 cells matching
- Paste Special
- Excel bug?
- Comes up #n/a, what do I do?
- Help with adding certain cells using an IF function
- linking workbooks
- Auto sum does not add inserted figures in colum
- Help with values
- index match with blank entries
- Linking worksheet event codes
- how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit
- formatting cells
- retrieve text from merged cells
- Cell Refences
- why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?
- What does ScreenUpdating = False do?
- Auto date/time insert when data entered into an adjacent cell
- Trim cell contents
- Sumif with criteria list
- Create a function wher last digit is always set
- California rollover Paid Time Off tracking - any templates availa.
- How do I compare 2 sets of data and highlight differences?
- What Excel Formula = finding dup records and removing them?
- mailto addresses
- What is the correct function to use, please?
- How do I reverse the order (sequence) of a column of data in Excel
- create list of unique values from a column with repeated values?
- VLOOKUP and ISNA functions
- SumProduct or CountIf
- Repositioning the tabs
- Imported Date & Time format with calcs. managed in excel from imrp
- Not filtering entire Database
- How do I use a cell value as the filename in an external link?
- Excel
- Comments Not Always Printing At End
- Can I format to always AutoFilter specific cells
- Function Bug ?
- Maintaining Protection when copying
- using sumif formula: but requiring satisfying 2 if statements
- Quick Little Function Help...
- Counting question
- What does 'cell("color",A1)' do?
- Conditional Sum Wizard
- calculate future date
- Headers on every worksheet
- Establish a Branch of Clayton College here in Malaysia
- the value of Text?
- Extracting Text from the right
- determine if a cell changed value
- SUM of Hex?
- want blank - not #N/A
- How do I copy formatting from 1 sheet to next in same workbook?
- How do I count occurences in a date range?
- Sums according to the content of fields
- formula that if ex. G4-G5 is less than zero = zero
- What happened to "Tab Color" for worksheets?
- calender in diary format
- Discount calculation
- Select rows of data in a worksheet on one criteria in multiple co
- =sumproduct((f5:f498=(cp5:cq5))*(e5:e498=(cp6:ct6) )*(m5:m498))
- Convert "800" to "8:00" or "08:00"
- A Challenge
- Named Ranges shown (or not shown) as blue means what?
- Running total
- Can I have a progressive number in the same cell when printing?
- Remove Time Element of a Date
- [XL] Edit Mode of formulae should be improved in legibility.
- Why "datedif" function results sometimes negative numbers?
- Running Total
- how do I use a cell value as part of a cell refereren in a formula
- Format to Thousands and x-foot the sum
- running total
- force excel to run in only one process excel.exe
- Summarize Out of Stock List
- Change General Format to Currency Format
- How do I make hide detail buttons in Excel 2002?
- in vba for access how do i get the day of the week for a date field?
- cell hililte
- MSNStockQuote Function Parameters
- I need a Formula, Please
- Random Number Generator
- Links to other worksheets
- Doing a grouped search in Excel.
- Different quantities of a certain item...
- How do I make all data in the formula bar appear in the cell
- Shelf Life Percentage
- Can this be done?
- How do I put each member of string concatenation in its own line?
- CTRL and END function
- IF function
- evaluate data by week number
- In excel, what does the esclemation point (!) in a function mean?
- can I format dates older than 1900
- another language in MS office at home and another at work
- How do I copy formulas from one wkb to another w/out linkng them?
- Create a list in one worksheet of the other worksheets' names
- How do I copy formulas from one wkb to another w/out linkng them?
- sumproduct between two dates
- Consolidating sheets
- Advance Filter Criteria
- hOW DO I
- Can Excel recognize when data is entered and apply formulas?
- Add cells from a range based on 2 conditions from 2 other ranges
- Cell and Sheet Reference/Return
- Nested Funtions
- Rate formula
- Multiple IF criteria
- Can I have different column widths in a worksheet?
- filter and delete
- EXTRACT TEXT FROM TEXT STRING
- Dynamic Arrays
- control-tab should move between Excel sheets without a mouse.
- How to create summary of expense report?
- Macro to Modify Pivot Table for Color and Bold
- Data Validation
- Sum IF function
- Limit or Exclude cells in Average and Sum formula
- Very simple, but difficult formula question
- Does a highlight row comand exist for Excel conditional formulas?
- Formula given three answer choices
- Copying cell values once and then making them static
- how do you find the SD(standard deviation ) for the multiple reg
- pivot table
- pivot table
- How do I translate from 5Row/20Col to 20Row/5Col ?
- n/a in vlookup/index/match formula
- Categorize drop down list
- i need to be able to add #'s in a spasific column togather
- Drop down lists
- formula to change 1 to a / and still add
- Return cell reference of lookup value
- Help with countif on multiple worksheets
- Data Validation
- Confused about arrays and ranges in functions
- Simple function problem
- Insert more than 1 Row Syntax
- How do I refresh the formulas in Excel?
- Can I automatically hide or filter a row?
- Quick formula question
- help with the countif function!!
- How to use a conditional function to insert an autoshape?
- updated running total from previous pages
- How do I filter a number list by numbers to the right of the decim
- Index needs a little help
- how do i comment 1000 lines of code at once in vba for excel?
- Can cells containing linked formulas be identified?