duplicates

  • It's me again:D


    i now have a database of 15000 songs, in column A i have the artist, in B the titles, what im wanting to do is remove duplicates, can this be done without me having to physicaly scroll down and checking?

  • Here's some VBA that might do the trick:


    It will sort your active sheet by ColA & ColB then it will remove any rows that have duplicate values in Both A & B.


    Public Sub RemoveDupes()
    ' sort the information
    Cells.sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("B2") _
    , Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False _
    , Orientation:=xlTopToBottom


    'compare and delete
    For Rw = Cells(65536, 1).End(xlUp).Row To 2 Step -1
    If Cells(Rw, 1).Value = Cells(Rw - 1, 1).Value And _
    Cells(Rw, 2).Value = Cells(Rw - 1, 2).Value Then

    Cells(Rw, 1).EntireRow.Delete
    End If
    Next Rw


    End Sub
    :)

  • Bruno,


    you may also wish to do this without deleting the duplicates (just in case) :


    advanced filter removes duplicates and puts the results in an area you specify, leaving the original data (..... just in case!) :


    make sure your list has headers (like Artist and Title)
    click in the list
    data
    filter
    advanced filter


    action : copy to another location
    list range : should already be entered
    copy to : click on your destination cell
    unique records only : check/tick this


    hit ok


    this simile doesn't exactly show you what to do, but it shows the results :


    <CENTER&gt;<TABLE ALIGN=CENTER BORDER=1 BORDERCOLOR=#C0C0C0 CELLSPACING=0 WIDTH=60%&gt;<TR&gt;<TD COLSPAN=8 BGCOLOR=#0C266B &gt;<TABLE ALIGN=CENTER BORDER=0 WIDTH=100%&gt;<TR&gt;<TD ALIGN=LEFT&gt;<FONT COLOR=WHITE&gt;<B&gt;Microsoft Excel - bruno duplicates 1.xls</B&gt;</FONT&gt;</TD&gt;<TD ALIGN=RIGHT&gt;<FONT COLOR=WHITE SIZE=2&gt;___Running: xl97 : OS = Windows (32-bit) 4.90</FONT&gt;</TD&gt;</TR&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD BGCOLOR=#D4D0C8 COLSPAN=8&gt;<TABLE BORDER=0 ALIGN=CENTER VALIGN=MIDDLE HEIGHT=10 WIDTH=100%&gt;<TR&gt;<TD&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp</TD&gt;<TD ALIGN=RIGHT VALIGN=MIDDLE&gt;<FORM NAME='formCb7552370787'&gt;<INPUT TYPE='Button' NAME='btCb5705426622' value='Copy Formula' onClick='window.clipboardData.setData("Text",document.formFb0487398093.sltNb8859926925.value);'&gt;</FORM&gt;</TD&gt;</TR&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD BGCOLOR=WHITE COLSPAN=8&gt;<TABLE BORDER=0&gt;<TR&gt;<Form name='formFb0487398093'&gt;<TD WIDTH=5% ALIGN=CENTER BGCOLOR=White&gt;<SELECT NAME='sltNb8859926925' onChange='document.formFb0487398093.txbFb1960511720.value = document.formFb0487398093.sltNb8859926925.value'&gt;<option value=Yellow Submarine&gt;A1</select&gt;</TD&gt;<TD WIDTH=3% ALIGN=RIGHT BGCOLOR=#D4D0C8 &gt;<B>=</B&gt;</TD&gt;<TD ALIGN=LEFT BGCOLOR=White&gt;<input type='text' name='txbFb1960511720' size='120' value=Artist&gt;</TD&gt;</form&gt;</TR&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;A</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;B</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;C</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;D</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;E</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;F</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;G</CENTER&gt;</B&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;1</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Artist</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Album</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Artist</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Album</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;2</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Ummagumma</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lamb lies down on Broadway</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;3</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Dark Side</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Trick of the Tail</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;4</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Rubber Soul</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Foxtrot</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;5</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Selling England by the pound</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;6</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Yellow Submarine</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Iggy Pop</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lust for life</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;7</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Sargeant Pepper</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lou Reed</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Take no prisoners</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;8</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lamb lies down on Broadway</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Ummagumma</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;9</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Trick of the Tail</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Dark Side</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;10</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Foxtrot</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Wall</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;11</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Wall</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Wish you were here</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;12</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Yellow Submarine</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Rubber Soul</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;13</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Yellow Submarine</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;14</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Selling England by the pound</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Yellow Submarine</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;15</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Wall</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Sargeant Pepper</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;16</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Pink Floyd</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Wish you were here</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;17</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lou Reed</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Take no prisoners</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;18</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Iggy Pop</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Lust for life</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;19</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Genesis</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Selling England by the pound</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;20</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;The Beatles</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF ALIGN=Left VALIGN=BOTTOM &gt;<FONT FACE=Arial COLOR=#000000&gt;Yellow Submarine</FONT&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD WIDTH=1% BGCOLOR=#D4D0C8 ALIGN=CENTER&gt;<B&gt;<CENTER&gt;21</CENTER&gt;</B&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;<TD BGCOLOR=#FFFFFF&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD COLSPAN=8&gt;<U&gt;Sheet1</U&gt;</TD&gt;</TR&gt;</TABLE&gt;<BR&gt;<FONT COLOR=#339966&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT COLOR=RED SIZE=2&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! Otherwise, the error of JavaScript occurs.</FONT&gt;<BR&gt;<BR&gt;<FONT COLOR=#339966 SIZE=1&gt;The above image was automatically generated by [HtmlMaker [email protected]]</FONT&gt;<FONT COLOR=#339966 SIZE=1&gt;If you want FREE SOFT, <A HREF=http://www28.tok2.com/home/corosuke/HtmlMaker.htm&gt;click here</A&gt; to download</FONT&gt;<BR&gt;<FONT COLOR=#339966 SIZE=1&gt;This code was graciously allowed to be modified: by <A HREF=mailto:[email protected]&gt;Ivan F Moala</A&gt; All credit to <A HREF=mailto:[email protected]&gt;Colo</A&gt;</FONT&gt;<BR&gt;</CENTER&gt;

  • :thumbup: @ Bruno


    if you like this facility, I'd recommend you check out the help file : not only can you filter in-place and filter somewhere else, you can include criteria with which to apply to the filtering (takes a bit of practise though)


    so, for example, you can filter your data to a new section where only sales &gt; 4000 AND saleperson = "Chris" etc etc

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!