• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Want to separate school,colleges university data in different sheets.

Status
Not open for further replies.

rahulsharma012

New Member
I have data in sheet1. i want that based on name of company column all the corresponding details of that column should be placed in sheet2.


Like if a2 is the name of college whole of the information of the corresponding row should be placed in sheet2,likewise i need to segregate all colleges information in sheet2 schools information sheet3 and university information in sheet4 respectively.


Deleted due to Secured Information


Regards,

Rahul
 
Hi Rahul,


Just checked your file, you have not shown how to identify the School, Institute & University for data in Column A.


I suggest you using the column "Name of the Company" and filter it with:


Code:
Advance Filter > Text Filter > Contains >


...and set criteria to [code]university, school or institute
and copy>paste[/code] the data on the required sheet.


Regards,
 
Hi Rahul,


I support faseeh's suggestion.. :)


I have deleted the URL, as they are actual & secured.. infact one of the chairman is my relative..


Please don't share any secured information with all contact & mail details.. Please upload with a sample for the same..


Regards,

Deb
 
Check this one..


Code:
=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH(TypeList,$A2)),TypeList),"")


https://dl.dropboxusercontent.com/u/78831150/Excel/Delhi-school-email%20data.xlsx


Regards,

Deb
 
as requested..


http://www.fileconvoy.com/dfl.php?id=gad767a7a032e6d9b9993108410ca183f18932f008


Regards,

Deb
 
Status
Not open for further replies.
Back
Top