75 reputation
7
bio website
location India
age
visits member for 3 years, 4 months
seen 6 hours ago

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


Mar
17
comment How to check if a date is within a given range in Microsoft excel
A hint: You can use the IF function. You need to a put formula, where you want X to be displayed. Something like =IF(Condition,CHAR(88),CHAR(32)). So if the condition is true it will display X, else BLANK. Now work on the Condition part of your problem.
Mar
16
awarded  Commentator
Mar
11
comment Notepad++ ; How to remove pending action
Try using Portable version [portableapps.com/apps/development/notepadpp_portable] of notepad++ so that you can install without Administrator rights.
Mar
9
revised how to view all process details from ps –ef command
Grammatical & spelling corrections only.
Mar
9
suggested approved edit on how to view all process details from ps –ef command
Mar
5
comment How to “draw” a square grid on excel?
Are you trying to draw rectangles with specific dimensions ? Insert-Shapes Now select rectangle. Then right click on the rectangle, select "Size and Properties..", now set the Height & Width.
Mar
5
comment Time format of Pomodoro in LibreOffice Calc
Yes, it is working at least in the cases I tried: I copied the formula from F4 in F5. Then entered 5 in B5 cell. Now enter =F5-F4 in F6, =F4+F5 in F7. You will now see 2:05 in F5, :25 in F6, 4:10 in F7 etc.
Mar
3
comment Time format of Pomodoro in LibreOffice Calc
Try =TIME(INT(B4*25/60), MOD(B4*25,60),0) in F4, where F4 is having hh:mm format, to get the desired results.
Feb
5
awarded  Informed
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 approved 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 approved 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.