Execel formula required

[Manoj K]

I have an excel file. I would like to count the number of words of column “B” and answer need in column F, G, H, I, J, K or L based on value in column “D”. Can anybody help for the same.

 

[SanjayGMusafir]

Assuming you data (table) starts from Row 1 itself

Use this formula in F2 and onwards

=IF(F$1=$D2,Len($B2),"")

 

[Manoj K]

First of all I am sorry, there were some mistake in my question submitted earlier.



I have a file containing 14 columns. I would like to get answers i.e. number of characters without space from column 2 (description) multiplied with quantity in column 6 either in column 7, or 8, or 9 or ….. 13 based on value in column 5. Example “if value in column 5 is 3, then the character count with quantity multiplied from column 6 should come in column 9” like if value in column 5 is 8, then the character count with quantity multiplied from column 6 should come in column 13”, etc, etc.. Please help.

 

[RoryA]

Reposted here (please don't do that in future - stick to one thread), so this is closed.