- Multiple functions per cell?
- How do you ...
- data tables in Excel
- Sum Count of Two Numbers in the same Row
- Excel Formula please
- How to sum items from column A only if Column B row equals X
- Inserting rows
- Count matching cells
- Quick-keys for FILL color?
- SUMIF Function Inside SUMPRODUCT Function
- cell to show ' 0 ' , or nothing at all, if the sum is a negative number
- Text Functions,
- Copying formats - column widths, formats, outlining to worksheets
- Excel Templet purchase order multiable pages
- Compile list of same cell from multiple worksheets
- Multiple Substitutes
- LOOKUP command
- Sum of Range of Cells
- What does @SUM mean?
- Enable Macros
- Exclude certain cells from printing.
- Conditional format of minimum number
- HYPERLINK IF referencing the cell of the function..
- Using MATCH() for an exclusive find?
- What does a $ in an excel formula do?
- Excel-Master
- Date Formula
- excel help
- COUNTIF - multiple conditions
- List of property names and values for a given object.
- SUMPRODUCT Acting Quirky
- creating and moving hyperlinks - Please help!!!!
- Automating Worksheet Names
- Return employee name when the employee's number is entered
- transfer information from one worksheet to another using a butto.
- Vlookup function question
- Macro Template File
- Custom menu
- lookup help
- Help With HLOOK
- 'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT'
- VLOOKUP on separate file: Works fine for a while....
- A bit of a Stumper
- Macro Help - Copying and appending data
- Collapsable Rows?
- How do I increment a formula?
- changing cell colors with formula
- Formula to determine whether number falls within range??
- Separate address column to Five columns
- Permutation in excel
- Rational exansion of a decimal number
- COUNTIF With Non-Continuous Cells
- Time Sheet to show hours owed
- Protecting Cells
- Permutation in excel
- Some help needed
- Percentage formula's
- Software to create color coded maps from excel?
- Finding Duplicates
- multiple pivot ranges
- need 360-day loan amortization excel spreadsheet template
- Rolling Balance after 30 days
- Need date to appear 90 days later than initial date entered
- Creating Scenarios and Scenario Manager
- freeze content
- Validation from Database (not sorted)
- How do you update links
- filters logics
- Find function
- INDIRECT FUNCTION jams?
- Countif function
- Find function
- use if function to change cell color
- create an array with unique items IN MEMORY
- dynamic connections in excel?
- random combination of letters
- Counting with Array Formula
- How to find MATCH numbers ?
- fill handle + query
- Can I get excel to auto save details from a cell into the doc nam.
- multiply the value of a cell
- How can I get rid this value "#VALUE!" in the cell
- Excel formulas
- Worksheet terminology
- how can i change the row from 123 to ABC
- If Then Statement in Excel
- Excel, Need some help
- Copy and paste from one spreadsheet to another
- Vlookup to find Second INstance
- blank cells
- Max Lookup formula
- Format a cell for hours ' minutes "
- Can Excel send alerts when due dates are not met?
- How to identify entries in a matrix also present in another list
- help locating first empty cell in a Column
- HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET
- Indirect function - Limitations
- Please help....
- In excel, how can I create a towards column in a single box?
- A calendar calculator template that reflects remaing weeks in a ye
- Formulas not recalculating when values change on another sheet
- Counting number of occurrences
- Autofilter - can I increase the drop down font
- Cell value & hyperlink
- Another IF question
- How did excel get de-installed? Got error mssg: CiceroUIWndFrame
- I can't delete columns - help!
- Macros for the AR Aging Workbook template?
- converting number string to number with decimal
- Auto populating fields
- lookup returns row number-why?
- The number of hours in a day cannot exceed 24...
- Allow unprotected cells to spell check after sheet is protected
- Summing on multiple conditions
- Sumproduct question
- Moving Around a Blank Spreadsheet
- Help
- IF statement
- If Or?
- Using Sumif with 2 conditions
- Locating Last Nonzero Cell in a Row
- Populating several cells
- Limits of MINV matrix function
- Problems with an IF statement
- Ranked list
- HELP - Date Range In 1 Cell Calculation
- Downloading documents
- concatenate strings
- How can I use like a mail merge feature in excel to create a form
- How do you calculate CAGR In Excel 2003 with no initial cost?
- count unique phrases in a word table or spreadsheet
- Columns
- counting comments
- Average based on Hour
- Compare Side by Side in Office XP Excel
- lookup based on a row number
- select lines from multiple worksheets and write to new worksheet
- Hiding a row if date is filled
- Help to adapt Formula syntax to work with Visible Filtered Cells
- How generate trendline equations for Power, Exp and Log trendlines
- how to get rid of #N/A
- combining data
- Conditional Formatting
- Date Creation in Cell
- COUNTIF or not to COUNTIF on a range in another sheet
- how could I import a text file with comma separated values into ex
- how to use input formula from several worksheets in excel?
- combining 2 pieces of text from 2 columns
- Formula error in merged cells
- data validation list should have opt. to select based on criteria
- Print only cells with values
- Linkage data between two spreadsheet
- How do you add a-z (alphabetically) to your toolbar in micr works
- Make boxes apear on paper?
- output based on data in a graph
- Page Header
- Search feature in workbook
- Getting the first 3 digits out of 6 digit cells?
- Can't get list in Document Contents for workwheet
- drop-down list validation won't allow a different worksheet
- options under tools dose not come up
- Formula Assistance Required
- How do I define "contains' as the default custom filter?
- how do i get this
- Finding DUplicate Data set in Worksheets
- Locking a table
- Formula to determine number of Standard Deviations based on % of population
- Complicated lookup/match fuction
- Opening multiple Excel files that contain varied selected sheets
- What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
- Sales League table
- Comparing Two Spreadsheets
- Locking cells after one answer
- Help with formula
- calculating number of months from today
- countif
- Date functions
- how do I keep the dropdown list button visible continuously
- Excel 2003 Subtotals not working correctly
- Using countif with 2 conditions
- Can I use Excel to create this text file?
- Locking format
- ranking
- Value of a Cell by Time
- Forecasting weekday occupancy between two years
- matching numbers in col a and col b
- Preceding a number by zeros, that is still a number
- Couple of hopefully easy questions
- using linest to generate 3rd order polynomial coefficients
- Help with formula please...
- looping through a set of calculations
- I cannot convert using HEX2DEC formula? i need a plug in i think?
- Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
- Adding Cells
- drop_down_box
- What is the shortcut key for adding $ to a cell reference eg $c$3
- =max(range includes #N/As)
- Changing positive figures to minus figures
- Optimizing mortage payback
- How do I get it to insert addresses instead of Next Record?
- When I move a vertical border it deletes horizontal borders
- add a column only if 5 other cells on the row satisfy criteria
- Vlookup Headache
- search value in a table and sum another column
- one formula to make a multiplication table work
- having a two tables on the same page with different widths
- Filtering Columns to Align Matching Data
- How do I count a value if another field = a specific value? Excel
- tab scrolling buttons not responding
- tab scrolling buttons
- Very Frustrating - Please Help!
- Converting CSV files into Excel files
- I Need Help with complex formula ?
- Avoiding #NUM!
- freeze other columns when columns have been frozen already
- dynamic defined ranges
- Vlookup for data contained in a cell
- Excel chart problem
- mixed font styles in the output of a formula?
- Sorting Identical Data set in a work sheet
- Need to compare 2 tables to generate 3rd table
- Need to get rid of blank rows without sort
- Need help summing time
- Cell references
- HELP ASAP get rid of blank rows without sort
- formatting dates
- Creation of a Generic Macro
- RE: Cell references
- RE: Excel chart problem
- Please Help and Thank you!
- Matching data using date criteria...
- finding name within range
- Word Associated Shading or Color
- numbers
- Calculating two numbers in one cell
- vlookup over 2 sheets?
- Dates Not Formatting as Dates
- lookup cell content in multiple files
- Retuning a column number for a specific value
- trouble shoot pointing to a cell
- How do I change where Excel looks for templates?
- tab scrolling buttons - excel 2003
- is there a "distinct" function native to Excel
- Can excel sort entire rows of data like access?
- Lookup question.
- Help One Way did not work
- SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL
- Conditional Formatting that will display conditional data
- formula change
- RE: Lookup question.
- Multiple If Statements
- VBA - Do not allow duplicates
- Adding numbers in a single cell
- HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES
- Look up problem
- European date formats
- Comparing ranges and deleting
- extract data Column 1 starting with A1, A4, A7, A10, etc.
- Macro
- *HELP NOW PLEASE*
- How do I split a cell of 2 words into two cells
- how do i find # hrs & mins. between 2 different dates and times
- Contains instead of Equal
- Calculating Time Values in Excel
- Help Needed Urgently
- Conditionl Format
- Connect columns, with restrictions
- Count "how many in a row"
- Adding time Values up in Excel
- format column for unique values only
- how do i move from one column to another after a set condition
- move from one column to another after a set condition
- How do I stop Excel from treating blank cells as zero?
- Make a formula that adds every 4th cell in a column indefinately?
- Complicated lookup/match fuction
- Copy and paste from 1 workbook to another
- Display "Last updated date" for the Workbook (without using a macr
- What is the spreadsheet function in excel
- Non-random numbers generated by excel's data analysis random gener
- Whats the best way to...
- Counting cells
- Subtotal results without word "Total"
- how do i calculate time in & out in excel using a formula
- Frequency of values with Criteria
- If typed 12805 then 12/8/05
- link help
- How do I sort entire spread sheet. Names w/data
- linked cell is displaying formula instead of the data
- Your online office "help" system REALLY sucks!! I'm not kidding!!
- vlookup almost does this but not completely...
- Delete repeated Cells
- #Value error when linking workbooks
- 2 different Companys. Data Sort
- Information from column to row
- finding if name within range
- Contents of cell
- error N/A
- Lookup
- organizing a workbook
- using getpivotdata function
- vlookup reverts to data from a previous report
- Functions not "recalculating" when input changes ???
- Merge & Center function is turned off...how do I turn it back on?
- using a checkbox for a conditional function
- Copy Cell Referecnces
- Text from Max value
- How do I randomize ascending data (number values) in excel?
- I want to add automaticaly my postponed check in my banking regis.
- Multiple coin flips in a single cell
- Sumproduct not working when summing values between two numbers
- Prevent Worksheet Deletions
- Pivot Table - 'Merge Labels' option and formatting
- Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
- Shared files
- How do I reconcile bank statements?
- How many std deviations is Excel function "STDEVP"
- Locate and retrivie data in table/matrix
- attendance sheet
- Frequency within date range
- File won't open. Error message "too many different cell formats"
- Pulling data from another workbook
- Format single column cells to be 6 characters long
- Pivot Table Question
- Use functions when cells are merged
- Select one of many clipboard item to paste into document
- using filters with the sum function
- how to format only a specific character or number in each cell withina range of cells
- Delete Rows where cells does not meet criteria
- How do I quickly fill a formula result into a column of cells?
- printing problems
- DATEIF Name error
- Complicated lookup/match fuction
- Arrays
- can you filter more than two items in excel 2000
- Workbook & multiple spreadsheets
- Pivot tables and total count
- =CONCATENATE() help!
- conditional formatting autoshapes
- Help with Formulas
- NOT UNDERSTANDING THE FORMULA
- Fill handle formula
- Pivot tables - calculated fields
- Trying to freeze panes. line down and through middle of worksheet.
- Showing Garbagge in my File.
- Interpolation using GROWTH function?
- Fill down to nonblank rows
- creating function (vba) with range arguments
- Protection-exceptions to delete a row
- Copy & Paste macro
- Summing specific cells!
- Subtraction formula for consecutive cells in a column, skipping blanks
- Auto number invoices in Excel
- XIRR function not defined?
- Excel sheet question
- 1430 to 2:30pm
- SUMIF problem...
- Average Function Help Needed
- =(A6)!$O$14 - why won't this look for same name sheet as A6?
- Summing accross sheets
- is there a percent error function in excel?
- removing year from date
- Put comments on a locked spreadsheet even though cells not locked
- if function
- Splitting Character String
- Remove apostrophe
- Need help with formulas
- Dro pdown list formulas
- halves
- Excel formula for monthly interest rates
- Referencing worksheets
- Smart tags for financial symbols
- How do I create a weekly series?
- If
- Compare two lists with two variables
- return a cell contents as the result of usiing "small"
- if statement problem
- Need Help Writing a Formula
- Delete repeated numbers in Excel
- delete repeated numbers
- comparing two columns & then perform a calculation
- Sort from lowest to highest
- Excel should have a tan^-1 Cos^-1 and sin^-1
- display minutes and seconds in excel
- How can I count values greater than and less than certain values?
- Apply cell shading based on adjacent cells in EXCEL
- EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
- serial number cell
- Find and Concatenate
- Range of data within a column
- Another Nesting IF Statement Problem
- Pivot table grouping of dates in row fields will not work. Why?
- Formula Help with Lists
- nesting if statements
- Summing only those cells that aren't hidden
- Random Numbers
- preserve "-" when importing text field from access
- SUMIF excel function not working
- How do you convert embedded drop-down lists in Excel '97?
- How to replace a word with a word from other column?
- counting unique values and matching to quantities
- What formula would I use to get -2 / -2 = -100%
- linear interpolation function in excel
- How to record macro to print pages modified today
- Controlling text in an Excel worksheet
- Concatenate and Vlookup
- Don't know what to call what I need?
- Help with conditional format
- Type in letter return word
- Please assist
- Linking cells
- Function
- Count cells with condition
- Is it possible to put 2 splits on one page? If so... How?
- Using dates in formulas
- My DCOUNTA formula results do not display in Excel.
- keep date format in a Combo box
- Fill-in empty cells from SAP report
- automatically insert row at each page break
- Conditional Average
- VBA Custom function for lookup
- % change in the last two cells in a row
- 27 sets of data. Need to find zero in each set
- Help writing an Excel Formula
- converting a number to English text ( not to Baht) is needed
- Count the number of Cells in one ROW with conditions
- How Show decimal in Bar Function
- How to pluck out initials of a 2 or 3 word name
- Count occurances Problem
- Div/0 error
- NOT UNDERSTANDING THE FORMULA
- return left most part of cell
- Index question
- Excel should let me sort by colour
- How can I get excel to look up prices in a table
- Conditional Formatting Reference / Inserting Rows
- special sum formula
- Evaluating Rank to determine formula
- commission spreadsheet
- IF Function??
- Evaluating results of a concatenate formula, as a formula
- Sumproduct.................
- Determining a specific time during the day
- Regression Statistics are returned as Rounded to 1 vs. several dec
- Close excel do not save
- Check box, then add current time to cell
- text function
- How do I calculate a future date in excel?
- delete spaces
- Using offset more than once on the same sheet
- format social security number
- Counting occurences of a substring in a range of cells.
- Complicated formula
- Compare two different size lists
- if function multiple variables
- Unhiding multiple worksheets in Excel 2000
- Entering Time Macro
- cut and paste subtotal from excel
- creating a excel spread sheet using ffinancial functions
- Looking for experience with counting and conditions in excel 2003
- countif OR function
- VBA function for "Mean" using Array as argument
- How do you sum just values that are bold in a list of values?
- separate text into different cells
- Refer new sheet to previous sheet
- How do I select on two variables in a range of data in excel
- FITTING HEADER ON SECOND PAGE TO PRINT
- how to return mulitple corresponding values
- Warning - "Fixed objects will move"
- Repeat calculations
- Fair Play
- Calculation of full hours
- Function for decreasing salary by 2.5%
- Count cells with specific values in the cells next to them?
- How can we see two different excel sheets on one screen?
- Can a UDF be used on an array of cells?
- Help with a Date Formula
- calculate payment with first payment due date variable?
- Counting .5 in a pivot table
- Count or result of matching cells
- Experienced any problems with nested subtotals using Windows XP
- List box, copy multiple Cells
- Moveing Data to another Worksheet
- How do I prevent a formula element from incrementing when copying
- Using COUNTIF for Counting Words?
- How to highlight an Excel row by clicking on a cell
- Select different source data for a PivotTable
- How to copy data validation utilizing a list to the entire column
- How do I prompt a user to update a cell value (ie the date)?
- return cell reference from any column
- ... Count, <<< Positive Values minus Negative Values >>> ...
- Filtering data and replace on to an new worksheet
- networkdays
- Formulas not updating until save
- countif - Criterion1 OR [Criterion2 AND Criterion3]
- Format of CSV File in export
- Macro help!
- Weeknum & Year
- Insert manual line break in formula
- Extract each item in the list
- Any function for Crop/Cut Text
- Percent of total in Pivot tables
- INDEX and workbooks
- VLOOKUP in SUMPRODUCT array
- #Name? Error when using NETWORKDAYS function ......
- Colour (color) problems
- Vlookup
- Counting Occurrence of Text within Text in Cells in Range.
- How do I convert a given number into a letter?
- What do I need to do here please.
- problems with macros
- Asking for Formula ~ Thanks!
- Verifying Dates
- Translate WEEKNUM result into a date
- Getting Yahoo Stock Quotes by a USer Defined Function
- MODE isn't working properly.
- Financial Calculation Help Needed -- Annunity
- combine the two into a single formula please
- Sumproduct + Array Function?
- Help on Networkdays
- ok for the first but I would like the first 2 Left please.
- ok for the first but I would like the first 2 Left please.
- ok for the first but I would like the first 2 Left please.
- Excel 2000 to 2003 update links doesn't work properly any suggest
- How can i italicize a word via a formula?
- Count Occurances if two conditions true
- Convert Range name in cell for VLookup
- VLookup returns #VALUE!
- Need Help: 'sheets' function with a variable in a formula
- countif >0, specific cells
- finding the right number
- Linking Columns and cells
- Problem with a "if" "then" situation.
- formula for finding a value!
- dates and if statement work on one sheet, not on another
- How do I use space provided for Company information
- How do I get custom views created in Excel 2K to show in Excel 200
- Dynamic Time Display
- Countif not blank
- Need help with lookup on text format
- ActiveX works in my spreadsheet but when sent to others, doesn't
- Counting cells that meet 2 differnet criteria
- Functions not "recalculating" when input changes ???
- Formula for rounding to the nearst eighth of one percent
- Excel Font Effects should include Upper Case
- Re: function for finding a value!
- Sorting by text colour
- Excel: Format Control: 'cell link' reamins constant. How to copy
- Creating Macro or Code Help?
- Sunrise / Sunset
- Import Data
- Formatting cells is not retained when saved as csv file
- Need assistance with printing macro
- Sorting Data
- Can we have custom Column headers instead of default
- Annual interest rate
- running balance in excel
- How do I find a name in a list of names?
- How can I get the domain name out a email adress?
- what is the formula to change 08/14/51 into 1951?
- Count occurances in range of cells
- How do I use VLOOKUP to find values across more than 1 sheet or Wo
- How do I keep with column widths of a pivot table when I refresh
- VLookup on two criteria - Not two dimensional
- excel function help
- sum using reference from other worksheet
- Lookup function, need help
- Automated file name retrieval and updates
- Analysis ToolPak Translator
- in a line of three possible answers how to prevent multiple answer
- excel files into money 2005
- How do I retrieve a date in a column of dates which > my criteria
- Return to individual sheets
- Linking total amounts
- sum and variable rows
- Disabling protected cell selection
- Formula which is greater tahn or equal to zero
- Create a single sheet from many sheets
- Comparing dates
- Can a conditional formula indicate "date added" next to a text?
- Vlookup Calculation Issue
- Re: Change formula for Employee Shift Schedule template
- Cenvert dollar amount into words
- no formula results in cell
- I need a template for my supply inventory
- Auto convert an alphanumeric string (CIS9638S) to numbers only?
- Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns
- If column c # is 101..then column e is $14.32 & column g is $8.00
- How do I calculate and show negative time in Excel?
- RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
- roundup within a formula
- RE: roundup within a formula
- i need help with a calculation formula...
- Sort with a List
- Excel 2003 - Copy Cell Reference
- Multiple Item Replace???
- RE: Sort with a List
- How do I show negative number in brackets using excel?
- Add money to a sum
- Data Entry
- How to add equal values and than replace them with their sum?
- Formula with current Date
- Copy a cell value and add literals
- Multi - Level Question involving Data Mapping and Formulation
- Identifying Dups in different ranges
- Count IF problem
- Need to find a row in a worksheet based on the value of a cell
- Statistical functions query
- Function to ignore decimals
- Creating Worksheet Using Server Object
- If statements
- Transposing Data
- Creating Worksheet using Server Object
- I want to make three sub colums under an original colum
- How do I copy a function with a called cell constant?
- SUMIF FUNCTION?
- VLOOKUP for Zip Code Ranges
- Formula
- Is the IRR calculation based on cash flows at beginning of year?
- Conditional Formatting
- ifsum slows down calculations
- Can I show a formula's result on a worksheet tab?
- Ladder Help
- change case in excel
- Using boolean function for color fill
- Truncating text before a hyphen
- Formulas and worksheet linking
- IF Command conditional formating
- find position of a number in a string
- League Tables
- What Function to use?
- Require alpha-numeric entry
- How to share a workbook to our staffs
- Solution Required to prevent #Ref! when rows deleted
- Discount rate - what to use?
- Filtrera Pivottabell
- IF formula?
- Calculate Date range
- Adding and Naming Multiple Worksheets
- Subtracting a Countif result from a constant
- Multiple Regression in Excel 2002 SP3 (Office XP)?
- Cell Separation
- Separate Column Sorting
- how to convert numeric into alphabet
- to convert Minutes into Day:Hr:min (not as fraction)
- box formatting
- how to add or subtract from two cells into one
- Returning the formula in another cell
- Exporting multiple cell contents into word document
- Box-Jenkins techniques & Time Series
- Formula to duplicate data to second sheet
- How can we get more columns on a spreadsheet, like 365 days/colmn
- I only want to print the horizontal lines in a spreadsheet
- Can the Combo Box move and size with cells radio button be enable
- conditional sum formula
- Option Button Help
- Solver, macros Excel
- How do I protect only formulas(functions) in a workbook?
- Format of one cell conditional on another
- Excel worksheets
- First part of "IF" function returns false even if true. ??
- Check for double entries in a row
- How to change a series of positive numbers to negative numbers
- Sum function based on format
- Conditional sum
- Counting a Filtered Dataset
- date function
- using text as a cell ref
- Value or function as result....
- Track changes across multiple worksheets
- Function or number depending on input
- Trying to pull date from field getting error.
- calculate numbers based on font color?
- Conditional Formatting
- Change to formulae
- Colomn of strings, how to count each string with "abc" OR "def"
- Help with a Ladder
- How many users can sucessfully use a shared excel workbook?
- can you entre a bar code into a excel cell?
- Sort Problem
- spellnumber function
- I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
- Pls Help!
- Asking for formula~thanks!
- Increase figures in cells by a percentage (on entire workbook)
- average of kth largest numbers in an array of n numbers
- formula's in cells are not calculating
- how do i create range names ?
- Coloring certain cells
- Nested "if" not returning expected value
- Excel Idiot Needs Formula Help!!
- How to get the complete list Excel Worksheet Functions
- Complicated Index Match Offset function
- Hide #DIV/0!
- HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
- HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
- Using Name as Worksheet Reference
- How can I have excel sort through a data string of dates?
- Formula problem
- HELP-Can not type on Spreadsheet
- I cannot change spreadsheet to rewritable
- Carrying formatting automatically to new W/S
- Need help with Vlookup
- FORMULA BAR OF SPREAD SHEET
- Different results from AVG funtion
- Novice Needs Help with Formulas
- References and links.
- monthly total
- adding formula to existing database
- lookup finding the next value that is GREATER
- Hyperlink.
- In Excel Sheet any digit repeat
- filter 400 names from list 1 from list 2 with 4000 names
- students grades, formulae to calculate what grade is needed based.
- auto fill a number
- IF function with 14 nested levels
- list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
- find names on list 1 in list 2. list 1 4000 names list 2 400 name
- AND/OR FUNCTIONS
- how do i add 1 year to a date formatted cell?
- SUBTOTAL(9,range) Does NOT work in AutoFilter
- calculate the number of words in a row whose length is greater than 2
- Column formating help!
- Set value for a cell basd on another cells value using an incremen
- type 020104 and get 02/01/04
- Need help with automating functions
- List
- calculating positive and negative formulas
- How do I copy a new module to 200 workbooks with a macro?
- How do I add cells from sheet to sheet?
- How do I start Excel Footer on 2nd page?
- grayed out options
- advanced filtering in XLS
- Creating a nested COUNTIF????
- COUNTIF for a partial value
- How do I change the range?
- find then sort formula
- Change percentages to numbers
- can conditional formulas be used in or with pivot tables
- How do I fix my arrow keys? They are no longer moving cell to cel.
- How do I change a blank ("") value to a cell with no value?
- Help PLEASE! Not sure what answer is: Match? Index? Other?
- Running Count
- How do I count cells that have are highlighted a certain color?
- Can I use HEX2DEC with cell references vs. numbers?
- check if worksheet exists
- Sum column if multiple criteria are met in adjacent cells
- I need help quick! Formula
- How can I use the NOW function and keep it from auto updating?
- help with excel
- reference to sheets without using sheet names
- Drawing a line in Excel 2003
- A list of Consecutive Integers, can I search for missing integers
- HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006
- Automatically date cell in Excel
- AutoFill w/formulas
- Excel toolbar commands
- Interesting Workbook formula problem
- edit across mult. wkbooks
- VLOOKUP seems correct, still getting #N/A
- function
- date functions for previous 60/90/180 days
- SUMIF?
- Unable to read File
- How do you convert text to rows?
- Worksheet keeps reverting to portrait when landscape is selected.
- how do I link purchase order dates from one excel workbook to ano.
- I'm stuck on and "function Activities" worksheet its due on MONDAY PLEASE HELP,
- Working in Excel
- keep cell blank
- Indirect Help
- hiding and showing graphs
- how to calculate the sum of the data copied from the net?
- Picking Values from a list
- text to dates?
- How do I check repeating sets of number in a range
- Can adjust Format Rows Autofit to ensure WYSIWYG when printing
- how can i enable or disable the paste option in excel 2000
- colour problems
- urgent ......problems on group
- working with excel
- formula based on text information
- excel
- please help
- Using Student Attendance Record template in Excel 2003
- Printing Question
- Excel formula
- how do I auto name worksheets in Excel?
- How can I work in excel 2000 with the find window open?
- is there a way to change formulas to values for sorting purposes?
- counting the number of printed spreadsheets
- lookup functions
- blank cells
- reference blank cell in formula
- Pivot Tables
- vlookup argument type
- Conditional Formatting
- Add numbers depending on other cells
- analyzing survey date
- Help with Excel Functions...
- I need help with a formula
- Page breaks
- leave cells blank #2
- Leave Cells Blank
- Writing a Macro to add decimal
- concatenating and formatting area code and phone number columns
- Need similar formulas to do the job
- Why do functions not allow commas to seperate arguments
- how can hide and show columns using macro?
- Count number of items by month
- column won't unhide
- IF Question
- Adding large minute and second values
- concatenate function/convert military to AM/PM
- VLookUp with Dates
- How do I use ISNA on this formula
- Auto-fill
- Locate max value of one column based on criteria in another colum
- IF(AND Question
- Concatenate/Time Functions
- VLookup Formula Excel Version 2002
- HELP!! Linked Cells
- vlookup function return all values
- copying the function contained within a cell to anouther cell.
- comparing columns of data
- Automatically filling in cells based on another cell's content
- IF statement when formula result is blank
- Sorting rows with alphanumeric starter cells
- Setting up spreadsheet
- Lookup the 1st 5 digits
- Mail a different files to each person in a range
- NPV Calc appears incorrect with a large # of negative cash flows
- Track Changes
- Using Offset with named ranges
- unable to open hyperlinks in chart
- #Name error
- Formulas
- Adding up Times
- if/then changing text format to Bold
- EXACT comparison formula
- I would like to open a new instance of Excel each time I double-click on a xls file
- Remove cells with text not relevant
- Selecting data within a date range
- Automating using VBA
- Replace formula with current value
- dependent drop down boxes and dynamic ranges
- If statement - 2 tests
- Splitting up a cells contents
- Replacing commas with carriage return
- need some help
- AND and OR in a single formula
- Input cell reference is not valid (One Variable Data Table)
- How do you insert an "or" operator in an "IF" statement.
- Find out first Friday every month
- Excel Formula to determine if cells contain certain data
- How to set up an IF formula in Excel
- copy worksheet to another worksheet
- Formula Causing a Save Error Message
- Opposite of Concatenate
- hide the returned value "false" I have submerged zero values
- Another Try
- can not imput data on saved worksheet
- If function
- Referring to function in another workbook
- Is there any way to disable the "getpivotdata" automatic formula?
- Conditional Formatting
- 1-7 Columns, to find last column with figure in
- semi-complicated nested IF statement
- Internal Database Query
- Formula to delete blank cells across multiple columns?
- How to count dates within a certain range in a column with mutiple date range entries
- MAX -1
- Omit blank cells from function results
- rows with formulas
- multiple if/than in one cell
- Excel should let me group rows of info and then sort them
- formula for decreasing $420.00 by 4 percent
- VBA Sum Function??
- setup reminder to a cell
- Date Calculation
- Selecting a cell in a range
- Creating mandatory fields(cells)...
- Macro
- vlookup help
- Embedding a Sumif in a sumif
- Function for characters
- Formula to Text
- Problem with IF function/circular/HELP!
- Time Sheet turmoil.
- Condensing my worksheet
- help parsing multiple text sets from one cell
- What does the + in '=+IF(...' do in an excel function
- Auto-Insert "Last Saved By"
- IF value
- Have "IF,Then" to get data from multiple columns--can I nest add'l IF,THENs?
- IF function
- IF statement with logical_value that is similar to this 0
- type information in one column and second coloumn will know respo
- EDATE
- how do i do this ?
- selecting multiple sheets
- Put an if statement according to cell format
- Show values from other sheet
- Timecards, hours & minutes
- duplicate words
- SumIf function
- Extend series using ref cell formula transposed
- If statements with validation lists
- How can I print a drop down list
- IRR weekly basis cashflow
- validation list with drop down list of options??
- dropdown with validation??
- file creation date
- Update Links problem
- Deleting Lead Zeros
- Sumif
- Excel: Add/subtract to existing value in same cell
- how i make the excel send data or save it to another bad file
- Excel 2000 VLOOKUP returns #N/A unless press F2 return on source?
- USCASCII characters
- RE: Excel convert 1 row 5 words INTO 1 row 5 columns
- Look for the first non-blank cell above!
- move to another cell within a subtotal report within a macro
- sort
- Frequency Array and Bin Array
- rolling 12 months
- automatic numbering of rows in excel, how to?
- RE: Sample selection in Excel
- RE: I need help converting a column from "cm" to "mm".
- Pivot, Sumproduct or both?
- Information Rights Management
- Email button within Excel
- Saving into 1 workbook as a different worksheet
- Rank based on criteria
- select a file name for a link?
- Advanced filter does not filter
- Formulas when dividing with negative numbers
- Are there functions that perform robust statistics in Excel?
- validate input of cell A1 to either 8 or 0 based on cell B > 0
- Formulas not showing results
- Open separate window
- Find data using three variables, all of which may repeat.
- not sure what formula to use
- Recap Worksheet
- Data Validation Manipulation
- If function
- #Name? Error in User Defined VB Function
- Excel 2003 - How do I set up a short cut key for the cent symbol?
- Rounding/Significant figures
- having a table in excel
- How can I put result of If worksheet function into a different cel
- Referencing Cells Using If Functions
- How do I save as a web page without losing comments box with pictu
- Input Cell in One variable data table
- separating numbers and letters from alphanumeric cell contents
- Date Problem's
- Formula for If Term is on Certain Date then Count
- Use a cell's value to set the source file name in link
- share excel document
- Create AVGIF function
- Have I exceeded nesting limit
- IF, AND Formulas
- How do you split one document into two columns?
- Macro virus
- complex date function
- How can I retrieve multiple rows that match one criteria, i.e. a d
- what formula do I use to count right-justified cells in a row?
- HOW DO I CREATE LISTS WITH CELL REFERANCE RULES
- Protecting Columns when another is used
- Nested Subtotal Formula
- how do i pull all subtotals from a spreadsheet
- cell fill colors in excel 2002 sp3
- How can I copy and paste the text of a formula?
- 3D formulas in Excel
- Date format when using a vlookup
- Changing data within one row
- FU: Distribute info from "summary" page to separate pages under condition
- Date function
- Pivot Table -- Add column to average Grand Total
- Distributed retrival
- How can I calculate columns?
- Help with formula that unexpectedly returns an answer
- ActiveCell giving blank value in vbscript
- x axis labels/scale move to middle of chart w/neg & pos line cht
- Distribute info from "summary" page to separate pages under condition
- Sorting Dates
- Vlookup on multiple similar entries / NO VBA
- Extrahera tal från alfanumeriska strängar
- I need help calculating dates?
- A number of days into weeks and days
- Find duplicate
- Hyperlink problem
- cell value change event
- Cannot Print From Excel
- Help with Ledger/accounting formulas
- Setting up hyperlinks automatically
- Input to populate report worksheet
- getting excel to switch to a new row
- total a colum using data from another column
- Count unique entries
- Change number to text formula