I downloaded to study the excel in this forum address below:
http://www.excelforum.com/excel-form...each-item.html
excel exists also here as attachment.
I couldn't reapply formulas in D, E and F columns.
What I tried for D column reapplication was:
I copied formula in E5 from formula bar
I selected J5:J39
ı pasted formula into address bar
I hit ctrl+shift+enter combination
result: All values are same in J5:J39
I need urgent help because of my job. unfortunately this was my 1st array formula usage so i failed
thanks in advance
best regards
Bookmarks