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