Excel Help and Problems

[smurf]

ever tried v-lookup?

nah index(,match is the way to go

[Gets]

It split column a,b,c rows 1-600 into column a 1-601 b 601-1200 c1201-1800. I put them side by side but they are not all exactly the same. I want to match them up by the id number at the beginning of each row.

[Gets]

nah index(,match is the way to go

Thanks. I'll try that tomorrow morning can you elaborate a little please

[smurf]

It split column a,b,c rows 1-600 into column a 1-601 b 601-1200 c1201-1800. I put them side by side but they are not all exactly the same. I want to match them up by the id number at the beginning of each row.

is the id number a consistent length?

[Gets]

No. The 3 groups are divided based on different info for the 600 people
So when I put them side by side I want it to match up using the user id so it will skip the ones that are n/a.
Thanks for all your help

[bubbles]

I think posting a small example might help. It sounds like the type of problem with an easy fix, but I'm still not exactly sure how it looks

[churnbabychurn]

Hi,
I ran a report at work and it divided the rows up into 3 sets of 600 rows instead of 1 wide row of 600. Is there any way to put them side by side matching the user Id of each row.
Please let me know if I can be any clearer. Tia

Ran a report from where?

[smurf]

It split column a,b,c rows 1-600 into column a 1-601 b 601-1200 c1201-1800. I put them side by side but they are not all exactly the same. I want to match them up by the id number at the beginning of each row.

Table	A	B	C
1	A1-600
2		B601-1200
3			C1201-1800

It sounds like your data looks like this

[chff]

For some reason, when I create a new sheet, the page name on the bottom is in Hebrew. How can I change it?

[dave]

how do i trun off  scientific notation?

[aygart]

how do i trun off  scientific notation?

meaning when you enter a long number?

[dave]

yes all data i enter should be  as is

[aygart]

Do you need it to be considered a number by excel such as to do calculations from

[Marco Polo]

yes all data i enter should be  as is

Try "trimming" the amount of decimal places shown in a cell (on the home tab in the "number" box).

[dave]

trying to upload template to amazon keeps on giving me this error

Error A EAN/UPC value in scientific notation is not allowed: [Product ID Type = "ean"], [Product ID =