Forum Discussion

jeheisler's avatar
jeheisler
Copper Contributor
Dec 03, 2019

Issues with finding MODE when using IFS

Hello,   I work for a nonprofit and we are trying to find what month is most common for specific individuals to give during. I have attached a list with important personal information removed.   ...
Formulas and Functions
CA_PUNIT_AGARWAL's avatar
CA_PUNIT_AGARWAL
Copper Contributor
Dec 03, 2019

Hii,

 

I have tried solve the problem through 2 steps:

 

1. I have created a pivot of your sheet

2. I have used match function to find out the month.

see Sheet 2 of the attachment

 

Thanks

Resources