CONDITION HELP ASAP!!

chelmones1203

New Member
Joined
Sep 17, 2006
Messages
2
Hi Everyone

I need help in creating formula that would:

Select only dates that are in my given range .. My Cell A1 composes all the dates in 2006. I want to display only dates that I define lets say, 09/17/2006 to 09/30/2006 and another column shows numbers. I want it to show only numbers that are 120 and above....


I appreciate anybody's help on this...
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
do autofilter-custom frist with column A and then the column where numbers are parked.
if necessary copy filtered data somewhere.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,401
Messages
5,547,740
Members
410,810
Latest member
thepinkbird
Top