Dear forums members. I need your help in upgrading a formula that I use to calculate 5 most frequent string values. I use this formula on a database that has two groups of participants. Now I need to make the same calculation for group 1 only, which is probably requires adding additional IF into the formula. I couldn't figure out how to make this work. Your help would be very much appreciated.
A demo file is attached. I have to calculate into "asylum seekers only" sheet. The total for all participants is calculated in "calculation" sheet.
Thank you
Marina
Bookmarks