Thread
:
how to make rows 'sort with' between sheets during separate sorts
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
ryguy7272
external usenet poster
Posts: 2,836
how to make rows 'sort with' between sheets during separate so
Sorry to take it offline, but I couldn't really understand what was needed.
Anyway, for those following this post, the issue was resolved with this
function:
=INDEX($A$1:$A$10,MATCH(ROW(A1),COUNTIF($A$1:$A$10 ,"<="&$A$1:$A$10),))
Ctrl+Shift+Enter
This 'alphabetizes' the array.
Ryan--
--
RyGuy
"RyGuy" wrote:
I can't see the file. Send it to me at:
(remove the xxx).
Regards,
Ryan--
"Margo" wrote:
I've uploaded a copy of the spreadsheet he
http://www.megaupload.com/
What I need to do is be able to perform sorts on Sheet1, then on any column
in Sheet2, and still have the rows hold true when I go back and perform
additional sorts on Sheet1 again. Also, under normal circumstances, any
columns with formulas would be locked and sorts performed via macros.
Thank you very much for any help - it's driving me crazy.
"ryguy7272" wrote:
I don't know about others, but I'm confused. If you can give somehow give an
actual example, with actual data, I'll try to help you.
Regards,
Ryan--
--
RyGuy
"Margo" wrote:
What I need to do is perform sorts on any column on either sheet that will
'hold' onto its respective row if linked from one sheet to the other.
IOW some columns on sheet 1 have formulas based on values in sheet 2 and
vice versa. But the columns referenced for values are not the same ie S2A1
has formula based on the value in S1B1, and S1C1 has formula based on the
value in S2C2.
All initial sorts I perform on S1, in any column, any way, carries over fine
to S2 (the first time I perform it), but then when I perform sorts on S2 that
sort doesn't carry back over to S1.
Sorts on both sheets, in several columns, filled with either values or
formulas, need be done a constant basis.
Reply With Quote
ryguy7272
View Public Profile
Find all posts by ryguy7272