View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] cipo.tm.forms@gmail.com is offline
external usenet poster
 
Posts: 2
Default Best way to create a sorting table with non numerical values

For calculating the results this works well thank you.

For the date I was looking for a way to have a field/button that could help me display either : All date, 07/18 or 08/18 (since these are the dates I have for now, but will eventually have more to account for).

This way I can generate monthly reports or annual ones.



On Friday, August 31, 2018 at 7:43:39 PM UTC-4, zvkmpw wrote:
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.