Formula required for distribution with multiple filters - IF or Vlookup or Index

Hello All,

I have set of data, wherein would I like to distribute to Given names (Column E) equally. However, it has to filter individual item of Value(B column) and item of Source (Column C). Example: I chose 100 K from column B first and then CEM from Column C, there are 62 items and those should be distributed equally to given names in Column E and any blank cell in Column C should be ignored.

Please do the needful.

Regards,
Dinesh

try this:

Formula:

Please Login or Register  to view this content.

Hello,

It is giving result as " 13408544.3". However, I want names to be appeared.

Please do the needful.

Please show the desired result as you are describing in words above. Attach an example that clearly shows how you want the name to appear; and based on what.

Hello,

Thanks all for the help.. But that is not what I want. Please find the attached sheet with result I want column.

Please do the needful.

Thanks in advance.

This works on the sample workbook, but will not work if there are more than four instances of a value and source. Let me know if you need an alternative.

Please Login or Register  to view this content.

Thanks Jacc. This works fine.

However, I would like to increase instances. Let me try.

Thanks so much.

Sagardinesh,

I have the formula for multiple instances, let me know if you want it. It is a simple adjustment.

The mod formula solves it.

Please Login or Register  to view this content.