Question description:
This user has given permission to use the problem statement for this
blog.
Hi please see the formula in column AU on the attached. I am trying to work out why I get #N/A whenever the value in AP = "No Work Orders". Is it something to do with the fact that this comes from the formula in AT?
Solved by A. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
09/08/2017 - 01:55
Hi what is the file size limit
Excelchat Expert
09/08/2017 - 01:55
Hi, Thank you for using Got it Pro
Excelchat Expert
09/08/2017 - 01:55
% MB
Excelchat Expert
09/08/2017 - 01:55
5MB
Excelchat Expert
09/08/2017 - 01:55
you could share with a google drive link
Excelchat Expert
09/08/2017 - 01:55
or dropbox
User
09/08/2017 - 01:56
Ah that's why it said unknown error because mine was 10mb
User
09/08/2017 - 01:56
ok how please?
Excelchat Expert
09/08/2017 - 01:56
do you have a google account
User
09/08/2017 - 01:56
yes
Excelchat Expert
09/08/2017 - 01:57
ok go to drive.google.com
User
09/08/2017 - 01:57
ok
Excelchat Expert
09/08/2017 - 01:57
the go to your drive
Excelchat Expert
09/08/2017 - 01:58
and sign in with your google account
Excelchat Expert
09/08/2017 - 01:58
drag and drop the file to the drive
Excelchat Expert
09/08/2017 - 01:58
and when uploaded right click and click on get sharelable link
User
09/08/2017 - 02:00
https://drive.google.com/open?id=0B7NqkqrZU9xlczZNLVkxM3p5ak0
Excelchat Expert
09/08/2017 - 02:00
ok got it
Excelchat Expert
09/08/2017 - 02:02
which sheet should I be on?
User
09/08/2017 - 02:03
should have opened on SB Outputs
Excelchat Expert
09/08/2017 - 02:03
ok the problem is in column AT
User
09/08/2017 - 02:04
ok
Excelchat Expert
09/08/2017 - 02:04
because I3 for example does not exist in the WO Pivot sheet
Excelchat Expert
09/08/2017 - 02:05
Are you there?
User
09/08/2017 - 02:06
no but it is on SB Outputs
Excelchat Expert
09/08/2017 - 02:06
yes it is
Excelchat Expert
09/08/2017 - 02:06
are you the one who wrote the formulas
User
09/08/2017 - 02:06
the formula in AT works but the one in AU looking at AT doesn't see that AT says No Work Orders
Excelchat Expert
09/08/2017 - 02:07
I'm asking to know how advanced are you in excel to know where to start explaining from
User
09/08/2017 - 02:07
Yes I don't know excel very well so probably very clumsy methods
Excelchat Expert
09/08/2017 - 02:07
AT3 in SB Outputs returns NA
Excelchat Expert
09/08/2017 - 02:08
so when referenced in AU it returns NA
User
09/08/2017 - 02:09
Oh sorry above I was saying AT but Meant AP
User
09/08/2017 - 02:11
so probably best I just sum AQ, AR and AS instead of looking at the pivot then?
Excelchat Expert
09/08/2017 - 02:11
the file just froze
Excelchat Expert
09/08/2017 - 02:11
give me a sec
User
09/08/2017 - 02:11
in AT I mean
User
09/08/2017 - 02:11
ok
Excelchat Expert
09/08/2017 - 02:13
ok the time will run out
Excelchat Expert
09/08/2017 - 02:13
https://docs.google.com/spreadsheets/d/1u4XSgURAj-IEcl90eAdCl56zT8V4feeuEH1-dpREq-E/edit
Excelchat Expert
09/08/2017 - 02:13
please open this link
Excelchat Expert
09/08/2017 - 02:13
we will continue chatting there
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.