shiftdelete
New Member
- Joined
- Dec 10, 2014
- Messages
- 9
I've tried a few methods, but I'm struggling to put them all together to get my exact scenario to work. Any help is greatly appreciated.
I have a spreadsheet that needs to search down column B (Rate), find any duplicate values (there will be 12-15 duplicate pairs)-- and compare the values of Column C (Price) between the duplicate pairs and get the smallest value. (I'm using this to do conditional formatting - changing font color so that it looks greyed out.)
See the example below-- I would like to apply the formatting to columns A, B & C to dim the font color. (or at LEAST column C.) I cannot have the entire row highlighted, because I have additional non-related data in other columns.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Coupon[/TD]
[TD]Rate[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.25[/TD]
[TD]98.335[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.375[/TD]
[TD]99.032[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.50[/TD]
[TD]99.600[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.25
[/TD]
[TD]97.101
[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.375
[/TD]
[TD]98.289
[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.50
[/TD]
[TD]99.413
[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.625[/TD]
[TD]100.472[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.75[/TD]
[TD]101.328[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.875[/TD]
[TD]101.923[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]4.00[/TD]
[TD]102.404[/TD]
[/TR]
[TR]
[TD]3.5
[/TD]
[TD]3.75
[/TD]
[TD]100.214
[/TD]
[/TR]
</tbody>[/TABLE]
I have a spreadsheet that needs to search down column B (Rate), find any duplicate values (there will be 12-15 duplicate pairs)-- and compare the values of Column C (Price) between the duplicate pairs and get the smallest value. (I'm using this to do conditional formatting - changing font color so that it looks greyed out.)
See the example below-- I would like to apply the formatting to columns A, B & C to dim the font color. (or at LEAST column C.) I cannot have the entire row highlighted, because I have additional non-related data in other columns.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Coupon[/TD]
[TD]Rate[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.25[/TD]
[TD]98.335[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.375[/TD]
[TD]99.032[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]3.50[/TD]
[TD]99.600[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.25
[/TD]
[TD]97.101
[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.375
[/TD]
[TD]98.289
[/TD]
[/TR]
[TR]
[TD]3.0
[/TD]
[TD]3.50
[/TD]
[TD]99.413
[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.625[/TD]
[TD]100.472[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.75[/TD]
[TD]101.328[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]3.875[/TD]
[TD]101.923[/TD]
[/TR]
[TR]
[TD]3.0[/TD]
[TD]4.00[/TD]
[TD]102.404[/TD]
[/TR]
[TR]
[TD]3.5
[/TD]
[TD]3.75
[/TD]
[TD]100.214
[/TD]
[/TR]
</tbody>[/TABLE]