Formula help

[ashani]

hi experts,

please can someone guide me with a formula to extract only percentage from the database and put it in the relevant field. I have attached the screenshot, so all I want is percentage from 39, 40 & 41 (highlighted blue) into the columns below.

thank you

 

[awoohaw]

I'm unsure of what you want in the numerator and denominators for the percentage calculation.
But, here it is based on my assumption:

(and please use the xl2bb add in to post your data if you want forum to look at it all. Or use the table posting feature).

Mr excel questions 66.xlsm
	A	B	C	D	E	F
1
2		39
3		39	39	39	39	39
4		Fruit	Veg	Drink	To	Pct
5	Seller 1	26	2	6	34	76.47%
6	Seller 2	22	2	11	35	62.86%
7	Seller 3	20	2	2	24	83.33%
8	Seller 4	38	3	6	47	80.85%
9	Seller 5	30	4	5	39	76.92%
10	Seller 6	30	2	9	41	73.17%
ashani

Cell Formulas
Range	Formula
F5:F10	F5	=B5/SUM(B5:D5)

 

[ashani]

I'm looking to copy the percentage in blue to the below under week numbers for example 39 should go below under 39 section and so on.

thank you

 

[awoohaw]

you just want 39% in cells F5:F10? You don't want it multiplied by anything? Are the values in blue in your image your expected results? What is the formula you have there now?

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3
4						%						%						%
5	Seller 1					59%						43%						N/A
6	Seller 2					31%						68%						N/A
7	Seller 3					75%						63%						N/A
8	Seller 4					68%						92%						N/A
9	Seller 5					64%						100%						N/A
10	Seller 6					51%						60%						N/A
11
12
13		39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55
14	Seller 1	0.59	0.43	N/A
15	Seller 2	0.31	0.68	N/A
16	Seller 3	0.75	0.63	N/A
17	Seller 4	0.68	0.92	N/A
18	Seller 5	0.64	1	N/A
19	Seller 6	0.51	0.6	N/A
Sheet5

Cell Formulas
Range	Formula
B14:D19	B14	=FILTER(B5:R10,B4:R4="%")
Dynamic array formulas.

 

[ashani]

Perfect - Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.