I want to get a summary of the unique value under a condition. Like in the below table-
1. For article BD-01, the Sorted (A-Z) unique area code is 11, 12, 15.
2. Then for these Unique codes, there are some product codes.
3. Now I want to Join all Area code and their Product codes with separator...
New to VBA coding. I have a dynamic table that is created from a macro based on another worksheet, a query, and equations. I then have a different module with the following:
Sub SortTable(ws As Worksheet, tableName As String)
Dim tbl As ListObject
Set tbl =...
i have a table of 6 column
first 3 tables already have data in it in a certain sort i would like to keep
second 3 table which i will put data in
i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1
I've searched everywhere, watched Youtube videos, and haven't had any luck finding what I need so I figured I would go to the experts of Mr. Excel to help me out! I have a pivot table in tabular format with all item labels repeating. I have 2 different rows and am trying to sort...
I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high)
If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column
If I choose High to low my pivot should get sorted in...
I can't XL2BB as my work won't allow it:
I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...
Hi all, I want to sort a pivot based on the options
Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values)
I have to create 3 options
2. High to low - Lives
3. Low to High - Coverage
If I choose any of the options my data...
I am collecting data for my class each week during PE depending on certain variables. I have put each title ( accuracy, speed, passing) into seperate tables. For example in table 1 the accuracy column shows the accuracy for each student and since student A has the highest accuracy, they...
As part of a macro to prepare client ready files, a tab with various tables of data of varying sizes gets filtered to show empty rows and these rows are then deleted. This is done using the following code:
Range("A2:A" & Range("A" & Rows.Count).End(xlUp).row).AutoFilter Field:=1...
Hi MrExcel expert, I really appreciate your help to solve this issue.
I have been working on this issue for a couple of days now and I feel stuck.
Data set: Hours & Date.
1. I want to sort the data of "date and hours" which have hours assigned to them, and listed beside of my existing...
I'm sorting a large range of data, based on values in column A.
Column A values are a mix of text and digits, so a String.
Example below shows sorting for an example case. There's an issue when there's a different count of digits.
Is there a fix for this, like a setting in Excel.
I've been using PowerQuery to collapse a flat file into combined, multi-value cells with delimiters. The inconsistent nature of the raw data results in repeating delimiters / spaces, like so:
; ; Smith, Judy; Carson, Kevin; ; Levy, Kevin; Bloom, Judy; ; ; ; Nicholas; ; ;
Long-time Excel user and dabbler in VBA and Power Query.
I've got a variation on a problem I posted a few years ago in this thread.
There, folks helped me use PowerQuery to collapse data, combining multiple rows into single, multi-value cells while removing duplicates. The wrinkle...
So i got this excel workbook that contains 2 sheets
in sheet 1
column b - employee id
column c - ranking on each equipment
column d - employee name
column e - date
column f - worked hours for employees
column g - shift (day shift or night shift)
column h - equipment id
in sheet 2
column a -...
I need help sorting the table with VBA code.
There are four rows and three columns of data.
The sort is on Last Name, then First Name
When I use the standard sort procedure, the blank rows are listed as rows 1 and 2.
I appreciate the help.
This is my sheet (unfortunately can't install XL2BB on my work machine):
Sheet is called "outstanding" and is 16 columns wide. I already have VB code in here which moves the row to another sheet based on the status from a drop-down list in column O.
When the workbook is opened (or...
My problem here is that I have a list of countries on the left. Then I have a list of countries on the right. One column to the right of the second column of countries is a column of numbers in the format 0.xxx. What I need is for that column of numbers to end up in the order that the first...
Hello everyone I need you help regarding sorting in an array. Let say that I create an array with command randarray(18,7,3,20) how can I sort the numbers that the smaller with obviously is 3 to be at the top left corner of the array and the biggest (20) be at the right bottom . I want the sort...
Is there a way to make custom sort work correctly on larger files? I created a custom list but both in VBA and in regular excel it does not work correctly on larger files, while it does work perfectly fine on smaller files.
Is this a known issue and is there a way to resolve this?
I have an excel file file about a thousand entries that we number like following (please copy/past this in new sheet)