Hi. I have a column with numbers. For example,
Column A
1
3
2
4
My goal is to have the following:
Column B
1
1
3
3
2
2
4
4
"Double" the results.
Hope you understand what I'm trying to do!
Thanks for any help!
Hi. I have a column with numbers. For example,
Column A
1
3
2
4
My goal is to have the following:
Column B
1
1
3
3
2
2
4
4
"Double" the results.
Hope you understand what I'm trying to do!
Thanks for any help!
copy the list in column A
Past it below the last value
after that sort the data A - Z
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks for your answer but I'm looking for a formula because this column is part of a macro with different scenarios that runs literally thousands of times!
a b c d 4 1 1b4: =index($a$4:$a$7, (rows(b$4:b4)+1)/2) 5 3 1 6 2 3 7 4 3 8 2 9 2 10 4 11 4
Entia non sunt multiplicanda sine necessitate
Thank you shg! This was what I was looking for!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks