# Excel question regarding if() loops?

**URL:** <https://forum.kirupa.com/t/excel-question-regarding-if-loops/210024>\
**Category:** Uncategorized\
**Created:** [December 14, 2006, 4:36am UTC](https://forum.kirupa.com/t/excel-question-regarding-if-loops/210024 "2006-12-14T04:36:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![The\_Vulcan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/the_vulcan/32/145_2.png) [@The\_Vulcan](https://forum.kirupa.com/u/The_Vulcan)\
**Post date:** [December 14, 2006, 4:36am UTC](https://forum.kirupa.com/t/excel-question-regarding-if-loops/210024/1 "2006-12-14T04:36:45Z")

</div>

\*\*  
I dont know if this can be done in excel…\*\*

Say I have a sheet with a list of jobs with details and a tick box to show when they are complete.

[COLOR=Blue]A. tick  
B.  
C. tick  
D. tick  
E.  
F. tick[/COLOR]

I want to generate a report that only shows the completed jobs.

[COLOR=Blue]A. detals  
C. detals  
D. detals  
F. details[/COLOR]

I know I could get it to show.

[COLOR=Blue] A. details  
B.  
C. details  
D. details  
E.  
F. details[/COLOR]

But i really dont want blank rows of data in it…

I know how I would do it in a program  
[COLOR=Blue]while (i \<= F)  
if (n = tick)  
print (n)  
n++  
i++[/COLOR]

\*\*but can you get excel to enter a loop like that ?

\*\*