- Summing rows based on column headings
- Formula to sum various cells based on rate factor
- copy paste formula to skip rows
- working hours
- Bob Phillips - guidance needed
- rows top-justified & bottom-justified in same sheet looks bad
- Group and Count Text Data More Efficiently
- vlookup and countif???
- ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN
- What is the formula for calculating the number of months passed?
- R^2 value in regression through Origin
- How do I do a formula to update numbers daily?
- Formula Question
- Excel - How do I remove a drop down box?
- How do I populate 2006 calendar into the attendance template.
- Return value
- UDF x worksheet functions
- Formatting based on text color
- Averages-HLOOKUP??
- Why won't Sumproduct funciton evaluate this data
- SUM function with row not known
- How to "blank" pivot table calculated fields if result = 0
- Random Numbers
- Advanced Filter contains part of a word
- How do I get a drop-down list to change other cells in Excel?
- Figuring daily average...function ???
- Need more than 2 conditions in Conditional Formatting
- Split cells below header column:
- Adding totals from numerous worksheets
- Using list of data in another worksheet
- LOOKUP FUNCTION
- Advanced Filtering by Date (or Macro) Help
- macro to insert into a formula
- How do I create autosum formula to show totals for visible data on
- Cross Reference
- Auto-Import and sort data in Excel
- ghost macro
- In an array, I need to find the row # that meets 2 criteria
- How do I calculate the statistical measure known as omega?
- conditional formulas
- Data Validation Input Message
- Open at specified page
- Worksheet functions
- excel formula auditing arrows not visible
- Pivot table problems since install of Office SP2 update
- Creating large formulas in Excel
- function with 'contain'
- Looking for Excel function
- I Can Not View Excell Sheet With Restricted Permission
- computing futures return series
- How can I type 2 effictive formula in one cell?
- logarithmic regression
- Calculate sales in the week by day ?
- Create macro
- Number to Word convertion
- i like 2006 crazy discount !!
- Referencing other workbooks
- CELL PROTECTION
- How to show only bold font ?
- min for the column contaning text
- Toolbars reset to default after a crash.
- Unable to edit formula
- Excel Question
- How do a find a second Max?
- How do I count distinct names?
- Formula help
- Save 2 separate data imports in separate worksheets on the same ex
- entering formulas in Excel
- defined cell as currency but still have to enter decimal point
- Pilot Logbook...
- COUNTIF with two criteria
- Excel to Text
- Limit of number which sin() can handle?
- using index, match on another worksheet
- Workspace & Links referenced when workspace opened.
- Copy/Paste Rows that Contain Specific Text
- Return multiple scenarios
- conditional if or filtering in pivot table
- Need help with an sum formula
- Count the number of unique records
- Have spreadsheet changes automatically highlight
- Need assistance with a formula
- Using functions for a cell with a number-range
- Lost NETWORKDAYS functionality
- from Excel look up customer information on a website
- toggling
- add-ins missing
- Missing Grand Total for a Calculated Field in a Pivot Table
- Timeclock calculations
- Worksheets
- Insrt curr file name & name of active worksheet respectively
- if statement
- combining 3 columns into useable date
- SUMIF & TRUNC question
- How do I get to the last line of a large spreadsheet to add data
- adding new rows and keeping the same formulas
- Formula to recognize text only in a cell
- count by month
- setting up columns
- I need to subtotal based on an if
- Calculate days between dates
- how to change font for all existing comments at once?
- Cell date format doesnt change
- WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES
- I want to print more than 17 lines in a merged box with 30 rows.
- Adding figures
- Validation
- Locking up the... Unlockable?
- Formula Help
- How to sort a drop-down list?
- Sum if with a list as criteria
- Complicated Problem!
- Numbers -format cells
- Using a Worksheet Form to add data to a separate worksheet databas
- How do I freeze a page tab?
- hash function for large strings
- Forced return??
- barcode in excel
- Excel User Conference - Atlantic City - April 2006
- HELP with Sormula to move data
- VLOOKUP problem
- A Lookup + 1
- need to know how to get the sum of right product returned
- Help with COUNTIF
- Extracting Dates
- Indirect
- Problem withe ABS Function
- Copy Rows to another Sheet Automatically
- textbox value to be used as a "subject" line within an email
- How do I ensure that the coments appear adjacent to the cell
- Trying to figure out an equation
- Tiered Calculation
- How can I reference a cell in datevalue?
- Autofilter
- total value of multiple products
- Please help: Extract some info. from a cell
- Changing a cell reference within a formula w/another cell
- =LOOKUP help please
- Displaying the Date #3
- How do I add 5 to amounts <25, 10 to amounts >25<100, etc?
- Distributing a Cell Value
- How do I set Checkboxes where you can only check yes or no, not bo
- assign a cell value to another cell
- Degree ,Min, Sec
- using the name of a worksheet written in a cell, inside a formula
- I need to automatically repeat cell
- How do I insert page numbers in many work sheets in excel?
- Second highest minimum in a group
- Formula for Commission
- negative times
- How do I change cell color based upon data range within the cell?
- Convert serial numbers to dates
- how do i show negative time in hours minutes
- translate function into english, anyone?
- DATES IN EXCEL
- How do I cure a "V look up problem
- Worksheet Names as a Date
- CONCATENATE
- If, then, else question.
- How to chnge 35 relative cells to 35 absolute cells at one time.
- #num Error index, match
- pivot tables
- Auto BOLD max value in a column
- '
- Conditional formatting for more than 3 variables
- Problem with Count IF Formula
- i need help with a lookup and/or array type formula
- HELP: Returning a value in an index
- How can i test a cell for bold style in a cell (Excel 2003)?
- vlookup cannot get data for some cells
- sumproduct not working
- Linked cells from ActiveX control
- Function: Ignore Mimimum and Maximum Values
- Workbook help
- mround function: is there a download for Excel 2002?
- Trying to create a range in an IF function
- Retail Price rounding help needed
- Shaded cells on a worksheet but do not show up on printed copy?
- spell checking options
- Comparing Named ranges apologies for the dodgey post below
- Custom Views
- Increasing the date/time in cells on a worksheet with a button
- command to Backup all my files
- Comparing databases and returning values
- Count formula
- Drop Down List Formatting II
- HOW DO I GIVE A CONTROL TOOLBOX CHECKBOX A VALUE IN EXCEL?
- Building the sheet name from two parts?
- Macro Password to open or access
- Countdown by Date
- Polynomial approximation
- Return entries from one named range based on the contents of another
- A huge job for the experienced
- How can I prevent users from linking to other sources in Excel?
- Using cell value to reference external worksheet?
- what function to use?
- How to view a custom view when the worksheet is protected?
- How do I maintain values in a template?
- ?set up a print range to cover multiple pages in excel
- password protect sheets
- Finding values
- How do I create a dropdown list using data from a different workbo
- One Sheet referres to many workbooks
- Excel COUNTIF Function - a range as criteria ?
- can i convert numbers to text automatically
- Data validation problem
- assign keystroke to object or button
- Can we unprotect a Excel sheet having password by Save as Option .
- Average of times where text may be in range
- Referencing Named Ranges
- Help with updating one spreadsheet off of another automatically
- RE: Help with updating one spreadsheet off of another automatically
- Variable Range
- Finding Matching Symbols in 2 Columns
- Multipul Functions
- COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL?
- excel formulas
- How do I get Arabic numbers converted to English text format?
- hyperlink that are relavant to a work book not a computer
- Calculation Question
- Calculation Qustion
- Need Formula
- How do I Increment a particular woksheet number?
- Statistical tests with 2-factor data
- How to determine the number of units based on given condition?
- How to compute the inverse of a matrix with some complex elements
- deletion of option buttons
- How do I give a checked checkbox a value in excel(as .5)?
- Problem adding a worksheet
- Worksheet Tabs Names as Dates
- Max Value
- total colum using x instesd of numbers what is the formula
- Extracting Text
- How do I create a password to unprotect cells in Excel
- how to convert whole numbers representing seconds to mm:ss
- Repeating a formula across mulitple columns
- Please help! - Possibly need a Macro?
- HELP with VLOOKUP
- Retaining data permanently from periodic changing data in workshe.
- How do I insert radio button to sum a cell when clicked
- Saving an entire workbook as a PDF using VBSCript
- Help please - Countif with multiple criteria
- Excell Headers
- is there a function that will multiply different cells
- Totaling columns of text in Excel
- Connected calculation of three cells
- How to perform the following function in Excel?
- polynomial equation
- formula?
- How do I use The "if" function
- Round up a time to the next 15 minutes
- Events per hour
- How to find a query source
- Help with leading Zeros when running Macro
- Import Comma delimited info in a Column
- Anomolous behaviour of slope function.
- how do I fix the date stamp in excel?
- RE: " invalid cell references.
- Need reference in adjacent column returned
- how to add a % to amounts in excel
- Rounding up numbers up or down.
- Opposite of Concatenate (Breaking apart a string)
- Converting Lotus function to Excel
- Need to round a formula up or down to a specific number
- Last row value to another sheet
- Running Total from previous page
- Hyperlinks: open directly in Excel?
- How do I open a calendar function for selection of date?
- spinner format control has no control tab
- Using #s in column as column #s
- Do formulas in a table translate when sorted?
- dollar amount versus Time
- Autocomplete from a list on the worksheet
- Formula Help
- Print Filter??
- custimise the "IF" formula function
- IF/then statement help.....
- Name Findout From a interval range
- combo box from data validation with source list in separate sheet
- Other Sum Question
- Please help!
- SUMIF or IF Function?
- Ratios expressed in excel? i.e. 3:7
- split text in one cell into multiple cells without breaking the wo
- How do I compare,differentiate few columns data?
- Looping between sheets picking up values on the way
- How do I prevent Crtl+End moving to a cleared cell?
- Formula Help Price Code
- WORKING OUT PERCENTAGES
- returning header row as a result...
- ANOVAs Excel 2000
- Calculation with dates
- 2 Q's. How to add X months to a date &
- Rookie at linking - need a tudor!!!
- need help w/sequential invoice number on excel worksheet
- First and Last Day of the Quarter
- counting
- Pivot Table question
- Please help - Permutations of words
- Capitalizing first word only...
- NPV - 4 values over 60yrs
- Howeractivate Excel after a macro failure
- Count # of "alt+0242" in cell
- Entire contents of cell not showing
- How recognize sheet protected?
- IsNumber & Mid function
- How do I rerank fields in table
- Need formula that Counts items matching criteria using two columns
- formula help
- Keep formual intact after deleting a line
- excel 2003 help comparing prices for lowest
- How do I seperate data in one column into multi columns
- Multiple Range Formula
- Re: How to count unique values?
- Create list of text matching criteria
- Conditional Formatting problem
- Time Calculation For A Timesheet To Include Lunch
- Query to MSN Stock Scouter
- Fill down produces correct formula but wrong answer
- Re: How can I average data from a repeating list into a unique list?
- Re: cannot shift objects off sheets
- RE: How can I average data from a repeating list into a unique list?
- If-VLookup
- How do I use the criteria "is not blank" in a SUMIF formula?
- Return an empty or blank cell value?
- How do I add leading spaces to a value?
- Sumif function, nonadjacent cells
- How do I omit hidden data from autosum calculations?
- How do I do the inverse of tan in Excel?
- Link worksheet totals to a summary worksheet in the same workbook
- Drop Down list formatting
- Using data, subtotal
- Using Conditional Formating /
- sorting range changes sum??? (excel)
- AND NOT AND OR
- Lookup and Sum
- Text Lower Case Letter
- Suggestions on formula to track powerball numbers?
- Formula Help
- extract date from string
- Strange (?) Evaluate Method Behavior
- Master Worksheet populated by other Worksheets?
- Problems with SUMIF()
- Adding two columns with vlookup
- formula help
- Need Formula
- closing & saving
- April 2006 - Excel User Conference
- Is there an Excel formula to sum color filled cells?
- Random numbers to make a known amount
- timed macro
- print macro
- Vlookup when more than one possiblity
- How to cycle through each of property and its value of Class?
- Use of IF
- Locking Cells
- Probability function
- can i get the "message pane" underneath the "threads pane" instea
- Form & Data Sheet???????
- Show the defined name of cells, help with modification of this UDF
- Worksheet consolidation help
- Problem with Sumif formula
- Displaying the Date#2
- Complex Problem
- I have clairified some info., maybe, I can be helped now .........
- Any way for 2 column vlookups. i.e match last name then match firs
- Function that determines whether a number is between two numbers
- Converting time period in hours
- Displaying the date
- Multiple search criteria to return one response
- HELP - I NEED A PLAN
- If cell value equals zero
- conditional formatting
- how can i use excel as a vehicle dispatch program
- Workbook contains links to other data sources??
- Excel 2000 Text
- Excel
- Adding new data to existing data
- Add-in Macros
- Help please - Index and Match "like" values
- How do I stack worksheet tabs on an excel spreadsheet?
- How do I set up a clumn of days, skipping weekends?
- average on column if two others have given values
- Need a Count Formula
- Color filled in auto but from where
- Sensitivity analysis
- Disable printing a spreadsheet until assinged cells have data
- How do I do this complicated macro???
- Required selection
- Date minus date=No. of days?
- Bug with Text function?
- I cannot add fill colour to any cell, or use coloured text
- Copy and paste between windows in excel 2003 will not work
- How to add the same cell on multiple spreadsheet?
- Trying to connect with Dave Braden
- More then 7 IF functions?
- How do i get time in excel to calculate time between 20:00-03:45
- Conditional Sorting
- CountIf on Date field
- Locking formulas without password protecting worksheet
- how to display the column or cell the MIN() result came from?
- OR EXACT Formula Appears to not accept Arrays
- convert "yes" and "no" to "1" and "0", respectively
- sales invoice templates
- Force function to show positive or negative number?
- How to Change List Based on Value Chosen in Another List
- GO TO LAST SHEET
- Random Name Generator
- How can I change column numbers back to column letters?
- filtering unique in multiple columns
- Timesheet Help. Rounding to the nearest 1/4
- Counting occurrences in one column based on an occurrence in anoth
- MegaFormula curiosity
- Indirect?
- Creating a Rankings Table
- match multiple criteria and highlight corresponding row in Excel
- Rounding
- Printing formulas on a worksheet
- formula converting number to column letter >26
- HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?
- how do i get a drop down pick list in a cell
- Name Lookup
- Choose function gives different results from different cells?????
- RE: HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?
- make macros usable! make instructions in plain english !!!!
- Formula Help
- Autosum refreshing
- RE: Autosum refreshing
- RE: how do i get a drop down pick list in a cell
- import .wmf->excel 03?
- How do I set up Reminders in an excel spreadsheet?
- Dynamic Labels
- Position in a string
- Comparing 2 pivot tables data using VBA
- how do i print filtered rows in Excel?
- Newby help
- Export XML
- "DAYS 360" and the date Feb 28th as start and end
- Need help on formula
- data val
- list unique values in a column
- End of a Worksheet
- How do I count data with criteria from two separate columns in exc
- Need help with "if" function in Excel
- Need help with "if" function in Excel
- How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4
- How do you add multiple spreadsheets in to one spread sheet
- Lookup Tables and Formulas
- pie symbol for math
- monthly growth rate
- how to get values from different sheet when info. matches?
- Possible to change the program Excel uses to open a hyperlinked file?
- dsum returns 0 if criteria range too large
- how do you set up an if, then formula in excel??
- Variable equations help please
- Trying to forecast the future
- I can see a worksheet, but I can't type in it or use the tool bar
- Sort Groups of Cells
- Help with a formula - probably an "IF"
- gridline the next page automatically in excel 2003
- can you link data from word to excel
- Text & Date in the same Cell???
- Web Query With Multiple Stock Symbols & Stock Scouter
- auto gridline restore after a cut and paste in excell 2003?
- Prevent Users from Selecting Cells
- Question : Workbooks or Worksheets?
- how do I add blank pages to
- formula help
- convert string to date
- index match function help me
- Sum Formula that excludes other sum formula in range
- $ vs time formula
- Pay per hour?
- Referencing subtotal numbers
- sort in excel that sorts digikey
- Is there a maximum number of constraints...
- Worksheet Formatting
- Returning a blank field
- Formula to figure ad schedules
- need formula if x<a3<y, value, else
- How do I enter like a Word document in an Excel worksheet
- Link Worksheets to a Master Sheet
- Sum on rows column wise - Strange error
- Counting Frequency of Filtered Data
- insert rows
- Conditional Formatting (IF function)
- How do I make it add a column based on 2 different criteria?
- Copying information into another workbook
- Conditional formatting, simple question...
- conditional formatting
- Can't get Excel 2003 to open a .wav via hyperlink
- Sum help this is puzzling???????????
- Conditional formatting
- sum with three criteria
- MATCH UP DATA IN COLUMNS
- Round up to nearest 10
- change loan periods in an amortization schedule
- copying word tables into excel
- copying word tables into excel
- Select sheet tabs in workbook & save to separate workbook files
- How do I correct error using the =IF(AND(formula in excel?
- Removing blank cells
- how do i Count with in the cell range value is >5 and <=15
- VLookup Question?
- calculation for bank interest chargeable
- Default a specific worksheet to be in forefront when open excel?
- fancy lookup
- VLOOKUP Limitation and Solution?
- autocomplete after 4000 entries
- Why do gridlines disappear from view when highlighted
- Calculate
- how do u set up multiple choice answer buttons/dots?
- Problem with crystalReportViewer
- showing and copying a formula in a cell
- Forecasting = loan planning or depreciation??
- Countif unique
- Microsoft request for slow-calculating workbooks
- selecting a worksheet
- Work Schedule
- incrementing mm/yy based on value in other cell
- Find a value in the table cell
- ROUND or "Precision as displayed"?
- Error message "formula is too long"
- locked out of my sheet for read only
- VLookup Help???
- how to bring an image onto a sheet
- Date Sorting
- appending and IF statement to an existing IF statement
- Hide Rows - copy and paste only rows that show
- Determine which column to use by date
- Countif Q
- Two column value match table look up
- Formula to Check Values between to variables
- Office 2003 vs. Office 97
- not copying correct value
- Stratify Data In a Range
- Help with Match Function
- how to convert csv format to separet columns in excel
- select rows
- Scoring/Ranking 2 Columns of Stock Symbols
- Extract last name and insert into a different field.
- How to display seconds on time stamp?
- Miscellaneous
- conditional formatting - Highest
- Sharing worksheet with a customer toolbar
- Why do some Excel cells refer to e-mail?
- V Look Up Function Problems
- Linking Worksheets
- Can't move between worksheets
- Lookup Problem
- Sumproduct
- forwarding cell data
- Countif????
- problem using Range Names in VLOOKUP
- I'm looking for an advertising layouts for a weight loss programs
- Sharing Violation error
- Why doesn't the DDB function work all the time?
- excel does not open up any workbook
- can you assign random numbers to many different lines of row?
- how to use cell contents as references in a formula
- Copy-Paste sheets - error in the dates
- Help With A Macro
- Creating a formula by using data in another file
- Create Lookup Table
- Excel 2002 formula displayed not value formula option not checked
- how can i multiply two columns
- consolidation of tables in excel with text and figures
- Save copy of folder with linked files
- VLOOKUP to return first hit
- Remove all formatting
- excel ?
- Formula for Excel
- Vlookup show #N/A
- Copt data with specific criteria
- Calculated Field/Item in a Pivot
- Calculated Field in A Pivot
- Cannot hide columns in Excel
- How to use if statement
- Close Dos from Vba?
- Rounding Error when adding or subtracting two cells
- AVERAGE DAYS OPEN IF BETWEEN DATES
- transferring data between 2 worksheets in same workbook
- Incrementing numbers
- Linking formulas in new sheets based on a template?
- pls help again!
- common entry reporting
- I have more than 6 conditions when using conditional formatting?
- Right click help please !
- How do I run Excel 95 macros in Excel 2003
- Drop-Down List
- dates into ages
- Complex function....not sure how if the result I want is possible
- Reference cell location
- Lookup Assistance
- Amending an existing function
- Is there a formula tutorial online ...............................
- How do I sum a range of data (column) that has #num! in some cells
- Goal Seel To get Average!?
- Using a Text Cell to Reference a Worksheet Name
- in excel worksheet, add numbers in column k2&k3
- format a drop-down box from a range of cell from another work...
- I have lost the in cell drop down in validation
- Can this be done with Domain Functions?
- Function giving a result for number within a range
- only printing certain rows
- converting julian day and year to a date?
- List info if criteria is met?
- range_lookup in lookup functions
- Hide previously used items from multiple drop lists
- How can I use numbers to define range for Max() ?
- Problems with formulas and sorting
- how can i view the range of 75% of a column
- Subtototal display is in different order than 2002, why?
- How can I make the rows go into a random order?
- look up functions
- Employees
- How do I correct error using the =IF(AND(formula in excel?
- creating macro working across multiple sheets
- hours and minutes multiplied by wage
- hours, minutes multiplied by wage
- How do I show True as a value in Excel B2 if Cell B1 is bold?
- hours multiplied by money
- information function - does cell contain reference
- Repeat Rows
- Dynamic Lists
- If Formulas
- Searching for mulitple strings and assigning identifying number
- IF function, i think??? please help.
- Sumproduct with 2 criteria
- How can i see on excel feet and inches from decimal system?
- Find Formula Problem
- sumproduct looking at multiple sheets
- How do I do a Reverse Find/Search in Excel?
- calculate number of days btw dates
- Extract the hour from a cell showing the date and time
- How do I protect multiple sheets at one time?
- List Box with macro
- How do I lock selected cells, so only I can change them?
- How do I get multiple matches when using the Vlookup function?
- copy sheet with updated dates
- assign macro
- sumproduct help
- how to use spellnumber formula
- Count Multiple Criteria
- Data validation
- Calculation on lookup
- counting if two columns contain the same numbers
- Forward looking forecast/cover help required
- ask 2 function
- Get data
- MACRO QUESTION
- How do I restore column & row cell references
- Labels
- has anybody come across this before?
- Checking Blank Cells
- Can function in one cell change value or function in another cell?
- Lookup Formula Help - PLEASE!
- Formula Help!!!
- Returning the last modified date to a cell in excel 2003
- Formatting of cells
- Is anyone on here with DVS Reporter???
- Page Break Problem
- pls help
- importing on protected sheet?
- Help with this formula please!
- Accessing the sheetname in a cell
- Calculating age.
- Looking up a value based on date and time, what's wrong?
- Formula to subtract a date from current date
- Variable criteria formula
- How to prevent copied data from appearing until triggered by anoth
- sorting with RANK/VLOOKUP (problem with equal ranks)
- Offset Function Trouble, Please Help
- Function similar to SHIFT+CTRL+DOWN KEY
- Excel references to other sheets
- Would like one cell to both count and multiply a range of cells
- Is there a better way of doing this?
- Lining Tables
- find a text - help
- Macro Question
- getpivotdata
- Counting blank cells until value is reached
- Date Range for my time sheet
- Formula question
- Help again please
- Display 10 records from same workbook but from different sheet
- How can I change the color of an "IF" function answer?
- Database
- Using VLOOKUP with abitlity to choose from multiple defined names.
- Can anyone calculate age next birthday from date field?
- Nested If statement revisited
- Information retrieval functions
- How to speed up Autofiltering?
- How can I make an excel cell equal to the value of a frame object text box
- Nest IF statement workaround
- how towrite inside margin
- cell protection based on a formula
- SUMIF
- Payroll equation for SS taxes
- Excel should automaticaly update a feild when printing ex:Version
- Need Help With Formula/Function
- How do I identify cells with matching numbers within a column.
- Macro - Return to starting cell
- Excel Euler function
- Find Matching Text In Col A move to Col B
- Htperlink in an unlocked cell but protected worksheet
- ACCTINTM problems after upgrading to Excel 2003
- How can I make an excel cell equal to the value of a text box
- Saved spreadsheet - now can't work on it - choices all greyed out
- put data from cells into other cells
- Read Only File Problems
- Counting Data
- Transforming Multiple Rows into 2 columns
- display a range of data when triggered by a specific condition
- I am use (=IF(A2=1,"90") in a few cell i need to then add them up
- LOOKUP FUNCTION
- Negative Percentage?
- auto copy only selected cells
- user form question: text box to display result
- VLOOKUP False Problem
- Multiple accessing of an excel file
- insert columns macro is putting 2 columns instead of 1
- pls help me
- How to convert VLOOPUP error value #NA to 0?
- Need macro to delete all text cells in an Excel range
- how do i use a formula count of figures between to conditions
- Data validation two criteria
- Inserting Worksheets
- lookup a value and return cells
- Help with a read only frustration.
- Run a macro automatically on workbook open
- Calculating sales commision HELP!!!!!!!
- Pivot Tables
- vlookup with two criteria
- What formula would I use?
- vlookup with two criteria
- Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet
- Nesting the SUBSTITUTE formula
- return multiple rows of data based on criteria
- Command Button protection problems????
- Number combinations
- Conditional formatting
- Can I automaticly figure "cost" and sale price in Excel?
- Returning Macro to Starting Cell
- Vlookup...
- Formula
- How can I label a worksheet based on a cell in Excel?
- Calculating monthly totals
- HELP! Making A Form
- how to combine text into a cell???
- formatting multiple worksheets
- Creating a master worksheet
- SumProduct w/WildCard
- Saving username into a cell
- linkig multiple cells in a pricesheet
- SumProduct With Multiple criteria
- Creating Array from Pivot Table
- sorting data by time and day of week
- Sorting with Multiple Rows per Entry
- Excel Checkbox can be regconized in a formula and be executed
- Formula for counting multiple variables in a spreadsheet
- sumif/if with conditions "HELP"
- links
- How do I change the default shape for comments in Excel?
- Returning Macro to Starting Cell
- how do i calculate over time per day
- Sorting List to a new sheet
- calculating the future value of an investment in excel
- autocorrect features
- Setting up a Macro
- How can I use "VLOOKUP" with cells containing both Text & Numbers?
- Added up # of cells containing a specified word
- Calculating Percentage Rent
- how do I format the sheet so that I may click on 1 cell at a time
- A function that looks for a value on a sheet on unknown column or row
- Why sometimes excel returns error just because function parameters are linked?
- Locking a Worksheet
- Worksheets/Forms
- How do I calcualte APR on Variable Rate Mortgages?
- SUMIF across worksheets
- Ensure unique solutions to random formula
- ISBLANK
- How can I prefill a text field with leading 0s?
- Counting Errors
- Difference between two months
- Worksheet name in a cell
- Conditional Formatting
- How do I set default folder for import
- Cell Formatting...
- How to show all formula's
- How to protect formula's, but allow autofilter
- How would you do a bank reconciliation in excel.
- dos from excel vba?
- =SUM(($C$1:$C$7>=--"10/01/2004")*($C$1:$C$7<=--"09/30/2005")*(H$1:
- INT((MONTH($C$1:$C$7)+2)/3)=$A$2
- lookup related with defined name
- CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT
- writing an "if then" macro
- Sum returning 0
- how do i concatenate a string and cell formula and use a comma?
- problem with replicate formula
- wts wrong with this statement
- AutoComplete not functioning correctly
- where can i find Formulas for excel 2000?
- Finding matching cell data
- Password protected? help!!
- copying multiple selections
- to make a single row record become multiple row records
- Properties of a document, help!
- Sqlrequest only return one value
- error accessing a protected worksheet
- excel vertical function
- Hitting Enter to Move Cursor to the Next Entry Cell
- Better way to do this
- Return Pay Date
- Calculation of instances a value is found in a series of cells
- Using last cell in a column that is not empty in a calculation
- Calculating an average based on 2 and 3 criteria
- Nested If Limit
- Nested if then else statement
- In excel the tabs at the bottom of the page are gone.
- dublication
- formula starts : =+ what does plus indicate?
- Adding a row to worksheet does not update cell references in another.
- indirect using name
- parsing a cell using |
- exchanging values amoung sheets
- diverting output
- Pivot Table Groups
- Concatenate
- Excel: How to choose data on two separate rows in the same column
- Large Function
- Divide a cell by 2 and then add that together
- Conditional Formatting
- Multi Level Subtotals and SP2
- add, multiply then divide
- Convert string of digits into a date
- how to turn positive to negative values in excel
- creating groups based upon correlations
- Multiple True's in IF Formula's
- Conditional formatting on overtime hours
- Copy Sheets Macro
- can you rank more than 7 items? how?
- How to Sum with two if statements
- Target Cells
- Urgent date/scheduling calc needed
- Row Expansion
- Alpha characters problem?
- I need help adding cells together?
- MESSAGE BOX ON REQUEST
- I NEED HELP WITH CONDITIONAL FORMATTING
- Sumproduct help
- If/cross referencing functions
- Adding specific cells in column
- Checkbox - Unprotect - How?
- Auto Import OR Searching TXT Data
- Help with =MOD
- Where do I enter the PROPER formula in a spreadsheet?
- count number of occurances of a word in a range
- countif more than one sheet/tab and sumproduct
- Excel color functions
- Formatting Question
- Rounding
- List date adjacent to duplicates?
- Worksheets
- Sumproduct
- Finding Duplicates
- delete some cell formulas and leave others using code
- Combine functions?
- Multiple entries in column
- Why does the Pivot table iin Excel add a 2 to my name?
- Why is my tab key not working properly any more in Excel?
- lookup/vlookup for dates, please help!
- Totaling up a column
- Format a column wihtout using "Format-Cells-Number-category-etc"
- How do I calculate formulas for yes/no data
- Make Cells Text
- Using a column of data from 1 worksheet to extract data from another worksheet
- A weekly equivalent of EOMONTH
- Calculating % when 0 is 100%
- printing to pdf file
- subtraction formula
- Formula for area conversation
- Message Box to appear Thursday midday!
- moving x column values into x row values
- macro command
- How do I display "Help" Text in my own functions
- Formatting #N/A
- What if analysis, can this be DONE??
- Can I set up a signal in Excel to let me know when my due date is.
- i need to find duplicates! ASAP
- Throwing Out top & lower percentages
- VB and Excel
- cell A1=worksheet name
- automatic offset cell location when there is a value in a selected cell.
- getting data from another spreadsheet
- IF function and combo boxes
- How can I set up a shortcut key for Autosum?
- How do I include a supporting help file for a excel function?
- too long sumif help
- More help!
- Formula creation...if possible
- Sort a list with uneven row information
- Vlookup always gives me #NA
- Complicated If Equation
- IF statements and ranges
- IF statments and ranges
- Test
- Password Protecting Sheets in Excel So Others Can't See Certain Sh
- Urgent reply would be a great help
- selecting values from raw data
- Add new button to spreadsheet to print
- Formals with IF and Then
- vlookup in if
- Hide previously used items from multiple drop lists
- subtracting time
- Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
- create a drop down list
- SUMPRODUCT help again!
- formula help
- Compare cells
- Ifs and Ands - I'm confused!
- function to reference all of pivottable data field array
- pivot table questions
- Differentiating data by year into columns
- Select all subtotal rows on Pivot Table
- my excel formulas are too long to execute find and replace
- TRIM formula
- I need a little help with comparing columns and indicating the mat
- Conditional Formatting in one column using data in two columns
- running a macro from a list
- countif question
- Help with max() fonction
- Formula's
- Can you change the function of the fill handle on a cell in Excel
- How do I could solve a equation
- Formatting Charts from Pivots
- set all column formats to Text
- Help with formula statament with a MATCH.
- How do I set up a cell for blinking due dates
- Hyperlink Help Urgent
- change sheet name macro
- Summary Worksheet from Multiple Workbooks
- disabling the copy paste function in a cell
- Creating my own user defined function help statements
- Count rows with specific attributes in VBA
- =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4
- Adding Up cells in one colum IF cell in another column is yes
- Hours multiplied by money
- Workday function including sat, excluding sun
- what if the result of a formula is text
- How do you consolidate tables contianing text?
- Excell 2000
- how do i link to a pivot table to get data dynamically
- IF X = Reverse of Y True = 1 False = 0
- INDEX then MATCH
- "300" notfound?
- Urgent help
- COLOUR
- Increasing number of columns beyond IV
- increasing a value everytime excel is opened?
- Excel 2000 worksheet is off centered for viewing
- function to add or remove
- Convert real number to an h:mm:ss display
- If 2 cols meet a criteria then sum the 3rd column
- Regression intercept to 0
- CHITEST worksheet function - bug?
- inventory cells
- shortcutkey F9
- Help with a problem have tried a number of things
- Adding dollars
- VLookup using 2 worksheets, whole column reference
- random numbers
- Cannot download exel spreadsheet file with extension type xls
- how to group records in a new worksheet
- If statements
- Removing blank cells in a column
- How do i ignore letters in a formula?
- Find value grater than X but less than Y
- Using colors outside the standard palette
- calculate average for all of data field using GETPIVOTDATA?
- Currency to Text
- If then with 2 criteria, then sum
- =If (need 2 criterias), true, false
- Return Totals from Certain Criteria
- Adding to Summed Figures
- number anagram
- Imported Data creates blank cells that aren't really blank
- How to create a histogram that updates when I filter the input ran
- Colomn of various dates, count & give % of all under 1 year, etc.
- Searching a column and returning a yes or no answer
- Need assistance: Count non-blank within date range
- Mail Merge in Excel
- function for finding repeats in a column...
- Count non-contiguous cells where value is greater than 0
- Formula to Sum Cells that Hold If Formulas
- Possible index/match problem?
- Find
- Cant figure out formula?
- updating date!