Reputation
1,301
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 6 13
Impact
~174k people reached

1d
awarded  Great Answer
Apr
22
revised Function argument delimiter - Excel 2011 for Mac OS X
highlight the 2 settings
Apr
22
answered Function argument delimiter - Excel 2011 for Mac OS X
Feb
17
awarded  Yearling
Jan
2
awarded  Excavator
Jan
2
revised Hide webpage headers that remain “stuck” at the top when scrolling
update title to match the question contents
Jan
2
suggested approved edit on Hide webpage headers that remain “stuck” at the top when scrolling
Jan
2
answered Hide webpage headers that remain “stuck” at the top when scrolling
Feb
17
awarded  Yearling
Feb
7
comment How to have num lock enabled by default on log on screen?
"press Num Lock in logon screen and then restart you system without login" - from comments under tweaks.com/windows/64867/…
Jan
16
comment Sumif & Indirect
to provide the sheet name
Jan
16
comment Sumif & Indirect
I see your point - @Ryan should it be sensitive to row insertion? if you add a new row between 2 and 102, should the formula update to F2:F103?
Jan
16
comment Sumif & Indirect
what is your point? INDIRECT is volatile already and CELL returns $G$2, $H$2 and so on when you copy it, the dollar signs themselves are completely irrelevant in this particular case
Jan
16
comment Sumif & Indirect
CELL("address", F2:F102)
Jan
16
comment How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
Application.Min(LBound(arr1), LBound(arr2)) is a bit excessive way to say 0, otherwise works fine
Jan
16
comment How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
very nice trick for constant number of items to split & merge
Jan
15
awarded  Organizer
Jan
15
revised How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
improve title
Jan
15
suggested approved edit on How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
Jan
15
revised Unicode play icon ▶ present in a page title is incorrectly displayed in my Firefox
already fixed