Thread: Need help sorting data in columns that will sort by number of Xs
View Single Post
 
Old 04-06-2014, 01:51 AM
Kevin@Radstock Kevin@Radstock is offline Windows 8 Office 2013
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
Perhaps something along these lines using a helper row. In this case I have the helper row in J3:P3 and formatted as ";;;" (Without the double quotes) to hide the helper row.

The formula in J1 is an array formula and copied across.
Attached Files
File Type: xlsx 005-Poll Results for Excel Forum.xlsx (17.1 KB, 12 views)
Reply With Quote