CountIF Formula

[gopinath_try]

Hi All,
Need Help with Excel Formula...

I have 2 sheets in my workbook.

How to retrieve corresponding servername & Groupnames into cell? in Sheet2 with the help of excel farmulas?

Pls, find attached xl file. & Help me...

Early help appriciated.

Thanks in advance
[email protected]

[gopinath_try]

Hi All,
I Need Help with Excel Formula...

I have 2 sheets in the workbook test1.xls (Pls See Attached test1.xls)

On Sheet2 - How to retrieve corresponding servername & Groupname from sheet1 to Sheet2 cell? with the help of excel farmulas?

Early help appriciated.

Thanks in advance
[email protected]

[Domenic]

First, unmerge cells A3:C3, move the text (Server 1) from A3 to B3, and merge B3:C3. Then try the following...

B2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=INDEX(Sheet1!$B$3:$I$3,MATCH($A2,INDEX(Sheet1!$B$5:$I$14,MIN(IF(Sheet1!$B$5:$I$14=$A2,ROW(Sheet1!$B$5:$I$14)-ROW(Sheet1!$B$5)+1)),0),0)-1)

C2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=INDEX(Sheet1!$B$5:$I$14,MIN(IF(Sheet1!$B$5:$I$14=$A2,ROW(Sheet1!$B$5:$I$14)-ROW(Sheet1!$B$5)+1)),MATCH($A2,INDEX(Sheet1!$B$5:$I$14,MIN(IF(Sheet1!$B$5:$I$14=$A2,ROW(Sheet1!$B$5:$I$14)-ROW(Sheet1!$B$5)+1)),0),0)-1)

See the attached file...

Hope this helps!

[Domenic]

Duplicate post...

http://www.excelforum.com/showthread...=1#post1923220

[VBA Noob]

Thanks Domenic,

gopinath_try,

You have already being asked to read the forum rules. Please do read these rules as if you continue to ignore them you may be banned from the forum

http://www.excelforum.com/showthread.php?t=645138

VBA Noob