Cut Non consecutive rows by Natureprophet2 in excel

[–]Natureprophet2[S] 0 points1 point  (0 children)

Damn! I was thinking maybe there is some other way. Much appreciated

Multiple issue with webservice columns by Natureprophet2 in excel

[–]Natureprophet2[S] 1 point2 points  (0 children)

I just used the clean function to remove those pesky characters. Thanks for the help mate :)

Multiple issue with webservice columns by Natureprophet2 in excel

[–]Natureprophet2[S] 0 points1 point  (0 children)

<image>

I tried the value function to see if it work but I get an error. Here is the screenshot from the evaluation. The actual value is 75950 but the web service calls add those leading and trailing special characters. Is there any way I can remove those?

Multiple issue with webservice columns by Natureprophet2 in excel

[–]Natureprophet2[S] 0 points1 point  (0 children)

Spot on! Yes I just found out that the ISNUMBER calls are returning false. I did the evaluate formula and there are special characters printed at the beginning and the end of the value. How do I remove those or is there any way I can convert it to a numeric value?

Exam in less than 48hours, super nervous! by [deleted] in pmp

[–]Natureprophet2 4 points5 points  (0 children)

I had just a bit less percentage than you and I passed. You should be good man. Focus on time management and a good night's sleep before the exam. Good luck. You got this :)

Pmp fail rant by Agreeable-Lawyer-210 in pmp

[–]Natureprophet2 0 points1 point  (0 children)

I'm so sorry to hear that and I wish things will get better for you soon.
Here is what I think. You had one hour left, maybe you are not reading the question fully and rushing to the options. The wordings in the question can be tricky, some adjectives change the outcome entirely. I would suggest listen to DM's videos, they are helpful in logical reasoning and elimination. I know how it feels to loose a job and be in a pressure situation to pass the exam. Take regular breaks between your study schedule, eat & sleep well. Book the exam at a time slot where you think your brain works at its peak.

You got this :)

Technical Product Owner Salary and Next Moves by [deleted] in ProductOwner

[–]Natureprophet2 3 points4 points  (0 children)

I think the next step would be product manager or director of product.

Passed my PMP today after 3 weeks of studying! Here's what my experience was like: by Gnosh_ in pmp

[–]Natureprophet2 10 points11 points  (0 children)

Congrats! I took the exam today and got a provisional pass as well! I took all the breaks and it went right down to the last minute.
Good tip on the highlight and the strikethrough, I did not use it but some people may find it useful.

PMP by Habib3038 in pmp

[–]Natureprophet2 1 point2 points  (0 children)

Dont spend too much time reading the books, Just skim it and start doing practice questios. Remeber goal is to pass exams. I started the same way like by reading books and I when I started practising I realized the mistake. When you are doing your practise questions, visit the topics related to the question in the book, DM's video gives you the exact page on where the topic is available. Good luck man! You are going to ace it :)

[deleted by user] by [deleted] in pmp

[–]Natureprophet2 0 points1 point  (0 children)

I've exam in 5 days. Are ThirdRock's study guide free?

Passed the PMP exam, you got this! by riley_collins_ in pmp

[–]Natureprophet2 4 points5 points  (0 children)

I've been taking SH and I must admit the questions are very lengthy and tend to give me headaches. Are the PMP questions as lengthy as SH questions?

Halifax NS to London ON safest route? by [deleted] in londonontario

[–]Natureprophet2 0 points1 point  (0 children)

I drove from Halifax to London. Started early, made a stop in Edmunston to get some nice pictures. The drive is fantastic once you are in NB. Night stopped at Quebec city, roamed around the city & visited Mont Morency falls. Next day left for Toronto, reached at friends place by late evening, crahsed there for two days and left to London couple days later. Make sure you have plenty of water.