- How to reference a list of data?
- lookup multiple instances
- Summary of cells
- date formula/format
- Having trouble entering formula
- hot to convert a date object into a text (format yyyy-mm-dd)
- car hire rental spreadsheet
- Lists
- Functions inside a header
- CountIf
- Data summation problem
- Finding duplicates
- daily and weekly cost sum
- INDIRECT function
- autogenerate reference numbers
- counting function
- Converting Text to Numbers
- Custom Lookup Function
- past due dates
- How to Truncate date and then add current year to it
- If, And function will it work as shown
- Negative date values without changing the Date System
- Store a cell value then change it, having remembered the initial value
- Percentage Formula Assistance
- Date Formula Question
- How to get data according to the current date
- Hyperlink to a Looked up Reference...
- Comparing Data
- INDEX/MATCH functions
- Lookup last value
- copy
- INDIRECT function problem
- Moving cell content
- Duplicates
- Excel Payroll Application
- Function for finding Duplicates and adding quantities
- Lookup Ranges
- more than 7 IF functions
- Advanced Right
- Pivot tables - More than one column display
- summary
- Apply Slab Rates????
- IF statement (Excel 2002)
- IF Statement Question dealing with Dates
- Populate fields based on value in a drop-down list
- Capturing Fields from Multiple Sheets
- Insert Zeros before a number in cells
- Linking Cells through formulae
- Counting function with 2 sets of variables
- counting months between dates and returning a decimal
- Custom Autofilter
- "IF statement
- Liner interpolation
- Copying formulas and possibly simplify
- sum values in "B" if repeating in "A"
- Vlookup
- IF and AND functions
- Dragging down a formula
- formula
- Total depending on condition
- count number of records per month
- put a zero in front of a number?
- reversing a rank
- Goal seek question
- Hide Protect formula
- vlookup
- Time/Date formating
- worksheet link
- referencing cells that are linked
- Average Function
- Custom Format
- Check Col. A against Col. D
- Sum budget totals depending on the month
- using a constant value
- Consolidating Data
- Using IF and AND to calculate 3 cells
- AND as a value of IF
- how to convert 6:80hrs imto 7:20hrs
- Simplifying my formula
- IF formula
- How do I achieve this result for Multiple range of number
- Checkbox
- Formatting IF........
- populating a cell from different lines
- Unlocking spreadsheet
- Sumif
- "indirect" question
- Sum even rows
- Inserting blank rows
- Excel Format
- IF statement for range of numbers
- ?compare two address lists?
- retrive parts from the cell which contains Text
- Formula not working
- Simple nested IF statement?
- nested formula
- Problem with IF and OR Formula
- Sum function
- Problems with Barcodes
- 33-Nested If function
- Trimming text
- rounding
- conditional formatting
- Convert text to date dd/mm/yyyy hh:mm:ss
- Getting original address of data validation list
- formula needed to split numbers
- Find Min
- Combining 2 Formulas
- vLookup for Multiple Variables?
- How to require a value be entered in a cell?
- Finding Duplicate Data
- Max Date
- Julian date formula
- Conditional formatting
- Count or Sum
- Kind of Sumif but with 2 criteria
- Referencing Next Column Over
- Excel Always trying to "calculate" after entering a lot of lookups
- formula for “more than” minutes
- Conditional Formatting Formula for zig zagging data
- Find & Replace in Forumlas within Auto Shapes
- Formula Help
- Formula copying problem
- formula Countif Function
- Consolidating worksheet data from many workbooks
- Copying from an array conditionally
- Range of cells
- sumproduct or index
- countif & countifs
- Complex Lookup Question
- Assending dates
- Ignoring Empty Cells
- Conditional Formatting based on 3 different cell values (criteria)
- keep adding 24 after 24hours
- Extracting Month and Year from Date
- Searching among different cells for Different Values
- Calculate grade based on percent change
- Search up from current location?
- Negatives to Positives, Positives to Negatives
- INDIRECT Function problem
- Conditional formating that references another page.
- sumif/countif question
- conditional formatting of entire rows
- Working with dates
- auto complete within a drop down list
- Summing Rolling Ranges
- Matching and adding!
- Insert new columns into data range!
- reduce print size on large sheet
- Linking Worksheets
- formatting changing variable. . .
- return value based on two conditions
- Value in one field to generate a value in another
- VLookup Error
- INDEX another workbook an network drive
- add text to existing cells
- sumif with a twist
- Data filtering problem - challenging!
- MAX function across worksheets with various arrays
- Change date display after specified time
- Vlookup with embedded round function error
- Two conditions - One criteria in Row and another in Column
- Counting items in nested manufacturing build
- Conditional sum for multiple criteria!
- Struggling With How to Create A Formula for Desired Result...
- replicated data in multiple cells on multiple worksheets
- Finding the final word in a string
- Finding the highest value across worksheets and returning the worksheet name
- last populated cel
- setting up a formula!!
- access an excel generated file name
- External Reference
- How do you auto number?
- Counting shaded boxes
- Trying to create codes
- Consolidating tables
- Checking records
- Reformatting data positions
- use more if function
- Change the cell color from green to red
- Salary sheet
- Month and Date only Comparison?
- Month Function Not Displaying Correct Output?
- OFFSET Question?
- Data Sorting
- false>0=true
- function to truncate text?
- Cursor Selection Changes ???
- Search/Lookup Formula?
- Flashing Cell
- IF, THEN statements...
- If Formula < & >
- Error Handling using Getdata
- Create Lines automatically
- Lookup values & return overall number
- Excel Function
- VLOOKUp (Within the Cells)
- Excel formulas not working?
- multiple worksheet scroll
- Adding Rows to Formulas
- how do I make Pivot table update automatiocally when I change values
- =HL12-HL2 (make it so that if I enter 10 in a box it takes hl12 and finds hl2?
- Tab problem
- Time Converted to a decimal??
- Conditional Formatting Formula...
- Double post >>> find and display
- If /Offset
- What functions to use . . .
- military times come up 0:00
- cn't workout the forumula - difficult problem?
- Calculating number of days in each month during a given period.
- IF funciton
- Advanced Lookup and Average Nest Function
- Sorting and offering second choice
- drop menu
- Deleting Check boxes
- sorting Problem
- IF function condition
- Compare Merge cells
- confused formula......, see attachment
- search formula
- Assistance with "IF" "OR" logical function
- Locking PrintArea Formula
- sorting numbers into ascending order
- Nested If.
- Seperating addresses into seperate fields
- Name for a given maximum value in cell
- Forumla for rounding up and down
- Target predictons
- Seperate address fields
- IF statement???
- Tabs
- Worksheet Formulas
- Attributing Values and multiplication
- Capitals
- Removing Punctuation
- Counting dates
- Maximum score in cricket season
- How to separate text?
- replace function
- Reference to fixed cell coordinate
- Remove brackets
- A relative address
- Using cell color as criteria for filtering
- Concatenate cells
- Two If Statements
- Sumproduct / Macros
- COUNTIF solution
- Finding percentage for a new row
- If Statements