raw data

  1. R

    Find matching string and get string of data in offset cell from raw dataset

    Attached is a screen cap of the imported dataset. Please note how the data is grouped with multiple labels and values in a single cell. I need to find the match JSN code which is located in a single cell along with miscellaneous data. The "JSN" text has (4) spaces after followed by the (5)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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...
  11. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top