- SUBTOTAL not updating correctly
- IF validation for time totaling
- VLookup IF word in string exists within cell, use the word.
- Using countif with multiple criteria
- List with Duplicates to uniques list
- Drop Down List Dependant Formula
- Testing a cell value for a specific weekday.
- IF Statement for Selection
- YTD SUMIF based on current date
- How to ignore a column of numbers in Grand Total for rows
- COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
- How to calculate time percentage of number of parts being pick in a timeframe
- Copy columns, but not hidden ones
- Can I add a range and then divide that sum by a specific value?
- VLOOKUP, a table with text and numerics
- Index Match Max?
- Lookup in multiple & separate cells
- If value between 2 numbers
- ranking data by a numeric value
- How to reset excel worksheet form lilstbox and combo box
- Multiplying a Number Found in an Alphanumeric String
- excel
- count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
- Excel 2003 "If" function
- Active Calendar
- Re: Antilog
- 2 dimensional date sort
- Calculate total by row number
- excel formulas
- Match/Index/Sum function with date range
- Learning arrays.
- Countifs with different restrictions
- Index and match if field contains specific text in it
- Calendar Logic: Recurring Dates
- How do I assign "Apple" to a cell reference in this evaluate code?
- *Issue* Concatenate dates in a large range of cells in a row.
- NumberFormat for small non-zero numbers?
- NumberFormat instead of an IF
- Replace data to right of string problem
- date & Time
- COUNTING THE SAME VALUES IN A SHEET
- IF statement not returning correct answer
- Multiple If statements, Calculating quarterly % holding costs
- Protect and Edit Object
- sorting noncontiguous data with exceptions
- Lookup Formula Assistance
- Matching two columns of data
- return a value depending on two previous values
- Simplifying multiple IF statements?
- IF/AND/OR Statements
- Calculating the change in lead times from a table.
- Vlookup and return sheet name also
- Re: Bitwise Functions?
- Standar deviation across sheets help
- Identifying common data between 2 cells
- Need help finding a substring in a array of strings.
- Evaluate Multiple Cells for any Value
- Multiple VLOOKUP in an IF statement
- Return Column Header from an Index/array, finding Large with a userinput date
- Validation of cell based on Drop down list
- Scaling multiple columns
- Need formulas for searching for a value in a table and returning row/column name
- Using IF, AND and OR functions together
- Need help calculating probabilities
- Formula I can't figure out
- Month Calculation
- Search Text and Add a Blank Line
- Pls Help - blank cell/formula issue
- VLOOKUP or SUMIF for Multiple Criteria
- Time Zone Conversion Table
- Help. Trying to do the opposite of VLOOKUP
- Setting a range in a named range
- Help on the Sumif Function
- Stumped on how to complete.
- Count value in range, but exclude based on adjacent value.
- Remove punctuation mark, Split cells & average accross column
- Summing up cells based on names in adjoining cells - I'm new to using functions
- Conditional Formatting - Assistance Please :(
- How to do a lookup with 2 parameters?
- Median Formula not working properly
- Countif with two criteria
- Need a function to match unidentical strings
- Vlookup
- Date reformatting question
- Copy values for every nth cell
- Calculating Future Value
- LOOKUP function??
- Simple COUNTIF function help
- Generate 1 or 0 in xls with input probability
- Help Needed! Using complex IF function
- Convert Number to Text for Index/Match
- Help needed: Minimum value based upon either/or criteria
- Sort column beginning with blank?
- INDEX MATCH SMALL
- Name break into half and reverse to upper case
- Splitting a number in one cell into other cells
- Please Help! Delete all cells in range except "1934 - 1934"
- help w indirect and index,match
- Re: Table "What If" Set Up If I Change One Or Two Variables
- Extract the 2 Lowest %
- how to count rows if 2 columns partially match
- Calculating time for 3rd shift
- Computer Properties
- Price Elasticity
- Postal code to Area translation
- Club Accounts
- Possible Sumproduct with Or Function
- preserving zeros in spreadsheet
- coding descriptors
- Countif with dates
- Change font size of Combo Box from Form tools
- Extract Alphabets and Numbers from a Cell
- Muti-result for lookup function
- range definition by cells numbers
- Logical formatting for multiple values
- Preserving trailing zeros for a fixed width file
- Compare a column of substring with another column of strings and get count
- Multiple Criteria Lookup
- DATE Calculations in pivot table
- Conditional Formatting Formula
- Formulas won't function
- pivot table to show date ranges and if over date
- Counting number of cells until a criteria is met
- Excel VBA macro, search - accumulate - delete original
- Automatically sort alphabetically ignoring header
- need help with Formula
- Counting number of days in several periods ignoring repeating dates
- Lookup Value From Sheet2
- Simple (maybe) percentage forumla
- percentage calculation
- Convert number to text as displayed
- Extract first and last login time for each day only
- Add time when working 3rd shift
- Series command grayed out
- Nested If Statement help
- Detailed Countdown
- Excel 2010,Voice Win7
- Counting cells with SUMPRODUCT and conditionals...?
- help!
- Distribution of capital contribution
- VLookup sum multiple matches
- Conditional Formatting - Dates
- Parsing full name into salutation, First, middle, last, Suffix
- Display next available number
- Vlookup a subtotal
- Vlookup Returning Zero For Every Cell
- Show latest date
- Search for string based on two columns
- Return a value if a range of cells contain text
- Help with complex IF statement
- Search a range for instances of a text string, return neighboring cell values each ti
- Extract Date formula Only
- Problem with formula for finding last greater than/less than or equal to value
- Unable to nest my IF statements properly
- Complex Lookups
- Using IF and VLOOKUP for range of cells
- Wage Calculator Q
- display Column Header based on cell value in a range
- Calculating days spent to complete a task
- Referencing an External Cell
- Possible to determine whether any one instance within many satisfy a criteria?
- Deriving several lists from a master list
- Sum of values in column A based on 0/1 of column B
- Allot Seats to Students based on Choice & Percentage
- Trying to count based on multiple criteria & cell comparisons
- Compare 2 lists and return value
- Help! Is this possible
- Excel time leading 1st ZERO
- Solve for a number (x)
- If Statement in Database Query
- How to work out working hours?
- Sorting by frequency
- Urgent help with Excel formula. Please please help
- Findiing highest and lowest in rows and columns
- Conditional concatenating!!!
- Excel: Probility
- Making data in appear in one worksheet from another
- Filtering Spreadsheets Using Multivariable "Or" Statements
- Command Button to create a folder
- conditional formatting update issue
- how to convert numbers to barcode in excel sheet
- Compressing multiple functions across an array into one cell
- Joining VLookups with line breaks but ignoring blanks
- SumIf and Vlookup together?
- Multiple Nested If Function
- One lookup option
- Function to Combine Names and Middle Initital In Various Formats
- Function to Combine Names and Middle Initital In Various Formats
- How to calculate difference between two date & time along with working hours and days
- countif, isna, or vlookup
- Solver Compiler issue
- Countif year = help needed
- Conditional Formatting discarding zeros
- Sum of Variable Cells in a fixed Row
- Help in Median of a quartile
- Index Match function for lookup HELP
- Re: How do I convert cubic feet to cubic meters?
- Formatting a spreadsheet to calculate difference in dates etc.
- Totaling Categories - Monthly and YTD
- VLOOKUP Help
- Lookup function to return highest value
- Lookup function to return highest value
- Calculating nr of books a certain author has published
- consolidation data in one row
- Re: Thank you Bruno!! One last question - "Test2.xlsx" 7948 Bytes yEnc
- Array formula lock-up
- AverageIf function with multiple columns
- calulation
- table to single row
- 12 columns by 8 rows to one row
- Use an "OR" around nested IF statements
- Re: Bruno... Sorry for being a idiot... - "Test.xlsx" 10.8 KBytes yEnc
- Run-time error 1004: Unable to set the left property of the OLEObject class
- Help with count/sumif
- Help with "IF" function
- is there a way to cut and paste text into excel with each paragraphimporting to it's own cell / row?
- Re: Bruno thank you very vary much... But I have an issue - "Test.xlsx" 10.8 KBytes yEnc
- Index function with duplicate Data.
- Lookup Across Multiple Rows / Columns
- Don't know if it's possible, but...
- Problem with averages..
- Re: Bruno Thank you... But I have another question - "Test.xlsx" 8872 Bytes yEnc
- COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION
- Multiple logic functions with multiple sums
- I need Help
- Re: Help with Convert Latitude/Longitude to Decimal - "Test.xlsx" 8856 Bytes yEnc
- Over time?
- Recent form / Results
- Help!!!!
- match some character in b1 to c1 and display on d1
- Randomize numbers
- How to Count Strike throughs
- Looking up Duplicate values in table
- combine three if functions
- Remove numbers from text cells
- Help with IF function
- Need help with SUMIFs
- Help on randomly selecting cells to SUM
- SUM FORMULA- skipping every seventh row
- FV when compounding occurs every 30 months
- Formula Help on Interpolation
- Get sum of values in a cell based on unique values in another cell
- sumif issues
- Countif formula perhaps
- Course completion
- SUMIF with broken range
- the specified form cannot be entered because it uses more levels of nesting
- If formula producing #VALUE Error
- Match Array returning #NA, Works individually
- Returning next item in list
- Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column
- Condtional Formatting or LOOKUP ?
- merging duplicate donors and donation amounts from different years
- order of months in pivot table
- Excel Template required for Daily managing daily income and expense at Mobile shop
- Counting Text
- sumproduct
- Have the SUMIF result (formula) on a separate sheet/tab
- Matching people to skills.
- formula issues.
- countif and sumif
- Blank until data is entered
- Help decipher this code PLEASE!!!
- IF and IF and IF
- Countifs with error #Value!
- Formula not being Friendly
- freeze first colums and hide one colums
- Calculated % completed by date
- formula to work from data column
- Date Format
- Issues when deleting cells with multiple versions of Excel
- stock remaining..
- Vlookup?
- First row where a cell is zero
- Enabling Macros message when NO macros in workbook
- copy specific cells from sheets if the information is correct
- split range address into individual cell addresses
- Variable to rename a tab in a worksheet via VBA
- AutoPopulate DATE in Excel
- Using formula to convert date result to text
- Representing letters (and symbol) to different numbers
- Referring to a cell by using another cell for the row number
- Highlighting duplicates on different sheets
- Row reference for consecutive series calculation
- How do I sort data
- SUMIF returning incorrect answer
- Vlookup not locating file
- IF ARRAY with multiple conditions.
- edate 1 March!!
- Needing help with a Function on Excel.
- Calculating an average of data between two dates
- Need to extract text between numbers in a string
- Here is Mortgage Calculator with Amortization
- Need urgent help with Excel formula
- Excel formula not able to work this out
- Date Range and Time Range IF Statment
- Getting text or numerical data from the formula
- Secondary axis alignment
- dragging formula is giving me undesired result in cell calls.
- Help? I need help in making formulas work to accomplish...
- What's wrong with this IF?
- Lottery Check with Winnings
- Help? I've been thrown under a BUS and can't get up
- Separating data in a row into new rows
- complicated lookups?
- Return text if column and row match values
- Keeping cells blank even though formula is input
- lookup needed to give value where the lookup value is a string within a cell.
- Excel Logical function
- Conditional formatting a big size
- Returning values listed under multiple conditions
- Lookup and Vlookup
- Probability of Time Loss, Non-time Loss and Fatality
- Saving as UTF-8
- Auto Sum not working correctly
- Conditional Formatting - Cannot get it to work, please help
- How do you make a summary sheet?
- Group & Sort with formulas (HTML)
- How to get a formula result to return either "+", "- ", or "="
- Formula help needed
- Calculating the difference, in hours, between two date/time in two different time zon
- Date Range Formular
- Counting # of entries for each month, in a specific status
- averageif cell doesn't contain "text"
- Using 'indirect' function with full network path
- Formating a row based on one cell's date
- Chronological Formula
- Multiple formats in one cell
- Formula to choose from the last column of a given row
- Function to return the highest combined value of ANY two values in a list?
- Need conditional formatting help!!!
- Return a Header Value with 2 vlookup criteria
- Change Color of Cell based on Date and today's date.
- Ambiguous name detected: worksheet_change
- Pivot Table Mapping
- Linking data from one worksheet to another using ookup functions
- Zero Occurance
- Regression Analysis on Excel
- Count Dates in a range based on Column Header Id without using sum-product
- What does this formulea mean?
- Aggregate multiple unique values and return top 5
- SUMIF over multiple spreadsheets
- How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours)
- blank cell return vs. a 0
- HELP!!!!!!!!!
- Sliding Commission Formula
- Pulling "Title" Attribute from Active Directory
- Converting Text
- Function to pull a single cell from a column into another cell
- partial match help
- Date Functions
- Select a range not equal to:
- Referencing the values of multiple cells in conditinal formatting.
- How to reference a cell based on the minimum of division of two cells, please help?
- Automatic Number Increase
- Scrubbing two excel worksheets, returning unique values from one sheet
- Function to sum values across rows with certain features
- Need help referencing b/w sheets for school project
- Function to Return a Date Value Q
- Lock Cell After Data is Entered on Particular Cell
- how to keep conditional formatting when adding row in middle of range
- Formula: Counting Cells on Different Worksheets
- Find next Sunday
- VLOOKUP text vs number issues returning value
- Dynamic Range for Chart Source data
- Function for returning quarter based on current date?
- Duplication
- Excel PRICE function: How does it compute Issue Date of the Security
- HELP!!! I have written my 1st ever VBA code and need more advice....
- I need serious help Worksheet functions
- match formula
- Index / Match Formula Problem
- Help on "Highlighting" and "Font Colour" functions
- LOOKUP function help
- IF statement reference
- Time formatting - Excel 2003
- Running total with IF statements
- partial text vlookup or lookup
- SUMPRODUCT to exclude text column header
- Formula Help Please
- vertical and horizontal lookup?
- Formula for dynamic data organiztion
- What regular savings, increasing every year to reach goal
- Date Conditional Formatting
- Cell interpreted as mailto
- Copy the content of a cell with Formula
- Formulas and Pc<->DropBox Iphone
- Automatic creation of rows with various permutations of few columnvalues list
- Using sumproduct function to count cell values on a remote workbook
- Automatic rows creation with various permutation of column values
- Auto populate
- Comment in protected sheet
- using an IF or AND function to get next largest value in list
- Average Time Not Calculating
- Formula
- sum columns only if date
- Only Calculating Numerics
- =IF, If only I knew the answer
- Extract Date from text
- refresh?
- Look Up Multiple Values And Returning One Value
- SUMIF with Certain Criteria
- COnverting Weeks into Month (text data)
- Counting with multiple criteria in multiple columns
- Excel Formula - If Cell contains word and select it from a list?
- Using SUM(INDIRECT())
- Quarter function based on current date
- adding multiple values from matched search results
- Function help
- Sumproduct in matrix means
- Creating an Excel Freight Calculator
- deleting numbers prefix
- Advanced Countif/H/VLOOKUP Function
- Dragging down Formulas
- Complex Placings
- Complex
- Autofilling Alpha-Numeric numbers with column headers
- Value of the first day of a year in a list
- Applying Number to Range.
- Using =RANDBETWEEN(a,b) in a paers of a whole colume
- Formula to return a value in column B conditional upon the value in Column A
- Sumproduct Ignore Text
- Multiple Challenging Excel needs....
- Calculating Weeks
- Using a CONCATENATE function with an IF function.
- Averaging times that cross midnight?
- Several projects w/ Excel involving dates ...
- Ranking Q
- Calulating future Age
- Need Help copying part of an Excel Cell
- series of formulas to get to one formula
- Combine files
- INDEX_MATCH or VLOOKUP with multiple criteria?
- Automatically populating cells down a row
- Add Values that Match 2 Criteria Q
- How do I combine/join multiple formulas
- Different Functions in One Cell Cancel Each Other Out - How can I fix this?
- averaging multiple items from one list
- Source information from different sheets with vlookup
- create manufacturing demand based on customer delivery
- Cell reference in formula string displays abbreviated value
- correcting #value! problem
- I can't paste from one cell to multiple cells anymore.
- Possible match and index formula needed please
- Help using the Workday Function
- Conditional Formatting help please
- Assistance in modifying a formula
- Cumulative time calculation in Excel 2003
- Conditional Formatting based on cell text
- How do I highlight past dates
- IRR vs XIRR
- "Repeat Rows" - selected printed pages only
- Spurious Formula Omits Adjacent Cells
- Checkboxes within a list
- Spurious Formula Omits Adjacent Cells
- Max/Min per item from a changing list
- Retreive data for same agent
- Pivot Table Calculated Field
- Rank Formula
- Rank Formula
- Finding dates without attention to data formats
- Drop down box w/contents of different worksheet? is this possible
- Consolidating multiple data
- Is there some kind of memory reference limit in excel?
- Creating list from values that meet multiple criteria from other sheet
- If function across sheets prints value of cell
- Embedded Count If array
- Counting instances of Specific column entry combinations
- reduce data points and average?
- Pulling Multiple Vales From Multiple Cells & Displaying them in one cell.
- can this be solved with VLOOKUP?
- Matching Values of 1 row vs all other rows.
- vlookup issue
- How to Sort and Address
- Conditional Formatting with 2 variables (or 3?)
- Forecast of Inventory - Explaination of Calcuations
- Capitilize last word in cell
- summing individual pitcher stats
- is it a VLOOKUP thing or something else?
- credit intrest on intrest
- Calculate duty payable
- Macro/Forumula to SUM values from Sheet that does not always exist
- Compare identifier columns from 2 sheets - remove rows that are dups
- display repeating row information in columns
- rounding a number up to a certain ending digit
- Need Help With YIELDMAT
- Merging Book Lists That Are In Different Formats
- median array help
- Pick up a cash flow line from a specific date
- Spread values across fields
- SumIf equation question
- Hide rows based on cell values
- Excel macro for row selection
- If statement based on time ranges
- identify which years are contained within a range of dates
- If equation with a VLookUp
- index,match - how to avoid same lookup when duplicates present
- Delimiters in Text to Columns
- Data (group And Outline)
- Extract Month and year from Cell containing date, month, year & time
- VLOOKUP Not working
- If or VLookup function
- Using the IF and IFBLANK functions
- difficult VLOOKUP question:
- Horizontal and Vertical lookup
- How may I lookup and return a value between two numbers
- VLookup Won't Copy down (#REF! error)
- Count if data falls within a range AND that has a certain criteria
- Applying a formula to multiple values within a single cell?
- View sheet from another excel file?
- End Date/Time adding business hours
- Help on multiple criteria for formula and return a date
- Allocate an income payment over a date range (tax years)
- Need to know give matrixes a name...
- Function to establish mortgage bond size.
- I need to add spaces to the beginning of my texts which are numbers
- checking for value in matrix
- Combining two separate lists and creating new values
- Data Validation - Custom question (multiple conditions)
- date/time formula
- search cell for specific text.
- drop down list and Locking certain cells
- Change the colour of a cell if another named cell is blank
- Formula for multiple rows of same value...
- Sheet and formatting programming
- Lookup value across multiple columns and rows
- Conditinal formatting blank output cell
- Conditional formatting code
- attempting complicated IF comparison with end goal easy for future users
- Count Column B if Column A is within a multiple specificed ranges
- check if or not time lies between a time interval
- check if or not time lies between a time interval
- Excel Formula or VBA Code
- Longtitude and Latitude Question
- Count Non-Empty Cells In Each Row
- Conditional Formatting Less Than Today Week Days only
- Percentile on Aggregate data with multiple criteria
- Finding average of top 70% of the values
- Lookup Function help
- calculating times
- IF statement with 2 logicals
- INDIRET fill
- Formula for looking up and copying from another worksheet?
- How do I unhide a row when ENTER is pressed in a certain cell?
- COUNT IF with unconditional AND on cell dates
- how to link horizontal data to vertical cells in a new sheet
- Naming cells
- Data validation help
- Color a cell based on column date and row content
- Function to establish the mortgage bond based on a monthly payment
- Changing cell content on n auto-filtered column
- Adding Periods at Specified intervals
- IF function limitation
- Yield to Maturity
- Adding days to a date - changed in Excel 2010
- Inserting a string in a cell reference
- countif
- countif
- CTRL SHIFT ENTER
- Populating entire rows of data from a master sheet?
- Countif between Time stamps and have - value
- Data Validation
- HELP: IF Statement between Dates for Reverse Index failing
- Excel import from PeopleSoft; formulas dont work
- Determine Resource Allocations by evaluating available time and required time.
- If, And Or
- Match function: error due to format?
- Conditional Formatting
- Match and Populate
- error message "#VALUE!" due to blank cells
- Auto Filter Multiple Criteria
- Template Updating and Flow To Worksheets....
- calculating payment terms "End of Month +30".
- #DVI/0! Error
- Index Match, IF or Vlookup
- can I make an equation to count how many cells are filled below acertain cell?
- Conditional Formatting Conundrum
- Cutting out a process
- Wildcard issue for Index/Match Function when searching numbers
- Triple IF?
- index-match function across different worksheets
- Select minimum with duplicate values to return column headings
- IF Function not working as I want
- Find or Lookup?
- Change row colors based on a cell value
- Change row colors based on a cell value
- Return corresponding information with minimum value
- incrementing batches of numbers
- Search and Combine Rows
- Balance Depreciation - how many years?
- REPOST
- Excel VBA Formula Help
- Combine text under different condition
- Pivot table grouping help
- ranking question
- Combine Rows Based on Capitalization
- VLOOKUP FOR COMPANY AND EMPLOYEE
- How do I copy several rows from one sheet to another...
- Create an array of separate cells
- Lookup matching 3 values to 3 others and returning a value
- Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function
- Excel automatically goes into 'Group' mode while toggling between worksheets
- multiple data sheet piovt table
- list box item
- Select rows which satisfy 2 criteria
- Unique Records in Column
- Transpose multiple Columns to rows
- if and when HELP!!!
- If Function Greater than Less Than
- Counting unique values based on 2 columns
- IF(ISNUMBER question
- conditional validation
- What is the best way to lookup from another worksheet?
- Vlookup/Hlookup confusion
- Hlookup/Vlookup with duplicate datas
- Find max and return corresponding value
- Command Button- Assign Macro & Sheet Protection problem
- How many rows are coloured
- SUMPRODUCT formaula not working
- Highlighting multiple triggers
- VB Function for Copy & Paste
- Creating a spreadsheet for my teenage daughter's grades
- formula
- Changing the color of a cell in excel based on due date
- Reference to a Defined Name in another Workbook
- Fill Series Calculations with Autofilter ON
- Date Reminder
- Conditional Formating based on method of input
- vba delete
- Formula
- nested IF without repeating the condition?
- Conditionally Format Particular Dates
- Help with Address(), Indirect(), Offset
- How to summarize copied data
- how to copy the contents into another cell?
- Auto Populate Sheets by Employer
- Highlight Highest Amount
- Count Blank Cells with Conditions
- Auto adjustment of functions
- how to find out the grade from marks-functions
- Re: Excel Copy tab to tab losing format (solved) check zoom level
- Calculations of Cell after Autofiltering
- HLOOKUP & VLOOKUP Combinded
- Match function
- Using text in VB Code
- Standardizing Addresses Help
- Re: Re: Re: Auto Populate from a Mater List into Sub Sheets
- random of 4 names
- Returning a value that hasn't already been found
- countif
- Alert on my Desktop or outlook from Excel worksheet on due dates
- Worksheet Names using Macros
- Find last date of sold stock and sold price.
- Function Error?
- Histogram/Frecuency for Multiple Response Questions
- calculate last 4 data points in a column (with sometimes blank rows)
- Time function problem
- Login User Form
- Average with criteria for adjacent cells ?
- downloading a template into a new sheet of an existing workbook
- Count partial dates
- [ not responding ] after a sort
- Subtraction from the lowest number postion wise in Column
- Not having luck with any examples of averaging...
- Complex formula to count cells
- Hyperlink problems
- Help with conditional formatting in Excel 2010
- Auto populate randomly
- Help - need to consolidate workbooks
- Editing an "IF" function across a worksheet/excel file
- Date Intervals
- If then Statement for Excel Columns
- Sumproduct Problem
- Power Pivot with 2 sets of values
- Pivot Table and Merged Cells Help
- Enable Slicer Data Refresh in Locked S/S
- RE: CONVERSION OF PA STATE PLANE COORDINATE SYSTEM TO LATITUDE & LONGITUDE
- SUMIF Formula with automatic updating dates in forumla.
- Split Data Series (Lookup, Index, Match references)
- Applying macro to mulitple worksheets?
- Many youths would appreciate your help...
- Creating unique keys
- Lookup against concatenated source value
- Help with SUMIFS
- Function Problem
- runtime error 9 subscript out of range
- Keep original cell formatting when using transpose array formula
- Special string convertion to date and time
- Counting one Character as a String
- Call a function within Excel VBA --- need help can't figure out syntax correctly
- Running Total Question
- Hide/Unhide with cell double click
- Formula Question
- Get Column Header if Condition is Met
- Losing Data From Formulas When Cell Variable Changes
- Dynamically sized table compiled from unsorted rows with blank entries
- Average If
- Sumif or vlookup
- function showing false result when it is not
- Progressive pricing
- Cros referencing Data on Excel
- Sliding Scale
- formula to disperse data to several worksheets
- hi al
- using excel as a markbook
- IF Function -- Return Null Value Help
- How to create a pivot table in a new worksheet by recording a macro
- formula displays as a formula, not as its result
- Large Data File Consolidation...
- Screening through days of the week including time
- VLOOKUP source values are a formula result. Getting #N/A
- Need VB formula to exit workbook
- Cross referencing data in Excel
- COUNTIF - help please
- 2 criteria
- Need VB formula to execute form
- Index and Match
- may need programming?
- Creating Palette Labels at work
- Highlighting duplicates across many sheets
- If statement checking list
- pivot table help
- Present Value Uneven Cashflows
- Help with a formula (calculating totals based on individual percentages
- Tricky one
- help with formula for last input in column
- SUMPRODUCT help needed
- N/A in pivot table become 0
- Extracting Data from Tables
- Formula to match different ranges of time and prices
- open file with multiple types of delimiters
- Multiple Tables and Multiple Pivot Tables Help
- Lookup cell next to data
- Show time as a bar graph
- can you make a cell blink?
- Formulas Still Not Working
- ANOTHER URGENT QUESTION - Sums and Ifs
- URGENT HELP - SUM FORMULA
- How to save random numbers?
- Benefits of knowledge base software
- Calculating what staff worked on which product
- Sort Issue Excel 2003
- Re: Dates
- Formula Based on Values in Named Range Q
- copy cell range in other sheet
- Need VB formula to edit and save data
- Re: Need VB formula to retrieve data
- copy cell by command button
- grouping dates in a pivot table
- Excel and Visual Basic
- IF Function error #VALUE
- 1st numer in string
- Conditional Formatting based on active Named Range; IF Function to VBA
- Cell Range Split into Multiple Cells
- Find text in N columns and one Row
- How to custom format a date
- Average of cells in a column if the top cell is a color
- Shared workbook error message
- Ignoring text in cell formulas
- I do statistical work. Recording numbers in notes,
- I do statistical work. Recording numbers in notes,
- help with Sum in between dates
- Largest value in column A based on conditions in columns B and C
- Formula/Macro Question
- Excel Facetime Measurement
- Big Bertha Thing Halfrail
- SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria
- hot to calculate peaks of an "irregular" sine wave
- Create A Button and Assign A Macro To It
- find and replace numeric strings in larger text strings
- Formula Error When Sorting
- Copy cells in Excel
- First, Last occurance of date in column
- Sumif between 2 numbers
- Min Max Question
- Question about Combin function
- Conditional sum, when condition has multiple values
- Constructing Range Name calls with Concatenate
- How do I have a cell value define a dynamic named range?
- Global Change Of Formula Value
- need help extracting data from cell....
- Formula Using Vlookup & Match
- Excel Macro or Formula Question
- Excel not totaling right amount
- I have a column of numbers, all are positive.
- Excel Currancy Decimals
- Decimals on cents
- Big Bertha Thing monorail
- Distribution between two limits
- Adding values for all rows in a range
- Highlight row
- Vlookup for repitative data
- Vlookup error
- Vlookup error
- I would like a formula that
- return proper match from three columns
- Lookup Formula
- Mixed numerical and textual data
- Combining two formulas
- Cell format
- Re: Need Help With String Concatenation
- Re: Need Help With String Concatenation
- Lookup across a Range
- Big Bertha Thing sedan
- Formula translator Excel
- Listing unique values, frequency, and maintaining list order integrity
- SUMIFS, one criteria range, multiple criteria
- Use array/braces **WITHIN** a formula?
- eliminate negative value from normal random number distribution
- code to unhide tabs based on cell contents
- divide numbers up for a paper form
- Possible to refer to a sheet's object name ?
- Does the order of worksheets matter ?
- setting up a schedule in Excel
- Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS
- Replace a fixed number with a variable via popup
- Split words in a cell
- SumByColor & #NAME?
- Big Bertha Thing tidings
- How to get range names to Apply across multiple tabs
- Changing the color of rows - conditional formatting
- Auto worksheet name?
- Auto worksheet name?
- The effects of time on value
- activity
- GST
- Activity
- formatting a percentage in a cell
- formatting as percentage
- monthly consolidation in separate worksheet
- Copy summary data to new sheet
- Select 3/4 digit numbers from text
- Formula Problem
- Median If in Excel not working
- Using COUNTIF with criteria in an adjacent column?
- Convert room dimensions 13' 8" X 9' 2" to square feet
- MATH COMPUTAION
- Sequencial page numbering of multiple tabs
- removing zeroes almost perfect
- counting absentees
- Row references
- Count Consecutive A's with a reset
- Searching for text within formula
- Sum of squares if condition
- Converting time to Minutes
- Changing function name in formula
- COUNTIF with dates
- SUMPRODUCT query
- Why doesn't this work ?
- Most common word
- Find in a sentence diferent word
- Stop Macro running when I save the workbook
- Big Bertha Thing pathos
- Taking relevant information to sheet 2
- Help With Formula For Cell Addresses
- Formula Help PLease
- test
- test
- Nesting SUBTOTAL with SUMPRODUCT?
- VBA Question (Again)
- Stopping one sheet from calculating
- All sheets in workbook have same rows to repeat at top
- Multiple Creteria Lookup(Between Dates)
- use cell address
- Problemmmm !!!
- Filter problem
- VBA Question
- custom data validation on cells with data validation values
- Help With Searching For Strings In Part Numbers
- Match and Vlookup issue
- Add Time Q
- Advanced Lookups
- INDIRECT with Sheet Level Defined Name
- Excel false positives for circular refs and not updating calculations
- Formatting a two-variable data table
- Noncontiguous cell range
- Last workday
- Any Help Appreciated
- Array Constants
- OR in SUMPRODUCT formula
- How does this formula work ?
- Getting smallest number > 0 in an array constant
- Validation List
- Removing 2-3 characters at the end
- Vlookup problem
- Removing 3-4 decimals
- SMALL function to find X smallest number greater than Y
- SUMIFS with Trim
- Is there a way to change the color
- display date of today in cell X when number >0 in cell Y
- Sumif? Or what to use
- Has =TEXT(. . .,0) been applied?
- Formulas within list fail to update after sorting/filtering
- Big Bertha Thing pin-wheel
- auto date update when cell is occupied
- Problem with pivot tables
- Re: Bullet Points
- quick question on sumif
- User Defined Function Help
- SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN
- SUMMING TOTAL BASED ON CHARATERS ENTERED IN CELLS
- Round Question
- text to column
- auto update on seperate sheet
- Pivot Table Help -filter with creation date
- Counting errors
- Formula help
- I need a help formula
- Converting from Decimal to Base-36 in Excel Formula
- Baffeling IF statement
- Need a Macro
- Skill about VBA
- Fixing date of entry
- BOLD WORDS IN CONCATENATE FORMULA
- EXCEL time match
- Countif item is > = 20% of total of range
- data validation across multiple columns
- Developing invoices with transaction breakdown
- Using the IF and Sheets
- macro to call other macros
- Parent child relation between two rows in an excel sheet
- Query regarding any lookup function
- Big Bertha Thing coil
- Conditional fomatting for cells containing a Comment
- How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars.
- VBA range selection question
- Conditional format
- How to write an array to a range without looping
- Get data from pivot table (using VBA / index and match function)
- compu-mania.co.cc
- IRR formula: weird pattern
- Indirectly us a Named Range
- Printing and scaling: why does Excel behave in such a way? PLZ HELP!!!
- Conditional Sum across WORKSHEET
- Excel 2007 Charts & Memory Leak??
- Copying a cell value from one page to another
- pytanie o kopiowanie bez zmiany komórek w formule
- COPY IF funcion???
- Less Excel more Math
- row totals in pivot table
- Want only rows with populated data
- Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted
- Is it possible to match a cell's contents from a list ?
- COUNTIF with 2 columns
- Modifying a complex date formual to count months
- How to sum x cells that are greater than zero on the right?
- Excel 2007 Chart Data Selection- Arrow Keys Frustration
- Growth Rate for number series
- SUMIF
- Count if "yes or no" in one range if there is a unique number in another
- Re: Re: Try this array formula**
- Parsing Question
- Big Bertha Thing letter
- Problem with Formula
- Copy all text in a string prior to the last period...
- Extracting Data From The Right of a Cell
- Recursive Functions...maybe
- Finding position of last period in filename
- very complex IF function if not an alternative function of crossselection
- colour numbers
- I have a column of numbers, some positive, some negative.
- Countif
- Looking up cells with vb
- get a cell reference as a result of an If Function
- path too long solution
- Consolidate two Data Sets for Making a Report
- Manipulating imported times
- Retrieve data based on 3 criteria
- Function problem with iPhone/Pad compatibilty
- Binary operator >> (?)
- Manipulating matrices of unknwon (a priori) size
- Conditional formatting backwards compatibility question
- Path Too Long fixer
- Path Too Long fix
- optimization
- Count
- Re: time window calculation
- Re: time window calculation
- time window calculation
- Protection
- setting scale for graphs
- Need array formula to ignore hidden values
- Re: Trying to add column headings to array formula
- Print Title
- Basic Probabilities UDF Function Help
- Hide/Unhide Cells
- Calculating Weighted Average
- consecutive blank cells
- module problem
- Formula to separate cell values in a column with commas
- IF this value IS NOT in this range THEN
- Adding Text if Value of Cell = 0
- Help with Xecel Sheets
- Desperately seeking ACTIVE.WORKBOOK function for XLM
- Formula Question
- How to supply Week values dynamically?
- Fixing function results
- Presentation file
- IQR of a frequency
- Countif function Issue