Excel Blog
Copied!
Home
Options
3,755
Shashank Gandhi on 11-04-2019 07:46 AM
12.4K
Jee Soo Han on 11-04-2019 06:00 AM
1,222
cuong on 10-31-2019 08:54 PM
6,002
JohnMacDougall on 10-08-2019 01:07 PM
6,393
Guy Hunkin on 10-02-2019 02:13 PM
3,850
Liam Bastick on 09-17-2019 08:56 AM
584K
Joe McDaid on 08-28-2019 09:00 AM
40.4K
Sam Radakovitz on 08-22-2019 09:00 AM
2,221
Ingeborg Hawighorst on 08-19-2019 01:31 PM
1,935
cuong on 07-30-2019 06:51 PM
11.3K
David Monroy on 06-03-2019 08:11 AM
12.7K
MS Excel Team on 05-29-2019 09:00 AM
8,013
Itai Goldstein on 05-19-2019 03:52 AM
1,914
cuong on 04-24-2019 01:17 PM
2,083
Theresa Estrada on 03-27-2019 05:05 PM
21.8K
David Monroy on 03-17-2019 09:01 PM
22.7K
Joe McDaid on 02-19-2019 11:27 PM
1,833
Theresa Estrada on 01-25-2019 02:18 PM
4,068
MS Excel Team on 12-05-2018 12:00 PM
2,669
Michael Molyneaux on 11-06-2018 02:54 PM
12.9K
Steve Kraynak on 10-22-2018 11:33 AM
3,634
MS Excel Team on 10-15-2018 01:05 PM
5,982
Maha Alam on 09-27-2018 04:39 PM
45.1K
Prash Shirolkar on 09-25-2018 06:00 AM
85.2K
Joe McDaid on 09-25-2018 06:00 AM
4,850
MS Excel Team on 09-18-2018 10:06 AM
3,324
Blake T Walsh on 09-14-2018 11:54 AM
8,039
Blake T Walsh on 08-23-2018 03:30 PM
27.1K
Blake T Walsh on 08-15-2018 12:11 PM
11.7K
Kasper Langmann on 08-07-2018 11:41 AM
Latest Comments
Where I can sign up for the annoucement that the script is avaiable? Is there a preview I can get to test it? @Marcin Rachwalski
0 Likes
@Ed Hansberry You may feel vindicated to know that I managed to fall into the 'parameter 4' trap. I was performing a 2D interpolation of gas density versus temperature (horizontal axis) and gauge pressure (vertical axis). Given a pressure, I need to return the next higher and lower values from the t...
1 Likes
@Patrick2788 Logically FILTER could replace any lookup function or xIFS (SUMIFS etc.) function. That is not to say it should, that is a case by case decision in which both performance and flexibility (e.g. speed versus multiple return values) are important considerations.@Ed Hansberry FILTER works w...
0 Likes
XLOOKUP is smoking fast.
0 Likes
Hey @Ed Hansberry I did a quick test a month or so back Data Set 20,000 rows 20,000 FILTER() v 20,000 XLOOKUP() XLOOKUP = INSTANT FILTER = 60 Seconds +
1 Likes