- Insert Excel hyperlink to word document
- Function THat wIll Add COntents Acorss Worksheets
- Matching and calculating 2 worksheets
- Date Question
- How to know Rank Of FieldName ??
- A letter to generat a number when entered into anywhere on the spr
- sheet line bottom of page missing
- Creating shapes from given criteria
- Code to get text from part of a cell
- generate a random number and use if function to generate new data
- macros
- Excel help (time and 1/2)
- what function best to use
- can you tell me how to embed a pic for paint into an excel cell
- Calculations Based on Format
- Why is the scroll bar way too big for my document?
- how do i link merged cells to a merged cell in another worksheet.
- writing a greater than/less than formula
- I need a formula in excel
- Option Button Help PLEASE!!
- Divide selected cells by 1000
- Copying links
- Optimal material layout
- Copy formula
- autosort
- Setting up columns based on a date
- Formatting cells in Excel does not work
- deleted work sheets - Excel
- Data depiction/transpose and retain formulas
- Help with SUMIF formula Please
- excel payments functions
- How do you divide two cells in a pivot table to equal a %?
- INDIRECT function
- How can user move in locked worksheet but not copy cell contents?
- Adding columns of times
- How can i protect...
- How do I create a Macro to sort data and insert blank rows & subto
- Excel needs to be able to cascade in multiple windows like word!
- Hide previously used items from multiple drop lists
- SUMIF((U:U,"ITEM#")AND(A:A,>4/01/06 AND <6/31/06),V:V)
- more help with min
- SUMIF Question
- i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
- show the sum of an arbitary selection of cells
- INDIRECT !@%?
- Count # days
- How do pivot table source fields automatically create tabs
- How to create a constant total column in Excel?
- Lower case
- How do I perform a concatenate?
- Convert data into proper time format
- If(and(function help)
- Random Matching
- How do I use vlookup with two lookup values?
- Average data with date and if constraints
- Excel formula?
- How to find a row since I found a value in a column? see example
- perform calculations using time arguments
- How can I create a customer database to use with an invoice?
- min function
- Finding 13 character codes in text strings
- How do I sum data in worksheet 1 to be placed in worksheet 2?
- Quickbooks exports to Excel, cleaning up the mess afterwards
- day of the week dates
- auto numbering macro
- how to locate local excel expert
- Text to value
- Problem with VLookUp Function
- making a list ?¿
- How do I write a formula to convert numbers to written text?
- Workbook protection
- convert military time to regular hours
- Counting cells if special criterias are true
- multi conditional searching
- How to combine milliseconds with date/time reference and display?
- Countif, two criterias need help
- vlookup in excel have alternative result than #N/A selectable
- Use Vlookup to find less than today
- VLOOKUP? Or another function?
- Hyperlink
- Filter function
- Data and the "IF" formula
- logical test, array, text and numbers
- Summing all BUT one...
- what is the formula to convert time (3:46) to total seconds?
- Formula help needed
- How do I apply color in cells ..color now shown only in print prev
- HOW TO CREATE DIFFERENT GROUP AND OUTLINE IN EXCEL
- struggling with index/match
- What does ! do in an Excel formula
- if then /lookup function
- Sorting a Worksheet using Capital letters
- 'null reference' when trying to use WorksheetFunction from C#
- SUMPRODUCT vs. COUNTIF -- Why does one work?
- Can excel alphabetize a list of names?
- Number of character in one cell.
- Hyperlinks
- Formula HELP!!
- "IF,THEN, DO) any help
- Taking age group Ie ages 20-29 and picking out net sales for group
- Excel "mode" function returns different results based on sort orde
- And,if,true Help
- Arrangement problems.
- what happened to =networkdays(a1,a2) in office 2003?
- Filtered Cell Question
- Formula for % of "yes" in range of cells?
- Count Non-Blank Rows
- best and worst outcomes
- Formula question
- Formula help!!
- Vlookup Function Arguments are correct but nothing in cell
- CountIF columnH2-H101 the number of time between ages 20-29 occurs
- Excel and Word
- Need how-to or example for data consolidation
- Data Validation - Drop Down
- weeknum for month
- Comparing against first non-blank cell
- Why does formula show rather than results (not in text format)
- Correct Format for formula
- Formula Will Not Evaluate
- 1st Monday of a month in date range??
- Moving from unlocked cells to unlocked cells in an excel form
- How My If Or Statements
- Numbers of boxes of fruit to buy
- keeping a running time for tv program
- If/Then Forumla to create blank cell???
- Multiple If/Or Statements
- creating checkboxes from forms tool bar
- Variable worksheet name
- ranking over a sum
- Format a cell to recognize data and change font colors accordingly
- how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
- Vlookup "Value Not Available" (#N/A) Error
- Another zero question
- Fillable form loses fillable fields when emailed - how do I fix
- How can I use spell checking in a protected worksheet?
- Excel Workbook Problem
- SumIf Help
- VLookup across Workbooks?
- How do I print a filename at the end of the file (not every page)
- How do I add (=Sum) the same cell for multiple sheets (103)
- Use VLookup for range of cells, but with a twist
- replace "." with "/"
- Analyze with Excel from Access
- Round near to Zero
- Remove content of last visited pages in "Insert Hyperlink" dialog
- Querying 2 Excel files
- Create a conditional formula to replace
- Displaying pivot table detail
- to compare sales plan vs actuals from two different worksheets?
- Index? Match? Function to sort and return value fr diff column in
- Trendline
- HOW TO PREPARE SUMMARY OF DIFFERENT ITEMS IN ANOTHER WORKSHEET?
- Speed up calculation of a worksheet that contains formula
- Combining Pivot Table Source Data
- Last non-blank cell in a row?
- How to use a very big formula
- Excel - filtering, sorting?
- Need difference between two dates/times in hours
- how can i recover an old saved spreadsheet
- counting problems
- Normal Text in Formula
- Timesheet
- Excel sheet scroll bar options
- need formula advice
- Do I need a macro or just a function?
- Change font/cell color by Formula
- Removing The N/A from showing in open fields
- Splitting firstName from Surname
- Excel Coding Error!
- lookup value and return result in column to left
- Conditional Formatting
- I want data to show in the cell only when the info is inserted
- Formula to look for value in a row depending on unknown value?
- How do I get a combo box to calculate percentages in Excel?
- retrieving old messages from this newsgroup
- Invalid Formula with the use of Indirect
- Transfer data relevent to date
- Transfer only information under todays date
- Fill in Date problem
- Formula not Return Required Answer Q
- Take fraction out of the figure
- Chop off parts of the statement
- inserting a space in a number
- Transferring contents and color of cell
- shortcut key to move to beginning of new row
- Dont include in sum if cell contains this value
- Oooh, I guarantee you are going to have fun with this one.
- Insert new row in 2 worksheets
- Auto Filter with Protected Worksheet
- I want any date 90 days or older from current date change color
- copy value of cell from last entry in column
- Simultaneously updating Charts in Multiple sheets
- Deriving mathematical equations
- can we convert "2 days 16 hrs" to " 64hrs" using excel functions
- merge 2 spreadsheets info to 1
- Change hrs&minutes into mins
- Add items to context menu
- Dialog box with worksheet information
- Zero Values in Charts
- Using the answer IF "true" in another formula?
- Conditional Formatting Q
- Auto calculate for date + days forward to yield new date
- If function
- sumproduct doesn't work
- referring entire page
- rolling average
- engineering functions
- How do I copy only values of cells when they are enterd?
- Inserting new rows
- how can I add a picture into protected worksheet?
- Could any one Explain this Formula
- How to create a 'dynamic' formula?
- FIFA World Cup 2006 Office Pool
- VLOOKUP Returns Erroneous Value When Control Data is Variable
- Multi-Column Dynamic Named Range...Is there an easier way?
- Selectively Clearing cell contents
- can i prevent duplications in cells
- How to extract value from a different file?
- When I SaveAs, the hour glass does not go away, nothing happens
- Please Help...
- if function
- if function
- How do I create a tip calculator chart?
- calculation to ignore a 0 (zero) value
- how do i get excel on my loptop
- Need a count
- sumif across multiple sheets
- Copyin text only...not borders or shading
- Data Query will not Refresh automatically
- Uppercase
- same data from one cell copy to multiple sheets
- Average outage time?
- Cost times amount (if populated)
- Tricky comparing question
- how do i retrieve overwritten Excel file
- can you use the match formula to look for two different values?
- how many calculations?
- Excel Data not showing up in Query
- filtering
- Fuction that gives number of days of a given month
- Unable to break links
- Another "working with dates ?"
- Lookup and List Results
- Countif Problem
- Can I use the IF Function?
- INDIRECT Function
- problems with vlookup
- thin # of samples by averaging
- Sumif between values
- How do I convert a list of data into mailing labels?
- If Sum Countif Function
- Working with dates
- conditional sum formula
- Years of Service Calculation
- Semi Annual Counter
- Need help find automate way to cross reference two GAINT excel databases!!
- hyperlink to sheet in formula, can't save under new filename
- Please help with a 3d formula.
- Anyone actually get Case statement to work ... ?
- List from a table
- how do you add up alpha???
- how do i enter a formula in excel that will change a cell value
- Pivot Table Row ?Grouping? Question
- Can someone help with this complex formula?
- Count items when specific text and date criteria are met
- DFunction + Print Preview = Slowdown ???
- Criteria Range at two different places
- Spreadsheet formula question!
- How would i setup a breakdown method for my business?
- Comments box position
- automatically making a copy of a sheet
- automatically making a copy of a sheet
- Monthly NPV
- Macros?
- funtion to determine the fraction portion of a number?
- How to stop a general format cell
- WEEKDAY Function?
- Suggestion to add Auto Filter option for columns
- How do I create a formula where a cell is automatically shaded ?
- transposing an array converts dates into numbers
- Excel formula to move certain fields
- Edit and Array
- Calculations
- Excel Tips
- IF statement problem
- Pivot needs BOTH cur/cum totals w/out extra cum cols/repeat lines
- > but < subtotal (3,...) or countif
- passing excel certification
- How do I stop VLOOKUP from asking what spreadsheet to look in?
- Counting text strings
- Importing information from 2 workbooks into a 3rd one
- Letters and Number formulas
- Pivot Table Formatting
- Worksheet button to send as attachment
- Index not Reurn the correct Result
- how to create a sorted summary list of counted species
- Insert a imge to a single cell
- Formula for determining if two date columns fall within specific date range
- Multiple worksheets within a workbook
- Template Wizard/Excel as database
- How do I format a formula to recognize multiple comparison factors
- Help for a newbie... please
- Median Formula In Pivot Table
- Summing specific cells on two worksheets
- Average Non-Adjacent Cells in Budget Spreadsheet
- Re: Average Non-Adjacent Cells in Budget Spreadsheet
- In Excel - how to delete new window created from window on tool ba
- Vlookup and hyperlinks
- how do I display number in thousands; i.e diplay 123,500 as 124?
- Function - counting based on criteria
- Msgbox experts please reply..
- how can you put a background in certain cells
- Data transfer from a template to a workbook
- If function
- Change fmt of a cell if number matches any in a range of cells?
- vlookup with linked cell references
- vlookup
- Want to change current prices in a column by a percentage
- number rounding
- If, then formula to capture data?
- write a "if" command. day of month + remainder
- Conditionsl Formatting
- What function/formula should I use?
- Issues copying excel charts to word documents - using Excel VBA
- What
- How do I stop cell borders dissappearing when pasting data?
- Is this possible with a macro?
- Combine Cells
- Combining IF OR and AND functions
- Lookup a value between two numbers
- workbook code
- how do i create form of yes/no answers for mass e-mail sending
- time data as number
- Deleting Row Macro
- VLookUp function to return multiple rows
- Circular:G4?
- Setting Conditional Formatting
- Counting unique values with criteria
- how do i get the equal sign on my formula bar in excel
- How to find duplicate data in two tables,then listing it?
- Disabling an 'on load' macro
- Value depends on comination of 2 columns
- How to find duplicate data in two tables,then listing it?(Excel)
- Expanding on a formula
- linking data to a form
- How to set a formula to convert the time zone
- How do I open worksheets in different screens, like Word??
- Referencing sheet1 from sheet2
- vlookup function addressing
- AutoFilter list problem
- Validation Data
- option buttons
- Check 2 different list get associated value from a column
- Summarizing data on one main sheet
- Automatic filtering and coping result to a seperate sheet
- How to create menu for listed names?
- What does the 0 in the formula 'Yr 3 Op'!G2,0 mean?
- link with date to data worksheet
- Countif time is between two nominated times
- Combining worksheets on a unique key column
- How do you add a blank line automatically after the Subtotal line
- Inoperative merge function
- Merge Rows depending on value of the first column
- Is there a macro or function to convert values to it written text
- Why doesn't this nested IF statement work?
- How do I sum totals from mulitple worksheets
- can someone explain function 'ara'?
- check boxes in the forms tool bar
- Hiding sheet in a workbook
- excel storing previous cell values in memory
- How can I subtotal a row that gives me =SUM(Q3:X3)
- Using FIND function to locate space between first and last name
- Data alchemy
- "NOW" or "TODAY" date function
- VLookup?????
- How can you sort a worksheet which has embedded lists?
- IF function
- SUM a named range
- True or false
- Fractional Workday Function
- Drop down lists and vlookup? or Match?
- How do I combine data from several sheets into one main sheet?
- conditional formatting issue
- Need Excel Formula/Function to color cell interior
- Excel: Find repeated items and be able to delete quickly, option.
- Calculating Dates Using Different Values for NETWORKDAYS
- Vlookup while pulling a cell color and comment
- Multiple Vlookups & IF statments
- find nearest help
- SumIf
- How to trim spaces from entered text in cell using exisiting functions?
- lookup function
- Excel
- automatic calculations
- school project ..please help
- EXcel Capture Data into one cell
- school project ..please help
- how do I compare two dates?
- Sort
- How do I exchange cell information; simply swap locations?
- How do I count cells that contain one of several specific numbers?
- Excel functions which support arrays (SHIFT-CNTRL-ENTER)?
- lookup function
- How do I format a cell so that I can only input a Y or an N
- bring up list
- cond format
- Workbooks
- LIST DATES IN MONTH ORDER
- how do i lookup the value of the next cell excluding the first lookedupresult
- Keeping formulas on running total and sorts
- Use MOD?
- Copy Row based on a condition
- Sum and Divide Formula error
- countif non blank cells + dates overdue
- comments issue
- Where's the plain old database functionality?
- Column picked randomly with probability relative to number of entr
- saved worksheet opens in new with macro error report
- VBA
- minus sign
- Concatenate two columns?
- Update Spreadsheets
- Custom functions calculating time arguments Help Desperate
- i have two days and i want the difference in days, months, year
- Need help setting up a spreadsheet of some sorts.
- Function Needed! Please Help!
- simplify equation
- how to make formula
- Sumif Command
- How to set the row for title to be fixed during scrolling?
- adding days correctly
- import txt create sheet name
- How do I use conditional formatting to hilite weekend dates where.
- COUNTA for a cell with a formula
- Updating links from one worksheet to another worksheet
- Conditionals
- Copying Data to next available empty cell in cloum
- Using a formula on cells containing results of formula How?
- Count data based on past dates
- How do I compare two values to calculate a total?
- Lookup from one spreadsheet that links to matching keys in another
- Counting values lower then the median.
- auto correct numbers with dates
- text fields in pivot tables
- Contional Formatting - other cells
- Data Validation and named lists
- format cells for color
- CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
- “Count” occurrences of two conditions on the same row
- Can you ID a cell that has both Alpha AND Numeric characters?
- Excel should have unhide all worksheets selection or button.
- create links to check boxes marked "good" fair"and "bad"
- How do I calculate the midpoint date between two dates.
- Link worksheets
- How can I create a link between cells in two separate Excel sheet
- Fix Simple #Div/0! error
- in excel, can i set varying CELL widths that are in same column?
- Hi people views once what I received:
- Hi people views once what I received:
- vlookup range changes
- transposing question...
- Return a formula as text string to a cell
- SUMPRODUCT
- how do I paste without EXCEL increasing the cell number ?
- Excel file window won't open
- Excel should have row column highlight indicator
- Carrying a balance forward
- how to catch the second or more cell with vlookup
- how can i change my sprdsht to list info from colums into rows
- How do I delete extra blank pages from an excel worksheet?
- Lookup in data from external datasource
- In Excel is there a function to change a cell's background color?
- Vlookup referencing one column that contains part numbers in both.
- how do I fix my 'if' statement?
- Please help w/ nested IF that returns a #N/A.
- Count Records Between A-K and L-Z
- Excel Help Needed......
- Advanced Filter w/ multiple sheet List Range
- Bug in days360 function
- automatically updating summary worksheet
- How paste text from note pad to excel w/o using (Text to column) f
- lists
- Sum Count of Numeric Criterion for LAST 5 Rows
- How do you dedupe a list in excel with parameter?
- Conditional Concatenate
- Calculating p-value from Fisher's Exact Test for XYZ parameters
- how do i use excel's natural log function with negative numbers?
- external data function error-MS Query
- Subsequence of characters
- Excel User Conference - Registration winners
- what is the problem, when value comes up in the total column
- how do i create a customised numbered list in excel
- Correct answers like a quiz
- LOOKUP function not returning expected value - Using vector_lookup format
- Looking-up Columns w/calc'd Values ONLY to Calculate Average
- Is there a fluctuating payment loan amortization template in XL?
- functions/formulas
- Formula to figure bonus
- look up a value
- create pivot table with master/detail data from 2 worksheets
- calculate the p-value for a negative t-value
- Finding the date on the 'nth' Monday in this Month in this Year
- how do you setup a table
- Counting dates, within a list of dates
- How can I add additional rows beyond the 65,536 in excel 2003
- Option Button - multiple selected
- Summing one column if two other columns' values appear in other sh
- Which formula?
- returning a cell name
- Rolling Forecast
- IF condition
- Finding/removing duplicate names in a worksheet
- centre across selection shortcut
- Dragging Conditional Formatting
- Sum & VLookup
- Returning value based on input data
- converting a string of information into excel cells
- How to pull cells from other worksheets including color/comments?
- vlookup is returning a value one cell above the correct cell.
- Calculate 2 Standard Deviations
- VLookup Error in Part of a Named Range
- AND in an array function?
- How to create a New system function
- one criteria/mult. values
- formula for matching text
- Display missing Part Number if Column A does not match column B
- list box
- How to best monitor threads on this site
- Returning a sum when looking up two different values
- IF Cell Contents Start with STRING
- Text to columns
- drop down lists
- Text manipulation
- Sorting two columns (again)
- data from 1 sheet to the next
- excel conditional formating decimal fractions
- Index and match among sheets
- How can I add 3 years to date 03/05/2003
- Pull information based on a range of numbers
- Changing date from =NOW() to Creation Date
- Establish formula for multiple logical_tests
- Help needed with conditional formatting and adjacent text
- function to populate different cell
- IF Command
- Drop down categories in Excel
- Switching Subcategories into Categories and Vice Versa
- T-Account templates can be found where?
- days between 2 dates
- Measure length of an AutoShape Line?
- Total width of several columns.
- Search a random array of cells and return a value of "X"
- Lookups
- loan payment
- Tables, How do I make new info push existing info to the next row?
- Unable to paste a formula into other cells
- Fill with zero
- Recording a high price on a worksheet
- Parse data where break is a first uppercase character in a string?
- Nested Ifs
- anti logarithm function for base 10
- Countif using the same cell on every sheet
- How to equalise loans by ditributing funds
- Protected worksheet with unprotected cells i.c.w. remarks
- Can I use IF function in calculated fields in a pivot table?
- Need a loud/bright warning before making changes.
- Adding or combining time problem.
- How to obtain both std dev and std error mean in each y error bar
- exponentials
- using worksheet name
- How do I type this so excel recognizes it?
- testing. do not open.
- Auto sum
- Change source ofr edit link is greyed out
- a h.s.l.@ £3.80 mtr & 10sq m are fitted whats the formula help
- template timer stopwatch
- Deleting formula in data validation list
- test a range of cells and return an adjacent value
- end result
- How do I get the largest number in a sheet to stand out on it own
- Help! With SUMPRODUCT
- Mortgage calculation after a large extra payment
- running total from the same field on multiple sheets as i add she
- how do I use the solver to solve polynomial equations?
- hyperlink using cell contents
- ranking with some blank spaces
- Filter arrows freezing!
- Adding percentage as interest to a total
- How to define table size
- accumulating values generated daily
- Hide used names in drop downbox.
- lloking for an easier way to count
- assigning points to rankings
- How can I alter the rounding rules?
- Excel formula
- Prevent user changing pivot chart layout
- Values not updating
- Find max number of character and return cell address
- Conditional formatting if value in cell is found in a named range
- INDEX and MATCH in one formula...
- Count If 3 Criteria Met
- CountIf by Month-to-date
- percetile function limitation
- Insert blank line macro
- Check for Duplicates
- why am I getting a #VALUE! error?
- find and replace - replace data in rows to separated by commas
- cell format changes when formula copied?
- Help with a function button within a cell
- Screening one list for data
- address() function
- Sum if need help
- Match/Index Returning #N/A
- Lookup different sheets and get the value from the sheet specified
- count function help
- VLOOKUP - 2 Questions
- Insert Subtotal button
- Another time addition problem
- Create number format for 4 digit integer preceded by zero
- sumproduct question - kind of...
- Changing Text format in a function
- order formulas are updated..
- CountIF() in Worksheet B while referencing cells in Worksheet A
- CountIF() in Worksheet B while referencing cells in Worksheet A
- Viewing data in Excel while scrolling. Instead of the cell count?
- copy data from various sheets into one sheet
- Data consolidation from Multiple Sheets
- Excel Formula or tool to compare two columns of data
- Macro help
- need to ONLY display worksheets that have had recently changed
- Copy cells, preserve cell size
- SQL.REQUEST not working in EXCEL 2003
- TRIMMEAN with different percentiles?
- increasing and decreasing a value in a cell
- how can update the data in an excel workbook without opening it
- Formula too long - Shorter version?
- Answers needed for challenging formula
- MSN Stock Quotes Excel plugin broken?
- how do i use import to consolidate data from multiple sheets
- seeking of array
- Comparing and counting occurences in 2 columns
- Little help with weibull function needed
- How can I set up a milestone report with red/green/amber alerts
- Lookup and compare rows
- Excel Programming
- Can't get CUMPRINC to work. Have Installed Analysis Toolpak
- Copying problem
- data entry in excel by linking to other word doc. or excel sheets
- how do I round numbers in .125 increments
- formula link to a file
- changing the year of a date
- Sumproduct Date clarification
- Formula for rounding a column of currency to a multiple
- 2 column lookup - match to date range
- Convert text in cell to a range name for formula
- Stake calculator
- Chart from different worksheets
- Count Unique Entries
- Sum if 2 conditions are met
- Vlookup Q
- Can sumproduct do two {x,y,z} arguments?
- Questionnaire sheet: Select "yes" or "no," and only one can be selected
- sumproduct/countif function help
- Duplicate listing
- Is there a go to function in excell
- ADDRESS Function
- Can you make a cell = 0 if original function is creating a"#ref!"?
- Is there a way to post a file to show an example?
- Nest a referenced formula in excel
- Ranking based on two columns
- I NEED A FLEXIBLE FORMULA
- Importing data into excel
- combining two lists
- Can the "Date Picker" from Infopath be used in Excel?
- Public Macro Help (CFColorindex)
- Is there a way for Excel to create a task in Novell Groupwise
- How do i find a correlation between 2 data point or sets?
- Nesting Networkdays function inside and If function
- My Datedif function only returns 0's in the cell what's wrong?
- How do i calculate the total revenue in Excel?
- pivot table field list
- Conditional Format - 3 conditions
- Can you print indicators when inserting a comment?
- Merging data from Multiple Worksheets
- VLOOKUP works in some cells but not others.
- functions
- lookup single value in entire worksheet
- if "a" selected from dropdown menu then show "K" in other cell
- How do I make the true return a drop down list in the IF function?
- use the current row in a list to populate a report
- How do I condense 3 columns into 1 in Excel?
- updating a spreadsheet in 1 field w/ out changing values in anoth
- If Statement???
- Convert Total Hours and Minutes to Whole Number
- Formula for cells that contain a specific letter
- Conditional Format Issue
- Copy a formula down a column
- Formula Help
- How do I format to currency when number includes cents?
- counting instances of specific times in fields with date and time
- Need help with formula
- Highliting Duplicate Cells across multiple rows
- Compare one Column to a Second Column Formula Help Needed
- Count Names in One Col if 2nd Col Isn't Blank
- Import data into my workbook
- Formula to return a value if any numbers in a group meet a criteri
- formula to sort size
- need macro to check part# and sum
- How do I make out an invoice using Excel that has two pages
- How do i populate a text box according to selection in combobox?
- skip rows
- To get values into an array
- Intergrate data area in a function
- Pop up windows in excel
- How to draw a circle in excel with specific radius
- Hiding Rows if Blank cell
- Make cells flash.
- How to make excell ignore non-whole numbers
- Which formula should I use?
- Arrange numbers in a sequence
- Password
- How do I speed up recalcs when using lots of SUMPRODUCT formulas
- Summing every other cell in a column?
- Need a function to convert value in its name
- get date with now() today() but dont update with recalc
- parsing text in a multiple column count
- How to evaluate a 'dotted' number using formulae (not UDF)
- Need Help with formula
- Using Mode in Excel, need more than 1st most frequent number.
- Formula w/negative no.s & Percentage
- Truncate words
- Using Concatenate operator to overcome > 7 nested IF's
- stumped ??
- time addition to predict finish time
- extend my formula with increments of 4 cells
- Average range including blank cells: #DIV/0!
- How to display two worksheets from the same workbook side-by-side
- Address of Maximum value in Cell
- count double occurences
- Can a linked hyperlink be updated
- Choosing which sheet opens
- LINKING WORKSHEETS
- How do I set up a formula for parts (or units) per hour?
- Multiple conditions in a formula
- Combo boxes and formulas
- Adding columns in Pivot Table having common description
- How to extract multiple cells based on one value
- Conditional page break if merged rows won't fit on the page.
- Validating non-blank cells in workbook
- columns on worksheet2 don't sort with worksheet1
- An "If" statement coded in a macro
- How do you set up the data to perform a Anova 2 Factor/w reps?
- How do I anchor a cell/create absolute ref. while clicking on it?
- lookup with more then one codition
- deleting line item in import function causes REF# error
- OFFSET function returning #VALUE when using external references
- Adding columns in Pivot Table having coomon description
- Vlookup Displays Blank
- Rounding to a specific value (up or down)
- Formula doesn't update when rows are inserted
- PHONE NUMBER formatting
- copying a reference
- Look up to return a true/false value
- get text from another worksheet
- Can anyone tell me what's wrong with this formula?
- vlookup returns last value in array
- Automated Popups
- GetPivotData need help
- Formula to add two cells when one or both cells are text
- Deleting info from all cells at once
- Changing Decimal to Hours
- How to total rows in Excel with non-value cells like "included"?
- Multiple Subtotal levels in Excel 2003
- Matching multiple columns
- London Excel User Conference - July 19-21
- SUMPRODUCT Criteria Via Cell Reference??
- can someone translate this formula pls
- Offset function help
- Linking sheets into one major sheet?
- PIVOT TABLE
- WEEKNUM
- How to prepare Multi Stock Valuation on Fifo Basis in Excel
- car loans
- IF statement too long, need another way
- Need help with multiple argument formula
- How to calculate "number of months" between two given date?
- Wildcard IF formula
- Nested Vlookups
- why is "sum" displaying zero?
- If stmt and assigning a value to another cell
- find exact values of SQRT
- Unable to find values of SQRT(0)
- sort, 2 row header
- Vlookup updates
- Pivot Table - creating % of Totals
- Using sum with cells containing text
- Multiple Formulas in same cell
- making subtotals and grandtotal from multiple pages excel2000
- Adding/Subtracting Dates & Times
- Totaling the number of comma delimited numbers in a column
- Copying formulas from multiple worksheets
- Is there a function Countif that operates like Sumif?
- Generate Report
- Schedule help: formula based on 3 choices of data?
- Ranking within in ranges
- How to convert Email into Mailto Email Addresses
- Calculate with codes and times
- Drop Down Value & Length Dependent
- HOW DO I BLOCK DUPLICATE NUMBERS IN EXCEL
- How to add characters to all existing values in a given column
- If - Then Formula
- proper way to nest AND & OR with IF?
- Excel conditional sum
- IF formula
- Conditional format lowercase
- Need Formula! Look for box selected and do certain function
- matching
- Gathering Data from Option Buttons
- how to freez more five columns without splitting the panes?
- reference multiple tabs
- vlookupand #na
- Numbers in the balance!!
- When I open a workbook, how can I choose which worksheet opens?
- How do I enter a formula that will delete a line when a cell = 0?
- Drop Down List Error
- Stripping text before a number (alpha or numeric)
- assign numbers a value, then get percentage
- Excel function glitch?
- create a formula
- Finding the Monday date based on a different date in same week
- Data Range Question.
- Formula auto-fill help!!
- Displaying time - Error in formula (I think?)
- Adding Time
- font problme
- Need to link excel "cell" to a pre saved PDF file?? How do I do th
- how to stop xl from showing hidden colomns
- Merging and unmerging cells
- my first 'IF' formula
- Formula help
- Spreadsheet won't print changes I made, only what was prev. saved.
- Merging Columns
- vlookup not found
- hit F2, want the color coded formula to appear in formula bar not
- "Looking Up" Access from Excel using SQL.REQUEST
- Variable VLOOKUP source and target
- Comapring fields that have TXT and No's
- variable Addition and substraction
- Build an array constant with DATE function
- Is this possible , screen captures with a macro?
- If Statements
- Expected end of Statement
- Split the date & time in one cell to be 2 colums.
- Convert Excel 4 formula to Excel 2003 format
- Exporting data from access to excel
- How do I format default cells in a template
- Centering comments
- multiple worksheets
- Loan Amortization
- Easy question: Sort ascending in a row?
- How to do nothing if @IF returns FALSE?
- Function that compares dates
- How can I use Excel to solve an equation?
- what's the formula for finding 401(k)?
- Excel Functions
- Count down clock
- Average only cells that contain numbers
- Auto Fill
- Creating formulas
- Match name not exact
- Address for Linked Files in Formula
- MRound and Roundup
- list box
- transfer data from sheet1 to sheet 2
- How do I stop a Macro from running?
- vlookup
- How Do I Do an Exclude Filter based on a Named Range?
- How do I make a letter represent a number?
- Protection will not allow me to insert a comment
- 3.02 PM ( Decimal Point )to 1502
- Find 2nd Largest Value
- grouping rows with blank cells
- IF formula doesn't work with certain numbers
- Identifying First Instance of a Value Given a Criteria
- Fixing Hyphens
- Function to count unique items in list
- PPMT Function with varies interest rate
- how protec cell in excel?
- Deleting unwanted colums on a worksheet
- Combo box with data to use as hyperlinks
- Re-Post - Any Help Appreciated
- How to fix lower and upper bounds for data
- Sum Values Question
- Return Summed Count of Multiple Consecutive Numeric Values
- Filling Blank Cells
- Rounding or not rounding
- complex excel formula Array how do I convert it to a vba Function
- Percentages
- excel
- hyperlink reference not valid
- Sumif Formula
- Count function applied to a time period
- Vlookup for multiple selections
- i have a excell for with data entered in and need to enter new da.
- subtotals
- Adding or pasting a row, but having info shift upwards not down??
- plus and minus sign in cells
- Can Named ranges be used in file link formulae?
- checkboxes
- checkbox
- CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS
- Protecting Workbook!..
- Code to raise Directory request box
- COUNTIF across multiple sheets
- Sort by column inside a worksheet
- Run out of nested Ifs
- how can i highlight dupplicated in 2 sheets at a time?
- Replacing Linked Cell Values w/ Current Values
- Column names
- Simplicity is Desired
- Improve Excel Help Text - Make easier to Find Function Refs
- Finance Formula Help
- the value of a box in excel if entered data is a certain value
- How Can I Do This?
- Where do I find MegaStat ?
- Auto Filling one sheet from another
- how do i only get negative values
- formatting cells
- Need Countif to work like Sumif
- HOW DO I CALULATE A OVERTIME FORMULA
- auto fill from another sheet in excel
- Tab Stop with a protected Spreadsheet
- Excel ? Formula for moving average
- Multi-sheet mapping problem
- Querying a range returned by another function
- COUNTIF function query for multiple colums
- Download An Open Letter From Al-RASHEDEEN Army To The American President
- Missing rows ?
- using a formula, no's 1-443 deleting (116-124) in serval cells
- How I can find breaks in continuity
- Can this be done
- multi-conditional expense tracking problem
- validation list
- NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET
- Transpose Row by Row
- use "if" and "max" in the same function
- Smart Tags and Stock Quotes
- How do i create a countif formula in excel?
- use "if" and "max" in the same function
- Function question
- Getting rid of helping columns
- Sum function not working, help please!
- sum a range between two given dates.
- sort 2 or more occurrences
- All of a sudden none of my Excel formulas are working...
- i'm trying to put a value with a number but its not working.
- Why do i have blank lines in my subtotals results
- repeating columnar data
- annualized return calculation for the purpose of portfolio performance evaluation
- results on sheet 2
- Finding specific text in string - Part II
- Randomly Generated List / Macro
- Finding specific text in a string
- divide by zero
- Easily convert all formulas in 3d spreadsheet to values?
- using a master reference
- Desperately trying to build a paid time off accrual worksheet...
- How to enter a range address using data elsewhere on the sheet?
- Help! Formula that can Ref. hidden data & Populate Cells with desired text
- Subtotals adding a description next to the subtotals
- duplicate numbers in column a and diferent values in b
- Transpose Function
- conditional formating
- Need formula to jump from one column to the next
- Dragging & incrementing cell values
- How do I optimaly distibute a number (whole values) into a range
- increase/decrease decimal
- Problem analyzing my data
- Conditional Formatting
- combining multiple sheets
- how do i use vlookup to search for a value on another sheet?
- Autofilter grayed out - why?
- In Excel a cell formatted "currency" shows "######" help!
- Circular reference mistake
- Complex or Conditional Countif(s)
- Help with looking the nearest Sunday
- How do I stop making the spreadsht move when I move up/dwn/lt/rt?
- Return A Range of All Cells With Links
- Public Function - Color Index
- If than copy function / Macro
- Table array in VLOOKUP (EXcel 2003)
- Named formulas in CHOOSE need to be Relative references when paste
- Using Match & Offset
- Custom Functions saved as addin
- Conditional Filtering
- Please help with Statistics Functions
- Adding data in a list that meets a specific criteria
- my filter is stuck !
- Access to Excel
- Excel Spreadsheet - Mandatory fields