View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Mos.StaLL@gmail.com is offline
external usenet poster
 
Posts: 7
Default Search end of data in column

I usally import data that varies in rows, sometimes it generates 1000
rows sometimes 2000 rows, again it varies. I have a forumula that
searches a range, for example, one forumula sums all the values in
B2:B10000. I set my range to 10000 because I never know how many rows
I am going to import. Is there a formula that I can use that allows
me to find the end of the data in a column?

James