- SUMPRODUCT and calculating an amount
- Lookup - Not all values in Array
- Unsure of how to do this..
- filtering and linking it to a print/save function
- Formula Worksheet
- add a character to every cell
- vlookup in second column if first result no good
- Pivot Tables - Extend pivot range with new data added at end
- Past date to Present Date Calculation
- My color has disappeared
- Cell Coloring
- I would really appreciate some assistance
- Formula to match data & Populate Column
- I need a help in solving this problem
- Offset function
- Newbie and weird one
- Concatenate from a reference
- Can anyone optimize the code? (to make it work faster)
- pulling infomation of specific sheets, depending on a logical test
- If or equals function across worksheets
- Excel help
- counting how mant times a date appears in a cell
- Nested IF Driving me crazy
- How to return blank cells only if a certain condition is met
- Count Distinct Query
- Repeat formulas in a range of cells
- Count the hours of each day for the month
- time sheet total hours from time
- Calculating Current Finacial Period
- Nested logic? Array formula?
- Building The Isna Function Into My Formula!!!
- Entering multipal Dates
- Transpose Question
- Problem with calculation
- Formula Help- Inserting characters around cell contents
- Copying EXACT formulas from another page
- Calculate future dates at 6 month intvls...?
- Year-to-Date totals for each person
- How to fill in Blank Cells with series?
- Calculate exact number of months
- Removing Doubles
- VLookup with Multiple Criteria
- Re-calculating data in separate rows
- If Statement
- Hyperlink from one book to another?
- is this search possible?
- Method to exclude data
- Formula help
- Rifle Scope Navigation
- Scale, Size
- problem in my countif
- pull header into column
- Calculating profit and loss
- Mail Merge Help
- Deleting Specific Row
- Sum IF Help
- How to calculate how much I can spend each year of a lump sum?
- Help with nested IF functions. Help -- I'm so confused.
- How to use labels or Intersections to sum data
- Multiple countif, 2 criteria
- count calc
- Array? help needed ...
- Corresponding value from MAX function
- Excel Graph Trendline Error - Polynomial
- Is this possible?
- formula to crop cell content?
- copy all rows from worksheet1 with matching value to worksheet2?
- Finding same patterns in groupings of cells
- remembering a previous score after updating
- count if
- Merging records / creating new columns based on duplicate records
- file name in a cell to use it as reference for formulas
- How to split alpha numerical noise/ wildcards
- Declining balance,hide totals until...
- count of occurances of varibles
- Formula to Delete daily values
- matching cells from diferent worksheets
- how to do sort and count?
- COUNTIF Function using more than one criterion
- How to protect the Excel VBA code
- Mail Merge from MS Excel to word
- lookup text
- Remove leading zeros from a function
- IF statement with range of numbers?
- LOOKUP function fails
- Problems with SumProduct and Dynamic Ranges
- Trim words
- Is there a workaround I am missing here? (INDIRECT and linking across workbooks)
- rounding within an IF function
- Collecting data from many sheets
- Tables
- Having trouble with OFFSET Function
- showing formula as text string rather than result
- moving formula
- picking out odd and even columns
- Count each name once
- excel funtion to remove all special characters
- Formatting a blank cell due to another cell (Conditional Formatting)
- Page layout?
- Data continuation collumns
- SubTotals
- Description should automatically appear in the column when I click the part #
- Adding question
- COUNTIF, SUMIF or other?
- Varibles inside formulas!
- Summary: To-do list
- Select Certain Samples
- Match a cell & replace a row
- Formual for number of Characters
- Shading cell(s) due to response of another cell
- Column Formatting
- Multiple Conditions
- SumIf by day of the week.
- date subtraction
- Hyperlinks and linking one
- conditional drop down lists
- Excel data lookup
- count function
- Matching data series
- Drop Down List
- paste as values to column with autofilter
- AVE cells with missing data
- A summary page sorted by value?
- Counting unique values
- linking cells but still being able to input data?
- Disabling a cell if it's neighbor has a certain value
- Automatically adding IDs next to names
- Comparing a date to today’s date?
- Multiple values in one cell?
- sales spreadsheet
- Find row number of largest value in cell range
- Random Output
- Function recognizes two columns and adds total of two other columns
- adding cells from multiple sheets
- cell references lost after sorting
- correl function
- Date COUNTIF
- auto complete words that already appear in the same colum
- Conditional Formatting and list of Criteria
- gettings months from date range
- Conditional Formatting
- count unique values if...
- search and sum
- Searching multiple columns on multiple sheets
- conditional lists
- lookup
- Locking columns
- formula too long
- Match question
- Trying to count how many 2 or more combinations
- Rounding up partial months
- V-Lookup formula copying problem
- Ignore Duplicates in Counts
- Match data in two columns and import third
- Connect a row of cells
- Lookup_value and Concatenate
- Trouble with #Div/0
- How to link to other workbooks "conditionally"?
- Weighted Average Formula Population
- LOOKUP question
- Validation for Time
- Xirr
- List Box
- Extracting Hours from a date time 'string'
- Lookup
- Copy cells containing $ sign but still adjust cell number?
- Conditional format
- Need help coding string manipulation!
- Searching columns
- Filtering Auto Sum combination
- Change text Colour based a another cell
- equation question
- If And
- Return the last value >-1
- Formatting Cell to highlight when data is changed
- sum certain cells based on criteria
- Offset/Match formula - range limited
- Search columns and rows by input and replace
- Sum excluding n/a's
- Advanced Filtering with multiple criteria
- Extract data from a date
- which lookup?
- Merge table columns and data from various excel workbooks into another
- Removing unwanted equation
- Multiple condition SUMIF
- value not being transfered by vlookup function
- dynamically linking multiple identical structured files
- Lookup problem
- Match neg numbers to pos
- Link/Fill but transpose
- Reference to tables according to a pull down selection
- SumIf Formual
- Variable Percentage depending on Value
- countif
- "if" formula
- Testing a cell for value
- Tabbing through cells
- How to write this formula
- Sum of Product of Multiple Pages
- offset/indirect
- Dependent Validation
- How to round 8.93 to 8?
- Combining 2 cells numbers unless one doesn't exist
- Combo Box In Worksheet
- Compare Parts of a Cell's Content
- VLookup cannot be found in the WorksheetFunction class
- embedded pdf file???
- generating "meaningful" analysis...
- Search Worksheet
- Goal seeking to a value contained in the spreadsheet?
- Counting duplicate values
- SUMIF functions behaving awkwardly
- calculating the number of instances...
- Lookup value in a table
- Vlookup and Data Validation in externa file?
- shared workbook problem
- Conditional dropdowns?
- Simple Total of Two Columns Containing Numbers and Words
- SUMIF multiple criteria
- Auto-Filter
- Worksheet Comparison
- Linear pattern
- Deduping in excel
- Deleting Cell Values
- wildcards in worksheet functions
- input military time
- Summing total from imported data
- How to count dates
- Trying to find a match
- conditional formatting in excel
- Hiding a list on auto filter
- Time Sheet Spreadsheet & Multiple IF Query
- Counting cells based on multiple criteria
- Cell referencing across multiple worksheets
- Dynamic Cell URL's from Tracking Numbers
- Nested conditional SUMIF?
- If, Then? or Lookup?
- attn: baseball fans.. formula for career similarity scores?
- Get Excel to ignore the first 4 zeros
- Vlookup based on 2 colomns
- Some Subtle Issues with Some Formulas
- Return a number from list
- vlookup using 2 lists
- Trying to reference a horizontal row in a vertical column
- Lost drop down menu
- lookup question
- Rounding to Multiple of 0.5
- Lookup
- quick and easy one =VLOOKUP nested
- Put "1" in non-empty cell