Thread: Best way to create a sorting table with non numerical values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default Best way to create a sorting table with non numerical values
To make an example, I put the input data in A1:F5.

The result data will be in A8:F10. I filled in A9:A10 with Yes & No; B8:F8 with the Qs.

In B9, I put
=COUNTIF(B$2:B$5,$A9)
and copied it into B9:F10.

So far, that got the result specified in the post.

Then I tried to understand what "use the date a sorting mechanism" means here. Sorting A2:F5 by date leaves the result unchanged, which seems reasonable, but I suspect something more is intended here by the mechanism.
Reply With QuoteReply With Quote