Ask Your Question
0

COUNTIF and the data range

asked 2015-07-01 06:18:10 +0200

lolax gravatar image

updated 2015-08-25 06:52:34 +0200

Alex Kemp gravatar image

LibreOffice 4.3.7 , Windows 7 The data has 1500 rows, and I used the data range $A$1:$A$1048576 for the formula =IF(COUNTIF($A$1:$A$1048576,A1)>1,"Y","") even it's only 1500 rows , then I tried to add one row between row 1 and row 2 and got the error message "$REF!".

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-07-01 08:29:55 +0200

karolus gravatar image

If you insert a Row, the Range in formula expands to $A$1:$A$1048577 which is out of available Rows, →→ $REF-error

edit flag offensive delete link more

Comments

So it can't be converted into $A:$A automatically like MS excel when the maximum number of rows have been reached.

lolax gravatar imagelolax ( 2015-07-01 10:10:47 +0200 )edit

@lolax: exactly

karolus gravatar imagekarolus ( 2015-07-01 10:35:36 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-07-01 06:18:10 +0200

Seen: 290 times

Last updated: Jul 01 '15