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