- VLOOKUP problem
- VLOOKUP problem
- Rounding up to a set of specific numbers?
- Side by Side Comparison Add-on
- Advancing formula
- Conditional Formatting : Numbers & Texts Conflict
- what are the uses for Vlookup and Hlookup?
- Using Nested RANK functions
- Rows to Named Sheets
- MID function
- Number of sundays between two dates
- Using Excel 2000 VBA Application on Excel 2003
- Count rows with a string in any cell
- how to create a repeat formula using the same multiplier?
- Return all matching values
- Round to nearest 5000?
- Thanks to all for the help
- confused by linking
- Cubic Parabola or Cubic Spiral
- Counting in two columns
- Pull a value from another worksheet
- Dropping the lowest score from a gradebook
- simplify this formula
- Removing blanks from a spreadsheet
- sumif or sumproduct?
- simple formula
- Opening a file
- count occurence and present results
- cell object exposure outside of VBA
- symbol to represent a carriage return
- usernames and passwords
- What does this mean ='FY04'!H9
- Relpace entire address with street name only, searching with wildc
- Converting column to array
- Adding multiple vlookups
- FORMULA HELP
- RE: FORMULA HELP
- Running macro x # of times with a prompt
- Looking for row # for highest value AND blank cell in other column
- logical test
- calculate time in the building
- RE: logical test
- RE: What does this mean ='FY04'!H9
- Cell Dividing
- help with functions to nest
- VLOOKUP
- Can this be done?
- Need help
- updating phone number formatting
- "Identify numbers in one column and add times from another?
- Automatic updating of a rollup worksheet when a new worksheet is a
- how do i lookup and sum from serveral wkshts to a recap sht?
- Identify and add formula - can it be done?
- summing numbers based on 2nd column
- subtotal
- Search and return
- Print 'Column A' on every page
- excell function
- VLOOKUP
- how do I email amacro?
- Help making Negative numbers to become zero
- I need a formula that change all date by putting in one date
- error running a paste macro
- want a list of selectable names on my worksheet
- ADD Change Case function from Word to Excel
- Adding minutes to Times
- What function?
- Sequential numbers when printing
- Update a Database From Excel
- copying conditional formats
- GETPIVOTDATA with an Array
- Sum If Function
- calculating average with blank cells
- Multiple Countif results
- change row colour when a value is given in a cell
- Fomula Problem
- Adding formula to PivotTable
- Multiple If function for more than 7 values
- Pivot table for formula
- "if" function
- Pivot : how to put more than one range of data in data area of a
- Creating username and passwords
- Problem on linking different cells from other worksheet ?
- Viewing comments - Filters On
- Month Format summation
- If A3=alpha numeric,"X", if A3=text,"Y", Blank
- Need assistance calculating bonus plan
- strange error
- my ? is this problem=E11-backword commaBikes Madeupside down comm.
- Is it possible to get formulas to equal certain object values in E
- Drop down bar to hide column according to the content of a cell
- Surname and First names formula
- How to setup a random matrix in Excel without repeating numbers?
- SUMIF across multiple worksheets in another workbook
- SORTING AN EXCEL SPREADSHEET ROW BY ROW
- Help Creating A Formula To Cut and Paste Text
- Excel
- problem of converting days months and years
- Calculating compound interest
- Cell Reference issue
- Adding the number of table entries by type
- HOW DO INSERT AN AUTONUMBER INTO AN INVOICE TEMPLATE IN EXCEL
- problem with days months and years conversion
- Need Help Please
- Copying Excel formulas between sheets
- How do I perform bitwise logical anding and oring in Excel?
- Go to Special or other function to jump to vlookup source?
- I am looking for the author of this script
- merging sheets
- Converting minutes to seconds
- time calculating formula
- Track changes
- OLE Problems
- index and match query
- SUMIF within date range as a function of today()'s date
- MAX figure within a date range as a function of today()'s date
- transferring amount to particular month column
- can excel insert rown based on variable data in a cell?
- Want one cell to show hyperlink from other cell
- method for arrange items in alphabetic order in a sheet
- I can't list items in the same box on the spreadsheet
- Help required for "between" dates formula
- Sale commissions calculations needed
- conditional formatting on If sentance
- surveying formula
- Sorting Rows
- I apologise in advance
- MSNStockQuote function gives #value
- How do I insert content of a2 into text string in b2 and so on?
- Add Instant Totals use what feature?
- how do I write an "if then" statement in Excel. eg. If L47 = 0 the
- Extracting first value of each month
- Want to update hyperlinks through multiple sheets but can't
- i want to do a vlookup but i want the table array to be changing
- Stupid Question
- if statemant
- Load image from directory for custom toolbar of Excel 2000
- software thuriam
- INDEX() columns first
- MultiPage control
- using sumproduct
- Advanced Find and Replace Question
- Calculating a scoring system (issue #2)
- Interest amounts
- Calculating a scoring system (issue #1)
- summarizing matched data
- Data Validation Combine Functions
- How do linked worksheets exist with data on an external device
- need to ammend a formula
- Find across multiple worksheets
- Linking workbooks
- Average of Multiple Calculations
- How to find how much to put aside monthly to reach savings goal
- Any more advice than the Excel help, on the XIRR Function?
- Help create a IF statement to look to to seperate vookup data sour
- Lookup Function not working
- SUMPRODUCT calc question
- Can I use the date in conditiional formating?
- HOW DO I CHANGE A SCHEDULE USING SOLVER WITHOUT CHANGING EACH DAY?
- Rounding data entered as Millions, how to please
- formula problem
- need help with V lookups
- Missing blank in Dynamic range
- Display Unique Values
- I have two columns (A) and (G) that have like product codes however
- Using formula results as values in other formulae
- How do i convert row array into one column using pivot table
- 2lines for tabs just like you can have 2 lines for toolbars
- How to use both Vlookup & data validation
- IF Function
- Write an Excel Formula Question
- IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
- Help w/ the PROPER function
- What formula to use?
- Some formula to add results until a given value is reached?
- Populating a field based on lookup values
- My Boss is nuts
- Counting problem - newspapers
- Search function
- How do i link an entire source wksheet to a dest' wksheet
- Return a text string when the result of VLOOKUP formula is #N/A
- My boss is crazy
- Enable Excel to Sort by IP Address
- Moving Sheets within a workbook
- how can i convert £28.34 to 2834 pence
- Populating empty cells
- varible table not
- Combining words and nums.
- How to use the drop down date in Excel?
- Absolutes in Formulas
- Flagging failed values.
- Replace in a currency column
- How do I count only values which are over a certain amount?
- function to count project overlap
- How do I keep the top row of a spread sheet visable?
- A formula to count characters in an Excel cell?
- copy data from 1 worksheet to another based on a condition
- Find next blank row in another spreadsheet
- fiterling merged cells
- Excel subtotals do not show on left of row numbers
- unable to hide columns -"can not shift objects off sheet" shows
- Coverting seconds, to minutes and seconds
- Variable Table Array in Lookup Function
- Creating a complex search
- Using EOMONTH displays #NAME? error
- copy from one workbook to another workbook
- display different images based on cell value?
- Formula for Annualized percentage
- Finding row & column given value in a Table
- is there a way to post dates without enetering 1 by 1 into cell
- Random function - weighted
- How do I use LOOKUP to return a range of values, then SUM values?
- How do I make tab stops within a cell of Excel?
- "Slope" and "intercept" function help
- nesting within vlookup
- Is there a way to prevent pasting data into an Excel worksheet?
- SumIf: use of greater or less than operators in Criteria
- macro- move down to empty cell & active worksheet
- Opening Protected EXCEL worksheets to update linked data
- Total back to w/c Monday
- IF AND help!
- Lists Problem
- Find text and open hyperlink
- Two colors in one cell...is this possible
- conditional formatting for multiple lines using similar criteria?
- Not printing rows with a zero value
- IF Function with < & >
- Adding numbers from specific cells in a number of sheets
- Data validation
- Vlookup to change a column
- Import excel spreadsheet into an excel spreadsheet
- Using Countif with multiple criteria
- RE: Using Countif with multiple criteria
- can any one tell me how to convert figures into words automatical.
- Help required with COUNTIF/AND function
- RANK Function - Zero Value Ranked as 1 - Should be 10
- How do you get Root Mean Square Error out of a column?
- calender display of list data
- fraction
- when inserting a file name in a cell how do you remove file type
- Need some help with name replacement type formulas
- How do I use the spell check on a protected sheet in Excel?
- How do I set default footer setting on excel spreadsheets?
- Count unique records... with a twist... Need help!
- Something is wrong with this IF statment
- varible table
- Dynamic naming of range needed
- Convert rows to Columns
- aligning decimal point in a column of figures in Excel
- help with order form function
- IF statement (non nested) that compares cell value against range
- Counting instances that 2 different columns match
- show or hide formatting marks
- Need Macro Help
- If Function
- Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG
- Delete Rows where there are #N/A Values
- M25 postcode
- how to type in 1 workbook & automatically insert in another book?
- Vlookup giving #N/A
- How to protect all sheet ?
- Drop down menu
- how do I format a cell to always have an ' in it?
- delete used records from drop down list?
- Excel spreadsheets linked together
- two way lookup and cell reference
- Pasteing formula gives blank result
- Name range not updating
- How to input cellcontent within worksheets if satisfies condition
- probability mass function
- I need some help
- I have problem with chart titles Value 'Y' Axis
- Conditional Average
- Referencing a cell including background colour...
- How to go to next day in fomula of Time differences ?
- Sumproduct giving #NA
- How can I change list into a directory format?
- Search function.
- counting unique items(values or text)
- A formula, probably quite simple.....
- Numeric entry
- time
- Sumproduct
- Automating charts with reference to new data and formulas
- I came across formula: =IF(B.11>0,B14/B.11,0) what "B.11" mean?
- get a rolling sum between current date - 30 days
- Locate duplicates in a work book by using conditional formatting
- whats wrong with the formula?
- Re: Selecting data
- Link to external link
- Locate duplicates in a work book by using conditional formatting
- rolling
- marco that inserts rows?
- marco that inserts rows?
- Formula for Calendar Quarter
- Weighted average
- Conditional formatting - multi-item text list
- Stop #N/A until data in the reference cell
- cell contents returned
- create a rolling sum??
- Sum largest numbers based on condition
- How do I lock a stamp date/time formula for an entry on a row?
- the drag feature in combining cells won't work
- input or copy data
- Work Rota
- Error in Formula ??
- formula for product not working
- How do I find the cell reference for a vlookup?
- Rounding down from .9 in an IF stmt
- send button
- How can I match a random number with closest number from sequence?
- minimizing space between cell content for printing
- function for pulling certain numbers from a cell?
- sort question
- How do I summarize time that exceeds 24 hours?
- extracting digits to the right of a decima point
- RE: extracting digits to the right of a decima point
- Is Leap Day between Date Range?
- Keeping track of results of refreshed/updated data
- two condition for vlookup?
- Copying line from one sheet to another based on given criteria
- I would like to find a templet that does cost reduction tracking
- add file name to spreadsheet
- Why is ther no "Convert" function available in excel?
- Indirect and Dynamic Range
- IF Statements...I think
- Need Help with Index and Match or Vlookup
- data in calender format
- Is there a way to modify the DAYS360 function to accomadate a 365
- data verification question
- NOW() function
- LOOKUP Command Issue
- Simple Code, I think...
- Compare values on sheet 1 to values on sheet2
- Look up twice
- Microsoft Excel
- How can I get "=TODAY()" results to be non-volatile?
- Highlighting an active cell
- Page Protection interfering with Hiding Rows
- Ctrl+pgup pgdn can't jump worksheets
- Compare to table
- Help: How do I convert a text date into a real date format
- Can I pick more than 1 entry in the validation function?
- How can I count IF, then, else statements that have values?
- How to use address from relative reference across worksheets?
- Simple If Statement
- Counting Data from Another Worksheet - Countif
- HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA
- Copying contents from multiple sheets onto one
- More Excel Tutorials/Tips Required
- List when worksheet protected
- How do I get just 1 cell to display it's formulae not whole sheet?
- comparing multiple columns
- Getting a chart to stop if the formula resutls in a blank cell
- Need field at top to float down as I scroll down?
- satır ve sütun başlıklarını değiştirme
- Cell Custom Formatting
- Need your help urgently
- Change pictures in Excel?
- Conditional Formatting
- Paste special doesnt have values
- LOOKUP?
- Cell identification for a 'lookup'
- Urgent - How to using formula to compare 2 worksheets
- 360 day calendar function
- Changing of Colour if my condition is "High"
- comparing multiple columns
- Spaces in cells
- SUM if cell is Bold
- Unique Entries with Conditions
- Nested And function
- Format number to Time in Excel?
- Multiple dynamic ranges in a Sumproduct
- Multiple dynamic ranges in a Sumproduct
- Excel Calculator always requires an = before a math function, can be turned off setting?
- Searching numbers in Worksheet
- Column Names?
- summing cells with text and numbers
- Advanced filter
- Look up for a range, Possible?
- copying formulas from one file to another
- How to find last filled in cell in a column?
- Problem w/Array Formula
- How to remove footers all Excel docs at once.
- Time formulas in Excel
- Excel should calculate large workbooks more efficiently
- Sum Product if? Three columns
- VLOOKUP question
- Date Problem: Between 2 dates
- IF function
- Excel 2003 Macro
- Making a column of numbers created from a formula permanent.
- IF Column A contains "xyz" replace with...
- How do I reference the same cell, but in different worksheets?
- how do I write a formula to pick a date or N/A?
- how can I use excel to tabulate survey results
- how can I use excel to tabulate survey results
- How do I set multiple parameters using VLookup
- Formula to choose cell and then cell three rows down
- How do I unhide column A of an excel spreadsheet?
- My Hyperlink bonks out after I save the file!
- Change Links/SumIf function
- VLOOKUP - 3 Table Array
- Use the value of a cell within a reference to another workbook?
- How do I group and edit multiple worksheets?
- Insert a new row when the criteria is met in the cell above
- indirect and networkdays
- How do I fix my Autofilter in Excel?
- Excel formulas
- COUNT
- $ value formulas
- Can't Set Minimum Y Axis Values
- How can I make a whole number
- How to change scheduled payment amount in Excel
- Modifying drop-down box options and formats
- can this be done?
- Weeknum help
- SUM calculation bug in Excel 2003?
- worksheet
- Auto sorting Help please
- West Coast Excel User Conference - Announcement
- how do I get the address of a cell to calculate with it
- How can I retrieve data from the same cell, from multiple sheets?
- MID function from right to left
- Command to count number of worksheets in a workbook?
- get a runing total for"curent date"or(cell)minus prev 30 days( cel
- how do i cancel getpivotdata in excell 2003
- how can i know that my worksheet having repeated same values
- Looking up the results from the function "LARGE"
- Insert Name Function not working
- how do i count the number of times criteria appears in a worksheet
- Newbie on Macros
- swap
- Where to find Excel sheet with Pipe & Forging charts and sizes.
- Using 8/23/2005 with INDEX, MATCH, VLOOKUP and IF
- How do I get a worksheet reference to increment when copied
- Growing range within a Sumproduct.
- How can i sort a database on numbers?
- Challenge: Copy across surname
- Vlookup using drop downs and table
- =LEFT - Cannot Format
- CELL("filename") acting Volatile? (in assoc. with PULL)
- IF function...>cell ref is a formula so True is retd when False sh
- Break Even Analysis
- ComboBox Question
- IF/THAN with regards to 2 Dropdown Lists in Excel?
- Data Validation with Blank Date
- Repeating background images
- time value
- GETTING STATIC DATE CONDITIONAL TO ANOTHER CELL VALUE
- Filtering a Drop Down List
- Cell Colors
- Help please - Data sorting
- INDEX function need to have col reference to be formula
- Trim
- Get Data based on Month and Year
- How do I add specific categories from several worksheets?
- I am unable to unhide certain rows in my worksheet-it is locked?
- linking Outlook email folders/subfolders to excell spreadsheets
- Excel drop down box
- Excel search for douplications
- Lookup formula help
- Unlocking excel features
- help with text sorting
- How to SUM cells that contain functions?
- Automatically copy data from one worksheet to another
- Range of data in Excel
- How can I recover data from excel?
- Display a weekly summary
- Links to closed worksheet
- REMOVE SORT WARNING
- Adding time
- advanced search
- Adding 2 Values When 3 Conditions are Met, Including an "OR"
- Using MATCH function does not return correct answer
- Dynamic Formulation with lots of sheets
- Pull in address from another worksheet
- Selecting a subset of items from a list
- Refresh/Recalculate a Custom Function
- Sumif & Isblank
- Multiple VLOOKUP
- Written values
- sum data in column for dates until today
- conditional formatting?
- What is the syntax for referencing another sheet with 'lookup'
- Cant quite get this formula to work:
- Paul B
- Disalbe the Calcuation in Excel after vaildety date
- Simulation in operations research using Excel
- Formula...function...how to?
- XY Scatter
- Rate function with #Num! result
- Renamed tab .xls>3 receiving a error but can't fix
- HELP with the RAND() Function......AGAIN!!!!!
- auto-numbering for invoices
- command button
- Conditional Format based on date ranges
- Multiple Option Controls w/in Worksheet
- Looking for command help in Excel
- Search & match more than one worksheet and matching cells.
- Time format shows default of 12:00 AM
- Formatting b/w Worksheets
- Top 5 Scores
- Copying Data from Excel to MS Outlook in Plain Text Mode
- Transpose Data from a column to several rows
- cell fill color
- Retrieving Amazon product data to excel, namely books!
- Benifit of AREAS
- Lookup function
- Searching numbers in Worksheet?
- Keep formatting from one worksheet to another?
- Adding Spaces to the end of a value
- When do we use -- (double minus) in a formula
- Changing working days
- HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
- Defaulting a random number
- Cell background color update
- Entering Data into worksheets Simultaneously
- Tips and tutorials needed
- HELP with the RAND() Function!!!!!!
- UDF for Data into 128 B barcode problem
- UDF problem in converting data into code 128 B
- Activate the top of sheet
- UDF to convert data to code 128 B
- Excel Formula
- My excel file is locked for editing. How do I get it opened.
- making a formula that will display a "word" in multile cells
- balancing check register
- function for conditional value from another worksheet
- SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
- calculate averages
- schedules
- how can i ask the program to convert numbers to text automaticaly
- limiting the viewable space to the data shown
- Auto Racing Score Sheets
- financial function ..please
- NAND ?
- Negative Numbers to Zero
- Linked Checkboxes
- Help! Forgot the password the file was saved under!
- Aquiring data from one sheet to another sheet in the same workbook
- Tally The award winning accounting software full with license Keys
- Comment card percentage formulas
- VBA Help
- Nested IF Function
- cell background cover
- excel puts dates instead of numbers when typed
- Please Help Combine to Two Lists
- Help please... Simple calculation - with unexpected results
- How do I check for duplicates across multiple worksheets
- save filter
- #Ref error question
- IF function comare to identical amount but inconsistent results
- Finding the average time
- prevent blank cell in excel worksheet
- Excel Sum formula for timesheets.
- Excel Function for max of percentage or dollar amount
- multiple text criteria sum if function
- SUMPRODUCT Assistance
- lock formula
- Error with linked files....Macro Problem???
- if then formulas with text?
- How do I set spreadsheet to "open for editing" automatically?
- is there any way to have multiple TEXT criteria in a 'sumif' funct
- help with functions
- +40 Hours in a Week Overtime Fromula
- help today and how long since day X?
- How do your remove ROUND function?
- pv of annuity
- combined HLOOKUP (urgent for a friend)
- Counting calls received by time range by year
- How do I get more color options for fill in for cells, excel 2003?
- Passing a row to a function
- Need Ideas for My Excel Tips and Tutorials Blog
- file path: reference to other workbooks
- format cell to show leading zeros and make cell a three digit fiel
- Formula to find last value in a range & then offset
- Working with Pivot tables with % change
- link form combobox
- how to get formula content of a cell?
- Help to sort out filtered data from the data contained in another sheet of the same workbook
- How to fix a Excel corrupt object pasted into Word?
- Excel sees cell formulas as constants, will not solve
- Cont'd - Offsetting within a range dynamically - But returning a sum of all instances criteria are met
- ADDING/SUBTRACTING FROM RIGHT TO LEFT
- RETREIVING THE SMALLEST NUMBER
- roundup by 16s
- How do I give different $ value to different colums in Excel?
- help about function
- Sum columns dynamically
- Is there any way to export your Chart from Excel to Word
- Creating Multiple Entrys
- Weekday
- VLOOKUP's
- multiple criteria with countif or sumif
- data entry criteria
- Compare 2 similar excel worksheets
- Advice on sumif - more than one criteria
- =INFO("Type_text")
- Dynamic range name - odd results
- VLOOKUP with OFFSET
- Spell check
- Coefficient of Repeatability
- Countif
- Trevor - Round Up/Down ?
- Absolute Values in Relative Cells
- adding + and - numbers
- Vlookup, match, or sumproduct?
- Round Up/Down ?
- PULL function (Harlan Grove) - can it use Named Ranges?
- test - sorry
- Input Box Help
- Lookup to the Left
- Lookup to the Left
- Copy Date on Excel Tab to Cell In Spreadsheet and Add Year, How?
- Need help searching another sheet and retrieving a value
- Formula Error
- Multiple Validation Lists
- Alpha/Numerical numbers
- Match and Sum?
- How can I use the result from ADDRESS in another formula
- Index and Match Functions
- Count up each day of the week
- Need a function or formulae that will return the current date + 1
- Copying Worksheets
- how do i get a value to appear in the cell and not the formula
- Concatenate question
- Average HELP!!
- Help with converting date formats
- Using offset within a formula dynamically
- Dates
- Menu item disabled
- How do I place a footnote in an Excel cell?
- How do I add a .bas into excel 2003 add-in?
- Trying to Create a Macro
- Need quick "if" function
- read excel with a c++ program on Unix
- Format Time
- combine multiple values in a table into one cell using vlookup?
- Conditional Formatting and Cell Color
- sum and product, but not sumproduct?
- vlookup with .csv data
- Text in formula bar is red
- Searching numbers in Worksheet?
- Add "Protect ALL Sheets" that is the same as "Protect Sheet"
- How do you average more than 30 time points in Excel
- Here is a simple formula request from a newb
- NETWORKDAYS
- Trouble with an IF formula
- Copy & Paste value Function
- Static time - again
- Insert static time
- making a more acurate mean
- Importing Data
- Macro Help
- why do I get the multiple data values when there is no data in my.
- Excel'03 crashes with VLOOKUPS ending in FALSE
- Tab name into cell
- DGET Function + External data from another excel file
- VLOOKUP Help
- Array formula returns blank in the cell where it is entered
- Pull recent pricing data from table
- Using the TODAY() function in a SUMIF function
- auto calculate not working
- How do I merge or combine 2 excel worksheets by a common collumn?
- Page Numbering
- Formulas autofill ok but continues to carry tot from 1st column??
- How do I print selected lines from a worksheet
- Satisfy 2 and more criteria
- Transpose
- detect cells with links
- How to delete column label from pivot table field
- Delete contents of cells
- Assigning consecutive date ranges
- conditional cell coloring
- Raffle winning odds (off topic)
- copy visable cells only
- Comparing 5 worksheets
- Using Solver with the 'Frequency Array' Function
- How can I make a specific cell blinking
- How do I convert Julian date to fiscal date
- Display value from another workbook, if less than display a blank
- Couting the number of referrences that...
- Dates in Conditional Formatting help!!!
- Time Stamp
- How do I get an average sale if multiple columns?
- Looking for duplicate ranges
- Match dBase with Fieldnames
- Problem with conditional formatting
- how do I add action buttons in excel
- Sum based on formatting
- Can I set the criteria in a sumif statement as a cell reference?
- IF statement and color formatting for cell B1 for condition in A1
- how to fill a different series?
- how to complete a specific series?
- saving a shared workbook is too slow on other 2 computers
- How to fill cells with a different kind of series?
- Trouble returning to Normal view after inserting a header and foot
- Merging two columns and keeping the data from both
- New Excel function(S)
- What does &L& mean in a page setup macro?
- Automatic Filtering
- Help with formula
- Create Macro to Tag Text
- populate fields based upon pull down lists
- Slow Save
- How to match information in two columns?
- Linking two lists to display the same data
- Subtraction when including the MOD() function
- How do i copy numbers from Web and paste to excel and and get tota
- VLOOKUP
- Hide sheet in workbook
- Conditional Formatting Need to Return to Zero
- Defining Range within Specific Dates
- Weekday formula calculating to end of month
- Replace #VALUE! with UNK
- Using VLOOKUP after finding LARGE value
- How do I create a button to print several worksheets in Excel?
- Excel 2002
- How many entries can be put into a drop down list in excel?
- Linking a worksheet
- Returning text from nested IF and Vlookup statements
- IF maximums
- Formula does not calculate - Have tried F9
- 2 if functions together
- Need to ungroup cells but don't have the option.
- Trying to create a grid type spreadsheet
- spaces not recognized as spaces
- Dates Excel 2000
- Matching Values
- Factor Analysis
- Sort and Match like Items in 2 Columns
- Sorting With dynamic Fields
- Formula for comparing two workbooks and highlighting the differenc
- Excel function LARGE returns error 'too few arguments'
- If and Round Functions
- Lookup functions
- SUM of #N/A cells (#N/D in italian EXCEL)
- Using Small
- maximum characters?
- How do I update data in linked cells without opening source workbo
- where do i find triangle.xla add in?
- VLookUp
- RE: Advanced Filter Using Calculaions
- RE: Advanced Filter Using Calculaions
- Import xml
- Formulas stop working on all excell spreads at the same time
- Vlookup
- HELP ON SUMPRODUCT
- Excel worksheets
- to enter today's date if a cell is blank
- to convert a julian date back to regular date
- how to spellout a digit in english
- Any idea how to work?
- logical function
- MOVE DATA INTO UNUSED ROWS
- zipped files
- dato calkulations
- Linking Excell Spreadsheets and Resorting Data
- Linking Excell Spreadsheets and Resorting Data
- calculating percentages
- Getting the value of the Minimum Date
- Problem with Excel 2000 Shared Workbooks
- Re: Need Vlookup to return a value of $0.00 in blank cells
- FORMULA COPY SHEET IN THE OTHER CELL
- Formula for Conditional Formating - Help!
- create a timesheet to add daily and weekly hours and overtime
- Trouble formatting date
- Macro Function
- I need to place the semicolon in my draft how is it done?
- Need Vlookup to return a value of $0.00 in blank cells
- Combining 2 cells
- find a cell matching separate column and row values
- Change background color with IF statement
- irr function
- How do I search an array for values in a column greater than zero
- How do I assign numerical values to a letter? Ex: A = 4, B=3, etc
- HOW DO YOU SORT EXCEL FILE WITH BLANKS
- validate work sheets
- Re: HOW DO I CLEAN UNCLEAN DATA?
- countif function
- How do I truncate or hide portions of text in a pivot table?
- Protecting a shared worksheet
- Pivot Table Error Message
- countif function
- naming a grouped column
- Column Name Formula
- Sumproduct,Countif, I don't Know!!!!!
- array formula count results of two tests
- How does Excel determine the ORDER of consolidated data?
- Help with IF function...
- Return number OR sum based on two criteria
- Change the Auto-filter that is "on" to a RED arrow, can't see blu
- Pick from lists
- How do you compare names in two lists? One is a subset.
- Count Certain Cells in Specified Range
- lookup and return values using lists
- sequence number based on date
- RE: Nested sumif/sumproduct
- Multiple Functions and conditions
- I want brackets around my math equation answer?
- Re: Advanced Filter Using Calculaions
- can a dde link populate excel creating new rows automatically?
- Re: Circular Reference Error Even Though There Is No C.R.
- New VLOOKUP problem
- I can't view column A in a document and it won't unhide.
- Can I merge addresses from one excel worksheet to another?
- how do i set up/use drop down list in excel
- Using Sumproduct to count text occurence
- max function with a less than or equal to
- How do I rename multiple sheets at one time in Excel?
- Apply multiple Conditional Formats
- Numbers Into Data
- how to save imported data in diffrent worksheet cel before refrehs
- Fomula need to pick up last entry in a row
- Nested IF with a VLOOKUP?
- Does anyone know how to create a lookup that will do this?
- Filename from a Cell
- How to find missing numbers in series
- Putting check marks in every cell in a column?
- How do I hide or unhide row and column heading in Excel?
- Copying Spreadsheets without referencing other workbook.
- SumIf with an Or
- Ignoring Blank value in a drop down list
- count cells that begin with specific text
- data validation
- Comma delimiter
- Passwords on Worksheets
- DIV error
- Execl formula return the lowest value
- Opening Different Programs using Excel.
- Number Placing
- Create Excel Grouping according to Merge Cells
- Not all links are created equal
- create a list box
- The Seemingly Impossible
- Sum of a range if the value in cells are > 0
- Data collation killing me!!
- Can this be right? Excel has no XOR function???
- Getting a string of data from a file name
- Holidays
- Need help on creating a formula in excel
- How do I update filters when using Autofilter?
- Brain Dead: Need help with ????
- Excel Rankings function
- Simultaneous Filtering
- How do I say "if this cell is blank, use this formula...
- Nested if statements - is there a better way?
- Dragging graph-points to change data? (!)
- problem with linking data
- Is it possible to combine two worsheets into one Pivot Table?
- Excel should let me divide and multiply time intervals
- How do I keep the 0 at the beginning of my order? (098523)
- calc # of d, m, y, then round to nearest fraction
- Start & Finish Time
- Follow-up to the IF with OR function
- Populating one worksheet from another
- Filter horizontally?
- How do I set up a way to keep track of vendor invoices?
- How do I create shiftwork schedules in Exel?
- Assign a date to a record for consecutive days
- finding exact matches using vlookup
- Adding math
- IF with "or"
- formula to calculate time values
- cell addition
- Top border in a footer in Excel,
- embedded ifs
- Pivottable percentages
- Matching up data
- Saving Sort Criteria (or Sort Lists)
- delete row
- VLookup Nightmare!
- match word in one column form list in another
- Right clicked range highlights in Excel would add the "$" to func
- distorted totals
- Counting a Column when Three Conditions are true
- Copying comments from one cell to another, in a different spreadsheet
- Discounted Payback
- I need a macro that saves a spreadsheet on two drive at once,
- Trying to convert date to day
- SUMPRODUCT not equal to...
- Match Function
- Listing variable names for 3 greatest values in a column?
- Functions- Finding and counting specified text in cell range
- lookup formula?
- formula to apply concatenation to successive rows of data
- Hiding tools/options
- VLOOKUP Help
- Conditional Formatting
- Using List Box To Clear Cells
- My Menu bar is hidden. How do i restore it.
- IF statement question
- Color of text/Data in a Cell
- refer to last cell in worksheet?
- Use of the MID function
- Worksheet Help
- How to get double quotes to show up after pasting?
- How to use the If Function?
- How do I get my curser to move by using my arrow keys in Excel?
- multiple lines in a cell
- Please explain function/formula
- 3 way dependant lists
- custom label
- Getting the top five incidents
- sort prob with Common info on more than one sheet
- Calculating Flying hours allowing for GMT or BST
- Matching cell information
- London Excel User Conference - Thank you
- word frequency
- Multiple criteria countif/sumproduct function
- Selecting the first non blank cell in Range
- Concatenating Text and Date in a chart series Name box.
- Project exponential growth againt linear timeline
- Find multiple repeated values in a Pivot Table
- combo box
- how to total amounts in one colum
- convert numbers stored as numbers to text
- Prevent The Cruelty
- DSUM with dates??
- #N/A errors when matching time values
- SUMPRODUCE and AVERAGE
- Can we do "save as tab delimited text" from cmd ?
- How to create a 'name' which is not worksheet spcific
- How to match values in one column to values in another?
- how do i enable negative results in the lcm function?
- How to insert hyphen "-" in between two numbers
- Intersection point return data
- Dropdown Data Lookup
- a weekly grocery list and costs, available coupons and value
- VLOOKUP and truncating time
- Object Variable Not Set Error on Selection object
- Format text 'dates' to real dates
- Setting up a validation of data listbox to provide the unique items within a range
- When I try to insert a logo (.jpg) it prints out as a black box
- Help to create a date formula
- Counting letters and symbols
- pulling 5 lines of info from a sheet
- Sumproduct W-t-d
- VLOOKUP and Add data
- enter data two worksheets but not in the same cell as first
- how can i change the colour of eg. datas more than 10%?
- WEEKNUM to dynamic range name
- Major Help Needed Asap
- dates
- How to Create a list which sort itself automatically
- Recording Absences
- How to determine the column letter from Cell address
- Convert My Data into Barcode 128 B
- Calculate Checksum
- Pivot Table Sub total and totals
- For dates, copy/paste special/values for 2006 gives me 2010--Why
- SUMIF / COUNTIF Problem
- Pivot Table Field
- Nursing Rota Question
- how can I stop an excel cell being calculated
- Sum on multiple columns
- Excel Worksheet Printing
- Pasting HTML into the cells in column A
- In Excel 2003 can you password protect a single page in excel?
- Help With Formula
- is there a function for this?
- data retrival
- Another Conditional Formatting Question
- Syntax to "OR" 3 "ISERROR" conditions
- How do I re-calculalate the values for all cells in a column
- numbers to characters
- If and nested Sumif error
- Updating a Date in a Graph Header Field
- How to copy data to the next empty cell in a column
- Conditional Formatting
- reference different sheet in same workbook
- How to get current worksheet name to display in a cell?
- common numbers in 2 columns
- Re: Averaging Time withing Excel
- NETWORKDAYS Function doesn't work
- Drop Down selecting worksheet
- Create a List That is Pivotable
- Increase group of numbers by same amount
- Return last cell that contains a particular value
- formulas involving ranges
- Need to Sum when THREE Conditions are met
- I need help with a formula...
- Simple Equation Builder/Solver in Excel for use in Dell Axim X51v
- writing a statement
- Trend question
- Need help with VLOOKUP
- Calculating correct pecentages with negative values
- Create a macro to delete rows if value is less than a specified nu
- removing weekends
- calculate difference between two times
- Hyperlinks in Excel
- Protect worksheet and still allow user to sort data
- Sum when two conditions are met
- How can I redline (mark corrections) in Excel 2003?
- Statistics Student>Simple Graph Template?
- Using IF statement compare cell ID with data in another column tru
- Countdown
- Countdown
- Countdown