- Cross Sheet References within cells
- IF AND Statement with ISBLANK and conditional
- Create if formula based on selection in drop down list
- Not sure what Formula will work
- Need assitance with a complicated lookup tool.
- Formula to count entries as per month, year and submission wise from different sheets
- Please help with VBA code for searching between dates
- Cumulative sum, based on previous data
- Issue with Filtering Datewise.
- Cumualtive Totals
- countif
- Calculating margin % and adjusting pricing
- Index funcion help need..............
- changing some random numbers to letters
- How do I get Vlookup to return multiple matches?
- Find highest rev number in one column of item number in another column and add total
- Calculate Subtotal for Repeat Number Only
- LOOK UP Problem
- Extracting words from a string up to a character count
- need to extract email addresses from excel files
- Sum text and numbers
- Create a template for importing changing Quickbooks reports
- Need help with
- Using a person's birth date to detect the originality of work performed on a sheet
- Lookup a text value based on multiple conditions
- Delete first rows and keep later ones
- Convert tenths of millimeters to decimal inches
- Help required for League Table data entry
- Creating formulas & Macros
- Changing cell value produces "#DIV/0!" error message in columns
- Formula to count by a set criteria
- Issue with text in a cell
- Protected sheet in the body of an email?
- VBA Error 1004, Glitch or Coding Error
- Help with an IF formula
- Help to write out a vlookup then If formula
- help with nested if than statement
- Help needed for a weekend rota - not quite so straightforward.
- Help to find numbers that equal a predetermined sum
- Splitting an AlphaNumeric string
- Conditional formatting - if one cell is this, another cell does that?
- Offset Function based on drop down validation menu
- Excel Sheet Setup (Advance)
- Dropdown list based on previous dropdown selection
- Reference worksheet name as a cell value in another worksheet
- drag formula for data that skips one cell in other sheet
- Merge multiple tables in one table
- Need consistent formatting / font between two specific ranges on two separate tabs
- Nested if condition
- Pulling dates from one sheet into another sheets formula - end calculations wrong.
- Get number of rows where month equals X AND where other criteria match
- Help! Beginner here
- PLEASE HELP!! COUNTIF function for counting specific value show zero
- Help with large data update (Excel)
- Setting a date and time based on other cell contents
- Year of Mfg to Age help...
- Finding the lowest value from repeated data
- Table array pull between dates
- Conditional Formatting question
- 70 hr 8 days
- Help for fledgling ebay start-up hugely appreciated
- Schedule on-call MDs random rotation based on availability
- incorrect formula result
- Ignore empty cells in an IF formula
- Help with a search function
- Incremental Average
- Time sum issue with formula
- IF Function with multiple true values
- Index and match functions on merged cells
- Nesting If with And Functions Help Please
- Auto Fill, Excel 2010
- Return cell reference of another cell thats highlighted
- Populating cells based on matching information
- Budget - Input multiple events within date range: 7 Days, 14 Days, 1 Month
- linking holiday to a planner
- I want to creat a list of 2nd and 4th Saturday between two dates in excel
- Adapting current formula
- Highlighted rows in "Format as Table" and cannot undo/delete!! Help.
- Some great formula challenges at http://chandoo.org/forums/forum/excel-challenges
- Working with Dates and "Active Wells".... HELP! very confusing!
- Landlord spreadsheet
- Adding Multiple scenarios using a base scenario
- Formula for if two numbers match
- Add multiple cells(cells are in incremental of 9)
- Creating a Metrics Count within Ranges of Dates
- represent date in text
- calculating average based on a summary
- Using Excel to Solve for a Goal Rate on new Units Sold
- Weekend date by ISO standards
- Cumulative Totals Sheet Referencing Eight Other Sheets
- Drop down menu choice decides other cell values
- Linking problem
- how to Replace a list of data to a string but in different sheets
- Nesting SUMPRODUCT in to an IF statement
- Using a Formula in Excel to create an "x" if date entered is between two dates
- Formulas loosing cell reference
- SumIf(S) formula with special criteria across two spreadsheets
- need help with #N/A removal
- Alphanumeric-Fully AutoFill & change new set of Alphanumeric when reach it max.target
- Overtime Formula Gives Negative Answers
- mailing address pasted from the internet to Excel and then Mail Merge with Word
- Paste address list from website to Excel
- Lookup problem
- vlookup picks wrong values from another sheet
- help with complicated formulas
- Adapting current formula to reflect a time period (otherwise = 0)
- Trying to get a yearly total using monthly subtracted values.
- cell ranges based on Month
- Help with Excelguru spreadsheet I downloaded that worked but now it doesn't
- Having trouble making a third dependent list with illegal characters
- Help on conditional formating
- Calculating data from other Worksheets
- help on loan amortization
- Picking a row from a range
- Index Match GetPivotData formula
- How to sum a variable part of a range
- Removing chracters from cell
- Need a formula to count Neg values, by colm header.
- AND function for an array
- Excel 2013 formula not responding
- Auto complete from different Workbook
- stuck with create formula include multiple Data Validation values
- Need help with my calculation on 95th and 50th percentiles.
- SUMPRODUCT not working
- vlookup multiple values
- Formula needed
- Sum dynamic range in closed workbook using address/match
- What Formula should i use?
- Extracting certain text/number from distinct patterns of alphanumeric strings
- Urgent!! Advanced formula filling
- Count unique values in columns based on 2 criteria
- logging in spreadsheet help
- Using the "IF" formula to return a defined list
- Need help with COUNT/COUNTIF/ COUNTIFS
- Need to combine contents of cells to create a formula
- Finding values for specific date
- Regarding calculation of C.D.
- Which formula should i use to display duplicates in another row?
- Urgent, can someone help for this formula
- Lookup formula/ macro
- CountIF + different conditions + do not take hidden rows into account
- Combining cells but keeping original font colour
- Macro Help
- Need help with lookup/count formula
- Count amount of desired numbers in a single cell and return that value in another cel
- Excel Formulas - add certain fields only
- Using the Values of a Formula for another formula
- Excel Formula Needed
- Food list - Formula to calculate nutritional macros
- Alternative to If statements
- Compare date in a range and return sum of 2nd row data array
- Help! Multi-year projections for time change parts
- Wierd issue with excel
- Fomula for Percentage Calculation
- Duplicating a formula for other categories
- Select and Copy a Set of Data in a Column based on starting and Ending Values
- Number format in formula with text
- excel formulas, add up certain cells
- macro problem posting not correctly
- Manpower Assigning formula
- Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new shee
- Another Macro Problem
- Finding MAX based on MATCH
- search with multiple criteria
- Sum Product formulae to ignore zeros and #DIV0! error
- If condition Multiple selection
- if statement to get year from 2 digits...
- Need help flagging accounts to be paid
- Help Organising Data
- Categories problem
- IF more than a certain value then True if not then false
- if an answer is correct copy question to different sheet
- Autopopulating a formula with incrementing cell values/Formula's outputting values.
- shapes with formulas
- How to count even exact date 90 days
- How to insert Multiple Filters or Write VBA or Excel way to filter
- Column Comparison
- If Statement with loop/repeat
- Matching Date Values and exporting data to identified row/column
- How to do a vlookup with multiple results and provide them with no duplicates
- Formula to use?? Index/match/col
- Need week ending date formula
- Multiple IF Statement to calculate commission
- Help with averaging problem
- Complex Formula, Error 504 Help!
- Hours worked issue
- Nested formula help please
- Converting Date field in Cell from DD-MMM-YY to YYYYMMDD
- a plus b times c equals d ?
- Index-Match Closest Value
- Phone Numbers
- Hours Worked (again)
- Rota Formulas
- Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
- Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
- help to amend a sumproduct formula to minus 'Yes' from another column
- HELP! Trying to move data from one worksheet to another with no success
- Index + Match/Multi-Vlookup for Items with shared names
- Updating calculations as data expands
- Help wuth transpose (perhaps ?)
- Limitations of AutoFilter on Long Text Strings?
- Trying to automate a workbook via formulas
- Conditional formatting not working
- Fetching Data from Multiple Name Changing Sheets with VlookUp
- Trying to create a Timesheet with sums based on dropdown value
- Is a VLOOKUP the right thing to use to get a drop down list to bring in a %
- If and Vlookup question
- Trying to get a blank result of formula if no data is captured
- Hiding apreadsheet area on press of radio button
- How to enter data conditionally ?
- Generate unique it to same amount
- help with IF or IFERROR formula - want a blank cell if no data has been entered
- Conditional Frequency formula?
- Which functions to use?????***
- formula help
- Need formula to validate if a word is used on another line within a time frame
- Percentage Formulas for Spreadsheet
- Need help with median formula based on a set criteria
- VLOOKUP - if column A contains text string then return new value to column B
- SUM Different Combinations?
- Moving selected column data to a new column whilst keeping the data in the same row
- please I need help with a time sheet
- How to protect excel sheet and formulas
- Match Multiple Criteria & Find Oldest Date
- Automated forecasting trough formulas
- Format Date with Condition
- Conditional Format with formula for each row
- Vlookup item from middle area of a table
- find data based on depth ranges
- Help needed for a newbie
- Return Average Based on an Input Constant to Define Range Length
- Out of my depth - yet the water's still only shallow
- I need to smooth out my production curve over time while still respectiing inventory
- How can I sort thete numbers?
- Dividing the number and setting the maximum in cells
- arguments in functions
- Need Help Writing a Formula with Multiple IF/ OR Statements.
- Lookup and Return Names With Non- Consecutive Rows
- Look up cell value in one sheet, if found post other cell value to another sheet
- Automatic copying of data from one sheet to two sheets
- League Table Formula Problem
- Recurring date formula
- Min - Max functions????
- Linking Spreadsheets and Cell Reference for Worksheet Name
- Percentages with 3 columns
- Multiply IF
- counting time between change in status
- How to convert individual cell values to percentage change values over time
- New Excel Formula Help Tool
- IF statement not working because of dropdown