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 118488 times)

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4394
  • Total likes: 2
  • 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: 217
  • 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: 217
  • 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: 2
  • 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: 217
  • 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: 5055
  • Total likes: 16
  • 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: 7246
  • Total likes: 282
  • 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: 2
  • 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: 4799
  • Total likes: 183
  • DansDeals.com Hat Tips 24
  • 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 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10032
  • Total likes: 3778
  • 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?
The thing with the hamster is that running on the wheel is actually what it is trying to do.

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 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10032
  • Total likes: 3778
  • 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
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline Marco Polo

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Jul 2012
  • Posts: 13608
  • Total likes: 35
  • 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 =