Impact
~6k
people reached
- 0 posts edited
- 0 helpful flags
- 7 votes cast
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? |