Reputation
284
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 5 18
Impact
~97k people reached

  • 0 posts edited
  • 0 helpful flags
  • 39 votes cast
Jun
23
comment Is there a union operator in Excel?
Note that there is nothing function-specific about this operator, it works everywhere. For example =(A2,C8,C10) A2 will give the intersection of A2 and (A1,C8,C10) just to give an insane example. Note that in general you'll want to avoid this
May
12
awarded  Famous Question
Jan
30
awarded  Popular Question
Oct
7
awarded  Notable Question
Oct
5
accepted Excel scatter plot with multiple series from 1 table
Sep
24
awarded  Autobiographer
Sep
1
awarded  Popular Question
Jul
2
awarded  Curious
May
6
comment Excel scatter plot with multiple series from 1 table
@BrianFunt Yes I forgot that point
May
6
comment Excel scatter plot with multiple series from 1 table
I've also added the plotted chart to show what I want to achieve, but automatically.
May
6
revised Excel scatter plot with multiple series from 1 table
Added the resulting chart
May
6
comment Excel scatter plot with multiple series from 1 table
@CharlieRB PivotTable's give aggregates of the data right? I want all the data points to be visible in the chart, so how can PivotTables help me?
May
6
asked Excel scatter plot with multiple series from 1 table
Mar
14
comment git clone fails with “bad object” under msys2 in a VM
msysgit is the official version of git for windows so I would advice you to try it (it's made for windows instead of running under a generic compatibility layer), but that might not be the problem. The only time I've seen problems like this is when the repo contained files with a : in the filename (allowed in POSIX but not in Windows), but that gave a different error.
Feb
16
accepted Extract Word creation date into filename
Feb
16
comment Extract Word creation date into filename
That worked perfectly, thanks
Feb
15
comment Extract Word creation date into filename
Thank you, that seems suitable. I indeed can use a regex with this information, but do you know how I can use regexes in Powershell to rename files?
Feb
15
accepted Share cost of activities between participants in spreadsheet
Feb
15
comment Share cost of activities between participants in spreadsheet
1/$I2:$I4 didn't work, but making the total column 1/SUM(...) and using sumproduct on that did work. Thanks!
Feb
15
asked Extract Word creation date into filename