Arif_Tamboli
New Member
- Joined
- Mar 1, 2018
- Messages
- 34
- Office Version
- 2016
I have data in Sheet2 from range ("b2: data wil get added in column")
(From b2 to b300") and column data will get added in column on daily basis
Result would be in sheet 1 range (B2 and c2)
Formula Percentile B2 0.5 & C2 0.95
Data
Sheet2
Result Should be
Sheet1
(From b2 to b300") and column data will get added in column on daily basis
Result would be in sheet 1 range (B2 and c2)
Formula Percentile B2 0.5 & C2 0.95
Data
Sheet2
Row Labels | 1-May | 2-May | 3-May | 4-May |
A | 45 | 45 | 59 | 24 |
B | 10 | |||
C | 15 | 12 | 5 | 8 |
D | 58 | 58 | 47 | 53 |
E | 98 | 13 | 19 | 105 |
F | ||||
G | 7 | 7 | 5 | 2 |
H | 92 | 41 | 44 | 118 |
Result Should be
Sheet1
Row Labels | Percentile |
Row Labels | |
A | |
B | |
C | |
D | |
E | |
F | |
G | |
H |