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...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top