Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
Polls: 2010s (Results), Animation (Jul 21st), 1974 awards (Jul 23rd), 1942 (Jul 27th)
Challenges: Low rating, Mystery/Suspense/Thriller, Benelux
Film of the Week: Spiegel van Holland, August nominations (Jul 26th)

Technical Support

Post Reply
User avatar
blueboybob
Donator
Posts: 1199
Joined: Mar 11, 2013
Location: DC
Contact:

Re: Technical Support

#1561

Post by blueboybob » June 24th, 2019, 6:55 pm

Try unlcoker on it https://www.softpedia.com/get/System/Sy ... cker.shtml

also hit f5 to refresh the window with the file

User avatar
Lammetje
Donator
Posts: 3544
Joined: Oct 04, 2013
Location: Poland
Contact:

#1562

Post by Lammetje » June 24th, 2019, 7:22 pm

blueboybob wrote:
June 24th, 2019, 6:55 pm
Try unlcoker on it https://www.softpedia.com/get/System/Sy ... cker.shtml

also hit f5 to refresh the window with the file
Unlocker took care of it. Thanks Bobby!
iCM | IMDb | Last.fm | Listal

Image
flaiky wrote::o :satstunned: :guns: :down: :facepalm: :yucky: :mw_confused: :pinch: :ph43r: :ermm: :sweat: :folded: tehe :cowbow: :think: :finger: :rip:
More memorable quotesShow
PeacefulAnarchy wrote:Active topics is the devil. Please use the forums and subforums as intended and peruse all the topics nicely sorted by topic, not just the currently popular ones displayed in a jumbled mess.
maxwelldeux wrote:If you asked me to kill my wife and pets OR watch Minions, I'd check the runtime and inquire about sobriety requirements before providing an answer.
monty wrote:If you can't take the heat, get out of the kitchen. iCM ain't for sissies.
OldAle1 wrote:stupid double post bullshit crap shit fuck
mightysparks wrote:ARGH. RARGH. RARGH. DIE.
Kowry wrote:Thanks, Art Garfunky.
Rich wrote:*runs*

User avatar
weirdboy
Donator
Posts: 3420
Joined: Jan 03, 2016
Contact:

#1563

Post by weirdboy » June 30th, 2019, 4:34 am

Lammetje wrote:
June 24th, 2019, 7:22 pm
blueboybob wrote:
June 24th, 2019, 6:55 pm
Try unlcoker on it https://www.softpedia.com/get/System/Sy ... cker.shtml

also hit f5 to refresh the window with the file
Unlocker took care of it. Thanks Bobby!
You also probably could have just restarted your computer to delete it. Sometimes the OS hangs onto a filehandle for various reasons, but a restart releases them.

User avatar
joachimt
Donator
Posts: 28588
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1564

Post by joachimt » June 30th, 2019, 6:24 pm

Is there a way to filter the ratings of a user on IMDb, meaning not your own ratings?
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
PeacefulAnarchy
Moderator
Posts: 22827
Joined: May 08, 2011
Contact:

#1565

Post by PeacefulAnarchy » June 30th, 2019, 6:38 pm

Apparently not.

User avatar
joachimt
Donator
Posts: 28588
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1566

Post by joachimt » June 30th, 2019, 7:09 pm

Thought so. Couldn't find it as well.

PdA just voted for 985 movies in the animation poll. I was curious to see how many movies he actually rated with the animation tag. Probably about the same amount. But couldn't figure out how to filter his ratings. It's also impossible to export someone else's ratings, as far as I can see.

......

Oh wait, on the profile page there is a ratings analysis. It says 1898 animated movies.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
mightysparks
Site Admin
Posts: 29217
Joined: May 05, 2011
Location: Perth, WA, Australia
Contact:

#1567

Post by mightysparks » July 3rd, 2019, 4:55 am

Excel question.

I want to use AVERAGEIF over multiple columns but it doesn't appear to work. =AVERAGEIF(Sheet1!F:F,Sheet3!A2, Sheet1!D:D) works, but if I expand the range to E:N I get an error. Do I have to add in each column separately or is there an easier workaround?
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | IMDb | LastFM | TSZDT

Image

User avatar
maxwelldeux
Donator
Posts: 5913
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#1568

Post by maxwelldeux » July 3rd, 2019, 5:43 am

mightysparks wrote:
July 3rd, 2019, 4:55 am
Excel question.

I want to use AVERAGEIF over multiple columns but it doesn't appear to work. =AVERAGEIF(Sheet1!F:F,Sheet3!A2, Sheet1!D:D) works, but if I expand the range to E:N I get an error. Do I have to add in each column separately or is there an easier workaround?
Wait - which part of that formula are you expanding to E:N? I want to make sure I understand what you're trying to do.

User avatar
mightysparks
Site Admin
Posts: 29217
Joined: May 05, 2011
Location: Perth, WA, Australia
Contact:

#1569

Post by mightysparks » July 3rd, 2019, 5:50 am

maxwelldeux wrote:
July 3rd, 2019, 5:43 am
mightysparks wrote:
July 3rd, 2019, 4:55 am
Excel question.

I want to use AVERAGEIF over multiple columns but it doesn't appear to work. =AVERAGEIF(Sheet1!F:F,Sheet3!A2, Sheet1!D:D) works, but if I expand the range to E:N I get an error. Do I have to add in each column separately or is there an easier workaround?
Wait - which part of that formula are you expanding to E:N? I want to make sure I understand what you're trying to do.
Sorry, the F:F bit.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | IMDb | LastFM | TSZDT

Image

User avatar
maxwelldeux
Donator
Posts: 5913
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#1570

Post by maxwelldeux » July 3rd, 2019, 8:19 am

There's likely a way to do it with array formulas, but I'm not quite awake enough to work that out at 1am. Otherwise, I think you're stuck with an averageifs formula repeating for each column.

User avatar
weirdboy
Donator
Posts: 3420
Joined: Jan 03, 2016
Contact:

#1571

Post by weirdboy » July 3rd, 2019, 4:04 pm

Right I think array formula would work. Maybe combine SUMIF() and COUNTIF()s?

User avatar
weirdboy
Donator
Posts: 3420
Joined: Jan 03, 2016
Contact:

#1572

Post by weirdboy » July 3rd, 2019, 5:05 pm

weirdboy wrote:
July 3rd, 2019, 4:04 pm
Right I think array formula would work. Maybe combine SUMIF() and COUNTIF()s?
I took a minute and tried this out. Using a rectangular selection (e.g. A1:G75) I was able to just do SUMIF()/COUNTIF() without an array formula.

However I'm not sure if my test case matches what you were trying to do.

User avatar
maxwelldeux
Donator
Posts: 5913
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#1573

Post by maxwelldeux » July 11th, 2019, 7:23 pm

Having some issues with my wired internet... anybody see a problem?

The ProblemShow
Image

User avatar
funkybusiness
Donator
Posts: 10446
Joined: Jan 22, 2013
Contact:

#1574

Post by funkybusiness » July 11th, 2019, 7:42 pm

my aunt has that same couch.

Post Reply