match

Hi All, I am working on a project whereby we have been provided a new list of descriptions with new codining to re-price. We also have years of existing data where the descriptions are somewhat similiar and have been working to match these with the existing codes we have as a base point. I...

Hi all, Hope you can help me with the following issue. I want to calculate the average number of grounds in a selection of cities (E2:E4). In this example, the number of grounds per city are given in column C. However, I don't succeed in getting the correct number, because it takes into...

Hello everyone. I'm new here and excited to share and answer. I've ran into several situations were I need to compare a list of values/text to see if they consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar...

Due to security controls on my system, XL2BB is not an option. Sorry, I really would prefer using that to writing this all out. Below is the destination table (well, one of them) I'm using to capture employee hours per month per department. This department is "AC" and is one of the few that has...

Hi all, This should be a simple problem but I seem unable to sort it: I have a list of numerical and word product codes in B44:B60, e.g HJK/5566712/19 A macro button on each row can copy the data from B44 over to H44 when sent to another department. Hitting the button again undoes the...

hi all, i have this overview: And in my other sheet entitled "XXX" i have this table: I am using this formula to calculate my nominal value in EUR: =IF(J2="EUR";I2;I2*VLOOKUP(J2;'XXX'!AO6:AS7;MATCH(J2;'XXX'!AO6:AS6;0);FALSE)) it should in the case above say 12046,37 * 0,134192, since...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...

Hello Can anyone help me in below attached picture from image 1 is my Data Sheet and 2nd is my daily sheet and i want to auto feel my columns from My DS sheet to daily sheet by month. EXAMPLE if i want jul-23 data in daily jul-23 data line which is 3C, in enter Jul-23 in C3, VLOOKUP formula auto...

Hi, I want to have a value of order from the exact file but with the different date range report. I want to match column A, B, C and D from the exact data from the other date range report and get the value of orders (column E) from the other file to this file. Can we achieve that through a...

Hi all, Hoping someone can help me with this query. I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached. I would like to expand upon this formula so that it still sums like I...

Hi everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...

I have a stream of cash flows with with two different Categories by which I would like to generate IRRs. I know you can create TRUE/FALSE ranges to be referenced by formulas and I think this is probably the way I want to do this? Basically I want to calculate separate IRRs for apple/banana/pear...

Hi i have a piece of code that is not working correctly for numbers. it will work perfectly when the cell value has at least one letter in it, but if the cell value is only numbers it will not work. I have a very limited understanding of VBA so any help at all is very much appreciated! here...

Hello, I am trying to automate a process and have tried various different platforms but seems that most roads lead to Excel. I'd like to take a column of numbers and group the 2 closest numbers that sum between 511 and 592. Once 2 numbers are grouped, they fall off the column of data and excel...

I'm sure this will be easy for one of you. I'm close, need a final tweak. I have a table of kids names with batting order in column1 (B3:B16), Inning # in row1 (C2:H2) and position they are playing each inning (1B, 2B, SS, etc.) scattered throughout the table. I'd like to create a unique cell...

G'day from Australia! Long time lurker, first time poster! Getting a bit stumped figuring a formula to generate a report using INDEX MATCH to detail all "VACANT" positions. This roster is an example (which generally varies in rows and titles) the only "fixed points" I can constantly refer to...

I am making a meeting overview of an event. I create each meeting down the rows and mark an "x" under each participant and time of the meeting (both along the columns). Hereafter I would like to make separate cellar overview where it automatically marks "free", "booked" or "double-booked" for...

Hi, I am looking to create a calendar on the first tab of a workbook I have. Currently the workbook has multiple sheets of data, each sheet containing data related to a different type of work that is being scheduled in for different people. In order to currently find out what type of work...

hello everybody, I have a problem with excel if command and I need your help I have let's say the below columns distance calendar price 200km 12 months 10€ 400km 24 months 17€ 600km 36 months 29€ 700 km 48months 33€ the distance might be a random number between 200 and 700 I want to create...

I have the following data in excel. I would like to derive the "Action" column for a "Person ID" based on the Y or N indicators in the "Value" column and what's in the "Month" column ABCD1Person IDValueMonthAction21N1/1/231st action32Y1/1/2341N2/1/232nd action52N2/1/231st...