communication

  1. E

    Latest Date

    Good evening all, I am trying to identify what the last communications are from a large range/list of data All I need is "Latest Communication" if the date from C12:F12:10003 and job from F12:F10003 is the last entered or if the only one entered Each job may have been communicated more than...
  2. L

    Help with unique value

    <tbody> Employee# ColumnA ColumnB 14900 support 14900 communication 14900 communication 15038 support 15038 communication 15039 support 15062 support 15062 support 15062 communication </tbody> I need help creating a formula that will get the unique value of employees...
  3. L

    Unique values with two criteria in one column

    Hi, I really need your help! I'm trying to count the unique values in column A that meet two criteria that are in column K. I have over 673 employees that did a communication or support. I want a number that counts the employees that did a communication and support. Column A- employee # Column...
  4. D

    rs 232 communication

    Dear, i hope someone can help me, i'm looking for a few days already to make with vba from excel to make a serial communication and nothing seems to work. I googled already everything i guess :(, What i need is a rs232 communication on com port 1 first to send the command "WT" then i should see...
  5. I

    Modify formula in Column E to exclude recurring customer names in column A.

    Hi Everone, I have following formula in E2 =COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2,$D$2:$D2,D2,$C$2:$C2,C2) and its giving me following output. I need to count unique customers in given criteria. Right Most column is my desired output. <colgroup><col><col><col><col><col><col></colgroup><tbody>...
  6. C

    Automate Document Classification or Email Classification via VBA - such as TITUS

    Hi, I have been searching for this for a long time, but no satisfactory solution. I have a VBA based macro that filters, generates excel workbooks, saves in a specific path with designated name, protects it with designated password, send via email to designated recipients. Its a loop - multiple...
  7. M

    VBA assistance request - trigger event on one workbook based on another workbook opening

    Hello, I am trying to come up with a macro that will make a change to one workbook based on another workbook opening. basically something to the extent of this: If workbook 'Master' opens, then change the color of cell A1 on 'sheet1' in workbook 'Tables'. The scope of this project is as...
  8. R

    Communication between sheets

    Hello This is Rohit... I have a project in my college in which i need to do the following. Please help :) I have a task in which I need to communicate between the sheets.. I have a unique ID in each worksheet through which I can identify which record to be edited in the other worksheet... So I...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top