I have a range of cells that are a mix of blank cells and cells containing a
time, name and purpose eg "10.30 John S Golf"
there should be no more than 10 cells containing text.
i want a range of cells say b2:b12 to represent this information in time order
I have tried using the small function but this will only work for cells
containing numbers only.
Some cells will contain text only with no time I want those to appear either
at the end or the start of the list.
i think this will require a combination of the search if and small functions
but not sure quite how!!
Any suggestions gratefully received.