| JamesNorth101 | 05-09-2013 05:04 PM | An easy way to track IP address when when using multiple stealth's. This is a very easy way to make sure that you never use the same IP address twice.
At the top of excel select the column A.
Select the conditional formatting button at the top of the page under the home tab
Select highlight cell rules, then duplicate values.
Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.
After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.
If the cell lights up red, you need to get a new IP, if it lights up green your good to go
Hope this helps
:typing: DOWNLOAD THIS AS A ZIP FILE HERE |
Ebayorbust | 05-11-2013 02:15 AM | Great tip, James.
Your stealth knowledge is seriously impressive for someone that has only been here for 20 days. |
JamesNorth101 | 05-11-2013 04:55 AM | I could pretend I am a fast learner.... But actually I have been doing stealth for a fair few years, never thought to look for a forum dedicated to it until about a month ago. I have learned a number of new things since I have been on here, it is an incredibly knowledgeable place. |
heil86 | 05-11-2013 09:41 AM | Perfect tip for Excel newbies such as myself. Pair this with some of the pre-made spreadsheets floating around and you'll have yourself an easier time. |
GreenBean | 05-11-2013 09:53 AM | |
Johnson1 | 05-11-2013 10:05 AM | Thanks for sharing, great tip. |
Also, if you want to check your IP quickly here is a good way:
1. Enter your IP address associated with your Account
2. Click on " Find & Select" at the top right hand corner of Excel
3. Either Copy/Paste, or enter manually your IP in the search field
4. Click on "Find All"
This will find all the cells with the same IP, here's a little example. http://i41.tinypic.com/33l0a48.jpg |
Ebayorbust | 05-12-2013 01:55 AM | Quote:
Originally Posted by JamesNorth101
(Post 448282)
I could pretend I am a fast learner.... But actually I have been doing stealth for a fair few years, never thought to look for a forum dedicated to it until about a month ago. I have learned a number of new things since I have been on here, it is an incredibly knowledgeable place. | You certainly appear to have learned a lot on your own, just you versus ebay.
Anyway, it's far better to have a place where ideas and support can be shared.
All the best. :) |
wiserjoe727 | 06-04-2013 11:22 PM | great tip thanks for the share |
Dmshark25 | 06-04-2013 11:52 PM | There is an iPhone APP called IP VIEW I know I mentioned this a lot but it really works great u can instantly see if your IP was used as long as you use it every time it keeps a log of all IPs and will tell u instantly if it is new or used, I use this along with excel to be xtra careful |
JamesNorth101 | 06-05-2013 07:18 AM | More ways the merrier, cannot be too careful. |
metatrade | 07-13-2013 07:50 AM | Quote:
Originally Posted by Dmshark25
(Post 455354)
There is an iPhone APP called IP VIEW I know I mentioned this a lot but it really works great u can instantly see if your IP was used as long as you use it every time it keeps a log of all IPs and will tell u instantly if it is new or used, I use this along with excel to be xtra careful | I thought using apps on iPhone or iPad was a big no no for stealth ? |
Quote:
Originally Posted by metatrade
(Post 467045)
I thought using apps on iPhone or iPad was a big no no for stealth ? | It is a big no no to use the EBAY APP. |
GreenBean | 07-13-2013 10:30 AM | |
Sandy D | 07-16-2013 02:40 AM | Quote:
Originally Posted by MM78
(Post 448495)
Also, if you want to check your IP quickly here is a good way:
1. Enter your IP address associated with your Account
2. Click on " Find & Select" at the top right hand corner of Excel
3. Either Copy/Paste, or enter manually your IP in the search field
4. Click on "Find All"
This will find all the cells with the same IP, here's a little example. http://i41.tinypic.com/33l0a48.jpg |
I have used this method for years now.
Thanks for sharing MM.
MM is full of little bits of info like this.
Hidden COMPUUUTTER genius MM is. |
Sandy D | 07-16-2013 02:41 AM | Quote:
Originally Posted by rsot
(Post 467049)
It is a big no no to use the EBAY APP. | I recently purchased a Samsung Galaxy and from all the stories I wont even touch the app. |
Killed by Ebay | 08-16-2013 03:31 AM | Is there a way to be able to do this but only highlight duplicates in different columns but not ones in the same? |
JamesNorth101 | 08-16-2013 03:33 AM | Sorry I don't entirely understand what you mean by this. |
Killed by Ebay | 08-16-2013 04:06 AM | I have columns set up from G through P with each account as the header for each column. I log the IP down the column for whichever account I am using.... So if an IP matches up with another one in its own column it doesn't matter, so I was wondering how I could just have the IP highlight if it mismatches with one from another column. |
grislybear | 08-20-2013 07:20 PM | I'm having the same problem utilizing this method of checking ip addresses. For those of us (assuming most of us) that are doing stealth with multiple accounts, it doesn't really matter if the ip address is a duplicate of an address that was used before for that same account.
Example: column A is date logged in, and column B is ip address used. Both columns are under Stealth Account X. Using this method, red would flash for the entire column B if the ip address was used before in that column, and green would flash for the column if the ip address was not ever used before for this particular Account X. Even if it flashes red indicating a duplicate ip, it doesn't matter because that ip is linked already to the particular account anyways. We would be able to use it without fear of any linkage to begin with.
We are more interested in cross-referencing these ip addresses with OTHER stealth accounts, in order to make sure that a different ebay/paypal has never before used the ip address we want to use. So using the excel spreadsheet, if Stealth Account X has columns A (for date logged in) and B (for ip address used), then Stealth Account Y has columns C (for date logged in) and D (for ip address used), and Stealth Account Z has columns E and F. We want to check if the ip address we put into column B has been used in columns D and F for the other accounts.
Much more useful would be something that flashes in the other columns for ip address. I hope this makes sense!
I have my spreadsheet set up the same as MM78's. You can see the screenshot a couple posts above. |
JamesNorth101 | 08-21-2013 05:17 AM | Quote:
Originally Posted by Killed by Ebay
(Post 477697)
I have columns set up from G through P with each account as the header for each column. I log the IP down the column for whichever account I am using.... So if an IP matches up with another one in its own column it doesn't matter, so I was wondering how I could just have the IP highlight if it mismatches with one from another column. | It is possible, but it is a lot more complex and error prone.
Much easier to just use 'Control H' to locate a previous IP and see which account that IP was used with in the past. |
grislybear | 08-21-2013 05:32 AM | Yeah that's what I thought. I know it's possible using excel but it gets real complicated at some point. Thanks for confirming! | All times are GMT -5. The time now is 07:56 PM. | |
vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Ad Management by RedTyger |