Trouble with adding to a formula

Steviefiege

Board Regular
Joined
Aug 29, 2018
Messages
66
Hi,

This is my formula:

=IF(O4="","",SMALL(IF($C:$C=O4,ROW($C:$C)),COUNTIF(O$4:O4,O4)))

I want to add if($b:$b=n2,ROW($b:$b). I tried putting it in the middle but it says theres an error in the formula, what am i doing wrong?

Rgs
Steve
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,648
You can't attach files can you?
Steviefiege,

It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
You can't attach files can you?
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
 

Steviefiege

Board Regular
Joined
Aug 29, 2018
Messages
66
Any luck in helping me with the formula please?
 

IbrahimAnjum

New Member
Joined
Sep 13, 2018
Messages
6
What do you want to achieve as n2 is the heading and b column is the column where the position, Goal keeper is written
 

Steviefiege

Board Regular
Joined
Aug 29, 2018
Messages
66
If you look down in the N column, theres a player there called Jones, Louis, he shouldn't be there, it should be Amos, Danny. Whats happened is is that its looked for the first person with that rating & found him. I want it to look at the position which is in n2 so it finds the correct player, the one with the rating who plays in that particular position.
 

Forum statistics

Threads
1,085,546
Messages
5,384,373
Members
401,890
Latest member
Angela7

Some videos you may like

This Week's Hot Topics

Top