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

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 #150 on: July 10, 2014, 08:08:00 AM »
I don't follow. If I remove duplicates I won't be able to see if the numbers have 2 names again I'm talking 2k names for now
I thought we solved this? Highlight duplicates in column A. Then highlight duplicates in column B. Then sort the two columns, first by column B (the numbers) with highlight on top, then by column A with highlight on top. Then scroll down a drop .The duplicate numbers without duplicate names will start where column B is still highlighted but column A no longer is.

Or simply delete duplicates by both columns and then highlight duplicates by number only

Offline username

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2008
  • Posts: 4013
  • Total likes: 259
  • DansDeals.com Hat Tips 9
  • Gender: Male
    • View Profile
  • Location: C Heights
  • Programs: ┌──────────────────┐ │───> Ữ₴ΣЯИΛΜӘ <─── │ └──────────────────┘
Re: Excel Problem
« Reply #151 on: July 10, 2014, 08:31:59 AM »
I don't follow. If I remove duplicates I won't be able to see if the numbers have 2 names again I'm talking 2k names for now
Only remove the duplicates from the newly created column.

How many lines do you have, how many unique names do you think there are?
^^^

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #152 on: July 10, 2014, 08:40:31 AM »
@bubbles
We did. Wanted to understand what username wrote.
@username
Plenty.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #153 on: July 11, 2014, 12:29:34 PM »
Hi
Can excel choose from a list of numbers to reach a specific amount. I have a list of donations I received, then I have a list of deposits made, can excel group together donations to deposit amounts?

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #154 on: July 11, 2014, 12:38:33 PM »
Hi
Can excel choose from a list of numbers to reach a specific amount. I have a list of donations I received, then I have a list of deposits made, can excel group together donations to deposit amounts?
You can probably do that with VBA, but what's to guarantee that you'll end up with the right breakdown? There could be more than one "answer"...
Workflowy. You won't know what you're missing until you try it.

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 #155 on: July 11, 2014, 12:47:35 PM »
Hi
Can excel choose from a list of numbers to reach a specific amount. I have a list of donations I received, then I have a list of deposits made, can excel group together donations to deposit amounts?
can you describe the structure of your document?
Fwiu you can just try sorting both lists by value, check for where they don't line up.

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #156 on: July 11, 2014, 12:50:30 PM »
can you describe the structure of your document?
Fwiu you can just try sorting both lists by value, check for where they don't line up.
True. And you can have excel show you on the bottom the total of the selected cells, so you could go through them and move things around until everything adds up.
Workflowy. You won't know what you're missing until you try it.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #157 on: July 11, 2014, 12:50:59 PM »
You can probably do that with VBA, but what's to guarantee that you'll end up with the right breakdown? There could be more than one "answer"...
I'll accept any breakdown
whats vba? if it's hard to explain i'll try to search in on youtube
thanks
can you describe the structure of your document?
Fwiu you can just try sorting both lists by value, check for where they don't line up.

column a small amounts, column b daily totals

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #158 on: July 11, 2014, 12:54:25 PM »
I'll accept any breakdown
whats vba? if it's hard to explain i'll try to search in on youtube
thankscolumn a small amounts, column b daily totals
VBA is Visual Basic for Applications, which basically means that you can write a program to interact with your excel/word/... file. Very cool, but you gotta know how to code. It sounds like unless your list is really long, you don't need something that complicated.
Workflowy. You won't know what you're missing until you try it.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #159 on: July 11, 2014, 12:56:31 PM »
VBA is Visual Basic for Applications, which basically means that you can write a program to interact with your excel/word/... file. Very cool, but you gotta know how to code. It sounds like unless your list is really long, you don't need something that complicated.
do i have to write the program, there is nothing set up for this yet?

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #160 on: July 11, 2014, 12:57:03 PM »
do i have to write the program, there is nothing set up for this yet?
right, unless you happen to find something by googling. I might be able to help with this next week, but you might not need something so complicated.
Workflowy. You won't know what you're missing until you try it.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #161 on: July 11, 2014, 12:58:22 PM »
right, unless you happen to find something by googling. I might be able to help with this next week, but you might not need something so complicated.
i'll try

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2750
  • Total likes: 126
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #162 on: July 11, 2014, 01:01:53 PM »
i'll try
If the list is small you can probably do it manually by yourself pretty easily. The larger the list is the more likely you need a VBA script to essentially compare the sum of each combination of the small amounts to the daily totals until every small amount is matched to a daily total.
« Last Edit: July 11, 2014, 01:12:17 PM by skyguy918 »

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #163 on: July 11, 2014, 01:08:25 PM »
If the list is small you can probably do it manually by yourself pretty easily. The larger the list is the more likely you need a VBA script to essentially compare the sum of each combination of the small amounts to the daily totals until every small amount is matched to a daily total.
about 40;8 (x12 months), but also there might be some missing so if there is a program or feature that can do this I'll prefer not to do it manually just to find out that something's missing

haven't applied this yet but it looks promising. Ill let you know
« Last Edit: July 11, 2014, 01:11:41 PM by unavailable »

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2750
  • Total likes: 126
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #164 on: July 11, 2014, 01:12:57 PM »
about 40;8 (x12 months), but also there might be some missing so if there is a program or feature that can do this I'll prefer not to do it manually just to find out that something's missing

haven't applied this yet but it looks promising. Ill let you know
I took out my edit. It'll only help you match a maximum of 200 small amount to 1 daily total at a time.