1. N

    Formula Help

    I build a simple spreadsheet to keep track of the job numbers I work on through the day. In order to get paid, these job numbers have a corresponding SR number that I am pulling from a table. Some jobs may not have a SR number, so those need to be requested. I made a simple formula that should...
  2. S

    Group By Character Name and list all Scene numbers

    Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...
  3. B

    =unique formula giving duplicates

    Hey all!! I have a unique problem... pardon the pun haha. I have a really simple equation =IFERROR(UNIQUE('Lims Report'!D7:D5000,FALSE,FALSE),"") This formula has always worked for a simple list with no duplicates, and now I have a list using this formula that has given me a duplicate :( Has...
  4. M

    From as per various ranges return a sorted A to Z Unique distinct list.

    Hi, Here is required a formula assistance to make a sorted A to Z unique distinct values in Start from column A:12, as based on data values extracted from column A:3 to D:9. Sample enclosed for your reference. Thanks for the help...
  5. M

    Return a unique numbers of sales list, values as categorized smallest to largest.

    Hi, Required a formula help for generate a unique numbers of sales list as a sequence to be smallest to largest unique numbers without blanks as based on data contains in column A:G. Sample are enclosed, Thanks for help, ABCDEFGHI1Total Sales Units21015101410Return unique numbes...
  6. N

    Vba code to compare columns in different sheets

    HI Friends , I'm looking for a little help in Vba macro. I have two sheets ( category ) which has values like CURRENT ASSETS ,NON CURRENT ASSETS, CURRENT LIABILITIES ,NON CURRENT LIABILITIES , PROFIT LOSS Etc.. in the other sheet (Balance sheet) in column A i have CURRENT ASSETS ,NON...
  7. L

    Duplicate Timestamps & Creation of Unique Reference Number based on Loads

    Good Afternoon, I am having some issues with a dataset that came from an outdated system our business used before I joined, they had recently moved to a new system when I joined and now I can see why! The data below relates to Customer Journeys, which lack a vehicle identifiable field (which...
  8. E

    Create Random Unique Groups of 5, Keep Duplicates in Column

    I have a spreadsheet of thousands of books that need to be broken down into groups of 5 titles. I want to know how many unique groups can be created from this list. The catch is, some titles have 600 copies, while some have only 1. How can Excel create my groups of books? Also, do I have any...
  9. F

    Identify values from same column on multiple sheets

    I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help? Thank you!
  10. D

    Extracting unique values from a column in a table - am I doing this as efficiently as possible?

    https://www.dropbox.com/s/12n3dt7pcchg1zf/unrealized%20cap%20gain%20loss%20finder%20project.xlsx?dl=0 ^ This is an example of the data I'm using. In reality, Sheet1 is ~30,000 Rows deep, and Sheet2 is ~800 Rows deep. What I'm trying to accomplish: Table1 (in Sheet1) is the raw data showing...
  11. M

    Unique formula

    Hi I've been given a set of data where I need to get a list of unique users from data where the usernames are repeated multiple times. A Pivot table will count the number of rows that each data set has, but not the unique number of users. There are 4 criteria that need to be met for a user...
  12. B

    Create unique "id" from codes with different cases

    Hi all I have a large table including Salesforce Id's, which are supposed to be "unique", but unfortunately also use case to make them so. The table uses data that includes a range of Salesforce Id's, from just one, to many rows with the same id. I need a way to convert these id's into truly...
  13. apgmin

    list and count unique Excel 2013

    In column A, I have a list of values from A2-A503, I fill these cells In column B from Column B2 onwards I want to list the unique values from column A ( A2-A503 ) In column C from Column C2 onwards I want the nos. of repetitions of the unique values listed from B2 onwards PLEASE SEE THE...
  14. J

    Extract all delimited values from column into their own cells in new column

    Hi everyone, I have a spreadsheet containing email sender/recipient metadata (email from, to, cc, bcc) that I am attempting to normalize. Column A contains the email IDs, and column B contains the recipients values, delimited by semi-columns. Below is an example: Column A (Email ID) Column B...
  15. L

    How to return the starting balance of a bank account in a master list of bank accounts

    Hi everyone, I've built a workbook that evaluates a client's banking information and processes multiple bank accounts at a given time. I'd like to find a formula that will return the starting balance of each unique bank account from my dataset to reduce human error with data input. The...
  16. M

    Copy and paste only unique rows from one sheet to another after refreshing data.

    Good Afternoon, All. I have a workbook, CallLog, containing the following tabs--"Summary,"Data","MysteryCallLog2," and "Pivot." "Pivot" is merely derived from "Data," and used to visualize data in graphs and slicers on "Summary." "Data" contains the resulting information from a SharePoint...
  17. G

    Populate Access ListBox with Distinct/Unique Values

    I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a...
  18. E

    Return unique values based on multiple conditions and sorted by date

    Hello, I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...
  19. J

    counting, ignoring multiple words and blanks

    I need formulas that will count unique occurrences, certain words while Ignoring blank cells and duplicates. I am trying to achieve the results in cells D8 and D9. In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL...
  20. J

    Formula for Unique Occurence using multiple columns

    I am trying to achieved the desired results on E4. I'm looking for a formula that will count a unique occurrence specific to a date, ignoring duplicates and blanks. In this case, 19NOV19 has 2 trucks. 20NOV19 has 3 trucks. 21NOV19 has 2 trucks.

Watch MrExcel Video

This Week's Hot Topics

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