Good Evening Gentlemen
I want to ask ,if there is any short cut key to just filter only selective values in any excel file in one go.
e.g. I have excel file with line items more than 100 , in each line item there is selling price in one column, now i want to filter values in such a way that while filtering ,values should appear only once ; below chart will help you to understand what i want to ask
I want to ask ,if there is any short cut key to just filter only selective values in any excel file in one go.
e.g. I have excel file with line items more than 100 , in each line item there is selling price in one column, now i want to filter values in such a way that while filtering ,values should appear only once ; below chart will help you to understand what i want to ask
| ORIGINAL DATA | ||
| SR.#. | ITEM | SELLING PRICE |
| 1 | PRODUCT-A | $100.00 |
| 2 | PRODUCT-B | $125.00 |
| 3 | PRODUCT-C | $135.00 |
| 4 | PRODUCT-D | $145.00 |
| 5 | PRODUCT-E | $100.00 |
| 6 | PRODUCT-F | $125.00 |
| 7 | PRODUCT-G | $135.00 |
| 8 | PRODUCT-H | $145.00 |
| 9 | PRODUCT-I | $100.00 |
| 10 | PRODUCT-J | $125.00 |
| 11 | PRODUCT-K | $135.00 |
| 12 | PRODUCT-L | $145.00 |
| 13 | PRODUCT-M | $100.00 |
| 14 | PRODUCT-N | $125.00 |
| 15 | PRODUCT-O | $135.00 |
| 16 | PRODUCT-P | $145.00 |
| 17 | PRODUCT-Q | $100.00 |
| 18 | PRODUCT-R | $125.00 |
| 19 | PRODUCT-S | $135.00 |
| 20 | PRODUCT-T | $145.00 |
| 21 | PRODUCT-U | $100.00 |
| 22 | PRODUCT-V | $125.00 |
| 23 | PRODUCT-W | $135.00 |
| 24 | PRODUCT-X | $145.00 |
| 25 | PRODUCT-Y | $100.00 |
| 26 | PRODUCT-Z | $125.00 |
| DATA I WANT FOR TAKING PRINT | ||
| SR.#. | ITEM | SELLING PRICE |
| 1 | PRODUCT-A | $100.00 |
| 2 | PRODUCT-B | $125.00 |
| 3 | PRODUCT-C | $135.00 |
| 4 | PRODUCT-D | $145.00 |
