What version are you on?

We've recentley been upgraded to 2003 here.. Say's it all.

I'm not sure you can do it on old versions but you might on 2007. Without it infront of me though I can't help.

Posted By: lurd on October 26th 2009 at 10:47:57

Message Thread

Excel question... (General Chat) - Yellalee, Oct 26, 10:25:20
- I think it is just an excel quirk... (General Chat) - Maillot Jaune, Oct 26, 10:53:30
- What version are you on? (General Chat) - lurd, Oct 26, 10:47:57
  - you could definitely do it with 2002, but again i don't think the row count was always giv (General Chat) - Ralf Scrampton, Oct 26, 10:50:40
  - no probs. I'm on 2003 as well. (n/m) (General Chat) - Yellalee, Oct 26, 10:48:46
- that's a good question that is, sadly one i don't know the answer to (General Chat) - Ralf Scrampton, Oct 26, 10:39:42
  - Yep, cheers. I did a Pivot Table in the end. A happy (alternative) ending (n/m) (General Chat) - Yellalee, Oct 26, 10:49:32
    - there is another quick way too (General Chat) - Ralf Scrampton, Oct 26, 10:55:45
      - Was gonna suggest that but thought it was too obvious.. (n/m) (General Chat) - lurd, Oct 26, 11:00:00
      - nice one, ta (n/m) (General Chat) - Yellalee, Oct 26, 10:56:31
        
        you could also GIYLF :-) (General Chat) - Ralf Scrampton, Oct 26, 11:00:28
        
        aha! That's it - I am using a lookup table formula on 15000 rows... (n/m) (General Chat) - Yellalee, Oct 26, 11:15:49

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.