Forum

Notifications
Clear all

Numbering columns

3 Posts
2 Users
0 Reactions
174 Views
(@leif-norindergmail-com)
Posts: 13
Active Member
Topic starter
 

How do I write a formula to number items column A1 - column J1 on the top row (A1 - J1) from 1 - 10. And if any column in the range A2:J10 is missing values, that column should not be numbered, but left blank. For example, column C has no values, in which case the numbering should end in 9 on row J1 instead of 10 (if all columns had values). I have Excel 2021 Home Office.

Very grateful for the reply as I can't solve this problem. 

Leif

 
Posted : 21/03/2024 1:00 pm
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

The attached file contains a pretty straight forward solution. It makes no used of more advanced techniques but I believe it will work just fine in the situation you described.

 
Posted : 22/03/2024 1:53 am
(@leif-norindergmail-com)
Posts: 13
Active Member
Topic starter
 

Thank you Riny!

If column A also is blank i can put a variant to your formula there, which i put in B1, to complete your formula: IF(COUNTA(A2:A10)>0;1;"")

And it all works fine!

 
Posted : 22/03/2024 7:44 am
Share: