Hi - How can you invert data in a row assuming that it is ordered the way you want. For Example:
C3:C10 have values 7,6,4,1,3,10, 8 I'd like to invert it on B3:B10 so that it looks like 8,10,3,1,4,6,7
Thanks!
Hi - How can you invert data in a row assuming that it is ordered the way you want. For Example:
C3:C10 have values 7,6,4,1,3,10, 8 I'd like to invert it on B3:B10 so that it looks like 8,10,3,1,4,6,7
Thanks!
Formula in B3 copied down to B9:
note your sample date is only 7 rows of data...hence 3:9
=INDEX($C$3:$C$9,10-ROW(),1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks