I need help with excel. Urgent and thanks alot please.

• ChingAlvin

  19 Apr 07, 18:47

  Hi i really need help here.
  
  I would like to ask about excel.
  
  Take for example, i have a row of data like this.
  
  
  
  How can i sort arrange it orderly without any spacing in between, but at the same time, not disturbing the order of the numbers? To something like this for example.
  
  
  
  Thanks alot, i need to do a set of data entry and i need to submit by tomorrow... thanks alot of any 1 can help...[/url]
• dark_snowboy

  19 Apr 07, 18:49

  actually you cant do that, thats what i know
• GoOdOnE

  19 Apr 07, 18:53

  select whole column den filter>unique records
• ChingAlvin

  19 Apr 07, 18:53

  Really ah?? i know can arrange them in order, but i dont want to change the order... any 1 ?!?! thanks.
• ChingAlvin

  19 Apr 07, 18:56

  Originally posted by GoOdOnE:

  select whole column den filter>unique records

  Thanks alot man. U are really my saviour. The other time i do, i organize them manually. took me one whole day.. =( Thanks!
• GoOdOnE

  19 Apr 07, 18:56

  eh u can forget about wat i sae earlier coz tt method will filter out ur data and onli display those unique ones data which are the same it will onli show 1 on it
  example if u got 3 '2' it will onli show 1
• ChingAlvin

  19 Apr 07, 19:02

  Originally posted by GoOdOnE:

  eh u can forget about wat i sae earlier coz tt method will filter out ur data and onli display those unique ones data which are the same it will onli show 1 on it
  example if u got 3 '2' it will onli show 1

  Eh no ah! can leh!
• valentinoo

  19 Apr 07, 19:03

  just install this add in tools for excel loh
  
  very easy to use
  
  http://www.digdb.com/excel_add_ins/delete_blank_hidden_rows_columns_sheets/
  
  
• GoOdOnE

  19 Apr 07, 19:05

  ? dun quite understand wat u saying so is OK or NOT OK coz i see ur data like got repeated ones so tt method not feasible
  
  or maybe u post a pic of the structure u wan it to be example how many columns how the data u wan to put it etc den maybe i can try help u
• valentinoo

  19 Apr 07, 19:07

  basically u r trying to delete blank rows correct or not? if correct then install that DIGdb