+ Reply to Thread
Results 1 to 6 of 6

How to take information from one Cell based on another cells information from the same row

  1. #1
    Registered User
    Join Date
    03-16-2021
    Location
    England
    MS-Off Ver
    microsoft office 2019
    Posts
    3

    How to take information from one Cell based on another cells information from the same row

    I have a problem that I don't know the answear to.
    In Column A I have a list of diffrent names (sometimes the same name are repeating) and in Column H I have a bunch of numbers that are specific to the names of the column A. What I need to do is take every instance of the number in the Column H that Shares the same name in the Column A and then divide it by the ammount of times that this Column's name has been repeated. What Formula would be used for something like this? I tried to search online but I wasn't lucky with it.

    Thank you for your time!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,638

    Re: How to take information from one Cell based on another cells information from the same

    Sounds like AVERAGEIF, or SUMIF/COUNTIF would be what you're looking for.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-16-2021
    Location
    England
    MS-Off Ver
    microsoft office 2019
    Posts
    3

    Re: How to take information from one Cell based on another cells information from the same

    So I assume I was vague in my initial post, I know how to calculate avrage of the numbers, What I'm haveing a problem is how to a get a number from one cell based on the information from a diffrent cell in the same row? Like I'm not sure how to get these numbers from the spreadsheet to begin with. I made a quick example of what I mean. Basically What I'm asking is how I would take every value that is corresponding with M for example.1123.jpg

  4. #4
    Registered User
    Join Date
    01-11-2021
    Location
    CANADA
    MS-Off Ver
    Excel 2007, Office 2019
    Posts
    31

    Re: How to take information from one Cell based on another cells information from the same

    =averageif(e5:e110,"m",f5:f110)

  5. #5
    Registered User
    Join Date
    03-16-2021
    Location
    England
    MS-Off Ver
    microsoft office 2019
    Posts
    3

    Re: How to take information from one Cell based on another cells information from the same

    That works Thank You !

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,638

    Re: How to take information from one Cell based on another cells information from the same

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count cells based on information from another cell
    By KngTuttle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2018, 11:37 PM
  2. Replies: 15
    Last Post: 10-11-2017, 11:36 AM
  3. Formula to pull information based on information in different cells.
    By apmi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2014, 03:57 PM
  4. [SOLVED] HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
    By CC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
    By CC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
    By CC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
    By CC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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