bio | website | |
---|---|---|
location | ||
age | ||
visits | member for | 2 years, 8 months |
seen | Aug 28 at 6:27 | |
stats | profile views | 5 |
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? |