ST Alpha - "need clarification. col 1 = names and col 2 = dates? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 156

In response to "I'm pretty sure I know the answer to this, but figured I'd ask the excel wizards here for their thoughts" by znufrii

need clarification. col 1 = names and col 2 = dates? -- nm

Posted by loosilu (aka loosilu2) Apr 4 '11, 15:08

(No message)

Responses:

on sheet 1, yes -- nm - znufrii Apr 4, 15:08 20
- sfek, sheet 2 will have each name once followed by up to four dates -- nm - znufrii Apr 4, 15:09 15
  - how many names are we talking about? -- nm - loosilu Apr 4, 15:09 14
    - 250-ish? - znufrii Apr 4, 15:11 13
      - oh lord, don't do manual anything. VLOOKUP -- nm - loosilu Apr 4, 15:11 12
        
        any idea how I would get VLOOKUP to return up to 4 different dates for the same search value? -- nm - znufrii Apr 4, 15:14 11
        
        do the names repeat in col1? how many cols for the date? -- nm - loosilu Apr 4, 15:15 10
        
        on sheet one, yes, names will likely appear more than once, each with a different date. I need to capture up to the first four instances. - znufrii Apr 4, 15:16 9
        
        I think pivot tables. -- nm - loosilu Apr 4, 15:20
        
        This is starting to sound like a pivot table situation... -- nm - con_carne Apr 4, 15:18 7
        
        DUH! - znufrii Apr 4, 15:19 6
        
        OH!!!! you could do "countif". -- nm - loosilu Apr 4, 15:20 5
        
        brilliant! *kisses you on both cheeks* - znufrii Apr 4, 15:21 4
        
        dont' know if this will help, but sometimes I put in an additional column with a number series. - loosilu Apr 4, 15:24 3
        
        the harder part will be cleaning up the data on sheet 1 to make sure the company names are all consistent with what I have on sheet 2. - znufrii Apr 4, 15:28 2
        
        if the first part of the names is always correct, you can do "left([number of chars]) to choose the first part of the word. - loosilu Apr 4, 16:02 1
        
        if i had been the one designing the database, i would've done something like the IM, but alas -- nm - znufrii Apr 4, 16:29
- highlight your field, paste special, the check "transpose" to change it to rows. - loosilu Apr 4, 15:09 3
  - that still requires autofilter and a manual operation for each name, but it's very helpful, thanks! -- nm - znufrii Apr 4, 15:10 2
    - abort! abort! -- nm - loosilu Apr 4, 15:12 1
      - STAY ON TARGET! - Porkins Apr 4, 15:14

Post a message top

Replies are disabled on threads older than 7 days.