Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 80779 times)

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4394
  • Total likes: 1
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: Excel Problem
« Reply #195 on: July 16, 2014, 09:47:35 PM »
ever tried v-lookup?
nah index(,match is the way to go

Offline Gets

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jan 2013
  • Posts: 218
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #196 on: July 16, 2014, 09:49:36 PM »
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.

Offline Gets

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jan 2013
  • Posts: 218
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #197 on: July 16, 2014, 09:51:20 PM »

nah index(,match is the way to go
Thanks. I'll try that tomorrow morning can you elaborate a little please

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4394
  • Total likes: 1
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: Excel Problem
« Reply #198 on: July 16, 2014, 09:52:17 PM »
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?

Offline Gets

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jan 2013
  • Posts: 218
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #199 on: July 16, 2014, 10:02:16 PM »
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

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5047
  • Total likes: 10
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel Problem
« Reply #200 on: July 16, 2014, 11:45:42 PM »
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

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7115
  • Total likes: 253
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #201 on: July 17, 2014, 12:28:09 AM »
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?

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4394
  • Total likes: 1
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: Excel Problem
« Reply #202 on: July 17, 2014, 12:56:17 AM »
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.
TableABC
1A1-600
2B601-1200
3C1201-1800

It sounds like your data looks like this

Offline chff

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2012
  • Posts: 4311
  • Total likes: 111
  • DansDeals.com Hat Tips 9
  • Gender: Male
    • View Profile
  • Location: NYC
  • Programs: All of them...
Re: Excel Problem
« Reply #203 on: July 17, 2014, 07:10:09 AM »
For some reason, when I create a new sheet, the page name on the bottom is in Hebrew. How can I change it?

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 118
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #204 on: August 18, 2014, 04:58:23 PM »
how do i trun off  scientific notation?

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 6734
  • Total likes: 1463
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #205 on: August 18, 2014, 05:02:42 PM »
how do i trun off  scientific notation?
meaning when you enter a long number?
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 118
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #206 on: August 18, 2014, 05:04:36 PM »
yes all data i enter should be  as is

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 6734
  • Total likes: 1463
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #207 on: August 18, 2014, 05:06:02 PM »
Do you need it to be considered a number by excel such as to do calculations from
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline Marco Polo

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Jul 2012
  • Posts: 13608
  • Total likes: 9
  • DansDeals.com Hat Tips 104
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #208 on: August 18, 2014, 05:06:28 PM »
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).
Quaerite et Invenietis.

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 118
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #209 on: August 18, 2014, 05:16:13 PM »
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 =