Hi. Is there a way to list, on a separate sheet in the same workbook, only
rows of data with a value in a specific column? I want to list closed leads
and all data in
that row) as long as there is a specific value of 100 or 0 in column F. If
there is a different value in column F for that lead, then I don't want it to
appear on this list.
Is there a way to do this with a formula and not a pivot table? Ideally, I
would like it to add the row to the bottom of the list.
For example, my colums are (A-I):-
Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage,
Probability, First Name, Last Name and Received Date

Thanks