New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

EXCEL FILTER ISSUE

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

EXCEL FILTER ISSUE

Postby chaithral » Sat Mar 12, 2016 5:58 am

hi ... everyone...

i have attached a excel sheet where in i have different departments for example B2 shows department cardio

my problem is whenever i filter cardio the display shows empty. i want it to display all the contents under cardio department.i,e S L. NO. 1 TO 77. (A 79 TO E 79)


Pls help... WAITING FOR U REPLY
  • 0

chaithral
Rookie
 
Posts: 25
Joined: May 4, 2012
Reputation: 0
Excel Version: 2007

Re: EXCEL FILTER ISSUE

Postby pecoflyer » Sat Mar 12, 2016 12:05 pm

No file attached...
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: EXCEL FILTER ISSUE

Postby chaithral » Sun Mar 13, 2016 11:07 pm

sorry...

pls find the attachment...
  • 0

You do not have the required permissions to view the files attached to this post.
chaithral
Rookie
 
Posts: 25
Joined: May 4, 2012
Reputation: 0
Excel Version: 2007

Re: EXCEL FILTER ISSUE

Postby pecoflyer » Mon Mar 14, 2016 6:37 am

I can't seem to open the attachment.

Might be me though, I use XL from Ubuntu
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: EXCEL FILTER ISSUE

Postby chaithral » Thu Mar 24, 2016 3:39 am

SL NO Register No. Patient Name Surgeon Name

0 CARDIO
1 15109667 JARAPPA GOWDA DR.SUBRAHMANYAM K
2 15107387 NARAYANA POOJARY DR.SUBRAHMANYAM K
3 15018618 GANESH (616826) DR.SUBRAHMANYAM K
4 15111510 VASU MOOLYA DR.SUBRAHMANYAM K
5 15109896 ISAMMA DR.SUBRAHMANYAM K
6 15110035 HERALD PERARA DR.SUBRAHMANYAM K
7 ENT
8 15023876 VASUDEV Dr. Nikhil Shetty, Dr. Karthik Vishwanath
9 15105189 SREERAG DR SUHAS
10 15111818 HAROON K.A DR.BINNIYAM
11 15110056 MARIYAM C DR.BINNIYAM
12 15109588 SREENIVEDH Dr. Rajeshwary
13 15095918 RAVEENDRAN C Dr. Rajeshwary



MY CONCERN IS I WANT TO FILTER DEPARTMENT WISE SURGERY LIST BUT HERE THE DEPARTMENT ARE UNDER REGISTER NO I;E (SL NO :O -CARDIO & SL NO :7 ENT.). WHEN I ADD AUTOFILTER AND SELECT CARDIO THE ITEMS (SL NO , REGISTER NO PATIENT NAME ,SURGEONS NAME )DOES NOT APPEAR ITS SHOWS BLANK . IS THERE ANY SOLUTION FOR THE ABOVE DATA



PLS REPLY ASAP.



THANK U
  • 0

chaithral
Rookie
 
Posts: 25
Joined: May 4, 2012
Reputation: 0
Excel Version: 2007

Re: EXCEL FILTER ISSUE

Postby pecoflyer » Thu Mar 24, 2016 10:17 am

Writing in upper case is considered shouting.

There is no need for this, we are all friends here - Thx
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: EXCEL FILTER ISSUE

Postby chaithral » Sat Mar 26, 2016 4:45 am

sorry i did not knw this.....

waiting for ur reply ...
  • 0

chaithral
Rookie
 
Posts: 25
Joined: May 4, 2012
Reputation: 0
Excel Version: 2007

Re: EXCEL FILTER ISSUE

Postby Kevin UK » Sat Mar 26, 2016 7:03 am

Try posting a file that one can open?
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016

Re: EXCEL FILTER ISSUE

Postby NoSparks » Sat Mar 26, 2016 8:56 am

I had no problem openning the file with Excel 2010 64bit.
It's a .xls file, have saved as .xlsx so maybe others can open it.

my project.xlsx

The 'filter' issue is not with the file but rather the OP's understanding of how 'filter' works.
  • 0

You do not have the required permissions to view the files attached to this post.
NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: EXCEL FILTER ISSUE

Postby pecoflyer » Sat Mar 26, 2016 12:43 pm

chaithral wrote:sorry i did not knw this.....

waiting for ur reply ...


And I am waiting for you to correct this


To all members : Please wait till the OP has corrected as requested. Thank you
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 45 guests

cron