I have tables containing a mix of cell contents copied from another location and "new" content. As new rows are added I want to present data in ascending order of entries in one row. The attachment shows that thiis doesn't happen as predicted. The "before", "during" & "desired" after are all clearly illustrated in it.
If you want to sort then the references should be absolute
=IF(J$2="","",J$2)
If you look at your Table.. 1st 3 column are reference.. where lst 4 columns are pasteAsValue..
Keep all in the same manner.. will work ..
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Unfortunately, neither of these do what I want, as the data ARE a mixture of references and "freshly entered" text.
did you try mixing absolute references and 'fresh text'?
I assume it is the bottom set of tables you are sorting?
Yes i did try..
See the notes in rows 27-32 for an explanation of what I'm (not) doing... The colured cells, relating to the new CC (222) show the problem that I've run up against. Thanks for you patience....
Andy - got it now... I see the mistake that I'd made. Do have some rep...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks