We help IT Professionals succeed at work.

Excel Formula to Iterate

124 Views
Last Modified: 2017-04-25
Hello EE,

Can someone please help me write a formula that will populate cells based on information in the adjacent column.  Based on the attached spreadsheet.  Data in column A and wanted populate column B with values in Column A where values in Column A equals to Zero.  Here is my example and spreadsheet is attached
  1. Type1      Type2
  2. Online      
  3. 0      Online
  4. 0      Online
  5. 0      Online
  6. Mail      
  7. 0      Mail
  8. 0      Mail
  9. 0      Mail
  10. 0      Mail
  11. 0      Mail
  12. 0      Mail
  13. 0      Mail
  14. 0      Mail
  15. 0      Mail
  16. 0      Mail
  17. System      
  18. 0      System
  19. 0      System
  20. 0      System
  21. 0      System
  22. 0      System
  23. 0      System
MyText.xlsx
Comment
Watch Question

KoenSDM Mobile
CERTIFIED EXPERT

Commented:
copy this formula in B3 and copy down:


=IF(A3=0;IF(A2=0;B2;A2);"")

Author

Commented:
Thanks, Koen, it worked!  Can you help me fill the empty cells with what is in type 1 for example:

  1. Type1      Type2
  2. Online      Online
  3. 0      Online
  4. 0      Online
  5. 0      Online
  6. Mail      Mail
  7. 0      Mail
  8. 0      Mail
  9. 0      Mail
  10. 0      Mail
  11. 0      Mail
  12. 0      Mail
  13. 0      Mail
  14. 0      Mail
  15. 0      Mail
  16. 0      Mail
  17. System      System
  18. 0      System
  19. 0      System
  20. 0      System
  21. 0      System
  22. 0      System
  23. 0      System
  24. 0      System
  25. 0      System
  26. 0      System
  27. 0      System
  28. 0      System
  29. 0      System
  30. 0      System

Thanks, this far for your help...
SDM Mobile
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you so much, Sir! It worked like a charm
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.