Ahromi Irawan, Cirebon wrote: > > > OOo 2.1 Calc; WinXP > > Dear All, > > how i can find an empty cell in a data range, if I use filter it will > removing the data structure. > what the RegEx syntax's that find an empty cell ? > > -- > Ahromi, Indonesia > I Can't speak english well > >
If there is no regular expression (which I believe to be the case), you could use formulas to search each column and row. For example, suppose your data range is A1:J100 . I A102, insert the formula =ROWS(A1:A100)-COUNTA(A1:100) . Drag the formula to column J - that will tell you the number of blank cells in each column. In L1, the formula =COLUMNS(A1:A100)-COUNTA(A1:100) will tell you the number of blank cells in row 1 and you can drag it down to row 100. -- View this message in context: http://www.nabble.com/--Find-an-empty-cell-in-Data-Range-tf3452240.html#a9634114 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
