+ Reply to Thread
Results 1 to 8 of 8

How to write FILTER to see the related line and one line below it together

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    How to write FILTER to see the related line and one line below it together

    Hey again MY CLEVER BUDDıES,

    İ attached the file , please tell me the method for filtering data and ama i wanna see also one line below

    For example : i want to see the match pairs whose home teams scored 2 and more than 2 goals in the fixture but, i also want to see the away team lines in these matches. in attached file, 5th match schalke-dortmund: 2-1 so home team scored more 1 goal so i wanna see schalke and dortmund lines as pair when i filter. or augsburg-werder bremen : 4-2 , i wanna see both these 2 teams lines together.

    how i can write filter for this? please help me
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-16-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    31

    Re: How to write FILTER to see the related line and one line below it together

    Simply Sort the Data and can count it
    Attached Files Attached Files

  3. #3
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: How to write FILTER to see the related line and one line below it together

    i didnt understand ur method, mngrshoaib
    but its giving wrong outputs

  4. #4
    Registered User
    Join Date
    01-16-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    31

    Re: How to write FILTER to see the related line and one line below it together

    Dear what kind of filtration u need, i mean which column Name or score

  5. #5
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: How to write FILTER to see the related line and one line below it together

    i told everything in post #1
    i want to see home and away teams together when home team scores =>2 goals

  6. #6
    Registered User
    Join Date
    01-16-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    31

    Re: How to write FILTER to see the related line and one line below it together

    together means add if condition gets true. Do you mean it?

  7. #7
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: How to write FILTER to see the related line and one line below it together

    Werder Bremen : 2
    Mainz : 1
    ----------------------
    Bayern Munchen :3
    Stuttgart :0
    ----------------------
    Mainz :4
    Augsburg :2

    i wanna see like this , Home teams here Werder Bremen, Bayern Munchen, Mainz and they scored 2 or more goals. So i wanna see them with away teams in their match.

    also u changed the results in original file. Why u did this?

  8. #8
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: How to write FILTER to see the related line and one line below it together

    nobody else ll help me with subject , my friends? its really so easy i m sure

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error on formula after deleting a line on related sheet
    By drtduarte in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-29-2013, 07:59 PM
  2. [SOLVED] how to write three macro code in single line ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2013, 03:29 AM
  3. [SOLVED] Comparing two data sets that don't line up on a line to line basis
    By ghan7650 in forum Excel General
    Replies: 10
    Last Post: 05-22-2012, 05:38 PM
  4. how to write sheet hide in one line?
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2010, 02:11 AM
  5. [SOLVED] Macro problem on, Yellowed line - previous line or next line.
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1