- = if X=1
- what is the formula for =if x =1
- SumIF
- How to use formula to decide when to apply TIME data validation
- Help with formula
- Sum of a range of cells that include cells using LOOKUP
- Complicated Formula
- How do I print formulas in a spreadsheet?
- Dupplicates
- Returning date instead of 'not null'
- Lookup
- Bottom value in a list
- Validation & Muliple List Picks
- Excel 2007
- Average across worksheets ignoring zero
- Hyperlink to cell within a sheet breaks when cells are sorted
- Pivot Table question
- Same experience
- Using Formulas
- Formulas
- VLOOKUP? to match 2 cells, then retrieve value of a third cell on the same row
- Standard Error of the Estimate
- trouble repeating cells in table
- Double unique formula
- SUMIFS-time criteria/month
- RE: Loop Until non-incrementing cell condition met.
- Help with Excel 2003 (multiple IF statements)
- XL2000 - Linking Named Ranges
- Help Please! Random generator issue.
- Add if blank statement to index match
- I have a column of 50 numbers
- I have a column of 50 numbers
- Return match result
- multiple sumif or sumproduct
- how I can calculate EAR with continuous compounding?
- Large formula
- Use Indirect to Select Worksheet
- Index, Match, Lookup, Vlookup or Combination?
- comparing
- Concatenating Criteria in DSUM
- Re: Multiple Lookup with Criteria
- XL2000 Links Between Workbooks
- Multiple Lookup with Criteria
- standard error of regression coefficient
- how do i do a compound if function?
- excell auto-populate word?
- How do I convert an Excel Spreadsheet into blocks of Text
- Mouse clicking on Excel Worksheet Cells
- Adding Hours Worked Correctly
- Edit Links Excel 2007
- Average formula across future worksheets
- RESET BUTTON
- how do i parse every nth data point from a large data set in exce
- Hyperlink Formula Problem
- Why do cell fill colors not show in worksheet view?
- Prevent function errors caused by cutting & paste or drag & drop
- Excel not calculating formulas
- Converting Decimal Degrees to Degrees/Minutes/Seconds
- Autofill row with a column entry
- I have a column of 50 names
- If AND/OR funciton with multiple criteria
- Formula Help
- Formula - If Statement with blank
- Naming a cell
- Troubleshoot LOOKUP, please
- Using a IF function in a validation list cell
- #N/A Error Reference
- Formula Issues
- Spread numbers by setting up a Min and Max
- I need to find someone to build a spreadsheet.
- Date calculation
- Formula for totaling selections
- Counting occurences of text
- Conditional Formatting - letters present
- counts repeated number in two different area only once
- Networkday & workday with array functions
- DCOUNTA with multiple criteria
- counts repeated number in two seperate area
- How do I count the number of records autofilter is showing in Exce
- Formulaes
- excel 2003 worksheet
- VLOOKUP with WORKDAY?
- Lookup Value in Multiple Columns
- AutoFill Numbers- shows up ###
- Row to Column
- Conditional Formating
- Conditional formating based on blank cell
- How do I add NOT insert additional worksheet to existing workbook.
- copy cell info to other sheets, other sheets dont contain all row.
- validate date entered
- Change cell font color if time is> by 15 minute intervals upto 2hr
- Multiple arguments
- RE: hlookup- move range by 2 rows with fill.
- RE: Sending data from one cell to another
- Counting based on multiple criteria
- CSV Column Conversion
- transfering a figure from 1 worksheet to the next
- Nested IF isnt working right..Why?
- Problem with COUNTIF being off by 1
- Lookup Question
- Conditional format for #DIV/0
- Tracking due dates
- 2 Spreadsheets find duplicates
- What should formula look like to define date range on SUMIF
- Finding text between 2 @ signs
- Adding a row to reconcile to a new worksheet
- help - need to parse a cell
- "IF THEN" FORMULAS
- excel 2003 subtract function
- Using MAX with a LOOKUP
- Help with a date calculation
- copying workbook formating to a differnent workbook
- Reference number
- excel should have a rolling paste function
- Excel question
- Array formula using sumproduct & vlookup
- Excel filtering
- Insert single quote symbol
- Counting the As and Bs
- how do i restrict cells to not accept formulas?
- creating formula in excel
- display calculation steps - not final answer
- Adding OR to an index match formula
- Conditional Formatting Question
- Lookup value one and retrieve more then one corresponding value fromanother sheet
- Pivottable getpivotdata problem
- Countif certain values on specific date
- fomula to divide
- Dynamic Named Ranges
- How can I insert a true blank inst. of a non-blank zero string
- First Name & Last Name
- Compare two cells with same name
- recode variable
- Insert a rows automatically
- adding two colum cells only if there is data in 3rd colum
- LOOKUP
- Formula For Counting Records
- Trying to find and replace *
- How can I move to the first cell in the selection in Excel 07?
- SUMIFS - How to use a variable with > or < in criteria
- Re: consolidate 26 pay periods/worksheets into 1 year end worksheet
- Need help with a lookup or if statement
- RE: consolidate 26 pay periods/worksheets into 1 year end worksheet
- RE: consolidate 26 pay periods/worksheets into 1 year end workshee
- Copy last entry of column to bottom of column
- Calculating a Check Digit Routine
- COUNTIF
- How do I filter by today's date(changing) and before in a macro?
- I have a column of 50 numbers
- Macro recorded... tabs & file names changed, macro hangs
- what function to let me create summarized spreadsheet from databas
- VLOOKUP displays formula rather than result Excel 2007
- How can I suppress the enable macros and save changes messages?
- Multiple text function calculation
- VLOOKUP or INDEX
- help counting
- Using Indirect Function in SumIF?
- Find a word in a sentence
- options of sharing workbook is not available
- Formatting Help
- Easy one for you all...
- Clear excess formats in Excel 2007
- Loop or Find code ?? need help !!
- Formulea
- disappearing Sheet tab & Scroll bars
- Using if statements with a date
- MATCH problem
- Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells references
- Inputs for Goal Seek Command
- Flashing or Blinking Cell
- Assign a function to a Command Button
- Choose dat range for sumif formula
- How can I prioritize data automatically?
- Adding hours to a time
- need a formula that has to do with dates.
- SUMIF Greater than or equal to
- Need Help
- IF, OR, ISERROR?
- Want to automate my football spreadsheet.
- IF(logical_test, may be a number or text
- how to search within a row or colomn for a particular string
- COUNT IF NOT....
- Sumproduct I think but a tough one
- using "OR"
- Conditional Format Won't Update Cell
- vlook up
- Need help in Excel 2007 - urgent
- Help summing a range base on a date
- Help with summing a range based on a date
- non number consolidation
- Need to use Countifs to return unique data
- RE: Excel TRANSPOSE
- Extract characters from cell
- Re: Excel TRANSPOSE
- Convert text to rows
- Searching for products and categorizing.
- Hyperlink HREF question w/ vlookup
- Scroll tabs
- Adding periods (full stops) to the middle of numbers
- Insert date, but keep static on archived
- PUT PAGE NUMBER INTO A SPECIFIC CEL?
- Reporting Info to New Sheet
- brought forward & carried forward
- Dynamic drop down list
- Inserting comma(,) after every two digits of a number from right t
- Convert Text to Columns
- Count If
- some numbers to be blank
- 1 equals 3
- Calculate between start and end times
- Counting No of character in a string
- Statutory Hrs Calculation
- Count the number of workday in a month
- resizing list width in combo box
- Function to display file name
- Sumif but taking a value
- Extraction for Ashish Mathur
- Whole month total vice daily
- CONSOLIDATE SHEETS
- Vlookup on partial match
- Reminder
- Why does "=SUM(E4,E8,E11,E14,E17)" display as text?
- convert sum number to a set number
- multiple ranking (sorting), based on diff. criteria
- Lookup and Display Multiple Unique values based on criteria
- Lookup and Display Multiple Unique values based on criteria
- Moving info from rows to columns
- howdoIaddcolumnsfor atotal
- sorting text with numbers
- Conditional Formatting Issues
- counting how many employees are scheduled to work by hour
- What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)
- formula assistance needed
- Can COUNTIFS be utilized to return unique values?
- Data Validation
- trim cells with space in betwen numbers in cell
- Linking Cells
- DATEDIF vs. simple difference
- Is it possible to link a whole table into another worksheet
- Can "COUNTIFS" be utilized to return unique values?
- Can "countifs" be utilized to return a count of unique values?
- Right align positive and neg numbers using brackets around neg #s
- sumif
- Conditional format a column based on value in a different column
- Copy Transpose and Link Data
- V lookup
- Can u help me plz??
- Simple Q - Multiple IF (And) Statement
- variable formula
- Return cell referance of the first cell that equals a value?
- Linking a workbook to worksheets
- Locate merged cells to sort on 3 columns
- If statements in a Vlookup.
- Re: Regional settings
- Pivot Table Constraints
- Searching for keyword in sheet 1 and returning the whole row intosheet 2
- Unique count in access
- Difficulty with Sum+IF Function
- Round it off
- To remove numbers in a cell with out using the macro
- Array formulas slows spreadsheet
- how to insert rows inbetween rows of data ?
- Sum the last 21 cells
- formatting a sentence with functions
- highlight the highest cell in a column
- Additional IF Function
- Extraction
- Sumproduct, 3 columns and date
- function to retrieve array name
- macro to sum select columns in all workseets within a workbook
- average without min qty
- want to create a link to another worksheet in another workbook
- Sumproduct problem
- any ideas if this can be done
- Separate colum
- Excel function
- Vlookup array formula problem
- If Function with multiple criteria
- Newbie needs help with chart
- Sum if not blank
- How to create a hyperlink to open a file with part of the name
- Index Match Error
- Can I put button on spreadsheet to make it print a specific part?
- How do I display data refresh date and time
- fill a form with specific data
- IF(AND with date comparison
- returning text; alternative to sumproduct/sumif?
- Conditional Formatting
- Ranking Sales Reps
- Copying and pasting with SUMIF and COUNTIF
- SumPRODUCT - calculating result??
- csv delimeter
- IF Function formula (I think?)
- IF to group months
- Remove hyperlink in Excel worksheet
- sumif using "AND" and "Date"
- Referencing a cell in the worksheet as the criteria for a formula
- ? enter a static time (Excel) in a cell using the IF function
- Pivot Table or lookup?
- Look up last and next entry
- Extract data from bracket
- Formula have a VLOOKUP but want it to =0 if no value is found
- Match value return a text
- Unique records formula & zero entries
- Allocate Value Across Monthly Periods
- Formula for payout & interest
- To All you Senior Guys out there.
- Match Column and copy to cell Column D
- Count text occurences in range when criteria in other column is me
- nper
- help formula (ranking)
- Count occurences of text in range only when Yes appears in other c
- Workday function returns the wrong date when the duration is 5 day
- Include calculations in the lookup function
- help with data match
- Split list query for Vlookups
- WildCards in Sumif Function
- Re: Counting Unique occurences of text in a column
- Sum formula when cell cantains alphabets too
- Counting Unique occurences of text in a column
- Pulling data from one spreadsheet to another.
- Numbering years and months
- Local Apparent Time (LAT) - real / actual solar time ?
- External data connections
- SUMIFs function
- More columne sorting
- how do i use IF to substitute for another cell?
- SUMIFS function
- Re: Help with formula (decimal to fraction)
- Do while not last row
- Create Sheet & Copy Stuff
- I have a column of 50 numbers
- using sort in excel 2003
- Please help with formula (multiple ifs to determine due date)
- formula in excel
- display number if date is in a range
- Weighted grades
- Table Lookup
- Re: scrolling columns behind previous columns
- Using wildcard * in MATCH
- Sumproduct Help
- Macro to copy data when data is detected in another column(s).
- RE: scrolling columns behind previous columns
- RE: scrolling columns behind previous columns
- RE: scrolling columns behind previous columns
- Vlookup
- Conditional Formatting based on values from other sheet
- BeforeRightClick
- Copying Formulas
- Project a date and calculate a % in one formula
- Difference between these two formulas?
- Sumif with multiple sets of duplicates
- Limit access in a pivot table
- Calc occurrances for weekday omitting weekend data
- IF statements with multiple criteria
- Formatting a radio button
- Validation List
- Problem with Functions and Formulas
- Mid function
- FAO Mike
- Re: Help with formula
- RE: Help with formula
- Re: Help with formula
- Pivot Table using data from multiple sheets
- Moving Average
- removing blanks from range (mr Pearson)
- Transpose data and retain links to original data
- Counting Closed Date < 2 weeks of Open Date etc
- convert currency to word
- Vlookups (sum of)
- Changing zoom level automatically
- Combining text from several cells into 1 cell
- User Defined Function and VLookUP
- multiple worksheets
- Copying formulas from one cell to another
- custom created table styles
- SumProd from 2 columns and date range
- count how many staff are scheduled between...
- Vlookup
- how many people are scheduled between...
- how to enter a formula in a text box
- Total days worked /20 to get actual months/days
- adding actual numbers in columns
- I want to highlight a column if the date in cell #4 is this week.
- Using a Master Worksheet
- Spreadsheet question
- Simpler way to pull a cell value from a group based on 2 factors?
- Auto Calculate Not Working in some Spreadsheets - Excel 2003
- A1=10,A2=20,A3=30,A4=40. What would be the result of the formula .
- Excel - change the primary Mousebutton to left ButtonClick
- Post
- Sumif criteria "equal"
- Formula Help
- Subtotal =0
- Excel
- count scheduled staff between hours
- how do i make a cell a search cell for a spreadsheet
- File name insertion in cell
- Solver Priority
- need quick help averaging multiple rows
- Merging two data tables together using Lookup function
- excel document with shapes on it but the shapes do not print
- Relative Addressing not working
- Avg in a Pivot?
- VLOOKUP Help!! ASAP!!
- Excel - gjør primær museknapp lik høyre museknapp og sekundær vens
- Excel 2007
- Change number from multiple decimals to 2
- I am a novice at using functions
- MID function results
- VLOOKUP
- IF calculation of Time
- macro Lookup
- HOW TO I COPY SPRADSHEET WITH EMAILS AND NAMES TO MY CONTACTS
- The first 25 percent
- The first 25 percent
- Palindromes
- how to enter numbers like 8:0 or 2:8 in a cell
- how to highlight the results of a search string in a worksheet?
- Excel is Calculating Incorrectly
- running balance
- Additional IF Function
- setting up sequence sets with only 3 repeat once in excel
- how can I use randbetween without repeating numbers in a set
- Reformatting data
- vlookup with 4 sets of criteria to match?
- Changing decimal numbers to hours and minutes
- Rearranging a report
- Locking certain cells in Excel 2007?
- Hate DBL post but I really need help
- SUMPRODUCT HELP
- Pecentage
- Column Headings
- How to change the direction of the enter key to go horizontal
- 106% to this please 6%
- Normdist Problem
- Counting
- SUMPRODUCT HELP
- Colors too dark!
- Selecting all the active cells in a named column.
- Multiple Conditions
- Calculating the mean within a SUBTOTAL function
- lookup column using text not col number
- copied formulas refer to destination sheet not source sheet
- Text Extraction (parsing)
- IF ISBLANK Function
- Percentile
- What formula do I use? Using 2007
- MVP ngs
- Increase cell B by one for every 3 in cell A up to 50?
- 2 cells on multiple pages onto 1 page
- Sumproduct "not equal"
- text and numbers
- info on 400 pageson to 1 report page
- "If" function and blank cells
- how do i combine text and formula calculation in same cell
- format a column to show bars
- Excel 2003 - Combining info from several pages to one page
- Finding cells that contain references to other workbooks
- "IF" Question?
- Copy info from one excel spreadsheet to an excel template
- Re: Check if time falls between two times?
- RE: Check if time falls between two times?
- Re: Check if time falls between two times?
- Formula link in previous version not updated in Excel 2007
- Increment invoice number
- Holiday spreadsheet - SUMIF forumla no longer works?
- formula to show time that data was entered on spreadsheet
- Returning comlumn hearder uppon matching a text sting in a row
- Calcualting hours
- Want to count all repeated number only once in Excel 2007.
- short cut key of function of count in excel?
- countif
- Count time formatted data within range
- How to match the same data
- Naming Consectutive Excel Tabs
- Pulling out lastest date in line of text
- LOOKUP Function gives wrong results
- Add (sum) numbers within cells
- Pivot Table
- Excel 2007 Nested formulas
- Width of DV drop down list changes
- Lookup with 2 criteria?
- 2007 Need macro to auto set option buttons all to "Yes" or "No"
- formula for days between completed meetings
- count
- Sumproduct
- The first 25 percent
- +1 only if there is a value
- Offset function
- Finding Unique/Duplicates
- Multiple Criteria Find & Replace
- Hyperlink to named range in workbook
- summing multiple lines throughout spreadsheet
- How do I change contents of a cell based on drop down list selecte
- The first 25 percent
- Formula
- Simple formula please?
- The first 25 percent
- The first 25 percent
- Summing Data
- 3D SUMIF
- debt owed/ how to calculate payments with in time frame?
- HOW DO I SELECT A RATE FROM A TABLE
- Countif, plus ?
- how do I set column headings up and down rather than across
- Sum or Sumif BUT exclude duplicate records
- Filtering Using Values In A Specific Cell
- Summing cells based on mulitiple criteria over mulitple columns
- maybe match, maybe sumproduct hmmmmmm
- Visibility of newsgroup postings
- Sum of amount with corresponding dates
- Replace "Cell based" formulas with "word-based" formulas
- Counting Unique Values
- how do I open a file when the file format is not valid?
- How can I find out if numbers in one column are also in a secondcolumn please?
- if or match hmmmmmm
- #N/A via Vlookup to produce name from other worksheet
- copy conditional formatting range
- Average formula only works partially.....
- Emailing A Worksheet
- how can I find the first non-zero cell
- sumproduct to obtain text output
- validate time entries linked to each other
- "Cross"-Auto filling: consecutive columns into rows
- Collate data from one spreadsheet into another spreadsheet
- Integration in Excel
- How to fill cell with data from a previous cell
- Vlookup i think >.<
- Indirect worksheet lookup in long formula
- Dates
- Variable calculation question
- please change Range("AB30").Select to any cell
- combine column labels in pivot table
- Re: Change default print set up?
- Re: Change default print set up?
- calculate the diffrence in cost
- Finding employee absence history
- Text Item Processor
- number of specific weekdays
- random numbers
- Add 18 months
- LOOOOONG formula, with drop down selection
- when i type txt in excel doesnt work
- One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
- How to add values in one column based on values in another column
- MS EXEL
- Auto Fill (sort of)
- Add cells on two adjacent rows but non-adjacent columns
- Sum, Average, and Count from imported .txt file
- If AND for large range of data
- Conditional Formatting in Excel 2007
- Conditional formatting a cell containing "<"
- Average formula works but....
- display formula - selected cells only
- Re: Conflicting vlookups
- Inserting a value in a cell when 2 others cell match a certain cri
- Percentile Logic
- Calculating probabilities
- Percentile
- SUM question
- sumproduct help using dates as the criteria
- aauugghhh...#div/o problems & various average formula problems
- Percentile
- Sum If
- Getting 'Dates'
- Age Formula
- Functions
- How do I make the FALSE go away?
- Hide #Value!
- Pick the 5th number out of the following number 1002300.
- Lookup w/ Multiple values
- Extract Cell Comments and Paste as text in a cell
- Cleansing/Data Comparison between spreadsheets
- multiple condition formula
- Conditional Formatting
- To Clear number in the cell(s)
- Workbook protection impacts file size when compressing a spreadshe
- get that 0 outta there
- Formating Day of the week
- Group rows (or hide rows) like in MS Project
- IF statements
- Min/Max multiple rows into another sheet
- Calculating Time
- Calculating Social Security
- Auto Populate a Cell
- Transposing data with Index function
- RANK Function
- Pivot Tables
- Find product from date range
- Entereing an age and if statement in the same cell
- Pivot Tables
- lookup if? sumproduct if? index/match?
- Combining Functions (Sumproduct and Countif)
- Data Sorting
- Conditional Formatting - comparison with another cell
- How to colour highlight empty cell
- Formula's
- Table function
- use of wildcards in conditional formatting
- set to display cursur on cell A1
- set to display cursur on cell A1
- Change the colour
- Determining Frequency of range
- If Function and Vlookups
- Data validation
- Quadratic trend equation?
- use of define name functions
- Create a Condensed List from Imported Data
- Current region emulation
- merging two worksheets
- Where does Excel2007 save files -- not where I select?
- Enter Data on one tab, then find matching data on another tab
- Randomly add numbers in a group
- An Odd problem with SUM using :
- Pasting Data from One Workbook to Another
- Shared worksheet will not 'share'.
- match value within any portion of lookup string in range
- picking largest number
- Duplicate image in Excel spreadsheet
- iserror
- Can Excel calculate CAD CAM cut outs?
- auto number
- Over time.
- how to search values ont several tabs
- Conditional formatting
- sum total of numbers that are a certain color?
- to link information between two lists
- subtract a single cell from range of cells and then count
- Nested Array Formula to Determine Average cost Per Mile in 100 mileincrements
- move fill automatically to another file
- look for subtotal
- Assign a formula to count items in a column if they are within cor
- writing an IF/AND formula
- How do i trouble shoot an IF function
- how do i import data from a web page into excel 2007?
- Printing
- HOW DO i INSERT A RANGE OF SERIAL DATES IN THE WORKDAY FUNCTION
- How to 'split' data from 1 column into 2??
- Sum Duplicates in Groups
- subtract one cell from each cell in a range and count instances
- How can I turn a fraction into a decimal.
- Countif maybe
- IF Formulas
- Shutting off all calculations
- RE: How can I turn a fraction into a decimal.
- Vlookup and If functions
- Drop Down Menu Title
- RE: How can I turn a fraction into a decimal.
- Issue with Number Conversion to text
- Connect different worksheets
- move data to another file
- Drop Down Value to Trigger Conditional Formatting
- Excel worksheet function
- Creating data entry form
- Calculate total time between two dates
- excel database
- Formula
- Count categories in one column if within particular month
- "Save As" Max file size?
- Copy Excel Function from a Cell Through a Function
- Assistance needed with a formula
- Sum Duplicates without Sorting
- Calculating weekly/year to date totals
- Help on Formula-
- Average of top x% of a list
- I PLEASE NEED URGENT HELP WITH A FORMULA!!!
- LOOKUP PROBLEM
- Re: How to add cell values until a condition changes
- Excel copy data
- How do I only make a cell available if an option from a differentvalidated cell is selected in Excel?
- When building a chart Dates are been included that are not in thedate range
- Re: Number stored as text
- Wrapping Text in Merged Cells
- sum hours and minutes with Excel 2000
- Time Value Between Two Times
- If Blank
- Vary response IF certain text is contained in a cell
- alphanumeric sku numbers
- Conditional Sum Based on Cell Background Color
- Help
- Spreadsheet organization
- Average Ranges of Cells, Return Separate Value for Each Range
- LOOKUPS USING 2 SETS OF DATA
- How do I combine a VLOOKUP formula and a NETWORKDAYS formula?
- Lookup Help
- If & sumproduct formula with text
- Concatenate
- Trying to build a If statement
- shortcut to display drop down menu
- Function Syntax not showing - xnpv
- creating a sheet 1 of
- If, then statement with the condition a blank cell
- would like to combine info. fr different location on a list
- How To Grade 40 Students relitively On a Normal Distribution.
- to replace cell
- how to vlookup colume with different values
- FORMATTING CELLS FOR QUICK INPUT
- Sum for 26 worksheets on one workbook
- Average last 3 in range
- IF column B = anything in column A format
- Link to another workbook
- £#,###,"k" format tweak
- Compare data (2 columns) from 2 worksheets within a workbook
- % commision
- RE: Sort
- Remove the char from right
- collect data from one excel sheet to another
- cell reference
- sumif & sumproduct
- subtotal excluding spaces ""
- Criteria to return maximum value where x = x
- Last few transactions
- Is it possible to add rows to a range using input form
- Matching two list - How can I do it?
- Unprotected cells
- Vlookup problem
- How to display the values of multiple cells in a text string?
- sum results based on a reference
- How do I enable automatic updates of links between spreadsheets?
- How to sum more than 30 cells
- How to Merge Two Cells IF Another Cell Matches
- i need a formula for two columns to sum and to be able divide the
- Check boxes and text strikethrough / color change
- Rolling 12 month average
- Why is VLOOKUP returning a value from the row above?
- IF AND OR problem.
- Formatting time in Excel 2007
- Formula to round off number to .95 cents
- Sorting by last digits in cell
- 2 colums needs to sum and the anwsers needs to divide to get a pe
- First Half / Second Half Month Budget
- Counting Zeros in a row until encounter first non-zero value
- VLOOKUP & 2 arguments
- Conditional Format question
- FILTERING RESULTS
- Counting coloured cells
- confirm the missing numbers in a series
- Creating Summary Worksheet
- Count cell except those contain zero
- Sum Postitive Values
- How do I add cell values that are in different rows/columns?
- How do I add cell values that are in different rows/columns?
- Multifunctional formula
- Conditional Arrays
- Big challenge!! Formula for count last 10 columns since today!
- How to sum one cell across workbook if nr of worksheets is variabl
- Vertical Database to Horizontal?
- allowing each value to be used once
- Summing a Formula