formula #explaination

  1. A

    How to get a total add up number from total number in another row??

    Hi , apologize if this question sound more difficult than it should be I would like to create a formula that is able to properly capture a certain amount of number and distribute as evenly as possible from total number in cell C16. The total delivery is 725. Im trying to figure out a...
  2. N

    Use different sheet names as part of a formula (indirect function?)

    Hi, I have a workbook with several sheets, which all have data in the same format but with different numbers. I am trying to create a summary sheet, which pulls the data from each individual workbook and lists it. As VBAs are disabled and I have never created a macro before, I am trying to...
  3. J

    Which formula can I use to automatically generate a new invoice number?

    Hi there I would like to know how I can set the following type of invoice numbers to be recorded on a different sheet by the use of a button form control and how I can use another button form control to automatically generate the next invoice number when I press the button as the sequence...
  4. H

    How to make excel count based on time data?

    Hello there! I'm sorry to bother you all, but I've been having trouble for about a week now on how to make this work in Excel 2016 and couldnt find a solution yet... Here's what we got: There's a lobby where people going in and out, in the left group of columns. We got exact time of their...
  5. K

    COUNTIFS (Name and date)

    Hi Wonderful people, Trying to get a countifs formulae to work based on the below: COUNTIF first column = Text (got this solved) COUNTIFS second column = yesterday (today - 1) I tried the below, but to no avail Countifs(A:A,"first interview booked,B:B,TODAY()-1 Also tried it with the...
  6. A

    Count no'of empty cells with no color fill

    Hi all, I am looking for a formula which will count the no of blank cells in a column having no color fill. I have values in both filled and unfilled cells. i want to get the count of unfilled cells if there is no value in it.
  7. S

    Count if/sum if formulae

    Hi all! Looking for some help! I want to add the total value for each reference So final hours = Total hours completed by reference Reference Hours complete Final hours 123 10 HELP HERE 345 12 123 8 123 20
  8. K

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...
  9. M

    Creating a calendar by matching names and dates from multiple sheets

    Hi, I am looking to create a calendar on the first tab of a workbook I have. Currently the workbook has multiple sheets of data, each sheet containing data related to a different type of work that is being scheduled in for different people. In order to currently find out what type of work...
  10. K

    SUM for Google Sheets

    Hello, I would like to ask how to sum a numbers in one cell which were deleted? I mean, every week I need to update the number in the cell and I wish to get the total of those numbers from last 4 weeks in another cell. How to do this? For example: I input in cell C10 : 24, one week later I need...
  11. E

    Choose function sequence

    In this formula for choosing a date for Memorial day, how is the sequence 30 thru 31 determined? =DATE((A1),5,CHOOSE(WEEKDAY(DATE((A1),5,1)),30,29,28,27,26,25,31)) Thanks
  12. J

    Subtotal if average formula on visible cells

    Hi wizards! I was hoping one of you bright heads could maybe help me out with a formula I'm struggling with :) I am trying to get the average value of all visible (non-filtered) cells in range 'Data for 2023'!$Y$9:$Y$2000 where the corresponding value in column D is not equal to "DC jobs"...
  13. A

    PERCENTRANK How does it work

    Hello, I am new to excel and am trying to use and understand the PERCENTRANK formula. Doc says that when the number you are looking for is in your data set, the formula is : lower values / (lower+upper values). The problem is when I try to search for a number that is not included in the data...
  14. J

    GOOGLE SHEETS: Counting Unique values based on another cells data.

    I keep a running total of how many orders need to be short shipped. I am able to use (=COUNTIFS(B:B,">=10/1/2022",B:B,"<=10/08/2022") to count the number of lines in a given time period as each line is required to be put in by itself. I would like to keep track of the MRs in the same way but an...
  15. L

    Next Quarter in Excel

    hi All I'm trying to find a formula that can give the next quarter based on the current quarter This is my formula to generate the current quarter but not finding a simple way ="Q"&INT((MONTH(U2)+2)/3)&"-"&YEAR(U2) Suggestions welcome I suspect this is a very simple answer I'm just not...
  16. K

    Excel - Not retuning correct values.

    I am experiencing problems with a formula in a workbook we use in my workplace. It was written by a former employee who has recently left but taken the knowledge with him. The data in cell 'BJ5' Should be the same as in 'BJ6'. BJ6 being the correct value. I have attached a copy of the...
  17. W

    Cumulative sum Value by rank and per group

    Hi everyone, I have to put an evaluation to the certain data set (ex : image below), and I'm attempting to create a summary for the cumulative sum of value by rank per group. Column A is the number of data Column B is the Group of each data Column C is the value of each data Column D is the...
  18. K

    How to change month After select Dropdown list ???

  19. Jyggalag

    Email multiple emails at once with macro/VBA

    Hi all, I currently have the following setup: The macro will send out an email to the 1st contact and BCC with this VBA code: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As...
  20. K

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFRENT-DIFFRENT TABLE ???

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

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