Hello -
I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Aetna[/TD]
[TD]BCBS[/TD]
[TD]Health Net[/TD]
[TD]Dean[/TD]
[TD]Geisinger[/TD]
[/TR]
[TR]
[TD]Bronze[/TD]
[TD]10[/TD]
[TD]N/A[/TD]
[TD]100[/TD]
[TD]35[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Bronze Plus[/TD]
[TD]15[/TD]
[TD]N/A[/TD]
[TD]50[/TD]
[TD]45[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Gold[/TD]
[TD]20[/TD]
[TD]N/A[/TD]
[TD]75[/TD]
[TD]55[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]30[/TD]
[TD]N/A[/TD]
[TD]25[/TD]
[TD]65[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]
Looking to find a way that I can pull the name of the lowest cost carrier (Geisinger) in my example above. Table range is E55:O60.
I'm looking to have this the result in C87
Is there a way to write this w/out { }?
I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula
Code:
{=IFERROR(INDEX($F$55:$O$55,SMALL(IF(INDEX($F$56:$O$60,MATCH("Bronze",$E$56:$E$60,0),0)=MIN(INDEX($F$56:$O$60,MATCH("bronze",$E$56:$E$60,0),0)),COLUMN($F$56:$O$60)-COLUMN($F$56)+1),ROWS($C$86:C86))),"")}
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Aetna[/TD]
[TD]BCBS[/TD]
[TD]Health Net[/TD]
[TD]Dean[/TD]
[TD]Geisinger[/TD]
[/TR]
[TR]
[TD]Bronze[/TD]
[TD]10[/TD]
[TD]N/A[/TD]
[TD]100[/TD]
[TD]35[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Bronze Plus[/TD]
[TD]15[/TD]
[TD]N/A[/TD]
[TD]50[/TD]
[TD]45[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Gold[/TD]
[TD]20[/TD]
[TD]N/A[/TD]
[TD]75[/TD]
[TD]55[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]30[/TD]
[TD]N/A[/TD]
[TD]25[/TD]
[TD]65[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]
Looking to find a way that I can pull the name of the lowest cost carrier (Geisinger) in my example above. Table range is E55:O60.
I'm looking to have this the result in C87
Is there a way to write this w/out { }?
Last edited: