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

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13066
  • Total likes: 3562
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1620 on: July 11, 2023, 04:59:10 PM »
Thanks. Is there a way to use it with the wild card feature?
I don't know offhand but it's worth a try!
Workflowy. You won't know what you're missing until you try it.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2555
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1621 on: July 11, 2023, 05:07:05 PM »
I don't know offhand but it's worth a try!
Got it. You put the * where its pulling the criteria from. Also you don't need to put = before the criteria. (the ' gets put in automatically)

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13066
  • Total likes: 3562
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1622 on: July 11, 2023, 05:10:40 PM »
Got it. You put the * where its pulling the criteria from. Also you don't need to put = before the criteria. (the ' gets put in automatically)
Sounds good! I was playing around with it and at some point adding the = helped, but maybe it was something else that it needed really
Workflowy. You won't know what you're missing until you try it.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2555
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1623 on: July 11, 2023, 05:17:59 PM »
Oh
It means that the column to sum is the 3rd column in the range (1st argument)
Is there a way to make it that if it says apple, green apple or red apple in the first column it won't count orange in the second column (in the same row)?

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13066
  • Total likes: 3562
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1624 on: July 11, 2023, 05:18:35 PM »
Is there a way to make it that if it says apple, green apple or red apple in the first column it won't count orange in the second column (in the same row)?
pretty sure it won't... since it's already counting that row due to the orange. It won't count it twice.
Workflowy. You won't know what you're missing until you try it.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2555
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1625 on: July 11, 2023, 05:21:22 PM »
pretty sure it won't... since it's already counting that row due to the orange. It won't count it twice.
It counts it bec it's 2 different values.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13066
  • Total likes: 3562
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1626 on: July 11, 2023, 05:25:15 PM »
It counts it bec it's 2 different values.
in the same row? in my testing it doesn't. It's adding up all the values in C where the row meets criteria
Workflowy. You won't know what you're missing until you try it.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2555
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1627 on: July 11, 2023, 09:58:34 PM »
in the same row? in my testing it doesn't. It's adding up all the values in C where the row meets criteria
It's counting it by me. There's 2 different criteria and each one is being met.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13066
  • Total likes: 3562
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1628 on: July 11, 2023, 10:34:52 PM »
It's counting it by me. There's 2 different criteria and each one is being met.
I'm curious to see a screenshot and try to replicate it
Workflowy. You won't know what you're missing until you try it.

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: May 2013
  • Posts: 773
  • Total likes: 12
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1629 on: September 19, 2023, 09:03:03 AM »
I am looking to show previous income.
I have dates of service, inbsame sheet i have date paid.
How do i pivot this information into a nice sheet.
Eg. All dates in May, how long did it take to get paid
All dates in June etc. Thanks

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 25K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31354
  • Total likes: 8240
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1630 on: September 19, 2023, 09:08:09 PM »
I am looking to show previous income.
I have dates of service, inbsame sheet i have date paid.
How do i pivot this information into a nice sheet.
Eg. All dates in May, how long did it take to get paid
All dates in June etc. Thanks

What I would do is make a DosMonth column that formats date date of service by yy-mm (this sorts well) then Add a DaysToPayment column that is date paid minus date of service (format as number to get how many days later it was) and make sure there are no negatives if it was paid early.

Then create a pivot table where you group by DosMonth and average the DaysToPayment formula column.
DDF FFB (Forum From Birth)

Offline Mordyk

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2013
  • Posts: 4165
  • Total likes: 1066
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
  • Programs: Some of this and some of that.
Re: Excel Help and Problems
« Reply #1631 on: September 19, 2023, 10:32:23 PM »
I am looking to show previous income.
I have dates of service, inbsame sheet i have date paid.
How do i pivot this information into a nice sheet.
Eg. All dates in May, how long did it take to get paid
All dates in June etc. Thanks
Ask chatgpt. It's amazing when looking for formulas. Sometimes it needs more than one try, but in the end it responds with a detailed formula or process
#TYH

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: May 2013
  • Posts: 773
  • Total likes: 12
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1632 on: September 19, 2023, 11:46:46 PM »
Ask chatgpt.
Thabks a million for that reminder.  Tomorrow I will look

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 25K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31354
  • Total likes: 8240
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1633 on: September 20, 2023, 12:40:18 AM »
Thabks a million for that reminder.  Tomorrow I will look

Have you tried my solution?
DDF FFB (Forum From Birth)

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: May 2013
  • Posts: 773
  • Total likes: 12
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1634 on: December 12, 2023, 11:33:31 PM »
Did anyone watch the 1st Microsoft excel championship
.
It was this past weekend in Vegas.

You can search youtube

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 7076
  • Total likes: 2804
  • DansDeals.com Hat Tips 66
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1635 on: December 13, 2023, 07:50:58 AM »
Did anyone watch the 1st Microsoft excel championship
.
It was this past weekend in Vegas.

You can search youtube
Certainly ain't the first
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Online joe1234

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2015
  • Posts: 2109
  • Total likes: 560
  • DansDeals.com Hat Tips 19
    • View Profile
Re: Excel Help and Problems
« Reply #1636 on: February 14, 2024, 09:22:28 PM »
I need to copy/paste a list of names with addresses to excel. Any way to do it in mass instead of each name/address seperately?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2191
  • Total likes: 385
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1637 on: February 14, 2024, 09:23:58 PM »
I need to copy/paste a list of names with addresses to excel. Any way to do it in mass instead of each name/address seperately?

Copy/paste from?

You can obviously paste a mass copy to Excel. The question is if you can copy it en masse (which has to do with the source, not with Excel.)

Online joe1234

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2015
  • Posts: 2109
  • Total likes: 560
  • DansDeals.com Hat Tips 19
    • View Profile
Re: Excel Help and Problems
« Reply #1638 on: February 14, 2024, 10:01:15 PM »
Copy/paste from?

You can obviously paste a mass copy to Excel. The question is if you can copy it en masse (which has to do with the source, not with Excel.)
Basically I have lots of papers with names/addresses that need to be scanned and have the text extracted and then copy/pasted to excel. Is that possible? Thanks for your help!

Offline Alexsei

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2011
  • Posts: 6065
  • Total likes: 1599
  • DansDeals.com Hat Tips 5
    • View Profile
    • Travel & Kivrei Zadikim
  • Location: Truckistan
  • Programs: COVID-23
Re: Excel Help and Problems
« Reply #1639 on: February 14, 2024, 10:29:34 PM »
Basically I have lots of papers with names/addresses that need to be scanned and have the text extracted and then copy/pasted to excel. Is that possible? Thanks for your help!
Yes with something like mechanical turk
Biden 2028!