unique

  1. R

    Unique Transpose Formula though results skip 3 cells

    Hi, I am using the below formula though I need the results to skip 3 cells each time, therefore the results to appear in cells A1, D1, G1, J1 etc. =UNIQUE(TRANSPOSE(Data!I4:I13)) Can someone help please?
  2. Z

    Drop down list using unique but with changed number of rows

    Hi, I was able to create a a data validation list by using UNIQUE, however, my rows may change whenever I update the template. Can anyone advise how can I change my current formula to consider the rows changes...
  3. T

    Sum-Unique - filter

    I am trying to do the following on a summary tab: 1. Perform a summary calculation of common part numbers 2. Display the total qty as a unique row displaying the total qty of the duplicate part numbers into col "A" on the "SUMMARY" TAB 2A. If all the rows of duplicate PN qty are 0 then omit...
  4. D

    Split and search for values in cell

    Good Morning I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -". Keep only unique values Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...
  5. SanjayGMusafir

    Filtering a list further

    Hi Experts This is the power of Excel - That you start to believe can I go 1 level further. Recently I had a thread - https://www.mrexcel.com/board/threads/filter-unique-values-out-of-a-multi-column-list.1251328/post-6140661 where @Eric W @ISY @Fluff gave me the solution. Due to my system...
  6. SanjayGMusafir

    Filter Unique Values out of a Multi-Column List

    Hi Experts, I wanted to get a one column list out a range. So far have been able to extract a multicolumn list. But I want it to be one column list so that it could be filtered further for unique values. Got kind of stuck somewhere. Please help Thanks in advance Underneath is the formula I...
  7. mohsinbipu

    Get summary results (Textjoin, Unique value) of a table

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

    Required a correct the single cell formula for join a values

    Hi, required a formula help to return a correct results, the below stated formula returns a N/A error could you please rectify it...
  9. F

    Random and unique number between 12345678 to 87654321

    hello i want to create list of random and unique numbers of 8 digits between 12345678 and 87654321 but any digit should not be repeat for example 12345678 ok 21345678 ok 32145678 ok 12245678 not ok. due to repeate of 2 87654321 ok 87754321 not ok due to repeat of 7 pls help
  10. C

    Issues using FILTER formula

    I am trying to use the FILTER formula to return only the results that meet a criteria listed on column B. On column A, I am using the UNIQUE function to bring unique values from a different table. Column B has 1/0 values related to the data on column A. In column C, I would like to have only the...
  11. M

    Unique or Sumproduct or something else?

    So I have a lot of data and someone has changed how it is imported! I needed to find how many different orders were taken by a salesperson in the month so ran this COUNTIFS(Dels!$O:$O,"BOB",Dels!$C:$C,">=01/08/2023",Dels!$C:$C,"<=31/08/2023",Dels!$H:$H,">0.00") which ran perfectly as all...
  12. T

    Formula to Extract Highest Unique from 2 Columns

    Hi, I'm looking for a fomula to help me extract the highest unqiue value in a 2 column list. I need a unique value from column B but it has to be the highest relevant value in column A. Example below of the desired result. Columns A & B to become C & D. Thanks as always for any help and...
  13. J

    Formula gets count of unique values not <> to a status - return those values...

    Formula gets count of unique values not <> to a status - return those values in a list to see what the text is for the not in X status.
  14. Chris_010101

    Filter Data?

    Hello, I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday. We...
  15. M

    #Value! Issue

    Hello everyone! I had this issue in excel on my laptop only and not on PC. I have created a table which is the Master of my workbook. I have used sumproduct, filters, unique function and it was all worked nicely on my PC. But for a sudden when i have move this sheet to my laptop all of the data...
  16. G

    Is there a way to use VBA code to identify unique rows in my data?

    Hello! I'm looking to see if there's a way to use VBA code to identify unique rows in my sheet. I have code that identifies unique in a column but cant seem to make it work for an entire row. My Data has 9 columns, and two of them are the main ones that will show me that the row is unique...
  17. E

    Count filtered unique values where sum of values in another column meets criteria

    Hello, hope you can help. I would like to use a formula to give the count of complete projects in [time range] where there is a total of <=1 hour spent on 'review' over the whole project - example sheet below. In this sample the desired answer is 2 as only project A and B meet the criteria...
  18. D

    Textjoin Calc error help

    Hi, I seem to be having error when using Textjoin. The worst part is that it was working fine, but file didn't saved and when I tried to replicate the formula, I keep getting now error Calc and cant see where is the issue. I have few tables, consisting of 2 columns each. 1 column has list...
  19. D

    Join multiple rows values in same cell, based on 2 conditions.

    Hi, I am trying to find the way to obtain a list of values in same cell, based on 2 conditions. I seem to be struggling with the right way based on below formula: =TEXTJOIN(", ",TRUE,UNIQUE(FILTER(ColumnB,(ColumnA=A2)*(ColumnC="Yes"),""))) for some reason i obtain only 1 result instead of...
  20. R

    XUNIQUE

    XUNIQUE is a powerful and straightforward alternative to the built-in UNIQUE with full control over data type(s) inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all the modules below, after the description; and download...

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