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

Loop a long formula through range
 

Hi
not sure why you want to do this in VBA. what is your goal with this
(there may be a simple worksheet function to achieve this)?

--
Regards
Frank Kabel
Frankfurt, Germany


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 it
that should be displayed in each cell that meets the criteria in the
row loop range.

But the references to cells in E34E25 and AK1 need to increment to
the 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/

Loop a long formula through range
 

Let me explain, first off I pasted the wrong formula, it should hav
been:
=IF(AND(E$1=$B2,E$1<=$C2,$E$24=$AK$1,$AK$2="X",$E $34$E$25),$E$24,"")


I'm trying to populate a work schedule with different tasks, If a
employee A2 is working in a time range E1:EI1 (Time of Day) with
start time B2 and an end Time C2 that is within the Time of Day Range

And a task is required E34 E25

And the employee can do the task AK2 = "X"

Then the cell in the loop range should = E24 (The task name)

Then loop this for each employee in range A1:A100

Thanks

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