Start Free TrialLog in
Avatar of fb1990
fb1990

asked on 

Excel Formula to Iterate

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
Microsoft ExcelMicrosoft Office
Avatar of undefined
Last Comment
fb1990
Avatar of Koen
Koen
Flag of Belgium image
copy this formula in B3 and copy down:


=IF(A3=0;IF(A2=0;B2;A2);"")
Avatar of fb1990
fb1990

ASKER

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...
ASKER CERTIFIED SOLUTION
Avatar of Koen
Koen
Flag of Belgium image
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of fb1990
fb1990

ASKER

Thank you so much, Sir! It worked like a charm
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent