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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top