Results 1 to 7 of 7

Thread: List values based on adjacent reference

  1. #1

    List values based on adjacent reference



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I would like the spreadsheet to tell me how many values have a certain value in the adjacent cell. See image below:

    Click image for larger version. 

Name:	1.png 
Views:	14 
Size:	91.2 KB 
ID:	2646

    So in the image, I would like to make a list of all values in columns C, E, G, I & K counting how many of each have an "A" in the adjacent cell.

    I hope this makes sense. It's taken me a while to get my head round this for some reason :/

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Since each of the A's, B's and C's have an associated cell with text to the left, then you can just count the A's, B's and C's with Countif.

    e.g.

    in S4:

    =COUNTIF(D:L,R4)

    copied down.


  3. #3
    My first thought, but he says he wants a list​ of all values.

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    I saw that too, LOL, but looking at the attachment, I see that the OP pre-entered A, B, and C and the active cell is S4, so I deduced that the OP wanted the counts of those letters


  5. #5
    I saw the same, but decided (probably wrongly) that list was what he wanted and that was just too much hassle

  6. #6
    I think the OP wants to look in C:K for the values in M and post the count of those with any character (A,B,C,X) adjacent in column P.
    P4 = 7, P6 = 5, and P10 = 9

  7. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Only one way to find out.... wait for OP to tell us


Posting Permissions

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