Forum Discussion
error msg when using IF( .when the colum reference is text
Riny_van_Eekelen thank you for the reply, i will go through the workbook you recommenced shortly, sorry if i was not more explicit with the problem, which as my second post tried to state i found one solution in the formulae. what i was trying to achieve was have the amount in column D to use the trigger in column G to make the amount in Column D auto place the amount in Column AI.
i am not sure i can create an array or a table as the number of rows in each month will vary depending on the number of transactions each month (may be 15 up to 60 rows).
redi_to_learn Perhaps you'll find the attached workbook helpful. Have tried to follow the logic from your latest post, though, I may have misunderstood.
Riny_van_Eekelen thank you for the reply, i will go through the workbook you recommenced shortly, sorry if i was not more explicit with the problem, which as my second post tried to state i found one solution in the formulae. what i was trying to achieve was have the amount in column D to use the trigger in column G to make the amount in Column D auto place the amount in Column AI.
i am not sure i can create an array or a table as the number of rows in each month will vary depending on the number of transactions each month (may be 15 up to 60 rows).