I have an Excel 2013 spreadsheet with over 3,000 entries.  The spreadsheet has customer numbers and Company Names (see attached sample) - my original spreadsheet has many more columns but I tried to simplify for explanation purposes. On the sample I have attached there are five customer numbers (3, 4, 5, 6, 7) and only two company names.  I am trying to find a quick way to determine what customer numbers are listed with both companies.  So in my example, customer #4, #5 and #7 are the customers that are associated with both companies.  That is what I am trying to extract.  I don't need to know the customer numbers that are only associated with one company. I need to pull only the customer numbers that are listed for both companies.  Any help is appreciated.  Thank you.

i have this file  working  but need paste the data in destination

after click the button
need paste the data in destination
wktaSSS_v2--1-.xlsm

Windows 7 IE11 opens and closes automatically.  I went to the Action Center Problem Details and saw this message from 7/7/17:  

Description
The program IEXPLORE.EXE version 11.0.9600.18698 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: 2670
 Start Time: 01d2f744967e20af
 Termination Time: 0
 Application Path: C:\Program Files (x86)\Internet Explorer\IEXPLORE.EXE
 Report Id:

Can anyone help on how to get IE working again?

We're talking an ASUS net book (tablet  that can detach from small keyboard) Modal T100H Mobile Dock.

Somehow I have managed to turn on the number lock so that instead of a "j" I get a "4 or some such, and so on for the letter set that prints numbers when you set it to. Except that I did not do that intentionally.

There is NO number lock key on the keyboard.

In case you did not get that, let me repeat it....THERE IS NO NUMBER LOCK KEY ON THE KEYBOARD!

I say this only because I did some searches and found that as the answer.

So experts, what's the solution?

This procedure --which I attached to a command button-- isn't working.

I'm really trying to make it work with an IF Then Else to see if it can be done. (see attached workbook.

Private Sub cmdAdd_Click()
Dim rowcount As Double
Beginning:
rowcount = 9
If rowcount = Empty Then
    Cells(rowcount, 1).Value = frmEmployeeInfo.txtEmpName.Value
    Cells(rowcount, 2).Value = frmEmployeeInfo.lstEmpDepartment.Value
    Cells(rowcount, 3).Value = frmEmployeeInfo.txtEmpEarnings.Value
    
    Else
    rowcount = rowcount + 1
End If

End Sub

Select all Open in new window

forms-in-excel.xlsm

need go to the las record of data

but data will increase so it will change as time goes

in this case F1211
Gotolast.xlsx

I want to remove the #NUM! errors from my list, I've attempted to construct a IF(ISERROR) condition but have been unsuccessful. Any advice would be appreciated.

=INDEX($C$2:$AG$500,SMALL(IF(INDEX($B$2:$AG$500,,MATCH(K$505,$B$1:$AG$1,0))<>"",IF($B$2:$B$500=$B506,ROW($B$2:$AG$500)-ROW(I$2)+1)),1),MATCH(K$505,$C$1:$AG$1,0))

CLOCK NO      1      2      3      4      5      6      7
279639      B      B      #NUM!      A      A      A      A
416848      A      A      A      C      C      C      #NUM!
797413      A      A      #NUM!      C      C      C      C

Dear Experts,

I have a user which started to have an issue with opening ppt files this week over vpn.
The strange thing is it's only happening with ppt files, pptx are opening fine.
If I copy the ppt file from the Shared drive to the desktop it takes 3-4 Seconds to copy and around 10 seconds to open.
If I open the same ppt file directly from a network share it takes around 3-4 Minutes to open or Powerpoint is even crashing.
The same files are opening fast when on the Office network.
I'm running out of ideas what could be the issue.
I tried the following until now:

- repair office
- Adjust MTU of the Wifi adapter
- start Powerpoint in safe mode
- disable all Add-ins
- Add network share in the trust center to trusted locations (including subfolders)

It's still the same after all this.

the following is used:
- Windows 7 64 Bit
- Office 2013
- Cisco Anyconnect

Best Regards and many thanks in advance for any input,

Patrick

Hi,

We started to implementing Continuous Integration in our company and for one of our products, we implemented the gated check-in in the MAIN branch, this way it will only be committed to TFS if it'is successful. Whenever we got a build error we were used to connecting to the build server and try to build it manually for debugging process only.

In our last code change, we noted that the source that was copied into the build agent folder did not have our last changes in the src folder, even though the result in the bin folder was right.

One of our theories is that it will create a shelveset that contains a merge of latest TFS version and the latest checked in changes, and it will build in this context. It would explain the outdated src folder and the updated bin folder.

Is it the normal gated check-in behavior or is it a bug? How does it work in detail when interacting with the build agent?

Thanks in advance

Hello Everyone, Im looking to create an MSI file for citrix so i can deploy to multiple computers at once. i have downloaded a .exe to MSI converter and that did not work. ive also tried following the instructions on Citrix's website at the cmd prompt yet i get an error that citrixrecevier.exe is not a recognized as an internal or external command....  
is there anyway to convert or deploy to multiple computers without creating a GPO on the servers?
If possible i would like to use Desktop Authority from Dell or PDQ deploy.

Whenever i drag a formula in excel, I have to double click the cell for it to actually calculate correctly. For example if i drag a formula from one cell that's total was 12 all the cells will say 12 that i have dragged the formula to even though the answer should be 29, or whatever.  I was wondering if there was an easy fix because this can be tedious.

Sir I have given a omr based exam all information in omr fill completely but one point we not fill in omr sheet this is- total no of answer attempted by candidate ..so please tell me my omr sheet will be evaluated or not please sir reply

In an excel sheet I want to have scores added up by contestant - say in B1 is the persons name 'Billy Brown' and in C1 is 10.  So the formula has to cycle through the B and C column then add only the scores for that persons name.  It would be good if it could put the persons name in say D1:D5 and their total scores next to their names in E1:E5