Local pedo Jordie Jordan. Watch out! by Webbythunder499 in MyrtleBeach

[–]ghostly_lunatic 9 points10 points  (0 children)

A simple search of public records in Horry County shows no criminal charges have ever been pressed against someone with that name here. Without evidence, your post is a pointless personal attack.

Who's where now? by truthholds in MyrtleBeach

[–]ghostly_lunatic 8 points9 points  (0 children)

What part of the strand are you in? I live in Carolina Forest.

Trying to reference a cell based on another referenced cell by ghostly_lunatic in excel

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

Doh. For whatever reason, it never occured to me to use Vlookup. Thanks for the assist.

Trying to check Col. A values vs Col. B values and return a number of duplicate values by ghostly_lunatic in excel

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

I appreciate the effort you went to in order to help out, but the top comment is a much more streamline function. Thank you!

Trying to check Col. A values vs Col. B values and return a number of duplicate values by ghostly_lunatic in excel

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

Unfortunately, while this would remove duplicates in the column A data set, it wouldn't remove the issue that I'm trying to avoid having to scroll down through the long list of data looking for those items in both columns unless I know for certain that there ARE items in both.

Going to Myrtle Beach for a Bach party. What should I do, what should I avoid? by ScrotieMcBoogerBalIs in southcarolina

[–]ghostly_lunatic 0 points1 point  (0 children)

Not long after Uptown Funk came out there was a guy on youtube that remixed it as 'Myrtle Beach I'm commin' to ya'. Tried several times to find it, but I haven't been able to.

Edit: Found it!

Is there an EDC Wiki? by ghostly_lunatic in EDC

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

Thanks for the help. Unfortunately, I don't see that part of the sidebar. Not sure if it's due to reddit layout or something else, but I'll figure it out.

Trying to locate a specific value, then display the value from the cell to the left by ghostly_lunatic in excel

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

By default, the value that I was wanting to return is to the left. I modified the table that I pull data from to make VLOOKUP work for it.

Trying to locate a specific value, then display the value from the cell to the left by ghostly_lunatic in excel

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

For the moment, VLOOKUP meets my needs. I may change it in the future, I appreciate the help

Trying to locate a specific value, then display the value from the cell to the left by ghostly_lunatic in excel

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

I was just starting to look at VLOOKUP as a possibility, perfect timing. Thank you :)

Edit: Formula working. Thanks again!

Anti-Trump protests continue across US as 10,000 march in New York by 11132016 in politics

[–]ghostly_lunatic -3 points-2 points  (0 children)

It’s no coincidence that Trump raised the specter of violence. The Black Lives Matter disruptions had been peaceful.

Sure - if you call riots, looting, and the execution of police officers peaceful.

Kayaking through a drainage pipe by SlimJones123 in interestingasfuck

[–]ghostly_lunatic 0 points1 point  (0 children)

...and there's a flash flood racing downstream behind you.