Get the Highest Count

[puuts]

Hello, formula or macro is okay. i just want to get the task name with the highest count of resource(s). Resource count should be not "blank" or greater than "0" otherwise it is not counted.


You can display the result in Sheet2. Thanks in advance!

[dilipandey]

Okay.. but why not put a column in sheet 1 to calculate the total count per task and basis that you can fetch the associated task name ?


Regards,
DILIPandey
<click on below * if this helps>

[puuts]

Hi DiliPandey, inserting column in Sheet1 is also okay, can you help me with that?

[dilipandey]

Please Login or Register  to view this content.

See the attached file where I included a new column on the right side of your data, then results are extracted on sheet2 :-

resource.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[puuts]

When i tried to change the values of resource in Sheet1, it still displaying task "PS-EXP-ITPCWA".

I've updated the attached file. It should be "PS-BAS-DLM00". Task the highest resource assigned, not count. Sorry.

[dilipandey]

what makes "PS-BAS-DLM00" makes eligible ?


Regards,
DILIPandey
<click on below * if this helps>

[puuts]

It's just an example. I've only updated that task that't why i mention it. nothing special on it .

[dilipandey]

I am still not getting it.. I just need a logic which clarifies what (sum / count) makes any task eligible to be extracted.. can you show an example.. ?



Regards,
DILIPandey
<click on below * if this helps>

[puuts]

Sorry for confusion.

Resources Column = from L3 - AG3

Every Task name has resources assigned. For example Task "PS-BAS-10GIR" has resources of PM=1,SA=0,IS=8.25. For this example, there are only two resources assigned, because SA is "0".

I just want to know what task is with the highest resources assigned ("0" and blanks are not counted).

[dilipandey]

PM=1,SA=0,IS=8.25

so the total count for this row will be 2 after ignoring 0s and blanks.. and basis this we can fetch out the associated task name..correct?

Try using below formula:-

Please Login or Register  to view this content.

Enter with ctrl shift enter key combination.

see attached:- resource.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[puuts]

Perfect! Thanks Dilipandey

[dilipandey]

Cheers

you are welcome



Regards,
DILIPandey
<click on below * if this helps>