Dear forum readers,
I am looking for a formula or vba code that counts the number of lines from which the cells are selected in those two columns.
The first must be 0, the second is 15 and the third should be 23.
Who can help me with this?
With Regards,
FvdF
YOu have been told before I think to provide workbooks, not pictures of them.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
With this I only tried to make it clear. Is this a problem then?
FvdF
If you look to the bottom of your Excel-sheet, you can see the number of selected cells. Its the count. In this example: 5.
Last edited by HansDouwe; 10-03-2023 at 11:30 AM.
I do not want the cells to be counted but the number of lines a selected cell contains. See the examples.
Oh, the number of selected lines. No that is not shown by Excel and it is not possible with a formula. May be with VBA?
vba
Please Login or Register to view this content.
How about:
Please Login or Register to view this content.
Last edited by johnnyL; 10-03-2023 at 06:01 PM.
Hello jindon & johnnyL
Both options works great!
Thanks for your help.
Muchas Gracias
Glad we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks