Free Microsoft Excel 2013 Quick Reference

In Statistics or Math, does anyone know what the "!" (exclamation point)

stands for? Please HELP. Thank you!

stands for? Please HELP. Thank you!

- What does the exclamation point (!) stand for in a math equation .
- In excel, what does the esclemation point (!) in a function mean?
- What does SINGLE QUOTE mean before value in a cell?
- What does the green tag in the top left of a cell mean?
- What are the Default {RGB} colors for graphs in Excel 2011?
- Whats the keyboard short cut for inserting a row in Excel
- What does the -- in a Sumproduct Formula Mean?
- Add File Sizes for Files Found in a Specified Folder
- What does the 22 mean in the equation: =ROUND((P4+Q4))/9,22)
- What does the double dash or "--" do when using it in a function? (and other questions)
- What does the $ symbol mean in a formula?
- Question about SUMPRODUCT - What does the "--" do?
- =SUMPRODUCT(--(TRIM(A1:A10)"")), what does the "--" mean?
- What does the "e" value mean?
- What does the ! mean?
- Display a digit before or after the decimal point in another cell
- Formula question-What does the 0 (zero) after the A1:A20 represent.
- Determining the number of Used Rows in a WorkSheet . . .
- Counting the most frequently occurring word in a range
- What does the '#' character mean when appended to a number?
- Question about filename formula ..
- What is the Maximum amount of sheets in a workbook?
- Why does the recorder select and not activate a cell
- What is the Status Bar used for

stands for? Please HELP. Thank you!

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'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?

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

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

Thanks,

Mark

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 SubThe 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

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?

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

"3.123423e-007" in my cell.

what does the "e-007" mean?

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?

=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

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: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.dblNumUsedRows = ActiveSheet.UsedRange.Rows.CountIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Weird!

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

Thanks!

Bryan

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?

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.

=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)

workbook? (2003 onwards)

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?