Good Day sir,
I am creating some formula to make my calculation easier. However i am stuck. :laugh:
In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18.
I already have formula in there, but idk what else i need to add.
This sheet is working on how many job that 1...
Good Day sir,
I am creating some formula to make my calculation easier. However i am stuck. :laugh:
In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18.
I already have formula in there, but idk what else i need to add.
This sheet is working on how many job that 1...
Hi All I am finding it hard to get results in the following scenario:
I have three worksheets Sheet 1, Sheet 2 and Sheet 3
In Sheet 1
I have a drop-down with values i.e. Team 1, Team 2, Team, Team 3 and Team 4.
In Sheet 2
I have 4 Columns with the headings Team 1, Team 2, Team, Team 3, Team...
I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for...
Hello from downunder (Sydney),
Im trying to create an item master from approx. 8 spreadsheets. All in different formats. Most have duplicate unique identifiers (SKU code), but some sheets have dirty incorrect data. Ive therefore determined a sequence based on the cleanest source.
I am using...
I have data in Sheet1 and in Sheet2.
I have three columns in Sheet1 Bank, Branch,Branch Code in A B & C column.
In sheet2 I have Bank Branch Code in A B & C column
In C2 of Sheet1 I want that IF A2 and B2 matches the criteria it will get the Branch code from sheet2 Range A2:C100.
For example...
Hello all,
I am working with a somewhat complicated formula that seems to work when referencing cell values with text, but not when cell values are numbers...
Hi all,
I'm having problems with some VBA script, and would appreciate any feedback on what I may be doing wrong - I've been using VBA for a few years but this is really beyond anything I've tried before.
The relevant sections of code are below, and the scenario is this:
I have a workbook...
<tbody>
Order
Appple
Orange
Lemon
None
Null
ProdType
1
Apple
Apple
2
Apple
None
Null
Apple
3
Apple
Orange
Multiple
4
None
Null
No ProdType
5
Lemon
None
Null
Lemon
6
None
No ProdType
7
Apple
Orange
Lemon
None
Null
Multiple
8
Null
No ProdType
</tbody>...
Hello,
I have a doozy here and any and all help is truly appreciated.
I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date...
Hi Folks,
I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks
Formula: =IF(ISERROR(INDEX('Analysis...
Hello,
I am self taught in excel and in the wonderful world of Macros. My question is that I am building a database with a data entering sheet. I want to use the index and match in a reverse form. That it would find the location in a table and copy and paste the data enter into the cell on the...
I'm working to get an index match formula to find a value in one table based on criteria in another. An example of each table is below, with my desired output being in the "Price" column of Table 1.
Table 1:
<tbody>
Column A
Column B
Column C
Column D
Row 1
Thickness
Type
Width
Price
Row...
I currently have a workbook with over 50,000 rows of data based on color, make, model, package, year and price of cars and I'm using an array formula to retrieve price based on multiple criteria. The formula works perfectly when all information is in one workbook, but the array formula does not...
hi,
I am trying to do an index match for 2 criteria. Lets say i have to return a random number from column C. Matching criteria 1 is DEF and matching criteria 2 is 01/11/2021 (I'd like to match the closest date). So ideally I would return Random(6).
A B C
ABC 01/01/2020...
I am trying to work with a User Form to send an email to my volunteers if they are a "No Show" selected on the User Form I have the code posted for the entire User form below, but the problem lies at the end with the email function. I am trying to use an index and match function using the name...
Hello,
I have a table of die numbers that correspond to another table of production numbers. I am looking to see if it is possible to automate the summing of the production numbers based on where the die numbers are. I will continue to use this in the future and don't want to have to sum the...
I have a macro that was running into issue mainly due to using the .select too much so I am trying to remove it from my code wherever possible, but I am unsure how to rewrite the following formula:
Range("L9").Select
ActiveCell.FormulaR1C1 = _
"=INDEX('Previous...
Hi,
I am looking for a formula to calculate QTD and YTD data.
Brief explanation of my model, it will contain 3 years of actuals (2015-2017) and 1 year of current budget/plan data, all of which are broken out monthly. I will have 4 QTD calcs (actuals & plan) and 4 YTD calcs.
I also have a lead...
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.