- change the calendar to reflect the current year
- change the calendar to reflect the current year
- Sumproduct error
- Text vs Number format
- Make Custom Macro always Available
- Summing cell totals across columns
- 2 different ?'s: Date? Macro?
- UK Postal codes in Excel
- What is the meanding of the term • Financial Functions
- Formula to count numbers
- average values in non-contiguous cells, ignoring 0 values
- Pulling data
- Writing a Marco
- Linking Sheets
- Format Cells - Hyperlink
- Can I set up a default footer that will appear in every spreadshee
- Alphabetizing in Library Format
- Macro problems
- Importing local OLAP cube in Excel 2007
- Excel math formula
- Can i set up tabs within tabs on Excel?
- Lookup and change to italic italic
- Sorting a Soccer PointsTable
- Link
- lookup on Table including blanks -
- Formula Too Long
- vlookup on 3 different tables - please HELP
- copy formula every x rows
- Use custom format to add text to a text entry.
- "Magic" Formula
- Matching Quarters
- Quarter Dates
- index_match_error!
- formula for counting
- How do I get items from sheet 3 to show up on sheet 1 and 2?
- weighted scores
- How do I make JUST the header row always visible in Excel?
- Tracking Check Boxes
- conditional formatting error message
- refresh option of pivot table not working
- SMALL() on unknown length of list
- go to last filled cell in a column shortcut
- How to set up an excel formula to copy cells to another worksheet?
- "Replace" problems
- How on Earth do I use the GHK Function?
- Last entry in a column/row function?
- entering same formula in multiple sheets
- Formula works but formula shows in cell???
- IF across multiple worksheets
- Is there a Way to Find the Cell Row and Column From my UDF
- formula that sums cells yet does not round the number up or down.
- Quickly Review Data
- Yes and No
- auto input
- Drop Down List choice selecting another drop down list
- look up sequential cells
- How can I concatenate a number and preserve the formatting?
- MATCH FUNCTION AND SERIAL DATE CONFLICTS
- When I open a file in excel, I cannot open any of the sheets
- Help with SUM and IF
- text box
- Auto e-mail message
- How to concatenate an array of four stings using formulae (not UDF)
- Fv
- FV Calculation problem
- convert time functions to numbers
- Read only files? Lost tabs on worksheetstoo!
- cannot paste link using equal sign
- Any macro experts out there?
- Worksheet naming using visual basic
- Text to rows...at wits end
- Send e-mail from a Excel file
- Filtering using Formulas
- Stop Excel from evaluating formulae unless I want it to
- How do I selectand copy only subtotals in a sheet
- Maximum length of a number
- Splitting cells - please help!
- Move data
- Date Interval Predictions
- Format Date
- How do i calculate the saved amount ?
- Conditional formats using more than 3 conditions
- Show input box with cell value
- How do I calculate Return on Investment in Excel
- How do you protect Headers and Footers in MOFFICE
- How can I get a cell to Flash if it meets a certain criteria in Ex
- MATCHING DATE TO A WEEKDAY
- cancelling getpivot formula when setting formula outside pivot ta.
- Advance Sumproduct calculation
- Excel Group & Sum function
- Can the contents of a drop down box differ from what's entered?
- Match cells with cells on another workbook
- Looking up a value from one cell in another range of cells
- how to change the insertion point color?
- Soundex converter formula?
- How do I seperate a full name field out into three seperate columns?
- I need to add check boxes to my Excel spreadsheet,checked and not
- NULL Cells
- BackFill Zeros
- COUNTIF
- Same page with Different Page numbers
- use track changes and macros
- Referencing another worksheet via a cell
- Help please - looking for a formula
- Count cells in a column that has a autofilter
- Lookup and summing comparison
- how can i capitalise text in an existing workbook
- How to create Cascading Drop-Down Lists?
- Filling values in a grid
- Date determination and sums
- lotus 123 worksheet function conversion
- How can I use Excel to mark student's tests?
- Restricting a Spreadsheet so users cannot save changes
- Sumproduct value error
- Restricting rights to save a spreadsheet
- Array formula with a constant?
- Need help with COUNTIF
- Counting cells with multiple data
- Looking Up Datas when Key Values are Identical
- Find String in another string - only between spaces
- countif Column A and excule column B if it's cancelled
- how to use GETFORMULA() in EXCEL 2003?
- Function Key for Calculating Average?
- Does anyone know if there is a symbol for the "except" in formula?
- SUMPRODUCT, COUNTIF and wildcard
- vlookup returns bad data
- Wildcard character inside sumproduct
- Ask user for information
- Auto Navigate Cells
- Array Fromula
- text box linked to cell
- Worksheet, selection macro
- Eliminate second browse box when right clicking for hyperlink
- percentage completed and colors
- Hi--how do I scramble a list randomly?
- Help - Looking for a Sumproduct formula
- RE: How to switch position of columns and rows respectively?
- Not getting messages in OE
- Re: How to switch position of columns and rows respectively?
- How do I get Excel to open email for single sheet?
- How do I set up for greater than 3 formats in excel?
- Re: How to switch position of columns and rows respectively?
- Drop down dependency stuff
- how can I multiply number of hours and minutes by hourly rate?
- cell value<>presented value
- Formula to subtract values in one cell only...
- Formula to subtract values in one cell only...
- I need conditional formatting to apply to maximum %
- MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING
- How do I work with swedish excel 2003 that uses EDATUM
- how do I write an IF/other statement to cut off time data?
- Is there an easy way to find/display merged cells in excel
- Resize the Check Box ActiveX Control
- How do i protect specific cells in a shared workbook?
- Can COUNTIF be nested to search two ranges
- Sumproduct question
- Combining two work sheets using a column in both as a key
- How do I change hyperlink targets in a group of fields at once?
- Get count for a table of dates
- how to apply the same header or footer to all sheets in workbook
- How do I use the (=) symbol for cut/pasting in excel?
- in Excel, how to put gridline every ten rows
- Vlookup
- Fixing a Total on a page
- Change the "Insert Function" display for mail merge
- SUMPRODUCT
- Excel won't calculate formulas unless I press F9 - HELP!!!
- Paste Special Not Working
- combining text and numbers in a string
- How do I create a unique spreadsheet reference?
- show current value
- MIN function
- Repeating an Excel Formula
- Finding how many events since last occurence in a database list
- using IF statement to compare text
- How to link a cell in date format without displaying it as 0-Jan?
- Conditional Formatting on one cell based on value in another
- Searching a range with MS Query
- Sumproduct(N and --
- N/A
- How do I get excel to sum a range without including hidden cells?
- Simple excel question for newbie
- Link Excel to Access
- INDEX/MATCH Functions with row-arranged table.
- Calander in Spreadsheet
- lookup function, returning the same format.
- Warning text triggered by values of a cell range
- Offset.
- How do I fill mutiple cells with one pull down menu?
- putting a number that is greater or lesser into different cell .
- Need help in formula - IF + Find + Vlookup
- Adding rows without the links moving
- Automatic Update of Dropdown List Box data
- Restricting Duplicate Entry
- smart tags
- Add sheets using macro
- IF function
- Countif Limit
- each number in cell should be 10 digit
- Excel 2003 Functions
- About workbook_Open madro
- grouping
- Hyperlink Problem
- do not copy data to another sheet if exists
- function
- EXCEL
- Auto Fill from Drop Down list
- Formula to calculate 401(k)
- Factoring
- protecting formulae!
- SUMPRODUCT + CSE
- IF Then HELP!!!!
- VLOOKUP problem
- drop down box
- VLookup does not work with "("
- Text Function
- Pivot Table Conditonal Format of the Grand Total
- Vlookup with 9E+307
- Hiding Specific Rows Based on Values in Other Rows
- Copying Formulas From One Column To Another??
- Pasting data with hidden columns
- HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
- date
- EXCEL formula
- Generating random numbers with the occasional outlier
- Why are my formulas not adding up automatically
- How to copy rows that meet criteria to another sheet in Excel
- Rounding results by ranges
- how do i change row font color based on cell value in that row
- Calculating Mode for multiple arrays based on criteria in another
- dynamic vlookup?
- How to ALWAYS have footer automatically?
- Conditional Counting
- need help
- How do I change fraction to fraction characters?
- using nested OR
- I'm trying to import fields from one Excel file to another
- Can't Access Paste Special Anymore
- Most resource-hungry functions?
- How do I lock/protect cells so they can't be changed
- Create mutli-level subtotals
- SMALL(IF( across multiple worksheets
- Create a function to calculate Mean time Before Failure
- Paste is acting up
- Dates That Change
- Count Non-Blanks in one column based on criteria in another
- Time difference - again!
- need scenarios function to running MPS for production planning
- SUMPRODUCT- double unary vs. *
- Formula Help Needed
- entering a matrix that contains formulae
- how to do matching 2 criterias
- How do I copy and move selections of data to other sheets?
- Command Button
- Excell Macros
- Calculations based on cell value
- how to set column check
- Date To Quarter, Plus Next 3 Quarters
- automatic passage to next cell
- relative reference when creating a link to another workbook
- Driver Hours Of Service
- help on indirect()
- Excel 2002 - Internet Explorer Windows opening up uncontrollably
- Excel 2002: Merging cell content with a comma seperattor
- In excel can we prevent the column width from change
- If statement
- Excel File Double's in size?
- MSNQuotes.Function Add In
- Enter text and formula in a cell
- how do I make excell show time values greater than 24 hrs?
- Is there an "Appear Behind Text Function in Excel" for a picture?
- Numbers not adding together correctly
- Conditioning??
- Return a value
- Parse an email address
- Parse an email address
- If lower, highlight
- I want to hide values if no data in target cell
- Use Excel to randomly generate selections for cyle counting?
- Formula to detect color?
- Grouping with a pivot table
- how do I put in the IF function only integer as true values?
- End of Year
- Columns to rows
- How do you represent a=t1+t2 divided by t3+t4 in excell
- formula for text string
- Formula to extract a specific word from text string
- IF THIS AND THIS BUT NOT THIS!?!? HELP!
- 12 Month Average
- Find and replace numbers using a formula
- Worksheet function?
- flaging items as "org","dup",etc.
- Help with Custom View
- Tip(s) from Excel User Conference
- Finding multiple values of a function
- How do I calculate within a range?
- Problem with VB string character limit.
- How do I show only the last portion of text in a multi line cell?
- How can I change 080402 to 08/04/02?
- ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE
- How can I paste a worksheet to an other program through a HYPERLIN
- Rounding Up in Cells With Formulas
- Major Goof, I deleted data HELP
- Conditional Format & Formula
- selecting using option buttons in excel
- Has anyone a template for a surveyors field book
- Excel not recognizing equal values
- lowest number in a set EXCLUDING zero
- excell search function
- Jump to next cell after selecting from drop down list
- Is there an easier way to pull URLs out of Web Query?
- HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
- Is there a better way?
- How do you calculate text into numerical answers?
- selected extraction of cell ref in a series of cells in a row/colu
- How do I make a spreadsheet w/ original price and then %?
- Protect Sheet but allow sorting
- creating formula help
- Changing hyperlink addresses (global)?
- looking to create a time + text history when a button is clicked?
- how to collectly put data in each cell from magnetic card reader data
- Lost all my worksheet tabs on excel
- How to count occurrences where 2 columns are required to be true?
- Sum Cells Based on Condition (2 problems)
- NEWSGROUP QUESTION URGENT
- NEWSGROUP MESSAGE URGENT
- Compare
- Make Function ignore 0 and error values
- How do I prevent saving an excel file if cells are blank?
- Sum a range of cells starting from an offset date list from TODAY()
- Add sum of cell from another worksheet
- Counting
- sumif with 2 condtion
- Lost my built in menu bar in excel 3
- VLOOKUP weirdness
- Displaying trendlines in legend (or not)
- automatically move cell data in 1 workbook to another workbook
- Is there a way to change Lowercase or Proper to ALL CAPS?
- Evaluate a column and extract last value
- #N/A
- adding quotations / brackets
- Delete rows that are empty across columns
- User form problem
- to recover deleted work sheet from file
- How to skip the blank cells for calculating StdDev?
- Simple VLOOKUP problem
- I want to get remaining text after using LEFT function
- How to skip the blank cells for calculating StdDev?
- Create formula in VBA
- Re: conditinal If statement with 3 outputs
- Generate random number from a list
- Help finishing array formula!
- Cell reference
- What if delete sheet is whited out?
- Can you write your own NETWORKDAYS function?
- Creating a Vendor ID from Vendor Name...
- Find Numeric sign in a string
- Any way to shorten this up?
- AutoSum
- count entries
- use field data from 1 pivot table in another?
- use field data from 1 pivot table in another?
- Using macro to select a range
- Lookup Function Referencing cells, not text values
- I was trying to protect a worksheet and my outlook tool bar is loc
- Weighted average question
- Getting #VALUE
- delete worksheet
- How to input 'Used time' data ?
- Nest vlookup within large function
- sumif in Excel2007 on Vista doesn't work.
- Automatic evaluation of custom worksheet function
- how to view sage tool bar
- MultiCriteria for Conditional Formating
- Conditional formating between 2 workbooks.
- percentages
- Using the MATCH formula and list the duplicates
- highlighting changes by color in an Excel column
- RE: Display the source for a pivot table page field
- Average
- Array problem - TIA
- IF Date formula
- Calculations in Pivot Table.
- double match formula
- How does one turn off gridlines only in a group of cells?
- Two columns of data in pivot table?
- My Auto Sum Function is not Automaticlly summing the cells
- Automatic Calculation Turns Off Intermittently
- Debra Dalgleish Question
- Excel commands
- creating table of content in excel workbook
- How do I merge and replace matching cells from different workshee
- Shared workbook
- Excel 2003 - Simple IF() Formula Will Not Work For Me
- if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG!
- Copy & Paste
- Format cells to pick up the name of the person who opened the excel in a network
- Format cells to pick up the name of the person who opened the excel in a network
- Applying J-Walk's SheetOffset() to SUM across sheets - possible?
- Physical Constants for Excel
- Counting "Question Marks"
- Ranking exam marks
- filtering/autofill problem
- data validation invalid in dynamic validation list
- how to perform a Mann-Whitney test?
- Need help implementing EPA rounding method
- conditional sum query
- Pivot tables - page section
- Re: how to perform a Mann-Whitney test?
- create view tabs
- How to create a copy of a folder having five files in it, & rename
- how can i set a date reminder to check on something in a certain.
- #value error when opening spreadsheet
- Question re: calculation time and Index formula
- Polynomial Treandline Coefficients
- Display results of formulas
- How to make a nested SUMIF possible
- Weird Worksheet Issues
- Excel 2007
- check for duplicates
- How to copy formulas with clustered data?
- calculating decimals
- Why do Excel worksheets imbedded in a Word document sometimes corr
- calculating ages
- Array UDF?
- Reference a cell in another worksheet?
- In excel, how do I enter unique cell information in a column
- Excel spawning a new window when opening a file
- If help
- Finding Location of Maximum Value in 2D Array
- IF statement for time data not working properly
- Dynamic unlock a cell (under condition)
- MIN and MAX Functions
- Timecard question
- Converting Text
- DSum criteria
- Adding an AP to a worksheet automatically
- Wow, never seen this error before (Excel science experiment)
- Go to functionality
- New Office 2007
- Keyboard command
- Invert excel data
- Need to pull a selected segment of numbers/text from a large strin
- formula for +- comparison check Excel 2003
- #Value Error
- Macro to change a formula to a value
- Excel Formula
- Identify the cell with Max & Min values
- Counif multiple condition
- Counting Update
- track changes on an excel sheet
- Data Validation Error
- DATEDIF formula enhancement
- Email Hyperlinks
- Find record
- Paste 2 different things from Excel to other programs
- Excel Functions
- multiple column comparison on 2 worksheets
- Compare And Merge Workbooks
- Need help with a formula
- Autofilter on a worksheet with merged cells
- IF function
- #VALUE error with valid formula
- vlookup with 2 values
- Multiple Configurations Addition for Sum
- Help, my macro always opens up spreadsheet it was created in
- Save button-shortcut
- Creating a form for multiple users
- IF statements with * character doesn't work
- Calculate minutes from timecard
- need help converting text codes to names
- File Exists Formula
- Delay Calculation of Worksheet Functions
- inserting a dash into a column of numbers
- Help with spreadsheet
- Return adjacent cell if conditional formatting exists.
- Interaction of form controls and pictures in Excel 2007
- inserting hard CR in a formula
- Deleting Repeated Rows
- Average If
- How do I prevent editing in a cell based on the value in another?
- Hyperlink Destination Positioning On Screen
- negative dates or times are displayed as # # # #
- Update Value Box
- Counting events since last occurences
- Formatting a row into a column
- Convert a file to an ASCII
- Allllen you rock!!!
- vLookup Help
- lookup
- When data match, copy adjacent value to adjacent column
- Time Function Problem
- Define Name
- lookup
- Separate data and put them into one line
- copying data in multiple sheets
- How do I hide a tab automatically?
- VLOOKUP Help
- Mail Function?
- How do I get the date for the 2nd friday of each month?
- Passwords in Excel
- Any way to have a dynamic range for ranking, based on criteria?
- VLOOKUP with a non-numerical columindex number
- Total of pages
- Recommondation for training sites for Pivot Tables in Excel 2000?
- shortcut issue - ctrl S
- help with database function
- how many times a specific value is in a range...?
- Wildcard character in an "If" statement?
- Dynamic name
- How to force workbook to always open on the index sheet tab
- vlookup problem
- How do I count the items in one column if another column is blank
- #N/A coming up in VLOOKUP when visibly the two cells are same
- looking for auditor tickmarks to add to excel toolbar
- How do I create a popup notification in excel ?
- Userform
- formula exercises
- Conditional Formating - More then 3 conditioned with formula
- Extract Data by keyword and export to new Excel sheet
- improve formula, Possible Genious needed !!!
- Formula Error when entire row is deleted
- Sum function
- VLOOKUP query
- Google search box on excel
- about functions...
- Calulating hours, minutes and seconds
- Worksheet name
- ^ Carrot in a Formula
- copy text A1*7
- Using =TRIM()
- Worksheets.add in VBScript overwrites existing worksheet
- Count the non blank cells
- couting dates as events per month
- Setting up conditional drop down lists in Excel 2003?
- how to use tier system
- how to sum cells from multiple work sheets
- Using an offset formula for the reference in a relative reference
- Pulling text from a cell
- I need an If statement for Excel that excludes empty cells
- search and sum
- How to set the time as condition within if statement?
- How do I count in column A when it meets all criteria in three col
- Replace all empty or " by the content of the cell above it
- Formula for copying tap info into a cell
- need help with conditional formatting 3 criteria
- How to Subtract times on 24hour clock and avoid error message in .
- Conditional Formating A Row
- Advanced Filter for multiple criteria, including blank cells
- List all sheets present in Workbook
- how to work out an age from a date of birth
- ARE THERE CONDITIONAL FORMULAS TO CHANGE TEXT COLOR?
- Which function to choose?
- Can't figure this out!!!
- between dates
- Summarizing in Excel
- lookup
- re: which function to choose?
- Enter a new name in the Name Conflict dialog box
- Conditional Formatting Formula
- How to return a value if a range (not a cell) contains a certain v
- Moving cells
- COUNTIF FUNCTION
- Using a comparison and taking data from one sheet and putting it i
- insert row into worksheet when date missing
- LONG IF (diff columns) STATMENT(s)
- How to trick a Dynamic Name to be Static when SOLVER is ON...
- Copying named lists used in drop downs from one workbook to anothe
- Macro to pull from different applications
- Formula Macro
- How can I set up an auto return to the next column in excell?
- how do i set up a weekly scedule in excel to track time worked
- Nested If statement to find greater than but less than numbers
- Excel 2000 versus 2003 and the TEXT Function
- Excel 2003 - How do I sort subjects in a worksheet by column?
- WORKSHEET FUNCTION or PROGRAMMING.
- Changing worksheet names
- Sumif with two criterias
- Write HTML Scripts On Excel
- IF function
- Add Between Two Dates Q
- IF and OR functions to obtain text descriptions
- Do I need SUMPRODUCT?
- Count the non blank cells
- How to subtract 2 dates to get number of days.....please
- Looking for help to build a predictive sales model
- Way to conditionally hide rows?
- Macro to search a website from a cell
- Functiono that copies a charts format
- Function that copies a charts format
- Function that copies a charts format
- Worksheets with password protection
- How do I enter a formula in a cell that changes per another cell's
- How do I count cells with a specific cell shading?
- Sheet Reference is not working
- 2 sheets 2 rows grab 1
- Excel Formula
- Countif & "AND"
- help with formatting a sheet with text and numbers
- Displaying negative time in excel
- cell displays function not value of function
- should it be if() or another logical function?
- n00b Q - Regarding the inner workings of pivottables
- Conditional Formatting
- Add a Sheet From a Previous Sheet Macro
- Way to Concatonate cells in a row based on the order they were entered?
- Bringing together multiple columns into one from least to greatest?
- Getpivot date w/ relative reference
- vlookup with dynamic table_array
- Default cell name and value
- Remove the fomula...?
- Can Excel do survey cross-tabulations?
- VLOOKUP with IF function
- linking (?) fields from one worksheet to another?
- Pivot Table newbie help..
- lookup formulas
- Index,Indirect, and Match
- OR function
- Export Excel Calendar to Outlook
- Sorting a Spreadsheet with locked cells
- maro to save wooksheet & open in sheet 1
- Last Cell in a Column Value
- how do I use OR in a way that true return calculation
- Formulas
- SumIF
- finding the last row in another worksheet
- Last data entry made time and Date show in each worksheet
- import excel to Access has a problem with text field
- return a collum heading
- All Worksheets in a Data Validation combo
- Incresing % per annum
- sum
- Attandance counting
- Read worksheet in excel
- changing password in Excel workbook
- How to clear content from unprotected Field
- Indirect Function
- Copying Worksheets
- DCOUNT with different files
- eliminating records!
- Lookup in array formula - loss of inspiration
- add OR to already nested If function - help required
- EOMONTH() question
- excel date scheduling not msProject
- Conversion Formula
- vlookup shows result one cell above the expected result
- how can i set up rand or rand between to give only -1 or 1?
- Lookup multiple results with gaps
- Lookup multiple results that has gaps
- Lookup Multiple results has gaps
- Lookup multiple results with gaps
- SumIf for Variable Conditions
- Can I create a line graph based on a formula
- Report Help from Bagram
- HOw to create a pivot of pivot tables
- REF# error on summing ranges
- number patterns
- Pivot Table Problem
- Spreadsheet name = cell content?
- looking for one value in a range of values
- Automatic text
- Help with an Excel formula please?
- how can I increase nested function 'IF' in EXCEL upto 10 levels
- eliminating matched records!
- headers in worksheet
- Macro Button
- Partial match lookup question
- VLOOKUP Help
- IF Function
- Remove content when saving / loading spreadsheet
- Auto Send email from IF command
- What formula do I use to count if value in other column?
- Need Help With a Excel 2003 Formula
- Disable copy paste option on a particular cell
- Partial / Conditional Sum of a Column
- How do I change automatically figures into words in Excel
- Arrays/Functions/Different datatypes in a formula?
- sumif based on cell comparison in excel
- Image (object) offsets in Web show mode
- Problem to close a group of columns
- formula 4 number of cells/rows in a range
- handle #VALUE exception
- Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2003
- Comma Deleted File into Excel doc
- Months
- keyboard shortcut for Σ symbol?
- default name and value in input cell
- Creating a Subset Report
- How do i stop numbers stringing together ? AB
- Vlookup in a pivot table
- Amaising for me, IF condition
- Summary File
- Excell 2003 Charts
- How do I delete object "Calender Control 11.0" ?
- need help with counting...
- Count & Multiply Months for Hours Budgeting
- matching columns using text strings!
- Months of review
- Database Functions
- FIND type mismatch error, but don't see it
- Average Functin
- disregard a cell on occasion when there is text in it instead of V
- How do I use nested countif statements?
- Lookup and populate question:
- Copying charts from excel into word
- Need to Extract Data from Spreadsheet
- Formula to Return Last Non-Zero Value in Row
- headers
- Data query failing
- sumproduct?
- Conditional statements: how do I make reslts show up in dif cell
- Access Queries into Excel
- where do i find create list in Excel
- array formulas
- Pivot Tables - Showing Details for some fields, but just summaries for others
- How can I Automatically refresh the NOW() Display in EXCEL?
- barcode macro
- Pivot Table or something else?
- HELLO
- Capitalizing Letters in multiple column data
- How do I add a zero in front of a text formatt number of 5000 reco
- How do I add a zero in front of a text formatt number?
- Sort Function
- formula to identify exact point where trendline intersects data
- combine 2 files into one
- Joining IF Statements
- If formula maxed out to 7, but need 1 more. Help ???
- Using AND or OR in a IF formula
- Data Columns to table
- Need something more than Conditional Formatting
- I need help fred smith
- Omit some cells, when take print
- Formula With Several Conditions
- Enable copying function
- Naming worksheets within a macro
- Excel query about Lists
- Using dates as data in Pivot Tables
- Why is the font printing smaller than it should?
- To find Multiple values in column B for a unique value in column A
- Formulas!
- Vlookup - Returning Additional Values
- where to put results of find operation in find and replace functio
- Absolut Value
- Any Functioon available..?
- how do i setup vlookup to look up in a different excel spreadsheet
- Sorting
- Data validation & Printing
- Workbook formula in a macro
- Funciton to Lookup First Post in a Column
- Is it possible to use a cell reference to define the database?
- Combining functions AND and OR
- Fill a cell by selecting a value from a list
- {=SUM()} vs =SUMPRODUCT()
- Convert hard keyed/formatted numbers to dates
- Condional Formating
- alphabetize - automatically
- Advanced Sorting - urgent
- Advanced Sorting - urgent
- Exporting Current Access data into Template?
- Lookup
- Time conversion in Excel
- account for weekends in date formula
- How do I remove unnecessary vertical page break?
- conditional formatting for cell date to equal today's date
- Time without date
- Even Distribution of Students now with a Weighted Twist
- Combining subtotal and sumif functions
- change a decimal into seconds
- Calculate date based on last column used
- anyone pls. help to pivot ???
- How do I convert 4'6" into decimals?
- Irregular Payment Functions
- Time Sheet
- add a number every two weeks
- Nesting functions - Countif ...
- Index function to find nth occurrence
- Help with database formula.
- excel positioning in Points for vba shapes
- How to set the time counter?
- how to format cells having text and numeric
- if any of 3 conditions is true, then answer is true
- Days from.
- cell with value returns that value, empty cell returns zero
- find a specific cell from the entire worksheet
- Compare and Extract
- COUNTIF
- Outlier analysis in excel - trimming means
- Auto sorting
- Filling Excel forms
- Move text that is a specific color to a different cell
- Text, IF and dropdown function
- Copying Formulas
- Problem with Geomean Function
- Number*10 multiplicity
- Copying Data from Access to Excel in a macro
- custom number format
- Can future dates on Excel be managed in Outlook calendar?
- How do I activate the auto return function in Excel?
- Conditional Formatting with Colours / Colors
- Wildcard characters, IF functions
- A ? for our Excel Guru's and MVPs
- IF function
- Changing a linked formula ... ... ...
- Count number of digits in a cell
- Hiding Formulas
- Worksheet Protection
- Counting the number of errors in a worksheet
- How do I get gender, race, age percentages from my spreadsheet?
- How do I create conditional excel formulas?
- closing file with multiple windows open
- MULTIPLE CRITERIA RETURNING SUM OF RESULTS
- MULTIPLE CRITERIA RETURNING SUM OF RESULTS
- referencing a control within formula
- lables from excel
- IF function using dates as cell references
- Xcl-create subsets of a set of numbers w/o duplicating the subset
- Breaking down days between dates
- calculating a price
- Multiple if statements in a sumif function
- Apply Colors to Worksheet Tabs
- Is there a formula can get min value of a range by certain conditi
- Formula result in different cell
- formulas
- any free add-ins?
- Fill Color on error
- How do I calculate age from birthdate to present in Excel?
- sumproduct date calc.
- Easier Match/Offset?
- conditional formats based on If
- lookup data and fill cells
- Jump to link worksheet
- Data Validation drop down boxes, retreiving numbers
- Use date modified to change format & create filter to track change
- appearance of a concatenated value
- appearance of a value arrived at by using CONCATENATE and ROUND
- moving part of information from one cell to another...
- Counting entries
- RE: Copying Formulas
- simple currency addition in cell without having to enter decimal
- Re: Copying Formulas
- Convert month number to string
- How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO
- IF worksheet function
- xml
- Auto Running Numbers in worksheets or workbooks
- Wildcards in hyperlink formulas
- How do you calculate logistic regression.
- Summarizing Column Data
- conditional formats for cells
- Are there equivalents of wildcard characters to use in hyperlink f
- conditional formatting
- zrušen* mezery v č*slech 20 000,00 na 20000
- Keep function result after removing referenced column
- Function to select random values from a list.
- Problems adding a column
- RE: Functions & Formulas
- =LEFT(J16,1)
- Average Days Open IF between dates
- How to average values based on a condition in another column
- Looking for excel function to convert hex to Ascii
- How do I put a toolbar button into a worksheet?
- Using two values for lookup
- Counting the number of "#N/A" errors
- Excel extended desktop options
- Sorting data from multiple worksheets into a master sheet/tab
- More About Breaking Down Days between Dates
- Help on sumproduct returning errors
- what is a formula
- Pivot Table Import Link to Numerical Values
- Need simple IF formula, please
- change date format.
- EOWEEK --- similar to EOMONTH
- can I sum one column if the value of another column is ex. "M"
- Percentage formula help
- lookup function for multiple worksheets...and then 'some'
- Counting the number of Error Types
- Date formula required
- Multiple values to report a third
- finding like values in multiple excel spreadsheets
- Using Contents of One Cell as Index into Another Cell
- Counting cells with blank adjacent cell
- HYPERLINK friendly name problem
- Another IF statement needed
- FORMULA TO PICK NUMBER
- exact value from supplied Row and Column data
- #NAME error
- Conditional Number Formatting
- What does ISERROR look at besides the 7 Error Types?
- Parameters wthin Query of External Data
- IF AND statement
- formula: count if not blank
- Grouping a range in pivot without standard to from
- Complicated Formula - I think
- A formula to use the greater value in a field
- multiple > < and = question
- Cut and Paste, VB
- delete rows in range - macro
- Formula to higlight highest and lowest values in row
- Pulling information from one worksheet into another
- Help with Comparing values and retrieving values in Excel!!!!!!
- any problem here ?
- curve! function
- RE: test
- Bob P. and Roger G. --> IF(and(...IF(OR( vs. IF(Boolean
- SUBTOTAL function to average column without blanks
- Complicated VBA? Moving filtered data....
- xml
- sheet protection - only selected range to be able to select/input data
- Sumproduct issues
- How can I round to a 0 or 0.5 in Excel?
- delete grid lines
- ?
- In one appl. I have lost the vert. scroll bar.Tools no help
- Can I envoke change tracking on a password protected excel file?
- vlookup with sum
- TRUE - Boolean vs. Text
- Counting repeatation
- calculations on conditions
- how do i set date as 1st thursday of every month
- Date Update
- Indirect ref in array formulas
- Area Codes
- Formula with text and numerics
- Excel Addin:Setting the range to the Excel.Range object range prop
- workbook and worksheet text as table_array
- Will 7 IFs remain ?
- Getting info from individual sheets into master sheet
- any limit?
- Excel formula question.
- i zoom to 75% on Excel but returns to 100% reopening file
- Team Role Rotation (number of team members is variable)
- Subtotal Order in Excel 2003
- tab naming
- Simple Macro
- Dsum or SumIf
- Sumif for multiple tabs
- Pivot table error
- Forecast function and Date option
- SUMPRODUCT works on first cell only...
- Sumproduct question
- Column multiplied by single cell
- Summing & Tallying-up
- Counting # of days worked
- #2: VBA to Pick Range and letter
- finding cell value in another column and returning a true or fals
- Wildcard in Excel
- excel calendar - list of names displayed on calendar
- how do i create a loan with a balloon payment in Excel?
- Different actions on a pivotal value
- Sub procedure in Macros
- Reading Multiple Pages Listing Top three Results.
- SUMPRODUCT trouble
- Dynamic Worksheet Lookup
- Comparing Data from two 2 worksheets
- Test if CELL is in RANGE
- user defined function
- HELP!! ARRANGE DATA MONTHWISELY IN ROWS
- Vlookup with conditions
- Conditional formatting
- How to use VBA variable in COUNTIF function?
- Sending a raw number to a cell from a calculated cell
- Disribute a group of numbers among four cells
- How do I have excel convert fractions to decimals?
- CTRL + END moves to the blank cell where data used to be
- Format>Cells>Number>Text is very tricky!
- Email alert from Excel
- Formula Solution
- Excel date calculation
- conditional formatting help
- sumif query
- ADD THREE YEARS TO A DATE
- Code to Unhide Rows using Macro
- Text=Number
- Workaround for HYPERLINK argument length limit
- Average only first number of actual values
- copying workbooks
- Is it Possible
- missing text after printing
- Number of Staff per Hour Clocked in
- convert arbic numbers to arabic text
- HYPERLINKING WITHIN A SINGLE SHEET
- Changing the cell contents from decimal to fractional
- Move exact information in a row as you sort a column
- How do I create column headings at top of every sheet?
- How do I combine text and a calculation in the same field?
- sorting
- data validation list - Lengthen ? Posible ?
- Sorting a Column and taking row information with it.
- call excelsheet within excelsheet when user clicks excelsheet ico
- Working with data from two worksheets
- Array Help
- How do i repeat dates monthly over the year
- dynamic table_array in lookup,match & index
- Unconcatenate
- Table_array lookup through a define list
- Adding time
- random number
- Pictures in Forms
- how do i insert rows in a cell
- Flashing cell