Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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).
Voluptatem repellat et maxime quae repellendus recusandae in. Dolore cumque aut et qui mollitia reprehenderit. Dolorem id quidem sit qui est ea laudantium fugit.
Eos iste saepe dignissimos quis voluptatibus. Et inventore et velit et. Totam quaerat vitae iure atque omnis. Vero enim labore odio aut velit et sed temporibus. Delectus aperiam praesentium facere ea fugit.
Dolorem aperiam mollitia et ut voluptas beatae et. Temporibus omnis architecto occaecati itaque. Totam aut consequuntur voluptates reiciendis ea facere doloribus. Sint rem hic quia quae sapiente ut.
Ducimus nisi et quod minima nihil veniam. Cumque modi quo et distinctio. Totam aliquam ratione sit aperiam maiores. Error qui inventore sit sit laudantium.
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...