=IF(ROW(A2)=1,IF(A2="*",1,"-"),IF(A2="o",IF(A1="*",B1+1,"1"),IF(A2="*",IF(A1="*",B1+1,1))))
-----Original Message-----coba pake gabungan fungsi if & countif
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Purwedi Kurniawan
Sent: Tuesday, November 22, 2005 11:48 AM
To: [email protected]
Subject: Re: [Programmer-VB] Sorry OOT : masalah counter di excel
On 11/19/05, g_liu <[EMAIL PROTECTED]> wrote:dear rekans prog-VB yg baik 'n ciamik :));
saya ada masalah dengan excel, mungkin ada rekan yang bisa bantu ;
nilai di A di input , sedangkan di B menghitung/ counter (secara otomatis)
sampai nilai "o" berikutnya, hasil nya seperti di bawah.
Gimana ya formula di B ??
br;
g_liu <~รด~>
#########
A B
=========
1 o -
2 * 1
3 * 2
4 * 3
5 * 4
6 * 5
7 * 6
8 * 7
9 * 8
10 * 9
11 o 10
12 o 1
13 * 1
14 * 2
15 * 3
16 * 4
17 * 5
18 o 6
19 * 1
20 o 2
21 o 1
#########
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
