uniqe values in one row

  1. N

    VBA for statement to filter

    I am needing some help figuring out my issue with the part of my VBA sub. I am new to this forum so if I did anything incorrect, please let me know. Sheet1 is a continuous list of everything being recorded and kept. Sheet2 is an updated list that is retrieved, with updated lines and new lines...
  2. S

    Need a formula or Query to list out unique values

    I have a sheet similar to the below data. Can we list out the unique names for each location? as shown in the below "desired output" section? Location Names Location 1 Name 1, Name 2, Name 4 Location 1 Name 1, Name 4 Location 1 Name 2, Name 3, Name 5 Location 1 Name 1 Location 1...
  3. I

    Gather data in a single line

    My problem is that each employee appears in the table for each month and I need to gather the data for each employee in a single line. <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Last Name First Name Location Employment Date Termination Date 1-Mar-2016...
  4. T

    unique values from a column into one row, each item separated with a comma

    Hello, Can anyone help me with this difficult task? I am looking for a formula that would select only unique values that are located in next column. The values in next column can be duplicated. What I need is a copy of each unique value from that column separated by comma in one cell. It can...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top