I have a spreadsheet witht he following formula - the intention is to list id numbers of individuals. Unfortunately when this was written the id's contained only numbers e.g 12345 since the inital development the id's of individuals have changed and there are now a mixture of text and numbers as well as number only. e.g. GOV6224
=IF(ISERROR(SMALL($R$3:$R$34,ROW()-ROW($S$3)+1)),"",SMALL($R$3:$R$34,ROW()-ROW($S$3)+1))
The formula only recognises the number only id's. I need the formula to recognise either and return an answer
Does anyone have any idea how I can achieve this?
Thanks
Bookmarks