IF Statement against an array (or range of cells)

[mollys]

Here we go again!

<table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width: 30px;"> <col style="width: 64px;"> <col style="width: 89px;"> <col style="width: 85px;"> <col style="width: 166px;"> <col style="width: 101px;"> <col style="width: 105px;"> <col style="width: 125px;"></colgroup> <tbody> <tr style="font-weight: bold; font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td></tr> <tr style="height: 19px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td> <td style="font-weight: bold;">Date</td> <td style="font-weight: bold;">Placement ID</td> <td style="font-weight: bold; background-color: rgb(204, 255, 204);">Identifier</td> <td style="font-weight: bold; background-color: rgb(204, 255, 204);">Placement Name</td> <td style="font-weight: bold;">3p Impressions</td> <td style="font-weight: bold; background-color: rgb(204, 255, 204);">Raw Cost </td> <td style="font-weight: bold; background-color: rgb(204, 255, 204);">Real Media Cost </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">2/15/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">12345</td> <td style="text-align: right;">12345</td> <td>Flat Fee Placement 12345</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,666.67 </td> <td style="text-align: right;">$ 1,666.67 </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">3/2/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">65432</td> <td>ABC Package</td> <td>Flat Fee Placement 65432</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,250.00 </td> <td style="text-align: right;">$ 1,250.00 </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">3/2/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">65431</td> <td>ABC Package</td> <td>Flat Fee Placement 65431</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,250.00 </td> <td style="text-align: right;">$ - </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">4/2/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">65432</td> <td>ABC Package</td> <td>Flat Fee Placement 65432</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,250.00 </td> <td style="text-align: right;">$ 1,250.00 </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">4/3/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">65432</td> <td>ABC Package</td> <td>Flat Fee Placement 65432</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,250.00 </td> <td style="text-align: right;">$ - </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">3/12/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">12345</td> <td style="text-align: right;">12345</td> <td>Flat Fee Placement 12345</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">0</td> <td style="text-align: right;">$ - </td> <td style="text-align: right;">$ - </td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">3/13/2011</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">12345</td> <td style="text-align: right;">12345</td> <td>Flat Fee Placement 12345</td> <td style="font-size: 10pt; font-family: Arial; text-align: left;">50,000</td> <td style="text-align: right;">$ 1,666.67 </td> <td style="text-align: right;">$ 1,666.67 </td></tr></tbody></table>

The column in question is G. Here are the rules:
WITHIN THE SAME MONTH, each unique identifier (column C) should only be paid once.
I want a formula comparing the month of each row, against every row above it, but when I wrote it, the formula stops at the first instance of that unique identifier.
Is there a way to change this: MONTH(A8)<>MONTH(INDEX(A:C,MATCH(C8,$C$1:C8,0),1)

so that it looks at every MATCH instance?

Thank you thank you thank you!!

 

[venkat1926]

the data should be first sorted according to the month of column A , ascending.. for this you can use a column H and type against H2 =month(a2) and copy down;.use this column for data to be sosrted

some more clarity is required. which is the PAID column F or G. some entries in column G are blank that means that is not paid.l

clairfy and sort and post back the data.

 

[Peter_SSs]

I'm agreeing with venkat - its not clear. For your sample data,
- exactly what result(s) would you expect?
- how do you arrive at the result(s) expected (description of logic process)?
- where would the result(s) be placed?