Hello,
I am trying to get the mirror image of a row of data.
Let's say I have data in cells A1, B1, C1, D1, etc. and I want to change this to D1, C1, B1, A1.
Is there a function that can do this?
Thanks!
Hello,
I am trying to get the mirror image of a row of data.
Let's say I have data in cells A1, B1, C1, D1, etc. and I want to change this to D1, C1, B1, A1.
Is there a function that can do this?
Thanks!
You could do the following:
E1: =INDEX($A1:$D1,5-COLUMNS($E1:E1))
copied to H1
Is that what you want ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
that looks like it will work, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks