unique value

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

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

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

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

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

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

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

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

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

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.

Hi I have the following macro (as part of a much bigger set of code that adds some formulas to to cells to return the total number of unique values. The problem is, this part of the macro takes over 10 minutes to run. Is there a quicker way of doing this or am I going to have to just wait it...

I'm dumping a large volume of data each month into Excel. I need to summarize the data by Budget type and Category and possibly a third variable such as year. In the image below the result I hope for is a formula will calculate the sum of the unique values in column D when BudgetType is equal...

I am trying to use the below code to fill a combobox with unique values. It works great except I can't figure out a way to replace BLOCK 1 with BLOCK 2. I want to use BLOCK 2 to populate mgNames so that only specific values are filled into mgNames. Currently BLOCK 1 just fills mgNames with an...

Hello, I'm trying to make a drop down list that shows only items in column A that have > 0 value in column B. For example, my column A has items A, B, C, D, E, F with values in column B as 0, 22, 20, 50, 0, and 50. I want to have a drop down list (Data Validation list) that would only show B, C...

I basically have a spreadsheet, where the first 4 columns contain unique values (such as different species of trees and soil types) (and only one values in each cell.) The following columns should list how many times each type of value occur, for example - there is a column that should count the...

I am fairly adept at excel formulas and have dabbeld in VBA but I am stumped. I have search this forum for days and can't find an answer to this: I need to be able to fill a column with a list of unique random 2-digit letters (AA, AB, AC, AD, AE, etc.). And I need the amount of letters to be...

In Office 2007/2008, I was able to use the following formula to create a list for data validation: =INDEX(B2:B79,MATCH(TRUE,B2:B79<>B2,0)-1):INDEX(B2:B79,MATCH(TRUE,B2:B79<>B2,0)) My B column contains 2 unique values, so this chose 2 next to each other that had different values. In Excel 2010...

Hi, all I have a list of Job Titles in column A of a spreadsheet, and a corresponding set of Occupational Levels in column B. e.g. A: B: Director Top Management HR Manager Senior Management Director Senior Management Director Senior Management Director Top...

Hello all, I am having problems trying to figure out how to do a loop in excel that copys rows to another sheet if the is a blank cell in the row. The problem I am having is some rows have more than one blank cell so it is creating duplicates, column A has unique values but having issues...