Good morning,
I need the help to solve a problem.
I need to search one text in a table with a range of date:
Supplier Date Value
A 19/10/2022 Madrid
A 05/10/2022 Barcelona
B 17/10/2022 Zaragoza
B 09/10/2022...
Hello,
I'm new to the forum. I've got a sheet where there sometimes exists shapes which cannot be targeted by the mouse (there are several different ones, they're not all the same shape).
I want to be able to remove them anyway, however I want to also control which ones I remove since some...
I need to identify whether two dates (Start and End) fall within any months from 01 April 2021 to 30 September 2022
Some of the End Dates are blank which shows that particular record is still active.
Example
Just a small look into the columns.
Apologies, don't know how to increase the number...
Hello everyone~
I have a problem with a task that I'm not sure how to do it.
I have an excel file where I make quotations and it brings a total quotation at the end. According to that quotation result I have an ActiveX combo box that should bring a specific range of values, for example...
Im really not sure how to explain this but here goes, Starting from the right, as u can see each item has specific range of KP (from column K and L). We start with item 1 for example, which range from 0.211 to 0.216. Now i would like to match these range to the ones in column A. Once that...
Hello All,
I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week.
- Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022.
I also need one that looks...
I've got code here that will bring in information while looping through workbooks in a folder. It could be 5 workbooks or 50. Usually on the higher end. I'm bringing in 5 rows of information so every time i open a new workbook for information, i need it to go down to the 5th row and start again...
Hi, I require a formula to work out a sales commission structure as a lot of online templates seem to be different structures.
In a nutshell, when looking at the picture, I will require 5 of the same formulas which I can replicate which need to go into the cells in yellow in G2, G3, G4, G5 &...
Hi all
Ive had a look through the discussion board and cant quite find what i was looking for, or the codes were very different.
The idea is a macro button which saves to a specific location, saves as a PDF, saves name as todays date.
Please find code below.
Currently it is saving the PDF in...
Hello excel experts,
I am using a two-way XLOOKUP() to grab a range of lookup values from a dynamic column lookup.
The formula I am currently using is:
=SUM(XLOOKUP($C$11:$C$43,INDIRECT("'"&G$10&"'!"&"$A:$A"),XLOOKUP($D11,INDIRECT("'"&G$10&"'!"&"$6:$6"),INDIRECT("'"&G$10&"'!"&"$1:$1048576"))))...
Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B...
My code below:
Sub arrange()
'all declarations for wkshts and wbs stated at top unless stated here
Dim g1 As Range
Dim g2 As Range
Dim g3 As Range
Dim g4 As Range
Dim g5 As Range
Dim g6 As Range
Dim g7 As Range
Dim g8 As Range
Dim g9 As Range
Dim g10 As Range
Dim g11 As Range
Dim g12 As Range...
I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22.
In the range of start dates and end dates in my...
Hi all,
In the code below I want to adjust the "criteria" line in such a way that it not refers to an array, but that it refers to a range in column A that is changing in size (sometimes it has more, sometimes it less lines) on a separate sheet (Sheet3)
How do I make this adjustment? I know...
Hello Experts,
I've been trying to figure out how to do this macro. I have a sheet with A-AK in column to be copied multiple times to another sheet.
I have seen and used the code found in this forum as well but with my requirements, I need some modification since the code copies the whole row...
Hello everyone,
I am struck with this problem since yesterday and have been unable to find any solution despite all the web searches. Please help me if it is indeed possible.
To better explain the situation:
We have multiple templates for different product types (400+). We share these files...
Hi everyone,
Just wondering if anyone can help me out here.
When the value of column A is changed, I want to refresh the combination of columns b, c, and d.
Also, if the cell is empty, I want it to be ignored.
I've gotten help from the community, but it's not working.
Sub...
xDRg1, xDRg2, xDRg3 Ranges contain empty Cells. Can I do a combination other than this?
Sub ListAllCombinations()
'Updateby Extendoffice
Dim xDRg1, xDRg2, xDRg3 As Range
Dim xRg As Range
Dim xStr As String
Dim xFN1, xFN2, xFN3 As Integer
Dim xSV1, xSV2, xSV3 As String
Set xDRg1 = Range("a2"...
I am trying to do a summation of how many labs occur per week from a daily count on another sheet. However, I can not get the summation to shift down 7 days at a time. Is there a way to do this?
Weekly summary:
From the Daily Counts:
I need It to sum a week at a time like this. Then , the...
I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things
I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...
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.