formula #explaination

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

# 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