LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Formula to sort names in alphabetical order? Fredrik Jonsson Excel Discussion (Misc queries) 0 September 1st 05 04:33 PM
Sum if or some sort of match formula JavyD Excel Worksheet Functions 3 May 5th 05 05:14 PM
Preform alphabetical sort without formula in cell changing ace Excel Discussion (Misc queries) 1 April 16th 05 01:46 PM
Formula Integrity Not Preserved During Sort in Excel 2000 Kevin Excel Discussion (Misc queries) 1 April 15th 05 10:26 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"