concatenate column values

I want top 3 Unique students ranking filtered from records below along with their details and all the other roll numbers excluding the ones that are once already mentioned once in the left Only that appeared on top 3 in the last column (with Comma separation) D1125A8:I20,J11:N20Cellcontains a...

Dear all, I would like to know if there is a way to use functions on concatenated arrays? I have 2 ranges of cells in the Name Manager as follows: Array 1 =Sheet1!$A$1:$A$5,Sheet1!$A$7:$A$10,Sheet1!$A$12:$A$16 Array 2 =Sheet1!$B$1:$B$5,Sheet1!$B$7:$B$10,Sheet1!$B$12:$B$16 When I try to...

Hi , I need to concatenate Row C value with its last cell value one another one in a below format and paste the output in Row D. Multiple files I have, so the number of rows will increase for each workbook. For Eg: C D 001 0001 OF 0005 002 0002 OF 0005 003...

G'Day Excel gurus, please help. I'm hoping to be able to concatenate the data in column 'A' and 'C' into column 'A' on the same row in a new worksheet using vba. It also needs to work it's way down the column and ignore any blank cells until a certain value ('END') in a cell is reached. It...

Hello all, I searched around on the forum for an answer for this, and I found some solutions that were close. I was not successful at adapting them to my needs (and I feel like this should be easy!). I have a spreadsheet with testing data (quality control tolerances), so there is a column...

Hello I wonder that someone can help me? I have a folder with several photos (jpg and png) whose names are numbers and letters eg 12345.jpg 12345a.jpg 12345b.jpg 12345c.png 9876.png 9876a.png 9876b.jpg etc. and I was wondering how to make an application in vba to list all the photos names in...

Hi - can someone help me write VBA to concatenate columns "A". "F" and "I" and put the results in column "E" until it runs out and briefly explain how the code is structured. ex. Column A | Column E | Column F | Column I | 123 123x873 x...

Hi Gurus, I'm new to this community/forum and I am hoping you can help me with the most easiest and efficient way (Formula or VB code) to get an excel spreadsheet to Concatenate data from mutiple cells only if those individual contain certain values as shown in the example table below. Example...

I would like to concatenate parts of one range based on the values of one or more relate ranges. I'm using Office 2010 and windows 8. Specifically, I would like to create two lists of awards, one of awards earned by, and one of awards earned but not yet given to, my scouts. My table has a...