So I need a formula to evaluate how many numbers are present in two ranges.
Please see attached file.
So I need a formula to evaluate how many numbers are present in two ranges.
Please see attached file.
Edit Forgot to refresh before editing mistake in formula.
Try in F5 and fill down.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 07-01-2019 at 06:04 PM.
Dave
Try this array formula:Formula:Please Login or Register to view this content.
It must be entered with Ctrl + Shift + Enter.
My formula goes in G5
Last edited by Jacc; 07-02-2019 at 04:21 AM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Thank you for your answer I need to drag the formula to the right so I use flameRetired formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks