Results 1 to 5 of 5

Thread: Return an specific value tied to a column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte BBrider's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    Professional Plus 2013

    Return an specific value tied to a column

    Hello guys

    It is a little difficult to explain in the Title what I am looking for. Basically I have a massive set of data is the below format.

    What I am looking for is return the week number of the associated cell that contains the first time an organization shows up. Better with an example...
    The first time Company B shows up is in A10 so I want a formula or code that returns the value 31 (C10).

    Let me know please! Thank you!

    Click image for larger version. 

Name:	Capture.JPG 
Views:	15 
Size:	51.2 KB 
ID:	8678
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	11 
Size:	9.3 KB 
ID:	8675   Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	20.4 KB 
ID:	8676   Click image for larger version. 

Name:	Capture.JPG 
Views:	8 
Size:	54.4 KB 
ID:	8677  

Tags for this Thread

Posting Permissions

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