Forum Discussion

Adrian Marston's avatar
Adrian Marston
Copper Contributor
Jun 15, 2017

Sorting 2 Columns of Data in Excel

Good morning.   I would like to sort two columns of data in Excel.   In Column J I have results called 'VSC Results'  in column N I have results called 'NSL Results'.   I then have all my rows,...
excel
Formulas and Functions
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Jun 15, 2017

Hi Adrian Marston,

 

You asked for sorting. It is possible.

 

But data in pdf shows there is a gap between data. You can't apply filter by selecting all. Because whole data will combine without separation.

 

If don't want to combine them, you can apply filter by selecting each group.

 

If you want COUNT of above, i will refer formula. Which one you want.

  • Adrian Marston's avatar
    Adrian Marston
    Copper Contributor
    Jun 15, 2017

    Thank  you for the quick reply.  I would like a count please to show total number of 

     

    Fail/Fail

    Fail/Pass

    Pass/Pass

    Pass/Fail

     

    Regards

    • Logaraj Sekar's avatar
      Logaraj Sekar
      Iron Contributor
      Jun 15, 2017

      Hi Adrian Marston,

       

      Just put the formula in cells, where you want result.

      =COUNTIFS(J:J,"fail",N:N,"fail")
=COUNTIFS(J:J,"fail",N:N,"pass")
=COUNTIFS(J:J,"pass",N:N,"pass")
=COUNTIFS(J:J,"pass",N:N,"fail")

      each formula in each cell.

       

      Ask if you have any queries.

Resources