Excel Blog
Home
Options
937
Theresa Estrada on 03-27-2019 05:05 PM
18.3K
David Monroy on 03-17-2019 09:01 PM
11.4K
Joe McDaid on 02-19-2019 11:27 PM
1,320
Theresa Estrada on 01-25-2019 02:18 PM
3,169
MS Excel Team on 12-05-2018 12:00 PM
2,054
Michael Molyneaux on 11-06-2018 02:54 PM
6,845
Steve Kraynak on 10-22-2018 11:33 AM
2,716
MS Excel Team on 10-15-2018 01:05 PM
4,044
Maha Alam on 09-27-2018 04:39 PM
29.2K
Prash Shirolkar on 09-25-2018 06:00 AM
56.9K
Joe McDaid on 09-25-2018 06:00 AM
4,058
MS Excel Team on 09-18-2018 10:06 AM
2,504
Blake T Walsh on 09-14-2018 11:54 AM
4,227
Blake T Walsh on 08-23-2018 03:30 PM
11.1K
Blake T Walsh on 08-15-2018 12:11 PM
8,862
Kasper Langmann on 08-07-2018 11:41 AM
3,294
Microsoft Excel on 07-26-2018 10:50 AM
6,614
Blake T Walsh on 07-17-2018 06:15 PM
7,644
Guy Hunkin on 07-16-2018 07:29 AM
1,482
Blake T Walsh on 06-25-2018 01:23 PM
2,619
Blake T Walsh on 06-18-2018 03:43 PM
63.2K
Michael Molyneaux on 06-01-2018 08:30 AM
5,641
Johnnie Thomas on 05-10-2018 05:49 AM
2,165
Blake T Walsh on 05-08-2018 04:12 PM
1,510
Blake T Walsh on 04-23-2018 09:25 AM
4,895
Sangeeta Mudnal on 04-10-2018 11:50 AM
35.7K
John Campbell on 03-29-2018 09:00 AM
3,859
Maha Alam on 03-12-2018 05:57 PM
15.1K
Gregory Appel on 03-04-2018 04:16 AM
4,417
Guy Hunkin on 02-20-2018 08:39 AM
Latest Comments
Thänks - Randarray is exact what I needed
0 Likes
@Henn Sarv DA's calculates in a 1x1 context, they then spill. This means that RAND and RANDBETWEEN will only provide 1 value which is what you are seeing. This is why we released RANDARRAY(). Give it a shot, it's very flexible.
0 Likes
Today I start for intent get dynamically set of random numberssome attempts:=SEQUENCE(10)*0+RANDBETWEEN(10;20) or =SEQUENCE(10)*0+RAND()NO help :(Any idea - how to get set of random numbers dynamicallyOR random subset of actual numbers dynamically
0 Likes
Would love if they allow features like VLOOKUP in the mobile versions.-------------FH
0 Likes
@mdallura , do you see Office Insider if you check File->Account for your Excel?
0 Likes