Excel Help
Closed
Jill
-
23 Feb 2011 à 19:08
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Feb 2011 à 10:10
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Feb 2011 à 10:10
Related:
- Excel Help
- Excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Menu déroulant excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
25 Feb 2011 à 10:10
25 Feb 2011 à 10:10
Hi Jill,
Try this:
=SUM(IF($B$1:$B$6<>A1,1,0))-5
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
I used 6 rows of data resulting in $B$1:$B$6, adjust this to suit your range.
You also need to adjust the final number at the end. This number should be 1 less of the total number of rows used. In my case 6-1=5.
Best regards,
Trowa
Try this:
=SUM(IF($B$1:$B$6<>A1,1,0))-5
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
I used 6 rows of data resulting in $B$1:$B$6, adjust this to suit your range.
You also need to adjust the final number at the end. This number should be 1 less of the total number of rows used. In my case 6-1=5.
Best regards,
Trowa
