Hi.... all.
How can i Get The Data From Column A
On Daily i reveived a data in Column A .. about 2500 Lines after daily closing.
After Reveive I want to Devided this data in Below Format catagory.
how to possible with formula....
please help me....
pranav
| Sales/Credit Account | Division | Prod2 | Prod1 | CAT |
| SALES (260000) CABLE | Wire | Wire | Wire | WIRE |
| SALES (ACCESSORIES) | W.D. | Penta | Penta | NON MOD |
| SALES (APPLIANCES) | Fan | Fan | Fan | FAN |
| SALES (AVE) | W.D. | Ave | Ave | MOD |
| SALES (AVE) PROJECT | W.D. | Ave | Ave | MOD |
| SALES (CABLE WIRE) | Wire | Wire | Wire | WIRE |
| SALES (CABLE WIRE) PROJECT | Wire | Wire | Wire | WIRE |
| SALES (CFL/PL/PLC) | Lighting | CFL | CFL | LIGHTING |
| SALES (CFL/PL/PLC) INSTITUTION | Lighting | CFL | CFL | LIGHTING |
| SALES (CFL/PL/PLC) PROJECT | Lighting | CFL | CFL | LIGHTING |
| SALES (DYNA) | W.D. | Dyna | Dyna | NON MOD |
| SALES (FAN) INSTITUTION | Fan | Fan | Fan | FAN |
| SALES (FANS & APPL.) | Fan | Fan | Fan | FAN |
| SALES (FANS) | Fan | Fan | Fan | FAN |
| SALES (FANS) PROJECT | Fan | Fan | Fan | FAN |
| SALES (H.I.D. RANGE OF LAMPS) | Lighting | L&T | HID | LIGHTING |
| SALES (KITKAT) | W.D. | Penta | Penta | NON MOD |
| SALES (LAMPS & TUBES) | Lighting | L&T | L&T | LIGHTING |
| SALES (LAMPS & TUBES) INSTITUTION | Lighting | L&T | L&T | LIGHTING |
| SALES (LUMINAIRES) | Lighting | Luminaries | Luminaries | LIGHTING |
| SALES (LUMINARIES) | Lighting | Luminaries | Luminaries | LIGHTING |
| SALES (LUMINARIES) INSTITUTION | Lighting | Luminaries | Luminaries | LIGHTING |
| SALES (LUMINARIES) PROJECT | Lighting | Luminaries | Luminaries | LIGHTING |
| SALES (M.C.B.) | MCB | MCB | MCB | MCB |
| SALES (MCB) | MCB | MCB | MCB | MCB |
| SALES (MCB) PROJECT | MCB | MCB | MCB | MCB |
| SALES (MULTICORE CABLE) INSTITUTION | Wire | MCC | MCC | WIRE |
| SALES (MULTICORE CABLES) | Wire | Wire | Wire | WIRE |
| SALES (NOA) | W.D. | Noa/XL | Noa | NON MOD |
| SALES (NOA) PROJECT | W.D. | Noa/XL | Noa | NON MOD |
| SALES (PEARL) | W.D. | Noa/Pearl | Noa | NON MOD |
| SALES (PENTA) | W.D. | Penta | Penta | NON MOD |
| SALES (PENTA) INSTITUTION | W.D. | Penta | Penta | NON MOD |
| SALES (PVC TAPE) | Wire | Tape | Tape | TAPE |
| SALES (RIDER ACCESSORIES) | W.D. | Rider | Rider G.A. | NON MOD |
| SALES (RIDER ACCESSORIES) PROJECT | W.D. | Rider | Rider G.A. | NON MOD |
| SALES (RIDER MODULAR) | W.D. | Rider | Rider Modu. | MODULAR |
| SALES (RIDER MODULAR) PROJECT | W.D. | Rider | Rider Modu. | MODULAR |
| SALES (RIDER) project | W.D. | Rider | Rider G.A. | NON MOD |
| SALES (ROMA) | W.D. | Roma | Roma | MODULAR |
| SALES (ROMA) INSTITUTION | W.D. | Roma | Roma | MODULAR |
| SALES (ROMA) PROJECT | W.D. | Roma | Roma | MODULAR |
| SALES (T-4 RANGE) | Lighting | CFL | T - 4 | LIGHTING |
| SALES (T-5 RANGE) | Lighting | CFL | T - 5 | LIGHTING |
| SALES (TELEPHONE CABLE) | Wire | Wire | Tel. Cable | WIRE |
| SALES (TELEPHONE CABLE) INSTITUTION | Wire | Wire | Tel. Cable | WIRE |
| SALES (TELEPHONE CABLE) PROJECT | Wire | Wire | Tel. Cable | WIRE |
| SALES (WIRE) | Wire | Wire | Wire | WIRE |
| SALES (WIRE) INSTITUTION | Wire | Wire | Wire | WIRE |
| SALES (WOODS) | W.D. | Woods | Woods | MODULAR |
| SALES (WOODS) INSTITUTION | W.D. | Woods | Woods | MODULAR |
| SALES (WOODS) PROJECT | W.D. | Woods | Woods | MODULAR |
| SALES (XL) | W.D. | Noa/XL | XL | NON MOD |
| SALES [CABLE WIRE] PROJECT | Wire | Wire | Wire | WIRE |
| SALES RIDER MODULER (PROJECT) | W.D. | Rider | Rider Modu. | MODULAR |
| SALES WIRE [INSTITUTION] | Wire | Wire | Wire | WIRE |
| SALES(H.I.D. RANGE OF LAMPS) | Lighting | L&T | HID | LIGHTING |
| SALES(LIGHTING CONTROL SYSTEM) | H.A. | H.A. | LCS | HOME AUTO |
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat Idul Fitri... Mohon maap dari momods... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| Selamat Idul Fitri... Mohon maap dari momods... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
.
__,_._,___
Nenhum comentário:
Postar um comentário