Data Migration from One Sheet to Multiple Sheets

fairchance

fairchance

New member
Joined
Jan 4, 2015
Messages
48
Reaction score
0
Points
0
Dear Sir,

I have spreadsheet with column Referred By (K). I want to copy data from Raw data sheet to other six sheet on the following criteria:

1.If Name is single then these records may copied to 1_Referral
2.If Name column contains double Names then these rows may be copied to 2_Referral sheet
3.IF Name.....................3 same values ............................................3_Referral sheet
4.............................................................................................4_Referral Sheet
5.............................................................................................5_Referral Sheet
6. If Name column contains 6 or more than six same values then............6_Referral Sheet
7. If No name exist or blank cell in Column K (Referred By) then Record may be excluded from count.

My worksheet is attached:

https://www.dropbox.com/s/qfh1v4sialdl69i/Referral Program Tracking.xlsx?dl=0

Kindly solve my problem and return the same after solution.

Regards

Shehbaz H.
 
I answer to you here. I solved problem with formulas, if you need idea
 
The answer was not upto the mark. Is there anyone to solve my problem please.

Regards

Shehbaz H.
 
You must log in or register to reply here.
Back
Top