- Bringing in a Union Query with excel?
- Autofit and merge
- Header
- excel
- How do I calculate in an IF
- How do I select a number from a specific group of numbers?
- sum one cell from multiple worksheets
- how can a two digit # be set up with 2 0's at the beginning 0025
- how do i add up 2 x columns separately and also do a minu
- SumProduct Question
- Re: Percentage value of amount
- Sum column information based on multiple criteria
- Insert-Name-Define How to change formula after-the-fact?
- this command is not available in a shared workbook
- Shared Workbooks
- how many tabs on a excel spreadsheet can you have?
- change the year in employee absence schedule
- function
- How do I display duplicate records in Excel without deleting?
- IF and VLOOKUP (maybe)
- sum with multiple arguments
- phrase to equal a number in time sheets(al=5hours)
- Logical test question
- VLOOKUP returning value when range_lookup false
- calculating time
- how do i countif on multiple criterea?
- Not sure which formula to use..
- Match fonts when inserting an excel worksheet into a word document
- Leading zeros lost in csv
- CAN YOU SORT DATES IN A/Z OR Z/A MODE? IN EXCEL
- Excel VBA Macro to compare 2 worksheets for same values
- Count unique items in groups
- VLookUP problem
- Conditional Formatting
- calculating a date with the CHOOSE function
- create multiple worksheets from a mastersheet same workbook
- VLookUp Tables
- Should be the easiest thing to do...
- need to compare id numbers of records in 2 workbooks
- remove tail spaces
- Date plus 1 year, but begin of month
- Summing up worksheets
- Vlookup using a formula possible?
- what is print to file in print dialogue box and its useage?
- Not all Filters made on Page Field Variables Update the Data
- How to separate the numbers and characters in the cell
- linking pivot table data to a cell in other sheet
- Data contains more than 65000 rows ?
- Display multiple lines of text within a cell from multiple column.
- Help Required!!! Macro to load data from version 1 to version 2
- Personal.xls
- conditional formating using dates
- select highest value
- macro help
- auto filter doesn't return cells containing the custom search wor.
- How to Manipulate formula for Binomial Distribution
- Countif with Two Criteria
- Data in cell changes then another cell data to change
- How do I auto-highlight a 'below limit' number in an average
- Rapidly Approaching Meltdown
- How to seperate OT and Reg. Hours from total hours
- How to match bits to a certain value
- How do I calculate the inflection point?
- plot graph from multiple worksheet as embedded chart object on every worksheet
- how do I create formula to sum hours & min's
- Change text based on other cell criteria?
- how do I combine two pivot table?
- Grabbing the filtered data in a list?
- Grabbing the filtered data in a list?
- Multiple field match?
- VLOOKUP and its properties
- is there anyway to use sumif using 2 criteria
- end number keeps changing to '0'
- Conditional Formatting
- How can I get a worksheet name appear in a cell?
- Conditional Count 2 Columns
- to convert columns to rows having mulit independent group columns
- keeping a running total in a single cell
- Help getting first column data based on criteria?
- add blank space in cell if first name is not blank
- need help with SUMIF
- Due Date with year using IF for several cells
- How to automatically create hyperlinks with excel
- Rows and columns in 2007 1,048,576 rows by 16,384 columns
- sumproduct with dates
- Looking for help creating dynamic list numbers
- Looking for help generating list numbers with reference
- How can I edit cell notes while track changes is turned on?
- how to install microsoft exel
- Help with Lookup Calculation
- CUMIPMT
- Vlookup, return zero if not found
- If function calculating date
- Average if is not greater than today
- Lookup vertically to next cell with data
- IF(OR Function with years
- USE KEYBOARD TO SELECT ALL SHEETS
- How do I sort records that are on two lines in a spreadsheet?
- Independent column widths
- IF function returning incorrect result
- How can I print a worksheet excluding blank rows?
- Sorting by 5 digit & 5 digit plus 4 zip codes
- formula won't paste from one cell to another with current cell inf
- How do I do a two level Vlookup?
- Lookup in one column
- IF Function
- IF Function
- lookup column label based on data in cell
- Counting total for multiple criteria
- Pivot column disappears after external data refresh
- Excel "IF" function
- Consolidating a Row of data from many worksheets
- countcolor
- alerts
- Need help with formula for Weekly Value
- Saveing workbook to a file as todays date daily
- calculating days + holidays
- Autofill a list
- Pivot Table Help
- Autofill Sequence
- Pivot Table Help
- Formula auditing inactive
- Sorting data within the same row.
- How can I get the value and the format of a cell.
- Counting data by week number
- Dropdown frustration
- Moving Rows to another sheet based on an entry
- Combining LOOKUP and COUNTIF functions
- Paste Special
- Truly Null
- Return all figures in a Range
- pick the greatest number out of a group for the total box
- condtional formatting not working
- excel formula question
- "IF" function, have the facility to place a colour in the cell
- not able to create subtotal summary report
- Need to automate unique identifier
- VLOOKUP over multiple sheets
- DATE STATIC
- how do you conditional format based upon today's date?
- Change results , change data in othe cells across the row
- Conditional cell auto fill
- Plesae help: Excel function
- Difficulty linking cells in Excel 2003
- creating a formula that condenses information in a cell
- sumif and range validation
- Multiples of 4 in an IF statement
- how do i flag a cell using background color
- how do i flag a cell using background color
- reference to other sheet doesnt work
- how can you autofilter a spread sheet and keep your hypelinks in o
- Lookup and Sum
- WEENUM into months
- validating cells in the same row has unique values
- How can I change all negative values in a column to = 0?
- Sum of visible cells only
- Linking Access Records to Excel
- Vlookup funtions
- Need some comments on my Utility_Move class module.
- Freezing cells
- how can I conditionally change font color, or background color?
- cell comments disappear in shared workbook
- Lookup - not sorted?
- Need some help
- Formula Referencing data on multiple worksheets
- Find data from one sheet in another sheet
- How do I add a series of cells?
- Request a formula!
- Footer exceed max characters
- I want to import a web query into the same cells each time
- =COUNT(IF(AND(K2:K20>=382,K2:K20<=383),IF(E2:E20=" x",1,0)))
- Time Table
- How can I make a clickable button to do a Key Combo?
- Data sorting over a large number of worksheets
- saving workbook to destination file automatically
- Insert into Header/Footer List Box
- VLOOKUP and logical functions
- Count down with auto fill?
- comparing data
- Conference pictures
- Inserting Blank rows after every row upto 2500 rows
- varying a cll value from min to max
- Auto size a pivot table to a page size
- Disable cut and paste
- Help me find function Datedif
- changing rows insted of columns
- How to add in increments for multiple cells
- Conflicking dates in formula
- Increasing a range of grades available
- Counting with date criteria
- excel lookup matching and value display
- where can i get accounting templates
- Making a spreadsheet for orders
- Auto Date in a cell if other cell is greater than 1
- File Format Not Valid
- Excell formula required. If a^b=C....... a = ?
- Identify a range of cells containing dates
- Pivot Table Layout
- DATE RANGES and other functions, formulas
- Adjusting Referances
- Index function and changing criteria help.
- Font Color Function
- How to make average function ignore MIN and MAX
- Finding test strings in a row which are missing from a column
- Copying Cells with Drop Down Lists
- link a spreadsheet to another spreadsheet
- need help on delimited
- Skip blank columns with LOOKUP formula
- how do i get multiple values in vlookup?
- Gaps In Bin Locations
- Searching for a value in an Array
- Should I use IF here? How?
- How do I average 4 of the last 8 golf scores to calculate a handic
- Scroll bars without control tabs
- Extracting part of Text from one cell to another
- Name Ranges: Function to convert special characters underscores
- T Vaule function
- indicate a number of rows to sum
- Using words in Formulas
- Combining Words
- Excel Drop Down!
- Monster Formula
- Vlookup
- line appears when deleting chart- cannot delete it
- This Year
- letters cut off in cell
- Change colour of cell if there is no value
- I need to set colums and rows to stay on the screen as I scroll
- RE: I need to set colums and rows to stay on the screen as I scroll
- How to extract the month in a Pivot Table
- Linking Sheets
- Re: Change colour of cell if there is no value
- SumIF through filtered data
- Problems appending cells together
- no more new fonts may be applied in this workbook...
- How do I subtract time?
- Formulas
- IF(AND)
- How to keep 0 in front of # in excel (ex: 018787766316)
- how can i make number to letter
- autofilter does not hide unwanted results
- sum column with na from v lookup
- what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
- My girls
- Show values in formula instead of cell reference
- INDIRECT
- My girls
- My girls
- My girls
- problem saving an open excel workbook
- Checking the Cells in Sheet1 with Cells in Sheet2 and replace
- Help with Crazy Lookups
- link worksheet A & B
- Can you set up a simple address book in Excel
- Lonely Heart
- calculate loan amout
- Analysis Tookpak
- Columns Counting Function Reqd
- How to convert date/time to seconds
- The most powerful computer security tool
- Autofill Match Formula on different worksheets
- sums are wrong
- Creating function to insert data based on criteria
- Finding day of week in 2030
- IF logic only works 7 times
- updating links
- sumproduct in a given year
- Adding time [t]:mm:ss
- How to retreive the data entry bar to edit a sheet?
- Day Off schedules
- How to get these cells into 1 column
- formula bar
- Conditional Formatting
- Analyze Data
- PIVOT TABLES
- Database Function Criteria Boolean Operations
- Sum formula result shows "#N/A"
- returning value if month is January
- Conditional formatting similar to shading alternating rows
- budgeting for your home
- connecting multiple cells to new sheet (VLOOKUP?IF?)
- How do you use more than 7 arguments in a logical IF?
- return range of data from lookup function
- return range of data from lookup function
- Re: IF AND OR functions
- Lady Only
- When Averaging a column, exclude value based on another cell value
- VLOOKUP using cell reference
- how to convert arabic numbers to english text format in excel?
- Inserting a cell changes my formula values
- How to pull extra info into Pivot table report
- Adding multiple worksheets
- How do I calculate only visible data (not hidden rows)?
- Inserting Characters
- Calculate Based on Drop Down Item Selected
- Match with a Twist
- How to Create a file in Excel that can't be copied or printed
- How to Create a file in Excel that can't be copied or printed
- How to Create a file in Excel that can't be copied or printed
- Excel drop down list arrow has disappeared.
- Digits to text
- Read
- Worksheet name
- ? about COMMENTS
- Tab Through worksheet
- Read
- Hyperlinks
- help making data base to look up stuff.
- How can I extract name of the LONG MONTH from previous cell.
- Read
- How can I combine cells with first/last names into email addy?
- Logging a website information.
- need to link without having source workbook open
- Freeze first and last rows
- inserting a row based on a condition.
- Get number of rows that data takes up, including blank rows
- LOOKUP formula
- Please help: identify where an automatic link to other spreadsheet is?
- help on excel function
- Finding most common occurence of values in cells containing letters and numbers
- link worksheet A & B
- calculating hours in one cell
- Count occurence with user defined upper&lower limit.
- Formulas to speed up many manual "=()" commands
- SUMIF function with text color condition
- How can I place a formula inside another formula?
- Help with countif using two columns
- Help combining formatting in macro functions
- IF ? function
- Blow ups in spread sheet
- How do I change replace text in a cell for different text?
- My IF in Excel formula is not returning the correct value.
- Relative Reference Help Macros
- Compare data in two columns
- + prefix on positive numbers
- Sumproduct
- A correct formula gives an incorrect figure
- Customize Formula Bar
- help with a macro
- Wildcard for finding the first numeric digit in a cell?
- How can I generate a unique number each time a form is printed?
- Insert Footer into Cells
- how do i write a macro
- using linest with very small numbers
- how do I create a formula in excel with using 2 columns of info?
- how do I create a formula in excel with using 2 columns of info?
- RE: how do I create a formula in excel with using 2 columns of info?
- UDF alternative to PULL that opens external workbook and grabs val
- How break column formatting to vary cell widths vertically?
- How to format a cell to reflect a NIC's MAC Address ? (put in dash
- RE: how do I create a formula in excel with using 2 columns of info?
- Is there a way to Lock down a date formula?
- sum of multiple arrays?
- COUNTIF on an autofilter?
- sum multiple lookups?
- Mortgage calculator: finish date?
- Repeating a concatenate function
- excel 2003- verify that row used in calculation is same within 2 c
- COUNTIF using OR
- Excel Marco for IP Address
- AOR to APR - Truth in Lending
- multiple column lookup?
- Price Function Error?
- How do I add a new TAB ?
- IF AND OR functions
- auto refresh
- Incorporating OFFSET into Chart References
- Calculating number of hours accross days
- wrong calculation in excel? formula outcome <> cell value??
- How can I have data auto insert into another pg in workbook?
- Automatically inserting a column
- Cell Referencing Code Error?
- IF Question
- if and or ifthen?
- Newbie at this---Getting to third standard deviation
- median function
- median function
- How do I add data to drop down lists?
- how do I copy R[40]C1 references
- Validating certain cell
- How do I sort with empty rows between none empty rows?
- search in excel - autolookup
- Dsum or Sumif Help!!!
- Make it possible to split unmerged cells again!!!
- Summary Sheet
- format cell to place colon btw every 2 alphanumeric characters
- address function
- If/Or Clarified
- Sumproduct wont update properly on closed workbooks
- Should be able to color code or highlight Excel worksheet tabs.
- How to embed email link in excel document to distribution list
- Re: Sheet Name in Cell
- formula to calculate time difference crossing midnight
- REPEATING NUMBERS IN A ROW
- Circular Reference Problem Calculating Net Pay
- Sum of columns that vary in position
- How to repeat multiple rows as a header - each page of worksheet?
- If and Or
- Force a field to be completed
- Adding a comment column to an external datasheet
- Adding a Comment-Column to an external data-sheet
- Filter the results of a list based on a previous vlookup against the same list
- Microsoft Excel
- CREATE A LOGICAL TEST CONTAINING TEXT
- Stylecheck function
- How can I count the no. of entries in a column.
- How do i match simillar data between two different rows in excel?
- Average & median of text "time" numbers
- Having trouble with AVG Function
- cell returns wrong value
- Concatenate and Line Breaks
- Executing a formula based on criteria being met
- have several excel questions
- Hi and function help please
- Is there a way to make Excel 2000 dial phone numbers?
- password protected
- RUNNING BALANCE NOT SHOWING
- Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
- Calculating numbers without using "=" sign ?
- Can we have cells pop up with a formula & hide if not want
- If between function...
- Random name
- copy data from a worksheet
- How do I reference an Excel filtered list in a function?
- DIVIDE NUMBERS EVENLY
- conditional subtotal function
- Conditional formatting - Different cell value
- Automatically entered decimal point.
- Select and adjust a value based on a total
- Pulling data from one worksheet to another
- Re: "CONTAINS" operator?
- Can you link 1 column in a sheet to the same column in another sh.
- Re: "CONTAINS" operator?
- Remove some text from a cell
- Count reports per month
- How do I change excel sheet from R1C1 for cells to A1 for cell?
- Find the 1st occurance of a number in a cell
- Count unique text
- Sub total data by year
- Need to insert a counter for supplies ordering.
- looking for information in the last column
- If Question
- Sum a vlookup
- Intellisense
- Saving a file
- Re: "CONTAINS" operator?
- Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
- RE: Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
- Still need help on annualized rolling sum
- Working days and hours calculation - request assistance please!
- If, Lookup
- Text to Speech Function
- Please help - sorting list of numbers
- ability to look up posts to discussion group by user name
- Can INDIRECT function reference a cell that contains a formula
- change 2000 cells (negative numbers) into positive numbers
- can vb from excel launch another program?
- How do i print only the comments for one person on a report?
- Dcount with Multiple Criteria
- Displaying a number with different decimals depending on a condition
- Excel : how do I sum costs if the they relates to the same period
- Need help with division, please!!!
- Over keying a formula - Can I set this to automatically bold ?
- excel
- Add Visual Foxpro 9 DBF import / Export to Excel 2007
- LA User Conference October 25-27, 2006
- Exclude records that start with *
- I need a criteria expression to not include records that start wit
- Carrying Detail Data to Subtotal Row
- order of calculations in Excel
- worksheet adds 1 or 2 values to totals
- Referencing 3 values for a lookup
- Intellisense
- Office 2003 merge questions
- Fill Function to next Column
- Vlookup Help
- Changing formula to a value
- Date sensitive cell pattern color
- calendar control excle 2003
- Solve for rate of growth on an investment
- Rows to repeat on each page
- How do I tie fields from tables of diferente files?
- ROWS TO REPEAT ON EACH PAGE
- Mid Function
- How to calculate something using equation from Chart' directly?
- Percentages and formatting cells
- Merge Excel multi columns into Word
- Vlookup value between 2 cells
- Embedded VLOOKUP function within IF function
- Dynamic cell range for functions
- Program error when using Compare and Merge Workbooks
- Hiding error values in cells
- Barcode 128 B Add-In
- Having Trouble with the RANK Function...Try LARGE or SMALL Functio
- Conditional summing across several sheets
- Assigning Name to new workbook
- Formula to fill a cell based on an entry in one of two worksheets
- How to add a variable as a parameter for a link?
- Data validation problems
- Lookup function with mulitple conditions
- Merging if
- how do i remove folder explorer side bar
- How do I copy/paste odd or even rows from Exel?
- Set up macro in Excel to choose active row?
- Numbers stored as text prevent calculations
- extract data up to a certain character
- DP Auto increment
- Switch function
- Move a spreadsheet to an unopened workbook
- Checking for subfolders and creating
- linking cell colors
- Formula help
- Sorting alphabetical list into multiple columns
- Using search when it returns #VALUE!
- COUNTIF values are > 0
- How can I list worksheet tabs as a table of contents?
- How do I resolve a problem with sharing a workbook
- Pasting values from 2 colums into 1 on a seperate workbook?
- problem with date sorting
- How to Search, Count, Match and Post Values
- Concatenating entire columns
- repeat macro until empty space in next column
- How can data be summed for based on corresponding dates?
- Printing invoices
- Popup boxes for dates?
- negative numbers
- Data Validation
- Text Color Change prompted by different columns
- alphanumeric sorting
- alternative to if statement
- How can I change my column references from Alpha to Numeric?
- Excel 2003 is missing toolbar button select visible cells
- Consolidation of dulpicate rows of data.
- HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE
- how to convert a column of numbers (monthdayyear) into dates?
- Using VLOOKUP in VBA code
- Vlookup not Resolving
- Excel 2003- Benefit attandance calendar
- I need to understand how the IRR, NPV and FPV formulas work? Thks
- Sumproduct Not Working
- vlookup and hlookup
- Searching a text string in a range of cells.
- Compare Two Columns (Exact and Wildcard)
- Calculate number of months between dates
- Using seperate sets of radio buttons in one sheet
- Convert from Excel to Software ?
- How can I get Exel to display every (eg) 35th row only?
- What happened to the Invoice Toolbar in Excel 2003?
- Overwriting prior formula
- How to convert Kgs to Stns, Pds & Ozs
- Report choosing a Pivot table data
- How do I match values in one spreadsheet to values in another?
- Where in Office 2007 can I record a macro?
- formula or vba code
- Reverse of VLookUp
- Do I need to combine hlookup and countif?????
- Enquiry Form
- How do I select the first cell of a filtered list?
- Mathematic problem solving using Excel
- no #VALUE! to printout
- no #VALUE! to printout
- MOre than 8 argurement
- Sumproduct using dates
- Use filename in cell to link data
- color code a row by expiration date?
- analysing sales vs price
- Rank Function
- Rate function
- Closing files and saving files
- find two (2) lowest values in a range (Excel)
- random sample
- Round Len Function Help
- Excel should let you select 2 rows, right click, and SWAP them
- Removing characters
- Help with Random Functions
- Concatenate values
- Ned Help W/ Custom Function
- Benefit attendance calendar make 2 items .5 points not 1 pt
- Getting wrong values
- where can I find the "Calculated Field" in Office 2007 version?
- Compare 1 column to another
- net present value
- a count formula
- name range from absolute to relative
- Index, Match or what???
- Excel 2002 dropdown lists
- Match Column B numbers to Column A numbers
- eliminate repeat values from a list of ascending order
- concatenate and hyperlink functions
- Sum If
- If function
- IT'S POSSIBLE TO CREATE UPC CODE IN EXCEL
- Calculating Geometric Mean in a Pivot Table
- New to this forum and yes I need help
- Create a reference to a sheet that changes to todays date
- Replace function into text
- How to use a cell value as operator in a worksheet reference?
- Moving Related Fields
- COUNTIF
- COUNTIF
- How can I Insert a date in a cell from a drop down calendar?
- Count
- Sort Formulas?
- "Fixed Objects Will Move"
- Search numerous spreadsheets for specific data.
- add vs. replace data when merging workbooks
- match, lookup ???
- Transfering Values
- stop changing my formula
- Freze panes
- Conditional output
- ISNumber - What Context?
- Function similar to TREND that interpolates lin. between data poin
- Crazy Hyperlinks
- Sumproduct with date range
- How to create a drop down button on a worksheet?
- I cannot reach the next cells in the xls worksheet
- Is there an excel funtion that retreives the last cell of a list
- Excel 2000 freezes when I try to Copy & Paste after start-up.
- How to Hyperlink from Excel to a VSS file ?
- excel formulas
- How to check valid Date value?
- New to this ! If Cell = less than
- Copy & Cut different animated boundaries
- Countif + Named range
- Loading MS Query takes a long time
- Minimum formula the excludes zeros
- Sum with two conditions
- Cell reference within a indirect..
- Can we use multiple if with VLookup function
- excel result return wrong calcuation result
- excel result return wrong calcuation result
- excel result return wrong calcuation result
- Help: SearchAndGet a value Help
- validation list. Scroll to top when using, how?
- return wrong result of the cell
- hyperlink a worksheet with no address
- Need function for one value for two criterias and two columns
- How do I nest IF statements to only return value if both true?
- Macro Function
- How do I set a cell to auto expand when it has a formula?
- How can I move from one desired cell to another in Excel using ENT
- automatic table to table copy
- Changing a Formula
- how do I convert a column last name first and in assending order?
- Conditional formatting between worksheets?
- Auto Updating
- How to specify which cells/columns macro applies to?
- formula problem
- Summing figures within letters???
- counting letters.
- Importing File greater than 65536
- Stop Excel 2003 auto-scrolling
- I need help with a simple vlookup formula
- data validation
- help with formula
- formala help required.
- Now as timestamp
- ascending sorting
- div
- Processing Data
- How to use RATE function?
- Another checkbook registry problem...
- if cell = no how to copy to another sheet
- % query
- how do i get field name from result of MAX or LARGE function
- How can I set excel to automatically insert rows
- Function or macro?
- How do I run the STDEV function with multiple criteria?
- Missing Excel commands
- What formula will eliminate the cell with #N/A when summing?
- Using conditional formatting to plot campaign dates.
- When I add time - Example 10 days of 8 hours each I receive 81.46
- RATE v. IRR: which to use?
- Formula or Function?
- Auto Update the formula values without opening the link worksheets
- Match 2 worksheet
- WEEKNUM to start on another day
- Formula Help
- how do i unlock microsoft word?
- Looking for a formula that will divide a column & rows by 2
- Current date and time when different cell = X
- Transposing Cells
- what's the command for erfc iterate integrals?
- Is there a formula for inches to feet and inches?
- Formula errors
- formant input
- HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?
- financial calculator
- text and number combined in a cell
- how to calculate Rate when PMT, Nper & PV is known
- How do I make my borded automatic black instead of pink?
- copy multiple cells but jumpin one step at a time
- How do I create a formula using part of the data in 1 cell?
- Is This Embedded in The COUNTIF() function???
- Today minus 1 day
- Formula for excel.
- Validation
- Cell function
- Need set up template/function in Excel to gather survey answers
- adjust the range in a long column of formulas to accomodate new da
- How to find the largest change of values in a column
- breaking links between excel files when one file already deleted?
- I Need Help Creating or Finding an Excel Template
- BIG FILE SIZE??
- Help with creating a formula
- Converting numbers to longitude and latitude
- MSN Money Stock Quotes
- SUMPRODUCT
- How do I slant field cell in the first row of a spreadsheet?
- WHAT FORMULA DO I USE FOR AGING A STATEMENT
- Adding times
- Date Conversion- DATEVALUE- including minutes
- cell color
- How can I create shortcuts for the view function in Excel?
- Format: General - Text - General
- Auto Filter question
- How do I keep Excel temp. format on import from another program?
- Formatting Cell from one sheet to another
- user defined function
- Subtract 6 months
- Copy info IF MAX
- Automating entry in a cell
- Locking rows or Regions in Excel worksheets
- Sorting a six digit number by terminal digit
- insert blank cells
- Automatically changing range of functions for monthly columns
- diable the save function when saving a spreadsheet online?
- copy numbers from numbers+text cell
- Autofill based on a cell reference
- GETPIVOTDATA() with relative reference
- 50% formula
- Help! I want to fill cells as a result of selecting a value from a list in another cell.
- How do I get back the sum feature when I highlight cells?
- #REF!, TRUE or FALSE
- OPen .hgl files
- auto filter / sumif
- Declear which picture I want to show and not?!
- AutoSum
- i cant see my user defined functions in function list
- Linking worksheet to Access Tables
- Excel with functionallity for calculation on in more levels
- Multiple If and Vlookup function
- How to set a number number value as text in all cells ?
- How to calculate cumulative values
- require macro or code for purchase order to do the following:
- Days to Years ? How
- IF Function
- something more than vlookup??
- advanced lookup/index-match problem
- centering items
- Lock the cell once enter the data
- Lock the cell once enter the data
- Blank Print
- New user needs HELP
- IF and Date Functions
- hi - is there a formula that matches text in different columns?
- Print mutiple sheet macro
- Count by date and hour
- Degrees
- How do I set up a 6 day work week in Excel?
- Question about SumIF
- 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates
- large page number in cenetr of sheet
- NETWORKDAYS calc with 3 columns of dates
- Copy data based on a count...
- Copy PasteSpecial not working
- Searching for duplicate numbers
- Updating Info from a previous worksheet
- median, frequency or histogram
- how to transpose forumlas
- microsoft excel
- Assigning consecutive dates
- Connecting of two data validating with each other
- How to hide running total in successive cells in a column
- #VALUE! in Time Calculation
- MAJOR Worksheet Dilemma
- Loop through folder of workbooks and add rows
- Rolling over the icons does not show information.
- Using an array range in GETPIVOTDATA
- Is there a way to find the address of a cell with a certain value?
- Function help
- Help on a function with Conditional Formatting
- Can you save add-ins information in a spreadsheet
- if function help
- if question
- Use an If Sum
- How to do a cartesian join in Excel?
- Wordart in Excel
- color page display black and white
- Why is Paste Formulas option is acting like Paste All option?
- How to add a suffix to a whole column of different part numbers?
- Can I use an array function to solve my question???
- Find the previous Weekday (thursday)
- Matching 2 lists
- Displaying Outlook toolbar in Excel
- Ctrl+Alt+F9 not performing Full Recalculation on some PCs
- date reading formula question
- How do I turn 'update links' back on when turned off?
- Link from a specific Cell in Excel to a specific para. in Word
- CAGR
- What does "No more new fonts may be applied" mean in Excel?
- Formulas
- Conditional formating a row
- Conditionally Formatting/Code Only One Word in a Formula
- When I sort an excel spreadsheet the data disappears.
- Merge two files and then allowing deletion of duplicate cells?
- Custom AutoFilter
- Reference workbook name
- Minimum Exam Score Calculator
- array formulas and getformula UDF
- page total
- how can I trap the change event (Tab Press key) of these controls
- how can I trap the change event (Tab Press key) of these controls
- List of Control functions
- what is PAR in the Yield Function
- Adding a date when something was created.
- sumif with criteria
- SumProduct Returns Zero
- importing a particular excel worksheet into another excel file
- Strange Data Look Up Problem
- MMULT
- Excel Throwing Circular Errors When No Errors Exist
- Sorting large worksheets
- Formula to rank cells alphabetically
- Links
- IRR function
- Hiding/Unhiding Columns
- VLookup & Case Sensitivity
- how do I count the number of gray-shaded cells within a range?
- changing x axis of column graphs
- How do I set up an Investments Trading and Cash Template?
- delete empty rows in workbook
- Product type function H.e.l.p
- Sumif Problem
- Multiple Lookup and CountIF
- Lookup between two margins / brackets
- number comparion function
- Edit Links Trouble
- Autocopy of data filtered by drop down list
- Importing a file(s)
- Page Break Preview Problem
- Extract specific value from a long text string
- Vlookup problem...
- Relative Cell Reference
- Help! I need multiple formulas for one cell.
- How can I convert a group of numbers to a group of letters?
- Finding Missing Data
- Multiple criteria
- Selecting Multiple Columns in a Named Selection
- find cell function
- Matching multiple columns and retrieving a value
- Accessing Attached xls File
- Index function
- Lookup?
- formula to add cells in multiple shts in the same wkbk
- Time sheet calculations
- Drop Down Box font size
- Changing the date format in a cell
- How do I add all "B1" cells on each worksheet?
- Add a guidebar in Excel
- Offset question
- VLOOKUP from Access Tables
- Fun With Functions
- Function that searches cell for string?
- getpivotdata refresh problem
- MATCH() and duplicate values -- is there a workaround?
- I want to be able to type vertical text on an excel worksheet
- hyperlink: back to last worksheet
- In Excel, conditional format (font red) referencing another cell?
- Lookup Array Calendar
- Put filename in a cell
- Reverse a spreadsheet reversing columns and rows?
- in excel 2003 a formula if cells have 0 = n 1-3 =s 4ormore=s
- How do I get rid of #REF error, imported Data changes
- Can you automatically filter for unique records?
- Please help iwith formula....second try....
- Variable column to fixed array
- How do I get tab to move the cursor one cell over rather than 8?
- Searching for the nearest value
- Problems with SUMPRODUCTS
- Conditional Sum Argument results do not equal cell results Excel
- how can i set more than three conditional formats to xl worksheet
- no comma separator for ="total"&"$ "&sum(a1:a10)
- named range help
- Is there a way MATCH() can cope with duplicate values?
- ﹎ 專收手機,保証最高價!
- vlookup Function Help Needed
- Look up based on Column and Row headings
- Can I group overdue Invoices by date from an Excel worksheet?
- What is the exact equation used in ToolPak t-test (unequal vari?)
- to-date total based on current date
- Or function with invalid number "zero/zero"
- Help with Match() function
- Cell Displays Formula, not result
- Help
- Lookup certain text within a cell, PLEASE HELP!
- formulas and decimal places
- text and numbers in cell
- Help
- Help
- How do I hyperlink from Excel to Outlook for a specific Contact na
- Workdays Function
- IF function
- Excel Charts
- Reformat A Time Value To Add/Subtract
- Dynamic links within workbook
- How do I unhide the PERSONAL.XLS worksheet?
- Cell Content as Header?
- Pivot tables - text rather than number?
- Provide a match from 2 cells to give a result from another
- type of probability distribution
- Formula result as real empty/blank cell
- Urgent enquiry
- Conditional Average (2 conditions)
- Suming selected cells based on two criteria
- Simple Calculator Problem
- hiding then printing a row
- MULTIPLE (X3) COUNT IF FUNCTION
- excel access will not update time
- Cell link inbetween Asterisks
- Something other than DATEVALUE
- Download excel doc from website, can this be done?
- Adding and subtracting dates
- histogram and macros
- Importing
- Using if function to show blank when cell in other sheet is empty
- Can a cell be *either text or the result of a formula?
- How do I find the cell reference that contains the minimum or maximum
- Accessing Attached XLS file
- Variable in VLOOKUP and referencing a cell another file in excel
- May be Explode is the correct to do this!
- How do I calculate employment service and display as yy/mm/dd in .
- Excel Formula to Calc Daily Averages?
- Excel Division Formula
- convert 7h 40.80n into time format
- Secret Code for Confirmation
- Spreadsheets
- Question about copying column of cells and......
- how do I nest 3 items?
- What formula figures less than & greater than?
- How to change empty ranges from a plot series without generating e
- 60% formula
- How do I sort locked cells in Excel?
- How Do I increase a date by 90 days?
- What does the double dash or "--" do when using it in a function? (and other questions)
- Need help with a Multiply Dependent One Cell Formula
- Macros AND Buttons
- How do I get the text to WRAP in my text box??? thanks...
- Re: error when running cut & paste macro
- Let me explain my problem... (Roommate Accounting)
- table, index, array, match, lookup?
- Updated Function Question
- copy & paste and change format
- how do I change cell references in a column
- Force "+" sign
- Can this formula be placed in VBA please.
- Return the column
- Repeating Columns
- RE: template for farmers
- Calculating difference between two times
- RE: rounding to multiples in excel ?
- I am trying to combine contents from 2 cells into 1
- Fomula (if?)
- Removing Blanks
- Bin, Distribution multiple objects???
- help with array
- Can one count cells having a certain format? i.e. using countif?
- Automatic Formula to Value Conversion
- how do i do a highlighted formula?
- Usernames and Passwords--Thomas Homan
- Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
- Can a header be applied once to a workbook & print on each page?
- Running Excel 2000 VBA Application on Excel 2003
- Multiple Correlations and Multicollinearity
- Importing a file
- Using Index Match etc. for price list
- VBA CODE range
- Choose date from drop-down calendar
- formula help
- Nested Formula?
- range only if A3=1
- range only if A3=1
- Split mail merge into separate headed columns
- Is This possible?
- Pivot Table Refresh
- Is there such a thing as an "if" command in excel?
- Text Import Wizard
- Modify array function length
- Auto Filter
- VLOOKUP example not working...
- I need to use the sumif for a workbook, not a worksheet
- Average-Range Change Each Month
- How to Add Rows From Active Cell with in a XLL Code
- Inserting new row but keeping formulae
- Using Comma in customise option
- how to calculate the number of non blank cells from any column?
- a problem with blank lines
- looking up values in 1 column based on 2 other columns
- how do i enable a drop down list depending on result of "if" funct