Trending Content
| +86 | Are you “less ambitious” for having long term goals outside of NYC | 22 | 1d | |
| +65 | Affair with my Associate… In Desperate Need for Advice | 23 | 4d | |
| +53 | How to sound more eloquent? | 25 | 17m | |
| +40 | WSO Ranking On Resume??? | 10 | 14h | |
| +34 | Interviews Are So Fake | 20 | 3h | |
| +30 | 2024 UK Election - Tories finished? | 18 | 6h | |
| +29 | Why do people listen to Jim Cramer Investing Advice? | 13 | 7h | |
| +27 | Carnivore Diet | 13 | 2d | |
| +26 | Is my boss gaslighting me? | 3 | 4d | |
| +24 | Chaotic Insane investment banker who passed away in the 90s or 2000s | 12 | 4d |
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).
Placeat non ea esse qui. Sed odio est iure modi esse non delectus. Voluptate eos pariatur eligendi in ducimus possimus exercitationem. Accusamus incidunt expedita nisi nisi facilis. Aut sed porro rerum molestiae repellendus nulla modi. At vel enim deserunt dolorum sint et.
Blanditiis rem quasi aliquam et accusantium voluptate. Perferendis optio et ut laudantium laborum delectus perspiciatis.
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...