Thanks
in [Functions]
|
From: Michael on 5 Nov 2009 22:33 Hi smartin Thanks for the reply. I don?t really get your formula, as I am looking for the time when the value appears for the first time. MATCH should not start comparing with the first time value, but e.g. 1 hour later. Am I supposed to copy your formula down due to the $-sign? Best regards Michael smartin wrote: Michael wrote:Try this out; must be 05-nov-09 Michael wrote: Try this out; must be array-entered*: =INDEX($B$2:$B$9999,MATCH(1,--($C$1<=$A$2:$A$9999),0)) *Array-entry: commit the formula by holding down Ctrl and Shift while you tap Enter. Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Useful Vista Tweaks http://www.eggheadcafe.com/tutorials/aspnet/f0247f48-7bc0-4981-b515-c80c5d6d00ec/useful-vista-tweaks.aspx
From: smartin on 6 Nov 2009 23:40 My bad: I read the requirement backwards. Revised formula (no array-entry needed): Return the next time in column A where the value in C1 matches a value in column B: =INDEX($A$2:$A$9999,1+MATCH(C1,B2:B9999,0)) Michael wrote: > Hi smartin > Thanks for the reply. I don?t really get your formula, as I am looking for the time when the value appears for the first time. MATCH should not start comparing with the first time value, but e.g. 1 hour later. > Am I supposed to copy your formula down due to the $-sign? > Best regards > Michael > > > > smartin wrote: > > Michael wrote:Try this out; must be > 05-nov-09 > > Michael wrote: > > Try this out; must be array-entered*: > > =INDEX($B$2:$B$9999,MATCH(1,--($C$1<=$A$2:$A$9999),0)) > > *Array-entry: commit the formula by holding down Ctrl and Shift while > you tap Enter. > > Previous Posts In This Thread: > > EggHeadCafe - Software Developer Portal of Choice > Useful Vista Tweaks > http://www.eggheadcafe.com/tutorials/aspnet/f0247f48-7bc0-4981-b515-c80c5d6d00ec/useful-vista-tweaks.aspx
|
Pages: 1 Prev: IF statement Next: DAVERAGE, MIN, and MAX from another worksheet |