- Countif with conditions
- Link and formula question
- empty cells
- Drop Down Lists
- automatic move row from sheet to another
- vlookup based on random result returns incorrect result
- how to get the middle name
- Date function/Text issue
- CountIf & null values problem
- how to get the middle name
- Combining 2 or more worksheets
- Calculate projected figure
- IF Function
- How do i analyse visible rows only in excel?
- lookup
- Tracking worksheet names in functions
- Locked spreadsheet, move cursor only to unlocked cells?
- Coloring rows in excel
- Arrays - Horizontal or Vertical
- Indirect formula using Data Validation List of Worksheet Tabs
- need enter key to move to the next column beginning
- Long Time Delay To Paste From UserForm To Sheet
- Combining Text and Date for VLOOKUP
- Concatenate in a formula
- Nested Formula help
- Pulling in Information from a worksheet
- Problem with pasting dates - year mysteriously changes
- Calculating a dollar value of the result between 2 different times
- count conditionally across two columns?
- SUMIF function?
- what is syntax for if(between range of dates,"Q1","Q2")?
- Australian currency question...
- Auto Filter Status Bar
- formatting time in excel
- Using "$" to reference same column in every row
- Modifying VLookUp
- RATIO number format
- Formula Color
- DSUM for date range
- Center text in dialog box
- emailing a single worksheet from a workbook
- Count Mondays worked in Month
- Time Calculations
- I want a formula to find age of person
- GetpivotData returns a #REF! error
- Tricky 'Find Maximum' problem seeks formula
- year function and financial years
- custom formatting??
- Today function is driving me nuts
- In Excel find characters when multiple characters exist w/i a cel
- Finding Cell Address for Use as Formula Argument
- Year row removal
- Random question / data selection
- If formula ?
- Custom Number Display
- Need 2 add second then third code with first code in the Tab View
- Sumproduct to ignore text and ""
- =cell("filename") in multiple places
- Comparing files and extracting info.
- Filter based on Pivot table
- Date/Time Function
- Relative standard deviation in Excel
- Creating a Pivot Table with data in more than one worksheet
- hidden element
- hidden element
- hidden element
- Using COUNTIF with visible rows only
- Converting 24 hr clock to GMT
- how to protect excel worksheet and still use the outline buttons?
- Link the format of one cell to another's
- using the name of the worksheet as argument
- Calculation of hourly rate times hours times 1.5
- Count if date is between two dates and value in another column equ
- Sorting rows to a another sheet
- How can I see custom formula code?
- Duplicate Cells
- Deleting cells with repeated data
- Conditional Formating won't work
- Issue with zero/# issue!!
- Complex formula vs. simpler
- "MEDIANIF" Array combining two ranges
- Paste Special - Values - Transpose
- Datedif incorrect month count - February problem??
- Dynamic External Workbook Formula
- A one page per view year planner
- 3 values, show which ones are same
- Auto-Fill in List Fields?
- Investment FV
- VBA error - End If without Block If
- cell reference?
- Function for generating monthly & weekly averages
- Linked cell displays 0
- formula for month that is prior to actual
- Complicated If Then / V Lookup / Match Statement...
- XML date formatting
- If Function containing VLook up
- Graphs
- vlookup returns list?
- Shortcut for referring to tab names in formulas
- Capture the Workbook Name
- Report by two categories.
- Rounding
- Index multiple cells
- How can I use the tab button after protecting the worksheet?
- Retry: VLOOKUP nested in IF Statement
- Can I do this with built in functions?
- basic sumif function help (urgent)
- Match more than 1 value
- Nesting-Don't use Blanks inside formula
- cannot use ISEVEN or ISODD functions in Conditional Formatting
- Maximum Drawdown Function
- Calculating days & time left from start date/time to end date/time
- How do I copy a worksheet's print parameters to other worksheets?
- 79% Doesn't like Me
- Counting dates for a the present month but not future months
- formula to look up a date and add x, y, z columns to x, y, z row
- sort by highlite color
- Maybe I need help with Lookups??
- formula that includes a maximum amount
- Array issues
- How do I effeciently share text from two different sheets?
- Can I use a drop down list to navigate to other spreadsheets
- stopping code from looping
- How can I make a range "dynamic"?
- Hyperlinks to .pdf files
- =COUNTIF across Worksheets
- protect specific cell but allow edit on other cell
- federal tax tables
- Formual to Lookup and Transpose
- convert negative numbers to positive numbers and vice versa
- HOW TO REVERSE THE ROW OR COLUMN HEADINGS
- if fuction
- Rows & Columns in Excel
- An FAQ that never seems to be answered: autofiltering with protection on...
- Limited byrows propagate a value via macro to all cells in column
- Complicated question...
- Updating Excel forecasts into an Access Database
- Count
- links for formulas between two worksheets, payroll carryover acrossmonths
- Dynamic External Workbook reference
- Weighed Average
- Missing cells, But they're NOT hidden
- Instead of a negative number, I'd like to show zero...
- Track Annual Inspection Due Dates Using Conditional Formatting
- Prevent selection of cells, based on value of another?
- Excel - create button to replace cell content with cell value
- how do get the frequency
- Syntax for using "IF"...
- Clipboard
- when I wrap text in excel it disappears? autofit does not work
- Help me help a user in our office
- Erase Duplicates
- Grouping By Date in Pivot Table
- SUMIF - Can I total the value of cells if three other cells = set
- formula for month(s) prior to actual
- Dividing the value of a cell if another cell equals a set value
- Sum Multiple Criteria
- Is there a way to build a timeline PPT spread sheet from excel
- Bonus formula help needed
- Microsoft Excel 2003
- Sum Multiple Criteria
- Using the "IF" function?
- FIND is not "finding" a number in a column which contains the numb
- Can Excel Calculate a Jensen Alpha?
- averaging on an "if" or "sumproduct"
- Countif, then multiply??
- How do I go from one page to another in excel without scrolling?
- Multiple Criteria
- Multiple conditions
- adding IF statement to subtotal for autofiltered data
- Calculations in pivot table
- Can actual size of CHECK BOX be increased?
- Word wrapping in Text Box Control feature
- add to an existing function
- How not to show #N/A when using vlookup formula
- How do I compare two Excel columns of numbers and see non-matches
- conditional format by comparing to current date
- Help with if statement.....
- Grids
- Time Intervals
- Looking up Top N using criteria
- Macro to Protect OK, Unprotect now messed up!
- I would like to extract some text in my WorkSheet Tab and enter it
- formula to look up and return smallest date from a range of dates
- formula for a pension
- Multiplying two rows together
- keystroke to close active workbook window
- Add missing rows
- Overtime computation and lunch break formula with IF and AND
- Complex overtime calculation
- GETPIVOTDATA function
- Show blank cell when not Closed or Open
- How do I capitalize and parse in the same formula?
- how do I set up a inventory sales template?
- Sum different departmnt
- Is there a way to calulate M-T-D or Y-T-D in Excelt?
- why is excel so slow
- Search engine in excel
- How can I change the font on a Sales Invoice Template?
- formula I can't figure it out?! ARGH
- What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
- To create formula to add 3 years and subtract 1 day from a date?
- finding redundant data
- Continue formula but without showing last total
- Data Validation Source Box
- warning: cannot change part of an array. how do I by pass this?
- Hide cell to printer
- Continue formula to LINE 1000 without showing FALSE
- US dates to UK??
- I want to create and name 365 worksheets...
- What am I doing wrong?
- Each New Excel to open in another session
- why does =GAMMAINV(0,5;389;1) return #NUM! ?
- R1C1 Formula in Excel
- Default cursor/selected cell position after protecting
- size of data validation dropdown list
- Count Mondays worked in Month
- macro
- Changing the colour of a logic expression
- Function not working
- If Statements - Multiple formulae
- Excell help
- How do I set up a range within a IF function?
- pivot table
- Comparative Formulas
- Multiple V Look up help?
- Function to find the address of a cell
- How to change positive numbers to negative numbers without re-ente
- Sequence Formula
- Update a cell with a specific value related to a date.
- COUNTIF: 2 criteria: Date Range Column & Text Column
- Excel If Statements, please help!
- How do I lock a column in EXCEL to prevent changes-can add input
- Subtotaling list of different items
- Position of cursor when protected file is opened
- How do I link a folder to a cell in an Excel spreadsheet
- Function to add multiple "."s with a cell?
- Entry into check box dependent on other check box.
- Change the right click menu on cells with imported data?
- Lists help
- Conditional Formatting
- Re: Rounding up the result of an IF function
- How can you insert a picture in a protected Excel Sheet?
- COUNT formula need two conditions
- 3.10 PM to 24 hour time please ( 1510 )
- Formula help for counting,with a column of dates and a column of n
- Question to Bob Phillips (or whoever...)
- Splitting the contents of a cell?
- restricted values that can be entered
- Splitting Up Text in One Cell To Many
- Conditional Formating issue.....
- Delete rows that contain blank columns
- SUMPRODUCT Question....
- dependent dropdown boxes
- Count if match any of 3 strings
- Sales V commission
- format cell based on previous one
- How to get leading zeros using DEC2BIN
- Add numbers in column b if date is between certain criteria
- count values in one column based on their realtionship with anoth.
- Problem Referencing Multiple Lists
- Comparing One Range and Adding Another
- I would like to count the # of times a value occurs in Col B base
- vlookup function
- Nested If/Then statements
- Yes, No, N/A in formula
- Conditional Formating
- Creating a single vertical array from multiple column arrays
- Conditional Formating
- COUNTIF nonblanks
- list data of same cell on different worksheets.
- Connecting data in different pages and make calculations
- Unique numbers if between dates
- combining conditional formatting and functions
- Sum formula of cells with specific color value
- Date formula needed
- Group function while using Pivot tables
- How to count uniques of a SUMPRODUCT subset?
- Want to offset found value using Index
- Convert letters into numbers. i.e. ABCD = 52
- Range efficiency
- how do get the frequency in 2 columns
- Count Question
- Creating a schedule
- Don't know how
- Formulas in Excel XP
- Formatting Numbers
- Macro for cell selection starting with Last Cell
- value of #'s in column if between dates
- Vlookup using two columns
- Counting Unique Part Numbers In A Range
- How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
- Sumif
- Is it possible to build macro that compares diff workbook columns
- Count Characters
- "last modified date"
- Help with a complicated array formula
- Count number of items in one column that have a value in another?
- Looking for best fit
- Need help updating my macro to include a 2nd worksheet.
- mid and find
- Find first occurence in a list that's greater than a specific num
- Matching Question
- how do i set the enter key to give a horizontal movement
- Nested function
- How do I specifly text lenth if the text is words instead of #'s
- Still trying to figure it out
- Sumproduct
- IF command, limit to number of entries?
- Is it possible?
- how do I keep column titles on subsequent pages of a pivot table
- how to add a drag-down list box in Excel
- How to Highlight the date if it is within 3 months from now
- When merging information not merging correctly
- Rank where lowest value is highest rank
- Sum Count of Criteria Every 3rd Row
- Still stumped
- I need to consolidate data from 3 different worksheets?
- De højeste tal
- Nesting or new column?
- Macro for Hyperion
- search box in excel 2003?
- excel - autonumber feature
- formula to find the filter criteria
- Calculate date
- Finding Matching (ContraSide) Transactions
- Will Excell 2003 convert numbers to words?
- Concatenate shortcut?
- sumif only for unhidden rows
- Update rows with new pricing
- Re: Find percentage ???
- Macro time out error
- Sum a row of multiple vlookups
- delete column heading for print
- RE: Find percentage ???
- gcTCPObjLib.dll use as Excel function library
- Ruler in excel for draw
- filtering between spreadsheets
- another data calculation
- How can I sort a group of numbers automatically as data is entere
- Macro required
- Indentify value from multiple values in a single cell
- sumproduct?
- Excel: How do I sum a row if one cell has #n/a in it?
- dragging a formula down a column
- count problem
- STDEVPA question
- Conditional subtotals
- How do I use multiple functions?
- Merge pages of data
- Sum doesn't work automatically
- how insert same text in empty cells in column (10000 rows)
- Counting Starting Digits
- Drill Down Function Office 2000/2003
- How to set condition: A1=A2=A3= ... =A10
- Insert manual line break in formula
- Extract each item in the list
- Dynamically-linked formula, cell reference in the string
- #VALUE!
- How do I set up automatic sequentially numbering for worksheets?
- How do I change my typing from horizontal to vertical
- round up numbers to next highest "4"
- Excel 2003 - Shared Workbook NOT Saving Changes
- add data to combo box in excel then invoke macro
- YIKES! All Validation functionality DISAPPEARED!
- Today's Due Date in Colour
- Copying Formulas
- Divide date into separate columns
- Exportin to xl
- match and if then
- Mileage calculator in EXCEL
- Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
- Excel Help Please
- can i recover a file i didnt save nor have i closed out?
- How to calculate average from large dataset in several sheets?
- All pictures disappear from my whole excel file when I use 'hidden
- Conditional formatting
- Problems with Sumproduct formulas
- How to interpolate in an array forX and Y values to get Z?
- How do I change the end cell (Ctrl end) in a excel spreadsheet?
- =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)>6,MON TH(date)-6, MON
- re-arrange text
- how to draw a chart using x,y axis not the date with x-axis?
- spell number
- MODE Function
- Buyer Vs Seller Matching Formula
- Time function
- Data Validation (Multiple Choice)
- Returning specific cell if zero
- Copying Formulas to Other Worksheets
- Worksheet tabs on multiple lines?
- Format & formula retained
- using the fill handle All the cells return the value of the first
- Text Extract
- How can I password protect a hidden column in Excel?
- Copying information and calculations from one sheet to another she
- cell reference math
- HOW DO i CHANGE THE FONT IN A CHECK BOX?
- How do I hide a TAB?
- How to reference cell in other worksheet
- if statements with colors?
- mail merge with Excel data source
- Calculation with IF functions
- The last column in my word document contains both text and number
- Test plus date and time
- I want to copy a formula n Excel but skip any blank cells
- Hyperlinks
- how do I set up multiple (3,000) hyperlinks in excel quickly?
- Using copy/paste after subtotalling
- How do I make a search sheet?
- How do I convert numbers to words writing checks with Excel?
- downloading an attachment
- Is this possible??
- identify first date a record appears
- Question about this formula...
- Forcing data into a cell
- retain formatting as an actual value
- copying an entire worksheet - need absolute values
- Summing values if conditions are true
- Excel ISERROR function
- need to change num key pad from moving the mouse pointer
- Using absolute cell refernce and inserting rows
- If Statement and two metrics
- Using a cells contents to reference a sheet.
- Nested IF Function and VLookup Alternatives
- Urgent appeal; Please get us out of here.
- Question regarding wildcard in multi-criteria IF formula
- how do i insert a code bar or link to a adobe designer file
- Can you use the validate function in a data form in Excel?
- average w IF
- "Best Practices" Use of GetPivotData Function
- I would like page setup to always be in landscape not portrait
- Calculate time in a cell
- References to Blank Cells turn into Zeros
- How do I highlight three cells in a row with speech recognition u.
- Match function
- Create a list based on single shared criteria
- Complex Sorting Problem
- How to turn a spreadsheet into a function?
- header/footer from page
- Help with Combination function
- Help with Combination Function
- If Function
- Vlookup in different worksheets
- EXCEL FILTERING - aghh!
- Hide tab sheet in webpage (Excel)
- lookup in MATRIX
- Extracting month as text
- Can I allow cell merging in a protected sheet
- Extracting Data from a list
- How to find hidden names on an Excel worksheet ?
- IF statement
- If Formula
- feet, inches
- Does SUMIF in Excel, take multiple criteria input?
- Round/Ceiling on an IF function returning numerical value or text
- Column Width and Row Height
- How do I separate worksheets in a workbook into individual files?
- countif
- greyed out menu items
- Linking 2 workbooks
- Multiple Workbooks Summary
- Countif on multiple dates
- Why aren't the exceptions I selected in WS Protection working?
- How to make Horizontal data go Vertical
- POP-UP MESSAGE IN EXCEL
- Is there a formula that will convert h:mm:ss into seconds?
- auto expand rows
- DSUM with Criteria containing non-hardcoded values?
- Set color of cell based on info on another sheet?
- count if with two references
- need to remove a comma from end of test in cells
- Can't change cell value with unusual font.
- Can I format a cell to include quotes " "
- Copy subtotals without hidden rows
- SUMIF and Dates
- Whey is Excel 2003 calculating take so long - sometimes 20 minute
- Combining Nested IF statement with Between operator
- how do I =if(any one of 20 specified cell=1," ",1)
- How do I use the concatenate function to add a date into a sentenc
- How do I combine If and VLookup function?
- Sorting Data in Tables
- Extract From Cell
- Autopopulate with zero
- Formula Help
- Value Return
- HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?
- Formula to compare a cell to find same value in a column in Excel
- INSERT COMMENTS WONT SAVE
- How do I unhide a column when format/column/unhide won't work
- creating a complex cell
- Sum numbers only; no text
- is there any excel founction for Cramer's V
- Need formula for: IF K1 = y then M1= the date in A1 + 15 days
- Checking for a zero value in multiple columns
- On the last day of each month, insert a static value
- hiding cells from others
- Need your suggestions
- microsoft.public.excel.worksheet.functions
- Help with find in Excel ...
- Lookup top 5 values (MAX function?)
- Matching problem
- Help - Separating numbers appearing on the right of a text string
- is there a formula for changing h:mm:ss to seconds?
- Test display until value
- stroll bar
- Data Validation
- Printing
- how do i create a macro for putting a check in a box?
- auto update of copy of workbook
- OR or conditional format
- Keeping Control Buttons Still
- Need Help with a Date Sum Product
- How do I format list of names formatted last,first to first last?
- Excel formula-cell reference not working
- Advanced Filtering.....
- How do I show file creation date in a cell in Excel?
- Ignoring highlighted cells
- create pivot table from excel table
- adding and divideing by a the number of cells!
- =IF(logical test,value if true,value if false) always backwards!
- Excel Help
- Eliminating #N/A
- Ignoring weekends & holidays-NETWORKDAYS?
- Data Validation drop down for multiple worksheets
- How do I increase the font of my drop-down menu options?
- WORKDAY formula in excel
- Sharing sheet
- How do I get the quick key commands to work in excel?
- Macros???
- Combine information about products from 2 spreadsheets
- How do I get the quick key commands to work in excel?
- Help with using filter criteria with date
- How do I build a reference to an external worksheet?
- Making this formula work
- Matching and aranging data form two sources
- make a negative number zero
- How do I Find links in worksheets - not in any formula
- Problem with VLOOKUP formula
- Can I add a graphic to a cell in Excel
- how to compare text fields in 2 different columns in excel
- Sum function
- Excel And Multiple CPU
- RE: Converting text into Date Value
- Is it possible to insert a picture using formulas?
- Converting text into Date Value
- RE: Countif question
- Multiple Count Criteria
- If, but, and still but, all in one formula?
- Summing Rows with Multiple Criteria
- Wrap Text
- How do I search excel spreadsheets using multiple search criteria.
- Copy Comments
- Macro - Delete Comments - What if there's none?
- 2 wkshts showing different views with same fonts & zooms
- Countif question
- IS there a way to find the name of GIF file over Excel cell
- Find and Replace
- sumproduct
- sumproduct with 0/blank cells
- Ok In One Column - #VALUE In the Next
- I want to combine the totals from several workbooks to one summar
- Problem with criteria when using it from VBA Code
- EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT
- Nested IF statement with cell range reference
- Can excel total up the same cell reference across several workshee
- grouping data
- link cell in 1 wk-sht to another & keep it regardless of sorting
- Can I use a header or footer more than 255 characters in Excel?
- find averages not including 0's for values not in contiguous rows or columns
- change cell size from page to page on the same worksheet
- Lookup against pivot table with multiple instances
- Add total number of rows (text) in a column
- vlookup does not work between 71% to 79% refernceing roundup numb
- Can I make a list, on one summary sheet, of data collected from ma
- Set View to 75% upon Workbook open
- #Div/01
- Changing Formula elements to values
- conditional data validation
- Macro to convert hyperlinks to text
- COUNT OR SUM OR IF?
- No refresh in copied cell
- Count Problem between dates
- =if returning 0
- couting transactions for same time
- Hide Fonts
- Floating Total Row
- Lookup (multiple variables)
- autotransfer data from different pages to balance sheet
- How do I change a name to titlecase in Excel?
- How do I set up an Human resources task planner
- Sumproduct: Formula is finicky
- ISNUM ????
- MSFT Excel
- Gathering and Combinging Data in 2 Spreadsheets
- XLSTART doesn't open PMW
- How do I protect hidden rows from being unhidden?
- Statistical smoothing a range of numbers - match average more clos
- Creating lookup formulas for material cost spreadsheet
- Is there a way to lock two or more rows together?
- How do I keep border permenant in a worksheet template?
- How do I copy subtotaled data without the underlying details?
- Importing External Data function
- can't change font
- Vlookup a column then a row
- how to copy cells data in every 7th row?
- Combo box list w/ data in 2nd workbook without opening both files
- Range of numbers in a formula...PLEASE HELP!!!
- Macro Help
- TAN different to a calculator? Please help would be appreciated lo
- "Cumulative" column based on a pivot table sum column?
- Inserting a string seach within a complex function
- Anyway to set numerical column name as Exel convention?
- Using Index(A:A,.........)
- Add a number button
- How do I change one repeated word in the spreadsheet to another?
- If Statement
- hidden worksheet?
- Trend Line constants
- Restarting a macro
- Data in cell to reference a worksheet page
- Cell Reference
- need to count/average if...
- merge
- How to lock a row in a spreadsheet based on the value in a cell
- Please Help !!!
- Linking WorkBOOKS across directories
- Macro to open workbook and copy and paste values in to orig workbo
- How to run a macro as soon a a workbook (.xls) is opened?
- vlookup:same lookup_value, different returns
- Look for match on two worksheets
- How to use distribution functions?
- Depriciation Matrix
- How do I combine the contents of multiple cells in one cell?
- TOTAL NUMBER OF ENTRIES
- how to write function to find max deviation from specific number .
- how to cover the formula
- Formula for determing average based on weighting
- Help with Formula,reulsts show in Function, not in Spreadsheet?
- Excel Formula - Reg
- ? Link attached - How to validate SIN (Social Insurance Number)
- Look for values on another sheet.
- IF function for scheduling tool with outlook integration
- How to auto activate macro when file open ?
- sumif criteria
- Separate records from Vertical to Horizontal
- How do I change the font color based on results of an IF stateme
- Use networkdays INCLUDE weekends, Exclude holidays
- formatting a cell with text from other cells
- Graphing error using Time as X axis.
- What is the formula for blinking a cell with a value in Excel
- Nett Date Calculation
- how to sort date in excel
- Change Cell Color Based on IF Statement
- Zip codes that begin with a zero...
- Calcualted Fields in Pivot Tables
- HOW TO: In a formula, how to change the format of the resulting te
- Excel won't update/calculate a single cell in a workbook
- Help Please-Counting Filtered Rows
- Override save as Dialog box
- Can't change font
- hide unnecessary sheets when emailing to others
- Setting Cell Number Format With A Worksheet Function
- Looking up information based on Columns and Rows
- Validation of Postal Code
- SUMPRODUCT question
- UDF's using other UDF's
- Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?
- Hide #div/0 Error When Averaging
- Return Single Row of Numeric Data to Single Column
- Generate an Absolute Date in a Cell
- Stock monitoring work sheet.
- In excel my find a value in a cell won't work. Why?
- Locking a cell
- Array formula needed
- formatting end of month on a monthly sheet
- Hyperlink
- Any software for charting moving averages?
- How to auto activate macro when file opened
- Complicated Vlookup/count problem
- If false skip to next
- Function help please!
- Including objects based on a condition
- Counting # of Times an Item Shows Up in a Table
- Time conversion
- Moving a Selection of data???
- Using cell contents within a formula
- Can i move scanned jpeg text to excel spreadsheets
- Worksheet name in cell
- How can I create a field indicating a persons age by using bd inf
- How to create compounded int table?
- Statement of Account
- Subtracting Hours - Eastern to Pacific/Central
- THE CUMIPMT() IS NOT PRESENT?
- Query
- Hlookup/max value?
- how do i get a set of pieces from a given # with standard lengths
- VLOOKUP range lookup
- Pivot tables
- vlookup question
- How torecord the highest value in a set of constantly changing num
- Merge and sort pages of data
- IIF issue
- Cant Get IF(ISBLANK) to work
- [R2]*-1 HELP
- I am trying to match 2 lists
- count and display unique values
- getting value 1 column to right of cell selected in pulldown
- find selling price of bonds
- Suppressing zero value display in print-out
- Totalling Collumns
- how do i use more than 3 conditional formats settings???
- Allow to "wrap" columns of data in Excel.
- Link to Cell Not Updating
- How I sort data in Excel, it keeps saying "merged cells must be ID
- Columns and Rows
- inserting sheets into existing workbooks w/o external references
- HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED
- Combine 2 Data Validations Q
- date format and the RIGHT function
- date format and the RIGHT function
- date format and the RIGHT function
- valuing a labelled odds formula '15/8 I want result 1.875 ??????
- If Statement and Dates
- Removing "Save As" Command from an excel file.
- sum limit and marking
- static data consolidation
- Sort text list alphabetically using a formula
- VLOOKUP result is not showing up - only the formula
- Cascading Lookup Functions?
- Lookup function or something like it...
- When using Autofilter on Excel, how do I ignore 1st 1 or 2 rows
- Simple Question
- synchronizing (?) two worksheets
- Multiple sheets as data for a single sheet
- If columns match
- How to find if a date falls between 2 dates
- What is the Formula to find the Media of a number of cells?
- Can Excel count the number of scores within a range?
- Spreadsheet performance is slow
- help.. too difficult to put into words
- Get rid of the zeros?!
- Adding numbers in a column results in zero: why?
- Advanced Filter criteria (formula)
- Select Largest 5 in A, AVG values in B
- Locking A Formula In A Cell
- Conditional Formatting when inserting a row
- Returning next value from a list
- time stamp
- Auto Filter Subtotals
- Division by Zero Error
- Excel Macro Question
- count records meeting three criteria
- How to write the formula for time accounting for a work schedule
- Value returned from Formula changes with the Date
- how do I find my old questions
- Sumif across multiple worksheets
- Multiple Functions In One Column
- Select from List of names to equal a specific rate
- Add/Replicate Text In Cell Entry
- formatting number value to text value in excel
- Autofill Date/Time
- Assigning values to letters
- reset option buttons
- lookup with a formula
- empty cell equivalent value
- How do I get rid of formulas?
- Wildcards
- Vlookup accross multiple worksheets
- Protect hide worksheet
- worksheet linked to a cell
- creating a date column from seperate data
- European Average Weight Legislation Formula
- Gaussian Elimination
- Changing Imported Date Formats
- Changing Imported Date Formats
- Correcting a #REF!
- vLookup - display multiple rows
- summing characters in a string
- Watermark
- clear all except formulas, conditional formatting and validations
- Urgent! Somebody Pleez help!! Inventory Valuation
- Rank by flight
- Calculating market growth rates
- Need to rebuild formula using the value entered into a cell on the
- worksheets
- Pivot Table Summaries
- Summarizing data based on ID
- Index Row
- Copying text from a free form field
- Calculated fields in pivot tables
- Syntax for IF with multiple criteria
- Linking Data from 1 sheet to another sheet
- Calculating total work week hours
- Calculate Term
- find the value of the last digit in a cell
- conditional formatting and timelines
- How do I use cell contents as an address in a formula
- show a block of info from a list on another worksheet
- Adding a Baseline Value into my existing column graph.
- How do I Hide frozen panes when printing?
- test for "special characters" in text
- replace formula
- Conditionally formatting other cells?
- get back to day one based on current date
- If statement to avoid Creating Circular Reference
- sum calculation
- Calculating a colmun to total a 40 hour work week
- Excel - print 2 pages on 1 sheet of paper
- group same
- Truncating a text string
- How do I track dates?
- Using Max & keeping other data
- Find the Cell Reference Resulting from MAX function
- Restructuring records into a list
- Splitting an Excel cell
- Can i "filter" in excel by words in Bold?
- Vacation accrual based on hours worked - Excel 2003
- Copyright in Footer
- Format monetary amount to 9 digits with No decimals without rounding
- Conditionally ignoring certain cells in columnar calculations
- the numbers are always in text and i cant seem to change them???
- synchronization ?
- convert number in cell to text in another cell
- How change "535?4090" to "535-4090" using replace
- Extending Row()
- How can I use a defined name in a header or footer?
- New Year
- Conditionally calculate formula in spreadsheet.
- Random search
- How do I add totals up from different sheets? A running total.
- Sum multiple text
- count duplicate records in a group
- Drop-down list & auto-population of cells
- I forgot my password in a protected column, is it hidden somewhere
- Excell-How to add the number of cells containing text? = a sum
- Average if
- Suming values from a xls file
- Hoe krijg ik = i.p.v. fx / werkte vh met oudere versie van Excel
- Month day confusion
- multiple individual comments in one cell
- Matching data from 2 columns
- Data Validation
- Trying to move a number in every 2nd column into a new worksheet into one colum, how would u do that? thanks
- How can I automatically highlight a cell that has changed value
- HOW DO YOU INSERT A MACRO INTO A FORMULA
- Counting consecutive periods
- Excel passwords are changing when two workbooks are open.
- how do i transfer an excel file from one computer to another
- Transfering colours
- vlookup
- Daily Totals on a summary sheet
- Need help in numbering a column while skipping lines
- Greater than, smaller than formula
- Getting the Check Register Balance to show on another Sheet
- Counting cells with formula CF (not value CF)
- Week/month/year rollovers with PivotTable
- Excel should have a formula to convert number into words
- How to Sum Up sales data by a product category from another sheet
- Two cell Comparison with three different Criteria
- Conditional formatting
- Protect Sheet with Marcro
- How to Sum Up sales data by a product category from anther sheet
- Excel System Error???
- How do I enter formula that adds a range if less than a number or
- Pivot Table formatting
- how to do normality test in excel
- Index and Row
- lookup? list data into summary table
- Code to protect sheet
- How can I change 255 character limit in 'hyperlink' function?
- CountIf formula results in the formula itself being displayed.
- Letter Counting Function
- Average of a >, < range
- Column Width
- Importing Data
- Averages
- How do I calculate the root of a number using Excel?
- lookup serch term and return sum of all values
- Coments
- formula linking "like" text
- links in excel change destination after sort
- sorting
- Data Validation w/ exceptions msg box
- adding accross sheets in a workbook
- In Excell-2000, database how do you extract unique records
- Conditionally formatting highest valued cell?
- Function triggering a macro
- Multiple criteria LOOKUP
- can you put radio buttons into an excel work sheet? and how?
- Pivot Table data source
- martrix help
- Average a set of figures which ignores 0 entries
- How to get auto change of name (word rama should be ram automati)
- DUPLICATE RANKS
- Conditional Formula
- How do I count rows in a filtered list when using AutoFilter?
- Formula to use to count instances of in Excel
- Changing today's date to the first of the month
- networkdays problem
- Multiple Sum, based on criteria
- Hyperlinks in a drop down menu
- Data Validation Function Help
- IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003
- CAPITALIZONG FIRST LETTER OF EACH WORD IN A TITLE
- Run macro based on time
- functions
- how do i use the vlookup with two references ?
- Text to value
- Tab Stops / Tab Order
- Pivot Table Question
- keyboard equivilent of the right-click
- Determine if Cell Address is within a Range
- Criteria in SUMIF
- Time calculation
- Can't add pay rates
- Allow Edit Prevent Delete
- Countif Question
- Lookup help, please
- How to avoid duplicate characters if only typed once?
- THE > SUPER-MONEY-SOURCE <
- How do I show the low-price supplier from seven different quotes?
- character limit in hyperlink function
- How do I create a worksheet within a worksheet in Excel?
- Insert file name in cells
- random numbers
- New Worksheets in a template to be pre-formatted.
- Is there a function to copy an entire worksheet?
- use of "if" based on text in another column
- Crossreferencing values between 2 spreadsheets
- Escape character for double quotes
- generate word file from excel
- Keeping cursor in same place on all worksheets in a workbook
- How to count several non-adjacent cells
- How do I create a random sample from a list?
- min or max results
- Formatting web imported data correctly
- Designating a workbook reference base on a cells contents
- Duplicate rows forever...
- how do i set up a calendar selection in excel
- Error formula too long
- totalizer formula
- Date formula
- Conditional Formatting
- how do i model discounts in excel solver
- Importing relative positoin information
- Correlation Matrix
- Reference a workbook with only a partial name
- Importing data, and need formatting advice
- wHAT AM i DOING wrong
- Excel recalculates on startup?
- compare cell contents
- COMPARE CELL CONTENTS
- Can I break and restart a link in a macro
- Drop down box of names with fixed values?
- Need to link/combine 5 worksheets into 1 (inventory nightmare)
- Allowing for variable cell reference in macro
- please i need an answer
- random number with text
- excel - sort, selected rows??
- How do I highlight a cell using conditional formatting and dates
- I ACCIDENTIALLY SAVED A BLANK PAGE OVER A FILE HOW DO I GO BACK T
- Filter unique random number
- How can I get a postal code in a cell - from the internet?
- lookup function
- A:1 now R1C1
- calculating return in a range
- Saving worksheet so that merge cells work in previous versions
- Convert Gig to Meg
- How to convert Number into words in EXCEL same or a new cell ?
- Open Hyperlinks at the same browser
- special row in excel
- Reference Cell if Found in a IF function
- Match function in a two input table
- what is the keyboard shortcut for generating a sequence
- Searching for the presence of specific words
- Basic If
- RUNNING TOTAL
- using linest excel function from msaccess with multidimensional ar
- #VALUE! error
- match problem
- Excel dropdown with text and value
- how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
- How Do I Ad Columns and Rows?
- sum up the ROW values with ref to COLUMN values!
- Checklist
- Partial String Match Using VLOOKUP
- Merge Row Data
- How to insert same header/footer across multiple worksheets?
- Urgent help needed!
- My Formula Changes on it's own?
- VLOOKUP show all results
- I would like to set a value for a range
- Networkdays & future months
- can i use a cell value as another sheet's cell reference
- Trouble with formula on Student 2006 learning essentials template
- Cell Address Matching
- HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
- macro problem
- macro saving problem