You say "Column B actually has the date formula". It would help if you told us what that formula is. For example, let's say you have this: A B 1 2/1/2016 2 =IF(B2>DATEVALUE("1/01/2016"), "√","") =IF(A1="","",A1)If you delete the date in A1 you will get the √ in A2 because the "value" of the "blanRead more
You say “Column B actually has the date formula“. It would help if you told us what that formula is.
For example, let’s say you have this:
A B
1 2/1/2016
2 =IF(B2>DATEVALUE("1/01/2016"), "√","") =IF(A1="","",A1)
If you delete the date in A1 you will get the √ in A2 because the “value” of the “blank cell” returned by the formula in B2 is considered greater than the DATEVALUE of any given date. Don’t ask me why, it just is.
Not knowing what formula you are actually using, I’ll toss out this workaround for my example:
EDIT:
Try this in A2 instead of the more complicated workaround I offered below. If this doesn’t help, then please tell us the exact “date formula” you are using. (I’m not even sure what a “date formula” is.)
Set your options so that 0 (zero’s) are not displayed in your workbook.
Put this in B2:
=IF(A1=””,,A1)
By not using using the “” to return a blank cell, the formula will return 0 if A1 is blank. Since 0 is not greater that DATEVALUE(“1/01/2016”), the IF in A2 will be FALSE and the cell will remain visually empty.
The reason you need to set the option to not display 0’s, is because 0 will appear as 1/0/1900 in B2, assuming it is formatted as a date.
Try this:Press Alt-F11 to open the VBA editor.Double Click the ThisWorkbook module in the left hand column.Paste this code in the pane that opens. It will run automatically each time the user prints the workbookRead the comments to see what it does.Private Sub Workbook_BeforePrint(Cancel As Boolean)Read more
Try this:
Press Alt-F11 to open the VBA editor.
Double Click the ThisWorkbook module in the left hand column.
Paste this code in the pane that opens. It will run automatically each time the user prints the workbook
Read the comments to see what it does.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
'Disable events while code runs
Application.EnableEvents = False
'Loop through sheets
For shts = 1 To Sheets.Count
'Read Sheet Name
Select Case Sheets(shts).Name
'If Name = Main, Don't Print it
Case "Main"
Cancel = True
'If Name = Cont_Sheet, Check B3, print if not empty
Case "Cont_Sheet"
If Sheets(shts).Range("B3") <> "" Then _
Sheets(shts).PrintOut
'All other sheets, check AX43, print if not empty
Case Else
If Sheets(shts).Range("AX43") <> "" Then _
Sheets(shts).PrintOut
End Select
Next
Application.EnableEvents = True
End Sub
any help with setting up my own sheet You haven't provided any information on what your looking for.You have a spreadsheet that does what you want, so what does it look like and how do you want it modified?What does your current worksheet not do, that you want it to do?What does it do, that you don'Read more
any help with setting up my own sheet
You haven’t provided any information on what your looking for.
You have a spreadsheet that does what you want, so what does it look like and how do you want it modified?
What does your current worksheet not do, that you want it to do? What does it do, that you don’t want it to do?
We need more specific information.
If you wish to post an example of your worksheet please read this How-To it explains how to you the < PRE > tags:
It seems like this could be done with VLOOKUPs. Since we don't know the "weighting" of each criteria we can't be exact, but you could build a table similar to the one below and SUM the values returned by VLOOKUP for each criteria.If the criteria have a range of values that return a specific score, tRead more
It seems like this could be done with VLOOKUPs.
Since we don’t know the “weighting” of each criteria we can’t be exact, but you could build a table similar to the one below and SUM the values returned by VLOOKUP for each criteria.
If the criteria have a range of values that return a specific score, then you would use TRUE (1) as the range_lookup argument. See the Help files on VLOOKUP for a more detail explanation.
Using the values in the table below, this formula will return 90:
The file extension of WR1 are Lotus file types.To convert them to Excel .xls files see here:http://www.mrexcel.com/archive/VBA/...MIKEhttp://www.skeptic.com/
http://www.differencebetween.net/te...Answers are only as good as the information you provide.How to properly post a question: Sorry no tech support via PM's
Also, run Snail, don't install any drivers, just upload screenshots of everything that is listed.SnailDriver for PC'shttps://www.softpedia.com/get/Syste...https://snailsuite.com/download-sna...For laptops/notebookshttps://www.softpedia.com/dyn-postd...http://www.freewarefiles.com/Snail-...http://wwwRead more
Also, run Snail, don’t install any drivers, just upload screenshots of everything that is listed.
Who setup your network? DId they do this because of security to prevent the other LAN from being connected to the Internet? If security is not an issue then yes all you need is a simple router to connect the LANs. You want the Internet accesable LAN to be connected to External (WAN) side of the routRead more
Who setup your network? DId they do this because of security to prevent the other LAN from being connected to the Internet?
If security is not an issue then yes all you need is a simple router to connect the LANs. You want the Internet accesable LAN to be connected to External (WAN) side of the router and you will want to give it a static IPs for each LAN on appropriate router connection. Don’t forget to setup a Reservation in your DHCP servers.
If the router has IP Filtering then you will need to setup port forwarding for ICMP and what ever else you need to get through. You may just op to for “Allow Any” to turn off the Firewall. If you do that make sure you do not allow DHCP through or you will get into DHCP wars between the servers depending on the TTL.
If you plan to make a one by one copy of that drive, you can use Norton Ghost and make an Image disk to disk. Or you can use a Linux Live CD and use the dd command to create a one by one copy of the whole harddrive.
If you plan to make a one by one copy of that drive, you can use Norton Ghost and make an Image disk to disk.
Or you can use a Linux Live CD and use the dd command to create a one by one copy of the whole harddrive.
If Statement Using Dates
You say "Column B actually has the date formula". It would help if you told us what that formula is. For example, let's say you have this: A B 1 2/1/2016 2 =IF(B2>DATEVALUE("1/01/2016"), "√","") =IF(A1="","",A1)If you delete the date in A1 you will get the √ in A2 because the "value" of the "blanRead more
For example, let’s say you have this:
A B 1 2/1/2016 2 =IF(B2>DATEVALUE("1/01/2016"), "√","") =IF(A1="","",A1)If you delete the date in A1 you will get the √ in A2 because the “value” of the “blank cell” returned by the formula in B2 is considered greater than the DATEVALUE of any given date. Don’t ask me why, it just is.
Not knowing what formula you are actually using, I’ll toss out this workaround for my example:
EDIT:
Try this in A2 instead of the more complicated workaround I offered below. If this doesn’t help, then please tell us the exact “date formula” you are using. (I’m not even sure what a “date formula” is.)
= IF(AND(ISNUMBER(B46),B46>DATEVALUE(“1/01/2016”)), “√”,””)
EDIT
Set your options so that 0 (zero’s) are not displayed in your workbook.Put this in B2:=IF(A1=””,,A1)By not using using the “” to return a blank cell, the formula will return 0 if A1 is blank. Since 0 is not greater that DATEVALUE(“1/01/2016”), the IF in A2 will be FALSE and the cell will remain visually empty.The reason you need to set the option to not display 0’s, is because 0 will appear as 1/0/1900 in B2, assuming it is formatted as a date.Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Excel:Print Specific Pg Based On Cell Content
Try this:Press Alt-F11 to open the VBA editor.Double Click the ThisWorkbook module in the left hand column.Paste this code in the pane that opens. It will run automatically each time the user prints the workbookRead the comments to see what it does.Private Sub Workbook_BeforePrint(Cancel As Boolean)Read more
Press Alt-F11 to open the VBA editor.
Double Click the ThisWorkbook module in the left hand column.
Paste this code in the pane that opens. It will run automatically each time the user prints the workbook
Read the comments to see what it does.
Private Sub Workbook_BeforePrint(Cancel As Boolean) 'Disable events while code runs Application.EnableEvents = False 'Loop through sheets For shts = 1 To Sheets.Count 'Read Sheet Name Select Case Sheets(shts).Name 'If Name = Main, Don't Print it Case "Main" Cancel = True 'If Name = Cont_Sheet, Check B3, print if not empty Case "Cont_Sheet" If Sheets(shts).Range("B3") <> "" Then _ Sheets(shts).PrintOut 'All other sheets, check AX43, print if not empty Case Else If Sheets(shts).Range("AX43") <> "" Then _ Sheets(shts).PrintOut End Select Next Application.EnableEvents = True End SubExcel Formulas To Show Clashes – How To Set Up Aspreadsheet
any help with setting up my own sheet You haven't provided any information on what your looking for.You have a spreadsheet that does what you want, so what does it look like and how do you want it modified?What does your current worksheet not do, that you want it to do?What does it do, that you don'Read more
You haven’t provided any information on what your looking for.
You have a spreadsheet that does what you want,
so what does it look like and how do you want it modified?
What does your current worksheet not do, that you want it to do?
What does it do, that you don’t want it to do?
We need more specific information.
If you wish to post an example of your worksheet please read this How-To
it explains how to you the < PRE > tags:
http://www.computing.net/howtos/sho…
MIKE
http://www.skeptic.com/
Excel Formula – Score Based On Criteria
It seems like this could be done with VLOOKUPs. Since we don't know the "weighting" of each criteria we can't be exact, but you could build a table similar to the one below and SUM the values returned by VLOOKUP for each criteria.If the criteria have a range of values that return a specific score, tRead more
Since we don’t know the “weighting” of each criteria we can’t be exact, but you could build a table similar to the one below and SUM the values returned by VLOOKUP for each criteria.
If the criteria have a range of values that return a specific score, then you would use TRUE (1) as the range_lookup argument. See the Help files on VLOOKUP for a more detail explanation.
Using the values in the table below, this formula will return 90:
=VLOOKUP(C1, $A$2:$B$4, 2, 1) +
VLOOKUP(C6, $A$7:$B$9, 2, 1) +
VLOOKUP(C11, $A$12:$B$14, 2, 0) +
VLOOKUP(C16, $A$17:$B$19, 2, 0)
Obviously this is just to show you the concept. You will have to build your tables to match your value vs. score relationships.
Difficulty Reading Wr1 Files.
The file extension of WR1 are Lotus file types.To convert them to Excel .xls files see here:http://www.mrexcel.com/archive/VBA/...MIKEhttp://www.skeptic.com/
To convert them to Excel .xls files see here:
http://www.mrexcel.com/archive/VBA/…
MIKE
http://www.skeptic.com/
VDSL To Cable Converter?
http://www.differencebetween.net/te...Answers are only as good as the information you provide.How to properly post a question: Sorry no tech support via PM's
Answers are only as good as the information you provide.
How to properly post a question:
Sorry no tech support via PM’s
How To Track Origin Of Video Uploaded In Website?
Get another BF! It will only get worse on issues with trust.
Get another BF! It will only get worse on issues with trust.
See lessHow Do I Fix Dialup Connection Error 777?
Also, run Snail, don't install any drivers, just upload screenshots of everything that is listed.SnailDriver for PC'shttps://www.softpedia.com/get/Syste...https://snailsuite.com/download-sna...For laptops/notebookshttps://www.softpedia.com/dyn-postd...http://www.freewarefiles.com/Snail-...http://wwwRead more
SnailDriver for PC’s
https://www.softpedia.com/get/Syste…
https://snailsuite.com/download-sna…
For laptops/notebooks
https://www.softpedia.com/dyn-postd…
http://www.freewarefiles.com/Snail-…
http://www.freewarefiles.com/screen…
https://snailsuite.com/snail-driver…
directupload ( no time delays/Captcha-I’m not a Robot/account/registration needed ) Give us the link/links please.
http://en.directupload.net/
Best Way To Access Two Networks From One PC
Who setup your network? DId they do this because of security to prevent the other LAN from being connected to the Internet? If security is not an issue then yes all you need is a simple router to connect the LANs. You want the Internet accesable LAN to be connected to External (WAN) side of the routRead more
Who setup your network? DId they do this because of security to prevent the other LAN from being connected to the Internet?
If security is not an issue then yes all you need is a simple router to connect the LANs. You want the Internet accesable LAN to be connected to External (WAN) side of the router and you will want to give it a static IPs for each LAN on appropriate router connection. Don’t forget to setup a Reservation in your DHCP servers.
If the router has IP Filtering then you will need to setup port forwarding for ICMP and what ever else you need to get through. You may just op to for “Allow Any” to turn off the Firewall. If you do that make sure you do not allow DHCP through or you will get into DHCP wars between the servers depending on the TTL.
See lessCloning Novell Partitions
If you plan to make a one by one copy of that drive, you can use Norton Ghost and make an Image disk to disk. Or you can use a Linux Live CD and use the dd command to create a one by one copy of the whole harddrive.
If you plan to make a one by one copy of that drive, you can use Norton Ghost and make an Image disk to disk.
See lessOr you can use a Linux Live CD and use the dd command to create a one by one copy of the whole harddrive.