TransWikia.com

MS-EXCEL How to Rank three columns together using countif

Super User Asked by fadi on August 20, 2020

I am trying to rank these three columns based on the minimum values in all three simultaneously, using the formula shown in the picture. But somehow, it selects the values that aren’t minimum in one of the columns, as i highlighted in Yellow.
How do I organize the formula so it wont give the rank this way. Ideally it should have ignore the 58 161 41 value.

IMG:

2 Answers

As you have ruled out the possibility of an incorrect formula in that row (fill error), there is no way this can normally happen.

Therefore we must conclude your Excel workbook has become corrupted.

Excel detects some types of corruption itself, when it will automatically start the File Recovery mode. In other cases, you must start the recovery process manually

Microsoft provide these instructions to manually repair a corrupted workbook.

Answered by Reg Edit on August 20, 2020

It should work.

Therefore I conclude there is a fill error in your sheet. This has meant that the problem row does not contain the formula you think it does.

Reapplying the fill down from the cell you have shown in your screenshot should resolve the issue.

Answered by Reg Edit on August 20, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP