microsoft excel 365

  1. R

    IF/MATCH statement that includes the SUM

    I am in need of an Excel formula that looks to see if cells in column A match. If they do, then provide the sum of all of the cells that match in that group in the first cell of that group in the appropriate column (GA = column "G", "FL" = column "I"). You can see the totals in columns G and I...
  2. P

    Need to Hide Columns in a sheet2 , when multiple check-boxes are ticked in sheet1

    Team, I am new to excel VBA coding, Could you please help me in this. My requirement is, In sheet1, I have a multiple check-box, with values IBM, HPM,UNY,ASM, When I tick check-box IBM, the columns with names HPM,UNY,ASM in Sheet2 has to be hidden and only IBM Column has to be visible...
  3. M

    Latitude and Longitude Value Formatting with 3 Splitters ( : : ) Only.

    I have following data for Latitude and Longitude with its coordinates and want to transform the value (LT and LG) as per below. for example S.no >383> 19.159314 to 21 : 8 : N and 77.313188 to 75 : 16 : E rather than a long coordinate numbers. These numbers are extracted from...
    • mba_110
    • Thread
    • formula & text latitude longitude microsoft excel 2021 microsoft excel 365
    • Replies: 2
    • Forum: Excel Questions
  4. H

    How do I create a table that then considers whether or not clients appear in other tables?

    Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...
    • HelpPlease123
    • Thread
    • automate excel 365 filter filter advance filter advance criteria microsoft excel 365 pivot table power pivot power query relationship relationships link tables selection criteria
    • Replies: 0
    • Forum: Excel Questions
  5. E

    Excel VBA Date Formatting help

    Hello I hope someone can help as I have been trying to figure this out for the last few days and getting nowhere. I have a complaints database that I have put together where the user fills in the userform with the details of the complaint and it gets put into the correct tab in the workbook...
  6. Q

    Drawbacks for checking whether input functions are valid in a textbox

    Kind regards I am carrying out a linear regression process, for which I have resorted to the use of a userform, where in each of the four textboxes I have to enter the input data corresponding to four functions fi(x) To check if the input functions are valid and do not present some kind of...
  7. Q

    Alternatives for the populating of a ComboBox

    Hi, I am working on a userform that calculates the distance between two cities (measured along a straight line) expressed in miles and kilometres. To make this possible, four ComboBoxes have been entered into the form, two of them record the State, while the remaining two contain the city...

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