Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Query was working on my Gsgeet, then now pulls a whole sheets data in to one row rather than separate cells. Also I would like to share the file but then unshare for security reasons if you could tell me how.
Solved by E. E. in 42 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/06/2018 - 04:35
User 06/06/2018 - 04:35
Excelchat Expert 06/06/2018 - 04:35
Welcome to excelchat.
User 06/06/2018 - 04:35
Excelchat Expert 06/06/2018 - 04:36
I need to see the query formula and the sheet please.
User 06/06/2018 - 04:37
If I share the link to gsheet, is there I was I can then take your permission away afterwards?
Excelchat Expert 06/06/2018 - 04:37
Yeah, of course.
Excelchat Expert 06/06/2018 - 04:37
Before we go ahead.
Excelchat Expert 06/06/2018 - 04:37
I need to know whether you are using web query or not?
User 06/06/2018 - 04:38
I don't know what that means :) I'm using a query in Googlesheets, to pull in data from other sheets in the same googllesheet doc
Excelchat Expert 06/06/2018 - 04:38
If it is a web query/ web scraping, then I can't help you with it since web scraping is out of our service scope.
Excelchat Expert 06/06/2018 - 04:38
Oh, okay, its alright then.
User 06/06/2018 - 04:39
Do I just paste the link?
Excelchat Expert 06/06/2018 - 04:39
Yeah, that would do. Please share the link.
User 06/06/2018 - 04:39
Excelchat Expert 06/06/2018 - 04:40
I'm on the sheet, where is the query again?
User 06/06/2018 - 04:40
The query is on the Do Not Edit tab, cell A:2. It was working, but not there is an error coming from the Barclays tab,
User 06/06/2018 - 04:42
so on Do Not Edit, cell A3 is pulling out all the information from the Barclays tab, rather than putting it on separate lines like the other tabs it pulls in
Excelchat Expert 06/06/2018 - 04:44
I see the problem now.
Excelchat Expert 06/06/2018 - 04:45
Please give me some time.
User 06/06/2018 - 04:45
User 06/06/2018 - 04:49
It did work. Then stopped, so I made a new barclays tab, copied accross the info and it worked again. Then suddenly stoped!
Excelchat Expert 06/06/2018 - 04:50
Thanks for the info. Please stay with me, I'm looking into it.
User 06/06/2018 - 04:50
Great ta!
User 06/06/2018 - 04:51
On the Barclays tab, if you delete the date in I:13 it removes the error. But as soon as put the date back in it stops work
User 06/06/2018 - 04:51
Excelchat Expert 06/06/2018 - 05:01
Thanks for waiting.
Excelchat Expert 06/06/2018 - 05:02
Unfortunately I wasn't able to find any reason why it shouldn't work.
User 06/06/2018 - 05:03
Excelchat Expert 06/06/2018 - 05:05
However I have noticed that a datevalue in I5 make the formula works perfectly.
User 06/06/2018 - 05:05
what does that mean?
Excelchat Expert 06/06/2018 - 05:06
Please input a date in I5
User 06/06/2018 - 05:06
Yup that works...no idea why!?
Excelchat Expert 06/06/2018 - 05:08
I'm not sure why.
User 06/06/2018 - 05:08
I don't really want a date in I5 :) . Would one of your colleagues know?
Excelchat Expert 06/06/2018 - 05:09
Yeah, I think someone might be able to find the actual problem.
Excelchat Expert 06/06/2018 - 05:10
Once this session ends, you can post the problem again. Please mention that the date in I13 is causing the problem.
User 06/06/2018 - 05:10
Ok I need to leave the office now, will I have to pay another $9.99?
Excelchat Expert 06/06/2018 - 05:10
Would you want to know how to remove file sharing permission now?
User 06/06/2018 - 05:10
Yes please
Excelchat Expert 06/06/2018 - 05:11
Okay, Please follow the instructions.
Excelchat Expert 06/06/2018 - 05:12
I presume you already know how to share the file.
Excelchat Expert 06/06/2018 - 05:12
Please go there, At the bottom right of the "Share with others" window, click Advanced.
User 06/06/2018 - 05:12
Yup I click on the share
User 06/06/2018 - 05:12
Excelchat Expert 06/06/2018 - 05:13
Next to the person you want to stop sharing with, click Remove
User 06/06/2018 - 05:13
You are not in the list as I gave you the link rather than email invite
Excelchat Expert 06/06/2018 - 05:13
Or if you have set global permission, meaning permission for everybody,
Excelchat Expert 06/06/2018 - 05:14
Click on the change button.
Excelchat Expert 06/06/2018 - 05:15
The change button is on the right of "Anyone who has the link can view" text.
Excelchat Expert 06/06/2018 - 05:15
Have you found it yet?
User 06/06/2018 - 05:15
Ok I need to leave the office now, will I have to pay another $9.99?
User 06/06/2018 - 05:15
Excelchat Expert 06/06/2018 - 05:16
Yeah, if you want to post another session then you have to pay.
User 06/06/2018 - 05:16
Yeah sure
User 06/06/2018 - 05:16
User 06/06/2018 - 05:16
Have a nice evening!
Excelchat Expert 06/06/2018 - 05:16
I'm sorry for the inconvenience. have a great day.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc