I gang

2008.08.06 Select and export certain products in Excel - for Hussien Sharaf only

This project is for Hussien Sharaf only.

In an Excel file we have various headings including "SKU" and "Price" in the first row. There are two things I'd like to do.

1. ++++++++++++++

I'd like to have the option of deleting any rows which have a SKU ending in "SF", for example:






I don't always want to delete such rows, but I'd like the capability of doing it if I'd like.

2. ++++++++++++++

If you look at the following SKUs...

364N301 £100

364N302 £0

364N303 £55

etc etc

... you'll see that SKU number 364N302 has the lowest price (in this case, zero) of the SKUs that begin with 364. I'd like to be able to export just those rows which have the lowest price for any given model of phone.

The number "364" is the phone model number. At the moment it goes from 1 to 404. So, the number could be from one to, eventually, four or more digits. The number is always followed by a letter so the SKUs are of the form 364N301, 73O305, 45VF07, 364BT01, 64TM02, 86OR09 and so on.

I mention that, because you need to be able to distinguish between two

different phones which might have SKUs such as 456N301 and 45N301. There has to be a way of determining that phone number 456 is different from phone number 45. Unfortunately the phone numbers don't have the same number of digits. If it becomes necessary to change the phone numbers so that they all have the same number of digits, then that can be done, I'm sure. "46" might then have the form "0046". I could then have phones numbered from 0001 to 9999.


Evner: Excel

Se mere: we excel, letter example, excel &, example letter, 404 d, function excel count 0001 9999, sku creator excel, making sku number excel, n excel, a letter c and letter t, sku, SF, price excel, export, export from excel, excel\ , excel, excel model, excel form, excel c#

Om arbejdsgiveren:
( 92 bedømmelser ) Dun Laoghaire, United Kingdom

Projekt ID: #297043