Archive of Mr Excel Message Board
Back to archive home
- $1000
- 9.99999999999999E+307
- Help ?Formula to count the number of days between to dates
- help:formula
- or ' before text in a cell that will not go away. HELP!!!!!!!
- problem with LINEST function
- V lookup updating
- #DIV/0 error message
- #div/0!
- #DIV/0!
- #DIV/0! error
- #n/A error message
- #N/A with Vlookup
- #N/B
- #NUM! and cell references
- #NUM! Error in CSE Formula
- #value
- #VALUE errors
- #value!
- #VALUE! Error
- #VALUE! Error Message from Formula Referencing a Blank Cell
- #VALUE! When adding empty cells on different worksheets
- $ in Excel
- % diff calculation
- &'s and ":"'s and ","
- "average speed" calculation
- "Average" Help!!
- "capturing" an address?
- "CONSOLIDATION" WITH VLOOKUP
- "FIND" EXCEL FORMULA
- "If statement"
- "IF" formula
- "If" statement problem
- "if" statement???
- "IF" with names?
- "IF,THEN FUNCTION" Question
- ( NM ) Aladin..check your mail..
- (1.) Sum values only (ignore text and #value!); (2.) formatting cell based on another cell value
- (Advanced Help) Finding first Non-Negative Number!!!
- (H/V)LOOKUP Function
- ** automatically filling in rows **
- .Setfocus
- ??Volume Calculator??
- @@@URGENT@@@ Custom Function - Vlookup
- {1;2;3;4;5;6;7;8;9;10} to {1;2;0;0;0;6;7;0;0;10}
- =AVERAGE(IF(AND))
- =COUNTIF using two criteria
- =FIND
- =if function
- =IF hide result
- =If(Sum( "Question"
- =IF...Array?
- =INDIRECT Help Needed
- =Left(I1,???),
- =Max
- =month? I need help!
- =OFFSET cell function help needed
- =ROUND or =TRUNC ?
- =Sum with a variation
- =sumif(*)
- =SUMIF([parket.xls]parket'!$B:$B;B4;[parket.xls]parket'!$D:$D) is not working for me
- =TREND inconsistency?
- =VLOOKUP
- =Workday function
- 0 instead of #N/A
- 1st and 2nd non-zero values in a row
- 2 Part: Splitting cell contents + using VLookup Formula
- 2 Questions (Concantenate and Returning Ranges)
- 2000: AGE calculation & EDATE
- 21 = 6+5+4+3+2+1. Help : )
- 2variable vlookup? or extract last characters on string?
- 3 dimensional Lookup
- 3 Lowest Values Function Help Needed
- 3 of a kind, rest delete
- 3d lookup function across multiple sheets
- 3D Formula...
- 3rd time's the charm I hope... need help on vlookup update
- A "reverse" filter question
- A "running average" that averages only the last 8 entries?
- A formula that will change each month!
- a hard one for me please help this site is a god send
- A little help please Hlookups
- a self modifying formula
- A similar Column totalling question
- A stupid summing problem - help!
- A totalled Spreadsheet from an existing spreadsheet.
- A tough one at least for me. Please help
- A twist to my earlier array problem
- a warning message
- A way to compare/checkoff
- A work schedule template in need of one adjustment
- A1 = "3" :: B("A1") = B3
- Aaaagh! Paste Function has ceased to work
- ABS Function
- absolute
- Absolute and Relative cell referencing
- Absolute and Relative values in the same formula...
- Absolute Cell Reference
- absolute cell references
- Absolute Cell References
- Absolute Max
- Absolute vs. Relative cell names
- Access queries and Excel functions
- Accumulative totals
- ACK! why when I place a 3D reference i get #VALUE error?
- across worksheets
- Active cell
- Active cell showing sheet.
- Actual vs. fx results
- ADD HOURS
- Add padded zeroes to value in a cell?
- Add to validation list
- Add up values only if 2 criterias correspond
- adding 2 cells
- Adding a month/.
- Adding a number to a cell on the first of the month
- Adding a Space
- Adding a Stupid Zero...
- adding and subtracting
- Adding business days to a date
- Adding cells in different worksheets
- Adding columns
- Adding days to a date formula...
- Adding hours
- Adding Months to Date Help
- Adding numbers to hh:mm:ss
- Adding numerical values from a alpha/numeric cell.
- Adding only the negative values
- Adding string
- Adding text of one column to text of another
- Adding Time formats together
- adding total
- Adding totals per code
- Adding up the number of cells containing an entry
- adding up totals when printing
- Addition to Function Question
- addition with an unknown range
- additon with unknown range
- Address Function
- Addressing YTD data (with vlookup) on another sheet - please help !!
- advanced filter
- Advanced Filter
- Advanced Help : DMIN function
- Advanced IF Function
- Advanced Number Rounding
- Age in quarters!!! - Any Help Very Much Appreciated
- Aladin
- Aladin
- Aladin
- Aladin - > useage of CSE
- Aladin - Array Formula
- Aladin - Follow up from 11/2 on sumif
- Aladin - Help!
- Aladin - More help needed on setting a dynamic range
- Aladin - thread 21939
- Aladin : 12492.html
- Aladin and Mark W - question on volatile functions
- Aladin or Robb or anyone again :)
- Aladin quick questions
- Aladin, Belarius & maybe Ivan can you give it another try with FIRST EMPTY CELL posted bellow?
- Aladin..mainly....and anyone who can shed lite?
- Alert for matching cells in single column
- Algebraic Covnersions
- Align Data in seperate cells?
- Alligning two collums
- allocating data specific cells
- Alpha & Numeric
- Alpha Numeric Sort Problem (Tough One) For Me
- Alpha/numberic sorting
- Alphanumerics
- Alternative Text to cells??
- amortization tables
- An Average IF problem
- an IF formula, probably
- An IF statements that operates if a cell CONTAINS a word...
- An 'or' command
- Analysis toolpak
- And - Or conditional statements
- Another blank cell question
- Another Brainteaser
- Another form of Duplication
- Another Formula Question.
- Another IF(ISBLANK Question
- another lookup question
- Another multiple condition question
- Another Simple Formula Question
- Another simple quetion for you expert
- Another sum Formula
- Another Sum Question
- Any idea how to do an Autonumber?
- Any idea what's wrong with this Formula????
- Any lookup using multiple worksheets
- Any to Shorten this formula
- Any way to recalculate automatically a user-defined function?
- any way to round to the nearest .95?
- anybody understand UPC codes???
- anyone had problems w/vlookup & network files?
- Anyone willing to help
- appending columns
- Appending Function?
- applying IF function to a range of rells in an entire worksheet
- Approximate vlookup
- APR
- APR Calculation
- APR from monthly % rate
- Are multiple COUNTIFs possible?
- Area of a Circle
- Argument Limits
- Array (score card)
- Array / Lookup / lost the plot
- array calculation
- Array Formula
- Array formula - Aladin?
- Array Formula Counts Blanks as Zeroes
- Array Formula Limations (MMULT, TRANSPOSE etc.)
- Array Formula Problem - Automatic updating
- Array Formula Using the Large Argument
- Array formula, I think??
- Array Formulas
- Array Formulas with multiple arguments
- Array Formulas, Strings/Anagrams (Brainteasers Continued)
- Array functions & TREND
- Array Help Req'd
- Array Help!
- ARRAY OR IF STATEMENT
- ARRAY OR IF STATEMENT
- Array, Match, and Index question
- Arrays misbehaving
- Assign value based on another
- Assign Values
- Assigning a value???
- Assigning Scores to Grades
- Attn: Barry Davidson
- Attn: Juan Pablo, Aladin... These should work, but don't...
- Auto Calc on all sheets on active cells
- Auto Date
- auto date update need help!!!!! any excel guru takers??
- Auto fill / lookup
- Auto Fill with Info above
- Auto Fill-In
- Auto Filling
- auto filling cells
- Auto insert row, zip code, multiple find and replace
- AutoFilter (SUBTOTAL Formula)
- Autoformat/correct in formulas
- Automate filling-in months column
- Automated links between worksheets
- Automatic Date Formating of Data Validation Function.
- Automatic filename
- automatic fill-in
- Automatic item (line) counter
- automatic sum of tabs in worksheet
- Automatically calculate percentages in a spreadsheet
- Automatically copying data from cells with same values
- Automatically increase a number using if/then???
- Auto-updating column to show the last text entry in any row!
- Average
- Average and Round
- Average custom function - PLEASE HELP!
- Average elapsed time of each item in a list.
- Average If
- Average If problem (again)
- average limit problem, please help~~~
- Average of the every 7 rows & Attention Mr Excel
- Average some values in a column based on a text string in another
- Average speed (kph)
- Average time for a column of cell entries in mins:secs is calculated how ?
- AVERAGEIF?
- Averages
- averages
- Averages function
- Averaging a varying number of entries?
- Averaging lowest values
- Averaging w/o zeroes or blanks
- Barrie, Question on your formula
- Basic Excel 2000 Questions
- batting average and on base percent
- Berrie, Juan, ANYONE??? Need help moving data from one column to another
- Best way to replace data
- Between
- between functions
- BIG Question with text and number values
- Binned Averages
- Blank Cell possible with unused Formula??
- Blargh, another counting problem now..
- Boolean if problem
- Bowling Stats
- Brainteaser
- Brainteaser: formula to calculate annual rate of attrition...
- Break-even points and data tables
- Breaking Data in one column to two
- Breaking up combined list into single entries ??
- Building a Conditional Formula with the IF Function
- building conditional formula
- Bump up.
- Calcuate elapsed business date/time
- Calculate absence by month
- Calculate Age in Excel 2000
- Calculate Commission by using vlookup
- Calculate Compound Annual growth rate
- calculate due date and give a warning message
- Calculate on first cell >0
- calculate the number of week days and weekend days in a range in sequencial order
- Calculate time by hours work
- Calculate top 10
- Calculate total time per day
- Calculating # Of hours between two given times
- Calculating %ages in Data|Subtotal rows
- Calculating a percentage
- Calculating age to update automatically
- calculating an interest rate
- Calculating average of a variable array
- Calculating budget spend each month
- Calculating cell entry from a date range
- calculating Compound Annual Growth Rate
- Calculating differences in time
- Calculating formatted values
- Calculating full actual months
- Calculating Holiday Hours PLEASE HELP!
- Calculating Hours
- calculating hours like "networkdays"
- calculating meals per 24 hour period
- Calculating minutes between two Date/Time cells
- Calculating number of employees by month
- Calculating Number Of Hours Worked In A Week????? Help!!!!!!
- Calculating Percentages?
- Calculating performance in Excel using an array?
- calculating the lowest value in a row of pricing
- Calculating the percentage of times a value apperas in a data set.
- Calculating time
- Calculating time differences in Excel
- Calculating time differences through midnight
- Calculating Time into $$
- Calculating total hrs, average per person, and then...amt above or below average used.
- Calculating travelling time
- calculating with time
- Calculating work hours
- calculating work hours
- Calculating workdays vs Calendar Days
- Calculating years
- calculation for discount
- calculations using times
- Calendar object cell link
- Calender
- Calling ALADIN
- Calling Functions from Third-Party Add-Ins
- Can a Vlookup output be automatically alphabetized?
- can anybody explain this code?
- Can anyone handle an argument
- Can anyone help?
- Can I "countif" multiple conditions?
- can I concatenate ranges within SUMPRODUCT ?
- Can I do a Vlookup from the right side of an area ?
- Can I do lookup in different XLS spreadsheet?
- Can I use Excel for this merge?
- Can someone help me with this please?
- Can someone help me with this please?
- Can someone help with this example? Thx
- can someone help!
- Can someone try this and let me know if it works for them - Thanks
- Can the "count if" function save me?
- Can the month be insterted and updated automatically?
- Can tou write a formula based on a cells format ??
- can' use the =
- Can you keep one side of formula from changing while you drag or copy an the second part of formula to change reflecting the column it is under?
- Cannot get data to do a sum total
- can't copy and paste formula from one worksheet to another
- Can't copy cell containing dropdown list
- can't get numbers to round properly
- Capacity Planner
- capital letters in Excel
- CAPITAL to small letters
- Capitalization
- Capitalization
- Capitalize One Letter in Text String
- Capitalizing 1st letter of every word in a column
- Capitalizing Letters
- Caps
- Case Conversion
- Catagory averages are effecting each other , What to do?
- Cell address with maximun value
- Cell Diplay
- Cell filling formula
- Cell Formats and Formulas
- cell formatting
- cell formatting, #value!
- cell formatting. a zero in the column
- Cell lookup returning '0'
- Cell Name
- cell protection
- cell ref. in GETPIVOTDATA function
- cell reference syntax clues?
- Cell reference within a sheet reference?!?!?!
- Cell Split
- Cell Value
- Cell Values???
- Cell Won't Hold Formula - Changes to a link
- cell works out the calculation and places the value in the cell with no trace of its workings....?
- Cell/Column Calculation
- Cells & Rows
- Change Formula
- Change function of key
- change month number into month text
- Change text color of a row if data entered is...
- Change values of X axis tic marks
- Changing a Number grade to a letter Grade...
- Changing a Text String into a Worksheet!Cell Reference
- Changing case
- Changing cell references on a sheet by changin a cell value
- changing colors if ...
- changing data to text?
- Changing formatted dates to true values
- Changing InputRange on DropDown ListBox
- Changing name of vlookup range
- Changing negative values to positive in a column with both negative and positive values
- changing numbers to time
- Changing Prices up a certain Percent
- Changing range name in functions
- Changing rows
- Changing the case - all letters in a cell
- Changing the orientation of a table of information
- Changing the way negative numbers are presented
- Changing values in two places
- Character count for cells
- Check a value in a cell is anywhere in column B
- check boxes
- checking a range for data
- Checking a range for data
- Checking Datatype
- Checking Register from HeLL
- Choosing x cells from y cells
- Chopping of intergers after decimal point
- Circular Reference
- Class detector...
- Cleaning an import into Excel
- Clearing #Value!
- close to commissions problem
- Clustering Of IF Functions
- code to detect data NOT FOUND when using LOOKUP
- coditional? If? diffrent
- Coloring cells "Red" when certain words are entered
- Column and Row Position
- Column Name
- columns
- columns to text?
- Combination of functions
- Combinations for match of predefined sum
- combine 2 cells text into one cell as a whole text
- COMBINE 2 FUNCTIONS
- Combine columns??
- combine hlookup & vlookup?
- Combining "First Name" and "Last Name" columns to one
- combining 2 files with common data
- Combining 3 columns into 1 column
- Combining 3 separate worksheets to get an overall total
- combining cells
- Combining Columns
- Combining columns
- Combining data from two fields into one
- combining date cells with time cells
- Combining hlookup and vlookup
- Combining IF and AND functions
- Combining MAX and OFFSET?
- Combining multiple columns of data - Subtracting date/time ranges
- Combining or merging 2 columns
- Combo Box
- Combo Box & Vlookup
- combo box link field lookup
- Combobox+Automonth
- Commision Calculation Formula that has stumped me.
- Commision Plans (again)
- Commissions
- compare
- Compare 2 Cells for an entry......
- compare 2 columns
- Compare cells - diplay if not identical
- Compare columns
- compare two columns
- compare two columns of data, excel 97 array
- Compare two columns using wildcards
- Compare Two Lists
- Compare two spread sheets and identify differences
- Compare value against a list
- compare worksheets
- Compare, sumif, delete row
- Comparing 2 columns
- Comparing 2 columns
- Comparing 2 columns
- Comparing 2 columns in Excel
- Comparing 2 ranges
- Comparing 2 spreadsheets
- Comparing 2 text columns and extracting their differences to a third
- Comparing 2 Worksheets and Returning Differences
- Comparing a value and outputing a result to a cell
- Comparing and deleting
- Comparing arrays, and comparing columns
- Comparing cell values using "IF"
- Comparing Cells with Text
- Comparing data in 2 columns
- comparing data in 2 or more excell worksheets
- Comparing data in two different spreadsheets
- Comparing date info
- Comparing srtings
- Comparing strings
- comparing text strings
- Comparing two columns
- Comparing two columns
- comparing two columns against two other columns
- Comparing two columns in Excel. NEED HELPFAST!!!
- comparing two excel files
- Comparing two lists in excel
- Comparing VLookup Results vs. Other Values?
- Comparing worksheets
- comparing worksheets for non-duplicate rows
- Comparing/Matching lists
- Comparison
- comparison of data in two columns
- comparring 65000 values, with conditions
- Complex Formula writing
- Complex formula....
- complex really need help from you.
- Complicated Formula Precedents
- Complicated Formula, need help!
- Complicated IF(AND & IF(OR Formula
- Complicated Pasting for QIF format
- Compound Annual Growth Rate
- Compound COUNTIF statements
- Compound Criteria
- Compound interest
- compound interest
- compound statement syntax
- computer vs calculator
- Computing Elapsed Time (hours & minutes in one cell)
- Con Can(')t enate (A tough one)
- Concat
- concatation of cells from first sheet to the second sheet
- Concatenate
- concatenate an array?
- Concatenate Date Format
- CONCATENATE function
- concatenate in a cell and using that cell value
- Concatenate various cells in one organized by column
- Concatenate w/exceptions
- Concatenate with code
- Concatenate/Format
- Concatenate?
- CONCATENATEIF ?
- Concatenating a cell reference
- concatenating a text cell with a currency cell
- Concatenating inside a single function
- concatenating partial cells
- Concatenation / Format $ / Split Lines
- concatenation of arrays
- concatinating 2 cells for export to fast file definition
- cond formatting times
- Condiional Formating
- Condition row counting.
- Conditional Array
- Conditional Array Reference inside of other Formula
- Conditional average.
- conditional cell hiding
- Conditional cell reference inside formula?
- Conditional COUNTIF, SUMIF, etc?!?!?!
- Conditional COUNTIF?
- Conditional display based on another cell
- Conditional Drop Down Box Values
- Conditional Dropdown Menus
- Conditional Format
- Conditional Format based on minimum values
- Conditional Format to yellow if "?" char appears in cell
- Conditional Format tweak again
- Conditional Formating
- conditional formatting
- Conditional Formatting
- Conditional Formatting
- conditional formatting
- Conditional Formatting
- conditional formatting
- Conditional Formatting and Pasting
- Conditional Formatting of Cells
- Conditional Formatting or other solution?
- Conditional Formatting question
- Conditional Formatting tweak
- Conditional Formatting -Using Formula is functionality
- CONDITIONAL FORMULA
- Conditional Functions
- Conditional insert Row?
- Conditional Median
- conditional response function
- conditional return function
- conditional select
- Conditional statement
- Conditional sum
- conditional SUM()
- conditional sumif
- Conditionals
- Condtional Formatting Problem
- Confused..Need Help
- Confusion between NOW and TODAY
- Consolidating a list?
- Consolidating Multiple Sheets within one workbook
- Constant Value In Formu;a
- constructing names in excel (not in VB!)
- Control Array
- control-shift-enter formula
- conversion from time to decimal
- conversion of num to time
- Conversions
- CONVERT NUMBER TO TIME
- Convert 1,223.35 to ONE THOUSAND TWO HUNDRED TWENTY THREE DOLLARS AND THIRTY FIVE CENTS.
- Convert date to text
- Convert from Minutes to Hours & Minutes
- Convert function to absolute value?
- Convert general number to time-of-day format
- Convert hours and minutes to minutes
- Convert Integer (seconds) to hh:mm:ss
- Convert last name comma first name into two separate cells
- Convert seconds into HH:MM:SS
- convert text to number
- Convert time
- convert time to number
- convert time to number
- converting a general number into minutes and seconds
- Converting a letter to a number
- converting a list to columns...
- Converting a numeric score to letter grade
- converting a text string to a formula
- converting an unusual text string to numerical entry
- Converting Cell Data to Time Data (QuiOui)
- Converting column number to name?
- Converting Date/Time to a numeric value
- Converting decimal feet to feet and inches
- converting decimals
- converting European figures ( comma as thousand seperator) from .txt files into Excel
- Converting Excel formulas to VB code
- Converting feet (in decimals, transit output) into English Ft.-inches
- converting hh/mm/ss to seconds
- Converting hh:mm:ss to hours with two decimal places
- Converting negative numbers
- Converting negative values to zero
- Converting Numeric Value in Text in Excel 97?
- Converting over from QP & have formula problem
- Converting seconds (raw number) to minutes (mm:ss format)
- Converting seconds into a calculatable time format.
- Converting Seconds to Hours:Miutes:Seconds and reverse
- Converting seconds to minutes:seconds format
- converting text
- converting text from UPPER CASE to Proper Text
- Converting text to numbers
- Converting text to values
- Converting Time
- Converting time from 3:30 to 3.50
- converting time to decimal
- converting time to number
- Converting time value to currency value
- Converting to Text Format
- Converting UPPER CASE to LOWER CASE
- convesrion of imported data
- Copy & Paste Formula
- Copy a column of zip codes and trim the first digit
- copy data from list based on text value in column A
- copy dates
- Copy incremental VLookup number?
- Copy Info without 0's
- Copy Paste Reference Formulas (but need it to skip)
- copy rows containing specific data to a new worksheet
- copy/paste incorrect
- copying cell
- Copying cell references
- Copying Cells
- Copying data from several tabs
- Copying data from two seperate cells on a line - loop this function
- Copying formula
- Copying Formula only
- COPYING FORMULAS
- Copying Formulas
- Copying Formulas
- Copying formulas without linking books
- Copying groups of cells and incrementing a counter
- Copying Row Labels when using Subtotal
- Copying Row to new range
- Copying select cells
- Copying text between cells/worksheets
- copying the contents of a cell
- Copying to multiple spreadsheets
- correct syntax for and "if statement"
- Correct Way To A Simple Formula
- Correcting Upper Case Text
- Cosolidating
- Count Between Ranges
- count blank with multiple conditions
- Count cells in excell that are wrapped
- count cells in time period
- COUNT CELLS WITH MORE THAT ONE CRITERIA
- Count empty cells
- Count Function
- Count function for unique values in a cell
- Count function frustration
- Count Function in Formula occurances
- Count how many times a customer occurs???
- Count how many values in a column only appear once??
- Count if
- count if
- Count like contents???
- count number of different values in a range ??
- Count occurences in columns, with criteria?
- Count Odd/Even Numbers in a range
- Count of Fill Color
- Count of Occurrences
- Count of specified range of numbers
- count of time
- count only cells with contents?
- Count Saturdays
- Count the number of times a word appears in a range?
- Count unique records
- COUNT UNIQUE TEXT IN COLUMN
- COUNT using coloured cells
- count work days only
- Counta & Multiple Conditions
- CountA if true in two koloms
- Countif
- countif
- COUNTIF
- Countif
- COUNTIF
- Countif
- COUNTIF
- Countif
- COUNTIF
- Countif
- COUNTIF Formula HELP!!!!
- COUNTIF help
- COUNTIF - is this the solution to my problem?
- COUNTIF (?) Interior Color
- Countif / If Function
- COUNTIF ??
- CountIf 2 Variables
- CountIf 2 Variables
- countif across a series of non-consecutive cells
- COUNTIF ARRAY FORMULA
- COUNTIF based on two separate criteria
- countif calculation problems
- COUNTIF CHALLENGE!
- COUNTIF Criteria
- COUNTIF for data in 2 columns
- COUNTIF for multiple criteria?
- CountIf for multiple ranges problem.
- Countif for numeric range
- countif formula with multilple conditions and wildcards
- Countif Function - Nightmare
- COUNTIF Function in MS Excel
- COUNTIF function with "between" condition
- Countif help
- COUNTIF help PLEASE!!
- countif identical cells
- Countif Isnumber(A1:A5) I thought that I mastered Countif function...wrong
- COUNTIF multiple conditions are met
- COUNTIF or not...
- countif problem
- Countif problems
- Countif Question
- COUNTIF Question - how to work around the 3-d reference 'limitation'
- Count-if Question Re Text
- COUNTIF Question re: time
- countif reference to cell
- COUNTIF statement - how can i use multiple args/ criteria
- Countif the number of entries > x and < y
- Countif to count items within a range of dates !!PLEASE HELP!!
- COUNTIF using dates
- countif w/ mult. variables
- COUNTIF with 3 criteria
- COUNTIF with multiple criteria
- COUNTIF with multiple IF's
- COUNTIF with two variables
- COUNTIF within a LARGE
- COUNTIF within a LARGE
- countif(and(
- Countif, In Array
- COUNTIF........
- Countif? Multiple values
- COUNTIF???
- Counting
- Counting
- Counting
- Counting a column of data (some are decimal numbers and some are integer)
- counting a piece of a text string
- Counting a series of numbers
- Counting case sensitive data
- Counting cell with different colors
- Counting cells
- Counting cells BETWEEN two values
- Counting cells containing text
- Counting cells containing text
- Counting Cells With Text
- counting cells within a time range
- Counting Characters
- Counting Characters In A Cell
- counting correct answers
- Counting data occurances in different columns
- Counting dates
- Counting Dates Entered VS Text In A Range
- Counting Days
- Counting different values within a column
- Counting Distinct Values
- Counting first of the month
- Counting for a string in a single cell
- Counting Frequency of Ones
- Counting in Excel
- Counting items from two columns
- Counting Items in an Array
- Counting License Plates
- Counting months
- counting months in a column
- Counting multiple data blocks in a large spreadsheet
- counting names
- Counting Names in cells
- COUNTING NAMES IN DATA BASE
- Counting Negative values in a column of data
- counting nightmare..
- counting numbers within a range
- Counting occurances of a string anywhere in a cell, not exact matches.
- counting occurrences of a text string in a column
- counting pieces, "+2"
- Counting Problem
- Counting salary...
- Counting the # of Characters in a Cell
- Counting the days and formatiing dropdowns.
- Counting the number of days.
- Counting unique entries in a list
- Counting Unique Occurances
- counting unique values
- Counting Values
- Counting values with a non-adjacent range.
- Counting Weekdays
- Counting weekdays
- Counting with multiple criteria
- Counting with out Duplicates
- counting within cells
- Counting without duplicates
- Counting Words
- Counting yes/no in excell
- COUNTING YES'S AND NO'S IN A COLUMN
- Couple of Questions
- Couple of Simple questions - I hope
- course
- coutif - I think!
- Coverting Date to Text
- Coverting rows to columns...
- Create 80/20 Rule?
- Create a Formula
- Creating & Naming a Nested IF(ISERROR(SEARCH)) Statement
- Creating a coloured flag that changes colour over time
- Creating a drop down list in excel
- creating a filename function
- Creating a List - Please help!
- Creating an estimating spreadsheet
- Creating an If/Then calculation
- creating cell references from text values
- Creating date objects from multiple cells.
- creating interactive button functions
- Creating new cell text from existing text
- Cross Reference Lookup
- crossing midnight
- C-S-E Function Help
- C-S-E Function Help
- CSE problems
- CSE problems
- CSE Question "<" insteat of a Constant
- CSE won't work...HELP!!
- CSV Format and list separator
- Ctrl-Breaking out of function leaves #VALUE wont go away
- Cumulative products in arrays
- Cumulative Run Counter when Event Changes
- Cumulative Sum ARRAY Formula
- CURLY BRACKETS
- Custom array functions with indeterminate number of values
- Custom button, How can I change the description of the function
- Custom Function
- Custom Function for Weighted Average
- Custom Function returnig a Date Value
- Custom Function to Calculate No. of Days between two Days
- CUSTOM SORT
- Custom sort order
- Custom Sort Question
- custom validation
- Customized Date Format/CONCATENATE functions
- Daily to weekly summation
- data comparison in excel 97
- Data Entry
- Data export - cell formats
- Data formats
- data point reduction
- Data Sets
- Data Summary
- Data summary
- data types
- Data Validation
- data validation
- Data Validation
- data validation problem
- Data Validation Problem
- Data Validation Query
- Data Validation Query
- Data varaiance
- database
- Database features
- Date + Superscripts
- Date and Time
- Date Arithmetic
- Date as Text
- Date calculation
- Date Calculation for day value without year
- Date Calculations
- Date change
- Date changes - Im stuck
- Date comparison formula
- Date conversion
- Date Format
- Date Formats
- Date formatting
- Date Formula
- Date Formula
- Date Formula
- Date Formula (Repost)
- Date Formula Help Plz
- Date Function
- Date function or Formula
- Date Functions --> Week of .....
- Date in Concatenate Formula In Excel 97
- Date of Year End
- Date problem
- Date problem
- Date problem--still can't deal with holidays---to Aladin
- Date query
- Date series excluding holidays
- DATE SPACE
- date teaser
- Date/Time format problem
- Datefunctions
- Dates
- Dates
- Dates
- Dates - excluding weekends
- Dates Formula
- Dates generator
- Dates within "IF" statements
- Dave
- Dave H - Help with Database functions please
- Dave: Question about duplicate data in new worksheet
- Day of the Year
- Day of week from date
- days of the week
- Dealing with empty cells
- dec2bin
- Decimals
- Decimals to whole numbers
- de-concatenation?
- Default rounding of 0.5
- default to specific value
- Default Value in InputBox
- Define name Problem
- degrees minutes and seconds
- Degrees Minutes Seconds
- Delete a row in an "IF" function
- Delete part of a string?
- Delete query
- Delete rows
- Deleting Duplicate rows?
- Deleting empty rows.
- Deleting last 4 characters in a range
- Deleting stuff
- Deleting the first 14 characters in a cell
- Desperate, need help!
- Desperate--need by tomorrow-please help!!
- despite increased character limitation, my cell only holds 1200 characters
- Determine if 2 cells contain data.
- Determining Whether a Value is Odd or Even
- Dfunctions - Criteria Range
- DGET function
- DGET function etc.. are not workingg
- Diff. Format visible in Formula Bar
- Dimension array
- Directory Path Problem with SHORTCUT
- Directory Validation
- Disappearing Formulas
- Display "0" instead of Formula
- Display an alert if an entered value already exists
- Display info from sheet 1 in sheet 2
- display zero if the calc is negative
- Displaying Column Widths
- Displaying last 10 entries
- Displaying status of a deadline
- Displaying time as quarter units
- Displaying Zero When Sum is Negative
- Distinct Cells
- Distinct values within a column
- Divide by 0 Error using IRR function
- Divide by 0 errors using countif
- divide by zero
- dividing minutes into hours:minutes
- Divisible by 3
- division by zero
- DMIN criteria argument, how to use?
- Documentation for Clean and Trim Functions
- doing count on certain categories
- Don't calculate this row
- Don't laught at me please; how to make Excel know last cell with info
- Double Entry
- double if function; array with two conditions
- Double Lookup
- Double Match - Mark W or Aladin???
- Drop down box
- Drop Down Menu
- drop down menus
- Drop down or combo box
- Drop Down Selection Cells
- drop-down cells-making them appear by Lookup possible?
- Dropping the Middle Initial
- DSUM in Excel 97
- DSUM only allows one criteria to be created?
- Dsum vs sumif
- dsum, array or vlookup
- Dual criteria for COUNTIF
- Dual lookup or index or ?...
- Due Dates
- Duplicate in another column
- duplicate invoice formula
- Duplicate Range names
- Duplicated Numbers In A Column
- Duplicates that aren't exact.
- Dynamic Counting
- dynamic link
- Dynamic Lookup Formula
- Dynamic named ranges and SumProduct function
- Dynamic Numerator...Static Denominator
- Dynamic Population of Data Validation Lists
- Dynamic range
- Dynamic Range Names
- Dynamic Ranges using Offset Function
- DYNAMIC SUBTRACTION - DATES & ABSOLUTE VALUES
- dynamic validation range
- Easter Function help..
- easy check for sheet protection
- Easy one!
- easy one? please respond (re:equations formatted as text in one cell, copied and calculated in another cell)
- Easy Question
- Easy Question : Percentages
- easy way to do computations across worksheets?
- EDATE function
- Efficient Copying Problem
- EIF TBOX1 = 2,4,6,9,11 THEN TBOX2 =
- Elapsed Time Calculation
- Elapsed time calculation
- Elementary Question
- Eliminate #DIV/0 from formula
- Engineering Interpolation x to y?
- Ensure all cells in a column contain unique values...
- Enter name with value attached
- Entering current time in cell with seconds
- Entering data on one worksheet in a certain column and automatically appearing on another worksheet in a different column
- Entering Text and having it represent a value
- EOMONTH function
- error
- Error Message
- Error message help
- Error with Dsum
- ERROR.TYPE
- ERROR.TYPE function doesn't work as shown in help example!
- Error: Formula is too long!
- Escape Character
- EUROCONVERT function & Excel 97
- Exact Value return
- Exceeding limit on nested IF Statements
- Excel
- excel
- excel
- Excel
- excel
- excel
- Excel
- Excel - VLookup
- Excel "If" Statement - What is the correct Syntax?
- excel .csv format
- Excel @@$%$!!!!
- excel 2000
- excel 2000
- Excel 2000
- Excel 2000 Calculation Error ???
- Excel 2000 rounding
- EXCEL 2000 WIN 98 - IF Statements using dates.
- excel 2000, using the if functions
- Excel 2000: Get max value based on a condition
- Excel 97 - conditional
- Excel 97 currency formatting
- Excel 97 problem
- Excel 97: Counting Game Winners
- Excel Beginer in over my head.....Multi conditions
- excel calender
- Excel cell formats
- Excel cell number formatting
- Excel Custom Number Format
- Excel Date ?
- Excel date formatting
- excel date range formula
- Excel equivalent of the Lotus #OR# function?
- excel fiscal calendar
- Excel Fix
- Excel formula
- Excel Formula
- Excel formula
- excel formula
- Excel Formula
- Excel Formula Crisis
- Excel Formula Situation
- Excel Formula Situation Again
- Excel Formula using COLUMN()
- Excel Formula Wanted
- Excel Formulas and Functions
- Excel function
- Excel Function Question
- Excel Help
- Excel Help
- excel help
- Excel If condition
- Excel IRR function
- excel is returning incorrectly
- Excel Issue
- Excel list validations - can i put the list anywhere else besides the spreadsheet?
- Excel Lookup Function
- excel merge ability
- Excel nightmare
- Excel Numbering Schedule
- excel problem
- Excel Query
- Excel question
- Excel rounding
- Excel Rounding
- Excel Running Total
- Excel Scroll
- Excel Sorting Problem
- excel spreadsheet
- Excel Spreedsheet
- Excel Time Calculations
- Excel Time Fields and Formulas
- EXCEL USER-DEFINED FUNCTION USING EXCEL TEXT FUNCTION
- Excel vlookup arrays
- Excel won't recognize CONVERT() function??
- excel,vlookup
- Excel-based language software
- excell
- EXCELL FIND FUNCTION
- excluding holidays
- excluding zeros when averaging
- Exhibiting system TIME on a spreadsheet using the TIME Function.
- Export from Crystal Reports is too small
- Extended Formula please help!!
- Extensive Data validation in excel
- Extract 1st 2 words in a Phrase
- Extract 1st Word in a Phrase
- Extract a number of characters
- Extract a portion of data within a cell...
- Extract Data
- extract numbers in text
- Extracting data that is separated by rows.
- EXTRACTING MORE THAN 1 LOWEST VALUE
- Extracting numbers from a long number.
- extracting part of a code from a cell & using it in a formula
- Extracting time from day
- Extracting/counting unique entries does not work
- Extraction and printing of values from every 12th cell of row
- F1 = Formula = "=subtotal(9,m1:m3000)"
- Factorial
- Fail Result Detector...
- False Return no value ??
- Fantastic formula needed
- Faster Array Formula?
- Feet and Inches Format
- Feet to Inches
- Fibonacci
- figuring occurrence
- Figuring the number of days
- File location print on spreadsheet like word
- file name
- file name
- file name in a cell
- FILE NAMES
- filename
- Filename on Workbook
- files
- Fill in the blanks
- Fill Serial - AA, AB,AC...,BA,BB,BC...ZZ
- Fill without changing format?
- Filling blank cells with neighbouring data
- filling column with n sets of numbers
- Filling down across several workbooks
- filling in the blanks
- Filtering
- Filtering a large list to use SUMIF formula
- Filtering cells in excel by format
- Financial DCF Calculation
- Financial Formula
- Find a text value in a list
- Find a value in a column, paste a row of data
- find all negative numbers in a range and total them
- Find Changes to conversions
- find duplicates in a list
- find function
- Find items with conditions
- Find last cell in row with negative number
- Find last used cell in column
- find maximum value based on criterion in another column
- Find row number of first occurance of data
- Find text in an Excel cell
- FIND THE LOWEST NUMBER IN AN ARRAY
- Find value in 1 col, move to adjacent
- finding appropriate supplier name in table with articles, suppliers and their prices
- Finding combinations to equal the total
- Finding consecutive values in a range
- Finding Duplicates
- finding duplicates
- Finding Duplicates
- Finding integers
- Finding last non-null cell in a range
- finding matches in different columns
- finding maxima
- Finding Median When Data is in Column1 and Label in Column 2
- Finding Midnight
- Finding out number of occurrences of string in one column?
- Finding specific data from lists
- Finding specific string value
- Finding text within text and then parsing out the text after that
- finding the "N" highest values in a range
- Finding the maximum number using an if criteria
- Finding the number of values in one range which are also in another range.
- Finding the value of a cell
- First occurance
- First Tuesday of the month - MORE
- First week of the year
- First Word In Cell
- FirstDayOfMonth + LastDayOfMonth Functions Wanted
- Flag a cell?
- flashing or blinking text
- Follow-up on rounding question
- for a true guru... formatting with concatenation
- For array geeks= rankif ?
- For Dave Hawley regarding 15492.html
- for Mark W
- For Mark W - Palindrome question
- For using non-integers
- Forcast function
- FORECAST FUNCTION
- Format cell to display trunated decimal W/O rounding
- Format cells to automatically round
- format number to time
- Format numbers in combining cells
- Formatting
- Formatting
- Formatting
- Formatting - 2 Questions !
- Formatting (or Formulas)
- Formatting a cell
- formatting a cell
- Formatting Date Codes in the Form YYWW
- Formatting Dates
- Formatting Number Within Text
- Formatting numbered lists?
- Forma