LinkBack URL
About LinkBacks
Have $ amt data on F2:F31 need sort by =>$50K (equal to or greater than $50K)
help advanced filter or conditional formatting for excel 2003
Have $ amt data on F2:F31 need sort by =>$50K (equal to or greater than $50K)
help advanced filter or conditional formatting for excel 2003
Last edited by raw_geek; 05-31-2012 at 12:19 PM.
hi raw_geek, u wanna maybe upload a file & show the desired results?
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
here I attached my excel sheet. I want sort columns F by =>$50K (equal to or greater than $50K)
I mean I want see only =>$50K amt
hi raw_geek, do u need it sorted by descending order, filtered to see just results =>$50k or both? i can't remember exactly where the Autofilter, Sort & Advanced Filter is at Excel2003. they should all be in the Data menu if i'm not wrong. but i remembered these shortcuts u can use.
Sort: ALT D S
Sort by Cost (Descending / Largest to Smallest)
Autofilter: CTRL + SHIFT + L
Use the filter on Cost & choose Greater or equals to 50000
if u wanna do conditional formatting, select F3:F49, choose Conditional Formatting & put this formula:
=F3>=50000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks