- Get data comparing Row Header and Column Header in a new sheet
- Rounding Dates to Next Quarterly Period
- Formulating labor cost information
- how can clear Value Error in paryroll.
- Add data from preceding cell in addition to available formula
- Help needed: cell should switch to Y or N, but formula doesn't work
- Copy of rows from one sheet to another sheets based on certain criteria
- Using IF Function
- Dynamic Drop down working from dynamic source list
- Formula Troubles
- Help with If/Then Statement - If Column B = "X" Then enter "Y" in Col C
- Rounding Date Up to Nearest Date in List (without array...?)
- Excel to Outlook Macro - Email Body
- Help with a simple formula
- SUMPRODUCT + VLOOKUP not working
- Formula to select first 3 runners and first in each category
- Help Setting VBA Memory Variables...
- Organize item sales by date and other variables based on cell content
- Modification in Excel Automation
- Formula Help
- Help on Lookup Formula
- Data Migration from One Sheet to Multiple Sheets
- Finding it hard to put into words what I'm searching for
- Excel VBA to copy and paste data on different worksheet
- Finding text within a pivot table to add to getpivot formula
- Displaying total # of names between dates into a different column based on a month/yr
- need help with a complicate "if" formula
- Excell Forms
- Activx and or Form Control
- How to add total of Hours and Minutes
- Hours worked/payroll formula help
- V Look Up Formula Not Working
- Help with extracting multiple rows from 5 sheets into one sheet based on criteria
- Using "IF" statement to count number of highlighted or colored font cells
- How to Calculate a Date if less then current date
- How to avoid #N/A in Index/Match
- How to trace the last non-zero value line in a report
- Help needed - Auto updating test schedule
- Using And, if, or, ISNA statements
- Sum values in one column based on unique, filtered values in another
- Price percentage formula
- problem with numeric format when downloading from external source
- splitting string and copy to other cells
- Linking Cell to Another Workbook and Using when Closed
- Using MATCH with IF AND <,>=
- Advanced filtering problem
- Formula that changes what cells it pulls from based on where active cell is
- Issue with a list of data
- Issue with lots of Data
- Reversing the result of a formula
- Need help with a complex formula
- Sum how many times a combination is made
- Conditional Formatting
- Comparison of values to find "efficient" calculations
- Calculating 3 and 5 decimal points in cells
- Match Cell Substrings to Column and Return Adjacent Cell
- TAT Tracker Help
- Creating a Scheduling System in Excel for improving functionality and performance
- Help with some logic..?
- Splitting name with various combinations using excel formulas
- Huge Permutation Problem
- Excel Parsing using POI problem
- Use group/ungroup with a locked workbook
- DAX SUM function per group
- SUMIF? Need to extract and sum data from pivot to another sheet.
- Formula for max consecutive wins and loses
- Formula help-- countif, if
- Subtracting time
- Am not comfortable with Pivot table. Would like to use a formula
- If text function when correct showing a corresponding value
- "Right" & "Left" If statment
- Possible formula or macro for Creating Drop down/Running tally counts
- Auto-Update to add row formula help
- Multiple IF and VLOOKUP
- Counting the number of Events that occur in a specific month in a range of days.
- Assistance with an IF, OR, VLookup formula
- data not passing from vba to cell consistently
- Splitting International Dialing codes into country and area code.
- How to get a parallelperiod to date with a partial date segment
- "if" this text found, keep this row and the next -- delete others. how to do this?
- Help with populating a cell depending on several criteria
- Copying formulas with complicated pattern
- Please chcek the formula - night shift tracker
- Comparing data in rows in multiple columns?
- How to Better the below formula without much Manual intervention?
- Usage Calculation
- Subtracting Time as per sample
- Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrup
- linked sheets losing Vlookup when filtering
- Sort birthday list from ID number
- Multiple IF and or VLOOKUP
- Vlookup
- Urgent Average Issue
- Different calculation on each worksheets
- Count based on today day condition
- VBA- Trying to combine; For each cell in range and Else
- Hi Guys, I am new here I have a problem with if than
- Fund Flow Statement Excel Template
- Admissions Spreadsheet: Simple method to populate data?
- Need help on Excel Test
- Matching data in columns and extracting information
- Worksheet, Warehouse work attendance with barcode scanning
- Excel spreadsheet, formula be for counting families on a sheet of individuals?
- How do I add the ROUND function to an existing formula?
- Excel Scroll Bar Problem
- If function help
- date range
- Two "IF" functions in the one formula?
- How to create detail invoice from data rows
- Formulas which help with sequential data
- Calculating Labor Hours by employee
- Finding the max value I can add to numbers in a list
- Data Validation
- Dependent Drop Down Lists
- Solver, goal seek or more simple formula
- Input - output by row
- Help COUNTIFS From Spreadsheet That Will Be Filtered
- Not to Include Data that Moved to a New Spreadsheet
- If this and this then this or if this and this then this - Need Help
- How do you replace Vlookup #NA errors with zero or blank cell
- Stumped on multiple formulas in one cell
- Help with Formulas
- Filtering Large Amounts of Records by Color
- Score handling in one column
- Extracting information
- Looking for a more efficient formula...
- Populate Report Automatically
- if statment
- Time calcultion formula
- Multiple criteria lookup
- How to make value 0 if formula reslut is a negative number
- Cant get my head around an INDEX/MATCH/LOOKUP Formula!
- Need help getting numbers in cell to match with numbers in another cell
- Best formula to generate HTML URL link code in excel
- Run-time error '9': Subscript out of range - Excel booking form with email macro
- Reconcile of Data-Formula Help Required
- In DATABASE criteria "Blank Cell" AND ="" are NOT the same things??
- Identifying/Indexing by partial text string
- help with excluding weekends in time sheet
- Drop down selection and populating data
- Using IF Statements as identifiers in an INDEX function
- Trouble with using MATCH INDEX to link cells from other sheets
- Need to look up table using multiple criteria
- Formula help
- Formula help please!!
- I need formula
- Complex problem. Is this possible?
- I need if Formula help please
- Excel Hack coming out of New Zealand
- Solver doesn't find maxium revenue
- Request help with Conditional IF
- Variable Start Period for Real Estate_Need help
- Help with Count and Rank
- Formula/Macro Help
- Index & Match - Sort Dilemma
- Highlighting dates
- Returning the value of a cell in a different workbook - name of book in cell
- Sum of unique values in a column based on values in another column
- Create formula that automates a regression equation with multiple varying criteria?
- Display a value if the date value falls within a month
- Take Percentile if between certain date range
- RoundDown Formula
- Automatic invoice generation
- Convert days into years, months and days in Excel
- Only show best selling product DAX
- INDEX MATCH Search across workbook
- Index Match HELP Please
- Data removal and copy it to new location
- Nested IF with VLOOKUP - best solution?
- formula help
- SLA Calculations
- Need automatic serial no in different pages
- how to convert string into readable format for =DATEVALUE?
- extract specific word or words from a text in Excel
- Help with Looking up transactions from within a date range, please.
- Remove file paths
- Divide X into Y whole numbers that total X
- What formula to use
- Transposing formula
- I need Formula help please
- Need help pulling values from column - hlookup?
- Help with SUMIFS
- Formula for Daily Average when the Columns are Monthly Totals
- Vlookup 2 different criteria
- Max, If & And
- Need help to add an Either/Or Statement to a working formula, please.
- DATE - Contract values for 2015
- How to find the average sales of each person in raw data.
- Need help writing a Formula
- vlookup-transfer-data-another-sheet-data-emp.
- Conditional formatting based on (x,y) data values
- Please read before opening new topic!!!
- Conditional Formatting w/ 3 Range Conditions
- IRR Formula Q?
- A referenced cell inside an IRR formula.
- Correct use of COUNTIFS and COUNTIF
- IF and SUM
- How convert the cell data to its formatting style?
- IF a value is true in a number of cells
- Step by Step
- Priority
- Conditional Formatting
- Assigning categories
- Auto populate data from one sheet to another with drop down
- New member here - have a question about developing a formula
- I need assistance urgently.. Please
- Help With AVERAGIF
- Pushing data to an empty cell.
- Is there an easier way of writing this formula?
- REF! error when referencing another worksheet
- VBA Loop
- LOOKUP function and date
- Conditional Formating
- Restrict cell entry of B1 as per the value in A1
- Forecast and offset
- Using Name Manager with table
- Match two columns from two different sheets and display Yes or No
- Moving Data from one tab to another
- Conditional Formatting a Row
- Please help need a solution for best combination for set of numbers
- Need help from a smarter person please :)
- multiple functions
- sumifs multiplie criteria
- Need a Formula to Auto populate dates
- Use COUNTA in SUBTOTAL
- Need a formula in the column “to be filled” in column “C”.
- Counting unique values in a column with a month condition
- Formula to provide RAG status
- =IF formula help
- Help me to solve this Excel File
- show string of rows
- 2 Week Rolling Average
- MATCH & INDEX (what am I missing)
- MAX IF statement help
- Index match function?
- Insert space in column randomly
- Choosing multiplying a number selected from a table
- Need formula for this
- Formula/Calculations Assistances
- To scan badge ID's to inventory list
- Return a list of values for a meal planning spreadsheet
- Excel - Lookup value in column and return values from the same row.
- stacked bar
- Highlight duplicates data form sheet to another sheet
- decompose data
- Formula For Matching Multiple Criteria
- Randomly generate list of numbers and text strings
- Excel Formula, Payment calculation
- Conditional formatting with wildcard match
- Sum of a number of columns dependant on value in another column