Topic Wiki

Rule 1: Did you try A.I? Right before you click post, give it a quick run. Most excel questions can be answered very quickly, thoroughly, and clearly via chatgpt. Wrong answer, or having trouble with the correct wording of the prompt? Post for help

=================
For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by Jojo202 on March 01, 2024, 12:09:44 AM »

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

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Excel Problem
« Reply #140 on: July 09, 2014, 10:59:51 PM »
hi
when removing duplicates is there an option that it should ask you what duplicate to remove/keep. or at least show what duplicate was removed?

tia

No direct option. If you want to delete all duplicates besides a specific set, create an indicator to flag those in another column and delete based on that column. Loads
Of alternatives using vba

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #141 on: July 09, 2014, 11:11:06 PM »
if they are duplicates what's the difference? you can highlight duplicates instead of deleting right away under condition formatting > highlight cells rules > duplicate values.

thanks used it
have a list of names and phone #'s  wanted to make sure no number has 2 names (by error)

No direct option. If you want to delete all duplicates besides a specific set, create an indicator to flag those in another column and delete based on that column. Loads
Of alternatives using vba
maybe, but I have no idea what's vba

thanks anyway

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel Problem
« Reply #142 on: July 09, 2014, 11:21:40 PM »
thanks used it
have a list of names and phone #'s  wanted to make sure no number has 2 names (by error)
maybe, but I have no idea what's vba

thanks anyway
You can delete values that are only duplicate in two columns. So it won't delete the number if the names are mismatched

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2623
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #143 on: July 09, 2014, 11:24:06 PM »
hi
when removing duplicates is there an option that it should ask you what duplicate to remove/keep. or at least show what duplicate was removed?

tia

You could make a copy of your data, and then remove duplicated, and compare the 2 versions to see which oned it took out.
It might be easier if you number the rows first, so then you can see which rows were taken out.

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #144 on: July 09, 2014, 11:39:19 PM »
You can delete values that are only duplicate in two columns. So it won't delete the number if the names are mismatched
yes but I wanted to see those names

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #145 on: July 09, 2014, 11:41:00 PM »
You could make a copy of your data, and then remove duplicated, and compare the 2 versions to see which oned it took out.
It might be easier if you number the rows first, so then you can see which rows were taken out.
Right, but we're talking 2000 names

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel Problem
« Reply #146 on: July 09, 2014, 11:43:01 PM »
yes but I wanted to see those names

I'm apparently not following. You have a list of names in column A and numbers in column B. You can highlight duplicates to see which values are going to be deleted. You can highlight duplicate values in column A alone and column B alone to find mismatched names. You can delete duplicates by two columns to make sure you don't delete any mismatched names. What else you need to do?

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #147 on: July 09, 2014, 11:45:26 PM »
I'm apparently not following. You have a list of names in column A and numbers in column B. You can highlight duplicates to see which values are going to be deleted. You can highlight duplicate values in column A alone and column B alone to find mismatched names. You can delete duplicates by two columns to make sure you don't delete any mismatched names. What else you need to do?
I used your idea

Offline username

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2008
  • Posts: 4531
  • Total likes: 602
  • DansDeals.com Hat Tips 14
  • Gender: Male
    • View Profile
  • Location: C Heights
  • Programs: ┌──────────────────┐ │───> Ữ₴ΣЯИΛΜӘ <─── │ └──────────────────┘
Re: Excel Problem
« Reply #148 on: July 09, 2014, 11:50:54 PM »
Create a column concecating the name and phone number. Then on that column remove duplicates and sort asceding, then scroll down and see if any numbers have more than one name on it
^^^

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Problem
« Reply #149 on: July 09, 2014, 11:58:21 PM »
Create a column concecating the name and phone number. Then on that column remove duplicates and sort asceding, then scroll down and see if any numbers have more than one name on it
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

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • 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: 4531
  • Total likes: 602
  • DansDeals.com Hat Tips 14
  • 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 + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • 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 + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • 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 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12863
  • Total likes: 3321
  • 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.

Online smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4525
  • Total likes: 276
  • 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 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12863
  • Total likes: 3321
  • 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 + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • 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 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12863
  • Total likes: 3321
  • 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 + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • 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?