Formula
How do I return the smallest value from one range based on another condition
from another range eg |
Hi
e.g. the array formula =MIN(IF(A1:A100="value",B1:B100)) -- Regards Frank Kabel Frankfurt, Germany Donkey wrote: How do I return the smallest value from one range based on another condition from another range eg |
All times are GMT +1. The time now is 04:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com