ST Alpha - "DUH!" (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 "This is starting to sound like a pivot table situation... -- nm" by con_carne

DUH!

Posted by znufrii Apr 4 '11, 15:19

I don't need the specific dates on sheet 2, I just need the count! *headdesk*

Responses:

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

Post a message top

Replies are disabled on threads older than 7 days.