192 reputation
11
bio website movingsql.com
location New Jersey
age 56
visits member for 4 years, 11 months
seen May 5 at 12:41
coder & programmer of many defunct languages...

May
5
awarded  Caucus
Apr
24
awarded  Popular Question
Sep
13
revised 2007 Worksheet Opens with Errors in 2010
deleted 1 characters in body
Sep
13
revised 2007 Worksheet Opens with Errors in 2010
added 503 characters in body
Sep
13
asked 2007 Worksheet Opens with Errors in 2010
Apr
25
comment How to count number of distinct values in a range?
This is the part that I'm having trouble with: "coming up with a scaled value for each distinct value based on how many iterations there are in the column." If I understand this, then SUMPRODUCT is effectively executing a loop like for each [i] in A2:A100 DO:{ sum += (([i]<>"")/COUNTIF(A2:A100,[i])) }, right? I am having a little trouble understanding how it knows to enumerate both the conditional and the 2nd COUNTIF parameter, but not the 1st COUNTIF parameter? Is this DWIM-magic documented/explained anywhere by MS? It would be nice to know how to write these intentionally.
Apr
25
awarded  Commentator
Apr
25
comment How to count number of distinct values in a range?
How/why does this work???
Apr
19
comment How do I apply formulas to subtotal rows?
Generally this is done the other way around: you apply subsequent formulas to just the data rows and skip the subtotals. Most of the time that should work out to the same result.
Mar
29
awarded  Critic
Mar
20
accepted How can I turn a Calculated Column back into a data column in an Excel Table?
Mar
20
comment How can I turn a Calculated Column back into a data column in an Excel Table?
Yes, that worked! Thanks! Any insights on the second part?
Mar
20
asked How can I turn a Calculated Column back into a data column in an Excel Table?
Oct
11
revised Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
added 429 characters in body
Oct
11
awarded  Editor
Oct
11
revised Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
added 25 characters in body
Oct
10
answered Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
Oct
9
comment Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
Offhand it sounds like it's trying to access a Domain Controller to do a security lookup.
Apr
2
awarded  Popular Question
Jan
26
comment How can I change my Desktop Icons “Gravity” on XP?
I knew that. Not what I asked for.