Excel Help
Closed
Jill
-
Feb 23, 2011 at 07:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 25, 2011 at 10:10 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 25, 2011 at 10:10 AM
Related:
- Excel Help
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 25, 2011 at 10:10 AM
Feb 25, 2011 at 10:10 AM
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
