this formula will properly pull numbers but it wont get text...
can someone break it down for me so I know which part needs to be changed to allow it to get text and numbers?Please Login or Register to view this content.
this formula will properly pull numbers but it wont get text...
can someone break it down for me so I know which part needs to be changed to allow it to get text and numbers?Please Login or Register to view this content.
Methinks a dummy workbook with a few examples of correct results would greatly help. As a first point, SMALL ignores text and deals only with numbers.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks