Functions
in [Excel]
|
validate date entered i want to validate the date entered as a Sunday - if the user enters a date that is not a Sunday, the user cannot continue. cell A1 - user enters the date (the cell is formatted as custom yyyy-mm-dd) cell A2 - text(a1,"dddd") returns back the day of the week is there a way to validate the value as a Sunday dat... 31 Oct 2009 17:43
Check if time falls between two times? Hi all, I'm having a little trouble with this formula: (D1 is formatted =Now()) =IF(OR(D1>TIMEVALUE("07:00"),D1<TIMEVALUE("19:00")),"Days","Nights") i also tried: =IF(OR(TEXT(D2,"hh:mm")>"07:00",TEXT(D2,"hh:mm")<"19:00"),"Days","Nights") And =IF(OR(D1>--"07:00",D1<--"19:00"),"Days","Nights") But the result is always "... 21 Oct 2009 10:24
Increment invoice number Hi I am looking for a formula or a way to increment my invoice number by 1 everytime my template is opened. Is there a way of doing this? Thankyou ... 21 Oct 2009 08:12
Counting coloured cells Hi I've used the following code to count the number of cells in a range that are filled yellow, using the basic funtion '=CountYellow(A1:A99)' Function CountYellow(MyRange As Range) Dim iCount As Integer Application.Volatile iCount = 0 For Each cell In MyRange If cell.Interior.ColorIndex = 6 Then iCount = ... 13 Oct 2009 09:57
Automatic Update in Multiple Worksheets I am trying to setup worksheets that stem off of one master worksheet to automatically update data on all worksheets when entered into the master worksheet. I don't want to just input =sheet1!A1 because then it returns null values which mess with another sheet and my charts. Basically I want a way to update wit... 9 Oct 2009 18:16
IF and VLOOKUP formula combined together {=IF(K8=AA11:AA21,VLOOKUP(K8,'Regular Assessment Table'! I2:J12,2,FALSE))} The above formula is looking up a K8 text content and returning a vlookup value from a table. Part of the text I enter is "104(a) Citation" and the formula return the correct value. But when I enter "104(d)(1) Citation" the formula retu... 15 Oct 2009 09:25
Can I SUM column C IF Column A=X AND Column D=Y? Hi, This formula works great whenever there are values in the columns, but when the columns contain formulas I get #N/A. Do you know how to go about this? Seb "RagDyer" wrote: You're welcome, and thank you for the feed-back. -- Regards, RD -------------------------------------------... 7 Nov 2009 15:11
Finding 2 different letters in a range I have been using the following formula to find the total occurrences of the letter "g" in a range =COUNTIF(B2:B39,"g") I now need to also look for the letter "a" to give a return of them both combined. How do I achieve this please? ... 8 Oct 2009 17:59
existing connections I am trying to pull in the stock quotes into a blank worksheet and keep getting the following error: "Unable to open http://moneycentral.msn.com/investor/external/excel/quotes.asp:SYMBOL=CAT+CSCO+KSS+MGM+S+ORCL+PG+WMT. Cannot locate the Internet server or proxy server." Can anyone help me with this? I am worki... 30 Sep 2009 15:49 |