S
Stewy p
I need help in looking up the a table that is sorted by product and by
dept
and date. (In my actual file is around 5,000 rows/records)
eg.
product dept date
111 1111 feb-01-03
111 1111 jan-01-03
123 1111 feb-28-03
123 1234 feb-14-03
123 1234 jan-11-03
124 1111 feb-01-03
124 1234 jan-01-03
Once I type in a department (in cell a2), I want it to come up with the
products they most recently acquired. I managed to get cell b2 and c2
to come up. but cell b3 and c3 I can't do it.
e.g.
dept product date
1234 123 feb-14-03
1234 124 jan-01-03
dept
and date. (In my actual file is around 5,000 rows/records)
eg.
product dept date
111 1111 feb-01-03
111 1111 jan-01-03
123 1111 feb-28-03
123 1234 feb-14-03
123 1234 jan-11-03
124 1111 feb-01-03
124 1234 jan-01-03
Once I type in a department (in cell a2), I want it to come up with the
products they most recently acquired. I managed to get cell b2 and c2
to come up. but cell b3 and c3 I can't do it.
e.g.
dept product date
1234 123 feb-14-03
1234 124 jan-01-03