offset&address

[mohadin]

Hi all
in cell
e2=OFFSET($E$2;ROW($A$1)-2;COLUMN()-4)
drag it down would be ok
but copy it to other cell in col E should be like this:
E2=OFFSET(E2;ROW($A$1)-2;COLUMN()-4)
causes problem when drag it down
so' i'm trying to replace the ref in offset with the formula [ADDRESS(ROW();COLUMN())]
but It do not like it
any Ideas
Thanks

 

[mohadin]

PLEASE SEE THE ATTTACED

 

[NARAYANK991]

Hi ,

Instead of asking us to debug your formula , can you explain what you want to do , so that members can suggest the correct formula , if that is possible ? If a formula-based solution is not possible , VBA can certainly do the job.

Narayan

 

[mohadin]

Hi Narayan
thank you very much
You are right
I was thinking about doing that but the net was down for some time
may I start a new thread, or carry on right here?

 

[NARAYANK991]

Hi ,

Anything of your choice ; since this thread was anyway started by you , I think continuing with this one should not be a problem.

Please post your problem description in this thread itself.

Narayan

 

[mohadin]

here you are
the explanation in the attached file
thanks

 

[NARAYANK991]

Hi ,

I am not sure this will work well. Check thoroughly.

Narayan

 

[mohadin]

Hi
thank you Mr. NARAYANK991
well It's ok but in my original work column F might not be empty
so.... I don't know
any Ideas?

 

[NARAYANK991]

Hi ,

So if the file you uploaded does not match what you actually use , that means we start all over again. Provided both of us have the time and the inclination.

Post your actual file ; someone else will help.

Narayan

 

[mohadin]

Hi ,

So if the file you uploaded does not match what you actually use , that means we start all over again. Provided both of us have the time and the inclination.

Post your actual file ; someone else will help.

Narayan

Thank you for your kindness