92 reputation
17
bio website
location
age
visits member for 2 years, 8 months
seen Aug 28 at 6:27

Apr
14
asked How to make \\MachineName\SharedFolder equivalent to \\MachineName\c$\SharedFolder on Windows
Jan
13
awarded  Student
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
accepted How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
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
13
awarded  Scholar
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.
Jan
12
asked How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?