Median function
 

hi all,
i wanted to find it out median from a huge data ..designation wise..
eg: in an office there are so many dept and their basic pay and in a
dept so many designations and i wanted to know the divisions median
...
but remember it's a huge file,.....can i do this with pivot tabel..


--
pamanaf
------------------------------------------------------------------------
pamanaf's Profile: http://www.excelforum.com/member.php...o&userid=19184
View this thread: http://www.excelforum.com/showthread...hreadid=394563

Have you tried?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pamanaf" wrote in
message ...

hi all,
i wanted to find it out median from a huge data ..designation wise..
eg: in an office there are so many dept and their basic pay and in a
dept so many designations and i wanted to know the divisions median
..
but remember it's a huge file,.....can i do this with pivot tabel..


--
pamanaf
------------------------------------------------------------------------
pamanaf's Profile:
http://www.excelforum.com/member.php...o&userid=19184
View this thread: http://www.excelforum.com/showthread...hreadid=394563