-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
prod3
-
B
Extract rows with value >=1 to another sheet
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...- bobbieatendido
- Thread
- extract help - macros prod3 sheet vba & excel 2016
- Replies: 5
- Forum: Excel Questions
-
find and remove... a repeating list
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...- tourless
- Thread
- prod1 prod2 prod3 prod4 vba & excel 2016
- Replies: 5
- Forum: Excel Questions
-
E
INDEX MATCH Dates
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...- EasterGreen
- Thread
- 1-jan-15 prod1 prod3 product table
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
