Forum Discussion

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 Sort Query.pdf230 KB

excel

Formulas and Functions

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

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.