If I have for example 200 formulas and I need to make them all array formulas ({}), do I have to do this manually or is it a clever way to do this?
For example
200 Countifs formulas, I need to make them all arrays, how?
have a good day,
best reg,
zeha90
Without any sample data (file) and the formula's, it's very hard for us to suggest the simplification method
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Excelforum.xlsx
Im adding one that my friend made for me as a test.
If you see the formulas in the yellow area (the countifs function) there are 6 of them. In my real document I have 500 of them and I dont want to press Ctrl + Shift + Enter on all 500 formulas.
Is there a way to do that fast without VBA?
best regards, Emil
Nvm, It solved itself!
First of all your current formula (stated below) is a normal formula which doesn't require CTRl+SHIFT+ENTER.
=COUNTIFS($C$15:$C$32,$D$7,$D$15:$D$32,$F$7,$E$15:$E$32,$H$7,$F$15:$F$32,$J$7,$G$15:$G$32,$K$7,$H$15:$H$32,$M5)
In I15 Cell
=C15&D15&E15&F15&G15&H15
Drag it down...
In N5 Cell
=COUNTIF($I$15:$I$32,CONCATENATE($D$7,$F$7,$H$7,$J$7,$K$7,$M5))
Drag it down...
Refer the attached file to know how to do it
you dont need array with countifs?
but if you did when you fill down CSE will fill down as well
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks