With help from Teradyne, we figured this out. The problem was that the configuration of the backplane ISA slots gets erased when the battery is removed. In our case, there are two IEEE-488 boards in the ISA slots. The software tries to talk to these during the boot up, and hangs when they don't answRead more
With help from Teradyne, we figured this out.
The problem was that the configuration of the backplane ISA slots gets erased when the battery is removed.
In our case, there are two IEEE-488 boards in the ISA slots.
The software tries to talk to these during the boot up, and hangs when they don’t answer. (generating the cryptic BUGCHECK error)
The solution for how to fix this is given in an old (2001) Teradyne Product Support Bulletin: PSB #559-500-08.
Word to the wise: If you are considering replacing the 15+ year-old battery in your DEC Alpha computer, before you do you should type the following two commands at the >>> prompt:
>>>SHO *
>>>SHO CONFIG
Write down all the setting from these two commands before you replace the battery.
Then with the new battery installed, update all the SHO * settings using SET commands, and update the SHO CONFIG settings using the ISACFG command.
Do an internet search to find out about the ISACFG command.
Remove blank rows in ExcelThis technique works if there's a column in your table that helps to see if it's an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.It is necessary to save lots of the rows order, thus we will not simply type the tRead more
Remove blank rows in Excel This technique works if there’s a column in your table that helps to see if it’s an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.
It is necessary to save lots of the rows order, thus we will not simply type the table by that column to move the blank rows to the lowest.
Use Filter Button for this issue and click here for better understanding with screenshots.
For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like. Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting froRead more
For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like.
Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting from the left:
=LEFT(A1,LEN(A1)-3)
If the part you want to strip off might contain something other than 3 characters, then we need to find the 2nd dot in the string and remove it and everything after it. This formula should work regardless of how many characters follow the 2nd dot.
=LEFT(A1,FIND(“.”,A1,FIND(“.”,A1)+1)-1)
For your second question, your text doesn’t match your screen capture, so I don’t really know what you are looking for.
Your text says “I want only “ME” email ids only” but your screen capture shows support@168.com in the same column as the “me” emails.
Here is an updated formula. Replace the formula in cell C1 with this: =COUNTA(INDEX(B:B,MATCH(TODAY(),A:A,0)):INDEX(B:B,MAX(1,MATCH(TODAY(),A:A,0)-29))) The previous formula would SUM the numbers in column B so, if by mistake you entered any number other than 1 your count of the days would be in errRead more
Here is an updated formula.
Replace the formula in cell C1 with this:
The previous formula would SUM the numbers in column B
so, if by mistake you entered any number other than 1
your count of the days would be in error.
This new formula Counts the number of non-empty cells
so, you can put any character you like or you could note
the site number and the count of days will be correct.
I have not done much with Dates in Word docs, so all I can offer is this link:http://www.gmayor.com/insert_a_date...A lot more difficult then I thought.MIKEhttp://www.skeptic.com/
I have not done much with Dates in Word docs, so all I can offer is this link:
I hope you are using Excel 2007 or later. If not, this solution will not work for you. Since you are looking to return data from a single sheet, the solution is fairly simple. Long, but fairly simple. The formula at the bottom of this post will look through 9 sheets (Sheet2:Sheet10) and return the dRead more
I hope you are using Excel 2007 or later. If not, this solution will not work for you.
Since you are looking to return data from a single sheet, the solution is fairly simple.
Long, but fairly simple.
The formula at the bottom of this post will look through 9 sheets (Sheet2:Sheet10) and return the data from the first sheet where the lookup_value is found. In this example, the formula searches A2:A10 on each sheet and returns a value from B2:B10 on that same sheet. If the lookup_value is not found on any sheet, the formula will return a blank cell. Obviously, the formula will need to be modified to fit your specific situation.
It is nothing more than a Nested IF using the ISNA function to determine if VLOOKUP found the lookup_value on a given sheet.
Perhaps starting with a shorter version would help. This formula searches 2 ranges on the same sheet, just to make the formula easier to read. If the first VLOOKUP returns a #N/A error, meaning that value wasn’t found in A1:A3, the first IF will be TRUE and the next VLOOKUP will be tested. If that VLOOKUP also returns a #N/A error, the second IF will be TRUE and a blank cell will be returned. On the other hand, if any IF does not return a #N/A error, that means the value has been found and the formula will skip to the FALSE argument for that IF and actually do the VLOOKUP, returning the requested value.
The trick it to keep the VLOOKUPs in the correct sheet order so the value_if_false argument for each IF matches up. Basically you count “up” through the sheets for the IF functions and then “down” through the sheets for the actual VLOOKUP’s in the value_if_false arguments.
Let me know if you need a more detailed explanation.
My Windows 7 box has faster response times for web pages loading then my XP box and both use the same router/comcast. I suspect Windows 7 is just doing a better job of caching by design. The question why is 7 faster than XP is like asking why is broadband faster than dialup. Old technology comparedRead more
My Windows 7 box has faster response times for web pages loading then my XP box and both use the same router/comcast.
I suspect Windows 7 is just doing a better job of caching by design.
The question why is 7 faster than XP is like asking why is broadband faster than dialup. Old technology compared to newer technology will always have newer being faster since that is what the market demands.
At lot depends on where you are and the infrastructure that is available to you. I see one of the hops is pal9-telecom-egypt which means you are somewhere in the Middle East if not Egypt itself. If your local ISP and infrastructure is a bit short on bandwidth then you are going to get long responseRead more
At lot depends on where you are and the infrastructure that is available to you. I see one of the hops is pal9-telecom-egypt which means you are somewhere in the Middle East if not Egypt itself.
If your local ISP and infrastructure is a bit short on bandwidth then you are going to get long response time. The response from your ISP is good but once you are outside of your ISPs control there is nothing you can do about it.
Compare yours to mine:
Tracing route to ir1.fp.vip.sp2.yahoo.com [98.137.149.56]
over a maximum of 30 hops:
1 33 ms 99 ms 99 ms api.home [192.168.1.254]
2 20 ms 20 ms 21 ms esr11.manchester6.broadband.bt.net [217.47.158.142]
3 21 ms 21 ms 21 ms 217.47.158.13
4 20 ms 21 ms 21 ms 213.123.108.6
5 20 ms 21 ms 21 ms 217.41.173.17
6 21 ms 21 ms 20 ms 217.41.173.66
7 21 ms 21 ms 20 ms 217.41.173.142
8 21 ms 20 ms 21 ms 217.41.173.62
9 21 ms 20 ms 21 ms 217.47.109.114
10 21 ms 20 ms 21 ms core1-pos5-7.manchester.ukcore.bt.net [194.72.2.181]
11 26 ms 28 ms 26 ms core1-pos0-9-5-0.ealing.ukcore.bt.net [62.172.103.66]
12 27 ms 27 ms 27 ms core1-pos14-0.telehouse.ukcore.bt.net [195.99.125.189]
13 27 ms 27 ms 26 ms 194.74.65.34
14 116 ms 115 ms 120 ms so-1-0-0.pat1.nyc.yahoo.com [66.196.65.13]
15 112 ms 110 ms 111 ms ge-2-0-0.pat2.nyc.yahoo.com [216.115.111.64]
16 130 ms 142 ms 135 ms so-3-0-0.pat1.che.yahoo.com [216.115.101.158]
17 167 ms 167 ms 165 ms as-1.pat1.dnx.yahoo.com [216.115.96.34]
18 199 ms 196 ms 195 ms as-0.pat1.sjc.yahoo.com [216.115.101.149]
19 185 ms 183 ms 182 ms UNKNOWN-216-115-107-57.yahoo.com [216.115.107.57]
20 196 ms 194 ms 191 ms te-9-1.bas1-1-prd.sp2.yahoo.com [67.195.128.249]
21 184 ms 175 ms 179 ms ir1.fp.vip.sp2.yahoo.com [98.137.149.56]
My faster speeds is because there is a lot more bandwidth available between the UK and the USA than there is between Egypt and the USA. Response 14 is the transatlantic hop.
Unusual to have two places for an IP address. I can only guess that the second IP address is reserved for an IPv6 address and you don't have IPv6 installed. If everything is working properly I wouldn't worry about it. From the description I can see that you have your Modem plugged directly into youRead more
Unusual to have two places for an IP address. I can only guess that the second IP address is reserved for an IPv6 address and you don’t have IPv6 installed. If everything is working properly I wouldn’t worry about it.
From the description I can see that you have your Modem plugged directly into you computer. I would give some consideration to getting a router. This will have a built in firewall and along with NAT will give you some protection from hackers. As it is your computer will be visible to all on sundry on the Internet.
Is this a wired or wireless network? The only way a computer can pick up the wrong IP address is if some other computer or device is providing DHCP services. Such as another wireless router that is in range.
Is this a wired or wireless network?
The only way a computer can pick up the wrong IP address is if some other computer or device is providing DHCP services. Such as another wireless router that is in range.
DEC Alpha Computer CR2032 Battery Replacement
With help from Teradyne, we figured this out. The problem was that the configuration of the backplane ISA slots gets erased when the battery is removed. In our case, there are two IEEE-488 boards in the ISA slots. The software tries to talk to these during the boot up, and hangs when they don't answRead more
With help from Teradyne, we figured this out.
See lessThe problem was that the configuration of the backplane ISA slots gets erased when the battery is removed.
In our case, there are two IEEE-488 boards in the ISA slots.
The software tries to talk to these during the boot up, and hangs when they don’t answer. (generating the cryptic BUGCHECK error)
The solution for how to fix this is given in an old (2001) Teradyne Product Support Bulletin: PSB #559-500-08.
Word to the wise: If you are considering replacing the 15+ year-old battery in your DEC Alpha computer, before you do you should type the following two commands at the >>> prompt:
>>>SHO *
>>>SHO CONFIG
Write down all the setting from these two commands before you replace the battery.
Then with the new battery installed, update all the SHO * settings using SET commands, and update the SHO CONFIG settings using the ISACFG command.
Do an internet search to find out about the ISACFG command.
Is There A Formula To Skip Blank Rows In Excel?
Remove blank rows in ExcelThis technique works if there's a column in your table that helps to see if it's an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.It is necessary to save lots of the rows order, thus we will not simply type the tRead more
This technique works if there’s a column in your table that helps to see if it’s an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.
It is necessary to save lots of the rows order, thus we will not simply type the table by that column to move the blank rows to the lowest.
Use Filter Button for this issue and click here for better understanding with screenshots.
message edited by aren111
I Want Separate Email Ids In Excel Sheet
For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like. Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting froRead more
For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like.
Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting from the left:
=LEFT(A1,LEN(A1)-3)
If the part you want to strip off might contain something other than 3 characters, then we need to find the 2nd dot in the string and remove it and everything after it. This formula should work regardless of how many characters follow the 2nd dot.
=LEFT(A1,FIND(“.”,A1,FIND(“.”,A1)+1)-1)
For your second question, your text doesn’t match your screen capture, so I don’t really know what you are looking for.
Your text says “I want only “ME” email ids only” but your screen capture shows support@168.com in the same column as the “me” emails.
What exactly are you looking for?
See lessI Need A 30 Day Rolling Calendar
Here is an updated formula. Replace the formula in cell C1 with this: =COUNTA(INDEX(B:B,MATCH(TODAY(),A:A,0)):INDEX(B:B,MAX(1,MATCH(TODAY(),A:A,0)-29))) The previous formula would SUM the numbers in column B so, if by mistake you entered any number other than 1 your count of the days would be in errRead more
Here is an updated formula.
Replace the formula in cell C1 with this:
=COUNTA(INDEX(B:B,MATCH(TODAY(),A:A,0)):INDEX(B:B,MAX(1,MATCH(TODAY(),A:A,0)-29)))
The previous formula would SUM the numbers in column B
so, if by mistake you entered any number other than 1
your count of the days would be in error.
This new formula Counts the number of non-empty cells
See lessso, you can put any character you like or you could note
the site number and the count of days will be correct.
How To Do Date + 30 Days In A Word Doc
I have not done much with Dates in Word docs, so all I can offer is this link:http://www.gmayor.com/insert_a_date...A lot more difficult then I thought.MIKEhttp://www.skeptic.com/
so all I can offer is this link:
http://www.gmayor.com/insert_a_date…
A lot more difficult then I thought.
MIKE
http://www.skeptic.com/
Excel Vlookup Over Multiple Sheets
I hope you are using Excel 2007 or later. If not, this solution will not work for you. Since you are looking to return data from a single sheet, the solution is fairly simple. Long, but fairly simple. The formula at the bottom of this post will look through 9 sheets (Sheet2:Sheet10) and return the dRead more
I hope you are using Excel 2007 or later. If not, this solution will not work for you.
Since you are looking to return data from a single sheet, the solution is fairly simple.
Long, but fairly simple.
The formula at the bottom of this post will look through 9 sheets (Sheet2:Sheet10) and return the data from the first sheet where the lookup_value is found. In this example, the formula searches A2:A10 on each sheet and returns a value from B2:B10 on that same sheet. If the lookup_value is not found on any sheet, the formula will return a blank cell. Obviously, the formula will need to be modified to fit your specific situation.
It is nothing more than a Nested IF using the ISNA function to determine if VLOOKUP found the lookup_value on a given sheet.
Perhaps starting with a shorter version would help. This formula searches 2 ranges on the same sheet, just to make the formula easier to read. If the first VLOOKUP returns a #N/A error, meaning that value wasn’t found in A1:A3, the first IF will be TRUE and the next VLOOKUP will be tested. If that VLOOKUP also returns a #N/A error, the second IF will be TRUE and a blank cell will be returned. On the other hand, if any IF does not return a #N/A error, that means the value has been found and the formula will skip to the FALSE argument for that IF and actually do the VLOOKUP, returning the requested value.
The trick it to keep the VLOOKUPs in the correct sheet order so the value_if_false argument for each IF matches up. Basically you count “up” through the sheets for the IF functions and then “down” through the sheets for the actual VLOOKUP’s in the value_if_false arguments.
Let me know if you need a more detailed explanation.
=IF(ISNA(VLOOKUP(C1,$A$1:$B$3,2,0)),
IF(ISNA(VLOOKUP(C1,$A$6:$B$8,2,0)),””,
VLOOKUP(C1,$A$6:$B$8,2,0)),
VLOOKUP(C1,$A$1:$B$3,2,0))
Here is the expanded version to search 9 sheets:
=IF(ISNA(VLOOKUP(B1,Sheet2!$A$2:$B$10,2,0)),
See lessIF(ISNA(VLOOKUP(B1,Sheet3!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet4!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet5!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet6!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet7!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet8!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet9!$A$2:$B$10,2,0)),
IF(ISNA(VLOOKUP(B1,Sheet10!$A$2:$B$10,2,0)),””,
VLOOKUP(B1,Sheet10!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet9!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet8!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet7!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet6!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet5!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet4!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet3!$A$2:$B$10,2,0)),
VLOOKUP(B1,Sheet2!$A$2:$B$10,2,0))
Win XP Internet Download Slower Than Win 7
My Windows 7 box has faster response times for web pages loading then my XP box and both use the same router/comcast. I suspect Windows 7 is just doing a better job of caching by design. The question why is 7 faster than XP is like asking why is broadband faster than dialup. Old technology comparedRead more
My Windows 7 box has faster response times for web pages loading then my XP box and both use the same router/comcast.
I suspect Windows 7 is just doing a better job of caching by design.
The question why is 7 faster than XP is like asking why is broadband faster than dialup. Old technology compared to newer technology will always have newer being faster since that is what the market demands.
See lessWhy Is My Ping High??
At lot depends on where you are and the infrastructure that is available to you. I see one of the hops is pal9-telecom-egypt which means you are somewhere in the Middle East if not Egypt itself. If your local ISP and infrastructure is a bit short on bandwidth then you are going to get long responseRead more
At lot depends on where you are and the infrastructure that is available to you. I see one of the hops is pal9-telecom-egypt which means you are somewhere in the Middle East if not Egypt itself.
If your local ISP and infrastructure is a bit short on bandwidth then you are going to get long response time. The response from your ISP is good but once you are outside of your ISPs control there is nothing you can do about it.
Compare yours to mine:
Tracing route to ir1.fp.vip.sp2.yahoo.com [98.137.149.56]
over a maximum of 30 hops:
1 33 ms 99 ms 99 ms api.home [192.168.1.254]
2 20 ms 20 ms 21 ms esr11.manchester6.broadband.bt.net [217.47.158.142]
3 21 ms 21 ms 21 ms 217.47.158.13
4 20 ms 21 ms 21 ms 213.123.108.6
5 20 ms 21 ms 21 ms 217.41.173.17
6 21 ms 21 ms 20 ms 217.41.173.66
7 21 ms 21 ms 20 ms 217.41.173.142
8 21 ms 20 ms 21 ms 217.41.173.62
9 21 ms 20 ms 21 ms 217.47.109.114
10 21 ms 20 ms 21 ms core1-pos5-7.manchester.ukcore.bt.net [194.72.2.181]
11 26 ms 28 ms 26 ms core1-pos0-9-5-0.ealing.ukcore.bt.net [62.172.103.66]
12 27 ms 27 ms 27 ms core1-pos14-0.telehouse.ukcore.bt.net [195.99.125.189]
13 27 ms 27 ms 26 ms 194.74.65.34
14 116 ms 115 ms 120 ms so-1-0-0.pat1.nyc.yahoo.com [66.196.65.13]
15 112 ms 110 ms 111 ms ge-2-0-0.pat2.nyc.yahoo.com [216.115.111.64]
16 130 ms 142 ms 135 ms so-3-0-0.pat1.che.yahoo.com [216.115.101.158]
17 167 ms 167 ms 165 ms as-1.pat1.dnx.yahoo.com [216.115.96.34]
18 199 ms 196 ms 195 ms as-0.pat1.sjc.yahoo.com [216.115.101.149]
19 185 ms 183 ms 182 ms UNKNOWN-216-115-107-57.yahoo.com [216.115.107.57]
20 196 ms 194 ms 191 ms te-9-1.bas1-1-prd.sp2.yahoo.com [67.195.128.249]
21 184 ms 175 ms 179 ms ir1.fp.vip.sp2.yahoo.com [98.137.149.56]
My faster speeds is because there is a lot more bandwidth available between the UK and the USA than there is between Egypt and the USA. Response 14 is the transatlantic hop.
See lessWhy Is My Ip Address A Question Mark?
Unusual to have two places for an IP address. I can only guess that the second IP address is reserved for an IPv6 address and you don't have IPv6 installed. If everything is working properly I wouldn't worry about it. From the description I can see that you have your Modem plugged directly into youRead more
Unusual to have two places for an IP address. I can only guess that the second IP address is reserved for an IPv6 address and you don’t have IPv6 installed. If everything is working properly I wouldn’t worry about it.
See lessFrom the description I can see that you have your Modem plugged directly into you computer. I would give some consideration to getting a router. This will have a built in firewall and along with NAT will give you some protection from hackers. As it is your computer will be visible to all on sundry on the Internet.
Some Devices Picking Up The Wrong IPs From DHCP Server
Is this a wired or wireless network? The only way a computer can pick up the wrong IP address is if some other computer or device is providing DHCP services. Such as another wireless router that is in range.
Is this a wired or wireless network?
See lessThe only way a computer can pick up the wrong IP address is if some other computer or device is providing DHCP services. Such as another wireless router that is in range.