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,...
Logaraj Sekar
Jun 15, 2017Iron Contributor
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 MarstonJun 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 SekarJun 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.