ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Thank you for sharing
My pleasure
that was a cool function
Great to hear you liked it.
Hi.. Can you show the function to serialize the number excluding the hidden rows in google sheets?
As I've already mentioned in the video, if you want to exclude hidden cells, just write the function code then prepend it with 10. In the example, that would be 10 then 9, so your formula would be SUBTOTAL(109,[range]). Hope this explains it.
@@WorkflowWisdom thank you so much.. it helped. Your expectations are much easier.
Glad it helped.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Thank you for sharing
My pleasure
that was a cool function
Great to hear you liked it.
Hi.. Can you show the function to serialize the number excluding the hidden rows in google sheets?
As I've already mentioned in the video, if you want to exclude hidden cells, just write the function code then prepend it with 10. In the example, that would be 10 then 9, so your formula would be SUBTOTAL(109,[range]). Hope this explains it.
@@WorkflowWisdom thank you so much.. it helped. Your expectations are much easier.
Glad it helped.