- Microsoft Visio templates - Stencil for Visio to create IT diagrams &network design
- count number of weeks missing for each individual in a database
- =IF(NOT(ISNA(VLOOKUP Function
- Offset 2nd ref.
- Workbooks&Cells
- Summary by Months
- totaling data from a drop down list
- Creating a Sheet Index of all Excel Worksheets
- Conditional Formatting with range
- Another Question regarding Multiple Criteria
- Calculating total number of days in rolling year
- Prevent functions from changing when new rows are added
- Double Entry Posting
- autofill limits
- Validation list based on criteria
- Current Month with real date
- Need to alphabetize data from separate cells within same row
- Room Occupied Checker Formula Help
- Printing issues
- PRINTING ISSUES
- Pull data from one worksheet and place in a new worksheet
- Comparing 2 worksheets in Excel 2007
- I need a statemnt to identify sales during each month
- Can I use the subtotal function while a worksheet is protected?
- what does the "carat" character mean in Excel - answer
- creating data points within collected data
- empty arguments recalculation
- Totaling VLookup
- what does the character ^ mean in an excel formula
- Adding a copy of an open window to an excel worksheet
- SumProduct - With Or Function
- INDIRECT doesn't retain data from external worksheets
- Importing data to Excel using a keyboard shortcut
- attendance with sorting
- How can I do this ?
- Countif over a range of cells for various codes.
- Calculate from another sheet - special
- Sum Number of Rows based on Value in Another Cell
- Selcting data from table without repeating plus calc's
- need to input alternate blank rows in spreadsheet
- Calculate Average in pivot item
- Not to inlcude zero in COUNT
- Linking worksheet and multiple cells
- convert text to formula using VLookup
- Don't Display #N/A
- Dealing with blank cells
- help with date formula
- returning the value in Colunm C using Colunm A as Ref
- How To?????
- Conditional IF Or Format
- multipule calculations in a single column
- Precedent lines
- re done Match formula needed
- Stopping a formula once a condition has been met.
- match formula needed
- How do I evaluate whether a character is present in a cell?
- repeating values
- Move data
- Recalling more than one cell by inputting a single command
- Can someone help me with this formula please????
- Adding digits with moving decimals
- ADVERTENCIA DE SEGURIDAD - SE HAN DESHABILITADO LAS CONEXIONES DE DATO
- Frequency of date
- Can I use AVERAGEIFS?
- How to find a particular word?
- Is there such thing as deoncantenate in excel?
- USING SUMPRODUCT
- Access-Excel querry problem
- Autofilter not grabbing last row
- Comparing text strings
- adding next years value
- Membership list: column for no. of over 18s?
- More Than VLOOKUP()
- Conditional formatting referencing multiple cells.
- Excel (2003) crashes when referencing to external workbook in freezeframe
- Conditional Formatting with Time
- upgrading to office 2007
- Splitting text divided by carriage returns
- Counting with conditions based on another range
- Make a cell content not printable
- Text Box with conditional formula
- summing adjacent data in a worksheet
- Adding one to two figures with moving decimals
- Number of hrs worked in a week, based on dates in a different column
- Blank Cells vs. Zero Values
- Counting blanks as zeros
- need help using "RANDBETWEEN" in excel
- Error showing up as #VALUE! in if function
- Conditional Format Formula Help
- Extracting charecter from a string
- Excel
- Prob an easy one: How do i copy a formula EXACTLY as it is
- Excel 2003
- Excel with macros to html covnersion
- BLANK cell as a result of IF condition
- Text Box with conditional formula
- Data validation causing problems when using a data form in Excel 2
- Updating Multiple Chart Titles and Scaling to Identical Values
- Adding multiple intances from several sheets?
- Counting rows that satisfy multiple conditions
- Formula
- Multiple selections of rows & columns by clicking in one cell
- SUMPRODUCT
- RANDBETWEEN PROBLEM
- Adding one to two figures with moving decimals
- How do I advance cell numbers?
- SUMIF Formula
- Time entry auto changes to date and then time ?
- excel formula needed
- how do I copy the page format form one worksheet to another?
- Finding values in different rows/columns
- Trickey SumProduct with Multiple Conditions
- Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet.
- Keeping references while changing worksheets
- converting email address formats
- Excel Macro issue
- How do I add a variable range of columns depending on criteria
- Comparing data sets with +/-1 tolerance using conditional formatin
- Sum (throw out highest and lowest)
- How to calculate a coloured cell as a number for a sum?
- User Defined Function returning #Value!
- How do I alphabetize & concatenate cells & maintain row integrity
- Randomly Select cell from filtered list
- Adding one to two figures with moving decimals
- Sum macro
- Formula Problem in Excel 2003
- Lists, lookup, if???
- Vlookup, COUNTIF, IF or Nested
- Cutting list summary - function??
- HELP! Lookup, countif or if statement
- function help, sumif??
- Automatic Formula Update
- Subtotal of values in cells containing formula
- Cell entry
- Data validation - restrict duplicate value
- Excel Graph
- Adding one to two figures with moving decimals
- formula looking for an either/or solution in same column
- adding moving decimals in more than one cell
- how do i embed an editable word document into excel 2007?
- Conditional Formating multiple cells in 1 row based on a list of d
- Keeping format Data returned in IF Statement
- The code below worked for a few days and just totally stoppedworking.
- Can someone please tell me why my code stopped working???
- formula to add a number to a long string **
- xlsx will not open from Explorer, opens from Excel 07
- I am using the COUNT function to determine the
- Re: Multiple Data Ranges in this Countif
- Formula (off form) that completes form data based on a result
- Manual Calculation in Excel 2007 with Calculate mode set to Automatic
- Find a Value the first Time It Occurs
- use dates to create a summary report
- Formula for summary from two column
- Switch names
- Counting Duplicates Once
- using the 'Convert' function
- Another Stingconcat question
- Sum cells using criteria from a row and a column
- Is anything wrong with this formula?
- Change date format in Excel footer
- using percentile in an array formula
- ??
- Simple I think
- Formula needed please :-)
- Filldown stops abruptly
- collect data from mail merge
- Formula for extracting out text entries
- Cell will not format
- Collating entries from multiple sheets
- Excel Column Widths When Printing
- How do I add multiple comments to a cell?
- Alarm
- Consolidation of Data from more than one worksheet file
- Calculate
- Not responding......
- links disabled ??
- Round numbers to get to the nearest 0.09
- Form Advice
- data in rows not showing in auto-filter drop down
- Row Number
- Conditionally summing data from two columns depending on their value.
- VLOOKUP
- Conditional formula drop down box
- Excel 2007 row markers
- Adding data only if adjacent to cell labeled "male"/"female"
- Pasting into protected cells
- Summ entries using a dynamic sheet name
- Replace data in a column
- sorting
- Returning page-count to a cell
- Spreadsheets
- looking up cell address
- Display file name without the file type extension
- Enter data from same cell in different sheets into a new sheet
- Conditional count if function
- rows disappeared
- Offset/Match when there is more than 1 result
- Excel 2003
- Where is the "File" menu?
- Repalce value
- Opposite direction
- Testing cell value for greater than 0
- How do I link an incrementing file name like reports1or reports2
- Discounting duplicates
- replace cell value
- Counting cells with specific month in
- How do I combine information from two separate spreadsheets
- How to insert the tab name in a cell
- using row number or column letters in formula
- Can I use a worksheet name in a formula?
- pvt table field settings!
- Automatically Record Date in a cell
- Attaching documents to Excel
- days calculation between dates
- Amortization w/ variable interest rate
- how do you total columns that are not adjacent
- Excel in Windows 7
- VLOOKUP would begin one row below what the first one found?
- how replace comma with point in import data
- count how long it will takes for a number to repeat
- count last number appear
- Sumit
- IF calculation
- Validation of Employee Timesheet
- FIND from right to left instead of left to right
- Saving 2003 up to 2007 ?
- Calculate the function in a cell that is created with CONCATENATE
- If Hours >0, If Volume <= 0,(and vice-versa) then....
- Incremental dates based upon specifications
- determine formula for percentage
- If Statement
- Formulas
- count if condition in two columns
- Stopping IF command from entering zero or 1 for blank cells
- How to select one record of each from a column
- Can a customer name from pg1 of a workbook be the Header on all pg
- Index-Match, with Like or some other Function
- how to divide the number in one cell into multiple cells
- Converting standard time to military time
- Date conversion
- SUMPRODUCT
- Conditional Formatting
- vlookup fails, and previous ones also now fail!
- SUMPRODUCT Function
- Pivot table
- =today() = weeknumber
- count - but exclude counting cells with a formula
- Multiple IF Statment not working
- Date to close file
- freeze panes cannot be saved
- need to automate a sheet re-organization
- How to compress an Excel work book?
- SUM multiple criteria
- Using SUMIF to add data between a range of dates
- Conditional formatting on autoshapes
- Vlookup formula
- Return value from a Two Variable Data Table with Dates
- How long for the first group
- Incorrect Total in Excel 2007
- subtotal with sumif nested
- Re: Auto Fill
- Can columns be protecteded by an assigned user?
- Grouping into groups
- Time In-Time Out/No. of Units
- DB Function?
- format
- How to retrive password protected worksheet but forgot password?
- Nested IF functions
- Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
- Next-To-Last, Non-Blank, Rightmost Value in a Row
- Auto fill typing in cells problem
- Sumproduct or ?????
- Counting Unique Names
- Current Yield vs. Yield to Maturity at low prices
- Excel F2 not working...
- projections
- "Cannot shift objects off sheet"
- getpivotdata wildcard?
- modified vlookup help
- Macro to merge 3 rows multi times, columns A:K only
- Formula/calculation returning a 0 instead of actual sum
- Date and User restriction coding
- 25th percentile (cycle time)
- HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
- Why doesnt this work?
- PivotTable Sum 2 Columns
- Count formula
- Sumifs (I think)
- Sort Date Column
- need help writing function
- vlookup and sum- to lookup a name and return and sum of all instan
- DATE
- Condense data for stock ordering
- How do I display results of a summation in the following format?
- conditonal format A2 using value in another cell C2
- Auto save and close
- VLOOKUP formula for multiple worksheets
- Need two different data types to give me a total
- Find Function behaving differently in different spreadsheets
- link values from same cell of 20 worksheets into column on one she
- Referencing the latest entry in a column
- Referencing the latest entry in a column
- Adding hours scheduled for week
- How to count with values from multiple columns?
- Conditional format to highlight only cells with formula, not const
- Comparing values of two charts
- Multiple Time Range Conditional
- Conditional Multiple Time Ranges
- Can't solve simple? problem. Can some genius out there help!
- have one sheet update others in workbook
- Hide Rows or Columns with +/- button above row/column label headin
- 25th percentile (cycle time)
- Amount Owing
- Lines are auto hiding in excel sheet 2003?
- Pricing Chart
- I have a column of numbers, some negative, some positive
- PETTY CASH
- How to stop scrolling in side by side comparison?
- Concatenate email addresses
- if statements
- Timesheets
- Pivot Table Problem
- In excel change color of a range of cells based on a cell value
- Price Comparison formula
- drop down list
- Match Multiple Criteria and Return values positioned above the zero
- edit, fill, justify
- Need formula to return exact match
- Return a name in the same row
- Vlookup when lookup criteria is not an exact match
- Excel MATCH Function
- Sum Multiple Criteria
- date text to change colour when it gets over six months
- Pulling data from another workbook
- Averageif is not working
- Hours and sum of hours
- calculating number of days belonging to each month within a given week
- move data from columns to rows
- Vlookup with AND, OR IF statements
- I have a worksheet
- i want to set conditional format to cells containing odd numbers
- Multiple formats in a cell
- Value Replacement
- How can I use the * wildcard in an array formula
- find a data in a list that have a few hit
- Fun with SUMPRODUCT
- Conditional Formatting on Autoshape
- COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED
- Excluding Cells From Avg Cals Due to Info in different col
- macro adjust
- Complex conditional summing - array COUNT works, array SUM gives#VALUE
- Need to separate multiple numbers in one cell
- Inserting a cell value from an "IF" function
- Conditional formatting of dates in two cells using Excel 2007
- Copy specific data form sheets into master sheet
- conditional Formatting cell wildcard
- Count IF Formula
- Combine Two Similar Arrays
- True false function for alpha data
- how do i turn on side by side in excel
- Greater Than
- Eliminate Duplicate Entries in Order to Create Labels Using Mail M
- Index and References within a workbook
- what would it take to.....
- I selected row 1 and row 2 to freeze and it is freezing at row 12
- my first excel experience (share portfolio)
- Copy sheets into one book
- If Function
- Which function and how?
- How do I roundup to .9 and rounddown to .9
- Quick VBA Worksheet Change Event or Selection Question:
- Function for different array
- median if
- Rows to Columns
- Countif and values greater than zero for a named range
- Error in subtracting times
- Error Messages
- Re: help functions
- Formula based on variable range
- Easy eay to copy / paste a formula in column
- Insert row with a locked cell
- Fill down conditional formatting series
- Format single words in cells
- Vlookup Help
- multiple formats in a cell
- Modify and add extra condition
- Find the maximum value in a row or column with text and numbers
- separating multiples digit in a cell into individual cell
- Can't open excel file
- Function to set Date
- Apply CF to Row after CF was applied to Column
- CF to Row after CF is applied to Column
- CF for Row when CF is applied to Column
- CF Row after CF applied to Column
- Date is displaying 00-Jan-00 when I type in 11/16/09.
- Index & Match doesn't seem to work
- Count Formula
- Using Count Formual with checked boxes
- FVSCHEDULE
- Formula to count the number of boxes checked
- Sumif
- Final entry in array
- If (Vlookup >0) working, but what if Vlookup cell does not exist
- Median If Function
- Help with my Excel database
- replace
- Count ifs
- IF statement based on need to recalculate
- Index
- match first and last name and insert column into existing sheet
- Rounding down with a calculation
- Cell highlighting question
- If function confused with 0.1
- how do i average the 3 max numbers in a column?
- Countif OR Sumproduct OR Istext????
- Last non-zero
- Find the last 4 cell entries in a row
- help with Linking excel
- how do I copy specific rows without copying each row individually
- IF function
- how do I copy every 2nd row
- column A matches f places the value from g in column b what funct
- need a formula
- How do I get random numbers from a certain range?
- Why Excel Does not increment by 2 or 3, odd/even numbers?
- Reduce Fie Size, Speed Up Calculation
- How to lock cells after a certain days
- formula when clicked on gets information form a percifice cell.
- excel help please. Urgent!!
- TIME X MONEY
- How to count rows with changing data
- multiplying
- Hpw do I delete multiple empty rows found between filled rows?
- Count first occurance of text
- Reference constant cells in different files from a master workbook
- Finding the unknown number
- MTD/YTD FUNCTION
- Overtime Calculation
- Help With IF INDEX AND MATCH??
- Help with Formula IF INDEX AND MATCH
- Finding Unknown number
- Count unique with multiple criteria
- clear unlocked cells macro help please
- FINDING THE UNKNOWN NUMBER
- Can cells be split ?
- What's happened to the Sort in 2007?
- Multi Criteria Countif
- Random -Median, finding the next number
- Formula
- inserting current windows user id into a cell
- Rounding up with IF
- how do I save my quick toolbar settings in Excel 2007?
- How do I insert a drop down calendar in spreadsheet?
- VLookup - Showing the values which DO NOT Match
- Converting 0 values to Blanks
- Date in Spreadsheet that changes to random numbers
- Copy formula down - cell references change - result is same for al
- ISFORMULA(Cell Referance)
- Vlookup Worksheet
- IF Function
- INDEX MATCH
- Count if?
- Invoice with Data Sheet
- One Formula Referenced In Many Cells
- Invoice
- Countif with multiple criteria and date range
- Excel 2007:Share Workbook with import live Data
- can hidden sheets be prevented from opening without a password?
- Dynamic name range for use in data validation
- Another Formula Question
- Range with 2 validations
- How do I increment the row and column of a cell in a formula?
- Referencing External files with slightly different names
- Leave final cell blank
- How do you make the INFO("directory") function work?
- Looking for the correct excel formula
- data sort with excel 2002
- Resize image using macro
- Return the current Yearly Quarter based on date
- Date
- Consecutive date calculation involving holidays
- go to a particular sheet Gord Dibben
- Automatic deleting graph segments
- Trying to add numbers that include text.
- Create a document from a spread sheet using data from another spre
- Auto insert of a pivot table?
- I want to freeze 2 columns (not next to each other)
- Hi
- SAVE AS CSV, KEEP DATE FORMAT
- Pivot Table Macro
- Hiding a cell with a formula.
- How do I set up an ordering sheet based on averages of past sales
- Conditional formula for dates
- Simple Question - Sum If??
- Lookup for the first occurrence
- Lookup Formula question
- Concatenate and IF?
- StringConcat(", ",A1:A1000)
- vlookup against one of two options?
- Need formula to round number up to always end in X.X9
- Using solver function in a locked (protected) worksheet
- SUMPRODUCT & Wildcards
- change year in downloaded calender template
- RECOVERING FILES--HELP ME!!!
- How to find lowest points
- Sum same cell across multiple worksheet function does not work...
- Fill Formula please
- Formula problem
- OFFICE 7
- highlight differences
- Copy data to different sheets
- function help!
- How do I formulate total before Gst?
- Sumproduct Subtotal
- How do I Undo a Page-Break in excel
- 2003 Exxel
- Sorting a column that contains both text and numbers
- Multiple Criteria Date Count formula
- histogram dynamic bin count
- Lookup function
- formula help
- Formula Count dates multiple criteria
- Copy/paste data across filtered rows
- Pivot Tables
- Formula Referencing Columns By Date
- Validation Drop Down List if cell meets criteria
- Removing check boxes (forms toolbar)
- Conditional Formatting Help
- Calculate row/column number in reference formula
- Old address information updated to current addressi
- Autofilter
- INDIRECT Function
- Hide Rows based on value, but not using autofilter
- Worksheet formula incorrect after copying to another worksheet
- Apply Filter to source of Pivot Table
- How can I count unique values
- Conditional Formula w/Lists
- Create Formula Using Select Values of a Cell
- Operation requires the merged cells to be identically sized
- need help with a downloaded template that was shared by steve
- daverage worksheet function
- Creating a formula
- i have a 2007 workbook that has a password i need to get it off. H
- How Can I ?
- days calculations
- days calculations
- Multiple worksheets
- Add In vs functions
- Create One Formula for Entire Column
- formulas
- Create Generic Formula for Entire Column
- lookups and sums?
- Protecting data after entering
- Hyperlink to a specific worksheet in another workbook
- Can you insert a shortcut to a different workbook?
- Normal distribution curve
- How to highlight what's different between two columns
- How to Stop calculation on one specific sheets only
- how many duplicates in the one column
- Error Message when I open Workbook
- Vlookup returns n/a for all lines - what am I missing?
- Hyperlink to a specific worksheet in another workbook.
- How to copy a spreadsheet in shared workbook
- Compare List Summary of Results
- percentage in brackets
- Adding cells with formulas
- Concatentate text and insert blank line
- Excel 2007 Move or Copy worksheet
- adding values lists
- If then statement
- HOW TOCREATE A DROP-DOWN MENU FOR MACROS
- Remove Text
- NETWORKDAYS Formula
- take some data column into next column ie ABC-DEF-GHI i want DEF
- Advanced Filter Question
- Formatting cell
- Multiple IF/AND/OR statments
- Working with Excel to control stock
- sumproduct with multiple variables
- average sum of 5rows
- multiplying by variables based off original number
- 12 dependent series
- Limit access to range of cells
- simple counting gone awry
- Workaround no COUNTIFS in 2003
- Help in counting and summing cells based on multiple conditions
- data entry needs to be changed in multiple files
- The ____ qualifier references the header row in the table.
- Convert currency to general
- How do you combine a date field and a time field into one?
- DCOUNT - date as a field only works when entered as a number
- hyperlink to website and then to information in a certain cell
- Week ending calculation
- Convert table by date to array
- Product formula help
- Using Format Painter on multiple cells
- Sumproduct igoring hidden value
- Converting Pounfs to US Dollars
- Data validation error message not showing
- Lookup a location # with multiple dates
- Can Excel look thru column of text & derive most commone
- pivot table field structure!
- COUNTIF - across 2 columns
- Running total for 2 columns IF column 3.......
- Long list into Table to contain only ten
- simple sum unless blank
- simple formula help
- produce a criteria based list
- Account # is a known the description is not, need to create a look
- Help creating continuously calculating and updating formula
- account # entry needs to return the account description
- Nested IFs
- If..The Statement to automatically format a name
- [Q] How to use Excel to show est. compounded value displayed by mo
- Help with a formula in an excel 2007 worksheet.
- How do I customize the available fraction formats to fourteenths?
- Can MSN Money stock quotes be used in Excel 2007. Smart tags suck
- complex if statement
- Sum a range based on another range of cells
- nested sumif?
- PMT function and 1st payment partway through a period
- % Variance
- Lookup Wizard
- SUMIF
- help simple SUM
- Conditional sum wizard
- formula for sum
- MIN from another worksheet
- AVERAGEIF
- One command in one cell initiating another command in another cel.
- vlookup Function
- IF THEN
- Uneven column lookup
- with "show formulas" justify
- Summing one column based on criteria from two other columns
- Match with 3 criteria
- Summing values within a matrix who are both in a column where theheaders are within a certain numerical range and in a row where the rowheaders are specified.
- How do you add 1 to an invoice number in Excel.
- DAVERAGE, MIN, and MAX from another worksheet
- IF statement and text
- Renaming a file while maintaining links
- Format dates from cvf file
- Execel file auto save
- Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b.
- Why can't I sum several vlookups ??
- exclude non numbers
- Function that will look at letter in a column and return a number
- Help Please - Lookup in an array that has duplicte values
- matching 1 to 1 and 1 with variations...
- Using Excel in Formatted Output
- Multiple levels of worksheet protection
- returned calculation incorrect
- Return a value from Chart 1 depending on the value typed into char
- Re: Palindromes
- Help Pls Copy 1 Random Result To Many On Another Sheet?
- Conditional formatting based on adjacent cell?
- Lookup values, compare and paste
- Why is AutoSum iinoperable w/protection when column is unlocked?
- Counting within groups
- Round Off
- IF statement
- Help with changing column reference in formula
- Excel Auto Filter Problem
- Returning a Text Value
- Using (SUM(IF(FREQUENCY....to determine unique values
- Markup/Cost formula help...
- Problem with Vlookup and Data Validation
- Sort all columns based on one colum
- Easily mailing list from Data File
- Sumproduct not working
- INDEX, MATCH, IF function does not work
- Sorting & pivot table
- Macro error when trying to open workbook
- get value of previous cell
- How do I repair corrupted data from a restore in Word and Excel?
- Counting cells only if cell X equals "yes"
- Trying to lookup values on another sheet
- Addition errors with Decimal Places
- Nesting Functions?
- Return matching value
- Open a worksheet by refrencing a number in 1 cell
- Count cell A1 only if cell B2 = Yes
- Worksheet print sizing/scaling without impacting a logo image
- add value of cells based on the formatted fill color
- Using the Countif, Countifs option for Excel
- Counting
- Averageif function with range that includes non-consecutive cells
- How do I get started using the Countif, Countifs option with Excel
- Excel is asking for a password while I never set one
- Permanently link Col A edits, inc 'insert row' in multiple workshe
- Is it possible to pick up formatting from range using index match?
- Conditional formatting comparing two columns
- Permanently linking Column A in many worksheets
- How do I correct a header in a custom view?
- Please can you help me
- INDIRECT function to reference a named range
- Calculating a future date using system clock & time remaining
- My cursor is highliting 3 cells instead of just one.
- sequential numbering exceptions
- Calculating a percenatge based on dates
- Match date to today
- Lookup with AND i think
- Adding cells but leaving blank if not populated
- Conditional age grouping
- Dynamic of Excel data
- Drag & Drop
- Picking up dates from within a string
- sumproduct i think
- Text stops wrapping within the cell
- How do I a calculation
- Summing a range of cells based on criteria in another range
- mmb- fiscal year calculation--
- If then else needed in Excel 2007
- =DSUM problems
- Macro to create date when sheet opens and then remain static when
- Wild characters in function?
- How do I find like data in multiple worksheets?
- Concatenate question on limitations
- XIRR #Num! Error
- Complex if
- Excel row height v. printed page
- Removing Links
- How do I produce consecutive invoice numbers in Excel?
- count
- Formula Help
- HELP. I need an "IF" formula with a lot of information
- Lookup date between 2 dates
- Excel and weird behave
- 2 criterias in lookup
- Print Multiple worksheets
- toolbar keeps coming back
- HELP! I need to make an IF Statement comparing date/time fields..
- VLOOKUP and Referencing a Range in a Formula
- Link
- sorting and matching in excel
- 61 Hosting Web www.ivys.es
- I need to delete the values in some cells,
- conditional format question
- Formula to get number of days excluding Fridays in a given period
- cant pass array to excel from c++ using xloper structure
- Selecting right part of text string
- Special Paste
- how do i create a dropdown box that also filters information
- In EXCEL - inserting box that toggles between a check mark & not.
- Custom pivot formula
- Complex Count formula
- Conditional Format
- how to count if a cell value falls between two numbers
- sum product if
- combo function of adding %
- Format a Telephone number
- Posts not showing up - posted through OE
- Posts not showing up - posted through CDO
- Lookup matching two values
- Formula to calculate either "-" "+"
- getting an error when updating links
- IF statement and Combo Boxes
- How do i create an IF func to return values from another spreadshe
- evaluate a concatenate expression
- COUNTIF Function Formula Question
- Sumproduct not working
- How can I link to a chart that is a full sheet?
- Uk Date Format to US Date Format
- = if X=1
- what is the formula for =if x =1
- SumIF
- How to use formula to decide when to apply TIME data validation
- Help with formula
- Sum of a range of cells that include cells using LOOKUP
- Complicated Formula
- How do I print formulas in a spreadsheet?
- Dupplicates
- Returning date instead of 'not null'
- Bottom value in a list
- Lookup
- Validation & Muliple List Picks
- Excel 2007
- Vlookup help menue is wrong ????
- Average across worksheets ignoring zero
- Hyperlink to cell within a sheet breaks when cells are sorted
- Pivot Table question
- Same experience
- Using Formulas
- Formulas
- Standard Error of the Estimate
- trouble repeating cells in table
- Double unique formula
- SUMIFS-time criteria/month
- Help with Excel 2003 (multiple IF statements)
- XL2000 - Linking Named Ranges
- Help Please! Random generator issue.
- Add if blank statement to index match
- I have a column of 50 numbers
- I have a column of 50 numbers
- Return match result
- multiple sumif or sumproduct
- how I can calculate EAR with continuous compounding?
- Large formula
- Use Indirect to Select Worksheet
- Index, Match, Lookup, Vlookup or Combination?
- comparing
- Concatenating Criteria in DSUM
- XL2000 Links Between Workbooks
- Multiple Lookup with Criteria
- standard error of regression coefficient
- how do i do a compound if function?
- excell auto-populate word?
- How do I convert an Excel Spreadsheet into blocks of Text
- Mouse clicking on Excel Worksheet Cells
- Adding Hours Worked Correctly
- Edit Links Excel 2007
- Average formula across future worksheets
- RESET BUTTON
- how do i parse every nth data point from a large data set in exce
- Hyperlink Formula Problem
- Loop Until non-incrementing cell condition met.
- Why do cell fill colors not show in worksheet view?
- Prevent function errors caused by cutting & paste or drag & drop
- Excel not calculating formulas
- Converting Decimal Degrees to Degrees/Minutes/Seconds
- Autofill row with a column entry
- I have a column of 50 names
- If AND/OR funciton with multiple criteria
- Formula Help
- Formula - If Statement with blank
- Naming a cell
- Troubleshoot LOOKUP, please
- Using a IF function in a validation list cell
- #N/A Error Reference
- Formula Issues
- Spread numbers by setting up a Min and Max
- I need to find someone to build a spreadsheet.
- Date calculation
- Formula for totaling selections
- Counting occurences of text
- Conditional Formatting - letters present
- counts repeated number in two different area only once
- DCOUNTA with multiple criteria
- counts repeated number in two seperate area
- How do I count the number of records autofilter is showing in Exce
- Formulaes
- excel 2003 worksheet
- VLOOKUP with WORKDAY?
- Lookup Value in Multiple Columns
- AutoFill Numbers- shows up ###
- Row to Column
- Conditional Formating
- Conditional formating based on blank cell
- How do I add NOT insert additional worksheet to existing workbook.
- copy cell info to other sheets, other sheets dont contain all row.
- validate date entered
- Change cell font color if time is> by 15 minute intervals upto 2hr
- Multiple arguments
- hlookup- move range by 2 rows with fill.
- Sending data from one cell to another
- Counting based on multiple criteria
- CSV Column Conversion
- transfering a figure from 1 worksheet to the next
- Nested IF isnt working right..Why?
- Problem with COUNTIF being off by 1
- Lookup Question
- Conditional format for #DIV/0
- Tracking due dates
- 2 Spreadsheets find duplicates
- What should formula look like to define date range on SUMIF
- Finding text between 2 @ signs
- Adding a row to reconcile to a new worksheet
- help - need to parse a cell
- "IF THEN" FORMULAS
- excel 2003 subtract function
- Using MAX with a LOOKUP
- Help with a date calculation
- copying workbook formating to a differnent workbook
- Reference number
- excel should have a rolling paste function
- Excel question
- Array formula using sumproduct & vlookup
- Excel filtering
- Insert single quote symbol
- Counting the As and Bs
- how do i restrict cells to not accept formulas?
- creating formula in excel
- display calculation steps - not final answer
- Adding OR to an index match formula
- Conditional Formatting Question
- Lookup value one and retrieve more then one corresponding value fromanother sheet
- Pivottable getpivotdata problem
- Countif certain values on specific date
- fomula to divide
- Dynamic Named Ranges
- How can I insert a true blank inst. of a non-blank zero string
- First Name & Last Name
- Compare two cells with same name
- recode variable
- Insert a rows automatically
- adding two colum cells only if there is data in 3rd colum
- LOOKUP
- Formula For Counting Records
- Trying to find and replace *
- How can I move to the first cell in the selection in Excel 07?
- SUMIFS - How to use a variable with > or < in criteria
- Need help with a lookup or if statement
- Copy last entry of column to bottom of column
- Calculating a Check Digit Routine
- COUNTIF
- How do I filter by today's date(changing) and before in a macro?
- I have a column of 50 numbers
- Macro recorded... tabs & file names changed, macro hangs
- what function to let me create summarized spreadsheet from databas
- VLOOKUP displays formula rather than result Excel 2007
- consolidate 26 pay periods/worksheets into 1 year end worksheet
- How can I suppress the enable macros and save changes messages?
- Multiple text function calculation
- VLOOKUP or INDEX
- help counting
- Using Indirect Function in SumIF?
- Find a word in a sentence
- options of sharing workbook is not available
- Formatting Help
- Easy one for you all...
- Clear excess formats in Excel 2007
- Loop or Find code ?? need help !!
- Formulea
- disappearing Sheet tab & Scroll bars
- Using if statements with a date
- MATCH problem
- Inputs for Goal Seek Command
- Flashing or Blinking Cell
- Assign a function to a Command Button
- Choose dat range for sumif formula
- How can I prioritize data automatically?
- Adding hours to a time
- need a formula that has to do with dates.
- SUMIF Greater than or equal to
- Need Help
- IF, OR, ISERROR?
- Want to automate my football spreadsheet.
- validating references; how to recognize the #REF! condition
- IF(logical_test, may be a number or text
- how to search within a row or colomn for a particular string
- COUNT IF NOT....
- Sumproduct I think but a tough one
- using "OR"
- Conditional Format Won't Update Cell
- vlook up
- Need help in Excel 2007 - urgent
- Help summing a range base on a date
- Help with summing a range based on a date
- non number consolidation
- Need to use Countifs to return unique data
- Extract characters from cell
- Convert text to rows
- Searching for products and categorizing.
- Hyperlink HREF question w/ vlookup
- Excel TRANSPOSE
- Scroll tabs
- Adding periods (full stops) to the middle of numbers
- Insert date, but keep static on archived
- PUT PAGE NUMBER INTO A SPECIFIC CEL?
- Reporting Info to New Sheet
- brought forward & carried forward
- Dynamic drop down list
- Varied Results obtained using Index and Match in Excel 2003 and 2007
- Inserting comma(,) after every two digits of a number from right t
- Convert Text to Columns
- Count If
- some numbers to be blank
- 1 equals 3
- Calculate between start and end times
- Counting No of character in a string
- Statutory Hrs Calculation
- Count the number of workday in a month
- resizing list width in combo box
- Function to display file name
- Sumif but taking a value
- Extraction for Ashish Mathur
- Whole month total vice daily
- CONSOLIDATE SHEETS
- Vlookup on partial match
- Reminder
- Why does "=SUM(E4,E8,E11,E14,E17)" display as text?
- convert sum number to a set number
- multiple ranking (sorting), based on diff. criteria
- Lookup and Display Multiple Unique values based on criteria
- Lookup and Display Multiple Unique values based on criteria
- Moving info from rows to columns
- howdoIaddcolumnsfor atotal
- sorting text with numbers
- Conditional Formatting Issues
- counting how many employees are scheduled to work by hour
- What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)
- formula assistance needed
- Can COUNTIFS be utilized to return unique values?
- Data Validation
- trim cells with space in betwen numbers in cell
- Linking Cells
- DATEDIF vs. simple difference
- Is it possible to link a whole table into another worksheet
- Can "COUNTIFS" be utilized to return unique values?
- Can "countifs" be utilized to return a count of unique values?