Okay... i am working on a database of leads that I retrieved online. All of the information was posted in column A since it was copied straight from a web page. Using the Phone number as an example... the phone number for every company is seperated by 18 cells in column A.
I am looking for a fomula that I can apply to the column that I am placing the phone number in (column D for arguments sake) which will reference every 18th cell in column A.
I have tried the OFFSET formula for this, and it works just fine for the initial reference. The formula I am placing in column D looks like this: =Offset(A34,18,0) This effectively returns the value in cell A52. However, when i try to drag that down to the next cell in column D, it returns the following: =Offset(A35,18,0) when what I want it to return is =Offset(A52,18,0) so that it references cell A69.
How can I get the formula to skip the 18 lines and then continue the fomula from that 18th line, and not the one below the originally referenced line?
Does this make sense? Please, someone help me. i have 3 people already racking thier brains on this.
Thanks.
Bookmarks