- Conditional Summing reminder/refresher (please!)
- exceptions in filtering
- Now formula problem
- Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21
- Sumif interior.colorindex condition
- Roster
- Count Number of Occurrences in a Column
- Tool tips for UDF
- HOW CAN I SORT A "RANKED" COLUMN WITHOUT LOSING THE FORMULA?
- What does an apostrophe (') in front of a word mean?
- move or copy sheet
- Hours and Minutes to minutes
- Am I able to protect my work sheet and keep my grouping function?
- forcing caps lock
- make criteria in sumif refer to another cell
- LOOKUP multiple results but ignore duplicates.
- Frequency
- Formula for calculating Hydro bill
- VLOOKUP problem with using a -
- nested if
- Getting cell reference in excel through VBA
- Lookup a value in a list & return multiple corresponding values
- two-way ANOVA
- Writing a macro that updates solver solutions?
- Need a count of #of times a result occurred on multiple platforms
- Unmerge to all cells possible?
- 2 questions about IF
- Can anyone shorten this one. (not overly clear on array usage)
- How can use a lookup formula through multiple worksheets?
- 3 step "if" function
- Creating a Count formula
- Office 2007 Installation
- pulling data!
- what's the easiest way to common size a balance sheet
- Insert macro in IF Function
- Which formula to use for compounding interest for specific # of da
- calculation LOG10 using relationals
- reference autofill.
- Looking for a function to count alpha values in a range.
- Cost to Retail Price Formula - some help pse
- Disable Cut function
- Rounding up Formula
- Looking for a formula to create a mnemonic, using two existing col
- Sumif
- Space between series
- Cell reference in different worksheet in formula
- Convert 1934 minutes into 32Hour 14Minutes
- using a countif with multiple columns
- lookup based on multiple dates
- Formula not working
- question about many sheets in one warkbook
- Sumif on Formula instead of Value
- How do I count non-contiguous cells?
- Macro Help
- formula doesn't show
- Protection
- How to make a more complicated version of the if function
- OT I would want protect my sheets of excel from a "password recovery" software... How?
- how do I get the cell to move to the right instead of the wrksht?
- finding blank cell and moving specific data into it
- How I print only the cells with data without selecting everytime?
- survey results tally
- Reference different files using vlookup
- Need to reference different files using vlookup
- IF/AND Statements in Comp Calculator
- How to dynamically calculate totals from data being exported
- MONTH()
- Password protect cells
- How do I eliminate "false" from showing in a cell?
- Count Function
- functions
- functions
- FUNTIONS
- Replacing the row index in HLOOKUP
- Calculation of Hrs and Mins from 2 Time Frames
- Help displayed while hovering over a button
- formating cells using formula rather than menus/VBA
- List Box Contents
- Filtering
- sorting rows
- Excel Iterations? Conditional Operations?
- Excel 2003 does not recognize "no fill" from older Excel
- VLOOKUP date search
- How do you turn off a FilterKey?
- OFFSET behaving oddly
- Works if I copy F Col to A Col
- Top 10% and Bottom 10%
- Autofilter - copy & paste
- Look up Webpage addresses from a List of company names in Excell?
- wild card with if logical function
- Cant get my head around this one
- If Function
- Concatenation and skipping blank cells
- Sumif
- Formula for Petty Cash form to return -/+ amount?
- Minimum highlight
- Links to Multiple Spreadsheets
- Advanced filter
- The edit - find command
- How do I sort a large column of data by length?
- Newbie Question, NOW() function
- Lookup query in excel
- MSNStockquote function is not working in Office 2007 beta
- how to get a data form to fill you own exel sheet (was data-form
- FOOTER
- projecting when a person is 70 from DOB
- cONDITIONAL fORMATTING
- how to get "123" as one hundred and twenty three in excel
- Defined name Relative to sheets
- How do i add a cell value in a sentence without using 2 cells?
- Setting TAB to navigate to selected Cells Only
- LINEST()
- Sumif problem
- I want cell A1 to equal $A$2 even after inserting line at A2
- holiday dates
- extend on an index formula I already have
- Adding number to a cell reference not to the contents
- :confused: Nested if then else statement
- Filter data automatically by input
- How do you set cursor position at current date in macro?
- How do I set macro to run at specified time?
- DMIN Criteria
- Disable a range of Cells
- Creating an exact time display
- VBA function for annualized return (geometric mean)
- Vertical scroll bar jumps scrolls line 1 to line 2705?
- Prevent Consecutive Entries
- Calculate Loan Payment Dates
- Schedule Type Graphic/Forumula
- Calc minutes and seconds difference
- Email selected worksheets from a workbook as attachment.
- There is a bug in formatting charts data labels.
- HOW DO I CHANGE THE EXCEL CURSOR TO AN ARROW FROM A CROSS ?
- How do I figure out a pre-tax amount when I know the final total?
- Displaying certain coloured cell
- Group & sort rows that have a specific value in column C
- Need help applying a formula to a certain area of the worksheet
- hyperlink cells between workbooks
- Question about copy/paste functions
- I wish automate a cut and paste of data from one work book to ano
- How do I copy data from main frame computer and keep data in cell
- I need to swap last name, first name in a cell to first name last
- set height of individual cells
- using AND/BETWEEN in a countif formula
- Rounding down
- Vlook
- Conditional string calculations
- validation of time
- equation for a power analysis
- subtracting time
- Excel shared workbook copies rows by itself
- Unexplainable results from my vlookup
- search massive
- BIN2DEC bits 0-5 then 6-15
- match and sort columns
- can you nested sum and round function within if function?
- Return a value for a range of dates
- HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT #
- Not as stupid a question; this time about data from multiple sheet
- false result
- RE: Data Group Total
- VLLOKUP - more than one result??
- Re: Data Group Total
- Lookup two different columns
- Can't Get Objects To Work In A Protected Worksheet
- Removing spaces from columns
- edit more than one Hyperlink at a time
- Formula to display the row number above?
- counting if
- date function
- date function
- Re: Help with using a work sheet to compile data
- Calculating first/last Monday, Tuesday, etc. in a given month in E
- Compare and merge
- IF Formala Doesn't Work
- How do I set the tab stops in a specific cell pattern?
- Sum of Cells if Row Contains a Specific Variable
- Conditional Formatting Bottom 10 with "ties"
- Cell calculate only once
- How to perform calcutions only if value if greater than zero?
- Setting Reminders
- Subtotalling
- Excel worksheets
- mix font styles in concatenated text
- Shared spreadsheet changes color when opened ny another user. Why
- Shared spreadsheet changes color when opened ny another user. Why
- find
- Multiple Filters in one Sheet
- How do I have calculation responses viewed in a Purchase Order?
- Multiple text sheets into a master worksheet as you enter data
- where is the function wizard in excell??
- If, then question
- If/Then Statements
- How to remove unwanted green horizontal lines in Word Table?
- Can't remove Conditional Formatting
- DELETE ALL ROWS & COLUMNS WITH ZERO BALACES
- Extracting Dates
- Index Match Two columns Find Last Bottom
- password protect column
- How do I calculate number of Mondays in a given month in Excel?
- sort column header
- Converting numeric data into 0
- Tab color
- Drop Down List Expertise please!
- Excel and Email
- excel table auto format total row should see sum formula already
- Auto table feature in excel doesnt work on multiple tables
- How to inport works spreadsheet into excel 2007
- Retrieve / Return LAST Row of Autofiltered data
- Which cell was the activecell before a keypress
- Making one field equal 2 others
- exel
- Dates and Intervals
- Reg autofiltering using macro in excel with out providing criteria
- Sumproduct checking between two dates
- Replacing empty cells with '-'
- URGENT IF STATEMENT REQUIRED:True if moving between financial years?
- How do I sum hours and minutes totalling over 24 hours?
- Result of Formula produces Picture?
- Calculating across workbooks
- Excel 12, er, 2007 - Semi-idle Curiosity
- False statement = "no action"
- Summing by categories
- same number appears in a random number generator
- vlookup or similar help
- comparing column values
- This example in Excel Help is wr
- print preview does not look like worksheet screen
- Macro Auto Run Problem
- How to return a value between date ranges
- What formula will get a cell to update when the month changes
- how do I convert a general number to a time format?
- How do I reference the value of a cell within a formula?
- Vlookup and isblank (or ???)
- Linear Regression using the TREND function
- Counting multiple variables in a worksheet for summary on another
- How do I add the same number/value for an entire column in Excel?
- AutoName Sheets by current date
- random start and calculation
- Rows to Columns
- Auto Page Break
- Embedding functions in Vlookup?
- How do you download reatime stock prices into a spreadsheet?
- remove text from string
- Is there a way to import a spreadsheet into a calendar template?
- Help please with formula
- Display cell contents in one xcell doc. from another xcell doc.
- WORKSHEET FUNCTIONS - LIST OF ALL ??
- Excel 2002
- A Cummulative List of Formulas
- How do I increment a number by1 each time I access it?
- excel
- How do I display every 5th row?
- Lookup and Move Data Function Help
- Split Cells using a Function
- formatting
- How to change cond. format icons in EXCEL 2007?
- Advanced Filter Function
- printing worksheet with hidden rows
- Lookup strings with ~ and ^ characters
- Vlookup Troubles
- How do I create two columns from one column (space separated info
- How do I change the rows number?
- Microsoft Excel-locking a column
- Microsoft Excel-locking a column
- Specific keywords copying data to cells
- Find data in table with to set of constant values
- Issues with formula not duplicating
- Which is faster? SUMPRODUCT or VLOOKUP, or another alternative?
- hide specific cells in Excel
- how do I validate the value and not the formula in excel?
- Master Sheet
- I need an Excel template that will calculate Retail Gross Profit
- Vlookup formula
- Another simple formula needed
- Needing simple formula
- Formula falling over in more than one cell
- Offset question .. better format!
- Re: Countif Command
- Help with OffSet Function!
- copying macros
- including two ranges of cells in an IF formaula
- Bringing together data
- Text to Coloumns, by consecutive capital letters
- Numbers to dates
- function to count the amount of cells depending on part of the cell entry
- If Function for BLANK cells
- SUMIF function
- Sorting columns
- Make Existing Data In Cells Text
- Understanding SUMPRODUCT
- Function for hours
- renaming sheet tabs in a sequence
- shift the cursor down 2 rows please.
- Repeating Formulas
- Clothing Rep - need template for list of clothing, etc
- Split into 2 wrkshts, now function doesn't work
- is it vlookup, match, offset?
- Automatic amalgamation
- Floating Cells
- Calculating Top 5
- One to many vlookup help!
- Adding minutes.
- Using IF formula to show what text is in the cell from ddown list
- how to generate a unique form # when using an excel form template
- Need some help on a formula please
- Calculating rate based on age ranges
- Help with Indirect function ?
- SUMPRODUCT with a #VALUE in a cell
- oops wrong place to post
- Max or Min with condition
- Conditional Formatting Question
- My first macro, uses Vlookup but doesnt update unless hit enter
- Formula returns 0
- CTL V
- I need a formula to help me calculate years of vesting for 401K.
- Numerical problems...
- Array formula
- make it easy to turn off the little paste option graphics
- create 3 drop down menus in Excel, each relating to previous
- Merge two rows into one, then merge into mailer?
- Eliminating rows in Excel worksheet
- Is there any way to print the digital signatures on a file?
- The last row of a pivot table shows blanks, but there is data.
- Formula help needed
- (Unsuccessfully!) Unhiding Rows in Excel 2003
- how do I set up stock control sheet in excel
- Pivot Table Function
- how can i insert a subtotal from a range of dates
- Finding Monthly Usage
- formatting columns by date
- 2nd lowest number in an array
- Protected worksheet and arrow keys
- HOW CAN I INSERT A SUBTOTAL FROM A RANGE OF DATES
- How do I print in excell without alphanumeric columns on document.
- Is it possible to change a template column headings? If so how?
- matching part of an entry in a cell
- Comparing lists
- Finding % sum instead of $ sum (as in % change)
- Transpose Function?
- Decimal Issues
- Sumif to return a blank if sum range is blank
- array formula with constant
- vlookup on pivot table results = #N/A
- Function =c25=c49
- Numbering rows in a worksheet
- pivot tables
- VLookup Null values
- Formula Help Needed
- DSUM problem
- whole numbers / not whole numbers
- Random within range
- Random within range
- Few conditions and come out with comment answer?
- MIS tracker
- automatically show data entered on another sheet within the workbo
- If Function?!?
- If one cell given value others in row be made blank automatically?
- Locate numbers in a row and send them to a cell
- IF statement with multiple values...
- Offset Function
- counting with multiple criteria
- Create a condition and allows a automatic comment
- conditional formatting
- paste formula to each cell in a column without changing values
- DateValue Problem...
- SEND button in Excel
- Comments box
- get to a particular point in a dropdown list
- Covariance for 3D coordinates
- wk19!$A:$O => SOME_FUNCTION!$A:$O
- ERROR.TYPE formula problem
- How come Word is adding zeros to a mail merge number from Excel?
- modify a template that is protected
- Vlookup in a named range
- How to sum data based on font or cell color?
- Intranet Excel File...Changing Name
- continue VLOOKUP to next value
- subtraction off time after midnight
- How can you change excel macros from absolute to relative?
- Use find with Index and Match
- A formula that is too complex for Excel?
- How do I do this: If A+B = D+E, make RED.
- Filling cells with absolute columns but "nth" rows
- formula help please....
- Logical functions to calculate points
- Logiacl function with multiple conditions
- offset example wanted
- Formula
- Index function help
- Pulling the largest numbers
- Need a 'last updated' timestamp for a web query
- If Range has certain value, add corresponding value from other col
- Help with linked formulas & multiple worksheets
- Share a workbook and be able to edit drawing?
- Excel Vlookup Problems Help!
- Using CountIf with 2 conditions - help!
- conditional formating cells i Excel based on other cells values
- Counting the number when you have a number and text
- How do I write an auto macro to undo filtering at statup in Excel
- Cannot chg. part of an array
- Vlookup with variable worksheet reference
- formula
- Bold doesn't work
- Excel worksheet Menu Toolbar
- Help with a protected shared workbook
- Day Of Week Formula
- How do I automatically convert $1,234,555,678.05 to $1.5 billion?
- Does Excel 2000 have an undo function after using a macro?
- Highlight if Data entered appears in another workbook
- Excel Help
- VLOOKUP
- highlighting cells beginning with certain numbers
- Retrieve values from 2 worksheets.
- How can I calculate amount of time left based on amount spent?
- Macro preparing numbers to be booked (columns to be chosen conditionally)
- How do I make a productivity report?
- Multi Column Sum and conditions
- Random List Generation
- DSUM or SUMPRODUCT?
- Making Macros Available in All Workbooks
- miricle lookup formula???
- Help with Forecasting function?
- Count non consecutive columns
- E-mail notifications from Excel based on dates in speadsheets
- Drawing print-out
- Vlookup is displaying the formula in its cell not the result??
- VLOOKUP stops working with pasted values
- How to create independent worksheets using data in columns in a s.
- conditional MIN() function
- Formula with ranges
- Can I create an input bar?
- Excelshouldletmechoose the format of the numberwhen I use
- Cumulative Return
- Question on Format in Hour & Minute
- I want a box with the total number of times ORDER appears!
- Sheet Name Function
- Counting the items
- Pastable function using VLOOKUP?
- From 1001 to 1001-1
- Sheet 2 name is "BTB_TACTIMESHT_578162"
- Macro help
- Toggle Button
- Remove Characters from a cell
- SumIF - problem with Criteria
- Im sure this question is elementary...
- Number of Weekdays
- How do I parse columns?
- crazy triple array formula
- Can I password protect worksheets?
- Excel Chessboard problem, boarders and cell shading
- lookup?
- VLOOKUP and LEFT to match text?
- How do I hide rows in a pivot table with zero values?
- only calculate if >100
- IF function for cell color
- How to set up a formula with two false values?
- can an array formula do this?
- I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns.
- Email and Excel Problem
- Exel
- Last Modification Date
- How do I sort rows w/o losing a picture
- No headers & footers in the worksheets
- if function checking for numerical data vs alpha characters
- drop down list value changes
- How do I use indirect when referring to a named range in a closed
- Copy down
- macros and protection
- Sum total from other worksheets
- countif using a range
- Summing where values
- HOW DO I ALPHABETIZ A SELECTED COLUMN
- how do I calculate the time service minus holidays?
- Shade a cell on one wrksht if another wrksht cell is occupied
- VLOOKUP and LEN/ISNA to match names?
- VLOOKUP and MATCH w/ name search?
- VLookUp problem
- how to erase all spaces in text cell?
- how to use the active cell in an Excel formula
- Power users need your help – calculation based on a date
- How do I hide spreadsheet range from data entry?
- named range into formula?
- Combo Box properties problem
- HELP: MsgBox takes 99% CPU usage... why?
- Create an increase or decrease formula with zero %
- VLOOKUP
- Forgot password on protected Excel spreadsheet . . change?
- Why is that happen ?
- inserting zero
- Any function to ...
- Vlookup
- Exist a function to...
- HELP! countif
- transferring formats
- what function to be used
- formula help
- referencing non-blank cells
- can a function do this?
- Golf Formula
- changing from relative to absolute cell reference in multiple form
- edit excel pdf hyperlink using find replace
- Pivot table and counting totals
- drop down formulas
- Need formula help!!!
- Goal Seek on PMT function give different answer than a mortgage ca
- find the largest value in column, put in a cell
- Linked cells refer to source one row off.
- what is formula for cubed root
- Cut and paste
- Dynamic finding and replacing via functions
- Macro - select and paste
- Macro - select and paste
- month plus one - excel 2003
- Split One Work book into several based on content
- find minimum of range based on multiple criteria
- Where can I find a simple paying in and out with Totals sheet
- Sum function
- import a variable number from a web page
- using text wrap how can I type over the page break point
- COUNTBLANK function
- summary data sheet from worksheet to worksheet
- Linking and Query, Please help
- edit bar is missing, where is it
- How to do a basic formula for Xcel?
- Conditioning Formatting - Thicker Borders
- Multiple criteria help...
- How do I bring back my worksheet tabs in Excel. Options doesn't
- Where can I find a journal for accounting purposes?
- Conditionally formatting rows
- sumproduct & average
- Generating Simple Reports From A Master Spreadsheet
- hiding columns or rows not using the hide function
- OpenOffice Download
- Single statement database/range processing with criteria
- seperat.buys from sells.on spreadsheet
- Editing an Excel Spreadsheet
- NOW function question
- ENTER DATA INTO 2 CELLS AT THE SAME TIME
- formula to lookup & sum totals, given a start inv.# & finish inv.#
- countif function doesnt work
- changing numbers into a barcode using excel
- sum problem
- Nested IF in this situation
- How do I hide the Worksheet menu bar
- VB Script
- weekly sales
- How do add time/hours to get answer in hours if Ans>24
- Print each record per page
- INDEX MATCH formula
- Conditional formatting works, is there a better way?
- Change a cell color based on a certain value (green or red)
- Bubble Charts with two non-numerical variables
- conditional moves
- cell data not validated if navigating cell to cell with mouse
- What function will find a value in a table with X & Y Values
- Purchase order...
- Index/Match not working
- How to create a ranked list
- need to work out bonuses
- Conditional formatting and formula
- conditional formatting for currency
- Selecting Cells
- IS there a mathematical formula for NORMSINV?
- Selecting alternate cells
- Too many variables?
- Copy data in one cell to blank cell immediately below, repeat
- Is there a formula that will add only highlighted rows?
- limiting rows of text in a textbox object?
- Formula behaves differently
- Pull data from multiple sheet
- Reference Worksheet Name
- Validation Issues
- Adding a space in text
- Displaying data from seperate sheet upon drop down box entry
- Automatically Re-Size Row Height
- Excel using dollars instead of sterling
- Need a Formula
- create template with certain fields to input information only
- Reference Worksheet Name
- Using Vlookuop and then calculating
- VLOOKUP error
- have different row lables calculate formula
- In Excel , How do I turn off the math funtions?
- how do I add new data and have it added to existing data
- Deleting rows from a worksheet automatically
- In excel counting cells in a range which meet condition ">Xand<X"
- Excel Formulas getting information from 1 workbook to another
- Excel Calculation of After tax Cost of debt Plz Help
- function to convert number to words [ 21 = "twenty one " ]
- Lookup
- Sheet Protection
- COUNTBLANK function
- How to link data from one drop-down list to another
- Counting occurance of text values across multiple worksheets
- Single Excel function to sort a list and eliminate dupes
- AutoFitMergedCellRowHeight - Jim Rech
- How do I combines data from multi-worksheets into one in ascendin
- Leap year indicator
- Relative Value to a Vertical Lookup Result?
- too many different formats on excel 2000
- Function: cell contents formula or value?
- How can I prevent someone from deleting a shared workbook?
- using formula with several possible answers
- CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY
- xirr value error
- zip code to city, state function
- Vlookup
- The word "calculate" is at the bottom of my spread sheet. why?
- cell ref in function formula change when inserting additional colu
- Can you convert a excell sheet to a word document
- How do I create an "outline summary" - please see message for deta
- The formula for NORMSDIST is wrong?
- Need help...
- Problem with data from cells in merge fields
- Excel Web Queiries should work with protected web sites.
- How to include data on the same sheet some in database some not
- Function-Date Problems
- how do i sort a complete worksheet by sorting columns
- summary report with duplicates
- Simultaneous entry of data between 2 different worksheets
- How do I get the true path to server (not mapped drive letter)?
- convert cubic centimeters to fluid ounces and cubic centimeters
- Macro wiping out worksheet
- locking column widths within a pivot table
- Replicating Text Using "=".
- Please Help me with VLOOKUP function
- Hidden Sheets
- Sorting By Row
- Sum and rounding functions
- count of tab characters in a single cell
- Incorporating Cell color fill in an "if" logical function?
- List all filenames & tab names
- Single formula to 'sort' a list onto a second sheet?
- adding more than one value to cells
- new staff
- help using lookup and some kind of ranking criteria
- if then function
- Excel Woes - Formula bug (I guess)
- US states
- Max of a defined function
- divide by zero
- Sumproduct with #N/A in range
- excel "Networkday" function
- Lookup Formula???
- Sumproduct-multiple criteria for same range "OR"
- I want to get a value from an array, row 1 and column 1 known.
- Can you perform Math functions with ActiveX Checkbox controls?
- How do I convert cubic centimeters to ounces in Excel?
- Vacation Accrual formula
- PivotTable
- Function to Convert dollar to text?
- IF statement colored results
- Break links automatically changes graph's date format
- transpose links from a column to a row
- transpose links from a column to a row
- how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE
- Workbook_open : Putting in message in titlebar (Visual Basic)
- Creating a form
- how to insert day of the week
- Newbie post - help with Subtotal please!
- workbook name
- Expand/Collapse Rows
- Using COUNTIF and AND functions together
- copying macros
- merging two worksheet
- NETWORKINGDAYS
- How do I highlight cells on a worksheet that contain formulas
- Disable Page setup
- Absolute function
- Sort function on Pivot Table
- IF Statment across Multiple Sheets
- How do I use VLookup Function effectively?
- Quickest alternative for shortcut of PasteSpecial then Values
- more than one lookup value
- how can i make macros to work when in tools, costumize and option.
- Combine 2 cells without using the CONCATENATE function
- compling info from multiple pages onto one page?
- how do I make an excel comment box bigger?
- SUMPRODUCT FORMULA
- Drop Down List
- ABS of cell on another page??
- Date/Time Calculations
- Formula!!!!
- incerting calender in a spread sheet cell
- Sort & Show Data
- Cell Additions
- Alternatives to GET.CELL and VB?
- counting cells in two columns that have the same results
- If I have my sheets protected will that prevent me running a macro to hide certain sells?
- Vlookup between two workbooks
- V-Lookup, column index number indicator in table array
- Re: Add to Summed Figures
- Add to Summed Figures
- WHY DO FORMULAS STOP WORKING IN EXCEL
- How to convert a repeating row of information to fit in 3 columns
- How to convert a repeating row of information to fit in 3 columns
- Hide Blank Rows
- Automatic League Sort
- protect excel wrkst but still be able to use grouping and lists
- How to copy several wkshts into one worksht with formulas?
- Averaging letters
- Excel pivot table field settings
- Conditional Formatting - Thick Border?
- How can I insert a new information between two rows?
- Match
- Drill Down Formatting
- sum of if formula
- Can I import a .xls spreadsheet into my wordperfect address book
- Existe un error en la nomenclatura de las formulas financieras:
- How do I conditionally format only some of the text in a cell?
- Histórico do excel
- Merging worksheets into one
- Can CELL Return Multiple Data Locations?
- set up a link that updates page one from all other page entries?
- How to consolidate worksheets (1 file) with different headers?
- Subtracting Date/Time pairs
- REF# error using VLOOKUP
- Phantom documents saved from shared workbook
- Center text across rows?
- sumproduct
- How do write a formula so that only rows with info prints?
- Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
- How do I determine who will be age 55 by 12/31/2007 and 6/30/2009?
- lookup data in array
- Removing the last two digits of a cell
- convert formulas to values
- Lookup dates, fiscal period table
- Lookup based on two conditions
- Incremental Formulae in Excel
- Macro Auto Run(2)
- RE:Column of Data - Set Next Column Value Conditionally
- Column of Data - Set Next Column Value Conditionally
- change lower-case to upper-case
- How to Limit Cell Values to Multiple of 10?
- Lookup Question
- Format 000-00000-00000-000 and recognize leading zeros in Excel?
- Can I get Excel to calculate hours:minutes when sum exceeds 24?
- A Challenge: Detection of first and Last +ve number in a range
- Excel Dates
- Lookup Funtion
- Need a shaded row in Excel that doesn't move as data changes
- formula help
- MIN function
- prepaid/depreciation formulas
- Help with Formula
- how to insert month date year and day of week
- insert formula
- Summing range that contains text
- calling up cells from a table.
- Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel
- How to use complex criteria in SUMIF()
- Sumproduct question?
- Double IF - is this possible
- Combining formula and cell reference
- Offset Function
- Formated Print Area in WEB page.
- working out quarters (three-month periods) between two dates
- Complicated formulas
- Want a serious muslim match?Join our club and start searching now!!!
- Want a serious muslim match?Join our club and start searching now!!!
- No. of digits accepted in one cell
- need help creating a Worksheet_Change code
- copy range from one workbook to other in C#
- Help me please. How do I delete custom number formats?
- Converting Getpivotdata function in Excel '03 to Excel '00??
- Reverse lookup
- MS Excel 2003
- Not sure how to ask
- Sumif & Dates
- Divide numbers and distribute evenly.
- Refusal to calculate
- Find duplicate entries within mulitple worksheets, then listing th
- Setting up dates
- If formula
- Help extract numerous text files and how to use avg formula
- Reference Cell Color From Other WorkSheets
- I want to place a "x" in a cell and give it a value of 1 (Excel)
- CUMPRINC workaround for Excel users without feature installed?
- Changing relative to absolute for a column
- excel exact command should not be case sensitive
- nested IF w/ LEN and ROUNDUP??
- To XIRR or Not To XIRR
- Excel solver should allow "equal to" value to be a selected cell.
- Slow Calculation
- I put in 19 the formula is ok but if i put in a566 it returns #N/A
- sumif and then regular equation to non selected cells
- Worksheet Command Button will not work
- finding last row in a fixed section then sort
- How do I set up a spreadsheet where it will automatically update?
- 3D formulas
- Dynamic Hyperlink
- keeping cell format with formula
- Trim file name only
- Average
- Locating First and Last Cell Containing a Specific Value
- Can Excel add working days to a date to result in another date?
- How do I create a running total (balance) in a pivot table?
- How do I countif the criteria is a nonblank?
- Vlookup problem
- Columns A - BY and 336 rows.Too much to filter&sort?Lose info.
- Columns A - BY and 336 rows.Too much to filter&sort?Lose info.
- ifsum function question
- DCOUNT WITH MULTIPLE CRITERIAS
- vlookup with variable col_index_num
- Format new Lines into Columns
- data validation
- check boxes from the forms tool bar
- pattern matching possible?
- In Office 2000, How do I delete multiple blank rows at one time?
- Conditional formatting based upon array
- Assign number to every value in a data range???
- how to maintain hyperlink between worksheets after sorting
- Excel functions names should be in English for all Localized versi
- Range Name C
- how to set number of characteres on a cell
- Dynamic reference to another sheet?
- date function
- Microsoft Excel
- function help-keeping data from true when false
- Formula Help
- OnTime VB
- Is conditional formatting only blank, unused cells possible?
- Automatically Refreshing Data at 12am
- Removing Spaces from string
- strange behaviour with matrix formulas
- July - UK Excel User Conference
- If question I think
- subtracting (extracting non-duplicate items)HELP!!
- Can a VLOOKUP use two items to search
- multi column of sumif
- Lookup using more than one criteria
- Is there anybody who can hlp in the function making!!!
- How to simplify "multiple if" formula
- NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
- Count coloured cells in a range
- Count Specific word in specific range
- formula
- Formulas
- Compare 4 columns?
- how to name the selected cells in a sheet?
- Help please!
- Countif with range name
- Refreshing when opening a file from the "File" Menu
- Search array and return element No
- open a query automatically
- checkbox event handling function
- Averaging Golf Scores
- History worksheet - can it remain viewable after saving?
- How Do I Combine Rankings for Multiple Categories?
- combining two formulas
- shortcut to insert cells
- Conditional sum
- vlookup returning a #N/A value
- Finding the Last Working Day
- How do I find the earliest dates in a range of dates?
- How do I convert run time(45,502h 30m) to number 45,502.5 ??
- Counting
- If then statements?
- vlookup display
- How can I bring forward formats with Vlookup?
- Combining Ranges
- Automatically Refreshing Data at 12am
- Merging a full column into a single cell
- Macro or function
- VLOOKUP problem
- Between Function
- How do i retreive data from another worksheet to a current one?
- Excel Grouping Enhancement
- Excel In-cell Enhancements
- data validation: formula for validating only multiples of 10
- Splitting cells using formula; RIGHT/LEFT not applicable
- HELP WITH FORMULA
- Mode
- Moving Data Question
- running total by date (not sorted by date though...)
- How can I save xls files to 'E:\'? I have no floppy disc
- Function that returns the page number a cell falls on
- Lines around cells
- Consolidate multiple workbooks into a single worksheet
- Formala to find the best/latest signal
- vlookup and subscript text formatting
- if/and statements
- How can I isolate a lookup vectors but not values from autofill?
- Show data dependant on selection from drop down box
- SAVING DATA TO CLOSED WORKBOOKS
- Sumproduct Question
- Recalculation
- How can you save a spreadsheet with a date stamp.
- function question
- error message: merged cells must be same size
- Changing the case of text data
- Solver problems
- sort and return column numbers
- I want to add up the amounts from 1 cell in a folder of files
- Importing Problem
- Deleting the same character automatically in each cell
- Help with Date Formula
- Combine all the data's from different sheet to one sheet.
- ranking in a dynamic range help needed??
- SUMIF using 2 Criteria in 2 columns
- copying adjacent cells with formula
- "IF" Formula Query...
- ROUNDDOWN but calculate actual numbers
- Excel Linear Regression by set slope (not intercept)
- How do I get the last number from a specific column
- Matching numbers witin a series
- How do I auto fill an entire spreadsheet at once?
- aa ab ac....ax ay az....ba bb bc....zx zy zz ?
- Creating a formula
- How do I autofill conditional formatting?
- Deleting/rasing a column of numbers??
- VLOOKUP from closed file using INDIRECT function
- how can I split one cell's data into two cells?
- Formula
- On excel, my formula will not calculate and add info into cell
- comparing a cell to a block off cels
- What buttons do I need to push in order to switch between sheets?
- My first macro - doesnt work - function not recognised
- Nested Vlookup and IF function????
- from Excel to TXT file
- tagging info
- Tagging a column
- min and if again
- Modified Average Function
- excel symbols
- calculating moving average
- Auto Virus Scan
- Cross Reference between sheets
- Graph orientation
- Polynomial equations
- columns reversed
- HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE?
- INDIRECT lookup of sheet names
- how do I apply 10% gray shade to a cell in Excel?
- Cell Reference in formula
- Newbie Date cells so most recent is on top
- help with vlookup, wildcards, multiple searches
- Newbie, Countif Question
- text & number sequence
- Help with Date Formula
- Break up my URLs? Can't figure it out...
- How to return zero for an equation = < 0/
- Manual AutoFilter - Vlookup, Index, Match, Array???
- ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003
- 3-D References and Link Updates
- In a column of numbers I need a function to find the last entry
- Formula for totaling column
- weird recalculation of user defined function
- ActiveDocument object not recognized
- How to make only the cells i need active
- deconcatenate
- Running averages
- Running averages and time stamping
- Employee Performance based ratios
- Ranking
- if column 1=>3 then column 2, if not return no value-Help?
- Formula Help
- Excel: How to import multiple XML "Repeating child elements" same.
- How delete formula bar and retain the computed number in a cell?
- Count ; in cell
- Compare name and copy from closed .csv files
- COUNTIF Formula in Excel with two conditions
- Finding last used
- Insert Criteria Based on Current Month
- floor function
- Three new functions that should be part of your standard set
- How do I setup dynamic linking between worksheets ie. T-O-C
- eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS
- Formula Fill help
- age formula
- Macro - Auto Run
- Filtering numbers in a column?
- =TEXT(I21,"MMYY")
- new romanian currency (ron)
- change display format for excel folders and files
- select all worksheets in formula (wildcard)
- Split 2 words
- RE: Otto M. - Data Matching
- Capital
- Find
- Finding duplicates in 2 worksheets
- How do I create a formula that makes text in a cell = 0
- Increasing values in Price column
- Choosing data based on Match to several items
- Several worksheet tally by name
- Right-click inside of a cell
- IRR for 2 cash flows
- trouble with viewing fill color and font color
- Is it possible to merge data from two worksheets?
- Macro Help for Saving a file
- min and max in a sequence
- excel export
- SUMIF with 2 conditions
- Merging 2 cells together and prefixing
- Is This Possible? - Data matching
- About Sheets
- INDEX / MATCH problem
- How can I link sheet to the certain Excel document
- Need help with possible formula