I downloaded a huge file in to excel. I selectively need to delete some
entries which in this case are all in "rows" NOT columns. Is there a
formula to do this?
Example
A B C
1.J.Smith 12/01/95 Active
rose - flower
2. D. Aaron 1/2/08 Active
Pink - flower
3. G. Stephen 9/04/04 Inactive
rose and pink -flower
What I want to do is sort a) by type of flower they sale b) select
when they sale more than one product c) by hire date.
The file has 185 employees. Each person's info is in two rows. Sort to
be done by the second row only.




--
ab3d4u