Excel 問題

A-F有6個欄,下面有d有銀碼,有d冇,我想select一D列,條件係呢個列有3個or小於3個銀碼,即係好似列2/4/26都中了,想問下有咩formula可以做到..
thx

File在此..
http://www.sendspace.com/file/p94nxe

萬分感謝

TOP

呢d問題點解唔放去軟件區呀?

by the way... 你可唔可以再講清楚你想出嚟嘅結果/效果係點?

TOP

剩係show =<3既列..

TOP

Formula in G2
=IF(COUNT(A2:F2)<=0,"YES","NO")

TOP

Formula in G2
=IF(COUNT(A2:F2)
pass0418 發表於 2010-1-29 13:44


樓主意思應該唔係咁...
佢想每一row, 如果只係得其中3個column或以下係有data嘅先show出嚟, 如果多個3 column有數就唔show出嚟(e.g. hide咗果row), 樓主請confirm...
我覺得係要寫macro去做, 唔係就咁用formula或者conditional formatting做到... 不過真係冇時間/心機去砌...

TOP

樓主意思應該唔係咁...
佢想每一row, 如果只係得其中3個column或以下係有data嘅先show出嚟, 如果多個3 co ...
happy_gemini 發表於 2010-1-29 15:00

Then, it could be modified as following:

Formula in G2
=IF(COUNT(A2:F2)<=3, "YES", "NO")

TOP

如果你係要連列都隱藏埋Formula真係幫唔到你。

TOP