- Nesting Functions with more than 7 arguements
- Formula to identify lower case vs upper case
- Autosum results of multiple if statements?
- cell resizing problems
- Increment and subtract Numbers
- Macro to Find & Replace
- Find then offset.
- Yikes! Look ups? Match?
- Conditional Addition
- Link to worksheet whose name is stored in another cell
- Help on EOMONTH error (have Analysis Pak installed)
- Help on Dates
- How do I get formula result of 3.56 to round up to 4 automatic?
- How do I get formula result of 3.56 to round up to 4 automatic?
- Protecting worksheets
- Summing a row excluding a text character
- global vs relative format
- Formula
- finding the right formula
- Comparing Lists
- How do I get a cell to count values from a list dependent on anoth
- Macro - msgbox
- Convert Text to Numbers in a Macro
- How do I automatically rename a sheet from the summary page?
- Function to skil blank cells/lookup specific value
- Countif
- Need a formula
- UNABLE TO RECORD A MACRO
- bullet in excell with indent
- can you help link images to excel.
- How can I write multidimensional arrays in Excel Formulas?
- while opening a normal file, microsoft excel displays cannot open
- COUNTIF across a number of worksheets
- how pmt function works, what is its background / machanizm?
- using vlookup for words w/different indentation
- spacing numbers in 1st column by inch intervals of 2nd column
- first number in cell
- forcing excel to update the Cell Link when copying Combo Boxes
- there is no such currency as Maori
- How do you rank in order numbers from highest to the lowest?
- subtotals
- how do you drop an HTML spreadsheet into excel
- delete part of a row based on certain criteria
- Formula Help
- IF Functions
- Cell with zero to appear as empty
- Hypelink and Paste
- set up an index linked to work book tabs
- assigning a value to a cell
- Text Search in an Array
- NEED TO SHOW EACH DAY INBETWEEN TWO DATES, help please
- Fixed decimals worksheet specific
- help with worksheets
- How do I COUNTIF from previously counted data?
- Control plus click will not select multiple boxes
- "paste special" a hyperlink to another worksheet...
- formula help
- figuring commissions based on gross sales
- Timesheet coding & calculating
- Random only once
- How to merge monthly workbooks into a quarterly workbook??
- comparing two spreadsheets using vlookup and compare
- Urgent! Help! duplicate MATCH
- Freezing column headings
- Visual basic macro move cursor down 1 cell
- if D1>10 then A1 should be red
- Auto-fill, to inventory 45 RPM records
- add in that shows names of tabs in workbook
- How do I enter a formula so that it follows the sequence of line#
- Autoinstall Add-in (Excel)
- how do i use & sign without it thinking its a formula
- excel formula
- SORT List Items in Pivot field
- drop down box
- Detect Presence Formula
- Cell Formula
- Linked date field in worksheet defaults a blank field as 1/0/1900
- Limit to number of named ranges before Excel starts messing things up?
- Counting instances of found text (Excel error? Or user error?)
- Worksheets are not protected - but Tools menu has unprotect w/s?
- putting images into a dropdown list
- On time
- Need formula: too complexe for me..
- excel drop down list of hyperlinks
- Flag for Follow Up
- If / Match function help
- Problems with time format in excel
- how do I program a cell to automatically fill in today;s date?
- How to write macro that selects relative locations
- Format cells to change a number from a positive to negative
- using data entry to change a fill color
- Putting pages in alpha order?
- HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET
- can you nest sumif functions ?
- Formulae to work out break even point?
- Formula Req'd - Autofilter limitation workaround
- merge columns
- new worksheet and rename from cell contents macro
- Changing a Number in a Column Using Arrays
- Forms and Data
- how do I make a template from an existing excel spread sheet?
- time sheet determination of what day and time rate
- Can not find Pivot function in office 2007
- Conditional formating: Compare two columns with Inserted lines
- How do I add totals from a range of dates depending on the month?
- Excel NPV initial cost in value1 and first year return in value2?
- HELP!!! Counting Selective Responses if 2 conditions are met?
- Cell reference in a range
- Preserve negative numbers in following macro
- How do I link specific rows of data from one workbook to another?
- why do zeros after decimals drop out of excel
- Find part data in row range?
- My formula's answer is calculated, but disappears
- How do you compare 2 different spreadsheets for duplication?
- NEEDING FORMULA Please
- Change second digit from 4 to 6
- Counting number of cells that contain certain text but not cell tw
- Trend Function
- Excel - Copy and Paste Footer Data
- IF statement
- Formulas
- Autosum and Manual Sum not working
- Concatenate Doesn't Work for this
- Inserting a space after a comma
- how to automatically number rows in an excel worksheet
- How do I assign a numerical value to a textual entry to calculate percent completion?
- Could this be possible?
- Fill in if..
- Why won't advanced filter return filter results?
- Data Validation Question. (oops...sorry)
- function to count the number of cell references in a formula
- How do i get Excel find a sum of #s om different pages/books?
- help with VBA
- Re: Weekly Date Function(s)
- how do I open a hidden column?
- can excel calculate time increments in a formula?
- how to amortirize unpaid late interest?
- how to i add the first six values of of a row when in various colu
- Troubleshoot horizontal scrollbar
- disk storage number format in excel?
- multiple conditional formatting
- Adding/Analyzing Data From One Worksheet to Another
- How do i increase the height of the worksheet tab in Excel?
- Why would a pivot table lose its character?
- conditional format if the cell contains a formula
- SUMIF across multiple worksheets
- Excel Row Limitation - Import External Data
- tricky search and replace
- Sorting
- when i sort, how can i get the formatting to sort along with text
- IF..AND Statement
- #VALUE about function Find
- copying cells to another worksheet
- Macro doesn't insert image when spreadsheet is protected
- How are symbols inserted in a data validation look-up list?
- Autofilter - failure to display ALL data down a column
- Problem with links not working correctly in spreadsheet
- how to get the column number from the corresponding column name denoting initial..???
- how do i update contents in 1 workbook from pivot tble in another
- Text format & number format
- How do I calculate an average by a certain percentage?
- Multiple Find and Replace in one function
- my vertical text, across several rows in Excel, is not appearing
- How to chose bold text in a sentence in Excel?
- Excel formula
- Match Lookup question
- sumproduct to count two arguments
- inserted a comment
- taking certian data from worksheet one to worksheet 2
- Avoiding counting the same cell twice
- Searching and matching in sheet (urgent)
- return worksheet name that a result came from
- Need help wiht a macro for autofill rows
- SUMPRODUCT PROBLEM
- why don't my functions in paste special work?
- sparklines for excel
- AVERAGE function
- Match duplicate data in 2 columns in a worksheet
- Combining Data from Seperate Files
- formula for taxes
- need list of formulas
- I want to set up a cell where 1=3 so when I insert 2 it will = 6
- import complex numbers to excel
- I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
- data sort/filter
- Duplicated cells
- Gauss elimination
- formula help
- Spacing in cells is preventing addition
- how to do formula with a fix discount
- Test Cell For Multiple Criteria
- Formula to Create Consecutive #s for Non-Linear Dates
- Using different spreadsheets to obtian values in cost equation
- How do I enter a function that has more than 7 nested functions
- Applying data to a spreadsheet..help please
- How to show cell content in the toolbar for editing?
- using a cell value to control a counter inside a macro and displaying macro value
- formula to give text of value($1.01 = "one dollar and one cents")
- SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREATOR.
- Need help with this
- Convert Dates
- Bond duration for monthly coupon
- Formula using IF? Vlookup? Lookup? I'm not sure.
- Tax Status
- Help to write a formaula
- Forumla Error
- I cant find VLOOKUP on my French computer ?
- formula won't calculate unless I click cell
- Add date or text to sheet name formula
- Problems with find/replace function
- I need to total col, but pick up number in other col. if not 0
- Dynamic Named Ranges Viewing in Name Box
- I recorded a macro, how can i share it with others?
- to get the same answer from a normal calculator
- to get the same answer from a normal calculator
- Calculating Age
- Looking up the most recent date
- How do I sum different rows
- What is Wrong with this function??????????
- Syntax for a relative formula
- auto copying
- Convert to Numbers from Smart Icon - Won't save in Macro
- SUMPRODUCT - Additional criteria
- Creating a clickable button
- In Excel can fill colors be arguments in formulas ?
- VLOOKUP, INDEX & MATCH ERROR HELP
- referencing a cell
- I type in a cell,it is giving me the ##### instead of $10.99 why
- Filtering a column, where it stopped showing records
- Auto insert date/time
- How do I make "some" of the cells in excel the same size?
- How do I change the appearance of a hyperlink?
- Number Combination finder
- Array
- how to omit printing data highlighted in red
- Retrieve and group row data by multiple critieria
- Convertig Number to Text - equivelent to single quote
- printing worksheet in newspaper columns
- Linking Jpeg Images to excel.
- Networkdays plus Sundays
- This is not a QUESTION BUT A THANK YOU
- Provide list from all columns marked with and "x"
- How do I create "push buttons" in Excel?
- Offset of a minumum
- Need help matching...
- Replace (') to space
- How can I find the greatest possible sum within 12 months? A newbie...
- How do I set up 16 team fixtures each Sunday
- How can I have 2 criterias within sumif function
- Formatting from text to numbers
- How to hide "0" in a cell?
- String Value not numberValue
- Limit number of character per cell to 26 in excel
- SUMPRODUCT has never let me down BUT...
- How do I display the result of one cell each time a change anothe.
- formulas between sheets
- DO I MERGE 24 WORKBOKS INTO 1 WORKBOOK?
- IF function won't do want I want
- STATISTIC FUNCTION USING EXCEL.. I NEED AN EXPERT
- personal.xls will not load
- Transport problem with Excel
- Searching for partial text match in range
- Find numbers in an array that sum to a certain number
- Any Good Book on Excel Pivot Tables
- pivot table pull down filter
- Update PivotTable
- clearing cells
- IF formula help
- Sumproduct question
- How do I sort my data by color? (color applied to rows)
- FIND LAST CELL WITH DATA
- nesting formulas
- formula seen in cell but not working
- worksheet name in formula
- SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx
- How to make a cell address remain constant when copying a formula
- Number Bullets
- LOOKUP a phone number?
- Editing Calculated Fields in Pivot tables?
- Link a cell from another worksheet as a result in a function?
- Off topic: Get Email when someone responds?
- COUNTIF with pivot table results?
- sum worksheets with a certain criteria
- how do I get exact amount when adding up a column?
- what does this symbol do in a excell formula? ^
- Counting number of instances in a range
- Adding A range of cells that have a certain text letter
- Counting
- Index heading when cell is populated
- Cell contents to refrenence cells
- How do I have excel setup so formulas is connected between sheets
- Approximating a curve
- how do i export information from an answer from a drop down menu?
- Finding most recent date by customer number
- Re: Sum every other 5th cell
- Converting test to numbers and adding into a summary page
- How to have a cell show as blank
- Loading Data into Multiple sheets in 1 book
- Unable to Insert Worksheet/Move and copy worksheet Excel 2003
- require cell to edit
- I want random numbers generated without repeating numbers
- Excel Program
- #N/A in calculations
- want Replace ALT+ENTER to SPACE
- Remove Dashes from Social Security Numbers
- Why do people get different views of a report on the shared drive
- Lookup
- Is it Possible
- Set Calculation mode for a single worksheet
- Identify Duplicate Items Based On Multiple Criteria
- Can excel list the possible combinations from a range of cells
- TO COUNT & TOTAL IT
- Saving .xls files to .csv - formatting?
- How do i insert an outlook msg file object in excel
- Creating a list of numbers in sequence
- Scatter chart
- while opening a Office file i am getting Data import wizard
- MinMax Buttons
- Convert Number to Words
- In Excel, print a business invoice from order data in a worksheet
- How do i get a list of Excel formulas that can be used?
- Can You Do This....
- remove zero value cells when printing.
- HOW CAN YOU ADD 3 SPREADSHEETS AT THE SAME TIME?
- Counting
- How can I display a list of all cells referencing a particular cel
- bunch of "yes" or "no" entered in row, output 1 if a single yes
- Creating a Detailed List from a Summary List
- dannycol
- copying data from sheet1 to sheet2
- entering text on an excel document
- Summing a column with formula value...
- Re: Summing values incolumns from row cell L7...
- indirect
- setting up payroll
- linking across worksheets
- How do I customize Excel print options?
- How do I combine data from 4 worksheets?
- Running total in Excell
- Vlookup partial text from a single cell
- Can you lookup a value & get the cell reference?
- Add New Worksheet through VBS COM Object
- Can I use a conditional if with a range <>
- Type info in one cell that automatically repeats in other cells.
- Create drop down that will show a range.
- mod formula used with midnight
- linking to contents of a cell vs cell address
- How do I copy worksheets with drop-down menus intact?
- I need to change cell string lenths prior to upload into sql table
- Converting currency from US Dollar into Canadian dollars from column A to Column B
- How do I DMAX only part of a column?
- Automatically replace cell value with next in list...
- My files in excel have been inverted .
- Named range into an array
- Find address of active cell
- sumproduct
- Need to insert a template with formulas into an existing workbook
- How do I make sure all empty columns are present in a .csv file?
- VLOOKUP returning errors
- Need formula for looking (finding)
- why can't I average 36 values?
- Excluding VAT for selected item
- How do get I my schedule to open at the current date?
- Use of Array Pivot Table for Percentile Calculation ...
- Member database question!
- Maybe an array is needed?
- Using IF function in excel to search for text across cells and she
- How to save Excel, using macro which takes the name from a cell contained in it?
- How do I add Watermark, across all the sheets in the print range,
- Multiplying the contents of two cells a variable number of times
- Posting lowest values in a seperate worksheet.
- Statistical Formular
- wich formula
- Adding picrutes into cells
- pivot tables not refreshing correctly
- entry removed from source table remains in pivot table pull down
- Create an annuity in Excel having monthly deposits plus interest
- how do i get a cell in a sheet to show the last 1024 characters?
- Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT'
- How do I calculate the distace between two GPS coordinates?
- SUM() and OFFSET() CAUSES #VALUE
- what causes this error" too many different cell formats"
- Excel 2003; spreadsheet with filtering; deleting rows
- Calculation vs formula
- Selective Deletion within a column
- limit characters returned a cell reference
- Don't want to return blank records
- Automatically generating a number range
- Sumif across workbook tabs
- Using IF function when "#value!" is present.
- ignore #N/A in a sum?
- How to link a drop down value to a cell in a different worksheet?
- Help with rounding formulas
- Output client name based on date...
- Sorting rows by pairs
- Working with hyperlinks
- perform an event if mouse rolled over an object
- Delete first two characters in a cell...
- why is the zero falling off a zip code in excel?
- Document at 100% doesn't print correctly
- Help needed on Macro
- Help with formula
- Text String Seperation.
- Need a AHLookup function
- Formula Help
- Excel autosave doesn't save every 10 minutes as shown.
- Excel: Changing "numeric $" to "text $" in a different cell.
- formulas appear as text instead of doing as expected
- How do I copy a group of worksheets with named ranges in Excel 200
- LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook)
- Compare two strings
- update link
- Please help w/Sumproduct!
- a cell to display number of days in a month given in another cell
- Converting Numeric values to Text
- Convert column data to semicolon delimited text string
- total on filtered data?
- linking items from drop down list in excel
- Problems with MAX
- Complex IF
- How do I arrange the worksheets in my workbook alphabetically?
- How to remove commas from a downloaded .dat file?
- sorting
- Creating an Invoice
- How do I delete specified times from a spreadsheet
- Re: Frame Type swap action, how???
- Function for Totals
- Extending VLOOKUP
- strings in a range
- Copying From Closed Workbooks
- Re: Unhide function grayed out, why?
- Name & Number in one cell.
- What is the Excel equivalent of the CELL function?
- Excel formula help needed-How to separate last and first names?
- copy formats vlookup
- automatically fill in blank cells??
- Sum Valour From different Columns
- formula to add certain data and then move to another sheet
- Delete the number "49" from each cell in a column
- Random number selection
- How do I enable emailing a worksheet in Excel?
- Limiting what it displayed from drop down menu
- Return Min & Max value of Conditional Formatted cells
- Code to clear contents
- I've changed the way my formulas are displayed !!
- Can't figure out
- Toolpack Correlation Matrix
- Vlookup by rows and columns
- need formula for # names listed * $5
- Changing one cell colour by inserting date in another cell
- Referencing other workbook.
- How do I restore my hash key on my keyboard?
- Excel 2007 Display value based on values in another column range
- Generating an auto number
- Transferring data from one worksheet or workbook to another
- simply function not work
- Combine Data
- How to retrieve character from a string for excel?
- Adding Prefix
- Reading results for automated Myers Briggs Type Indicator?
- arrange contents of a table in Alphabetical order in excelsheet
- when entry removed from source data pivot table hold in drop down
- entry not removed from pivot table drop down
- entry not removed in pivot table pull down filter
- update week to week in excel.
- update week to week in excel.
- How to use vlookup when lookup contains number and letters
- How to extract the url in a hyperlink using a formula
- Nested If Function
- What is the Function for Inverse sin
- Inverse Sign
- Why does the data shift out my outline when I refresh the Pivot table?
- problem conditional formatting?
- I would like a function to return a value that fits its range
- copy range of cells with blanks then paste without blanks
- Looking for gurus that knows show and hide functions on a pivot table?
- What is E?
- Excel worksheets needs to sort ascending or descending order.
- Date changes to formula when entered in a cell
- using IF & AND in formula
- Apply green to current date, red to 2 days overdue and none if pai
- Indirect
- Consolidating data from 4 sheets to one!
- Protecting a Sheet - Issue
- How do I combine an if and min formula?
- "AND" & "OR" in a IF loop
- Empty Chart Values
- Excel error:ROUND(1000.2555-999,3)=1.255
- Select and Display top 5 results
- Interpolate, Interpolation, VlookUp, HlookUp, Read a table
- Copying forumla for vlook up but changing the column Index #
- Day of week question
- how do i sort a set of averages and have them list in descending o
- rolling twelvemnoths formula for attendance calendar
- Count the number of times a cell value is within a specific range
- My data validation cells don't activate when I click on them
- Help with an Array
- How to do integral calculus in Excel spreadsheet?
- VLOOKUP Changing reference cells in autofill
- sort numbers high to low, copy to new cells with associated data.
- Hide Columns
- spreadsheet question
- Macros inside Excel
- I need help with a text and quantity summary report.
- Change Font Colour and Background If Q
- help with change to formula
- Protecting Page Set in spreadsheet / workbooks
- How do I break a large .CSV file into several small Excel files?
- Picking out column in named range
- HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET
- HOW TO GET A SUM TO NOT EQUAL A NEGATIVE
- range inside RANK formula based on contents of other cells
- HOW DO I TRANSFER INFO FROM POSITION CHART TO A SCHEDULE SHEET?
- How do I get personal financial templates(blank) for studies
- delete "-" in cells
- want to create a time card to add time
- I need help to set up a spreadsheet
- Year-Days-Months
- If function
- define one cell location throughout workbook?
- protect cell ranges in spreadsheet and have data filters on
- How can I use nested IF using OR in a pivot table?
- Dates Before 1900
- Vlookup approximate match question.
- i have a check box that keeps clearing out my cells content
- Date Format Question
- Date question
- Invisible precedent lines. The system draws them but I can't see t
- Opcional Values
- how to print file address of the file on page?
- I need to search for then extract a specific portion of cell data...
- help with SUM of hyperlinked numbers
- Default Sort Order
- How can I update a Attached Custom Toolbar in a shared file?
- Linking cells for a form
- Repost of function problem
- 4 conditional formats?
- Create a date column (MM/DD/YY) that fill sout automatically?
- How do I dictate cell to cell progression in a protected worksheet
- Sum Product Question
- Repeating a Macro Based
- Having this tablet X;Y values how can I make interpolate between e
- Formula for excel PLEASE HELP
- Adding numbers in cells based on colour
- how do I add multiple fields together?
- linking a cell
- Fourmula help
- arguments in MATCH and OFFSET functions
- Drop Down List
- How do I set up Excel to handle complex (& imaginary) numbers?
- Range (Mabe) Help...
- access password to worksheet
- conditional formatting text
- How to set up a cost estimate spreadsheet?
- hlookup & ?
- Sumproduct (Sumif) with Nested Or Criteria
- autofilter off
- copy rows to new page
- Needed Help..
- Random scramble cell contents
- COUNTIF across Multiple Rows and Columns
- How do I return a value by clicking an associated list box item
- reference for last used cell in row
- multiple sumproduct with dates
- how do i find and delete all empty rows in an excel worksheet
- can vlookup look up the result of a function?
- 7 day workweek timesheet - excluding lunch
- Can I do two validations on a cell?
- Odd excel usage question:
- urgently required help
- How do I lock VBA?
- import data in rows instead of columns
- Linked cells don't automatically update in Excel 2003. Why?
- tally of nonblank cells
- New to Excel: Need help finding functions. Please Help!!!
- LookUp Question
- Hi Leo
- Excel "if" Bug?
- transposing cells with formulas
- Deleting Named Ranges
- counting dates
- Auto Filter problems...
- Testing someones skillz...
- Save Linked Doc in Another Folder Without Changing Link Path
- Rank with an array formula
- Run A Macro On Selected Worksheets
- How to create spreadsheet that averages up to 10 columns of data
- CONVERT TO (###) ###-####
- pivot table question
- How to reference one column against another
- offset formula or any other function??
- Add to IF formula
- Copy/Paste Problem
- how to count a column based on condition of another column
- Restoring fields in a pivot table
- Public Function Question
- Rounding formulas for negative numbers
- Tan and Gold have disapped from my color scheme
- linking cells
- Can I compare two worksheets using Excel?
- Removing excess rows in excel
- Custom Function basic
- Calculating number of workdays
- if a vlookup returns "#n/a" how can I make that zero?
- Cell shading in linked cells
- Functiona Language..
- Re: Combining VLOOKUP functions
- How to cancel a find & replace command "midstream"?
- Excel function
- How to create a pivot table
- Direct reference
- Table of Contents (Exact match Hyperlinks?)
- Add row above TOTALS to all sheets when done in one sheet.
- how to merge 2 colomns
- Copying data depending on cell value
- Re: Enable Macros Pop-Up Dialog Box???
- Sort by column problems
- SORT A LIST OF NUMBERS AND LETTERS A,B,C,D AND FIND MAX
- Excel problems
- I found a tickets site
- If a cell is specified by the user, use formula.
- Is there an Excel Function that coverts: 37 to thirty seven?
- Formula wont copy! Help please.
- Conditional Formatting for Excel XP.
- formula to show a formula in a different cell
- Working with logical functions
- FALSE argument in VLOOKUP
- Predicting a Number From a Time Series
- Toolbar Button Image Question
- Age Formula
- Why would Show All not be active in Filter part of Data menu?
- How do I caclculate a ratio where the outcome is X to 1
- IRR function when the cash flows are not in array?
- Creating a List From Worksheets in a WorkBook
- cell selection appears locked. How do I unlock it.
- Do I use conditional formating?
- Array Formula Help
- Need formula help please.
- How do I find points on a curve between known points?
- Pasting formulas but not the links help needed
- functions
- functions
- Counting based on values in two separate columns
- freezing formulas when cells move
- formula for copying from one sheet to another
- Mile value
- How can I create a percentage increase formula?
- Net Present Value Question
- Excel 2K3 Macro - Find and Update
- Standard deviation calculation
- Is there a keystroke to go between tabs in a workbook?
- Is there any way to use HLOOKUP in an array formula to return multiple matches?
- How can I record the date of last revision in footer?
- Various rates applied to various cumulative balances
- rounding down to positive when adding cells
- Formula or Function providing Mile value in a cell from 2 addresse
- copy if
- sum a row, but just the cells, where there is a number.
- total and summarise data
- table data
- returning all matching values in column A that have the same value for columnB
- Pivot Calculated Fields
- Mouse not selecting area correctly
- How do I use 10<J3<20 in an IF Formula?
- Default of IF statement doesn't work when copied
- IF AND
- Do Ms Excel able to lookup more than 1 date in spreadsheet?
- link to other workbook with changing filename
- How can I switch the pmt function to calculate based on a 360 day
- How do I change the fill color of a cell using an "IF" function
- hide mouse over link path pop up box
- what setting needs changed, my drop down box displays upwards?
- change time into simple number
- Highlighting Duplicate Values
- Macro not working properly when the file is shared
- RE: Index Match Concatenate and Screen Size
- October Excel / Access User Conference
- IF & AND function
- Priorsheet Function Problem
- How to perform cumulative addition in excel V6=V6+T6
- want to use list, while using if function?
- New button on toolbar
- Index Match Concatenate
- Locate unique items
- Go to Last edited cell
- How to return multiple instances using VLOOKUP
- subtracting date and time formats excluding weekends
- Re: Sorry, here goes again!!!
- Re: #Value! error
- Re: Look-up and Compare Table Range Then
- Charts can the end points of 2 lines be moved as one?
- problem with date stamp and protected cells
- how do I obtain position of specific value in a row of numbers
- list comaprision
- NETWORKDAYS calculation returns inconsistent results
- How do I select colors instead of numbers for rating risk?
- How do I add N/A to a selectable cell with an arrow?
- Complex Function?
- Create a macro that finds values then sorts
- Copy Formula Is conditional format
- How do I get my function to subtract .5?
- combine 2 tables of data into one based on date
- NESTING FORMULA
- How do I create a floating text box with hyperlinks
- Finding Characters Conditionally - Easy Question
- How do I draw an arrow in my excel sheet?
- Insert copied cells
- Time Sheets - regular vs overtime
- lock in current decimals when quantity changes.
- How do I convert kilograms to ounces in excel?
- Display data from multiple worksheets' cells in one worksheet
- Create a list box/combo box with hyperlinks
- HOw do I merge two separate months of sales figures?
- Combine text and today's date in a cell
- Conditional Format??
- "2-Way" Lookup?
- Return value in adjacent cell
- Macro Modification
- "Reading"the logic behind too-long command statements
- How do I use a different 12-month date for formulas in excel?
- testing for character strings within a cell
- How to alphabetize entries in microsoft excel?
- "Textualize" another cell's formula
- Totaling columns in a row with duplicate data - Pivot Table??
- HELP WITH THE IF FUNCTION
- Excel should sort by month
- Max Value of a cell
- Highlight
- What is wrong with formula?
- spread sheets - adding
- LOOKUP is delivering inaccurate data
- Goal seek gone
- Extracting a Date from a YYYYMM number
- daverage
- Fomulas and calculations are no longer working on my Excel Spreads
- Complicated cell counts
- Generating a list
- IF function
- duplicate check
- highlight dates when it arrives on a spreadsheet
- Max Values
- Dynamic Ranges and Offset
- Picking out a Period, in relation to certain cells
- attention [email protected] re alphanumeric
- How to convert number into word in excel i.e. 100 to one hundred
- Gridlines are not printing in Excel although box is checked
- File Names
- Shortcut for entering $ within a cell
- diplaying coulmn name with result in excel
- What formula?
- Need conditional formula
- Excel - Lock date in multiple cells
- formula
- conditional formula
- adding "Data Analysis" to my Excel
- How do I correct rounding errors in Excel formulas?
- can't get excel to calculate
- Summing Values in a Row
- Wookbook will only print the first page, Why?
- Compound Savings Plus Pay Increase
- How do I enter updated data into Excel worksheet?
- How can I name worksheets in Excel according to named ranges?
- Formula to test for existence of external file
- Validation on date
- How do I convert GMT date/time to different timezone
- ISREF Formula Function
- Fill formulas into adjacent cells does not take formula only data
- what does a high covariance mean?
- Ascii iinput file - separate text from Numbers
- Compare data in 3 cells
- Assistance with password in Excel
- Fill in Color within formulas
- Cost Coding? How in the.....?
- UDF... PLEASE HELP!!!
- calculating the mean
- Text Displayed
- checkboxes and cell-link references...is there a better way
- How do I set up a list of all of my music records
- sales needed to cover costs that increase as sales do
- Macro HEEEELP
- Excell formulas
- Conditional Formatting Merged Cells
- Help with OFFSET statement needed
- Should be easy how to
- Date Format Not Working
- Help with Conditional Formula
- Excel_Format Cells_Numbers Tab_should have 'Measurements' setting.
- Macro Question
- How do I cause a sort to quit seeing a normal row as a header row
- Using the AND and OR functions in the same formula
- Help with IF statement needed
- Macro Prob
- function to seach directory for file location
- HELP! PLEASE
- Problem with Goal Seek
- Hidden Range Names
- (date diff.) A2-A1=#value! ?
- NPV of future investment and savings
- cell to cell text and link
- Very puzzling - how do I reference cells without the blank rows???
- How do I convert time to the nearest 1/4 hour with a 7 min. window
- inserting columns inclusion in formula
- rounding numbers
- calculate difffernce in time in attendane eg 0830 - 1750
- How to count nos. on 3 criteria
- Count Column Difference
- Cannot get VALUE function to work with cell references
- Use look-up table in Excel and enter into a "county" column, same
- Make a printable version of the Excel formula help page.
- confined space entry permit
- COUNTIF or SUMPRODUCT?
- Sum IF
- Dual Formatting in Macro
- round up
- How can I change default row numbers in Excel ?
- AutoSelect? in Drop Down List Box
- copying info from one cell to another, changing the format, but leaving the number
- condition formating
- Can a column of data be searched from bottom to top
- Help with function on LOOKUP with Text
- Change Cell background color by selection
- How can I track numbered inventory?
- divide records equally among multiple employees
- Count occurences in array with condition
- Formula to open an Autoshape
- how can I send a cell value to another worksheet?
- Adding more than 3 cells (2003)produces "0" but no error message
- Summary Sheet
- Work Break Down Structure templet
- How can I get assistance on Excel Formula?
- Weight tracking formula?
- Repete Dates at a value of 28 days, 56 & 84
- converting hours to minutes w/o VBA
- ticket counting
- summing values in a data table based on criteria in another column
- LOOKUP problem
- How do I match 2 cols on two books and get price info for all matc
- identify nested parentheses
- repeat summing?
- Crazy Question here
- How to use the 'if' - function? Pls teach me...
- rotating list
- How do I choose first value greater than 0?
- Refer to Named Range on another sheet for IF function
- alphanumeric range
- Lookup through multiple sheets
- Using MIN Function on cells containing formulas
- Run formula only if values are enter, otherwise leave blank
- multiple condition lookup and match cell format
- returning a value from a string in a single cell
- can't use scrollbars on large spreadsheet, they bounce back
- How can I set the number sequence on the invoice template?
- INDEX function multiple columns & rows
- Counting cells that don't contain certain text
- Convert stored numbers into a set naming convention
- Help with function
- Help with function
- Creating a List
- Date formula
- if vlookup
- move column on condition
- Need help w/ logic statement in excel
- Sorting more than 3 columns
- Macro Question
- Prevent Row Height from increasing when Pasting lenghthy text into Cell.
- Insert spaces in String of Numbers
- Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells
- Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells
- 12ths denominators for fractions in Excel (for pension calcs)
- New numbers
- How do you suppress duplicate lines?
- wrapping text and vlookup
- Annualized rolling (moving) average
- How do I apply conditional formulas across multiple columns?
- Can SUMPRODUCT be used to extract varying data in a column?
- Rounding dollar amounts up/down when cents aren't part of the fact
- how do i square matrices?
- Conditional Statement to Compute Average
- Two "if"s in a formula
- HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?
- Configured cell that looks like a combo box.
- Conditionally Formatting
- Set default value
- Rows to repeat at top... ON SCREEN
- Need some help
- Copied tabs
- how to merge many cells to one cell with keeping all data
- how to merge many cells to one cell with keeping all data
- how to merge many cell to one cell with keeping all data
- month formula
- Why can i not see my drop down menu ie file, edit etc
- if + if
- Shortcut keys not working
- More than 7 nested IF(AND...
- Can the Row_Index_Num in HLOOKUP adjust relatively?
- help me is it possible to add to multiple cells without changing t
- Significant number rounding based on key cell
- How to switch data between cells?
- Consolidate Several Workbooks into One
- Fill cell that is blank
- Split data in a cell
- worksheets linking in Excel?
- lookup multi values
- How do i use a combo box or drop down list to preform a calculatio
- PV Function
- Pull Out Last Name
- OR Functions in a Conditional Formatting Furmula
- how do I lock only a few cells in Excel within a worksheet?
- Can I undo changes I made days ago in my Excel spreadsheet?
- Combo Box
- Extract within a cell
- Pivot Table Sorting
- Conditional Formulas
- Conditional Formulas
- I want to us Pivot Table to calculate the % of one Item ("Yes")
- How do I sum between any two entered values in a vlookup table
- Searching for Duplicate Text in a column
- Accessing sheets based on cell contents
- Color formula function
- Copying formulas without changing previous results/calculations
- how do i write a function to display a list of information
- I want to use a cell Value as a named Range in a Formula
- moving average
- Macro Question
- Add a text to rows option
- Creating a number from different fields.
- look for multiple entries
- How do I convert time listed in hours(e.g. 170:41:19) to seconds?
- How to obtain the number of filtered records in Autofilter
- Golf Formula Help
- Help With Macro Code??
- worksheet function
- Connecting two databases in MS Query
- How:Add New Worksheet that copies the cell of the previous sheet
- PLEASE add median in pivot tables PLEASE. PLEASE.
- cifras en letra
- Problem With An Average IF Formula
- Sumproduct across multiple worksheets
- How do I get Excel to not print blank pages when using outlines
- Rename a Worksheet on Input of Value in Cell
- Adding up number of yes, no, maybes in a column
- Referencing Data
- Problem with copy and paste together with macros
- Why does my shared spreadsheet have formula errors?
- More than 15 digits in excel cell it turns them to zeros. Fix?
- Excel Cell Format
- Calculate Elapsed time: difference between 2 Date/Timestamp perio
- Read only on CD drive
- TRUNC zero giving odd results?
- Can I link cells so that copying one copies all?
- refresh macro
- Can you link HLOOKUP AND VLOOKUP formulas and return their interce
- Filter or Look up?
- List of excel 2000 formulas
- Problem in Excel
- If then formulas
- Count Cells that meet Criteria
- How to get the address of a cell
- HLOOKUP using a named range returns #VALUE!
- datas of one Excell sheet will automatically updated in other workbook
- Conditional Formatting Q
- Looking up worksheets for values
- AUTOFILTER
- Pivot table from CSV data, problem with percentage of total.
- How do I do Conditonal Formatting with formula progression
- merge 2 cells and change format
- adding and subtracting columns
- Macro to call-up UserForm
- changing text to numerals
- How can we tranfer data from iSeries in MS-Excel 2003 with SP2?
- Running balance!!!...?
- Can I format telephone numbers?
- allocate different colors to each number
- Need Function to look up value and return a text value?
- Can you get around the 7max IF function?
- How do I add times calculated using =TEXT(D40-C40+(F40-E40),"h:mm"
- WHEN I GROUP IT ERRORS WITH 'CANNOT MOVE CELLS OFF WORKSHEET??
- Changing Tab Colours
- How do I unlock an Excel spreadsheet?
- adding cells within an array
- can I set an excel spreadsheet to print in sections
- How do I write a VLOOKUP function that returns 0's, not neg vals?
- character limit for linking files
- Pivot Table Calculated Field
- Printing Excel Sheet with borders
- The worksheet option under "insert" is gray (unavailable)- why?
- cell that only a certain number may be entered
- How change days of change history tracking?
- Cell display worksheet title
- lookup info in another worksheet
- limit on embedded IFs ?
- DateDif ?
- trying to change Proper function results to text?
- formulas for linking cells in different worksheets
- File Size Problem
- DATA VALIDATION
- Functions not Calculating
- excel, how enter >15 digits in a cell without rounding off last?
- Average IF Question
- DMAX wrong calculation