53 reputation
5
bio website
location India
age
visits member for 2 years, 11 months
seen Oct 13 at 7:24

Currently working on IBM midrange (earlier on mainframes).
Love to solve puzzles.
Fan of Martin Gardner, W W Sawyer, Ya Perelman, Carl Sagan, Isaac Asimov, George Gamow, Raymond Smullyan, Richard Dawkins, Douglas Hofstadter.
Interested in Maths & Science education, science popularization.


Sep
24
awarded  Autobiographer
Sep
13
comment Double column value in a spreadsheet
Or put =C1+C1 in F1 and copy to all the cells below, till you have values in column C.
Aug
12
awarded  Citizen Patrol
Jul
25
revised Autofill in Excel skipping rows
Grammatical correction
Jul
25
suggested suggested edit on Autofill in Excel skipping rows
Jul
10
comment Modifying the System Path variable from cmd
You can see answers to this [question].(superuser.com/questions/758950/…) and this(superuser.com/questions/284342/…)
Jul
6
revised How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)
Minor spelling corrections
Jul
6
suggested suggested edit on How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)
Jul
5
revised What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?
added 145 characters in body
Jul
5
answered What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?
Jun
20
comment Finding duplicate values occurring consecutively
Thanks for the suggestion, now I have revised the answer.
Jun
20
revised Finding duplicate values occurring consecutively
changed the answer as per the suggestion
Jun
20
revised Finding duplicate values occurring consecutively
added 348 characters in body
Jun
20
answered Finding duplicate values occurring consecutively
Feb
17
comment Complete the sequence 1 2 3 up to 156 in Notepad++?
OK, so I made the usual off-by-one error.
Feb
17
comment Complete the sequence 1 2 3 up to 156 in Notepad++?
No, you don't have to go to the beginning of the first line. While recording the macro you have already created the first line. Now play the macro 155 times ( Option Run a macro multiple times ) to get the 156 ( 1 + 155 ) lines. Now ctrl + Home will get you to the beginning.
Feb
17
answered Complete the sequence 1 2 3 up to 156 in Notepad++?
Jul
7
answered Extracting an item from a list in Excel
Dec
31
awarded  Supporter
Dec
29
awarded  Editor