Hi Guys,
Is there any formula to count the text entries in pivot table in excel 2007 apart from highlighting the cell?
Hi Guys,
Is there any formula to count the text entries in pivot table in excel 2007 apart from highlighting the cell?
Hi Kashaikh78,
You can use below function which is counting the text entries in range d1:d7 :-
Formula:Please Login or Register to view this content.
enter formula using ctrl shift enter key combination. thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi Dilipandey,
Thanks buddy...it worked
You are welcome Kashaikh78...
Please mark this thread as [SOLVED].. thanks.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks