|
|
 |
| found 14 articles for 0.303 sec |
  |
|
Group: comp.os.linux.advocacy · Group Profile · Search for T612 in comp.os.linux.advocacy
Author: Night0wl
Date: Nov 15, 2007 08:36
Assuming that one week is in say column C, the next is in D, then you can get the indicator woth =SUBSTITUTE("D"&SUBSTITUTE(C2,"T","")-SUBSTITUTE(D2,"T",""),"D-","U") not arrows, but U and D. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ben" <Ben@discussions.microsoft.com> wrote in message news:1978F57F-DB8C-4CBC-AF2D-A9E6647725C4@microsoft
|
| Show full article (2.79Kb) · Show article thread |
Group: alt.os.linux.ubuntu · Group Profile · Search for T612 in alt.os.linux.ubuntu
Author: Peter Köhlmann
Date: Nov 15, 2007 08:06
Try this Ben, =IF(COUNTIF($D$2:$D$760,D2)>1,"T","")&ROUND(COUNTA($D$2:$D$760)-SUM(IF(D2>$D$2:$D$760,1/COUNTIF($D$2:$D$760,$D$2:$D$760)))-1,0) array entered it is. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ben" <Ben@discussions.microsoft.com> wrote in message news:9C48C142-53D6-45C5-9733-90A657C734D7@microsoft.com... Hi
|
| Show full article (2.32Kb) · Show article thread |
|
 |
|
1 ·
2 ·
next |
|
|