Forum Discussion
Adrian Marston
Jun 15, 2017Copper Contributor
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,...
Adrian Marston
Jun 15, 2017Copper Contributor
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
Jun 15, 2017Iron Contributor
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.