Hi,
Is there any way to have the following array ignore blank cells in the range?
=SUM(IF(FREQUENCY(IF(AN2:AN1021<=100,ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))
Thanks in advance!
Hi,
Is there any way to have the following array ignore blank cells in the range?
=SUM(IF(FREQUENCY(IF(AN2:AN1021<=100,ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))
Thanks in advance!
Perhaps?
=SUM(IF(FREQUENCY(IF((AN2:AN1021<=100)*(AN2:AN1021>0),ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks that didn't work but adjusting it to:
=SUM(IF(FREQUENCY(IF((AN2:AN1021<=100)*(AN2:AN1021<>""),ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))
seems to work!
However, when i try to add this in vba code I get a runtime error because the array is longer than 255 characters. Is there any way around this?
Thanks
we'll need to wait for a VBA expert to come by....
This should work...
Please Login or Register to view this content.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks