hi!my problem is that i have lets say 3 columns for example like these.
61 250 7890
62 450 7890
63 300 7890
65 690 7769
69 480 7769
85 900 6922
i would like to make a column where if the value in the third column is the same with some other in the same column will bring me the sum of column 2 and another column that will bring the value of column a which had the bigger value in column 2.for example like this
62 1000 7890
65 1170 7769
85 900 6922
Is the 3rd column sorted or not?
Quang PT
it is sorted
The answer is in file
Appreciate the help? CLICK *
thk u but i see it brings 61 where is should bring 62 because this is the one that had the bigger value in column b for 7890
Ok, i didnt know the reson of 62 thus it was wrong. Enter the array formula below to g2 cell in my fileOriginally Posted by stratos2121
=IFERROR(INDEX($A$2:$A$7,MATCH(MAX(IF($C$2:$C$7=I2,$B$2:$B$7,"")),IF($C$2:$C$7=I2,$B$2:$B$7,""),0)),"")
do you mean Max - as you have shown Min here
62 1000 7890
65 1170 7769
85 900 6922
69 is max
see attached sheet for the result in Columns E,F & G
Last edited by etaf; 04-20-2013 at 12:06 PM.
See the file attached.
column a is not a number but a code of a customer.so i want to bring in the new column the code of the costumer that had the bigger value from column b and has the same code in column c if you get it..the two other columns are correct what you did.
i decided to stick with the solution by bebo.thk u very much all for your answers.but i have a problem to do it for more cells although i change the ranges...i hope i manage sometime tonight to do it right...
Nice to hear it works with your sample.
However, note that it is array formula, after changing your range, do not remember to confirm by hitting Ctrl-Shift-Enter key combination rather than Enter only.
stratos,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks