Re: show duplicate rows in a pivot table using vba

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


any thoughts on how to make the requisition number the field that the
pivot table looks for unique values in? I tried making it the first
field in the table, but it didn't seem to care about that.


--
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: The best elegant solution to override 65k rows limit in a sheet
    ... Put your data in Ms Access then import them on excel by pivot table. ... sgm020's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26226 ... Prev by Date: ...
    (microsoft.public.excel)
  • RE: averaging N rows in column B which have a certain number in column
    ... An alternate approach is to use a Pivot Table which would look like: ... Gary's Student ... > g s's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24263 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Update pivot tables automatically
    ... Does anyone know how to update the pivot table automatically when ... minrufeng's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26208 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Excel Formulas
    ... the spreadsheet - your only part is to place the columns and rows so ... etc. "PIVOT TABLE" is located under DATA on the menu bar. ... wjohnson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29640 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can this be done?
    ... I think a Pivot Table would handle this nicely... ... Phillycheese5 ... Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24196 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)