finding out more than one match value???????

[md@xl]

HI,

I HAD A PROBLEM WITH THE MATCH FUNCTION,PLEASE HELP ME IN SOLVING THE PROBLEM BY APPLYING ANY OTHER FORMULA.BY APPLYING THE MATCH FORMULA I AM ABLE TO GET THE COLUMN NO OF FIRST MATCH VALUE,HOW I CAN THE
COLUMN NUMBER OF OTHERS MATCH VALUES.


Thanks.

[Teethless mama]

Try this:

=SMALL(IF(C6:H6=J6,COLUMN(C6:H6)-COLUMN(C6)+1),n)

n = 1 (first match)
n = 2 (second match)
n = 3 (third match)
and so on...

Array formula press Ctrl+Shift+Enter, not just Enter

[md@xl]

thank u very much for responce but it does not work out,i am geeting a message an error in formula.please sort it out.solution with an attachment will be helpful.

[FDibbins]

Did you enter using CTRL SHIFT enter?
Did you change n to a number?