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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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