single column

  1. J

    One Column Confusion!

    Greetings! I have a single column with 1,013,922 rows of values. There are 585,636 unique values in this column. I'm trying to determine how many times each of those 585,636 values occur in this column without entering a variation of the "COUNTIF(A:A,B2)" formula on each line of the 585k...
  2. P

    Copy single column from different sheets and paste it in master sheet side by side

    I have a workbook that has 500+ sheets naming sheet1, sheet 2,sheet3......sheet500...each sheet has multiple columns. I need to copy 'M column' of each sheet and paste it in a master sheet. like from sheet1.. O column in master sheet in A Column, from sheet2 ..O column in master sheet in B...
  3. P

    Copy single column from different sheets and paste it in master sheet side by side

    I have a workbook that has 500+ sheets naming sheet1, sheet 2,sheet3......sheet500...each sheet has multiple columns. I need to copy 'M column' of each sheet and paste it in a master sheet. like from sheet1.. M column in master sheet in A Column, from sheet2 ..M column in master sheet in B...
  4. S

    How to open a delimited text file in a single column

    Hello, I wrote a macro a few years ago in Excel 2010 that opens a series of text files, imports the data, and manipulates it as needed. Our computers are being updated and we are getting Excel 2013. So I'm trying to update the code for my macro in preperation for this. The original line of...
  5. E

    Sumproduct for all numbers in one column and all criteria in second column

    I have a problem where I am trying to determine percentage averages for multiple customers in a given period. For example in the graphic below, "Cust 1" has 10 units at a 10 percent discount, Customer 2 had 20 units at a 5% discount and so on. For the quarter, the average discount is...
  6. B

    One column diagram

    Hi! Have roughly 2200 times (hh:mm) which I need to plot in a diagram, as to how often a certain time appears. Help...
  7. L

    VBA to Extract unique values from multiple columns in to one column

    Hello, I'm a new member and I'm not entirely sure how this forum works and where to post questions. I've been searching on this site as well as online and did manage to find some info, but none of them seem to work or doesn't apply. Issue: I have a workbook with multiple tabs; each tab does...
  8. K

    Sum of Negative and Positive Values in single column

    Hello, I am trying to have excel total all of the negative amount and positive amounts out of a single column by identifying if each cell is above or below zero. I have been trying a few different formulas, but not working out for me. Here is example data: COLUMN -40.00 10.00 12.00 -100.00...
  9. S

    Find and Replace when a File Exists

    I want to have a find and replace macro for a spreadsheet that uses vlookup to get a file for a particular month The vlookup function will have a network path like For every month I need to find and replace the current month (Jun 14) with the next month's spreadsheet (Jul 14) but if it...
  10. E

    Add a line below if a cell is not blank

    I am trying to stack the values of a chart into a single column. So my data looks like this: -------A--------B 1 Value1 Value2 2 Value3 3 Value4 4 Value5 Value6 5 Value7 If cell 1B does not = 0 I want to add a line between line 1 and 2 (I'll call that line "11") and take Value2 and paste it...
  11. N

    Paste Values Selected in a Single-Column MultiSelect Enabled Listbox to Another Worksheet

    I have a single-column multiselect enabled listbox that populates with data from a worksheet called "Testing". I would like to copy all the selected values in the listbox to column AG on another worksheet called "Admin" when the command button "OK" is pressed. Thanks in advance for any help! I...
  12. E

    Array formula - non-blank cell extract from table into a single column list

    First of all, I'm very sorry and thank you in advance for any help - this is probably easy and I can usually work my way through these sorts of things from looking at other excellent examples posted here. Despite searching long and hard and perhaps because I'm now out of time, etc, I'm at...
  13. S

    copy/paste Every Sheet Single ( P Column ) and Paste to Note Pad

    copy/paste Every Sheet Single ( P Column ) and Paste to Note Pad and take P1 As file name for note pad.
  14. E

    How to convert rows of Excel addresses into a single column in Word?

    This is what I have in Excel, rows of addresses: John Doe | 123 Anystreet | Anytown, NY 12345 Mary Doe | 123 Anystreet | Nowhere, NY 22333 This is how I want it to appear in Word, a single column of addresses: John Doe 123 Anystreet Anytown, NY 12345 Mary Doe 123 Anystreet Nowhere, NY...
  15. M

    How to put many columns into one single colulm sorted by the first to last coloum

    Hello im new here and new into VB coding! here is a picture what i want to do Basiclly im looking for a for a fuction that selects the left side (raw data all cells and columns) and order them into a single column. I got a function like this but this is not perfect... The ranged selection...
  16. J

    Single Column --> 2d Grid

    Since it seems to come up every now and then, here's a quick generic routine/idea for reshaping single columns of data: Option Explicit ' -------------------------------------------------------- ' DECLARE APIs ' -------------------------------------------------------- Private Declare Sub...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top