Nested If Statement + Index/Match with multiple criteria

L

lpost1214

New Member
Joined
Nov 9, 2016
Messages
6
I am trying to populate an open order report with next production dates since our system does not peg production to orders. I am trying write a formula that will meet multiple criteria, but can't seem to get the formula to work just right. Below is a sample of the data and below that the production data and the formula I've written.

Formula: [TABLE="width: 2432"]
<tbody>[TR]
[TD="colspan: 38"]IFERROR(IF(OR(VALUE(g4) > 0,A4=" "),"",IF(AND(VALUE(g4)=0,a3="Description"),VLOOKUP(B4,Sched!A:C,3,0),IF(B4=" ","",IF(AND(VALUE(g4)=0,VALUE(g3) <> 0),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0)),IF(AND(VALUE(g4)=0,VALUE(g3)=0,VLOOKUP(B4,Sched!A:C,3,0)-h3 < h4),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0)+1),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0))))))),"-")[/TD]
[/TR]
</tbody><colgroup><col span="38"></colgroup>[/TABLE]


Criteria:
*If value in balance on hand (column G) = 0, and first row for item (column A) then look up first production quantity for that item.
*If value in balance on hand (column G) = 0, and not first row for item (column A), check to see if production quantity looked up in row above minus the open order qty for the line above, >= open order quantity in the current row. If true, then return the same production quantity as above, if false, return next production quantity for that item.
*If there is no look up value once criteria is met, return a 0
*If an empty row or the value in column G is >0, then show as blank

Thanks in advance for your help!
[TABLE="width: 604"]
<colgroup><col width="180" style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl67, width: 180"]Description[/TD]
[TD="class: xl67, width: 107"]Cust PO #[/TD]
[TD="class: xl67, width: 87"]Del Date[/TD]
[TD="class: xl68, width: 64"]Customer PO Quantity[/TD]
[TD="class: xl68, width: 55"]Shipped Qty[/TD]
[TD="class: xl68, width: 65"]Open Order Qty[/TD]
[TD="class: xl66, width: 121, bgcolor: #AEAAAA"]Balance On Hand [/TD]
[TD="class: xl66, width: 126, bgcolor: #AEAAAA"]Next Production Qty[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 604"]
<colgroup><col width="180" style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl67, width: 180, bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl67, width: 107, bgcolor: transparent"]2171337828[/TD]
[TD="class: xl66, width: 87, bgcolor: transparent"]4/20/2018[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]5417[/TD]
[TD="class: xl67, width: 55, bgcolor: transparent"]0[/TD]
[TD="class: xl67, width: 65, bgcolor: transparent"]5417[/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]0[/TD]
[TD="class: xl65, width: 126, bgcolor: transparent"]5472[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl67, bgcolor: transparent"]2171369379[/TD]
[TD="class: xl66, bgcolor: transparent"]6/4/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]5417[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]5417[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]5472[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171328949[/TD]
[TD="class: xl66, bgcolor: transparent"]4/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4750[/TD]
[TD="class: xl65, bgcolor: transparent"]48[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171369382[/TD]
[TD="class: xl66, bgcolor: transparent"]6/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1425[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1425[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1440[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171264847[/TD]
[TD="class: xl66, bgcolor: transparent"]7/6/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2500[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2500[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307716[/TD]
[TD="class: xl66, bgcolor: transparent"]8/10/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1250[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1250[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]6788[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171259218[/TD]
[TD="class: xl66, bgcolor: transparent"]2/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4106[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4106[/TD]
[TD="class: xl65, bgcolor: transparent"]3883[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307607[/TD]
[TD="class: xl66, bgcolor: transparent"]3/12/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl65, bgcolor: transparent"]1341[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171332469[/TD]
[TD="class: xl66, bgcolor: transparent"]4/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]11400[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171259219[/TD]
[TD="class: xl66, bgcolor: transparent"]2/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2933[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2933[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]2934[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307606[/TD]
[TD="class: xl66, bgcolor: transparent"]3/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1467[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1467[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171348593[/TD]
[TD="class: xl66, bgcolor: transparent"]3/26/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]3838[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171348594[/TD]
[TD="class: xl66, bgcolor: transparent"]4/26/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]88[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171352728[/TD]
[TD="class: xl66, bgcolor: transparent"]5/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3750[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171375520[/TD]
[TD="class: xl66, bgcolor: transparent"]6/15/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3750[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171366788[/TD]
[TD="class: xl66, bgcolor: transparent"]6/1/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2083[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2083[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3126[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171375519[/TD]
[TD="class: xl66, bgcolor: transparent"]6/15/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1042[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1042[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3126[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/68ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171352178[/TD]
[TD="class: xl66, bgcolor: transparent"]5/24/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]4210[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB RC Frt 8/3/75ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171362181[/TD]
[TD="class: xl66, bgcolor: transparent"]5/24/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]4210[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 364"]
<colgroup><col width="209" style="width: 157pt; mso-width-source: userset; mso-width-alt: 7643;"> <col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;"> <col width="162" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;"> <tbody>[TR]
[TD="width: 209"]Part Description[/TD]
[TD="width: 113"]Due Date[/TD]
[TD="width: 162"]Production Quantity[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/11/2018[/TD]
[TD="bgcolor: transparent, align: right"]11400[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/18/2018[/TD]
[TD="bgcolor: transparent, align: right"]2934[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]3126[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/20/2018[/TD]
[TD="bgcolor: transparent, align: right"]3750[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/18/2018[/TD]
[TD="bgcolor: transparent, align: right"]3750[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/7/2018[/TD]
[TD="bgcolor: transparent, align: right"]6250[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB RC Frt 8/3/75ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/11/2018[/TD]
[TD="bgcolor: transparent, align: right"]4210[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/68ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]4210[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]1440[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/25/2018[/TD]
[TD="bgcolor: transparent, align: right"]1920[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/15/2018[/TD]
[TD="bgcolor: transparent, align: right"]1440[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]5472[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]5472[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/8/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
993
AlanY
A
N
  • Question Question
How to Create Multiple Reports from One Sheet
Replies
1
Views
3K
Logit
Logit
subrosumon
  • Question Question
Multiple Sheet pivot table
Replies
1
Views
841
steve the fish
steve the fish
G
  • Question Question
Transpose matching data from columns to rows
Replies
3
Views
861
bwaaack
B
M
  • Question Question
Index Match formula with multiple criteria
Replies
5
Views
783
DanteAmor
DanteAmor

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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