Steve Bernstein
- Total activity 27
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 7
Activity overview
Latest activity by Steve Bernstein-
Steve Bernstein created a post,
"comment out" columns?
Is there a way to effectively "comment out" tabs in a workbook? I.e., leave them in place but not calc them. CONTEXT: I'm toying with changes in a workbook upstream, which break the downstream ta...
-
Steve Bernstein commented,
That's an awesome way to implement the idea. Maybe could implement it in the right-click-on-tab to "duplicate sheet" process. Managing it at the column level is a great idea and, and as you may k...
-
Steve Bernstein commented,
The duplicates are legitimate. The source file is essentially a log file of changes to one of dozens of properties of a ticket listing on Stubhub, and the millisecond-grain timestamp is not granul...
-
Steve Bernstein created a post,
Easy deduping of a workbook?
I have a workbook with 14 columns of interest derived from a data source with a couple hundred columns. No rows are duplicated in the source, but in the subset of 14 columns there are duplicates. ...
-
Steve Bernstein commented,
BTW, ignore my weeks to event notion. I'm really just trying to create a histogram with breaks at seven days. Primarily this q is just to get clear on what groupbybin does.
-
Steve Bernstein created a post,
Basic GROUPBYBIN question
The documentation for GROUPBYBIN is pretty sketchy. Here's my question. I have a column with days-to-an-event, integers. I want to bucket them into weeks-to-event, so I use groupbybin(@days-to-e...
-
Steve Bernstein commented,
That's good--that'll work, thanks!
-
Steve Bernstein created a post,
How to get penultimate date in a sorted sequence of >1000 dates
I have sequences of transaction dates by buyer over a long period of time. To classify the buyers properly, I need three of those dates: the first date, the last date, and the penultimate (second...
-
Steve Bernstein commented,
Actually, I think it's "Exchange Data" I want, not Add Data--trying it now.
-
Steve Bernstein commented,
Hi Alan, Thanks-- That approach seems to add the data in a new sheet tab. I need to expand the data in the original tab, if possible. Otherwise, I guess I could try to replace the original tab wi...