- sort in hex
- Days of the week.
- Sorting using HEX
- Slow Computer
- Can I mail merge filtered data on an Excel spreadsheet to a word d
- How do i create a "look up" to sum values in excel?
- How can I convert an excel file into a list of conference attende.
- Rounding up and down
- Passwording
- Problem with search
- Re: Problem with search
- coverting answer from Radian mode to degree mode
- Subtracting time in date format
- vlookup
- showing the # of times an item is entered in a column
- round up ?
- copy group of cells to another group of cells using "IF" in third
- insert picture into excel
- How do I create a formula in Excel that will countif or sumif bef.
- How do i get an average that ignores blanks in the range of cells.
- Excel Lookup Functions
- VLOOKUP and AND function
- SUMIF or SUMNPRODUCT Help
- Formula help SUM(IF((...
- Excel Lookup Functions
- Saving a position dinamically
- Find duplicate rows then deleting them
- how to build a formula to match numbers in 2 columns with the equ.
- Impossible Formula!
- Is there an autofill for all row fields in a pivot table?
- Feature in Borland Quattro - Is this in Excel??
- Multiple Shipping problem
- Renge filtering
- Excel 2000 Functions
- Extend conditional formatting to more than 3 conditions
- Copy on filtered list
- Problems with functions
- .CSV file format - comma or semi-colon?
- .CSV file format - comma or semi-colon
- Problems with functions
- Tracking activities
- Is there an easy way calculate 2 variables in conditional sum wiz.
- How do I make a group of data (not figures) which could be collaps
- algebraic function
- Sum of cells in different worksheets
- How do I make an If-Then formula in Excel?
- Difference of date & time in minutes
- Select all worksheets
- How do I select all worksheets
- Color Code Filter indicators - Change from Blue to Red
- Conditional if statement
- jpeg picture always the same size
- Excel 2003 - Formula result shows as 0:00
- Need Excel Analysis toolpak - don't have CD, where to download?
- Sumproduct Multiple Conditions
- CFPlus - v1.01.090 - Error 5
- problem with countif
- How do I create a formula that could have two different outcomes?
- SUM until blank cell
- Report
- How to verify that 3 cells are equal
- listing data without blank rows
- How to verify that 3 cells are equal
- Removing links to other workbooks-Excel 2000
- formulas for transferring data validation information in excel 200
- SUM problem
- printing rather than doing
- Impossible Formula!
- calc constant date from variable date & return with ability to rn.
- Formula to refer to other worksheet...
- How do I see detail of summed cells
- Re: Lookup Doesn't Work
- re-naming worksheet tab adds ".xls]" to the begining of the name I entered
- SUM until blank cell
- number format
- How do i Match all COLUMNS?
- average without 0 value
- Convert week number into calendar month?
- Rounding to the next highest 1000 after a resulting formula
- Paste Link and Templates
- Impossible Formula!
- Excat Forumla HELP
- PMT formula
- Impossible Formula!
- displaying results and not formulas
- range names
- range names
- range name
- range names
- Unknown IF function parameter on amortization schedule
- String function
- Protected Cell Link
- range name
- Impossible Formula!
- How to filter by greatest of
- Merging Cells but have each cell counted in the range of merged c.
- GETPIVOTDATA - Pivot table name problem?
- Sorting data while the shading stays the same
- Re: Have negative numbers show as zero
- Rounding a number to a multiple quantity that adds to a fixed total number
- Please Help Guys!
- Finding last cell to contain same value as current cell?
- Inserting Blank Rows Macro?
- excel oc curve
- Saving Macros
- Isolate text following a period (".")
- search & replace
- Problems with functions
- Please Help Guys!
- Complex formula help needed
- How do I know if another user have inserted a web query on my wshe
- Complex forumula help needed
- search & replace
- Sumproduct in Excel Spreadsheet to read Access db table
- formula to determine the first column containing any data
- Generate random numbers 1-100 without any repeats?
- How do I define the signum function sign(x) in Excel?
- pivottable - show all not appearing
- Multiple Worksheets in a workbook
- tricky conditional formatting
- Remainder Zero Function?
- getting data from 2 different exc sheet
- Adding cells with numbers and text
- Multiple Vlookup?
- getting data from 2 excel sheets automatically
- Can I count values in column 1 if criteria in column 2 are met
- Req, Tricky column formula
- import currency rates into Excel?
- Scurve fomula in Excel
- sort data with the same result
- Req Formula to place 1 into next columns
- VLookup accesses half the text in a field?
- If formula help
- Complex lookup task for a newbies
- Easiest Way to do this Importing method?
- how do i set up employee performance database in excel
- stop excel from shifting cells up when a query returns no data
- EZ Q 4 U: How do I change a number to text, based on the number
- Copy macros to new computer
- cell info
- How can I make a picture of my Excel sheet?
- rounding again
- How can I get the lowest price, second lowest etc. from a range o.
- cell info
- search & replace
- How do I program a cell to automaticinput the current date as dat.
- Sorting
- Need Formula Help
- Lookup Doesn't Work
- rounding
- MATCH Question
- label problem
- Drop List Referencing
- changing a cell value depending on an If Function/Lookup
- Need help with a Macro
- running totals in a macro for each month
- How do I convert 300616a to show as a number 303616?
- Can you get around the GETPIVOTDATA command when referencing a pi.
- word lookup
- Need assistance with cell formatting
- Need assistance with cell formatting
- Delete carrots in a string
- Need help with cell formatting
- Delete carrots
- can you use a variable or cell reference in a getpivotdata formul.
- How do I create a multi formula IF function in Excel?
- Can I hide locked cells?
- Find a match that;s not exact
- Help with formula please
- I need help with a formula
- write a formula to sum cells on different pages of the same workb.
- sql.request
- SUMPRODUCT problem
- How do I turn off ALL autoformat in Excel ? (I can't even type "J.
- A=P(1+i)^n
- I can't edit excel by right clicking
- max and min
- Can you enter a formula in a cell that auto-inputs calculations a.
- I need to randomize a column of alphanumeric employee ID's for a .
- The colors should work properly in Shared Excel Workbooks.
- alphanumeric cells
- Autofill skipping cells
- how do I name ranges in an Excel worksheet
- Time / Formula to look at time difference
- Formula MATCH error
- Vlookup, Index & Match
- VLOOKUP dragging down
- Formula needed
- VLOOKUP dragging down
- Distinct Value With Countif
- Summation Problem
- how to format pull down rows
- Formula MATCH error
- cells lose relativity to other WorkSheets after data sort?
- Setting up data to create a chart
- Data calculations require more than 7 nested functions
- Data calculations require more than 7 nested functions
- how to hide #N/A's?
- What is the "TextBridge" menu button used for?
- formula from Excel97 doesn't work in Excel2003,any ideas why?
- Too many nested functions
- How do I setup a list box that has several account numbers so use.
- How do I create a personalized heading row in excel (one that rea.
- Sort by Colour?
- hyperlinks
- GETPIVOTDATA - Pivot table name problem?
- IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF.
- Counting Function Dilemma
- Is there a way to sort by color in excel? using macros?
- view multiple sheets from same workbook
- Adding column data
- Req Formula to place 1 into next columns
- Date Difference On Working Days
- Populating cells based on calculation
- SUMIF
- deleting second open window in a workbook
- Difference between two dates in months with decimals
- IF or SUMIF help for Overtime Formula
- Numbers Wont Sum
- Determining Dates Within A Calender
- <<Don't Understand>>
- Combining Defined Names to New Name For Validation
- Change Color on an IF statement
- SUMIF or SUMPRODUCT or something else?
- GCD Function doesn't work in some cases
- Advanced Window Split & Freeze Question
- How do I set up a dropdown list in excel? The instructions given .
- Insert Month and Year in my worksheet
- I am entering data but it appears as a date in excel
- Cell Formula Help
- COUNTA Function not working =COUNTA(C3:C69,"NH")
- Change Color on an IF statement
- Newbie: How to round down to the lowest 5
- Only using the correct cell for the sum
- change function variable prompts??
- Only using the correct cell for the sum
- How to calculate the data in excel 2002 including only the last 9.
- combining several individual cells of numbers into one cell
- Formula help on a cell
- Group by count formula
- Indexing/Referencing
- error checking reports a value in the formula is of the wrong dat.
- help please with conditional format problem
- Conditional Formatting
- Naming & renaming a sheet tab
- How do I change a date in a cell
- conditional formatting
- Conditional Formatting
- Can you run a macro from an if statement in excel?
- Modify Row & Cell Contents based upon Cells Values
- looking up a value between two numbers and returning a related value
- How do I count how many times x appears in a column?
- hide "#VALUE!"
- Using two separate scenarious in one IF function
- IF Function or IF then else
- Summing values of corresponding columns
- lookup function?
- I have a password problem
- How do I disable text-to-speech in excel?
- SUM array formula question
- Countif ???
- Modify Row & Cell Contents based upon Cells Values
- RIGHT Function
- Appl need that VLOOKUP will not handle
- Modify Row & Cell Contents based upon Cells Values
- Parttime¡°¡@¡D¡@No.1 Work from home¡@¡D¡@¡°
- Summing cells in Excel
- Summing cells in Excel
- Help Needed With - If-Function
- PASSWORD
- Problem with Pivot Table Drop-Down Menus
- How can I subtract 111 from a number like 097 and get 987, using .
- excel 2003
- Vlookup
- Delete contents of unprotected cells in workbook
- Conditional formating in excel
- First column that does not contain "Cucumber"
- Modify Row & Cell Contents based upon Cells Values
- Formula Recalculation after using AutoFilter
- How do i increase the size of numbers in a text in Excel.
- letter Validation
- selecting and listing data
- letter Validation
- letter Validation
- letter Validation
- ANY FORMULA FOR CHECK =ISBOLD(A1)
- Macro did not run after download file from net
- Excel 2003 - referenceing the active worksheet page in vlookup
- 00-jan-00
- 00-jan-00
- Years when 1 April occurs on a Saturday
- Problem with time calc
- How do I Delete a file from the drop down file menu?
- conditional formulas in excel
- letter Validation
- Need help!!!
- SUMPRODUCT - HIERARCHY
- generating Unique ID numbers for students
- Conditional Format Advanced
- generate serial number
- reformulation question
- Place a set value in a cell from a drop down list name reference
- increment cell value automatically
- Date & Time function
- binomial distribution
- How can I group a bunch of cells together, so I can sort by colum.
- Time Calcs
- Is there a way to use the space bar to delete?
- Data manipulation help required !
- vlookup returns n/a
- Distinct Value With Countif
- Another date function question
- Using Average function when number is zero
- IF function displays wrong amount
- Keeping Array values?
- vlookup function in excel referencing an access table
- Why do formulas turn to values wen copying in Excel 2003...
- Nesting A Function
- countif
- Comparing Date Fields
- countif
- Formula not updating
- Worksheet names
- Autofill Questio
- Goal Seek - reference a cell for "To value" field?
- Help With The Upper Function
- Data Validation List Option Affecting Other Cells?
- offset and vlookup
- Modify Row & Cell based on Multiple Data
- How do I insert a line break when using the CONCATENATE function?
- Do I need nested IF statements?
- Need to add the same cell from several workbooks
- Auto color change to tabs in worksheet
- How do I get the COUNTIF criteria to recognize only month and yea.
- Using a worksheet name in a formula
- UPPER Function
- links not linking
- links not linking
- generating Unique ID numbers for students
- Excel 2000 - Advanced IF AND ELSE COUNTIF??
- import data protection
- Timesheet calculation
- Countif
- removing green triangle in cell
- Data Validation List Option Affecting Other Cells?
- Multi pick into database
- How do i change the numbering shceme of my rows?
- Syntax For Conditional Formula
- auto update
- to express degrees & power of a number in excel
- How to return min, mean, max using criteria?
- find LAST match in column
- HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS.
- Lookup Functions
- How do I get a pivot table to sum instead of giving me a count?
- Naming Sheets Tabs
- Difference between two dates in months with decimals
- Another date function question
- Tabs on Excel 2000
- auto update
- Vector lookup function
- projecting growth
- Macro did not run after download file from net
- Difference between two dates in months with decimals
- Excel: How to return count for each cell within date range criter.
- Count If Formula
- How to sum-up alternate rows ?
- How to add up a number of colums (posted on 29/10/04)
- Value Increase/Decrease/No Change
- auto update
- Using Indirect & Creating a worksheet Macro
- Help with function
- sumif calculate
- IF/ LOOKUP FUNCTION - Excel 2000
- Countif/Sumif function question
- count function
- vba to sort group copy paste to another sheet
- Pivot table : Excel cannot complete this task with available resou
- Formula to Extract Data from a Table
- Creating Links
- Calculated fields-Pivot tables
- Excel should allow "select all" and also "insert bookmark" as Wor.
- average by operand
- Returning the Week Number of a Specific Date on a Month
- I have an "IF"Statement problem...please help!!
- How to return min, mean, max using criteria?
- blank cells that include text
- how to remove label formatting (eg label to number)
- Price rounding - exception formula required
- find LAST match in column
- Modify Row based upon cell value
- Extract Pixel Values to Excel?
- Apply formuls to whole row (multiply ColumnC*.00274)?
- Sending Text Messages with Excel???
- How do I modify a row depending upon what a cell value is?
- last data entry in column
- Summing values of corresponding columns
- 30 Day Aging Report Using Conditional Formating
- Unknown Character removal
- Summing values of corresponding columns
- Excel, problem with hiding formulas.... please help!
- Select or Filter by Fill Color
- ?odd results for =left(F#,2)
- how do i create drop down menu in excel
- How to do consecutive numbers in separate docs
- IF-SEARCH
- cell reference show cell name (ie. D45) and not cell value
- Importing Data Into Formula Based Cells
- make list of information from different cells
- Text to Speech toolbar problems
- Getting Speech to work
- formula help
- import problem on huge xls file
- Calculate the number of workdays between 2 dates
- If function
- formula
- help
- Can I use a cell reference in the criteria for the sumif function.
- How do I find the first value in a column less than a number?
- Decimal places in Excel 2003
- How to use Vlookup
- Chart question insert
- Adding column data
- An instant sorting problem
- Calculate the number of workdays between 2 dates
- HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE
- Lookup a date between other dates
- "Is Between" Function Solution --- Many Thanks
- Number Format Issues-Decimal Places
- single quote 10-digit number that has leading zeroes & then conca.
- Vector lookup function
- Needing to know how to use a "and" in a formula....
- Can Excel be pre-formatted to apply "double quotes" to data enter.
- Excel Time Duration Formula
- "Is Between" function?
- GetPivotData
- Alphabetizing
- can i colour a cell on basis of results of a formula e.g clour bl.
- The Auto Filter button lost the column specified option.
- Importing Data Into Formula Based Cells
- Using Workday syntax
- Average/Min column of numbers, but skip 0's and Null's in the form
- Find AVG/MIN of a Column, excluding 0's and NULL's?
- Why does Excel freeze and have to close when I hold Alt down and .
- Average Column, but Skip Null and 0?
- Linking an entire worksheet from a restricted drive?
- Linking an entire worksheet from a restricted drive?
- Re: Vlookups and multiple returns (again!)
- unique records
- Not quite the same lookup?
- How do I delete duplicate entries?
- GradeBook
- Adding column data
- What function or formula do I use to calculate ROI with this data?
- how to count the nr of occurrences of a text string in a cell rang
- Look up or Index?
- convert numeric to text
- Countif Problem
- forming a new column by using the other column
- Excel Function
- Comment associated with a cell
- consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc
- Count Comments
- Hlookups + Vlookups
- can I merge two different workbooks, with the same format, just d.
- TRANSPOSE()
- Summing Formula
- Conditional Formatting for dates
- < and > functions aren"t working for me
- Create a total based on multiple conditions is not giving correct.
- remote data query and sum not working
- Combining Defined Names to New Name For Validation
- lookup problems
- How do I limit the number of rows in an Excel worksheet.
- How do I build a feature into a cell that would send an email rem.
- Navigating between worksheets.
- What is the easiest way to learn math functions in excel .
- Need to learn about formulas
- Using Cell references in VLookUp
- Help-IF Function
- Parsing text in Excel
- Copying Rows when hiding other rows
- countif
- Need help on Select Case
- unrecognized fuctions evapp etc
- Excel 2003 isn't updating my cells
- Comparing Data in two columns
- Sorting merged cellsHow do I sort merged cells not identically siz
- getpivotdata() by position
- no repeats in a column
- How can i get my whole workbook highlighted in the page break pre.
- format numbers into feet / inches
- What's wrong with this?
- Pivot table, how do you exclude counting cells with formulas as a
- Count distinct
- how do I 'count' the number of cells with a text in red or black?
- Sorting problem
- Calculating Average Values Using Arithmetic Equations
- need a formula for cumulative grade
- 2-Dim Lookup
- Double-Click a Hyperlink
- Calculating Average Values Using Arithmetic Equations
- Date Alert
- Adding text before a function
- If's and Isna's and stuff
- How do I reference multiple rows
- macro to not print blank value rows in invoice
- Freezing panes
- If Formula
- Is there a way to use the space bar to delete?
- Is it possible to send a worksheet without the unhidden data?
- Display excel formula on worksheet
- Convert text to dates
- Help! - with a formula please
- Countif, Sumif, If - help!
- Activating the Send As Attachment option
- How do you delete one cell from a range of protected cells
- Extract date from cell
- Deleting/IDing Rows that Don't Meet Criteria
- Duplicate fields does not match up! If statement
- If statement needed
- Edit Hyperlinks Globally
- sort option is greyed out in excel
- How do I set up a worksheet to let me know when a birthday is comi
- Do any newer versions of Excel (2003 or XP) offer more than 65,53.
- How can I format a cell to accept feet and inches and add them
- Seriessum is not quite it...need help, please
- #N/A In Max min Average Formula
- Adding TR to the end of each value in a column..formula
- Count data entries and date problem
- conditional format for text
- do we have semilog paper
- vlookup.
- Lookup with logic
- Maps.........Having Trouble Loading things
- RANDBETWEEN query
- data validation on sth else
- How to Concatenate Time with some operator?
- #div/0! problem - please help
- Drop Down List not Appearing
- variable range countif
- How to Set a fix # of days per month
- Returning the Week Number of a Specific Date on a Month
- Extracting data
- Import file names into cells
- Deleting/IDing Rows that Don't Meet Criteria
- Need to learn about formulas
- How do I set up a min and max function in the same caluclation?
- Another Lookup function, please
- Returning the Week Number of a Specific Date on a Month
- Lookup Function
- Using Countif
- How Do I (Macro Function)?
- real estate formulas
- If and (and) formula to allow a zero answer
- Workaround for UPPER(F31:F10000)
- Use of Exact(or other) function for alternate rows?
- Identifying exact values in alternate rows
- Formulas
- Function Macro for Nested IF
- Copy/paste Subtotals
- How I use SUMIF & AND
- How I use SUMIF & AND
- Referring to Pivot Table in Excel 2003
- If Statement
- Re: IF Statement difficulty
- Re: IF statements
- How I use SUMIF & AND
- HOW DO I CREATE MULTIPLE CURRENCY
- Calculation Question
- Help!
- How do I put a graphic behind the grid in Excel?
- returning a text cell based on a number cell
- Can you create an administrator for an excel file that is not sub.
- Forced Distribution
- how do i display formulas in only certain cells?
- CHIINV error
- FORMULA
- CHIINV error
- How do I conditional format for data that's repeated
- CHIINV error
- Concatenate and make uniform
- Excel to Access
- Getting rid of curly brackets within formula
- parse cell and insert rows?
- Counting problem again!
- Deleting content in a column
- Linking Data between worksheets in a workbook
- differentiating between "and"/"or" in a formula
- repeated numbers
- first week of year - according to european standard
- Getting rid of curly brackets within formula
- COUNTIF
- how to display heading of column corresponding to the cell
- How do I protect one cell in a spreadsheet?
- how do i create a blank cell in excel using a formula
- How do I prevent tied results when ranking data?
- Getting rid of curly brackets within formula
- If..then quesiton.
- RANDBETWEEN query
- How do I find downloads for workbooks for Accounting homework?
- Concatenate and make uniform
- why are nested subtotals coming out below outer subtotals?
- dynamic 3d sum
- Automatic date change when spreadsheet changes
- Add numbers for duplicate entries then delete
- CHOOSE Function
- How do I calculate the hours spent on a project by entering a sta.
- find and match the max
- Re: Grouping data within intervals
- Archive
- Excel row headings
- listing linked cells
- Address
- find and match the max
- find and match the max
- Where can I see VBA code for financial functions?
- Find & Replace questions
- Cell Validation.
- functions: 4 Millions Domains data with Category
- A different "Fill Color" problem
- dynamic 3d sum
- search multiple worksheets for an item and return the Wsheets name
- Excel-value in a range of cells for two cross references
- Using Pick Lists
- generate random numbers
- Calculating due date?
- Identify if Cell is Formula or written number
- SUMPRODUCT using offset from ROW if X marks the spot
- Import file names into cells
- Calculating due date?
- Grading Function Question...
- Deleting content in a column
- When do you use 3-D reference?
- Web Saving Help
- making calculated fields constant.
- making a column of formuls constant
- making variables constant
- IF Statement
- Subtotals
- copy and paste
- Saving Charts to .htm
- Excel can't find the end of the spreadsheet (Ctrl+end)
- Excel Formula Question
- Sum and Count Function
- high lite a row
- Upgrading Problems: Excel from 2000 to 2003
- COPYING CONDITIONAL FORMATTING TO A COLUMN
- copying conditional formats to a whole column
- Macro for sorting different rows
- Lookup a date between other dates
- how do I make a function to count days?
- solver can not solve polynomial eq. where one variable is five di.
- accessing worksheets
- Sumproduct #N/A elminate?
- How do I stop the autopaste function in Excel?
- Data Sorting
- record count using two different cells
- count based on two fields- need as quick as possible
- count based on two fields - need quickly
- countif, again
- Need help with a formula
- Formula for date function
- If statements
- XIRR Function Error
- Automatic date change when spreadsheet changes
- count if
- A different "Fill Color" problem
- Count certain changes between columns
- How can I use count function in excel where I have several criter.
- combining countif formulas
- Save Excel file - prompts to save - no Volitile functions used
- Formula results in font color change
- counting entries between two dates?
- VBA: Update worksheet when txtBox data changes.
- Stumped! Collecting values into one cell.
- variation on countif?
- What is the formula to calculate Age when I have Date of Birth?
- What is the formula to calculate Age when I have Date of Birth?
- Data from one tab to another
- multiple vlookup
- Summing a Column wit errors?
- Conditional Formatting "OR" function
- #REF error
- Formulas with If/ and results
- VBA: Update worksheet when txtBox data changes.
- random number generation
- Stumped! Collecting values into one cell.
- grouping
- Combine & Display “Fixed” & “Automatically Updated” Date Parts
- Data from one tab to another
- dynamic 3d sum
- Function to return colour of formatted cell
- Why do the ActiveX text boxes move when I print preview?
- Grading Function Question...
- No value entered
- excel won't work with peachtree
- Hiding rows based on date
- Display result as Yes or No
- vlookup
- =SUM Then insert word.
- Problem with array and msgbox
- Outlook with excel
- help please <d :D
- Excel Programming help
- Random
- Static Dates in Footers
- vlookup to see 2 values?
- Counting a Running Column
- Average determination
- open ended multi page sum
- <<Question From New User>>
- COUNTIF Question
- Circular reference
- function about hyperlink
- How do I create complex functions?
- How do I set up a formula in excel that is the tenth root of 7 ve.
- Workaround for UPPER(F31:F10000)
- How do I set this up?
- sort automatically
- Web Tool Bar
- sorting automatically
- open ended multi page sum
- COUNTIF Question
- How Do I created a nested sumif - if this column has this and thi.
- Have a question on scrolling sum with Excel.
- Have a question on scrolling sum with Excel.
- open ended multi page sum
- Workaround for UPPER(F31:F10000)
- COUNTIF Question
- Workaround for LOWER(A1:A100)
- How to lock a worksheet and enable the PivotTable refresh data opt
- How to use a table index from a formula
- Lookup, IF, Then help
- How do I stop automatic page breaks in excel
- Graphs and sheet referencing?
- Autofilter - Return a Value
- Is there a way to link a received outlook email to a cell?
- Help with Interpolating for a value.
- How to control worksheet initialization upon opening a workbook
- Deleting Zero after Subtotal
- How do I create automatic cell movement when using excel
- Help w/ algebra equations (wrong formula used in my first 2 posts!
- Stumbling with IF THEN in Excel.
- Lookup value in colA whos row matches row of index value in colB
- Highlite a row
- Why is it important to check the range placed in the SUM function.
- Lookup value in colA whos row matches row of index value in colB
- open ended multi page sum
- Sumproduct on filtered cells