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...
I want a formula that If J1 is less than 1000 and H1>0 and I1>0 then the value should be 1000-J1 else 0. I am trying this formula but getting error.
=IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)
for example
I have two Sheets "DATA" "RAW DATA"
In DATA sheets
<tbody>
APPLE
10
APPLE
15
APPLE
16.5
BANANA
35
BANANA
20
BANANA
36
ORANGE
45
ORANGE
15
ORANGE
50
ORANGE
111
</tbody>
In RAW DATA sheet in Column B I have to input APPLE/BANANA/ORANGE in various rows.
I...
I have two Sheets "DATA" "RAW DATA"
In DATA sheets
Column A COLUMN B
APPLE 10
APPLE 15
APPLE 16.5
BANANA 35
BANANA 20
BANANA 36
ORANGE 45
ORANGE 15
ORANGE 50
In RAW DATA sheet in Column B I have to input...
Dear Experts,
I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like-
Sheet1
<tbody>
Group
Name
Value
1
Nashid
200145
2
Kashem
188516
1
Jabed
184198
2
Rubel
172569
3
Romel
168251
1
Eman
156622
2
Hasin
152304
3
Nasim
136357...
I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist...
I'm building a scheduler for a team of 200+ individuals.
I have 50K rows of data with a large number of columns. I'm trying to build a...
I'm trying to figure out how to select two values from a drop down list and then to to a table on another tab to pull out a sub value.
I have SIZE as a drop down (pulling from a named range)
I have COLOR as a drop down (pulling from a named range of parent colors, which have child colors)...
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.