- Colour full row in CF
- Reformatting dates as text
- Excel Function returning negative 0
- workday date function
- Matching data from seperate excel files
- SUMPRODUCT
- Show timesheet time in and out in regular time versus military tim
- creating hyperlinks
- a formula that leaves cell "empty"?
- Extract Unique Records from two lists
- need help with determining a formula
- forumal does not work
- ISNA(MATCH...) and IF functions - can they be combined?
- 2nd attempt ~ Faster/Shorter formula
- Linked Combo Boxes
- Match help
- Add seperate Items.
- With formulas does anyone know the order of precedence BOMDAS
- Building Formulas
- Printing problem
- Conditional Statement in Charts
- linest r-squared bug when calculating forced through zero?
- regression
- Need some assistance
- Spreadsheets with multiple entries
- AVERAGE(IF()) problem
- Location of the last "s" in a text string
- Formulas across worksheets do not update
- X axis break
- matching and lookup??
- FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES
- Timesheet maximum hours problem
- how do I count the numbers of row that meet 2 criteria
- questions being addressed
- RE: matching and lookup??
- sum>1 --> count = count +1
- saving documents with macros
- Preventing new worksheets when drilling down in PIVOTs
- Spreadsheet will not sort
- ##value error
- how to perform a deduplication of names on large mailing list
- IF/THEN Average Problem
- Running Query
- prevent empty rows from printing
- How do I compare excel spreadsheets, tracking the differences?
- IF COMMAND WITH TEXT
- spreadsheet spanning 4 weeks
- how do I insert a blank row when a value changes, automatically
- Columns in excel 2003
- SUMIF question with multiple criteria
- autofilter freeze
- How to set the "to value" in GOAL SEEK as a cell reference?
- Formula to compare two lists and separate non-recurring items?
- Using IF Function with EDATE Function
- countif condition problem
- Changing Cell Color
- Checking for duplicate items in list
- Formula for markup won't change when the initial value is changed.
- Confusing VLOOKUP with Indirect reference
- How do I change how cells are sorted in an excel file?
- IF STATEMENT PROBLEM
- SUMPRODUCT
- CF in a filter
- linkiing a worksheet
- Need faster/shorter formula
- Reverse numerical values
- Can "IF" function display calculated data as bold?
- Macro With IF Function
- UDF Add-in New category in "Paste Function Dialog Box"
- In Excel can you add cell A2:A10 that only have text
- How do i compare data fields and assign values?
- Can I write each row to a separate file?
- cheapest price
- Is there a function to give us the highest value in a list of tex
- mail merge. interest rate numberic format not working
- Is there a function that gives us the last day of a month
- Problem with adding time values
- Excel student/teacher edition 2003
- width of drop-down menus in lists
- Width of drop-down menus
- macro save a workbook whilst increasing file no
- Worksheet template
- How do i count numbers and letters to find a total count of all
- trying to link but not lose info
- Hour Sum
- How can I keep a fraction from being reduced?
- Replacing Values in Cells Via Formula
- Alternative to multiple IF limits
- pivot % or column tinkering
- options to update automatic links
- IF statements and moving data to different columns
- I have alot of text in a cell, I just want to see the top line
- Calender Help
- combobox not working
- Showing + and - (show and hide) for rows in the sheet
- transposing links
- Index/ Lookup formulas and fuzzy matching
- Help I am going crazy with this formula.
- Format cell to show numbers in words
- PIVOT Table
- formula QUESTION
- how can I have Excel total a column of # that were derived by form
- COMPUTING TWO COLUMNS
- Drop-Down Menus in Created Lists
- How do I create a list from a large spreadsheet without headings
- Change event fails to work
- Counting similar text
- How do I get LINEST to show all stats?
- function problem regarding cell range
- password protection
- CONCATENATING DATE AND TIME
- in excell the cell only displays formula, not the number
- Can I limit the amount of characters in a cell?
- Cell reference to current cell minus 1
- time/date calculation
- how do you have rows automatically insert in excel?
- How do I calculate pro-rata formulas?
- VLookup function to search an entire workbook
- using sumproduct on subtotals meeting certain conditions
- RE: CONCATENATING DATE AND TIME
- RANK Funciton
- Count number of different entries?
- Date/Time Question
- This is so silly...
- RE: CONCATENATING DATE AND TIME
- Should have ability to right click to accept autosum, not Enter.
- Multiple SUMIF Criteria
- Inserting Copied Row To Always Insert Above Sub Total
- Select random cell
- Warning! Time has expired....
- Conditional Formatting
- Delete rows listed less than 8 times???
- max and lookup
- Blank Printouts and Print Preview
- How can you convert the false/true into 1/0 in Excel?
- Formula is entering a default time when it comes across an empty cell..
- Sub-Totaling
- how do i add every fifth row in a spreadsheet?
- No Excel Function Wizard on Mac-Office 2004?
- add page number to entire workseet
- IF/AND/OR/DATEIF Issue...sorry...long post...
- Dynamic range - is there a better way?...
- Excel should have multiple window splits .
- templates
- the answer to appear in more than one cell
- Referencing cell in another sheet yields null?
- Footage to seconds (# to mm:ss).
- LOOKUP function
- Function for interest rate over several years
- Transpose rows to columns w/varying numbers of lines per record
- How do I change hexadecimal number to binary in excel
- trend for polynomial curve fitting by regressing
- Search for instances of X in a sheet
- comparing many cols of data to one col
- Dissappearing formula
- Excel find the content of cell using row and column header
- How do I sum percentages calculated from IF statements?
- i need info from the top workbook to be read in multiple workbooks
- "s Appear in files saved as Text (MS-Dos)
- how to create a conditional formula for a range of cells?
- Borders Functionailty
- include INDIRECT function into SUMPRODUCT formula
- Seting up an Indirect Formula
- skipping every second cell
- Substitute ,replace and delete in a cell.
- How do I have a data table display cell names rather than values?
- Excel
- How to change reference to other worksheet by changing one cell?
- Macro?
- Concatenation in a CountIf
- shortcut for merging selected cells would be nice.
- Excel data base
- ... I would like to apply more than 3 conditional formats ...
- Expanding data
- editing spreadsheet
- Showing the contents of a cell based on another cell
- How do I turn off the solver results dialog box
- How do I select & use contents of first non-blank cell in row?
- hyperlink to files
- Taking data from another worksheet and converting
- is it possible to make a spreadsheet display '0' when negative
- function problem
- Value error
- populate data valadation list by criteria
- using the same function to convert a column of numbers
- formula to look up in an application
- Creating Combinations
- Nested IF's with Rank Problem
- New Auto Selecting Cell Question
- LOOKUP
- How do I convert time (38:30) to decimal (38.5) format?
- how to apply one function to an entire column of numbers
- Excel multiline formulas
- Can I create a random order within a series of numbers in Excel?
- Conditional Formatting
- Weighted avg of numbers not in contiguous row-ie array w lookup?
- Is there a function to auto-sort 2 columns?
- Using Two Worksheets To Capature Data
- strange error calculations provides errors until i add any new one
- Another #N/A Result question...Sorry
- 2nd attempt ~ complicated formula
- How can I generate correlated standard normals?
- If Function
- How do I set up an IF function with text and numbers?
- SUMIF function question
- Protected sheets
- Access data base is able to store any number of records
- macro button in all my workbooks
- Help matching entries in two sheets???
- sum
- How do I change my cell reference columns from number to alphabet?
- How can I change dafault color in excel from black to another?
- How do you count data that matches more than one condition?
- Using excel 2003 cannot see Canadian Postal Codes
- Copied nubers is not possible to add
- SSN Format not showing
- excel 2003
- Get tab name formula
- How to I get a warning message box
- Help with Date Functions
- Renaming and saving workbooks but macro still deletes
- How do I clear data values wthout losing the formulas?
- how can you copy cells from one book to a shared file
- Counting the days worked in a month by employee
- Using Autofilter with Protection on
- Can't make Excel "if" Formula work
- How to copy 98-97 excel macros to excel 2000 (XP)
- vlookup, multiple values, sum values into one cell??
- western australian payroll templates
- Worksheet tabs in a Macro
- STRING functions
- What function can I use
- Need a Formula for DATES
- two cases for countif
- assigning rows
- Consolidating data??
- Function IN VBA
- how to automatically convert a number to words in Excel
- Help with schedule layout
- Worksheet Names
- How to display weeknumber with year code
- Excel Crashes
- Autofilter stops responding
- How to AUTO SORT A-Z new data in a column (not menual sorting)
- keep active sheet view and cursor position
- Can someone give me a hand with this formula please?
- Re: Excel macro
- How can I add data analysis function in tool?
- can we round time in excel
- Vlookup doesn't work until i edit(but not change) the lookup cell
- Statistical help file
- Average with a 0 in the equation
- Count and Sum cells with certain format (e.g. color)
- Need help creating a formula to summarize data!
- dynamic summed range based on a variable
- Detecting when a user deletes a row
- lookup tables
- Is it possible to insert a macro command in an "IF" function?
- Formula Help
- Autofilter with Subtotal Sumif
- How to Count Rows with defined values in multiple columns
- extract name when a date in another cell gets near
- Re: splitting names can't see whats going wrong (Save My Sanity )
- splitting names can't see whats going wrong (Save My Sanity )
- Can an Excel Spreadsheet automatically sort new data?
- how do I use if formula using dates?
- Time Sheet frustrations
- Calendar - vlookup based on dates
- How can I display a "sliding" range?
- Worksheet name in function
- Excel columns do not add correctly.
- Comparing Lists
- IF statement containing OR
- Searching for a particlar value and matching to a name..
- Delete Formula
- Can you create a formula to add 1 to the # you enter
- Protect Workbook vs Worksheet??
- Logon Screen
- Drop-down boxs
- Calc Diff Between Two Julian Date
- Protected sheets and cells
- Help w/ counting multiple columns based on IF criteria
- Complicated counting of cells (based on other cells contents)
- Multiple IF
- Change text within multiple functions
- How many IF are authorized?
- Text moving
- Counting te days worked in a month
- Need to derive combinations for 4 elements each with 3 possible va
- Non-Blank Cells: Conditional Counting
- How to generate a list of randomly selected numbers within a range
- counting text
- Consolidate Woorksheets
- Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
- rows that need deleting
- Formula which splits principal & interest pmts on P&I Loan
- VLOOKUP Problem (limitation)?
- "Rows to repeat at top" option under page setup
- {=AVERAGE(IF((C3:C325<M4), C3:C325))}
- CHK file in excel link files
- import external data too many rows for one worksheet
- HELP ME PLEASE
- Columns with "zero" width
- How do I lookup a corresponding value in another table
- Complicated IF Formula
- Formula Help
- Re: Combobox to fit the size of a cell
- need a function to calculate a mortgage payment
- conditional subtotal counting
- RE: need a function to calculate a mortgage payment
- Conditional Equations in Excel
- pricing problems
- Look up a list of prices
- Counting Age
- counting 0 in a row
- Need cells to show as zero or empty
- How do I merge 2 excel spreadsheets containing some common info?
- How to add auto remender in worksheet
- conditioning
- Conditionally Fill a sheet row if cell value in another sheet >0
- Vlookup worksheet function
- I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
- Average, IF
- How to Append the Data to the Master Table
- event macros - xl 2003
- Merging Text Help
- How can I use the same validation for an entire column?
- Why have my Excel Macro Shortcuts stopped working?
- In 2 Excel worksheets, I am trying to eliminate duplicate entries
- E-mail sent for a cell in a sheet that lists a birthday as today
- want sumif function's range to evaluate 2 columns
- range of cells from + to -
- Creating a league table based on results
- mortgage calculator formula
- How to make data in one workbook appear automatically In another
- MATCH Limitation?
- Dynamic Average
- Finding Bad Web Queries
- Setting up a fiile/template to generate a new number when opened?
- Bessel function/directivity function
- Percentages
- change the colour of text in cell for minus figure
- Lock row in Excel
- New Menus - attaching but menus are reset
- Auto Selecting Cells
- Problem sorting cells containing hyperlinks
- HELP on COUNTIF
- How to add date format into if statement?
- how do i sort by numerical prefix ? 1423 would come before 850
- Workingday Calculations
- how to lookup a value and return multiple corresponding values
- Data from one sheet to another
- How to highlight a row containing specific phrase?
- How to return a value Referring to the other cell.
- I need to combine 30 columns into 1 or 2
- After adding Analysis Tool Pack, still no PRICE function, why?
- linking columns
- Reference Formulas
- Finding Min Cell values excluding zero in alternate columns
- YEAR and MONTH confusion
- RE: Finding Min Cell values excluding zero in alternate columns
- how can I fix a #value! error?
- Some rows sort incorrectly in Excel. How do I correct the problem.
- excel input 0 when cell blank or deleted by key or spacebar
- Converting functions into numbers
- don't allow users to assign the cntrl+s as a short cut for macro
- IRR Guess Problem
- column and row headings
- Function to return last entry in a column series?
- Formula writing problem
- Hide text in shaded cell
- unable to open file
- question about SUMPRODUCT
- Conditional Protection of Cells
- Beyond Conditional Formatting...
- Conditional Formatting
- Cell reference in diff worksheets
- NETWORKDAYS question
- right function on pasted link
- subtotal
- separate worksheet into multiple worksheets by grouping
- Hyperlink Formula to call up browser
- problem using "<=" with SUMPRODUCT - PLEASE HELP
- adding rows of hours and minutes to get a total
- Excel puts a 0 at the end of my number
- Confused beginner
- Using MAX to reference a row
- Find a "9" within a range using a function (T/F)
- sumproduct based on format
- Getting Excel to Calculate All Combinations of a Set of Data?
- The conditional format function
- Sumif
- Today() & Now() function
- how to do a spread sheet
- I am trying to set up a spread sheet to enter some real estate dat
- Converting numbers to text
- Replace on a password protected sheet
- how to calculate commissions
- Excel: custom header - is it possible to paste into header?
- How to calculate the RATE in annuity?
- How do I count a named range for a specific word or acronym?
- Conditional Format (month and year) = Today()
- how to change a color of cell 2a to blue if 2b contains a value?
- linking sheets
- Array formula help please
- How to blank a cell with a formula
- Average given criteria, HELP!
- Creating a list in sequential order
- How do I get my worksheets to print in the right order?
- How do you Stop Entering Duplicate Data in a Column?
- How can I include bmp file in excel 2000 header?
- Pulling in the path to a filename
- Ordering fields formatted YYYY Mth in a Pivot
- date format
- Excel Holiday Roster Calender
- Range used in a macro needs to be variable
- How can I correct this Time formula
- Link A Cell In O ne Workbook To A Formula In Another Workbook
- excel formula to enter "0" if cell blank
- Count cells with strikethrough font?
- Excel formula that sums if meets two requirements.
- Mathematical explanations/equations for Excel functions in "Help"
- How to add an ActiveX control in Excel?
- RSQ function gives incorrect result
- Want #VALUE! to show as blank cell
- simple MAX + comparison formula
- could someone help!
- Number of hours worked between 18:00 and 06:00
- drop down box
- Is there a pull down Box to alert for minus balance such as ($5.00
- create reference formula that looks through all sheets for matchin
- Comparing and Merging data
- Limiting the range of a lookup function
- =if(and(....
- Referring to Cells in a forumula using a function
- how can I get the name of the active worksheet?
- PLEASE HELP
- isolating different aspects of worksheets...as objects? through section breaks?
- excel spreadsheet into address labels
- overcoming nested IF limitations...with VBA?
- Add a unique formula
- create a list of single values from multiple values
- IF formula works one way and not the other
- Dates in Excel
- How do I display colour on my EXCEL spreadsheet?
- macro for new sheets
- external import of multiple worksheet data & create pivot table
- Links only update when external workbook is open
- Help with IF Statement
- Is there any "autonumber" in Excel?
- Update one spreadsheet and reflect on another
- what is the maximum number of vlookups in a given workbook that E.
- How do you link 2 drop-down menus?
- How can I using Excel custom document properties in the header?
- Income Tax Payable from table with escalating marginal percentage rates.
- Has anyone successfully used NETWORKDAYS with arrays?
- IF Function
- matching the column b(sku)c(count)with A
- how to format Doe,John to Doe, John (space after a comma)
- checkbox?
- Can I set up a sort by clicking on table a heading
- VBA Code To have a macro repeat on all sheets in a workbook
- Locking linked cells
- Counting the number of times a specific character appears in a cell
- "IF" function - 7 nested limit
- Printing in Excel2000?
- Time stamp that does NOT update
- Finding a value within two rows
- Adding a column that used X's
- significant digits for decimals
- How do I fill the upper or lower half of a cell with color?
- Eliminating blank cells in a list on a ROW
- How copy Excel macros from Excel XP (or before) to Excel 2003?
- search all tabs for tab name specified & lookup reference?
- how do I include advance payments in the PMT function
- How do you create an Excel Gantt chart with double bar per line item ?
- countif function
- how can i do a (fx) visible in a cell
- Navagating issue
- Locked & protected cells still can be changed
- Reflecting info between an excel file and a word one or two excel file.
- Payroll analysis
- Using VLOOKUP across multiple files
- Countif using Wildcard * and number 1
- Multi column Drop-down tables.
- Calculate Total Sales from a Database
- listing and selecting data
- Hide 0% figures in Pivot Table
- Editing Repeated Text
- Moving a sheet from one work book to another?
- Moving week numbers
- Charting
- How do I read a file name into =[BookA.xls]Sheet1!$a$1?
- useform autosize to fullscreen problem
- Just a test message to be deleted
- Convert mins:secs to seconds only
- following a hyperlink
- multiple hits in random sequences
- formula cut and paste
- Sorting imported .txt data in Excel
- dividing columns
- Unusual data format
- Complicated conditional formatting if numbers match across a data set..How?
- formula that calc the diff in time, with a less than function?
- Formula to predict a future date
- help with vlookup across multiple worksheets
- formula to calculate future date from date in cell plus days
- Split data in column
- How do I write a formula in Excel
- Vlookup based on designated occurrence of value
- Conditional format combined with functions
- Compare worksheets and generate list of missing data?
- Why doesn't my resized worksheet have a minimize or close box in .
- SUMIF With Multiple Criteria
- How do I always insert last cell from a increasing array ?
- How do I hide #N/A, ### in cells not yet worked on?
- trying to archive need suggestions
- Translating an IF formula from Lotus 1-2-3 to Excel
- hide sheets use data
- Can I retrieve a value and its format using the minimum function?
- Text to Number
- why does this appear when i hit the = sign : =[ or[=
- How can the count of filtered records always display?
- Cell Validation
- subtotal a range of cells on a different worksheet
- Formula Constant
- Copy data to another column Macros
- can't find custom function code
- convert excel spreadsheet to a calendar?
- edate function
- Extract Fractional Numbers as Numbers NOT Date
- IF Statement Help please
- Getting corresponding test value to a MIN function
- sort worksheet without affecting workbook
- Convert weeknr to a date
- Extrapolate numeric values from text string
- len function
- Is there a formula in Excel to calculate a loan amount?
- Sumproduct
- double lookup
- excel formulas not copying
- Creating a Web Query
- Excel XP - Printing multiple worksheet in a workbook
- Random Date Generation
- Size of a Worksheet
- how do I print address labels from an Excel Spreadsheet
- Formula for a time card
- Currency button
- Conditional Formatting
- Text displays as ### in a cell.
- Extract Numbers from Alpha-Numeric String
- Interpolation
- Data Validation or Conditional Format (or combo of)
- Changing a Formula in Conditional Formatting
- Blanking out a field
- Calculating Cells n% displayed in a cell?
- Estimating costs
- multiplying with excell
- Formatting Question
- Using a cell value for row in R1C1
- 2003 compatibility with earlier versions
- Excel-links in worksheet shows #Ref
- Need to Sum Mon-Sat each seven days; Average Sunday
- Distribution of reporter cells according to a specified column
- Returning one text value in a long list?
- Why does / key act like Alt+F and highlight file menu not type /
- how to let the userform autosize depending on the screen resolution
- color the interior of a range
- embeding a picture into a cell
- Range Lookup in VLookup ?'s
- Hourly rates
- numbers to time
- function
- Excel should let me change the form data arrange direction
- Activex Text Box Protection
- deducting the same percent in a column
- how to I make an excel spreadsheet into a label format?
- formula or macro
- Convert Text to Number
- format combobox in userform to accept dates
- SUMPRODUCT as array formula?
- redistributing figures based on %
- Simple find with right function
- Has anyone had formulas change automatically with no explanation?
- Counting Expression in a Single formula
- excel formulas
- create formula to add 15 minutes to previous time value
- Pull and store a value on specific date in another cell
- Vlookup using text
- how do i sort a column numerically going from 01-01 to 225-99
- How do I write an 'if exist" statement
- toclearasell
- j2thea
- I need a " IF THIS THEN _" formula
- Yup - another question!
- Mortgage Calculation Question/s
- Function or Formula
- Formatting data within an equation
- formula to differenciate whether a cell contains a funtion or numb
- Lookup Value between 2 ranges
- how to fourth root a number on excel
- Find a "date" in a column of dates in Excel 2000
- # of Worksheets
- Historical Quotes
- Can excel take content from another cell and add information either side??
- Need Help with Replace Function
- Week ending
- sumproduct
- Vlookup returning Hyperlinks
- Setting to Keep a Spreadsheet in Front Window
- How do I auto fit when the cells are merged together?
- index / match ?
- blank cells with auto fill in excel
- Hyperlinks change path on save in Excel 2003
- UK Postcode formula
- Countif with star operator in criteria
- Uge nummer
- anova post-hoc analysis: tukey test
- How do I connect 2 Excel Sheets to give auto answer on the 3rd
- Showing Mininum $ for items
- adding color to cells based on a formula
- large / sumproduct combo
- Can Excel calculate the effect of extra principal on loans?
- Combining sheets on one
- blank values
- Loading Office 2003 Service Pack 2 conflicts with Excel Subtotal
- Goodness of fit function
- If True Concatenation
- Progressive Calculation
- Excel worksheets
- How to create a combination chart?
- Custom export with multiple rows for each row in original spreadsh
- Cut command
- How do I ignore cells with errors when calculating an average?
- update multiple worksheet in single book
- Sum YTD Budget
- Can I apply Cond. Formatting to a Formula result?
- Max and MIN question
- RE: Max and MIN question
- RE: Max and MIN question
- linking cells
- 12 digit code sorting
- IF text statements
- DIAS.LAB function poblem
- Text to columns delimited by carriage return
- How do I set up a notification for expired items in Excel?
- formula returns error in version 2003 only
- Begins with as criteria in function
- Indirect in combination with ROW
- Radio Buttons
- Monthly Totals
- Commission Calculation
- Data Validation List Length
- How do I display the user details in a XLS sheet?
- Permanant button for macro
- understanding dash dash in a excel formula
- Conditional formatting depending a range of cell
- Templates in Spanish
- Sum box at bottom toolbar of Excel
- GO TO
- substract cell F from cell H and total into cell I
- different tables
- Date Format
- Test
- How to extract the data
- I have several old WQ! files - how can I open them in Excel?
- How to merge one cell from many workbooks to one cell on one work
- valid formula doesn't work in 2003 version
- How do I set a rule to add a number, but only if it is positive?
- IF Formul
- Conditional Formatting - Can I select a select with Conditional Formatting?
- Moving cells
- How do I show number of resources by hour in excel?
- Separating names
- Extracting specific data from a cell
- I dont think there is a formula to do this
- how do I prevent a RAND number from changing
- link between sheets get messed when master sheet is sorted
- sorting master sheet messes up cells in other sheets linked to it
- sorting master sheet messes up cells in other sheets linked to it
- how would you do A40-20 = aA20, the value 20 is in another cell
- Multiple IF functions
- Chart Help Needed
- list generating
- PV of uneven stream of cash flows
- if function constains date
- calculating data
- Help with PV calculations
- How do I write a formula in excel that calculates payroll?
- Headers getting lost in multiple sort
- Formulas and/or formating
- Opened Autosave but when closing workbook Autosave closes itself
- Calculating the number of cells containing dates within the last m
- COUNT.IF, how to include single cells
- simple find
- how to calulate time in hours cbetween two different dates?
- How to Specify a range using another cell vale instead of row number
- Preventing Duplication
- Display row number of the last value in a column
- Is there an Excel function to shade cells?
- how do i stop excel from changing a dash to a zero in a cell?
- How to LOOKUP the last value in a column on another worksheet?
- IF(<criterion across sheets>,1,0)?
- Formula help for complex formatting.
- Return Numerical Label for LAST value Subtracted to reach Sum Target Value
- duplex print after each total page only
- duplex print after each total page only
- rows 1-2 missing from excel worksheet
- OWC - Saving An WorkSheet As Web Page
- Copying & pasting formulas
- book selection when using move or copy tab in excel
- hours to fractions
- deleting values in a worksheet without deleting the formulas
- Lookup Problem
- Need know what are valid SUMPRODUCTS arguments and functions
- Sharing and Solver
- Real RATE of return using =RATE illusive, inflation adjusted inflo
- I Need a formula to evaluate a cell with + or - values
- bibliography cards for research paper
- SUM OF GROUPS
- Need help with this function
- Using CountIf with criteria on another sheet
- Selecting Worksheet by it's value originally given
- Using CountIf with criteria on another sheet?
- Absoulte referencing between worksheets
- Strip text before character
- Choices for User
- Get cell value with multiple criteria lookup
- Worksheet IF Functions
- How do you assign clip art to a cell?
- Need No Blanks List based on two conditions
- Project Management Schedule
- How can I cross reference 2 excel docs to look for duplicate info
- How can I Lookup and sum payments for cash flow forecast?
- Excel Cell Format - 2
- In the worksheet_change event, how do I determine what occured?
- MS Excel Cell Formatting
- IF with OR Question
- Looku values
- looking for ideas for calendar in sheet with separate months
- when i delete a row in one worksheet, how do i...
- Lookup help!!
- trouble with documents after upgrade
- How do I replace a return value of #N/A in a vlookup with zero?
- Nested Vlookup or alternative?
- Alphabetically reorder a text string with multiple words
- How to get the values using a condition refering to the other column
- Alphabetically reorder a text string with multiple words
- 2 or more lookup values
- Multiple Criteria
- How to convert numeric value to mins and addimg mins to Hrs.
- Formula to give 5%rise in a figure if it occurs b/wn 2 dates
- What Formula Q
- Is it possible to combine MATCH & IF to search an excel sheet
- How can I share information between multiple sheets in Excel?
- datedif problem
- random number question
- Something like CEILING or FLOOR
- print files & subfiles fo we can organize them
- merging columns - one date, one time
- Pivot calculated field not summing correctly
- Estimating figures
- How to get a row consecutive from a sheet to another
- adding amounts according to labels
- combo boxes
- Excel 2000
- conditional search
- drop down list and row extraction
- Proper Function not working
- conditional search
- Overtime Question Unlike Others (Pictures Included)
- How do I round up fractions to the next whole number?
- Sumproduct and offset
- Sorting by Scripture
- Spinner box in Excel to adjust date
- Sum Product
- Section Breaks
- Multiple Column Index Number in VLookup
- Macro Save File (Unique file name)
- How do I delete or remove additional blank pages of a worksheet?
- I can see th formula result in the dialog box but not in the cell
- Function or VBA Help Needed
- another interesting thing...
- Freezing panes--splitting spreadsheet into quarters
- Conditional formulas: color code text populated cells?
- feel that the STANDARD DEVIATION formula on Excel is incorrect !!
- Clear Cell based on event w/o macro?
- convert time imported as text to time format for calculations
- Data Validation Error Does Not Work?
- the scroll wheel button should have an optional pan feature
- Text from one sheet cell to appear in another sheet cell
- cell format in Excel 2002 SP3 will not accept long numbers
- populating a list box with weekly dates
- how can I sort alphanumeric entries by number in excel
- 3D Count in all worksheets
- Sumif() help
- Updated cells
- IF statement using multiple criteria
- Copy complete row
- How do you enter a ratio e.g. 100:1 into a cell?
- Clear Contents Macro
- is there a macro which will allow me to copy/paste another documen
- troubleshoot absolute value
- Lookup? for more than one criteria
- Button in Excel that will save the form?
- SUMPRODUCT question
- Excel 2000
- Deleting links to other spreadsheets
- How do I multiply cell value by percentage?
- What is wrong with this formula?
- Fiancial Calendar
- How can I get Excel to find the first number in a list greater tha
- Search multiple values & return single value - seperate worksheets
- Sumif - double columns
- Unique value in a list
- Repositioning a cell based on its value
- Excel Formula Error
- My view has changed, I want same view as when opening excel
- Is there a way I can autofilter columns instead of rows
- Advanced Filters
- Remove single spaces
- Search multiple values to return single values
- HOW CAN DUPLICATES BE DELETED,NOT FILTERED?
- Match Infomation
- Joint ranking (never seen a satisfactory answer!)
- loosing test fomat after using replace command
- Summing large columns
- Difference between Cells
- Vlookup is not enough ... can OFFSET be used ?
- Conditional formating using formulas
- Across a worksheet, which cells I have formatted as locked?
- Omit the first word from a cell contain text
- text as an argument of SUM function
- How to see macro code of a password protected macro without a password?
- Average Calculation
- how do you split a cell within the same column?
- Finding constants in formulas
- zeros generated by a calculated item in pivot table
- i want to find a value in a refference array
- Cell reference problem
- Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
- how to hide the formula
- Here's an EASY one for you, not me :(
- Last value & if,then
- how do i only see subtotals in a pivot and hide the detail
- Converging two lookups? (would save me AEONS of time!)
- auto cut and paste...
- Need crosstab function in excel
- Multi-lookups on variable data
- What formula/fn would I use to count multiple condition records?
- subtraction in a list of numbers that resets with a label.
- My formula in Excel 2002 reads: =12.08*85.60 result 1034.048
- Importing CSV data into a template or?
- I'm sure this is an easy one, but....
- Formula using IF, AND and OR Arguements
- how can I get analysis toolpack for anova calculations
- look up one value and return a corresponding value using lists
- How can I sort by the value of my formula and not actual formula
- Pivot Table Fields
- Consolidating spreadsheets
- In Excel, can a function yield a drop-down list?
- How many similar functions can be put in one cell?
- find an average from a range, utilizing all data > 0
- Count multiple data by date
- how get filename with worksheet function?
- Can I copy the formatting of a cell in a IF Fucntion "VLOOKUP"?
- Repeating data in a Pivot table
- Auto sort a linked sheet
- Need a Formula
- Deleting Duplicates
- Last cell used in SUM IF formula
- shorten formula
- Status Bar Autocalculate Width
- Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA
- Can you copy multiple tabs from formulas to values w/o paste spec?
- How to have a the liist items appear at the top, not bottom
- Protected sheet to unprotected sheet
- Need to indirectly reference columns >26 using A1 notation based on numeric column number- how to?
- Data Validation and Blanks in List
- In Excel, option to enter text in cells the same as text boxes
- Advanced Date Functions
- Not sure if question is "if-then".....
- COUNTA with IF trouble...
- A simple listing desire...
- Macros/Formulas
- now()
- How to produce(move) an embedded image using a formula?
- How do I calculate IRR using monthly cash flows, not annual?
- Index and Match - the next step
- Capturing a date field once only
- Getting data from another worksheet
- moving cells
- ISNUMBER and VLOOKUP Help Needed
- DATEDIF Simple request
- How do I put in more than 7 validations in IF FORMALA in EXCEL
- how to identify
- Populate List Box
- my comments are disappearing from a shared excel workbook
- Page Number of a cell
- How do I print out selected worksheets one after the other
- Validation
- Data Validation
- Generate random numberes using reference to the other cell.
- Sumproduct #N/A! error issue
- offset? match index? sumif? 2way look-up?
- How do I multiply a unit measurement?
- Which lookup should I use?
- HOW TO EXTEND A NAMED RANGE
- conditional formating??
- Re: Problem occur in sum function while deleting the rows
- Return Range of Numerical Values in Single Column based on Frequency Percentage
- Sort Columns in Protected Worksheet, etc.
- List Box Selections
- calculation
- ranking
- URGENT need help with if/then stmt.
- How to print everything in a cell
- if function
- Excel IRR calculation
- Lookup a value using two columns
- Summing hours
- #REF!
- how to run a macro when a calculation equals a certin number
- how to run a macro when a calculation equals a certin number
- Split data from one cell to two separate cells
- Sumproduct if column begins with text
- last four digits of a social security number
- How do I sequentially number every third page of my workbook?
- REPLACE Function
- Templates
- Help! How can I get data from one sheet to another
- HELP! Nesting IF Statements/Dependent Dropdown List
- Delete Row Macro - if cell > $5000
- Combine Indirect and Sumif
- formula to transpose
- How do center headings across columns in excel
- max value
- Concatenation Problem / VBA ?
- Link To Drop Down Menu
- using =COUNTIF to count two text values
- Picking one column of info
- Newbie - Need help with zipcode format- no options for cell
- formula in excel to skip cells having - number and add only +
- filtering row data
- formula(excel) to skip cells having - number and add + one
- lookup and if?
- How can I sum every third cell in a row in Excel
- Counting unique records based on date range
- Unique records of matching pairs
- Formula
- Referencing Corresponding Values
- Intervals as logical statements
- Issues with saving text file
- Commission formula
- Multiple Criteria using countif
- Can you link an excel spreadsheet to an outlook calendar
- How do I sort the data in 8 columns by two of the columns?
- How do I show the contents of a dropdown without showing the box?
- Re: Automatic List Grab?
- Formatting Columns
- Count If
- Can I change the font/shading of a cell by moving the mouse over i
- lookup formula
- How can I type Excel numbers to show as a barcode?
- Re: Conditional formula date
- How to compare two cells for the same numbers
- CountIf
- Re: Conditional formula date
- RE: rounding off month
- Re: rounding off month
- RE: Automatic List Grab?
- multiple selections in a sumif functions
- Sorting a Concatenated Range
- If Function Help Please!
- Pivot table problem...
- is there a conflict between afxdisp.h and atlbase.h
- Use of pre-defined lists
- Lookup Array Formula
- cell address of occurence of a vlookup formula
- conditional formula in every third row and last row.
- creating formula using if function
- sum from many worksheets
- If I don't have MS equation installed in my MS excel how should I
- An array and countif based on criteria in each column
- Create a summary list without using PivotTables?
- Auto Record Transfer (2)
- I need to create an array formula combined with a countif
- Microsoft Press book - Data Analysis and Business Modeling
- Warning message on file close
- Shortcut to refresh format cells
- Excel Won't Calc?
- How to lookup row # based on content of another column's cell
- Combine contents of multiple workbooks into one worksheet
- data validation using vlookup
- Excel to COUNTIF if number greater than one but less than another
- Calculate Interest Rate when payment changes!
- Auto color-shading of rows
- Excel Timesheet template
- Macro recording problem.
- latest entry