L
Laura Keith
I am making a text list down 1 column of at least 1000
rows. I need Excel to continue to scan all entries for
duplicate text. Does anyone know how many rows above
and/or below an entry, does Excel do the AutoComplete and
highlight the duplicate entry? Is it changeable ie: if
Excel scans for 100 rows, can it be changed to scan 1000
rows?
Thanks!
rows. I need Excel to continue to scan all entries for
duplicate text. Does anyone know how many rows above
and/or below an entry, does Excel do the AutoComplete and
highlight the duplicate entry? Is it changeable ie: if
Excel scans for 100 rows, can it be changed to scan 1000
rows?
Thanks!