Search results

I have this table of data with column headers as follows..."School Code", "ISBN", "Cost",etc...Is there a formula or combination that will (1) extract all the ISBN's for a particular "School Code", then (2)Multiply each extracted record by its associated cost? I am trying to avoid pivot tables...

Hi-In the "Sort" dialogue box there is an "Options" button. It allows you to sort horizontally. Hope this helps.

You can also use "conditional formatting" as follows: Highlight the cells in column A... Go to Conditional Formatting>>New Rule>>Use Formula to determine which cells to format...In formula box type the following...=countif($B$2:$B$4,$A2)<1...Choose a color for your...

Is there a quick and simple way to update the links between workbooks when the linked tab in the source workbook is moved and/or renamed.

Thx..Much appreciated.

Hui...Thanks for the input. I have dates in Column A..But i used the "month" function to convert to month number eg..05/22/2010 = "5". This is the number i used in the formula. I need to extract data for all dates prior to 7/1/2010 and all dates on 7/1/2010 and later and place these in separate...

I am attempting to retrieve data based on "service dates" prior to July 2010 and dates in July 2010 or later. Results for each of these periods will be placed in cells A1 &B1. However, because the fiscal year runs from July 10-June 11, i can foresee a problem when January 11 comes around as data...

Will this function work with an array that contain duplicate values?

DaveCon- The formula below may work for you. If you are using excel 2007 it can be easily accessible. The syntax is as follows: =DAYS360(StartDate,EndDate,TRUE or FALSE)

how to display data or values contained in one table but not another?