- Data and If statements, need some advice!
- Week by week report
- Help on SUMIFS Function
- Problem with Look Up Array Formula
- high and low
- Multiple Sheet Consolidation - Help
- Excel 2007 - Count unique formula
- Calculating Vacation Time at Beginning of Year
- interpolating y value on a scatter graph
- If value is met hide/reveal named range
- Need a formula to return text instead of a number
- How to pull entire row data from 1 sheet to another ONLY if cell in row is this week
- Days Off
- automatically transferring data to another worksheet
- Need to add cells depending on other cell.
- Data validation with different formulas
- Conver values into text
- Formula Help? Date Range help...
- Vlookup partial matching for cell content (text)
- Blood sugar results
- Search for date and then apply mutliple search criteria in huge dataset
- Formula Help. Sum of Cells if Certain Criteria is Met
- Trying to setup a sheet to give a running balance
- Excel 2007 - Sum of value found in Column BT if value in Column D equal the criteria
- Need help! "Data-validation-Like' formula??
- Need Help!Extracting data
- If text value = Like "**" then insert a given value in Row
- Building up 16 teams (2 persons per team) 12 times differently using excel
- Create Formula For Rooming List
- Excel 2010 IF nested date formula Help needed please
- Excel 2010 - Sharing one common Defined data name range by multiple sheets
- Excel 2010 - Vlookup question
- Count days between two dates function
- Index match formula [Solved]
- Help with VLookup
- Color match formula
- Struggling with an IF Function
- Sum number of calls within a specific time frame
- Excel function for highest number for every 10 numbers?
- Copy and Paste Macro Problem
- incrementing in cell
- Need to match 2 criteria with 2 criteria to pick up a value
- if statment
- Excel vba format issue when trying to insert variable
- This should be simple for someone with a little more than no experience in Excel
- Need help with team lists
- Need help in formula
- help with vlookup formula!
- Need help with excel formula!
- Need to Have Form Control Scroll Bar, scroll left to right
- Font size formula
- Formula help with drawing random cards
- Clockcard 2 ins/outs p/day. Max o/time rate @1.5 rate = 6hrs, Bal o/time hours is @ 2
- Adding cells together where one is a date
- Need Help for Hiding column & Row through Short cut
- Help with writing a code
- display cell information
- formula involve with if and #n/a
- How to separte the letters in an excel sheet by using formula
- Referencing File Path - Dynamic Cell Input for Worksheet
- Need Cell Values instead of Cell Address
- Need help w/VLookup formula
- Or formula help please
- Do not want "False" to display with this formula - ideas?
- Deduping records without loosing right data
- need help with keeping a result from reverting back to zero
- creating variable results for a single cell
- Would like to have an "or" in an if, then statement
- is there such a formula?
- Search using formula and get multiple results in rows
- Formula for Creating code from data in cells
- Need help with updating sheets from another sheet
- Fetch data from 1 table and post in another table in same excel sheet after pivoting
- Multiply number based on alpha character at the end
- Keyword extraction formula
- Conditional Formatting on Today.
- ISBLANK and Nested IF
- How to replicate data values for a time series?
- Need to transform name and address from vertical rows to columns accross
- Copying the Data in reverse by using Formula/Paste Special
- Calculating frequencies from worksheet to worksheet.
- average of single cell per line?
- Want formula to return average days between two dates in a given month
- How to create lists from intersecting column and row headers?
- StdDev and Var in different data sets
- Week End date on Every Saturday
- Search all cells in a column for text and if found provide the cell reference
- Help me!!! Listbox select
- Help with formula for curve
- Help with Multiple Data Validation Inputs and If Statements
- How can I combine a series of dates? VLOOKUP can only work with one unique identity.
- Separate string into separate cells
- VLOOKUP or Index Match for me?
- noob wanting help with formulas
- Index multiple sheets
- If Function with data validation
- VLOOKUP when Lookup Data is not in the left column
- Input data then clear cell but save to another cell..Is there a formula for this?!
- IF formula evaluates to wrong value
- Add Values only if Matches with criteria
- Help with a complex formula or lookup table
- Vlookup data from a Tables to a single column
- Work out an average that converts a number with a letter to a numeric value
- I'm Getting different results using the same formula
- Need a multiple formula which can bring result in single cell
- Formula to return median values if true
- Dependant Data Validation and Relative Referrence in Macros
- how to draw to scale
- Problems with MROUND
- How to determine if a cell contains a comma
- Daily Log
- IF and AND Formula for a Call Back Reminder with Conditional Formatting
- Want to copy time in dot format from one cell to another
- SUM number values according to days of week and highlight red If exceeds ?
- Need to merge data from two sheets with different structure according to 4 criteria
- SUM Weekday formula ?
- VLOOKUP & IF(ISBLANK to merge sheet and not overwrite existing data
- Auto update every cell in a worksheet
- worksheet_change event error
- A (seems) simple "vlookup" complicating my life
- Hyperlink-IF formula
- Lock certain Cells with click of a button
- Project.
- If function to show the expected result
- Copy Conditional formatting in Excel 2007
- plz help.. which formula
- Request : Pl help me Send mail merged mail in Lotus notes using XL VBA
- FALSE error in formula
- Auto update cell each time a number is used
- Deleted Data Source in Pivot Table
- Calculating total run time of a device...
- Ignore Duplicate Entries on Dynamic Validation List
- Average of several columns grouped... and a conditional concantenate
- Modelling and Formatting
- much numbers
- Dynamic Data Validation
- Data Validation with Multiple References
- Prevent Copying and Pasting
- TAN Help
- Trying to work out the Best Formula
- x,y,z=100% - if x = 77, what value y and z...
- in how much classes are the children together? Excel formula
- Search and replace/insert HTML code into Master File using tags
- New Excel User
- need excel help please
- Help Condensing Data
- BeforeSave Event SaveCopyAs
- How to give values from two reference from different sheet of excel---help
- Vlook up & concatenate
- Reference Table in seperate Workbooks
- Sum last 10 entries in a row
- Formula returns Error value - fix?
- Filtering Error
- Formula for creating summary of vast data
- Newbie question
- automatically sort
- Hyperlink in formula
- Painting cells whose sum is zero
- Formula
- Automatically check for last date and insert row below the last date
- Autocalculate average formula on inserting a new row
- Freeze time in a cell
- sort letters
- Sumproduct help
- Insert Value according to month and date value
- Find & Match Number, and return the Cell
- Help to Reduce Formula
- Need a help with a forumula
- Need Help With AVERAGE Function!
- Help with VLOOKUP if a date is between two dates
- the empty condition not working properly
- VLOOKUP or INDEX & MATCH
- Distilling data using drop boxes
- Special Currency Format
- When I enter a dot in the formula it displays the formula
- Once I drag it down if gives me #######
- Present Value Calculation Dependent on a Drop Down option.
- Match or index???
- Sorting months and data from large set of data
- Can someone help me Im tearing my hair out here.
- Delete Duplicates based on Earliest or Latest Time
- Finding closest match to values in a range
- countifs
- offset to start from a cell containing 3 specific letters
- My VLOOKUP is showing a lot of #N/A entries when no match. Cant it just return blank?
- last few formulas needed, but unsure where to start
- using another funtions with dividing numbers
- new to formulas so this should be an easy one for you experts!
- Checking data and copying to cell
- sorting HELP!!
- Conditional Formatting to letters
- Formula not giving correct output
- DEX / MATCH Table Values
- Formatting Excel Texts and Values
- A method to add the same cell in a worksheet across several workbooks
- Condensing Formulas
- Excel formula
- How can multiple different hyperlinks be given to corresponding cells quickly?????
- Senior requires baseball help
- Wildcard VLookup or Index(Match) Problem
- Need to average Multiple worksheets into one
- If and roundup formula together
- I need a formula for managment in excel
- Formula HELP
- Excel 2010:Applying a value to a room in a rooming list that changes when re-ordered
- two values to find on the same cell
- FALSE statement
- average for each day
- results at the top of each day, not at each cell
- Combining a formula with a cell search from a different spreadsheet
- Function if ex: a1=2 then b1=text1 b2=text2
- Find text and return cellreference in a chart
- Excel formula for retrieving Initials from Full Name
- extract info from raw data based on alot of criteria
- Difficulty copying cell refs across two spreadsheets with same worksheet name
- Formula to compare pairs of cells in a row
- adding statement to give the values that do not appear
- array formula to nest several optional values from same cell
- counting cell containing only numbers
- I want to add card numbers?
- Making a Budget Report with IF & And Functions
- Do sum of cells having specific code in front be done
- Need hep to automate task using formula
- Help with some time.
- Help! Withexcel conditional formula
- Excel formula to copy from random colums
- SUMPRODUCT function
- Finding the number of times a max value is seen per location
- Need help with Excel equation to determine sales volume needed to reach company cap
- Dependancy Formula
- Partial Lookup
- Finding ranges of values that satisfy a condition that stops and starts
- IF statement added is not working
- Selecting non zero dates and repeating 24 times( for hours) without macro
- (1) "If" Auto Entry ....and...(2) Auto Open Worksheet or Second Spreadsheet
- If a cell has a Y or N, another cell needs to make a varying calculation
- Problem with Iterative calculation invExcel
- Excel formula for converting First letter to CAPS
- Long multiplication with fixed cell
- Putting together a logical check with combined conditions
- Find the Average of a sum of numbers in a single cell
- Small formula needed
- Formula that returns only value from a cell that is not N/A
- formula
- Help needed with lists and Data validation
- to compare between two workbooks and retrieve data..if match is found
- Urgent Help
- If (city1 or city2 or city 3.....) result = state1
- selecting multiple criteria returning headers
- modelling cycles