- Merge and sort pages of data
- How torecord the highest value in a set of constantly changing num
- vlookup question
- Pivot tables
- VLOOKUP range lookup
- how do i get a set of pieces from a given # with standard lengths
- Hlookup/max value?
- Query
- THE CUMIPMT() IS NOT PRESENT?
- Subtracting Hours - Eastern to Pacific/Central
- Statement of Account
- How to create compounded int table?
- How can I create a field indicating a persons age by using bd inf
- Worksheet name in cell
- Can i move scanned jpeg text to excel spreadsheets
- Using cell contents within a formula
- Moving a Selection of data???
- Time conversion
- Counting # of Times an Item Shows Up in a Table
- Including objects based on a condition
- Function help please!
- If false skip to next
- Complicated Vlookup/count problem
- How to auto activate macro when file opened
- Any software for charting moving averages?
- Hyperlink
- formatting end of month on a monthly sheet
- Array formula needed
- Locking a cell
- In excel my find a value in a cell won't work. Why?
- Stock monitoring work sheet.
- Generate an Absolute Date in a Cell
- Return Single Row of Numeric Data to Single Column
- Hide #div/0 Error When Averaging
- Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?
- UDF's using other UDF's
- SUMPRODUCT question
- Validation of Postal Code
- Looking up information based on Columns and Rows
- Setting Cell Number Format With A Worksheet Function
- hide unnecessary sheets when emailing to others
- Can't change font
- Override save as Dialog box
- Help Please-Counting Filtered Rows
- Excel won't update/calculate a single cell in a workbook
- HOW TO: In a formula, how to change the format of the resulting te
- Calcualted Fields in Pivot Tables
- Zip codes that begin with a zero...
- Change Cell Color Based on IF Statement
- how to sort date in excel
- Nett Date Calculation
- What is the formula for blinking a cell with a value in Excel
- Graphing error using Time as X axis.
- formatting a cell with text from other cells
- Use networkdays INCLUDE weekends, Exclude holidays
- How do I change the font color based on results of an IF stateme
- Separate records from Vertical to Horizontal
- sumif criteria
- How to auto activate macro when file open ?
- IF function for scheduling tool with outlook integration
- Look for values on another sheet.
- ? Link attached - How to validate SIN (Social Insurance Number)
- Excel Formula - Reg
- Help with Formula,reulsts show in Function, not in Spreadsheet?
- Formula for determing average based on weighting
- how to cover the formula
- how to write function to find max deviation from specific number .
- TOTAL NUMBER OF ENTRIES
- How do I combine the contents of multiple cells in one cell?
- Depriciation Matrix
- How to use distribution functions?
- Look for match on two worksheets
- vlookup:same lookup_value, different returns
- How to run a macro as soon a a workbook (.xls) is opened?
- Macro to open workbook and copy and paste values in to orig workbo
- Linking WorkBOOKS across directories
- Please Help !!!
- How to lock a row in a spreadsheet based on the value in a cell
- merge
- need to count/average if...
- Cell Reference
- Data in cell to reference a worksheet page
- Restarting a macro
- hidden worksheet?
- Trend Line constants
- If Statement
- How do I change one repeated word in the spreadsheet to another?
- Add a number button
- Using Index(A:A,.........)
- Anyway to set numerical column name as Exel convention?
- Inserting a string seach within a complex function
- "Cumulative" column based on a pivot table sum column?
- TAN different to a calculator? Please help would be appreciated lo
- Macro Help
- Range of numbers in a formula...PLEASE HELP!!!
- Combo box list w/ data in 2nd workbook without opening both files
- how to copy cells data in every 7th row?
- Vlookup a column then a row
- can't change font
- Importing External Data function
- How do I copy subtotaled data without the underlying details?
- How do I keep border permenant in a worksheet template?
- Is there a way to lock two or more rows together?
- Creating lookup formulas for material cost spreadsheet
- Statistical smoothing a range of numbers - match average more clos
- How do I protect hidden rows from being unhidden?
- XLSTART doesn't open PMW
- Gathering and Combinging Data in 2 Spreadsheets
- MSFT Excel
- ISNUM ????
- Sumproduct: Formula is finicky
- How do I set up an Human resources task planner
- How do I change a name to titlecase in Excel?
- autotransfer data from different pages to balance sheet
- Lookup (multiple variables)
- Floating Total Row
- Hide Fonts
- couting transactions for same time
- =if returning 0
- Count Problem between dates
- No refresh in copied cell
- COUNT OR SUM OR IF?
- Macro to convert hyperlinks to text
- conditional data validation
- Changing Formula elements to values
- #Div/01
- Set View to 75% upon Workbook open
- Can I make a list, on one summary sheet, of data collected from ma
- vlookup does not work between 71% to 79% refernceing roundup numb
- Add total number of rows (text) in a column
- Lookup against pivot table with multiple instances
- change cell size from page to page on the same worksheet
- find averages not including 0's for values not in contiguous rows or columns
- Can I use a header or footer more than 255 characters in Excel?
- link cell in 1 wk-sht to another & keep it regardless of sorting
- grouping data
- Can excel total up the same cell reference across several workshee
- Nested IF statement with cell range reference
- EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT
- Problem with criteria when using it from VBA Code
- I want to combine the totals from several workbooks to one summar
- Ok In One Column - #VALUE In the Next
- sumproduct with 0/blank cells
- sumproduct
- Find and Replace
- IS there a way to find the name of GIF file over Excel cell
- Countif question
- 2 wkshts showing different views with same fonts & zooms
- Macro - Delete Comments - What if there's none?
- Copy Comments
- How do I search excel spreadsheets using multiple search criteria.
- Wrap Text
- Summing Rows with Multiple Criteria
- If, but, and still but, all in one formula?
- Multiple Count Criteria
- RE: Countif question
- Converting text into Date Value
- Is it possible to insert a picture using formulas?
- RE: Converting text into Date Value
- Excel And Multiple CPU
- Sum function
- how to compare text fields in 2 different columns in excel
- Can I add a graphic to a cell in Excel
- Problem with VLOOKUP formula
- How do I Find links in worksheets - not in any formula
- make a negative number zero
- Matching and aranging data form two sources
- Making this formula work
- How do I build a reference to an external worksheet?
- Help with using filter criteria with date
- How do I get the quick key commands to work in excel?
- Combine information about products from 2 spreadsheets
- Macros???
- How do I get the quick key commands to work in excel?
- Sharing sheet
- WORKDAY formula in excel
- How do I increase the font of my drop-down menu options?
- Data Validation drop down for multiple worksheets
- Ignoring weekends & holidays-NETWORKDAYS?
- Eliminating #N/A
- Excel Help
- =IF(logical test,value if true,value if false) always backwards!
- adding and divideing by a the number of cells!
- create pivot table from excel table
- Ignoring highlighted cells
- How do I show file creation date in a cell in Excel?
- Advanced Filtering.....
- Excel formula-cell reference not working
- How do I format list of names formatted last,first to first last?
- Need Help with a Date Sum Product
- Keeping Control Buttons Still
- OR or conditional format
- auto update of copy of workbook
- how do i create a macro for putting a check in a box?
- Printing
- Data Validation
- stroll bar
- Test display until value
- is there a formula for changing h:mm:ss to seconds?
- Help - Separating numbers appearing on the right of a text string
- Matching problem
- Lookup top 5 values (MAX function?)
- Help with find in Excel ...
- microsoft.public.excel.worksheet.functions
- Need your suggestions
- hiding cells from others
- On the last day of each month, insert a static value
- Checking for a zero value in multiple columns
- Need formula for: IF K1 = y then M1= the date in A1 + 15 days
- is there any excel founction for Cramer's V
- Sum numbers only; no text
- creating a complex cell
- How do I unhide a column when format/column/unhide won't work
- INSERT COMMENTS WONT SAVE
- HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?
- Formula to compare a cell to find same value in a column in Excel
- Value Return
- Formula Help
- Autopopulate with zero
- Extract From Cell
- Sorting Data in Tables
- How do I combine If and VLookup function?
- How do I use the concatenate function to add a date into a sentenc
- how do I =if(any one of 20 specified cell=1," ",1)
- Combining Nested IF statement with Between operator
- Whey is Excel 2003 calculating take so long - sometimes 20 minute
- SUMIF and Dates
- Copy subtotals without hidden rows
- Can I format a cell to include quotes " "
- Can't change cell value with unusual font.
- need to remove a comma from end of test in cells
- count if with two references
- Set color of cell based on info on another sheet?
- DSUM with Criteria containing non-hardcoded values?
- auto expand rows
- Is there a formula that will convert h:mm:ss into seconds?
- POP-UP MESSAGE IN EXCEL
- How to make Horizontal data go Vertical
- Why aren't the exceptions I selected in WS Protection working?
- Countif on multiple dates
- Multiple Workbooks Summary
- Linking 2 workbooks
- greyed out menu items
- countif
- How do I separate worksheets in a workbook into individual files?
- Column Width and Row Height
- Round/Ceiling on an IF function returning numerical value or text
- Does SUMIF in Excel, take multiple criteria input?
- feet, inches
- If Formula
- IF statement
- How to find hidden names on an Excel worksheet ?
- Extracting Data from a list
- Can I allow cell merging in a protected sheet
- Extracting month as text
- lookup in MATRIX
- Hide tab sheet in webpage (Excel)
- EXCEL FILTERING - aghh!
- Vlookup in different worksheets
- If Function
- Help with Combination Function
- Help with Combination function
- header/footer from page
- How to turn a spreadsheet into a function?
- Complex Sorting Problem
- Create a list based on single shared criteria
- Match function
- How do I highlight three cells in a row with speech recognition u.
- References to Blank Cells turn into Zeros
- Calculate time in a cell
- I would like page setup to always be in landscape not portrait
- "Best Practices" Use of GetPivotData Function
- average w IF
- Can you use the validate function in a data form in Excel?
- how do i insert a code bar or link to a adobe designer file
- Question regarding wildcard in multi-criteria IF formula
- Urgent appeal; Please get us out of here.
- Nested IF Function and VLookup Alternatives
- Using a cells contents to reference a sheet.
- If Statement and two metrics
- Using absolute cell refernce and inserting rows
- need to change num key pad from moving the mouse pointer
- Excel ISERROR function
- Summing values if conditions are true
- copying an entire worksheet - need absolute values
- retain formatting as an actual value
- Forcing data into a cell
- Question about this formula...
- identify first date a record appears
- Is this possible??
- downloading an attachment
- How do I convert numbers to words writing checks with Excel?
- How do I make a search sheet?
- Using copy/paste after subtotalling
- how do I set up multiple (3,000) hyperlinks in excel quickly?
- Hyperlinks
- I want to copy a formula n Excel but skip any blank cells
- Test plus date and time
- The last column in my word document contains both text and number
- Calculation with IF functions
- mail merge with Excel data source
- if statements with colors?
- How to reference cell in other worksheet
- How do I hide a TAB?
- HOW DO i CHANGE THE FONT IN A CHECK BOX?
- cell reference math
- Copying information and calculations from one sheet to another she
- How can I password protect a hidden column in Excel?
- Text Extract
- using the fill handle All the cells return the value of the first
- Format & formula retained
- Worksheet tabs on multiple lines?
- Copying Formulas to Other Worksheets
- Returning specific cell if zero
- Data Validation (Multiple Choice)
- Time function
- Buyer Vs Seller Matching Formula
- MODE Function
- spell number
- how to draw a chart using x,y axis not the date with x-axis?
- re-arrange text
- =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)>6,MON TH(date)-6, MON
- How do I change the end cell (Ctrl end) in a excel spreadsheet?
- How to interpolate in an array forX and Y values to get Z?
- Problems with Sumproduct formulas
- Conditional formatting
- All pictures disappear from my whole excel file when I use 'hidden
- How to calculate average from large dataset in several sheets?
- can i recover a file i didnt save nor have i closed out?
- Excel Help Please
- Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
- Mileage calculator in EXCEL
- match and if then
- Exportin to xl
- Divide date into separate columns
- Copying Formulas
- Today's Due Date in Colour
- YIKES! All Validation functionality DISAPPEARED!
- add data to combo box in excel then invoke macro
- Excel 2003 - Shared Workbook NOT Saving Changes
- round up numbers to next highest "4"
- How do I change my typing from horizontal to vertical
- How do I set up automatic sequentially numbering for worksheets?
- #VALUE!
- Dynamically-linked formula, cell reference in the string
- Extract each item in the list
- Insert manual line break in formula
- How to set condition: A1=A2=A3= ... =A10
- Drill Down Function Office 2000/2003
- Counting Starting Digits
- how insert same text in empty cells in column (10000 rows)
- Sum doesn't work automatically
- Merge pages of data
- How do I use multiple functions?
- Conditional subtotals
- STDEVPA question
- count problem
- dragging a formula down a column
- Excel: How do I sum a row if one cell has #n/a in it?
- sumproduct?
- Indentify value from multiple values in a single cell
- Macro required
- How can I sort a group of numbers automatically as data is entere
- another data calculation
- filtering between spreadsheets
- Ruler in excel for draw
- gcTCPObjLib.dll use as Excel function library
- RE: Find percentage ???
- delete column heading for print
- Sum a row of multiple vlookups
- Macro time out error
- Re: Find percentage ???
- Update rows with new pricing
- sumif only for unhidden rows
- Concatenate shortcut?
- Will Excell 2003 convert numbers to words?
- Finding Matching (ContraSide) Transactions
- Calculate date
- formula to find the filter criteria
- excel - autonumber feature
- search box in excel 2003?
- Macro for Hyperion
- Nesting or new column?
- De højeste tal
- I need to consolidate data from 3 different worksheets?
- Still stumped
- Sum Count of Criteria Every 3rd Row
- Rank where lowest value is highest rank
- When merging information not merging correctly
- How to Highlight the date if it is within 3 months from now
- how to add a drag-down list box in Excel
- how do I keep column titles on subsequent pages of a pivot table
- Is it possible?
- IF command, limit to number of entries?
- Sumproduct
- Still trying to figure it out
- How do I specifly text lenth if the text is words instead of #'s
- Nested function
- how do i set the enter key to give a horizontal movement
- Matching Question
- Find first occurence in a list that's greater than a specific num
- mid and find
- Need help updating my macro to include a 2nd worksheet.
- Looking for best fit
- Count number of items in one column that have a value in another?
- Help with a complicated array formula
- "last modified date"
- Count Characters
- Is it possible to build macro that compares diff workbook columns
- Sumif
- How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
- Counting Unique Part Numbers In A Range
- Vlookup using two columns
- value of #'s in column if between dates
- Macro for cell selection starting with Last Cell
- Formatting Numbers
- Formulas in Excel XP
- Don't know how
- Creating a schedule
- Count Question
- how do get the frequency in 2 columns
- Range efficiency
- Convert letters into numbers. i.e. ABCD = 52
- Want to offset found value using Index
- How to count uniques of a SUMPRODUCT subset?
- Group function while using Pivot tables
- Date formula needed
- Sum formula of cells with specific color value
- combining conditional formatting and functions
- Unique numbers if between dates
- Connecting data in different pages and make calculations
- list data of same cell on different worksheets.
- COUNTIF nonblanks
- Conditional Formating
- Creating a single vertical array from multiple column arrays
- Conditional Formating
- Yes, No, N/A in formula
- Nested If/Then statements
- vlookup function
- I would like to count the # of times a value occurs in Col B base
- Comparing One Range and Adding Another
- count values in one column based on their realtionship with anoth.
- Problem Referencing Multiple Lists
- Add numbers in column b if date is between certain criteria
- How to get leading zeros using DEC2BIN
- format cell based on previous one
- Sales V commission
- Count if match any of 3 strings
- dependent dropdown boxes
- SUMPRODUCT Question....
- Delete rows that contain blank columns
- Conditional Formating issue.....
- Splitting Up Text in One Cell To Many
- restricted values that can be entered
- Splitting the contents of a cell?
- Question to Bob Phillips (or whoever...)
- Formula help for counting,with a column of dates and a column of n
- 3.10 PM to 24 hour time please ( 1510 )
- COUNT formula need two conditions
- How can you insert a picture in a protected Excel Sheet?
- Re: Rounding up the result of an IF function
- Conditional Formatting
- Lists help
- Change the right click menu on cells with imported data?
- Entry into check box dependent on other check box.
- Function to add multiple "."s with a cell?
- How do I link a folder to a cell in an Excel spreadsheet
- Position of cursor when protected file is opened
- Subtotaling list of different items
- How do I lock a column in EXCEL to prevent changes-can add input
- Excel If Statements, please help!
- COUNTIF: 2 criteria: Date Range Column & Text Column
- Update a cell with a specific value related to a date.
- Sequence Formula
- How to change positive numbers to negative numbers without re-ente
- Function to find the address of a cell
- Multiple V Look up help?
- Comparative Formulas
- pivot table
- How do I set up a range within a IF function?
- Excell help
- If Statements - Multiple formulae
- Function not working
- Changing the colour of a logic expression
- macro
- Count Mondays worked in Month
- size of data validation dropdown list
- Default cursor/selected cell position after protecting
- R1C1 Formula in Excel
- why does =GAMMAINV(0,5;389;1) return #NUM! ?
- Each New Excel to open in another session
- What am I doing wrong?
- I want to create and name 365 worksheets...
- US dates to UK??
- Continue formula to LINE 1000 without showing FALSE
- Hide cell to printer
- warning: cannot change part of an array. how do I by pass this?
- Data Validation Source Box
- Continue formula but without showing last total
- finding redundant data
- To create formula to add 3 years and subtract 1 day from a date?
- What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
- formula I can't figure it out?! ARGH
- How can I change the font on a Sales Invoice Template?
- Search engine in excel
- why is excel so slow
- Is there a way to calulate M-T-D or Y-T-D in Excelt?
- Sum different departmnt
- how do I set up a inventory sales template?
- How do I capitalize and parse in the same formula?
- Show blank cell when not Closed or Open
- GETPIVOTDATA function
- Complex overtime calculation
- Overtime computation and lunch break formula with IF and AND
- Add missing rows
- keystroke to close active workbook window
- Multiplying two rows together
- formula for a pension
- formula to look up and return smallest date from a range of dates
- I would like to extract some text in my WorkSheet Tab and enter it
- Macro to Protect OK, Unprotect now messed up!
- Looking up Top N using criteria
- Time Intervals
- Grids
- Help with if statement.....
- conditional format by comparing to current date
- How do I compare two Excel columns of numbers and see non-matches
- How not to show #N/A when using vlookup formula
- add to an existing function
- Word wrapping in Text Box Control feature
- Can actual size of CHECK BOX be increased?
- Calculations in pivot table
- adding IF statement to subtotal for autofiltered data
- Multiple conditions
- Multiple Criteria
- How do I go from one page to another in excel without scrolling?
- Countif, then multiply??
- averaging on an "if" or "sumproduct"
- Can Excel Calculate a Jensen Alpha?
- FIND is not "finding" a number in a column which contains the numb
- Using the "IF" function?
- Sum Multiple Criteria
- Microsoft Excel 2003
- Bonus formula help needed
- Is there a way to build a timeline PPT spread sheet from excel
- Sum Multiple Criteria
- Dividing the value of a cell if another cell equals a set value
- formula for month(s) prior to actual
- SUMIF - Can I total the value of cells if three other cells = set
- Grouping By Date in Pivot Table
- Erase Duplicates
- Help me help a user in our office
- when I wrap text in excel it disappears? autofit does not work
- Clipboard
- Syntax for using "IF"...
- how do get the frequency
- Excel - create button to replace cell content with cell value
- Prevent selection of cells, based on value of another?
- Track Annual Inspection Due Dates Using Conditional Formatting
- Instead of a negative number, I'd like to show zero...
- Missing cells, But they're NOT hidden
- Weighed Average
- Dynamic External Workbook reference
- links for formulas between two worksheets, payroll carryover acrossmonths
- Count
- Updating Excel forecasts into an Access Database
- Complicated question...
- Limited byrows propagate a value via macro to all cells in column
- An FAQ that never seems to be answered: autofiltering with protection on...
- Rows & Columns in Excel
- if fuction
- HOW TO REVERSE THE ROW OR COLUMN HEADINGS
- convert negative numbers to positive numbers and vice versa
- Formual to Lookup and Transpose
- federal tax tables
- protect specific cell but allow edit on other cell
- =COUNTIF across Worksheets
- Hyperlinks to .pdf files
- How can I make a range "dynamic"?
- stopping code from looping
- How do I effeciently share text from two different sheets?
- Can I use a drop down list to navigate to other spreadsheets
- Array issues
- formula that includes a maximum amount
- Maybe I need help with Lookups??
- sort by highlite color
- formula to look up a date and add x, y, z columns to x, y, z row
- Counting dates for a the present month but not future months
- 79% Doesn't like Me
- How do I copy a worksheet's print parameters to other worksheets?
- Calculating days & time left from start date/time to end date/time
- Maximum Drawdown Function
- cannot use ISEVEN or ISODD functions in Conditional Formatting
- Nesting-Don't use Blanks inside formula
- Match more than 1 value
- basic sumif function help (urgent)
- Can I do this with built in functions?
- Retry: VLOOKUP nested in IF Statement
- How can I use the tab button after protecting the worksheet?
- Index multiple cells
- Rounding
- Report by two categories.
- Capture the Workbook Name
- Shortcut for referring to tab names in formulas
- vlookup returns list?
- Graphs
- If Function containing VLook up
- XML date formatting
- Complicated If Then / V Lookup / Match Statement...
- formula for month that is prior to actual
- Linked cell displays 0
- Function for generating monthly & weekly averages
- cell reference?
- VBA error - End If without Block If
- Investment FV
- Auto-Fill in List Fields?
- 3 values, show which ones are same
- A one page per view year planner
- Dynamic External Workbook Formula
- Datedif incorrect month count - February problem??
- Paste Special - Values - Transpose
- "MEDIANIF" Array combining two ranges
- Complex formula vs. simpler
- Issue with zero/# issue!!
- Conditional Formating won't work
- Deleting cells with repeated data
- Duplicate Cells
- How can I see custom formula code?
- Sorting rows to a another sheet
- Count if date is between two dates and value in another column equ
- Calculation of hourly rate times hours times 1.5
- using the name of the worksheet as argument
- Link the format of one cell to another's
- how to protect excel worksheet and still use the outline buttons?
- Converting 24 hr clock to GMT
- Using COUNTIF with visible rows only
- hidden element
- hidden element
- hidden element
- Creating a Pivot Table with data in more than one worksheet
- Relative standard deviation in Excel
- Date/Time Function
- Filter based on Pivot table
- Comparing files and extracting info.
- =cell("filename") in multiple places
- Sumproduct to ignore text and ""
- Need 2 add second then third code with first code in the Tab View
- Custom Number Display
- If formula ?
- Random question / data selection
- Year row removal
- Finding Cell Address for Use as Formula Argument
- In Excel find characters when multiple characters exist w/i a cel
- Today function is driving me nuts
- custom formatting??
- year function and financial years
- Tricky 'Find Maximum' problem seeks formula
- GetpivotData returns a #REF! error
- I want a formula to find age of person
- Time Calculations
- Count Mondays worked in Month
- emailing a single worksheet from a workbook
- Center text in dialog box
- DSUM for date range
- Formula Color
- RATIO number format
- Modifying VLookUp
- Using "$" to reference same column in every row
- formatting time in excel
- Auto Filter Status Bar
- Australian currency question...
- what is syntax for if(between range of dates,"Q1","Q2")?
- SUMIF function?
- count conditionally across two columns?
- Calculating a dollar value of the result between 2 different times
- Problem with pasting dates - year mysteriously changes
- Pulling in Information from a worksheet
- Nested Formula help
- Concatenate in a formula
- Combining Text and Date for VLOOKUP
- Long Time Delay To Paste From UserForm To Sheet
- need enter key to move to the next column beginning
- Indirect formula using Data Validation List of Worksheet Tabs
- Arrays - Horizontal or Vertical
- Coloring rows in excel
- Locked spreadsheet, move cursor only to unlocked cells?
- Tracking worksheet names in functions
- lookup
- How do i analyse visible rows only in excel?
- IF Function
- Calculate projected figure
- Combining 2 or more worksheets
- how to get the middle name
- CountIf & null values problem
- Date function/Text issue
- how to get the middle name
- vlookup based on random result returns incorrect result
- automatic move row from sheet to another
- Drop Down Lists
- empty cells
- Link and formula question
- Countif with conditions
- Appending Random Results?
- Advancing Down A List
- how do I insert user name into a cell
- how do i make excel do this a*b=c then add the c colum up
- Conditional Display
- what is chidist and how to calculate it?
- Excel Project
- Question Please.
- Array Calculation Error
- concatenate in combination
- printing on 3 x 5 cards
- view fonts and size as you change them on the screen like corel
- Copy Paste Failure
- solver problem
- Calculatin NPV for a range of numbers.
- can't remember password
- can't remember password
- Trace Dependants Not Working...
- Index function error
- Moving from worksheet to worksheet
- input mask in excel
- Please HELP: Checking data
- Recently used files
- input mask in excel sheet
- converting a decimal number to hours and seconds
- protecting the worksheet
- Constraints in Excel Solver
- Mail merge
- Genetics with Excel: Determining ratios from Punnett Square Crosses
- finding part of fole path
- Summation from a to b
- Lookup with multiple conditions
- complicated sum formula question
- Is the Pivot Table the right tool to do?
- The negative brackets in Excel 2002 version do not appear. Why?
- External Link Shows Formula Not Info
- Sum values in multiple sheets using Lookup to find a text match
- locate and change hidden lines
- worksheets
- RE: Lottery exercise
- changing values in speadsheet
- IF Formula
- Improvement Percentage Formula Help
- how do i set up a weighted factor model in excel?
- Data>Validation>Input message
- Interest Functions
- matrix calculations
- checking that cells have a value before the workbook will close
- Keeping a cell value constant trhoughout a list of values
- Re: Restricting entry in B1 on the basis of entry in A1
- Error: Number of query values and destination fields are not the s
- IF this and IF that
- I moved a file from work to home and now my color macro does not w
- template use
- creating a search model
- Broken Limks
- Birthday date formula?
- Vlookup query
- Password visible if user selects "view code"
- Date problem (YYYY.MM.DD)
- Populating a grid
- average if, multiple if, divide if
- how to use 2 worksheets in one formula with INDIRECT & VLOOKUP
- countif
- Convert month to number and subtract one
- Restricting entry in B1 on the basis of entry in A1
- if statement i think...
- Mergers - market concentration - math help
- Find 2nd instance of a word in a range.
- crosschecking for duplicates
- Help with list box
- Sum cells in excel if shaded
- msg box at close
- Displaying Blank Cells
- Formula using 2 points of reference to return a value from a table
- List matching data from sheet 1 in sheet 2
- Using the filter value to look up other info
- Need a function to fill column from other columns
- How to find the largest product of an array of values?
- calculating matrix values
- How can you have data automatically populate btw workbooks
- "Calulate" appearing on Status Bar
- Trying to match a text string to a data table, any suggestions?
- Generating (in a random order)each number once from a given number
- Create a dialog box
- Storing Formulas to Use
- Help with Offset/Lookup
- "IF" formula returns zero or other incorrect number
- can you convert baht text back to a number?
- Filling Text from Another File
- how to get excel to display blank if reference cell blank
- Identify current active cell
- how do I round up a result of a formula in Excel
- Symbol function
- print excel worksheet gridlines without data
- Masking numbers
- Goalseek / Solver Target Value
- =If Function
- How to generate formula from two dimensional array of data
- AUTOMATIC way to copy the value of a cell in one spreadsheet
- Extension to Excel INDEX function
- how to make webquery based on cell
- Most popular items in a list
- Pie on pie charts
- Opposite of Concatenate
- last entry done in certain area
- How do I lookup data with two comparison values?
- Does excel have a function for statistical hypotosis testing?
- Date Command to Get the Sunday Before the First of the Month
- Adding Time
- organize data in a pivot table without summarizing?
- add more conditional formatting?
- adding odd numbers
- conditional formating - wildcards
- Formula Problem
- Dependent List (via Data Validation) Error
- How do I Delete Sheet when it won't light up in the Edit menu?
- Launch new browser window from hyperlink within Excel
- add month to date
- Reading Cell Function???
- sumproduct, arrays affecting speed
- vlookup and offset
- How do a create a formula that if a1=rh than c1=13
- Adding Time
- How do I extract numbers from a cell with both text and numbers?
- Is there any way to make buttons copy from one worksheet to anothe
- How do I return the row for a value I VLOOKUP?
- Formula returning current user name
- How to change and error message to text
- excel 2000
- make a cell required to fill-in on form template
- POP UP Message
- Automatically elliminate duplicates within a spreadsheet?
- How do I display list of tab names used in a workbook on a sheet
- COUNTIF use with fields of time
- What does the message: "Cannot shift objects off sheet" mean?
- Match then lookup
- Specifying the person who has achieved the highest result
- Excel cannot subtract???
- How do I return the first non-blank value in a row?
- Filling in missing dates
- Precision as displayed problems
- Conditional Count
- How do I sum numbers that match two conditions?
- Display a digit before or after the decimal point in another cell
- Return text
- IF statement for a column
- Cell Address Location
- Dynamic Ranges: Speed Issue
- Formatting for 15th and last day of the month
- How do I set conditional formatting to interface with other cells?
- BEFORE SAVE IMAGE
- how do I display row 1 (my column titles) as I page down in excel
- Duplicate rows
- How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?
- Excel Macro to Copy & Paste
- Replacing blank cells
- Countif and hidden rows.
- return value from list many conditions
- nested if function
- Spreadsheet sticking in Excel 2003
- Help with IF
- 1 TO 9 EXCEPT CELL CONTENT
- Filter Notepad file into Excel
- Vlookup considering 2 conditions
- Converting a date to a day
- to find missing serial numbers in randomly generated numbers
- IF function with multiple results: No problem for you guys, but for me...
- Can you color cells with Array Formula?
- Separate 5digits by inserting -
- how to do a Vlook up givin two conditions
- shortcut
- Drop Down Lists - Not allowing other contents to be put in same ce
- copy formula using same references
- How do I use IF in Excel to string the two text values (high,low)
- Longest string in a column
- Returning multiple instances of the same lookup value
- excel today countif over expired date
- Countif w/ #VALUE! errors
- Backup files in separate directory?
- making excel work like a mail merge
- Sort
- Automate process via button on form
- what control key function causes all CAPS-caplock not on
- Pop-Up Message
- Coping formulas
- conditional formatting:highlight row based on blank or non-blank c
- can I calculate S&H on a sliding scale in an order form?
- Writing Excel Macro
- How do I COUNTIF in excel using multiple criteria?
- decimal point
- copy cells with formula without references
- How do I Auto Number a field in Excel - sequential PO#
- Help with a macro to open to a specific worksheet
- How to reset all enteries on the worksheet?
- lookup prblem.
- Cube root?
- How do I data sort multiple sheets in Excel that are linked with i
- Preventing user entering duplicate values in a cell range
- Calculating percentages
- email using hyperlink
- How do I calculate time durations over numerous dates
- "Calculate" appearing
- using a hyperlink how do I send an updated file without saving it
- Producing Age Based on Date of Birth
- Leaing to the next full number?
- BETTER SPACING - If Then Date Range
- Conditional formating on if statement
- If then Date Ranges
- Clipboard Popup
- If statement help
- Not allow certain cell entries
- Turn Table into plot chart
- How do I save a worksheet "unshared" when it has been sent shared
- Cell Format - $ and Text
- 'find' somtimes can't find numbers. I folowd the 'help' instructi.
- trying to retrive number combo to = fixed amount
- linking customer database to invoices in excel
- multiple regression template
- mastery level thinking
- Convert Local Names to Global Names
- Making graphs from updates...
- Tricky FV function
- Conditional Formatting Copy down Rows
- VlookupS-Alan Beban
- microsoft should make a commercial lending software
- Linking Information in Sheets based on its content
- Why does using @SUM in EXL 2002 trigger an O/L "new" email ?
- Run-Time Error
- How can I find and mark double entries in a customer database?
- Excel should have a bar button to center across selection
- How do convert time into numeric
- How can I relate more than 7 cells with IF(...
- IRR - selecting cells
- How do I Excel countif column a =? and column b = null ?
- Is de-duping in advanced filter limited to a number of rows
- Auto-increment cell values by one
- last entry from certain area
- count cells in a range
- IF(I2-I25,"yes",K3=K2-C3:F3) formula not working, why?
- Excel2000: The latest value
- AutoComplete - Forms Combobox
- Finding total via entered text
- How to group multiple items in to three groups.
- can't edit a cell with a formula
- Can i add up all green filled cells in a workbook?
- need help guys
- Add amount if record contains a value
- subtotals in a pivot table
- how to add a row between rows of data
- return multiple corresponding values using INDEX
- Counting Entries in two lists
- unable to view color fill changes unless I print preview
- Where is the Data Tools group Help refers to when splitting cells
- how to split data from 1 row into two rows continuously
- Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu
- Minif / Maxif ?
- Compound interest
- Correct coding entry of VBA macros in Excel worksheet
- Delete a Row IF = certain value
- Replacing #DIV/0! With Just 0
- Tables tab under the Insert tab
- Using Dialog Boxes
- Function Help Needed
- Calculation in left corner
- Countif? or Vlookup? Lost??
- Countif and date check for second criteria
- Countif and date check for second criteria
- look up function and sum values
- How do I extract hyperlink as text from an array of hyperlinks?
- This should be easy...
- Make Autofilter Menu Font modifiable
- IF function with value_if_true and value_if_false as equations
- Linear interpolation between two points found using a lookup funct
- How do I format Excel to add new rows automatically?
- retrieve unique items with 2 criteria
- importing csv files and dates
- AutoFilter (Temporary Solution)
- Forecasting using arrays
- Formula Instead Of A Pivot Table
- Where's it gone?
- Array Formula Problem
- If Funtion
- on a calander how do i enter more than one event in one square
- Count Number of Times Something appears
- Calenderfor My Excel Spreadsheet
- in excel, how do i change the fill color?
- COUNTIF function when 2 conditions exist?
- extract decimal place digit
- how to use sumbycolor fuction?
- how to limit edit access to certain users for a shared workbook?
- Is it possible to create a workbook within a workbook?
- SumIf
- How to stop file open macro prompt after deleting all macros?
- Array Reference
- How do I make the D.O.B. Column calculate in Age Colum in Excel?
- VLOOKUP?
- Print all from list