Patcheen
Active Member
- Joined
- Sep 28, 2015
- Messages
- 391
- Office Version
- 365
- Platform
- Windows
Im using this formula to eliminate any blanks and return the most item value instead...
{=INDEX(B2:B21,MODE(IF(B2:B21<>"",MATCH(B2:B21,B2:B21,0),0)))} (Array Formula)
but it still returns blanks
example in b2:b21 is - oranges x8 - apples x2 - pears x4 and blanks (no value) x6 (it should show "apples"
the X represents the amount of times the word appears in the row from b2:b21 etc etc
thank you all in advance for your input and help
{=INDEX(B2:B21,MODE(IF(B2:B21<>"",MATCH(B2:B21,B2:B21,0),0)))} (Array Formula)
but it still returns blanks
example in b2:b21 is - oranges x8 - apples x2 - pears x4 and blanks (no value) x6 (it should show "apples"
the X represents the amount of times the word appears in the row from b2:b21 etc etc
thank you all in advance for your input and help