ids

I have an Excel spreadsheet which I have been automating via VBA macros, but it appears the processing time has increased significantly because one worksheet has 222,465 rows of data. That worksheet will only accumulate more data, so I would like to convert this into an environment that can...

I have a lookup table that looks like the table below. It is truncated and masked to simplify the problem, but the logic will be the same. <tbody> ID CODE REASSIGN(CODE) W12-05 AA ZZ W12-05 BB ZZ W14-01 CC CC W14-03 AA AA W15-01 DD DD W15-01 DD DD </tbody> ID and CODE are...

I am looking to count something specific, using multiple criteria, however I cannot use the COUNTIF function due to the way my workbooks are linked. The goal is to count how many unique PARTY ID's fall within a given date range. I thought I had this working using the below formula, but it's...

I am using the following to calculate the mean per row where the ID's are the same. =IF(A4=A3,"",SUMIF(A:A, A4,E:E )/COUNTIF(A:A, A4)) Column A contains my ID's, Column E contains the paid amounts. This works except for the fact that if there are 2, 3, 4 matching ID's it will not populate the...

Good morning. I need help with the following, thank you. There are 2 columns: ID and rate. Some IDs are repeated, sometimes 3 times, 5 times, 9 times etc. I need to pick the highest rate for each ID and there are over 20,000 IDs. I tried DMAX but didn't seem to work. Thank you for your help...

Hi All, Struggling with an excel problem. I have one list (list 1) with IDs and a corresponding value (letter). Separately, i have a list of IDs (list 2) that I want to put the latest value for (see output columns for what i mean). I want to check first if a 2 -C exists, if not, check if a...

Hello, I have a list of Data with the following headers: Count, Year, ID. What I am trying to do is come up with a formula that will give me the top 25 IDs for each year that have the highest counts. Basically the table I want to fill out looks like what you see below. I need a formula that...

Hi, I'm in a pickle and I can see a way out of it, but just not how to do it, arrghhhhhhhh! We've got a [looong] list of more than 10,000 records which has on it: Col A: old_product ID's Col B: their customers. (one old_product ID can have multiple customers) And we need to work out how to...

Hi All, I desperatly need help with powerbi. I am new to powerbi and I have 1 table with unqiue ids called headcount data and another table called survey data which has multiple ids. I have a relationship 1 to many from the headcount tble to the survey tble. I then have 3 filters:-...

Hello, I have a list of c300 student IDs and 13 tutors. Please could you tell me how to randomly assign an equal (as far as possible) number of student IDs to tutors? Many thanks, Adam

Hello, Can anyone help please? I have table of 7000 records an each of these has ID (not unique) in column Z and a date in column W). There are approximately 250 different IDs, therefore some IDs have multiple rows with different dates. At the end of each row, I would like to display the most...

I have 2 columns of ID's, both of which may contain duplicates or blanks. What I need to do is if an ID in column A has textlonger than 3 characters in the same row in column B then *every occurance* of that Id in column A should be coloured red. I am basically flagging up that if an Id in...

Example: Worksheet2, ColA, is a list of User IDs that are created via a formula that combines data from other cells in the same worksheet. Worksheet2, ColA, is a list of IDs for existing account holders. What I did: I created a vlookup formula to confirm whether or not the new ID that is...

Hello, I am a beginner to VBA and I am in need of some help to create a code. I have a file that contains thousands of ID's that need to be put into a list that shows each ID included in each group. The ID's are broken up in sections based off of similar products. I need to create a list...

Hoping someone can help, I'm pretty sure there must be an easy way to do this! I've got 2 sheets with a crossover in data I need to consolidate: sheet 1 has 2000 contacts, email and order ID's sheet 2 has 5000 contacts (original 2000 contained within the 5k) and email (no order ID's) I want to...

Hi all, I really need some help with this one, I have done some research online but struggling to find anything for what I need. In a sheet called "Data" I have some staff IDs in column H, with assessment results ("Pass","Fail") in column Z. I need to be able to track those staff IDs that have...

Dear All, I written small VB code to check codes are existing in other sheet or not. If code is not exiting in other sheet it should populate "not eligible" instead of "eligible" I have 3 sheets in workbook (sheet1: 5000 ID's along with other columns as a PIM and column A as a PIM1 / sheet3...

Okay, so I have a table with the following sample info. In column A I have an ID. There could be multiple duplicates or there could just be one. These IDs will run from cell A5 to probably no more than A10000. I have another column for a fee that is charged to each ID. If there are...

I really have no idea where to start here. I have two worksheets and I need to match a Crew IDs in one with the Crew IDs in another. Note, there are multiple rows with Crew IDs in both. For example, There are probably 100 crew IDs in both and multiple rows of each Crew ID in both. I want to...

Assume I have a table of data with many different regions that have many groups. How can I create a totals query the sum of the result of a calculation by region? For instance, assume I need to perform this calculation, using group ID's: (25+37+56)-(21+15) I can limit the query to only pull...