Data Extraction?

[Chintan Trivedi]

Please let me know I can extract the data from column "Rating assigned" without filtering the data. (Suggest the formulas)

as I have almost more than 6890 raw lines.


Sr No Name of Entity Rating Assigned Required Result

1 ABC CAREBBB BBB

2 BCD CAREBB BB

3 CDE CAREBB+ BB+

4 DEF BBB BBB

5 EFG CAREBB+(SO) BB+

6 FGH CAREBB+(SO) Inprinciple BB+

7 GHI BBB(SO)Inprinciple BBB

8 Hij BBB+(SO) BBB+

9 IJK CARED D

 

[kaushik03]

Hi Chintan,


Welcome to this forum and we glad to have you here.


Regarding your question, can you plz clarify the following?


1) The values of "rating assigned" column are the following(for e.g):


CAREBBB

CAREBB+

BBB

CAREBB+(SO)

CAREBB+(SO) Inprinciple

BBB(SO)Inprinciple


OR,

BB+, BB etc.


2)If later is true, then would you like to extract the unique values from these column?


But if earlier ones (e.g., CAREBB+(SO)) are the values of "rating assign" column, then I do not see any duplicate occurrence of these values. If this is so, then on what basis you want to extract the values?


Plz clarify...


You can consider uploading a sample file here:

http://chandoo.org/forums/topic/posting-a-sample-workbook


Kaushik

 

[sdsurzh]

Hi,


Can you please updload the file.


Thanks,

Suresh Kumar S

 

[Chintan Trivedi]

How can I upload the file? I don't Know Sirji.

We have rating scale like that..

AAA

AA+

AA

AA-

A+

A

A-

BBB+

BBB

BBB-

BB+

BB

BB-

B+

B

B-

C

D


I want that only in required data column

 

[sdsurzh]

Hi,


Try the below link:


http://www.2shared.com/


Thanks,

Suresh Kumar S

 

[kaushik03]

Hi Chintan,


Upload it here: http://www.speedyshare.com/


It does not require any registration to upload files.


Now, let me explain my understanding of your requirement in my own words.


The part of the string in "rating assign" column contains the ratings as well, like AA+, AA,BB+, BB etc as you have specified above. Now you want to extract that rating part from the string and place it in the "required result" column.


Is my understanding correct?


If so, the list of rating scale that you have specified above is the entire list of ratings or you may have some other ratings as well?


Kaushik