software

Hi is any one can help?? I need a formula can calculate the item no. ,if the
column quot;cquot; show quot;deletedquot; or column quot;Bquot; show the same no. for the above row,
the formula will skip to next item. sample as follow:-

item no A B C
1 8 8-TP$3B 200E-L-75-1
- 8 8-TP$4A DELETED
- 8 8-TP$4B DELETED
- 8 8-TP$5A 200E-L-75-1
2 8 8-TP$5A 200E-L-75-1
- 8 8-TP$6A DELETED
- 8 8-TP$6B DELETED
- 8 8-TP$7A DELETED
- 8 8-TP$7B DELETED
- 8 8-TP$8A DELETED
- 8 8-TP$8B DELETED
3 8 8-TP$9 200E-L-75-1
- 8 8-TP$10A DELETED
- 8 8-TP$10B DELETED
- 8 8-TP$11A DELETED
- 8 8-TP$11B DELETED
4 8 8-TP$12A 200E-L-75-1

Many thanks
philip
Use formlua like this
lt;starting from row 2gt;
if(or(B2=B1, C2=quot;DELETEDquot;),quot;-quot;, sum($A$1:$A1) 1)--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================

quot;philipquot; gt; wrote in message
...
gt; Hi is any one can help?? I need a formula can calculate the item no. ,if
gt; the
gt; column quot;cquot; show quot;deletedquot; or column quot;Bquot; show the same no. for the above
gt; row,
gt; the formula will skip to next item. sample as follow:-
gt;
gt; item no A B C
gt; 1 8 8-TP$3B 200E-L-75-1
gt; - 8 8-TP$4A DELETED
gt; - 8 8-TP$4B DELETED
gt; - 8 8-TP$5A 200E-L-75-1
gt; 2 8 8-TP$5A 200E-L-75-1
gt; - 8 8-TP$6A DELETED
gt; - 8 8-TP$6B DELETED
gt; - 8 8-TP$7A DELETED
gt; - 8 8-TP$7B DELETED
gt; - 8 8-TP$8A DELETED
gt; - 8 8-TP$8B DELETED
gt; 3 8 8-TP$9 200E-L-75-1
gt; - 8 8-TP$10A DELETED
gt; - 8 8-TP$10B DELETED
gt; - 8 8-TP$11A DELETED
gt; - 8 8-TP$11B DELETED
gt; 4 8 8-TP$12A 200E-L-75-1
gt;
gt; Many thanks
gt; philip
gt;
gt;
I think Daniel means COUNT at the end, not SUM.

Andy.

quot;Daniel CHENquot; gt; wrote in message
...
gt; Use formlua like this
gt; lt;starting from row 2gt;
gt; if(or(B2=B1, C2=quot;DELETEDquot;),quot;-quot;, sum($A$1:$A1) 1)
gt;
gt;
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt; =================================
gt;
gt; quot;philipquot; gt; wrote in message
gt; ...
gt;gt; Hi is any one can help?? I need a formula can calculate the item no. ,if
gt;gt; the
gt;gt; column quot;cquot; show quot;deletedquot; or column quot;Bquot; show the same no. for the above
gt;gt; row,
gt;gt; the formula will skip to next item. sample as follow:-
gt;gt;
gt;gt; item no A B C
gt;gt; 1 8 8-TP$3B 200E-L-75-1
gt;gt; - 8 8-TP$4A DELETED
gt;gt; - 8 8-TP$4B DELETED
gt;gt; - 8 8-TP$5A 200E-L-75-1
gt;gt; 2 8 8-TP$5A 200E-L-75-1
gt;gt; - 8 8-TP$6A DELETED
gt;gt; - 8 8-TP$6B DELETED
gt;gt; - 8 8-TP$7A DELETED
gt;gt; - 8 8-TP$7B DELETED
gt;gt; - 8 8-TP$8A DELETED
gt;gt; - 8 8-TP$8B DELETED
gt;gt; 3 8 8-TP$9 200E-L-75-1
gt;gt; - 8 8-TP$10A DELETED
gt;gt; - 8 8-TP$10B DELETED
gt;gt; - 8 8-TP$11A DELETED
gt;gt; - 8 8-TP$11B DELETED
gt;gt; 4 8 8-TP$12A 200E-L-75-1
gt;gt;
gt;gt; Many thanks
gt;gt; philip
gt;gt;
gt;gt;
gt;
gt;
thanks fro advise however,
I try both formula, it doesn't work
start at row A12
=IF(OR(C12=C11,AI12=quot;Deletedquot;),quot;-quot;,SUM($A$6:$A12) 1)
or
=IF(OR(C12=C11,AI12=quot;Deletedquot;),quot;-quot;,COUNT($A$6:$A12) 1)

am I missing something ...??

please advise

quot;AndyBquot; wrote:

gt; I think Daniel means COUNT at the end, not SUM.
gt;
gt; Andy.
gt;
gt; quot;Daniel CHENquot; gt; wrote in message
gt; ...
gt; gt; Use formlua like this
gt; gt; lt;starting from row 2gt;
gt; gt; if(or(B2=B1, C2=quot;DELETEDquot;),quot;-quot;, sum($A$1:$A1) 1)
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Best regards,
gt; gt; ---
gt; gt; Yongjun CHEN
gt; gt; =================================
gt; gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; gt; - - - - www.XLDataSoft.com - - - -
gt; gt; Free Excel-Based Data Processing Tool is Available for Download
gt; gt; =================================
gt; gt;
gt; gt; quot;philipquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hi is any one can help?? I need a formula can calculate the item no. ,if
gt; gt;gt; the
gt; gt;gt; column quot;cquot; show quot;deletedquot; or column quot;Bquot; show the same no. for the above
gt; gt;gt; row,
gt; gt;gt; the formula will skip to next item. sample as follow:-
gt; gt;gt;
gt; gt;gt; item no A B C
gt; gt;gt; 1 8 8-TP$3B 200E-L-75-1
gt; gt;gt; - 8 8-TP$4A DELETED
gt; gt;gt; - 8 8-TP$4B DELETED
gt; gt;gt; - 8 8-TP$5A 200E-L-75-1
gt; gt;gt; 2 8 8-TP$5A 200E-L-75-1
gt; gt;gt; - 8 8-TP$6A DELETED
gt; gt;gt; - 8 8-TP$6B DELETED
gt; gt;gt; - 8 8-TP$7A DELETED
gt; gt;gt; - 8 8-TP$7B DELETED
gt; gt;gt; - 8 8-TP$8A DELETED
gt; gt;gt; - 8 8-TP$8B DELETED
gt; gt;gt; 3 8 8-TP$9 200E-L-75-1
gt; gt;gt; - 8 8-TP$10A DELETED
gt; gt;gt; - 8 8-TP$10B DELETED
gt; gt;gt; - 8 8-TP$11A DELETED
gt; gt;gt; - 8 8-TP$11B DELETED
gt; gt;gt; 4 8 8-TP$12A 200E-L-75-1
gt; gt;gt;
gt; gt;gt; Many thanks
gt; gt;gt; philip
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;