View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default HOW DO I SORT USING THE IF FORMULA!!!

I really need help!!! this is extremally important for me, and I can't do it;
I tried a lot of options no one works;... Im getting carzy.

I have this sheet 1:
A B C
Loan ID TX
1 550 42 0
2 980 52 1
3 120 80 2
4 333 44 1
5 890 33 0

The information that counts for me is the one in column C. I have to send a
report with ONLY the rows that the number on C is more than 0 without losing
the data on each row.
Using the example above the new report would be in a different page like this.
Sheet 2
A B C
Loan ID TX
2 980 52 1
4 333 44 1
3 120 80 2

Without the rows that have a 0 on column C.
If anybody could help me it would be really appreacieted!!!
I was thinking using the IF formula in another sheet but don't know how.
Thank you.