Thread: [Solved] =if(series
View Single Post
 
Old 09-24-2020, 07:20 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
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
Reply With Quote