Ta bort specifika rader i Excel genom formel eller annan lösning

[Pär K]

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CKRISTO%7E1.WEL%5CLOKALA%7E1%5CTemp%5Cmsohtml1%5C11%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Normal tabell"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hej,
<o> </o>
Är det någon som skulle kunna hjälpa mig med följande specifika problem. Jag exporterar data från vårt system för inköp till en Excel-fil. När jag gör detta får jag in X-antal oönskade rader med Summa+ett tal som jag skulle vilja filtrera bort eller deletea i Excel (jag vill inte göra detta ”manuellt” för det är för många rader) . Tyvärr finns det ingen möjlighet att ta bort denna summa rad i är vårt system för inköp (Hogia) innan man sparar ner dokumentet som en Excel-fil. Se skärmdumpen nedan.


<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CKRISTO%7E1.WEL%5CLOKALA%7E1%5CTemp%5Cmsohtml1%5C12%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CDOCUME%7E1%5CKRISTO%7E1.WEL%5CLOKALA%7E1%5CTemp%5Cmsohtml1%5C12%5Cclip_editdata.mso"><!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:595.3pt 841.9pt; margin:70.85pt 70.85pt 70.85pt 70.85pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Normal tabell"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:453pt; height:139.5pt'> <v:imagedata src="file:///C:\DOCUME~1\KRISTO~1.WEL\LOKALA~1\Temp\msohtml1\12\clip_image001.png" o:title=""/> </v:shape><![endif]--><!--[if !vml]-->

<table x:str="" style="border-collapse: collapse; width: 458pt;" width="612" border="0" cellpadding="0" cellspacing="0"><col style="width: 74pt;" width="99"> <col style="width: 54pt;" width="72"> <col style="width: 78pt;" width="104"> <col style="width: 44pt;" width="59"> <col style="width: 35pt;" width="47"> <col style="width: 61pt;" width="81"> <col style="width: 35pt;" width="47"> <col style="width: 77pt;" width="103"> <tbody><tr style="height: 12.2pt;" height="16"> <td class="xl24" style="height: 12.2pt; width: 74pt;" width="99" height="16">Artikel 1</td> <td class="xl24" style="width: 54pt;" x:str="Kanna " width="72">Kanna </td> <td style="width: 78pt;" width="104"> </td> <td class="xl26" style="width: 44pt;" x:num="5" width="59">5</td> <td class="xl24" style="width: 35pt;" width="47">pc</td> <td class="xl26" style="width: 61pt;" x:num="5" width="81">5</td> <td class="xl24" style="width: 35pt;" width="47">SEK</td> <td class="xl29" style="width: 77pt;" x:num="36210" width="103">36 210</td> </tr> <tr style="height: 12.2pt;" height="16"> <td style="height: 12.2pt;" height="16"> </td> <td class="xl24"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr style="height: 11.45pt;" height="15"> <td class="xl25" style="height: 11.45pt;" height="15">Summa</td> <td> </td> <td> </td> <td> </td> <td> </td> <td class="xl27" x:num="5">5</td> <td> </td> <td> </td> </tr> <tr style="height: 12.2pt;" height="16"> <td class="xl24" style="height: 12.2pt;" height="16">Artikel 2</td> <td class="xl24" x:str="Lampa ">Lampa </td> <td> </td> <td class="xl31" x:num="30">30</td> <td class="xl24">pc</td> <td class="xl31" x:num="30">30</td> <td class="xl24">GBP</td> <td class="xl33" x:num="5037.45">5 037,45</td> </tr> <tr style="height: 12.2pt;" height="16"> <td style="height: 12.2pt;" height="16"> </td> <td class="xl24"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr style="height: 11.45pt;" height="15"> <td class="xl25" style="height: 11.45pt;" height="15">Summa</td> <td> </td> <td> </td> <td> </td> <td> </td> <td class="xl32" x:num="30">30</td> <td> </td> <td> </td> </tr> <tr style="height: 12.2pt;" height="16"> <td class="xl24" style="height: 12.2pt;" height="16">Artikel 3</td> <td class="xl24">Sko</td> <td> </td> <td class="xl28" x:num="1050">1050</td> <td class="xl24">pc</td> <td class="xl28" x:num="1050">1050</td> <td class="xl24">GBP</td> <td class="xl34" x:num="161762.25">161 762,25</td> </tr> <tr style="height: 12.2pt;" height="16"> <td style="height: 12.2pt;" height="16"> </td> <td class="xl24"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr style="height: 11.45pt;" height="15"> <td class="xl25" style="height: 11.45pt;" height="15">Summa</td> <td> </td> <td> </td> <td> </td> <td> </td> <td class="xl30" x:num="1050">1050</td> <td> </td> <td> </td> </tr> <tr style="height: 12.2pt;" height="16"> <td class="xl24" style="height: 12.2pt;" height="16">Artikel 4</td> <td class="xl24" x:str="Pinne ">Pinne </td> <td> </td> <td class="xl31" x:num="47">47</td> <td class="xl24">pc</td> <td class="xl31" x:num="47">47</td> <td class="xl24">GBP</td> <td class="xl35" x:num="80622.180000000008">80 622,18</td> </tr> <tr style="height: 12.2pt;" height="16"> <td style="height: 12.2pt;" height="16"> </td> <td class="xl24"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr style="height: 11.45pt;" height="15"> <td class="xl25" style="height: 11.45pt;" height="15">Summa</td> <td> </td> <td> </td> <td> </td> <td> </td> <td class="xl32" x:num="47">47</td> <td> </td> <td> </td> </tr> </tbody></table><!--[endif]-->
<o> </o>
Tacksam för hjälp,
<o> </o>
P

 

[fairwinds]

Hej och välkommen!

Använd Autofilter (Data - Filter...) och filtrera fram alla rader med Summa och deleta dem i ett svep.