LinkBack URL
About LinkBacks
Looking for a formula to extract all values in column A2:A100. For example, column A2:A8 values Food, Money, Ice, Snow, Snow, Locus, Food. Need a formula to extract all these vlaues.
Thanks
Looking for a formula to extract all values in column A2:A100. For example, column A2:A8 values Food, Money, Ice, Snow, Snow, Locus, Food. Need a formula to extract all these vlaues.
Thanks
Last edited by bjnockle; 10-26-2016 at 08:50 PM.
Do you mean to put them all in one cell?
Pete
I mean extract all values in Sheet1 A1:A8 to Sheet 2
It's difficult without seeing your excel file, try to upload it with step click "Go Advanced" button and find "Manage Attachment" button to attach the file, and please explain with detail your desired results on that file
Well, the simplest way would be to put this formula in A1 of Sheet2:Originally Posted by bjnockle
=Sheet1!A1
then copy down as required.
I suspect, though, that there is a bit more to your request than this.
Hope this helps.
Pete
If values are deleted, you get #REF! and will not shift. That is why I try not to do =Sheet1!A1
Last edited by bjnockle; 10-26-2016 at 09:19 PM.
Attachment
Try this ...
=INDIRECT("Sheet1!A"&ROWS($A$1:A1))&""
hope this works
azumi: works like a charm. Thanks a million Azumi.
Phuocam: great formula, Phuocam. Works like a charm. Thanks
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks