John Mulhall
- Total activity 14
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 0
Activity overview
Latest activity by John Mulhall-
John Mulhall commented,
Thanks Jason, that makes perfect sense...
-
John Mulhall created a post,
What does the blue 100% at 2 (count) mean
I have a dependency tree with one of the branches splitting at 0.5 ending with a pie chart that makes sense and one that has now breakout information. It is coloured in blue, has 100% of 2 and that...
-
John Mulhall commented,
Thanks Gido & Joel... the Booleans work for me and have added value to the analysis... onwards we go bro's!
-
John Mulhall commented,
Hey Joel.. any other cool commands that are not immediately obvious like GT that a relative newbie like me would like. I presume LT is a command also?
-
John Mulhall commented,
Joel, thank you for this. It was a silly mistake! I have corrected my error and it works just fine. Will be back with more questions.. I am generating them as a I work an analysis..
-
John Mulhall commented,
Hi, thanks for the formula dude.. it crashed the sheet with on both occassions with Sheet contains errors. Sheet 'CrashData2010' referenced in 'ProcDataSheet' does not exist in: [NYC_NYPD_CrashData...
-
John Mulhall created a post,
What is the best way of creating a boolean column based on an integer column?
AnsweredHi Folks, what is the best way in a workbook of creating a boolean column based on an integer column. If I was to pseudo code it, it would be as follows: OPEN CODE if("#_CrashData2010!NUMBER_OF_PE...
-
John Mulhall commented,
Thanks Joel, so it basically works like a manual version of the DISTINCT command in SQL, right?
-
John Mulhall commented,
Thanks Joel for your continuing engagement on this. So, if I GROUPBY (#Column A) and row 1 and 3 (col A) have identical identifiers, will the dulicate cell in Col A be removed or will be row/record...
-
John Mulhall commented,
Joel, thanks for this. Much appreciated! It seems like a cumbersome way to deduplicate records in a process. Is there any specific function to do de-deduplicate records like the "UNIQUE" function f...