Forum

Notifications
Clear all

[Solved] SERIAL NO

3 Posts
2 Users
0 Reactions
282 Views
Md Saliha
(@navsal66)
Posts: 108
Estimable Member
Topic starter
 

Hi every one,

          i have a little query in my working list, i need serial no based on category (C column) in Status.

if i changed "Closed or Pending" its should be change automatially.

image
 
Posted : 26/02/2025 2:35 pm
Topic Tags
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

In D1 you can enter:

=COUNTIF($C$3:C4,C4)

and copy it down. That will do exactly what you need. 

 
Posted : 26/02/2025 4:22 pm
Md Saliha
(@navsal66)
Posts: 108
Estimable Member
Topic starter
 

Hi Riny,

Thanks for your support and its working fine.

 

 
Posted : 27/02/2025 1:38 pm
Share: