I could not use the option of auto filter.no options to select my criteria
would come up.i did try advanced filter...but i couldnt...i need a solution
because doing it manually is too time consuming.


"starguy" wrote:


select your column headers i-e Empname, AccountCode, Hours, go to Data
Filter Auto Filter
now filter your data from the drop down list appearing on your
AccountCode column by selecting 100 (or any other code)

hope this will solve your problem.

Jess Wrote:
Hi...i cant quite figure out how to do this or if there is a way to.
Ive got 3 columns.Employee Name in A,AccCode in B, Total of Hours in C.
Each
employee has multiple entries of hours per account code.Account codes
are
100,101,102.How do list all the employee's who have put in time for
Account
100 only.
The result should look like
Empname AccountCode Hours
ABC 100 20
XYZ 100 56

Thanks in advance


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555934