Excel Help and Problems

[Luvisrael]

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

[Centurion]

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?

[yitzf]

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.

[Luvisrael]

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

[etech0]

I have a salesforce question- didn't find the thread yet. who can I ping?

I can try to help.

[yitzf]

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

[churnbabychurn]

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

[etech0]

Start a thread

+1

[Centurion]

Start a thread.. I have limited experience but you never know

https://forums.dansdeals.com/index.php?topic=104992.new#new

[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.

[Therebbesbocher]

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

[Der Deutsche Jude]

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

[Therebbesbocher]

are you using conditional formatting

No, the list is copied from somewhere else and came with the color and shading

[yitzf]

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?

[Therebbesbocher]

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?