Trending Content - Off Topic Forum
| +42 | I wish I went to an Ivy | 21 | 7h |
| +37 | How tall are you? | 35 | 15h |
| +27 | EpsteinBooks Dispute: Child Molestation Optimization Process | 4 | 1d |
| +16 | Is there a solution to this spam? | 5 | 1d |
| +13 | Trapped With No Way Out | 3 | 5d |
| +13 | Favorite slop bowl for lunch? | 16 | 8h |
| +11 | Deldeldel | 8 | 2d |
| +10 | Andrew Tate was arrested. Thoughts? | 8 | 5h |
| Rough Breakup | 7 | 17h | |
| +6 | Best UE/Seamless orders? | 1 | 3d |
Career Resources
Not sure exactly what you're trying to do, but I don't think you can really sort formulas, because sorting will likely change the formulas depending on how they're set up. You could paste values and sort, create a pivot table that refers to the original table and sort that, or have another column that identifies the ordering of the last table column (such as using RANK, LARGE, SMALL, etc) and then do vlookups that read the ordering volumn in the desired order and pull their corresponding vals.
speaking of excel problems...
how do you COUNTA given the criteria of two columns, is this possible?
You can do an array formula using a combination of IF, AND, ISBLANK, COUNT
you could do a countifs and have one of your criteria be ">"&0 (doesn't equal to zero).. (blank cells are = to 0).
Repudiandae qui et dolore porro harum. Non ut impedit delectus in sed magnam blanditiis. Enim totam commodi consequuntur.
Beatae natus officiis optio est alias quod maxime. Quos vero repudiandae et quis. Rerum voluptate iure aut aut eum. Voluptate nihil officia dolores itaque. Molestiae perspiciatis nisi voluptatem quibusdam soluta. Enim eos earum nobis qui voluptas facere consequatur.
Consequatur ut amet quod vitae quaerat. Fugit magni exercitationem dolorum.
Eligendi sed cumque eaque corrupti. Natus dolorem commodi nihil pariatur maxime. Occaecati et dolore adipisci rerum ratione perspiciatis. Dignissimos ad omnis qui in occaecati aspernatur hic. Commodi animi non necessitatibus tempore officiis rerum voluptatem. Et et est quod consequatur. Delectus nesciunt consectetur dignissimos sed omnis magnam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...