Reputation
1,011
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 12
Newest
 Yearling
Impact
~105k people reached

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
Jan
15
revised How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
max nr of indexes
Jan
15
answered How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
Jan
15
comment How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?
if this is a 1-off problem that does not need automatic solution, see Splitting concatenated Excel columns at spaces? and other Related anwers listed here
Jan
15
answered Increment numbers inside a text in microsoft excel 2007
Jan
15
answered Multiple data points in a graph's labels
Jan
5
awarded  Self-Learner
Dec
1
answered Excel - how can I count rows based on three column values?
Oct
8
revised How do I join two worksheets in Excel as I would in SQL?
added 10 characters in body