excelindexingpivot-tableexcel-2013
Ignore some rows when using INDEX function on a PivotTable
In Excel 2013 I am using an INDEX function to populate a column with ticker symbols that appear in a pivot table. I find that when I do this it is also pulling in the categories that each ticker appears under - for example "Consumer Discretionary". I do not want to pull the category in at all. I only want a list of the tickers.
How would I be able to do this? Maybe INDEX is the incorrect Excel function to use.
Solution
I'm guessing you have something as on the left, which can be changed to as in the middle by clicking in the PT, DESIGN > Layout - Report Layout, Show in Tabular Form. The subtotals might then be removed for a result as on the right:
The row labels may be repeated ("filled in") under Field Settings, if desired.
- How to make picture %60 transparency in vba?
- Draw vertical line in scatter plot?
- Special character check mark
- How to change Font Color of Dates without changing color of other text or background using VBA for Excel
- Update cell value based on another cell VBA
- Use Console as debug window in VBA
- Calculate median using vba
- How can I join cells with a vertical line?
- How to change font color for specific line (row) of Textbox
- How do i use Excel Random list generation without duplicate
- excel countif entire row in a table
- Simplifying If Statements Into Loop
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- How to find and replace with regex in excel
- How to format graph to show dates from one or more sheets on the horizontal axis?
- How to embed a SVG into a Cell using Aspose.Cells
- Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
- loop through excel raw data file and input them to other excel formula sheet and perform iteration calculation
- Deleting duplicate header rows
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Overwrite Excel 2016 worksheet data with data from CSV file
- Laravel validator and excel files error
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Ascii Art using VBA
- How to obtain the full-path names of files read with WorkbookConnections
- How can export all part of columns to pdf file with VBA code?
- Difficult to run
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- Export Charts from Excel as images using Python