raw data

  1. S

    Pivot table. Hide blank and show top 10.

    Whenever I try to do this it ends up deleting one or another filter. It is very not surprising to me as it filters same columns, But it also happens when I try to filter value over say 300, which seem to be different columns. Is there a way to hide blanks and show top 10 or alternatively hide...
  2. S

    Make dynamic advanced filter trigger on formula value update

    So currently I have an advanced filter that triggers on value input. However when I try to make criteria cell formula based it ignores changes. unless I click on cell and hit enter Here is my advanced filter Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target...
  3. G

    Show raw data based on formula within a cell

    In a pivot table you are able to double-click on a cell and it will show you the raw data rows that makes up the given value. I am wanting to show data like this based on a formula I have created. Is this possible. Formula...
  4. R

    Refreshall Twice

    HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...
  5. F

    Pivot table and data issues!!! HELP PLease

    Anyone!!! I have been attempting to create some spreadsheets for fantasy football, to help better determine which players to draft. Anyways I have worked with excel many times before. However, the raw data I have that basically has all players from 2008 -14 listed in the spreadsheet. I have a...
  6. C

    Referencing Data from one sheet to the next (within the same workbook)

    Hello, I have 2 sheets within a workbook, RawData! and View!. I want to be able to paste raw data into the RawData! sheet, and have specific data be references within certain headings on the View! sheet. My attempt to create a visual of what I want to do is below: RawData! sheet: The data...
  7. C

    Macro to get complete raw data from a Pivot Table

    I get excel reports generated from an outside source/software. It comes sliced in a few ways, and there are several worksheets named Inventory Summary, Inventory Summary2, etc. I need a macro so I can run it, and get the raw data from it, ALL OF IT. I know that I can go into the PivotTable...
  8. timstring

    Show raw data for Pivot Table

    I so hate windoze. I have a vba script that takes data from a CSV file and puts it into an Excel pivot table. My problem is that Exsmell for windows hides the data sheet for the table, and the script tries to write to the pivot table instead of the data. How do I open up the data sheet? ty tim
  9. A

    showing Text in Data Field in Pivot Table

    Hi everybody... So i have a raw data dump that I need to put in a spacific reporting fashion. Excel pivot tables seems to almost do the trick. The problem is the information that I need to drop in the "data" field is text (peoples usernames) and when I drop it in I get numbers instead of...
  10. A

    is there a way to add text to the Data Field in a pivot table?

    Hi everybody... So i have a raw data dump that I need to put in a spacific reporting fashion. Excel pivot tables seems to almost do the trick. The problem is the information that I need to drop in the "data" field is text (peoples usernames) and when I drop it in I get numbers instead of...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top