92 reputation
17
bio website
location
age
visits member for 2 years, 11 months
seen Dec 14 at 16:47

Aug
14
comment Outlook Keyboard Shortcut to Jump from Task's Subject to Task's Note
this looks promising. I'm guessing this can be invoked within outlook. right? how?
Aug
8
comment Outlook Keyboard Shortcut to Jump from Task's Subject to Task's Note
yeah... that's what I'm using till now :)
Aug
8
comment Outlook Keyboard Shortcut to Jump from Task's Subject to Task's Note
no it worked for outlook 2007, but not for 2010 :(
Aug
2
comment Outlook Keyboard Shortcut to Jump from Task's Subject to Task's Note
sorry my notes are multi-line and in rich text format :(
Aug
2
comment Outlook Keyboard Shortcut to Jump from Task's Subject to Task's Note
yes I know this. But I was searching for one key shortcut. If none, can I assign this (like we do in Visual Studio). Thanks!
Jun
20
comment Why does this work: Windows same local admin username and password, able to access other computer?
Does that mean windows just hashes passwords and compares hashes in above case?
Apr
15
comment How to make \\MachineName\SharedFolder equivalent to \\MachineName\c$\SharedFolder on Windows
so in short answer to 2nd question is no. Right?
Jan
13
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
No Id. But in my case employee name is unique. Can be treated as Id. Won't I've to keep this id sorted. I came to know that VLookup needs sorted array for lookup.
Jan
13
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
Nice. Simple solution :) Thanks! Though I wish if there can be a solution which avoids this duplication, but I guess with excel, most solutions to tricky problems involves some form of duplication.
Jan
13
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
I found this... support.microsoft.com/kb/181212 this should work?
Jan
13
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
I've one concern. As you mentioned table_array for vlookup needs to be sorted. Lets say initially I've sorted array with manager column referenced like =A3 before, if I add new employee detail into this table I will face the same old problem again when I sort. How to prevent this?
Jan
12
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
this is a huge list. Sorting is a frequent operation. in above case I mentioned age only, but in actual case, I'll have more such columns and more sort operations. Re-entering references is not an option.
Jan
12
comment How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
I tried that. It doesn't work. It replaces the value to whatever fills up after sorting in A3. I even tried $A3 but that didn't do the trick either.