Having problem trying to use array with indirect function

I don't quite understand your explanation, but the formula below will select the two cells 1 column to the left and two rows up from the cell with the formula, using N1 as the criteria:

Please Login or Register  to view this content.

Okay, I'm trying to look to see if there are partial duplicate text inputs in my excel list. they are all in alphabetical order, and the duplicates only are variations of the previous 1 or 2 in the list, for
example Agent P and Agent P Infinite, where I don't want to count the Infinite one, but only the original ones. I've been trying different formulas and can't seem to figure it out without making a separate
column to check if they're duplicates then sum up that column, but I would like to avoid that if possible. Sorry This is probably more advanced then I should be attempting.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!