I have 250 products , I have different winners
for each product , I need results of each seller
won how many products without showing the
rest of the sellers , thus I need a formula to do
this , see file attached , you will understand closer ,
have put the expected reults
Okay I think I found it
It should be
=IF(D1=B2,$D$1,"")
=IF(E1=C2,$D$1,"")
It does exactly what I needed
Ouch does not work , seems it only worked for seller 1 ,
seems I will wait for the answer
Would it be if , not sure , sound some match case
here , ouch
Someone maybe ?
Re-Read your example file.
Post code below in cell D2 and copy down (copy to E2 and drag down and so on as needed)
Please Login or Register to view this content.
Last edited by playaller; 04-25-2014 at 01:10 AM. Reason: Re-Read your example file - Updated Code
Works partially result is
Its writing seller 1 and both cells
seller 1 seller 1
seller 1 seller 1
While it needs to be
seller 1
seller 1
Please look closer you are almost correct , one column working
the other column e not working
I'm not sure why excel didn't update the cell reference when you copied and paste but either way it's because you need to update the reference to the header cell. When you paste in the next cell change:
=D$1
to
=E$1
and so on. Then drag the cell down. This letter will always be the column you are pasting in.
Pasting in E2 would change to
Please Login or Register to view this content.
Shelton A.
If Helpful, Add Reputaion!
Ouch same results
seller1 seller 1
seller1 seller 1
If you are sure of the answer , please fill
in the file and return back the file if you
don't mind
the formula as is, will only return the header name so if you pasted the second formula in E2 then E1 name must be still typed as seller1 in your worksheet because the formula does not determine the name to search for the E1 cell does. double check and if so change E1 name to seller2. F1 name to seller 3 and so on.
Hello makinmomb,
I am not exactly sure what you want to do. In your sample you show in Cells D1 and E1, "Seller 1", and that confuses me somewhat.
So, I have changed things a little bit, and provided you with three possible examples, of what I think you may want to have a look at.
Please see the attached sample Workbook.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
winner runner seller 1 seller 1
product 1 seller 1 seller 1
product 2 seller 1 seller 1
product 3 seller 2
product 4 seller 3 seller 3
product 5 seller 2
let me re explain this again , i think an important heading is missing
I am looking for summary of where seller 1 appears
as winner and runner , second winner , by typing
seller 1 on d2 and e2 , I hope Winon this now puts
you into the shoes of understanding
If I type seller 1 on cell d2 and e2 , it should throw
results seller 1 onto sell d3 and e4
If I type seller 2 on d2 and e2 , it should throw
results sellere 2 on d5 and and e7
Its thus a sum of which products seller 1 has won and
which he is runner up , without informing the rest of the
sellers
Anyone maybe ?
Hello makinmomb,
Maybe the attached Workbook will now be okay with you?
Regards.
D3 = if(B3=D$2,D$2,"")
and drag to the right and below.
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.
Winon yours correct too, thanks , but I pick that of Oeldere ,
look at its shortness and simplicity , I almost struggled
with the same kind if you see in the loop string but was
not able to write it correctly
Hello makinmomb,
Thank you for the feedback.
Glad your problem has been solved now.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks