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

Offline Luvisrael

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1273
  • Total likes: 59
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1290 on: July 04, 2019, 03:56:17 PM »
Importing data from excel to quickbooks and some cellaís are marked in red error. I understand that I have to change the headings to match the text in Quickbooks to be valid data input? When I try doing this they formula, define name, itís giving me an error saying the syntax of this name isnít valid. Can someone help me? TIA

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1312
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Help and Problems
« Reply #1291 on: July 07, 2019, 03:01:25 PM »
In C147 you'd want =NOT(ISERROR(MATCH(A147,$A$1:$A$142,0))) to give a True or False if a customer called, and if you want to know how many times they did  - if they did - you can also do (in D147) =COUNTIF($A$1:$A$142,A147)

Good?

Excellent!  great Job thank you!

I have a salesforce question- didn't find the thread yet. who can I ping?
you can only make a first impression ONCE

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2589
  • Total likes: 26
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1292 on: July 07, 2019, 03:08:20 PM »
Importing data from excel to quickbooks and some cellaís are marked in red error. I understand that I have to change the headings to match the text in Quickbooks to be valid data input? When I try doing this they formula, define name, itís giving me an error saying the syntax of this name isnít valid. Can someone help me? TIA
Not sure if this is your issue, but the vendor names and account names need the first be in QuickBooks otherwise you'll get that red error. If the names are already there, you might be pulling the wrong columns for example account name in vendor name or vice versa.

Offline Luvisrael

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1273
  • Total likes: 59
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1293 on: July 07, 2019, 03:19:08 PM »
Not sure if this is your issue, but the vendor names and account names need the first be in QuickBooks otherwise you'll get that red error. If the names are already there, you might be pulling the wrong columns for example account name in vendor name or vice versa.
im actually putting in inventory

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9382
  • Total likes: 306
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1294 on: July 07, 2019, 03:38:32 PM »
I have a salesforce question- didn't find the thread yet. who can I ping?
I can try to help.
Workflowy. You won't know what you're missing until you try it.

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2589
  • Total likes: 26
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1295 on: July 07, 2019, 03:43:17 PM »
im actually putting in inventory
I don't have experience with that. So the error is in Excel? Are you putting an = before the name? That could throw the define name error

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7162
  • Total likes: 270
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1296 on: July 07, 2019, 08:21:28 PM »
Excellent!  great Job thank you!

I have a salesforce question- didn't find the thread yet. who can I ping?
Start a thread.. I have limited experience but you never know

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9382
  • Total likes: 306
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1297 on: July 07, 2019, 08:32:42 PM »
Workflowy. You won't know what you're missing until you try it.

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1312
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Help and Problems
« Reply #1298 on: July 07, 2019, 08:53:41 PM »
you can only make a first impression ONCE

Offline Am

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Nov 2011
  • Posts: 947
  • Total likes: 1
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1299 on: August 30, 2019, 12:42:16 AM »
Is there a way to trace Dependent or Precedent Cells in Google Sheets?
It's such a basic and easy to use feature in Excel but I can't seem to figure it out in Sheets.
TIA.

Offline Therebbesbocher

  • Dansdeals Bronze Elite
  • *
  • Join Date: Jun 2017
  • Posts: 26
  • Total likes: 1
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1300 on: September 15, 2019, 12:26:58 PM »
I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA

Offline Der Deutsche Jude

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Jan 2016
  • Posts: 810
  • Total likes: 17
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
  • Location: Brooklyn, NY
  • Programs: AA, CA, FAA, GA, NA, OA, WA
Re: Excel Help and Problems
« Reply #1301 on: September 15, 2019, 12:29:04 PM »
I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA
are you using conditional formatting

Offline Therebbesbocher

  • Dansdeals Bronze Elite
  • *
  • Join Date: Jun 2017
  • Posts: 26
  • Total likes: 1
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1302 on: September 15, 2019, 12:36:32 PM »
are you using conditional formatting
No, the list is copied from somewhere else and came with the color and shading

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2589
  • Total likes: 26
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1303 on: September 15, 2019, 12:49:31 PM »
I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA
How do you know that you have the exact shade?

Offline Therebbesbocher

  • Dansdeals Bronze Elite
  • *
  • Join Date: Jun 2017
  • Posts: 26
  • Total likes: 1
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1304 on: September 15, 2019, 12:52:05 PM »
How do you know that you have the exact shade?
That's why I'm using find format from cell, shouldn't it match it exactly?