matches

Hello everyone, I have to lookup a set of values through other sets of values (almost half million rows total). Could anyone suggest any approaches to this task? I thought of creating named ranges with each set, then iterate through each range to get all the matches. But would there be any...

I found a fast way of utilising VLOOKUP when having huge amount of data (I'm looking at 1,000,000 rows of data looking up another table of 200,000 to 500,000 rows (& 15 columns, if that as any bearing). I used the following: =IF(VLOOKUP(id,data,1,TRUE)=id, VLOOKUP(id,data,col,TRUE), NA()) This...

I have data wtih 21 rows & 6 columns. Wherein I need to compare a1 with a2 to f2 similarly ,b1,c1,d1,e1 & f1 with a2 to f2 and then increment row by 1 and continue the same process till end. If the result matches then highlight the previous row cell...

Hello, I want to count rows that have specific values in different columns but also for one of the columns that contains a DATE, I want to return matches for the function MAX(TODAY()-DATE,TODAY()-1/1/18)>50 Any idea how to do that?

Hi folks, I am trying to extract multiple matches from one sheet into another sheet. Using =VLOOKUP won't work as it only brings the first instance. I have done some research and I think the solution is something more complicated with =INDEX and =SMALL and =ROW or =COLUMN ... but my brain...

Hello. I am comparing 2 workbooks and checking if their respective values matches. If matches, the return value is either a TRUE or 1. However, I want the return value to be something like an alphabet. E.g. return a "P" Below is my excel formulae...

I am trying to do a type of SumIfs. My formula is going in K3 (and will be copied down to the end of the sheet) If the Value in Column $B:$B matches the Value in $B3 and the Value in $F:$F matches the Value in $D3 AND the Value $I:$I is less than the value in $I3

<tbody> Name Number Amount Total Brad Jones 1234567 35 Brad Jones 1234567 19 Brad Jones 1234567 10 Joe Bob 9999999 55 Steve Smith 1111111 60 Steve Smith 1111111 40 </tbody> Hi, I am looking for help to make a formula or macro for this spreadsheet. I am not great at excel...

Hello guys, I am new to the community, so please forgive me for any mistakes regarding my first post. Now, I have a range of some store names with their respective addresses. I need to find all possible matches against every store to remove any sort of duplication due to typo or abbreviations...

Hi There, I am trying to match two values in a range of data, if both match, then sum the value in column of all matches. Can anyone advise how I do this please? Many thanks in Advance! <colgroup><col><col span="2"><col><col span="2"><col><col span="8"></colgroup><tbody></tbody>

Hi Mr Excel, I am currently looking for a formula that index matches multiple criteria (For example; Name & Course Name) & also looks for the latest date & returns the latest grade. Please see example attached below. I tried to make up an example on here but I am having a bit of trouble with...

Hi Mr Excel, I am trying to work out a formula that matches two criteria & returns the value in an adjacent cell. I can find this quite simply but I was wondering if there was a way to use an Array Formula to return all matches & not just the first or last match. Please see example with result...

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

Hello, I'm needing help creating a syntax for the following scenario. I have two sheets in an Excel file. I'm wanting to take column A from Sheet2 and see if there are any matches in column B of Sheet1, then if there is a match(or same containing character sequence) then return value "retired"...

Hi, I want a formula on column E. If the number on column F matches that on column B, I want the word that is on that line on column A to be on column E. For example, on E1, since F1 is 107, it matches B6, so word should be Green. On E2, it will be Sad, E3 will be Sad, etc. What formula...

Hello, How do regex/wildcards work in Excel search and replace? How can I search for a cell reference inside formulas that matches E\d+? i.e. E1 ... E25 ... E162, etc? Thanks!

Hello, everyone, I'm trying to concatenate several cells into one if it matches a certain criterias. I was wondering if you could lay me a hand. Below you will find a file with a simple example: https://ufile.io/9e7ht Thanks!

Hi, What I need help with is this - if A1 matches the data in D1 and B1 matches E1 then reference the data from from C1

Hello, Thank you for reading my question. I am trying to create a formula but can't figure it out. This is what I'm looking for: IF anything in Column A matches AND of those matches, If any cell in Column B is equal to 3140, 3140L, 3141, 3141L, 3142, 3142L, 3143, 3143L, 3144, 3144L, 3145...

I have months and the year in col B4:M4 in destination workbook I am trying to set up a formula to do extract a value from row 7 in the source file where the month and year in Col C1:N1 matches B4 in the destination file. =OFFSET('[Sales ACCNTS(P).xls]Summary'!$C$7,MATCH(B4,'[Sale...