s

Nouveau venu

Inscrit le :16/04/2015
Dernière activité :13/09/2020 à 08:47
Version d'Excel :2007 FR
Messages
7
Votes
0
Fichiers
0
Téléchargements
0
SujetsMessagesStatistiquesVotes reçus

Sujets créés par stchln

DateForumSujetExtrait du message
12/09/2020 à 16:06Excel - VBA COUNTIF number of occurrences of numerical value < thresholdI am trying to count number of times a number - in a text format - is below a given threshold. It happens that is the range, there are non-numerical values as in below example - In B1, the formula "=--(VALUE(A1:A4))" is to convert A1:A4 into numerical value, shown in Excel as { 10, 20, #VALUE!, 30 }...