Sorting 2 Columns of Data in Excel

[Adrian Marston]

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, and in each row I have either a 'pass' or a 'fail' in the results columns for both columns J and N.

I would like to sort the results so I get the numbers of passess and fails for differnet permutations

eg

Fail VSC (results from column J)  and Fail NSL (results from column N) = X number count

Fail VSC but Pass NSL = ?

Pass VSC and Pass NSL = ?

Pass VSC but Fail NSL = ?

Screenshot attached.

I am sure there is a very simple way to do this, whether with a formula/filter, or a pivot table, but I don't know how to do this.  Any help would be very much appreciated.

Thank you in advance

[#2]

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.

[#3]

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

[#4]

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.