Hi,
To find the number of times that a certain text appears within a specified range use the following formula:
=SUMPRODUCT(--EXACT($B$2:$B$11;D2))
Hi,
To find the number of times that a certain text appears within a specified range use the following formula:
=SUMPRODUCT(--EXACT($B$2:$B$11;D2))
Hi,
=SUMPRODUCT(--EXACT($B$2:$B$11;D2))
the (--) in the above formula to make the result as value (number), the following formula may be used instead:
=SUMPRODUCT(EXACT($B$2:$B$11;D2)*1)
This is better served by utilizing VBA. In any case, you don't state how you wish to "recognize" your entrances. Refer more from write my paper for cheap to get better result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks