- Doing a YTD sum - vlookup?
- using vlookup as a cell reference
- dates/ variables/ finding certain values..
- IF(AND)) function: condition is part of another cell's value
- IF(AND)) function: condition is part of another cell's value
- Conditional Formating entire rows
- Random Numbers that don't change on opening
- distributing a part of a number based on a percent
- comparing, then adding
- Search 2 colums, display the value of a cell between the two results.
- [SOLVED] Removing Text from a cell
- Button Functions?
- Comparing columns
- Removing text and dashes CB-PC-150
- Nested VLOOKUP, or similar
- expand menu bar
- calculate number of people
- excel 2002 date problem
- Formula Auditing
- How to remove duplicates
- Remove 1st character if it is 0
- Another IF THEN help PART 2
- If Then Function Help
- Countif, Sumif or what can I use?
- Searching a cell for mulitiple strings and returning a value
- date formula
- Search Function
- Expanding Hidden Rows
- GETPIVOTDATA in Execl 2000
- How to return multiple IF values in a single cell?
- Calculating payroll
- apply color to a cell using a formula
- Identifying matchig text values from two different columns
- if the current row is same as below row number?
- [SOLVED] Looking to add time to a time
- Comparing two worksheets and matching data
- Comparing Worksheets
- Nested formula's, data from 2 sheets.....
- Using probabilties
- Formula from new excel to old one
- Values won't update after copying
- Convert mm to fractional inches
- Time troubles
- Bold results with IF function
- auto insert path INTO a footer
- Formula to Sort a Column
- Sum product using time range
- Calculating Commissions for Different Pay Rates
- Enter "ABC" if previous cell is "XYZ"
- Sum data if 2 conditions met
- Mark the order
- serial (ordinal) numbers after filtering
- If function?
- vlookup/if formula not working as expected
- Formula for differences
- Strange MOD() result?
- Counting enteries with a time frame
- recurring functions for newly added rows.
- Formula about summing cells
- Sumif problem
- File referencing
- substract two time logs based on a string
- formula to return payment to yield desired IRR
- Multiple IF Functions
- ISBLANK Across multiple sheets.
- Formula to return the balance of the first in first out?
- removing - from numbers
- Blocking cells depending of the time period
- [SOLVED] Counting Days in Date/Time Format
- Summing $ Amounts, using a date range, and key words in other columns as restrictions
- Extracting data via lookup from Multiple files
- Limit calculation
- Can row number in index forumla be referenced to several rows?
- how to change column into row
- Search multiple tabs for number in string
- Incremental dates with an exception
- How to select figures?
- compare and extract missing data from 2 sheets
- Add 0.25 if function not adding
- return all unique values
- finding a cell from a value inside another cell
- Counting Events with 3 criteria
- Return name of month based on single digit number
- Conditional Formatting
- Sumif across multiple sheets.
- Countif Greater Than/Less Than Date Range
- Cross Referencing two spreadsheets? (vlookup)
- Summing data from one fixed date to between two others.
- Display blank cell rather than error?
- If Formula not working correctly on two identical sheets
- If-and formula working incorrectly
- When updating linked info from external workbook why does it say file not found?
- Min Function and averaging two groups.
- Remove Hyperlink
- How to sort Single Letters before Double Letters
- Dynamic dropdown list quandry
- Formula for adding allowances
- Sum a range when a condition is met in another range
- Multiply IF formula?
- Sumif, Averageif, Countif, From a range
- Matching Function
- Use the Drag Down to continue a sequence?
- date range for autofilter
- paste special - charts
- Print formulas
- Match on General Format
- locating cells that add up to a given number?
- Do not want to add an IF Formula if value is blank
- Graphing the sum of an autofilter result
- Find and copy between sheets using function
- Over time Calculation
- Multiple rounding conventions per row/column
- alternative to too many nested IF statements
- insert reference into cell
- Equation Question.....
- Advanced Function Help Request
- Using the SUMIF function to calculate mutiple columns
- Summing Column within date range
- copy down
- Offset with Vlookup advice please
- Lookup Function (I think)
- get name from a different worksheet using and id field
- SUMIF question
- calculating days between 2 dates
- lookup from another sheet
- Vlookup Error
- VLookup Error
- formula
- add value '1' to cell based on time.
- Autofill: Change direction
- How to Use reference cell or this purpose?
- if formula
- calculating using absolute cell reference
- Lookup or Macro ? - Not sure which is best?
- Vlookup longest three times
- Vlookup for multiple columns
- Date Format
- Sum up qty of the Duplicates
- value at random intersection of row & column
- Working In Dozens
- Skipping rows, copying, subtracting...
- Assign Numbers to letters sum and average
- [SOLVED] COUNTIF: for the number of occurance of each term. ONE code for whole doc.
- [SOLVED] Establishing a Time Interval
- How to edit DBF file in Excel 2003?
- Referencing Data
- Vlookup, or do I need a Macro?
- Auto formatting a time in a cell
- Dates and conditional formatting
- Help with countif formula
- Countif with Merged Cells
- Difficulties
- Function to turn empty cells yellow
- Technical Lookup & DCount Query
- Extracting text from a string
- Is V-Lookup suitable
- Golf Score card with bets
- Any help with a function please?
- Auto Charts with expanding data???
- Total of top 5 cells
- COUNTA and Ignoring words
- count /sum/sum product from multiple criterea
- Projecting Jobs due calendar
- Subtract a % from a single cell entry
- [SOLVED] Sum within a date range
- How to do amortization schedule with 30/360 year
- Help with formula
- Deselecting Highlighted Cells
- Choose formula needed
- Distributing string\char to each cells
- sample
- 3-way SUMPRODUCT
- IF, Wildcards and Search Oh-My
- Need help with SUMIFS function please
- Rank data by names
- [SOLVED] Copy & Paste Formula
- Columns - Expand and Collapse
- Combo box
- HELP!!!! Formulas
- Linking cell color to dropdown list values
- Extracting Numeric data from a string
- Calculation
- Formula Writting help for CRITERIA.
- Rank Function & Problems with a 0 in the denominator!!
- Absolute References
- Calculating Vacation Time
- Different partner each week.
- Subtotals - Across Columns
- Fomula to calculate supply vs Demand - Stock
- Evaluate expression to an argument
- Transpose AND compile data for unique identifiers
- Totalling
- Summarising data from a number of worksheets
- e-mail address
- SUMIF embedded with AND statements
- Looking up and returning value
- [SOLVED] Search from every row of column in a column and return row number
- sumproduct help
- [SOLVED] merge date/time value , concatenate ?
- Separate text and numbers in excel of variable length
- Recording Monthly Billing Formula
- Summing up totals of populated fields
- Pull data from a matrix table into a report using 2 report conditions
- hope there is a formula
- auto complete data in row
- Tricky Q for a clever guy/gal
- Array formula returns a 0, but I don't want it to
- SUMIF multiple criteria and dates
- Ignore Characters when using VLOOKUP
- VLOOKUP error when nesting within an IF statement
- Lookup full name
- Trouble when inserting row into data when referenced for combo box
- Error: 'Workbook contains one or more links that can not be updated'
- sumproduct: 2 crit: (employee and values between dates)
- Countif Problem
- Protecting a worksheet
- Delete everything before and after a "."
- Average cells which meet condition
- [SOLVED] Calculate dates/times using If Statements?
- Identifying cells that match each other.
- function that enters the corrent date automatically
- How to calculate 2 Rolling Averages?
- using vlookup with 'contained strings'
- Countif based on Criteria
- Insert "Total" each time cell value changes
- Calculating Business Fiscal Year
- COUNTIF function
- [SOLVED] Function to List Data
- =IF(AND(OR function
- Using =If formula to match criteria problem
- Calculating between sheets.
- Novice stuck again
- Negative value causing issues
- [SOLVED] averaging formula
- color cell
- #NUM! Error and Formula Updating Problems
- Combining 2 formulas to remove #NUM! error
- Generating unique pairs from a set of numbers
- VLookup
- simple daily interest
- Picking up a cell value
- search for cell info between 2 sheets
- Filtering
- lookup function
- Highlighting a row red if a specific date has passed.
- Increment dates by 2 days
- Vlookup help
- lookup
- Referencing a worksheet on the server using VLOOKUP?
- Simple formula question