unique value

  1. N

    VBA code that returns a unique list of non consecutive items, for a lookup value from a table

    I need some vba code, that will return a list of unique non consecutive items from a table, when a certain value changes in one of the sheets. I have been trying with this formula, but I have had no luck. =INDEX('Price List'!$A$3:$C$57000, SMALL(IF('Price Sheet'!$B$4='Price List'!$A$3:$A$57000...
  2. D

    Get up to 3 unique values based on two criteria and put in variables in VBA

    Hi guys, I've searched high and low for a solution to my specific problem, but to no avail. Hence this post. I am developing an Excel database of drivers and the trucks they drove. These entries are being made via a userform throughout the month as they use the truck. The basic table as...
  3. L

    create dynamic dropdown based on UNIQUE values from a column within a table

    Hello expert Excel users! Below i will describe what is the purpose of my first forum post, so bear with me. So i have multiple tabs defined as tables in a big excel file. Each table has one or more columns but then, some of the tables do have common fields among them. What i want to do is...
  4. I

    Multiple Criteria: IF 2x 2-Column Matches then show corresponding value in parallel row (two sheets)

    Hi there, I'm wanting to create a formula that retrieves a unique cell value if multiple criteria are met. E.g. If 'Interface'!H8 matches item in 'ReferenceList'!ColumnT3:T245 & 'Interface'!I8 matches item in 'ReferenceList'ColumnU3:U245 then show corresponding value in...
  5. D

    Search data sheet for updated values, if value doesn't exist in other sheets then copy data range to specific sheet

    Help needed by anyone who can grant me some assistance. Here is what I am trying to accomplish with VBA. I have a workbook that contains 4 sheets - summary - rollup of campaign information from billing and impressions billing - campaign billing information impressions - campaign impression...
  6. M

    Unique Value Nightmare!

    Hi All! I am having trouble with formulas. One formula i have wont work, and I need a creative formula. Columns A and B: I have a long list of values, some will be repeated up to three times, some wont be repeated at all. The number of values in the list will vary every tie I use the...
  7. V

    Split workbook with multiple worksheets by first column entries, into multiple workbooks with same sheets (per entry)

    Good evening to all, It is very nice to meet you! I would like your help for a vba code to do the following: I have a workbook containing sheets A, B, C. All sheets have the column "Name" as their first column (there might be multiple lines with the same name). I would like to split the files...
  8. C

    Returning Unique Value Combined with an IF or Match statement

    Hello, I am looking for help with a formula to return a unique value once Excel has found a match. I will try and explain as best as I can. I have a column (Column A) in a master worksheet (Worksheet A) that compares two columns from two separate worksheets (Worksheet B and Worksheet C)...
  9. B

    Filter for unique values

    I Have a names in excel a1 to a13, i want to Filter for unique values, after getting the unique values, i change the Name to correct format, when ever i change the 1st unique value, how to automatically change the duplicate Values. Corret Name : Balu, Raju, When Ever i Change a1 Ballu to...
  10. K

    Index match and unique values

    Hi everyone. I've been racking my brain with this one for a while now and am hoping someone can help me to understand what change I need to make to return unique values. I have a workbook with two worksheets. One worksheet contains a list of every employee in my local organization, and in the...
  11. P

    Macro to Highlight First Row of Each Unique Value in Column

    Hello Experts, I need help with a macro that cycles through one column ("Week-Ending Date") of a formatted table that users are updating each week to find unique values (e.g. "6/25/2016 or "7/9/2016") in that column and then highlighting the first row with that unique value up and through...
  12. P

    Unique UPCs/EAN/Barcodes from across multiple spreadsheets without Macro

    Hi All, could really use some help here. I have an excel workbook where I keep inventory of different stores, and a TOTALS spreadsheet as the first spreadsheet tab.. (Spreadsheet tabs such as Totals, Store1, Store2, Store3, Store4 etc). All spreadsheets have UPCs/EANs/Barcodes in Column A. I...
  13. G

    If all values "x" in column A equal the same value in column B, write "y" in column C

    I am looking to write a formula that doesn't require the use of pivot tables (not opposed to VBA) that can answer this question. If all the same values "x" in column A equal the same respective value in column B, write "y" in column C, if not, write "z". To illustrate, take this picture for...
  14. I

    Formula to find the column and row of a unique value within a table?

    Hi, Say I have a 3x3 grid containing numbers 1-9, populated in rows from left to right. I need two formulae that will tell me the column and the row of any number, eg. "8" = column 2, row 3. <tbody> 1 2 3 4 5 6 7 8 9 </tbody> Thanks in advance for any help you can offer. Much...
  15. M

    Match function without a look up value

    Hi there, I am trying to understand the formula here. The function of the formula is to look up unique values from a column. The match function here has no look up value. Could anyone explain it a little to me? Does there have sth to do with the fact that it is an array formula...
  16. S

    Count unique values meeting certain criteria

    Hi, I have the below two columns. I want to count the unique names that come up as Priority 3. I tried =SUMPRODUCT((B2:B5<>"")*(A2:A5="Priority 3")/COUNTIF(B2:B5,B2:B5)). However, it's giving me an incorrect number. Can someone help, please <TBODY> Priority Name Priority 1 Sam Priority 1...
  17. S

    Data Validation, allow UNIQUE values only

    I want a column to allow unique values only. Source data is from third parties and is an identifier. List is long and prefer to use Form for data entry but don't wish to have to do search to avoid duplicates before entering or use find duplicates after (both band-aids.) I should be able to use...
  18. J

    Output the nth smallest UNIQUE number with one condition

    Hello, I have a table such as this: <tbody> Apples 25 Orange 16 Apples 25 Apples 26 Apples 26 Apples 27 Oranges 18 Apples 28 </tbody> How do I output the nth smallest unique value if column A is "Apples"? The array formula I have to output the 3rd smallest NONunique value is...
  19. J

    Highlighting Rows from Unique Value Conditional Format

    I need help finding a way to highlight rows while doing a conditional format for the unique values of a column. For example if column had the values 1 1 2 3 3 I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that...
  20. P

    Unique Values from a single cell

    Hi, I have a single cell comprising A|B|C| A. How do i get the unique values? Also please let me know if there is a chance to count the variables. Thanks. I badly need a excel function to sort this out.

Some videos you may like

This Week's Hot Topics