Get instant live expert help on I need help with iteration in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Type in the R square of my model ( Hint: R square after first iteration) ?
Solved by A. L. in 20 mins
If there is a duplicate value in the same column, i want it to put into the next column to the 1st value 1, second iteration 2 etc.
Solved by T. B. in 14 mins
Hi, in the file the sheet number 2 must have the cell B11 the same value as in the cell 91. But this is not so. Please help to solve the problem. I have activitat "iteration" in the options of Excel. I think that this do not work correct. Thanks Holger
Solved by C. U. in 15 mins
I am creating a membership chart for a chartered club where we charge for a daily fee and hourly fee. Column A is the Name, B is the fee. I need a function for column B to be blank until a name is scanned into column A, once a name is scanned it copies the member fee (from column D4), HOWEVER once the 2nd scan (scan out) it is 0.00. the problem with the formula I use, is that BOTH daily fees get changed to 0.00 instead of just the second iteration. How can I fix this? =IF(A7<>"",IF(COUNTIF($A$7:$A$33,A7)>1,"0.00",$D$4),"")
Solved by O. J. in 19 mins
i need help in dates in excel , how to count dates in excel ,
Solved by S. E. in 20 mins