- hiding worksheets in excel
- Date Calculation to exclude weekends
- vlookup: I have to double click each cell to get correct results?
- Filters in excel
- FVSCHEDULE should allow cell reference for interest rate schedule
- Forgot how I phrased the question, want to go to thread
- Help Convert "MM/DD/YYYY" to "YY:DDD"
- compare lists
- Excell how to make a cell rotate names when taken off top
- pivot table and groups
- how do i get excel to display the result of a formula i build?
- Problem with cell shading
- VLOOKUP Error with "TRUE"
- How can I convert a Number into words. Ex: "10" as "Ten"
- Grouping combo boxes
- How to quickly divide a cell by another cell in a different column but same row?
- "+" in DSUM field?
- how do i total up different pages all on one page?
- counting cell color help
- copying VLOOKUP
- DDE Chart
- Default Information Showing Up
- indexing problem, I think
- Change the path of a Microsoft Query?
- Compare multiple column of data and list out common and unique component in adj columns
- maintain worksheet reference
- Trying to use IF but I don't get it
- unable to edit any of my workbooks
- Compare and copy
- How do I copy a function formula?
- ADD PREFIX TO COLUMNS
- Automate a complex decision structure
- finding rightmost location of a character
- counting digits, not numbers
- How do I get the concatenate function in Excel to display results?
- Error message using subtotals
- Making cells show nothing
- Rolling over a Remainder
- How do I change several hyperlinks at once in Excel?
- Print a range on multiple worksheets on one sheet of paper?
- Resizing a cell
- Does anyone know how to calculate Yield to Maturity using Exel?
- validation error, urgent plz help
- How to enter symbols for subset or element of a subset in Excel?
- How can I change a # in an array formula for a whole column?
- Can you use a formula to make a truly "blank" cell
- Restrict pivot table
- Multi Formula With Exclusions For Jail Inmate Count
- Fill blank cells with cells above data
- Thanks Kassie-but it didn't help
- automatically hide rows with zero value
- Unable to run Macro in an Add-in
- Excel Subtotal problem
- Can I get help with an excel 2003 formula
- How do I add a picture to the background?
- IntToHex Error
- Formula not working
- Track time
- Need help with a tricky problem of placing a number within an array...
- How do I add to figures already in a cell?
- Pivot Table/Report in Shared workbooks
- Blanks in spreadsheet
- combo box doesn't work in excel 2003
- Refresh data from an Excel sheet
- =weeknum() - installed the add-in
- Function needed to calculate arrival patterns
- formula for adding every other cell in Excel
- Scenario?
- Move data in repeated sets of coluns
- how do i view 2 excel sheets in same file at the same time
- Create a dll with functions to excel
- putting a string from one cell in the formula of another -- indirect needed?
- Freeze rows/columns in Excel
- Copy between worksheets...
- Sum multiple Unique Values in col
- E-Mail Merge difficulties--not actually sending?
- adding specific cells
- Excel formula that calculates percentage of increase or decrease
- Sum of cells whit the same name
- Track Changes
- Invert a matrix larger than 52 x 52 using MINVERSE
- Word Wrap not working correctly
- How do I automatically add 1 day to a base number every day?
- Change "interface" language?
- excel scroll bars within work books
- Spread sheet Functions
- The question is an excel question that I need to figure out howto do in excel.
- The above is an excel question
- does anyone know how to attach a word doc into a excel spreadsheet
- Sum of Vlookup values
- Date and time difference
- Can I use a function to detect whether a cell is highlighted?
- MS Query DateTime String
- View the rows in alternate black and white
- Conditional calculation?
- Using Sumproduct Function To Add Multiple Criteria
- Twist on the variable rate problem
- VLOOKUP - Multiple cells in lookup value
- data that matches exact column and row
- How do I get Excel to generate an ex-gaussian distribution?
- Merge words in diff cols to one
- How do I set up a formula to count multiple items?
- Sum Total # Of Cells That Meet Several Criteria
- CheckBox in a cell?
- Extract numbers with units. Eg. 1.6mm², 20.23mm²
- My formulas return the formula not a result in the cell
- What do those numbers mean when i perform linear regression on exc
- Referencing a Value in variable length columns.
- Bringing Last line of worksheet to a Summary page
- populating a worksheet
- Date Calculation
- hidden column concern
- Goal Seek
- Science Fair Project
- how to write a class row for grading
- excel
- delete zero value's using a macro
- date validation
- cursor highlights entire doc when moved
- Help - Radio Buttons
- Help - Radio Buttons
- degrees formula
- Please help,Template functions
- summarise totals from many worksheets into one final worksheet
- How can I turn on "Line Style"?
- negative figures macro
- Left arrow key opens up 'Save As' window
- How to check multiple cells
- Number convert in to text ?
- Looping in VB with cell ranges
- Lookup Function
- Desperate...please help!
- how do I correct uncommanded font color changes.
- Getting macro to copy to starting cell
- formula for tracking number of elapsed days from a stard date
- excel
- Multiple values in one cell
- Moving Table Data to other worksheets.
- Deleting some tabs from sum formula
- Ranking a list
- How to create a function using references
- IF Statement
- Flashing Warning
- calculation in an if formula
- Protect Cell
- Random letter and number generator
- use of sumproduct function
- Retrieving an Item from a List that Meets Multiple Criteria
- Alert in Excel???
- Need help with using SUMPRODUCT with INDIRECT
- Pivot Charts / Tables
- VLOOKUP question
- formula
- Excel User Conference - Atlantic City
- sumproduct formula too long, & how to use make an 'OR' statement w
- How to use built-in Excel functions in PivotTable formula?
- Help w/ Cell Manipulation
- Percentages incorrect
- = sum value turns to text and formula disappears
- Multiple Variables in a Commission Structure...a tough one!!!
- Adding amounts that fall within a range
- Excel ? Do Not Call Table
- conditional formatting error removal
- Skip a cell that contains data
- Count if cells have multiple data
- cell format help
- What is the formula for geometric mean with some negative data
- how do I insert a cell based on its match with an adjacent cell?
- add column to template
- worksheet reference returns address instead of value
- Bring the cell format along with the cell value from a reference c
- Macro question
- drop-down lists print on a separate page in excel
- IF Function Nesting Problem
- Retreive data based on multiple column input
- Count unique values
- Deleting filtered out data from a worksheet
- Return day of week for 1 January
- Repeating a Cell
- How to reference a value in a cells for a row number
- Sum a range based on a criterion
- How do I reference data from a sheet specified by text in a cell
- variables in footers
- if, sumproduct, help by date
- Need formula to show if a field hasn't been updated
- How do I switch the names in a column in Excel
- Find data in one table from another.
- Use of Indirect function to fetch data from another Excel file
- Excel, Schema and XML
- Vlookup
- Excel, Formatting Cells
- How can I write for extensive a number (Excel) ?
- Test for data in a range of cells
- in EXCELL, the function does not return results
- change year date
- Truncating entire worksheet
- Subject: Summing one column where criteria in two other
- compare data from 2 columns
- Summing one column where criteria in two other columns are met
- search data set, then put in all info base on one critera
- Can you set a "trigger" in excel to send an email?
- AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS
- =IF(AND(F2>69,F2<90),25,IF(F2>100,60,""))
- How to remove Hyperlink without changing cell format?
- vlookup, match/index ????
- convert $1.00 to text one dollar.
- convert $1.00 to text one dollar.
- Average of days within a range
- Unique drop down list
- How do I sum scattered entries on an Excel worksheet?
- Datevlaue function/ day/month/year function
- vlookup combined with AND-function
- Condition 1 overules condition 2?
- how to compare 6 columns of text data
- Sum with multiple conditions
- Finding/deleting duplicates and merging cells
- Counting of tickets that have certain criteria
- Can't right click
- Copying Formulas in LARGE Files
- if, sumproduct, help by date
- Multiple Inputters into file - Need help
- Merging Excel Files - Option "grayed out"
- Funny! More offers to select a search engine!
- sumproduct help
- How do I use the count if function for a range from 40-60 ?
- Auto hide/Unhide columns
- How to find hidden text
- Make T=True in a cell, when I enter T
- Round down numbers
- Looking up non-unique data
- change odbc data source
- concatinate data
- rEPOST: Summing clock in and out by date
- IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM?
- How do I count just the subtotals in Excel?
- Best way to get a list of unique entries in a field
- Carrying over background color to another worksheet
- best formula to use?
- how do you have information from one tab automatically populate i
- match/index using multiple values
- how do I give weights to averages
- 2 Nesting questions
- Not Automatically Calculating Formulas
- extract data from multiple worksheets
- Sheets duplicating
- yield on bond priced over 100
- Get different numbers to return text??
- filling up data in blankrows!
- How can I fix values in cells calculated by formula in Excel
- Sum
- Protected Row-Oriented Data Entry
- Compare and match names and extract a cell content
- Heading at the top of page...
- Cannot group by date in a pivot table
- countif, multiple criteria...
- Non Leap Years I want to show 28, leap years show 29 in an"IF"
- Show DateValue as Text not decimel
- Have 2 columns of names - need to filter out names not duplicated
- Is there a simple worksheet method to determine a cube root?
- Conditional Population in separate Worksheets?
- Formatting month values
- SumIF
- Using a MODE formula in a Pivot Table
- list formula for dates
- Inserting a revision date to an Excel document
- formulas / rounding
- Text "comparison" operator for "contains" used in an "IF" Function
- help please
- help please
- How do I look at two worksheets in same workbook at same time?
- How can I group formating, not data on worksheets?
- Does how #s are listed affect IRR calc- same #s vertically vs. hor
- pivot Table
- Calculated cells in Excel
- How do I save Filters, so that they appear when I open a sheet?
- conditional formula
- How do I combine 2 COUNTIF formulas??
- I have a problem fillling series with indirect function
- pivot table option is greyed out
- Fold / unfold without subtotals function
- In Excel, what do the dollar signs mean in $A$1
- Can I add and IF function to a SUMIF function?
- Nested ifs and conditional population
- Workday function
- Excel should allow more than 65536 lines.
- Conditional auto-filtering to summarize data
- is excel really what I should be using?
- Make cells negetive amount
- How do you cause a cell to flash in Excel?
- Excel should let its worksheets be arranged (tiled) in a workbook
- How can I retreive rows from one column?
- calculating formulas in excel
- Copy Values in a cell (derived from formulas)
- Repost: Summing clock in and out by date
- how i do to make a self filter in more than 3000 lines?
- data subtotalling isnt working properly on my spreadsheet
- Software Update INVENTORY Query
- MsgBox alerts
- Calc RSQ and exclude zeros
- "Insert Function" pop-up in Excel 2003, has anyone figured out ...
- modulus 11 formula
- Creating input messages or comments
- Find the first Sunday for a given year?
- Cells color automatically dependant on value
- Re: =average
- Can't open a png file when hyperlinking through Excel. How to do?
- Category Labels(X) axis on a chart:
- AutoFilter
- msg box
- Copy/Cut and paste
- I have a list1 and a list2, I want to remove list2 from list1
- Moving data between worksheets ...
- make multiple cells in 1 worksheet equal multiple cells in another
- Column Merging
- Allow header/footer to copy to other worksheets in 1 spreadsheet.
- HELP? nested, complex, vlookup? The impossible!
- MIN IF
- Concatenate and remove blanks
- xnpv with actual/360
- how do I turn ON auto REcalculate for formulas if new data enter?
- If(And for Conditional Formating
- IF, OR, AND function
- Summing clock in and out by date
- Need A Formula
- Adding same cells across multiple worksheets
- Cell just shows formula after named region var change
- column truncated due to width constrain
- Combine text and formula?
- consolidate totals
- Inventory and Date Ranges
- Can an if then formula be done for this?
- need if formula for 12 months
- formulas
- LOOKUP problem
- Searching a range of numbers for a specified total
- Funtion or Pivot Table?
- How do you use countif for values in every four cell in a row
- Formula nesting
- Lookup or Summing problem
- How do i separate full names appearing in single cells?
- IF sum is GreaterThan 0... why wont this work!?
- How can I find duplicate numbers within a column?
- Basic formula for linking data
- Date and Time formula
- How to return first 3 digits of a number?
- List "OPEN" orders based on a status column
- Comments in Excel saved to HTML
- count col-A if col-B = condition
- Lookup function
- Trying to get an IF/AND average to work
- How do I link cells from a workbook, to talley one one sheet?
- Forcing Input from a user
- remove read only - not showing up in properties
- proper syntax order
- A question about VLOOKUP / any other helpful formula
- INTERformula precendence
- nesting another formula
- can I use IF as a GO TO command?
- My formula returns a result but the cell displays a zero?
- using a selection box and moving the accepted data
- Meal Break on Time Sheet in Excel
- Workday - Saturdays Included - Holidays Excluded
- Printing only certain rows?
- Combining Row Contents!
- Copy based on conditions
- Different column widths
- Adding then dividing
- graphics placement
- Rounding
- Replacing last digit with Zero
- Still need help on outstanding question
- Workday With Weekends Excluding Holidays
- Total an array
- GOLF Spreadsheet problem
- How to enter data in one row cell only in a cell range
- Excel Count Formula?
- Auditing
- Countdown formula
- Autorun macro
- cHARACTERS BEFORE THE SPACE
- 20 yr Replacement plan for assets
- ISODD and EVEN formula
- Excel Macro - Merge Cells unavailable - Unable to figue out why.
- wrapping text in excel
- formula to calculate a 401K company match?
- Troubleshooting Template Wizard in Excel
- Excel 97 date diff
- Need some help
- Matrix in cells
- VLOOKUP & Dates: Why is this Formula working?
- how do I create a formula to convert kilograms to pounds
- Code to delete rows and column cells that have formulas in.
- need a formula for setting colour target cells
- Price Function - Difficulty in understanding the formula
- combining and sorting 2 lists
- need help to create a formula
- Using Column in Sumproduct
- Auto-Numbering Occurrences Question
- Date Comparison and IF statement
- Is it possible to save work on the clipboard and reuse ?
- Hypertext Links
- Column Problem Help Please!
- Copying Pivot Tables from one workbook to another
- Counting occurrances
- cell format for date/time in same cell excel 2003
- If I have two reoated data-sets and a common code, how can I get i
- Formula
- in workbook, where is delete worksheet
- Sort by date - just not getting it all the way there
- Page numbering multiple worksheets in a file without affecting set
- Formula Help
- chart help
- Formula
- Formula please to highlite every second Row.
- "Indirect" refs to other workbooks
- If, then
- Count if ('true) does not work
- IF Formulas
- VBA Function that ignores dates in a Holiday Table
- =OFFSET(cell("address"),-1,0)
- Determining which cells are locked.
- How can I calculate hours in a Hourly schedule in Excel?
- Subtract/divide answer/add in one cell
- Filling in a number x, y times in y cells
- Store an image inside a cell?
- Need a formula that will turn a date red if that over 60 days
- search and export multiple records
- HELP! Hyperlink Recovery Problem
- Combo Box sorting
- calculate years worked by 3% * salary in excel
- How do I generate a "blank" value?
- Finding Names
- Formula error
- Sortin method advice please
- RE:GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL
- Difficult Two Column Lookup
- Need formula or Function to sum value of every other cell in a col
- Difficult Two Column Lookup
- Adding 6 Months to a Date
- #N/A in VLookup - Can I use another function that will return 0?
- using muliple functions to return one result
- Help with Countif
- "sumif" With Multiple Criteria!
- How can i keep formulas in a spread sheet when it is saved over?
- cummulative sum
- Summary total from another worksheet?
- Compare worksheets
- Converting Negative Number to Postive number
- Formula Help... Thanks Tom
- Calculating time interval (some across midnight)
- Formulae in spreadsheet no longer update with new data
- IF AND Function problems
- Linking clip art
- COUNTIF 2 Conditions using Defined Names
- Formula Help
- Help, too difficult for me.
- Excel - WsF - Dan B
- refer to drop down item as a sheet reference in a formula
- COUNT IF
- Issues in Opening a file
- STOP BLANK CELLS
- excel 2000 worksheet
- VLOOKUP using date problem
- need to change writing to bold by only typing, not changing cell
- auto filter not working on all data
- offset a lookup in excel
- Renaming Column
- Renaming Column
- Want Vlookup to list multiple items with the same key?
- Days calculation between months
- How can i add a print-and save-date field in Excel as in Word?
- Macro's
- Price function difference in Output formula vis a vis Manual Calculation
- Checking names on correct line across sheets
- Mulitple conditional formatting
- Copy Pivot graph
- vlookup working sometimes, sometimes not
- 30 Day Moving Average Ignoring Blank Cells
- Newbie needs help deciphering formula.
- FIND THE LAST CELL ENTRY IN A ROW
- was working, now :(
- Summing weekending dates
- What function to use
- How to create a link including all formatting from origin cell?
- select numbers from a list and add to optimise result
- excel division formula question
- How can I use DGET in Excel with criteria that changes each line?
- How to enter numerical numbers in rows where value is same
- Changing other fields using IF Function!?
- To fix a sheet in MS Office to be opened first always
- Conditional Formatting
- How to manipulate controls added at run-time
- Input Mask
- how do I multiply dollars by networkdays for forcasting run rates
- Remove duplication from validation list?
- validation/list properties
- Paste link problem
- Which function to use?
- Autofill problem
- Rounding to nearest 5 cents in excel
- one column on my excel spreadsheet will NOT format the date
- Need to align text around a symbol???
- Help with formula, IF, AND, OR, etc.
- Color Excel Spreasheet print previews in black/white. Reason?
- Looking up a value using a range
- Using the NOW() function without it recalculating
- cell calculation check if result is negative and zero out if not l
- Copy Function Without Range Update
- setting up a pricelist?
- labels
- =SUMPRODUCT
- "Between" function?
- automatically numbering rows
- Fix Excel'S Proper() So It Won'T Miscapitalize Contractions
- How do I use Lookup to return a row of values eg. 6 cells
- number sequence gap
- Need help with this formula...
- Can I lock cell contents after current date is past?
- Excel 2003-color coded reference cells has stoppped on a spreadsh
- How can I add a fixed value to all cells in a table?
- help creating a formula using IF and AND
- How do I insert a comment in unlocked cell of a protected workshee
- Transfering Data from Several Sheets to another
- Date programming
- count if
- Unicode
- Extracting All But Last Word
- Get the reference from a referenced cell
- Calculating Bond Price
- nesting conditional formulas
- how to seperate into columns?
- what are the uses of merging?
- how do i convert a column of minutes into hours
- Counting again
- How to lookup the value next to a lookup result
- i want to import data from one workbook to another and add a row
- Help with INDIRECT function.
- Index/Match from multiple columns
- date updated conditionally based upon other cells
- Computing Mutual Fund Diversification
- Count if Multiple columns
- lookup multiple values
- Add a warning popup to a Macro Button
- formula suggestion please
- Weighted Average
- Cut/Copy and Paste Functions without old links
- Multiple V Lookups
- Loopy?
- Running macros automatically-AutoFit
- how Excel can copy the data in a row of worksheet to other?
- Multiple conditions...why wont this work?
- Checking 2 sets of values to provide True False
- Conditional math using AND, Average
- Print range names and how know if have too many?
- How do I count like dates in a column with format "January-05"?
- Store Functions by a name
- How do I get cell data in multiple Excel files into one summary fi
- Average function with #VALUE! error in reference cells
- HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
- How to link an Image to a cell value
- add non-contiguent sums in one column to a Grand Total
- Common Text Entries
- How to translate excel function names from english to local langua
- Perpetual calander
- template
- Functions
- Turning a negative into a positive
- turning student scores into a level???
- conditional formula: return 1 of 4 values
- How to insert random phrases
- EXCEL SPREADSHEET SET-UP QUESTION
- DATEVALUE works on one sheet, not another
- back date calculation?
- IF function using dates ?
- how to consolidate large worksheets w/ 800~1000 rows by category?
- Sum Cells within each date.
- mortgage formulas etc..
- Unique values
- parentheses
- Creating Array formulas with multiple criteria
- How to perform two actions ?
- Convert Values to formulas
- Function needed????
- HELP WITH EXCEL SPREADSHEET
- How do I exit a macro subroutine?
- Templete question...I hope there is an answer
- Calculate the closest day
- Multiple condition help needed
- How prevent email address from being hotlinked to open send msg wi
- what does the symbol "^" mean and how can it be represented in a f
- IF it will work?
- Excel Formulas
- The 7 nested If() function Limitation. Is there anouther way?
- Refer to a url and retreive info for a spreadsheet
- How does Excel Sheet with combo box show it when used projector?
- Insert row to EXACT function
- HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
- How to switch column headers from numbers back to letters?
- Looking up several number
- Sumif question
- Looking up several number
- Find, Lookup, Match, can't figure it out.
- Use lookup or ??
- Sorting a column to use with an INDEX function
- Vlookup for range, help
- If Statement linked to cell with VLOOKUP problem - getting wrong v
- Excel 2003 has wrong timing using the worksheet_change macro
- IF/AND used with SUMPRODUCT?
- How to set highlight for the column&row header of the active cell
- Formula to extract digits from a text string?
- Formulas
- How clear the cut/copy blinking boxes after macro
- Projecting sales dollars based on actual history
- Holidays
- return value based on two criteria
- filter by frequency
- vlookup - i think
- Why can't I scroll down?
- Problem with SUMPRODUCT and Arrays
- casing
- date formula for extracting unique dates
- SUM formula - using variable values
- formula to calulate length of time
- data query
- Counting blanks, either 1, 2 or 3
- How to estimate a future service date?
- Right Function
- How do I make longer a drop-down list (the window) in excel?
- Help typing formula
- =countif (h3:h16">=01 01 2006") how to substitute cell for date
- How to do I convert angles from radians to degrees in Excel?
- Average when No Data
- Currency format within an equation...
- How can I Lock Formatting?
- How many business days were in 2005?
- How can I get the value of a cell to increase in steps?
- Data Validation with Defined Name
- Exceeding the limit for Nested IFs
- index or filter?
- COUNTIF Function
- Problem with link
- loan amount pay per share
- Formula to recognize Duplicates
- Help writing a lookup formula
- repeat rows for add'l pages for tabs on a multi-tab worksheet
- VLOOKUP bug?
- Counting or Total Formulas -- Further Explanation
- I found this cool link
- When February 29 is date?
- Spreadsheet protection password
- how do i find palindromes using excel?
- Nested IF question
- Using subtotaling and protecting a sheet at the same time
- sumif less than 11/30/2005
- Totaling amounts based on duration
- Changes in date functions between excel 2002 and 2003
- How many formula
- How do I use the "SUMIF" function using dates as a condition
- Zero Suppression in Excel barcode fonts
- Formula to copy text from a column in different workshhets
- Circular Reference... Help!
- Vlookup over multiple sheets
- date intervals
- calculating date intervals
- Cell problems - need a quicker way.
- Error Messages
- Rename Defined Names
- Help Tidying up formula
- Sumif function does not add up cells, even when criteria is blank
- Re: More elegant method?
- DSUM Switched Off?
- Cell format changing on the fly
- Formula to see if a cell has an entered value
- bold part of cell unavailable at time
- advanced filter
- Pivot table - Custom calculation question
- How to create a formula 5 to 10% based on given list of price
- Nested Loop Link
- password protected page not opening by web query
- Moving data from from one worksheet to another
- Infinite Updating Column
- Mixed Cell
- How to return a single value for a range of numbers
- creating an hourly matrix (scheduling)
- countif based on fill color
- conditional date formula
- Math Experts - Function to compare where salary is compared to others have 800 rows of data
- insert colons in time automatically when input to cell
- unwanted date conversions
- Using AND function to evaluate cells
- HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?
- SUMPRODUCT or COUNTIF?
- how to loose all numbers after decimal (not rounding)
- Trasnsposing or copying filtered data from one sheet to another
- Testing for Cell Fill Color
- How do I create a sheet in Excel that updates itself from other sh
- Converting Dates to 8 digits
- I need a formula
- How do I bulletize in Excel, analogous to Word?
- Fill colours
- menus don't work
- Max number of named ranges
- sequential numbers
- Is it possible to have a formula for the following scenario please
- sum, lookup, and date range
- grab detail when = > 1
- Formula to display last few entries
- identifying a string of positive numbers
- HELP! Single cell formula to calculate weeks cover of stock on forward sales.
- Pivot tables
- Collecting weekly and monthly totals from daily data
- Can unmerged cell contents be split to another cell
- Is there an array function or something like it?
- Importing Workbooks into a Master Workbook
- Copy info in a range that always changes.
- re: how do i do this
- Need formatting help
- Excel: How do I change all upper case ss to proper case?
- Print unique values
- How do I set up multiple logical conditions on one result cell
- Return SEARCHED Column Number of Numeric Label and Value
- Help! data from pasted table is not included in sum
- Counting Formulas -- Re-explained
- EXCEL LOOKUP
- Quick answer please!
- How to use an index number in a search range
- Time format to number while keeping value
- excel, i want to add 20 in increments to the number 101+20
- Cell Reference Question
- Problems shading a cell!
- How do I insert manual line breaks in excel?
- Using the paste link function in Excel 2003
- Modify a Macro to Repeat for all Selected Worksheets
- Transpose Reletive Cell References?
- Calculating Time Past Midnight
- How do I add a second criteria to the SUMIF or DSUM function?
- Array
- formulas in excel are not working
- Any quick key for entering Current Date and Time?
- My excel document is opening two versions.
- Pivot Table Totals Incorrectly Summed
- if formulas
- How to name cells?
- how do i do this?
- Substitute for Dragging
- Format cell to show colon
- How do I use an Excel interactive calendar?
- how do i format a cell in Excel to 3 significant numbers
- Calculating number of instances occuring in an hour for 24 hours
- Having a Macro Prompt Me For Input
- Making cells "unavailable"
- "In Today's Dollars" help needed...
- Calling macros in another workbook
- LOOKUP question
- 5 highest then list names
- How do I tell a price list to round up and down to the nearest 25
- Need help in conditional formatting
- How do I protect the cell from users entering values in Excel?
- how to restore worksheet's gridlines & attributes
- Show + beside positive number?
- Macro Problem
- How can I protect cells and allow users to insert/delete
- File copy
- VLOOKUP help needed!
- My worksheet has turned grey and is not working
- Worksheet has turned
- selecting columns in a worksheet
- conditional minimum value of various cells?
- IF statement help
- Extract the first few characters
- Sum column based on column heading
- How to convert an excel spreadsheet into a Powerpoint page?
- Posting date
- How do I select all values within a category in Excel?
- Duplicating cell value between worksheets
- return multiple corresponding values in excel
- Boolean comparison: range vs. single cell
- help comparing two sets od data to find the odd data
- SORTING DATA TO ANOTHER SHEET
- SORTING DATA TO ANOTHER SHEET
- Added new columns - Pivot Table not refreshing - why?
- Insert times including seconds?
- IF formula - evaluation shows it should work but...
- How do I make items repeat on a pivot table?
- time problem or excel mistake
- Excel Link problem
- Repeating a Macro For Each Selected Worksheet
- Help With Formulas Needed
- linking cells in one worksheet to cells in another worksheet
- Return value if cell greater then 0
- I'd like to make a formula that does this..
- Number value based on date function
- sorting by date
- Comparing two lists and extracting data from one to another
- Comparing two lists and return specified data
- making changes
- color coding
- Repeating Rows
- Average function question
- is there a way to auto copy cells similar to auto sum?
- Keeping track of Sickdays, Vacation days, and hours for each.
- Conditional Auto-Population
- the name tabs at the bottom of each page, how can they be made big
- importing csv files, problem with date formats
- Lookup and paste as value
- Count Cells if diff cell meets conditions
- RE: Tex Dates to numerical Dates
- Totals of calculated field in pivot table give incorrect results
- Is there a Function for Appreciation
- Protecting Worksheets
- what is the underlying formula for the percentrank function
- can lookup return err if no match found
- Finding All but Last Word
- way to get jus the number off the cells that have functions in them
- Need Help
- Different print page setups on one worksheet?
- Fv & Emi!
- Is there a SUMPRODUCT-like function that I can use on text?
- if cell has been changed...
- Apology
- How do I change the default folder when I import data?
- Take a list from one workbook and apply asdropdown in another work
- How do I copy a column into a row and keep the links?
- Please Help!! Macro error
- business days - trade date plus 3
- EAN/UCC-14 Barcode: set Excel column widths based on a cell value?
- Mathematical elimination
- Macro that filter data
- Graph
- automatic list
- conditional fields in a picote table (I think)
- Problem with Subtotals
- how to add many cells on diff. sheets and put in 1 cell in excel
- Day / Date Formula
- Re: VLOOKUP and wildcards
- Seeking help from a GURU
- Precision in formulas?
- Copying all formats from worksheet to worksheet
- Autofill a series
- Vlookup return 0 when cell is blank
- Shortcut for wrapping text
- import excel data into existing excel report
- Change the text format for weekend days (Sat, Sun)
- DCOUNT? DSUM?
- CARET or ^, as in CTRL but CTRL !!! ???
- Combo box from MSQuery
- Does such a function exist ?
- COUNTIF-how do I count the quantity of 'H', as opposed to 'h'?
- Text box acting as a notifier?
- How do I delete rows with negative values all at once i.e. 47,000.
- formulas producing unjustified results
- how do I setup a formula for a same range of cells on 12 sheets
- How can I make a formula in Excel showing when the file modified?
- Grouping in Pivot Table
- Is there a simple way of removing duplicate data in Excel?
- Formula question
- How do I get the unique values from a range?
- #VALUE in formula as opposed to result
- PivotTable -adding more than one function
- COUNTIF multiple crietria
- Matching Data in Columns
- How to make drop-down menu of months in schedule,when сhoose it - columnes are added?
- Iterating files in folder
- List Object and Protection
- Solving sets of equations
- Want to compare two columns and then fill with data from the match
- Mode - getting bi- and multi-modal results??
- time sheet that takes out taxes
- Add 15 minutes
- solve a inverted matrix
- Auto Fill Cells, When Choosing From Drop-Down List...
- Finding Maximum
- Formatting in Excel
- Working with Arrays
- Conditional count of rows dependent on multiple columns
- New a little help
- Copying formulas referencing multiple sheets
- SumIF
- to search for a string and affect data if it finds the string?
- How do I copy just the "web page name"?
- Linking two "total" pages to create a "Complete Total" page
- How do globally clear pre-marked cells
- Unclear about hot to automate searchs
- How can I copy and paste an entire workbook?
- is there a problem with hyperlink in excel 2003
- IF Function!?
- Need help with a formula
- Excel
- conditional formatting with four conditions
- Formula to retrieve range of dates from a worksheet to calculate d
- I can't drag a worksheet to sort
- do you know how i can find the f(x) of the arctan?
- Create drop down box with the formatting of range cells colors ect
- adding/subtracting time
- Auto Calculation not working
- Can this be done...?
- excel 2003 right-click function not working
- How do I make the Stop Recording bar pop up when recording macros
- COUNTA
- Why does Excel change the dates I input?
- Conditional Worksheet Access Question
- Recorded Macro to Copy Format
- Is there a simple solution?
- I want to print at 100% but prints only at 60%
- Overline the sum instead of underline the number
- I need help with the IF Statement
- need a template for quilters/crafts for things to make
- how do you find a excel spreadsheet that you replaced with a new
- can conditional formatting on one cell value to another cell valu
- COUNTIF with Logic?
- count colored cells?
- Need to revise formula
- Need to revise formula
- Need to revise formula
- Cumulative Sums in Pivot Tables
- How can I add rows inbetween?
- Fill Sum of months by quarter
- Freeze pane
- Comparing Birthdate to specific date in the future
- How do I find a % difference between two numbers (comparing 2005 .
- How do I change the Tab spacing in Excel 2003?
- Lookup
- Macro with Array Function Problems
- Excel Charts - Time line for random points on X axis
- basically want to go from mm/dd/yyyy to yyyymmdd
- help with an if statement
- Divide Monthly Sales Budget to Day Budget
- In Excel, how do I look for the last number either 0 or 5
- In Excel, how do I look for the last number either 0 or 5
- Sort referenced sheets together!
- Double lookup count
- Excel Formula with two clauses
- =If() results based on cell color?
- Edit/Move or Copy Creating .xls on Tab
- How do I format tabs to automatically go to next cell I want
- Formulas, question for Roger Govier
- Character Count
- exporting e mail adresses from Excel into Outlook
- importing fixed machine data to excel
- Determine number of days
- Using INDIRECT in INDEX(LINEST.. ) function
- import von konstanten workstation - daten
- how do i convert weight (stones+llbs) to llbs?
- Nested IF.. is it the right one to use?
- Please help with enclosed schedule of duty
- File reference
- Looking for the truth !!
- formula gives 2 different answers
- pivot tables
- Lookup Two Columns - Again
- Conditional MS Query
- Convert Hours to Decimal
- If they are or not?
- locating the top 5 number (in a col)
- location of cell
- How do I generate a new sheet based on date/week/month?
- Create a Value for a cell
- How do I sort a range of cells via a worksheet function
- IF/WHEN forumla fo when a cell is between two numbers
- IF/WHEN forumla fo when a cell is between two numbers
- IF/WHEN forumla fo when a cell is between two numbers
- Grand total in Pivot-Table
- Add protect worksheet password in macro
- can I lock just the formular in a cell
- how to get column totals on each page?
- need help with functions
- Leap year date problem
- How do I count values across multiple columns?
- Something Along The Lines of a SumIf, but not
- copy down an indirect formula
- taking out lowest 2 values
- Reference External Worksheets & Protect Worksheet / Workbook
- Rounding Subtotals
- how to extract a specific range of days (7 or 30) to make a chart
- Function to find only exact matches in spreadsheets?
- combining cells
- Copying a formula to multiple worksheets
- Auto Coloring a Row
- Averaging excluding min and max numbers
- Creating a table based on rank
- Automated Reporting
- Counting occurrences over range of sheets
- automatically updating "school event record" formula
- Data ranges within a column
- template to use to track employees
- When I select from drop down menu I would like the next column to populate a specific cost.
- formula references vertical cells in a separate worksheet
- formulas\conditional formating
- a sort of GROUP BY data extraction question...
- Counting cells not containing specific text
- How do I find the largest in a column
- formulas
- Finding days between cells C and L where the cells may be empty
- stop insert from changing cell reference
- Rounding error in Stdev function result.
- Date function
- Macro to move a row from one table to another
- Simple interest, multiple payments, loan balance
- merging data to a single cell
- How do I count items within a date range in Excel?