single column

  1. S

    How to get Exact Matches in a Column

    I need a column like this "Exact Match" column where only the duplicate values where the match is exact (Case sensitive) shows True. Please help. Name Exact Match Coca Cola Bottlers Japan Inc FALSE Coca Cola East Japan Co TRUE Coca-Cola Bottlers Japan Inc FALSE Coca Cola East Japan...
  2. 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...
  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.. O column in master sheet in A Column, from sheet2 ..O column in master sheet in B...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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.
  15. 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...
  16. 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...
  17. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top