Jump to content


Photo

Another excel question


  • Please log in to reply
5 replies to this topic

#1 Cunny

Cunny

    Doyen of Topiary

  • Sponsor
  • 12,725 posts

Posted 18 June 2017 - 11:08 AM

In worksheet 1 I have a 10 row table with following columns: Position, Player, Club, Manger

 

e.g.

 

GK    MIGNOLET LIVERPOOL  STE 

GK    CECH     ARSENAL    PETE

DEF   BAINES   EVERTON    ALAN

DEF   KOMPANY  MAN CITY   STE  

DEF   JONES    MAN UTD    PETE

MID   CAN      LIVERPOOL  STE

MID   ALLEN    STOKE      ALAN

MID   MANE     LIVERPOOL  PETE

FOR   KANE     SPURS      STE

FOR   INGS     LIVERPOOL  ALAN

 

In work sheet 2 I want to automatically populate a 4 row table from the data in the worksheet 1 table where the manager cell value = 'STE'

 

e.g.

 

GK    MIGNOLET LIVERPOOL  STE 

DEF   KOMPANY  MAN CITY   STE  

MID   CAN      LIVERPOOL  STE

FOR   KANE     SPURS      STE

 

Any ideas?


Edited by Cunny, 18 June 2017 - 11:11 AM.


#2 Behind Enemy Lines

Behind Enemy Lines
  • Sponsor
  • 2,703 posts

Posted 18 June 2017 - 11:59 AM

To see the content of this post you must Register or Sign in to your account.



#3 Senrab_nhoj

Senrab_nhoj

    Typo Knig

  • Sponsor
  • 2,270 posts

Posted 19 June 2017 - 08:19 AM

To see the content of this post you must Register or Sign in to your account.



#4 philmatthews

philmatthews
  • Members
  • 4,099 posts

Posted 19 June 2017 - 08:51 AM

To see the content of this post you must Register or Sign in to your account.



#5 charlie clown

charlie clown

    No way home...

  • Moderators
  • 16,504 posts

Posted 19 June 2017 - 03:45 PM

To see the content of this post you must Register or Sign in to your account.



#6 Cunny

Cunny

    Doyen of Topiary

  • Sponsor
  • 12,725 posts

Posted 19 June 2017 - 09:23 PM

To see the content of this post you must Register or Sign in to your account.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users