Hi,
I would like to ask for help. I need to extract rows when it meets the criteria >=1.
EX:
Complete Product Sheet:
<tbody>
ProdCode
ProdDesc
Qty
1001
Prod1
0
1002
Prod2
1
1003
Prod3
2
1004
Prod4
0
1005
Prod5
1
</tbody>
Order Product Sheet:
<tbody>
ProdCode
ProdDesc
Qty
1002...
Hi Folks,
I'm copying a variable range of data which may or may not contain a repeating list of values in column A. In the case there IS a repeating list, I would like to keep only the first 'set' and delete all rows below. Turning this...
Prod1
Prod2
Prod3
Prod4
Prod5
Prod1
Prod2
Prod3...
Just can't get this to work.
I have products where the price changes over time and need to historically check these.
Inputs are "Prod1" and "23-MAR-18". Output should be $5.00.
Table:
<tbody>
Product
1-Jan-15
1-Jan-16
1-Jan-17
1-Jan18
Prod1
$5
$5.50
$5.75
$6
Prod2
$6
$6.25
$6.5
$6.74...
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.