match & extract position

Hi Everyone, I'm working on this unique case. I've a table (raw data) in which I have Column 4 columns named Country, Supplier, Parts, and Net Price. Country Supplier Parts Net Price Germany Intel Part 1 2.30 Germany Intel Part 2 2.34 Germany Spirax Part 1.A 2.38 Germany Romoss Part...

In the first image in column F I have name of customers, and in column K I have deposited amount (here are multiple amounts which are similar). In the 2nd image, in column E I have received amount of amount and in Column H I want to input names of customer based on the data of Column F in Image...

Hello. I've been using this forum for a decade and this is the first time I've needed to ask a question because there has always been an answer to my question. Please help me figure out how to populate blank cells to the midpoint with the previous value i.e. I have semi random sample points...

1) The Values need to Match cell C1& B2 value like that cell value need to check. Condition like as below cells cell c1& b2 cell c2& b3 cell c3& b4 cell c4& b5 like this matching up to 100 After that I need total count of match value. The same way need to match reaming values...

Hi all, My data is structured in 2 Excel tables: tComments and tKeyTerms. Both are loaded in Power Query and I converted the tKeyTerms to a list {tKeyTerms}. The goal is to detect if any of the terms, which are not single words but a group of words, are used in any of the comments. When there...