separate columns

  1. C

    Extract multiple matches which are unique into separate columns

    I have a following table. Name Value X 10 Y 20 Z 30 X 40 Y 50 Z 60 X 10 Y 60 I wish to extract all the unique values corresponding to the name in separate columns. The output shall come out like this. Since X has 10 as a value twice, I want it to be considered only once...
  2. U

    VBA Find Text and Add Blank Column

    Hello Gurus, Hope all is well. Could you possibly help be on how to code this? 1. In Sheet1, I need to highlight in yellow the text containing "Target" in column AZ. 2. Separate the data with "Target" text by adding a blank column 3. Add message box noting how many "Target" text are there...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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

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