Results 1 to 11 of 11

collating information

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    collating information

    If you have a spreadsheet where column A is a list of names, for each name there are several data types (listed in column B) some of the data types are repeated. Column C contains the percentage for each of the data tpes for the whole thing. There are 300+ names, each with several data types and most where at least one data type is repeated. How can i easily calculate the total percentage for each data type, for each name.

    eg.
    Column A            Column B           Column C
    Site A              Grassland          12.00
    Site A              Inland Water       7.00
    Site A              Mixed Woodland     30.00
    Site A              Grassland          33.00
    Site A              Grassland          18.00
    At present I have been creating a sum function for each data type and then deleting the rows that I don't need to neaten it up. But this is very time consuming and like I said I have to do this over 300 times.

    Any help on this would be great,
    Cheers
    B2B
    Last edited by Back2Basics; 12-05-2008 at 06:18 AM. Reason: Added Code Tags and aligned data

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1