ExcelBanter - find the number for visible row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find the number for visible row (https://www.excelbanter.com/excel-discussion-misc-queries/263839-find-number-visible-row.html)

Nahc

find the number for visible row

I hope some expert can help me with my problem.

I wish to perform serial number visible row only.

Regards / Chan

T. Valko

find the number for visible row

=SUBTOTAL(3,B$2:B2)

Copy down as needed.

--
Biff
Microsoft Excel MVP

"Nahc" wrote in message
...
I hope some expert can help me with my problem.

I wish to perform serial number visible row only.

Regards / Chan

All times are GMT +1. The time now is 02:09 AM.