troubleshooting Question

Excel Formula to Iterate

Avatar of fb1990
fb1990 asked on
Microsoft OfficeMicrosoft Excel
4 Comments1 Solution134 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros