Results 1 to 6 of 6

selecting and use cells with the same value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    selecting and use cells with the same value

    Dear sir/madam

    You begin by looking to the value of the first cell in column B now you have to look if there are other cells in column B with the same value.

    2. if you found cells with the same value you go one cell to the right (so to column C) and you have to look to the value of that cell(s)

    3. Now sum up the the numbers of the selected cells of column C and divide them by the number of cells you selected. This value is the answer.

    I have attached my excel file

    I really tried a lot so I hope that someone can help me!
    Attached Files Attached Files
    Last edited by keis386; 06-19-2011 at 07:08 AM.

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