case Posted to ExcelForum

[ziad alsayed]

dear all

please find below link

http://www.excelforum.com/excel-general/766165-excel-array-formula.html#post2480077


Appreciate any help

 

[ziad alsayed]

Any Idea

 

[Ruddles]

I tried to download the workbook but it asked me to log in.

And some people are very nervous of downloading anything with the word "Nigeria" in it!

 

[ziad alsayed]

dear ruddles

, don't worry there is nothing in it. (actually JeffreyBrown) was assisting me in sorting out the issue, but we couldn't sort it out. so he suggested to me to post it into excelforum, which i did

below is the history link of the thread on this Board.

http://www.mrexcel.com/forum/showthread.php?t=532114

also if it is Ok by you , if have no problem sending you the file if you send me your e mail

Appreciate your input

 

[Ruddles]

If it's an array formula, I can't help - I'm not very good with them. Sorry.

 

[ziad alsayed]

thanks Ruddles , No Problem

 

[ziad alsayed]

dear all

How can we do it in VBA?

i a am really sorry, i know i am inssisting on it, but this Array formula is really slowing the file calculation

appreciate any help.