![]() |
Conditional Formula
I'm having trouble updating a conditional array formula to fit new
criteria. Right now, I have something that looks something like this: {=IF(AND(($O6-$O$2:$O$7)<1),true,false)} Basically, if a number in the array is equal to or less than every other number in the array, it returns TRUE. (value) (result) 1 false 1 false 1 false 1 false 0 true 1 false Now, I want to limit the array it looks at, so it only considers values that are in the same row as the letter "l". I want the result to change to something like this: (value) (letter) (result) 1 l true 1 l true 1 l true 1 l true 0 s false 1 l true Because the 0 is no longer considered, each of the 1's are equal to each other. All numbers not considered would return false. Thank you for any help. -bgetson |
All times are GMT +1. The time now is 01:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com