Excel 2007
Windows XP Pro
Based on the Main Acct (Column B) and highest Unique Value (Column C) how can I retrieve a result of a Y (Column D) for the highest value for a Main Acct? Terrible explanation I feel like, but an example of what I am trying to accomplish is below. I've tried using a Max function, but to no avail. I have basic knowledge of Excel, but this might be well beyond my limitations. Any help provided would be extremely appreciated.
<TBODY>
</TBODY>
<TBODY>
</TBODY>
Windows XP Pro
Based on the Main Acct (Column B) and highest Unique Value (Column C) how can I retrieve a result of a Y (Column D) for the highest value for a Main Acct? Terrible explanation I feel like, but an example of what I am trying to accomplish is below. I've tried using a Max function, but to no avail. I have basic knowledge of Excel, but this might be well beyond my limitations. Any help provided would be extremely appreciated.
Acct</SPAN> | Main Acct</SPAN> | Unique</SPAN> | Result</SPAN> |
123</SPAN> | 11111</SPAN> | 3</SPAN> | ????</SPAN> |
321</SPAN> | 11111</SPAN> | 2</SPAN> | ????</SPAN> |
443</SPAN> | 11111</SPAN> | 1</SPAN> | ????</SPAN> |
556</SPAN> | 22222</SPAN> | 1</SPAN> | ????</SPAN> |
487</SPAN> | 33333</SPAN> | 1</SPAN> | ????</SPAN> |
456</SPAN> | 44444</SPAN> | 5</SPAN> | ????</SPAN> |
789</SPAN> | 44444</SPAN> | 4</SPAN> | ????</SPAN> |
987</SPAN> | 44444</SPAN> | 3</SPAN> | ????</SPAN> |
654</SPAN> | 44444</SPAN> | 2</SPAN> | ????</SPAN> |
234</SPAN> | 44444</SPAN> | 1</SPAN> | ????</SPAN> |
<TBODY>
</TBODY>
Acct </SPAN> | Main Acct</SPAN> | Unique</SPAN> | Result</SPAN> |
123</SPAN> | 11111</SPAN> | 3</SPAN> | Y</SPAN> |
321</SPAN> | 11111</SPAN> | 2</SPAN> | N</SPAN> |
443</SPAN> | 11111</SPAN> | 1</SPAN> | N</SPAN> |
556</SPAN> | 22222</SPAN> | 1</SPAN> | Y</SPAN> |
487</SPAN> | 33333</SPAN> | 1</SPAN> | Y</SPAN> |
456</SPAN> | 44444</SPAN> | 5</SPAN> | Y</SPAN> |
789</SPAN> | 44444</SPAN> | 4</SPAN> | N</SPAN> |
987</SPAN> | 44444</SPAN> | 3</SPAN> | N</SPAN> |
654</SPAN> | 44444</SPAN> | 2</SPAN> | N</SPAN> |
234</SPAN> | 44444</SPAN> | 1</SPAN> | N</SPAN> |
<TBODY>
</TBODY>