Search results

Great, thanks for the replies!

The reference data has four columns: date, class (three letters), FX(three letters) and return. The output is based on three columns: date, class and FX.

Is it possible upload screen shots or sample Excel sheets?

Hello - I am trying to use index match to locate values based on two criteria. The column I want to return is return. I need to match this to a specific date, a fund name and a currency. Thus, there are three different criteria that needs to be met in order to match the right data. Here is...

Great, thanks.

Hello - I would like to use a VBA that generates a "true" when a date falls on a weekend and a "false" signal if it is a weekday. I tried some of the codes listed online but none seemed to work properly. Any thoughts?

I see, thanks. This is my first post so my apologies. Here are the formulas I mentioned: =IF(G2<>G3,MAX(OFFSET($D$2,MATCH(G2,$G$2:$G$16,0)-1,0,COUNTIF($G$2:$G$16,G2))),"") =IF(G2<>G3,MIN(OFFSET($D$2,MATCH(G2,$G$2:$G$16,0)-1,0,COUNTIF($G$2:$G$16,G2))),"") I tried to use...

This seems to work but it does not match the correct column. Instead of matching the values from the "group" column I would like to match the "last" column. That is column E. Is there anyway to update this formula to use the value from column E instead of the value in column H? I think the...

I second part of the formula appears to work but unfortunately the countif logic does not. Here is an example when I just use the countif logic with a sample data set: I need to generate a false to capture the MAX and MIN for each formula. Time[L] Type Last hour Minute...

For each row the countif function is TRUE.

Unfortunately, the formulas are not working properly. Are you suggesting to plug the first formula is cell I2, change the formulas to include all the rows and then drag the formula down the rest of the columns?

Great, thanks! Much appreciated. Is there a way to adjust the formula to include all the rows? The sheet has 37,627 rows so how would this impact the cells referenced in the second part of each formula: MIN(IF($H$2:$H$20=$H2,$E$2:$E$20))and MAX(IF($H$2:$H$20=$H2,$E$2:$E$20)))? I also tried...

I cleaned up the group column. Here is a clearer example: The * indicates a cell where I need to find the MAX and MIX from the "last" column that includes the range for each group. Again, the range sequence is random, which complicates the formula-writing process. I will then reference these...

The results would look like this: Then, I could match the high/low for each group with my other dataset. Last hour Minute Group high low 1.3610 0 0 00 1.3606 0 0 00 1.3602 0 10 010 1.3610 1.3602 1.3606 1 0 10 1.3605 1 0 10 1.3605 1.3606 1.3611 1 10 110 1.3614 1 10 110 1.3615 1 10 110 1.3622 1...

hello - thanks for the feedback. I have other data that I am going to match with the "group" criteria. The plan is to round down each value in this data set and the other data set to 10 minute intervals and match the high and low of each group (as you can see there are multiple last values for...

I need to find the MAX and MIN of the "last" column for the "groups" I created (see table below). The groups are rounded down to 10 minute intervals and then concatenated with the hour and minute. As such, the first group is 12:00am (00) and the third group is 12:14 (rounded down to 12:10am)...