Microsoft Excel Usage Question - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > General Discussions (Off-Topic) > Everything Else

Everything Else For off-topic conversation. The rules are relaxed in here, but play nice!

Reply
 
Thread Tools
  #1  
Old 02-04-2017
florea_cioaca's Avatar
Junior Member
 
Join Date: Jan 2017
Posts: 97
Thanks: 52
Thanked 5 Times in 5 Posts
Activity: 0%
Longevity: 41%
iTrader: (0)
Default Microsoft Excel Usage Question

I know it's not the right forum to ask this but I hope some of the members are aware with excel usage.

I would like to know how I could remove a row that contains a cell where you can find letters.
I scrap some sites and sometimes in the upc field it's letters. I want to drop the entire product(row)if the upc field contains letters.

Thank you if you have any solution.
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 02-04-2017
JamesNorth101's Avatar
Executive [VIP]
 
Join Date: Apr 2013
Posts: 20,073
Thanks: 2,424
Thanked 5,197 Times in 3,996 Posts
Activity: 27%
Longevity: 63%
iTrader: (462)
Default Re: Microsoft Excel Usage Question

You can delete the entire row if you just click the number of the row on the left. Click it and you will get a 'delete row' (or words to that effect) option pop up. If you delete row 5 then row 6 becomes row 5. All excel calculations will be automatically adjusted to take account of the new row numbers (from memory!)
Reply With Quote
The Following User Says Thank You to JamesNorth101 For This Useful Post:
florea_cioaca (02-04-2017)
  #3  
Old 02-04-2017
florea_cioaca's Avatar
Junior Member
Threadstarter  
 
Join Date: Jan 2017
Posts: 97
Thanks: 52
Thanked 5 Times in 5 Posts
Activity: 0%
Longevity: 41%
iTrader: (0)
Default Re: Microsoft Excel Usage Question

Quote:
Originally Posted by JamesNorth101 View Post
You can delete the entire row if you just click the number of the row on the left. Click it and you will get a 'delete row' (or words to that effect) option pop up. If you delete row 5 then row 6 becomes row 5. All excel calculations will be automatically adjusted to take account of the new row numbers (from memory!)
thanks james but I need a kind a formula or something, it's going to be around 100k rows and probably 20-30k rows that have cells with wrong upcs (containing letters)
I need a way to avoid doing this manually.
Reply With Quote
  #4  
Old 02-04-2017
Senior Member
 
Join Date: Aug 2012
Posts: 6,123
Thanks: 1,110
Thanked 1,655 Times in 1,333 Posts
Activity: 0%
Longevity: 67%
iTrader: (38)
Default Re: Microsoft Excel Usage Question

hmm.. this will be a little tedious what i'm about to suggest, but a good solution if there's no alternative.

1. Get a filter setup on the UPC column
2. Using the filter function, search each letter of the alphabet, "A", "B"...
3. Deselect them, then click add current selection to filter (with the UPC/header cell selected).

This will (one alphabet at a time) filter out all the rows that happen to have an alphabet within it.

Then simply copy and paste the remaining rows into a new sheet and you should (technically speaking) have all the rows where the UPC doesn't have letters within it.

Once yot get the hang of it, it wont take you more than a minute to do.

Hope that helps
Reply With Quote
The Following User Says Thank You to Play For This Useful Post:
florea_cioaca (02-05-2017)
  #5  
Old 02-05-2017
florea_cioaca's Avatar
Junior Member
Threadstarter  
 
Join Date: Jan 2017
Posts: 97
Thanks: 52
Thanked 5 Times in 5 Posts
Activity: 0%
Longevity: 41%
iTrader: (0)
Default Re: Microsoft Excel Usage Question

Quote:
Originally Posted by Play View Post
hmm.. this will be a little tedious what i'm about to suggest, but a good solution if there's no alternative.

1. Get a filter setup on the UPC column
2. Using the filter function, search each letter of the alphabet, "A", "B"...
3. Deselect them, then click add current selection to filter (with the UPC/header cell selected).

This will (one alphabet at a time) filter out all the rows that happen to have an alphabet within it.

Then simply copy and paste the remaining rows into a new sheet and you should (technically speaking) have all the rows where the UPC doesn't have letters within it.

Once yot get the hang of it, it wont take you more than a minute to do.

Hope that helps
Play you're the men, I'll try it in a day or two when I finish scrapping.
Reply With Quote
  #6  
Old 02-05-2017
JamesNorth101's Avatar
Executive [VIP]
 
Join Date: Apr 2013
Posts: 20,073
Thanks: 2,424
Thanked 5,197 Times in 3,996 Posts
Activity: 27%
Longevity: 63%
iTrader: (462)
Default Re: Microsoft Excel Usage Question

Quote:
Originally Posted by florea_cioaca View Post
thanks james but I need a kind a formula or something, it's going to be around 100k rows and probably 20-30k rows that have cells with wrong upcs (containing letters)
I need a way to avoid doing this manually.
Ha that is a whole lot larger than I was expecting!
Reply With Quote
The Following User Says Thank You to JamesNorth101 For This Useful Post:
florea_cioaca (02-08-2017)
  #7  
Old 02-10-2017
florea_cioaca's Avatar
Junior Member
Threadstarter  
 
Join Date: Jan 2017
Posts: 97
Thanks: 52
Thanked 5 Times in 5 Posts
Activity: 0%
Longevity: 41%
iTrader: (0)
Default Re: Microsoft Excel Usage Question

don't know if anyone will be faced with the same problem in here but my fastest solution was this formula:

=ISNUMBER(A2) where you replace the A2 with the cell number you want to check
Then you sort by true or false. True contains only numbers and false mixed ( letters and numbers ). Then you delete the one you like easily.
Reply With Quote
The Following User Says Thank You to florea_cioaca For This Useful Post:
Play (02-10-2017)
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
data plan usage on mifi or dongle question barkley70 IP Address 1 03-05-2015 12:29 AM
Entropay usage question a.v.limited Entropay 33 03-07-2014 12:56 PM
paypal usage question trustywatchguy Subscriber Discussions 8 04-24-2013 06:12 AM
Microsoft Excel Formula Killed by Ebay Everything Else 8 07-22-2010 05:16 PM
Question on Virtual Phone Number usage MasterChief Subscriber Discussions 2 03-14-2008 11:18 PM


Aspkin Group

All times are GMT -5. The time now is 08:54 AM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58