Re: show duplicate rows in a pivot table using vba

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


I do have a requisition number that is unique for each one. I guess I'm
just not sure how to make the req number the field that the pivot table
is looking at for uniqueness instead of the Job Title.


--
ktpack
------------------------------------------------------------------------
ktpack's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12167
View this thread: http://www.excelforum.com/showthread.php?threadid=387581

.

Relevant Pages

  • Re: show duplicate rows in a pivot table using vba
    ... any thoughts on how to make the requisition number the field that the ... pivot table looks for unique values in? ... ktpack's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12167 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Help needed with Adapting complex INDEX formula
    ... BarCodes'!$B$1:$X$5,SUMPRODUCT(SMALL(ROW('Stock Req 3-8 Digit ... sonar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8424 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Max
    ... which is an array formula, it should be committed with Ctrl-Shift-Enter, not ... Req || Req Date ... Requisition number in Column A so that we can tell what order that New ... completing Requisition A01 since the Required Date was 01/11/06.) ...
    (microsoft.public.excel)
  • Re: Another No Data Question
    ... Count([Req numbers]) will count the number of times there is a value in the Req number field. ... This is more difficult to do and you would need to give us more information on your report. ... Do you sort the report by requisition number or requisition title? ... have created an Access table for our recruiters to capture dates, candidate's name, job reqs, intervied, hired and other pertenent data. ...
    (microsoft.public.access.reports)
  • Max
    ... Req || Req Date ... Requisition number in Column A so that we can tell what order that New ... completing Requisition A01 since the Required Date was 01/11/06.) ... when I change the formula to reference just a particular cell (In this ...
    (microsoft.public.excel)