Excel
Closed
shailu
-
3 Jul 2010 à 00:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jul 2010 à 01:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jul 2010 à 01:14
Related:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Vat calculator excel - Guide
- Transfer data from excel to excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Jul 2010 à 01:14
3 Jul 2010 à 01:14
Put the maximum value where ?
Any how you have to use an array function. To enter array formula, type in the formula and INSTEAD of pressing enter, you NEED TO PRESS, CTRL + SHIFT + ENTER. If you have done it correctly the formula would get enclosed within {}
this is based on assumption that that there would be a maximum of 500 rows
=MAX((A$2:A$500=A2)*(D$2:D$500))
Any how you have to use an array function. To enter array formula, type in the formula and INSTEAD of pressing enter, you NEED TO PRESS, CTRL + SHIFT + ENTER. If you have done it correctly the formula would get enclosed within {}
this is based on assumption that that there would be a maximum of 500 rows
=MAX((A$2:A$500=A2)*(D$2:D$500))
