separate columns

  1. 0

    I want to have to separate stacked columns listed for each quarter of data - Obi Wan you're my only hope!

    Hello! Below is my data and the accompanying graph. I've looked across forums (including MrExcel), YouTube, and MSFT help pages and I can't seem to figure out how to separate the stacked column 'ANZ' data from the 'APAC' data. I DO NOT WANT TO HAVE ALL THE DATA STACKED IN THE QUARTER!!! My...
  2. H

    Separate the lines based on column header and its value

    Hi Team, Hope anyone can help me, I have column heading fields like New, Old, Exist, Duplicate and each column has its own values and require vba code to get each line separately. For example for product A, if you have value in New and Duplicate amounting $1000 and $2000 respectively then it...
  3. D

    Find One Cell Value Across many Columns

    Hello, I have a question that i am trying my best to ask. I want to be able to find a SINGLE Value across a range of columns. The best way i can explain this is I have a value of "ABC7190612" in a cell. I need to find ABC in the "Product" Column I need to find 7 in the "Year" Column I need...
  4. C

    Pivot Table Separate Year on Year Columns

    Using Excel 2016, I would like to use a pivot table that groups by date into monthly columns (this part is easy), though months from different years should be in different columns (this part I can't figure out). My current pivot table summarises a few thousand financial transactions and groups...
  5. J

    How to quantify Check-in/out data Per hour Per day

    Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...
  6. J

    How to quantify Check-in/out data Per hour Per day

    Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...
  7. B

    Split Details With Same Class Names Excel Macro

    Hi Friends I Want To Split Or Separate The Values In Different Columns In Excel. I Am New To Excel. Don't Know How To Separate Values From Webpage With Same Class Names. div class="result"> <div> <ul class="result__details"> <li> <p class="result__label">Mango</p> <p>Kesar</p> </li> <li> <p...
  8. K

    How do you separate numbers and words of varying lengths into columns in Excel 2003?

    How do I separate the Fund Name, Ticker and Net Flows in this list, which are currently in one column, into three separate columns with Excel 2003? I got it from this site, ETF Fund Flows Tool - IndexUniverse.com, and wanted to reproduce it for a newspaper publication. I couldn't find an...
  9. D

    count values of a condition, based on values of another condition in separate column

    my question: in cell U2, im trying to return a value based on: Where column Q = "R" Count "*RWRK*" in column N end statement

Some videos you may like

This Week's Hot Topics

Top