| Author | Message | ||
Netsaint Side Hero Username: Netsaint Post Number: 2238 Registered: 05-2008 Posted From: 75.185.82.44 Rating: N/A |
gutthivankay: mega fans ni paapam excel batch ani edispithu untaru. atleast ee vidhamga ga skills help auhtunnai "chinmaya chidaaanda chidvilasa brundaavana sundara sukumaara saundharya gaandharva lalaaama Thana yavvana poooritha prapoooritha prajwalitha netra thanaku thanai digivacchina vanithaa mani thana vihaara vinoda vinooothna spoorthi andhamai gandhamai anubandhamaiiiii..... My Telugu Bhakthi Blog :http://gurugeetha.blogspot.com/ | ||
Guttonkay Side Hero Username: Guttonkay Post Number: 2776 Registered: 05-2008 Posted From: 148.87.67.136 Rating: |
that was very helpfull too idle. You post came after I finished several google searches. Thanks so much though. | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 22059 Registered: 02-2008 Posted From: 24.147.136.253 Rating: N/A |
 RahulGandhi/JP/Chiru | ||
Guttonkay Side Hero Username: Guttonkay Post Number: 2774 Registered: 05-2008 Posted From: 148.87.67.136 Rating: |
Thanks all. Resolved it. Don't have VB or MSaccess. Did with macros. | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 22058 Registered: 02-2008 Posted From: 24.147.136.253 Rating: N/A |
=IF(ISERROR(FIND("B",A1)),"",A1) 1. put all the data in one column say A, then paste above function in cell B1, if A1 has name it puts name in B1 or else empty 2. Drag the formula to all rows 3. copy B column 4, go to another sheet and right click on any cell and select paste special and select "only values" 5. sort the column to eliminate empty rows RahulGandhi/JP/Chiru | ||
Ishan Side Hero Username: Ishan Post Number: 2792 Registered: 01-2009 Posted From: 68.90.244.232 Rating: N/A |
Try If function. Something like this, =If("cell"=B, B, "") ...and I am never gonna dance again...guilty feet I have got no rhythm...though its easy to pretend...I know you are not a fool...I should've known better than to cheat a friend...wasted chance that I'been given...so I am never gonna dance again...the way I danced with you... http://www.youtube.com/watch?v=bQtlrBziyzI http://www.youtube.com/watch?v=zALiyJ02k_Y | ||
Rekkadithe_gani_dokkadadhu Junior Artist Username: Rekkadithe_gani_dokkadadhu Post Number: 808 Registered: 01-2010 Posted From: 68.206.114.127 Rating: N/A |
or use vb macro యుగానికొక్కడు-సచిన్ | ||
Raogaru Comedian Username: Raogaru Post Number: 1195 Registered: 01-2010 Posted From: 166.217.21.13 Rating: N/A |
or save the file in csv file and then use 'awk' to emit the data with matching values, redirect to file నన్ను ఇన్వాల్వు చేయకండి సార్ | ||
Rekkadithe_gani_dokkadadhu Junior Artist Username: Rekkadithe_gani_dokkadadhu Post Number: 807 Registered: 01-2010 Posted From: 68.206.114.127 Rating: N/A |
If u have MS access you can export that excel file to MSACCESS and do SELECT name from ..where Name like '%B'; once you get what ever results copy them and paste in xcel sheet... యుగానికొక్కడు-సచిన్ | ||
Raogaru Comedian Username: Raogaru Post Number: 1194 Registered: 01-2010 Posted From: 166.217.21.13 Rating: N/A |
you can filter the data and then copy the filtered data to new worksheet or use a macro to do the job నన్ను ఇన్వాల్వు చేయకండి సార్ | ||
Stig Junior Artist Username: Stig Post Number: 517 Registered: 01-2010 Posted From: 99.27.205.153 Rating: N/A |
Ctrl- F lo Options select chesi direct ga copy chesukovachhu !! formatting teda vastundemo kakapothe !! ------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
Guttonkay Side Hero Username: Guttonkay Post Number: 2771 Registered: 05-2008 Posted From: 148.87.67.136 Rating: N/A |
Addtional info - B occurs only in some rows. Say 50% of the total rows. | ||
Guttonkay Side Hero Username: Guttonkay Post Number: 2769 Registered: 05-2008 Posted From: 148.87.67.136 Rating: N/A |
I have a large file. I need to find rows that have B in them name and put them in a new worksheet. Is there a way to do this in one go? The issue is that the rows with B in the name are all over the place. TIA. |
