Excel

#1

NEO

Eat at Joe's
Joined
Sep 14, 2009
Messages
18,794
Likes
14,050
#1
Need help merging two seperate list into one.

Also need help deleting about 5,000 records on another list and don't want to delete row by row.

Anybody know the formula to use and can show me?


Thanks!
 
#2
#2
You'll need to either sort or query to isolate the rows you want to delete then just copy the remaining rows into the other list.
 
#3
#3
Need help merging two seperate list into one.

Also need help deleting about 5,000 records on another list and don't want to delete row by row.

Anybody know the formula to use and can show me?


Thanks!

You mean you're merging text from columns together, or merging two spreadsheets?

Also, do the 5000 records have anything in common that makes them easy to sort?
 
#4
#4
they are both CSV and they are both set up the same way....a through g.

a is name

b is last name

c is street number

d is street address

e is city

f is area code

g is number
 
#6
#6
Pretty simple. Highlight all the rows (not the cells) and then hit the sort button which I think has A-Z and maybe arrows on it. Then it will ask you what in the row you want to sort by and excel will sort the data and keep your rows intact.
 
#7
#7
How do I sort or query?

The easy way is

select row one (or whatever your title row is)

goto "data"

hit "filter"

Select what you want to filter from the drop downs, then delete or copy the rows as needed.
 
#8
#8
GAVol suggestion works too.

The filter allows for custom searches. You can filter on all cells "less than", "greater than", "containing", etc.
 
#9
#9
Thats why I like Excel. There are usually multiple ways to manipulate data. And I'm the type of guy whose reports need to be manipulated. :)
 

VN Store



Back
Top