1, 2, 3.. IF formula and Rank If Uniques

[Lewzerrrr]

Hi,

I'd have 2 separate data sources, 1 is a list of values that's automatically sorted highest to lowest. I have a formula that puts a Y next to a value if it meets a criteria. (This is in column B). What I'd like in column A is to place a 1, 2, 3.. but skip if the value in B is a Y. I only need to go up to 20 so it can be as complex as need be.

The 2nd is a list of values that isn't sorted at all, it's a list of serial #s with their sales next to. Again in column B is Y's if they meet criteria. I want to rank only the NON Y serials whilst also ignoring duplicates. Again I only really need to go up to rank 20 so can be a complex formula.


Here's 2 tables and the results I'd like to see.

1		95		11		22
2		95		7		46
3		92		6		50
	Y	83		4		73
4		73		1		95
5		69			Y	64
	Y	64		2		95
6		50		8		46
7		46		3		92
8		46		5		69
9		37		15		7
10		31		12		19
11		22			Y	83
12		19		13		14
13		14		14		12
14		12		9		37
15		7		10		31

<tbody>
</tbody>

 

[Jeffrey Mahoney]

I assume that row 1 is headers and Cell A2 is the first Rank value. In cell A2 put:
=IF(AND(B2<>"Y",C2<>""),MAX($A$1:A1)+1,"")

Jeff