- worksheet is locked on highlight how do I unlock it
- Merging new data
- Solver returns non binary answer in binary constrained cells
- GETPIVOTDATA - return cell reference, not value
- Is there a Division funtion in Excel?
- SUMPRODUCT Help
- convert date of birth to mos. old now, 30 and 60 days
- How do I find address of cell containing maximum value
- how can i rank a column in excel
- CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
- Worksheet Selections in Macros
- Exl: how to? If column N value =R, then copyentir rowto sheet 2
- RE: CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
- RE: Worksheet Selections in Macros
- words means numbers
- How do I display a graph from one workbook to another
- How do I return a blank for VLOOKUP instead of #N/A?
- HYPERLINK
- is there a blank drlling AFE available
- Linking Spreadsheets
- Calculating Percentage
- Can I sum only highlighted cells in a worksheet?
- Excel Lookup with If
- How to protect sheet but allow grouping to work
- How...?
- Comments Help
- function vba
- Sum of a row minus two smallest numbers
- Combining worksheets
- Adding columns to a worksheet
- Comparing Cells
- SUMPRODUCT Help
- Round function that rounds down if 5
- how to change formula bar settings
- Add more than 65536 rows?
- Counting rows containing data (both numbers and text)
- Figuring hours
- functions with nonadjacent cells
- Drop down lists show button?
- Reference an identical cell on a different page using copy/paste?
- SUMIF with multiple criteria
- Offset And Vlookup Combo Help!!
- Comments
- Hightlighting Numbers & then all Cells to the right of these Numbers.
- Paste Link
- Sort function or macro for the first 4 letters
- Database type Formulas
- how to save/copy data in cell to a series of cells on another pg
- graphing algebra equations
- Making a drop down list/column
- Overtime Hours
- Paste question
- Creating a formula for down and distance
- Formula does not work with 13 digit numbers
- Countif
- Need Help
- Count down formula
- Excell Check Digit Formula
- Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA
- Complicated sort function with sort and sum
- Figuring hours
- How to consolidate data from multiple worksheets.
- Any MVP to try this ..
- delete command macro's
- import text and sort data into excel
- import text and sort data into excel
- Auto Sorting
- Compare two cells to evoke a response
- Compare to cells to evoke a response
- I cannot edit a graph
- STPCScut STPCScopy macro missing??
- can i store percentage formulas to reuse them?
- validation-list
- how do I calculate hours using one cell only
- How do you reference another cell in the criteria of a SUMIF funct
- IF function trouble
- Finding text within text
- Less i column
- "tomorrow worksheet function"
- sum / lookup w error correction
- um... im lost
- Index function works in A2, but not in A10, Why is that? Cant figure it out.
- Complicated Formulas
- How do a lock a picture to the rest of the spread sheet row entry
- variable as a cell reference?
- Creating a league in excel
- IfSum
- counting decimal places
- how to count the number of decimal places in a cell?
- Automatically copy values
- How do I sort (or group?) a spreadsheet by similar rows?
- add leading "0"
- joing (merge) tables by key field
- how to get the name of the sheet in a cell?
- how to spell out number using function in Excel
- if/then statements
- How to insert a picture with IF-function
- How do I calculate if a date is in a certain time frame?
- Invoice Numbering
- Selecting from a Validation Drop Down Box aborts macro
- IF Statements-Circular Reference
- Get other sheet names into a column
- making the range a set of data within a column
- selecting certain text in long row of text
- copy certain data from one row
- Adding superscript in text function
- Can I auto fill a cell in one worksheet by typing a code number
- formula for linear regression
- conditional formula
- Adding numbers to a running total
- IF Function Help
- Lookup across multiple worksheets
- How can I replicate a conditional sum formula?
- Help with IF Function
- Help needed with Adapting complex INDEX formula
- Use of iteration function
- how to share spreadsheed in excel with a person at another comput.
- Is there a way to copy multiple worksheets into one, row by row?
- In Use Message
- How to make excel not to compute formula
- Changing dates entered in 2005 to previous years
- How do I specify more than one argument for the SUMIF function?
- posting 20050826
- Please make it easier to access the IS functions (e.g., isblank) .
- how to find returns for lump sum & yearly investments
- Count the occurence of more than one condition
- Compound interest rate of return on investments
- Drop down List
- Formula requireing the system time
- COUNTIF criteria using date ranges?
- Linking Spreadsheets
- is date can be filtered to a different cell?
- autosend for excel worksheets for distribution list option
- Can You Translate This Function Into Excel Format?
- Hit enter in cell & move text down in cell, not go to cell below.
- Signifcant digits
- how do i convert 536 seconds to 8minutes 56seconds
- Lookup value throughout an array_return adjacent value and summing
- Opening workbook in user-defined folder
- Concatenation with leading zeros
- I lost the box on the top of Excel that you can type text in???
- my output appears very small
- fill series is incorrectly copying result
- sort rows in alphabetical order and move the corresponding data
- EXCEL 2000 AVERAGE function
- Random numbers
- How to move characters to the end of the string
- Hyperlink probelm
- Exponential values
- IF ranges for multiple columns greater then less then
- Linest function: data selection problems
- Linest function: data not being selected in formula
- RE: Converting text to numbers
- Collapse rows with duplicates
- Can Excel operate a function based on a true or false result?
- look up
- EXCEL WORKSHEET
- Select updated data from a range of columns
- opslag
- Difficult Time equation
- Inserting a row with functions
- Find last occurance of text in range
- overtime formula based on dynamic date range?
- Linking information between workbooks
- Summing a variably-sized range
- creating macros in multiple worksheets
- Re: Array formula needed
- SUMIF with 2 conditions
- Advanced Auto Filtering
- How do I find the last number in a column of numbers?
- Is this possible please if so How. Thankyou.
- Dynamic VLOOKUP function
- Showing a unique random number w/o duplicates
- Re: Formula for Ratios
- Vlookup using a range condition
- Select unused number
- Re: Default font for Comments
- 'SUM' Tables
- Combine into one please
- RE: SUMIF Function?
- Re: if amount <0, put the all line in red
- Hourglass comes up when going between split screens.
- Counting Months
- Average of numbers within a range meeting certain criteria
- Pivot Table - if Formula
- Inserting Pictures with IF function
- Not Sorting Problem?
- Problem, again
- Autofilters-Remove (Top 10...) and (Custom) options from the drop-
- i can not fliter unique records
- Copy and Pasting Every Third Row
- Modifying Macro
- Retrieving Unique Values From A List - TIP
- Please Help: Adding an equation to a range
- Color change - Cell Pointer
- Excel function to countif a criteria is matced within to columns
- Count a value if next to another value...
- Help with Excel Formula VLOOKUP
- Conditional Formatting Pbm
- Referencing worksheet names
- Sum the results of an equation through a series of Cells
- Complex Macro to perform an operation as it steps down cells?
- How do I convert time (2:30) to a number (2.5) in a formula?
- Drop down list button hidden
- Comparing a list to a Calendar worksheet.
- conditional copying of sheets
- put the index back into excel help - I want pop-down of functions
- Saving Version Control
- How do I get Excel date to change from 1/1/1900?
- Counting a range
- How to update links between wk sheets
- Excel doesn't add up
- Conditional Format to highlight entrire Row
- Function-formula help
- In Excel,how do I lookup a value and assign it to a list?
- formula for named cell/range using cell values
- Subtracting date:hour from date:hour
- Re: Bug in Excel's (not VBA's) MOD function
- Please add an INTERPOLATE function. For vector or array data.
- Index and match functions help needed.
- Hiding text so it doesn't print
- finding matching cells in worksheets
- Validation Problems
- Duplicates
- Returning a Value dependant on a cell which could have different d
- font colour change within a IF formula - Help!!
- wildcard use in formulas
- function/formula help
- Interest calculation
- Date problems
- Cell Offset
- Parse text & numbers & format
- Parse text & numbers & format
- Parse text & numbers & format
- Help!! with a formula
- how to enter numbers value for calculation?
- HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY
- multiple cell editing
- International Language Functions
- Conditional Format to Highlight entire Row?
- how can i filter data from one sheet and copy to another via formu
- combine text of multiple cells
- mass cell data editing
- Return Single Instance of Numeric Values from a Column
- Automatically insert row and copy formula
- How to print detailed instructions for all functions in Excel?
- How to print detailed instructions for all functions in Excel?
- trying to add text
- SUMIF for Dates / Months ?
- Real Value of .UsedRange.Rows.Count
- How do I add time (in mm:ss) from multiple worksheets?
- How can I match data about countries drawn from two database queries?
- Searching Excel for a value
- Data Validation dependant and unique
- Another Reason to Hate Insurance Companies (as if you needed one)
- Change color to red when fraction is negative
- Help with Excel formula
- IF Function or Countif
- When using SUMIF won't worj with crieria = cell referrence
- Entering same data, two worksheets
- Duplicates
- Changing a Link Mid-way Across Worksheets
- cell custom format
- =ppmt
- Refreshing drop down cell values...
- fill a series of dates excluding holidays
- assigning ranks to number ranges
- Ability for Excel to find and replace graphic objects (like Word)
- do I have to manually change PER to amortize a loan out 40 years?
- "BLANK" - need to delete
- do I have to manually change PER to amortize a loan out 40 years?
- Formulas requiring a time stamp
- Conditional formating help needed
- ATTN: Mr. Bob Phillips
- Check if cell contains certain text
- can not enable macros
- Can an IF formula result in a color filled cell in Excel?
- International Equivalents
- How do I separate a text value with dashes?
- Carying Forward data with specific information
- VB Error, combining rows if...
- Re: Excel finds a value that is not in the lookup range
- IF statement
- Source Data in Pivot Tables
- puzzled
- formula stays same in cell when new row is inserted
- vlookup, but ignore errors if #n/a
- Quick and easy
- Lookup and return
- errors and printing
- How do I input zeroes in a zip code for a mail merge?
- DATA > TABLE -- 2 variable data tables?
- subtact between times
- Combo Box
- Nested functions HELP!
- Formatting Cells - color based
- IF - need to insert a cell value
- ISERROR
- Excel - open a new workbook with "own" macro
- How to autofill data from one sheet into another
- Automatic Sort with VLOOKUP/LARGE Functions
- HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE
- Opening excel spreadsheets via excel.application object w/o prompts
- Update worksheet by comparing two cells
- Sort defaults
- copying formulas to another cell
- Data entry for two worksheets
- Nested If with And
- date shows 1/1/1900
- Array Formula help pls.
- Nesting Problem
- Excel Worksheet crashes when changes are made.
- Average of the minimum+50 in a row
- lookup function bringing in wrong info
- pivot table to sheets
- Copy Formula to Different Workbook
- COMPARE DATA FOR CHANGES
- Reading data in onther Excel document
- SUMIF Returns a #VALUE error when external source is closed
- Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17
- I want to convert 10,000 to "Ten Thousand" using Excel Function
- moving cell
- How do i make a range of cells change colour
- IF STATEMENT in multiple workbooks.
- Autosum returns an incorrect zero value on the selected cells
- LookupV
- Simple Copy from Worksheet to Worksheet
- Error using "IF" in Microsoft Excel
- Sumproduct / Max array formula problem
- plz help
- print bottom row repeat on every page
- Date Language setting
- How do I set up an automatic running average in Excel
- QUOTE NUMBERS
- Calculating the right formula
- backing sales tax out of a total including sales tax
- Using Sheet names in formulas
- working with dates
- convert a PDF file on the Web to Excel
- Matching a sampling # to it's row #number
- Newbe Help with count/countif function
- how can I blank out columns that are not being used
- Cleaning up data from Crystal Report
- Lookup - Pro-rate formula
- How do you format a cell for % varience for multiple answers
- IF Statement??
- inserting a VISIO drawing into a worksheet
- Product formula help
- Formula for appending data
- Caculating a "staircase" discount
- column to column conditional formatting won't work, need formula
- Results in a column
- How to transfer info from PDF file to excel (lists)????????
- how do I write the date in an if statement
- Freeze frame printing
- Drop Down List Autofill
- Vlookup then OFFSET over and down
- Do Loop
- Drop - Down Box
- Date Function
- create default cell value
- Formula Problem
- Exclude non-numeric data from calculation
- Counting Match Pairs In Rows
- formula to identify weekend dates
- combine date one column, with time another column into third?
- Is it possible to split a cell within a cell?
- Create a master worksheet based on 2 different worksheets
- moving the formula "average" over one column in a macro
- formula with changing cell ranges
- IF statements/formula problem
- Help with a formula
- Excel for inventory aging?
- Lookup function help
- display Calendar for Excel field entry?
- Do I have a corrupt shared Excel 2003 File?
- Help with formula...please
- create a multivariable regression in excel without using array
- Payment formula Question
- Cell reference
- how do you count checkboxes in excel2003
- use replace to edit a formula with wildcards
- Pivot Tables - Named Range
- School assignment: Excel worksheets.
- minimum along rows
- How do I total amounts on various sheets in excel?
- Function to return the active sheet name
- excel, printing data in columns
- Identifying bottom of list
- Range Changes with the Months
- page numbering
- Counting Blanks
- Editing Array Formula
- Countif using dates
- How do I delete the same item from all pages of a workbook?
- Best 8
- Not including blank fields in pivot tables
- coutif with 3 criteria including brackets
- randomly select value WITHOUT changing
- How can I merge and link workbooks into one summary workbook?
- Time format in excel
- Could you help me to calculate overtime
- CREATE A SUM BASED ON DATES
- cover #s to text
- how to change colour of text in true or false formula
- How do I calculate time
- Struggling Again With A VLOOKUP
- how to convert numerical figure into text
- Worksheet VBA function - not recognized
- Numbers converted into amount in words in English?
- Formula for Calculating a Floating Date
- importing data into a workbook
- Help with IF & Average Functions
- Function Help Please ....
- No Match
- Is there a way to reverse the layout of your colums?
- How to get pivot table Time field to appear correctly
- Question about Emailing
- How can I get fonts bigger on my dropdown list?
- counting filtered items
- How do I do this?
- Tracking calculation progress
- Find certain text in a column and return statement
- Need a help with the IF/ IFCOUNT function
- Update of cell values after insert row?
- IF - Nesting... almost got it - need a bit of help
- Need insert a dash in between last 4 digits in text string
- Target.Address syntax
- How can perform a summation?
- drop down lists/validation tables
- Automatic Date Entry
- How do I calculate operating expense
- Nested IF AND OR function Inexplicable error
- sumproduct w/horizontal range not working
- Spell Check an Unlocked Cell in a Protected Spreadsheet
- Selecting a Worksheet Range
- How do I calculate operating expense
- Links
- Logic Tree, MS help = useless
- I need to insert a drop down menu in a cell?
- Create a print macro that would automatically select print area?
- Make an =if show - instead of 0
- Can I modify Excel 2003 color palette to accept Pantone colors?
- formulas using text
- IF is not carrying out the FALSE part
- Getpivotdata - Excel 2000 vs. Excel 2002 and later
- VLookup and HLookup at the same time
- Check to see if cell data is within a range
- move one row to another in excel (worksheet)
- merging sheet1 to sheet2
- If Statement Using Wild Cards
- custom cell number
- Editing countif formulae
- Generalised version of LINEST using QR Decomposition
- counting date entries by month & year
- I want to use the same function as SUMIF, but for two criterias
- Max number of IF statements
- I'm Having Problems with EOMONTH
- Date Range and calculation
- Copy Formula - EXACTLY
- Recalculating a Regression Output in Data Analysis
- Selecting Rows
- save as macro/for password
- Automatically Sort By Reference Amount?
- Lookup and return multiple Values
- Workbook formulas
- Next Row
- In Format>Cell>Numbers>currency>Symbol Please add "Rs. India"
- Convert Text (letter) To Number Excel
- Large function
- Weeknum Function
- Splitting a Target Figure
- Help! Formula between the sheets
- #N/A! to be blank please.
- Age with mont in decimal
- unbalanced data in ANOVA
- Sum of comma seperated values in cell(Reposting)
- Help with VLookup function
- Referencing data in different worksheet based on month name
- How to insert picture and automatically size to cell?
- How to insert a picture that automatically sizes to size of cell?
- Excel formula help?
- creating a rate schedule
- Help with IF function
- Conditional Average
- Is it possible to place a stopwatch in Excel
- this may be simple, sumif question
- what exactly are relational operators in Excel? All math symbol?
- Countif based on 2 criteria
- pivot tables reports - altering display of (blank) cells
- I need help
- Help using the 'If' function to automatically fill in other cells
- Moving data in financial forecast
- How do I calculated total hours per week
- use only the first 3 letters of cell data
- excel does not open file in network
- Convert numbers into its equivalent in words?(12 to Twelve)
- Formula to lookup Multiple Column Text and then Count Result
- Lookup Function Problems
- Modify A Formula To Include AND
- Naming Worksheets
- cell format limits
- Conversion of Cell Contents into a Functional Worksheet name ?
- Conform a total to a list of results?
- how do I add minutes and seconds together in excel
- Customizing MSOffice 2K Format toolbar.
- need assistance with merging cells
- #REF! help
- Subtracting cell contents - I can't believe it's not working!
- IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR
- have a date cell pop up a monthly calendar to choose a date
- VLOOKUP using a cell calculated with NOW returns Error
- web page numbers
- totals from a tabel
- Calulating Age Formula
- macros in personal.xls file
- Nesting excel greater than 7 arguments
- macros in personal.xls file
- copying data
- I am trying to set a letter grade for my students, HELP
- VLOOKUP, INDEX, MATCH... What to choose
- number to text
- How to auto number cells that have colour
- using item#s to link cells
- Need if Statement
- How to make repeat long numbers shortcut ?
- Counting Multiple Values In A Cell
- MOD function computation error
- Unprotect Cells depending on Cell value
- Need Help on Lookup function
- accessing an address stored in another cell
- complex conditional formulas in excel using "IF"
- Keep all cells in one row together?
- sumif with similar cells
- Value between 2 dates
- Help with SumIf
- Excel sumif functions?
- Counting Unique Values Given Criteria
- In Excel, how do I setup sequential numbering on an invoice?
- Will Excel produce invoices from a spreadsheet?
- Min and Max
- Hide Empty Rows When Printing
- cell values
- double vlookup in same function
- coverting rows to columns
- countif criteria only one word of few doesn't work
- function CELL() to return the formula in the referenced cell
- binary bit word
- Can you sort a column in Excel that's different by colored font?
- Pivot Table - Average of counts
- how do i replace ( with / without changing format to fraction
- filtered values can displayed in certain cell
- Do Loop
- LOOKUP problem!!!
- range names or check box
- how do I place the sheet tab name in my spreadsheet by formula?
- Group Contraction/Expansion in Protected Worksheet
- Large Index Match Lookup
- Average function and two criteria
- Convert Zip Code to County
- Help needed in finding specific series via row.
- Do Loop
- Sorting Data question
- Can I make the data_field in the getpivotdata formula a cellrefere
- can u use formulas between tabs in a worksheet?
- Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell
- Password Protect
- Do Loop
- Positive Results
- having one more than one column index number
- Text spacing in drop down lists
- Inventory Control
- need information
- Required fields with comments
- Match - #N/A
- How do I create a pivot table from multiple pages of data?
- Number of paychecks in a month?
- update cell in other worksheet based...
- excel
- How do I use a "check(ed) box" as a criteria in an "=if" statement
- Insert blank row and issue a sum
- URGENT - Help with choice of formula
- calculate a MEDIAN using multiple criteria?
- DGet vs VLookup
- flag date within a cell after 15 days have past?
- Check to see if a cell is populated
- Format not Really What It Pretends to Be
- Conditional formatting wth more than 3 conditions
- plot graph and place it in a cell possible?
- why does undo feature not work after value entered?
- aging formulas
- Subtract number of Working Days
- Update a Date Quarterly
- how do I protect a worksheet and still use a checkbox control
- Lookup min & column heading
- Find duplicates then calculate..???
- Maps of countries of the World.
- indirect function to reference cell on different sheet
- Can this be done? Conditional formatting
- Maximum If Help
- Control function for copy/paste
- Trouble with Image Control on a worksheet
- Average if Help
- Find the sum of Comma Seperated Values In a Cell
- DATE (MOD) Function
- Function to convert Time String to Time
- Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I
- Hyperlink function without openening new Explorer every time
- HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
- How to protect different cells by diff. passwords?
- Using Vlookup to compare and validate data
- negative sumif
- woorkbook
- Triple occurence formula
- Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)?
- My Quest with Time!!
- Validation for a cell
- Visible rows and functions that work
- Dedrie, FORMATTING SUBTOTALS
- Excel Formula help
- how do i copy rows using critera in a formula?
- Apostrophes instead of equals in Excel
- Identifying an item in one col/row and searching an entire spreads
- mailing labels
- RE: how to auto assign po numbers in Excel
- Work Schedule - Automaticaly filling name?
- Why cant I use =countif(Jan:Mar!$b3)
- How do I change the format of a cell based on what I input?
- Auto repeate parts of functions
- I have 12 scores over 12 weeks . I want to average the highest 5
- What do I need so I can open an Excel worksheet for editing?
- How do I convert a number of minutes into hours and minutes?
- Column Headers Not Fixed
- Can a worksheet date itself?
- Scrolling an Excel worksheet embedded in a Visio diagram with VBA
- links to same files in different folders
- SUMPRODUCT by Date (numeric) value
- Rank based on Totals
- filter/lookup question
- Formula needed
- USING NAMES IN FORMULAS
- Excel should calculate exponentials properly (right to left)
- Linking cells
- Nested If with VLOOKUP's and AND function
- complex?? Q about Conditional formatting
- transfer one worksheet to another worksheet without losing format.
- VLOOKUP - problem in stock request
- is there a way to add single digits within a single cell?
- how to auto assign po numbers in Excel
- text search help please?
- Finding a function in Excel
- HOW DO I ADD A PRINTABLE BACKGROUND IN EXCEL
- How to make "common factor" formula ?
- number cell increment +1 when dragging down box
- Formatting Subtotals
- How do you make calculations between different tabs?
- Please help!! Vacation Accrual Formula
- Hide Rows / Columns - complex question
- Problems with Copy and Paste in Excel
- Tricky maybe
- How can I convert a scanned PDF paper document into EXCEL format.
- MERGING COLUMNS WITH DUPLICATE INFO.
- wild cards in formulas and functions
- Hide columns & rows that contain "0" or blank in a range of cells
- How do i link Excel chart to Outlook automatic emails?
- Drop down list
- Formula help ... moving to next cell everyday
- Linking spreadsheets
- Formula to combine text?
- Pull down cell to access n&a spreadsheet
- Formula for incremental increase
- Need help adding :
- Vlookup problem
- How do I print two sheets in same workbook duplex?
- Formula to activate macro
- Setting Purely BLANK Cell
- Fourier Analysis
- Simple selection, but hey, I'm no guru!!
- hyperlink
- blocking cells
- copy text between 2 open workbooks via macro
- Selecting Random Data
- Help on ifsum
- Help - basic formula question
- Autofilter - Link to 2nd worksheet?
- how to reference external refereces from a list
- Excel Function With Multiple Criteria
- Adding the same cell in different worksheets. Can that cell be variable?
- time sheet calculations
- Whats the best way to...
- Problem with Find and Replace
- Vacation Accrual Formula
- Nested "If" Function
- Help for a newbie?
- sumproduct wildcats
- column won't sum
- Linking with equals sign doesn't always work
- sharing rows of data across multiple worksheets within a workbook
- Return unique fields only - but not a filter?
- re: Rand function
- Can I Somehow load a Spread Sheet thru a Scanner
- Average of count in pivot tables
- Linking changing values (cells) between worksheets.
- Tools - Option - "move selection after enter"
- GPA formula
- Formula to get Relative Folder Reference to data in another file?
- sum product problem
- Linking arrays and Worksheet names
- worksheets lookups
- Counting weeks
- Overlapping or Duplicate Date & Time
- How can I do a lookup and get multiple row results?
- count function not working, keeps displaying 0
- sumif function
- Drop Down button with functions?
- formula results take up to 2 lines if needed, but keep border
- How do I get the color format to follow the data when referencing.
- lookup with offset?
- VLookup
- How do I stretch the height of a font in Excel 2003
- Count nonblank AND fill color
- how to find duplicate cells in large array of numbers
- copy text from 1 workbook to another by macro
- How do I use the "Proper" function? The instructions are vague.
- Sort columns by content
- formula to divide a monthly bill...
- Conditional formatting a full row triggered by a single cell
- If formula evaluating 2 cells contents
- #Value must be 0
- worksheets vlookups
- Can I import a folder's contents as a dropdown list?
- Converting negative/positive numbers to a CSV (Comma-delimited .TX
- SUM, OFFSET and CELL("address")
- How can I copy a row as result of an IF function
- formula suggestion
- Is there an opposite function to "Concatenate" in Excel?
- Which function?
- Pay Stub Problem help PLEASE
- Reverse false and combine with true true value
- Need to merge columns
- formula to use when number of rows changes dynamically
- Saving onto Floppy Disk
- Row Sequencing
- Formula for incremental increase
- Create conditional IF to format cells using 6 different colours
- Conditional Formating
- Assign values to text
- How do I sort worksheets in excel? i.e. Order them by date
- sumif on 2 criteria with worksheetprotection enabled
- Formula for incremental increase
- Finding an Excel value using one repeating & another value?
- Finding an Excel value using one repeating & another value?
- customising toolbar.
- subtotal - multiple criteria
- Look up a value as close as possible to ....
- Conditional formatting
- formulas
- Can I make the number in one cell automatically appear elsewhere?
- Conditional formatting a full row triggered by a single cell reference...
- Month Counter
- Sum product -Is column value in range/list
- Conditional functions
- Missing linked file - can still be referenced but can't find it!
- the option to send an exle file as an attachment is not there
- excel, how do I get sumif with two criterias?
- how do I convert euro values to GBP in excel
- cell formatting?? and making it so that it will move to the first option on a listing
- How do I create an equivalent VLOOKUP function using FIND?
- Pivot style return
- cell equation ?
- New Data Consolidation Question
- time conversion frustration
- finding end of document
- data analysis on fields with words not numbers
- Using Excel link (hyper?) and list functions
- Find Min of a row, but only greater than zero?
- calculate odd days interest
- How do I calculate total hours by rate of pay?
- How do I convert Meters to Feet and Inches?
- Sumif with a twist?
- lookup and sum
- watermark
- Absoluet Reference
- text has numerical values
- 'vlookup' and/or 'if' help!
- Excel
- how do i use the proper command
- HELP HELP HELP HELP HELP
- IF STATEMEMNTS
- Unwanted rounding of large number
- Adding Column in an Excel Sheet by Command
- why formulas have stopped working in Excel?
- filter 15 worksheets so i can print all on one page
- day/month/year in incorrect format for date format
- Grouping
- all worksheets have 2 descimals
- when editing a comment box
- Combine functions into one cell
- Excel help
- circular drop down list on different pages
- product function
- MsgBox with condition and showing details
- How can i get an If formula in excel to edit another cell?
- Select by multiple criteria (Excel 2003)
- count and limit radio button selections
- I need a system for keeping up with church members and finances?
- unique alpha's in order
- a question of differences
- Sumproduct Problem
- EXCEL: Is there a way to insert a picture into a comment?
- results display in filter function
- Purge macros
- select a string of characters
- Running filters using a macro
- multiple results when using filter function
- collect data from different worksheet
- Copying formulas with mixed references
- conditional sum question
- Future Value
- Using COUNTIF
- Sum If or DSUM help?
- re auto cloring of cells
- IF on the cell that contains it ?
- CSV file importing to other software
- sum or similar with conditions
- I have saved an incorrect worksheet over the right one.
- Averaging across worksheets
- can an excel spreadsheet be set to remove all hyperlinks
- cell equation ?
- Using LARGE Function
- Can conditional sum use wildcards in the formula?
- Two cell accumulator
- Illinois Personal Information Protection Act
- how would I count dates (not # of days) in cells that fall betwee.
- date criteria to select range
- Can Conditional Sum use wildcards?
- if statement
- Remove variable text in cells
- vlookup
- I cannot edit my excel. How do I do it
- IF function?
- 1 will be City, 2 will be Roskill and so on please.
- Validation List, Automatic Colors
- 1=City, 2=Roskill
- Hiding Rows using conditions
- Minimum Value & Cell Cross Referencing
- help
- vlookup backwards
- Need help with a function I'm not sure exists
- How do I undo an action when multiple sheets are selected?
- Using certain data from lists in other cells in Excel.
- Compare Data
- DATE Format
- simultaneous entry lookup problems
- Data Validation
- Kilometres Calculator
- insert verticle lines between columns
- Email only the filtered data
- Creating & Combining Macro to Functions
- Calculation
- How can I rank numbers based on other numbers?
- sumif and colored fonts..
- Multi-conditions with SUMPRODUCT and COUNTIF
- How can I get the XIRR funct to work for a positive first number?
- Look up function and Max function
- How can I return a cross referenced cell value?
- Thanx David
- V-Lookuo
- Count values in a cell
- filling information from one cell and filling another.
- Automate the Text Import Wizard (Fixed Width)
- Unique Values
- Delete text while numbers remain intact
- Array index, match problem
- colors
- substitute for =
- Compare Text in 2 worksheets where verbiage is slightly different
- How do I use the PROPER function?
- =concatenate With A Space
- Add items in column 3 if column 1 and 2 conditions are met
- Extract data from one Worksheet to another
- AND function in Excel
- Timesheet Date Calculation
- VLookup Problems
- Can wildcards be used in the Logic Test of an Excel "IF" function?
- NUF schedule
- IFSUM
- How prevent formulas to get external references/path to current workbook?
- excel date problem
- How do I change the number on copy sheet so I don't have to renam
- How to do matrix operation with complex number elements in Excel
- if functions
- Formula to determine shift
- Subtracting dates?
- formula
- Problem with formula in Excel
- NEED HELP! Cannot figure out complex function
- "IF" Function limited to 7 in a formula.... need 14
- Question about {}
- colums in uppercase only
- Payment formula problem..
- how do i count how many people are working between two times in e
- DSUM gives a #VALUE! error and I can't work out why!
- SUM.IF...probable fingertrouble
- Sum function across multiple sheets
- How do I set up an automated numbering system For my "Invoice Num
- First Number in a Cell
- PorductLog
- HD I build funct @if cell=AorBorC then ...else if cell=DorE then
- Dividing by unknown to get a number
- Microsoft Excel 2000 Subtotals with Group Name
- How can i swap between the tabs in excel?
- cell equation ?
- Complex =mid formula
- Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc.
- Displaying info in a new tab in excel
- time math
- countif question
- Data From One Worksheet To Be Used In A Cell In A Different Worksheet
- Array Formula? Lists?
- formula that will subtract a number that relates to text
- Removing Duplicates from a list
- Look up function
- Whats the best way to...
- Need help with Excel formula!!
- Test IF Two Numeric Values Match (from two separate Dynamic Ranges)
- How do i keep a running balance without adding rows each time?
- IF(ISBLANK)
- If(ISBLANK)
- Whether 3 diff fields are blank determines several different resul
- How to hide unused cells when running accumulated totals
- Modifying A Formula
- Future Value of single investment
- Display single value for multiple ranges?
- Adding an ongoing value to an Average
- I there a way to not print a cell(s)?
- How do I expand columns in a table and auto change vlookup in wrks
- Stumped by a lookup scenario
- adding zero's to a text cell
- how do I format a cell reference to move as source changes
- Summing a column
- Removing $$ Reference in cells
- Excel & MINITAB generated regression equations are different
- Array formula returning terminated employees
- ENTER DATA EXCELL SO RELATED DATA APPEARS
- need help with formula
- Setting up page template
- adding day (sunday, Monday) to date
- How do I set up an array using countif for 2 separate arguments.
- How do I use a conditional (IF) statement in Data Validation?
- Consecutive numbers in 1 cell
- editing custom dialog boxes
- Use Range Name in Macro
- variable across all worksheets?
- MATCH Formula
- I want to link, not just copy,Word source text to a text box in Ex
- Using a cell reference of a sheet in Vlookup
- Sumproduct Formula
- Vlookup question
- Auto Filter
- Changing the max length of a worksheet name
- excel function cumipmt
- "END mode?"
- how do i maintain one worksheet from data from multiple worksheet
- Step value
- Need Address Formula
- differences in groups of numbers
- HELP: How to Repeat Cell Content into a Second Worksheet ?
- Listing data from multiple worksheets
- cell shows 20. Formula shows 20. why not 540/27
- How do I use wild cards in nested array formulas?
- Troubleshoot resetting hyperlink base to a network drive
- Line adherence
- Running a Daily MTD average.
- INDIRECT(ADDRESS... Across worksheets
- How do I remove hyphens from a product UPC?
- How to save a custom header/footer on ea. sheet of a workbook?
- How to use the "Fr" function, what is agrument
- Identifying Cells with formulas
- Date Function
- Conditional Formatting?
- Create a Macro to jump to next cell
- Functions
- merge multiple row cells of text corresponding to one row of data
- Count blank cells since last entry
- sorting cells according to all cells in column A
- Can I change a cell and cause an automatic change in other cells
- VLOOKUP
- Pivot Tables
- Help to find duplicate #'s
- Adding dates to get a date
- DATA/VALIDATION/SETTINGS
- Stock qoute quiry in Excel 97 doesn't work
- Macro Help
- Display each row as one recrd per page
- How to convert DATE and TIME to text
- Excel worksheet function that will return the currency for a cell
- Look up for all sheets
- Excel help!
- Working with Lists in Excel 2003