- miscalculating
- Return column header from first cell from consecutive cells below a threshold
- Looking for formula that matches certain condition
- MODE Formula based off an array using a lookup
- how to determine element of matrix when sum of rows and columns are given
- Is it possible to exclude 0.00 values in the MODE function
- Waiting List Removal Formula
- help with formula with multiple criterias
- Extract unique data based on criteria
- Cell Value based off another cell
- Linking summery page with special requirement
- excel formula
- Naming Cells Based on Data
- single list of unique values from multiple columns
- Automatic Time Update as per Timezone
- problem with iferror
- Date Range Conditional format outside the Cells without data
- Index Formula with multiple criteria
- Sum(If formula problem when=<+> issue help needed
- Nested function?
- pull down menu
- Alternate for Indirect and Sumproduct formula
- Look Up Help - Multiple Worksheets
- How to delete unsubscribers from excel files
- Building a custom summary sheet without VBA
- Index Match #N/A Error
- Using "Named range" in "Indirect Function"
- Auto-Sort with multiple Dynamic Ranges
- Return a hyperlink with hlookup
- determine Y value on graph from intersection of x value with series value on graph
- determine Y value on graph from intersection of x value with a series value
- Grafik
- Excel Query Question
- Determining a monthly trend from yearly data
- $$$$ Help w/ an Addition Formula! $$$$
- Dynamic rotating work schedule help please!
- Need Help with Dragging a Formula
- Locate duplicate sku and extract all rows with duplicate sku
- Auto sum data across multiple sheets based on 2 criteria
- Nested formula question
- Display common values in column A & B of sheet 1 & sheet 2 in excel
- Link to a dynamic file reference in closed workbook
- Set of rounded numbers to sum to a certain total
- Identify highest point total and return name
- Help with formulas
- *HELP* Consistent Updating Fields
- What forumula does Excel 2016 use to extend data series?
- What formula should i use for matching table?
- Horizontal rows into multiple colums
- Automatic reflection of data from another workbook
- Object Assignments based on coordinates
- If condition
- nested IF and Workday function
- Excel Paste
- How to Rearrange OR sort Number of columns based on one column
- Forms
- Retrieve list of values from array which has duplicates
- match cells and then calculate values based on a dat
- VLOOKUP formula not returning a value
- Count no of name and id in single formula
- FIND with RIGHT formula
- adding values against Duplicate rows
- Unable to calculate average of a column
- Help please
- Cell Reference Between Two Worksheets
- Formula to count unique value in a sheet based on multiple criteria
- Averaging Cyclical Data
- Index Match w/Offset - Riddle me this!
- Summing area of data across multiple tabs with multiple criteria-array and indirect?
- Find top 2 values that may include a negative value
- Index Match w/single criteria, multiple results,
- Annual payments based on varying monthly payments
- Time Sheet With SLA
- Select one option, flash tab
- Excel Formula
- Making presence list
- Formula to Extract Certain Text
- Time Function - Show Specific Text Based on 4 Fixed Time Scenarios
- Concurrent Calls in Excel
- Formula that returns the date that a criteria is met
- Newbie Needs Help
- Newbie needing help with weighted division
- How to solve for multiple numbers that add up to X from a list??
- Font colour associated with cell value
- Need macro to populate supplier template
- Listing all Unique Values from Multiple Tabs in One Tab
- NEWBIE needs help aligning cells with matching values
- Help adding to an IF statement
- Calculator Based on Differing Variables
- Formula for Capturing Non Negative amount on FIFO Basis
- Merge different cells into one cell by lookup value
- Lowest average of student and return student name
- check box responses
- Compare 2 sheets and remove the rows that dont have match
- Lookup a value then generate Hyperlink to the cell containing the value
- formula to measure win and loss streaks for both teams to score
- SUMPRODUCT Help!
- Tricky formula needed! Screenshot attached.
- Solver to get the maximum summary is not working
- help with time sheet calculations
- Calculate Cumulative Total - UPTO THE MONTH
- if function selecting from a range
- A tricky (for me!) end-of-year inventory report formula
- Help comparing columns in separate tabs
- Conditional Formatting based on 3 condition
- How to take a set of dates and have them match up to column headings?
- Creating a serious of dates, where the dates never fall on the weekend
- Multiple lookups and match
- Extract right part of the cell with multiple space
- Solver to find best matching Situation
- Help for Noob
- Help Separating Duplicate Cells
- Lock in today date, how to?
- Picking the data if criteria is qualified
- Listing of numbers within different postcode ranges given in one column
- SUMPRODUCT function =MIN?
- finding and extracting data from Table X into Table Y
- Lookup with conditions
- Multi-tab referencing
- Formula or function for rank, but not necessarily using the RANK function itself...
- Combining 2 working formulas into 1 large one
- Conditional Formatting two cells
- cell match
- What formula i should be use for this condition?
- Formula has me stumped
- Formula for a 3argument logic problem
- SUMIF with Index Match with multiple criteria
- Alphabetical Data Search
- Excel advanced search / cross-matching names
- Index and Match based on condition from other sheet...
- Excel Data
- noobie toleranceing question
- Weighted Average Summary Table
- Which function to use please
- Search a data set and return adjacent cell values and sum them within one cell
- A probabilty calculation
- Sumifs/Index/Match/Indirect Combo Formula
- Help with comparing and bringing over information from another workbook
- Count column in Filtered Table
- have an apostrophe before all the times format
- Extracting data by date (today-function) but don't want data to change over time
- Help to calculate working hours in financial hours
- Running percentage
- Extracting single numbers from a string
- Identify coloum after using VLOOKUP to find row
- Update number based on existing date (anniversary)
- Formula to Calculate Payment Date based on Multiple Conditions
- Dynamic Calendar
- Match 2excel and display the output
- Help with Network Days Formula
- Product price sheet
- IF statement with HLOOKUP (mulitple criteria) or INDEX/MATCH?
- Dynamic cell references in formula
- Total hours worked per day and market - formula
- Counting values in a column according to criteria in a second column
- Conditional Format Based on Numerous Columns
- Nested IF statement returns statement and not a value
- combination searching rows with equivalent date + transfer of this to 2nd spreadsheet
- sum values based off matches from two ranges
- Problems with downloaded .csv - matrix sum problems
- Array to Aggregate (or VBA?)
- Short date in A show as weekday in B
- Simple bank chech spreadsheet help
- Simple bank check spreadsheet help
- Import data into excel from crystal reports
- Extracting String between two types of characters
- Addition to an "IF" formula help
- Transpose / Rearrange Dates - Formula
- Conditional Formatting based on tick boxes
- Search string query
- Excel 2016 lookup (find in column & go to the correct row)
- Sumifs not working...
- Conditional Formatting - Highlighting dates within range specified in other tab
- Look at range of cells and calculate price
- finding 7th day working attendance
- INDEX & MATCH Doesn't Work Though Formula, Look-Up and MATCH Value Are The Same
- Strange effect using "IF" statement
- Formula to determine size curve based off current inventory and Purchase quantities.
- Selecting array that equals or is less than value
- limiting a formula to never return a negative number
- Formula to compare names in pairs of columns
- fibonacci formula
- Formula for variable transformation
- Help with counting the number of times any value repeats greater than a certain numb
- How to add third parameter - isblank to this formula
- Formula to manage inventory of raw materials
- Change default cell format for new tab
- Return an specific value tied to a column
- A (non Volatile) way to do this without using INDIRECT?
- conditional formatting
- Creating Nested Forumla (?)
- Index Array Of Names But Omit Zero Values
- Incentive Calculation - 2019
- Formula to get exact part number
- Formula Problem
- Sort Employee Logs In and Out
- Conditionnal Formating
- VLOOKUP Formula help!
- Formula that add a number if a value is greater or equal ...
- Is this possible ? Variable Date Entry ?
- Setting a cell value based on duplicates in two other rows
- Concatenate with an If Statement?
- break scheduling within a single cell
- Vlookup for comment with image
- Having problem with an index match formula
- Percentages help
- Vlookup
- A Simple Problem and a Simple Answer?
- match forumla problem
- Forumula for Betting - a Staking Plan formula
- Validation with Dropdown list dependent on validated selection in another cell
- need help on formula
- Index Results Help
- split text by specific criteria
- VLOOKUP or INDEX formula for a database search
- Count Total Values in a Column with Including Duplicates or Blank Cells
- Active sales promotions per week
- VBA Sort Data using Macro
- Creating Connecting Network Units (airports)
- If & lookup
- Multi column lookup using Index and Match combo.
- need with help with data validation
- Duplicate counting
- 3D formulas
- Multiple if with TEXT as cell content
- Running total in single cell
- Ranking Top n Values, With Duplicates, Using Multiple Criteria
- Need to add timings (10 minutes and 30 minutes seperately to the same formula using =
- Data Consolidation
- Search a number in multiple tabs and show up the tab name
- Excel - If Formula Query
- Excel - Copying formula down selected cells
- CountiF Filtered Cells Only
- Formula to determine selling price
- How to show a list of top 10 pairing names from far left column and top row
- How to show a list of top 10 pairing names
- Best 10 out off last 20
- vlookup solution
- IF, AND Formula with multiple criteris
- Automate Commission Accelerator calculations based on quota attainment range.
- Dividing by Zero Formula Solution
- VBA: Cut and Paste Not Working
- SUM of Total Positive Changes in a Column
- Change the value of one cell in a group
- VLOOKUP solution please
- Lookup two dates in a 3 dimensional table
- How to unify two lists in one?
- Auto Match and Numbering in Excel - Thank you
- How to Tally and Rank Frequency of Occurrences of a Year in a Column
- Summarize multiple rows into one