Pull Found Records From Table Based On Single Column
I have the following data :-
SHEET 1
COL A_______COL B________COL C
V1990_______J100_________U1212
H2323_______Y999
U2222
SHEET 2
COL A_______COL B________COL C
U2222
I0000_______U8900________T67888
H2323
I need to search data from range defined A1.C3 and if any data in that range found in the sheet 2 that having the same records.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Extract Records Based On Single Condition
I am working on a data mining project and need to extract records based on a single condition. In the attached workbook you will see 5 columns – 4 Inputs and 1 Output. I need to automatically copy and paste on a separate sheet those records in which the Output value is greater than 970. A Record includes the values of all 4 inputs and the corresponding output value. I did this by hand for this subset of data but the actual number of record is extremely large so I need a macro which will do this for me automatically.
View Replies!
View Related
Fill League Table Based On Value Found Or Not
I am trying to update a league table from a different sheet. The table is not fixed on how many people with be in it as this can grow. This what I have in mind to do what I need but can work out how to implement it. I need to loop though column "A" in sheet "U8" range A2:A? The value in column "A" is unique so from "A2" I then take the value in "K2" for this unique id. I now need to search column "A" in sheet "U8 League Table" for the unique ID place the value of "U8 - K2" into column "D" (Round2) row will be different in most cases to round1. If the unique ID is not found in "U8 League Table" then add it. The U8 sheet is populated a fresh per event (fortnightly) and the data fed (riders score will always be in column K, different row) into the League Table. However. as the rounds mount the data will need to go into next column along in the Table i.e Rd1 in C, Rd2 in D, Rd3 in E etc.
View Replies!
View Related
Find Records Based On More Than One Column
I have a very large table that has a one to multiple relationship in a GIS. GIS doesnt support that type of relation ship. I need to find records that are related to the single key but have different values than the first record for that key. eg Col 1 col 2 Col 3(key) ab ab 1 bc bc 1 In this example, only the first row (ab) will be regarded in the GIS. so I need to pull out the second row and put it into another dbf based on the three columns so that I can then put it into the GIS so that the second row is considered and not ignored.
View Replies!
View Related
User Box Options If Cell Entry Is A Duplicate Found In A Table Column
I have a table that i use for a customer database. and the end user adds new customers to this table, what i would like is for a message box to pop up whenever cell B2 matches an entry in a column in the customers table. the table starts on row 25, and the column i would like to check for duplicates is column B. I would like the message box to give the user the message "A customer by this name already exists, Would you like to load this customers file?" If the answer is yes, then the row that the match was found on would be copied and pasted onto row 1. if the answer is no, then nothing else happens. I hope this makes sense, i am posting this sheet of my workbook for reference.
View Replies!
View Related
Extract Unique Records Based On 1 Column
I have a single excel data sheet with 10 rows of header information and then multiple rows and columns of data I need to extract the 10 rows of header data plus the rows for each unique record in Col A into its own separate worksheet, with the work sheet name being the unique record from Col A To further add to the challenge, the data in col A may have "/" in so will not comply with excel sheet naming convention so would like an error message to remind me to manually change a sheet name. I attach an dummy data sheet just to show what I mean!
View Replies!
View Related
Create Summary And Pull Up Records
I have three worksheets called North, East and South. Data is held in each of these sheets starting in D1:BZ144 and the data is in columns of three. Example columns D:E is one set of records, F:H is another and so on. The first cell of each set of columns is the company name. I need to copy all of these records into a Summary works sheet so that the records are in held in columns B:D and that the first cell is shown shown in column 'A'. Secondly, in a second sheet I'm trying to setup a lookup so that I can call the company name and the records from the sheets North, East and South are shown that relate. I've tried using HLOOKUP but as the company name only appears in the first column I cannot get columns rwo and three to show.
View Replies!
View Related
Selectively Pull Records Into Master Sheet
I've got a master excel sheet with about 6000 rows of unique variables. In separate source files, I have many rows of these variables with information next to each. Each file has a random number of these variables, some a couple of hundred, some a thousand or two. What I'm looking to do is to have the master sheet with all 6000 rows and have all of the information next to each variable, with new columns for each new bit of information. I could sit there for hours copying and pasting each new bit of information to the relevant variable in the master sheet, but I'm convinced there's a quicker way. Is there, for example, a way to filter the master sheet based on the variables contained in one of the source files and therefore (once a-z sorted) copy all the information from a source file and simply paste it into the master file? Then once the filter is lifted the same can be done for the next file (there's only about 20 source files so that's manageable).
View Replies!
View Related
Combine Multiple Records Onto 1 Row Based On Unique Number In Column
I searched and searched and I can't find an easy way to do this without using Access which I am rubbish at. Is there an easy way to do the following in Excel. I have several thousand records by row each with a unique numerical identifier. The unique identifier is the "Household". Within the household there are sub "Accounts". The sub accounts are truely unique. All the "Accounts" are in the same column. What I am trying to do is combine the records into one row per "Household" with the accounts listed in successive columns. The maximum number of accounts there may be is 7 but it can be as few as 1. Example: BEFORE HH Acct 1 1234 1 2345 1 3456 1 4567 2 9876 2 8765 3 1113 4 5556 4 4447 4 3335 AFTER HH Acct1 Acct2 Acct3 Acct4 Acct5 Acct6 Acct7 1 1234 2345 3456 4567 2 9876 8765 8765 3 1113 4 5556 4447 3335
View Replies!
View Related
Pull A Reference Number And Assign It To All Records In A Particular Section
I need to pull a reference number and assign it to all records in a particular section. The code I recorded keeps going back to the first section. Also would like it to repeat until all records have the reference number attached. 06010-100Beginning Balance07/09/2004AD06011-10007/23/2004AD06011-10008/06/2004AD06011-100 06011-100Beginning Balance07/09/2004AD07/23/2004AD08/06/2004AD Sub Macro1() ' ' Macro1 Macro ' Macro recorded 10/14/2008 by acantu ' ' Selection.Copy Selection.End(xlDown).Select Selection.End(xlDown).Select Range("C7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("B7").Select Selection.End(xlDown).Select Range("C63").Select Range(Selection, Selection.End(xlUp)).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Selection.End(xlToLeft).Select Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlDown).Select End Sub
View Replies!
View Related
Search Column Bottom Up Then Delete Rows Based On Value Found
I've attached a dummy worksheet that shows constant values of 1.00 in columns D and E. In the actual workbook, user action will sometimes cause these values to change to something other that 1.00. The user may wish to delete the action that caused the change. I need a macro that will search from the last cell in column D upward to the first instance of a cell that is not equal to 1.00 and select that cell and those immediately above with the same value as the first found cell. For example, in the attached worksheet the search would start in the last cell of Columd D and search upward. It would find cell D23 and upward to D19. These entire rows would be deleted.
View Replies!
View Related
Pull Found Data From Multiple Workbook
I am trying to Loop Through a Folder Of Excel Workbooks and get required Info from one of the workbooks, back to my Master File. I thought of "VLOOKUP" but I am not shore if it will work over Approx. 60 workbooks? if there is an other or better approach, I am open to all Ideas. So far I have code to Open my Master and declare the criteria for the VLOOKUP with the help from: Re: Run A Macro On All Files In A Directory -------------------------------------------------------------------------------- See also this page on how to loop through a folder Loop Through Folder Of Excel Workbooks _________________ I am now able to open all Files in the sub directory, now I need to know how to approach my problem of looking for and getting the Info back to my Master File with approx. 5000 entrys to look for?
View Replies!
View Related
Merge Duplicate Records In Single Record
Through a query I extract data from an oracle database. This database creates a record for every unique Article_Batch_Pallet_Faultnumber combination. Through a filter macro I create a new format on a different worksheet which creates a record for every uniqe Article_Batch_Pallet combination. I need a searchfunction to get the faultnumbers in the same row.
View Replies!
View Related
Copy Rows Based On Criteria In Single Column
I have on sheet1 of my workbook a number of rows of data, from column A through Column G. The Data in column G either contains the text "Yes", or "No". I need a macro that will look through each row in this sheet, and upon finding a "Yes" in the cell in the column G, will copy that entire row (columns A through G) into a new row in sheet2. Sheet2 currently contains data, so I'd like to move everything down by one row and paste this data at the top (row 6 is the first line of data on this sheet). I'd then like to go back to sheet 1, and delete the row I've just copied. Then continue though the loop. The loop needs to stop when a blank row is discovered.
View Replies!
View Related
Combining And Rearranging Data Records From Multiple Worksheets To A Single Worksheet
I have a set of related variables that are split over multiple worksheets, and I need to be able to take specific information, duplicate certain values and produce an output sheet for use in a separate piece of software. The variables are: Position Number (Sheet 1) Position Title (Sheets 1 and 2) Position Requirement (Sheet 2) Requirement Importance (Sheet 2) The output sheet requires a list of all the requirements for each position number, which means the position number itself needs duplicating (in new rows) X number of times, where X is the number of requirements assigned. The appropriate requirements are then to be pasted in next to each position number (and the requirements can be found by comparing position number to title, and from title to requirements). Normally, I’d be able to do this using lookups and so forth, but my problem arises when I have multiple position numbers with the same related title (in the attached example, there are three plumbers with unique position numbers). I can’t figure out how to say to Excel “a plumber has five requirements, and there are three plumbers, so duplicate each position number for each plumber five times, then insert the appropriate qualifications (and their associated importance values) next to the position numbers”.
View Replies!
View Related
Return Range Of Numerical Values In Single Column Based On Frequency Percentage
I have a single column of numerical values that may repeat many times within the column. I require a flexible Formula: Use an Input Cell for the specified and changeable Percentage(s) %. Column may be filtered – so only take into account Visible Filtered Cells. The Formula will calculate and Return the numerical range of values that fall between the specified percentage % (using the Input Cell) e.g.; 70%. The Formula should Return two numeric values: a Start Value and an End Value – NOT necessarily the minimum and maximum per se BUT the MIN and MAX of the values that appear 70% of the time in the column; therefore, taking into account Repeat / Duplicate values. The calculated Results: the two numeric values will be returned to separate cells on a new Sheet.
View Replies!
View Related
Pull Data From Different Columns Based On Info In Column "A".
I'm having a little trouble figuring out what formula to use for situation. I have 5 columns of information. Column A = School # of current school Column B = School 1 Name Column C = School 2 Name Column D = School 3 Name Column E = School 4 Name What I want to do is in Column F to look through a row of information and find the current school. So: If A="1", pull from B If A="2", pull from C If A="3", pull from D If A="4", pull from E I tried doing a VLOOKUP table, but I think I'd have to do one for every row, but I could be wrong. I also thought of INDEX(MATCH), but I couldn't quite figure it out.
View Replies!
View Related
Locate Data Based On Found Data In Another Column
I have this nice formula (listed below) that I'm trying to use to get the employee names that belong to each manager. How ever using the first formula I only get the first name in each cell and using the second formula (associates is a define name for the range A1:A70) gives me name that do not belong the that manager.... I would like this formula to only pull names from the manager that is listed in the C column....
View Replies!
View Related
Find Value In Table Based On Value In Row & Column
I have a table where the columns are named: A, B, C, D and E and the lines are named: 1,2,3,4 and 5. All the cells of this table are filled with values. I want the function to return the value on the correspondent cell everytime I type a combination of column and line. For instance if I type "B2" the function would return the value on this position... Actually I am looking for something like a combination of the functions "hlookup" and "vlookup"...
View Replies!
View Related
Archiving Records To A Separate Table Then Edit.
I'm having an issue and I've tried thinking of all the work arounds and haven't come up with a usable method. I built a form that pulls info from a Pipeline table. I wanted to keep track of all the people that make edits on a separate table. Is there a way to take the original info and paste it on to another table by way of a click() and allow the others to make edits on the fly afterwards? This has been bugging me all week.
View Replies!
View Related
Extract Certain Records Based From List Based On Date
In sheet1 I have the following 1. Names (Column A) 2. Date (Column B) My current list if from A2:B300 I am trying to have a piece of code go through all the records in this list, if any of the dates are within the next 2 weeks (from now()) then copy this record (name, date) and put in sheet2. And loop through all 300 records or possibly additional records.
View Replies!
View Related
Pull Out Specific Data From Table
I don't know where to begin or if this is even possible. I have report that I need to format. See example file. Note: real file has 2000 rows. The book date and book amount in the orginal is the POS date and POS amount in the format sheet. I don't need the "over/short" data from the original. Col. A contains store #'s and they are 2,3,or 4 numbers long preceeded by an "S-". In the formatted sheet I need the "S-" removed. The data is grouped by column C. 3 of the same equals 1. Groups vary.
View Replies!
View Related
Fill Table Based On An Drop-Down Choice In 1st Column
I'm working on making a spreadsheet that allows me to select an item type from a dropdown list (through validation) and then would copy in a range of values from another worksheet based on my dropdown selection. The set-up: I am primarily concerned with two sheets in my workbook, BiS and Weights. I have a database of items and their associated values listed in Weights. I have already managed to get dropdown lists of my specific item types using named lists and have put that in the BiS worksheet. What I would like to do is have the values in the Weights worksheet copied over in the same order and number of cells based on what item I select from the dropdown list.
View Replies!
View Related
Extracting Date Related Records In Pivot Table
I have a master list that is updated in real time by linked worksheets from several people. While my actual report covers 7 managers and 7 different products (“contract types” in this example), I have summarized and simplified the input in the attached file. There are three pertinent dates – the date assigned to the manager (col A), the date completed by the manager (col F), and the date approved by the executive (Col G). These dates will span month ends and I need to be able to provide monthly reports that provide details on the number of contracts and the dollar value all contracts assigned and completed by the manager during the month (say, February) as well as any contracts assigned in any month which remain uncompleted at the current month-end (e.g. the $7,500 Smith contract assigned on Feb 21st that remains uncompleted and the Feb 26th $200 Jones contract which was uncompleted at Feb 28th, but completed in early March, in this example). Can this be done directly in a Pivot table from the full master list, or will I need to have separate sheets in my workbook where I extract the pertinent records for that month?
View Replies!
View Related
Display Title For A Match Found In A Table
I have at the top of a table the titles and then 3 rows under it. the titles are text..whereas the rows filled with number. What i want in a cell is to display the text(of the title) of a corresponding value in the same column!..[simply 'look for a specific number in a table,and display the title of that column).. i input all info but returns #value error!does it not work with text?
View Replies!
View Related
Place / Pull Html Table Into Worksheet
I need to copy/cut and paste an Html table from a website into and Excel sheet without the data being transposed. See link for the table I need to get into Excel: http://www.voedingswaardetabel.nl/voedingswaarde/?vw=vv Then cut and paste it to Excel, you see the data is now vertical. I need the table horizontal as it appears on the website.
View Replies!
View Related
Copy Data Table Seperate Sheets Based On Column Criteria
I need to copy all the work sheets into one single work sheet (mastersheet). The source work sheets are having same column structure. The condition which i need to take care of is that after column 3 if at all there is any data till column 10 then in the destination mastersheet these should be copied in different rows with first two columns repeated. I need to do this using VBA macro.
View Replies!
View Related
Return Heading Ascociated With Date Found In Table
Attached is a very small sample of a workbook that looks at community impact; before, during and after a project. The source data (not shown) is down loaded from a system that can only supply the date in reverse order (see column A). i.e. 20080229 = 29-Feb-2008. I've applied a conversion in column "C".... = DATE(LEFT($A2,4),MID($A2,5,2),RIGHT($A2,2)) The 'properly' formatted date is then used to determine when on the scale of observation that given date falls. e.g. the number of weeks before, during and after the project. This is determined by the 18 week date 'matrix/ array' in columns F to X the red box is used to input the project start date, (& assumes the project runs to its normal 6 week time scale, it get REALLY messy if the boss prolongs or cuts short the project!) From the result various figures and a graph using the properly formatted date are calculated, produced and presented showing.... The scale of the problem {before} The impact of the project {during} The lasting efftectivness {after} You can see that I've managed a 'workaround' for the limit on the number of IF statements allowed in one formula using a rolling formula in columns; B then Z - AQ. This works OK, but!! combine that with the other formulae doing the impact calculations and 20000+ rows of data (with the acssociated workings in B + Z-AQ) the effect is to make make the file over 15Mb for 1!! worksheet, (the limit for emailing on the jobs system is 3Mb!!) & just to really make it scary sometime there are 2 projects on the go at once. Before I created the attached the user responsible for these graphs and calculations manually counted dates & typed/copied & pasted the week number/tile, initially several days work followed by half a day every weekly update!
View Replies!
View Related
Search Table & Return Heading Of Found Value
In a large spreadsheet that receives external data, I have codes (U, N or V) allocated at various times to different rows as shown in sample worksheet attached. Elsewhere in the spreadsheet, I need to display (for later export) these codes along with their respective number in a sorted list. Please review the attached: In the spreadsheet you'll see a column of codes, the next column is the data reference number, then to the right is three columns, one for each code. As displayed in the sample book attached, each Code column is to display the data reference number (from column 2)that matches that column's code. What formula can I use to list these numbers in the appropriate columns?
View Replies!
View Related
Lookup: Pull Any Color Choices Associated With A Year From The Data Table On The First Worksheet
I have a data table that contains begin dates, end dates, and colors. The data is input starting with the earliest begin date. On a second worksheet, I have a listing of the years starting with the year of the first begin date and ending with the end of this year. I need to be able to pull any color choices associated with a year from the data table on the first worksheet. Some years may not be specifically listed in the data sheet as the person could have had the same color choice for several years. Sometimes a person could have more than one color choice in a year. I am at a loss for how to get to the data I need. I created an example spreadsheet to demonstrate the data I am working with, and an example of what I need my results to look like in the end.
View Replies!
View Related
Filter Records Based On The Value Of A Cell
I have an excel file that gets records from access database. I have a field named "Class" in column C which starts at row 4. I want to filter the records in such a way that only those records with Class equal to whatever value I put in cell B2 will be shown. For example: A B C REPORT Filter Class: _______ ProjID Name Class 001 Project A 4 002 Project B 4 003 Project C 4 004 Project D 8............
View Replies!
View Related
Table Of Calculations Down To A Single Array Formula
I'm trying to condense a table of calculations down to a single array formula, but am getting stuck on one piece of it. The table data is very simple, and can be in just two columns: 1, value 2, value 3, value 4, value 5, value Where 1 thru 5 are time periods, and values are various numbers. I want to perform the GammaDist function on each value. It requires a time period input, and in this case it is the 1 thru 5 in the table. So at the end of period 5, the formula for the first value would be =Gammadist(5,x,y,TRUE) (x,y values not important here) and the formula for the second value would be: =Gammadist(4,x,y,TRUE) The only thing that changes is the period number. So, my goal is to write an array formula that will sum the GammaDist for each of the 5 rows, for all timeperiods (which is 5 in this case) I can get this far: ={SUM(B1:B5*GAMMADIST(ROWS(1:5)-1,C1,C2,TRUE))} But this passes 1 thru 5 to all rows, I only want 1 thru 5 passed to row 1, 1 to 4 passed to row 2, etc.
View Replies!
View Related
Query From 2 DSN's Into A Single Table
Our company's accounting system is physically split into 2 company databases, CompanyA and CompanyB. I'm trying to write a query which will pull the customer number and the accounts receivable balances from both companies into a single Excel table, for any customer with a total balance 0. I have created the following query, which doesn't generate any errors, but is only successfully importing the data from the first company. The CompanyA DSN is specified in the query ...
View Replies!
View Related
Convert Two Dimentional Table To Single Dimention
I have a two dimentional table that I want to be able to convert to single dimention records so I can import into database as records. Sample two dimentional table Description, Week1, Week2, Week 3, Widget1, 200, 100, 150 Widget2, 75, 25, 30 Widget3, 10, 20, 30 I want to be able to convert above table into format as below Widget1, week1, 200 Widget1, week2, 100 widget1, week3, 150 widget2, week1, 75 widget2, week2, 25 widget2, week3, 30 widget3, week1, 10 widget3, week2, 20 widget3, week3, 30 I do this each week with with approx, 40,000 records, (single dimention) copying and pasting is becoming a chore. Does anyone know a method to address this via functions, macros, formulas, etc. Number of rows and columns vary each time I repeat the exercise.
View Replies!
View Related
Extracting Records Based On Expiry Dates
I have created a database at work which collates various information on the sale of products. Part of this information is the date that each particular product is up for review (In DD,MM,YYY) format. Using the internal clock function I have produced a formula that calculates the numeber of days until expiry. However, using this information I want to be able to run a macro that looks at accounts that have for instance 5 days left until expiary and populate a new worksheet with various information extracted from my 'main' database. For example, search all the porducts that are due to expire tomorrow and then populate my new workseet with data from cells such as Product 1 = Cell A1, Cell a2, Cell a6, Cell a7, Prodcut 2 = a1, a2, a6, a7, Product 39 = a1, a2, a6, a7
View Replies!
View Related
Multiple Date Column To Single Column & Sort
I'm looking for a way to sort dates from several columns into a new single column (perhaps multiple columns if the entry columns become too numerous). I've included an example. There are currently only 4 columns, but there may be as many as 20 in the future, each with 20 dates under each heading. Any blank cells would be eliminated. If I filled a blank with a new date, that date would be placed into the chronological column. So basically, this would take the date from several different categories and create a single calendar of events.
View Replies!
View Related
Select Records And Create A New Column
Basically what I want to do is take any value that isnt "0" in column F and place it in another column in a nicely formatted table. So basically get rid of all the zeros... Im sure this has been done and asked before but I have no idea what to search for or if there is some easy forumla in excel for situations like this.
View Replies!
View Related
Pivot Table (count As A Single Fail Against The Associate)
I have a source data tab laid out like this: QC Date.......Policy#......Associate.......Pass/Fail......1stError.....2ndError.....3rdError QC'ers can enter up to 3 different error types committed on a single failed policy, thus the reason for 3 error fields, even though all 3 fields offer the same value list selections (ie ErrorTypeA, ErrorTypeB, ErrorTypeC......). A policy, whether it has one error or three errors assigned, should only count as a single fail against the associate. My problem comes into play when attempting to pivot the data. I would ideally like to see the pivot table in this format: (filter)Associate (filter)QC Date ... ErrorTypeA.......Count ErrorTypeB.......Count ErrorTypeC.......Count ErrorTypeD.......Count Where the "count" is the total number of occurances of that error type across all three error fields - 1stError, 2ndError, 3rdError. But since 1st/2nd/3rd error fields are different columns, I am unable to do a single count. My pivot ends up looking something like this: 1stError.....ErrorTypeA.......Count 1stError.....ErrorTypeB.......Count 1stError.....ErrorTypeC.......Count 1stError.....ErrorTypeD.......Count Then repeated for the 2ndError and 3rdError fields.
View Replies!
View Related
Pull Column Data (Sheet3) From Master.xls And Paste To Column 4, Sheet4 Of WorkingSS.xls
Pull Column Data (Sheet3) from Master.xls and past to Column 4, Sheet4 of WorkingSS.xls I'm assuming this would be done with VBA or a really exotic macro. The Funky Part would be that the WorkingSS.xls file column data is being copied/pasted too (WorkingSS1.xls or WorkingSS2.xls ect) the file may be different every time so I would need an insert in macro or VBA to "Choose File Please..." then continue. The Master.xls workbook has spreadsheet lets say "Sheet1" in which I need all the data in Column A (except the header or cell A:1) copied TO WorkingSS1.xls on Sheet4, Column B, but Column B already has about 6000 rows of info, so I need it copied to the very end of (A:6001 although it will be different everytime) or the first empty cell at the bottom of that column. next another Column from Master.xls workbook lets say "Sheet1" again in which I need all the data in lets say "Column B" copied to the WorkingSS1.xls on Sheet4, Column F. Caveat this time is that the data needs to copied to the same row as the first copy/past. So it would be pasted into F:6001. Double caveat is that the Column F contains no other data except for what we are about to paste in. I have several more steps of automation to be done here but this is the beginning and a big hump I need to get past. The rest I think I can do.
View Replies!
View Related
Pull Last Entry From Column
I am trying to find a formula that will choose the last number from a column of data. The column has a number added everyday and I want the last number entered to be pulled to a different cell. e.g. 34 35 35 33 38 37 so 37 is entered into the cell
View Replies!
View Related
Count Unique Records With Criteria From Another Column
As the title says, I need to count the number of unique records (names) in column A, where column L is = to something specific (X,Y,Z,W, whatever) for some statistics im trying to report. Please see the attached spreadsheet. For role X statistics, I need a count of the unique names from col A, where col L = X. Based on my sample spreadsheet, the number should be 2. For Role Y, it should be 3. There is the potential for spaces in the rows, and no one will be 'cross role' I've got a few different methods to just count unique values with specific criteria in the same column, but I just can't make anything work for specific criteria in another column.
View Replies!
View Related
|
TRACKER
