correct total column in flitered list

This is a multi-part message in MIME format.

------=_NextPart_000_000D_01C75DB4.A3C658D0
Content-Type: text/plain;
	charset="windows-1256"
Content-Transfer-Encoding: quoted-printable

correct total column in filtered list

Dear friends,

I have a list(table in 2007) as bellow

      Serial
     Item Code
     Import
     Export
     Remain
    =20
      1
     10
     20
     =20
     20
    =20
      2
     20
     =20
     10
     10
    =20
      3
     10
     30
     =20
     40
    =20
      4
     30
     10
     =20
     50
    =20
      5
     20
     =20
     20
     30
    =20


note how last column (remain) is calculated (remain=3Dup =
remain+import-expor)
if i filter (itemcode) for 10 the remain column value not calculated on =
new condition (correct calculation but useful for me)
how can I implement last column calculation to get as bellow list?
      Serial
     Item Code(=3D10)
     Import
     Export
     Remain
    =20
      1
     10
     20
     =20
     20
    =20
      3
     10
     30
     =20
     50
    =20

Thanks
Tarvirdi

------=_NextPart_000_000D_01C75DB4.A3C658D0
Content-Type: text/html;
	charset="windows-1256"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1256">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>
<P><FONT face=3DArial size=3D2>correct total column in filtered =
list</FONT></P>
<P><FONT face=3DArial size=3D2>Dear friends,</FONT></P>
<P><FONT face=3DArial size=3D2>I have a list(table in 2007) as =
bellow</FONT></P>
<P><FONT face=3DArial size=3D2>
<TABLE class=3DMsoTableGrid=20
style=3D"BORDER-RIGHT: medium none; BORDER-TOP: medium none; =
BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: =
collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: =
text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0mm 5.4pt 0mm 5.4pt"=20
cellSpacing=3D0 cellPadding=3D0 border=3D1>
  <TBODY>
  <TR style=3D"mso-yfti-irow: 0; mso-yfti-firstrow: yes">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Serial<?xml:namespace prefix =3D o ns =3D=20
      "urn:schemas-microsoft-com:office:office" =
/><o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Item Code<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Import<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Export<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Remain<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 1">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>1<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 2">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>2<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 3">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>3<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>30<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>40<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 4">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>4<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>30<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>50<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 5; mso-yfti-lastrow: yes">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>5<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      =
face=3DCalibri>30<o:p></o:p></FONT></P></TD></TR></TBODY></TABLE></FONT><=
/P></DIV>
<DIV><FONT face=3DArial size=3D2>note how last column (remain) is =
calculated=20
(remain=3Dup remain+import-expor)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>if i filter (itemcode) for 10 the =
remain column=20
value not calculated on new condition (correct calculation but useful =
for=20
me)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>how can I implement last column =
calculation to get=20
as bellow list?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<TABLE class=3DMsoTableGrid=20
style=3D"BORDER-RIGHT: medium none; BORDER-TOP: medium none; =
BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: =
collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: =
text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0mm 5.4pt 0mm 5.4pt"=20
cellSpacing=3D0 cellPadding=3D0 border=3D1>
  <TBODY>
  <TR style=3D"mso-yfti-irow: 0; mso-yfti-firstrow: yes">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Serial<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Item Code(=3D10)<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Import<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Export<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>Remain<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 1">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>1<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>20<o:p></o:p></FONT></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 2; mso-yfti-lastrow: yes">
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
    vAlign=3Dtop width=3D127>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>3<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D119>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>10<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      face=3DCalibri>30<o:p></o:p></FONT></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D130>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
      face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

    vAlign=3Dtop width=3D132>
      <P class=3DMsoNormal style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: =
normal"><FONT=20
      =
face=3DCalibri>50<o:p></o:p></FONT></P></TD></TR></TBODY></TABLE></FONT><=
/DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Tarvirdi</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_000D_01C75DB4.A3C658D0--

0
mail8040 (4)
3/3/2007 1:24:42 PM
excel 39879 articles. 2 followers. Follow

4 Replies
630 Views

Similar Articles

[PageSpeed] 37

This is a multi-part message in MIME format.

------=_NextPart_000_00AD_01C75DA9.64F2D300
Content-Type: text/plain;
	charset="windows-1256"
Content-Transfer-Encoding: quoted-printable

Use the SUBTOTAL function.

--=20
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=3Des-es
EN: http://mvp.support.microsoft.com/?LN=3Den-us
Profile: =
https://mvp.support.microsoft.com/profile=3DAB32F8EE-8ED3-4AB9-ADDA-9E6C7=
3C09A36


  "Tarvirdi" <mail@tarvirdi.com> wrote in message =
news:O$nwidZXHHA.3984@TK2MSFTNGP02.phx.gbl...
  correct total column in filtered list

  Dear friends,

  I have a list(table in 2007) as bellow

        Serial
       Item Code
       Import
       Export
       Remain
      =20
        1
       10
       20
       =20
       20
      =20
        2
       20
       =20
       10
       10
      =20
        3
       10
       30
       =20
       40
      =20
        4
       30
       10
       =20
       50
      =20
        5
       20
       =20
       20
       30
      =20


  note how last column (remain) is calculated (remain=3Dup =
remain+import-expor)
  if i filter (itemcode) for 10 the remain column value not calculated =
on new condition (correct calculation but useful for me)
  how can I implement last column calculation to get as bellow list?
        Serial
       Item Code(=3D10)
       Import
       Export
       Remain
      =20
        1
       10
       20
       =20
       20
      =20
        3
       10
       30
       =20
       50
      =20

  Thanks
  Tarvirdi

------=_NextPart_000_00AD_01C75DA9.64F2D300
Content-Type: text/html;
	charset="windows-1256"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1256">
<META content=3D"MSHTML 6.00.6000.16397" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Use the SUBTOTAL function.</FONT></DIV>
<DIV><BR>-- <BR>KL<BR>[MVP - Microsoft Excel]<BR>RU: <A=20
href=3D"http://www.mvps.ru/Program/Default.aspx">http://www.mvps.ru/Progr=
am/Default.aspx</A><BR>ES:=20
<A=20
href=3D"http://mvp.support.microsoft.com/?LN=3Des-es">http://mvp.support.=
microsoft.com/?LN=3Des-es</A><BR>EN:=20
<A=20
href=3D"http://mvp.support.microsoft.com/?LN=3Den-us">http://mvp.support.=
microsoft.com/?LN=3Den-us</A><BR>Profile:=20
<A=20
href=3D"https://mvp.support.microsoft.com/profile=3DAB32F8EE-8ED3-4AB9-AD=
DA-9E6C73C09A36">https://mvp.support.microsoft.com/profile=3DAB32F8EE-8ED=
3-4AB9-ADDA-9E6C73C09A36</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Tarvirdi" &lt;<A=20
  href=3D"mailto:mail@tarvirdi.com">mail@tarvirdi.com</A>&gt; wrote in =
message <A=20
  =
href=3D"news:O$nwidZXHHA.3984@TK2MSFTNGP02.phx.gbl">news:O$nwidZXHHA.3984=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>
  <DIV>
  <P><FONT face=3DArial size=3D2>correct total column in filtered =
list</FONT></P>
  <P><FONT face=3DArial size=3D2>Dear friends,</FONT></P>
  <P><FONT face=3DArial size=3D2>I have a list(table in 2007) as =
bellow</FONT></P>
  <P><FONT face=3DArial size=3D2>
  <TABLE class=3DMsoTableGrid=20
  style=3D"BORDER-RIGHT: medium none; BORDER-TOP: medium none; =
BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: =
collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: =
text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0mm 5.4pt 0mm 5.4pt"=20
  cellSpacing=3D0 cellPadding=3D0 border=3D1>
    <TBODY>
    <TR style=3D"mso-yfti-irow: 0; mso-yfti-firstrow: yes">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Serial<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT =
face=3DCalibri>Item=20
        Code<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Import<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Export<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Remain<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 1">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>1<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 2">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>2<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 3">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>3<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>30<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>40<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 4">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>4<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>30<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>50<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 5; mso-yfti-lastrow: yes">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>5<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        =
face=3DCalibri>30<o:p></o:p></FONT></P></TD></TR></TBODY></TABLE></FONT><=
/P></DIV>
  <DIV><FONT face=3DArial size=3D2>note how last column (remain) is =
calculated=20
  (remain=3Dup remain+import-expor)</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>if i filter (itemcode) for 10 the =
remain column=20
  value not calculated on new condition (correct calculation but useful =
for=20
  me)</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>how can I implement last column =
calculation to=20
  get as bellow list?</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>
  <TABLE class=3DMsoTableGrid=20
  style=3D"BORDER-RIGHT: medium none; BORDER-TOP: medium none; =
BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: =
collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: =
text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0mm 5.4pt 0mm 5.4pt"=20
  cellSpacing=3D0 cellPadding=3D0 border=3D1>
    <TBODY>
    <TR style=3D"mso-yfti-irow: 0; mso-yfti-firstrow: yes">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Serial<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT =
face=3DCalibri>Item=20
        Code(=3D10)<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Import<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Export<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1"=20
      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>Remain<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 1">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>1<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>20<o:p></o:p></FONT></P></TD></TR>
    <TR style=3D"mso-yfti-irow: 2; mso-yfti-lastrow: yes">
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: black 1pt solid; WIDTH: 95.4pt; PADDING-TOP: 0mm; =
BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid black .5pt; mso-border-themecolor: text1; =
mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1"=20
      vAlign=3Dtop width=3D127>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>3<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 89.35pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D119>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>10<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.85pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        face=3DCalibri>30<o:p></o:p></FONT></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 97.45pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D130>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><o:p><FONT=20
        face=3DCalibri>&nbsp;</FONT></o:p></P></TD>
      <TD=20
      style=3D"BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0mm; =
BORDER-LEFT: #ece9d8; WIDTH: 98.75pt; PADDING-TOP: 0mm; BORDER-BOTTOM: =
black 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid =
black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid =
black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid =
black .5pt; mso-border-top-themecolor: text1; =
mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1" =

      vAlign=3Dtop width=3D132>
        <P class=3DMsoNormal=20
        style=3D"MARGIN: 0mm 0mm 0pt; LINE-HEIGHT: normal"><FONT=20
        =
face=3DCalibri>50<o:p></o:p></FONT></P></TD></TR></TBODY></TABLE></FONT><=
/DIV>
  <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>Tarvirdi</FONT></DIV>
  <DIV><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_00AD_01C75DA9.64F2D300--

0
3/3/2007 2:34:12 PM
Thanks,
But SUBTOTAL is useful for bottom total not for column(remain)
if I mistake please describe and help me to write the function
thanks again 


0
mail8040 (4)
3/4/2007 4:59:04 AM
if Import in column C, Export in column D, and Remain in column E,
then put a formula below in E2

=SUBTOTAL(9,C$2:C2)-SUBTOTAL(9,D$2:D2)

and copy it down to e.g. E6

keizi

"Tarvirdi" <mail@tarvirdi.com> wrote in message 
news:%23TVHanhXHHA.4264@TK2MSFTNGP05.phx.gbl...
> Thanks,
> But SUBTOTAL is useful for bottom total not for column(remain)
> if I mistake please describe and help me to write the function
> thanks again
> 

0
kounoike1 (60)
3/4/2007 8:56:17 AM
thanks, it works 


0
mail8040 (4)
3/4/2007 10:35:03 AM
Reply:

Similar Artilces:

Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins?
I've been fiddling and fiddling for some time now this evening but I seem to be missing something completely today. In the past I've dealt with adding/subtracting times formatted the same way as the end results, so they've worked from the get-go. In today's case, I have a spreadsheet that I'm using to calculate best fits for movies transferred from VHS to DVD via a DVD Recorder. My DVD Recorder deals with hours and minutes but my internet source gives total running time in minutes only. How do I get Excel 2000 to add up a column of minutes and then give the results in a...

Payroll corrections after Payroll Year is closed
I have a client who closed their payroll year and issued W2s. Now, they've realized that because the last payroll of 2008 was printed on 12/31 but not distributed until January 2nd, it needs to fall into 2009 for wage reporting purposes. My first thought to correct this was to void the checks from the last payroll and re-issue them but I've discovered GP won't let you do this once the payroll year has been closed. Has anyone ever run into this scenario and if so, how was it corrected? Thx, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www....

OE Blocked Senders List #2
In Outlook Express 6.0 in Win XP, after I entered a blocked sender to the list, it is no longer there after I reboot or open OE 6 the next day. I do see the names in the Regedit File under Mail etc. Do I need to set some sort of code to keep the block senders list? .. TEC <anonymous@discussions.microsoft.com> wrote: > In Outlook Express 6.0 in Win XP, after I entered a > blocked sender to the list, it is no longer there after I > reboot or open OE 6 the next day. I do see the names in > the Regedit File under Mail etc. Do I need to set some > sort of code to...

Replace data in a column
Okay, I have a column that has text in it. I want to change all these to the Identifying number that is found in a different table. So how do I do this? Example: Current table has: A 1 First name 2 New first name 3 Another first name Need to change the A column in first table to the correspoding column in this table: A B 1 12 First name 2 15 New first name 3 22 Another first name So after the switch either I need a new column in the current table so it look like the second column (there might be more then one match in the current t...

Taste corrective patch
--zncknrruviimfhh Content-Type: multipart/related; boundary="nqkfxcjees"; type="multipart/alternative" --nqkfxcjees Content-Type: multipart/alternative; boundary="iqpjepqzbj" --iqpjepqzbj Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Partner this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to protect your...

validation column
Hi all, I have a problem to make validation to prevent duplication value in column. Suppose I have arrays of data in column A (Employee ID) that contains values, i want to no duplication value when i entering new data. If i entered the same value as previous row then error message should be alert. Any body can help what should the formula function applied. Thanks in advance. cheers. Select all of column A. Assuming A1 is active, use Data/Validation, Select Custom, enter =COUNTIF(A:A,A1)=1 then put in your error message. Bob Umlas Excel MVP "benny" <bharijan@sampoerna.co.id&...

Watch this corrective update that came from Microsoft Corporation
--onkdsuysvvng Content-Type: multipart/related; boundary="bfbhdbklwehwbiu"; type="multipart/alternative" --bfbhdbklwehwbiu Content-Type: multipart/alternative; boundary="ampkwllbdcvecaddz" --ampkwllbdcvecaddz Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Consumer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install n...

subtotals/totals from SQL statement
Access 03/WinXP I am using a function to generate an SQL statement based on several user-defined filters from a form. This SQL statement is used as the record source in the OnOpen statement of the report property. I have no problems with the SQL statement, filters, etc. - the report displays exactly the records requested. Where I am having an issue in the the report's group subtotals and the report totals; the amounts calculated are the totals for the *entire* underlying table of the initial SQL statement from the function and *not* the filtered set of records. I tried using th...

Distribution list #41
I have a distribution list in outlook 2007 but if I want to add further contacts in the future how do i do it please only i cant find it in the help. TIA Open the DL Select Members -- Russ Valentine [MVP-Outlook] "PWB" <pwbutt@googlemail.com> wrote in message news:uYAWi.1986$pg.936@newsfe6-win.ntli.net... >I have a distribution list in outlook 2007 but if I want to add further >contacts in the future how do i do it please only i cant find it in the >help. TIA > ...

Find first non-blank or non-zero in a column of data
I have my data in, say row A - specifically A1:A50 - and want my calculation to look from the bottom of A50 to the top of the row (A1) and return the first non-blank OR the first non-zero within that data. What is the best way to do this? E.g. A1 = 4 A2 = 3 A3 = 0 A4 = blank cell A5 = blank cell Answer would be 3 as it looks from the bottom. Many thanks, Jim Jim, If it is just numbers, use =INDEX(A:A,MATCH(9.99999999999999E307,A:A)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "DerbyJim" <DerbyJim@discussions.microsoft.com> wrote ...

Export from 2000 to 2008
I did an export of data from 2000 to 2008, all the tables and data copied over with the exception of the Identity attribute. (which is the auto number feature). This is not good, I tried to manually do it and it says that I need to drop and recreate table. This poses an issue given all data I have in the table and that needs to be imported over. What am I missing? MOCK (MOCK@discussions.microsoft.com) writes: > I did an export of data from 2000 to 2008, all the tables and data > copied over with the exception of the Identity attribute. (which is the > auto number fe...

sync list with SharePoint is greyed out
I link a spreadsheet to a SharePoint document library. Everytime I go to synchronize list the option is greyed out. I am able to retrieve from the sharepoint list, i just can't post. What am I doing wrong. Thanks, Mike ...

Emails correct sent?
Hallo, Sometimes when i am forwarding a mail to somebody the mail in the map "messages send" is seen as send to myself? So, i am not sure if the person has really received the mail. Regards Huib That is an indication that a problem occurred during the send(process interrupted by user, the ISP, or an AV client are a few of the causes) - The message may have been sent and received(only the recipient can verify if delivered). - WLM creates that message in that form just in case you need to recover the contents and recreate the message -- ...winston ms-mv...

user not in global address list
I created a new user using Active Directory Users and Computer and created an email address, but is not showing in th global address list, it used to work before, Please help "cacho" <anonymous@discussions.microsoft.com> wrote: >I created a new user using Active Directory Users and >Computer and created an email address, but is not showing >in th global address list, it used to work before, > >Please help The first thing is a little patience, but if you've waited as long as you normally do then check the default email addresses have been created. Then...

disappearing columns
I have a workbook on the network that is shared by three people and myself and it consists of four worksheets. When I open the workbook it opens to the first sheet. The first couple of seconds as Excel loads all the data, focus is on the first sheet and I see all the columns that I expect to see. As soon as the hourglass goes away it is as if I had deleted columns 4 and everything to the right of it shifts to the left. If I reopen the spreadsheet, I get the same behaviour everytime I reopen it. If I remove the share on the worksheet then the column that keeps "disappearing" is go...

Charting: Displaying cumulative totals at top of stacked columns
Hi, I'm having some trouble displaying the cumulative total at the TOP of each of my two stacked columns. Right now, only one of the columns have the total value on top while the other one has it in the middle. To be more specific, this is the exact scenario: I'm trying to graph the revenue data of 2005 and expected of 2009. So there are two stacked columns in this graph. And these columns can be stacked by different product revenues. I want to show the cumulative total of each stacked column, but the shorter 2005 column displays the total value half-way up the column inst...

Import auto correct to Word 2007
I am a lousy typist. I am switching from Word 2003 to Word 2007. Is there a simple way a non tech guy like me can export my auto correct setting to Word 2007 without risking screwing up everything? The simpler the solution, the more grateful I will be! Thanks. Hello, On 2010.01.21 17:38, in article 9F0A4A5F-9136-4F3C-8079-520E1A1D93E5@microsoft.com, "ShivN" <ShivN@discussions.microsoft.com> wrote: > I am a lousy typist. I am switching from Word 2003 to Word 2007. Is there a > simple way a non tech guy like me can export my auto correct setting to Word...

how to sum up qty totals for non-duplicate values ?
Hi, Do you know in EXCEL how can I sum up the total Order Qty base on only the "unique" PartNumber ? Any help is very much appreciated. Thank you. Any help is very much appreciated. Thank you. PartNumber unique/duplicate PN? Order Qty Total Order Qty 7050905500 unique 2 10 7050905500 duplicata 3 7050905500 duplicate 5 7051605400 unique 1 1 0010-01419 unique 4 8 0010-01419 duplicate 4 ----------...

Sorting from a list with data on different cells
Hi, How can sort alphabetically a list of data present on different cells. Ex: A6 = Scott A10 = John A14 = Abrahim I am creating a call log list. with clientname, Date and messages fields. There can be one client name, multiple dates and messages rtelated to each date. Ex: Scott 6.6.05 Test msg 6.7.05 called again John 1.1.05 adfasfda Now I want to sort by the client name. Now I want this list to be sorted without breaking the cloumns next to it. Can this be done? Also how can I make the message field automatically expand if mor...

Adding running total to union query
I posted this before and thought I had a solution. Unfortunately, it became too large and I received a "Query is too complex" error, so now I'd like to try a different approach... I have created a Union Query to consolidate results from separate queries, each one of which represents results for a single month: SELECT ReportMonth, MonthlyRev, MonthlyCost FROM qryMonth1Total UNION SELECT ReportMonth, MonthlyRev, MonthlyCost FROM qryMonth2Total UNION SELECT ReportMonth, MonthlyRev, MonthlyCost FROM qryMonth3Total; etc. (12 months total) This gives me the following results: ...

Want file title listing as in Excel 5.0 File>Find
The File>Find display in Excel 5.0 was great for me. I have many files with similar names but File>Find would display them, one per line, _with their titles_. This made file selection a breeze because I could scan dozens of file titles at a time. In later versions of Excel, File>Open displays a lame Explorer bo that only displays the file title of the currently highlighted file. I other words, only one title can be read at a time, making scanning 150 files very difficult. Are there add-ins or other solutions to regain this crucial feature? I want to move on to newer versions ...

Column A to change font color if column B is not empty
Hi, I'd like to have column A of a sheet to automatically turn to red font when a cell in column B is entered,ie, the Cell A3 will change from red to black when B3 is entered and B3 is a date. Can it be done? Thanks & Regards, Val Hi try: - select cells A3:A10 - goto 'Format - Conditional format' - enter the formula =$B3<>"" - choose a format -- Regards Frank Kabel Frankfurt, Germany dolphinv4 wrote: > Hi, > > I'd like to have column A of a sheet to automatically > turn to red font when a cell in column B is entered,ie, > the Cell ...

correction
What is process "tkupd32.exe"? Safe to end process? It's pegging my processor at 100% utilization. Thx. Looks like it is something to do with Groupshield, and there is a hotfix: http://ktp.e-isa.com/Downloads/McAfee/Patches/GroupShield/Hotfix7.txt -- Mark Fugatt Microsoft Exchange MVP www.exchangetrainer.com www.msexchange.org "jallen" <anonymous@discussions.microsoft.com> wrote in message news:08e501c3c963$a59beaf0$a401280a@phx.gbl... > What is process "tkupd32.exe"? Safe to end process? It's > pegging my processor at 100% utilization. ...

Return to column A
Hello I am entering information in cells A - J and then using the mouse to click on cell A in the next row. Please can anyone tell me if there is there a quick way to go back to A to insert the next set of information. Thank you Press the HOME key -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------�------------------------------�---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------�------------------------------�---------------- ...

Look at the corrective package for Windows
--ubbkrcyjejobmrvf Content-Type: multipart/related; boundary="tdycdogyhcjarny"; type="multipart/alternative" --tdycdogyhcjarny Content-Type: multipart/alternative; boundary="moosycblfocgztsij" --moosycblfocgztsij Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabiliti...