Hi Experts. I know this forum is best to those want to learn in excel/vba.
Please help me to solve this problem.
I need to sort this items by rows and columns based on their x and y coordinates.
Input Photos:
The x and y columns are their coordinates.
\1
This should be the output without the x and y coordinates
\1
Thank you everyone in advance
Last edited by dotdll; 11-17-2015 at 10:20 PM.
You could use the UDF CountIfs
Put =concatifs($A$2:$A$11,$B$2:$B$11,F$1,$C$2:$C$11,$E2) in F2 and drag down and right
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi mickerickson,
it seems that there is no "concatifs" in excel 2010.
Maybe im just to weak to do this. can you send me your sample?
Thank you my friend.
ConcatIfs is a UDF, not a part of any version of Excel.
Copy paste the posted code into a normal module and the function will be available to you.
Got it!!
My mistake.
You are so nice, now its working!!
Additional question, on the output image above the coordinate is hard coded. What if i will remove those?
Output should look like this
output_1.JPG
Thanks a lot.
You could use
=concatifs($A$2:$A$11, $B$2:$B$11, 10*COLUMN(A1), $C$2:$C$11, 10*ROW(A1))
But this depends on all the values in B and C being multiples of ten, it will not catch any items whose coordinates are intermediate values (e.g. 12)
I see. may be I should go with your first advised since those coordinates values sometimes not in whole numbers (eg. 22.72, 81.4, etc). I will try to work and get those output to another sheet or workbook.
Thanks again my friend, you help me alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks