Mode

[kathrinewhite]

I have made a database of information in a worksheet. I need to pull the mode from the same cells across multiple worksheets. Also, would like to full the frequency. How would I do this?

Thanks in advance

Kathrine

 

[kathrinewhite]

is this not understandable or is it too simplistic not doable. Thanks

 

[shg]

Neither MODE nor FREQUENCY accept 3D references, and you can't pass a 3D reference to a user-defined function other than as a string.

You might consolidate all of your data on a single sheet, and then apply the functions.

 

[shg]

Kathrine,

Aladin Akyurek ("Alan Accurate") pointed out via PM that FREQUENCY does accept 3D references -- my bad.

 

[kathrinewhite]

so frequency is possible but not mode?

 

[shg]

They are both possible, but MODE requires that you aggregate the data on a single sheet.

 

[kathrinewhite]

so to make this possible I could build a formula to pull all the data to one and then pull the mode. OK, Thank you that I can do. Appreciate the help with the hang up.

 

[shg]

You're welcome, Kathrine.