Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anybody help me out here ?=20
Maybe a little example to explain a bit ... Let's say I have the following data : =B0=B0=B0=B0=B0A=B0=B0=B0=B0=B0=B0=B0=B0=B0=B0B=B0 =B0=B0=B0=B0=B0=B0=B0=B0= =B0C=B0=B0=B0=B0=B0=B0=B0=B0=B0=B0D 1 =B0=B0Bruno______V________PMV=20 2 =B0=B0Jane______AMV________V_______ PMV 3 =B0=B0Bruno_______________AMV 4 =B0=B0Jane____AMV+PMEx_____V________V 5 =B0=B0Jane_____V I now want to count the times that, with Jane in the A=20 column,=20 I have V or AMV or PMV in the whole cell or part of the=20 cell. So for Jane, it would be=20 4 times V =3D 4 times 1 =3D 4 3 times (AMV or PMV) =3D 3 times 0.5 =3D 1.5 Thanks for your assistance !! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |