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

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6335
  • Total likes: 68
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel help
« Reply #90 on: April 07, 2014, 10:22:25 PM »
The problem is with a word mail merge, nothing wrong with excel's zip code format. In word there should be an option to format the field as zip also

Offline yitzf

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Mar 2011
  • Posts: 2458
  • Total likes: 3
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel help
« Reply #91 on: April 07, 2014, 10:26:54 PM »
I don't think it's necessary to do it this way, but if you want...
=IF(LEN(A1)=4,CONCATENATE("0",A1),A1)

Now that you mention it, I think that's what I did. (I know I wasn't so tied down to lakewood  :) )

Offline jack12

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2008
  • Posts: 1120
  • Total likes: 0
  • DansDeals.com Hat Tips 8
    • View Profile
  • Programs: National Emerald Club Executive Elite, Hertz #1 Club Gold Presidents Circle, Sixt Platinum
Re: Excel help
« Reply #92 on: April 08, 2014, 07:23:45 AM »
Funny how this issue only comes up with lakewood :)
All New Jersey zip codes start with a 0

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6798
  • Total likes: 3
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • Flight Lynx
  • Location: Chicago, Jerusalem
  • Programs: AA Exec Plat; UA Premier 1K; ; LY Plat; Hyatt Platinum; Hertz President's Circle; Avis President's Club
Re: Excel help
« Reply #93 on: April 08, 2014, 07:44:41 AM »

All New Jersey zip codes start with a 0

And why would no one mention that earlier. ???
You may not hold me responsible or liable for any actions taken that was recommended from my account or username.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 8369
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #94 on: April 08, 2014, 08:57:01 AM »
And why would no one mention that earlier. ???
That's the funny part...
Workflowy. You won't know what you're missing until you try it.

Offline AnonymousUser

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 2943
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel help
« Reply #95 on: April 08, 2014, 09:46:02 AM »
And why would no one mention that earlier. ???
You mean there are places in NJ besides Lakewood??? ;)

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6798
  • Total likes: 3
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • Flight Lynx
  • Location: Chicago, Jerusalem
  • Programs: AA Exec Plat; UA Premier 1K; ; LY Plat; Hyatt Platinum; Hertz President's Circle; Avis President's Club
Re: Excel help
« Reply #96 on: April 08, 2014, 09:47:03 AM »

You mean there are places in NJ besides Lakewood??? ;)

Nope. :P
You may not hold me responsible or liable for any actions taken that was recommended from my account or username.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 8369
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #97 on: April 08, 2014, 10:11:41 AM »
Nope. :P
Sorry guys, but I'm moving to Passaic in less than a month...
Workflowy. You won't know what you're missing until you try it.

Offline jack12

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2008
  • Posts: 1120
  • Total likes: 0
  • DansDeals.com Hat Tips 8
    • View Profile
  • Programs: National Emerald Club Executive Elite, Hertz #1 Club Gold Presidents Circle, Sixt Platinum
Re: Excel help
« Reply #98 on: April 08, 2014, 12:16:37 PM »
All New Jersey zip codes start with a 0
Other states do too. From Wikipedia: 0 = Connecticut (CT), Massachusetts (MA), Maine (ME), New Hampshire (NH), New Jersey (NJ), Puerto Rico (PR), Rhode Island (RI), Vermont (VT), Virgin Islands (VI), Army Post Office Europe (AE), Fleet Post Office Europe (AE)

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6335
  • Total likes: 68
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #99 on: May 19, 2014, 09:35:42 AM »
Whats an easy way to remove every second row of data?

Offline AnonymousUser

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 2943
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #100 on: May 19, 2014, 09:38:15 AM »
Whats an easy way to remove every second row of data?
Write a macro? And start from the bottom up.

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3687
  • Total likes: 10
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #101 on: May 19, 2014, 09:42:32 AM »
Whats an easy way to remove every second row of data?
One way you can do it is:
In the column to the right of all the data, enter a 1 on the first row, 0 on 2nd row, drag it down to the bottom and select copy cells. Now, every other row will have a 1 at the end and every other row will have a 0.

Filter to show only the 1's and not the zeros.  Copy/paste the filtered data to a new tab and you'll have just the data you want.

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7397
  • Total likes: 1
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #102 on: May 19, 2014, 09:44:59 AM »
Whats an easy way to remove every second row of data?
add a new column at the end of all your data. in the first row put a 1 and in the second row put a 2 drag down those two rows to the end of your data. Filter to only see the "2" rows. Then delete

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7397
  • Total likes: 1
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #103 on: May 19, 2014, 09:45:25 AM »
One way you can do it is:
In the column to the right of all the data, enter a 1 on the first row, 0 on 2nd row, drag it down to the bottom and select copy cells. Now, every other row will have a 1 at the end and every other row will have a 0.

Filter to show only the 1's and not the zeros.  Copy/paste the filtered data to a new tab and you'll have just the data you want.
add a new column at the end of all your data. in the first row put a 1 and in the second row put a 2 drag down those two rows to the end of your data. Filter to only see the "2" rows. Then delete
you beat me to it

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6335
  • Total likes: 68
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #104 on: May 19, 2014, 09:47:19 AM »
Was thinking something similar...
Thanks!