I need to sort column "C" largest to smallest. However, I don't want any blank cells showing. Please see attached file.
I need to sort column "C" largest to smallest. However, I don't want any blank cells showing. Please see attached file.
Why not have a filter on columns A to C (not just on col B), then sort column C largest to smallest, and exclude blanks in the filter.
Please see attached.
Your filter was only on Column B. You have to turn off the filter, select the entire Row 1 and turn the filter on. Then sort Column C largest to smallest, then filter out the blanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks