LinkBack URL
About LinkBacks
HI ,
I would like to get the reverse of the numbers ie. reverse the numbers so that the number at the bottom occurs on top, and so on. by using OFFSET function
HI ,
I would like to get the reverse of the numbers ie. reverse the numbers so that the number at the bottom occurs on top, and so on. by using OFFSET function
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
DATA ROWS Reverse order
20 1
5 2
8 3
4 4
25 5
30 5
5 6
Like this I have almost 300 rows and for which I haveto get 300 to 1
Your example makes no sense to me. And I asked that you provide a workbook with a before and after scenario. Did you read the instructions for attaching a file?
Assuming that your list is in A2:Axxx, try this in B2 and fill downFormula:
Please Login or Register to view this content.
I cannot share the excel . Sorry ! Need to use the OFFSET function is mandatory.
Why mandatory, is it for a course assignment?Originally Posted by vandanare
Yes, It was mentioned to use the OFFSET function
In that case, I would suggest taking a different course that doesn't teach you bad habits. In my opinion, OFFSET is the wrong tool for the job.
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
Thank you for the response !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks