Dear Excel wizards,
I am trying to find an Excel non-VBA formula to automatically calculate the end-of-year holiday week based on the available yearly data.
These are the holiday data (including the 25th of December and the 1st and 2nd of January the next year):
Monday 26 - Friday 30...
I am needing to COUNTIF column B on "Data" sheet is greater than column C on "Data" sheet, if the name in column A of "Totals" sheet matches the name from column A on "Data" sheet. The Data sheet has multiple rows with the same name that need to have the values in B and C checked.
Data Sheet...
(1) How to get reference Sheet 1 to Sheet 2
(2) We Need four Option Reference According Match Question on Sheet 1
*Kindly make this formula for "sheet2"
Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1")
Condition...
How do you sum up different cells with different input? what i'm trying to to do is to have a formula that will sum up the gas product i used. In my excel i have 3 diffrent gas product
but i used different gas product at the same time or sometimes the same gas product. Is there a formula that...
PLS HELP. I LIKE TO CREATE A FORMULA BUT I DON'T KNOW
HOW TO INPUT THE CORRECT FORMULA.
WHAT LIKE IS TO HAVE A FORMULA THAT WILL AUTOMATICALLY
CALCULATE DEFENDING TO WHICH GASOLINE PRODUCT I
CHOICE TO CONSUME AND AUTOMATICALLY SUM UP, IF HOW MUCH
I CONSUME ON EACH PRODUCT.
NEVERMINE THE...
Hello,
I'm trying to calculate the number of months past due from a given date.
For example: If my date is given as 06/25/2020
I would like to see in the new column how many months this is overdue from 06/26/2020 to the previous month (Feb 2022).
Thank you for your help in this matter.
Hello i have the formula below and it is referencing another cell on another sheet, and when that cell does have info in it the formula does what it needs to. However, when that cell it is referencing in 'List' is empty the formula is placing a '0' which i would rather it be blank still and not...
Hello I have this formula I am trying to get to work and it is leaving the cell place when I have an X in T5 and the word First Class is on b33 on the page this page
I was wondering what I am doing wrong? I am trying to do is if First class is on cell b33 on page This Page then do the following...
Hello, i am trying to get this conditional format down to where on my sheet on cells D16 and E16 are greyed out and or also crossed out of the cell b33 = "Last" on sheet "Check Off". Thank you in advance!
Hi!
I've had great success in the past here with VBA macros so I thought I would try my luck again. I pasted some mini sheets as an example, hopefully I did it correctly...
I need to converge 2 spreadsheet given the following scenario:
Spreadsheet 1 entitled "total_siteA.xlsx" with a sheet...
I am looking for a simple VBA code to Delete lines in cells starting with an alphabet.
In each cell in column c, there is a multiline text starting with numbers, special characters, and words.
I also delete the space before them if any. Some cells are empty.
I'm stuck! I've been trying to figure this out for hours now. I have the following formula below:
=SUMIFS('July - Present'!O:O,
'July - Present'!A:A,">="&DATE(2021,10,1),
'July - Present'!A:A,"<="&DATE(2021,10,31),
'July - Present'!Q:Q,"",
'July - Present'!R:R,"",
'July - Present'!S:S,"")
The...
I’m trying to link the square footage on the Taxes worksheet to the lot number (G8 on sheet1). That way, when I enter the lot number on G8 it automatically pulls the corresponding square footage into the calculation on the taxes sheet and puts the result in cell G41 on Sheet 1.
Thanks!!!
Hi Gurus,
Any thoughts on what would be the right sumif lookup formula for below scenario?
Sheet 1 - I have a long list of Data. Simple example below:
Name
Change
Sam
250
Mike
300
Sam
-500
Mike
-150
Sam
-50
Mike
-25
Sheet 2 - I'm having a hard time doing it in pivot so just...
Can we build a single formula to auto-populate the list of dates as shown in column 'G', based on the payment cycles set in (i) & (ii) and the list of dates provided in (iii), without repeating common dates between them?
For now, I prepared separate list of dates using formulas to calculate...
combine cash flow dates
combine cashflow dates
combine cyclic date frequency
combine date schedules
combine dates
combine list of dates
combine payment cycle
excel date formulaexcelformula
Hi Friends,
I looked some posts over here on how to extract words before closed backets and based on number of characters/letters within closed brackets.
I am looking to do this with formula/vba/udf.
Here is an example
Designed and developed the application using Java Server Faces (JSF)...
Hi!
So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product.
As you can see the result is 0 for each row.
This is just an example of my real problem with a report of 200K...
Hi Guys
I have the following formula
=IF(H2>=F2,"withinsla",IF(H2<F2,"slabreached"))
The above formula works well
I want to add the following in the formula
if H2=Q2 ,"urgent"
Thanks and Regards
rakesh
I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be...
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.