Locating and displaying data from a rather long column.

[Ivanhoe]

I have a long column, mostly blank, but I need to collect the data from the cells that are not blank and print the information along with a note of the cell reference. Any hints as to how I go about this will be helpful.....Yup! Bill F.

[PaddyD]

Bill,

Many ways to do this:

1) Select data...filter...autofilter, then select non blanks from the list. do whatever next....

2) Assuming your data is in col A, try the following:

=IF(ISBLANK(A1)=FALSE,"Cell reference is: "&CELL("address",A1)&" Cell Value Is: "&A1,"Blank")

3) Hope some bright VB spark throws up something more elegant.

Hope this helps,

Paddy

[Ivanhoe]

Thanks Paddy, it works great - appreciate the pointer. Changed it about a bit of course to get the result I need but you saved me a good bit of time. Thanks Bill