How to obtain the relevant percentage data and number problem ?

[rayhen]

The sample has been stored in the file

F3:F7 Use formula to obtain relevant percentage data

G3:G7 Calculate the number of percentages

Thanks for any help!

[Shareez Saleem]

Please Login or Register  to view this content.

[wk9128]

More troublesome, currently use Glenn Kennedy moderator custom formula for F3:F7

OR

F3 cell array formular , drag down

G3:G7 Array formula

It's hard to explain, just look at the attachment file

Hope this can help you, if you have any questions pls ask

[rayhen]

Amazing , that does the trick! Much appreciated! @wk9128 tqvm