offset & match

Hi all so i am trying to do something that i don't know if is possible I have created a table for training courses that can work like a calendar The course details ar within the red boxes and can be anywhere within the range - but always come as a block. on my team view sheet - The formula...

Hiya, I have a workbook with two worksheets in. Worksheet one has a list of telephone numbers starting in column A2 -> A143 and in D2 -> D143 are their respective owners. The second worksheet has a list of telephone numbers with charges associated with them. I want the second worksheet to...

Hello, as per the below, i have a sheet showing a page of info about different people. On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result. Is there a way to lookup (for example) "person 6" across multiple columns...

Happy thanksgiving and Columbus day! Not sure if I'm thinking about this in the right way or if this is even efficient. I'm facing a couple of problems and can't construct the right formula. I feel it has to do with index, match, offset? I'm thinking about this problem in this way as I know...

Hi I´m sitting with a job-task I would like ideas on. I got two tables. See picture attached. 1. "Pricelist" with product-numbers and prices (Column B+C) 2. "Brochure" that contains same information. (F+G) I need to update prices from my "Pricelist" to my "Brochure". My idea: 1. Search...

I've attached a link to a data table. Here's what I'm trying to do. For each cell in column G, I need to calculate the revenue-weighted average price of the product lines EXCLUDING the product line associated with the row of the cell that I am calculating in column G. Cell G2 is a manual...

Hi there, In my daily workbook I have an invoice date that changes every month and the payment date is always on the 2nd of the following month. I'm trying to create a formula to flag the payment date and show the corresponding cash outflow on the payment date. Using the OFFSET function...

FOR EXPERTS Hello everyone. As this is my first post on this platform as I got stuck after days of trying without success and I apologize if already exist the same post because I couldn't find it. Namely, I have a excel table that consist of horizontal dates (of 2-3 years) and vertical data...

Dear all, have a nice day. I appreciate any information you can give me about the following question. I am performing a search process that allows me to find, within a set of students [A2:A9], who obtained the highest grade [B2:I9], for a set of subjects [B1:I1]. I found a solution, but it...

Dear all, have a very nice day I apologize for the lengthy statement, but I want the problem to be well formulated to avoid confusion. In the 'Data' worksheet, you will find information that compiles the weather conditions recorded daily for any given city from January 1, 1999 to December 31...

Hi All! I am having an issue copying data (several fields) from one worksheet to another worksheet.... in the correct row of data. The first sheet (Summary) has a a few student names and data listed. These names are compared to another sheet (Tutoring Attendance) and the "new" names added to...

Hello, I am trying to sum up a range based on a condition, using the functions: SUM(), OFFSET(), MATCH(), and COUNT(). To take the figures in the screenshot as an example, the formula is retrieving 35 as the sum of 24 and 25 (numbers that are bigger than the condition, 23). However, what I...

Hi, I would really appreciate some urgent help on this please as I'm so stuck. I currently have a few rows of data and I'm looking to shift the data by a month, apply some distribution probabilities based on how many months have elapsed and sum cumulatively. Say I have a distribution table with...

Hey guys I am working on this code and my plan is to go into a worksheet, get the max of column A. And if the max is found then go to the next row over and get the name associated with it. I wrote this code and the value of the name is coming up blank and I don’t what I am doing wrong. Dim...

Hi. Quite some time ago I used Offset Match (and possibly Index) in a formula, that helped me collate some data in a spreadsheet. In the example attached, I have a list of players and the teams they have scored against (Column A-B). What I would like to do is use Offset Match Index to give me...

Hello Everyone, I have a sheet contain lots of value in rows. please find below for example: if you see , difference between Fruit and Place is equal i mean 3 rows Same Apple and America has same interval i e 3 rows I want Fruit in B1 and Place in B2 and in front of B1 it should be apple in...

i have a code when on cell change then loop and fine matching value. then offset and paste in cell to left. code works fine but need it to work faster. Any help would be appreciated. Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Sheet1.Range("C2:C50")...

Hi all, I hoping for some advice here. I am trying to calculate the success rate of members of staff. I have each student's score in a number of subjects (A2:J6) and there teacher for each subject (L:U) I want to COUNT the total number of student scores over a certain amount (e.g. >5) for the...