Free Microsoft Excel 2013 Quick Reference

What does the exclamation point (!) stand for in a math equation .

In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!


In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!

In excel, what does the esclemation point (!) in a function mean?

Hello everyone,
does anybody know what does SINGLE QUOTE mean before value in a cell?
I have a function VLOOKUP that does NOT work without a SINGLE QUOTE before value in a cell that is searched.
Surotkin

I am preparing a table with values and percentages but in some areas (where
I'm doing a % calculation) a small green tag appears in the top left of the
cell with an exclamation mark. It suggests an error but the calculation is
right. What does the green tag mean and how do I get rid of it?

What are the Default {RGB} colors for graphs in Excel 2011?

I don't want an approximation. I want to match what is has used in some of the automatically generated graphs elsewhere.

whats the keyboard short cut for inserting a row in Excel , deleting a row

What does the -- in a Sumproduct Formula Mean?

I have seen it around but I can't seem to find exactly what it does or what it mean?

Thanks,

Mark

Hi All,

A long time back, with all your help I managed to get the below code working:

What does the current code do?
It searches a predefined folder for all files of a chosen file extension and lists them in column A at Time T=0. It then repeats the process leaving a gap of one row before re-lisiting the file names in the same folder again. This repetition is defined for every xxx sections up to yyy hours. At current for each block of file names found it lists the date and time found in columns B & C respectively on the first Row of the Search block.

Additions I would like to have in the Code
I would like the date and time to be listed along side every file name found for a given Time, not just the first of the file names.
I would also like to introduce the File Size of each of the file names found in Column D of the spreadsheet.

The Starting Code
Sub Timer()

    Static FunctionOn   As Boolean
    Static StartTime    As Date

    Dim Timer1          As Date

    If FunctionOn = False Then
        FunctionOn = True
        StartTime = Now() 'If Not defined
    End If

    Timer1 = Now + TimeValue("00:00:30") 'Every 30 seconds

    If Now() - StartTime > TimeValue("03:00:00") Then '03 Hours
          FunctionOn = False
          Debug.Print "Stopped"
    Else
          Extension = ""
'         Folder to look in.
          Folder = "OddjobGCreactiveCRE_10_387HM8.6"
          First = True
          RowCount = Range("A" & Rows.Count - 18).End(xlUp).Row + 2
                    Range("B" & RowCount).Value = Format(Now(), "dd-mm-yy")
                    Range("C" & RowCount).Value = Format(Now(), "hh:mm:ss")


          Do
              If First = True Then
                    FName = Dir(Folder & "" & Extension)
                    
                    First = False
              Else
                      FName = Dir()
              End If

              If FName <> "" Then
                  Range("A" & RowCount) = FName
                  RowCount = RowCount + 1
              End If

          Loop While FName <> ""

        Debug.Print "Time to go: " & _
                     Format(StartTime + TimeValue("01:10:00") - Now(), "hh:mm:ss")

        Application.OnTime Timer1, "Timer"

  End If

End Sub
The point of the spreadsheet is to gauge a Run process of a job I have running on my machine. I hope to do this by looking at the size of certain files with respect to time.

Any help would be appreciated.
Many Thanks, Mark

What does the 22 mean in the equation: =ROUND((P4+Q4))/9,22)

This is a really hard thing to do a search on, so I'm posting it here
to hopefully be enlightened.

1) What does the double dash "--" do in a function?
2) Specifically, what does it do in this function:
=OFFSET(Y!$B$2,,,SUMPRODUCT(--(Y!$B$2:$B$2000<>"")))

3) Final and related question, I want to have a drop down menu where
the options change based on the field to the left of the menu.
Date Name Account #
7/26/06 Joe 123456
7/26/06 Dan 654321
7/30/06 Joe 987654

I would like to have the account number pull from a long list of
account numbers like this...
Joe 123456
Joe 987654
Dan 654321
Dan 456789
Joe 555555

and have the drop down menu give me the option...
Row1 7/26/06 Joe (123465 / 987654 / 555555)
Row2 7/26/06 Dan (654321 / 456789)
Row3 7/30/06 Joe (123465 / 987654 / 555555)

so I can select which account number I want to use.

Any ideas?

What does the $ symbol mean in a formula?

example:
=G8*($A$14*2)*100
thanx

I have been trying to find an answer to this question, but have not been able to find an answer.

In relations to the SUMPRODUCT formula, what does the "--" notation do, and when should it be used. I have actually recevied help from people in the forum, and have that used in several spreadsheets, but I can't seem to find out more about it and when to use it. If anyone has any answers or direction I would really appreciate it. Thanks.

Claymationator

Excel 2003 - SP2 - MS Office Professional

Hi,

What does the "--" operator mean in the above worksheet equation?

Thanks.

Hi sometimes when computing my results i get a number that looks like
"3.123423e-007" in my cell.
what does the "e-007" mean?

in the formulae in excel, what does the "!" mean? and also, what doesthe $ mean?

I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?

if I have a formula like this

=index(A1:C20,match(D12,A1:A20,0),2)

What does the 0 (zero) after the A1:A20, (this zero) represent.

I know the 2 is what column to get the corresponding data.

Thanks for anyone's time and help.

Josh

Hey All,

I am a newbie here, but am not new to VBA. I am trying to complete a large application that I wrote using Excel and VBA for work, but I am stuck on one stupid little thing.

My problem is that I need to be able to determine the number of used rows in a WorkSheet (i.e. rows that contain at least one cell of data). Logically, I thought that the following line of code would get me this result:

	VB:
	
 
dblNumUsedRows = ActiveSheet.UsedRange.Rows.Count 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
However, this code does not work for me. I have 406 rows containing data on the active sheet, but this code is returning dblNumUsedRows = 12605.

Weird!

Can anyone help me out? I would greatly appreciate it!

Thanks!
Bryan

I have a large amount of text divided into one word per cell.
I've been trying to figure out a formula that I could use to find the top 10 most frequently occurring words in the range (in order).
Just to complicate things a little more, I'd like to be able to list the top 10 most frequently occurring one letter words, then two letter words, etc. in the range.

So far, I've come up with a formula that will give me the most frequently occurring word in a column of data, but I don't know how to find the second through tenth most frequent. I also don't know how to find only those words of length one, two, three, etc.

This is what I have thus far:
{=Index(range,Match(Max(Countif(range,range),Countif(range,range),0))}

Any idea how to add the extra details that my function doesn't account for?

I recorded a macro while adding a shape (rectangle) to an Excel chart:

Sub box2()
'
' box2 Macro
' Macro recorded 1/8/2006 by mk2968
'

'
ActiveChart.Shapes.AddShape(msoShapeRectangle, 13.5, 103#, 59.5, 43#). _
Select
ActiveChart.ChartArea.Select
ActiveChart.Shapes("Rectangle 16").Select
Selection.ShapeRange.ScaleHeight 1#, msoFalse, msoScaleFromBottomRight
ActiveChart.ChartArea.Select
End Sub

What do the '#' characters indicate? I can't find in the documention. Thanks.

I found this formula, which was posted in 2004.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

I wonder what does the cell A1 stand for? I removed it and it works
also ..

Matt

Can someone tell me what the mamimum number of sheets you can have in a
workbook? (2003 onwards)

Hello everyone. What does the
mean, and how do I get a cell to do that when I am recording a macro? For example, I want the cell A1 to say 
	

	
, how do I do that?

What is the Status Bar used for?