Hi, Write the correct problem in subject section, like "pivot, conditional formatting, lookup function,". and then elaborate the problem as clearly as u can, and also if possible attach the sample sheet.
Regards, Waheed. On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema <shankar.n...@gmail.com> wrote: > Sir, > I totally confused to put my query in group ID. pls tell me the procedure > > On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed <waheedb...@gmail.com> wrote: >> >> Plz put all ur queries n replies to the group id. So that everyone >> will try n learn, that is wht our objective. >> >> Thnx >> Waheed. >> >> On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales >> <alliage.mora...@gmail.com> wrote: >> > Thank you very much! >> > >> > Hope we could get in touch soon for future problems on Excel. Thank you! >> > >> > On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed <waheedb...@gmail.com> >> > wrote: >> >> >> >> Hi John, >> >> >> >> PFA, i have deleted some rows bcoz the file size was getting huge. >> >> >> >> What u need to do is take this as example and do it in ur original >> >> file, in sheet 2 u need to drag down the formulas till the end. >> >> >> >> Hope it hels u >> >> >> >> Regards, >> >> Waheed >> >> >> >> On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales >> >> <alliage.mora...@gmail.com> wrote: >> >> > I attach my raw file. >> >> > >> >> > GEOCODE contains the geographic code >> >> > Other sheets contain the geographical areas without the codes >> >> > >> >> > On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed <waheedb...@gmail.com> >> >> > wrote: >> >> >> >> >> >> Can u plz mail a sample file. >> >> >> >> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales >> >> >> <alliage.mora...@gmail.com> wrote: >> >> >> > If two geographical data match in two sheets, then >> >> >> > add/copy/replicate >> >> >> > unique >> >> >> > id/code >> >> >> > >> >> >> > Hi guys, this is my problem. >> >> >> > >> >> >> > I have a geographical data (divided into four colums per REGION, >> >> >> > PROVINCE, >> >> >> > MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet >> >> >> > contains a >> >> >> > UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. >> >> >> > >> >> >> > Now, I have also another sheet which lists the same geographical >> >> >> > data >> >> >> > (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, >> >> >> > and >> >> >> > BARANGAY/STREET). The geographic areas included in this sheet are >> >> >> > recipients >> >> >> > of one government program. But this sheet does not contain the >> >> >> > UNIQUE >> >> >> > GEOGRAPHICAL CODE. >> >> >> > >> >> >> > What I would like to do is to match the geographical data found in >> >> >> > two >> >> >> > sheets, and if they match, copy/replicate/add the UNIQUE >> >> >> > GEOGRAPHICAL >> >> >> > CODE >> >> >> > found in sheet to the other sheet that does not contain the code. >> >> >> > >> >> >> > I would like to include the geographical code, so that it would >> >> >> > become >> >> >> > the >> >> >> > primary key when I create a database in MS Access. >> >> >> > >> >> >> > This is the example >> >> >> > >> >> >> > SHEET 1 >> >> >> > A B C D E >> >> >> > 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET >> >> >> > >> >> >> > *Column A contains the UNIQUE GEOGRAPHICAL CODE >> >> >> > >> >> >> > SHEET 2 >> >> >> > A B C D >> >> >> > REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET >> >> >> > >> >> >> > *Sheet 2 contains only 20k entries of geographical areas while >> >> >> > Sheet >> >> >> > 1 >> >> >> > contains about 40k entries. Only half of the geographical areas >> >> >> > are >> >> >> > included >> >> >> > in the government program >> >> >> > >> >> >> > Can you help me? >> >> >> > >> >> >> > >> >> >> > On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed >> >> >> > <waheedb...@gmail.com> >> >> >> > wrote: >> >> >> >> >> >> >> >> Hi, >> >> >> >> >> >> >> >> Right Click on the pivot table, select Pivot Tabel Options, move >> >> >> >> to >> >> >> >> 'Data' tab and then Uncheck- "Enable Show Details". >> >> >> >> For the date format i think its working fine in both rows n >> >> >> >> columns. >> >> >> >> >> >> >> >> Regards, >> >> >> >> Waheed. >> >> >> >> >> >> >> >> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu <prabhugate...@gmail.com> >> >> >> >> wrote: >> >> >> >> > HI All, >> >> >> >> > Plz find the pivot table sheet. >> >> >> >> > kindly help. >> >> >> >> > Regards, >> >> >> >> > Prabhu >> >> >> >> > >> >> >> >> > -- >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > ---------------------------------------------------------------------------------- >> >> >> >> > Some important links for excel users: >> >> >> >> > 1. Follow us on TWITTER for tips tricks and links : >> >> >> >> > http://twitter.com/exceldailytip >> >> >> >> > 2. Join our LinkedIN group @ >> >> >> >> > http://www.linkedin.com/groups?gid=1871310 >> >> >> >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >> >> >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >> >> >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> >> > >> >> >> >> > To post to this group, send email to >> >> >> >> > excel-macros@googlegroups.com >> >> >> >> > >> >> >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> >> >> >> > Like our page on facebook , Just follow below link >> >> >> >> > http://www.facebook.com/discussexcel >> >> >> >> > >> >> >> >> >> >> >> >> -- >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> >> >> Some important links for excel users: >> >> >> >> 1. Follow us on TWITTER for tips tricks and links : >> >> >> >> http://twitter.com/exceldailytip >> >> >> >> 2. Join our LinkedIN group @ >> >> >> >> http://www.linkedin.com/groups?gid=1871310 >> >> >> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >> >> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >> >> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> >> >> >> >> >> To post to this group, send email to >> >> >> >> excel-macros@googlegroups.com >> >> >> >> >> >> >> >> <><><><><><><><><><><><><><><><><><><><><><> >> >> >> >> Like our page on facebook , Just follow below link >> >> >> >> http://www.facebook.com/discussexcel >> >> >> > >> >> >> > >> >> >> > >> >> >> > -- >> >> >> > John Alliage Tinio Morales >> >> >> > Researcher >> >> >> > GMA News and Public Affairs >> >> >> > Mobile: 0915.846.8473 >> >> >> > Tel: (02) 982.7777 loc 1338 >> >> >> > Fax: (02) 982.7777 loc 1340 >> >> >> > >> >> >> > >> >> >> > >> >> >> > DISCLAIMER: >> >> >> > This Message may contain confidential information intended only >> >> >> > for >> >> >> > the >> >> >> > use >> >> >> > of the addressee named above. If you are not the intended >> >> >> > recipient >> >> >> > of >> >> >> > this >> >> >> > message you are hereby notified that any use, dissemination, >> >> >> > distribution or >> >> >> > reproduction of this message is prohibited. If you received this >> >> >> > message >> >> >> > in >> >> >> > error please notify your Mail Administrator and delete this >> >> >> > message >> >> >> > immediately. Any views expressed in this message are those of the >> >> >> > individual >> >> >> > sender and may not necessarily reflect the views of GMA Network, >> >> >> > Inc. >> >> >> > >> >> >> > >> >> > >> >> > >> >> > >> >> > -- >> >> > John Alliage Tinio Morales >> >> > Researcher >> >> > GMA News and Public Affairs >> >> > Mobile: 0915.846.8473 >> >> > Tel: (02) 982.7777 loc 1338 >> >> > Fax: (02) 982.7777 loc 1340 >> >> > >> >> > >> >> > >> >> > DISCLAIMER: >> >> > This Message may contain confidential information intended only for >> >> > the >> >> > use >> >> > of the addressee named above. If you are not the intended recipient >> >> > of >> >> > this >> >> > message you are hereby notified that any use, dissemination, >> >> > distribution or >> >> > reproduction of this message is prohibited. If you received this >> >> > message >> >> > in >> >> > error please notify your Mail Administrator and delete this message >> >> > immediately. Any views expressed in this message are those of the >> >> > individual >> >> > sender and may not necessarily reflect the views of GMA Network, Inc. >> >> > >> >> > >> > >> > >> > >> > -- >> > John Alliage Tinio Morales >> > Researcher >> > GMA News and Public Affairs >> > Mobile: 0915.846.8473 >> > Tel: (02) 982.7777 loc 1338 >> > Fax: (02) 982.7777 loc 1340 >> > >> > >> > >> > DISCLAIMER: >> > This Message may contain confidential information intended only for the >> > use >> > of the addressee named above. If you are not the intended recipient of >> > this >> > message you are hereby notified that any use, dissemination, >> > distribution or >> > reproduction of this message is prohibited. If you received this message >> > in >> > error please notify your Mail Administrator and delete this message >> > immediately. Any views expressed in this message are those of the >> > individual >> > sender and may not necessarily reflect the views of GMA Network, Inc. >> > >> > >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel