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

Offline joe1234

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2015
  • Posts: 2073
  • Total likes: 537
  • DansDeals.com Hat Tips 19
    • View Profile
Re: Excel Help and Problems
« Reply #1640 on: February 14, 2024, 10:33:07 PM »
Yes with something like mechanical turk
this is for a few hundred names for wedding invitations... was thinking maybe to use some free program to scan and extract the text and then to paste to excel. if that's possible...

Offline Definitions2

  • Dansdeals Gold Elite
  • ***
  • Join Date: Aug 2023
  • Posts: 183
  • Total likes: 148
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1641 on: February 14, 2024, 10:40:03 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!
https://support.microsoft.com/en-us/office/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7

Offline Alexsei

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2011
  • Posts: 5816
  • Total likes: 1437
  • DansDeals.com Hat Tips 5
    • View Profile
    • Travel & Kivrei Zadikim
  • Location: Truckistan
  • Programs: COVID-23
Re: Excel Help and Problems
« Reply #1642 on: February 14, 2024, 10:44:32 PM »
this is for a few hundred names for wedding invitations... was thinking maybe to use some free program to scan and extract the text and then to paste to excel. if that's possible...
I guess you'd want them delivered
Jews ≠ Zionists
Palestinians ≠ Hamas
Satmar ≠ SatmarHQ

Offline joe1234

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2015
  • Posts: 2073
  • Total likes: 537
  • DansDeals.com Hat Tips 19
    • View Profile
Re: Excel Help and Problems
« Reply #1643 on: February 14, 2024, 10:58:11 PM »
https://support.microsoft.com/en-us/office/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7
Thanks! but I don't have an option to select data from picture, maybe my excel isn't up to date (mine is 2021)...

Offline joe1234

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2015
  • Posts: 2073
  • Total likes: 537
  • DansDeals.com Hat Tips 19
    • View Profile
Re: Excel Help and Problems
« Reply #1644 on: February 14, 2024, 11:32:57 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?
I found this. https://nanonets.com/image-to-excel
Itís pretty good..

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2162
  • Total likes: 365
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1645 on: February 14, 2024, 11:48:11 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!

So you're not even at the step of copying it yet  :-\. You need to extract data from scanned files, and then extract them to a spreadsheet.

I don't think there is any free or simple way to do it.

Offline lcm

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2019
  • Posts: 1617
  • Total likes: 644
  • DansDeals.com Hat Tips 6
    • View Profile
  • Location: 5th paragraph of https://www.dansdeals.com/sms/
Re: Excel Help and Problems
« Reply #1646 on: February 15, 2024, 08:45:18 AM »
So you're not even at the step of copying it yet  :-\. You need to extract data from scanned files, and then extract them to a spreadsheet.

I don't think there is any free or simple way to do it.
Gemini and chatgpt are free

Offline Sammy82

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2011
  • Posts: 1493
  • Total likes: 429
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: AWAY
Re: Excel Help and Problems
« Reply #1647 on: February 15, 2024, 02:38:07 PM »
Need some help with conditional formatting. Some background-
I chart staffing hours every week (with each position in another row and each week in a new column). It's a running spreadsheet. I would like the cells in each column turn green/red based on if the number is lower/higher than the previous week's similar cell (in the same row). How would I use conditional formatting to automatically do that for me?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2162
  • Total likes: 365
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1648 on: February 15, 2024, 03:35:43 PM »
Need some help with conditional formatting. Some background-
I chart staffing hours every week (with each position in another row and each week in a new column). It's a running spreadsheet. I would like the cells in each column turn green/red based on if the number is lower/higher than the previous week's similar cell (in the same row). How would I use conditional formatting to automatically do that for me?

Something along the following lines:
Formula for red:
Code: [Select]
=AND(ISNUMBER(C2),C2<B2)Formula for green:
Code: [Select]
=C2>B2Both Applies to:
Code: [Select]
=$C$2:$T$1000

Offline Definitions2

  • Dansdeals Gold Elite
  • ***
  • Join Date: Aug 2023
  • Posts: 183
  • Total likes: 148
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1649 on: February 15, 2024, 07:07:03 PM »
Why do you need the isnumber for red?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2162
  • Total likes: 365
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1650 on: February 15, 2024, 07:09:14 PM »
Why do you need the isnumber for red?

Otherwise first empty column gets all red, since it's "less than" column before it...

Offline hocker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2009
  • Posts: 3501
  • Total likes: 85
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1651 on: February 21, 2024, 04:39:29 PM »
Looking to hire an excel expert to help me with excel from time to time. Anyone here interested or know anyone that does this?

Offline JuryDuty

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Nov 2018
  • Posts: 1110
  • Total likes: 227
  • DansDeals.com Hat Tips 18
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1652 on: February 21, 2024, 04:43:07 PM »
Looking to hire an excel expert to help me with excel from time to time. Anyone here interested or know anyone that does this?

What type of tasks do you need? Likely plenty of them here
Jury Duty: Nothing to do there but chill and write a TR. Kinda like the beach but missing the view and ocean breeze.

Offline Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6699
  • Total likes: 2626
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1653 on: February 21, 2024, 06:45:12 PM »
What type of tasks do you need? Likely plenty of them here
Spearheaded by chat gpt ;)
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline hocker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2009
  • Posts: 3501
  • Total likes: 85
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1654 on: February 21, 2024, 07:47:18 PM »
What type of tasks do you need? Likely plenty of them here
Multi column matching and referencing to bring back values, where the data format being referenced doesn't match exactly. (Last Name, First Name to First Name Last Name, DOB style etc.)

Offline cholent

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2014
  • Posts: 2653
  • Total likes: 521
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1655 on: February 21, 2024, 08:47:23 PM »
Multi column matching and referencing to bring back values, where the data format being referenced doesn't match exactly. (Last Name, First Name to First Name Last Name, DOB style etc.)
You should be able to manage that easily with power query
Don't ask stupid questions and you won't get stupid answers

Offline JuryDuty

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Nov 2018
  • Posts: 1110
  • Total likes: 227
  • DansDeals.com Hat Tips 18
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1656 on: February 21, 2024, 10:57:53 PM »
You should be able to manage that easily with power query

Or I'm happy to do it, and take my wife out to a fancy dinner
Jury Duty: Nothing to do there but chill and write a TR. Kinda like the beach but missing the view and ocean breeze.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2525
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1657 on: February 29, 2024, 10:45:36 PM »
Does xlookup work with dropdowns?
I want to use drop down menus to name columns and then have xlookup pull whichever column has that name selected.
« Last Edit: February 29, 2024, 10:54:56 PM by avadah »

Offline haltkup

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Apr 2015
  • Posts: 281
  • Total likes: 147
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: ny metro
Re: Excel Help and Problems
« Reply #1658 on: February 29, 2024, 11:02:22 PM »
Does xlookup work with dropdowns?
I want to use drop down menus to name columns and then have xlookup pull whichever column has that name selected.
sounds like an index-match formula will work for you.

Offline avadah

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2012
  • Posts: 2525
  • Total likes: 38
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Jerusalem
Re: Excel Help and Problems
« Reply #1659 on: February 29, 2024, 11:11:02 PM »
I'm not familiar with that. How does it work?