Morning all,
Apologies, posting this because I could not find appropriate solutions to my problem. Earlier I obtained this particular code from Dante (which I’m immensely thankful for) which helped in generating a message box (when two conditions are met) for my worksheet:
Private Sub...
I got a task in which i have 2 Files
One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail
And there is Another file containing Daily Collection with payment 2 Detail
In Master File there are two column
Pay 1
Pay 2(Values Coming From Another File...
I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...
I've developed a workbook to calculate pricing. Pricing for labor differs based on location - there are 4 locations. A location is chosen and then labor rates auto populate the worksheet(s) based on the chosen location. The location is a drop down list with results 1,2,3,4 in cell M3. (City1...
Hello!
I'm working on a macro and i need some help.
I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR.
I'm giving an example below.
Lets say i have the below table and my...
Hi Excel Gurus,
For the last few days I'm wrapping my head around an Excel related difficulty and even though I'm pretty used to working with Excel and VBA, I can't figure it out myself.
I have a work schedule as shown below, each number in the schedule represents a different type of work to be...
Hi,
I'm trying to use multiple COUNTIF to check two sets of criteria.
I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria
If duplicate IDs are found and the same fruit on both days it...
Hi all,
I have two worksheets in the same workbook
The first screenshot is Worksheet A
The second screenshot is Worksheet B
Question:
How to match SIZE PERCENTAGES numbers according to the columns “Line”, “Sub-Line”, “Category”, “Sub-Category”, “Occasion” and “Size Pack”?
For...
Hi all,
I have two worksheets in the same workbook
The first screenshot is Worksheet A
The second screenshot is Worksheet B
I would like to match the corresponding quantity to the corresponding grade in Worksheet A based on the Columns "Line", "Sub-Line", "Category", "Occasion"...
Hi All,
New member :)
Struggling with SUMPRODUCT / SUMIF Function.
I can do this successfully with 2 criteria / ranges but wont allow me any further.
I am wanting to sum up data in a tab/cells (Template!$AL$5:$AX$1115)
Based on numerous criteria from many drop down/ data validation lists...
Hi all,
Hope You can help me.
I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas.
The idea of the table is:
<tbody>
A
B
C
D
E
F
G
H
I
J
Name 1
V
V
V
V
V
V
V
V
V
V
Name 2
V
V
Name 3
V
V
V
V...
Hi, I would like to delete all columns that only contain Blanks, or "n/a".
I want a code that deletes based on whether the column contains anything other than a combination of a specific word e.g. "n/a" and/or trimmed Blank cells e.g. "" and/or " ". If it contains something else e.g. other...
Hi
I am trying use a COUNTIFS statement as I have a large data set on another worksheet.
I am trying to count the number of cells and I have numerous criteria. The one which I can not get to work is:
I have a Date Received column and I want to add 56 days to it in the formula combined with...
I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...
Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it.
=IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...
Hi All,
I am after some assistance with writing a formula.
This is the data I have to work with:
Sheet1-
<tbody>
A
B
C
D
E
F
CIS Key
Document Created Date
Client Name
Planner Name
Case ID
Task when Document was Created
1111111
8/04/2018
Client 1
Planner 1
23565454
2222222...
Using Excel 2016. Windows 7.
I'm stumped and need help. A new real estate investment property was purchased that contains vacant and occupied units. There are two kinds of vacant units: Vacant Penthouse Units (PH) and Vacant Units (or all others that aren’t PH). There are a total of 14 Vacant...
Hi all,
thank you for looking in to this.
I have crated a formula to count downtime min from ('Master Data'!X column) when downtime category from B29 equal to range 'Master Data'!W column (see below).
=SUMIF('Master Data'!$X$3:$X$4519,"*"&'Data (by date)'!B29&"*",'Master Data'!$W$3:$W$4519)...
Hello - I'm a beginner in Excel so my question may be very simple. I've gone through several threads for the past 45 minutes and cannot find one like this. I believe I may not need a Vlookup or an IF but possibly a INDEX and Match nested formula. I would be eternally grateful if you could assist...
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.