Linked Questions

Ask Question
17 questions linked to/from Populate unique values into a VBA array from Excel
Hot Newest Score Active Unanswered
-1 votes
1 answer
2k views

Possible Duplicate: Populate unique values in to VBA array from excel I need to calculate the sum of 2 (A&B) columns value in a 3rd (C) Column. But I don't want to write the =B1+C1 in every ...
Sowmya's user avatar
  • 27k
4 votes
4 answers
830 views

At risk of being of topic, I decided to share some code, Q&A-style. If the general opinion is such that this would be off-topic I'll be happy to delete if need be. Background Can we retrieve all ...
JvdV's user avatar
  • 76.8k
0 votes
2 answers
28k views

I looked but could not find a valid response for this specific circumstance. I need to write a macro that searches a table for a specific Name (Column A), Material (Column B), and Color (Column C) ...
D_Zab's user avatar
  • 735
0 votes
1 answer
4k views

I have a range of cells in Excel that is more than one column wide and more than one row long. Some of the cells are blank. I would like to merge (using VBA) the non-blank cells into a list, remove ...
Alan Turing's user avatar
  • 12.7k
0 votes
2 answers
8k views

I have an unsorted list of names in Sheet1, Column A. Many of these names appear more than once in the list. On Sheet2 Column A I want an alphabetically sorted list of the names with no duplicate ...
Swiftslide's user avatar
  • 1,357
1 vote
4 answers
4k views

I have a large table with lots of data, but what I'm looking at is six columns of that table - the names of people who went on a particular job together. Something like this: +-------+--------+-------...
RolloTreadway's user avatar
  • 33
0 votes
2 answers
1k views

I have data (names) spread out in a sheet in Excel. It is in columns A through M. Some rows have data in every column (A-M), some rows have nothing. I want to extract a list of every unique value (or ...
Dom Vito's user avatar
  • 577
0 votes
1 answer
2k views

I have two columns filled with data in an Excel spreadsheet: Column 1: A B C D Column 2: C D E F G Desired Data: A,B,C,D,E,F,G (not A,B,C,D,C,D,E,F,G) I want to combine the two columns, and remove ...
sooprise's user avatar
  • 23.3k
0 votes
1 answer
2k views

I have following input: I want to write a macro which will group by City first and then with Car number. In the output, I want columns from MIN(start date) to Max(end date) and each row as Unique car ...
Dau_uaD's user avatar
  • 88
0 votes
1 answer
1k views

I am trying to automate the creation of a report. I have a workbook with names in column A. I am trying to program a macro that scans through column A, and for each unique name in column A, i would ...
batt700's user avatar
  • 9
1 vote
2 answers
338 views

I have searched and found a number of similar questions (here and elsewhere) but I can't get my head around how to adapt to my needs. Usually I find pivot like Pivot data using VBA and either I can't ...
dt647146's user avatar
  • 15
0 votes
0 answers
286 views

I really need your help with this as I believe that there is more to this puzzling problem. I am using a basic for loop to grab all of my column values from column A and insert them into my user form ...
Jason Kelly's user avatar
  • 2,665
0 votes
3 answers
144 views

So I have an excel sheet organized by case that are assigned to emails. Each case is assigned to one email and each email is responsible for more than one case. Emails are not in order, they are ...
Maria Fakhry's user avatar
  • 13
-1 votes
1 answer
184 views

I have an Excel sheet where values are in the column A and B. Column A has duplicate values. I need to find the smallest value in column B for a given value in column A, and copy that value into a new ...
jimbo's user avatar
  • 1
0 votes
1 answer
157 views

I'm trying to loop through a spread sheet of non consecutive values and read/compare the value to the rest of the values previously read into the array before incrementing the array dimension and ...
J.Burger's user avatar
  • 1

15 30 50 per page
1
2