Extracting desired data

[Raja Kamarthi]

Hello Friends,


I have a data dump which is enormous.here there is column which has multiple queue details as :

DEV-.NET-L1

EIM-DSER-L3

BIP-PUBLISHING-L1

EIM-DQCORE-L1

BIP-ADMIN-L1

RA-CR-L1

BIP-DEPLOYMENT-L1

EPM-BPC-MS-L1....like wise there are more than 500 + unique queues


Now I want to pick only the data of the queues which has "BPC" as a component for eg EPM-BPC-MS-L1


Is there a simple and quick method of getting this desired data?


Please share your inputs.


Thanks,

Raja

 

[Debraj]

Hi Raja,


* Is there any problem in

Filter > Text Filter > Contain > BPC


If yes.. then why not Formula..

=ISNUMBER(SEARCH("BPC",A1))

in separate cell and filter TRUE..


or Advance Filter


List Range : $A$1:$A$9

Criteria Range : $C$1:$C$2

where C1 is heading in A1 and C2 = "*BPC*"


Please reply if any of the above is not working..


Regards,

Deb

 

[Raja Kamarthi]

Hello Debraj,


Your first remedy [=ISNUMBER(SEARCH(BPC,A1))] has the done the job effortlessly for me


And in regards to the usage of filter option, I seldom use it because when I apply filter to a data and copy the filtered data and paste it in a different sheet, I always get the complete data (as if there was no filter applied) so I keep away from this filter thing as much as I can


Anyways, Thank you for this piece


Regards,

Raja

 

[Debraj]

Hi Raja..


Then one more vital capsule to remedy..


after selecting and Before copy the filtered data press..

[Alt + E + G + S + Y].. (GoTo > Special > Visible Cells Only)

Then paste..


I am sure, it will never copy other than filtered data..


Regards,

Deb

 

[Raja Kamarthi]

Hi Deb,


Now this is what I say complete "fool proof" stuff. Today I learnt a lot from you.


Many Thanks for sharing this valuable inputs.


Regards,

Raja

 

[prashanthahu]

Dear Friends,


I have few columns in which col A and B are from genuine source and columns from c to J are edited with some additional data. Col C represents the same as col A but is not in order.

The data in column c to H should be aligned in the same order as col A, can anyone suggest the best way to do this ?

[pre]

A	B	C	D	         E	F	G	H
1	FPD	1	KARAMANGALA	102	29	52	77
10	FPD	2	CHIKKA 	         53	16	13	42
14	FPD	3	JAYARAMAIAH 	113	21	55	88
11	FPD	4	ANSAR 	        140	25	43	72
8	FPD	5	AMANULLA         83	21	27	53
9	FPD	6	SOREGOWDAN	 60	11	26	40
4	FPD	7	HULIBELE	 69	10	20	40
3	FPD	8	ABBIGIRIHOSA	 47	13	21	29
2	FPD	9	SIDDANAHALLI     72	27	39	51
7	FPD	10	MADIGARA         39	13	27	47
6	FPD	11	SOOLIKUNTE       82	42	45	116
13	FPD	12	MAAGONDI         73	9	54	84
12	FPD	13	ANSAR	         47	4	28	40
5	FPD	14	KHAN	        119	18	54	109[/pre]
The answer for the second row in Col A has 10 and the result should be

10	MADIGARA         39	13	27	47

which should be drawn from the corresponding 10th row from column C to H


Am looking forward for your help.


Thanks and regards,

H.Prashanth

 

[Faseeh]

@prashanthahu


Welcome to the Forums!! Posting a your Questions in some one Else's thread is not allowed at this forum. Please start a separate thread for your query. Your query will be replied promptly.


Regards,