that doesn't really sound possible? i dunno!


i don't know how to do this.

i don't know much about excel!

I wasn't really asking if that was possible in excel (it is, and it's easy) I was just asking if there's a reason that wouldn't work.

Google "excel filter" and see if that can help. Basically what it will do is allow you to easily sort tables of data based on the values one column. The values can be either numbers or letters, so it seems like it should work for whatever you need.

i'm sure there's a better method for the first part but my rather rudimentary method seems ok.

the second part can basically be rewritten and simplified as :

i have two columns

a
b
c
d
e
f
g
h
i
j

and

a
d
e

how can i quickly get a list of which in the first column are not in the second?

i'll check out that link. is what i'm asking to do with VLOOKUP? (something i have never used and have no idea about)

How to compare data in two columns to find duplicates in Excel

I hope this helps.

Edit: Damn, reading comprehension fail.

Edit 2: The first method might work since it leaves the spaces blank for the ones that aren't duplicates.

I think Yeti just wants to return data if he gets a match. That should easily be accomplished with a conditional + VLOOKUP.

i imported a bunch of data but some of the cells have two sets of numbers in them like this
20-25. what is the formula to change it so they are in two different cells?

nm

=VALUE(LEFT(A1,FIND("-",A1)-1))

could just do 'text to columns -> delimited and put the hypen in the 'other' box

Question:

I have a column of numbers, just plain old numbers. I want to put each number within a set of parentheses in its cell. Is it possible to change a block of cells format in this way? Can the contents of a cell even be in parentheses within Excel?

eg. column looks like:

1
5
4
15
3
...

becomes

(1)
(5)
(4)
(15)
(3)
(...)

This is pretty simple to do.

Basically, you need to enter a formula into the column next to the numbers.

So, if your numbers start in cell A1, in cell b1, input:

="("&A1&")"

You can then copy that formula down, as far as your numbers go.

To replace the column without the parentheses, copy the column with the formula, and then paste special as values into cell a1.

If you're on excel 2007, paste as values can be done by hitting: alt+h+v+v in succession.

edit: You may have some formatting issues, since excel might want to interpret these as negative numbers - changing the format of the data to "Text" should take care of it, or you can "ignore" the error on the menu that pops up next to the cells.

Just format all the cells as "Custom" and type this: (0)

Help Please! Scenario:

50 names on list #1. 50 names on list #2.

I want it so that, if a name on list #1 = a name on list #2, it will display the cell beside the name on list #2.

How do I do this?

My business is transport. I made an excel sheet that calculates costprice and rate based on # of load/discharges and kilometers. The costs per load/discharge and the cost per km vary per customer, so I have a table with the customers in different columns.

Now I have a second excel that I use to register all quotations. I look up the distance and enter it and the actions in the excel, then register the outcome in the second excel file. I want to keep these files separate since not everyone that needs the second excel file can access the first.

I would like it to do the entire calculation automatically in the second sheet. I know I can rebuild the entire formula and perhaps with some kind of hlookup I can make sure it displays the proper rate (provided that I make column A customer name). I would, however, prefer a more elegant way as this referring will make the sheet very slow in the end, and it will make the second sheet dynamic which is not ideal since I have to look up rates from the past and the variables may change in the first sheet.

I can't really paste or send the files since they are extremely sensitive for the company.

Woopdedoo

If list 1 is in col a and list b is in col b:

=vlookup(b1,$a$1:$a$50,1,false)

If you want blanks where there is no match then:

=if(iserror(vlookup(b1,$a$1:$a$50,1,false)),"",vlo okup(b1,$a$1:$a$50,1,false))

This is a lot harder to do on an iPhone than in excel, hope there's enough brackets there.

Apologies, I haven't checked this thread for a while didn't realise it was still being bumped

Say column A has the first list and column B has the second list

in C1 you can put the formula below and copy down

similar to above next to list #2 put

Ok great! I tested it out and I'm still having a bit of trouble, I'll use an example.

Sheet1
A1: Sidney Crosby
B2: (empty cell)

Sheet 2
A1:A50 - Sidney Crosby is here somewhere
B1:B50 - Beside Sidney Crosby is a number

I'd like the cell in "Sheet 1 B2" to pull the number beside Sidney Crosby on Sheet 2. Is this possible?

p.s. you guys are awesome

How many hotkeys do you know that are no longer listed in MS' documentation [either for Users or the Help Desk]?

this works great, thanks!

this doesn't, but thanks anyways!

http://forumserver.twoplustwo.com/47...k-1104630-new/

In cell B2
=vlookup(A1,Sheet 2!A1:B50,2,false)

=look up value (sidney crosby),table,column,exact match

While this can probably be done in excel, why not go to SPSS and use that since it is created for these types of problems?

This is a really dumb question, apologies in advance

Whenever I create a new chart with char wizard, the default chart settings aer so terrible. lame grey background, lame colors, lame line colors, and so on.

Is there a way to change the default settings for charts?

ret,

awesome, thanks for the detailed reply. i recently got a job where i have to use a lot of SAS and excel and watching people who are experts swan their way around these programs really impresses me and has me determined to improve. cool thread, thanks again.

thanks obie!!

Grunching:

I have a customer report xls and I'm trying to segregate different customers.

For this one list I'm trying to sort my sheet by anybody who hasn't ordered since XX.

The problem is the date format from my shopping cart looks like this:

header: "Last Order Date"

09 MAY 2011 14:03:29

I can't get excel to recognize the format. Can anybody help me to write a formula to turn this into something readable?

Thanks so much.

Joshk