Thread
: [Solved]
=if(series
View Single Post
09-24-2020, 07:20 AM
Purfleet
Windows 10
Office 2019
Expert
Join Date: Jun 2020
Location: Essex
Posts: 345
Its much easier if you add a workbook rather than a screen dump.
Try
=COUNTIFS($A$1:A1,A1)
Note the locked first A1 then the unlocked second A1. That gives you an expanding range
Last edited by Purfleet; 09-24-2020 at
07:21 AM
. Reason: typo
Purfleet
View Public Profile
Find all posts by Purfleet