Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Another excel question

Cunny

By Cunny
in The Swanny

 Share

Recommended Posts

Cunny

Cunny

Posted
Posted (edited)

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
Cunny

Cunny

Posted
  • Author
Posted

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

Home

Notifications

PMs
×
×
  • Create New...