tag:blogger.com,1999:blog-1869924468172210809.post818618236401343601..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Knowing where you are in your spreadsheet, using the ROW and COLUMN commandsGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1869924468172210809.post-78719868140093112102014-09-16T14:43:32.642+01:002014-09-16T14:43:32.642+01:00Hi Glen and thanks for your help with ROW / COLUMN...Hi Glen and thanks for your help with ROW / COLUMNS.<br /><br />Look, i have a little problem with this formula from here:<br />http://dataage.blogspot.com/2009/01/validar-caracteres-contenidos-en-un.html<br /><br />=SUMPRODUCT(ISERR(FIND(MID(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1))),1),"AÁBCDEÉFGHIÍJKLMNÑOÓPQRSTUÚVWXYZ "))*1)=0<br /><br />Look the use about ROW(....)<br /><br />I know and understand what is the formula working for, but "the way" to use ROW (........) is completely strange or weird , right? .<br />In fact if you see, ROW() is working .. but with error inside.<br /><br />Would you offer me an explanation for this use ROW () .<br /><br />I never saw this function ROW () in this form.<br /><br />Thanks in adavance .<br />Anonymoushttps://www.blogger.com/profile/05745963116600826471noreply@blogger.com