View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_44_] hotherps[_44_] is offline
external usenet poster
 
Posts: 1
Default Loop a long formula through range

I have the following formula that works well:

=IF(AND(B2=D25,D25<=C2,E24=AK1,AK2="X",E34E25),E 24,"")

I want to loop this formula through each cell in range B2:BB100

The result that is returned E24:P24 is a cell with some text in i
that should be displayed in each cell that meets the criteria in th
row loop range.

But the references to cells in E34E25 and AK1 need to increment to th
next cell to the right (i.e. F34F25 and AL1 etc.) in the range (E:P
AK:AV) each time the result of the formula is false or "".

Is this the right approach (long formula and loop)?
If so I need help writing the loop

Thanks!

--
Message posted from http://www.ExcelForum.com