separate columns

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  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. 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...
  7. 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...
  8. 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

  • 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