thread

  1. J

    Split function placement

    Hello, I am currently using a VBA code which extracts emails from outlook. I am attempting to use the split function in order to separate the body of the email using a colon as a delimiter. I am extremely new to VBA only learning what I can from forums and Google searches and one thing I've yet...
  2. C

    Formula help, several steps

    Hi, Asked for help regarding below in a different thread but since it evolved to be very disconnected from the subject/title I am reposting it as a separate thread: Please see picture, https://imgur.com/28MVScU I want the formula to do the following: Divide the costs in col B with the number...
  3. J

    Question About Posting Questions Posted on Other Forums

    Hi everyone, can i post a thread present in another forum? jc
  4. P

    Pull data from cell based on max value against that data

    Hi, Hoping someone can help. This is kinda similar to my previous thread but I think different enough of an issue to warrant a new thread. I have Devices in one column, Memory in another, IMEIs in another and days in stock in another. I want to have a sheet that shows which of each device has...
  5. M

    How to Upload/Attach File to Post

    Is there a way to attach either an Excel file or a jpg a thread? What is the size limitations?
  6. R

    Posted replies not showing in thread

    Hi, I have replied to a thread i started last week, and it hasn't been posted, i did the first one about 11am AEST +10GMT and it worked fine, bu then i replied to another quote, i pressed submit, and had a meeting to go to. I came out of the meeting an hour ago and checked the thread and the...
  7. F

    Average If one criteria across multiple columns ignoring blank cells in the column to be averaged

    Hi I posted in an older thread as it helps with part of my problem but not sure if that is the right thing to do. The formula I used is from thread https://www.mrexcel.com/forum/excel-questions/817354-averageif-single-criterion-multiple-columns.html i.e. =SUMPRODUCT(('Updated...
  8. D

    Changing linking so instead of being between tables, it is linking between ranges

    I started a thread that had a bad name so I started a new thread with a more meaningful name. The original thread is here https://www.mrexcel.com/forum/excel-questions/1098809-i-need-some-help-please.html#post5283211
  9. G

    if values in Column D matches then

    Hi everyone, I had created same thread https://www.mrexcel.com/forum/excel-questions/1098491-if-values-column-d-matches-then.html but as i couldn't view that thread i have created this. Here i am trying to check the values in column 'D' and if the values in column 'D' matches then in column B...
  10. JenniferMurphy

    Posting screen shots

    This thread lists 4 ways to post "small screen shots of your sheet(s)": https://www.mrexcel.com/forum/about-board/508133-attachments.html Are they only good for screen shots of cell ranges or can they be used for any screen object? I would like to post a screen show of the Name Manager...
  11. S

    VBA Read cell value character by character

    Hi All, I hope you can help. I've found below thread, and have a similar challenge. https://www.mrexcel.com/forum/excel-questions/590962-typewriter-animated-text-excel.html Instead of writing the text in the VBA code, I would like to pick up the text from another cell in the workbook. It...
  12. RasGhul

    Multiple criteria sales rate

    Hi Excelakos, I've started a new thread so we don't continue to hijack the previous thread with a different problem. Here is the same solution across sheets, just change the names & ranges to what you need and test if it suits; <b></b><table cellpadding="2.5px" rules="all"...
  13. JenniferMurphy

    Can I always have the Advanced Editor on?

    Is there a way that I can have the Advanced Editor active when I reply to a thread? When I start a thread, like now, I have the Advanced Editor. But when I reply, I get some other editor and I have to click on the Go Advanced button to get it. In my Settings under Miscellaneous Options, I have...
  14. A

    Insert Images or Files

    What is the best way to insert images into New Threads? I cannot seem to get this feature to work. I am using Snagit to copy screenshots which will assist me in posting my thread and showing exactly my issue, Thank you.
  15. M

    Duration countdown (single input)

    Greetings, As a policy in other forums, I am posting the same thread below perhaps you have a proper solution for the query https://www.excelforum.com/excel-programming-vba-macros/1268754-duration-countdown-single-input.html#post5084896 ThanksGreetings, As a policy in other forums, I am...
  16. kelly mort

    Disable all controls and menus except the "close", "minimize" and "maximize"

    So I have been digging the web for a while now and I can't find the best way to handle the above challenge yet. Can it be possible to disable all the menus except the control box items as indicated in the header of this thread? Regards
  17. JLGWhiz

    multiple users with same user name prefix

    Just wondering if anyone knows the story behind the &#x2605 user name prefix. All of the threads that I have viewed that use that prefix seem to be homework type questions and I am hesitant to respond to them. The latter part of the name varfies from thread to thread but the &#x2605 is always...
  18. S

    if statement not working

    I have some problem in my excel formula. how can i upload excel file in my thread. please help. where is attach file option
  19. C

    Macropod

    you locked my original thread didnt know how else to get a hold of you
  20. F

    VBA or formula - Subtotal of Non-Hidden columns

    Hi, Have a report, totals represented in cells b3:ac3. I need to hide columns at times and would like the subtotals. I tried this thread but can't get it to work. Can anyone help? https://www.mrexcel.com/forum/excel-questions/655374-subtotal-column-hiding.html

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top