Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

autofill-starts with numeral;dropdown;merged cells;

I have a spreadsheet that I have to use, (that was created by a CPA)
with a column that has a dropdown validated list. I would like for it to autofill when I start filling it in. He has somehow prevented me from doing this- the list for the dropdown is less that 20 codes and the list formatting is:
1102 - Personnel
I would like to type 1102 hit tabkey and have it pick that line from the list and auto fill- instead it tells me the error: the value you have entered is not valid User has restricted values that can be entered into this cell
And on top of it all, he has merged 6 or 7 cells together to create this location of where the list is to populate
is there any simple way to fix this that anyone could share? I lived with this the last whole fiscal year and would like to start out different this year for faster data entry. TX


Post your answer or comment

comments powered by Disqus
Hi

I tried with this formula for finding the values starting with "EXT" from the cell

=MID(B2,FIND("EXT",B2),FIND(";",B2,(FIND("EXT",B2))))

Its working fine when there is only one value starting with "EXT".

In case, we have multiple values starting with EXT in one cell For eg:
EXT-gen;rest;life;EXT-test

Its giving this output:
EXT-gen;

Required output:
EXT-gen;EXT-test

Can anyone help with this formula...

Hello,

I'm trying to create a spreadsheet that will have row 1 columns A-Infinity filled as follows:

Monday, 3/15/10 | Tuesday 3/16/10 | Wednesday, 3/17/10 | Thursday, 3/18/10 | Friday 3/19/10

This with each day of the week Mon-Fri with that date figured in a column of its own.

I am unable to find a way to make this autofill for each week to avoid having to manually do it.

Can anyone help?

I would like to show Mon-Fri and the numeric date for each day of the week and start with Mon-Fri the next week and so on to infinity.

Hey guys,

I bought the course and have learned a lot but I haven't learned enough yet that I can figure this one out. I've spent about a day and a half looking through the forums but I haven't found something that fits. If there is I apologize and ask that you please point me to it.

Here's what I'm looking for.

I need to calculate the percentage of cells in one column that have data in them compared to those that do not. This is easy enough to do by itself but here's where it gets tricky for me.

I need this percentage calculated only when cells in a different column contain data.

Here's the specifics. All of the row and column references are exactly what I'm looking to have in my worksheet.

If A5:A200 contain any value then I want to know the % of the cells in F5:F200 that have a value in them compared to the same number in F5:F200 that contain no value. I would like the answer to show up in B2.

Part of the issue is that cells A5:A200 already have a formula in them so I think that would count as a value. The one thing that might help is the fact that A5:A200 values that I'm looking for ALWAYS start with TN so that could be used as the search function.

The reason why I need to base it on a value in A5:A200 is that the sheet is blank until I enter data in the rows. I can't have the blank rows below the last data that I've entered on the sheet count towards the percentage that I'm looking for.

Basically it's a sheet that I enter installations and service calls on. The information always has a TN# associated with it. Which through a formula is automatically populated in the same row in the A column. I track the installation or service call and when it's completed I enter a completion date in the F column in the same row.

I am trying to be able to keep track of the percentage of jobs completed (completion date entered in column F) compared to incomplete (cells in column F that have no completion date) but it has to only look at rows that actually have information entered in them which I think should be done by column A.

column D5:D200 is where I enter the main information and there is no formula entered in the cells in column D so if it's easier to base it on that column then that's fine.

Sorry for the long post but I wanted to be as clear as possible.

Thanks in advance

Hi

I need to count cells in a column starting with certain characters. each
cell's data varies in length. I have tried with @countif( but does not work
if the cell contains other characters after the "prefix".
eg.

row 20 cell 5 apples
row 21 cell 5 apples red
row 22 cell 5 apples green
row 23 cell 5 plums green
row 23 cell 5 plums purple

totals required for apples = 3 (regardless of colour)
total required for plums = 2 (regardless of colour)

@countif(C20:c30,"plums") gives answer of 1 require answer of 2
@countif(C20:c30,"apples") gives answer of 1 require answer of 3

Thanking you in advance

Regards

Norman

--
Message posted via http://www.officekb.com

Hi,

I am having problems with row heights of merged cells. It works almost
perfect. The problem comes in when the text in the cell is two or three
lines. For instance if the merged cell initial width is 50 and initial
height is 13.5, n the text is about such that it fits in two lines i.e.

"asdfdsafasdfkjasdfjadsfsadfadsfdsafadsfdsafasdfsadf..." initially all
text not visible

After I run this function I see the text like this
"asdfdsafasdfkjasdfjadsfsadfadsfdsafadsfdsafasdfsadf
asfasdfasdfasdfasdfasdfasdfasdfasdfasdfadsfasd

"

This results in taking up more height for the row. As you can see, it
only needs about two rows to fit in text. Now I have sorta gotten close
to where the problem could be, it could be in the statement :
PossNewRowHeight = .RowHeight
So if I do PossNewRowHeight = .RowHeight -
curentRowHeight

The above appears expected, but it messes up the logic and the other
rows do not get merged right and seems like no formatting gets done.

Would someone please suggest where the problem could be?

Thank You

Adev111

here's the function I found from google groups

Sub AutoFitMergedCellRowHeight()
Dim CurrentRowHeight As Single, MergedCellRgWidth As Single
Dim CurrCell As Range
Dim ActiveCellWidth As Single, PossNewRowHeight As Single
If ActiveCell.MergeCells Then
With ActiveCell.MergeArea
If .Rows.Count = 1 And .WrapText = True Then
Application.ScreenUpdating = False
CurrentRowHeight = .RowHeight
ActiveCellWidth = ActiveCell.ColumnWidth
For Each CurrCell In Selection
MergedCellRgWidth = CurrCell.ColumnWidth +
MergedCellRgWidth
Next
.MergeCells = False
.Cells(1).ColumnWidth = MergedCellRgWidth
.EntireRow.AutoFit
PossNewRowHeight = .RowHeight
.Cells(1).ColumnWidth = ActiveCellWidth
.MergeCells = True
.RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _

CurrentRowHeight, PossNewRowHeight)
End If
End With
End If
End Sub

I orginally posted this inquiry in Excel General but now that the answer is clearly VBA programming I was hoping for some assistance from this room. The original post is

http://www.excelforum.com/excel-general/649936-word-wrap-in-merged-cells-adjusting-row-height.html

I am very novice in programing with VBA and I have been provided a macro that needs editing. It is very important to get the spacing correct on the sheet that I am working, and unfortunately there is no way to getting around using a merged cell. The problem:

I have a Merged cell that is using a concatenate formula and depending on the circumstances has the possibility to be anywhere from 1 to 7 lines long. Since the cell is a merged cell it will not autofit.

The solution that was provided to me was:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
Dim CurrentRowHeight As Single, MergedCellRgWidth As Single 
Dim CurrCell As Range 
Dim ActiveCellWidth As Single, PossNewRowHeight As Single 
If ActiveCell.MergeCells Then 
With ActiveCell.MergeArea 
If .Rows.Count = 1 And .WrapText = True Then 
Application.ScreenUpdating = False 
CurrentRowHeight = .RowHeight 
ActiveCellWidth = ActiveCell.ColumnWidth 
For Each CurrCell In Selection 
MergedCellRgWidth = CurrCell.ColumnWidth + MergedCellRgWidth 
Next 
.MergeCells = False 
.Cells(1).ColumnWidth = MergedCellRgWidth 
.EntireRow.AutoFit 
PossNewRowHeight = .RowHeight 
.Cells(1).ColumnWidth = ActiveCellWidth 
.MergeCells = True 
.RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _ 
CurrentRowHeight, PossNewRowHeight) 
End If 
End With 
End If 
End Sub
This solution is a good start but I have a problem that I beleive can be edited out of the program but I do not know where to start.

Problem 1:
My merged cell has the possibility to be between 1 and 7 lines.
If the Merged Cell is:

1 Line, Macro Result = 15 point height (correct)
2 Lines, Macro Result = 45 point height (incorrect should be 30)
3 Lines, Macro Result = 75 point height (incorrect should be 45)
4 Lines, Macro Result = 75 point height (incorrect should be 60)
5 Lines, Macro Result = 105 point height (incorrect should be 75)
6 Lines, Macro Result = 135 point height (incorrect should be 90)
7 Lines, Macro Result = 150 point height (incorrect should be 105)

Problem 2: (minor cosmetic)
When the input data goes from large to small the cell height does not reduce in size.

Any assistance in editing this macro would be greatly appreciated

Hi

I need to count cells in a column starting with certain characters. each
cell's data varies in length. I have tried with @countif( but does not work
if the cell contains other characters after the "prefix".
eg.

row 20 cell 5 apples
row 21 cell 5 apples red
row 22 cell 5 apples green
row 23 cell 5 plums green
row 23 cell 5 plums purple

totals required for apples = 3 (regardless of colour)
total required for plums = 2 (regardless of colour)

@countif(C20:c30,"plums") gives answer of 1 require answer of 2
@countif(C20:c30,"apples") gives answer of 1 require answer of 3

Thanking you in advance

Regards

Norman

--
Message posted via http://www.officekb.com

I have a sheet and its organized like so:
Row Column
1 A - K: each cell has seperate info
2 B: has info
3 B: has info
2-5 C-K: merged cell with text info
6 : blank

Then the pattern repeats itself. What I want to do is on workbook 2,
look up in workbook 1 column J for the info in 1J and if it says X,
copy 1-6 onto work book 2. If it says Y skip it.

Is this possible with the big merged cell?

--
foxspirit
------------------------------------------------------------------------
foxspirit's Profile: http://www.excelforum.com/member.php...o&userid=31264
View this thread: http://www.excelforum.com/showthread...hreadid=509405

I created a spreadsheet with a few merged cells. i would like to sort them,
by any colum, but i get an error saying operation requires merged cells to be
identically sized. What should i do so i can sort how i want...

I have a sheet and its organized like so:
Row Column
1 A - K: each cell has seperate info
2 B: has info
3 B: has info
2-5 C-K: merged cell with text info
6 : blank

Then the pattern repeats itself. What I want to do is on workbook 2, look up in workbook 1 column J for the info in 1J and if it says X, copy 1-6 onto work book 2. If it says Y skip it.

Is this possible with the big merged cell?

I have a column that includes a numer of merged cells. The COUNT functions
are not recognizing the merge, however, and are returning the number of
pre-merged cells that are not blank, rather than the number of merged cells
that are not blank.

I am using Excel 2003 SP2

Thanks.

I've got formula in 4 cells (fourth cell is the end result I need), that I've
tried to combine into one long formula in one end result cell, but I can't
get it to work. I'm still learning formula aughh.
If someone can combine them for me that would be awsome because I'm starting
to go cross eyed!

Cell A1 - is customer take a ticket number being served i.e. =J50

Cell B1 - is customer take a ticket number being issued i.e. =A10

Cell C1 =100*(CODE(UPPER(LEFT(A1,1)))-65)+VALUE(RIGHT(A1,2))
"FORMULA TO CONVERT CELL A1 TO A NUMBER VALUE" i.e. =950

Cell D1 =100*(CODE(UPPER(LEFT(B1,1)))-65)+VALUE(RIGHT(B1,2))
"FORMULA TO CONVERT CELL B1 TO A NUMBER VALUE" i.e. =10

Cell F1 =MOD(D1-C1, G1)
"FORMULA TO SHOW THE NUMBER OF CUSTOMER NUMBERS WAITING TO BE SERVED - BASED
ON NUMBER OF TICKETS OUT AND HOW HIGH IN THE ALPHABET THE ROLL OF NUMBERS GO
BEFORE STARTING AGAIN AT #A00." i.e. =60

Cell G1 =ABS(((CODE(UPPER(LEFT(H1,1)))-65) - (CODE(UPPER(LEFT(I1,1)))-65)
))* 100 + 100
"FORMULA TO COUNT HOW MANY TICKETS ARE ISSUED BEFORE STARTING TICKET #A00 IS
ISSUED AGAIN." i.e. =1000

Cell H - is the starting letter of the alphabet the number rolls start with.
i.e. =A

Cell I - is the ending letter of the alphabet the number rolls end with.
i.e. =J

I'm trying to eliminate Cells C1, D1, G1 by combining their formula into the
formula in Cell F1.

Sadly I've to cope with those crappy merged cells, no way around it.
So I'm looking for a way to determine a group of merged cells.

I can determine whether a cell is merged via MergeCells and whatnot, that's all nice and shiney, but is there any way to tell with what cells that particular cell is merged?
Say, A1:A5 are merged, how can I determine this? MergeCells would return 5 seperate cells...

Hi,

I posted my initial question about sorting merged cells here (http://www.ozgrid.com/forum/showthread.php?t=149511) and had an additional question about the sort which in turn brought up further issues. Maybe I'm going about this all wrong but I really hate to go all the way back to "start".

I'm using Excel 2003 in Windows XP SB3 environment.

Firstly, thank you a million times to shg and PCI for their time and effort spent in crafting what looked like an excellent response to my question. I have a workbook that is going to be used to record man days for a variety of projects. Each superintendent will be responsible for their own project record. The issue was how to sort rows with merged cells - please refer to the attached document - so that they are in numeric order.

I started with some code written by Aaron Blood in 2005 and shg updated it to fit my requirements. However I didn't create the necessary format tab that the code called for before I submitted the workbook. I created it after the fact and based it on Aaron Blood example. Problem came about when I was testing it and noticed that it still wasn't exactly right. It should sort by the job number and if there were blank cells, leave them blank at the end of the report. However, for some reason, it either repeated the job number and job name or it would put "Job Number" and "Job Name" into ALL the cells in column A & B.

Now after going carefully through the steps I noticed another flaw in my thinking. I was focused on 1 quarter only. I need to be able to have data flow from 1 quarter to the next if the jobs are active and then total on the "Totals 2011" tab. I can give my guys a quarter at a time and manually put the information on the "Totals 2011" tab or, if it's easier, try to automate it.

I am open for suggestions from the experts. When I got into this project it was easy enough to accomplish at my level. With the other added expectations, it is way beyond me. Is there a way to alter the existing code (see below) to do what we need? I am going to be taking a VBA class next semester but I need this as soon as possible.


	VB:
	
 
Sub Sorted_Report() 
    Dim r           As Range 
    Dim i           As Long 
     
    Set r = Intersect(Range("A3").CurrentRegion, Range("3:" & Rows.Count)) 
     
    With r 
        .UnMerge 
         
        On Error Resume Next 
        .Resize(.Rows.Count, 1).Offset(, 0).SpecialCells(xlBlanks).Formula = "=R[-1]C" 
        .Resize(.Rows.Count, 1).Offset(, 1).SpecialCells(xlBlanks).Formula = "=R[-1]C" 
        On Error Goto 0 
        .Columns("A:B").Value = .Columns("A:B").Value 
         
        .Sort Key1:=.Cells(1, 1), Order1:=xlAscending, DataOption1:=xlSortNormal, _ 
        Key2:=.Cells(1, 2), Order2:=xlAscending, DataOption2:=xlSortNormal, _ 
        Header:=xlNo 
        Range("VBA_RecFmt").Copy 
        .PasteSpecial Paste:=xlPasteFormats 
         
        Application.DisplayAlerts = False 
         
        For i = 1 To r.Rows.Count Step 3 
            r(i, 1).Resize(3).Merge 
            r(i, 2).Resize(3).Merge 
        Next i 
         
        Application.DisplayAlerts = True 
    End With 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Thank you again for any and all help! I hope to be able to do this myself soon and will pay this forward when I am able.

~ Brenda ~

I am using Excel 2003. I would like to add some functionality to a spreadsheet I made that will allow rows to automatically be inserted as needed instead of just adding a bunch at the beginning and hoping it will be enough. I have searched around and found some useful information to get me started, but I am having a couple of problems.

First, I have tried using the "List" feature, but it does not work with merged cells. I found some code that does work (sort of) with merged cells but it only works after you press "tab" and the active cell stays on the same row. If you press "enter", a row is inserted but the format does not copy properly. I could fix this so enter would work, but then tab won't and ideally I want to make this as "dummy-proof" as possible. I think I know what needs to be done, just not how as I am not familiar with this VBA stuff.

Basically, I need to keep track of what row I start in, and then where the active cell is relative to it after a row is inserted, and based on that copy the format to the right place. Here is the code I have so far:


	VB:
	
 Excel.Range) 
    If Target.Column  2 Or Target.Count  1 Then Exit Sub 
    If Target.Row = Cells(65536, 2).End(xlUp).Row Then _ 
    Target.Offset(1, 0).EntireRow.Insert 
     
     '   Copy  formatting from the current row to the row below
    ActiveCell.Offset(0, 0).EntireRow.Copy 
    ActiveCell.Offset(1, 0).EntireRow.PasteSpecial xlPasteFormats 
    Application.CutCopyMode = False 
    ActiveCell.Offset(-1, 3).Select 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The other thing I noticed is that when I tab, that active cell ends up in the right place, but when you press enter, it shifts down one row (normal) but then to the right one row as well. It would be nice if it ended up where you would normally expect it regardless if you press enter or tab.

Anyway, am I on the right track or is there a way easier way to do this? Thanks in advance for your time!!

In the area A23:G30, each row contains merged cells of column B, C, D, E
and F apart from each other row in the area. I get a "This operation
requires that merged cells to be identically sized" error when running
this macro. Even using the Data/Sort from the File menu gives me this error.

How would I sort an area containing rows with merged cells? Also, the
cells must remain (or return to being) merged after this operation.

I appreciate the previous help concerning clearing the contents from
merged cells using ActiveCell relative references. Unfortunately, my
email/newsgroup client, for whatever reason, will not display that
previously posted newsgroup thread, so I must start another. Will fix.

Also, the Header parameter line is not broken in my code but just
displays that way in this message formatting.

'''''''''''''''''''''''''''''''''''''''''''''''''' '
Sub SortData()

Application.ScreenUpdating = False

Range("A23:G30").Select
Selection.Sort _
Key1:=Range("A23"), Order1:=xlAscending, _
Key2:=Range("F23"), Order2:=xlAscending, _
Header:=No, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom

ActiveCell.Select

Application.ScreenUpdating = True

End Sub

''''''''''''''''''''''''''''''''''''''''''''''''''

Hi I'm working on this timeline that is suppose to show the start and the end date for a certain number of tasks.Please see pics for a better idea. The dates are shown week by week (mondays) and they will change respecting to the program that they are related. So what I want to have is a timeline that will autopopulate the dates respecting to that first date. What i did was to relate the first cell in each row (year, month, day) with the start date that is on a separate sheet. Then I sum 7 days all the way to the right and for a row im displaying the years, for the other one the months and for the other one the days.

The problem is that to make it look better I want to merge all the cells that contain the same month or the same year. when i do this by using the merge and center button the sequence gets messed up because it is only using the value in the first merged cell and deleting the others.

Is there a way in which i can do al this automatically and not having the sequence problem? Or any suggestion of a simpler way of doing this?

thanks for the help!

Hi there,

I need some code to add to my macro. The code needs to cut customer names starting with "A" or a numeral, from sheet 1, column C.

The entire row needs to be pasted into sheet 2, starting at cell A2

Can anyone help please?

Thank you.

I am using the following functions to determine the highest row and column that contain data:

Public Function LastColumn(ws As Worksheet) As Long

Dim LColumn As Long
    
    If Application.CountA(ws.Cells) > 0 Then
        
        LColumn = ws.Cells.Find(What:="*", _
                                after:=ws.Range("A1"), _
                                SearchOrder:=xlByColumns, _
                                SearchDirection:=xlPrevious).Column
    Else
    
        LColumn = 0
    
    End If
    
    
    LastColumn = LColumn
    

End Function
Public Function LastRow(ws As Worksheet) As Long

Dim lrow As Long
    
    If Application.CountA(ws.Cells) > 0 Then
        
        lrow = ws.Cells.Find(What:="*", _
                             after:=ws.Range("A1"), _
                             SearchOrder:=xlByRows, _
                             SearchDirection:=xlPrevious).Row
    Else
    
        lrow = 0
    
    End If
    
    LastRow = lrow

End Function
I've just inherited a spreadsheet which contains merged cells and it would seem these merged cells cause the above functions to fail, on the lines in bold, with a Run-time error '91' "Object variable or with block variable not set".

The real problem is the spreadsheet, I've just started a new job and the spreadsheet I've inherited is horrible, 90+ sheets filled with all sorts of crap. However redoing the spreadsheet in a sane fashion isn't really an option at the moment and I need to get on with identifying all the cells with errors and fixing them so does anyone know of a way in which to deal with merged cells when trying to determine the highest column and highest row to contain data?

In the area A23:G30, each row contains merged cells of column B, C, D, E
and F apart from each other row in the area. I get a "This operation
requires that merged cells to be identically sized" error when running
this macro. Even using the Data/Sort from the File menu gives me this error.

How would I sort an area containing rows with merged cells? Also, the
cells must remain (or return to being) merged after this operation.

I appreciate the previous help concerning clearing the contents from
merged cells using ActiveCell relative references. Unfortunately, my
email/newsgroup client, for whatever reason, will not display that
previously posted newsgroup thread, so I must start another. Will fix.

Also, the Header parameter line is not broken in my code but just
displays that way in this message formatting.

'''''''''''''''''''''''''''''''''''''''''''''''''''
Sub SortData()

Application.ScreenUpdating = False

Range("A23:G30").Select
Selection.Sort _
Key1:=Range("A23"), Order1:=xlAscending, _
Key2:=Range("F23"), Order2:=xlAscending, _
Header:=No, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom

ActiveCell.Select

Application.ScreenUpdating = True

End Sub

''''''''''''''''''''''''''''''''''''''''''''''''''

I don't know if this is possible but I have to sort a spreadsheet with new information every week and all the cells are related to each other and some of them are merged.here is the layout that repeats it self for 99 different groups of information that I want to keep together. How can I sort and be able to keep the merged cells intact? cell Layout.pdf

I have columns A through I that start at row 4 with varing merged cells. So the first merged row might be 3 rows deep or 5 or maybe just one. I would like to take each merged row and shift the values to one row so I can sort the spreadsheet.

Hi,

I am sure this is simple for someone who knows much more than me on vba but I need a code to merge cells together.

I have a 4 x 2 block of cells to merge into one. A1:D2, E1:H2 and I1:L2 and then down the worksheet ie A3:D4, E3:H4 etc. All I want to do is end up with these cells merged into 4x2 blocks.

PS this is to allow a copy past into some stupid spreadsheet someone else has created with a load of merged cells!

I have some code to insert 3 columns after each column and 1 row after every row but if someone can add this to the start to make 1 macro that would be great

Thanks
Pete

Hi all, I have been using the following code to successfuly auto increase row height in (I know I know) merged cells. I have discovered that there is a maximum row height the cell wil grow, it seems to be 91.8. If double click the cell it shows the full contents, Ive decreased the font size, which helps, but but otherwise all I can view is the amont a cell 91.8 high will show.
Any ideas?

	VB:
	
 redomergerow() 
     '
     '
    Dim CurrentRowHeight As Single, MergedCellRgWidth As Single 
    Dim CurrCell As Range 
    Dim ActiveCellWidth As Single, PossNewRowHeight As Single 
    If ActiveCell.MergeCells Then 
        With ActiveCell.MergeArea 
            If .Rows.Count = 1 And .WrapText = True Then 
                Application.ScreenUpdating = False 
                CurrentRowHeight = .RowHeight 
                ActiveCellWidth = ActiveCell.ColumnWidth 
                For Each CurrCell In Selection 
                    MergedCellRgWidth = CurrCell.ColumnWidth + _ 
                    MergedCellRgWidth 
                Next 
                .MergeCells = False 
                .Cells(1).ColumnWidth = MergedCellRgWidth 
                .EntireRow.AutoFit 
                PossNewRowHeight = .RowHeight 
                .Cells(1).ColumnWidth = ActiveCellWidth 
                .MergeCells = True 
                .RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _ 
                CurrentRowHeight, PossNewRowHeight) 
                Selection.Locked = False 
                Selection.FormulaHidden = False 
            End If 
        End With 
    End If 
     '
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines



No luck finding an answer? You could always try Google.