| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
One thought, one Comment/Question:
Thought: I think you could simplify the formula a bit by using an array formula: =AVERAGE(IF('Entire Org'!$C$4:$C$4505&'EntireOrg'!$D$4:$D$4505&'Entire Org'!$E$4:$E$4505='Employee Database'!$F1&'Employee Database'!$G1&'Employee Database'!$H1,'Entire Org'!$I$4:$I$4505)). Comment/Question: The formula that you are asking to build will actually return a 4,401 item array. The best you could hope to see would be one item in that array. So...What is it that you are really looking to see from the formula? Regards, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Hybrid Mode
