- data movement
- Dropdown - option is picked it will return a date
- dsum and ignoring empty cells
- How to fill columns in one sheet based on data from another sheet?
- count cells if one column is blank and the other is not
- Format cells based on 2 criteria
- Date formula
- Return cell contents on a partial match
- Referring with mixed data sources
- invoicing
- Array or IF problem's
- VLookup and Hlookup combined using separate workbooks
- sumproduct to count
- Assigning Multiple Rankings to Data based on different columns
- Converting military time to decimal time not rounding correctly
- Vlookup & Hlookup Combination
- Count Filtered Column Data only
- formula problem
- Copy data from Duplicate Records
- Use dynamic hyperlink to populate cell value
- Return function as an argument
- separate columns
- streamlining a list
- sumif
- IF arguement
- How to get the average of multiple VLOOKUP findings
- Problem with Lookup text and numbers
- Mod function with time formatted values
- Data validation formula - base 60
- Matching data in separate columns
- Using Regression in formulas (Formula too long)
- exact graph date in line graph
- Splitting columns by , and retaining orginal row information
- vat calculation
- Merging cells with comma seperators.
- Skipping Columns for Cell Referencing
- If And Function
- timesheet formula
- Find term on one sheet, put corresponding row on another sheet
- Excel file for a waiting list
- Repeating items a specific number of times
- merge old excel file with new file?
- Time Calculation
- Reset Auto Filters On Exit
- Conditional Formula Switcher
- Vlookup data from Pivot Table in another Workbook
- linked cell - variable rather than fixed?
- Link Multiple Data to Multiple Drop Down List
- Function to identify duplicates
- date, link n calculate
- How do I summarize values?
- Index & Match Fuction
- Summing by Date with discrete conditions
- 1 column that i need to divide into two
- insert row automatically
- Pivot Table - Rankings
- Join 2 Cell to make a new formula
- Change to upper case aft space
- Data from the web
- Sumproduct and Match Text in Cell
- Vlookup
- help on formula interpolation
- Auto-Assigning a (random) Name from list of values
- checkbook reconciliation
- Sorting Function
- Excluding values form audit scoring
- Extract number from alphanumeric string
- Adding up a column based on two Criteria's in a row
- Converting / translating / representing "multiple numbers" as "single unit" ? Table ?
- Using array formula to total entries
- Need function for finding and indicating repeats/duplicates
- Time Left and If/Then
- If's against Vlookups
- SUM cells only below a checked cell
- If Then Statement?
- Showing just the 3rd digit of 3 digit number.
- Available hours calculation in Utilization!!!
- lookup double criteria and sum total amt
- if function
- Timesheet calculations
- Cell with HTML Code
- Using a reference from another page to fill a worksheet
- Count number of dates in one month
- Capture information from one sheet
- summing while #REF! present
- Nested If's/VLOOKUP's
- If statements with multiple functions
- Nested If...then To Lookup Value Based on Two Ranges
- Add spaces in formulas
- Copy Data from another worksheet
- list multilpe info from the same source
- Copy data from one spreadsheet to another with a dated filename
- Formula too long
- how can i select to only view desired columns?
- Sumif from 2 worksheets
- subtotals, percentage charts, multiple sheets
- Paste Special Menu
- Vlookup
- Trying to pull corresponding column value for a particular number
- Highest number in row then info 23 lines down
- distributing values to make them equal
- Data search / filter all worksheets
- Search a range for value and if true put a x in a cell
- Counting the Number of Dates with Matching Month Criteria
- Worksheet Formula
- Removing Information From column A with associated info from Column B then new row Re
- Functions and words in a single cell
- access the auto filter list
- setting up criteria for database functions
- nesting in vlookup
- Associating A Range Of Cells Based On Like Values Of Other Cells
- Multiple If Commands
- Using days of the week to compute work hours
- Excel workbook 2-sided printing
- Financial Functions...which one to use?
- counting number of items after filter
- Replacement Function
- Autofill Dates
- Validation Problem
- Add rows
- holiday tracker
- IF Function outputting numbers in text form
- Simple IF formula question
- how to do autosum 5(4,5) without the numbers in ()
- Match & N/A
- Index a table of contents
- need help with a calculating feild
- indirect trouble
- If statement
- Problem with Indexing
- Count of pairs of cells with diffenent corresponding values in 2 datasets
- Average per day in a week
- Nested Ifs and what's the best solution?
- Index & Match Funtions
- Sumproduct Formula
- Comparing staggered times with total time
- shortcut for summing DIFFERENT cells over multiple worksheets
- question about IF function
- matching last "text"
- hours per week = how many hrs per day
- Hyperlink with formulas in the text
- subtracting custom date m/d/yyyy h:mm
- Colour a whole line on todays date
- Colour a whole line on todays date
- Date Format
- if, blank else if, using text, using multiplpe inputs
- Table Checksum
- Can i make the same change to seperate files
- Matching Data
- text functions - find
- Retrieving from List by Position
- Lookup referencing cell referencing range
- INDIRECT with VLOOKUP problem
- Summarize Data using Multiple Criteria
- IF Formulas
- Simple Subtraction
- Concatenate formatting question
- IF, AND, OR functions in order to get certain value
- counting question
- =SUM of letters and numbers.
- Sumif
- Counting numberical values mixed with letters: Yes, Yes+1, Yes+2, etc.
- Too many arguments!
- multiple functions for one cell?
- Deleting the #DIV/0! from cells
- How do i do "=>2 and <3"
- Quotation marks in concatenate command.
- MPG's between "Full tanks"
- change the column I to D and sum the totals.
- Delete first character of a cell if it is a particular number?
- X Marks The Spot!
- Hyperlink to Protected Sheet
- Hide Tabs
- sum values from every sheet in a workbook- inc. ones that havent been created yet!
- Creating putton to add (or subract) a fixed value from a cell
- Why is ranking formula giving a fractional number?
- Displaying Multiple items in Excel
- Sorting alpha-numeric barcodes
- trying to calculate regular days in date range excluding holidays
- Sum formula error
- choose cell
- formulae that applies to all sheets on opening
- Find last monday in May
- "Last date updated" on spreadsheet
- Risks Matrix Help
- Discrepencies with average readings?
- Join text-strings and send to clipboard
- Vehicle Age
- Formating Cell Number Code
- Matching Data from 2 columns
- Remove dashes in number automatically.
- "Dynamic" worksheet/database: 1 with data and 1 for presentation
- look through a sheet, find a text reference, then bring up something in a cell
- Small Function
- Time vs. Temp - total positive slope
- Using SUMIF?
- Average of cricket scores above 20
- Copying cells from to the next available line
- automatically hide cells if no info is reported from another sheet
- Insert row function greyed out
- Hyperlinks from Excel in web browser window
- Emailing From EXCEL
- web query
- SumIf Function
- SumProduct error when using Year , Month and text criteria
- Raniking numbers avoiding those with DIV/O
- Copying Sheets and updating ranges
- Vlookup to find missing or replicated data`
- "if" command formula using Text
- Conditional formatting or other highlighting function
- Forumula to calculate between two dates
- Vlookup- multiple corresponding values (2 separate sheets)
- Data Validation to Ensure Like Numbers in Cell A has Same Date in Cell B
- use text as array arguement
- Automatically changing a Table Array in a Vlookup
- To many IF criteria!
- Tallying totals of ten
- Matching data between two sheets
- Find out the Misspelt Name through Excel Formula
- Sum if
- Sumproduct and Average, Max & Min
- Duplicate / Mirror / Copy Worksheet
- Maximize a ratio
- Worksheets reference series fill??
- Sum across 52 Sheets and Sum Cells D13 thru D19
- Freezing the RANDBETWEEN function
- Change font of cells with formulas
- Random Dates?
- Logical test function problem
- Not all matches matching
- sum if on a range
- Sorting Question
- Table queries
- Daily Compound Interest On Given Amount
- Finding name in list
- Data Validation to Ensure Like Numbers in Cell A has Same Date in Cell B
- Quantity summing with 2 checks
- Running Average with non-contiguous data
- WORKDAY Function
- Multiple Text Lookup
- VLOOKUP to return multiple corresponding values
- SUMPRODUCT - So confusing
- How to combine each word from column A with each word from col B
- If and Vlookup
- Calculate with criteria
- functions with filters
- Logical test function problem
- week number based on year start 01/10
- Comparing worksheets
- SUMPRODUCT with 3 criteria