Excel VBA - Counting Negative Values and Ranking Them
Trying to count the negative values and ranking them from highest count to lowest
Capture.PNG
I was going to use the worksheet function like this
But not sure how I can rank them. Maybe I need to use array here?
Please Login or Register to view this content.
Result should rank Orange (3), Banana (2) and Apple (1)
Why not just use a formula to rank?
For that matter, why not also just use a formula for the Countif?
If you can provide a sample workbook that sure would help and a better idea on how you want to achieve what and where.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
HTH
Regards, Jeff
Right, this is easy with Formula but that's not an option, the result can be anything like msgbox or result on any cell
How about...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks