IF, OR, Index, Match, Multiple Criteria

W

wintye

New Member
Joined
Apr 15, 2013
Messages
15
Hi All,

I hope you're enjoying the weekend.

I wonder if anyone can help with the following formula. I'm trying to pull a date from another table but only if it matches certain criteria.

Table with Data
[TABLE="width: 500"]
<tbody>[TR]
[TD]Unique Identifier[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Course[/TD]
[TD]Date[/TD]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Course 1[/TD]
[TD]15/04/2016[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Course 2[/TD]
[TD]17/05/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Course 3[/TD]
[TD]19/01/2018[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]Course 2[/TD]
[TD]10/07/2017[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]Course 3[/TD]
[TD]25/06/2017[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]Course 1[/TD]
[TD]28/10/2016[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]78901[/TD]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD]Course 3[/TD]
[TD]01/01/2016[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]78901[/TD]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD]Course 2[/TD]
[TD]01/10/2017[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]78901[/TD]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD]Course 1[/TD]
[TD]01/05/2015[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]Course 2[/TD]
[TD]29/03/2015[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]Course 1[/TD]
[TD]23/10/2017[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]Course 3[/TD]
[TD]16/03/2016[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

Table pulling data into

[TABLE="width: 500"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Unique Identifier[/TD]
[TD]Course 1[/TD]
[TD]Course 2[/TD]
[TD]Course 3[/TD]
[/TR]
[TR]
[TD]VLOOKUP from another table[/TD]
[TD]VLOOKUP from another table[/TD]
[TD]VLOOKUP from another table[/TD]
[TD]to include the formula[/TD]
[TD]to include the formula[/TD]
[TD]to include the formula[/TD]
[/TR]
</tbody>[/TABLE]

The formula I have so far is:

{=IF(C2="","",IF(OR(Data_Report[Grade]="3",Data_Report[Grade]="4"),INDEX(Data_Report[Date],MATCH(1,(Data_Report[Unique Identifier]=C2)*(Data_Report[Course]="1"),0)),"Not Applicable"))}

Basically I'd like the formula to show if there's nothing in the "unique Identifier" column then to leave the cell empty,
If there is a "unique Identifier" in cell 'C2' then to lookup the unique identifier to the data table ensuring to match the grade to either a grade 3 or 4 and additionally match the the course name and pulling through the date the course was completed.
If the grade is different to 3 or 4 then to return 'not applicable'

e.g. = Jane Doe, Course 2 should show as '17/05/2017'
John Smith, Course 3 should show as 'Not Applicable'
Jane Smith, Course 1 should show as '01/05/2015'
John Doe, Course 1 should show as a blank cell

Hoping the above makes sense and welcome any feedback and advise. I've spen forever trying to get it to work and am so close but haven't quite got it.

Many thanks in advance for reading
Wintye :confused::confused:
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]17/05/2017[/TD]
[/TR]
</tbody>[/TABLE]
</body>
 
Sort by date Sort by votes
Hi there, Apolgies if this is not the way to go about this but I have a variation on a similar theme that I am trying to solve. Please let me know if I should make this a separate posting.

In the following table, the full version of which is about 30k records at the moment, I am trying to sum all the sales made in the QTY column where the EVENT = "8549", and the CODE ="IB" or "CC" and if possible the CUST = "TBAT". I have a number of combos/variants on this that I will hang together once I understand the general way in which this is handled. I had thought to pivot the data first into simple total report that I then lookup into if that makes sense.

[TABLE="width: 522"]
<tbody>[TR]
[TD="class: xl66, width: 87"]EVENT[/TD]
[TD="class: xl66, width: 87"]CODE[/TD]
[TD="class: xl66, width: 87"]QTY[/TD]
[TD="class: xl66, width: 87"]PRICE[/TD]
[TD="class: xl66, width: 87"]CUST[/TD]
[TD="class: xl66, width: 87"]FEE[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]CC[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]CC[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]IB[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]IB[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8582[/TD]
[TD="class: xl66"]IB[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8582[/TD]
[TD="class: xl66"]IB[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8582[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]INGRESS[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]INGRESS[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]CC[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]TBAT[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]ENTA[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]ENTA[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]8549[/TD]
[TD="class: xl66"]AH[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]ENTA[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]7711[/TD]
[TD="class: xl66"]CC[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]GIGS[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]7711[/TD]
[TD="class: xl66"]CC[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]50.75[/TD]
[TD="class: xl66"]GIGS[/TD]
[TD="class: xl66"]0.8[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
TJORNERS said:
Hi there, Apolgies if this is not the way to go about this but I have a variation on a similar theme that I am trying to solve. Please let me know if I should make this a separate posting.

In the following table, the full version of which is about 30k records at the moment, I am trying to sum all the sales made in the QTY column where the EVENT = "8549", and the CODE ="IB" or "CC" and if possible the CUST = "TBAT". I have a number of combos/variants on this that I will hang together once I understand the general way in which this is handled. I had thought to pivot the data first into simple total report that I then lookup into if that makes sense.
Click to expand...

Try this in K2:

=SUMPRODUCT(SUMIFS(C:C,A:A,H2,B:B,I2:I3,E:E,J2))


[TABLE="class: grid, width: 487"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]EVENT[/TD]
[TD]CODE[/TD]
[TD]QTY[/TD]
[TD]PRICE[/TD]
[TD]CUST[/TD]
[TD]FEE[/TD]
[TD][/TD]
[TD]EVENT[/TD]
[TD]CODE[/TD]
[TD]CUST[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8549[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD]8549[/TD]
[TD]IB[/TD]
[TD]TBAT[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8549[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD]CC[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8549[/TD]
[TD]IB[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8549[/TD]
[TD]IB[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]8582[/TD]
[TD]IB[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]8582[/TD]
[TD]IB[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]8582[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]INGRESS[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8549[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]INGRESS[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]8549[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]8549[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]TBAT[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]8549[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]ENTA[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]8549[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]ENTA[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]8549[/TD]
[TD]AH[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]ENTA[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7711[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]GIGS[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]7711[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]50.75[/TD]
[TD]GIGS[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]****[/TD]
[TD]********[/TD]
[TD]*******[/TD]
[TD]*****[/TD]
[TD]*********[/TD]
[TD]*********[/TD]
[TD]******[/TD]
[TD]**[/TD]
[TD]********[/TD]
[TD]********[/TD]
[TD]********[/TD]
[TD]*****[/TD]
[/TR]
</tbody>[/TABLE]

Markmzz
 
Upvote 0
Thanks Mark, i'll try that - for this to work, do the column headings have to be there in columns H,I & J or does it just use the actual data content in H2, I2:I3 and J2 for the maths to work ?

I had got somewhere similar using a DSUM function but I felt that that needed far too many criteria tables for me to then report on each event in the range I need to report on - I have 50 events in total from which I want to derive sums.

Doing it you way will greatly limit the criteria sections that I have to create which is great. Basically I can just use your basic sum and change the Event criteria field only each time for me to get what I need.
 
Upvote 0
Hi Mark, No need to respond to my previous submission i've worked its out and event better I can hard code one or two of the pre-reqs into the formula you gave me and then it can actually use the cell address of the event from the table in which I am going to store the results making the whole pretty much a copyable solution rather than a function that required me to edit multiple times - thanks for your steering on this - much appreciated.
 
Upvote 0
TJORNERS said:
Hi Mark, No need to respond to my previous submission i've worked its out and event better I can hard code one or two of the pre-reqs into the formula you gave me and then it can actually use the cell address of the event from the table in which I am going to store the results making the whole pretty much a copyable solution rather than a function that required me to edit multiple times - thanks for your steering on this - much appreciated.
Click to expand...

I'm glad to help and thanks for the feedback.

Markmzz
 
Upvote 0
Hello I am looking to pull the closest price of a particular serial no.

The criteria being the serial no. The value returned needs to be the closest value (absolute).

[TABLE="width: 443"]
<tbody>[TR]
[TD]Serial No.[/TD]
[TD]Average[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]105.125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.625[/TD]
[TD][/TD]
[TD]Criteria[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.6271136[/TD]
[TD][/TD]
[TD]Serial No.[/TD]
[TD]00163UAD8[/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]107.875[/TD]
[TD][/TD]
[TD]Average Bid & Ask[/TD]
[TD="align: right"]103.68[/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]115.065[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]113.38[/TD]
[TD][/TD]
[TD]Output[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]104.85[/TD]
[TD][/TD]
[TD]Average of Bid & Ask[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]105.0255[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.5953352[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.9375[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]

[TABLE="width: 443"]
<tbody>[TR]
[TD]Serial No.[/TD]
[TD]Average[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]105.125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.625[/TD]
[TD][/TD]
[TD]Criteria[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.6271136[/TD]
[TD][/TD]
[TD]Serial No.[/TD]
[TD]00163UAD8[/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]107.875[/TD]
[TD][/TD]
[TD]Average Bid & Ask[/TD]
[TD="align: right"]103.68[/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]115.065[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]113.38[/TD]
[TD][/TD]
[TD]Output[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]104.85[/TD]
[TD][/TD]
[TD]Average of Bid & Ask[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]105.0255[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.5953352[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.9375[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.8125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.1696[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]105.755[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.615[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAD8[/TD]
[TD="align: right"]104.87[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]107.69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]110.1549026[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]112.125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00163UAA4[/TD]
[TD="align: right"]105.2696711[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Dynamic Filter by row
Replies
5
Views
678
BrettJH
B
C
  • Solved
VBA: Comparing two tables and adding unique values from 1 table to another
2
Replies
15
Views
682
Peter_SSs
Peter_SSs
F
  • Question Question
Index min value from one column based on multiple matches in another column
Replies
2
Views
445
Anonymous1378
A
C
  • Question Question
Index/Match multiple criteria and results
Replies
3
Views
774
Fluff
Fluff
F
  • Question Question
Would like to index different data points based on multiple criteria, and then index additional data in the same columns based on date/time proximity
Replies
4
Views
531
freeb1893
F

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top