To highlight largest and smallest values in a worksheet I have used large and small function to calculate and then and index to highlight name attached
it presented a problem with nothing being shown for the smallest value when zeros are present in the range. I corrected this by amending the small function to![]()
Please Login or Register to view this content.
but now it will not pick up the name for the resulting smallest numberhow can I amend the index to do this??![]()
Please Login or Register to view this content.
Any help appreciated.
Bookmarks