Ranking of data based on multiple criteria

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,178
Thanks Aladin. The formula works! What if the colums are next to each other. I never mentioned the column names because they aren't next to each other. There might be a couple of columns between the yes/no column and code column. Does the formula work the same?
Yes. Just adjust the ranges to suit.
 
Last edited:

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

siddharthnk

New Member
Joined
Jun 20, 2013
Messages
44
Hi Aladin,
I was working on my file using the formula. It worked up to a point and then I noticed inconsistencies. Is there a way I can send my file to you so that you can take a look at what is going wrong?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,684
Office Version
365
Platform
Windows
Is there a way I can send my file to you so that you can take a look at what is going wrong?
Not directly, it is not permitted. Refer to #4 of the Forum Rules.

If possible, post a smallish sample that demonstrates the problem, using a table like you did in your earlier posts or one of the suggestions from Attachments. Failing that, you can upload a sample that demonstrates the problem to a file-share site and provide a link to that. Note, however, that many of the helpers here choose not to download files from other sites or, due to security restrictions at work sites, are unable to download such files.


Here is another option for you to try anyway. It doesn't require the C+S+E entry confirmation.

Excel Workbook
ABCDEFG
1YES/NOCODESSERIAL NO'S
2YES12345
1
3YES123462
4NO12356
5YES123451
6NO12356
7YES123573
8YES123462
9YES123462
10YES123474
11YES123474
Serial Nos
 
Last edited:

siddharthnk

New Member
Joined
Jun 20, 2013
Messages
44
Mr. Peter_SS,

Thanks a lot. Your solution worked perfectly. I have already executed and published my report. Apologies for my late response.

Nevertheless, thanks to Mr. Aladin too for all your efforts.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,684
Office Version
365
Platform
Windows
Mr. Peter_SS,

Thanks a lot. Your solution worked perfectly. I have already executed and published my report. Apologies for my late response.

Nevertheless, thanks to Mr. Aladin too for all your efforts.
Cheers, glad you had a successful outcome. Thanks for letting us know.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,275
Messages
5,467,720
Members
406,549
Latest member
midcoastchris04

This Week's Hot Topics

Top