LinkBack URL
About LinkBacks
Hi
Can these be accomplished without formulas?
Thanks
Hi
Can these be accomplished without formulas?
Thanks
Try in D1:
=INDEX($C$1:$C$15,ROWS($C1:$C$15))
Copy down.
For COlumn A (NUmber): put this on cell A15 and copied up to A1
=16-ROWS($A$1:A15)
For Column D (Text): put this on D1 and copied down as necessary
=OFFSET($C$15,-(ROW(A1)-1),0)
Thank you all!
I was hoping there were internal commands that I overlooked to accomplish those simple tasks without formulas!
As my knowledge the efficient way to overcome simple problem is with formula
Are you looking for a VBA solution?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
No, I thought it might be a command hidden in the menu somewhere like the paste / transpose (for the 2nd question).
The Paste Special Transpose command takes a vertical range and makes it horizontal or vice versa. There is no command that will paste the inverse of the array.
Understood.
Let me see a vba code for the inverse, including dialogs please select input range and output point.
Thanks
OK. If you want VBA for this, then you need to flag this in your thread title to alert the VBA experts (I am not one - sorry).
I need to ask a moderator to move the thread?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks