subject

  1. X

    Sumproduct combined with a condition of subject to maximum

    Suppose I have the following data <tbody> Alex 01/07/18 10000 Mike 09/07/18 20000 Alex 13/07/18 35000 Jason 13/11/18 26000 </tbody> Now, I'd like to find the maximum commission earned by a person for a month subject to the condition that for each transaction max commission earned...
  2. sharky12345

    Replace subject in Outlook message

    I'm using this to replace the subject in an outlook message; Item.Subject = Replace(Item.Subject, " - IMPORTED", "") Can someone show me how to take it a step further and remove not only the above but any text after 'IMPORTED'?
  3. J

    Embarking on an idea out of my depth....

    I’m trying to create a ‘test’ function within excel where I can enter subject headings from an email and then they’ll either be approved or rejected based on various criteria. Here are the criteria; - Text length between 18-25 characters - Any words on a ‘bad’ list will flag...
  4. P

    Possible combinations Or Pivot student exam program

    Lets say i have a data set with five columns with subject name for every student and need to create a program for exams. Mark A B C F Paul K C L A Jane B F D A George M N C E I need to find the best way to combine all letters so that no student has two exams the same...
  5. A

    Guys I need help with a VBA code at my work

    Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example
  6. J

    Using counta and countif

    Hi, I have a spreadsheet and on one of the sheets named 'data' I have names (column C), areas (column E) and categories from row F1:P1. For easy reference I will call the areas 'class' and categories 'subjects'. It looks something like below...
  7. J

    Index match min if

    <tbody>#CACACA[/URL] "] A B C #CACACA[/URL] , align: center"]1 #C0C0C0[/URL] , align: center"]ID #C0C0C0[/URL] "]Subject #C0C0C0[/URL] , align: center"]score #CACACA[/URL] , align: center"]2 1000 Math 80 #CACACA[/URL] , align: center"]3 1001 English 45 #CACACA[/URL] , align: center"]4...
  8. M

    Adding cells : If one cell is zero, how do I return zero for the whole formula?

    Hi everyone, I promise I have searched the boards, but I just can't figure out how to solve my problem :eeek: It looks like I could use SUMIF, but I just can't get my head around how to do it. Basically I want to sum cells, not the same range, different ones within a column. The difficulty...
  9. apgmin

    drop down multiple

    Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...
  10. G

    Using Wildcards in an Index Match Formula

    I have an existing Index Match formula which has been working fine when searching for a single string of text. What I'm trying to do now is to get a wildcard introduced so that if the course is called 'Subject A', it would also select the result if it's 'Subject A - North', 'Subject A - South'...
  11. C

    Change Outlook Subject with VBA

    Hi, I'm trying to create a template so that I can have VBA prompt me to change items in the subject. I've got a template email with the subject line that should be Project / GC/Client, and in the template I've written that as #0# / #1 #. So far, I'm at the below, but it's erroring. Anyone...
  12. S

    Command Button -

    I'm using a command button to automatically email a document. I have the recipient (srecipient), subject line (subject) and the body (sbody) text setup - I want to add additional recipient as a "CC". Any help on this would be appreciated.
  13. M

    Conditional Formatting Based on Selected Drop-Down

    I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an...
  14. S

    VBA code to Email excel sheets as an attachment to different people

    Hi everyone I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and...
  15. D

    Filter by multiple subjects in single cell

    Hi Guys, Apologies in advance if my post is not formatted correctly as this is my first question - this is a simple question that seems to have a complicated solution. In my spreadsheet I have 1540 book titles for each book title I have multiple subjects, e.g animals, children etc. I want...
  16. 1

    A table of multiple values error

    Hi, this was working last week, now appear to be causing an error. I have 2 tables, one is called inbox and one is sent items. inbox has from, subject, cc, received time, powerapps id as standard sent items has the same plus some formula. Original Subject = if(left('Sent...
  17. F

    If/Find/Search??

    I'm not really sure how to do this or even if there is a way it can be done (but I'm really hoping it can). I need to find the days when a specific subject is taught. The subject name will always contain the characters 11a/En which will be followed by 1, 2, 3, 4 etc. At the moment my table...
  18. M

    Enter Email Hyperlink into cell

    I have a drop down where the user can select a name form the list which runs an Access query to return an email address for the selected person. I need the email address to be shown as a clickable hyperlink to open a new email and to be entered via VBA code which works on the Worksheet_Change...
  19. R

    Adjust "time" column when modifying row

    Hi everyone, Is there a forumla to automatically adjust the "time" in a column when any specific row is modified? For example: <tbody> Time Subject 7:00 am 7:30 am 8:00 am 8:15 am 9:00 am </tbody> If I were to modify "7:00 am" by 15 minutes to "7:15 am", I would want all the...
  20. R

    Need help - Vba to save file from Outlook

    Hi all, I need some assistance to create a macro for saving excel files from Outlook. 1. I will receive n number of excel files from outlook with same subject name. Example - "Tracking" is the subject name. 2. I need to open and consolidate those files in a single excel and save in my local...

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
Back
Top