- Some function problems
- How to set up single Header/Footer for all tabs in Excel Workbook.
- RE: How can I change the settings on the row headers/
- How do I pull a merged cell from another workbook?
- Merging multiple worksheets
- Errors in COUNT, COUNTA, COUNTIF when counting merged cells
- IF Statement
- Forecast
- Sum of cell on numerous worksheets in a workbook
- Finding the value of a cell in an entire worksheet
- How do I sort multiple worksheet pages to list in numerical order?
- Cell Reference Embedded in Formula
- Why does my sheet have 60,000 rows when only 60 rows have data?
- change cell color based on cell value
- How to populate a table?
- data not viewable after installing Java JRE version 1.5.0_06
- Two Logic tests in an IF Statement
- How do I view formula results intead of formula in excel?
- Auto rename and save prompt needed.
- combining text
- How do I do running Totals in a Pivot Table
- v function
- How do I use a wildcard or multiple of a cell value in a formula?
- add hex numberings together in excel 2003
- AUTO CASE
- Activating a worksheet through use of a variable
- LISTS OF BILLS TO BE PAID
- ANYONE GOT THE TIME?
- filtering excel worksheet column by color of text
- help with personal budget spreadsheet
- Is there a way to autoinsert current row into a formula
- Printing Spreadsheets
- how do i enter a function in a sentence
- Interpolation with VLOOKUP
- Help with 'named' functions
- buttons?
- averages
- Automatically starting code
- What formula can I use to sum only certain colored cells in an exc
- Function Question
- Urgent help needed
- Refresh workbook automatically
- last 20 items in a list
- Sort is turned off. How do I turn it on?
- Formula Displays in One Cell
- lookup mutliple values to return one value
- How to delete footer & header history in Excel?
- multiple column lookups
- RE: multiple column lookups
- Pivot Table using "LIKE" code
- Excel formulas
- How to stop "Synchronized Scrolling" in Excel Workbook comparing
- WorkSheet Function Help
- first saturday in a month
- Formula to return cell position
- Formula to show all items with an "x" next to them
- Count # of A's in a Cell
- RE: WorkSheet Function Help
- RE: Count # of A's in a Cell
- Can I change the default sheet name?
- seperate words in a cell
- formatting cells
- RE: Can I change the default sheet name?
- RE: Count # of A's in a Cell
- using functions to compare multiple columns for mismatch of cells
- RE: multiple column lookups
- REPLACE or ??, Help please
- How to Set Worksheet Name to a cell Value in WorkSheet?
- RE: Excel formulas
- RE: seperate words in a cell
- RE: multiple column lookups
- RE: REPLACE or ??, Help please
- Dragging a formula correctly?
- RE: Formula Displays in One Cell
- Excel spreadsheet
- Worksheet controller
- Question about decimal places
- Using variables as first and last cells in range statement
- Matching two columns and their data
- Calculating Rolling Peak to Valley in a Column
- Date the input, then tell if over 7th off month
- HELP: Comparison IF statement
- use address function to indicate range in calculation
- Lookup nearest value (Index & Match)
- Lookup nearest value (Index & Match)
- Multiple IF
- What is Excel keyboard shortcut for adding column?
- #ref to equal zero
- Formula/Equation
- How do I paste horizontal references in large array
- Lookup problem
- RE: Selected cell highlighting has vanished...no shading now.
- Advanced Filtering Extract Range Missing,etc
- YTD formula help
- V-lookup and summing values if more than 1 matches criteria
- vlookup for multiple columns
- Why won't Excel let me copy and paste my concantenate formula now
- Populate worksheets based on a master sheet
- Help!!!! Strange things are happening to a Shared Workbook!!
- Splitting text to columns
- Subsequence value
- How to extract data from a wooksheet in a closed workbook
- matching value of top 20 in a list!
- Another Multiple Conditions Query
- naming tabs
- Calling procedure when leaving cell
- track unpaid invoices
- How do I put days of the week into a multiple regression model?
- timer Macro
- Help with workbook updates
- sumproduct
- A Sheet Error for dates I can't explain
- multiple conditions
- excel formula calculations are wrong
- Conditional formatting--simple question
- Case Sensitive w/ IF
- Finding a minimum value and selecting the cell containing this val
- Using the results of formulae between different spreadsheets.
- Index / Hlookup
- Blocking entry of data in a cell
- Registration drawing ending - Excel User Conference
- Working out age from "Day" "Month" "Year"
- Color Coding Cells
- financial functions dll
- How to show data from other sheet depend on value??
- Transpose and link Multicolum matrix in 2 colum array
- Ignoring negative number
- how to copy displayed value only?
- Link Data from Multiple Worksheets
- First occurance greater than or equal to a specified value
- extracting numbers
- quotation marks
- Why won't my formulas work until I save the worksheet?
- Yahoo + "Get External Data"
- template error
- returning macro value to starting cell (different each time)
- help on excel formula
- How to delete in batch the same color format letters in a cell
- MORE THAN ONE LOGIC TEST
- CountIf Conditions / Occurrences
- EXCEL LOOKUP FISCAL YEAR WITH DATE
- Conditional Sum Wizard with dynamic named ranges
- Date dif
- Reference range of cells and perform subtraction or nothing depending on contents
- Reference
- Confidence function
- Set up Tax planning sheet by week/monrth- Income/deductions
- Loan Amoritization Spreadhsheet Issue...please help
- How do I set up conditional formulas
- Insert Photo into a protected worksheet
- Bi weekly payments per month
- Numbers stored as text causes problem with VLOOKUP
- Is there a macro for Canadian compounding
- Why do I have certain raw data disappearing in my pivot table
- Sumif or Sumproduct
- DSUM
- Converting to Decimal degree's
- Keyboard Shortcut for Zooming
- linking worksheets
- date and time updated automatically
- "how to make data lineup from 1st to 2nd page for printing?
- how to format time
- Excel 2003 - paste special option
- How do I expand the checkbook register to more than 98 entries?
- RE: Numbers stored as text causes problem with VLOOKUP
- Run macros on protected worksheet
- Spreadsheet Summary Report
- Sumif or Sumproduct? Maybe neither?
- Loan Amoritization Spreadsheet Issue
- replacing value between sheets!
- changing to two place decimal
- general syntax
- Extracting information from records to another sheet automatically
- help interpreting expression
- Is their any Function to convert no. in figure to in words
- filtering pivot table!
- Check Boxes
- stock quote lookup query for Excel 2000
- Formulas in are turning into values for no reason
- Create a spreadsheet to budget
- Question regarding formula
- Re: Extracting information from records to another sheet automatically
- Time Functions
- Formaula to multiply and add
- Setting Tab Names To Dates In Spreadsheet
- Re: Extracting information from records to another sheet automatic
- using the equation of a polynomial
- RE: Setting Tab Names To Dates In Spreadsheet
- MIN to get three lowest
- RE: Converting to Decimal degree's
- RE: Check Boxes
- Excel subtotals should subtotal "blanks" separately.
- Hyperlink from one cell to another
- RE: Is there a macro for Canadian compounding
- options custom list
- RE: Run macros on protected worksheet
- 'if' and 'and'
- New user with a question
- Text to Number Value.
- Edit Query
- Counting and Summarizing Data
- Comparing Entries to a list
- Formula to ignore negative numbers in a column?
- Column Labels (A, B) are showing us as numbers (1,2). Please Help
- Find numeric value at end of string
- Auto update to "tab" in a reference link
- Countif or Vlookup
- Fiscal Year Calculation
- Need to get rid of 0's and replace with Blanks
- Vlookup problem with Date Time
- Random numbers function
- Compare cells and Create a new File
- Vlookup - no match
- copy, insert and add digits
- Office 2000 vs 2003
- Totals sheet - deal with employee names
- reference
- How do I allow multiple choices in a list-box?
- sumproduct?
- Function that will copy sheet to sheet IF...
- How can you use multiple ranges in a function?
- Conditional Formatting in Excel
- change cursor to highlight cell I'm in
- #N/A conditional format
- Due date excluding weekend days
- Formula to Link to Specific List on Another Worksheet
- Change Last Cell
- How to place parenthesis around a negative percentage calculation.
- Current cell position
- Using Logical Function in Pivot Calculation
- INDIRECT EXTERNAL DATA
- Protection and Spell check
- Difficult for me, probably basic to you
- NA()
- Enter 1 in a cell, excel change to 0.001, WHY?
- Conditional Formatting Formula
- Combo Boxes for data entry
- Calculating Overtime
- Linking to a closed workbook
- count with filter
- How to use month() and day() without considering year()?
- Week Number
- Protect "signature" cell
- currency Problem
- Data compiling formula
- In a linked calculation how do I lose the '0' in the linked file?
- Nested IF error
- SUMPRODUCT?
- joining worksheets
- summing previously ranked values
- I am trying to round a list of numbers (prices) to xx.95. Is the
- vlookup in several sheets
- Can I display comments in a validation list
- Using Countif to count occurences of time?
- RE: summing previously ranked values
- Change Date without Opening the Workbook
- Spinboxes In MS Excel 2003
- Average every 20 rows
- RE: Average every 20 rows
- keyboard shortcut for zoom
- Digits in ascending order ?
- Copy data into/from textbox
- FOrmulas in MS Excel
- Adding a constant to a formula. Problems w/filling in
- populating spreedsheet with data from access
- trouble with seeing formula in formula bar
- Finding a name with biggest number
- Finding Maximum value while excluding some values
- summing values appearing in col B when col A has been filtered
- Formula or Function to accomplish this?
- complex count
- user defined function help
- Read-only access by SHEET (not workbook). Is it possible?
- How do you extend the number of blank columns in a worksheet?
- Concatenation question
- FillDown Macro
- comission split based on 365 days
- invoice toolbar
- Vlookup not working because of duplicate matches
- Date Function
- Macro for Subtotals
- SQL Queries
- dates and vlookup
- Groups of numbers
- attach a label to number, like validation but follows the number
- vlookup
- Sumif Function
- Vlookup refs a cell that has a worksheet name
- =DATEDIF
- macros
- Need formula help setting a range for calculations
- Conditional Sum problem
- =SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
- Look up/math text
- create a separate backup file in excel when exiting
- how do I import tab delimited data?
- how do Import data tab delimited text?
- formula help need to get current row
- Sheet Protection
- converting text to negative numbers!
- Auto Insert/Auto Formula?
- Resorting full names
- ... round a time entry to the next "30 minute increment"...
- Sum like items
- Between Dates
- any good reference books on building excel formulas?
- Embedded IF Fuction
- Fill in contents based on another column
- enter date(A) and have (B) total to current day?
- If+if+if+if... Does anyone know a better way?
- Basic Solver Problem
- Combining 2 Formulas
- Conditional Formatting for more than 3 conditions
- vlookup
- COUNTIF using exclusions
- vlookup
- sum multiple rows based on progressing date field on each row
- Why doesn't this work "=IF(C2>= "13:00",C2+"16:00",C2+"4:00")
- Hiding a Worksheet
- Using the AVERAGE Function
- COUNTIF using exclusions
- My If+If+If etc.. is too long! Anyone know a better way?!
- automatically move results from a calculation to a specific cell
- if equation
- Sorting by number of ocurrences!
- Solver question
- Counting Cell with Quotation
- NPV
- Extract certain parts of string
- RE: Extract certain parts of string
- unique order number according to criteria
- calculated field - Pivot Table
- Need excel password cracker.
- Can excel limit the characters in a cell to 28 automatically?
- if equation
- average with mulitple ciriteria
- A counting question...
- not printing lines?
- sorting cells
- Circular references
- SUM returns #VALUE! error
- trigger help
- Countif in VBA
- cell address
- Repeat in functions?
- product from k= 0 to n
- Custom formats to round numbers such as 465,123 to 465,000
- Disable auto-formatting dates.... GRRR!
- life contingencies
- How do I add time abouve 10000 hours in excel?
- Smart tags
- How to update one manually-entered value from another?
- Time Display ?
- The Top Toolbar Min,Max,Cancel is NOT showing in Excel
- Calling a specific worksheet from a hyperlink in a seperate file.
- Not able to access certain Excel functions
- How do I sum cells' values over 30+ worksheets?
- Returning Multiple Text or Address Locations
- Mortgage calculations
- Summed Cell won't update as I add data into the cell range...
- dynamically select a range of cells for use in a formula
- time elapsed formula
- Sum rows if two columns = specific criteria.
- Conditional Formatting for Array containing Text
- Removing unwanted rows
- Combining Worksheets into one
- Use InStr function in formula?
- intercept graph vs. function
- Finding unique data between 2 columns
- Text and Function Formulas
- problem with macro on Excel
- vlookup into 2 shhets
- HOW CAN I RECOVER MY OVERWRITTEN DOCUMENT?
- Need help with formula to give 0 if value is negative or answer is
- copying specific data from 1 wrksht to another
- Forecasting
- I used Lotus Help for regressions in MS Excel 99. Now what?
- Time function
- Please Help! - Need Help pulling data from one spreadsheet to anot
- MSOffice Excel 2003-Validation Listbox takes only 47 values
- how to activate controls in protected sheet
- calculate percent met (comparing 2 date columns)
- Querying a range within Excel
- Is there an AVERAGEIF function similar to COUNTIF - how do I do i.
- Modifying an If Statement
- INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP)
- why doesn't sort work when it's choosen before protecting sheet
- How can I set up week to date report?
- Vlookup problem
- COUNTIF Question
- Is there a function to extract the URL part of a hyperlink in another cell?
- Automate Spreadsheet
- Convert text string to date
- exporting summary data for pivot table!
- isnumber multiple criteria.
- COUNTIF according to presence of string within text
- "New Web Query" always refreshes data from website (3 times)
- How can I view color coordinated formulas
- Random Number generator
- Nested function - what key strokes to save and return a value?
- how do I count with multiple arguments
- How to format a number cell to auto count 1 up on file open
- Limit drop down list and linking to other info
- How do I find the last instance of data in a column
- How do you convert an entire column into absolute value?
- Tabbing to the next cell
- Setting borders for two rows and all columns on spread sheet
- Conditional DAY
- How do I advance filter to multiple locations at once?
- help with a table
- Capitalization?
- highlighting duplicates
- Dsum will not work
- special formatting adds extra zeroes
- 3D Interpolation
- Vlookup for two value
- PivotTable - Calculated Field
- how to hide raws and use password
- Difficult for me, probably basic to you
- Including Environ Username in Cell
- How do I sum increments of minutes and seconds
- I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
- Error when opening Excel workbook
- EC Excel User Conference This week registration giveaway
- Totaling some hours but not others HELP!
- paste special - formulas
- How do I get a count of dates within a range..?
- re-produce/loate auto filter list
- color of filter arrows
- workbook1 data to workbook2 data
- Macro to highlight cells based on content
- Dates and Quantity sort
- Sumproduct question
- quirky array not working
- If Function - Multiple Arguements?
- Postman
- chart types
- Adding months to dates should account for 28-30-31 day months
- Updating inventory quantity
- Conditional Format - Outline Border
- need help with a payroll formula
- Combining "AND" with "OR" Statements
- Color Code Date Checking
- subtotal of sum and count in one spreadhseet?
- how to put the subtotal of the sum and count in one spreadhseet?
- Extracting entries from long list
- Rank & Match Problem
- Excel should have case changing menu items like Word.
- HOW DO I DO SIMPLE DIVISION?
- how can I use the NOW() function without it updating thetime?
- How do i combine duplicate column headings
- YTD average - How do I create a formula?
- why does auto sum get wrong totals?
- Effective method to paste array formula
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- EARN OVER 9850 DOLLAR in 3 WEEKS !!!
- Double lookup formula
- HELP!!!!!!!!!!!!please!!!!!!!!
- Extend Excel Workbook Columns to 366
- Use "PROPER" to change UPPERCASE text to Title Case on worksheet
- Copying a worksheet witrh protected cells to a new worksheet
- Barcodes
- IF functions
- *****Upgrading Calendar for Office Manager*****
- How do you create page numbers on excel worksheets?
- Freeze and split panes in Excel 2003
- Web scraping
- How to make autosum update totals in excel
- How do I convert text to numbers in an old version of excel
- Linked Worksheets
- How to Update a link within a workbook
- Adding hours minutes and seconds
- Counts/Percents Multiple Criteria
- Extracting certain information from cells
- braincramp
- How can I copy text from one worksheet to another
- Counting lines that meet TWO criteria
- Help! Complete text in cell not showing
- Autofill cels based on two dates in adjacent cels
- hyperlinks
- Writing macro in Excel
- Refreshing OLAP cube by date using VBA
- Macro code error; machine dependent
- SumProduct Formula
- =Average(if( formula using different worksheets
- sumproduct returns zero
- index/match
- Data Validation
- Question about merging data
- Feynman Experiment
- autofill dragging result rather than formula, why?
- Using INDEX and MATCH to find data in 2 different sheets
- How do I query a future date?
- Excel List & Format
- Averging non-zero cells only
- Re: IF Function
- Calculating timesheet with overtime
- How to programatically control a 3D-sum?
- Color background with Matching cells in row
- how do i sort a proceted work sheet
- Need an advanced "if" function: if 2<x<2.9 then y, if 3<x<3.9 then
- =DATEVALUE
- How do I create a List in Excel 2000
- Excel - remaining wks in a year formula
- Compare two Numbers - Determine Decrease, Increase, Same
- =DATEVALUE("7/1/20"&MID(C3,13,2)) creates error
- operations on arrays
- Splitting single column data into two
- Match and Copy
- Absolute Named Ranges????
- help with sumif formula with multiple critera
- multiple IF's ?
- How do I return True False
- Request
- how do i add 2 columns to make the answer apper on the 3rd column
- Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )'
- causing macros to run at insertion point
- Presentation errors with multi-level sub-totalling
- concatenate
- Mode or frequency
- Calculating Month To Date Revenue
- RE: Creating ODBC link within SELECT statement
- Functions not working in Spreadsheet
- CountIF Range
- Refresh Pivottable last 4 weeks data from today
- Trimmean for limited array
- Permutations of an array element <> to a value
- sorting data into separate worksheets
- count cells since last non-zero value
- Number of pages
- rounding values in in array before sum
- workdays formula ends on weekend date
- Cannot use Data Analysis tools on Excel worksheet embedded in PwrP
- Will Excel's time function do this?
- SUM(COUNTIF(range,NOT Criteria))
- Array formula lookup
- Elements and Arrays in Excel
- Average Values / Multiple Worksheets
- Formula With Dates
- Saving transfered data
- How to I past the exact copy of a form without it shrinking
- help with VBA.Financial.rate error
- Comparing worksheets in Excel and highlighting changes
- Easy Nested IF formula question, please help
- ms works question
- How do I round to the nearest $5.00 in Excel? $74.03=$75
- Reference is not valid
- check cell val, increment val
- Excel - let search for more than one disconnected word in a cell
- how do I create a macro to auto insert rows?
- Help with Formula
- COUNT SEVERAL TEXT VALUES AUTOMATICALLY
- Reporting results of pivot table
- Outlook Calender to Excel Spreadsheet
- Access import query list incomplete
- Formulas that don't compute
- Can you search for common results in many wrksheets?
- multiple sheets when importing into excel
- Quick Question
- AutoFill over 30,000 rows
- If function with date; if sale is Oct place sale $ amount here
- V Lookup and return cell address
- SUMPRODUCT is broken (I swear!)
- I need a Lookup to return more than 1 result
- How do I avoid getting "too many different cell formats" error?
- V Lookup
- Can Excel Data be simultaneously entered in seperate category list
- How to copy records containing a specific date range to new sheet?
- Forcing Alignment Options
- Help Please with %
- How do I delete a lookup table array name?
- unknown - maybe grouping
- Where?Worksheet code module or Worksheet_SelectionChange event han
- index/index
- adding individual cells in a column
- help for an excel newbie
- add a ruler to use on spreadsheets
- Problem with Vlookup array selection
- YEAR function name not found
- COUNTIF not counting properly!! Character limit?
- Display worksheet protection status in a cell?
- FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES
- show difference between weights with correct pos and neg values
- Average Array help with a formula
- retaining functions or formulas in cells
- How do I use countif to count values excluding blank cells
- Change Cell properties by Function
- Can individual cell boundaries be changed?
- automatically number every other row
- Check if a value exist in a column
- worksheet tabs automatically change?
- VBA
- Subtotal Range of Alphanumeric References
- Formula not evaluated automaticly in Office 2003
- run macro when cell is selected
- Problem calculating weekly costs
- how to match data of one column with other
- How do i link w/sheets to increase value without just overwriting
- How can I test if a Macro if firing?
- nest functions in CELL function
- Wild Card Search
- Q: how to create summary daily lists from another, and reverse
- Autofilter - on select columns
- Assessing unconventional projects
- Formula/Macro to copy into a cell
- CountIf Function Help Needed
- Filterered list to new worksheet
- TEXT SEARCH
- how to insert calander control in excel?
- function wizard excel 2000 not calculating in worksheet
- Excel Formula
- Cell Displayed Does Not Equal Cell Copied
- using If statement to change values in a range
- Complex Formula to Find Doubles
- Using AutoFilter to Sort Data Pulled in by INDEX / MATCH
- Daily time sheets
- IF functions
- Catentate or cotentate
- Ranking based on frequency
- I NEED OLL BROG IN BOX
- Slow data filtering
- multiple vlookup
- Color rows if
- How do I convert a cell(s) from the formula to it's contents?
- Display total in more than one cell...
- How do you trim characters?
- Sumproduct Will Not Find Date
- undo auto symbol
- How do I freeze more than one location on my worksheet?
- Can I have multiple freeze panes in one worksheet?
- How do I multiply 1 cell x 1 cell and answer in 3rd cell?
- Auto filtering vs Date> List > Create List
- Excel gridlines not printing
- Time card template
- What is the -- in formulas?
- Random cell generator
- Why am i getting #VALUE! in a cell?
- Help :Circular References
- show a column of numbers also as percentages
- Dynamic Range, Data Validation and Address, Match and Offset Funct
- return a list
- group comment format on text
- formulas
- DSUM : what am I doing wrong?
- i need a templet to add and subtract
- adding rows to ALL worksheet (all in one)
- text cuts off in cell
- Weekday
- syntax question
- Help to write a formula using a letter value and a number value
- Tab question
- serial numbers excel
- I want vlookup gets the value once
- How do i add multi-spreedsheets together
- Pivot Table - How Do I Convert Data?
- Need help merging worksheets
- Macro to open new sheet??????
- Need Help Please
- Formatting Upper Case letters
- Guidance needed wrkng with a wrksht
- How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
- How Do I Autofit To Screen Size
- appending text to existing values
- How do I show a surplus number in an entry (on the plus side)
- Page Header concern
- Workspace opening issue
- Macro Save As Code???
- Custom formatting not functioning in Excel
- delete duplicate record but only determine 1 column data
- access or XL!
- Splitting Column Data into 2 fields
- Excel User Conference in Atlantic City - April 19-21
- Help needed with function
- Access to hidden cells
- how do i add seconds (time)?
- Q about: IfAnd or is it AndIf?
- Worksheet Problem
- nearest match
- Matching Items
- Q About Macro Security
- RE: Equivalent of Minus in Excel. Also Union, Intersect.
- APR Rate on a Loan
- Help With If Statement
- Sorting
- Continuous Alphabetization
- compare 2 columns
- Date formula and if function
- Sorting
- point protect
- getting unique records similar to the primary key in access
- I want vlookup gets value once
- Inserting a row
- Excel GURUs help. (How to make program parse more than 1 forumla within a cell)
- month worksheet function returns wrong value
- conditional formula to show "open" or "closed"
- can I use =if with vlookup statements
- How to I exclude GETPIVOTDATA from formulas?
- Vlookup not recognizing field
- in excel, how do i get an average without including the zeros?
- + and - "hide" icons
- How to add one column if 2 other columns have a specific value
- Couple of vlookup queries
- vlookup
- write a formula to calculate age in yrs; 04/30/06 minus birthdate
- how to sort my whole sheet
- HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
- Enter dates and return availability
- Populating Multiple Worksheets with one entry
- Add additional info to multiple fields
- enter doesn't work with sumif
- isolating a string containing a % symbol
- Formula to replace invalid filename characters
- How do I get a cell to show the result instead of the formula?
- Copying formula to another workbook
- New to charts help
- shrink to fit and wrap text
- need to convert list of dates to count no. of dates by week
- HelpNeed to know what formulas I need to use to move names in a co
- How I can use the same graph in multiple worksheets?
- Using a worksheet name from a range
- Complex data referencing - too many for nested IF's
- sorting concern
- Tab Names
- concatenating rows from different sheets
- arrow across, up and down etc in an excel row? How ?
- Macro puts #REF in VLOOKUP formula
- Date of expiry - warning?
- Iserror and vlookup
- Someone moved my linked file
- what if
- I need to add a range of cells until I reach a cell with a zero va
- Continuous Averages Formula
- Macro recording?????
- Match formula
- easy if statement
- Multiple Lines in List Box?
- "Save as template" option
- getting data from another worksheet
- Opening Excel with no workbook open
- What is the function opposite of LOG
- What is the function opposite of LOG
- Delete syntax problem
- Formula Help
- Ratio function
- Merging data from mulitple worksheets
- shrink to fit in excel
- building a web site
- Excel User Conference - Atlantic City, New Jersey - April 19-21, 2006
- Cell Value Changing
- In Excel, how can I type a number with a circle around it?
- hyperlink in drop-down list
- VB syntax help requested
- logarithmic graphs are these possible?
- Function to find duplicate values, then delete
- SUNIF with 2 criteria cells
- IF Functions
- Text to Columns - Only want to split SPECIFIC NUMBER of times
- excel cells are merging onto the next cell
- Do I use a Look up?
- Max values from 2 ws and a range
- lookup problem
- Why does tabbing from A1 take me to L1 then to W1
- Vlookup + Address functions combined
- Is it possible to lock cells together while organizing?
- If cell is not blank, then line out row
- lookup
- matching one value in a list of values
- V LookUp
- dates in one month
- How do I determine a winning % based on wins, losses, and ties?
- How to find number of pairs of strings from list of strings?
- Convert Unix timestamp to Readable Date/time
- Shorten a Formula
- how can i sort times as in 00:10:30?
- Access Closed workbooks (2003)
- Return Value If Two Conditions occur
- excel text
- EXCEL - When you filter, the indicator is BLUE can it be RED
- LOOKUP formula not working right
- FOUND LOST FILE BUT COPY IS MISSING
- Can a sound be inserted in a cell?
- Sort with ISNA and vlookup
- multiple searches?
- Painful...
- Template Creation
- Find Percent something in particular in a column.
- Keep Worksheet Format
- Text string inverting
- My formula show up in the cell instead of a resulting value
- Lookup Multiple Criteria return One answer
- #value returned instead of data
- How do I add 10% to every number in a set of cells?
- Excel's Personal Macro Workbook
- "COUNTIF" function
- Getting the last time a web query was refreshed.
- my excel formulas have quit working
- Can I write an excel formula to display the file save date?
- OR'ing to IF Statements
- worksheet protection
- excel spreadsheet do an automatic spell check
- Format a cell with a custom number format
- Excel Puzzle
- Formula's
- Dates and periods
- excel printing problems
- Calculation between two dates
- Count Occurrences and Print Total
- Is there a macro to identify and remove duplicate data in Excel?
- Cpk to ppm
- cumulative rolling additions
- Why can't I use XML in the Student and Teacher Edition?
- VBA, delete all macro
- Use Excel To Calculate Several ranges within one column
- Range of variables with the 'floor' command included
- Subtotal the median
- Help with an IF Formula
- Updating one cell with a formula
- Daily Refresh of Ext Data
- Nested If Statements
- Having problems creating a cube
- Populating Data and Looking Up Info.
- Excel Formula's
- How To return 0 if error
- Detect page break settings
- need help splitting a name form a date
- Converting to absolute reference
- Using a txt string to refer to other work book
- Macro to Delete blank cells
- Custom Formula in Pivot Table Row
- CSV values and retrieiving nth item
- vlookup truncating information
- Shortening a vlookup
- When autofilling I would like to change worksheets rather than cel
- how to get coefficients for Polynomial regression as for rgp()
- Its better we have Format Painter KeyBoard Shortcut for MS Excel.
- Using Vlookup as "value_if_true" in IF function
- Highlighting an entire row using conditional formatting.
- I want a straight answer
- printing Union of Ranges
- How do I unprotect certain cells in a protected sheet?
- How to solve tie when using the Rank function?
- Formula to calculate cumulative interest
- vlookup
- How do I format an Excel date earlier than 1900?
- Need a simple subtotal Formula
- Text after a dash
- CountIF Question
- returning blank cells in an IF function
- Populating a table based on values in another table
- Re: Satifying 2 criteria...then sumif
- Re: Cannot Shift Objects off sheet
- formula problem
- How to count the number of times a string appears in a column?
- How can I check for duplicate $'s?
- How do I find the last value of a column
- Convert Hyperlink to cell value automatically
- Interactive Forms
- Subtotal - Directorate
- Conditional Formatting
- how do i link data from one sheet to another if value keep changin
- How circle an individual number in a cell?
- Printing a table based on a larger table
- In Excel, how to count a list of check boxes some are checked?
- Look up info in a database using 2 conditions
- Transferring Data
- Link/Hyperlinks Problem
- HOW DO I LINK CELLS
- vlookup error
- join cells for a vlookup
- Can Vlookup from one spreadsheet and not another
- column headings problems
- Profit and Loss Formula
- regression results without using the wizard
- Hyperlinks
- Excel Improvement Suggestion
- Allowing for a range using COUNTIF
- How do I add a "code" to a value?
- CHECK BOX
- Is there such a think as "dual link"?
- how to show different photos, base on different value of a cell?
- cumulative total
- Please help me how to make formula if as following case
- vlookup error with subtotal
- 0-9 and a-z in functions
- Sorting into Columns
- can you filter your sheet by colour?
- How can I wrap text in a drop down list?
- Array Offset Function
- avoiding message warnings and otherconcerns
- GEOMEAN Function
- time formula
- How can I display my "false" value as an actual value?
- time and attendance
- what formula will get the url from a cell with a hyperlink?
- mulitple formulas
- Why will Excel will not save text format in a .csv file
- Interactive spreadsheets for transferring info from 1 to another
- calculate elapsed time between dates and times
- Get number of a cell in a list.
- SUMIF Question
- Stuck with an =IF
- How do you return the sum of two cells in a vlookup?
- Import csv data and convert to TIME format
- Finding the percentage difference of two or more numbers
- UDFunctions and nested If-the-else statements
- Using "COUNTIF" with more than 1 criteria
- Is there a way to use labels and 3-D references in a formala?
- No Dumb Question
- ERFC
- Re: 24 time format and calculations
- Excel too helpful! (problem with absolute reference)
- Printing of voucher
- =SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5))
- greater than or less than if statements
- How to change lookup references
- Problems entering a formula
- How to show the defined name of another cell
- Change a Column list into multiple rows & columns
- If statement
- Automating adding up a column
- Master spread sheet to manage then show info on seperate tabs
- How to check for a bold text formating through (in) a formula?
- Pivot Table Grouping
- Lookup help (simple)
- How to make a cell value generate a cell value in another cell
- Tables in excel
- How do I set up an automatic column select
- connecting two Excel workbooks so one grabs info from antoher?
- multiply A by 1000 record results in B
- How do I get the print of the background image of excel?
- The NOW function
- HOW DO I RETRIEVE DATA FROM THE LAST UPDATED CELL IN A ROW
- what formula do i use?
- text around a circle
- value function
- Avoiding #value
- Matching names to numbers in a table
- Limiting macros to certain sheets
- Counter in a worksheet
- how do i sort a table in excel
- REQ: Where does this =Core1!B13 come from? TIA
- sumif based on date
- Dont know what to use.
- Reference date as text
- Update and Retain Prior Data
- Formating a cell in Excell
- how can i use concatenate to create a linking formula?
- moving text
- Formula that returns Col A data in Col B, but omitting blank cells
- ayrı sayfalardaki aynı kodları tek sayfada satırları yan yana dizm
- How can the font in the Data Validation list be changed?
- some 'Protection' questions
- vlookup answer in different cell
- INDEX
- where can I find the Auto Sum feature on Excel
- can vlookup place results in a different box than the formula?
- How do I change the tab order in an Excel worksheet?
- Combining worksheets
- Macro to find, copy, and paste until value change
- Incorporating Vlookup in a IF Statement
- trying to create a formula and require help.
- not sure where to start
- Use of Indirect on two worksheets
- What Does -- Mean In A Formula
- How do I see entire validation list without scrolling
- Right-click menus
- Data in list w/same A:B move to column
- stop autocorrecting (c) to copywright
- insert a drop down list if a certain cell value is true
- simple chart question
- functions
- how do I get STDEV() 2 sigma?
- I cannot select a single cell or pull down cell contents
- Change highlighted cursor BOX border color (appearance) in Excel
- Word wrap problem
- Grouping
- Lookup of data
- vlookup with date formats
- macros not updating
- Excell version problem???
- Formula Required
- Compare lists
- sumif
- About nesting the hour function
- Copy/Paste from once cell to another
- Counting Function
- Lowest value
- gliding price
- SUMIF??
- How do I force Excel to show filter totals in the Status bar?