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!”
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