{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Ark1","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ark1","index":0,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Postkode","Dato","Bilags nr.","Konto nr.","Konto navn","Beløb"]
[null,null,100,null,null,100]
[2,"2016-02-02",{"$f":"C2+1","v":101},10,"tekst 1",{"$f":"F2+25","v":125}]
[2,"2016-02-03",{"$f":"C3+1","v":102},20,"tekst 2",{"$f":"F3+25","v":150}]
[2,"2016-02-04",103,30,"tekst 3",175]
[2,"2016-02-05",104,40,"tekst 4",200]
[2,"2016-02-06",105,50,"tekst 5",225]
[2,"2016-02-07",106,60,"tekst 6",250]
[2,"2016-02-08",107,70,"tekst 7",275,null,"Forsøgs opstilling"]
[2,"2016-02-09",108,10,"tekst 8",300]
[2,"2016-02-10",109,20,"tekst 9",325]
[2,"2016-02-11",110,30,"tekst 10",350]
[2,"2016-02-12",111,40,"tekst 11",375]
[2,"2016-02-13",112,50,"tekst 12",400]
[2,"2016-02-14",113,60,"tekst 13",425]
[2,"2016-02-15",114,70,"tekst 14",450]
[2,"2016-02-16",115,10,"tekst 15",475]
[2,"2016-02-17",116,10,"tekst 16",500]
[2,"2016-02-18",117,70,"tekst 17",525]
[2,"2016-02-19",118,20,"tekst 18",550]
[2,"2016-02-20",119,30,"tekst 19",575]
[2,"2016-02-21",120,40,"tekst 20",600]
[2,"2016-02-22",121,50,"tekst 21",625]
[]
["I det aktuelle program, strækker området fra række 14 til 750, det er mange rækker at sammenligne."]
[]
["Der er 11 hovedkonti for delt på følgende måde;  ",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
["Hovedkonto nr. 1000 fordelt med 15 underkontoer  med et spring på 10 = ",null,null,null,null,null,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000,11000]
[null,null,null,null,null,null,{"$f":"G28+10","v":1010},{"$f":"H28+10","v":2010},{"$f":"I28+10","v":3010},4010,5010,6010,7010,8010,9010,10010,11010]
[null,null,null,null,null,null,{"$f":"G29+10","v":1020},{"$f":"H29+10","v":2020},3020,4020,5020,6020,7020,8020,9020,10020,11020]
[null,null,null,null,null,null,1030,2030,3030,4030,5030,6030,7030,8030,9030,10030,11030]
[null,null,null,null,null,null,1040,2040,3040,4040,5040,6040,7040,8040,9040,10040,11040]
[null,null,null,null,null,null,1050,2050,3050,4050,5050,6050,7050,8050,9050,10050,11050]
[null,null,null,null,null,null,1060,2060,3060,4060,5060,6060,7060,8060,9060,10060,11060]
[null,null,null,null,null,null,1070,2070,3070,4070,5070,6070,7070,8070,9070,10070,11070]
[null,null,null,null,null,null,1080,2080,3080,4080,5080,6080,7080,8080,9080,10080,11080]
[null,null,null,null,null,null,1090,2090,3090,4090,5090,6090,7090,8090,9090,10090,11090]
[null,null,null,null,null,null,1100,2100,3100,4100,5100,6100,7100,8100,9100,10100,11100]
[null,null,null,null,null,null,1110,2110,3110,4110,5110,6110,7110,8110,9110,10110,11110]
[null,null,null,null,null,null,1120,2120,3120,4120,5120,6120,7120,8120,9120,10120,11120]
[null,null,null,null,null,null,1130,2130,3130,4130,5130,6130,7130,8130,9130,10130,11130]
[null,null,null,null,null,null,1140,2140,3140,4140,5140,6140,7140,8140,9140,10140,11140]
[null,null,null,null,null,null,1150,2150,3150,4150,5150,6150,7150,8150,9150,10150,11150]

{"sheet":"Ark2","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Indsæt underkonto nr. -->",20]
[]
["Postkode","Dato","Bilags nr.","Konto nr.","Konto navn","Beløb"]
[{"$f":"IF(D4<>\" \",'Ark1'!A3,\" \")","v":" "},{"$f":"IF(D4<>\" \",'Ark1'!B3,\" \")","v":" "},{"$f":"IF(D4<>\" \",'Ark1'!C3,\" \")","v":" "},{"$f":"IF('Ark1'!D3='Ark2'!$F$1,'Ark1'!D3,\" \")","v":" "},{"$f":"IF(D4<>\" \",'Ark1'!E3,\" \")","v":" "},{"$f":"IF(D4<>\" \",'Ark1'!F3,\" \")","v":" "}]
[{"$f":"IF(D5<>\" \",'Ark1'!A4,\" \")","v":2},{"$f":"IF(D5<>\" \",'Ark1'!B4,\" \")","v":"2016-02-03"},{"$f":"IF(D5<>\" \",'Ark1'!C4,\" \")","v":102},{"$f":"IF('Ark1'!D4='Ark2'!$F$1,'Ark1'!D4,\" \")","v":20},{"$f":"IF(D5<>\" \",'Ark1'!E4,\" \")","v":"tekst 2"},{"$f":"IF(D5<>\" \",'Ark1'!F4,\" \")","v":150}]
[{"$f":"IF(D6<>\" \",'Ark1'!A5,\" \")","v":" "},{"$f":"IF(D6<>\" \",'Ark1'!B5,\" \")","v":" "},{"$f":"IF(D6<>\" \",'Ark1'!C5,\" \")","v":" "},{"$f":"IF('Ark1'!D5='Ark2'!$F$1,'Ark1'!D5,\" \")","v":" "},{"$f":"IF(D6<>\" \",'Ark1'!E5,\" \")","v":" "},{"$f":"IF(D6<>\" \",'Ark1'!F5,\" \")","v":" "}]
[{"$f":"IF(D7<>\" \",'Ark1'!A6,\" \")","v":" "},{"$f":"IF(D7<>\" \",'Ark1'!B6,\" \")","v":" "},{"$f":"IF(D7<>\" \",'Ark1'!C6,\" \")","v":" "},{"$f":"IF('Ark1'!D6='Ark2'!$F$1,'Ark1'!D6,\" \")","v":" "},{"$f":"IF(D7<>\" \",'Ark1'!E6,\" \")","v":" "},{"$f":"IF(D7<>\" \",'Ark1'!F6,\" \")","v":" "}]
[{"$f":"IF(D8<>\" \",'Ark1'!A7,\" \")","v":" "},{"$f":"IF(D8<>\" \",'Ark1'!B7,\" \")","v":" "},{"$f":"IF(D8<>\" \",'Ark1'!C7,\" \")","v":" "},{"$f":"IF('Ark1'!D7='Ark2'!$F$1,'Ark1'!D7,\" \")","v":" "},{"$f":"IF(D8<>\" \",'Ark1'!E7,\" \")","v":" "},{"$f":"IF(D8<>\" \",'Ark1'!F7,\" \")","v":" "}]
[{"$f":"IF(D9<>\" \",'Ark1'!A8,\" \")","v":" "},{"$f":"IF(D9<>\" \",'Ark1'!B8,\" \")","v":" "},{"$f":"IF(D9<>\" \",'Ark1'!C8,\" \")","v":" "},{"$f":"IF('Ark1'!D8='Ark2'!$F$1,'Ark1'!D8,\" \")","v":" "},{"$f":"IF(D9<>\" \",'Ark1'!E8,\" \")","v":" "},{"$f":"IF(D9<>\" \",'Ark1'!F8,\" \")","v":" "}]
[{"$f":"IF(D10<>\" \",'Ark1'!A9,\" \")","v":" "},{"$f":"IF(D10<>\" \",'Ark1'!B9,\" \")","v":" "},{"$f":"IF(D10<>\" \",'Ark1'!C9,\" \")","v":" "},{"$f":"IF('Ark1'!D9='Ark2'!$F$1,'Ark1'!D9,\" \")","v":" "},{"$f":"IF(D10<>\" \",'Ark1'!E9,\" \")","v":" "},{"$f":"IF(D10<>\" \",'Ark1'!F9,\" \")","v":" "}]
[{"$f":"IF(D11<>\" \",'Ark1'!A10,\" \")","v":" "},{"$f":"IF(D11<>\" \",'Ark1'!B10,\" \")","v":" "},{"$f":"IF(D11<>\" \",'Ark1'!C10,\" \")","v":" "},{"$f":"IF('Ark1'!D10='Ark2'!$F$1,'Ark1'!D10,\" \")","v":" "},{"$f":"IF(D11<>\" \",'Ark1'!E10,\" \")","v":" "},{"$f":"IF(D11<>\" \",'Ark1'!F10,\" \")","v":" "}]
[{"$f":"IF(D12<>\" \",'Ark1'!A11,\" \")","v":2},{"$f":"IF(D12<>\" \",'Ark1'!B11,\" \")","v":"2016-02-10"},{"$f":"IF(D12<>\" \",'Ark1'!C11,\" \")","v":109},{"$f":"IF('Ark1'!D11='Ark2'!$F$1,'Ark1'!D11,\" \")","v":20},{"$f":"IF(D12<>\" \",'Ark1'!E11,\" \")","v":"tekst 9"},{"$f":"IF(D12<>\" \",'Ark1'!F11,\" \")","v":325}]
[{"$f":"IF(D13<>\" \",'Ark1'!A12,\" \")","v":" "},{"$f":"IF(D13<>\" \",'Ark1'!B12,\" \")","v":" "},{"$f":"IF(D13<>\" \",'Ark1'!C12,\" \")","v":" "},{"$f":"IF('Ark1'!D12='Ark2'!$F$1,'Ark1'!D12,\" \")","v":" "},{"$f":"IF(D13<>\" \",'Ark1'!E12,\" \")","v":" "},{"$f":"IF(D13<>\" \",'Ark1'!F12,\" \")","v":" "}]
[{"$f":"IF(D14<>\" \",'Ark1'!A13,\" \")","v":" "},{"$f":"IF(D14<>\" \",'Ark1'!B13,\" \")","v":" "},{"$f":"IF(D14<>\" \",'Ark1'!C13,\" \")","v":" "},{"$f":"IF('Ark1'!D13='Ark2'!$F$1,'Ark1'!D13,\" \")","v":" "},{"$f":"IF(D14<>\" \",'Ark1'!E13,\" \")","v":" "},{"$f":"IF(D14<>\" \",'Ark1'!F13,\" \")","v":" "}]
[{"$f":"IF(D15<>\" \",'Ark1'!A14,\" \")","v":" "},{"$f":"IF(D15<>\" \",'Ark1'!B14,\" \")","v":" "},{"$f":"IF(D15<>\" \",'Ark1'!C14,\" \")","v":" "},{"$f":"IF('Ark1'!D14='Ark2'!$F$1,'Ark1'!D14,\" \")","v":" "},{"$f":"IF(D15<>\" \",'Ark1'!E14,\" \")","v":" "},{"$f":"IF(D15<>\" \",'Ark1'!F14,\" \")","v":" "}]
[{"$f":"IF(D16<>\" \",'Ark1'!A15,\" \")","v":" "},{"$f":"IF(D16<>\" \",'Ark1'!B15,\" \")","v":" "},{"$f":"IF(D16<>\" \",'Ark1'!C15,\" \")","v":" "},{"$f":"IF('Ark1'!D15='Ark2'!$F$1,'Ark1'!D15,\" \")","v":" "},{"$f":"IF(D16<>\" \",'Ark1'!E15,\" \")","v":" "},{"$f":"IF(D16<>\" \",'Ark1'!F15,\" \")","v":" "}]
[{"$f":"IF(D17<>\" \",'Ark1'!A16,\" \")","v":" "},{"$f":"IF(D17<>\" \",'Ark1'!B16,\" \")","v":" "},{"$f":"IF(D17<>\" \",'Ark1'!C16,\" \")","v":" "},{"$f":"IF('Ark1'!D16='Ark2'!$F$1,'Ark1'!D16,\" \")","v":" "},{"$f":"IF(D17<>\" \",'Ark1'!E16,\" \")","v":" "},{"$f":"IF(D17<>\" \",'Ark1'!F16,\" \")","v":" "}]
[{"$f":"IF(D18<>\" \",'Ark1'!A17,\" \")","v":" "},{"$f":"IF(D18<>\" \",'Ark1'!B17,\" \")","v":" "},{"$f":"IF(D18<>\" \",'Ark1'!C17,\" \")","v":" "},{"$f":"IF('Ark1'!D17='Ark2'!$F$1,'Ark1'!D17,\" \")","v":" "},{"$f":"IF(D18<>\" \",'Ark1'!E17,\" \")","v":" "},{"$f":"IF(D18<>\" \",'Ark1'!F17,\" \")","v":" "}]
[{"$f":"IF(D19<>\" \",'Ark1'!A18,\" \")","v":" "},{"$f":"IF(D19<>\" \",'Ark1'!B18,\" \")","v":" "},{"$f":"IF(D19<>\" \",'Ark1'!C18,\" \")","v":" "},{"$f":"IF('Ark1'!D18='Ark2'!$F$1,'Ark1'!D18,\" \")","v":" "},{"$f":"IF(D19<>\" \",'Ark1'!E18,\" \")","v":" "},{"$f":"IF(D19<>\" \",'Ark1'!F18,\" \")","v":" "}]
[{"$f":"IF(D20<>\" \",'Ark1'!A19,\" \")","v":" "},{"$f":"IF(D20<>\" \",'Ark1'!B19,\" \")","v":" "},{"$f":"IF(D20<>\" \",'Ark1'!C19,\" \")","v":" "},{"$f":"IF('Ark1'!D19='Ark2'!$F$1,'Ark1'!D19,\" \")","v":" "},{"$f":"IF(D20<>\" \",'Ark1'!E19,\" \")","v":" "},{"$f":"IF(D20<>\" \",'Ark1'!F19,\" \")","v":" "}]
[{"$f":"IF(D21<>\" \",'Ark1'!A20,\" \")","v":2},{"$f":"IF(D21<>\" \",'Ark1'!B20,\" \")","v":"2016-02-19"},{"$f":"IF(D21<>\" \",'Ark1'!C20,\" \")","v":118},{"$f":"IF('Ark1'!D20='Ark2'!$F$1,'Ark1'!D20,\" \")","v":20},{"$f":"IF(D21<>\" \",'Ark1'!E20,\" \")","v":"tekst 18"},{"$f":"IF(D21<>\" \",'Ark1'!F20,\" \")","v":550}]
[{"$f":"IF(D22<>\" \",'Ark1'!A21,\" \")","v":" "},{"$f":"IF(D22<>\" \",'Ark1'!B21,\" \")","v":" "},{"$f":"IF(D22<>\" \",'Ark1'!C21,\" \")","v":" "},{"$f":"IF('Ark1'!D21='Ark2'!$F$1,'Ark1'!D21,\" \")","v":" "},{"$f":"IF(D22<>\" \",'Ark1'!E21,\" \")","v":" "},{"$f":"IF(D22<>\" \",'Ark1'!F21,\" \")","v":" "}]
[{"$f":"IF(D23<>\" \",'Ark1'!A22,\" \")","v":" "},{"$f":"IF(D23<>\" \",'Ark1'!B22,\" \")","v":" "},{"$f":"IF(D23<>\" \",'Ark1'!C22,\" \")","v":" "},{"$f":"IF('Ark1'!D22='Ark2'!$F$1,'Ark1'!D22,\" \")","v":" "},{"$f":"IF(D23<>\" \",'Ark1'!E22,\" \")","v":" "},{"$f":"IF(D23<>\" \",'Ark1'!F22,\" \")","v":" "}]
[{"$f":"IF(D24<>\" \",'Ark1'!A23,\" \")","v":" "},{"$f":"IF(D24<>\" \",'Ark1'!B23,\" \")","v":" "},{"$f":"IF(D24<>\" \",'Ark1'!C23,\" \")","v":" "},{"$f":"IF('Ark1'!D23='Ark2'!$F$1,'Ark1'!D23,\" \")","v":" "},{"$f":"IF(D24<>\" \",'Ark1'!E23,\" \")","v":" "},{"$f":"IF(D24<>\" \",'Ark1'!F23,\" \")","v":" "}]
[]
[]
["Jeg vil gerne have vist alle data som relaterer til en bestemt underkonto nr. fra den 01-01 til d.d."]
["Dette skal vises under hinanden og uden tomme felter."]
["Som det fremgår her i Ark2 er der mange tomme rækker - tænk hvor uoverskueligt det må være med 750 rk. Hvor kun 10 rk. bliver udfyldt."]
[]
["Ha - Jeg bruger da bare et filter. Troede jeg, men jeg har stort set ikke anvendt filtre før, så min viden er ganske begrænset."]
["Fik det til at virke i underkonto 20 - alt i skønneste orden, men nej, såsnart der sættes et nyt nr ind i F1 så virker filteret ikke."]
["Der må da findes en anden løsning? - måske med VBA, eller er det nødvendigt med 11*15 = 165 filtre???"]

{"sheet":"Ark3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}