Stephan wrote: > To get a more user friendly result, use the following formula: > > = IF(MIN(ISNUMBER(G4:H7)), "All values are numeric", > ADDRESS(MIN(IF(ISNUMBER($G$4:$H$7), "All good", ROW($G$4:$H$7))), > MIN(IF(ISNUMBER(OFFSET($G$4:$H$7,MIN(IF(ISNUMBER($G$4:$H$7), "All > good", ROW($G$4:$H$7))) - MIN(ROW($G$4:$H$7)), 0, 1)), "All good", > COLUMN(OFFSET($G$4:$H$7,MIN(IF(ISNUMBER($G$4:$H$7), "All good", > ROW($G$4:$H$7))) - MIN(ROW($G$4:$H$7)), 0, 1))))))
I just have a small correction to make. For consistency, the first range reference in the formula should also be absolute (i.e. G4:H7 should be $G$4:$H$7). So the formula should actually be: = IF(MIN(ISNUMBER($G$4:$H$7)), "All values are numeric", ADDRESS(MIN(IF(ISNUMBER($G$4:$H$7), "All good", ROW($G$4:$H$7))), MIN(IF(ISNUMBER(OFFSET($G$4:$H$7,MIN(IF(ISNUMBER($G$4:$H$7), "All good", ROW($G$4:$H$7))) - MIN(ROW($G$4:$H$7)), 0, 1)), "All good", COLUMN(OFFSET($G$4:$H$7,MIN(IF(ISNUMBER($G$4:$H$7), "All good", ROW($G$4:$H$7))) - MIN(ROW($G$4:$H$7)), 0, 1)))))) > Once again, remember to enter it as an array formula (by pressing > CTRL+SHIFT+ENTER instead of just ENTER). Regards Stephan -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
