Angelo, I didn't use iteration. Perhaps you're confusing the concept of iteration with something else. Iteration is a special kind of resource in writing formulas for excel, that takes advantage of circular references. Google for "excel iteration" for more on this, or see for example here: http://people.revoledu.com/kardi/tutorial/Excel/Iteration.html
<http://people.revoledu.com/kardi/tutorial/Excel/Iteration.html>Excel iterations are very useful for some problems that regular formulas can't help, but that's not your case. If I understood correctly, what you are asking for can be solved with simple =IF() formulas. In the sheet you sent, there were 3 cases to consider - that is simple to do with a couple of nested IF's. However, if you have a more complicated problem in your hand, you should consider using a VLOOKUP if possible, or using an specific macro. If my explanation didn't help you, you can try sending us your file. The more information you give us about your problem, the easier will be to understand what you really want and help you. Regards On Fri, Aug 13, 2010 at 7:48 PM, Angelo Spinola <spinolaang...@gmail.com>wrote: > Hi, > > thanks, yes, is the number of if iteration ilimited? > > Regards > > > 2010/8/12 Bruno Bruno <brunobbr...@gmail.com> > >> See if it's this what you want. >> >> >> On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola <spinolaang...@gmail.com >> > wrote: >> >>> Dear Bruno, >>> >>> I will send you an attachment, so i can make this clear. Result is based >>> on size and code as you can see... i have put some sample data for column >>> that i desire that is result. >>> >>> Regards, >>> Angelo Spinola >>> >>> 2010/8/12 Bruno Bruno <brunobbr...@gmail.com> >>> >>> Hi Angelo, >>>> I'm still confused about exactly what you want. Are you really sure >>>> you're looking for an iteration? >>>> >>>> You say that If in cell A1 i have "aaa" it should stay the same, but if >>>> i have "bbb" it should be changed to "ccc" , but cell A1 *has* "aaa" or >>>> *displays* "aaa"? >>>> - If it has "aaa", then there is nothing to iterate here. I think you >>>> would be looking for a macro then. >>>> - If it displays "aaa", where is the cell feeding this value from? Are >>>> you sure you need to iterate cell A1 with itself, and not simply change the >>>> string with a formula? >>>> >>>> Regards >>>> >>>> On Wed, Aug 11, 2010 at 6:51 PM, Angelo Spinola < >>>> spinolaang...@gmail.com> wrote: >>>> >>>>> Dear Bruno, >>>>> >>>>> Thanks for the feedback. >>>>> >>>>> If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" >>>>> it should be changed to "ccc". >>>>> >>>>> >>>>> Regards >>>>> >>>>> 2010/8/11 Bruno Bruno <brunobbr...@gmail.com> >>>>> >>>>> Hi, >>>>>> I am not pretty sure of what you want, but aren't you looking for a >>>>>> simple formula? Something like: >>>>>> >>>>>> =IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3)) >>>>>> >>>>>> Where A1 is the cell with "aaa" >>>>>> >>>>>> >>>>>> On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola < >>>>>> spinolaang...@gmail.com> wrote: >>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> >>>>>>> How can i create and iteration for: >>>>>>> >>>>>>> If cell 1 is "aaa" then leave it the same >>>>>>> >>>>>>> else >>>>>>> >>>>>>> if cell "bbb" then change it to "ccc" >>>>>>> >>>>>>> and continue.... >>>>>>> >>>>>>> >>>>>>> Can you use other type of iteration...like for example switch or for? >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards to all member, >>>>>>> Thanks! >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> ---------------------------------------------------------------------------------- >>>>>>> Some important links for excel users: >>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>> http://twitter.com/exceldailytip >>>>>>> 2. Join our LinkedIN group @ >>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>> >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>> HELP US GROW !! >>>>>>> >>>>>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>>>>> about the learning and support from the group.Let friends and co-workers >>>>>>> know they can subscribe to group at >>>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Join our LinkedIN group @ >>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>> >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> HELP US GROW !! >>>>>> >>>>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>>>> about the learning and support from the group.Let friends and co-workers >>>>>> know they can subscribe to group at >>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 7000 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
